Advertisement

Annuity payout calculator

Find a fixed-term annuity payout or the number of payments an entered payout can support.

Calculator

Opening balance
$10,000.00
Closing balance
$0.00
First periodic cash flow
$105.52
Term (years)
10.0000
Number of payments
120.0000
Nominal annual return
5.00%
Effective annual return
5.00%
Return per payment period
0.41%
Total cash flows
$12,662.82
Net investment growth
$2,662.82
Closing balance in starting purchasing power
$0.00
Model end date
2036-10-31
Cash flow schedule
PeriodModel dateCash flowInterestClosing balance
12.002027-11-011,266.28471.249,204.95
24.002028-10-311,266.28431.488,370.16
36.002029-10-311,266.28389.747,493.62
48.002030-11-011,266.28345.926,573.25
60.002031-11-011,266.28299.905,606.87
72.002032-10-311,266.28251.584,592.17
84.002033-10-311,266.28200.853,526.73
96.002034-11-011,266.28147.572,408.02
108.002035-11-011,266.2891.641,233.38
120.002036-10-311,266.2832.910.00

Advertisement

How this calculator works

The opening fund earns the assumed return while regular withdrawals reduce it. The final balance goal acts as a reserve. The nominal return is converted to the selected payment interval before valuing cash flows. The first cash flow is the entered amount; later cash flows grow by the equivalent periodic growth rate. Choose beginning or end timing and yearly summaries or individual payment rows. Enter a whole number of payment periods. Time solving finds the first payment period reaching the goal, adjusting the last cash flow to finish there; this mode supports non-negative returns and cash flow growth up to a 100-year horizon. Rate solving searches nominal annual returns from -99% to 200%. Dates use a 365.25-day model year and are illustrative rather than bank settlement dates. This is a finite fund calculation. An insurer lifetime annuity also depends on mortality, guarantees and expenses; these outputs are not an insurer quote.

Formula

Let j be the nominal annual return, m the compounding count and q payments per year. i = (1 + j/m)^(m/q) - 1, or exp(j/q) - 1 for continuous compounding. g = (1 + annual cash flow growth)^(1/q) - 1. For n payments, A = ((1+i)^n - (1+g)^n)/(i-g), with A = n(1+i)^(n-1) when i=g. Multiply A by (1+i) for beginning payments. Closing balance = opening balance x (1+i)^n + signed first payment x A. For withdrawals the signed cash flow is negative.

Worked example

$1,000 with zero return supports ten year-end withdrawals of $100 and leaves no reserve. A $210 fund earning 10% annually pays $121 at each of two year ends: $210 x 1.1 - $121 = $110, then $110 x 1.1 - $121 = $0.

Advertisement

Frequently asked questions

Is this a guaranteed lifetime income quote?

No. It models a fixed fund and assumed returns over a stated horizon. Lifetime insurance payments also use mortality and contract terms.

What if withdrawals never exhaust the fund?

A time-solving request is rejected if the reserve is not reached within 100 years. Choose a higher withdrawal or use final-balance mode to inspect a specific horizon.

Do withdrawals rise with inflation?

Only if you enter the corresponding annual cash flow growth. The inflation field itself adjusts purchasing power and does not change nominal withdrawals.

Sources

Advertisement