Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. in an excel spreadsheet, detail the returns on fiv

In an Excel spreadsheet, detail the returns on five selected stocks (Netflix, Amazon, Starbucks, Microsoft,...

60.1K

Verified Solution

Question

Finance

  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.

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!
Become a Member

Other questions asked by students