How To Calculate Annuity

photo src: www.wikihow.com

An annuity is a series of payments made at equal intervals. Examples of annuities are regular deposits to a savings account, monthly home mortgage payments, monthly insurance payments and pension payments. Annuities can be classified by the frequency of payment dates. The payments (deposits) may be made weekly, monthly, quarterly, yearly, or at any other regular interval of time.

An annuity which provides for payments for the remainder of a person's lifetime is a life annuity.

photo src: adiemus.info

Maps, Directions, and Place Reviews

Types

Annuities may be classified in several ways.

Timing of payments

Payments of an annuity-immediate are made at the end of payment periods, so that interest accrues between the issue of the annuity and the first payment. Payments of an annuity-due are made at the beginning of payment periods, so a payment is made immediately on issue.

Contingency of payments

Annuities that provide payments that will be paid over a period known in advance are annuities certain or guaranteed annuities. Annuities paid only under certain circumstances are contingent annuities. A common example is a life annuity, which is paid over the remaining lifetime of the annuitant. Certain and life annuities are guaranteed to be paid for a number of years and then become contingent on the annuitant being alive.

Variability of payments

• Fixed annuities - These are annuities with fixed payments. If provided by an insurance company, the company guarantees a fixed return on the initial investment. Fixed annuities are not regulated by the Securities and Exchange Commission.
• Variable annuities - Registered products that are regulated by the SEC in the United States of America. They allow direct investment into various funds that are specially created for Variable annuities. Typically, the insurance company guarantees a certain death benefit or lifetime withdrawal benefits.
• Equity-indexed annuities - Annuities with payments linked to an index. Typically, the minimum payment will be 0% and the maximum will be predetermined. The performance of an index determines whether the minimum, the maximum or something in between is credited to the customer.

Deferral of payments

An annuity which begins payments only after a period is a deferred annuity. An annuity which begins payments without a deferral period is an immediate annuity.

How To Calculate Annuity Video

Valuation

Valuation of an annuity entails calculation of the present value of the future annuity payments. The valuation of an annuity entails concepts such as time value of money, interest rate, and future value.

Annuity-certain

If the number of payments is known in advance, the annuity is an annuity certain or guaranteed annuity. Valuation of annuities certain may be calculated using formulas depending on the timing of payments.

Annuity-immediate

If the payments are made at the end of the time periods, so that interest is accumulated before the payment, the annuity is called an annuity-immediate, or ordinary annuity. Mortgage payments are annuity-immediate, interest is earned before being paid.

The present value of an annuity is the value of a stream of payments, discounted by the interest rate to account for the fact that payments are being made at various moments in the future. The present value is given in actuarial notation by:

${\displaystyle a_{{\overline {n}}|i}={\frac {1-\left(1+i\right)^{-n}}{i}},}$

where ${\displaystyle n}$ is the number of terms and ${\displaystyle i}$ is the per period interest rate. Present value is linear in the amount of payments, therefore the present value for payments, or rent ${\displaystyle R}$ is:

${\displaystyle PV(i,n,R)=R\times a_{{\overline {n}}|i}}$

In practice, often loans are stated per annum while interest is compounded and payments are made monthly. In this case, the interest ${\displaystyle I}$ is stated as a nominal interest rate, and ${\displaystyle i=I/12}$.

The future value of an annuity is the accumulated amount, including payments and interest, of a stream of payments made to an interest-bearing account. For an annuity-immediate, it is the value immediately after the n-th payment. The future value is given by:

${\displaystyle s_{{\overline {n}}|i}={\frac {(1+i)^{n}-1}{i}}}$

where ${\displaystyle n}$ is the number of terms and ${\displaystyle i}$ is the per period interest rate. Future value is linear in the amount of payments, therefore the future value for payments, or rent ${\displaystyle R}$ is:

${\displaystyle FV(i,n,R)=R\times s_{{\overline {n}}|i}}$

Example: The present value of a 5-year annuity with nominal annual interest rate 12% and monthly payments of $100 is:

${\displaystyle PV(0.12/12,5\times 12,\$100)=\$100\times a_{{\overline {60}}|0.01}=\$4,495.50}$

The rent is understood as either the amount paid at the end of each period in return for an amount PV borrowed at time zero, the principal of the loan, or the amount paid out by an interest-bearing account at the end of each period when the amount PV is invested at time zero, and the account becomes zero with the n-th withdrawal.

Future and present values are related as:

${\displaystyle s_{{\overline {n}}|i}=(1+i)^{n}\times a_{{\overline {n}}|i}}$

and

${\displaystyle {\frac {1}{a_{{\overline {n}}|i}}}-{\frac {1}{s_{{\overline {n}}|i}}}=i}$

Proof of annuity-immediate formula

To calculate present value, the k-th payment must be discounted to the present by dividing by the interest, compounded by k terms. Hence the contribution of the k-th payment R would be R/(1+i)^k. Just considering R to be one, then:

${\displaystyle {\begin{aligned}a_{{\overline {n}}|i}&=\sum _{k=1}^{n}{\frac {1}{(1+i)^{k}}}={\frac {1}{1+i}}\sum _{k=0}^{n-1}\left({\frac {1}{1+i}}\right)^{k}\\&={\frac {1}{1+i}}\left({\frac {1-(1+i)^{-n}}{1-(1+i)^{-1}}}\right)\quad \quad {\text{(Geom. series)}}\\&={\frac {1-(1+i)^{-n}}{1+i-1}}\\&={\frac {1-\left({\frac {1}{1+i}}\right)^{n}}{i}}\end{aligned}}}$

which is the desired result.

Similarly, we can prove the formula for the future value. The payment made at the end of the last year would accumulate no interest and the payment made at the end of the first year would accumulate interest for a total of (n-1) years. Therefore,

${\displaystyle s_{{\overline {n}}|i}=1+(1+i)+(1+i)^{2}+\cdots +(1+i)^{n-1}=(1+i)^{n}a_{{\overline {n}}|i}={\frac {(1+i)^{n}-1}{i}}}$

Annuity-due

An annuity-due is an annuity whose payments are made at the beginning of each period. Deposits in savings, rent or lease payments, and insurance premiums are examples of annuities due.

Each annuity payment is allowed to compound for one extra period. Thus, the present and future values of an annuity-due can be calculated through the formula:

${\displaystyle {\ddot {a}}_{{\overline {n|}}i}=(1+i)\times a_{{\overline {n|}}i}={\frac {1-\left(1+i\right)^{-n}}{d}}}$

and

${\displaystyle {\ddot {s}}_{{\overline {n|}}i}=(1+i)\times s_{{\overline {n|}}i}={\frac {(1+i)^{n}-1}{d}}}$

where ${\displaystyle n}$ are the number of terms, ${\displaystyle i}$ is the per term interest rate, and ${\displaystyle d}$ is the effective rate of discount given by ${\displaystyle d=i/(i+1)}$.

Future and present values for annuities due are related as:

${\displaystyle {\ddot {s}}_{{\overline {n}}|i}=(1+i)^{n}\times {\ddot {a}}_{{\overline {n}}|i}}$

and

${\displaystyle {\frac {1}{{\ddot {a}}_{{\overline {n}}|i}}}-{\frac {1}{{\ddot {s}}_{{\overline {n}}|i}}}=d}$

Example: The final value of a 7-year annuity-due with nominal annual interest rate 9% and monthly payments of $100:

${\displaystyle FV_{due}(0.09/12,7\times 12,\$100)=\$100\times {\ddot {s}}_{{\overline {84}}|0.0075}=\$11,730.01.}$

Note that in Excel, the PV and FV functions take on optional fifth argument which selects from annuity-immediate or annuity-due.

An annuity-due with n payments is the sum of one annuity payment now and an ordinary annuity with one payment less, and also equal, with a time shift, to an ordinary annuity. Thus we have:

Perpetuity

A perpetuity is an annuity for which the payments continue forever. Since:

${\displaystyle \lim _{n\,\rightarrow \,\infty }\,PV(i,n,R)\,=\,{\frac {R}{i}}}$

even a perpetuity has a finite present value when there is a non-zero discount rate. The formula for a perpetuity are:

${\displaystyle a_{{\overline {\infty }}|i}=1/i;\qquad {\ddot {a}}_{{\overline {\infty }}|i}=1/d.}$

where ${\displaystyle i}$ is the interest rate and ${\displaystyle d=i/(1+i)}$ is the effective discount rate.

Life annuities

Valuation of life annuities may be performed by calculating the actuarial present value of the future life contingent payments. Life tables are used to calculate the probability that the annuitant lives to each future payment period. Valuation of life annuities also depends on the timing of payments just as with annuities certain, however life annuities may not be calculated with similar formulas because actuarial present value accounts for the probability of death at each age.

photo src: www.scotty.com.au

Amortization calculations

If an annuity is for repaying a debt P with interest, the amount owed after n payments is:

${\displaystyle {\frac {R}{i}}-\left(1+i\right)^{n}\left({\frac {R}{i}}-P\right)}$

because the scheme is equivalent with borrowing the amount ${\displaystyle R/i}$ to create a perpetuity with coupon ${\displaystyle R}$, and putting ${\displaystyle R/i-P}$ of that borrowed amount in the bank to grow with interest ${\displaystyle i}$.

Also, this can be thought of as the present value of the remaining payments:

${\displaystyle R\left[{\frac {1}{i}}-{\frac {(i+1)^{n-N}}{i}}\right]=R\times a_{{\overline {N-n}}|i}}$

See also fixed rate mortgage.

photo src: www.youtube.com

Example calculations

Formula for Finding the Periodic payment(R), Given A:

R = A/(1+?(1-(1+((j/m) )?^(-(n-1))/(j/m))

Examples:

1. Find the periodic payment of an annuity due of $70000, payable annually for 3 years at 15% compounded annually.
   • R = 70000/(1+?(1-(1+((.15)/1) )?^(-(3-1))/((.15)/1))
   • R = 70000/2.625708885
   • R = $26659.46724
2. Find the periodic payment of an annuity due of $250700, payable quarterly for 8 years at 5% compounded quarterly.
   • R= 250700/(1+?(1-(1+((.05)/4) )?^(-(32-1))/((.05)/4))
   • R = 250700/26.5692901
   • R = $9435.71

Finding the Periodic Payment(R), Given S:

R = S\,/((?((1+(j/m) )?^(n+1)-1)/(j/m)-1)

Examples:

1. Find the periodic payment of an accumulated value of $55000, payable monthly for 3 years at 15% compounded monthly.
   • R=55000/((?((1+((.15)/12) )?^(36+1)-1)/((.15)/12)-1)
   • R = 55000/45.67944932
   • R = $1204.04
2. Find the periodic payment of an accumulated value of $1600000, payable annually for 3 years at 9% compounded annually.
   • R=1600000/((?((1+((.09)/1) )?^(3+1)-1)/((.09)/1)-1)
   • R = 1600000/3.573129
   • R = $447786.80

photo src: www.asepag.net

Legal regimes

• Annuities under American law
• Annuities under European law
• Annuities under Swiss law

Source of the article : Wikipedia