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
Determine their expected return from finance.yahoo.com.
Presume you would invest 20% equally in these stocks and average the return.
The objective is to develop an investment strategy, as a suggestion, with stocks of your choosing and/or mutual funds, which support your future financial needs.
Expected retirement: 30 years
| Stock | P/E Ratio | Price | Investment | Expected Return | ||
| Amazon | 132.71 | $93.50 | 20% | |||
| Tesla | 55.93 | $196.88 | 20% | |||
| Warner Bros. Discovery, Inc. | 13.44 | $15.55 | 20% | |||
| American Airlines Group, Inc. | 81.89 | $15.56 | 20% | |||
| Ford Motors | 6.35 | $11.88 | 20% |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
