2.6 Calculating the Interest Rate for an Annuity
Learning Objectives
- Calculate the interest rate for an annuity
Formula & Symbol Hub
Symbols Used
- [latex]FV[/latex] = Future value or maturity value
- [latex]PV[/latex] = Present value of principal
- [latex]PMT[/latex] = Annuity payment amount
- [latex]I/Y[/latex] = Nominal interest rate
- [latex]P/Y[/latex] = Number of payments per year or payment frequency
- [latex]C/Y[/latex] = Number of compounds per year or compounding frequency
- [latex]n[/latex] or [latex]N[/latex] = Total number of annuity payments
Formulas Used
-
Formula 2.1 – Total Number of Payments (Annuity)
[latex]n=P/Y \times t[/latex]
-
Formula 2.2 – Future Value of Ordinary Annuity
[latex]FV=PMT \times \left[\frac{(1+i_2)^n-1}{i_2}\right][/latex]
-
Formula 2.3 – Future Value of Annuity Due
[latex]FV=PMT \times (1+i_2) \times \left[\frac{(1+i_2)^n-1}{i_2}\right][/latex]
-
Formula 2.4 – Present Value of Ordinary Annuity
[latex]PV=PMT \times \left[\frac{1-(1+i_2)^{-n}}{i_2}\right][/latex]
-
Formula 2.5 – Present Value of Annuity Due
[latex]PV=PMT \times (1+i_2) \times \left[\frac{1-(1+i_2)^{-n}}{i_2}\right][/latex]
Introduction
You must calculate the interest rate on an annuity in a variety of situations:
- To determine the interest rate being charged on any debt.
- To determine the interest rate that an investment is earning.
- To calculate the required interest rate for savings to reach a goal within a certain time period.
- To calculate the required interest rate needed for a series of payments to be sustained over a certain time period.
Using a Financial Calculator
In the future value and present value formulas for annuities, there is no way to algebraic isolate the periodic interest rate. Consequently, calculating the interest rate for an annuity cannot be found by using the formulas. However, a financial calculator can quickly find the required interest rate. You use the financial calculator in the same way as described previously, but the only difference is that the unknown quantity is I/Y (the nominal interest rate). You must still load the other six variables into the calculator, set the calculator to the correct payment setting, and apply the cash flow sign conventions carefully.
Using the TI BAII Plus Calculator to Find the Interest Rate for Annuities
- Set the calculator to the correct payment setting (END or BGN).
- Enter values for the known variables ([latex]PV[/latex], [latex]FV[/latex], [latex]PMT[/latex], [latex]I/Y[/latex], [latex]P/Y[/latex] and[latex]C/Y[/latex]), paying close attention to the cash flow sign convention for [latex]PV[/latex], [latex]PMT[/latex], and [latex]FV[/latex].
- After all of the known quantities are loaded into the calculator, press [latex]CPT[/latex] and then [latex]I/Y[/latex] to solve for the interest rate.
Notes
- Ensure that the calculator is set to the required payment setting. The interest rate will be different for END and BGN.
- Because the calculator is using a trial-and-error technique to calculate the interest rate, it may take your calculator a few seconds to compute the answer. If your screen goes blank and your calculator hesitates, this is normal.
- The values you enter for [latex]PV[/latex], [latex]FV[/latex], and [latex]PMT[/latex] must adhere to the cash flow sign convention.
Example 2.6.1
Smartchoice, a rent-to-own store, offers a Dell 10″ Mini Inspiron Netbook for a cash n’ carry price of [latex]\$399[/latex]. Alternatively, under its rent-to-own plan you could make [latex]\$59.88[/latex] monthly payments in advance and own the laptop after one year. What effective interest rate is being charged on the rent-to-own plan?
Solution
The timeline for the annuity appears below.
PMT Setting | BGN |
[latex]N[/latex] | [latex]12 \times 1=12[/latex] |
[latex]PV[/latex] | [latex]399[/latex] |
[latex]FV[/latex] | [latex]0[/latex] |
[latex]PMT[/latex] | [latex]-59.88[/latex] |
[latex]I/Y[/latex] | ? |
[latex]P/Y[/latex] | [latex]12[/latex] |
[latex]C/Y[/latex] | [latex]1[/latex] |
[latex]I/Y=337.98\%[/latex]
The effective interest rate being charged under the rent-to-own payment plan is [latex]337.9759\%[/latex].
Example 2.6.2
Cubonic Industries deposits [latex]\$30,000[/latex] at the end of every quarter to save up [latex]\$550,000[/latex] for a capital project in four years. To achieve its goal, what nominal interest rate compounded quarterly does Cubonic Industries require on its investment?
Solution
PMT Setting | END |
[latex]N[/latex] | [latex]4 \times 4=16[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]550,000[/latex] |
[latex]PMT[/latex] | [latex]-30,000[/latex] |
[latex]I/Y[/latex] | ? |
[latex]P/Y[/latex] | [latex]4[/latex] |
[latex]C/Y[/latex] | [latex]4[/latex] |
[latex]I/Y=7.15\%[/latex]
For Cubonic Industries to achieve its savings goal, the savings annuity must earn [latex]7.15\%[/latex] compounded quarterly.
Try It
1) Francisco just changed occupations. Unfortunately, he is not able to transfer his company pension with him to his new company. The administrators of the pension plan offer him the choice of a lump-sum payout of [latex]\$103,075[/latex] today or beginning-of-month payments of [latex]\$535[/latex] for the next [latex]25[/latex] years. What semi-annually compounded rate of return are the pension administrators using in their calculations?
Solution
PMT Setting | BGN |
[latex]N[/latex] | [latex]12 \times 25=300[/latex] |
[latex]PV[/latex] | [latex]103,075[/latex] |
[latex]FV[/latex] | [latex]0[/latex] |
[latex]PMT[/latex] | [latex]-535[/latex] |
[latex]I/Y[/latex] | ? |
[latex]P/Y[/latex] | [latex]12[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]I/Y=3.90\%[/latex]
Example 2.6.3
Amadeus has already saved [latex]\$5,000[/latex] in his RRSP today. Suppose he continues to make [latex]\$250[/latex] contributions at the beginning of each month for the next [latex]14[/latex] years. For him to achieve his goal of having [latex]\$100,000[/latex], what effective rate of return must his investment earn?
Solution
The timeline for RRSP contributions appears below.
PMT Setting | BGN |
[latex]N[/latex] | [latex]12 \times 14=168[/latex] |
[latex]PV[/latex] | [latex]-5,000[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]-250[/latex] |
[latex]I/Y[/latex] | ? |
[latex]P/Y[/latex] | [latex]12[/latex] |
[latex]C/Y[/latex] | [latex]1[/latex] |
[latex]I/Y=9.17\%[/latex]
The nominal rate of interest that Amadeus must earn on his investment is [latex]9.17\%[/latex] effective.
Example 2.6.4
Gemma is looking to purchase a new Nissan Pathfinder for [latex]\$54,904.64[/latex] including all fees and sales taxes. She can afford to pay no more than [latex]\$1,500[/latex] at the end of every month, and she wants to have the balance owing reduced to [latex]\$30,000[/latex] after two years, when she can pay off the vehicle with her trust fund. What is the maximum effective rate of interest she could be charged on the car loan to meet her goals?
Solution
The timeline for the car loan appears below.
PMT Setting | END |
[latex]N[/latex] | [latex]12 \times 2=24[/latex] |
[latex]PV[/latex] | [latex]54,904.64[/latex] |
[latex]FV[/latex] | [latex]-30,000[/latex] |
[latex]PMT[/latex] | [latex]-1,500[/latex] |
[latex]I/Y[/latex] | ? |
[latex]P/Y[/latex] | [latex]12[/latex] |
[latex]C/Y[/latex] | [latex]1[/latex] |
[latex]I/Y=13.53\%[/latex]
Gemma will be able to purchase the car if she can obtain a car loan that has an effective interest rate lower than [latex]13.53\%[/latex].
Try It
2) An investment today requires [latex]\$1,125.51[/latex] to purchase. In return, the investment pays out [latex]\$30[/latex] after every six months for the next [latex]20[/latex] years, along with an additional final lump-sum payout of [latex]\$1,000[/latex]. What semi-annually compounded interest rate is being earned on the investment?
Solution
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 20=40[/latex] |
[latex]PV[/latex] | [latex]-1,125.51[/latex] |
[latex]FV[/latex] | [latex]1,000[/latex] |
[latex]PMT[/latex] | [latex]30[/latex] |
[latex]I/Y[/latex] | ? |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]I/Y=5\%[/latex]
Try It
3) When you buy a car, a cash rebate is usually available if you finance the vehicle through your bank instead of the dealership. If you finance the vehicle through the dealership, you are not eligible for the cash rebate. Assume you can purchase a vehicle for [latex]\$24,960[/latex] and finance it for four years with month-end payments at [latex]0\%[/latex] through the dealership. Alternatively, you could get a loan from a bank and pay cash for your vehicle, which would entitle you to receive a [latex]\$3,500[/latex] cash rebate. What monthly compounded interest rate would the bank have to charge to arrive at the same monthly payment as the dealership alternative? What decision rule can you create from this calculation?
Solution
Payments for financing through the dealership at [latex]0\%[/latex] interest:
PMT Setting | END |
[latex]N[/latex] | [latex]12 \times 4=48[/latex] |
[latex]PV[/latex] | [latex]-24,960[/latex] |
[latex]FV[/latex] | [latex]0[/latex] |
[latex]PMT[/latex] | ? |
[latex]I/Y[/latex] | [latex]0[/latex] |
[latex]P/Y[/latex] | [latex]12[/latex] |
[latex]C/Y[/latex] | [latex]12[/latex] |
[latex]PMT=\$520[/latex]
Interest rate for the bank with monthly payments of [latex]\$520[/latex] and applying the [latex]\$3,500[/latex] rebate to the present value:
PMT Setting | END |
[latex]N[/latex] | [latex]12 \times 4=48[/latex] |
[latex]PV[/latex] | [latex]-21,460[/latex] |
[latex]FV[/latex] | [latex]0[/latex] |
[latex]PMT[/latex] | [latex]-520[/latex] |
[latex]I/Y[/latex] | ? |
[latex]P/Y[/latex] | [latex]12[/latex] |
[latex]C/Y[/latex] | [latex]12[/latex] |
[latex]I/Y=7.61\%[/latex]
Section 2.6 Exercises
- You purchase an annuity for [latex]\$500,000[/latex]. The annuity will pay you [latex]\$8,000[/latex] every quarter for [latex]21.5[/latex] years. What rate compounded quarterly does the annuity earn?
Solution
[latex]3.12\%[/latex]
- You invest [latex]\$300[/latex] at the beginning of every month for [latex]33.5[/latex] years. At the end of the [latex]33.5[/latex] years, you have saved [latex]\$750,000[/latex]. What rate compounded semi-annually did your investment earn?
Solution
[latex]9.04\%[/latex]
- You have the opportunity to make an investment of [latex]\$100,000[/latex] today and receive beginning of the month payments of [latex]\$1,200[/latex] for [latex]10[/latex] years. Calculate the rate compounded monthly on the investment.
Solution
[latex]7.90\%[/latex]
- Today, your RRSP has [latex]\$25,000[/latex]. Over the next [latex]8[/latex] years you plan to deposit [latex]\$6,250[/latex] every six months into the RRSP with the goal of having [latex]\$200,000[/latex] in the account. Calculate the rate compounded semi-annually the RRSP must earn for you to achieve your goal.
Solution
[latex]9.76\%[/latex]
- You have [latex]\$300,000[/latex] in your RIF. Over the next [latex]13[/latex] years and [latex]3[/latex] months, you receive beginning-of-quarter payments of [latex]\$4,975[/latex] from the RIF. At the end of the [latex]13[/latex] years and [latex]3[/latex] months, the balance in your RIF is [latex]\$150,000[/latex]. What rate compounded quarterly does the RIF earn?
Solution
[latex]3.77\%[/latex]
- Following his financial adviser’s recommendations, Sanchez starts monthly contributions of [latex]\$375[/latex] today to his RRSP. The plan is to have [latex]\$240,000[/latex] in his RRSP after [latex]20[/latex] years of monthly compounding. What nominal interest rate does the financial adviser think Sanchez’s RRSP will be able to realize?
Solution
[latex]8.61\%[/latex]
- Helen’s husband recently passed away. The life insurance company is offering her a lump-sum payout of [latex]\$250,000[/latex] today, or month-end payments of [latex]\$1,585[/latex] for [latex]20[/latex] years.
- What monthly compounded rate is the life insurance company using in its calculations?
- Helen thinks she can take the lump sum and invest it herself at [latex]4.75\%[/latex] effectively. How much will her monthly payment increase?
Solution
a. [latex]4.53\%[/latex]; b. [latex]\$16.89[/latex]
- Under a wrongful dismissal suit, a court awarded a former employee [latex]\$100,835.25[/latex] for end-of-month wages of [latex]\$4,500[/latex] for the past [latex]21[/latex] months. What effective interest rate is the court using in the judgment?
Solution
[latex]8\%[/latex]
- Jake’s Electronics wants to match a competitor’s advertised payment plan on an identical stereo system. If the system retails for [latex]\$1,011.35[/latex] including all sales taxes and Jake wants to advertise six equal end-of-month payments of [latex]\$174[/latex], what effective rate of interest does he need to charge?
Solution
[latex]11.56\%[/latex]
- The marketing manager for Gold’s Gym offers members a two-year membership for [latex]\$650[/latex] in advance or beginning-of-month payments of [latex]\$29[/latex]. What monthly compounded interest is the marketing manager using in his pricing?
Solution
[latex]7.25\%[/latex]
- A retail store wants to offer its clients different two-year ordinary payment plans on their product purchases. The marketing manager understands the importance of odd-number pricing in these plans, where [latex]\$499[/latex] is better than stating [latex]\$500[/latex]. On a typical [latex]\$5,000[/latex] purchase, the marketing manager wants to offer payments of [latex]\$229[/latex] monthly, [latex]\$699[/latex] quarterly, or [latex]\$1,399[/latex] semi-annually. The Competition Act of Canada requires full disclosure of the annual interest rate being charged on any plan. What interest rate must be published for each plan?
Solution
monthly plan: [latex]9.95\%[/latex], quarterly plan: [latex]10.62\%[/latex], semi-annual plan: [latex]9.54\%[/latex]
- On a [latex]\$3,500[/latex] purchase, a company is thinking of offering a year-long month-end payment plan that requires payments of [latex]\$299, \$319, \$334[/latex], or [latex]\$349[/latex].
- If the goal of the plan is to offer a competitive interest rate comparable to a bank credit card that averages [latex]18\%[/latex] effectively, which payment plan should be chosen?
- If the goal of the plan is to offer a competitive interest rate comparable to a department store credit card that averages [latex]28\%[/latex] effectively, which payment plan should be chosen?
Solution
[latex]\$299[/latex] payments: [latex]4.71\%, \$319[/latex] payments: [latex]18.24\%, \$334[/latex] payments: [latex]29.07\%, \$349[/latex] payments: [latex]40.51\%[/latex]; a. choose [latex]\$319[/latex] plan with [latex]18.24\%[/latex] effective; b. choose [latex]\$334[/latex] plan with [latex]29.07\%[/latex] effective
- Margarite’s goal is to save up [latex]\$100,000[/latex] after [latex]10[/latex] years of monthly contributions into an investment annuity starting today. Depending on the level of risk she chooses, her adviser tells her that under low-risk conditions she would need to contribute [latex]\$645.19[/latex], under medium-risk conditions her contribution needs to be [latex]\$523.32[/latex], and if she puts her money into high-risk investments she would need [latex]\$401.14[/latex] per month. Based on the adviser’s calculations, what are the effective interest rates on the low-, medium-, and high-risk investments?
Solution
low: [latex]5\%[/latex], medium: [latex]9\%[/latex], high: [latex]14\%[/latex]
Attribution
“2.6 Calculating the Interest Rate for an Annuity” from Financial Math – Math 1175 by Margaret Dancy is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.