PLEASEEEEE SHOW FORMULAS ON THE EXCEL TABLE. THANK YOU!

Sarah Moore has taken a short position in one CBOT T-Bond futures contract at the price indicated below. She would meet all margin calls, but would not withdraw any excess margin. T-bond futures are traded at CBOT with T-bond of $100,000 face value as the underlying. The prices are quoted in points and 1/32 of a point with par on the basis of 100 points. For example, 134-16 represents 134 16/32. The dollar price is $134,500 per contract (134.5\% of $100,000). A. Download and complete the table and provide an explanation of any fund deposited. Assume the contract is purchased at the settlement price of that day, so there is no mark-tomarket profit or loss on the day of purchase. B. How much are Moore's total gains or losses by the end of day 6 ? Total deposit Ending Balance Net Gain Price at t=0 Price at t=6 Change \$Amount Sarah Moore has taken a short position in one CBOT T-Bond futures contract at the price indicated below. She would meet all margin calls, but would not withdraw any excess margin. T-bond futures are traded at CBOT with T-bond of $100,000 face value as the underlying. The prices are quoted in points and 1/32 of a point with par on the basis of 100 points. For example, 134-16 represents 134 16/32. The dollar price is $134,500 per contract (134.5\% of $100,000). A. Download and complete the table and provide an explanation of any fund deposited. Assume the contract is purchased at the settlement price of that day, so there is no mark-tomarket profit or loss on the day of purchase. B. How much are Moore's total gains or losses by the end of day 6 ? Total deposit Ending Balance Net Gain Price at t=0 Price at t=6 Change \$Amount