Brothers, Mark and Mike Lalla want to plan for their retirement and need your ad

Question

Brothers, Mark and Mike Lalla want to plan for their retirement and need your advice.

Mark plans to travel extensively in the first 5 years of his retirement and will need $450,000 each year to do so. After that he will be able to live on $100,000 per year. Mark does not know how long he will live so once started, he needs to be able to withdraw the $100,000 each year forever.

Mike plans on having some income from a part time job in the first 5 years of his retirement so will only need $50,000 per year. He then plans on travelling lavishly for the next 6 years and will need $750,000 per year. He figures he will not live past that point so will not need any more funds.

Both men will retire next year and thus will need the first cash flow from his retirement fund at that time. If both can earn an 8% rate of return, calculate how much each brother will need today to realize his retirement dream.

Explanation / Answer

Mark
He needs $450,000 for 5 years and $100,000 for perpetuity
PMT = $450,000
Rate = 8%
Nper = 5
Present value (calculated in excel) = $1,796,719.52
Present value = $100,000/8% = $1,250,000.00
Total Money needed = $3,046,719.52

Mike
He needs $50,000 per year for 5 years and $750,000 for 6 years
PMT = $50,000
Rate = 8%
Nper = 5
Present value (calculated in excel) = $199,635.50
PMT = $750,000
Rate = 8%
Nper = 6
Present value (calculated in excel) = $3,467,159.75
Total money needed = $3,666,795.25

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.