We'd like to remind Forumites to please avoid political debate on the Forum. This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
We're aware that dates on the Forum are not currently showing correctly. Please bear with us while we get this fixed, and see Site feedback for updates.
Financial Planning spreadsheet or tips on how to build one?

swimchamp1
Posts: 3 Newbie

Hi, I'm fairly financially literate and can build financial models etc. I'm in my early forties and want to do some fairly detailed financial modelling of the next 20 years or so. Does anyone know if there are pre-built excel models I can buy which have the current assumptions, ranges, discount rates, etc. built in? Or websites offering guidance? I'm happy to pay for the info but I don't want to approach a financial advisor because I don't want to be sold investments, I just want to create scenarios so I can better understand budgeting, worse cases, etc.
0
Comments
-
Timeline application. RetireEasy. And some other web tools.
If you are of a "data stays here" disposition and want to build in LibreOffice or Excel then
Perhaps watch Lars Kroijier videos for tips on how to do this yourself.
A step on from just laying out a cashflow model with in/outflows and a single average for long term returns and inflation uplift.https://www.youtube.com/watch?v=nMfT6cAYJjU
gets you to the series
1 -
Great! I hadn't thought of YouTube at all. I'm not too worried about using a third party site from a data perspective but don't want to pay onerous ongoing fees for continued hosting. I don't want to put in a lot of work then be held hostage. I'll look at all of the above, thank you very much for the response.
0 -
Voyant is another cash flow modelling that's normally used by advisers.- you can pay to get access to it, but you have to sign up to a training class to get the initial access, and after that it costs about £120 per year.
Timeline is also a good software for stress testing but they have now locked it down so you have to pay even to get a short term demo version.
If you trawl these forums, a few people have posted web sites and spreadsheets.
cfiresim is a free web site that does stress testing of retirement scenarios against US stock market data.1 -
Thank you, I tried to have a look through the forums but the search terms I was using weren't getting me far. Hopefully searching for some of these applications will throw up some relevant threads and I'll have a look at the applications themselves too.
0 -
https://www.bogleheads.org/wiki/Tools_and_calculators. Not sure what you want, but you will get some leads here.
1 -
I've been using Guiide and quite like it.2021 GC £1365.71/ £24000
-
Search for James Shack on Youtube - he has a XLS that is pretty good - UK based Content Creator.
I can't post a link yet to the video so just search for James Shack Cashflow Plan on youtube
I can also recommend Chris Bourne and MeaningfullMoney as really helpful Content creators
1 -
If you're going to build your own, do it on Google Sheets via Google Drive. The number of times I've found myself updating sheets on my mobile phone - something I thought I'd never do - amazes me. It's like a simpler version of Excel in the cloud.0
-
BrassicWoman said:I've been using Guiide and quite like it.1
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 348.4K Banking & Borrowing
- 252.1K Reduce Debt & Boost Income
- 452.4K Spending & Discounts
- 241K Work, Benefits & Business
- 617.3K Mortgages, Homes & Bills
- 175.7K Life & Family
- 254.2K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 15.1K Coronavirus Support Boards