Future Value Formula: Complete Guide to Calculating FV

What Is the Future Value Formula?

The future value formula calculates what a sum of money today will be worth at a specific point in the future, assuming it earns a fixed rate of return. At its core, the formula captures the time value of money — the principle that a dollar today is worth more than a dollar tomorrow because it can be invested to earn interest.

The most fundamental form of the future value formula is:

Where:

• FV — Future Value: the amount your investment will grow to
• PV — Present Value: the initial investment or deposit today
• r — Interest rate per compounding period (expressed as a decimal)
• n — Total number of compounding periods

This formula assumes that interest is reinvested — meaning you earn interest on your interest. This compounding effect is what makes long-term investing so powerful. Even modest annual returns can produce dramatic growth over decades.

For example, if you invest $5,000 at an annual interest rate of 8% for 10 years with annual compounding:

Your investment more than doubles, and $5,794.62 of the final amount is pure interest earned through compounding.

Future Value Formula with Compound Interest

In practice, interest often compounds more than once per year. Savings accounts may compound daily, bonds may compound semi-annually, and certificates of deposit often compound monthly. When the compounding frequency differs from annually, we adjust the formula:

Where:

• r — Annual nominal interest rate (APR) as a decimal
• m — Number of compounding periods per year
• n — Number of years
• r/m — Interest rate per compounding period
• m × n — Total number of compounding periods

Compounding Frequency Values

Why More Frequent Compounding Increases FV

When interest compounds more frequently, each compounding period adds earned interest to the principal sooner. That added interest then earns interest in subsequent periods. The effective annual rate (EAR) captures this effect:

For a 6% nominal rate compounded monthly: EAR = (1 + 0.06/12)¹² − 1 = 6.168%. This means monthly compounding at 6% APR is equivalent to annual compounding at 6.168%.

Consider $10,000 invested at 6% for 20 years under different compounding schedules:

Over 20 years, the difference between annual and daily compounding on $10,000 at 6% is over $1,127. For larger balances and longer horizons, this gap grows substantially. Explore all frequencies with our Compound Interest Calculator.

Future Value of Annuity Formula

An annuity is a series of equal payments made at regular intervals. The future value of an annuity formula calculates the total accumulated value of all those payments plus the compound interest earned on each one.

Ordinary Annuity (End of Period)

For an ordinary annuity — where payments occur at the end of each period — the formula is:

Where:

• PMT — Payment amount per period
• i — Interest rate per period (= annual rate / compounding periods per year)
• n — Total number of payment periods

The expression [((1 + i)ⁿ − 1) / i] is known as the Future Value Interest Factor of an Annuity (FVIFA).

Annuity Due (Beginning of Period)

For an annuity due — where payments occur at the beginning of each period — each payment earns one extra period of interest. The formula is:

This is simply the ordinary annuity formula multiplied by (1 + i). Annuity due payments are common for rent, insurance premiums, and lease payments.

Derivation: Why Does This Formula Work?

Consider making payments of PMT at the end of each period for n periods at rate i. Each payment compounds for a different number of periods:

1. Payment 1 (made at end of period 1) compounds for (n − 1) periods: PMT × (1 + i)ⁿ⁻¹
2. Payment 2 (made at end of period 2) compounds for (n − 2) periods: PMT × (1 + i)ⁿ⁻²
3. ...
4. Payment n−1 compounds for 1 period: PMT × (1 + i)¹
5. Payment n (final payment) earns no interest: PMT × (1 + i)⁰ = PMT

The total FV is the sum of this geometric series:

Applying the geometric series sum formula yields:

Try different payment scenarios with our Annuity FV Calculator.

Future Value of Growing Annuity Formula

A growing annuity is a series of payments that increase at a constant rate each period. This is more realistic for many real-world scenarios — for example, retirement contributions that increase with annual salary raises, or rental income that grows with inflation.

Where:

• PMT — First payment amount
• i — Interest rate per period
• g — Growth rate of payments per period
• n — Total number of periods

Important Conditions

• This formula requires i ≠ g. When i = g, use the special-case formula: FV = PMT × n × (1 + i)ⁿ⁻¹
• The growth rate g must be less than i for the series to converge in a present value context, though the future value formula works regardless

Worked Example: Growing Retirement Contributions

Suppose you contribute $500/month to your 401(k), and you expect your contributions to grow by 3% per year (matching salary increases). Your expected annual return is 7%, and you plan to invest for 30 years.

1. Convert to annual periods: PMT = $6,000/year (first year total), i = 0.07, g = 0.03, n = 30
2. Apply the formula: FV = $6,000 / (0.07 − 0.03) × [(1.07)³⁰ − (1.03)³⁰]
3. Calculate each term: (1.07)³⁰ = 7.6123, (1.03)³⁰ = 2.4273
4. Solve: FV = $6,000 / 0.04 × (7.6123 − 2.4273) = $150,000 × 5.1850 = $777,749

Compare this to a flat $6,000/year (no growth) which would yield approximately $566,765. The 3% annual growth in contributions adds over $210,000 to your retirement fund.

Continuous Compounding Formula

Continuous compounding represents the theoretical limit of compounding frequency — interest is calculated and reinvested at every infinitesimal instant. As the number of compounding periods per year (m) approaches infinity, the compound interest formula converges to:

Where:

• e — Euler's number, approximately 2.71828
• r — Annual nominal interest rate (decimal)
• n — Number of years

Mathematical Derivation

Starting from the compound interest formula and taking the limit as m → ∞:

1. Start: FV = PV × (1 + r/m)^m×n
2. Substitute k = m/r: FV = PV × [(1 + 1/k)^k]^r×n
3. Recognize the limit: As k → ∞, (1 + 1/k)^k → e
4. Result: FV = PV × e^r×n

When Is Continuous Compounding Used?

While no real-world bank compounds continuously, this formula is essential in:

• Options pricing — the Black-Scholes model uses continuous compounding for the risk-free rate
• Theoretical finance — continuous-time models simplify many mathematical derivations
• Upper-bound estimates — continuous compounding gives the maximum possible FV for a given nominal rate
• Forex & derivatives markets — where rates are often quoted with continuous compounding

How to Calculate Future Value in Excel

Microsoft Excel and Google Sheets include a built-in FV() function that handles both lump-sum and annuity calculations in a single formula:

Parameter breakdown:

• rate — Interest rate per period. For monthly compounding at 6% APR, enter 0.06/12 or 0.005
• nper — Total number of compounding periods. For 10 years monthly, enter 10*12 or 120
• pmt — Payment per period. Enter as a negative number for deposits (cash outflow). Use 0 if no periodic payments
• pv — Present value (initial investment). Enter as a negative number for investments. Default is 0
• type — 0 or omitted = payment at end of period (ordinary annuity); 1 = payment at beginning (annuity due)

Excel FV Examples

Example 1: Lump Sum Only

$25,000 invested at 5% annual rate, compounded monthly, for 15 years:

Example 2: Monthly Deposits Only

$300/month deposited at 7% annual rate, compounded monthly, for 20 years:

Example 3: Lump Sum + Monthly Deposits

$10,000 initial investment plus $200/month at 6% for 25 years:

Of this amount, $10,000 is your initial investment, $60,000 is total deposits ($200 × 300 months), and $111,638.61 is compound interest earned.

Example 4: Annuity Due

Same as Example 3, but with payments at the beginning of each period:

The annuity due version is $849.42 higher because each deposit has one extra month to compound.

Future Value Formula Examples

Below are three detailed, step-by-step examples covering different real-world scenarios. Each walks you through the formula selection, variable identification, and full calculation.

Example 1: College Savings — Lump Sum with Monthly Compounding

Scenario: You deposit $15,000 into a 529 college savings plan earning 6.5% APR compounded monthly. How much will you have in 18 years when your child starts college?

1. Identify variables: PV = $15,000, r = 0.065, m = 12, n = 18
2. Calculate rate per period: i = r/m = 0.065/12 = 0.005417
3. Calculate total periods: N = m × n = 12 × 18 = 216
4. Apply the formula: FV = $15,000 × (1 + 0.005417)²¹⁶
5. Compute (1.005417)²¹⁶: = 3.2209
6. Final answer: FV = $15,000 × 3.2209 = $48,313.50

Your $15,000 deposit grows to over $48,000 — a gain of $33,313.50 in pure compound interest.

Example 2: Retirement Savings — Combined Lump Sum + Annuity

Scenario: You have $50,000 in your 401(k) today and contribute $400/month. Your portfolio earns an average of 8% annually, compounded monthly. What is your balance in 30 years?

1. Identify variables: PV = $50,000, PMT = $400, r = 0.08, m = 12, n = 30
2. Rate per period: i = 0.08/12 = 0.006667
3. Total periods: N = 12 × 30 = 360
4. Lump-sum component: FV_lump = $50,000 × (1.006667)³⁶⁰ = $50,000 × 10.9357 = $546,785
5. Annuity component: FV_annuity = $400 × [((1.006667)³⁶⁰ − 1) / 0.006667] = $400 × 1,490.36 = $596,143
6. Total FV: $546,785 + $596,143 = $1,142,928

You become a millionaire! Your total out-of-pocket contributions are $50,000 + ($400 × 360) = $194,000. The remaining $948,928 is compound interest growth.

Example 3: Short-Term Savings — Quarterly Compounding

Scenario: You invest $8,000 in a 3-year CD paying 4.8% APR compounded quarterly. What will it be worth at maturity?

1. Identify variables: PV = $8,000, r = 0.048, m = 4, n = 3
2. Rate per period: i = 0.048/4 = 0.012
3. Total periods: N = 4 × 3 = 12
4. Apply formula: FV = $8,000 × (1.012)¹²
5. Compute (1.012)¹²: = 1.15389
6. Final answer: FV = $8,000 × 1.15389 = $9,231.13

Your $8,000 CD matures to $9,231.13 after 3 years, earning $1,231.13 in interest. The quarterly compounding gives you a slightly higher return than the same rate compounded annually ($9,219.17).

Future Value vs Present Value Formula

Future Value and Present Value are mirror images in the time value of money framework. FV projects forward in time; PV discounts backward. Understanding both is essential for investment analysis, loan evaluation, and financial planning.

These two formulas are algebraically identical — just rearranged. If you know FV and want PV, divide by the compound factor. If you know PV and want FV, multiply by it. Together, they form the backbone of discounted cash flow (DCF) analysis, which is used to value businesses, projects, and financial instruments.

Frequently Asked Questions

• What is the basic future value formula?

  The basic future value formula is FV = PV × (1 + r)ⁿ, where PV is your initial investment (present value), r is the interest rate per compounding period, and n is the total number of compounding periods. This formula calculates how much a single lump-sum investment will be worth after earning compound interest over time. For annual compounding, r equals the annual interest rate and n equals the number of years.

• What is the difference between the FV of a lump sum and the FV of an annuity?

  The FV of a lump sum calculates growth of a single one-time deposit: FV = PV × (1 + r)ⁿ. The FV of an annuity calculates the accumulated value of a series of equal periodic payments: FV = PMT × [((1 + i)ⁿ − 1) / i]. In real-world investing, most scenarios combine both — an initial deposit plus ongoing contributions. You can add both formulas together to get the total future value.

• How does compounding frequency change the future value formula?

  When interest compounds more than once per year, the formula becomes FV = PV × (1 + r/m)^m×n, where m is the number of compounding periods per year. More frequent compounding produces a higher future value because earned interest is reinvested sooner. For example, at 6% over 10 years on $10,000: annual compounding gives $17,908, while monthly compounding gives $18,194 — a difference of $286. In the extreme, continuous compounding uses FV = PV × e^r×n.

• What is the growing annuity future value formula?

  The growing annuity formula is FV = PMT / (i − g) × [(1 + i)ⁿ − (1 + g)ⁿ], where g is the growth rate of the payments. This is used when payments increase at a constant rate each period — for example, retirement contributions that rise by 3% annually with your salary. The formula requires that the interest rate (i) is not equal to the growth rate (g).

• How do I use the FV function in Excel or Google Sheets?

  Use =FV(rate, nper, pmt, [pv], [type]). Enter the rate per period (e.g., 0.06/12 for 6% monthly), total periods (e.g., 120 for 10 years monthly), payment per period as a negative number, and present value as a negative number. The type argument is 0 for end-of-period payments or 1 for beginning-of-period. Example: =FV(0.07/12, 360, -500, -10000) calculates the FV of $10,000 + $500/month at 7% for 30 years.

• What is continuous compounding and when is it used?

  Continuous compounding is the mathematical limit of compounding frequency — as if interest were calculated and added every infinitesimal instant. The formula simplifies to FV = PV × e^r×n where e ≈ 2.71828. While no bank truly compounds continuously, this formula is widely used in derivatives pricing (Black-Scholes model), theoretical finance, and as an upper bound when comparing compounding methods.

• What is the Rule of 72 and how does it relate to future value?

  The Rule of 72 is a mental shortcut for estimating how long it takes an investment to double. Divide 72 by the annual interest rate to get the approximate doubling time. At 6%, money doubles in about 72/6 = 12 years. This works because setting FV = 2 × PV in the formula gives (1 + r)ⁿ = 2, and solving for n yields n = ln(2)/ln(1+r) ≈ 72/r for typical rates. It's most accurate for rates between 2% and 12%.

• How do I adjust the future value formula for inflation?

  To find the real (inflation-adjusted) future value, you have two approaches. First, you can calculate nominal FV normally, then deflate: Real FV = Nominal FV / (1 + inflation)ⁿ. Second, you can use the real interest rate directly: Real Rate ≈ Nominal Rate − Inflation Rate (Fisher approximation), then apply FV = PV × (1 + real rate)ⁿ. For example, if your nominal FV is $100,000 after 20 years and inflation averages 3%, the real FV is $100,000 / (1.03)²⁰ = $55,368 in today's purchasing power.

Related Financial Calculators