Requirement: Fill in the blanks with excel solution.

Problem 2 P1 D1 PO 2.4 31.3 5.4 12.3 0.5 0.3 Estimated Return 29.5 4.7 55.319148936% 7.563025210% 13.9 4.316546763% 18.5 8.108108108% 41 5.000000000% 4.225352113% 18.9 . 0.1 0.7 6.7 Problem 3 Required Return Beta Under/Over? Market Return 9.50% 8.70% RER 4.20% 3.70% 3.80% 1.2 8.20% 6.18% 8.00% 6.80% 0.4 0.6 1.1 1.3 5.00% 4.60% 11.75% 9.34% 7.90%