Assume an investment advisor, Roy Dodson, is assisting a widowed client in determining a sustainable retirement withdrawal. The client is a 59-year-old woman who turns 60 in two months. She has $1,000,000 in a tax-deferred retirement account that will be the primary source of her retirement income. Roy has designed a portfolio for his client with returns he expects to be normally distributed with a mean of 8%% and standard deviation of 2% Withdrawals will be made at the beginning of each year on the client's birthday Roy assumes that the inflation rate will be 3%, based on long-term historic data. So if her withdrawal at the beginning of the first year is $40,000, her inflation-adjusted withdrawal at the beginning of the second year will be $41,200, her third year's withdrawal will be $42 436, and so on For his initial analysis, Roy wants to assume his client will live until age 90, In consultation with his client, he also wants to limit the chance that she will run out of money before her death to a maximum of 5% a. What is the maximum amount Roy should advise his client to withdraw on her 60th birthday? If she lives until age 90, how much should the client expect to leave to her heirs? b. Roy is now concerned about basing his analysis on the assumption that his client will live to age 90 After all, she is healthy and might live to be 110, or she could be ina car accident and die at age 62 To account for this uncertainty in the client's age at death, Roy would like to model the client's remaining life expectancy as a random variable between O and 50 years that follows a lognormal distribution with a mean of 20 and standard deviation of 10 (rounded to the nearest integer). Under this assumption, what is the maximum amount Roy should advise his client to withdraw on her 60th birthday and how much should the client expect to leave to her heirs? ( Hint Modify your spreadsheet to accommodate ages up to 110, and use a V/LookUP( ) function to return the client's ending balance in her randomly determined year of death) ( Roy is pleased to now be modeling the uncertainty in his client's life expectancy But he is now curious about limiting to See the chance that his client will run out of money before her death. In particular, he is wondering how sensitive the sustainable withdrawal amount is to changes in this 59% assumption. To answer this question, create an efficient frontier showing the maximum sustainable withdrawal amountas the chance of running out of money is varied from 10 to 10% How should Roy explain the meaning of this chart to his client? d Suppose Roy's client has three children and wants there to be a 9590 chance that they will each inherit at least $250,000 when she dies, Under this assumption, what is the maximum amount Roy should advise his client to withdraw on her 60th birthday, and how much should the client exped leave to her heirs
