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.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Drawdown Planner Spreadsheet

2»

Comments

  • dustymil59
    dustymil59 Posts: 16 Forumite
    10 Posts First Anniversary

    So 15 months on and life has been better difficult since last posting on this, but now back on the retirement plan!

    The premium version was OK but no better than the spreadsheets built using the very decent video above, my subscription ran out after 12 months and I don't feel the urge to renew it, especially since i like and got used to the spreadsheets.

  • mrklaw
    mrklaw Posts: 170 Forumite
    Part of the Furniture 100 Posts Name Dropper Combo Breaker

    I liked Edmund baileys one from earlier - he customised for some alternate return rates and use duplicated tabs to try what-ifs


    it’s good but I also wanted some nominal vs real & planned vs actual tracking to show deviation from the plan. Planning in real but then updated balances each year would always be nominal

    I have some manual stuff for now but also we’re hopefully only a few years off so can probably fudge the gaps

  • NormalNorman
    NormalNorman Posts: 171 Forumite
    100 Posts Photogenic Name Dropper

    We just have a google sheet.

    It lists all retirement income streams, when they start and when they cease. It also has a split so on one side is all the guaranteed money like PT job till 67, DBs, SPs and on the other, DC pots. It's all based in todays money.

    Then below it's all displayed on a stacked graph i.e. there is a column for each year of retirement which makes earnings very visible. Each income stream is a different colour. The first column is current incomes for comparison. Certainly helps with planning.

    The only thing I'm not to sure how to incorporate is known lump sums that will arrive in the future? No mortgage or debts so I guess the money will be drip fed into ISAs, SIPPs, PBs.

    Another addition I need to do is incorporate a line graph across the years for mandatory outgoings. The idea is to show disposable income. For example, in three years at retirement income may be lower but our outgoings will drop by £1500 per month plus no NI to pay nor £2k pm pension contributions deducted from our salaries.

  • cloud_dog
    cloud_dog Posts: 6,446 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Photogenic
    edited 2 June at 10:30AM

    I use a similar sounding sheet to yourself, unsure if is the one I borrowed from someone (I think it was a 'stress testing' spreadsheet from one of the YT gurus) and began enhancing it.

    Re your comment on contributions, I've simply added a column against the flexible income pots / columns (DCs, ISAs), and plan any contributions in that way.

    Personal Responsibility - Sad but True :D

    Sometimes.... I am like a dog with a bone
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
  • 354.9K Banking & Borrowing
  • 254.6K Reduce Debt & Boost Income
  • 455.6K Spending & Discounts
  • 247.7K Work, Benefits & Business
  • 604.7K Mortgages, Homes & Bills
  • 178.7K Life & Family
  • 262.3K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.7K Read-Only 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.