Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

3.39 Rating (124 Votes )

There are 3 Steps involved in it

Step: 1

Creating a portfolio for Howard requires careful consideration of various factors such as risk tolerance investment horizon and tax implications Heres ... blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis And Decision Making

Authors: Christian Albright, Wayne Winston, Christopher Zappe

4th Edition

538476125, 978-0538476126

More Books

Students also viewed these Finance questions

Question

A 300N F 30% d 2 m Answered: 1 week ago

Answered: 1 week ago