Excel Formula for Savings Growth: FV & More

Formulas & functions · Updated November 22, 2026

The core Excel formula for savings growth is =FV(rate, nper, pmt, [pv], [type]), where you plug in the periodic interest rate, number of periods, payment per period, and starting balance. For a simple example, =FV(0.05/12, 10*12, -200, -1000) calculates the future value of a $1,000 initial deposit plus $200 monthly contributions at 5% annual interest compounded monthly for 10 years, returning about $31,944.06.

Understanding the FV Function

The FV (Future Value) function is Excel’s built-in tool for calculating how much a series of deposits or a lump sum will grow over time at a constant interest rate. Its syntax is:

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

  • rate – the interest rate per period. If your annual rate is 5% and you deposit monthly, use 5%/12 (0.004167).
  • nper – the total number of payment periods. For 10 years of monthly deposits, that’s 10*12 = 120.
  • pmt – the payment made each period. It must be entered as a negative number because it’s money going out of your pocket (an outflow).
  • pv – (optional) the present value, or the initial lump sum. Also negative if it’s an outflow. If omitted, assume 0.
  • type – (optional) 0 or omitted means payments are made at the end of the period (ordinary annuity); 1 means at the beginning (annuity due).

For example, if you start with $1,000, contribute $200 at the end of each month, earn 5% annually compounded monthly, and want the balance after 10 years, the formula in cell A1 would be:

=FV(0.05/12, 10*12, -200, -1000)

Excel returns $31,944.06. That’s the total of your contributions ($1,000 + $200*120 = $25,000) plus about $6,944 in interest.

How to Set Up a Savings Growth Spreadsheet

Instead of hardcoding numbers, you can build a simple model with labeled cells so you can change assumptions easily. Here’s a typical layout:

  • A1: Annual Interest Rate (e.g., 5%)
  • A2: Years (e.g., 10)
  • A3: Monthly Contribution (e.g., 200)
  • A4: Initial Balance (e.g., 1000)

Then in A6, put the formula:

=FV(A1/12, A2*12, -A3, -A4)

This returns the same $31,944.06. To see the effect of monthly vs. annual compounding, you’d adjust the rate and nper accordingly. For annual compounding, use =FV(A1, A2, -A3*12, -A4) – but note that this assumes you make one big deposit at the end of each year, not monthly, so it’s not directly comparable.

Choosing Between FV and Other Functions

Excel offers several related functions, each for a different question:

  • FV – future value of an investment (what you’ll have).
  • PV – present value of a future amount (what you need to start with to reach a goal).
  • PMT – the payment needed to reach a future value (how much to save each period).
  • RATE – the interest rate needed to grow a present value to a future value.
  • NPER – the number of periods needed to reach a goal.

For example, to find out how much you need to save monthly to reach $50,000 in 15 years at 4% annual interest, use:

=PMT(0.04/12, 15*12, 0, 50000)

This returns about -$203.54, meaning you’d need to deposit $203.54 each month. Note the negative sign indicates an outflow; you can wrap it in ABS() to get a positive number.

Common Mistakes and Misconceptions

One frequent error is forgetting to divide the annual rate by the number of compounding periods. If you use 5% instead of 5%/12 with monthly periods, you’re effectively applying a 5% monthly rate, which grossly overstates growth. Another is mixing up signs – if you enter pmt as positive, FV returns a negative number, which confuses many users. Also, be careful with the ‘type’ argument: if you deposit at the beginning of the month (common for savings), set type to 1, which increases the future value slightly because each deposit earns interest for an extra month.

A common misconception is that FV accounts for inflation or taxes – it doesn’t. It only calculates nominal growth at a fixed rate. To see real purchasing power, you’d need to subtract an assumed inflation rate from the interest rate (e.g., use 3% if nominal rate is 5% and inflation is 2%).

Comparing Compounding Frequencies

The more frequently interest is compounded, the higher the future value, all else equal. Here’s a quick comparison for $10,000 at 6% annual interest for 5 years:

  • Annual compounding: =FV(0.06, 5, 0, -10000) → $13,382.26
  • Monthly compounding: =FV(0.06/12, 5*12, 0, -10000) → $13,488.50
  • Daily compounding (365 periods): =FV(0.06/365, 5*365, 0, -10000) → $13,498.26

Notice the difference between annual and daily is about $116 – significant over longer terms. In practice, most bank savings accounts compound daily or monthly, so use the appropriate period.

Using a Savings Goal Calculator

If you have a target amount in mind, you can use the NPER or PMT functions to plan. For instance, to see how long it takes to reach $100,000 starting with $5,000 and saving $500 monthly at 4% annual interest compounded monthly, use:

=NPER(0.04/12, -500, -5000, 100000)

This returns about 142.5 months, or 11.9 years. Note that the pv and pmt are negative (outflows), and the fv is positive (inflow). If you want to know the rate needed to double your money in 10 years with no additional contributions, use:

=RATE(10, 0, -1000, 2000)

That gives approximately 7.18% annual rate.

Frequently Asked Questions

Why does my FV formula return a negative number?
Because FV assumes that money going out (deposits) is negative and money coming in (future value) is positive. If you enter pmt or pv as positive, the result flips to negative. Use ABS() or change the sign of the inputs if you prefer a positive result.

Does FV include the initial deposit?
Yes, if you provide the pv argument. If you omit pv, it assumes 0. So to include a starting balance, enter it as a negative number (e.g., -1000).

How do I calculate savings growth with irregular deposits?
FV assumes constant periodic payments. For irregular deposits, you’d need to build a schedule with each deposit’s own FV and sum them, or use a table with dates and amounts and the XIRR function for irregular cash flows.

What’s the difference between FV and FVSCHEDULE?
FVSCHEDULE calculates the future value of a single lump sum with a schedule of varying interest rates. For example, =FVSCHEDULE(1000, {0.02,0.03,0.04}) grows $1,000 over three periods with different rates. FV uses a constant rate.

Can I use FV for a loan balance?
Yes, FV can calculate the remaining balance on a loan after a certain number of payments. For example, =FV(0.05/12, 24, 500, -20000) would show the balance after 24 months of $500 payments on a $20,000 loan at 5% annual interest. But for amortization schedules, consider using the CUMIPMT or CUMPRINC functions.

Is there a way to account for inflation in my savings growth calculation?
Yes, but not directly. You can subtract an assumed inflation rate from the nominal interest rate. For instance, if your savings earns 4% and inflation is 2%, use 2% as the rate in FV to get the future value in today’s dollars. This is a simplified approach; real-world inflation is variable.

Safety and Accuracy Notes

When using financial formulas in Excel, always double-check your units: rate per period and nper must be consistent (monthly rate with monthly periods). Also, remember that Excel’s financial functions assume end-of-period payments unless you specify type=1. For real-world savings, check with your bank or financial advisor for exact compounding terms, as some accounts compound daily, others monthly, and some have tiered rates. This article is for educational purposes and does not constitute financial advice.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.