Question

In: Finance

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 portfolio .12 .20
The risk-free asset .05


*With the market portfolio.

b-1. According to the CAPM, what is the expected return of Firm A's stock? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Expected return             

b-2. What is your investment recommendation for someone with a well-diversified portfolio?

Sell

Buy



b-3. According to the CAPM, what is the expected return of Firm B's stock? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Expected return             

b-4. What is your investment recommendation for someone with a well-diversified portfolio?

Sell

Buy



b-5. According to the CAPM, what is the expected return of Firm C's stock? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Expected return             

b-6. What is your investment recommendation for someone with a well-diversified portfolio?

Sell

Buy

Solutions

Expert Solution

Part 1

Solution (a) - Calculation of Missing figures

Formula to be used for calculation

Beta = (Correlation* Standard deviation of security)/Standard deviation of Market portfolio.

Security Expected Return Standard Deviation Correlation Beta
Firm A 0.105 0.36

0.44

(Note 2)

0.8
Firm B 0.145

0.49

(Note 1)

0.55 1.35
Firm C 0.165 0.6 0.4

1.2

(Note 3)

Market Portfolio 0.12 0.2

1

(Correlation of market portfolio with iteself is always 1)

1

(Beta of market with iteself is always 1)

The Risk free asset 0.05

0

(Risk of risk free asset is always zero)

0

(correlation of risk free asset when combine with risky asset is always zero)

0

(beta of risk free asset is always zero)

Note 1 - Standard deviation of Firm B (let 'x')

Beta = (Correlation * Standard deviation of security)*standard deviation of market portfolio

1.35 = (0.55*x)/0.20

0.55x = 0.27

x = 0.49

Note 2 - Correlation of firm A

0.8 = (x*0.36)/0.2

0.36x = 0.16

x = 0.44

Note 3 - Beta of Firm 3

x = (0.4*0.6)/0.2

x = 1.2

Part 2 - Calculation of return as per CAPM model (Capital asset pricing model)

Rs = Rf + Bi * (Rm - Rf)

Rs = CAPM return

Rf = Risk free return

Rm = Market return

Bi = Beta of Firm

Concept of Buy/sell = In case valuation of return of security, CAPM model is used to calculate the return. In case the return as per CAPM model is greater than the expected return then such stock is overpriced and should be sell (go short). And if Return calculated as per CAPM Model is less than expected return then stock is undervalued and should be bought (go long)

Solution to question from b-1 to b-6 is in this single table

Security Question Part CAPM return Question Part Decision of Buy/sell
Firm A (b-1)

0.106 or 10.6%

(Note 4)

(b-2)

Expected Return= 0.105

CAPM return = 0.106

Since return as per CAPM model is greater such stock is overpriced and should be sell (go short)

Firm B (b-3)

0.1445 or 14.45%

(Note 5)

(b-4)

Expected return = 0.145

CAPM return = 0.1445

Since return as per CAPM mod is less than the expected return such stock is underpriced and should be bought (go long)

Firm C (b-5)

0.134 or 13.4%

(Note 6)

(b-6)

Expected return = 0.165

CAPM return = 0.134

Since return as per CAPM model is less than the expected return such stock is underpriced and should be bought (go long)

Note 4

Calculation of CAPM return

let CAPM return (Rs) = 'x'

x = 0.05 + 0.8*(0.12 - 0.05)

x = 0.106

Note 5-

x = 0.05 + 1.35*(0.12-0.05)

x = 0.1445

Note 6 -

x = 0.05 + 1.2*(0.12-0.05)

x = 0.134


Related Solutions

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...
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’...
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 are an active investor in the securities market and you have established an investment portfolio...
You are an active investor in the securities market and you have established an investment portfolio of two stock A and B five years ago. Required: a) If your portfolio has provided you with returns of 9.7%, -6.2%, 12.1%, 11.5% and 13.3% over the past five years, respectively. Calculate the geometric average return of the portfolio for this period? (1 mark)? b) Assume that expected return of the stock A in your portfolio is 14.6%. The risk premium on the...
You are an active investor in the securities market and you have established an investment portfolio...
You are an active investor in the securities market and you have established an investment portfolio of two stock A and B five years ago. Required: a) If your portfolio has provided you with returns of 9.7%, -6.2%, 12.1%, 11.5% and 13.3% over the past five years, respectively. Calculate the geometric average return of the portfolio for this period? (1 mark)? b) Assume that expected return of the stock A in your portfolio is 14.6%. The risk premium on the...
The following data have been provided to you: (all amounts are in dollars)            ...
The following data have been provided to you: (all amounts are in dollars)                                                                   April   May Sales 150,000 157,500 Merchandise purchases 107,000 112,400 Operating expenses:              Payroll 13,600         14,280      Advertising 5,400           5,700      Rent 2,500           2,500      Depreciation 7,500           7,500 End of April balances:              Cash 30,000          Bank loan payable     26,000 Additional data: Sales are 40% cash and 60% on...
You are given the following three stocks and you have been asked to propose a portfolio...
You are given the following three stocks and you have been asked to propose a portfolio for a wealthy client. The client wants either a 2 asset (A-B, B-C, or A-C) or a 3 asset(A-B-C) portfolio. In any case, the portfolios must be equal weighted. Which of the four portfolios do you suggest to the client? Why? Show your work step by step. Stocks Mean Return Std of Return X 1.5 4 Y 4 8 Z 7 1 Correlations X...
You are given the following three stocks and you have been asked to propose a portfolio...
You are given the following three stocks and you have been asked to propose a portfolio for a wealthy client.  The client wants either a 2 asset (A-B, B-C, or A-C) or a 3 asset(A-B-C) portfolio. In any case, the portfolios must be equal weighted.  Which of the four portfolios do you suggest to the client? Why? Show your work step by step. Stocks Mean Return Std of Return X 1.5 4 Y 4 8 Z 7 1 Correlations X and Y...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT