Future Value Explained: Periods, Deposits and Excel FV

What a future value calculation answers

Future value asks how much a starting sum and a sequence of equal deposits would become under a specified constant rate. It is a forward scenario based on assumptions, rather than a forecast of what an investment will earn.

The most useful first check is the period: does the rate describe a month, quarter or year, and do the payment and count refer to that same interval? This guide uses a period-native model so an 18-month plan can be described directly without pretending it lasts an integer number of years.

Starting money, recurring deposits and equal periods

Starting amount P is money present at period 0. Deposit C is an equal nonnegative payment per period. R is a percentage per period, not an annual rate unless your period is one year. N counts complete equal periods. All money uses one currency; the display selector does not convert it.

For example, starting with 1,000 and adding 100 monthly for 18 months needs an explicitly monthly rate and N=18. An annual rate needs annual periods and annual payments under this model. A calendar label cannot repair mismatched input units.

Beginning timing is an annuity due: the first recurring payment occurs at period 0 beside the starting sum. End timing is an ordinary annuity: the first payment occurs at period 1. The starting amount itself always begins at period 0.

Lump sums and level savings scenarios

Set the deposit to zero to examine a single invested amount. Set the starting amount to zero to isolate a level savings stream. Combine both to compare the contribution of existing money with that of future payments.

Compare scenarios by changing one assumption at a time. A larger future balance can reflect more money deposited rather than better growth, so inspect actual contributions and interest together. Use a different model for changing payments, withdrawals or varying returns.

Future value formula and payment timeline

Set i=R/100 and q=1+i. Grown starting money is Pq^N. End-period deposits contribute C×sum(q^k, k=0…N−1); beginning deposits multiply only that sum by q. Future value is the sum of those two grown components. Actual contributions are P+CN, and interest is future value minus actual contributions. At zero rate use P+CN; at zero periods use P with no recurring deposit.

The familiar annuity factor (q^N−1)/(q−1) equals the finite sum when the rate is nonzero, but direct subtraction is unstable near zero. The engine uses an 80-significant-digit binary accumulation of growth and payment sums, with half-even currency rounding only for display. Independent 110-digit period ledgers test the outputs; they do not import the engine.

A negative rate is applied to balances already present in each period. Earlier deposits face an extra period of decline under beginning timing. This is why a beginning balance need not be larger than an end-timing balance when the rate is negative.

FV = Pq^N + CΣ(q^k), k=0…N−1; q=1+R/100. Beginning timing multiplies only CΣ(q^k) by q.

Verified examples: 18 months, a lump sum and Excel signs

Start with 1,000, deposit 100 at each month-end, use 1% per month and count 18 months. Grown starting money is 1,196.1474756867; grown deposits are 1,961.4747568666. Future value is 3,157.6222325533 (3,157.62 displayed), actual contributions are 2,800 and interest is 357.6222325533. Moving the same 18 deposits to period starts gives 3,177.2369801220 (3,177.24 displayed). These are hypothetical assumptions, not expected returns.

The 18 end payments occur at months 1 through 18; the last deposit earns no interest before the endpoint. Beginning timing uses months 0 through 17. The difference is 19.6147475687: one extra month of growth on the deposit component, not another 100 payment.

A lump sum of 400 with no recurring deposit at 1% per period for 18 periods gives 400×1.01^18=478.4589902747, displayed as 478.46. With zero rate, the main savings example becomes 1,000+100×18=2,800. At zero periods, it is 1,000 even under beginning timing.

For a familiar spreadsheet comparison, P=500, C=200, rate=0.5% per period, N=10 and beginning timing gives 2,581.4033740602, displayed as 2,581.40. In Excel the corresponding positive savings result uses FV(0.005,10,-200,-500,1). Excel outflows have negative signs; entering positive outflows there changes the result sign.

1. Confirm that 1% and deposit 100 both refer to one month.
2. Set starting money 1000, deposit 100, rate per period 1 and count 18.
3. Choose end timing: verify 18 payments at indices 1 through 18.
4. Compare 3,157.62 ending value with 2,800 actual capital and 357.62 modeled interest.
5. Switch to beginning timing and verify 3,177.24 with the same 18 deposits.

How to use the calculator

Choose a display market. Enter starting amount and deposit (explicit 0 for a lump sum), then rate per period and complete period count. Choose beginning or end timing. Check that all three period units match, inspect the deposit timeline, and read contributed capital separately from interest. Use Clear values to remove the in-memory scenario.

Numeric assumptions start empty. Load worked example deliberately supplies the documented 18-period scenario; it does not claim a representative market rate. Changing display currency keeps numeric assumptions unchanged. There is no hidden time-unit switch or annual-to-monthly conversion.

1. Choose one currency basis for starting money and deposits.
2. Determine the rate and payment period before entering values.
3. Enter complete periods; 18 monthly periods means 18, not 1.5.
4. Choose when each deposit occurs and inspect the timeline.
5. Read ending components and contributions; clear the scenario when finished.

Separate your capital from growth

The ending value includes both your money and modeled growth. Grown deposits already include the original deposits, so do not add contributed capital to future value again. End timing places N nonzero payments at indices 1 through N; beginning timing places them at 0 through N−1. With zero deposits or zero periods there are no recurring payments.

The grown starting amount plus the grown recurring-deposit amount equals the ending value. In contrast, starting money plus un-grown deposits equals actual contributed capital. These are two different decompositions; adding all four quantities double-counts capital.

A negative interest result can coexist with a larger ending balance than the initial sum because new deposits add capital. None of these outputs measures risk, volatility, tax liability or purchasing power.

The model contract

The supplied rate and deposit apply to exactly the same equal period. A monthly rate needs a monthly deposit and a count of months. Growth is constant and reinvested; payments are level and timing is explicit. No calendar dates, leap-day accrual or day-count adjustments are inferred. No per-period cent rounding is imposed.

The number of periods is a supplied complete count, not a date difference. A daily scenario needs an explicitly daily rate and deposit; the calculator does not choose 365, 360, leap years or a bank accrual policy. There is no per-period currency posting rule or rounding to cents inside the projection.

Supported domain and numerical limits

P and C each range from 0 through 10^15. R must be greater than −100% and at most 1000% per period; N is a whole count from 0 through 36500. Inputs use ungrouped decimal points, at most 12 fractional places and 48 characters. Ending values above 10^30 are rejected. No withdrawals, changing rates, fractional payment counts, annual-rate conversion, inverse solve, taxes, fees, inflation or FX are included.

An exact 10^30 ending amount is allowed; a larger ending amount produces an error rather than a clipped projection. Tiny positive amounts remain nonzero internally and the shared currency formatter marks amounts below its two-place display threshold. The 80 significant digits describe arithmetic precision, not 80-digit certainty about economic assumptions.

No import, export, persisted scenario, inverse calculation or annual-rate converter is supplied. Unsupported cases must use a separately documented tool rather than treating blank values as a missing variable to solve.

Rate, count, timing and sign mistakes

Do not enter an annual effective yield as a monthly rate or divide it by 12 without deriving the correct convention. Eighteen monthly periods are 18, not 1.5 periods. Beginning timing moves the same N deposits earlier; it does not add an extra payment. Positive deposits here correspond to negative PV/PMT outflows in the Excel FV convention.

An effective annual quote E converts mathematically to an equivalent monthly effective rate of 100×((1+E/100)^(1/12)−1). A nominal annual rate compounded monthly uses its stated annual nominal rate divided by 12 instead. These conventions generally yield different values. The tool deliberately asks for the final periodic rate rather than silently selecting a conversion.

A hypothetical 1% monthly rate means 12.6825030132% effective growth over 12 equal months, before fees and taxes, not a 12% effective annual return. This is an arithmetic illustration, not a product rate.

Do not use N+1 payments for beginning timing. Both timings contain N deposits. Do not enter negative deposits to imitate withdrawals: this initial savings model rejects them, and irregular cash flows require their own schedule.

Future value versus compound interest and simple interest

The Compound Interest Calculator starts with a nominal annual rate, selected compounding frequency and complete years; it derives period inputs under its documented convention. This Future Value Calculator directly accepts a periodic rate and complete period count, useful for an 18-month scenario. Align assumptions before comparing outputs.

Simple Interest keeps the interest-bearing principal unchanged and does not reinvest earlier interest. Future value here reinvests growth and can include equal recurring payments. Historical ROI, CAGR, IRR and XIRR describe other return questions; none establishes a guaranteed future growth assumption.

USA, UK, Canada, Australia and India

USD, GBP, CAD, AUD and INR are display options for the same arithmetic. The USA, UK, Canada, Australia and India share this model; formatting includes local symbols and Indian grouping, without exchange-rate conversion. Do not combine amounts in different currencies merely because the display selector can change.

Real savings, pensions and investment products can have different rate definitions, tax rules, charges, contribution restrictions and posting dates. No ISA, TFSA, RRSP, superannuation or Indian account tax treatment is assumed. Check the relevant agreement and official guidance for a real decision. No near-duplicate country pages are created.

Educational scope and review

Educational scenario arithmetic, not personalized investment advice, a product quotation or a guaranteed forecast. Real cash flows, fees, tax, inflation, risk and agreement-specific posting rules can materially change outcomes. Verify the assumptions before using a result for a decision.

Prepared with AI assistance under operator editorial responsibility. Independent software reference calculations validate arithmetic, not investment suitability or agreement compliance. No independent professional financial review is claimed. Sources below explain general financial mathematics and spreadsheet conventions; review date is 2026-11-04.

Frequently asked questions

Sources and review

Sources reviewed Nov 4, 2026. Consult current local rules before relying on time-sensitive information.

• Microsoft: FV rate, payment periods and cash-flow signs
• OpenStax: annuities and payment timing
• OpenStax: compound interest conventions