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 cell above the $100, enter the interest rate you expect to earn on the investment. 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. 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 cell above the $100, enter the interest rate you expect to earn on the investment. 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