How to Calculate the Future Value of Geometric Annual Annuity?

  • Context: MHB 
  • Thread starter Thread starter waptrick
  • Start date Start date
  • Tags Tags
    Annuity Geometric
Click For Summary

Discussion Overview

The discussion revolves around calculating the future value of a geometric annual annuity over a period of 45 years, with varying growth and interest rates. Participants explore the application of formulas and methods to address the complexities introduced by these changing rates.

Discussion Character

  • Technical explanation
  • Mathematical reasoning
  • Debate/contested

Main Points Raised

  • One participant outlines the parameters of the annuity, including payment amounts, growth rates, and interest rates for different periods.
  • Another participant shares their calculation using the geometric annuity formula, arriving at a specific future value for the first 20 payments.
  • Concerns are raised about the differing interest and growth rates, complicating the calculations.
  • Some participants propose using difference equations to derive future values and discuss the implications of compounding versus simple interest.
  • There is a discussion on how to calculate the value of specific payments at different points in the annuity timeline, with various formulas suggested.
  • Participants explore the future value of payments received during specific intervals and how to account for changes in growth rates and interest rates.
  • Discrepancies in calculations are noted, with participants discussing rounding practices and the impact on final results.
  • Clarifications are made regarding the application of growth rates to determine future payments, particularly when transitioning between different growth periods.

Areas of Agreement / Disagreement

Participants generally agree on the use of the geometric annuity formula and the need to account for changing rates, but there are differing interpretations and calculations regarding the future values, leading to unresolved discrepancies in some cases.

Contextual Notes

Participants express uncertainty about the correct application of formulas due to the complexity of changing growth and interest rates, and there are unresolved mathematical steps in some calculations.

Who May Find This Useful

This discussion may be useful for individuals interested in financial mathematics, particularly those dealing with annuities, growth rates, and interest calculations in varying contexts.

  • #31
Since I botched part of one of the questions, I am going to amass everything into one post as a follow-up. The questions asked are as follows:

A geometric annual annuity runs for a period of 45 years which starts now.

  • The first payment at the end of the first year from now amounts to R2 000.
  • The growth rate of the annual payments equals 7% per year during the first 30 years (of the period of 45 years).
  • The growth rate of the annual payments equals 11% per year during the last 15 years (of the period of 45 years).
  • The interest rate during the first 20 years (of the period of 45 years) amounts to 10% per annum.
  • The interest rate during the last 25 years (of the period of 45 years) is equal to 14% per annum.
a) Calculate the future value of the first 20 annual payments (of the total period of 45 years) at the end of the period, 45 years from now.

b) What would the value of the payment that occurs at the end of the 23rd year be?

c) Find the future value of the 10 annual payments that are received from the end of Year 21 until the end of Year 30 at the end of the period of 45 years?

d) Find the future value of the last 15 annual payments at the end of the period of 45 years.

In post #5, I derived the following formulas:

$$P_{n}=P_1(1+g)^{n-1}\tag{1}$$

$$F_{n}=\frac{P_1}{i-g}\left((1+i)^{n}-(1+g)^{n}\right)\tag{2}$$

a) For the first 20 payments, we have the following data:

$$P_1=2000,\,i=0.10,\,g=0.07,\,n=20$$

Hence, using (2), we find:

$$F_{20}=\frac{2000}{0.03}\left(1.1^{20}-1.07^{20}\right)\approx190521.03$$

And then applying the interest rate of 14% compounded annually for the remaining 25 years, we have:

$$F_{45}=F_{20}(1.14)^{25}\approx5,041,551.52$$

b) For the first 23 years, we have:

$$P_1=2000,\,g=0.07,\,n=23$$

And so, using (1), we get:

$$P_{23}=2000\cdot1.07^{22}approx8860.80$$

c) From the end of year 21 until the end of year 30, we have the following data:

$$P_21=2000\cdot1.07^{20},\,i=0.14,\,g=0.07,\,n=10$$

And so, using (2), we find:

$$F_{10}=\frac{2000(1.07)^{20}}{0.07}\left(1.14^{10}-1.07^{10}\right)$$

And then the 15 years of annually compounded interest at 14% gives:

$$A=F_{10}\cdot1.14^{15}\approx1,373,241.72$$

d) For the last 15 annual payments at the end of the period of 45 years, we have:

$$P_{31}=2000\cdot1.07^{29}\cdot1.11,\,i=0.14,\,g=0.11,\,n=15$$

And so, using (2) we have:

$$A=\frac{2000\cdot1.07^{29}\cdot1.11}{0.03}\left(1.14^{15}-1.11^{15}\right)\approx1,238,932.13$$
 

Similar threads

  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 2 ·
Replies
2
Views
9K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
Replies
1
Views
2K
  • · Replies 5 ·
Replies
5
Views
5K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 9 ·
Replies
9
Views
3K