please explain in EXCEL with formulas

An Investment management firm wishes to decrease the bele of one of his portid for a five-month period. The portfolio has a market value of $200,000,000. The investment firm plans to use a futures contract priced at $102,500 in order to adjust the portfolio beta. The futures contract has a beta of 1.02. A) Calculate the number of futures contracts that should be bought or sold to achieve a decrease in the portfolio beta. The number of the contracts should be a whole number. B) At the end of 5 months, the overall equity market is down by 3.5%. The stock portfolio under management is down by 4.025% The futures contract is priced at $88,840.75. Calculate the value of the overall position and the effective (realized or ex post) beta of the portfolio 6 7 30 tes mo 4.025% 10 21 12 13 14 15 16 12 S-5200,000,000 Beta (stock) 1.15 Beta (19) 0.65 Beta(fut 1.02 $102,500 CHG(mkt) 1% $98,840.75 -3.50% 10 1 A) 20 21 22 B) No of contract Short or long? Value of position? Effective beta