Jump to content
DOSBODS

  • Welcome to DOSBODS

     

    DOSBODS is free of any advertising.

    Ads are annoying, and - increasingly - advertising companies limit free speech online. DOSBODS Forums are completely free to use. Please create a free account to be able to access all the features of the DOSBODS community. It only takes 20 seconds!

     

IGNORED

The Big Pension Thread

spygirl

By spygirl
in Property Prices & Economy

 Share

Recommended Posts

spygirl

spygirl

Posted
Posted

No specific point, just came out of a @One percent post about BBC pension deficit.

They are in shit.

Anyhow, with the get out that Im not an actuary ...

https://www.pensions-expert.com/Law-Regulation/What-does-High-Court-ruling-mean-for-the-BBC-and-other-DB-pension-schemes?ct=true

In evidence given to the High Court, Leigh Tavaziva, chief operating officer of the BBC, explained that the broadcaster was paying a contribution rate of 42.3 per cent of the pensionable salaries of active members, which is almost three times what the contribution rate was in 2010.

By contrast, members of the BBC’s defined contribution (DC) scheme who joined after 2010 are receiving an employer contribution of seven to eight percent.

DB employees accounted for less than 40 per cent of the workforce, but accounted for over 80 per cent of the pensions spending, according to the judgement.

A stark reminder of how the young are being screwed by the old. And how the public sector are fucking over the private.~40% is about the a DB pension will cost an employee.

For the likes of fire n police, its about double. For a woman copper you are talking about 100% of salary.

Ive not problem wit DB pension - as long as they are funded. They are not.

Dont work for a company that has moved from DB - > DC.

Any extra effort or money will be eaten by the pension fund.

 

Picked this up -

https://www.pensionsage.com/pa/BLOG-How-many-presenters-does-it-take-to-plug-theBBCs-pension-deficit.php

Nonetheless, both the public and the pensions industry share a similar view when it comes to the gender pay gap. While the spotlight has been shone on the BBC's male and female stars' largely differing salaries, their pensions gender pay gap is likely to be vast as well. We’ll have to wait a few decades to see if these male and female stars enjoy vastly different retirements though!

What they are hinting at is that women pension cost *FAR* more than blokes - abut 30%.

And at 40% of salary a pension is a huge extra for wimmin.

The BBC DB lets both men n women retire at 60. Thats nuts.

All that the idiots needed to do was sync the retirement age to   to SRA.

They morons didnt.

 

  • Agree 1
  • Vomit 1
Link to comment
Share on other sites
spygirl

spygirl

Posted
  • Author
Posted

https://www.pensions-expert.com/Defined-Contribution/The-rise-of-Generation-DC

Are Generation DC - the first generation of savers to retire without a defined benefit (DB) underpin - already coming through?

Generation DC is already a reality, says AJ Bell’s Laith Khalaf. The head of investment analysis at AJ Bell said: “I think Generation DC are already coming through, seeing as Group Personal Pensions developed at the beginning of the 1990s, and before that there were occupational DC schemes in play.

Khalaf adds: “Average DC pots at the moment are looking somewhere in the region of around £30,000 to £40,000 at retirement, but clearly there will be a wide range of dispersion within that data. That’s not a very large hill of beans and certainly not enough to see someone through a comfortable retirement. It also means more people relying on the state pension, which may well be altered by politicians struggling to fill the fiscal gap created by the ageing demographics of the UK.”

Crappy average - mean or median.

Lets assume mean.

UK new state pension is basically designed on a couple having a ~150k fund each.

Thatll give them 10k each NSP + ~7k/y each private pension - 34k, which is OK for comfortable pension.

Those averages point to the lifecos fucking people over with vast projection for a WP pension of £50/m

If you start a pension at, say, 20, you really need to be putting 20% of salary in a year.

A good employee will contrib match up to 10%.

A crap company will match to 5%.

Dont work for a company that doesnt match to 10%. They are taking the piss.

And yo need to plan on 40y contributions.

This is why the Fat Shazzas on TCs are fucked.

 

 

  • Informative 2
  • Cheers 1
Link to comment
Share on other sites
spygirl

spygirl

Posted
  • Author
Posted

We had a post on this fucktard -

https://www.pensions-expert.com/Law-Regulation/TPR-prosecutes-owner-of-Norton-Motorcycles

The Pensions Regulator (TPR) has successfully prosecuted Stuart Garner for illegally investing nearly £11 million from pension schemes under his control into his own business.

Garner was the sole trustee of three pension schemes, Donington MC, Dominator 2012 and Commando 2012. He unlawfully transferred nearly all the £11.5 million of member funds into his company, Norton Motorcycles.

The three schemes invested in Norton Motorcycles in return for preference shares. The schemes were marketed to members as an investment in Norton Motorcycles.

Between April 2012 and December 2013, 255 members transferred into the schemes from other pension arrangements. Members were forbidden to withdraw any funds for 24 months from the date of transfer, and they were charged if they withdrew funds for the first five years.

This is fraud.

Fraud esp with pension need to attract a jail for 1y for each 50k.

Judicary needs to pull its finger out and gets its sentencing guidelines updated.

https://www.theguardian.com/uk-news/2023/jul/24/mps-launch-inquiry-into-prosecution-of-norton-motorcycles-pension

The parliamentary inquiry follows years of reporting on the scandal by the Guardian, which exposed how senior government ministers feted a businessman called Stuart Garner, who acquired Norton with £1m borrowed directly from a pension fraud, received a further £10m that was raised via a pension liberation scam a decade ago and then illegally invested that money into his own business.

https://www.motorcyclenews.com/news/stuart-garner-sentence/

Heres the cunt

https://www.greatbritishlife.co.uk/things-to-do/whats-on/22632296.home-donington-hall-stuart-garner-norton-motorcycles-uk-ltd/

15833656.jpg?type=mds-article-642

 

 

  • Agree 1
  • Informative 2
  • Vomit 1
Link to comment
Share on other sites
Guest

Guest

Posted
Posted
On 04/11/2023 at 10:45, spygirl said:

If you start a pension at, say, 20, you really need to be putting 20% of salary in a year.

A good employee will contrib match up to 10%.

A crap company will match to 5%.

It should be obvious that paying in 5-10% of gross income a year for 40 years (total of 2-4 years paid in) is not going to fund 25 years on 50% of salary (13 years paid out) in DC world but most people can't/won't do the maths.

If people want 13 years paid out they are going to have to pay in a roughly similar amount, which for a 45 year working life would be 29% of gross income going to pension contributions.

Link to comment
Share on other sites
Formerly

Formerly

Posted
Posted
12 hours ago, Darude said:

It should be obvious that paying in 5-10% of gross income a year for 40 years (total of 2-4 years paid in) is not going to fund 25 years on 50% of salary (13 years paid out) in DC world but most people can't/won't do the maths.

If people want 13 years paid out they are going to have to pay in a roughly similar amount, which for a 45 year working life would be 29% of gross income going to pension contributions.

You're missing out the "magic of compound returns". Of course the evil of compound inflation is never mentioned.

  • Agree 4
Link to comment
Share on other sites
Guest

Guest

Posted
Posted
4 hours ago, Formerly said:

You're missing out the "magic of compound returns". Of course the evil of compound inflation is never mentioned.

UK GDP per capita hasn't grown for about 2 decades, my base case assumption is this will continue for some time. If the economy is not growing then compound real returns are difficult to achieve.

Link to comment
Share on other sites
reformed nice guy

reformed nice guy

Posted
Posted
6 minutes ago, Darude said:

UK GDP per capita hasn't grown for about 2 decades, my base case assumption is this will continue for some time. If the economy is not growing then compound real returns are difficult to achieve.

The denominator for the per capita calculation is population which I believe is deliberately underestimated. Replace with the true population and GDP/capita will have steadily declined.

Bringing in people with below average wealth and below average earnings will do that - only economists pretend it does not

  • Agree 4
Link to comment
Share on other sites
No One

No One

Posted
Posted
On 06/11/2023 at 19:41, Darude said:

It should be obvious that paying in 5-10% of gross income a year for 40 years (total of 2-4 years paid in) is not going to fund 25 years on 50% of salary (13 years paid out) in DC world but most people can't/won't do the maths.

If people want 13 years paid out they are going to have to pay in a roughly similar amount, which for a 45 year working life would be 29% of gross income going to pension contributions.

Can some one do the maths for me, 

At what ages x,y,z would you expect to have a,b,c £s in a dbc?

Link to comment
Share on other sites
spygirl

spygirl

Posted
  • Author
Posted
16 minutes ago, No One said:

Can some one do the maths for me, 

At what ages x,y,z would you expect to have a,b,c £s in a dbc?

It depends, and that's the problem with pensions.

The averageDC person really needs to be aiming at a 100k, ideally 150k, pot to go with the New State Pension.

Personally, I've always saved 30% of my income. By save I mean pension or mortgage capital repayment.

That way, when I eventually retire I'll just continue on same income - without tte 30% saving bit.

There used to be that old saying - save half your age when you start a pension -

10% for 20yo.

25% for 50yo.

I don't really see how that can work for 50+ . 25% is just not enough.

 

 

 

 

  • Agree 1
Link to comment
Share on other sites
Chewing Grass

Chewing Grass

Posted
Posted
On 04/11/2023 at 10:39, spygirl said:

No specific point, just came out of a @One percent post about BBC pension deficit.

They are in shit.

Anyhow, with the get out that Im not an actuary ...

https://www.pensions-expert.com/Law-Regulation/What-does-High-Court-ruling-mean-for-the-BBC-and-other-DB-pension-schemes?ct=true

In evidence given to the High Court, Leigh Tavaziva, chief operating officer of the BBC, explained that the broadcaster was paying a contribution rate of 42.3 per cent of the pensionable salaries of active members, which is almost three times what the contribution rate was in 2010.

By contrast, members of the BBC’s defined contribution (DC) scheme who joined after 2010 are receiving an employer contribution of seven to eight percent.

DB employees accounted for less than 40 per cent of the workforce, but accounted for over 80 per cent of the pensions spending, according to the judgement.

A stark reminder of how the young are being screwed by the old. And how the public sector are fucking over the private.~40% is about the a DB pension will cost an employee.

For the likes of fire n police, its about double. For a woman copper you are talking about 100% of salary.

Ive not problem wit DB pension - as long as they are funded. They are not.

Dont work for a company that has moved from DB - > DC.

Any extra effort or money will be eaten by the pension fund.

 

Picked this up -

https://www.pensionsage.com/pa/BLOG-How-many-presenters-does-it-take-to-plug-theBBCs-pension-deficit.php

Nonetheless, both the public and the pensions industry share a similar view when it comes to the gender pay gap. While the spotlight has been shone on the BBC's male and female stars' largely differing salaries, their pensions gender pay gap is likely to be vast as well. We’ll have to wait a few decades to see if these male and female stars enjoy vastly different retirements though!

What they are hinting at is that women pension cost *FAR* more than blokes - abut 30%.

And at 40% of salary a pension is a huge extra for wimmin.

The BBC DB lets both men n women retire at 60. Thats nuts.

All that the idiots needed to do was sync the retirement age to   to SRA.

They morons didnt.

 

I counter with this as PWC says schemes are in rude health.

https://www.pwc.co.uk/press-room/press-releases/uk-db-pension-schemes-funding-reaches-unprecedented-level.html

The UK’s 5,000 corporate defined benefit (DB) pensions schemes reached a record surplus of £250bn in October, according to PwC’s Buyout Index, as an increase in long-term gilt yields reduced the estimated cost for schemes to ‘buyout’ their pension promises. 

Screenshotfrom2023-11-0721-27-46.thumb.png.0999aab8d76603c3cb201831c453f238.png

Link to comment
Share on other sites
spygirl

spygirl

Posted
  • Author
Posted
1 minute ago, Chewing Grass said:

I counter with this as PWC says schemes are in rude health.

https://www.pwc.co.uk/press-room/press-releases/uk-db-pension-schemes-funding-reaches-unprecedented-level.html

The UK’s 5,000 corporate defined benefit (DB) pensions schemes reached a record surplus of £250bn in October, according to PwC’s Buyout Index, as an increase in long-term gilt yields reduced the estimated cost for schemes to ‘buyout’ their pension promises. 

Screenshotfrom2023-11-0721-27-46.thumb.png.0999aab8d76603c3cb201831c453f238.png

Private sector DB, who acted in the mud 90s,  are in rude health.

But  few if any new members have joined those in the last 25y.

They have git a massive boost with ruse in Gilts, and a little shove in life exp falls.

BBC has trundled on blindly, assuming it didnt have an issue til 2010.

Bbc is in shit as the only way its hosts revenue (bbc) is going is down.

 

Link to comment
Share on other sites
Chewing Grass

Chewing Grass

Posted
Posted
4 minutes ago, spygirl said:

Private sector DB, who acted in the mud 90s,  are in rude health.

But  few if any new members have joined those in the last 25y.

They have git a massive boost with ruse in Gilts, and a little shove in life exp falls.

BBC has trundled on blindly, assuming it didnt have an issue til 2010.

Bbc is in shit as the only way its hosts revenue (bbc) is going is down.

 

I did notice shrinking liabilities (probably jabbed to death).

Link to comment
Share on other sites
Chewing Grass

Chewing Grass

Posted
Posted (edited)
                                                                                           
Multiples of Salary
 
                                                                                             
                                                                                             
                                                                                             
                                                                                             
  Percent In 15                                                                                        
  Return % 2.5                                                                                        
                                                                                             
                                                                                             
  Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25 Year 26 Year 27 Year 28 Year 29 Year 30 Year 31 Year 32 Year 33 Year 34 Year 35 Year 36 Year 37 Year 38 Year 39 Year 40 Year 41 Year 42 Year 43 Year 44 Year 45 Total  
Year 1 0.15                                                                                         0.15  
Year 2 0.15375 0.15                                                                                       0.30375  
Year 3 0.15759375 0.15375 0.15                                                                                     0.46134375  
Year 4 0.1615335938 0.15759375 0.15375 0.15                                                                                   0.6228773438  
Year 5 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                                 0.7884492773  
Year 6 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                               0.9581605093  
Year 7 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                             1.132114522  
Year 8 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                           1.310417385  
Year 9 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                         1.49317782  
Year 10 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                       1.680507265  
Year 11 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                     1.872519947  
Year 12 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                   2.069332945  
Year 13 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                 2.271066269  
Year 14 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                               2.477842926  
Year 15 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                             2.689788999  
Year 16 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                           2.907033724  
Year 17 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                         3.129709567  
Year 18 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                       3.357952306  
Year 19 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                     3.591901114  
Year 20 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                   3.831698642  
Year 21 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                 4.077491108  
Year 22 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                               4.329428385  
Year 23 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                             4.587664095  
Year 24 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                           4.852355697  
Year 25 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                         5.12366459  
Year 26 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                       5.401756205  
Year 27 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                     5.68680011  
Year 28 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                   5.978970113  
Year 29 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                 6.278444365  
Year 30 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                               6.585405474  
Year 31 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                             6.900040611  
Year 32 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                           7.222541627  
Year 33 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                         7.553105167  
Year 34 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                       7.891932796  
Year 35 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                     8.239231116  
Year 36 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                   8.595211894  
Year 37 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                 8.960092192  
Year 38 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15               9.334094496  
Year 39 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15             9.717446859  
Year 40 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15           10.11038303 10X = Half Salary for 20 Years
Year 41 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15         10.51314261  
Year 42 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15       10.92597117  
Year 43 0.4231492793 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15     11.34912045  
Year 44 0.4337280113 0.4231492793 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15   11.78284846  
Year 45 0.4445712115 0.4337280113 0.4231492793 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15 12.22741967  

 

Far right column gives multiples of salary equivalent.

Each cell contains the years proceeds and compounds as a percentage of salary based on percent sacrificed.

Feel free to use, comment, modify for yourselves but I'm a nutter..

https://docs.google.com/spreadsheets/d/1Iv0e3Mn60TdRtoco0YlZNdpoIwa6G1de/edit?usp=sharing&ouid=103428325892558075288&rtpof=true&sd=true

Edited by Chewing Grass
Link to comment
Share on other sites
Guest

Guest

Posted
Posted
15 hours ago, Chewing Grass said:
                                                                                           
Multiples of Salary
 
                                                                                             
                                                                                             
                                                                                             
                                                                                             
  Percent In 15                                                                                        
  Return % 2.5                                                                                        
                                                                                             
                                                                                             
  Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25 Year 26 Year 27 Year 28 Year 29 Year 30 Year 31 Year 32 Year 33 Year 34 Year 35 Year 36 Year 37 Year 38 Year 39 Year 40 Year 41 Year 42 Year 43 Year 44 Year 45 Total  
Year 1 0.15                                                                                         0.15  
Year 2 0.15375 0.15                                                                                       0.30375  
Year 3 0.15759375 0.15375 0.15                                                                                     0.46134375  
Year 4 0.1615335938 0.15759375 0.15375 0.15                                                                                   0.6228773438  
Year 5 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                                 0.7884492773  
Year 6 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                               0.9581605093  
Year 7 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                             1.132114522  
Year 8 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                           1.310417385  
Year 9 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                         1.49317782  
Year 10 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                       1.680507265  
Year 11 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                     1.872519947  
Year 12 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                   2.069332945  
Year 13 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                                 2.271066269  
Year 14 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                               2.477842926  
Year 15 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                             2.689788999  
Year 16 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                           2.907033724  
Year 17 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                         3.129709567  
Year 18 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                       3.357952306  
Year 19 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                     3.591901114  
Year 20 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                   3.831698642  
Year 21 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                                 4.077491108  
Year 22 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                               4.329428385  
Year 23 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                             4.587664095  
Year 24 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                           4.852355697  
Year 25 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                         5.12366459  
Year 26 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                       5.401756205  
Year 27 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                     5.68680011  
Year 28 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                   5.978970113  
Year 29 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                                 6.278444365  
Year 30 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                               6.585405474  
Year 31 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                             6.900040611  
Year 32 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                           7.222541627  
Year 33 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                         7.553105167  
Year 34 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                       7.891932796  
Year 35 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                     8.239231116  
Year 36 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                   8.595211894  
Year 37 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15                 8.960092192  
Year 38 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15               9.334094496  
Year 39 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15             9.717446859  
Year 40 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15           10.11038303 10X = Half Salary for 20 Years
Year 41 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15         10.51314261  
Year 42 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15       10.92597117  
Year 43 0.4231492793 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15     11.34912045  
Year 44 0.4337280113 0.4231492793 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15   11.78284846  
Year 45 0.4445712115 0.4337280113 0.4231492793 0.4128285652 0.4027595758 0.3929361715 0.3833523624 0.3740023048 0.3648802974 0.3559807779 0.3472983199 0.3388276292 0.3305635407 0.3225010153 0.3146351369 0.3069611091 0.2994742528 0.2921700027 0.2850439051 0.2780916147 0.2713088924 0.2646916024 0.2582357096 0.2519372777 0.245792466 0.2397975278 0.2339488077 0.2282427392 0.2226758431 0.217244725 0.2119460731 0.2067766567 0.2017333236 0.1968129987 0.1920126816 0.1873294455 0.1827604346 0.1783028631 0.1739540127 0.1697112319 0.1655719336 0.1615335938 0.15759375 0.15375 0.15 12.22741967  

 

Far right column gives multiples of salary equivalent.

Each cell contains the years proceeds and compounds as a percentage of salary based on percent sacrificed.

Feel free to use, comment, modify for yourselves but I'm a nutter..

https://docs.google.com/spreadsheets/d/1Iv0e3Mn60TdRtoco0YlZNdpoIwa6G1de/edit?usp=sharing&ouid=103428325892558075288&rtpof=true&sd=true

What investment class gives a real terms yield of 2.5%?

Link to comment
Share on other sites
Chewing Grass

Chewing Grass

Posted
Posted
4 hours ago, No One said:

Thank you C.G, Could you explain what the fractions represent?

Easy, my cells are fixed size and wrapped the text round for the many decimal places #notafraction

Link to comment
Share on other sites
spygirl

spygirl

Posted
  • Author
Posted

BT Group raises prospect of pension refund after scheme deficit halves

One of UK’s biggest retirement plans has been boosted by higher interest rates

https://www.ft.com/content/2956f0d7-dcc1-4293-bac8-6d5b79af4eb7

Theres a lot of large UK (and EU firms) that having been on the pension deficit treanikk sicne QE startedm, will find themsleves having to act liek compnies agian i..e spendign money, developing products and services.

 

  • Informative 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Latest threads

×
×
  • Create New...