Question: 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

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 to fund all of your initiatives assuming the rate of return on these equities is constant.Describe your rationale for selecting the stocks in your portfolio, including your own risk tolerance and any considerations for diversification.

My five stocks are : SBUX (stock price $74.17, rate of return 48.6%), FB (stock price $241.20, rate of return 19%), PENN (stock price $34.34, rate of return 17.46%), PANW (stock price $229.31, rate of return 8.29%), and SQ (stock price $105, rate of return 65.9%). The goal is to make $2,000,000 in the next 44 years. How do I go about finding the annual deposits I need to make for each company in order to reach my goal of $2 million in 44 years?

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!