Buying a Stock Portfolio Required: 1. Create a portfolio containing two shares of each of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Buying a Stock Portfolio Required: 1. Create a portfolio containing two shares of each of the stocks in the Dow Jones Industrial Average. Assume you pay $0 in commissions to your broker for each trade (many brokers now 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 create this portfolio. 2. Because of the way the DJIA is constructed, you are somewhat duplicating the lindex. I say somewhat because there isn't any adjustment for prior splits or dividends in what you put together. 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 DJIA c. Identify the lowest price per share stock in the DJIA d. Which of these two stocks will have a greater impact on changes to the value of DILA when the price of that stock changes? Buying a Ready Made Portfolio In this part of the assignment, you should see the advantages of buying a ready-made portfolio rather than purchasing individual stocks Required: 1. Using information from the first part of this assignment - what is the total spent on purchasing the portfolio made up of two shares each of DJIA component companies plus commissions? DIA is an ETF (Exchange Traded Fund) that replicates the Dow Jones Industrial Average. Assume you pay no commission to make a DIA purchase with no limit on the number of shares in the single purchase. Assume you trade through a broker that allows the purchase of fractional shares. Create a table showing: 2. 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 spend constructing the portfolio from question 1. How many shares of the ETF can you purchase? 3. Comment on the differences between buying individual securities versus a ready-made portfolio of the same stocks, and include answers to the following questions. a. What if you don't have enough money to buy the individual shares of stock in the DJIA? b. If shares of the Dow pay dividends, how many shares do you earn the income on in your constructed portfolio versus the ETF? Buying a Stock Portfolio Required: 1. Create a portfolio containing two shares of each of the stocks in the Dow Jones Industrial Average. Assume you pay $0 in commissions to your broker for each trade (many brokers now 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 create this portfolio. 2. Because of the way the DJIA is constructed, you are somewhat duplicating the lindex. I say somewhat because there isn't any adjustment for prior splits or dividends in what you put together. 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 DJIA c. Identify the lowest price per share stock in the DJIA d. Which of these two stocks will have a greater impact on changes to the value of DILA when the price of that stock changes? Buying a Ready Made Portfolio In this part of the assignment, you should see the advantages of buying a ready-made portfolio rather than purchasing individual stocks Required: 1. Using information from the first part of this assignment - what is the total spent on purchasing the portfolio made up of two shares each of DJIA component companies plus commissions? DIA is an ETF (Exchange Traded Fund) that replicates the Dow Jones Industrial Average. Assume you pay no commission to make a DIA purchase with no limit on the number of shares in the single purchase. Assume you trade through a broker that allows the purchase of fractional shares. Create a table showing: 2. 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 spend constructing the portfolio from question 1. How many shares of the ETF can you purchase? 3. Comment on the differences between buying individual securities versus a ready-made portfolio of the same stocks, and include answers to the following questions. a. What if you don't have enough money to buy the individual shares of stock in the DJIA? b. If shares of the Dow pay dividends, how many shares do you earn the income on in your constructed portfolio versus the ETF?
Expert Answer:
Answer rating: 100% (QA)
Buying a Stock Portfolio 1 Create a portfolio containing two shares of each of the stocks in the Dow Jones Industrial Average Assume you pay 0 in commissions to your broker for each trade many brokers ... View the full answer
Related Book For
Quantitative Analysis for Management
ISBN: 978-0132149112
11th Edition
Authors: Barry render, Ralph m. stair, Michael e. Hanna
Posted Date:
Students also viewed these finance questions
-
The figure shows the daily Dow Jones Industrial Average (DJIA) and its 30-day moving average from late July to early November. Use the figure to complete the following. (a) Approximate the absolute...
-
The monthly closing values of the Dow Jones Industrial Average (DJIA) for the period beginning in January 1950 are given in the file C02_02.xlsx. According to Wikipedia, the Dow Jones Industrial...
-
The file P02_05.xlsx contains monthly values of the Dow Jones Industrial Average from 1950 until recently. It also contains the percentage changes from month to month. (This file is used in an...
-
A new computer system allows your firm to more accurately monitor inventory and anticipate future inventory shortfalls. As a result, the firm feels more able to pare down its inventory levels. What...
-
Ultraviolet light is responsible for sun tanning. Find the wavelength (in nm) of an ultraviolet photon whose energy is 6.4 10-19 J.
-
The following table gives data on median salaries of full professors in statistics in research universities in the United States for the academic year 2007. a. Plot median salaries against years in...
-
On July 1, Chi Kong creates a petty cash fund with a balance of $300. During July, Elise Sautter, the fund custodian, signs the following petty cash tickets: Petty Cash Ticket Number 101 102 103...
-
XYZ Ltd. is a large retail company listed on a major stock exchange, and its reported net income for the year ended December 31, 2015, is $ 5 million. The earnings were announced to the public on...
-
After the Movement Control Order, people were allowed to dine inside the restaurants. A well-known fast-food restaurant in Sunway had three opinions for their customers to order their fast food: dine...
-
On January 1, 2023, Logan Limited had shares outstanding as follows: 6% cumulative preferred shares, $100 par value, 10,000 shares issued and outstanding $1,000,000 Common shares, 200,000 shares...
-
You, CPA, have completed the risk assessment process of Modern Chair Company (MCC) and have identified the following key risks relating to the financial statement audit for the year-end March 31,...
-
How do each of the basic business strategies (differentiation, cost leadership, and focus) relate to operations management?
-
How are a firms strategy and operations management interrelated?
-
Why is it important for organizations to control productivity?
-
What types of information are particularly important to an international firm?
-
How are operations management, productivity, and quality interrelated?
-
Z Water with the density of 1000 kg/m and dynamic viscosity of 1003-10-6 kg/ms is flowing in a narrow pipe (d = 5 mm). The average flow velocity is 0.4 m/s. () (a) Calculate the Reynolds number. (1...
-
Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...
-
Today's Electronics specializes in manufacturing modern electronic components. It also builds the equipment that produces the components. Phyllis Weinberger, who is responsible for advising the...
-
Mysti Farris (see Problem 1-19) is considering raising the selling price of each cue to $50 instead of $40. If this is done while the costs remain the same, what would the new break-even point be?...
-
Kathy Roniger, campus dietitian for a small Idaho college, is responsible for formulating a nutritious meal plan for students. For an evening meal, she feels that the following five meal-content...
-
Examine the Dollarama statement of cash flows. Suppose Dollarama's operating activities used, rather than provided, cash. Identify three things under the indirect method that could cause operating...
-
Which of the following is a misappropriation of assets? a. Classifying inventory held for resale as supplies. b. Investing cash and earning a 3 percent rate of return as opposed to paying off a loan...
-
Canada Wide Transportation (CWT) began 2020 with accounts receivable, inventory, and prepaid expenses totalling \(\$ 65,000\). At the end of the year, CWT had a total of \(\$ 78,000\) for these...
Study smarter with the SolutionInn App