Question: In an Excel spreadsheet, detail the returns on five selected stocks (Amazon, Walmart, Target, Wells Fargo and McDonalds) that you will use as the basis

In an Excel spreadsheet, detail the returns on five selected stocks (Amazon, Walmart, Target, Wells Fargo and McDonalds) 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. 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.

Provide commentary, summarize and describe your intentions. Explain your rationale for selecting the stocks in your portfolio, including your own risk tolerance and any considerations for diversification. Describe your opportunities and challenges with implementing your financial plan. Document the annual savings required to fund all of your financial goals according to your calculations. If there is a gap with the total amount you are able to realize based on your current income, develop and document a plan to supply the difference. Will you have to make changes? Indicate how you might revise your plans. Various alternatives may include finding another career position and increasing income, or purchasing a smaller home, curtailing retirement funds, or deriving savings elsewhere.

***Please provide written commentary with the above instructions above***

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!