Enrollment for the FMVA™ Certification Program is now OPEN!

FV Function Excel

Calculates the future value of an investment

What Is the Excel FV Function?

The FV Function Excel formula is categorized under Financial functions. The function helps calculate the future value of an investment.

As a financial analyst, the FV function helps calculate the future value of investments made by a business assuming periodic, constant payments with a constant interest rate. It is useful in evaluating low-risk investments such as certificates of deposit or fixed rate annuities with low interest rates.

 

FV Excel Formula

=FV(rate,nper,pmt,[pv],[type])

 

This function uses the following arguments:

  1. Rate (required argument) – It is the interest rate for each period.
  2. Nper (required argument) – It is the total number of payment periods in an annuity.
  3. Pmt (optional argument) – It specifies the payment per period. If we omit this argument, we need to provide the PV argument.
  4. PV (optional argument) – It specifies the present value (PV) of the annuity. The PV argument if omitted defaults to zero. If we omit the argument, we need to provide Pmt argument
  5. Type (optional argument) – It defines if payment is made at start or end of the year. The argument can either ne 0 (payment is made at the end of the period) or 1 (the payment is made at the start of the period).

 

Make sure use the units of rate and nper are consistent. If we make monthly payments on a five-year loan at an annual interest of 10%, we need to use 10%/12 for rate and 5*12 for nper. If we make annual payments on the same loan, then we would use 10% for rate and 5 for nper.

 

How to use the FV Function in Excel?

To understand the uses of the FV function in Excel, let’s consider few examples:

 

Example 1 – FV function Excel

Let’s assume we need to calculate the FV based on the data given below:

 

FV Function Excel - Example

 

The formula to use is:

 

FV Function - Example 1

 

As the compounding periods are monthly (=12), we divided the interest rate with 12. Also, for the total number of payment periods, we divided by compounding periods per year. As the monthly payments are paid out, they are entered into the function as negative values. If we forget to put the percent sign in cell C5, the calculation will wrong. We need to enter the interest rate in percentage form or in decimal form = 0.04.

We will get the result below:

 

FV Function - Example 1a

 

Example 2 – FV function Excel

The example below shows how to use the function for personal finances. Assume we need to buy a car and are saving for it. The target is to buy in 1 year. There are $10,000 in our bank account as savings. The bank pays 5% interest on our savings account. Our capacity is to add $2,000 for next 12 months into the account. Let’s calculate the amount we would need at the end of the year to purchase the car?

Suppose we are given the information below:

 

FV Function - Example 2

 

The monthly contribution we can do is $2,000. As it represents outflow, we took it as -2,000 (-C8).

 

FV Function Excel - Example 2a

 

We will get the result:

 

FV Function - Example 2b

 

Things to remember about the FV Function

  1. If the pmt argument is for cash going out of business, the payment value will be negative and for cash received, it must be positive.
  2. #VALUE! error – Occurs when any of the given arguments is non-numeric.

 

Click here to download the sample FV Function Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

Free Excel Tutorial

To master the art of Excel, check out CFI's FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.  

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!