The FV function calculates the future value of an investment based on a constant interest rate, regular payments, and an optional initial amount. It tells you how much your money will grow to after a specified number of periods.
=FV(rate, nper, pmt, [pv], [type])What does FV do?
The FV function in Excel is a financial tool that answers a simple but powerful question: how much will my investment be worth in the future? Whether you are saving for a holiday, planning a pension, or evaluating a business project, FV helps you see the end result of regular deposits or a lump sum growing at a given interest rate.
Unlike manual calculations, FV handles the compounding automatically. You provide the rate, the number of periods, the payment amount, and any starting value, and Excel does the maths. This saves time and reduces errors, especially when comparing different scenarios.
Imagine you are setting aside a fixed amount each month into a savings account. You want to know if you will reach your target. With FV, you can test different interest rates or monthly amounts in seconds. It is equally useful for students learning finance or office workers building budgets.
When to use FV
- Projecting the balance of a savings account with regular monthly deposits.
- Estimating the future value of a retirement fund with annual contributions.
- Calculating the accumulated value of an investment with a lump sum and periodic additions.
- Evaluating the future worth of a loan or lease with regular payments.
- Comparing different savings plans to see which reaches a goal faster.
- Determining how much a series of investments will be worth after several years.
FV syntax
=FV(rate, nper, pmt, [pv], [type])| Argument | Required? | What to enter |
|---|---|---|
rate | Required | The interest rate per period. For example, 5% per year with monthly payments becomes 0.05/12. |
nper | Required | The total number of payment periods. For a 10-year monthly plan, use 10*12 = 120. |
pmt | Required | The payment made each period. It must be negative if you are paying out (e.g., -100 for a deposit). |
pv | Optional | The present value (initial lump sum). If omitted, it is assumed to be 0. Use a negative number if you are investing money. |
type | Optional | When payments are due: 0 or omitted for end of period, 1 for beginning of period. |
What it returns: The future value of an investment as a number, representing the total amount accumulated after the specified periods, including interest and payments.
FV examples
1 Simple Savings with Monthly Deposits
You deposit $100 at the end of each month into an account earning 0.5% monthly interest for 12 months. The goal is to find the future value. The formula uses rate=0.005, nper=12, pmt=-100, and pv=0. It returns the total balance after one year, which is approximately $1,233.56. This shows how regular small deposits grow with compound interest.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Monthly Rate | 0.005 | |||
| 2 | Number of Months | 12 | 1233.556237 | ||
| 3 | Monthly Deposit | -100 | |||
| 4 | Initial Amount | 0 | |||
| 5 |
2 Lump Sum Investment Growth
You invest $5,000 today at an annual interest rate of 4% compounded annually for 5 years, with no additional deposits. The formula uses rate=0.04, nper=5, pmt=0, and pv=-5000. It returns the future value, which is $6,083.26. This illustrates how a single investment grows over time.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Annual Rate | 0.04 | |||
| 2 | Years | 5 | 6083.264512 | ||
| 3 | Annual Payment | 0 | |||
| 4 | Present Value | -5000 | |||
| 5 |
3 Retirement Fund with Annual Contributions
You contribute $2,000 at the beginning of each year to a retirement account earning 5% annually for 20 years. The formula uses rate=0.05, nper=20, pmt=-2000, pv=0, and type=1. It returns the future value, approximately $69,438.50. This demonstrates the effect of contributions made at the start of each period.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Annual Rate | 0.05 | |||
| 2 | Years | 20 | 69438.50362 | ||
| 3 | Annual Contribution | -2000 | |||
| 4 | Initial Amount | 0 | |||
| 5 | Type | 1 | |||
| 6 |
4 Business Equipment Lease Future Value
A company leases equipment with monthly payments of $500 at the end of each month for 3 years. The lease includes an interest rate of 6% per year (0.5% monthly). The goal is to find the future value of the lease payments. The formula uses rate=0.005, nper=36, pmt=-500, pv=0, and type=0. It returns $19,668.05, representing the total cost if paid as a lump sum today.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Monthly Rate | 0.005 | |||
| 2 | Number of Months | 36 | 19668.05248 | ||
| 3 | Monthly Payment | -500 | |||
| 4 | Present Value | 0 | |||
| 5 | Type | 0 | |||
| 6 |
Common FV errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | One or more arguments are non-numeric, such as text or empty cells. | Ensure all arguments are numbers or references to numeric cells. Remove any text or special characters. |
| #NUM! | The rate is extremely high or the number of periods is too large, causing overflow. | Check that rate and nper are reasonable. For example, rate should be a decimal like 0.05, not 5. |
| Incorrect sign | Payments are entered as positive numbers, leading to a negative future value. | Remember that outgoing payments (deposits) should be negative, and incoming (withdrawals) positive. Adjust signs accordingly. |
| #DIV/0! | The rate is zero and nper is zero, causing division by zero in the formula. | Ensure rate is not zero when nper is zero. If rate is zero, FV simplifies to pmt*nper + pv. |
Tips for using FV
- Always use negative numbers for payments you make (deposits) and positive for money you receive.
- Convert annual rates to the period rate: divide by 12 for monthly, by 4 for quarterly.
- Multiply years by the number of periods per year to get nper.
- Use the type argument to specify whether payments are at the beginning (1) or end (0) of each period.
- Test your formula with a simple case (e.g., one period) to verify signs and logic.
- Format the result as currency for readability.
Frequently asked questions
What does the FV function do?
FV calculates the future value of an investment based on a constant interest rate and regular, equal payments. It tells you how much an investment will be worth after a certain number of periods.
Why is my FV result negative?
A negative result usually means you entered payments as positive numbers. In Excel's financial functions, outgoing payments (like deposits) should be negative, and incoming (like withdrawals) positive.
How do I use FV for monthly payments?
Divide the annual interest rate by 12 to get the monthly rate, and multiply the number of years by 12 to get the total number of months. Then use those values in the FV formula.
Can FV handle payments at the beginning of the period?
Yes, set the type argument to 1. If omitted or set to 0, payments are assumed to be at the end of each period.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. FV reference