Compounding spreadsheet including regulars

ruthiebusybee

Hi All

Does anyone have a compounding spreadsheet they'd like to share?

We need to include current fund value, increasing regulars, inflation and growth rate and charges!

Thanks

R

benjaminfabi

Here you go. works on monthly compounding periods only. only fill in the orange cells.

benjaminfabi

Improved version...the monthly limitation was annoying me!!

Note that it escalates contributions each compounding period, so a £300pm contribution increasing at 4% each year actually increases by 0.327% each month. This inflates the contribution rate slightly over the term, but it's not going to make a huge difference.

ruthiebusybee

Brilliant - thank you so much!