A growing perpetuity is a stream of cash in flows that occur at regular intervals and grow at a constant rate forever. For this example, we are not allowing it to grow forever, unless the intention is to start withdrawing from the fund upon retirement which is assumed to be after age 65.
In a growing annuity, the start defrayal will be designated by a C and will have a growth rate of g with formula C x (1 + g) for the second payment, C x (1 + g)2 for the third payment, C x (1 + g)3 for the fourth payment, etc (Berk, 2007).
There are several components provided from this example. They are the total amount that you want to save by age 65 which is $2 million, how old you soon are on this birthday, which is 30 years of age, and every bills invested will generate a return of 5%.
The time period or tot of periods or payments to be make during your lifetime is 36. This can be arrived at by adding the number of years across the time line below: 1 + 4 + 5 + 5 + 5 + 5 + 5 + 5 +1 = 36. The last payment that is made on your 65th birthday will not earn any interest.
The missing data that must be found is the payment amount for the 36 payments that need to be made on an annual basis in order to reach the remnant of $2 million. The PMT function was used in Excel to suss out the amount of monthly payments. The PV and PMT input sections were left blank within the formula below since they are unknown. The amount that you must set aside each year is $20,868.91 to ensure that you reach the coating of $2...If you want to get a full essay, order it on our website: Orderessay
If you want to get a full essay, wisit our page: write my essay .
No comments:
Post a Comment