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
Get step-by-step solutions from verified subject matter experts
