Mini Case 613 20-7 The following are data on August 2015 gold futures contracts: Hedging Month Last Change Prior Settle Open High Low Volume Aug 2015 1,158.6 6.2 1.152.4 1,154.1 1,165.7 1,153.5 853 A mining company wishes to hedge against a decline in gold prices between now and August The company has 2,500 oz. of gold to hedge (each futures contract is based on 100 oz.) a. If gold prices decline by $0.25 per oz., what is the change in value of 1 contract? b. How should the company hedge itself? What will be the value of the total futures position? c. If closing prices for the next four days are 1,158.6; 1,176.1; 1,183.0 and 1,172.0, what are the losses and profits each day for the company? What was the company's net gain (loss) over the 4 days? d. If the futures contract matured in August at 1,161.7, how much did the company gain or lose by hedging? Spreadsheet Problem 20-8 Start with the partial model in the file Ch 20 Build a Medells from the textbook's website