
FIN500_Case_Study_1.doc Download Attachment
FIN 500: Case Study 1 Assignment
Notes
Your first case assignment deals with the concepts of risk and return. Please read the
case questions through and give some thought to your answers before you...FIN 500: Case Study 1 Assignment
Notes
Your first case assignment deals with the concepts of risk and return. Please read the
case questions through and give some thought to your answers before you commence.
Answer all parts of the ten (10) questions presented below. Your report should be wellorganized, typewritten/word processed, and independently prepared. Each student's
report must be his/her own original work and the writeup must also be individually
prepared.
1.
Buxton Corporation is planning to invest in a security that has several potential rates of
return. Using the following probability distribution of returns during different states of
the economy, what is the expected rate of return on this investment? In addition,
compute the standard deviation of the returns (σ). Finally, briefly explain what these
numbers represent.
Probability
0.10
0.20
0.30
0.40
2.
Expected Return
10%
5%
10%
25%
Using the capital asset pricing model (CAPM), estimate the appropriate required rate of
return for the following three stocks, assuming that the riskfree rate (r RF) is 5 percent
and the expected return for the market (rM) is 17 percent.
Stock
A
B
C
3.
Based on the following table of actual (or ex post) returns for both Inquiry Corporation
and the market from 2007 through 2010, calculate the average return and the standard
deviation for both Inquiry and the market (keep in mind that this data is historical and
not based on a probability distribution, so be sure to use the correct formulas).
Year
2007
2008
2009
2010
4.
Beta (β)
0.75
0.90
1.40
Inquiry Corporation
4%
6%
0%
2%
Market
2%
3%
1%
1%
(a)
Derive the expected return (rP) and beta (βP) for a portfolio based on the
following information:
Stock
Percentage of
Portfolio
40%
25%
35%
1
2
3
(b)
5.
Beta (β)
1.00
0.75
1.30
Expected
Return
12%
11%
15%
Given the information in the table above, present the equation for the security
market line and explain where the return for this specific portfolio would lie (plot)
relative to the SML (i.e., below or above the line). Assume that the riskfree rate
(rRF) is 8 percent and that the expected return on the market portfolio (r M) is 12
percent.
Reliable Printing is evaluating a security. Oneyear Treasury bills (r RF) are currently
paying 3.1 percent. Calculate the following investment’s expected return and its
standard deviation (σ). Should Reliable Printing invest in this security? Briefly explain.
Probability
0.15
0.30
0.40
0.15
Expected Return
1%
2%
3%
8%
6. You have researched the common stock of two companies (A and B) and have
compiled the following information:
COMPANY A
Probability
0.20
0.50
0.30
COMPANY B
Return
Probability
2%
0.10
18%
0.30
27%
0.40
0.20
Return
4%
6%
10%
15%
Calculate the expected return, standard deviation (σ), and the coefficient of variation
(CV) for each stock and, based on the CV, which stock should you invest in? Briefly
explain.
7. Assume you own a portfolio consisting of the following stocks:
Stock
1
2
3
Percentage of
Portfolio
20%
30%
15%
Beta (β)
1.00
0.85
1.20
Expected
Return
16%
14%
20%
4
5
25%
10%
0.60
1.60
12%
24%
(a) Determine the expected return on your portfolio.
(b) Determine the portfolio beta (βP).
(c) Given the portfolio beta and the assumptions that the riskfree rate (r RF) is 7 percent
and the expected return on the market portfolio (rMKT) is 15.5 percent, present the
equation for the security market line (SML).
(d) Based on your equation for the SML and the expected returns from the data in the
table, which stocks appear to be winners (i.e., underpriced) and which stocks
appear to be losers (i.e., overpriced)?
8.
The common stock for a particular company is known to have a beta (β) of 1.20. The
expected return on the market (rM) is 9 percent and the riskfree rate (rRF) is 5 percent.
(a) Compute a fair rate of return based on this information.
(b) What would be a fair rate of return if the beta were 0.85?
(c) What would be a fair rate of return if the expected return on the market increased to
12 percent and the beta remained at 0.85?
9.
The expected return for the general market (rMKT) is 12.8 percent, and the market risk
premium (i.e., RPM) is 4.3 percent. Moe, Larry, and Curley have betas of 0.82, 0.57,
and 0.68, respectively. What are the required rates of return for the three securities?
10.
Hickory Stick’s common stock has a beta (β) of 0.95. The expected return for the
market (rM) is 7 percent and the riskfree rate (rRF) is 4 percent.
(a) What is the required rate of return based on this information?
(b) What would be the required rate of return if the beta were 1.25?
11. An exhaustive financial analysis has produced the following returns on two investments
under three different scenarios:
Scenario
S1
S2
S3
Expected Returns
Probability
0.3
0.4
0.3
Stock X
10%
16%
12%
Stock Y
8%
15%
20%
(a) Calculate the expected return on each investment.
(b) Calculate the standard deviations (σ) for both X and Y.
(c) Calculate the coefficient of variation (CV) for both X and Y.
(d) If you were to create a portfolio consisting of 67% of Stock X and 33% of Stock Y,
what will be the expected return (rP) and the standard deviation (σP) for your
portfolio?
View Full Attachment Show more
Additional Requirements
Level of Detail: Show all work
Sorry for inconvenience.
Thank You.
Please find attached the solutions.
Request... View Full Answer

8452877  Solutions.xlsx Download Attachment
Probability (A) Expected Return
(A * B)
(B)
0.01
0.1
10%
0.01
0.2
5%
0.03
0.3
10%
0.1
0.4
25%
Expected Rate of Return On This Investment
The standard deviation of the returns ()
=
=
13.00%...Probability (A) Expected Return
(A * B)
(B)
0.01
0.1
10%
0.01
0.2
5%
0.03
0.3
10%
0.1
0.4
25%
Expected Rate of Return On This Investment
The standard deviation of the returns ()
=
=
13.00%
4.79%
Here total expected return on this investment is 13% with a deviation of 4.79% in the return.
The riskfree rate (rRF)
The expected return for the market (rM)
=
5%
=
17%
As Capital Assets Pricing Model (CAPM),
Cost of equity (Required Rate)
Stock
A
B
C
Beta ()
0.75
0.9
1.4
=
Risk Free Rate + Beta * ( Expected Return From Market  Risk Free Rate)
Required Rate
14.00%
15.80%
21.80%
As per the required rates calculated, Stock "C" has more required rate because of higher "Beta". We understand that, Beta is the
indicator of risk I,e Volatility. More is the Beta Value , more volatile is the stock or vice versa.
Year
2007
2008
2009
2010
Average Return
Standard Deviation
Inquiry Corporation
4%
6%
0%
2%
3.00%
2.58%
Market
2%
3%
1%
1%
1.25%
1.71%
(Excel "Average" function Is Used)
(Excel "STDEV" function Is Used)
Stock
1
2
3
(a)
Percentage of
Portfolio (A)
40%
25%
35%
Beta () (B)
The expected return (rP) of portfolio
Portfolion of Beta
Expected Return
(C')
12%
11%
15%
1
0.75
1.3
=
=
13%
1.04
A*C
4.80%
2.75%
5.25%
A*B
0.40
0.19
0.46
Reliable Printing
Risk Free Rate
Probability (A) Expected Return
(B)
0.15
1%
0.3
2%
0.4
3%
0.15
8%
Expected Return
Standard Deviation
3%
A*B
0.2%
0.6%
1.2%
1.2%
2.9%
0.6%
Reliable Printing should not invest in this security because the expected return on investment are less than
the risk free rate, which indicates that rather investing in security, it is better to invest in Oneyear Treasury
Bills.
Company A
Company B
Probability (A)
Return (B)
A*B
0.2
0.5
0.3
2%
18%
27%
Probability
('C)
0.1
0.3
0.4
0.2
0%
9%
8%
Company A
Expected Return
Standard Deviation ()
The coefficient of variation (CV)
Return (D)
4%
6%
10%
15%
Return
(C * D)
0%
2%
4%
3%
Company B
17%
15%
0.89
9%
5%
0.53
As per the above calculted ratios, we understand that security "Company A" is a risky stock to
invest in , but parallely there is an opportunity of getting more returns. Higher the coefficient
of variation, more is the riskreturn trade off and vice versa as well.
Stock
1
2
3
4
5
Percentage of
Portfolio (A)
20%
30%
15%
25%
10%
Beta ()
(B)
1
0.85
1.2
0.6
1.6
Expected
Return (C')
16%
14%
20%
12%
24%
A*C
3.2%
4.2%
3.0%
3.0%
2.4%
(a)
Expected Return on portfolio
=
15.8%
(b)
Portfolio Beta
=
0.95
(c)
Risk Free Rate
Expected Return On Market Portfolio
Portfolio Beta
=
=
=
7.00%
15.5%
0.95
B*C
0.20
0.26
0.18
0.15
0.16
( We have multiplied the... View Full Attachment Show more
Revised... View Full Answer
Download Preview:
Probability (A) Expected Return
(A * B)
(B)
0.01
0.1
10%
0.01
0.2
5%
0.03
0.3
10%
0.1
0.4
25%
Expected Rate of Return On This Investment
The standard deviation of the returns ()
=
=
13.00%...
"Answer was thorough and wellpresented. "
Would like to love in all your future assignments.
Appreciated your association.
Related Questions


Q. I need help working this spreadsheet. I'm totally lost!!!!
 Answer Rating:
 View Answer



Q. hi! i need help with excel solver?
 Answer Rating:
 View Answer
