Please solve it in the given excel template and show excel calculations. B....
80.2K
Verified Solution
Link Copied!
Question
Finance
Please solve it in the given excel template and show excel calculations.
B. Your cousins grow corn in Wisconsin and plan to harvest 7,000,000 bushels at the end of the season. They are unsure whether to sell the futures contracts and lock the price in at $5.05/bushel or take a gamble and sell it all at the spot price at season's end. They think they can get $4.50/bushel based on historical prices and their own analysis. Assuming no transaction costs and each contract covers 5,000 bushels, what will the cousins' profit/loss be if they sell the contracts and the spot price is $4.85 at maturity? Ukraine had a bumper harvest and spot prices fall to $4.70/bushel, what will the cousins' profit/loss be now? Ukraine b. Futures Prices Base Bushels Bushels/contract # of contracts Contract price Spot price Profit/(Loss) to cousins
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
