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
swimchamp1 Posts: 3 Newbie
First Post
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.

Comments

  • gm0
    gm0 Posts: 1,076 Forumite
    Sixth Anniversary 1,000 Posts Name Dropper
    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



  • 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.
  • Pat38493
    Pat38493 Posts: 3,133 Forumite
    Tenth Anniversary 1,000 Posts Name Dropper Combo Breaker
    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.
  • 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.
  • https://www.bogleheads.org/wiki/Tools_and_calculators. Not sure what you want, but you will get some leads here.
  • I've been using Guiide and quite like it.
    2021 GC £1365.71/ £2400
  • 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

  • jim8888
    jim8888 Posts: 406 Forumite
    Tenth Anniversary 100 Posts Name Dropper
    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.
  • I've been using Guiide and quite like it.
    I like Guiide too.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.