Part 1 (50 pts) Construct a way to monitor the margin call for a long and short position in a future contract with one year maturity entered into at time zero using the Excel template given. Please calculate the daily gain/loss, cumulative gain/loss, margin account balance and margin call for long position and short position. Correct calculation of the daily gain/loss and cumulative gain/loss (20 points) Correct calculation of the margin account balance and margin call (30 points) Complete 50 points Partial 40 points Insufficient 20 point Missing O points Part 1 (50 pts) Construct a way to monitor the margin call for a long and short position in a future contract with one year maturity entered into at time zero using the Excel template given. Please calculate the daily gain/loss, cumulative gain/loss, margin account balance and margin call for long position and short position. Correct calculation of the daily gain/loss and cumulative gain/loss (20 points) Correct calculation of the margin account balance and margin call (30 points) Complete 50 points Partial 40 points Insufficient 20 point Missing O points