A food company buys large amounts of corn for manufacturing, but also sells some of the corn to other food manufacturers.

This year the company is afraid prices will drop on corn when it is time to sell corn to other companies.

The current price on February 1 for selling corn is $17 per bushel, and that is the price they want to receive for their future sales on July 1.

They plan on selling 5,000 bushels, which is also the amount of one corn futures contract.

The July corn futures current price on February 1 is $19, and it is anticipated that the future spot price of corn on July 1 will be $15, with the futures contract price on that date at $17.

Margins are 6%, and broker loans are at an 8% interest rate.

What is the gain/loss on a 1 contract hedge combined with the proposed company sale, at the prices assumed for July 1?

What is the gain/loss on a 1 contract hedge combined with the proposed company sale, at the prices assumed for July 1?

Group of answer choices

A. $5,190 loss (negative)

B. $810 loss (negative)

C. $190 loss (negative)

D. $3,810 gain (positive)

Please show work in Excel if possible