Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mutual Fund (Ready Made Portfolio) HomeworkEnter your information in and submit an Excel spreadsheet for this assignment.Buying a Stock PortfolioRequired:1. Create a portfolio containing two

Mutual Fund (Ready Made Portfolio) HomeworkEnter your information in and submit an Excel spreadsheet for this assignment.Buying a Stock PortfolioRequired:1. Create a portfolio containing two shares of each of the stocks in the Dow Jones IndustrialAverage. Assume you pay $0 in commissions to your broker for each trade (many brokersnow provide zero commission trades). Create a table using Excel showing: company name,company symbol, price per share, date for the price, and the total amount spent to createthis portfolio.2. Because of the way the DJIA is constructed, you are somewhat duplicating the index. I saysomewhat because there isnt any adjustment for prior splits or dividends in what you puttogether.a. What type of weighting is used to construct the DJIA price or market value?b. Identify the highest price per share stock in the DJIAc. Identify the lowest price per share stock in the DJIAd. Which of these two stocks will have a greater impact on changes to the value of DJIAwhen the price of that stock changes?Buying a Ready Made PortfolioIn this part of the assignment, you should see the advantages of buying a ready-made portfolio ratherthan purchasing individual stocksRequired:1. Using information from the first part of this assignment - what is the total spent on purchasingthe portfolio made up of two shares each of DJIA component companies?2. DIA is an ETF (Exchange Traded Fund) that replicates the Dow Jones Industrial Average. Assumeyou pay no commission to make a DIA purchase with no limit on the number of shares in thesingle purchase. Assume you trade through a broker that allows the purchase of fractionalshares. Create a table showing:a. Symbol, price per share, NAV per share, and date when your data was gathered for DIA.b. Assume you invest the same amount of money in the ETF as you would spendconstructing the portfolio from question 1. How many shares of the ETF can youpurchase?3. Comment on the differences between buying individual securities versus a ready-made portfolioof the same stocks, and include answers to the following questions.What if you dont have enough money to buy the individual shares of stock in order toconstruct a portfolio made up of the DJIA stocks?

my stocks are apple, best buy, coke, and starbucks

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

Behavioral Finance And Wealth Management

Authors: Michael M. Pompian

2nd Edition

1118014324, 978-1118014325

More Books

Students also viewed these Finance questions

Question

Know how procedures protect an organization

Answered: 1 week ago