Question

In: Accounting

Question You are provided with the following data for a three-sector LUSE portfolio (P) and the...

Question
You are provided with the following data for a three-sector LUSE portfolio (P) and the benchmark (B):

Sector Weight (P) Weight (B) Return (P) Retn (B)
Energy          50%        50%        18%           10%
Health Care 30%       20%         −3%            −2%
Financials    20%         30%         10%           12%

Required:
a) Determine the allocation contribution of the following:
i. Energy sector
ii. Health sector
iii. Financials sector
[06 Marks]

b) What was the fund managers’ contribution to the portfolio performance due to security selection for the:
i. Energy sector
ii. Health sector
iii. Financials sector
[06 Marks]

c) How did the portfolio perform in comparison to the benchmark?
[04 Marks]

d) What were the main causes of the difference in performance between the two?
[04 Marks]
[Total: 20 Marks]

Solutions

Expert Solution

(a)

Allocation contribution Portfolio Benchmark
Energy 9% 5%
(18*50%) (10*50%)
Health care -0.90% -0.40%
(-3*30%) (-2*20%)
Financials 2% 3.60%
(10*20%) (12*30%)
(b)
Allocation contribution Performance
Energy 4%
( 9% - 5%)
Health care -0.50%
( -0.9% - ( -0.4%) )
Financials -1.60%
( 2% - 3.6%)
(c)
Allocation contribution Portfolio Benchmark
Energy 9% 5%
(18*50%) (10*50%)
Health care -0.90% -0.40%
(-3*30%) (-2*20%)
Financials 2% 3.60%
(10*20%) (12*30%)
Overall performance 10.10% 8.20%

The performance of the portfolio on overall basis is better than benchmark as the overall performance of porfolio is 10.10% which is higher than the overall performance of becnch i.e 8.2%.

(d) The main causes for the differences

  1. Difference in the sector allocation of the weights.
  2. Difference in the performance represented by the returns .

Related Solutions

You are provided with the following data for a three-sector LUSE portfolio (P) and the benchmark...
You are provided with the following data for a three-sector LUSE portfolio (P) and the benchmark (B): Sector              Weight (P)        Weight (B)        Return (P)         Return (B) Energy              50%                 50%                  18%                  10% Health Care       30%                  20%                  −3%                 −2% Financials         20%                  30%                  10%                  12% Required: Determine the allocation contribution of the following: Energy sector Health sector Financials sector [06 Marks] What was the fund managers’ contribution to the portfolio performance due to security selection for the: Energy sector Health sector Financials sector...
You have been provided the following data on the securities of three firms, the market portfolio,...
You have been provided the following data on the securities of three firms, the market portfolio, and the risk-free asset: a. Fill in the missing values in the table. (Leave no cells blank - be certain to enter 0 wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Security Expected Return Standard Deviation Correlation* Beta Firm A .105 .36 .80 Firm B .145 .55 1.35 Firm C .165 .60 .40 The market...
You have been provided the following data on the securities of three firms, the market portfolio,...
You have been provided the following data on the securities of three firms, the market portfolio, and the risk-free asset: a. Fill in the missing values in the table. (Leave no cells blank - be certain to enter 0 wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Security Expected Return Standard Deviation Correlation* Beta Firm A .104 .35 .81 Firm B .144 .54 1.36 Firm C .164 .61 .39 The market...
You have been provided the following data on the securities of three firms, the market portfolio,...
You have been provided the following data on the securities of three firms, the market portfolio, and the risk-free asset: a. Fill in the missing values in the table. (Leave no cells blank - be certain to enter 0 wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Security Expected Return Standard Deviation Correlation* Beta Firm A .101 .32 _____ .84 Firm B .141 _____ .51 1.39 Firm C .161 .64 .36...
You have been provided the following data on the securities of three firms and the market:...
You have been provided the following data on the securities of three firms and the market: Security E[Rj] sj rjM bj Firm A 0.13 .12 ? .90 Firm B 0.16 ? 0.40 1.10 Firm C 0.25 0.24 0.75 ? Market 0.15 0.10 1 1 Risk-free 0.05 0 0 0 Assume the CAPM holds true. Fill in the missing values in the table. 0.9 = (rjM)(0.12) / 0.10 ri,m= .75 bj     = (rjM)(sj) / sm = .4 (sj) / .10...
The following information is for the next three questions. Investor P has the following portfolio: Stock...
The following information is for the next three questions. Investor P has the following portfolio: Stock Amount Return Beta A 10,000 10% 1.2 B 30,000 12% 0.8 C 20,000 15% 1.4 D 40,000 20% 2.0 01 - What are the weights of these four stocks in the portfolio? A. w1= 20%, w2= 30% w3 = 20% w4= 10% B. w1= 10%, w2= 40% w3 = 20% w4= 10% C. w1= 10%, w2= 30% w3 = 20% w4= 40% D. w1=...
You have been provided with the following data about the securities of three firms, the market...
You have been provided with the following data about the securities of three firms, the market portfolio, and the risk-free asset: Security Expected return Standard deviation Correlation with the market portfolio Beta Firm A 0.10 0.31 ? (a) 0.85 Firm B 0.14 ?(b) 0.50 1.40 Firm C 0.16 0.65 0.35 ?(c) The market portfolio 0.12 0.20 ?(d) ?(e) The risk-free asset 0.05 ?(f) ?(g) ?(h) Fill in the missing values in the table. Show your work please. Is the stock...
S&P Enterprises has provided data from the first three months of the year. The Controller has...
S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell on the...
QUESTION 4: You have been provided with the credit portfolio footnote disclosure of JP Morgan Chase...
QUESTION 4: You have been provided with the credit portfolio footnote disclosure of JP Morgan Chase from their 2017 annual report. Answer the following: You see an amount of ($291,319 )million under the column titled Derivative netting adjustments. Describe what is being “netted” for financial statement purposes. (15 points) Explain how derivative notional principal (contract amounts) are reflected in the financial statements. (5 points)
The financial data for a corporation is provided to calculate all the following question. Most recent...
The financial data for a corporation is provided to calculate all the following question. Most recent annual common dividend $4.00 Today’s common stock price $50.00 U.S. Treasury 10y annual rate 3 percent Market risk premium 5 percent Equity Risk Premium on Bond Yield 10 percent Number of common shares outstanding 2.5 million Today’s preferred stock price $100.00 Fixed preferred dividend $8.00 Constant growth rate 6 percent Beta β 2.0 Floatation costs for Preferred and common stock issuance 7 percent Market...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT