chrislowe2006
New Member
- Joined
- Feb 13, 2014
- Messages
- 8
Hello all,
Thanks in advanced for your assistance!
I am trying to create a formula for calculating defferal periods for annuities, based on a comparison taking an income straight away or deffering it X amount of years down the line to show if it is worth doing.
The initial and deferred income can be subject to a fixed escalation rate in % ranging from 0-10%. For the example below they are both done on 3%.
So the user will enter 6 Variables: //Variables used in example below//
- Age //56//
- Outset income //£100//
- Outset Escalation //3%//
- Deferred Income //£120//
- Deferred Escalation //3%//
- Deferred Period //5yrs//
<tbody>
</tbody>
My current issue is getting a formula that will leave the correct number of rows blank in the red section that relate to the number of years deffered, so the example shows 5 years.
Then after the relevant number of years the payments begin and it calculates the income using the starting income specified.
I bet it is really simple but I can't figure it out .
Thanks again,
Chris.
Thanks in advanced for your assistance!
I am trying to create a formula for calculating defferal periods for annuities, based on a comparison taking an income straight away or deffering it X amount of years down the line to show if it is worth doing.
The initial and deferred income can be subject to a fixed escalation rate in % ranging from 0-10%. For the example below they are both done on 3%.
So the user will enter 6 Variables: //Variables used in example below//
- Age //56//
- Outset income //£100//
- Outset Escalation //3%//
- Deferred Income //£120//
- Deferred Escalation //3%//
- Deferred Period //5yrs//
Age | Outset Income | Cumulative Outset | Deferred Income | Cumulative Deffered |
56 | 100 | 100 | 0 | 0 |
57 | 103 | 203 | 0 | 0 |
58 | 106.09 | 309.09 | 0 | 0 |
59 | 109.27 | 418.36 | 0 | 0 |
60 | 112.55 | 530.91 | 0 | 0 |
61 | 115.93 | 646.84 | 200 | 200 |
62 | 119.41 | 766.25 | 206 | 406 |
63 | 122.99 | 889.23 | 212.18 | 618.18 |
64 | 126.68 | 1015.91 | 218.55 | 836.73 |
65 | 130.48 | 1146.39 | 225.10 | 1061.83 |
66 | 134.39 | 1280.78 | 231.85 | 1293.68 |
<tbody>
</tbody>
My current issue is getting a formula that will leave the correct number of rows blank in the red section that relate to the number of years deffered, so the example shows 5 years.
Then after the relevant number of years the payments begin and it calculates the income using the starting income specified.
I bet it is really simple but I can't figure it out .
Thanks again,
Chris.