How this instrument works
One million dollars is not derived from anyone's actual spending — it is a fixed, round number that has carried cultural weight as a wealth milestone for well over a century, long before compound-growth spreadsheets existed. This instrument answers one narrow question about that number: given what is already saved, what gets added every year, and an assumed rate of return, how many years pass before the balance crosses it. The target never moves; only the three inputs do.
The formula rearranges the standard compound-growth equation to isolate time instead of a future balance. C ⁄ r — the annual contribution divided by the assumed return — stands in for what that contribution stream would be worth if it kept compounding forever at the same rate; adding it to both the $1,000,000 target and the current balance converts a lump sum plus a repeating deposit into one clean ratio, and a natural logarithm turns that ratio into years. Nudge the return up half a point and the years drop by more than a simple proportion would suggest, because the higher rate compounds on the contribution term too, not only on the balance already sitting in the account.
A million dollars is not automatically enough to retire on, fund a business, or support a family for a decade — its adequacy depends entirely on what a person or household spends, a question this sheet never asks. A retiree living on $30,000 a year could draw that sum down for decades at a conservative rate; a household spending $80,000 a year would exhaust it far sooner. Treat the years figure as a countdown to a specific dollar amount, not a verdict on whether that amount is the right one to chase.
- Enter Current savings, $ — the balance already set aside toward the goal today.
- Set Annual contribution, $ to the amount added to that balance every year.
- Set Assumed annual return, % to the long-run growth rate you expect the balance to earn.
- Read Years to reach $1,000,000 for the countdown those three figures imply.
- Raise the contribution or the return to see which one moves the countdown further.
Worked example — $50,000 saved, adding $20,000 a year at 7%
Set Current savings, $ to 50,000, Annual contribution, $ to 20,000, and Assumed annual return, % to 7. Dividing the contribution by the return gives 20,000 ÷ 0.07, close to 285,714. Add that to the 1,000,000 target and the sum is about 1,285,714; add it to current savings instead and the sum is about 335,714 — the first divided by the second is close to 3.8298.
Take the natural log of 3.8298, about 1.3428, and divide it by the natural log of 1.07, about 0.06766, and the result is Years to reach $1,000,000 of 19.8468234212 — close to nineteen years and ten months, starting from a $50,000 balance and adding $20,000 a year at a steady 7% return.
Questions
Why is the target fixed at exactly $1,000,000 instead of a personalized number?
Because a million dollars is a round, cultural milestone, not a number derived from what anyone actually spends. Retirement-target calculators usually multiply annual expenses by 25 to reach a personalized figure — for a household spending $40,000 a year that happens to land on exactly $1,000,000, but for one spending $70,000 the true target sits far higher. This sheet answers a narrower, more literal question: when does the balance cross one million, full stop.
How is this different from a FIRE or early-retirement calculator?
The underlying algebra is the same — both solve a compound-growth equation for time using a logarithm — but the target differs. A FIRE calculator derives its target from annual expenses times a withdrawal-rate multiple, so the number moves with spending; this sheet locks the target at $1,000,000 no matter what a saver actually spends, which suits tracking progress toward the milestone itself rather than toward a personalized retirement figure.
Why does the answer come out as a long decimal, like 19.8468234212 years?
The formula solves a continuous growth equation, so it returns whatever real number balances the equation exactly rather than a figure rounded to whole years. Multiply the decimal part by 12 to read it in months — 0.8468234212 years is close to ten months, so 19.8468234212 reads naturally as roughly nineteen years and ten months.
What actually shortens the years the most, the contribution or the return?
In the default scenario, doubling Annual contribution, $ from 20,000 to 40,000 cuts Years to reach $1,000,000 from 19.8468234212 to 13.7117641074 — a bigger swing than most realistic changes to Assumed annual return, % produce, because the contribution arrives on a fixed schedule every year while a higher assumed return is only ever an estimate of the future.
What if my current savings already exceed $1,000,000?
The ratio inside the logarithm drops below one once Current savings, $ passes the target, which makes the log negative and returns a negative years figure. Read a negative result as confirmation the milestone is already behind you, not as a countdown still running — the arithmetic does not stop or cap itself at zero.
Does this account for taxes, inflation, or investment fees along the way?
No. Assumed annual return, % is applied as one flat rate for the entire period, with no allowance for the fees a real account pays, the taxes due on eventual withdrawals, or the way inflation erodes what $1,000,000 will actually buy by the time the balance gets there. Enter a return already net of fees, and treat the years figure as nominal time, not inflation-adjusted purchasing power.
References
- Consumer Financial Protection Bureau — Planning for retirement
- SEC Investor.gov — Compound Interest Calculator
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.