
a
To evaluate: The portfolio’s performance and plot the monthly values of alpha plus residual return.
Introduction:
Alpha: Symbolically, alpha is denoted as ‘a’. It is supposed to be the difference amount that is determined after deducting the actual return from the expected return. The selection of the portfolio is made when the alpha of a portfolio is the highest.
Treynor ratio: It is named after its creator - Jack Treynor, who is an American economist. Treynor ratio tries to explore the amount of return which is generated in excess. This also is calculated for risk per unit.
a

Answer to Problem 22PS
The consumer industry has a record of good performance than the manufacturing. Even then its performance can be judged as below the benchmark.
Explanation of Solution
The information given to us is as follows:
Month | Consumer | Manufacturing | Risk-free rate | Rm-RF | Market return | SMB | HML |
2012-08 | 1.84 | 1.82 | 0.9 | 2.58 | 3.48 | 0.5 | 0.79 |
2012-09 | 1.71 | 2.44 | 0.7 | 2.69 | 3.39 | 0.72 | 1.36 |
2012-10 | -0.78 | -0.82 | 1.1 | -1.7 | -0.6 | -1.31 | 3.43 |
2012-11 | 2.23 | 0.01 | 1.3 | 0.71 | 2.01 | 0.55 | -1.4 |
2012-12 | -0.87 | 1.8 | 0.4 | 1.09 | 1.49 | 1.53 | 3.56 |
2013-01 | 5.25 | 6.5 | 0.5 | 5.65 | 6.15 | 0.57 | 0.68 |
2013-02 | 1.67 | 1.09 | 0.8 | 1.27 | 2.07 | 0.07 | -0.04 |
2013-03 | 4.78 | 2.88 | 0.8 | 4.07 | 4.87 | 0.54 | 0.08 |
2013-04 | 3.16 | 0.7 | 0.5 | 1.57 | 2.07 | -2.2 | -0.05 |
2013-05 | 1.12 | 1.51 | 0.2 | 2.64 | 2.84 | 2.3 | 0.91 |
2013-06 | -0.07 | -1.71 | 0.3 | -1.12 | -0.82 | 1.44 | -0.48 |
2013-07 | 5.1 | 5.44 | 0.2 | 5.63 | 5.83 | 1.26 | 0.88 |
2013-08 | -3.86 | -2.29 | 0.4 | -2.65 | -2.25 | 0.06 | -2.17 |
2013-09 | 3.74 | 3.4 | 0.2 | 3.74 | 3.94 | 2.39 | -1.7 |
2013-10 | 4.52 | 4.44 | 1.1 | 4.23 | 5.33 | -1.4 | 1.01 |
2013-11 | 2.66 | 1.52 | 0.5 | 3.13 | 3.63 | 1 | 0.24 |
2013-12 | 1.12 | 2.83 | 0.2 | 2.7 | 2.9 | -0.57 | -0.39 |
2014-01 | -5.95 | -4.26 | 0.2 | -3.2 | -3 | 0.83 | -1.99 |
2014-02 | 4.92 | 5.13 | 0.5 | 4.57 | 5.07 | 0.27 | -0.85 |
2014-03 | 0.68 | 1.39 | 0.5 | 0.39 | 0.89 | -1.04 | 4.83 |
2014-04 | -0.04 | 2.96 | 0.2 | -0.13 | 0.07 | -3.91 | 2.69 |
2014-05 | 1.79 | 0.96 | 0.3 | 2.17 | 2.47 | -1.79 | -0.37 |
2014-06 | 1.55 | 3 | 0.2 | 2.69 | 2.89 | 2.83 | -0.67 |
2014-07 | -3.26 | -4.34 | 0.2 | -2.08 | -1.88 | -3.93 | -0.16 |
2014-08 | 5.33 | 3.97 | 0.3 | 4.21 | 4.51 | 0.69 | -1.11 |
2014-09 | -1.7 | -4.55 | 0.1 | -2 | -1.9 | -3.67 | -1.72 |
2014-10 | 2.95 | 0.73 | 0.2 | 2.35 | 2.55 | 3.08 | -0.45 |
2014-11 | 6.27 | -2.03 | 0.4 | 2.41 | 2.81 | -2.3 | -3.73 |
2014-12 | 0.09 | 0.36 | 0.3 | -0.22 | 0.08 | 2.24 | 1.15 |
2015-01 | -0.76 | -3.11 | 0.2 | -2.95 | -2.75 | -0.73 | -4.73 |
2015-02 | 5.58 | 3.83 | 0.2 | 6.11 | 6.31 | 1 | -0.29 |
2015-03 | -0.47 | -1.9 | 0.2 | -1.14 | -0.94 | 2.38 | -0.88 |
2015-04 | -1.09 | 1.76 | 0.2 | 0.75 | 0.95 | -2 | 4.17 |
2015-05 | 1.12 | -1.15 | 0.1 | 1.28 | 1.38 | 0.29 | -3.53 |
2015-06 | -0.92 | -3.06 | 0 | -1.62 | -1.62 | 2.68 | -1.42 |
2015-07 | 4.18 | -3.28 | 0.3 | 1.41 | 1.71 | -4.16 | -4.77 |
With the help of given information in the above table, let us calculate the average and standard for column label.
The average has to be calculated using the above formula in each of column.
The formula used is to calculate standard deviation is as follows:
Where
S=Sample standard deviation
n=The number of observations
x= The observed mean values of a sample item
The total depicts the sum of the values of 36 months. The formula of average and standard deviation is used to calculate the values for the above said columns.
Particulars | Consumer | Manufacturing | Risk-free rate | Rm-RF | Market return | SMB | HML |
Total | 53.59 | 27.97 | 14.7 | 51.23 | 65.93 | 0.21 | -7.12 |
Average | 1.4886 | 0.7769 | 0.4083 | 1.4232 | 1.8314 | 0.0058 | -0.1978 |
Standard deviation | 2.834 | 2.900 | 0.307 | 2.537 | 9.918 | 1.984 | 2.18 |
Having the values of average and standard deviation, let us now calculate the Beta, Sharpe ratio, Treynor ratio and Jenson ratio. The formulas to be used are as follows:
?where:
Covariance=Measure of a stock’s return relative to that of the market Variance=Measure of how the market moves relativeto its mean?
Sharpe ratio:
Where
S= Sharpe ratio
Rp= Return earned from portfolio
Rf= Risk-free
sp=Standard deviation of the portfolio’s return
Treynor ratio:
Where
T= Treynor ratio
Rp= Portfolio return
rf= Risk free rate of interest
ßp= Portfolio beta
By using the above said formula, we get the following values.
Particulars | Consumer | Manufacturing | Market return |
Beta | 0.9711 | 0.9684 | 1.0000 |
Sharpe ratio | 0.3811 | 0.1271 | 0.5644 |
Treynor Ratio | -0.3017 | -1.0095 | 1.4231 |
From the above calculation, it is clear that the consumer industry has a record of good performance than the manufacturing. Even then its performance can be judged as below the benchmark.
b.
To compute: The alpha plus residual returns using the Fama-French three factor model.
Introduction:
Alpha: Symbolically, alpha is denoted as ‘a’. It is supposed to be the difference amount that is got from deducting the actual return from the expected return. The selection of the portfolio is made when its alpha is the highest
Treynor ratio: It is named after its creator’s name Jack Treynor who is an American economist. Treynor ratio tries to explore the amount of return which is generated in excess. This also is calculated for risk per unit.
b.

Answer to Problem 22PS
The consumer industry has a record of good performance than the manufacturing. Even then its performance can be judged as below the benchmark.
Explanation of Solution
The information given to us is as follows:
Month | Consumer | Manufacturing | Risk-free rate | Rm-RF | Market return | SMB | HML |
2012-08 | 1.84 | 1.82 | 0.9 | 2.58 | 3.48 | 0.5 | 0.79 |
2012-09 | 1.71 | 2.44 | 0.7 | 2.69 | 3.39 | 0.72 | 1.36 |
2012-10 | -0.78 | -0.82 | 1.1 | -1.7 | -0.6 | -1.31 | 3.43 |
2012-11 | 2.23 | 0.01 | 1.3 | 0.71 | 2.01 | 0.55 | -1.4 |
2012-12 | -0.87 | 1.8 | 0.4 | 1.09 | 1.49 | 1.53 | 3.56 |
2013-01 | 5.25 | 6.5 | 0.5 | 5.65 | 6.15 | 0.57 | 0.68 |
2013-02 | 1.67 | 1.09 | 0.8 | 1.27 | 2.07 | 0.07 | -0.04 |
2013-03 | 4.78 | 2.88 | 0.8 | 4.07 | 4.87 | 0.54 | 0.08 |
2013-04 | 3.16 | 0.7 | 0.5 | 1.57 | 2.07 | -2.2 | -0.05 |
2013-05 | 1.12 | 1.51 | 0.2 | 2.64 | 2.84 | 2.3 | 0.91 |
2013-06 | -0.07 | -1.71 | 0.3 | -1.12 | -0.82 | 1.44 | -0.48 |
2013-07 | 5.1 | 5.44 | 0.2 | 5.63 | 5.83 | 1.26 | 0.88 |
2013-08 | -3.86 | -2.29 | 0.4 | -2.65 | -2.25 | 0.06 | -2.17 |
2013-09 | 3.74 | 3.4 | 0.2 | 3.74 | 3.94 | 2.39 | -1.7 |
2013-10 | 4.52 | 4.44 | 1.1 | 4.23 | 5.33 | -1.4 | 1.01 |
2013-11 | 2.66 | 1.52 | 0.5 | 3.13 | 3.63 | 1 | 0.24 |
2013-12 | 1.12 | 2.83 | 0.2 | 2.7 | 2.9 | -0.57 | -0.39 |
2014-01 | -5.95 | -4.26 | 0.2 | -3.2 | -3 | 0.83 | -1.99 |
2014-02 | 4.92 | 5.13 | 0.5 | 4.57 | 5.07 | 0.27 | -0.85 |
2014-03 | 0.68 | 1.39 | 0.5 | 0.39 | 0.89 | -1.04 | 4.83 |
2014-04 | -0.04 | 2.96 | 0.2 | -0.13 | 0.07 | -3.91 | 2.69 |
2014-05 | 1.79 | 0.96 | 0.3 | 2.17 | 2.47 | -1.79 | -0.37 |
2014-06 | 1.55 | 3 | 0.2 | 2.69 | 2.89 | 2.83 | -0.67 |
2014-07 | -3.26 | -4.34 | 0.2 | -2.08 | -1.88 | -3.93 | -0.16 |
2014-08 | 5.33 | 3.97 | 0.3 | 4.21 | 4.51 | 0.69 | -1.11 |
2014-09 | -1.7 | -4.55 | 0.1 | -2 | -1.9 | -3.67 | -1.72 |
2014-10 | 2.95 | 0.73 | 0.2 | 2.35 | 2.55 | 3.08 | -0.45 |
2014-11 | 6.27 | -2.03 | 0.4 | 2.41 | 2.81 | -2.3 | -3.73 |
2014-12 | 0.09 | 0.36 | 0.3 | -0.22 | 0.08 | 2.24 | 1.15 |
2015-01 | -0.76 | -3.11 | 0.2 | -2.95 | -2.75 | -0.73 | -4.73 |
2015-02 | 5.58 | 3.83 | 0.2 | 6.11 | 6.31 | 1 | -0.29 |
2015-03 | -0.47 | -1.9 | 0.2 | -1.14 | -0.94 | 2.38 | -0.88 |
2015-04 | -1.09 | 1.76 | 0.2 | 0.75 | 0.95 | -2 | 4.17 |
2015-05 | 1.12 | -1.15 | 0.1 | 1.28 | 1.38 | 0.29 | -3.53 |
2015-06 | -0.92 | -3.06 | 0 | -1.62 | -1.62 | 2.68 | -1.42 |
2015-07 | 4.18 | -3.28 | 0.3 | 1.41 | 1.71 | -4.16 | -4.77 |
The Fama-French three factor model suggests the usage of market risk, size of the company and company’s book to market value to calculate the returns. The formula to be used to calculate the required returns is Jenson’s Alpha ratio.
Jensen's Alpha Ratio:
By using the above said formula, we get the following values.
Particulars | Consumer | Manufacturing | Market return |
Jenson’s Alpha Ratio | 1.3377 | 0.6300 | 1.6394 |
From the above calculation, it is clear that the consumer industry has a record of good performance than the manufacturing. Even then its performance can be judged as below the benchmark.
Want to see more full solutions like this?
Chapter 24 Solutions
Investments
- Imagine that the SUNY Brockport Student Government Association (SGA) is considering investing in sustainable campus improvements. These improvements include installing solar panels, updating campus lighting to energy-efficient LEDs, and implementing a rainwater collection system for irrigation. The total initial investment required for these projects is $100,000. The projects are expected to generate savings (effectively, the cash inflows in this scenario) of $30,000 in the first year, $40,000 in the second year, $50,000 in the third year, and $60,000 in the fourth year due to reduced energy and maintenance costs. SUNY Brockport’s discount rate is 8%. What is the NPV of the sustainable campus improvements? (rounded) a- $70,213b- $48,729c- $45,865d- $62,040arrow_forwardImagine that the SUNY Brockport Student Government Association (SGA) is considering investing in sustainable campus improvements. These improvements include installing solar panels, updating campus lighting to energy-efficient LEDs, and implementing a rainwater collection system for irrigation. The total initial investment required for these projects is $100,000. The projects are expected to generate savings (effectively, the cash inflows in this scenario) of $30,000 in the first year, $40,000 in the second year, $50,000 in the third year, and $60,000 in the fourth year due to reduced energy and maintenance costs. SUNY Brockport’s discount rate is 8%. What is the NPV of the sustainable campus improvements? (rounded)a- $70,213b- $48,729c- $45,865d- $62,040arrow_forwardAfter many sunset viewings at SUNY Brockport, Amanda dreams of owning a waterfront home on Lake Ontario. She finds her perfect house listed at $425,000. Leveraging the negotiation skills she developed at school, she persuades the seller to drop the price to $405,000. What would be her annual payment if she opts for a 30-year mortgage from Five Star Bank with an interest rate of 14.95% and no down payment? 26,196 27,000 24,500 25,938arrow_forward
- Why should we care about the difference between book value and market value?arrow_forward1. A bond currently has a price of $1,050. The yield on the bond is 5%. If the yield increases 30 basis points, the price of the bond will go down to $1,035. The duration of this bond is closest to: Group of answer choices None of the above 6.0 5 4.5 5.5 2. A callable corporate bond can be purchased by the bond issuer before maturity for a price specified at the time the bond is issued. Corporation X issues two bonds (bond A and bond B) at the same time with thesame maturity, par value, and coupons. However, bond A is callable and bond B is not. Which bond will sell for a higher price and why? Group of answer choices Bond B; bond B should have the value of bond A minus the value of the call option Bond A; bond A should have the value of bond B plus the value of the call option Not enough information Bond A; bond A should have the value of bond B minus the value of the call option Bond B; bond B should have the value of bond A plus the value of the call optionarrow_forwardIn plain English, what is the Agency problem?arrow_forward
- HW Question 29: what is the difference between accounting and finance?arrow_forward1. You are assessing the average performance of two mutual fund managers with the Fama-French 3-factor model. The fund managers and the Fama-French factors had the following performance over this periodof time: Manager 1 Manager 2 Rm − rf smb hmlAvg. (total) Ret 27% 13% 8% 2% 6%βmkt 2 1 1 0 0s 1 -0.5 0 1 0h 1 0.5 0 0 1 The risk-free rate is 2%. What kinds of stocks does Manager 1 invest in? Group of answer choices Small-cap value stocks Large-cap value stocks Large-cap growth stocks Not enough information…arrow_forward1. A hedge fund currently invests in $100 million of mortgage-backed securities (MBS) that have a duration of 15 and convexity of -500 (negative five hundred). Which of the following is closest to how much money the fund would gain or lose if interest rates decreased by 1%, using the duration+convexity approximation? Group of answer choices Lose $12 million Lose $10 million Lose $12.5 million Gain $11 million Gain $12 million 2. A hedge fund currently invests in $100 million of mortgage-backed securities (MBS) that have a duration of 15 and convexity of -500 (negative five hundred). Suppose the Hedge fund financed their $100 million of MBS by using seven-day repurchase agreements in addition to their investors’ capital. Assuming they borrow the maximum amount, the required haircut is 10%, and the interest rate is 2% per year, which of the following is closest to how much interest they will owe at the end of the first seven-day term? Group of answer choices $35,000 $40,000 $30,000…arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,



