How to calculate the future value (FV) of a monetary amount
Requirement:
Solution:
1. Click in cell B6 (FV).
2. Click on Insert Function (fx), select the category Financial, click on the function FV and then click OK.
3. The function argument dialog box ill open.
4. Click in your spreadsheet to enter values for Rate (B3), Nper (B4) and PV (B5) (leave Pmt and Type blank).
5. Click OK.
Obtained from the OzGrid Help Forum.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to calculate the present value (PV) of a monetary amount |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
