I need to help filling out the excel sheeting using the data provided. I need to figure out Stock A's Beta, Stock B's Beta, Mean Return, etc.

| PVldle, mpel, pui, LiV), Llype]). Risk & Return Spreadsheet Example 4 Module V Name: Date: Market Closing Return 9 10 Month 11 Dec. '16 12 Jan. '17 13 Feb. 14 March 15 April 16 May 17 June 18 July 19 Aug. 20 Sept. 21 Oct 22 Nov. 23 Dec. 24 Jan. '18 25 Feb. 26 March 27 April 28 May 29 June 30 July 31 Aug. 32 Sept. 33 Oct. 34 Nov. 35 Dec. Stock A's Stock A's Stock B's Stock B's Stock C's Stock C's Closing Closing Closing Closing Closing Closing Price Return Price Return Price Return 65.00 81.00 26.00 66.00 82.00 26.50 66.25 82.50 27.25 67.75 83.25 28.00 68.25 83.00 28.55 69.00 83.75 29.00 70.00 84.25 29.25 72.25 85.75 30.00 73.50 86.75 29.25 72.75 85.00 28.00 73.45 88.25 29.75 74.50 87.50 30.25 75.00 88.00 31.00 74.05 87.00 29.50 73.75 88.25 29.25 74.05 92.00 30.25 75.25 91.25 31.00 76.50 94.00 31.75 75.75 92.75 32.75 76.35 92.00 33.00 77.50 95.50 34.50 76.25 96.25 35.00 77.00 95.50 34.00 78.00 96.00 33.00 76.00 95.00 34.00 Market Closing Index 990.00 993.38 997.64 1000.58 1001.58 1003.59 1017.37 1025.26 1036.38 1032.29 1046.17 1048.25 1053.25 1050.38 1049.89 1052.94 1060.53 1065.78 1068.73 1070.62 1072.75 1075.52 1074.00 1073.25 1075.01 36 37 Mean Return 38 Standard Deviation 39 95.00 34.00 1075.01 35 Dec. 76.00 36 37 Mean Return 38 Standard Deviation 39 40 41 42 Stock A's Beta 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 Stock B's Beta 65 66 67 PV rate, nper, pmt, [ty], [type]) ; 85 86 Stock C's Beta 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 2. Calculation of Portfolio Beta and Portfolio Return 110 111 Weighted 112 Investment Average 113 Stock Amount Weight Beta Beta 114 A 115 B 116 C 117 Total Portfolio Beta 119 Average Weighted Monthly Average Return Return Stock Weight 118 Portfolio Monthly Return Portfolio Annual Return 120 121 3. If the annual risk-free rate, Rrf, will be 4 percent in 2019 and the expected return on the market index, 122 E(Rm), will be 10 percent, what is your portfolio's required rate of return according to the CAPM? 123 124 E(Rp) = R r + (E(Rm) - RAB, = formula 125 E(Rp) = 126 127 128 129 130 131 132 | PVldle, mpel, pui, LiV), Llype]). Risk & Return Spreadsheet Example 4 Module V Name: Date: Market Closing Return 9 10 Month 11 Dec. '16 12 Jan. '17 13 Feb. 14 March 15 April 16 May 17 June 18 July 19 Aug. 20 Sept. 21 Oct 22 Nov. 23 Dec. 24 Jan. '18 25 Feb. 26 March 27 April 28 May 29 June 30 July 31 Aug. 32 Sept. 33 Oct. 34 Nov. 35 Dec. Stock A's Stock A's Stock B's Stock B's Stock C's Stock C's Closing Closing Closing Closing Closing Closing Price Return Price Return Price Return 65.00 81.00 26.00 66.00 82.00 26.50 66.25 82.50 27.25 67.75 83.25 28.00 68.25 83.00 28.55 69.00 83.75 29.00 70.00 84.25 29.25 72.25 85.75 30.00 73.50 86.75 29.25 72.75 85.00 28.00 73.45 88.25 29.75 74.50 87.50 30.25 75.00 88.00 31.00 74.05 87.00 29.50 73.75 88.25 29.25 74.05 92.00 30.25 75.25 91.25 31.00 76.50 94.00 31.75 75.75 92.75 32.75 76.35 92.00 33.00 77.50 95.50 34.50 76.25 96.25 35.00 77.00 95.50 34.00 78.00 96.00 33.00 76.00 95.00 34.00 Market Closing Index 990.00 993.38 997.64 1000.58 1001.58 1003.59 1017.37 1025.26 1036.38 1032.29 1046.17 1048.25 1053.25 1050.38 1049.89 1052.94 1060.53 1065.78 1068.73 1070.62 1072.75 1075.52 1074.00 1073.25 1075.01 36 37 Mean Return 38 Standard Deviation 39 95.00 34.00 1075.01 35 Dec. 76.00 36 37 Mean Return 38 Standard Deviation 39 40 41 42 Stock A's Beta 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 Stock B's Beta 65 66 67 PV rate, nper, pmt, [ty], [type]) ; 85 86 Stock C's Beta 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 2. Calculation of Portfolio Beta and Portfolio Return 110 111 Weighted 112 Investment Average 113 Stock Amount Weight Beta Beta 114 A 115 B 116 C 117 Total Portfolio Beta 119 Average Weighted Monthly Average Return Return Stock Weight 118 Portfolio Monthly Return Portfolio Annual Return 120 121 3. If the annual risk-free rate, Rrf, will be 4 percent in 2019 and the expected return on the market index, 122 E(Rm), will be 10 percent, what is your portfolio's required rate of return according to the CAPM? 123 124 E(Rp) = R r + (E(Rm) - RAB, = formula 125 E(Rp) = 126 127 128 129 130 131 132