{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Cost Analysis","Detailed Analysis"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Cost Analysis","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[4,1,4,2],[6,1,6,2],[11,1,11,4],[13,1,13,2],[14,1,14,2],[15,1,15,2],[19,1,19,4],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[26,1,26,2],[27,1,27,2],[30,1,30,4],[33,0,33,3]]}
[null,"Calculate potential profitability"]
[null,"GMO soybeans vs Non-GMO soybeans"]
[]
[null,"Assumptions"]
[null,"GMO Yield (bu/acre)",null,60]
[null,"Non-GMO Yield (bu/acre)",null,60]
[null,"Acres",null,1]
[null,"Futures Price","SX24",{"v":13.5,"d":"$13.50"}]
[null,"Basis",null,{"v":0,"d":"$0.00"}]
[]
[]
[null,"Soybean Input Costs/acre*"]
[{"$nulls":3},"GMO","Non-GMO"]
[null,"Seed",null,{"v":75,"d":"$75.00"},{"v":55,"d":"$55.00"}]
[null,"Crop Protection",null,{"v":75,"d":"$75.00"},{"v":90,"d":"$90.00"}]
[null,"Total Cost",null,{"$f":"SUM(D14:D15)","v":{"v":150,"d":"$150.00"}},{"$f":"SUM(E14:E15)","v":{"v":145,"d":"$145.00"}}]
[]
[]
[]
[null,"Estimated Revenue*"]
[{"$nulls":3},"GMO","Non-GMO"]
[null,"Futures Reference ($/bu)",null,{"$f":"$D$8","v":{"v":13.5,"d":"$13.50"}},{"$f":"$D$8","v":{"v":13.5,"d":"$13.50"}}]
[null,"Basis",null,{"$f":"$D$9","v":0},{"$f":"$D$9","v":0}]
[null,"Cash Price ($/bu)",null,{"$f":"D22+D23","v":{"v":13.5,"d":"$13.50"}},{"$f":"E22+E23","v":{"v":13.5,"d":"$13.50"}}]
[null,"Premium",null,0,{"v":2.3,"d":"$2.30"}]
[null,"Estimated price ($/bu)",null,{"$f":"D24+D25","v":{"v":13.5,"d":"$13.50"}},{"$f":"E24+E25","v":{"v":15.8,"d":"$15.80"}}]
[null,"Total inputs cost ($/bu)",null,{"$f":"-($D$14/$D$5)-($D$15/$D$5)","v":{"v":-2.5,"d":"$(2.50)"}},{"$f":"-($E$14/$D$6)-($E$15/$D$6)","v":{"v":-2.4166666666666665,"d":"$(2.42)"}}]
[null,"Total Revenue ($/bu)",null,{"$f":"(D26+D27)","v":{"v":11,"d":"$11.00"}},{"$f":"(E26+E27)","v":{"v":13.383333333333335,"d":"$13.38"}}]
[null,"Total Revenue ($/acre)",null,{"$f":"D28*$D$5","v":{"v":660,"d":"$660.00"}},{"$f":"E28*$D$6","v":{"v":803.0000000000001,"d":"$803.00"}}]
[]
[null,"*We have used typical market prices for seed and inputs in fall 2023.  Revenues are estimated and not exact."]

{"sheet":"Detailed Analysis","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"merged":[[0,1,0,6],[1,1,1,6],[3,1,3,6],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[null,"Compare FOB Your Farm Options"]
[null,"Cargill Non-GMO soybeans vs Other locations"]
[]
[null,"                        Estimated Price at Your Farm*"]
[{"$nulls":3},"Cargill Non-GMO","Location A","Location B","Location C"]
[null,"Futures Reference ($/bu)",null,{"$f":"'Cost Analysis'!$D$8","v":{"v":13.5,"d":"$13.50"}},{"$f":"'Cost Analysis'!$D$8","v":{"v":13.5,"d":"$13.50"}},{"$f":"'Cost Analysis'!$D$8","v":{"v":13.5,"d":"$13.50"}},{"$f":"'Cost Analysis'!$D$8","v":{"v":13.5,"d":"$13.50"}}]
[null,"Basis",null,0,{"v":0.2,"d":"$0.20"},{"v":-0.2,"d":"$(0.20)"},{"v":-0.25,"d":"$(0.25)"}]
[null,"Cash Price ($/bu)",null,{"$f":"D6+D7","v":{"v":13.5,"d":"$13.50"}},{"$f":"E6+E7","v":{"v":13.7,"d":"$13.70"}},{"$f":"F6+F7","v":{"v":13.3,"d":"$13.30"}},{"v":13.25,"d":"$13.25"}]
[null,"Premium",null,{"v":2.3,"d":"$2.30"},0,0,0]
[null,"Freight",null,{"v":0.3,"d":"$0.30"},{"v":0.2,"d":"$0.20"},{"v":0.15,"d":"$0.15"},{"v":0.1,"d":"$0.10"}]
[null,"Estimated price at your farm ($/bu)",null,{"$f":"D8+D9-D10","v":{"v":15.5,"d":"$15.50"}},{"$f":"E8+E9-E10","v":{"v":13.5,"d":"$13.50"}},{"v":13.15,"d":"$13.15"},{"v":13.15,"d":"$13.15"}]