Question

In: Finance

Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute...

Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute the average return differential with and without sign. Do not round intermediate calculations. Round your answers to two decimal places. Month Portfolio Return S&P 500 Return January 5.3 % 5.5 % February -2.4 -2.9 March -1.8 -1.1 April 2.5 2.0 May 0.9 0.5 June -1.1 -0.5 July 0.2 0.4 August 1.3 1.7 September -0.8 -0.1 October -3.2 -3.8 November 2.8 2.3 December 0.8 0.3

R2:

Alpha: %

Beta:

Average return difference (with signs): %

Average return difference (without signs) %

Solutions

Expert Solution

Step 1 calculating variance

                            Portfolio S%P 500        

month                 return                   Ri-E(Ri) Return Rm-E(Rm)      [Ri-E(Ri)x Rm-E(Rm)]

January                 5.30%                   4.93% 5.50%            5.14% 0.253%

February              -2.40%                 -2.78% -2.90% -3.26%             0.090%

March                   -1.80%                 -2.18% -1.10%            -1.46% 0.032%

April                       2.50%                   2.13%           2% 1.64% 0.035%

May                       0.90%                   0.53% 0.50% 0.14%                0.001%

June                     -1.10%                 -1.48% -0.50%          -0.86% 0.013%

July                       0.20%                   -0.18% 0.40% 0.04%               0.000%

August                  1.30%                   0.93% 1.70%           1.34% 0.012%

September -0.80% -1.18% -0.10%            -0.46%             0.005%

October               -3.20% -3.58% -3.80%              -4.16%             0.149%

November 2.80% 2.43%          2.30%              1.94%              0.047%

December 0.80%                    0.43% 0.30%             -0.06%             0.000%

                  E(Ri)     = 0.375%                          E(Rm) 0.358%                               0.637%

variance:

portfolio variance =

[(4.925)2+( -2.775) 2 +(-2.175) 2 +( 2.125) 2 + (0.525) 2 + (-1.475) 2

+ (-0.175) 2 + (0.925) 2 + (-1.175) 2 + (-3.575) 2 + (2.425) 2 + (0.425) 2] /12

= 5.40

S&P 500 variance =

[(5.142)2+( -3.258) 2 +(-1.458) 2 +( 1.642) 2 + (0.142) 2 + -0.858) 2

+ (0.042) 2 + (1.342) 2 + (-0.458) 2 + (-4.158) 2 + (1.942) 2 + (-0.058) 2] /12

=5.48

standard deviation = sqaure root of variance

portfolio = =2.32

S&P 500 = = 2.34

STEP 2 calculating covariance

covariance = 63.7/12

= 5.31

calculating R = Covariance/ (SD of portfolio x SD of S&P 500)

= 5.31/(2.32 x 2.34)

= 0.98

STEP 3

value or R2 = 0.98 x 0 .98 = 0 .95

value of beta = covariance of S&P 500/ variance of S&P

= 5.31/ 5.48

= 0.97

value of alpha = E(Ri) - Beta (E(Rm))

0.375 - (0.97 (0.358)

= 0.03

STEP 4

Average return difference (with signs): %

month        portfolio return         S&P %)) RETURN              Return diff

January                5.30%                    5.50%                               -0.002

Februa                  -2.40%               -2.90%                              0.005

March                    -1.80% -1.10%                           -0.007

April                        2.50%                 2.00%                             0.005

May                        0.90%                  0.50%                              0.004

June                     -1.10%                 -0.50%                             -0.006

July                         0.20%                  0.40%                             -0.002

August                  1.30%                  1.70%                              -0.004

September         -0.80%               -0.10%                             -0.007

October               -3.20%               -3.80%                             0.006

November          2.80%                2.30%                              0.005

December           0.80%                 0.30%                             0.005

AVERAGE RETURN DIFFERNCE ( WITH SIGN )    = 0.0167%

Average return difference (without signs) %

month           portfolio return      S&P %)) RETURN              return diff

January               0.053                      0.055                                     -0.002

February              0.024                    0.029                                    0.007

April                     0.025                      0.02                                        0.005

May                     0.009                      0.005                                     0.004

June                    0.011                     0.005                                      0.006

July                      0.002                      0.004                                    -0.002

August                0.013                     0.017                                     -0.004

September         0.008                    0.001                                      0.007

October               0.032                    0.038                                    -0.006

November          0.028                   0.023                                      0.005

December           0.008                    0.003                                      0.005

AVERAGE RETURN DIFFERNCE WITHOUT SIGN             =0.167%


Related Solutions

Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute...
Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute the average return differential with and without sign. Do not round intermediate calculations. Round your answers to two decimal places. Month Portfolio Return S&P 500 Return January 6.0 % 6.3 % February -2.6 -3.3 March -1.5 -1.3 April 2.3 1.7 May 0.7 -0.1 June -0.9 -0.3 July 0.5 0.8 August 1.5 1.8 September -0.4 0.2 October -3.0 -3.5 November 2.9 2.4 December 0.4 -0.1...
Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute...
Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute the average return differential with and without sign. Do not round intermediate calculations. Round your answers to two decimal places. Month Portfolio Return S&P 500 Return January 5.8 % 6.0 % February -2.4 -3.3 March -1.9 -1.3 April 2.4 1.6 May 0.5 0.2 June -1.0 -0.6 July 0.2 0.4 August 1.4 1.9 September -0.5 -0.3 October -3.5 -3.8 November 2.5 1.9 December 0.4 0.0...
Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute...
Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute the average return differential with and without sign. Do not round intermediate calculations. Round your answers to two decimal places. Month Portfolio Return S&P 500 Return January 5.5 % 5.7 % February -2.3 -3.2 March -1.9 -1.1 April 2.3 1.8 May 0.9 0.2 June -0.5 0.0 July 0.0 0.2 August 1.3 1.5 September -0.3 0.2 October -3.7 -4.2 November 2.3 1.5 December 0.3 0.1...
Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio.
Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute the average return differential with and without sign. Do not round intermediate calculations. Round your answers to two decimal places.R2:   Alpha:   %Beta:   Average return difference (with signs):   %Average return difference (without signs)   %
Given the monthly returns that follow: Month Portfolio Return S&P 500 Return Jan. 5.5.% 5.8% Feb....
Given the monthly returns that follow: Month Portfolio Return S&P 500 Return Jan. 5.5.% 5.8% Feb. -2.4 -3.3 March -1.8 -1.5 April 2.7 2.0 May 0.7 -0.1 June -0.9 -0.4 July 0.1 0.5 August 1.5 2.0 September -0.8 -0.6 October -3.2 -3.7 November 2.4 1.6 December 0.6 0.1 Calculate R2:    Alpha:   % Beta:    Average return difference (with signs):   % Average return difference (without signs)   %
CAPM and expected​ returns.. a.  Given the following​ holding-period returns, compute the average returns and the...
CAPM and expected​ returns.. a.  Given the following​ holding-period returns, compute the average returns and the standard deviations for the Zemin Corporation and for the market. b.  If​ Zemin's beta is 1.88 and the​ risk-free rate is 7 percent, what would be an expected return for an investor owning​ Zemin? ​ (Note: Because the preceding returns are based on monthly​ data, you will need to annualize the returns to make them comparable with the​ risk-free rate. For​ simplicity, you can...
A firm has two mutually exclusive investment opportunities, Alpha and Beta. Returns on the projects are...
A firm has two mutually exclusive investment opportunities, Alpha and Beta. Returns on the projects are as follows: Project Alpha: returns $300 million after one year with probability 40% and $50 million after one year with probability 60%. Project Beta returns $180 million after one year for certain. Assume that all investors are risk-neutral so that present values can be calculated by discounting expected future cash flows at the risk-free interest rate of 5% per year. Also, assume that all...
Explain beta concept and how can you find the beta of an asset or portfolio? Identify...
Explain beta concept and how can you find the beta of an asset or portfolio? Identify key components of the CAPM model. What is SML? What method would you use to establish risk and return relationships?
Below you can find the comparative financial statements of “Alpha – Beta” company in € for...
Below you can find the comparative financial statements of “Alpha – Beta” company in € for years 2017 and 2018: Comparative Balance Sheet of “Alpha- Beta” Assets 2018 2017 Liabilities & Stockholders’ Equity 2018 2017 Fixed Assets Property, Plant and Equipment Accumulated depreciation Net Property, Plant and Equipment Other Assets Total Fixed Assets Current Assets Cash and Cash Equivalents Accounts receivables Inventory Prepaid Expenses Total Current Assets Total Assets 3,250,000 (425,000) 2,825,000 725,000 3,550,000 300,000 900,000 1,100,000 100,000 2,400,000 5,950,000...
For this assignment, you will implement the minimax algorithm with alpha-beta pruning in order to find...
For this assignment, you will implement the minimax algorithm with alpha-beta pruning in order to find the optimal move for a game of generalized tic-tac-toe. In this version of the game, the players can choose different board sizes, for example 4x4 or 5x5, instead of the normal 3x3. The game proceeds with the usual rules for tic-tac-toe (see https://en.wikipedia.org/wiki/Tic-tac-toe). Requirements You are to modify the mp2basecode (below) program to implement the alpha-beta search for making the computer’s move. This will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT