Example 22 - Annuity's Rate of Return
This example applies to our online demo Time Value of Money Calculator. The C-Value! program for Windows works in a similar way and has a few more features. Note, our online demo TVM calculator is limited to calculations using interest rates between 4.0% and 5.99%
Note:This topic has not been proofed and images need to be added. However, we believe that the steps are complete and accurate.
Calculating the rate of return on an annuity.
- Click the [New] button to clear any previous entries.
- Set "Rounding" to "Ignore" by either:
- clicking on the "Rounding" button on the toolbar;
- clicking on the {Compute} menu choice and select {Rounding...};
- When evaluating an annuity (or any investment) one will usually want to know the rate of return. Generally, the annuity with the higher rate of return, assuming everything else being equal, is preferable over the annuity with the lower rate of return. This example will show you how to evaluate one annuity. The point, of course, is to use this technique to evaluate two or more annuities and then compare the results. Is annuity A generating a high rate of return with a single payment amount or annuity "B" with a higher initial payment amount and a lower payment amount paid to the survivor.
- This example assumes that the annuity has an up front cost of $1,500,000. That there will be a monthly withdrawal of $8,775 for 20 years and then the withdrawal will be reduced to 65% of the initial withdrawal amount (due to the death of one spouse) and payable for another 10 years.
- 1) Open the C-Value! Setup Window. Press either [F6] or select {Settings}{Compute Setup} from the menu.
- A) For the "Compute Method" select the "Normal" option.
- B) Set the "Year Length" to 360.
- C) Click on the [OK] button to close the Window.
- 2) Set compounding to "Daily".
- 3) Enter "Unknown" for the "Nominal Annual Rate".
- 4) Create the first event as a "Deposit". We use the Deposit event here because we are assuming you will be buying the annuity and thus depositing funds for future withdrawal. See event names and creating event names using the events setup dialog window for more details.
- A) Set the "Date" to November 1, 2004. (11/01/04)
- B) For the "Amount", enter $1,500,000.00. (This is the cost of the annuity, or the amount invested.)
- C) Enter 1 for the "# Periods".
- 5) Create the 2nd event. It will be a "Withdrawal".
- A) Enter the "Date" as December 1, 2004
- B) Enter the "Amount" as $8,775.
- C) Enter 240 for "# Periods" (20 years of monthly withdrawals)
- D) Select "Monthly" for "Frequency". Then "End Date" will be November 1, 2024. That is, the last withdrawal for this series will be on this date.
- 6) Create the 3rd event. It will also be a "Withdrawal". (Here's where we assume the withdrawal will be reduced.)
- A) Enter the "Date" as December 1, 2024
- B) Enter the "Amount" as $5,703.75.
- C) Enter 120 for "# Periods" (10 years of monthly withdrawals)
- D) Select "Monthly" for "Frequency". Then "End Date" will be November 1, 2034.
- 7) Click on [Calculate] button. The "Annual Rate" is 5.093%
- A) click on the [>>] button to the right of the Annual Rate. The effective rate is 5.225% is considered by many to be the annualized rate of return This value is the result that Excel calculates as the XIRR.
Back to the online Time Value of Money Calculator.