You are constructing a future value spreadsheet. Users will be asked to enter the periodic investment in

Question:

You are constructing a spreadsheet. Users will be asked to enter the periodic investment in cell A3, the interest rate as an equivalent decimal in cell A4, the time in years in cell A5, and the number of times per year the interest is compounded in cell A6. Cell A8 will contain the of the periodic investment. Write the formula that will display this value in A8.
Future Value
Future value (FV) is the value of a current asset at a future date based on an assumed rate of growth. The future value (FV) is important to investors and financial planners as they use it to estimate how much an investment made today will be worth...