please explain in EXCEL with formulas
You took a long position in 10 Eurodilar futures contracts (June 2023 delivery) on 1/13/2021 at the price indicated below. You met all margin calls, and did not withdraw any excess margin. All ED futures have a 90-day maturity and a notional principal of $1 million regardless of the delivery month. When the ED futures price increases by 1 basis point (98.35 to 98.36, for example), one long ED futures position gains $25, and one short ED futures position loses $25. A. Complete table 1 and provide an explanation of any fund deposited. B. How much is your total gain by the end of 1/21/2021? 90-day ED Sept 09 futures on 1/13/2021 Initial Margin Maintenance Margine TODAY A) Long Position Day (1) Futures Price Change (5) Gain / Losses (6) 98.54 $1,000 $800 1/13/21 10 contracts Beginning Funds Settlement Balance Deposited (3) Price (4) (2) 98.54 99.04 98.38 98.53 98.48 99.53 97 45 Ending Balance (7) Wednesday, January 13, 2021 Thursday, January 14, 2021 Friday, January 15, 2021 Monday, January 18, 2021 Tuesday, January 19, 2021 Wednesday, January 20, 2021 Thursday, January 21, 2021 You took a long position in 10 Eurodilar futures contracts (June 2023 delivery) on 1/13/2021 at the price indicated below. You met all margin calls, and did not withdraw any excess margin. All ED futures have a 90-day maturity and a notional principal of $1 million regardless of the delivery month. When the ED futures price increases by 1 basis point (98.35 to 98.36, for example), one long ED futures position gains $25, and one short ED futures position loses $25. A. Complete table 1 and provide an explanation of any fund deposited. B. How much is your total gain by the end of 1/21/2021? 90-day ED Sept 09 futures on 1/13/2021 Initial Margin Maintenance Margine TODAY A) Long Position Day (1) Futures Price Change (5) Gain / Losses (6) 98.54 $1,000 $800 1/13/21 10 contracts Beginning Funds Settlement Balance Deposited (3) Price (4) (2) 98.54 99.04 98.38 98.53 98.48 99.53 97 45 Ending Balance (7) Wednesday, January 13, 2021 Thursday, January 14, 2021 Friday, January 15, 2021 Monday, January 18, 2021 Tuesday, January 19, 2021 Wednesday, January 20, 2021 Thursday, January 21, 2021