Prepare a schedule to determine the earnings effect of various hedging relationships. During the third quarter of the current year, Beamer Manufacturing Company invested in derivative instruments for a variety of reasons. The various investments and hedging relationships are as follows:

a. Call Option AThis option was purchased on July 10 and provided for the purchase of 10,000 units of commodity A in October at a strike price of $45 per unit. The company designated the option as a hedge of a commitment to sell 10,000 units of commodity A in October at a fixed price of $45 per unit. Information regarding the option and commodity A is as follows:

b. Call Option BThis option provide d for the purchase of 10,000 units of commodity B in October at a strike price of $30 per unit. The company designated the option as a hedge of a forecasted purchase of commodity B in October. Information regarding the option and commodity B is as follows:

c. Put Option CThis option provided for the sale of 10,000 units of commodity C in September at a strike price of $30 per unit. The company designated the option as a hedge of a forecasted sale of 10,000 units of commodity C on September 10. Information regarding the option and commodity C is as follows:

the spot price. The manufacturing cost of the units sold was $20 per unit.

d. Futures Contract DThe contract calls for the sale of 10,000 units of commodity D in October at a future price of $10 per unit. The company designated the contract as a hedge on a forecasted sale of commodity D in October. Information regarding the contract and commodity D is as follows:

e. Interest Rate SwapThe company has a 12-month note receivable with a face value of $10,000,000 that matures on June 30 of next year. The note calls for interest to be paid at the end of each month based on the LIBOR variable interest rate at the beginning of each month. On July 31, the company entered into an agreement to receive a 7% fixed rate of interest beginning in August in exchange for payment of a variable rate based on LIBOR. The reset date is at the beginning of each month, and net settlement occurs at the end of each month. LIBOR rates and swap values are as follows:

In all of the above cases, the change in the time value of the derivative instrument is excluded from the assessment of hedge effectiveness. Furthermore, the company assesses hedge effectiveness on a continuing basis. Such an assessment at the end of June concluded that call option B was not effective.

Prepare a schedule to reflect the effect on current earnings of the above hedging relationships. The schedule should show relevant amounts for each month from July through September.