Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, In an Excel spreadsheet, detail the returns on five selected stocks that you will use as the basis for creating wealth required to support

Hi,

"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."

I do not have any more instructions on this and I'm not sure what needs to be done. Please assist using the above information. My goal is to retire with $1 million in savings. The stocks that I want to use are: Amazon, Apple Inc., Disney, Proctor & Gamble, and Pfizer Inc. Retirement would be 35 years from now.

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

International financial management

Authors: Jeff Madura

12th edition

1133947832, 978-1305195011, 978-1133947837

More Books

Students also viewed these Finance questions