We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
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
Comments
-
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.
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
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!)2 -
savingmore 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.
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
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 think....4 -
I assumed they meant 'would be happy'1
-
savingmore 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.
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
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!)
eta - message sent!
Plan for tomorrow, enjoy today!0 -
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)3 -
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.0 -
cfw1994 said:savingmore 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.
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
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!)
eta - message sent!
Thanks0 -
graham131 said:cfw1994 said:savingmore 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.
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
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!)
eta - message sent!
ThanksPlan for tomorrow, enjoy today!1 -
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 🤣1
-
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 🤣Plan for tomorrow, enjoy today!1
Confirm your email address to Create Threads and Reply

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