Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here is the question that I need help with : In an Excel spreadsheet, detail the returns on five selected stocks that you will use

Here is the question that I need help with : "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, PENN, SQ, PANW, and FB. I am confused how to get the Return and average rate of return and just how to set this up in general. I will say that my goal amount for retirement savings that I want to make with these investments is $2,000,000 (so 400,000 for each stock?).

I have attached what I have for the table so far. I am just confused what to do from here and how to figure out the values. I need a push in the right direction. This really needs to have been done like 3 days ago but I am confused. I know how to answer the question regarding why I chose the stocks, but confused on how to get the actual values, like how much I need to invest every year.

Thank you

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Finance Markets Investments and Financial Management

Authors: Melicher Ronald, Norton Edgar

15th edition

9781118800720, 1118492676, 1118800729, 978-1118492673

More Books

Students also viewed these Finance questions