You are the manager of a stock portfolio. On October 1, your holdings consist of the ten stocks (please see in the data file), which you intend to sell on December 31. You are concerned about a market decline over the next three months. The number of shares, and their prices are shown in the table. Others information can be filled/calculated from the dataset. On October 1, you decide to execute a hedge using a particular stock index futures contract, which has a $500 multiplier. The March contract price is 450.20. On December 31, the March contract price is 465.5

Determine the beta for each share (assume a 360-day year).

Stock Beta 1 Oct Weight 1st Oct Price 81.84 ABT BAC 28.44 CMCSA INTC KO Number of shares 16,000.00 7,000.00 2,000.00 4,000.00 15,000.00 20,000.00 17,000.00 20,000.00 20,000.00 11,000.00 31 Dec Price 86.86 35.22 44.97 59.85 55.35 197.61 90.95 323.57 39.18 108.17 44.52 50.76 54.65 209.02 83.61 269.58 35.43 102.53 1st Oct Value 1,309,440 199,080 89,040 203,040 819,750 4,180,400 1,421,370 5,391,600 708,600 1,127,830 31 Dec Value 1,389,760 246,540 89,940 239,400 830,250 3,952,200 1,546,150 6,471,400 783,600 1,189,870 MCD MRK NFLX PFE PYPL Stock Beta 1 Oct Weight 1st Oct Price 81.84 ABT BAC 28.44 CMCSA INTC KO Number of shares 16,000.00 7,000.00 2,000.00 4,000.00 15,000.00 20,000.00 17,000.00 20,000.00 20,000.00 11,000.00 31 Dec Price 86.86 35.22 44.97 59.85 55.35 197.61 90.95 323.57 39.18 108.17 44.52 50.76 54.65 209.02 83.61 269.58 35.43 102.53 1st Oct Value 1,309,440 199,080 89,040 203,040 819,750 4,180,400 1,421,370 5,391,600 708,600 1,127,830 31 Dec Value 1,389,760 246,540 89,940 239,400 830,250 3,952,200 1,546,150 6,471,400 783,600 1,189,870 MCD MRK NFLX PFE PYPL