Question

thing dollar complete the following the Round FVA factors to 3 decimal places and final nuwers Number of Annual Deposit Rate of Return at the End of Time Total Amount Total Amount of of investment Earnings 2000 2.000 2.000 15

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

A B C D E Amount Deposit Rate of Returns Number of Years Total Amount of investment Total Amount of Earnings $2,400 $2,400 $2,400 $2,400 3% 9% 5% 11% 10 10 30 30 Investment value at the End ot Time period $27,514 $36,463 $159,454 $477,650 $24,000 $24,000 $72,000 $72,000 $3,514 $12,463 $87,454 $405,650

Cell reference -

A B C D | Amount Rate of Number of Investment value at the End ot Total Amount of Total Amount Deposit Returns Years Time period investment of Earnings 2400 0.03 =ROUND(FV(C3,D3,-1,,0),3)*B3 =B3*D3 =E3-F3 2400 0.09 10 =ROUND(FV(C4,D4,-1,,0),3)* B4 =B4*D4 =E4-F4 2400 0.05 3 0 =ROUND(FV(C5,D5,-1,,0), 3) *B5 =B5*D5 =E5-F5 2400 0.11 30 =ROUND(FV(C6,D6,-1,,0),3)*B6 =B6*D6 =E6-F6

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.