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

 
Best Response

going to answer the questions within the quote, not a html code expert. @"AndyLouis" feel free to come behind me & clean it up.

dr0833:

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?

the simple answer to this is I would recommend they spend no more than 80-90k out of their retirement assets per year (the first year, with this growing in line with inflation every year). I recommend that range because 90k is roughly 4% based on your estimate of future value, and 80k is conservative, if they have emergencies, it's better to have a cushion.

2) How would you invest the portfolios differently to maximize tax efficiency?

the utility of asset location is overstated in my opinion. at this asset level, it's not going to make a huge difference in my opinion, only if they were in the AMT bracket would it matter. to answer this another way, the simple thing would be to put the taxable portfolio's fixed income in munis instead of corps/govvies and put all of the stocks in the IRA, but I personally believe this leaves the couple underexposed to equities given their high cash flow needs

3) How much will the couple need at age 67 to meet their cash flow objectives?

simple math would tell you 150k needed - 40k guaranteed = 110k shortfall / 4% = 2.75mm; this is using the 4% rule (by the way, I'm not going to write a dissertation on this, look this up on google), which is often cited because it's the highest percentage statistically you can withdraw from a balanced portfolio while protecting the purchasing power.

4) At age 67, from which buckets would they initially draw money first and why? Would this change at all after age 70.5?

ah, bucketing. a great concept that some claim can allow you to take an extra 1% a year, but really it's a behavioral thing. if you do anything other than rebalancing and taking cash from stuff that's done well/overvalued, you're trying to time the market, which we don't do. if the market hasn't moved, we do it pro rata, while trying to minimize short term cap gains, but otherwise we just rebalance and take cash from that (buy low, sell high)

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?

depends how you compound the money (annually, monthly, end of period, beginning of period, etc), so whatever convention you're used to/is recommended for the job, work backwards from the 2.75mm figure I gave you, account for the starting value (today's value), your financial calculator will do the rest.

Can anyone tell me how you go about predicting life expectancy and therefore how many years they will need to receive $150k cash flow?

look at mortality tables but realize the wealthy tend to live longer. we model 90 for men and 92 for female, which are high estimates, granted, but better safe than sorry.

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

 

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%

 

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.

 

Dolor autem et dolorum sunt ab esse. Repellat esse est enim eum cum. Sint numquam animi nostrum reiciendis vero. Officiis unde numquam voluptas illo optio vero ea. Voluptatem dolorem pariatur sint quasi et veritatis. Cupiditate fuga qui voluptatem.

Vitae dolorem fugiat vero quis aut. Et explicabo provident exercitationem. Explicabo odio possimus autem optio.

Dolor dolor nobis voluptas delectus. Dolor nostrum sunt est est voluptate. Sit nemo inventore molestias aut et modi. Sit nam et repudiandae aut nihil qui. Ut soluta optio quidem. Quasi ut excepturi saepe rem dignissimos.

Et illum suscipit voluptas eos quod at veniam et. Incidunt hic et repudiandae voluptatem id quidem.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Perella Weinberg Partners New 98.9%
  • Lazard Freres 01 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 05 97.7%
  • Perella Weinberg Partners New 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 06 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (148) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
GameTheory's picture
GameTheory
98.9
8
kanon's picture
kanon
98.9
9
numi's picture
numi
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”