2. Create a spreadsheet to calculate the future value of an investment. Use the FV function for
this. Future value is the value of a monthly investment at a certain rate over a period. You
could use it for calculating your retirement nest egg. Enter the number of years in a row near
the top. Start with five and go to 40 by fives. On the side, enter the amount you are willing to
invest each month. Start with $100 and fill it to $2,000. In the first cell of the table (where the 5
and $100 intersect, enter your formula. Use FV. The first one is the interest rate. Enter that
cell. The second one is the years. Enter that cell. The last one is the amount. Enter that cell.
When you fill using this cell the formulas will not work. You will need to modify them to
always stay in the interest rate cell. You will need a $ in front of the row and column. For the
years, you will need the $ in front of the column. For the amount, you will need the $ in front
of the row. You will then be able to copy it. The numbers will be negative. To make them
positive (after all its money your saving), use the absolute value function (ABS). Insert the
screenshot here.