Function Explained

PV function is used for the calculation of the present value of a loan.

Syntax

The PV arguments are as follows:

Rate – That’s our interest rate. 

Nper – That’s the number of periods of our loan. 

pmt – That’s the fixed payment we have to pay each period for our loan

[FV] (optional argument) –  The Future Value of the loan. If this argument is omitted the FV is 0.

[type] (optional argument) – when the payment is made – At the beginning (1) or the end (0) of the period. The default, if omitted, is 0 – End of the period. 

Example

The bank agreed to give you a loan. Here are the details: It is for 3 years, bearing a yearly interest rate of 10%. A payment of 105,000 USD has to be made every year. 

What is the PV (Present Value) of the loan? 

In this example, we did not type any value in [fv] as the Future Value of the loan is 0. We kept [type] empty as well, meaning that payments are made at the end of each period. 

Practice PV function

 Let’s see if you know how to use the PV function!