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!