Financial functions: = PMT (rate; nper; pv; fv; type) = FV (rate; nper; PMT; pv; type) = NPER (rate; PMT; pv; fv; type)
Posted: Fri May 06, 2022 6:01 am
Financial functions: = PMT (rate; nper; pv; fv; type) = FV
(rate; nper; PMT; pv; type) = NPER (rate; PMT; pv; fv; type) = RATE
(nper; PMT; pv; fv; type) = PV (rate; nper; PMT; fv; type)
Exercise 3: After 7 years, the cost for each study year will be
40,000 USD.
1) How much will we have to invest today at an annual rate of
10% to get the 40,000 USD?
2) If you only have $ 15,000 to invest, what should the rate be
to reach $ 40,000?
(rate; nper; PMT; pv; type) = NPER (rate; PMT; pv; fv; type) = RATE
(nper; PMT; pv; fv; type) = PV (rate; nper; PMT; fv; type)
Exercise 3: After 7 years, the cost for each study year will be
40,000 USD.
1) How much will we have to invest today at an annual rate of
10% to get the 40,000 USD?
2) If you only have $ 15,000 to invest, what should the rate be
to reach $ 40,000?