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 a. Determine the beta for each share (assume a 360-day year). b. Calculate the number of future contracts c. Calculate the gain/loss from the spot market d. Calculate the gain/loss from the future market e. Calculate total gain/loss Stock Number of shares Beta Ist Oet Price 31 Dec Price 1st Oct Value 31 Dec Value 1 Oct Weight 1 ABT 16,000.00 2 BAC 7,000.00 3 CMCSA 2.000.00 4 INTC 5 KO 4,000.00 15,000.00 20,000.00 6 MCD 7 MRK 17.000.00 8 NFLX 20,000.00 9 PFE 20.000.00 10 PYPL 11,000.00 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 a. Determine the beta for each share (assume a 360-day year). b. Calculate the number of future contracts c. Calculate the gain/loss from the spot market d. Calculate the gain/loss from the future market e. Calculate total gain/loss Stock Number of shares Beta Ist Oet Price 31 Dec Price 1st Oct Value 31 Dec Value 1 Oct Weight 1 ABT 16,000.00 2 BAC 7,000.00 3 CMCSA 2.000.00 4 INTC 5 KO 4,000.00 15,000.00 20,000.00 6 MCD 7 MRK 17.000.00 8 NFLX 20,000.00 9 PFE 20.000.00 10 PYPL 11,000.00