# Retirement Calculations

#### Hirtle22

##### New Member
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.

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).
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:

Code:
``=IF(AGE <= 65, INPUT_VAL, 0)``

Code:
``=IF(AGE > 65, OUTPUT_VAL, 0)``

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

Replies
6
Views
381
Replies
6
Views
362
Replies
2
Views
231
Replies
5
Views
591
Replies
1
Views
540

1,221,213
Messages
6,158,565
Members
451,498
Latest member
tyshanklin1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back