How this instrument works
A lumpsum investment moves one sum into the market in a single transaction — a year-end bonus, an inheritance, a matured CD, or the proceeds from selling a house — rather than feeding money in gradually. The formula behind this sheet, FV = P(1 + r/100)^t, reflects that choice: it has no slot for a second deposit, so the entire principal starts earning on day one and keeps earning on its own earnings for every one of the t years that follow. That is the arithmetic difference between a lumpsum and dollar-cost averaging, where smaller amounts arrive on a schedule and each one only compounds for whatever time remains after it lands.
The field asks for an assumed annual return rather than an interest rate on purpose, because the number that belongs here is a compound annual growth rate — the single steady rate that would have produced the same ending balance as a real, bumpy sequence of up and down years. That is not the same figure as the average of those yearly returns: a fund that gains 50% one year and loses 50% the next has an average return of 0%, yet a dollar invested in it actually shrinks to $0.75, a compound annual growth rate of roughly −13.4%. Typing a fund's simple average return into Assumed annual return, % instead of its compound annual growth rate is the single most common way a projection like this ends up overstating what a lumpsum will actually become.
Four things sit outside this arithmetic. The rate is held perfectly constant for the whole horizon, when no market ever delivers a flat line — actual returns arrive as the volatile sequence the growth rate above is standing in for. Nothing is added or withdrawn after day one, so any plan to top up the account later needs a different calculation entirely. The result is nominal and pre-tax: fund expense ratios, brokerage fees, and the capital gains tax due whenever the position is eventually sold all reduce what actually lands in hand. And the formula cannot express a loss — Investment horizon, years and Assumed annual return, % both require a positive number, so a genuine down-year scenario has to be modeled by hand outside this sheet.
- Enter the sum you're deciding what to do with into One-time investment, $ — the windfall, payout, or balance you'd invest in a single transaction.
- Set Assumed annual return, % to the compound annual growth rate you want to test, not a raw average of yearly returns.
- Set Investment horizon, years to how long the money stays invested without being added to or withdrawn from.
- Read Future value — what that single sum becomes if the assumed rate holds exactly steady for every one of those years.
Worked example — a $100,000 windfall over ten years
Say a $100,000 inheritance arrives in one transaction, and the plan is to leave it in a diversified fund assumed to compound at a steady 10% a year for a decade. One-time investment, $ takes 100000, Assumed annual return, % takes 10, and Investment horizon, years takes 10. Future value returns $259,374.25 — the exact result of multiplying $100,000 by 1.10 ten times over, not an estimate.
Two comparisons make that number legible. Doubling the principal to $200,000 under the same 10% and ten years exactly doubles the answer to $518,748.49, because the formula is linear in the amount invested — an equal windfall, twice as large, growing at the same assumed rate for the same stretch. Setting the return to 0% instead leaves the full $100,000 untouched after ten years, confirming that every dollar of growth above the original deposit came from the 10% assumption alone, not from anything hidden in the arithmetic.
Questions
What counts as a lumpsum investment?
Any single sum invested in one transaction rather than staggered over time — a bonus, an inheritance, a matured CD or provident-fund payout, or proceeds from selling property or a business, all moved into an account on one date and left to compound. The opposite is dollar-cost averaging, where the same total arrives in smaller pieces on a schedule, and each piece then compounds for a shorter time than a lumpsum invested on day one.
Is investing as a lumpsum better than spreading it out?
This instrument doesn't answer that — it only computes where one assumed rate, compounded once a year, lands after a chosen horizon. A lumpsum is fully exposed to the return sequence from the moment it's invested, while dollar-cost averaging spreads entry points across many dates and needs its own separate calculation. Comparing the two means weighing how much of that sequence risk you're willing to carry, a judgment call this sheet deliberately leaves alone.
Why does the calculator ask for one 'assumed annual return' instead of year-by-year figures?
Because a single compound annual growth rate is the standard way to summarize an uneven sequence of yearly returns into one number that reproduces the same ending balance. It is not the same as the simple average of those yearly figures — a 50% gain followed by a 50% loss averages to 0% but actually leaves a dollar worth $0.75, a compound annual growth rate near −13.4%. Use a fund's published growth rate here, not its average annual return, or the projection will run high.
How much does the return assumption change the final number?
A great deal, because the rate sits inside an exponent. On the calculator's own $100,000-over-ten-years setup, dropping the assumed return from 10% to 8% lowers Future value from $259,374.25 to about $215,892; raising it to 12% instead lifts the answer to about $310,585. Small shifts in the assumption compound into large shifts in the projection, which is why that figure deserves more scrutiny than the horizon or the principal.
Can this calculator model a market downturn or a loss year?
No — Assumed annual return, % and Investment horizon, years both require a positive number, so the formula can only project growth, never a decline. To see how sensitive the outcome is to a downturn, run the same principal and horizon at a lower positive rate and compare the two Future value readouts; that shows the cost of a slower path without pretending to model an actual negative year.
Does Future value account for taxes, fees, or inflation?
No. The result is nominal and pre-tax: fund expense ratios and brokerage costs reduce the return actually earned, capital gains tax is due on the profit once the position is sold, and inflation erodes the purchasing power of whatever balance remains. Treat Future value as the arithmetic outcome of the stated assumption, not the amount that would land in a bank account after those costs.
References
- SEC Investor.gov — investing basics, compounding, and risk
- IRS Topic no. 409 — capital gains and losses
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.