In an Excel spreadsheet, detail the returns on five selected stocks (Netflix, Amazon, Starbucks, Microsoft,...
60.1K
Verified Solution
Link Copied!
Question
Finance
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.
Calculate how much will you need to invest monthly in each stock.
With the monthly payment, calculate the yearly total of investment for each stock (# x 12)
With this number, calculate the total yearly investment (the sum of the 5 stocks) A+B+C+D+E
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.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
