Question: The five selected stocks are Apple , Amazon, Disney, Microsoft, and Google . The income for calculations will be $10,000. In an Excel spreadsheet, detail

The five selected stocks are Apple, Amazon, Disney, Microsoft, and Google. The income for calculations will be $10,000.

"In an Excel spreadsheet, detail the returns on five selected stocks that you will use as the basis for creating wealth required to support your personal financial initiatives. Select five key stocks and determine their expected return from finance.yahoo.com Presume you would invest 20% equally in these stocks and average the return. Calculate how much you would have to deposit each year until retirement (34 years) to fund all of your initiatives assuming the rate of return on these equities is constant."

-Please show work in an Excel worksheet with the above information

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!