Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please solve it in the given excel template and sh

Please solve it in the given excel template and show excel calculations. B....

80.2K

Verified Solution

Question

Finance

Please solve it in the given excel template and show excel calculations.

imageimage

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!
Become a Member

Other questions asked by students

Biology
1.2K views

7 6 PILAVI Smith B Pteronotus parnellii mesoamericanus Smith C Pteronotus parnellii mesoamericanus Smith orie...

Biology
1.2K views

A given sequence of bases in an mRNA will code for one and only one...

Physics
1.2K views

A 10 m long steel wire has mass of 5 g If wire is under...

Basic Math
1.2K views

A B C D E You have 22 pieces of Halloween candy and want to...

Basic Math
1.2K views

A driver gear is turning at 310 rpm and has 191 teeth. If the driven...

Basic Math
1.2K views

Determine whether the following statement is true or false, and explain why.In a Markov chain,...

Basic Math
1.2K views

Use the quadratic formula to solve for x.2x-8x=1Round your answer to the nearest hundredth.If there...

Accounting
1.2K views

E20-13 (L01,2,4) (Computation of Actual Return, Gains and Losses,...

Accounting
1.2K views

Ben Lieber is a waiter at Harbor House, where he receives a weekly wage of...

Accounting
1.2K views

3. At January 1, 2017 the Leon White Company had 400,000 shares of common stock...

Accounting
1.2K views

On December 31, 2020, Green Bank enters into a debt restructuring agreement with Teal Mountain...

Accounting
1.2K views

The partnership of Ramos, Rios, Safar, and Wong is being liquidated. It currently holds cash...