{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Introduction","Cover Crop Tool"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,11],[30,1,30,4],[31,1,32,11],[33,1,34,11],[36,1,37,4],[36,6,37,8],[41,4,41,6],[28,1,29,11],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13]]}
[]
[]
[null,"KSU-Cover Crop Cost-Return Budget"]
[]
[null,"An Excel spreadsheet to analyze the economics of planting a cover crop based on short-run benefits."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 8.10.16"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"The default values in this tool are based on a cereal rye and turnip cover crop mix planted in southeastern Kansas  The tool, however, can be used to look at the economics of planting any cover crop by changing the inputs in blue.  Note that long-term benefits (soil health, decreased runoff, etc) are not captured in this budget because the budget is based on one year's time and these are difficult to monetarily capture.  The authors do recognize the importance of these benefits and promote the use of cover crops for these purposes."]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly. This spreadsheet uses macros to print , however printing can also be done manually by highlighting the desired range and using the menu print commands."]
[]
[null,"All blue numbers are inputs and all black numbers are calculated from these inputs.  Several  cells have a red diamond in the upper right hand corner of the cell.  By moving your mouse cursor over this diamond, more detail of the input will be displayed on the screen."]
[]
[null,"FOR MORE INFORMATION:"]
[null,"Deveolepd by:"]
[]
[null,"Robin Reid",null,null,"Mykel Taylor",null,null,"Doug Shoup",null,null,null,"Jaymelynn Farney"]
[null,"Extension Associate",null,null,"Agricultural Economist",null,null,"Agronomy Specialist, SE",null,null,null,"Beef Systems Specialist, SE"]
[null,"Kansas State University",null,null,"Kansas State University",null,null,"Kansas State University",null,null,null,"Kansas State University"]
[null,"robinreid@ksu.edu",null,null,"mtaylor@k-state.edu",null,null,"dshoup@ksu.edu",null,null,null,"jkj@ksu.edu"]
[null,"785-532-0964",null,null,"785-532-3033",null,null,"620-421-4826",null,null,null,"620-421-4826"]
[]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Cover Crop Tool","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"cut":false,"hidden":false,"merged":[[9,9,9,11],[4,16,6,16],[9,0,9,1],[10,0,10,1],[11,0,11,1],[8,0,8,1],[0,9,0,16],[1,0,1,7],[2,0,2,7],[63,12,63,14],[4,9,4,10],[5,9,5,10],[6,9,6,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[46,16,47,16],[14,0,14,1],[11,13,11,15],[7,2,7,4],[52,12,52,14],[22,11,22,13]]}
[null,null,null,null,null,null,null,null,null,"Supplement Tables with more detail:"]
["Cover Crop Cost-Return Budget",null,null,null,null,null,null,null,null,"TABLE 1. Production Inputs "]
["Cereal Rye & Turnip in Southeastern Kansas",null,null,null,null,null,null,null,null,"Item",null,"Price",null,null,"Rate",null,"Total"]
["Department of Agricultural Economics - www.AgManager.info",null,null,null,null,null,null,null,null,"Seed, lbs"]
["Robin Reid & Mykel Taylor",null,"Doug Shoup",null,null,"Jaymelynn Farney",null,null,null,"    Rye",null,0.24,"/lb      x",100,"lbs/acre",{"$f":"L5*N5","v":24},{"$f":"SUM(P5:P7)","v":33}]
["Agricultural Economics",null,"Agronomy Specialist, SE",null,null,"Beef Systems Specialist, SE",null,null,null,"    Turnip",null,3,"/lb      x",3,"lbs/acre",{"$f":"L6*N6","v":9}]
[null,null,null,null,null,null,null,null,null,"    Other",null,0,"/lb      x",0,"lbs/acre",{"$f":"L7*N7","v":0}]
["INCOME PER ACRE",null,"           Yield Level, tons/ac          ",null,null,null,"Your Farm"]
["A. Yield per acre",null,1,1.75,2.5,null,null,null,null,"Herbicide chemicals"]
["B. Net Grazing Income",null,{"$f":"M58-L67","v":56.521739130434781},{"$f":"N58-L67","v":84.259259259259267},{"$f":"O58-L67","v":120.37037037037037},null,null,null,null,"Burndown/Termination",null,null,null,null,null,0,{"$f":"SUM(P10:P10)","v":0}]
["D. Government Payment",null,0,0,0]
["E. Miscellaneous income",null,0,0,0,null,null,null,null,null,null,null,null,"         Yield Level (tons)         "]
["F. Returns/acre (B+D+E)",null,{"$f":"SUM(C10:C12)","v":56.521739130434781},{"$f":"SUM(D10:D12)","v":84.259259259259267},{"$f":"SUM(E10:E12)","v":120.37037037037037},null,{"$f":"IF(G9=\"\",\"\",(G10+G11+G12))","v":""},null,null,"Fertilizer:",null,null,null,{"$f":"C9","v":1},{"$f":"D9","v":1.75},{"$f":"E9","v":2.5}]
[null,null,null,null,null,null,null,null,null,"    N",null,0.56000000000000005,"/lb      x",0,40,80,"lbs/acre"]
["COSTS PER ACRE",null,null,null,null,null,null,null,null,"    P",null,0.68,"/lb      x",0,0,0,"lbs/acre"]
["    1. Seed ",null,{"$f":"$Q$5","v":33},{"$f":"$Q$5","v":33},{"$f":"$Q$5","v":33},null,null,null,null,"    K",null,0.4,"/lb      x",0,0,0,"lbs/acre"]
["    2. Herbicide",null,{"$f":"$Q$10","v":0},{"$f":"$Q$10","v":0},{"$f":"$Q$10","v":0}]
["    3. Insecticide / Fungicide",null,0,0,0,null,null,null,null,"Irrigation Water"]
["    4. Fertilizer ",null,{"$f":"SUMPRODUCT(N14:N16,$L$14:$L$16)","v":0},{"$f":"SUMPRODUCT(O14:O16,$L$14:$L$16)","v":22.400000000000002},{"$f":"SUMPRODUCT(P14:P16,$L$14:$L$16)","v":44.800000000000004},null,null,null,null,null,"Fuel and Oil",0,"/inch  x",0,0,0,"in/acre"]
["    8. Miscellaneous",null,0,0,0,null,null,null,null,null,"Repairs and Maint.",0,"/inch  x"]
["    9. Machinery Expense",null,{"$f":"SUMPRODUCT(L26:L39,P26:P39)","v":19.77},{"$f":"SUMPRODUCT(M26:M39,P26:P39)","v":25.96},{"$f":"SUMPRODUCT(N26:N39,P26:P39)","v":25.96}]
["  10. Non-machinery Labor",null,{"$f":"L41*$P$41","v":7.5},{"$f":"M41*$P$41","v":7.5},{"$f":"N41*$P$41","v":7.5},null,null,null,null,"TABLE 2. Machinery & Equipment"]
["  11. Irrigation",null,null,null,null,null,null,null,null,null,null,"         Yield Level (tons)         ",null,null,null,"Custom"]
["        a. Labor",null,{"$f":"L42*P42","v":0},{"$f":"M42*P42","v":0},{"$f":"N42*P42","v":0},null,null,null,null,"              ITEM",null,{"$f":"C9","v":1},{"$f":"D9","v":1.75},{"$f":"E9","v":2.5},null,"Rate"]
["        b. Fuel and Oil",null,{"$f":"$L$19*N19","v":0},{"$f":"$L$19*O19","v":0},{"$f":"$L$19*P19","v":0},null,null,null,null,"Tillage/Planting/Chemical Applications:"]
["        c. Repairs and Maintenance",null,{"$f":"$L$20*N19","v":0},{"$f":"$L$20*O19","v":0},{"$f":"$L$20*P19","v":0},null,null,null,null,"    Harrow",null,0,{"$f":"L26","v":0},{"$f":"L26","v":0},null,9.6999999999999993,"/ac"]
["        d. Depreciation on Equipment / Well",null,{"$f":"IF(SUM(L48:L50)=0,0,(L48*(1-O48)/N48+L49*(1-O49)/N49+L50*(1-O50)/N50)*Q49)","v":0},{"$f":"C27","v":0},{"$f":"C27","v":0},null,null,null,null,"    Disk",null,0,{"$f":"L27","v":0},{"$f":"L27","v":0},null,11.97,"/ac"]
["        e. Interest on Equipment",null,{"$f":"IF(SUM(L48:L50)=0,0,((L48*(1+O48)/2+L49*(1+O49)/2+L50*(1+O50)/2)*P45)*Q49)","v":0},{"$f":"C28","v":0},{"$f":"C28","v":0},null,null,null,null,"    Roller",null,0,{"$f":"L28","v":0},{"$f":"L28","v":0},null,12,"/ac"]
["  12. Land Charge / Rent",null,{"$f":"P44","v":0},{"$f":"P44","v":0},{"$f":"P44","v":0},null,null,null,null,"    Field cultivate",null,0,0,0,null,11.11,"/ac"]
["G. SUB TOTAL",null,{"$f":"SUM(C16:C29)","v":60.269999999999996},{"$f":"SUM(D16:D29)","v":88.860000000000014},{"$f":"SUM(E16:E29)","v":111.26000000000002},null,{"$f":"IF(SUM(G16:G29)>0,SUM(G16:G29),\"\")","v":""},null,null,"    Drill",null,1,1,1,null,19.77,"/ac"]
["  13. Interest on 1/2 Nonland Costs",null,{"$f":"(C30-C27-C28-C29)/2*P45","v":1.50675},{"$f":"(D30-D27-D28-D29)/2*P45","v":2.2215000000000003},{"$f":"(E30-E27-E28-E29)/2*P45","v":2.7815000000000007},null,{"$f":"IF(SUM(G16:G29)>0,(G30-G27-G28-G29)/2*P45,\"\")","v":""},null,null,"    Broadcast",null,0,0,0,null,15,"/ac"]
["H. TOTAL COSTS",null,{"$f":"C30+C31","v":61.776749999999993},{"$f":"D30+D31","v":91.08150000000002},{"$f":"E30+E31","v":114.04150000000001},null,{"$f":"IF(G9>0,G30+G31,\"\")","v":""},null,null,"    Anhydrous application",null,0,0,0,null,14.52,"/ac"]
["I. RETURNS OVER COSTS (F - H)",null,{"$f":"C13-C32","v":-5.2550108695652114},{"$f":"D13-D32","v":-6.822240740740753},{"$f":"E13-E32","v":6.3288703703703533},null,{"$f":"IF(G9>0,G13-G32,\"\")","v":""},null,null,"    Fertilizer application",null,0,1,1,null,6.19,"/ac"]
["J. TOTAL COSTS/TON (H/A)",null,{"$f":"C32/C9","v":61.776749999999993},{"$f":"D32/D9","v":52.04657142857144},{"$f":"E32/E9","v":45.616600000000005},null,{"$f":"IF(G9>0,G32/G9,\"\")","v":""},null,null,"    Herbicide application",null,0,0,0,null,6.26,"/ac"]
["K. RETURN TO ANNUAL COST (I+13)/G",null,{"$f":"(C33+C31)/C30","v":-6.2191154298410677E-2},{"$f":"(D33+D31)/D30","v":-5.177516026041809E-2},{"$f":"(E33+E31)/E30","v":8.1883609296875368E-2},null,{"$f":"IF(G9>0,(G33+G31)/G30,\"\")","v":""},null,null,"    Insecticide / fungicide application",null,0,{"$f":"L35","v":0},{"$f":"L35","v":0},null,6.29,"/ac"]
[null,null,null,null,null,null,null,null,null,"Harvest"]
[null,null,null,null,null,null,null,null,null,"    Swathing and conditioning",null,0,{"$f":"L37","v":0},{"$f":"L37","v":0},null,17.46,"/ac"]
[null,null,null,null,null,null,null,null,null,"    Sideraking",null,0,{"$f":"L38","v":0},{"$f":"L38","v":0},null,4.2,"/ac"]
[null,null,null,null,null,null,null,null,null,"    Baling",null,0,0,0,null,13.16,"/bale"]
[]
[null,null,null,null,null,null,null,null,null,"Non-machinery labor",null,0.5,0.5,0.5,null,15,"/hr"]
[null,null,null,null,null,null,null,null,null,"Irrigation labor",null,0,0,0,null,15,"/hr"]
[]
[null,null,null,null,null,null,null,null,null,"Land charge/rent",null,null,null,null,null,0,"/ac"]
[null,null,null,null,null,null,null,null,null,"Interest on capital",null,null,null,null,null,0.05]
[]
[null,null,null,null,null,null,null,null,null,"Irrigation Equipment",null,"Investment, $/ac",null,"Years","Salvage value",null,"% to charge to cover crops"]
[null,null,null,null,null,null,null,null,null,"    Well, pump and gearhead value",null,"n/a",null,"n/a","n/a"]
[null,null,null,null,null,null,null,null,null,"    Power unit and meter",null,"n/a",null,"n/a","n/a",null,0]
[null,null,null,null,null,null,null,null,null,"    Irrigation system",null,"n/a",null,"n/a","n/a"]
[]
[null,null,null,null,null,null,null,null,null,"TABLE 3. Grazing Income"]
[null,null,null,null,null,null,null,null,null,null,null,null,"         Yield Level (tons)         "]
[null,null,null,null,null,null,null,null,null,"Stocking Rate & Charge",null,null,{"$f":"C9","v":1},{"$f":"D9","v":1.75},{"$f":"E9","v":2.5}]
[null,null,null,null,null,null,null,null,null,0.75,"per/hd/day"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((M54*2000)*0.65)/(0.03*575)","v":75.362318840579704},75,75,"grazing days"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"((N54*2000)*0.65)/(N56*20.25)","v":1.4979423868312758},{"$f":"((O54*2000)*0.65)/(O56*20.25)","v":2.1399176954732511},"head/acre"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$55*M56*M57","v":56.521739130434781},{"$f":"$J$55*N56*N57","v":84.259259259259267},{"$f":"$J$55*O56*O57","v":120.37037037037037},"Total per acre"]
[]
[null,null,null,null,null,null,null,null,null,"Costs",null,"per acre"]
[null,null,null,null,null,null,null,null,null,"Fencing",null,0]
[null,null,null,null,null,null,null,null,null,"Water",null,0]
[null,null,null,null,null,null,null,null,null,"Supplement",null,0]
[null,null,null,null,null,null,null,null,null,"  Mineral",null,0]
[null,null,null,null,null,null,null,null,null,"  Labor",null,0]
[]
[null,null,null,null,null,null,null,null,null,"  Total",null,{"$f":"SUM(L61:L65)","v":0}]