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?
Financial functions: = PMT (rate; nper; pv; fv; type) = FV (rate; nper; PMT; pv; type) = NPER (rate; PMT; pv; fv; type)
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Financial functions: = PMT (rate; nper; pv; fv; type) = FV (rate; nper; PMT; pv; type) = NPER (rate; PMT; pv; fv; type)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!