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