Complete in a Excel Spreadsheet

You are a financial advisor Chris, just recently won a jackpot playing slots in Las Vegas and earned $200,000 after taxes. Chris is 36 years old and wants to use this money for his retirement. Chris is an impulsive spender and knows that he will be unable to save any money from his future paychecks, so he is very dependent on the $200,000 for his retirement. He would like to retire at 65 years old.

Your assignment is to come up with a portfolio for Chris for the next 29 years. Your submission should include a breakdown of how much Chris has and in which investment for the next 29 years (by investment type. Ie - IRA, Roth IRA...then in your IRA, how much is large cap stock, small cap stocks, junk bonds, etc.). It should also include the final amount Chris will have at retirement. Consider risk, taxes, and other concepts discussed in class. Use 15% as a capital gains tax in the beginning and then adjust to 20% as needed. Make sure to note your assumptions about rate of return for each investment.