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 Beta Ist Oct Price 31 Dec Price Ist Oct Value 31 Dec Value 1 Oct Weight Number of shares 16,000.00 1 ABT 2 BAC 3 CMCSA 7,000.00 2.000.00 4,000.00 4 INTC 5 KO 15,000.00 6 MCD 20,000.00 7 MRK 17,000.00 20,000.00 8 NFLX 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 Beta Ist Oct Price 31 Dec Price Ist Oct Value 31 Dec Value 1 Oct Weight Number of shares 16,000.00 1 ABT 2 BAC 3 CMCSA 7,000.00 2.000.00 4,000.00 4 INTC 5 KO 15,000.00 6 MCD 20,000.00 7 MRK 17,000.00 20,000.00 8 NFLX 9 PFE 20,000.00 10 PYPL 11,000.00