Pension Calculator

This is a calculator based on relatively simple actuarial maths. Its not rocket science. The core reason I have produced this is twofold. In part because in my particular case it was me losing out and, much more importantly the advice given to me by my lawyer (who categorically states this is the position of all lawyers and is established practice) is fundamentally and morally wrong.

“Just because everyone does it does not make it right. Just because nobody does it does not make it wrong.”

The core element of this error is assumption. When looking at pre-marital assets, which I agree is a fundamental principle of fairness, lawyers take a straight line approach; assuming the figures will pretty much match up. They are wrong, and quite spectacularly so. Because most people are mathematically weak; our education system seems to pride itself on leaving people vulnerable when it comes down to money, even my own, highly educated, lawyer took some convincing as to the reality of this error.

The issue is caused by ignoring compound interest and growth.

Pension error illustration, CETV £640k, 50% would be £320k.

The graph above shows the lawyers straight line and the actuarially accurate growth curve, and the arc shows the error. What this shows is that your lawyer will only ever get their straight line calculation correct once; that is if the pension was started on or after marriage. The way to look at this graph is by taking 30 as the date of separation.

In this example the total CETV for the pension is £640,000, and so if the marriage date was at 0 (on or before the pension was stated), then the split agreed both using the actuarially correct method and what a lawyer would use will be £320,000. However if the marriage date is in-between 0 (pension start) and 30 (separation) there needs to be a valuation of the pre-marital asset, and this is where it goes very wrong.

So for example, you got married at year 1 your lawyer will say the PMA split value is £10,666, where it is actually £3,354, meaning that you would lose c.£7,300 in the settlement.

The worst case is at c17 years where the lawyers PMA split valuation is £181,333 where the real value is £107,711. This is a massive error of c.£75,000.

Even if you look at year 29 the lawyers PMA split value is £309,333 where the real value is £297,141; still a significant error for one years marriage, e.g. c.£12,200. All I can say is lawyers need to take a long hard look at their refusal to use fairly simple maths.

Try the calculator below to see what difference it makes to your outcomes.

Instructions for use:

Most importantly this is only for situations where the pension was started BEFORE the marriage. It is for working out the correct pension value at marriage and thus the PMA (Pre Marital Asset) and thence the Asset value to be used in the Assets/Liabilities separation calculations.

I have tried to keep things as simple as possible and it is oddly, given my rants, still skewed in favour of the pension holder, in that it makes some assumptions.

So for example the form assumes a linear career progression with fixed annual pay rises, whereas it is far more likely that there will have been significant jumps in salary. Also I have set the default to 6% which is representative of a career professional, you may want or need to drop this to better represent you or your partner.

I have set the pension growth to 5% which I believe to be fairly typical. If you know this to be different so adjust accordingly.

The critical field for getting this right is the Contributions field. This may look quite large, but remember this will include employer contributions too. You will need to adjust this number until the Calculated Valuation matches as close as possible the PETV/CETV figure entered. I’ve set a GOOD/BAD flag field at a 0.003% deviation which I guess is close enough.

Good Luck