Retirement Calculations

[Hirtle22]

I am building a retirement calculator that will show clients approximately when their money will run out (whoel idea is to introduce them to investments like annuities). I cannot for the life of me figure out the formula to stop payments after a set amount of years. Here is the situation:

Client is 55 years old, plans on retiring at age 65. This means that for the next 10 years he/she will continue to add X amount of $ to their retirement savings account. I am also graphing this data, so I need to figure out how to show that X amount of $ being added every year for the next 10 years, but then stopping after that 10 year. I can then show how quickly their money will run out based on expenses and inflation. Any help is much appreciated, thanks.

 

[NeonRedSharpie]

Here's how I assume your data is laid out:

AGE	61	62	63	64	65	66	67	68	69
Input	10	10	10	10	10	0	0	0	0
Output	0	0	0	0	0	5	5	5	5
Total	10	20	30	40	50	45	40	35	30

<tbody>
</tbody>

So, in the INPUT row, it would be:

=IF(AGE <= 65, INPUT_VAL, 0)

Then, your output would be:

=IF(AGE > 65, OUTPUT_VAL, 0)

Your total is just the last total + input - output.