Microsoft Office Tutorials and References
In Depth Information
B16 =B4
Displays the initial investment amount
B17 =B5*B6*B10
Calculates the total of all regular deposits
B18 =B16+B17
Adds the initial investment to the sum of the deposits
B19 =B13*(1/B6)
Calculates the periodic interest rate
=FV(B19,B6*B10,-B5,-
B4,IF(B7,1,0))
B20
Calculates the future value of the investment
B21 =B20-B18
Calculates the interest earned from the investment
Search JabSto ::




Custom Search