Formula to Calculate Annuity Payment

The formula based on an ordinary annuity is calculated based on PV of an ordinary annuityPV Of An Ordinary AnnuityThe present value of the annuity is the current value of future cash flows adjusted to the time value of money considering all the relevant factors like discounting rate. Thus, it helps investors understand the money they will receive overtime in today’s dollar’s terms and make informed investment decisions.read more, effective interest rateEffective Interest RateEffective Interest Rate, also called Annual Equivalent Rate, is the actual rate of interest that a person pays or earns on a financial instrument by considering the compounding interest over a given period.read more, and several periods.

where,

  • PVA Ordinary = Present value of an ordinary annuityr = Effective interest raten = Number of periods

Mathematically, the equation for annuity due is represented as,

  • PVA Due = Present value of an annuity duer = Effective interest raten = number of periods

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Annuity Formula (wallstreetmojo.com)

How to Calculate Annuity Payment? (Step by Step)

Examples

Example #1

Let us take the example of David, who won a lottery worth $10,000,000. He has opted for an annuity payment at the end of each year for the next 20 years as a payout option. Determine the amount that David will be paid as annuity payment if the constant rate of interest in the market is 5%.

  • Firstly, determine the PV of the annuity and confirm that the payment will be made at the end of each period. It is denoted by PVA Ordinary. Next, determine the interest rate based on the current market return. Then, the effective rate of interest is computed by dividing the annualized interest rate by the number of periodic payments in a year, and it is denoted by r. r = Annualized interest rate / Number regular payments in a year Next, determine the number of periods by multiplying the number of periodic payments in a year and the number of years, and it is denoted by n. n = number of regular payments in a year * Number of years Finally, the annuity payment based on PV of an ordinary annuity is calculated based on PV of an ordinary annuity (step 1), effective interest rate (step 2), and some periods (step 3), as shown above. The calculation of annuity payment can also be derived by using the PV of an annuity due in the following steps:Step 1: Firstly, determine the PV of the annuity and confirm that the payment will be made at the beginning of each period. It is denoted by PVA Due.Step 2: Next, determine the interest rate based on the current market return. Then, the effective rate of interest is computed by dividing the annualized interest rate by the number of periodic payments in a year, and it is denoted by r. r = Annualized interest rate / Number regular payments in a yearStep 3: Next, determine the number of periods by multiplying the number of periodic payments in a year and the number of years, and it is denoted by n. n = number of regular payments in a year * Number of yearsStep 4: Finally, the annuity payment based on PV of an annuity due is calculated based on PV of an annuity due (step 1), effective interest rate (step 2), and several periods (step 3), as shown above.

The calculation of annuity payment can also be derived by using the PV of an annuity due in the following steps:Step 1: Firstly, determine the PV of the annuity and confirm that the payment will be made at the beginning of each period. It is denoted by PVA Due.Step 2: Next, determine the interest rate based on the current market return. Then, the effective rate of interest is computed by dividing the annualized interest rate by the number of periodic payments in a year, and it is denoted by r. r = Annualized interest rate / Number regular payments in a yearStep 3: Next, determine the number of periods by multiplying the number of periodic payments in a year and the number of years, and it is denoted by n. n = number of regular payments in a year * Number of yearsStep 4: Finally, the annuity payment based on PV of an annuity due is calculated based on PV of an annuity due (step 1), effective interest rate (step 2), and several periods (step 3), as shown above.

Given below is the data used for the calculation of annuity payments.

PVA Ordinary = $10,000,000 (since the annuity to be paid at the end of each year)

Therefore, the calculation of annuity payment can be done as follows –

  • Annuity = 5% * $10,000,000 / [1 – (1 + 5%)-20]

Calculation of Annuity Payment will be –

  • Annuity = $802,425.87 ~ $802,426

Therefore, David will pay annuity payments of $802,426 for the next 20 years in case of ordinary annuityOrdinary AnnuityAn ordinary annuity refers to recurring payments of equal value made at regular intervals for a fixed period. The frequency of these consecutive payments can be weekly, monthly, quarterly, half-yearly or yearly.read more.

Example #2

Let us take the above example of David and determine the annuity payment if paid at the beginning of each year with all other conditions the same.

We will use the same data as the above example for the calculation of Annuity payments.

  • Annuity = r * PVA Due / [{1 – (1 + r)-n} * (1 + r)]Annuity = 5% * $10,000,000 / [{1 – (1 + 5%)-20} * (1 + 5%)]

  • Annuity = $764,215.12 ~ $764,215

Therefore, David will pay annuity payments of $764,215 for the next 20 years in case of an annuity due.

Annuity Calculator

You can use the following Annuity CalculatorAnnuity CalculatorAnnuity calculator can be used to calculate the series of regular payments which are to be received in future either at the end of the period or at the beginning of the period. The one which is to be received at the beginning of the period is called an annuity due and the one which is received at the end of the period is known as ordinary period.read more.

Relevance and Uses

The annuity payment is one of the applications of the time value of moneyTime Value Of MoneyThe Time Value of Money (TVM) principle states that money received in the present is of higher worth than money received in the future because money received now can be invested and used to generate cash flows to the enterprise in the future in the form of interest or from future investment appreciation and reinvestment.read more, which is further indicated by the difference between annuity payments based on ordinary annuity and annuity due. The lower annuity payment for an annuity is that the money is received at the start of each period. It is believed that the funds will be invested in the market, and interest will be earned during that period.

The equation for annuity payment finds application in calculating income annuities, amortized loans, lottery pay-outs, structured settlements, and any other type of fixed periodic payments.

Annuity Formula Video

This article has been a guide to Annuity Formula. Here we learn how to calculate Annuity Payments for Ordinary and due annuity along with practical examples and a downloadable excel template. You can know more about financial analysis from the following articles –

  • Annuity vs. PerpetuityEffective Annual Rate FormulaFormulaFormulaThe present value of an annuity formula depicts the current value of the future annuity payments. Present Value of an Annuity=C×(1−〖(1+i)〗^(−n))/i, where C is the cash flow per period, i is the interest rate, and n is the frequency of payments.read more of Present Value of an Annuity Tax-Deferred AnnuityTax-Deferred AnnuityA tax-deferred annuity is an employee retirement benefit plan where both an employer and its employee contribute to the saving plan for long-term investment growth. It offers various benefits like age 50 plus catch up, lifetime catch up, taxes, and investment options. Tax-Deferred Annuity = A*[(1+i)n−1​]​ / i
  • read more