The yellow boxes at the bottom need to be filled with the correct formulas on excel

Corporate Valuation, Investment Decisions and Risk Management Lecture Note 1 Calculating Beta and CAPM Required Returns for Individual Assets Ex. 1.5 Economy Recession Below Avg. Average Above Avg. Boom Sum Prob 0.10 0.20 0.40 0.20 0.10 1.00 T-Bill 8.0% 8.0% 8.0% 8.0% 8.0% Hi-Tech -22.0% -2.0% 20.0% 35.0% 50.0% Colls 28.0% 14.7% 0.0% -10.0% -20.0% USR Mkt Port 10.0% -13.0% -10.0% 1.0% 7.0% 15.0% 45.0% 29.0% 30.0% 43.0% km u(R) (Exp Return) o(R) (Variance) O(R) (Std Devn) KRE 8.00% 0.00000 0.00% 17.40% 0.04014 20.04% 1.74% 0.01786 13.36% 13.80% 0.03542 18.82% 15.00% 0.02352 15.34% 0 0.03052 -0.020356 0.021 0.02352 im (Covariance) Bim (Beta) SML Req'd. Return