We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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!

It's time to start digging up those Squirrelled Nuts!!!!

Options
1127128130132133437

Comments

  • savingmore
    savingmore Posts: 661 Forumite
    Part of the Furniture 500 Posts Photogenic Name Dropper
    cfw1994 said:
    Sea_Shell said:
    I don't have a template as such, i just played around with Excel.

    I have the following columns.

    Year
    Starting fund
    Growth in £  (based on an adjustable % in another cell)
    Fund plus growth
    Estimated Spends - adjustable (linked to an adjustable inflation % each year)
    Income ( nil at present and then includes DB/SP when due)
    Net Balance
    Number of years spends at this rate

    Copy the Net balance back to the next line down as the starting fund for year 2, repeat. 
    You need to play around with the formulas a bit to get them to do what you need.

    It basically tells me that if i had say a starting pot of £500,000, with a 3% growth rate, that would give me growth in £ of £15,000.
    If I then said I would spend £20k per year, increasing at 2% inflation, it would show i'd have £495,000 for year 2, with growth in year 2 of £14,850 and spends of £20,400.   Drag the formulas down the columns to see when (if) you run out of money!!    Using the above, shows 25 years of spending, initially, with £400,000 left after 12 years.

    £166,200 of growth, to offset £266,400 of spends.  

    Hope that helps.

    Interesting: we are tangentially at odds with each other!
    My spreaddie has a row for each year, and columns for the income streams (pensions), DC pot, investments.   
    I can adjust whether I will take from the DC pot (tax implication) or investments.
    I can chuck in the odd negative % growth to test it a bit.
    I can try changing things (growth rates, inflation adjustments) to project when I need to take leave of this mortal form due to running out of money!
    Much like The Lotus Eater, by Somerset Maughan  :D
    If you ever fancy a copy, message me (but I will insist on feedback please - too many have shown interest then never responded - tell me it's rubbish or looks too hard if you want!)

    i would love a copy and wouldn’t be happy to give feedback.  i am trying to ok work out some scenarios to see if we can retire 33 months earlier than planned.  would be most grateful!   
  • michaels
    michaels Posts: 29,107 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    cfw1994 said:
    Sea_Shell said:
    I don't have a template as such, i just played around with Excel.

    I have the following columns.

    Year
    Starting fund
    Growth in £  (based on an adjustable % in another cell)
    Fund plus growth
    Estimated Spends - adjustable (linked to an adjustable inflation % each year)
    Income ( nil at present and then includes DB/SP when due)
    Net Balance
    Number of years spends at this rate

    Copy the Net balance back to the next line down as the starting fund for year 2, repeat. 
    You need to play around with the formulas a bit to get them to do what you need.

    It basically tells me that if i had say a starting pot of £500,000, with a 3% growth rate, that would give me growth in £ of £15,000.
    If I then said I would spend £20k per year, increasing at 2% inflation, it would show i'd have £495,000 for year 2, with growth in year 2 of £14,850 and spends of £20,400.   Drag the formulas down the columns to see when (if) you run out of money!!    Using the above, shows 25 years of spending, initially, with £400,000 left after 12 years.

    £166,200 of growth, to offset £266,400 of spends.  

    Hope that helps.

    Interesting: we are tangentially at odds with each other!
    My spreaddie has a row for each year, and columns for the income streams (pensions), DC pot, investments.   
    I can adjust whether I will take from the DC pot (tax implication) or investments.
    I can chuck in the odd negative % growth to test it a bit.
    I can try changing things (growth rates, inflation adjustments) to project when I need to take leave of this mortal form due to running out of money!
    Much like The Lotus Eater, by Somerset Maughan  :D
    If you ever fancy a copy, message me (but I will insist on feedback please - too many have shown interest then never responded - tell me it's rubbish or looks too hard if you want!)

    i would love a copy and wouldn’t be happy to give feedback.  i am trying to ok work out some scenarios to see if we can retire 33 months earlier than planned.  would be most grateful!   
    I guess that is honest...
    I think....
  • I assumed they meant 'would be happy'  :)
  • cfw1994
    cfw1994 Posts: 2,127 Forumite
    Part of the Furniture 1,000 Posts Hung up my suit! Name Dropper
    edited 27 July 2020 at 1:49PM
    cfw1994 said:
    Sea_Shell said:
    I don't have a template as such, i just played around with Excel.

    I have the following columns.

    Year
    Starting fund
    Growth in £  (based on an adjustable % in another cell)
    Fund plus growth
    Estimated Spends - adjustable (linked to an adjustable inflation % each year)
    Income ( nil at present and then includes DB/SP when due)
    Net Balance
    Number of years spends at this rate

    Copy the Net balance back to the next line down as the starting fund for year 2, repeat. 
    You need to play around with the formulas a bit to get them to do what you need.

    It basically tells me that if i had say a starting pot of £500,000, with a 3% growth rate, that would give me growth in £ of £15,000.
    If I then said I would spend £20k per year, increasing at 2% inflation, it would show i'd have £495,000 for year 2, with growth in year 2 of £14,850 and spends of £20,400.   Drag the formulas down the columns to see when (if) you run out of money!!    Using the above, shows 25 years of spending, initially, with £400,000 left after 12 years.

    £166,200 of growth, to offset £266,400 of spends.  

    Hope that helps.

    Interesting: we are tangentially at odds with each other!
    My spreaddie has a row for each year, and columns for the income streams (pensions), DC pot, investments.   
    I can adjust whether I will take from the DC pot (tax implication) or investments.
    I can chuck in the odd negative % growth to test it a bit.
    I can try changing things (growth rates, inflation adjustments) to project when I need to take leave of this mortal form due to running out of money!
    Much like The Lotus Eater, by Somerset Maughan  :D
    If you ever fancy a copy, message me (but I will insist on feedback please - too many have shown interest then never responded - tell me it's rubbish or looks too hard if you want!)

    i would love a copy and wouldn’t be happy to give feedback.  i am trying to ok work out some scenarios to see if we can retire 33 months earlier than planned.  would be most grateful!   
    I’ll message details in the morning.  Do let me know how you get on!
    eta - message sent!
    Plan for tomorrow, enjoy today!
  • Sea_Shell
    Sea_Shell Posts: 10,025 Forumite
    Tenth Anniversary 1,000 Posts Photogenic Name Dropper
    Good Morning Squirrellers

    Again, not much to report, so just checking in. 
       
    Month end figures for July, show that we were up £19,000 on last July (approx 3.4%), but have spent £10,500 of that (year to date) and so are up a net of £8,500.   No trailing salary to include now.   Still solvent, for now.

    Markets seem to have been a bit twitchy again this past week, so we'll see what next month brings.  
    How's it going, AKA, Nutwatch? - 12 month spends to date = 2.60% of current retirement "pot" (as at end May 2025)
  • atush
    atush Posts: 18,731 Forumite
    Part of the Furniture 10,000 Posts Name Dropper
    Sounds good.

    I am still finding spending down, savings up in general.  Groceries are up, as no more special offers like there used to be but wasnt spending anything on eating out.  But now eating out has resumed for us, and we are off to our gite in france later in the month.  So i expect spending to go back up to more normal levels esp as we will be on vacation.

    I expected to find ferry/chunnel tickets to be low, but they were HIGH.
  • cfw1994 said:
    cfw1994 said:
    Sea_Shell said:
    I don't have a template as such, i just played around with Excel.

    I have the following columns.

    Year
    Starting fund
    Growth in £  (based on an adjustable % in another cell)
    Fund plus growth
    Estimated Spends - adjustable (linked to an adjustable inflation % each year)
    Income ( nil at present and then includes DB/SP when due)
    Net Balance
    Number of years spends at this rate

    Copy the Net balance back to the next line down as the starting fund for year 2, repeat. 
    You need to play around with the formulas a bit to get them to do what you need.

    It basically tells me that if i had say a starting pot of £500,000, with a 3% growth rate, that would give me growth in £ of £15,000.
    If I then said I would spend £20k per year, increasing at 2% inflation, it would show i'd have £495,000 for year 2, with growth in year 2 of £14,850 and spends of £20,400.   Drag the formulas down the columns to see when (if) you run out of money!!    Using the above, shows 25 years of spending, initially, with £400,000 left after 12 years.

    £166,200 of growth, to offset £266,400 of spends.  

    Hope that helps.

    Interesting: we are tangentially at odds with each other!
    My spreaddie has a row for each year, and columns for the income streams (pensions), DC pot, investments.   
    I can adjust whether I will take from the DC pot (tax implication) or investments.
    I can chuck in the odd negative % growth to test it a bit.
    I can try changing things (growth rates, inflation adjustments) to project when I need to take leave of this mortal form due to running out of money!
    Much like The Lotus Eater, by Somerset Maughan  :D
    If you ever fancy a copy, message me (but I will insist on feedback please - too many have shown interest then never responded - tell me it's rubbish or looks too hard if you want!)

    i would love a copy and wouldn’t be happy to give feedback.  i am trying to ok work out some scenarios to see if we can retire 33 months earlier than planned.  would be most grateful!   
    I’ll message details in the morning.  Do let me know how you get on!
    eta - message sent!
    cfw I too would love to see a copy if possible and again am happy to feedback
    Thanks
  • cfw1994
    cfw1994 Posts: 2,127 Forumite
    Part of the Furniture 1,000 Posts Hung up my suit! Name Dropper
    graham131 said:
    cfw1994 said:
    cfw1994 said:
    Sea_Shell said:
    I don't have a template as such, i just played around with Excel.

    I have the following columns.

    Year
    Starting fund
    Growth in £  (based on an adjustable % in another cell)
    Fund plus growth
    Estimated Spends - adjustable (linked to an adjustable inflation % each year)
    Income ( nil at present and then includes DB/SP when due)
    Net Balance
    Number of years spends at this rate

    Copy the Net balance back to the next line down as the starting fund for year 2, repeat. 
    You need to play around with the formulas a bit to get them to do what you need.

    It basically tells me that if i had say a starting pot of £500,000, with a 3% growth rate, that would give me growth in £ of £15,000.
    If I then said I would spend £20k per year, increasing at 2% inflation, it would show i'd have £495,000 for year 2, with growth in year 2 of £14,850 and spends of £20,400.   Drag the formulas down the columns to see when (if) you run out of money!!    Using the above, shows 25 years of spending, initially, with £400,000 left after 12 years.

    £166,200 of growth, to offset £266,400 of spends.  

    Hope that helps.

    Interesting: we are tangentially at odds with each other!
    My spreaddie has a row for each year, and columns for the income streams (pensions), DC pot, investments.   
    I can adjust whether I will take from the DC pot (tax implication) or investments.
    I can chuck in the odd negative % growth to test it a bit.
    I can try changing things (growth rates, inflation adjustments) to project when I need to take leave of this mortal form due to running out of money!
    Much like The Lotus Eater, by Somerset Maughan  :D
    If you ever fancy a copy, message me (but I will insist on feedback please - too many have shown interest then never responded - tell me it's rubbish or looks too hard if you want!)

    i would love a copy and wouldn’t be happy to give feedback.  i am trying to ok work out some scenarios to see if we can retire 33 months earlier than planned.  would be most grateful!   
    I’ll message details in the morning.  Do let me know how you get on!
    eta - message sent!
    cfw I too would love to see a copy if possible and again am happy to feedback
    Thanks
    You have a message!
    Plan for tomorrow, enjoy today!
  • Blackcats
    Blackcats Posts: 3,874 Forumite
    Sixth Anniversary 1,000 Posts Name Dropper
    CFW May I have a copy too please.  I'm a lurker here and am always impressed, amazed (and very intimidated) by the amazing calculations folk here can do.  My feedback will definitely be from a novice's perspective 🤣
  • cfw1994
    cfw1994 Posts: 2,127 Forumite
    Part of the Furniture 1,000 Posts Hung up my suit! Name Dropper
    Blackcats said:
    CFW May I have a copy too please.  I'm a lurker here and am always impressed, amazed (and very intimidated) by the amazing calculations folk here can do.  My feedback will definitely be from a novice's perspective 🤣
    Messaged!
    Plan for tomorrow, enjoy today!
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
  • 351K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.6K Spending & Discounts
  • 244K Work, Benefits & Business
  • 598.9K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.3K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K 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.