Spreadsheet: 3630210b-f969-4691-9939-a222b2ac149d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | by [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  | Last modified on 5/25/11
 |  |  |  |  |  | <=data input cells are yellow
Crop Estimated Costs and Returns, Minnesota, Projected 2011, Late Planting Scenarios |  |  |  |  |  | <=white cells are calculated
Per Acre | Corn | Soybeans | Corn 5% higher price | Corn 10% lower yield, 5% higher price | Corn 25% lower yield, no price change | Soybean 5% lower price
REVENUE
Yield per acre | 164 | 42 | 164 | 147.6 | 123 | 42
 | bushels | bushels | bushels | bushels | bushels | bushels
Price per unit | 6 | 12.5 | 6.300000000000001 | 6.300000000000001 | 6 | 11.875
Government payments | 38.25136000000001 | 15.39384 | 38.25136000000001 | 38.25136000000001 | 38.25136000000001 | 15.39384
Miscellaneous income | 4.109999999999999 | 7.11 | 4.109999999999999 | 4.109999999999999 | 4.109999999999999 | 7.11
Total Revenue | 1026.36136 | 547.50384 | 1075.56136 | 972.2413600000001 | 780.36136 | 521.25384
COSTS
Seed | 109.875 | 55 | 109.875 | 109.875 | 109.875 | 55
Fertilizer | 103 | 7.2 | 103 | 103 | 103 | 7.2
Crop chemicals | 40.81 | 42.77 | 40.81 | 40.81 | 40.81 | 42.77
Crop insurance | 19.46564307078764 | 18.39889332003988 | 19.46564307078764 | 19.46564307078764 | 19.46564307078764 | 18.39889332003988
Miscellaneous | 43.25569720132984 | 35.8001986539583 | 43.25569720132984 | 43.25569720132984 | 43.25569720132984 | 35.8001986539583
Machinery w/Labor | 70.12 | 65.83000000000001 | 70.12 | 70.12 | 70.12 | 65.83000000000001
Crop drying | 46.26040360501568 | 1.324784482758621 | 46.26040360501568 | 46.26040360501568 | 46.26040360501568 | 1.324784482758621
Transport | 27.99169072122768 | 7.168603721290015 | 27.99169072122768 | 27.99169072122768 | 27.99169072122768 | 7.168603721290015
Labor & Mgmt (Non-machinery) | 48.57960784313725 | 29.2106432748538 | 48.57960784313725 | 48.57960784313725 | 48.57960784313725 | 29.2106432748538
Rent | 147.2524157303371 | 126.8755056179775 | 147.2524157303371 | 147.2524157303371 | 147.2524157303371 | 126.8755056179775
Interest on pre-harvest var. expenses | 11.44364585163163 | 6.356335263614408 | 11.44364585163163 | 11.44364585163163 | 11.44364585163163 | 6.356335263614408
Total Listed Costs | 668.0541040234666 | 395.9349643344926 | 668.0541040234666 | 668.0541040234666 | 668.0541040234666 | 395.9349643344926
NET RETURN | 358.3072559765333 | 151.5688756655073 | 407.5072559765333 | 304.1872559765335 | 112.3072559765334 | 125.3188756655073
Per Acre | Corn | Soybeans | Corn 5% higher price | Corn 10% lower yield, 5% higher price | Corn 25% lower yield, no price change | Soybean 5% lower price | $/unit
Production Inputs Used for Budgets:
Seeding rate (lbs, seeds, etc.) | 34 | 1 | 34 | 34 | 34 | 1
Seed price, $/unit | 2.9375 | 45 | 2.9375 | 2.9375 | 2.9375 | 45
Roundup Ready fee, $/acre | 10 | 10 | 10 | 10 | 10 | 10
Fertilizer:
N | 140 | 0 | 140 | 140 | 140 | 0 | 0.41
P2O5 | 30 | 10 | 30 | 30 | 30 | 10 | 0.52
K2O | 50 | 5 | 50 | 50 | 50 | 5 | 0.4
Application | 1 |  | 1 | 1 | 1 |  | 10
Chemicals:
Glyphosate, 4.5L (oz) | 44 | 48 | 44 | 44 | 44 | 48 | 0.49
AMS (qt) | 3 | 3 | 3 | 3 | 3 | 3 | 1.75
Axial (oz) |  |  |  |  |  |  | 0.9
Headline (oz) |  |  |  |  |  |  | 2.81
Folicur (oz) |  |  |  |  |  |  | 0.75
Proline (oz) |  |  |  |  |  |  | 4
Penncap (oz) |  |  |  |  |  |  | 0.01
Raptor (oz) |  |  |  |  |  |  | 4.69
Warrior (oz) |  |  |  |  |  |  | 3.2
Apply crop chemicals | 2 | 2 | 2 | 2 | 2 | 2 | 7
Total chemical cost | 40.81 | 42.77 | 40.81 | 40.81 | 40.81 | 42.77
Click here for the web page where you can download the "Machinery Cost Estimates" extension publication with more details on the machinery costs and a larger list of machines.
Per Acre | Corn | Soybeans | Corn 5% higher price | Corn 10% lower yield, 5% higher price | Corn 25% lower yield, no price change | Soybean 5% lower price | $/acre
Machinery and Labor Resources Used: | - - - Passes per year - - -
Chisel Plow 37 Ft | 1 | 1 | 1 | 1 | 1 | 1 | 8.68
Field Cultivator  60 Ft | 2 | 2 | 2 | 2 | 2 | 2 | 4.8
Row Crop Planter 24 Row-30, 40 Ft | 1 | 1 | 1 | 1 | 1 | 1 | 11.56
[NAME]  30 Ft |  |  |  |  |  |  | 11.55
Cultipacker seeder 12 Ft |  |  |  |  |  |  | 10.02
Row Cultivator 12 Row-30, 40 Ft | 1 | 1 | 1 | 1 | 1 | 1 | 6.64
Hay Rake (Wheel, 2-16') 30 Ft |  |  |  |  |  |  | 3.32
[NAME] 14 Ft |  |  |  |  |  |  | 10.93
[NAME] 1500 Lb, 20 Ft |  |  |  |  |  |  | 8.52
[NAME], 15 Ft |  |  |  |  |  |  | 47
[NAME]  30 Ft |  |  |  |  |  |  | 21.66
[NAME] Ft |  | 1 |  |  |  | 1 | 29.35
[NAME] 8 Row-30, 20 Ft | 1 |  | 1 | 1 | 1 |  | 33.64
Note:  This section calculates a total column which is a weighted average of the crops included in each of two rotations.
Crop | Corn | Soybeans | Corn 5% higher price | Corn 10% lower yield, 5% higher price | Corn 25% lower yield, no price change | Soybean 5% lower price
Rotation (1 or 2, if none enter 0) | 1 | 1 | 0 | 2 | 0 | 2 | (dropdown menus)
Rotation 1 calculations: | Corn | Soybeans | Corn 5% higher price | Corn 10% lower yield, 5% higher price | Corn 25% lower yield, no price change | Soybean 5% lower price | Rotation 1 Average Per Acre | Farm Total Acres
Percent of rotation 1 (total  - 100%) | 0.5 | 0.5 | 0 | 0 | 0 | 0 | 1 | 1000
REVENUE | 1026.36136 | 547.50384 | 0 | 0 | 0 | 0 | 786.9325999999999 | 786932.5999999999
COSTS
Seed | 109.875 | 55 | 0 | 0 | 0 | 0 | 82.4375 | 82437.5
Fertilizer | 103 | 7.2 | 0 | 0 | 0 | 0 | 55.1 | 55100
Crop chemicals | 40.81 | 42.77 | 0 | 0 | 0 | 0 | 41.79 | 41790
Crop insurance | 19.46564307078764 | 18.39889332003988 | 0 | 0 | 0 | 0 | 18.93226819541376 | 18932.26819541376
Miscellaneous | 43.25569720132984 | 35.8001986539583 | 0 | 0 | 0 | 0 | 39.52794792764408 | 39527.94792764408
Machinery | 70.12 | 65.83000000000001 | 0 | 0 | 0 | 0 | 67.97500000000001 | 67975.00000000001
Crop drying | 46.26040360501568 | 1.324784482758621 | 0 | 0 | 0 | 0 | 23.79259404388715 | 23792.59404388715
Transport | 27.99169072122768 | 7.168603721290015 | 0 | 0 | 0 | 0 | 17.58014722125885 | 17580.14722125885
Labor & Management | 48.57960784313725 | 29.2106432748538 | 0 | 0 | 0 | 0 | 38.89512555899553 | 38895.12555899553
Rent | 147.2524157303371 | 126.8755056179775 | 0 | 0 | 0 | 0 | 137.0639606741573 | 137063.9606741573
Interest on pre-harvest var. expenses | 11.44364585163163 | 6.356335263614408 | 0 | 0 | 0 | 0 | 8.899990557623019 | 8899.99055762302
Total Listed Costs | 668.0541040234666 | 395.9349643344926 | 0 | 0 | 0 | 0 | 531.9945341789796 | 531994.5341789796
NET RETURN | 358.3072559765333 | 151.5688756655073 | 0 | 0 | 0 | 0 | 254.9380658210203 | 254938.0658210203
Rotation 2 calculations: | Corn | Soybeans | Corn 5% higher price | Corn 10% lower yield, 5% higher price | Corn 25% lower yield, no price change | Soybean 5% lower price | Rotation 2 Average Per Acre | Farm Total Acres
Percent of rotation 2 | 0 | 0 | 0 | 0.5 | 0 | 0.5 | 1 | 1000
REVENUE | 0 | 0 | 0 | 972.2413600000001 | 0 | 521.25384 | 746.7476 | 746747.6
COSTS | 0 | 0 | 0 | 0 | 0 | 0 | 0
Seed | 0 | 0 | 0 | 109.875 | 0 | 55 | 82.4375 | 82437.5
Fertilizer | 0 | 0 | 0 | 103 | 0 | 7.2 | 55.1 | 55100
Crop chemicals | 0 | 0 | 0 | 40.81 | 0 | 42.77 | 41.79 | 41790
Crop insurance | 0 | 0 | 0 | 19.46564307078764 | 0 | 18.39889332003988 | 18.93226819541376 | 18932.26819541376
Miscellaneous | 0 | 0 | 0 | 43.25569720132984 | 0 | 35.8001986539583 | 39.52794792764408 | 39527.94792764408
Machinery | 0 | 0 | 0 | 70.12 | 0 | 65.83000000000001 | 67.97500000000001 | 67975.00000000001
Crop drying | 0 | 0 | 0 | 46.26040360501568 | 0 | 1.324784482758621 | 23.79259404388715 | 23792.59404388715
Transport | 0 | 0 | 0 | 27.99169072122768 | 0 | 7.168603721290015 | 17.58014722125885 | 17580.14722125885
Labor & Management | 0 | 0 | 0 | 48.57960784313725 | 0 | 29.2106432748538 | 38.89512555899553 | 38895.12555899553
Rent | 0 | 0 | 0 | 147.2524157303371 | 0 | 126.8755056179775 | 137.0639606741573 | 137063.9606741573
Interest on pre-harvest var. expenses | 0 | 0 | 0 | 11.44364585163163 | 0 | 6.356335263614408 | 8.899990557623019 | 8899.99055762302
Total Listed Costs | 0 | 0 | 0 | 668.0541040234666 | 0 | 395.9349643344926 | 531.9945341789796 | 531994.5341789796
NET RETURN | 0 | 0 | 0 | 304.1872559765335 | 0 | 125.3188756655073 | 214.7530658210204 | 214753.0658210204
 |  |  |  |  |  |  |  |  |  | (Rotation choices for dropdown boxes in row 72)
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2