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)
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: