3. 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 Price at > The Profit Beginning End of or Loss Is of Quarter Quarter

$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