Week 4 Quiz
future Value of 10,000 for 30 years at 7% $76,122.55 paying 10,0000 enter it as a negative Develop Model inputs Quiz rate 7% 12% nper 30 6 pmt 0 -3500 pv -10000 0 output fv $76,122.55 $28,403.16 Quiz
pv= fv1 591.0165485 11455 10048.24561 50000 45045.04505
Find the present value of 30 payments of $1000 assuming a discount rate of 7% pv=fv2 581.2361328 16376 12600.80025 75000 60871.68249 pv=fv3 591.9116828 19812 13372.53568 125000 91398.92266 639.688411 47643 36021.58154 250000 164682.7435 $12,409.04 Quiz 2403.852775 500000 361998.3937 rate 7% 15% nper 30 5 pmt -1000 -37250 pv 0 0 output PV $12,409.04 $124,867.78
If you invested $2400 per year for 30 years, and your employer matched your contribution, what rate would you need to earn to accumulate $1,000,000? 11.24%
nper 30 pmt -4800 pv 0
FV 1000000
Rate 11.24%
Suppose you plan to save for a new home for 10 years. If your goal is to have $50,000 at the end of 10 years and you can earn 8% how much do you need to save each year? inputs rate 8%
pv= fv1 591.0165485 11455 10048.24561 50000 45045.04505
Find the present value of 30 payments of $1000 assuming a discount rate of 7% pv=fv2 581.2361328 16376 12600.80025 75000 60871.68249 pv=fv3 591.9116828 19812 13372.53568 125000 91398.92266 639.688411 47643 36021.58154 250000 164682.7435 $12,409.04 Quiz 2403.852775 500000 361998.3937 rate 7% 15% nper 30 5 pmt -1000 -37250 pv 0 0 output PV $12,409.04 $124,867.78
If you invested $2400 per year for 30 years, and your employer matched your contribution, what rate would you need to earn to accumulate $1,000,000? 11.24%
nper 30 pmt -4800 pv 0
FV 1000000
Rate 11.24%
Suppose you plan to save for a new home for 10 years. If your goal is to have $50,000 at the end of 10 years and you can earn 8% how much do you need to save each year? inputs rate 8%