I need help with Investment Scenario for job
Hi I have an investment scenario I am working on. If anyone with knowledge on the subject is willing to help me answering these questions, I would appreciate it.
Married couple:
Name person 1 person 2
Age 56 56
Employment Doctor Professor
Annual Income $195k $75k
Taxable Portfolio : $1 mil
401k – Person1 : $500k
401k – Person 2 : $250k
They two people would like to retire at age 67 and believe they need $150k per year in retirement to achieve their goal (this is in addition to their anticipated social security of $40k).
1) What spend rate (as a percentage of total assets) would you recommend in retirement and why?
2) How would you invest the portfolios differently to maximize tax efficiency?
3) How much will the couple need at age 67 to meet their cash flow objectives?
4) At age 67, from which buckets would they initially draw money first and why? Would this change at all after age 70.5?
9) At what rate would the portfolios have to grow to meet their cash flow objectives in 11 years if they each are adding $23k per year to their 401ks?
Can anyone tell me how you go about predicting life expectancy and therefore how many years they will need to receive $150k cash flow?
Currently their total assets between their portfolios are $1,750,000. They will both add $23,000k a year which means after 11 years person 1’s 401k will be $753,000 and person 2’s will be $503,000. Their total asset 11 years from now when they retire at 67 would be $1,000,000 + $753k + 503k = $2,256,000.
$2,256,000/150k cash flow per yr = 15 years which means without taking into account any sort of capital appreciation, they would have enough money to cover 15 years of life after retirement which puts them at 82 (which I believe is around average life expectancy for a woman in the US).
Haha this is almost exactly what I do for a living. Will do a full response over the weekend, but any idea on their social security or other retirement income like pension for the professor or buyout for the doctor if he sells his practice? Also the wealthy tend to live longer than the average American so we model 90 for men and 92 for women
going to answer the questions within the quote, not a html code expert. @"AndyLouis" feel free to come behind me & clean it up.
well done, sb'd x10
I think thebrofessor pretty much got you the information you need, but I've added some comments below. For #3, I think OP is saying they would need $150k per year in retirement in addition to what they get from social security.
3) How much will the couple need at age 67 to meet their cash flow objectives?
This depends on your assumptions for life span, rate of return, and inflation. They would need $2.46M assuming they live to age 90, portfolio return during retirement is 6%, and inflation is 3%. Go with the 4% rule to error on the conservative side though.
N 23 PMT $150,000 I 3.0% FV 0 PV = $2,466,541
9) At what rate would the portfolios have to grow to meet their cash flow objectives in 11 years if they each are adding $23k per year to their 401ks?
Assuming their targeted future value is the $2.46M we calculated in #3, they would need a return of 5.4% on the $46k saved per year over the 11 year period from age 56 to age 67.
PV $(1,750,000) N 11 PMT $46,000 FV $2,466,541 I = 5.4%
I like your style. we use 4% inflation because what the gummint prints and what is actually happening are different things. gas, food & healthcare go up much faster than CPI, but either way I like what you did here.
4) At age 67, from which buckets would they initially draw money first and why? Would this change at all after age 70.5?
Assuming their 401k accounts have to be converted to a rollover IRA in retirement, age 70.5 would trigger RMD. At this point, the retirement account loses a bit of the "tax-deferred" luster and allocation should be rebalanced accordingly.
Fugiat cupiditate dolores earum id error. Possimus saepe sint fugiat repudiandae vel tempora expedita.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...