The actual returns of the S&P, Tbill and Tbonds, corp bonds and real estate, since 1928 are in the attached file. This has been sourced from the site for Prof Damodaran FAQ question: wont the answer be different since it will change when i open it The Assignment answer: i expect that using the random function even a couple of dozen times (since there is only 90 odd years of history) the average Your team works at a financial advisory firm and is asked to work with a client, Ms Christie, who has will be relatively stable. retired and has 400K in liquid assets. She is 65 years old. again i care about the analysis and model and any out of the box thinking you can bring to the issue please dont hesitate if you have any other questions To maintain a semblance of her prior lifestyle she needs to draw down 50K per year to complement social security and other pension payments. question: how can we set the formuala to get a non-negative number? answer: the random function is used to randomize the retirement year back in history. so a random function may result in your a) Based on actual data (use the random function to select different starting years, sampling 40 times), retiring in 1939 or 1972 or 1956 etc.. determine the average number of years she can continue to draw down 50K before she runs out of we need to do a simulation. what happens with your savings if you had invested in the market and the market returned whatever it money. actually did that year (data provided) figure out how frequently she might be broke before she dies? b) Second, since your client understands distribution (she took this course) and comes from a family of also see how much the frequency of going broke drops, if the cash spent is reduced septagenarians, she wants to know what is the maximum she can draw down, with 95% confidence, if hope this helps. this is a very realistic and non-academic assignment. she expects to live to 78. She is 65 now. The question is how does one count the number of years till the money goes negative. c) finally, any other advice you would like to offer Answer: please keep in mind that the money invested on the first year of retirement earns a return based on the return of that year in the market. so unless one is unlucky in retiring when thie market is about to crash, the one should be able to make do for many years. a simple example is that if the market returned 10% the year the person retired, then the market paid the retiree $40K on a 400K investment. so even if the drawdown is $50K, it should go a longish while. the purpose of the exercise is to make it vividly clear how much of financial security is random Question: I am wondering for the answer, do we just pick any year to work out an answer or does the answer need to account for all possibilities (starting year ranging from 1928--1998)? Answer: One has to account for more than one year. One can do it for all years (since the sample is not too big) OR use the random function for a few dozen years and take the average of that.. Again, please don't be scared about not having the 'right' answer. In life there is rarely such a thing. I look forward to your best thinking and work, maybe incorporating any tools and material we covered