![]() |
|
|
|||||||
![]() |
|||||
![]() |
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
#1 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2007
Posts: 67
|
Almost 40 years old and SOOO happy to find this forum!!!
Hi all,
I have been a near maniac in creating excel spread sheets to help me model for retirement. Most times I am happy with what I produce but their are many times where I wish I had someone to look things over and discuss with. We have a goal to retire at 50. I would appreciate any one who has the time in taking a look at the data below and commenting whether we are in the ball park or have no real hopes and to change our retirement expectations. If you require more information to help make a judgment, please ask and I will provide Thank you very much: Family Info Married with one child (it will remain 1 child) Daughter is 8 and in the 3rd grade I am 39 and wife is 40 Work Salary Info Combined household income: $231,000 Current Savings: $1,330,000 This breaks down into the following (all approx) $70k in cash $650k in brokerage account (all mutual funds) $610k in retirement accounts (all mutual funds) Mutual Fund Break Down (all approx.) 43% Value 35% Growth 14% International 8% Blend 52% Large Cap 24% Mid Cap 24% Small Cap Asset Allocation of Mutual Funds(approx) 85% Stocks 15% Bonds 529 Plan (this is above and beyond the savings listed above): $81k Mortgage All paid off. Home value ~$525k after expected Realtor fees if we were to sell Retirement Goal 50 years old Current Savings Rate/year: $11k into 529 $30k into 401K's (not including company matching) $8k into traditional IRA $50k into brokerage account Current Expenses/year $48k Expected Expenses in retirement (in todays dollars) pre age 75. Note: this amount is what I would need AFTER tax!! $68k: This accounts for health care and a travel budget Expected Expenses in retirement (in todays dollars) post age 75. Note: this amount is what I would need AFTER tax!! $53k: This accounts for lower health care and a small travel budget Expected Inflation: I switch between 4 and 4.5% in my models Growth rate: Pre retirement: Goal 7.5% Standard Deviation: Pre retirement: Goal 10.5% Growth rate: Post retirement: Goal 6.5% Standard Deviation: Post retirement: Goal 9.5% Pension: My wife and I will both be getting a tiny pension from an old company we worked for. I expect maybe $800 a month in todays dollars from this. Social Security: For now I model $0 Expected Savings Rate per year for retirement: (note this is SIGNIFICANTLY less than we are saving now but I want to be conservative in the model in case one of us loses our job) $30k Downsizing in retirement: We have a big house and would not be adverse to downsizing(and as such lowering retirement expenses). Initial goal though would be to not have to downsize though and stick with the above expense models. Death Approx. Shooting for early 90's for both of us Money Left Over when dead: The goal is to pass the house on. (ie, the money can run out when we do) Last edited by maldini; 10-05-2007 at 02:45 PM. Reason: Adding more info for clarity |
|
|
|
|
|
#2 |
|
Thinks s/he gets paid by the post
![]() ![]() ![]() ![]() ![]() ![]() Join Date: May 2005
Posts: 3,050
|
Somebody else might do the numbers, but it looks like you have things well in hand...
And welcome aboard. |
|
|
|
|
|
#3 |
|
Moderator
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Apr 2006
Posts: 1,774
|
Wow! You're doing great. In fact, it seems like you could jump earlier if you wanted to.
__________________
You should not assume that I have a clue about anything I post. If you need a lawyer, go get your own. |
|
|
|
|
|
#4 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Feb 2007
Posts: 87
|
Welcome Maldini
Welcome Maldini -
When reading about your age, your income, your accounts, your allocations, and your expenses, I am amazed how closely we mirror each other. I almost could have written your post, except I have 2 kids (and so, double the 529 account amounts). But other than that, we're two peas in a pod. I'm just guessing about you, but I believe for myself I'm on target to retire in about 5-6 years. Unless anything major happens, I bet you'll make your goal before 50, or perhaps even earlier if the markets are kind to us. Congrats on having the focus and wherewithall to be where you are before age 40. Charlotte |
|
|
|
|
|
#5 | |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2007
Posts: 67
|
Quote:
The scary thing for me is running the model one time with an inflation rate of 4% and seeing a ton of money left in my 90's and then running it again with an inflation rate of 5% and seeing the money run out in my 80's. Just makes me a bit scared is all. I really do appreciate this forum and the feedback I can get. |
|
|
|
|
|
|
#6 |
|
Full time employment: Posting here.
![]() ![]() ![]() ![]() ![]() Join Date: Feb 2007
Posts: 642
|
Welcome!
__________________
Make no mistake, my friend, it takes more than money to make men rich. - A. P. Gouthey |
|
|
|
|
|
#7 | |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2007
Posts: 67
|
Quote:
you guys are making me feel better already! As finances of this detail are not the type of thing you can discuss with work mates or even friends/family, its sometimes hard to get a read to whether our goals are achievable. I am keeping my fingers crossed and will keep saving as much as we can until our inevitable drop in salary (we both work for high tech firms that are on semi life support). This is one of the reasons I try and model a much smaller savings rate than we currently achieve. Maldini |
|
|
|
|
|
|
#8 |
|
Thinks s/he gets paid by the post
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Jul 2006
Posts: 1,515
|
Maldini, welcome to the Board! I'm impressed that, unlike many newbies, you present precisely the information necessary to enable old timers to make a good asssessment of your ability to FIRE (which you most certainly can).
Andy, should this be a template for others to use? |
|
|
|
|
|
#9 | |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2007
Posts: 67
|
Quote:
What is FIRE (sorry as you said I am newbie)... |
|
|
|
|
|
|
#10 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2004
Posts: 198
|
A couple quick things. Your expenses right now are 48k per year, but are expected to go to 68k per year when you retire. Why the 20k jump? I've heard that health care for a family may be around $1k per month right now (which accounts for $12k), but would travel take up the other $8k? Or is that just a conservative number?
You have $1.3M invested + 500k in home value. Now I know you said you did want to keep your home. But theoretically you could do the following: Sell your home ($1.3M + $500k = $1.8M) Buy a new 2.5k square foot home with 3 acres in Kentucky/other lower class place for $200k (actually you could get it for less, but lets just call it $200k) ($1.8M - $200k = $1.6M) Retire ($1.6M * .04 = $64k) So with your current funds listed (and I rounded down) you could retire now with $64k per year. It's more than your current expenses in a cheaper area, and you'd have an extra 10 years of retirement. Personally I'd love to retire 10 years earlier if it meant I just needed a cheaper home? Anyway, it's certainly your choice, but I thought I'd point it out. |
|
|
|
|
|
#11 | |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: May 2007
Posts: 119
|
Quote:
FIRECalc: A different kind of retirement calculator |
|
|
|
|
|
|
#12 |
|
Thinks s/he gets paid by the post
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Feb 2005
Location: Mississippi
Posts: 3,188
|
Hey man, can you spare a $1 for a cup of coffee? Nice portfolio for your age. You should have plenty to spare when you reach 50. I would do it sooner if I were you.
Best of luck!
__________________
The born loser. |
|
|
|
|
|
#13 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: May 2007
Posts: 119
|
Financially Independent / Retire Early
Here's a summary of some of the common slang you'll see here... http://www.early-retirement.org/foru...rum-19058.html |
|
|
|
|
|
#14 | |
|
Give me a museum and I'll fill it. (Picasso)
Give me a forum ... ![]() ![]() ![]() ![]() ![]() ![]() ![]() Join Date: Mar 2003
Posts: 9,226
|
Quote:
I suppose if I were single and had no kids, I would make such a move in a heartbeat (probably to somewhere other tahn KY). But I am married with two kids and have aging parents nearby. No can do, and OP is probably in the same/similar boat.
__________________
“When you realize that you are one of the rare few who observe moral principles in their relationships with others, there is a temptation to sink into amorality, not out of conviction or pleasure but simply to avoid further pain, because there is no greater suffering than being an angel in hell, whereas a devil feels at home wherever he goes.” – Martin Page, How I Became Stupid |
|
|
|
|
|
|
#15 | |||
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2007
Posts: 67
|
Quote:
1) To live the exact same life style today in retirement 2) Add $1k a month for health care 3) Add a travel budget (which is the remainder). A single nice cruise could eat that up. In general though I do think its conservative because it does not take into account the expenses my daughter is using out of the 48k. Quote:
If we do downsize some day, we figure it will get us ~$150k in todays $'s. Quote:
I tend to think of things in terms of growth and inflation. What does the 4% withdrawal rule use for the difference between the expected growth and expected inflation? Thank you so much for the help! Maldini |
|||
|
|
|
|
|
#16 |
|
Thinks s/he gets paid by the post
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Jun 2006
Location: Boise
Posts: 1,331
|
FIRE = Financial Independence / Retire Early
Just looking at your numbers I think you're certainly in the ballpark. Your $1.3M will most likely double over the next decade, so you'll be at $2.6M or so. At 4% inflation for 10 years your $68K retirement budget will grow to just about $100K. $100K on $2.6M is about a 3.85% withdrawal rate, which for 40 years is about 96% successful historically. One thing you don't mention is your asset allocation. It looks like you are 100% stocks. The 96% success rate is assuming 75% stocks; increasing to 100% decreases the survivability slightly to 95%. For a 40 year period I believe the sweet spot is about 80% stocks / 20% bonds. If you were to downsize the house that might shave a year or two off, depending on the particulars. Also, depending on how much you spend on your daughter between now and then, college/wedding/launching expenses, could play a minor role. 2Cor521
__________________
"At times the world can seem an unfriendly and sinister place, but believe us when we say there is much more good in it than bad. All you have to do is look hard enough, and what might seem to be a series of unfortunate events, may in fact be the first steps of a journey." Violet Baudelaire. |
|
|
|
|
|
#17 | |
|
Thinks s/he gets paid by the post
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Jun 2006
Location: Boise
Posts: 1,331
|
Quote:
Check out the posts in the Best of the Boards Forum to learn about the 4% rule: http://www.early-retirement.org/forums/f35/ 2Cor521
__________________
"At times the world can seem an unfriendly and sinister place, but believe us when we say there is much more good in it than bad. All you have to do is look hard enough, and what might seem to be a series of unfortunate events, may in fact be the first steps of a journey." Violet Baudelaire. |
|
|
|
|
|
|
#18 | |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2007
Posts: 67
|
Quote:
I have some balanced funds in my portfolio which give me some bond exposure. Rough guess would be 15% of total portfolio is in bonds. |
|
|
|
|
|
|
#19 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Aug 2006
Location: athens
Posts: 485
|
Welcome Maldini,
You're out of the gate like a race horse! One question: Where did you come up with the growth and std. dev. numbers? And I'm just curious: what age did you start saving so aggressively and what convinced you to do it? So many people making high incomes in expensive areas spend a lot on life style, although I suppose $230000 income does give you some flexibility.
__________________
Can't you see yourself in the nursing home saying, " Darn! Wish I'd spent more time at the office instead of wasting time with family and friends." |
|
|
|
|
|
#20 |
|
Recycles dryer sheets
![]() ![]() ![]() ![]() Join Date: Oct 2007
Posts: 67
|