Function Explained

FV function is used for the calculation of the Future Value of a loan or any other financial instrument.

Example

The bank agreed to give you a loan and here are the details:

• The amount of the loan is 379,079 USD.
• It is for 5 years, bearing a yearly interest rate of 10%.
• A payment of 100,000 USD has to be made every year.

What is the FV (Future Value) of the loan after 2 payments? (In other words – How much loan is left after 2 payments were made?)

In this example, we kept [type] empty as well, meaning that payments are made at the end of each period. Also, we typed minus before the formula to get a positive FV result.

Syntax

The FV 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

[PV] (optional argument) The Present Value of the loan. If this argument is omitted the PV 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.

Practice FV function

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