Finance & Money
Retirement Income Payoff Calculator
Stress-test desired retirement spending against pension income, portfolio depletion, inflation, fees, and a selected planning horizon.
Asset depletion safety zone
Retirement balance path, zero-capital boundary, and horizon-safe spending rail
The chart marks whether the balance crosses zero and compares desired spending with the solved horizon-safe level.
Live decision table
Retirement asset longevity ledger
Inspect spending, pension offset, portfolio withdrawal, return, and balance by year.
| Year | Monthly spending | Pension offset | Portfolio withdrawal | Investment return | Ending balance |
|---|
Cash-flow schedule
Annual and monthly cash-flow schedule
How to use
Model spending before testing longevity
- Enter total desired monthly spending.
- Separate pension from portfolio assets.
- Include annual fees.
- Use a horizon beyond median life expectancy.
Calculation logic
Depletion is driven by net withdrawals, not total spending
Only spending above pension income draws on the portfolio. Inflation increases that gap over time.
The horizon-safe result solves spending, rather than applying a fixed rule of thumb.
Calculation method
Simulate inflation-linked net portfolio withdrawals until depletion
Pension income offsets spending before the portfolio withdrawal. A second solver finds the starting spending level that exactly uses assets over the horizon.
Detailed calculation process and general formulas
Need_m=max[S_m-P,0]S_m=S_0(1+π)^(m/12)B_m=B_(m-1)(1+r-f)-Need_mM_deplete=min{m:B_m≤0}S_safe solves B_N=0Symbols, meanings, and units
- S_m
- monthly spending needcurrency/month
- P
- monthly pension incomecurrency/month
- B_m
- portfolio balancecurrency
- r
- monthly returndecimal/month
- f
- monthly fee ratedecimal/month
Decision checks
Stress the result before acting
- Lower early returns.
- Higher inflation and fees.
- Pension start-date changes.
- Irregular healthcare costs.
Longevity anatomy
What moves the depletion date
The model isolates spending, pension offset, net return, and inflation.
Portfolio need
—First-month spending not covered by pension.
Depletion time
—First modeled month the balance reaches zero.
Safe spending
—Starting total spending sustained through the horizon.
Decision takeaway: A small monthly spending adjustment can materially change asset longevity.
Practical applications
Decisions this calculator is designed to support
Early retirement bridge
Pension income is modest while spending begins immediately.
What the result clarifies: The depletion zone shows how long investments carry the gap.
Fee-sensitive portfolio
A retiree compares high and low portfolio costs.
What the result clarifies: Annual fees compound against longevity.
Worked example
Current-input substitution and reconciliation
Important note
Actual retirement outcomes depend on return sequence, taxes, account order, benefit timing, longevity, fees, and irregular spending.
Retirement Income Payoff Calculator FAQ
Does depletion mean bankruptcy?
It means the modeled investment balance reaches zero; other income or assets may remain.
Can safe spending be below pension?
The solver never requires a negative portfolio withdrawal.
Are returns smooth?
Yes, so separate sequence-risk stress testing is essential.