Time-to-Goal Calculations

You have a target number—$2.5M, £2.2M, or CAD $3.2M. You have a timeline—20 years, 25 years, or flexible. Now the question is practical: given your current savings rate and expected investment returns, when will you reach your goal?

This is pure mathematics. A spreadsheet, financial calculator, or basic formulas will answer it. The key is understanding the inputs: current portfolio balance, monthly contribution, expected annual return, and years to goal. Plug in numbers. See the outcome. Adjust assumptions. Iterate. This is how you transform an aspirational target into a realistic or adjusted plan.

Key takeaways

• Future value calculations show whether your current savings rate and assumptions hit your goal on time
• The three variables you can control are: time (years to goal), savings amount (monthly contribution), or return assumptions (asset allocation choice)
• Small differences in return assumptions (6% vs. 7% annually) compound significantly over decades
• "Breakeven" calculations reveal the required return if you cannot increase savings
• Stress-testing assumptions (what if returns are 2% below forecast?) shows how fragile your plan is

The basic formula: Future Value

The future value formula accounts for three components:

1. Current balance growing at a rate of return over N years
2. Monthly contributions also growing at the same rate
3. The total reaching your target

The formula is:

FV = PV × (1 + r)^n + PMT × [((1 + r)^n - 1) / r]

Where:

• FV = Future Value (your target, e.g., $2.5M)
• PV = Present Value (your current portfolio, e.g., $100,000)
• r = Monthly return rate (annual return ÷ 12, e.g., 7% annual = 0.07 ÷ 12 = 0.00583 monthly)
• n = Number of months (years × 12)
• PMT = Monthly payment (e.g., $2,000)

This looks intimidating. Fortunately, you do not need to calculate it by hand. A spreadsheet (Excel, Google Sheets) has built-in functions. A financial calculator (even a smartphone app) can solve it. Most online calculators let you enter values and immediately see the outcome.

Scenario 1: Finding the monthly contribution

You know: Target ($2.5M), current balance ($50,000), timeline (20 years), expected return (7% annually).

You want: How much must I save monthly?

Use the PMT function in Excel: =PMT(rate, nper, pv, fv)

=PMT(0.07/12, 240, -50000, 2500000)

This returns approximately $6,120/month. Interpretation: if you currently have $50,000, expect 7% annual returns, and want to reach $2.5M in 20 years, you need to save $6,120/month.

Is $6,120 realistic for your household? If you earn $150,000 gross and take home $95,000 after tax, and your living expenses are $60,000, you have $35,000 annual discretionary income—or about $2,917/month. You cannot save $6,120/month. So either your target is too high, your timeline is too long, or your return assumptions are too low.

Scenario 2: Finding the timeline

You know: Target ($2.5M), current balance ($50,000), monthly contribution ($3,000), expected return (7% annually).

You want: How long will it take?

Use the NPER function: =NPER(rate, pmt, pv, fv)

=NPER(0.07/12, 3000, -50000, 2500000)

This returns approximately 327 months, or 27.25 years. Interpretation: if you save $3,000/month, earn 7% annually, and currently have $50,000, you'll reach $2.5M in about 27 years.

If you're 38 years old and want to retire at 60, that's 22 years—not 27. You have a shortfall. You could increase your contribution to $3,850/month, reduce your target to $2.1M, extend your retirement age to 65, or assume a higher return (which means a more aggressive asset allocation).

Scenario 3: Finding the required return

You know: Target ($2.5M), current balance ($50,000), monthly contribution ($3,000), timeline (22 years).

You want: What annual return do I need?

This requires a solver (trial-and-error or a spreadsheet solver tool). Set up the future-value formula as a goal: find the return rate that results in $2.5M after 22 years with $3,000/month contributions.

Using Excel's Goal Seek or a financial calculator, the answer is approximately 8.2% annually. Interpretation: to reach $2.5M in 22 years with $50,000 current balance and $3,000/month contributions, you'd need an 8.2% annual return.

Is that realistic? Historical US stock returns average about 10% nominally (7% real, after inflation). A balanced 70/30 portfolio (stocks/bonds) has averaged 7–8% historically. An 8.2% required return is in the ballpark—not impossible, but not certain. This forces a conversation: are you comfortable assuming 8.2% returns? Or should you increase contributions, extend the timeline, or lower the target?

Real-world example: Young couple

Sarah and Marcus are both 30. Their combined household income is $180,000 gross ($110,000 after tax). After housing ($2,000/month), childcare ($1,200/month), food ($1,000/month), utilities and insurance ($800/month), and other expenses ($1,500/month), they have $2,500/month disposable income.

They want to retire at 60 (30-year timeline). Their target retirement spending is $70,000/year (adjusted for inflation). Using the 25× rule: $70,000 × 25 = $1.75M.

Their current balance is $75,000 (Roth IRA and taxable brokerage combined).

Using a 7% annual return assumption (60/40 portfolio):

=PMT(0.07/12, 360, -75000, 1750000)
= $2,158/month

They need to save $2,158/month. They have $2,500 disposable income. Saving $2,158 leaves them $342/month for unexpected expenses, gifts, or splurges. It's tight but achievable.

Let's verify with timeline:

=NPER(0.07/12, 2158, -75000, 1750000)
= 359 months ≈ 30 years

Perfect. Saving $2,158/month for 30 years will reach $1.75M at 7% returns.

Now suppose the stock market crashes in year 25, and their 30-year expected return drops to 5% due to high valuations. What happens?

=NPER(0.05/12, 2158, -75000, 1750000)
= 412 months ≈ 34 years

Suddenly they reach $1.75M in 34 years, not 30. They'd retire at 64, not 60. This is sequence-of-returns risk baked into the math.

Sarah and Marcus now have options:

1. Increase contributions (if possible) to offset lower returns.
2. Extend their target timeline to 34 years (retirement at 64).
3. Reduce their target to $1.5M and retire at 60 with less annual spending.
4. Accept that some years will be above 7% returns, averaging out.

The calculation illuminates the trade-off. Without it, they'd be blindsided at year 25.

Stress-testing: What if returns are lower?

A practitioner's habit is to calculate assuming expected (historical average) returns, then stress-test against lower returns.

If the expected return is 7%, stress-test at:

• Conservative (5%): Represents below-historical but not catastrophic returns.
• Pessimistic (3%): Represents a very long and severe bear market or a very conservative portfolio.

Using Sarah and Marcus's scenario at 5%:

=PMT(0.05/12, 360, -75000, 1750000)
= $2,476/month

At 5% returns, they'd need to save $2,476/month to reach $1.75M in 30 years. That's above their $2,500 disposable income and leaves almost no margin.

This tells them: the plan is fragile. If returns disappoint, they'll either need to work longer, save more, or accept a lower retirement number. A more resilient plan might be:

• Target $1.5M instead (retire on $60,000/year, not $70,000).
• Plan to work until 62, not 60 (32-year timeline).
• Commit to saving $2,300/month, not $2,158, to build a margin of safety.

Comparing timelines for multiple goals

Couples with competing goals (house down payment, retirement, education) can use these calculations to compare timelines and prioritize.

Suppose a couple has two goals:

1. House down payment: $120,000 in 5 years (current savings $20,000, expecting 4% return in bonds)
2. Retirement: $1.8M in 25 years (current savings $50,000, expecting 7% return in stocks)

House goal:

=PMT(0.04/12, 60, -20000, 120000)
= $1,498/month

Retirement goal:

=PMT(0.07/12, 300, -50000, 1800000)
= $2,821/month

Combined, they need $1,498 + $2,821 = $4,319/month. If their disposable income is $4,000/month, they can't do both at full intensity. They might split: $2,000/month to house (extending to 7 years), $2,000/month to retirement (extending to 27 years). Or they prioritize: $3,500/month to retirement (15 years earlier is valuable), $500/month to house (slower progress).

The math clarifies the constraint.

Annual vs. monthly contributions

Most of the above examples use monthly contributions. If you're self-employed or receive annual bonuses, use annual contributions instead. The formulas are the same; adjust the periods:

=PMT(0.07, 30, -75000, 1750000)

This calculates annual contributions needed over 30 years. The result is approximately $25,900/year, compared to $2,158/month ($25,896/year). The slight difference is due to compounding frequency, but they're essentially the same.

Using online calculators and spreadsheets

Rather than memorizing formulas, use tools:

• Google Sheets: Built-in PMT, NPER, RATE, FV functions. Free and simple.
• Excel: Same functions, more powerful.
• Investor.gov: SEC-provided calculator; simple and clear.
• Bankrate or NerdWallet: Free online calculators; good for quick estimates.
• Personal Capital or Vanguard: Dedicated retirement calculators; more detailed.

Build a simple spreadsheet with columns for:

• Current balance
• Monthly contribution
• Expected annual return
• Years to goal
• Target future value
• Outcome (hit or miss)

Adjust the contribution or timeline until you hit your target.

The disciplinary power of mathematics

Calculations do not have emotions. They show you plainly whether your plan is achievable, fragile, or impossible. Many people avoid these calculations because they fear the answer. But once you know the truth—whether you need to save more, work longer, or adjust expectations—you can make deliberate choices.

Ignorance is not bliss; it's risk. Knowing you need to save $2,500/month instead of your current $1,500/month is uncomfortable but actionable. You can explore: increase income, reduce expenses, or adjust the goal. Without the knowledge, you drift, hoping the math works out, and find yourself underfunded at retirement.

Diagram

Related concepts

• Quantifying the Target Number
• Financial Independence Goal
• Required Return vs Realistic Return

Next

Once you've calculated your required monthly savings and timeline, you'll face a critical question: is the required return realistic? If your math says you need 10% annual returns to hit your goal, but historical balanced portfolios earn 6–7%, you have a problem to address.