Howard won $200,000 (after taxes) after a weekend of gambling. Howard is 36 and would like to
Question:
Howard won $200,000 (after taxes) after a weekend of gambling. Howard is 36 and would like to save this money for his retirement. He wants to retire at the age of 65.
On Microsoft Excel, make a portfolio for Howard for the next 29 years. The portfolio should include a breakdown of how much Howard has and in which investment for the next 29 years (by investment type) Examples include: Traditional IRA or Roth IRA?
How much is the small cap stocks and large cap stocks in the IRA? How much are the junk bonds, etc.?
The portfolio should also include Howard's final amount for when he retires. Please take into consideration the risks and taxes involved. For capital gains tax in the beginning, use 15% and then you can adjust it to 20% if need be. Make sure to take note of the assumptions you may have about the rate of return for each of the investments.Do not forget that the structure of the portfolio should present the information in a logical way.
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe