In: Finance
The table below shows daily returns on XYZ and Market.
|
Return of XYZ |
Return of Market |
|
|
Monday |
5% |
-4% |
|
Tuesday |
-3% |
3% |
|
Wednesday |
6% |
10% |
|
Thursday |
-10% |
-5% |
|
Friday |
8% |
7% |
Expected return of XYZ = [5%-3%+6%-10%+8%]/5 = 6%/5 = 1.2%
Expected return of market = [-4%+3%+10%-5%+7%]/5 = 11%/5 = 2.2%
| Days (i) | Return of XYZ (ii) | Return of Market (iii) | Return of XYZ - Expected return of XYZ (iv) | Return of market - Expected return of market (v) | (vi) = (iv)*(v) | (vii) = (v)^2 |
| Monday | 5% | -4% | 3.80% | -6.20% | -0.2356% | 0.3844% |
| Tuesday | -3% | 3% | -4.20% | 0.80% | -0.0336% | 0.0064% |
| Wednesday | 6% | 10% | 4.80% | 7.80% | 0.3744% | 0.6084% |
| Thursday | -10% | -5% | -11.20% | -7.20% | 0.8064% | 0.5184% |
| Friday | 8% | 7% | 6.80% | 4.80% | 0.3264% | 0.2304% |
| 1.2380% | 1.7480% |
Covariance of XYZ & market = Σ{[Return of XYZ - Expected return of XYZ]*[Return of market - Expected return of market]/N = 1.238%/5 = 0.2476%
Variance of market = Σ{[(Return of market - Expected return of market)^2]}/N = 1.748%/5 = 0.3496%
Beta of XYZ = Covariance of XYZ & market/Variance of market = 0.2476%/0.3496% = 0.7082