Use the Future Value Function (FV) to determine the future value of the monthly investment. Amount invested monthly $300 Number of years invested 20 Interest rate earned 7.00% Future value of investement
i need to do it with an excel formula
Please see the snapshot from my excel model.
The last column shows the formula used in the preceeding column. The excel formula used in the adjacent cell has been shown in blue color.
The final answer has been calculated in the cell highlighted in yellow color. The adjacent cell highlighted in blue color shows the formula used in the preceeding cell to get the output.
Get Answers For Free
Most questions answered within 1 hours.