Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Retirement Spending Allowance Spreadsheet
Old 12-05-2007, 06:08 PM   #1
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
TromboneAl's Avatar
 
Join Date: Jun 2006
Posts: 11,197
Retirement Spending Allowance Spreadsheet

I've attached a very simple spreadsheet for determining how much to spend each year. I figured that having a spreadsheet would keep me honest.

You enter the retirement year, the amount of your retirement dough (including or excluding house, you decide) and the SWR you will use.

It tells you how much to spend for your first year. At the end of that year, you enter the inflation rate that you will use for that year, and it tells you how much to spend next year. Any money left over goes in your fun money account.

I've put in hypothetical values to illustrate how it works.
RetirementSpending.jpg
Attached Files
File Type: zip RetirementSpendingPlanAndRecord.zip (5.4 KB, 111 views)
__________________

__________________
Al
TromboneAl is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 12-05-2007, 08:19 PM   #2
Dryer sheet aficionado
 
Join Date: May 2005
Posts: 46
thanks - will come in handy. hoping to RE in 2 years
__________________

__________________
steinj is offline   Reply With Quote
Old 12-05-2007, 08:33 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Moemg's Avatar
 
Join Date: Jan 2007
Location: Sarasota,fl.
Posts: 10,032
Wow Al and I thought you were living a frugal life !
__________________
Moemg is offline   Reply With Quote
Old 12-05-2007, 08:47 PM   #4
Dryer sheet aficionado
 
Join Date: May 2005
Posts: 46
are you talking to me?
__________________
steinj is offline   Reply With Quote
Old 12-05-2007, 08:55 PM   #5
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas Hill Country
Posts: 42,081
Is your name Al?
__________________
Numbers is hard

When I hit 70, it hit back

Retired in 2005 at age 58, no pension
REWahoo is offline   Reply With Quote
Old 12-05-2007, 09:32 PM   #6
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
bbbamI's Avatar
 
Join Date: Dec 2006
Location: Dallas 'burb
Posts: 9,039
__________________
There's no need to complicate, our time is short..
bbbamI is offline   Reply With Quote
Old 12-05-2007, 10:20 PM   #7
Dryer sheet aficionado
 
Join Date: May 2005
Posts: 46
No, Im not Al , but there are two ways to interpret the sentence:

Wow. Al and I thought you were living a frugal life !

or

Wow Al, and I thought you were living a frugal life!

That's what happens when you forget punctuation...

JoJo
__________________
steinj is offline   Reply With Quote
Old 12-05-2007, 10:27 PM   #8
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas Hill Country
Posts: 42,081
Maybe I should have asked "Is your name Robert?"
__________________
Numbers is hard

When I hit 70, it hit back

Retired in 2005 at age 58, no pension
REWahoo is offline   Reply With Quote
nice starting point
Old 12-06-2007, 07:56 AM   #9
Recycles dryer sheets
gandalf42's Avatar
 
Join Date: Mar 2007
Location: Fort Collins, CO
Posts: 138
nice starting point

Thanks! I want to track how the nest egg does relative to inflation and how my withdrawals track relative to the moving annual SWR of 4%, so this spreadsheet is a good starting point. I will add a few collumns to do this and "complicate" it some.

What's the best source for the annual inflation rate? Consumer Price Index or ?
__________________
"Being rich is having money; being wealthy is having time."

"It is only possible to live happily ever after on a day-to-day basis” Margaret Bonnano
gandalf42 is offline   Reply With Quote
Old 12-06-2007, 10:23 AM   #10
Recycles dryer sheets
Jake46's Avatar
 
Join Date: Sep 2006
Location: Fort Collins
Posts: 194
Thank you Al. Simple but elegant!
__________________

__________________
Jake46 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spending in retirement aenlighten FIRE and Money 17 08-20-2007 05:45 PM
Spreadsheet for calculating life of retirement assets tlg501 FIRE and Money 2 03-12-2007 01:09 PM
Allowance for young children bongo2 Other topics 9 10-21-2006 06:26 AM
Spending In Retirement bookman51 FIRE and Money 45 07-23-2006 04:10 PM
spending less in retirement maddythebeagle Young Dreamers 1 06-28-2005 03:31 PM

 

 
All times are GMT -6. The time now is 11:01 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.