FV

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

Microsoft

[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!