Key Post Excel spreadsheet to project size of pension fund on retirement.

I

interested21

Registered User
Messages
85
Brendan Burgess said:
Do you have an Excel spreadsheet for this into which people could input their own figures?
Click to expand...
Sure - it's a bit rough and ready but it can be accessed here. Just make a copy and edit with your own figures. Assumptions and viz are in the first tab and the raw numbers are in the second tab



Edit: Attaching an Excel version for anyone who prefers that.
 

Attachments

  • Pension.xlsx
    10 KB · Views: 277
Last edited by a moderator:
Hi interested

That is great.

So, it starts with a pension fund of €70k at age 30

The default growth seems high. 4% would be a better estimate.

But even with that, it shows that someone contributing the maximum is likely to blow their SFT .

But at 55, they could reduce their contribution to 7% and it would still exceed the SFT.

Brendan
 
Hi Brenden how does one start with €70k at age 30, is that a €70k pot built up by age 30.

Also the File doesn't allow for a max salary input, in my company we have salary bands once you reach that your salary doesn't go up more, that will be well reached in next 7 years a long time before retirement age.
 
One small thing to note about the age related tax relief limits is that they kick in in the year in which you reach the relevant age. So, even if you turn 55 on December 31st 2022 you are entitled to full tax relief on 35% of your income for the full year 2022.

Tax relief for pension contributions

This page outlines the tax relief for pension contributions
www.revenue.ie
 
Let's be clear about what this spreadsheet is.

It's a projection about what the size of the pension fund will be in 20 or 30 years.

There are many assumptions about growth in salary, continuation of tax relief and investment returns.

You should never add a more precise measure to a less precise measure - so don't worry about "one small thing" in such projections.

Brendan
 
Brendan Burgess said:
You should never add a more precise measure to a less precise measure - so don't worry about "one small thing" in such projections.
Click to expand...
Fully agree.

Investment returns over a 40-year horizon are subject to huge uncertainty and you won't know if you are at risk of hitting SFT realistically into your 50s, and the SFT might change too.

The best anyone can do at any age is maximise tax-relieved contributions and take full advantage of employer matching.
 
I'm not sure that an average of 6 months of an additional 5% of income compounded over decades would be negligible?

But moderators delete this and my other post if they are off topic.
 
ClubMan said:
But moderators delete this and my other post if they are off topic.
Click to expand...

Not off topic at all.

It's very instructive. A lot of people spend ages working out detailed calculations about long-term forecasts, so it's worth pointing out that it is incorrect to do so.

Brendan
 
You must log in or register to reply here.
Menu
Log in
Register