1. In an Excel spreadsheet, detail the returns on five selected stocks (Netflix, Amazon, Starbucks, Microsoft, American Airlines). Determine their yearly expected return from finance.yahoo.com.
2. Calculate how much will you need to invest monthly in each stock.
3. With the monthly payment, calculate the yearly total of investment for each stock (# x 12)
4. With this number, calculate the total yearly investment (the sum of the 5 stocks) A+B+C+D+E
5. Compare the amount to this retirement plan of $95,423. WIll you need more money? Will you be economically solvent?

****Presume you would invest 20% equally in these stocks and average the return.

You will need to calculate monthly payments. Retirement period 27 years (324 months). Use a TVM calculator for the monthly investment for each stock. For compounded select *monthly, for future value (FV) insert $19.084.6 ($95, 423 - 20% = 19,084.6 ) this number is the investment for each stock

please make sure to calculate it properly. Assume a 5-year rate return.