CalcTrace

Annuity Payout Calculator

The payout phase turns a balance into a regular income while the remainder keeps earning a return. Find the payment that lasts a set number of years, how long a chosen payment lasts, or the balance a target income needs, with or without a yearly increase.

Last updated .

Payout phase

Solve for

Optional. The payment steps up once every twelve months, for example to keep pace with prices. Leave at 0 for level payments.

Each payment is taken at the

The return is your own assumption and is applied once per payment period at the yearly rate divided by the number of payments a year.

Result

Payment

–

–Starting balance
–First payment
–Total paid out
–Return earned along the way

Where the payments come from

    The balance running down

    YearEach paymentPaid outReturnBalance left

    Paid out and return are the totals for each year. Figures are rounded to the nearest dollar. The same return is assumed in every period, with no fees or tax.

    Show the working

      The payout formula

      During the payout phase a balance is paid out in instalments while whatever remains goes on earning a return. For level payments taken at the end of each period, the balance and the payment are tied together by the present value of an annuity formula:

      B = PMT × (1 − (1 + i)−n) ÷ i

      Rearranged, it answers each of the three questions on this page:

      Payment: PMT = B × i ÷ (1 − (1 + i)−n)

      Number of payments: n = −ln(1 − B × i ÷ PMT) ÷ ln(1 + i)

      ln is the natural logarithm. If payments are taken at the start of each period, the first leaves at once and earns nothing, so the balance needed is (1 + i) times larger for the same payment. At a return of 0% the balance is simply divided up: PMT = B ÷ n.

      When the payment rises each year there is no compact formula for monthly or weekly payments, so the calculator discounts every payment individually to find the starting payment or the balance, and runs the balance down period by period to find how long it lasts.

      Worked examples

      By hand: $10,000 paid out over 3 yearly payments at 5%

      1. Annuity factor. 1.05−3 = 0.863838, and (1 − 0.863838) ÷ 0.05 = 2.723248.
      2. Payment. $10,000 ÷ 2.723248 = $3,672.09.
      3. Year 1. Return $10,000 × 0.05 = $500. Balance 10,000 + 500 − 3,672.09 = $6,827.91.
      4. Year 2. Return $341.40. Balance $3,497.22.
      5. Year 3. Return $174.86. Balance 3,497.22 + 174.86 − 3,672.09 = $0 once the fractions of a cent dropped along the way are counted.

      A $500,000 balance at 4% a year, paid monthly

      With i = 0.04 ÷ 12 and n = 240, the factor is 165.021858 and a 20-year payout is $500,000 ÷ 165.021858 = $3,029.90 a month. Payments total $727,176.40, of which $227,176.40 is return earned while the balance ran down. Taken at the start of each month, the payment is $3,019.84.

      Ask for a 2% increase each year and the first payment falls to $2,560.11, rising to $3,729.59 a month in year 20. The starting income is lower because later payments are larger.

      Fix the payment at $3,500 a month instead. The formula gives n = 194.31, so there are 194 full payments and a final one of $1,090.74 in month 195: the balance runs out after 16 years and 3 months. With 2% yearly increases the same starting payment lasts 165 full payments, with a final $2,175.87 in month 166.

      For the third question, a level $3,000 a month for 25 years needs a starting balance of $568,357.45, or $699,086.31 if the payment is to rise by 2% a year.

      How to read the result

      When the balance never runs out

      In the first month the $500,000 balance earns $500,000 × 0.04 ÷ 12 = $1,666.67. A level payment at or below that figure never touches the capital, and the number-of-payments formula has no answer because it asks for the logarithm of zero or a negative number. The calculator stops after 100 years and tells you the balance is still standing.

      The order of returns matters in practice

      The method assumes the same return in every period. Real returns vary, and a run of poor years early in a payout does more damage than the same years later, because payments are being taken from a reduced balance. A constant-rate calculation cannot show that; treat the term as an illustration at the rate entered, not as a date.

      Increases compound

      A 2% yearly rise looks modest, but in the example it shortens a $3,500 payout from 195 months to 166. If the purpose of the increase is to keep up with prices, the return entered should be a nominal one, including inflation.

      What is not included

      This is arithmetic on a balance, a return and a payment. It does not price an annuity product sold by a provider, which also depends on life expectancy, fees and guarantees, and it applies no country’s tax, pension or minimum-withdrawal rules.