Compute the portfolio return, the portfolio beta and the expected return of the portfolio based on the
Fantastic news! We've Found the answer you've been seeking!
Question:
Compute the portfolio return, the portfolio beta and the expected return of the portfolio based on the CAPM model.Did the portfolio over or under perform?
Transcribed Image Text:
Stock Portfolio Name Shares Price 7/1/2014 Price EPS Dividend Beta 7/1/2015 Progressive 300 $25.48 $28.44 $2.24 $0.69 0.87 Corp. Medtronic 250 $63.91 $74.08 $2.15 $1.52 1.44 Starbucks 600 $39.10 $53.89 $1.78 $0.64 0.87 Berkshire Hath - 100 $127.24 $137.52 $7.28 $0.00 0.29 B Procter & 200 $79.28 $79.72 $2.44 $2.65 1.00 Gamble Visa, Inc. 125 $53.17 $67.85 $2.42 $0.48 0.85 PACCAR 200 $63.78 $64.59 $4.47 $0.96 1.32 Microsoft 100 $41.87 $44.45 $1.48 $1.44 0.87 Rangold 100 $84.59 $65.03 $2.23 $0.60 0.11 Pioneer Nat Res 200 $228.75 $136.23 $3.40 $0.08 0.52 Amgen 150 $120.31 $154.99 $7.55 $3.16 1.01 Coca-Cola 400 $42.29 $39.49 $1.71 $1.32 0.96 Bristol-Meyers 475 $48.12 $67.67 $1.07 $1.48 1.06 Squibb Maximus 125 $42.85 $66.14 $2.37 $0.18 3.66 Starwood 200 $81.50 $82.00 $3.29 $1.50 0.91 J2 Global 200 $52.03 $68.01 $2.50 $1.23 1.44 Walmart 300 $75.28 $71.88 $4.79 $1.96 0.87 General Mills 150 $52.90 $57.09 $2.11 $1.76 0.71 Apple 250 $93.52 $126.60 $8.65 $2.08 1.09 Home Depot 450 $81.82 $112.07 $5.13 $2.36 1.04 Monsanto 250 $124.30 $107.66 $5.41 $2.16 1.08 Exxon 125 $101.36 $82.37 $5.62 $2.92 0.93 Global Robotics 200 $28.22 $26.05 $0.00 $0.00 1.95 Nike 200 $78.00 $109.43 $3.95 $1.12 0.72 Toyota 425 $122.26 $133.60 $11.76 $4.02 0.55 Pfizer 200 $30.08 $33.69 $1.41 $1.12 1.08 The return on the market has been 8.15% and the current risk-free rate is 2.05%. Stock Portfolio Name Shares Price 7/1/2014 Price EPS Dividend Beta 7/1/2015 Progressive 300 $25.48 $28.44 $2.24 $0.69 0.87 Corp. Medtronic 250 $63.91 $74.08 $2.15 $1.52 1.44 Starbucks 600 $39.10 $53.89 $1.78 $0.64 0.87 Berkshire Hath - 100 $127.24 $137.52 $7.28 $0.00 0.29 B Procter & 200 $79.28 $79.72 $2.44 $2.65 1.00 Gamble Visa, Inc. 125 $53.17 $67.85 $2.42 $0.48 0.85 PACCAR 200 $63.78 $64.59 $4.47 $0.96 1.32 Microsoft 100 $41.87 $44.45 $1.48 $1.44 0.87 Rangold 100 $84.59 $65.03 $2.23 $0.60 0.11 Pioneer Nat Res 200 $228.75 $136.23 $3.40 $0.08 0.52 Amgen 150 $120.31 $154.99 $7.55 $3.16 1.01 Coca-Cola 400 $42.29 $39.49 $1.71 $1.32 0.96 Bristol-Meyers 475 $48.12 $67.67 $1.07 $1.48 1.06 Squibb Maximus 125 $42.85 $66.14 $2.37 $0.18 3.66 Starwood 200 $81.50 $82.00 $3.29 $1.50 0.91 J2 Global 200 $52.03 $68.01 $2.50 $1.23 1.44 Walmart 300 $75.28 $71.88 $4.79 $1.96 0.87 General Mills 150 $52.90 $57.09 $2.11 $1.76 0.71 Apple 250 $93.52 $126.60 $8.65 $2.08 1.09 Home Depot 450 $81.82 $112.07 $5.13 $2.36 1.04 Monsanto 250 $124.30 $107.66 $5.41 $2.16 1.08 Exxon 125 $101.36 $82.37 $5.62 $2.92 0.93 Global Robotics 200 $28.22 $26.05 $0.00 $0.00 1.95 Nike 200 $78.00 $109.43 $3.95 $1.12 0.72 Toyota 425 $122.26 $133.60 $11.76 $4.02 0.55 Pfizer 200 $30.08 $33.69 $1.41 $1.12 1.08 The return on the market has been 8.15% and the current risk-free rate is 2.05%.
Expert Answer:
Answer rating: 100% (QA)
To calculate the portfolio return portfolio beta and expected return of the portfolio based on the CAPM model well use the following formulas Portfoli... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
My question is how to write the code in WareHouse.java This is WareHouse.java package warehouse; /* * * This class implements a warehouse on a Hash Table like structure, * where each entry of the...
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
Compute the expected number of cars arriving in Problem 14-15 using the expected value formula. Compare this with the results obtained in the simulation. Problem 14-15 The number of cars arriving per...
-
Gamma Company adjusts its accounts at the end of each month. The following information has been assembled in order to prepare the required adjusting entries at December 31:1. A one-year bank loan of...
-
As a result of a casualty event, Theresa disposed of tangible personal property (a 1231 asset) at a realized and recognized loss. At the time of the casualty, the property was worth substantially...
-
Describe the differences among Black Belts, Green Belts, and Master Black Belts in a Six Sigma program.
-
Compute the correlation coefficient for the data below, saved, and interpret the coefficient. We are examining the relationship between the number of years of training that doctors have and their...
-
On July 1, 2012, Kim Wheeler established an interior decorating business, Aztec Designs. During the month, Kim completed the following transactions related to the business: July 1. Kim transferred...
-
A Michelson interferometer is used to measure the wavelength of light emitted from a monochromatic source. As the adjustable mirror is slowly moved through a distance DA = 0.0265 mm, an observer...
-
A counter-current gas-absorption column is to be designed to remove CO 2 from an inert gas stream by reaction with an amine solution at 20C. At this temperature, CO 2 reacts with the amine according...
-
3) Can the (R,r) conventional (standard) space be made? Show me.
-
Discuss with a close adult friend or relative his or her estate plans including the use of a will, trusts, lifetime gifting, a living will, and/or a durable power of attorney. Write a one-page report...
-
Babe Ruth was paid $80,000 in 1931. When it was pointed out that this was morethan President Hoover made, he replied, I had a better year than he did. Using a base 100 in 1967, the CPI was 45.6 in...
-
Make a List of typical items paid for through borrowing. Share your list with friends and relatives and ask them to quickly categorize the debts as good or bad. Record their reactions. Then explain...
-
According to this chapter, "planning and budgeting require control." Talk to several friends, family, or acquaintances about the strategies they routinely or occasionally use to control spending and...
-
On January 11, 2008, the value of the Dow Jones Industrial Average was 12,606.30, and the divisor was 0.123017848. Explain why you either agree or disagree with these statements: a. The average price...
-
Write a cause and effect paragraph on the given topic. The paragraph must contain the Topic Sentence, Example Sentence, Analysis Sentence, and Linking Sentence. Causes of bullying in school and its...
-
Suppose you are comparing just two means. Among the possible statistics you could use is the difference in means, the MAD, or the max min (the difference between the largest mean and the smallest...
-
Exhibit 5.16 presents risk ratios for Coca-Cola for Year 1 through Year 3. REQUIRED a. Assess the changes in the short-term liquidity risk of Coca-Cola between Year 1 and Year 3. b. Assess the...
-
Boston Scientific, a medical device manufacturer, reported net income (amounts in millions) of $1,062 on sales of $5,624 during Year 4. Interest expense totaled $64. The income tax rate was 35...
-
Selected financial data for Georgia-Pacific Corporation, a forest products and paper firm, appear in Exhibit 4.28. REQUIRED a. In which years did financial leverage work to the advantage of the...
-
_____________ is also used as requirement finding and feasibility testing tool. (a) Prototype (b) Reports (c) System (d) Procedure
-
A prototype can be ___________. (a) Complete system with partial requirements (b) Working model (c) Full-fledged system (d) All of these
-
Which of the following systems development approach is adopted if information requirements are not well defined? (a) SDLC (b) Prototype (c) Structured approach (d) Agile
Study smarter with the SolutionInn App