Question

**Problem 2-14**

Historical Returns: Expected and Required Rates of Return

You have observed the following returns over time:

Year |
Stock X |
Stock Y |
Market |

2011 | 16% | 12% | 13% |

2012 | 19 | 7 | 10 |

2013 | -15 | -2 | -14 |

2014 | 4 | 1 | 1 |

2015 | 24 | 9 | 17 |

Assume that the risk-free rate is 4% and the market risk premium is 7%. Do not round intermediate calculations.

What is the beta of Stock X? Round your answer to two decimal
places.

What is the beta of Stock Y? Round your answer to two decimal
places.

What is the required rate of return on Stock X? Round your
answer to one decimal place.

%

What is the required rate of return on Stock Y? Round your answer
to one decimal place.

%

What is the required rate of return on a portfolio consisting of
80% of Stock X and 20% of Stock Y? Round your answer to one decimal
place.

%

Answer #1

By Using Excel, The Beta is as follows

By Using Slope Function we can calculate Beta in Excel workbook

1. Beta of X = 1.25

2. Beta of Y = 0.43

3. Required Rate of Return of Stock X = Risk Free Rate + Beta * Market Risk Premium

Required Rate of Return of Stock X = 4% + 1.25 * 7%

Required Rate of Return of Stock X = 12.8%

4. Required Rate of Return of Stock Y = Risk Free Rate + Beta * Market Risk Premium

Required Rate of Return of Stock X = 4% + 0.43 * 7%

Required Rate of Return of Stock X = 7.0%

5. Portfolio return if weights are 80% stock X and 20% Stock Y

**Portfolio Return = Weight * Return = 0.80 * 12.8% + 0.20
* 7.0% = 11.6%**

Problem 6-14
Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock Y
Market
2012
15%
12%
12%
2013
18
8
9
2014
-14
-3
-14
2015
4
1
1
2016
20
12
18
Assume that the risk-free rate is 3% and the market risk premium
is 7%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal
places.
What is the...

eBook
Problem 6-14
Historical Returns: Expected and Required Rates of Return
You have observed the following returns
over time:
Year
Stock X
Stock Y
Market
2012
14%
11%
11%
2013
17
7
11
2014
-13
-2
-11
2015
4
2
1
2016
21
8
15
Assume that the risk-free rate is 3%
and the market risk premium is 6%. Do not round intermediate
calculations.
What is the beta of Stock X? Round your
answer to two decimal places.
What is...

Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock Y
Market
2009
14%
15%
13%
2010
20
7
9
2011
-15
-8
-12
2012
4
2
2
2013
24
13
18
Assume that the risk-free rate is 4% and the market risk premium
is 6%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal
places.
What is the beta of...

Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock Y
Market
2009
16%
14%
13%
2010
19
6
9
2011
-15
-2
-13
2012
2
1
1
2013
23
11
18
Assume that the risk-free rate is 3% and the market risk premium
is 6%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal
places.
What is the beta of...

Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock Y
Market
2011
15%
14%
10%
2012
19
6
12
2013
-17
-3
-12
2014
3
2
3
2015
19
12
17
Assume that the risk-free rate is 6% and the market risk premium
is 6%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal
places.
What is the beta of...

Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock Y
Market
2012
16%
14%
14%
2013
21
7
11
2014
-14
-3
-10
2015
5
2
1
2016
21
9
17
Assume that the risk-free rate is 3% and the market risk premium
is 6%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal
places.
What is the beta of...

Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock Y
Market
2012
16%
12%
14%
2013
18
6
8
2014
-16
-4
-14
2015
5
2
3
2016
21
11
16
Assume that the risk-free rate is 6% and the market risk premium
is 6%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal
places.
What is the beta of...

Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock Y
Market
2012
16%
15%
12%
2013
21
6
11
2014
-16
-6
-11
2015
3
3
1
2016
22
12
13
Assume that the risk-free rate is 4% and the market risk premium
is 7%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal
places.
What is the beta of...

Required Rate of Return
Stock R has a beta of 1.9, Stock S has a beta of 0.65, the
expected rate of return on an average stock is 12%, and the
risk-free rate is 4%. By how much does the required return on the
riskier stock exceed that on the less risky stock? Round your
answer to two decimal places.
Historical Returns: Expected and Required Rates of Return
You have observed the following returns over time:
Year
Stock X
Stock...

Problem 6-13
Historical Realized Rates of Return
Stocks A and B have the following historical returns:
Year
2012
-24.70%
-14.40%
2013
22.75
23.00
2014
11.75
37.10
2015
-2.50
-6.10
2016
31.50
-0.80
Assume that someone held a portfolio consisting of 50% of Stock
A and 50% of Stock B. What would have been the realized rate of
return on the portfolio in each year? What would have been the
average return on the portfolio during this period? Round your
answers...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 22 minutes ago

asked 59 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 3 hours ago

asked 3 hours ago

asked 3 hours ago

asked 4 hours ago