Using a Spreadsheet to Calculate Profit and Loss on Futures Transactions: At the beginning of the quarter, you purchased a $100,000 Treasury bond futures contract for 108-12. Calculate the profit on the futures contract if the price at the end of the quarter is 106-16, 108-20, 110-8, and 112-02. (LG 10-2)

Price at Beginning of Quarter Price at ⇒

End of Quarter The Profit or Loss Is

$100,000 × 108.375 = 108,375 $100,000 × 106.5 = 106,500 –$ 1,875 100,000 × 108.375 = 108,375 100,000 × 108.625 = 108,625 $250 100,000 × 108.375 = 108,375 100,000 × 110.25 = 110,250 1,875 100,000 × 108.375 = 108,375 100,000 × 112.0625 = 112,062.5 3,687.5 AppendixLO1