C18 :fx=1000 G31 :Xfx C18 :fx=1000 G31 :Xfx

C18 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 fx -1000 Problem 3 Time Value Analysis Solving for "Future Value" Future Value of a $1000 Investment What will the $1000 be worth 5 years from now at an Future Value of a Lump Sum Interest Earned Present Value Number of Periods Interest Rate Method for Solving Future Value "Manual Formula" Method for Solving Future Value "Excel FV Function" 10% Return c Initial Investment 1,000.00 (1,000.00) 5 S S Year 1 1,100.00 100.00 S S Year 2 1,210.00 110.00 S S Year 3 1,331.00 121.00 S S Year 4 1,464.10 133.10 Year 5 S 1,610.51 S 146.41 Given Parameters Solutions O S 610.51 Effective Rate formula quarterly calc' Compounded Quarterly Manual Compounded Quarterly Excel