Question
In: Finance
Use the following data to explore the risk-return relation and the concept of beta for Apple...
Use the following data to explore the risk-return relation and the concept of beta for Apple stock, Alphabet (Google) stock, and the S&P 500 market index:
|
Year |
Apple Stock Price |
Alphabet Stock Price |
S&P 500 Market Index |
|
2017 |
$174.09 |
$1,072.01 |
2,601.42 |
|
2016 |
$115.82 |
$807.80 |
2,238.83 |
|
2015 |
$105.26 |
$765.84 |
2,043.94 |
|
2014 |
$113.99 |
$521.51 |
2,058.90 |
|
2013 |
$80.01 |
$559.76 |
1,848.36 |
|
2012 |
$72.80 |
$358.17 |
1,426.19 |
| Market risk premium: RPM = | 4.01% |
| Risk-free rate: rRF = | 1.30% |
- Calculate the portfolio beta of the four-stock portfolio and the required return on the portfolio (9 Points) ***Please Provide the Excel Functions
| Beta | Portfolio Weight | ||
| Apple | 25% | ||
| Stock A | 0.77 | 15% | |
| Stock B | 0.99 | 40% | |
| Stock C | 1.42 | 20% | |
| 100% | |||
| Portfolio Beta = | |||
| Risk-free rate | Market Risk Premium | Portfolio Beta | Required Return on Portfolio |
Solutions
Expert Solution
Beta of Apple = 0.086
Portfolio Beta = 0.086 * 0.25 + 0.77 * 0.15 + 0.99 * 0.40+1.42 * 0.2 = 0.817 Answer
Using CAPM,
Required Return on Apple = 1.3 +4.01* 0.086 = 1.64486
Required Return on Stock A = 1.3 +4.01 * 0.77 = 4.3877
Required Return on Stock B = 1.3 +4.01 * 0.99 = 5.2699
Required Return on Stock C = 1.3 +4.01 * 1.42 = 6.9942
Required Return on Portfolio = 1.64486 * 0.25 + 4.3877* 0.15 + 5.2699* 0.40+6.9942* 0.2 = 4.58 % Answer
Risk Free Rate = 1.3% Answer
Market Risk Premium = 4.01% Answer
Kindly inform me in case you have any queries.
A B C D 3 Year Apple S&P 500 Market 2017 174.09 2601.42 2016 115.82 2238.83 2015 105.26 2043.94 2014 113.99 2058.9 2013 80.01 1848.36 2012 72.8 1426.19 Considering it as a sample. Beta of Apple = Covariance(Apple, Market)/ Variance (Market) 14 Covariance Of (Apple,Market)= 13156.73819 =COVARIANCE.S(B4:B9,04:09) Answer Variance (Market)= 153700.7593 =VAR.S(C4:09) Answer 15 16 17 Beta of Apple= 0.0856 =D14/C15 Answer 18 19
jeff jeffy answered 1 year agoRelated Solutions
Use the following data to explore the risk-return relation and the concept of beta for Apple...
Use the following data to explore the risk-return relation and
the concept of beta for Apple stock, Alphabet (Google) stock, and
the S&P 500 market index:
Year
Apple Stock Price
Alphabet Stock Price
S&P 500 Market Index
2017
$174.09
$1,072.01
2,601.42
2016
$115.82
$807.80
2,238.83
2015
$105.26
$765.84
2,043.94
2014
$113.99
$521.51
2,058.90
2013
$80.01
$559.76
1,848.36
2012
$72.80
$358.17
1,426.19
E) Calculate the expected return on the market according to:
Expected Return on Market = Risk-Free Rate + Market...
Risk and Return Use the following data to explore the risk-return relation and the concept of...
Risk and Return
Use the following data to explore the risk-return relation and
the concept of beta for Apple stock, Kroger stock, and the S&P
500 market index:
Year
Apple Stock Price
Kroger Stock Price
S&P 500 Market Index
2020
$252.92
$30.71
3,234.85
2019
$156.23
$27.66
2,531.94
2018
$169.23
$27.32
2,753.15
2017
$125.17
$29.52
2,276.98
2016
$108.41
$31.80
2,043.94
2015
$112.98
$33.37
2,058.20
Part 1: Risk and Beta
Calculate the return each year for Apple, Kroger, and the
Market using...
Risk and Return Use the following data to explore the risk-return relation and the concept of...
Risk and Return
Use the following data to explore the risk-return relation and
the concept of beta for Apple stock, Kroger stock, and the S&P
500 market index:
Year
Apple Stock Price
Kroger Stock Price
S&P 500 Market Index
2020
$252.92
$30.71
3,234.85
2019
$156.23
$27.66
2,531.94
2018
$169.23
$27.32
2,753.15
2017
$125.17
$29.52
2,276.98
2016
$108.41
$31.80
2,043.94
2015
$112.98
$33.37
2,058.20
Part 2: Required Return
Market risk premium: RPM =
5.60%
Risk-free rate: rRF =
0.70%
Calculate the...
Risk and Return using EXCEL Use the following data to explore the return-risk relation and the...
Risk and Return using EXCEL
Use the following data to explore the return-risk relation and
the concept of beta for Apple stock, JPMorgan Chase & Co stock,
and the S&P 500 market index:
Year | Apple Stock Price | JPMorgan Chase & Co Stock Price |
S&P 500 Market Index Value
2017 | $149.04 | $93.85 | 2,425.17
2016 | $95.89 | $59.60 | 2,102.94
2015 | $124.50 | $68.25 | 2,076.79
2014 | $94.03 | $57.05 | 1,960.96
2013...
A project has a beta of 1.3. The risk-free return is 2% and the return on...
A project has a beta of 1.3. The risk-free return is 2% and
the return on the market is 12%. The project has an IRR of
14%.
a) If the firm’s cost of capital is 10%, will they take the
project using the cost of capital?
b) Using the CAPM to determine project risk, will they take
the project?
c) Which method is better for analyzing this project?
Why?
Portfolio Risk and Return Given the following portfolio Stock Amount (MV) Beta Return CAPM A $10,000...
Portfolio Risk and
Return
Given the following
portfolio
Stock
Amount (MV)
Beta
Return
CAPM
A
$10,000
1.1
13.50%
B
$5,000
1.4
14.00%
C
$6,000
1.5
7.50%
D
$13,000
0.7
8.50%
E
$16,000
1.9
19.80%
Total
$50,000
Risk free rate
3.00%
market return
12.00%
Portfolio return
Portfolio beta
Portfolio CAPM
Portfolio Beta and Expected Return Assume that CAPM holds and that both Apple and Yahoo...
Portfolio Beta and Expected Return
Assume that CAPM holds and that both Apple and Yahoo plot on the
SML. Apple has a beta of 2.6 and Yahoo has a beta of 0.9. The
expected return on the market portfolio is 9.25% and the risk-free
rate is 1.0%.
Based on the above data, what is the expected return for Apple?
(Express your answer in percentage, rounded to 2 decimal
places.)
The expected return for Apple (in
%):
Show the formula...
What is Beta and how can we use Beta to measure risk?
What is Beta and how can we use Beta to measure risk?
Beta and required rate of return A stock has a required return of 12%; the risk-free...
Beta and required rate of return
A stock has a required return of 12%; the risk-free rate is
2.5%; and the market risk premium is 3%.
What is the stock's beta? Round your answer to two decimal
places.
B. If the market risk premium increased to 9%, what would happen
to the stock's required rate of return? Assume that the risk-free
rate and the beta remain unchanged.
1. If the stock's beta is equal to 1.0, then the change in...
discuss the concept of risk and diversification in relation to the capital asset pricing model (500...
discuss the concept of risk and diversification in relation to
the capital asset pricing model (500 words)
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella Co.,...
- Parallel Arrays This question is in MindTap Cengage Summary In this lab, you use what you...
- 5. You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella...
- JAVA Write a test program that prompts the user to enter a series of integers and...
- (2) Cite an example on how organizations like Google, Facebook, Youtube etc collect data for image...
- The legal landscape is perpetually changing. Psychologists must remain abreast of these changes to avoid potentially...
- We are evaluating a project that costs $1.68 million, has a six-year life, and has no...
ADVERTISEMENT