Alright you math nerds. I've spent time making fun of you, now I need your help. Let's do this.
I need a way to estimate my future pension. Preferably some sort of spreadsheet I can use just to make it easier on me. But I'll take what I can get. The details of how the pension works:
Each quarter (so 4 times a year, look I am good at math!) an amount of money figured from the below chart is deposited into my pension account. Obviously the main variables are my actual age + how long I've been working for this employer, and what my salary is (to determine the pay credit). In the meantime, the money in the account is growing. Once each quarter, before the new $$ is deposited, a 4.64% interest rate is applied to the old account balance (Edit: It's a 4.64% annual growth rate, not every quarter) So if the account balance was $100, after the next quarter the account balance would be $104.84. Then the new $$ is added.
Age + Years at Job Pay Credit
Less than 40 1.5%
40 – 49 2.0%
50 – 59 2.5%
60 – 69 3.0%
70 – 79 4.0%
80 – 89 5.0%
90 or more 6.5%
I want a way I can not only enter in my current numbers, but also estimate future growth. So obviously as I age plus spend more time at this job, my Pay Credit will go up. At the same time I expect regular increases in salary (3%-5% a year), so the actual $$ amount of each pay credit will rise along with the percentage of my salary.
If anyone decides they want to help, but needs more info, feel free to ask!
Edited to clarify that 4.64% is the Annual rate of account growth.