How to calculate the present value (PV) of a monetary amount
Requirement:
Solution:
1. Click in cell B6 (PV).
2. In the toolbar click insert function (fx). This will open the insert function dialog box.
3. Select the category Financial then click the function PV and click ok for the functions dialog box to open.
4. The cursor ill be in the Rate argument field of the functions argument dialog box. click the Rate value inn your worksheet (cell B3). The interest rate will be entered.
5. Click in the Nper function argument field and then click the Nper value in your worksheet (cell B4).
6. Click in the FV argument field, and then click the FV value in your worksheet (cell B5).
7. 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 future value (FV) 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
