Corn

Document Sample
Corn Powered By Docstoc
					SDSU Cooperative Extension Service
2011 Draft of Projections




This spreadsheet may be used to estimate revenues and costs per crop. In the spreadsheet, revenue is
calculated by entering expected yield and price. Other income includes government payments and any crop
residue sales on a per acre basis. Line item estimates are listed below. These items are best estimated from your
records or expected costs in your area. Machinery operating costs include fuel, oil, and repairs. The cost
estimates are calculated using a "Machinery Cost Calculator". Price estimates for diesel are $2.75 per gallon and
an operating loan at 7.5%. "Blank lines" are left for costs that are material and unique to your operation and may
be inserted as needed. Machinery ownership costs are depreciation, interest at 8%, insurance, and housing. Land
is at rental rate.

Jack B. Davis, Management Specialist
Cooperative Extension Service
PO Box 397
Woonsocket, SD 57385
605-796-4841

Special thanks to SDSU Extension and Industry Specialists for their input.

This spreadsheet is intended for educational purposes only.

  DISCLAIMER
The authors and distributors of the template assume no liability for
use or misuse of this template or the decisions which result.
et, revenue is
ents and any crop
est estimated from your
 airs. The cost
 e $2.75 per gallon and
 ur operation and may
 nce, and housing. Land
                         SDSU Cooperative Extension Service


Enter your cost estimates in yellow shaded cells. These will carry thru to
      crop budget. Enter remaining costs on specific crop budget.



Table 1: Production Inputs Corn                     Table 2: Production Inputs Winter Wheat
       Item      Quantity Price Unit Cost/ac               Item      Quantity Price  Unit  Cost/ac
Seed                 25.0   3.07 1,000 $ 76.75      Seed              140.0    0.16  lbs $ 22.40
Fertilizer                             $ 129.60     Fertilizer (lbs)                      $ 97.70
  N                200.0    0.48 lbs                 N                150.0    0.48  lbs
  N                               lbs                N                               lbs
  P                  60.0   0.50 lbs                 P                 52.0    0.50  lbs
  K                         0.38 lbs                 K                         0.38  lbs
  Lime                            lbs
  Zinc                1.0   4.00   qt
Herbicide                              $ 20.02      Herbicide                            $    8.82
  Harness Extra       1.2   8.25   qt                 Wolfpack        0.8    4.70   pt
  Roundup            44.0   0.23 oz                   Roundup        22.0    0.23   oz
Insecticide                            $    -       Insecticide                          $     -

Fungicide                                $    -     Fungicide                            $ 17.82
                                                     Stretgo         5.00    1.08
                                                     Prosaro         6.50    1.91

Table 3: Production Inputs Soybeans                 Table 4: Production Inputs Spring Wheat
       Item      Quantity Price Unit     Cost/ac           Item      Quantity Price  Unit  Cost/ac
Seed               150.0    0.35 1,000   $ 52.50    Seed              140.0    0.13  lbs $ 18.20
Fertilizer (lbs)                         $ 31.26    Fertilizer (lbs)            .         $ 97.70
  N                  11.0   0.48 lbs                 N                150.0    0.48  lbs
  N                               lbs                N                               lbs
  P                  52.0   0.50 lbs                 P                 52.0    0.50  lbs
  K                         0.38 lbs                 K                         0.38  lbs
                                  lbs
                                  lbs
Herbicide                                $ 15.28    Herbicide                            $    8.82
  Select              4.0   1.29 oz                   Wolfpack        0.8    4.70   pt
  Roundup            44.0   0.23 oz                   Roundup        22.0    0.23   oz
Insecticide                              $   3.81   Insecticide                          $     -
  Baythroid            2.8  1.36 oz
Fungicide                                $    -     Fungicide                            $ 17.82
                                                     Stretgo         5.00    1.08
                                                      Prosaro        6.50    1.91

Table 5: Production Inputs Sunflowers
     Item        Quantity Price Unit     Cost/ac
Seed                21.2    1.10 1,000 $ 23.32
Fertilizer (lbs)                       $ 56.30
 N                 100.0    0.48 lbs
 N                                lbs
 P                  17.0    0.50 lbs
 K                          0.38 lbs
                                  lbs
                                  lbs
Herbicide                              $ 35.60
  Spartan Adv.       1.0   22.10   qt
  Prowl              3.0    4.50   pt
Insecticide                            $   -

Fungicide                             $    -
                                               Corn


                                                  CORN
Gross return
 Estimated Yield                                      180
  Estimated Selling price                  $                  4.75
 Value per acre                            $                855.00
 Other income per acre
Gross Return per acre                      $                855.00

Direct costs per acre
 Seed                                      $                 76.75
 Fertilizer                                                 129.60
 Herbicide                                                   20.02
 Insecticide                                                   -
 Fungicide                                                     -
 Crop Insurance                                              25.00
 Machinery Costs (Operating)                                 43.00
 Custom hire                                                   -
 Drying                                                      12.00
 Operating Interest                                          18.38
 Other variable costs                                          -
                                                               -
Total direct costs per acre                $                324.75
Return over direct cost per acre           $                530.25
Total direct costs per bushel              $                  1.80



 Machinery (Ownership Costs)               $                 51.00
 Land Charge                               $                110.00

 Total costs per acre                      $                485.75
 Total cost per bushel                     $                  2.70
 Return to management and labor per acre   $                369.25




                                           Page 5
                                           Soybean


Enter your specific input costs in blue
shaded cells.                                   Soybeans
Gross return
 Estimated Yield                                     40
  Estimated Selling price                   $          10.50
 Value per acre                             $         420.00
 Other income per acre
Gross Return per acre                       $         420.00

Direct costs per acre
 Seed                                       $             52.50
 Fertilizer                                               31.26
 Herbicide                                                15.28
 Insecticide                                               3.81
 Fungicide                                                  -
 Crop Insurance                                           25.00
 Machinery Costs (Operating)                              38.00
 Custom hire                                                -
 Drying
 Operating Interest                                        9.95
 Other variable costs

Total direct costs per acre                 $         175.80
Return over direct cost per acre            $         244.20
Total direct costs per bushel               $           4.39



 Machinery (Ownership Costs)                $          51.00
 Land Charge                                $         110.00

 Total costs per acre                       $         336.80
 Total cost per bushel                      $           8.42
 Return to management and labor per acre    $          83.20




                                           Page 6
Enter your specific input costs in blue
shaded cells.                              Spring Wheat

Gross return
 Estimated Yield                                80
  Estimated Selling price                  $           6.80
 Value per acre                            $         544.00
 Other income per acre
Gross Return per acre                      $         544.00

Direct costs per acre
 Seed                                      $          18.20
 Fertilizer                                           97.70
 Herbicides                                            8.82
 Insecticide                                            -
 Fungicide                                            17.82
 Crop Insurance                                       23.00
 Machinery Costs (Operating)                          38.00
 Custom hire
 Drying
 Operating Interest                                   12.21
 Other variable costs

Total direct costs per acre                $         215.75
Return over direct cost per acre           $         328.25
Total direct costs per bushel              $           2.70



 Machinery (Ownership Costs)               $          51.00
 Land Charge                               $          65.00

 Total costs per acre                      $         331.75
 Total cost per bushel                     $           4.15
 Return to management and labor per acre   $         212.25
Enter your specific input costs in blue
shaded cells.                              Winter wheat

Gross return
 Estimated Yield                               80
  Estimated Selling price                  $          6.00
 Value per acre                            $        480.00
 Other income per acre
Gross Return per acre                      $        480.00

Direct costs per acre
 Seed                                      $         22.40
 Fertilizer                                          97.70
 Herbicides                                           8.82
 Insecticide                                           -
 Fungicide                                           17.82
 Crop Insurance                                      20.00
 Machinery Costs (Operating)                         38.00
 Custom hire
 Drying
 Operating Interest                                  12.28
 Other variable costs

Total direct costs per acre                $        217.02
Return over direct cost per acre           $        262.98
Total direct costs per bushel              $          2.71



 Machinery (Ownership Costs)               $         51.00
 Land Charge                               $         65.00

 Total costs per acre                      $        333.02
 Total cost per bushel                     $          4.16
 Return to management and labor per acre   $        146.98
                                           Sunflowers


Enter your specific input costs in blue
shaded cells.                                 Sunflowers
Gross return
 Estimated Yield                                     1800
  Estimated Selling price                     $           0.17
 Value per acre                               $         306.00
 Other income per acre
Gross Return per acre                         $         306.00

Direct costs per acre
 Seed                                         $          23.32
 Fertilizer                                              56.30
 Herbicide                                               35.60
 Insecticide                                               -
 Fungicide                                                 -
 Crop Insurance                                          25.00
 Machinery Costs (Operating)                             43.00
 Custom hire                                               -
 Drying
 Operating Interest                                      10.99
 Other variable costs

Total direct costs per acre                   $         194.21
Return over direct cost per acre              $         111.79
Total direct costs per lb                     $           0.11



 Machinery (Ownership Costs)                  $          51.00
 Land Charge                                  $          45.00

 Total costs per acre                         $         290.21
 Total cost per lb                            $           0.16
 Return to management and labor per acre      $          15.79




                                            Page 9
                                           TEMPLATE


                                                 CORN
Gross return
 Estimated Yield
  Estimated Selling price
 Value per acre                                  #VALUE!
 Other income per acre
Gross Return per acre                            #VALUE!

Direct costs per acre
 Seed
 Fertilizer
 Crop chemicals
 Crop Insurance
 Machinery Costs (Operating)
 Custom hire
 Drying
 Operating Interest
 Other variable costs

Total direct costs per acre                  $             -
Return over direct cost per acre                 #VALUE!
Total direct costs per bushel                    #VALUE!



 Machinery (Ownership Costs)
 Land Charge

 Total costs per acre                            #VALUE!
 Total cost per bushel                           #VALUE!
 Return to management and labor per acre         #VALUE!




                                            Page 10

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:2
posted:7/13/2011
language:English
pages:10