FV Function Excel
Calculates the future value of an investment
Calculates the future value of an investment
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(rate,nper,pmt,[pv],[type])
This function uses the following arguments:
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.
To understand the uses of the FV function in Excel, let’s consider few examples:
Let’s assume we need to calculate the FV based on the data given below:
The formula to use is:
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:
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:
The monthly contribution we can do is $2,000. As it represents outflow, we took it as -2,000 (-C8).
We will get the result:
Click here to download the sample FV Function Excel file
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:
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!