Any personal finance cashflow projection excels / tools?
Any personal finance cashflow projection excels / tools?
Author
Discussion

devnull

Original Poster:

3,862 posts

186 months

Monday 4th January 2021
quotequote all
Before I start making one myself, wondering if there are any cashflow projection spreadsheets that exist that people find useful?

I"m PAYE so reasonably easy to predict what I am going to be paid and what's going out, I'm just wondering if someone has made anything particularly whizzy that I might not have been able to think of.

I'm looking to forecast my 2021 pay and beyond - looking at long term cash flow to see what I can do in terms of adjusting mortgage overpayments, predicting impact of large purchases (i.e. cars and home improvements) etc.

I'm actually a YNAB (You Need a Budget) user already, which is fine, but it is a mildly cultish financial tool that only lets you focus month to month on things, rather than predicting.

Mr Pointy

13,355 posts

188 months

Monday 4th January 2021
quotequote all
There's quite a few free spreadsheets here:
https://www.vertex42.com/Calculators/financial-cal...

Maybe you could modify this annual one to cover more years:
https://www.vertex42.com/Calculators/budget-calcul...

fatvik

354 posts

212 months

Monday 4th January 2021
quotequote all
Thanks Mr. Pointy, this might be something useful for myself thumbup

Mr Pointy

13,355 posts

188 months

Monday 4th January 2021
quotequote all
fatvik said:
Thanks Mr. Pointy, this might be something useful for myself thumbup
They are rather American biased but if you know a bit of Excel you can modify the spreadsheets to suit your needs.

devnull

Original Poster:

3,862 posts

186 months

Monday 4th January 2021
quotequote all
Mr Pointy said:
There's quite a few free spreadsheets here:
https://www.vertex42.com/Calculators/financial-cal...

Maybe you could modify this annual one to cover more years:
https://www.vertex42.com/Calculators/budget-calcul...
Thanks very much, think I will use this as basis to do some modifying upon.