Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started