Create in Excel a Mark to Market for the following positions.

SHORT $10$ contracts per month for $1$ year $2020$ of Crude oil and LONG $10,000m\frac{m}{b}tu$ or $1$ contract Per Day of NG for $1$ year $2020.$

Assume these trades were initiated at the monthly prices in the HW#$2$ Settlements excel spreadsheet provided from $2020$ in Canvas

Pay attention to volumes and direction of trades.

Get the Notional value of each trade. hints do this $12$ times for each strip and then total them.

Then, Calculate how much you would make or lose if the price changed to these prices below. How much would futures be worth if the crude oil strip was $$80$ dollars and the natural gas strip was worth $$1\mathrm{.}75.$ Assume that all of the $13$ months are each the same price $$80$ and $$1\mathrm{.}75.$

How much would i lose in a mark to market?