Pension balance sheet?

Jaguar_Skills

How do you guys record your investments etc?

Is there a decent excel to use?

I'm only investing £600/@ month into two funds but would still like to monitor it.

Should I just use the platform? Cavendishonline?

[Deleted User]

Jaguar_Skills wrote: »

How do you guys record your investments etc?

Is there a decent excel to use?

I'm only investing £600/@ month into two funds but would still like to monitor it.

Should I just use the platform? Cavendishonline?

I suspect my system is not what you are looking for but this is what I do...


List all my pensions in Excel with what they are expected to pay at what age with any benefits, lump sums etc


This is also combined with key dates in my life so I can map out my financial future. i.e. so I can ~pinpoint when would be a good idea to retire/go part time etc Obviously not an exact science...


By combining this with our on-going spending diary I can easily see what income is needed in retirement.


For example I'd like to clear the mortgage but the time daughter finishes high school but this has to be balanced with pension over-payments to achieve the desired retirement income...


Gets refined regularly.


All good stuff

Jaguar_Skills

Thanks for that. I just wondered as I am not that great on Excel so wondered if there was a ready made sheet that I could utilise.

Surprised MSE havent come up with something?

AlanP_2

You can set up a Portfolio Tracker on morningstar or trustnet if you don't want to use Excel, just select the funds and enter the Buy / Sell details for each transaction.

The advantage of Excel is that you can "what if" looking forward but I find that more useful in terms of estimating values of investments pots / salaries / pensions (when they start paying out) / mortgage etc. to see what the overall picture looks like.

Jaguar_Skills

Thanks Alan. I could set both up together I guess. Or just have it in excel and adjust the figures six months into the investment. I.e. when I have £600 * 6 months in there then £600 * 12 months + increase etc..