Future value (FV) is the amount a starting balance and any subsequent contributions would reach by a chosen date under an assumed rate or sequence of returns. For a single deposit, the familiar formula is FV = PV × (1 + i)N. For monthly contributions, their amount and timing must also be included.
Future value is a useful planning calculation, not a guarantee that investments will earn a fixed return. For an interest-paying deposit account, the disclosed APY is different from a nominal interest rate. For market investments, the actual path of gains, losses and deposits can differ from a smooth-growth projection. This guide makes each assumption explicit.
What does future value actually tell you?
Future value answers a dated, conditional question: if an amount earns a specified rate for a specified period, what balance does the model produce? The calculation can help compare savings plans, payment dates and financial targets. It cannot determine whether you can afford a contribution, forecast a stock price or remove investment risk.
Future value and present value run in opposite directions. Future value moves an amount forward using a rate; present value discounts a later amount back to a comparison date. A later dollar amount can also be expressed in today’s purchasing power by adjusting for inflation, which is different from a present-value comparison using a chosen discount rate.
The Rate–Deposit Timing–Horizon check
Before doing any calculation, identify these three inputs. This framework prevents most future-value spreadsheet and calculator mistakes.
Is your 6% a nominal rate compounded monthly, a disclosed 6% APY or merely a hypothetical investment return? They do not use identical monthly conversions.
Are contributions made now, at the start of each month, or at month-end? Count only deposits that will actually be made by the goal date.
Are you modeling five years, 60 months or 60 credited periods? Use an interest rate that matches the modeled period.
There is also a fourth check after the math: compare the result with an achievable contribution plan and the consequences of missing the target. The calculation solves the formula you enter, not the affordability of the inputs. For the goal-first approach, see our Savings Goal Calculator.
Future value of one deposit: formula and example
PV is the starting amount; i is the rate per modeled period, as a decimal; N is the number of periods; and FV is the ending balance. If the rate compounds once a year, i is the annual rate and N is the number of years. If it compounds monthly at a nominal annual rate r, then i = r ÷ 12 and N = years × 12.
Consider a hypothetical $5,000 deposit earning a fixed 6% annual rate, compounded annually, for ten years with no deposits, withdrawals, fees or taxes:
The model adds $3,954.24 beyond the original deposit. That addition is interest only if the underlying product really pays under those terms. For a stock fund, the same formula is just an illustrative growth path, and the actual investment may lose value.
To reverse this single-deposit calculation, divide the future target by the same growth factor: PV = FV ÷ (1 + i)N. Our Time Value of Money guide explains how to choose a meaningful discount assumption before comparing payments at different dates.
Future value when you add money every month
Most plans have both an opening balance and recurring deposits. If all payments occur at the end of each month and the balance grows at a constant monthly rate i, the ordinary-annuity formula is:
C is each monthly contribution and N is the total number of monthly contributions. This formula assumes no withdrawals, a steady rate, and equal payments. When i = 0, do not divide by zero: simply use FV = PV + C × N. OpenStax describes the end-of-period payment stream as an ordinary annuity.
Suppose you begin with $5,000, deposit $200 at the end of every month for 10 years, and assume an unchanged 6% nominal annual rate compounded monthly. The monthly rate is 0.06 ÷ 12 = 0.005 and N = 120:
| Component | Amount | How counted |
|---|---|---|
| Starting balance | $5,000.00 | Money already held at month zero |
| 120 monthly deposits | $24,000.00 | 120 × $200 paid at each month’s end |
| Total contributed | $29,000.00 | Your cash, with no growth included |
| Modeled additional growth | $12,872.85 | Depends on the assumed rate |
| Projected future balance | $41,872.85 | Deposits plus modeled growth |
The distinction matters: $29,000 comes from money deposited; the remaining $12,872.85 depends on the hypothetical growth assumption. A retirement account balance does not earn a contractual 6% merely because the formula uses 6%. The actual investment return can be negative in some periods.
Correction to the former 25-year example: $300 deposited at each month-end for 25 years, at a hypothetical 8% nominal annual rate compounded monthly, yields $285,307.92. That is $90,000 of deposits plus $195,307.92 of modeled growth. Carry the full monthly rate of 0.08 ÷ 12 through the calculation, rather than rounding it to 0.00667 before exponentiation. A reproducible spreadsheet check is =FV(8%/12,25*12,-300,0,0). This still is not a market-return forecast.
Information gain: show the funding source, not just the future balance
Here is the exact same $5,000 starting balance and 120 deposits of $200, changing only the hypothetical nominal annual rate with monthly compounding. These are sensitivity cases, not a range of expected market outcomes or current bank offerings.
Ten-year balance at different fixed model rates
| Model rate | Future balance | Own contributions | Modeled growth |
|---|---|---|---|
| 0% nominal | $29,000.00 | $29,000.00 | $0.00 |
| 3% nominal | $34,695.05 | $29,000.00 | $5,695.05 |
| 6% nominal | $41,872.85 | $29,000.00 | $12,872.85 |
| 9% nominal | $50,959.64 | $29,000.00 | $21,959.64 |
A higher number in this table does not mean the higher rate is achievable or that one investment is automatically better. A practical test is to ask whether the goal can still work with 0% growth or with a less favorable outcome, especially if the due date is not flexible. For choosing products by deadline and ability to withstand loss, consult Saving vs. Investing.
What changes if deposits happen at the start of the month?
In an annuity due, a deposit arrives at the beginning of each period and receives one additional period of modeled growth. For the contribution component only, multiply the ordinary-annuity value by (1 + i). The original starting deposit is already present at time zero, so you must not multiply its component twice.
| Deposit schedule | Ending balance | Difference |
|---|---|---|
| End of month (ordinary annuity) | $41,872.85 | Baseline |
| Beginning of month (annuity due) | $42,036.73 | +$163.88 |
The two plans contain the same number of deposits and total amount paid. Their difference comes only from deposit timing under this particular constant-rate model. Real bank accounts may calculate interest on daily balances and credit it on a different schedule; a real investment’s daily prices and executed contribution dates will also matter.
When should you use APY instead of annual rate ÷ 12?
The examples above specify a nominal annual rate compounded monthly. That is why dividing 6% by 12 is appropriate. If instead a savings account advertises a 6% APY, compounding is already reflected in the annual yield. Assuming equivalent smooth monthly growth, convert with:
For a stated 6% APY, the equivalent monthly rate is approximately 0.4868%, not 0.5000%. Treat this as a modeling conversion, not necessarily the bank’s daily interest-crediting procedure. Its actual interest depends on account terms, balances and the published rate throughout the period. The APY vs. APR guide explains deposit APY disclosures and borrowing APR separately.
Do not enter a stock fund’s hoped-for return as “APY.” Investments involve changes in market value and do not have a standardized insured deposit yield. Investor.gov explains that principal and returns can be lost in market investments.
Work backward: How much must you contribute to reach a target?
Suppose the desired balance is $40,000 in ten years, with $5,000 already set aside and 120 possible month-end deposits. Begin with the no-growth requirement:
At a constant 6% nominal annual model rate compounded monthly, solve the earlier formula for C:
The unrounded modeled requirement is about $188.5718 per month. Paying $188.57 would leave a modeled shortfall of approximately $0.29; rounding up to $188.58 per month would exceed the target by about $1.35. This illustrates why contribution requirements should be rounded upward when the goal is a minimum balance. The lower contribution assumes growth that may not materialize. The Savings Goal Calculator lets readers compare the deposit-only requirement with an APY-based model using the correct rate conversion.
This page teaches future-value math; it does not decide whether $188.58 or $291.67 is affordable. Compare the required deposits with actual spending and upcoming bills using the Budgeting & Saving hub.
What the formula leaves out: fees, inflation and investment losses
Inflation changes purchasing power, not the nominal account balance
At a hypothetical constant 3% annual inflation rate over ten years, the $41,872.85 projected ending balance has purchasing power equivalent to approximately $31,157.34 in today’s dollars, calculated as FV ÷ 1.0310. This is an inflation adjustment, not a discount rate selected for a present-value investment decision.
Fees and taxes depend on their actual timing and rules
Fund expenses can reduce returns, and transaction charges can reduce money available to grow. A simplified net-rate assumption can illustrate long-term fee drag but may not reproduce an actual fee schedule, deposits, tax consequences or realized returns. Don’t deduct the same fee twice—once through a reduced rate and again as a cash withdrawal. Our Power of Compounding guide shows how persistent costs affect growth models.
Average returns are not a fixed monthly payment from the market
Consider $1,000 with a 20% gain in year one and a 20% loss in year two, without any other cash flow. The final balance is $1,000 × 1.20 × 0.80 = $960. Although the arithmetic average of the two annual returns is zero, the account ends 4% lower. Sequence and volatility matter; a smooth positive growth-rate assumption can conceal those risks. Investment holdings are not the same as insured deposits. Investor.gov explains why securities can lose principal.
How to use the Future Value Calculator on this page
Use the existing WordPress Future Value Calculator to test the numbers from this guide. Choose lump sum or regular contributions, enter a rate and term with matching periods, and compare the reported total with the separately calculated contribution total. If the tool displays “interest earned” for a stock-investment example, interpret it as modeled growth, not guaranteed earned interest.
If you want to work backward from a specific savings goal, use the Savings Goal Calculator, which separates monthly deposits from assumed growth.
Future Value Calculator
Estimate how much your balance and deposits could grow over time.
Modeled Investment Growth
Printable future-value assumption worksheet
Record the inputs, calculation convention and the money you will actually contribute. This avoids treating a modeled dollar amount as an available balance before its due date.
Do not record account passwords, PINs, Social Security numbers or full account numbers on a worksheet that may be shared or printed.
Future value frequently asked questions
What is the easiest future value formula?
For one deposit at a constant per-period rate: FV = PV × (1 + i)N. For regular equal end-of-month deposits, add the ordinary-annuity term. At 0% growth, future value is simply the starting balance plus all deposits.
Why is my spreadsheet future value different from an online calculator?
Check whether the quoted rate is APY or nominal, whether payments are at the beginning or end of each month, whether the starting amount is counted separately, and whether intermediate interest rates are prematurely rounded. Fees, daily balances and nonmonthly compounding also change results.
Is an 8% assumed investment return the same as earning 8% APY?
No. A deposit-account APY is a specific disclosure about interest; an 8% investment-return assumption is only a scenario. Markets can produce gains and losses, and the result may differ greatly from a constant-rate projection.
Does future value tell me how much I need to save each month?
It can if you rearrange the equal-payment formula with a defined target, deadline, initial balance and model rate. But the required amount may exceed what your budget can safely support, and the modeled return may not occur.
How do I calculate future value in Excel or Google Sheets?
For this article’s $5,000 initial balance, $200 end-of-month deposits, a nominal 6% annual rate compounded monthly, and 120 months, use =FV(6%/12,120,-200,-5000,0). The final argument 0 means payments occur at period-end; 1 models beginning-of-period payments. The formula’s rate and period must match.
Should I use the same growth assumption for savings and stocks?
Not automatically. A deposit account has stated terms and may have a variable APY; stocks and stock funds have market risk without a fixed annual return. Choose a rate for the specific exercise and keep the uncertainty visible.
Bottom line: future value is a model, not a promise
Future value becomes most useful when you separate the money you control—your starting balance and actual deposits—from growth you assume. Label the rate correctly, count deposits on their real dates, test 0% growth and unfavorable cases, then compare the result against a goal you can fund on time.