{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Menu","CoastalEstablish","LargeRoundHay","SmallSquareHay","CoastalPasture","CoastalOverseed","SmallGrainPasture","CowCalf","Livestock Budget","Crop Budget","Comparative Returns - Cash Rent","Your Returns - Cash Rent"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":336,"comments":9,"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":"Menu","index":0,"n_rows":72,"n_cols":26,"rows_kept":72,"cut":false,"hidden":false,"merged":[[5,0,5,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
["     East Texas Extension District - 5     "]
[]
[null,null,null,"Budgets"]
[]
[]
[null,null,null,"Forage Crops"]
[]
[null,null,null,{"$f":"+CoastalEstablish!A3","v":"Coastal Bermudagrass Establishment"}]
[null,null,null,{"$f":"LargeRoundHay!A3","v":"Coastal Bermudagrass Hay, Large Bales"}]
[null,null,null,{"$f":"SmallSquareHay!A3","v":"Coastal Bermudagrass Hay, Small Square Bales (60 lbs.)"}]
[null,null,null,{"$f":"CoastalPasture!A3","v":"Coastal Bermudagrass Pasture Grazing"}]
[null,null,null,{"$f":"CoastalOverseed!A3","v":"Coastal Bermudagrass Pasture, Overseeded Rye and Ryegrass"}]
[null,"Comparative Returns",null,{"$f":"SmallGrainPasture!A3","v":"Small Grains - Ryegrass Winter Pasture"}]
[]
[null,null,null,"Livestock"]
[]
[null,null,null,{"$f":"+CowCalf!A3","v":"Cow-Calf Production"}]
[]
[null,null,null,"Other Budgets"]
[]
[null,null,null,{"$f":"'Livestock Budget'!A3","v":"Livestock Enterprise"}]
[null,null,null,{"$f":"'Crop Budget'!A3","v":"Crop Enterprise"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]

{"sheet":"CoastalEstablish","index":1,"n_rows":102,"n_cols":18,"rows_kept":102,"cut":false,"hidden":false,"merged":[[79,3,79,8],[89,3,89,8],[99,0,99,9],[101,0,101,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Coastal Bermudagrass Establishment"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",25,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(25 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,0,null,0,null,"",0,null,0,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},0,{"$f":"+J10-N10","v":0},0,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,0,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},0,{"$f":"SUM(P10:P12)","v":0},0,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Sprigging and Sprigs",1,null,"Acre",100,null,100,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},100,{"$f":"+J18-N18","v":0},2500,{"$f":"+J18*E$7","v":0}]
[null,"Fertilizer"]
[null,"","Phosphate",40,null,"Pound",0.5,null,20,0,0,null,0,0,20,0,500,0]
[null,"","Potash",130,null,"Pound",0.25,null,32.5,0,0,null,0,0,32.5,0,812.5,0]
[null,"","Nitrogen",180,null,"Pound",0.42499999999999999,null,76.5,0,0,null,0,0,76.5,0,1912.5,0]
[null,"","Lime",1,null,"Ton",60,null,60,0,0,null,0,0,60,0,1500,0]
[null,"Herbicide"]
[null,"","Glyphosphate",256,null,"Ounce",0.109375,null,28,0,0,null,0,0,28,0,700,0]
[null,"","Diuron 4L",2,null,"Pint",3.4375,null,6.875,0,0,null,0,0,6.875,0,171.875,0]
[null,"Seed"]
[null,"","Seed - Elbon Rye",100,null,"Pound",0.32,null,32,0,0,null,0,0,32,0,800,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},0,{"$f":"+J31-N31","v":0},0,{"$f":"+J31*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",1.31,null,"Hour",15,null,19.650000000000002,{"$f":"E33*H33","v":0},0,null,0,{"$f":"J33*L33","v":0},19.650000000000002,{"$f":"+J33-N33","v":0},491.25000000000006,{"$f":"+J33*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",15,null,0,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},0,{"$f":"+J34-N34","v":0},0,{"$f":"+J34*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},0,{"$f":"+J37-N37","v":0},0,{"$f":"+J37*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",4.93,null,"Gallon",2,null,9.86,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},9.86,{"$f":"+J38-N38","v":0},246.5,{"$f":"+J38*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",3.8,null,3.8,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},3.8,{"$f":"+J41-N41","v":0},95,{"$f":"+J41*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,null,0,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},0,{"$f":"+J42-N42","v":0},0,{"$f":"+J42*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.448,null,2.448,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},2.448,{"$f":"+J45-N45","v":0},61.199999999999996,{"$f":"+J45*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",7.1753504359097402,null,7.1753504359097402,0,0,null,0,0,7.1753504359097402,0,179.38376089774351,0]
[null,null,"Implements",1,null,"Acre",9.9782796349953102,null,9.9782796349953102,0,0,null,0,0,9.9782796349953102,0,249.45699087488276,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,{"$f":"+J49*E$7","v":0}]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,4.7500000000000001E-2,null,17.352486909858843,{"$f":"+SUM(J17:J50)/2*H51","v":0},null,null,0,{"$f":"+SUM(N17:N50)/2*L51","v":0},17.352486909858843,{"$f":"+SUM(P17:P50)/2*L51","v":0},433.81217274647111,{"$f":"+J51*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,426.1391169807639,{"$f":"SUM(J18:J51)","v":0},null,null,0,{"$f":"SUM(N18:N51)","v":0},426.1391169807639,{"$f":"SUM(P18:P51)","v":0},10653.477924519098,{"$f":"SUM(R18:R51)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-426.1391169807639,{"$f":"+J13-J52","v":0},null,null,0,{"$f":"+N13-N52","v":0},-426.1391169807639,{"$f":"+P13-P52","v":0},-10653.477924519098,{"$f":"+R13-R52","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit",null,"Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.5704000000000002,null,2.5704000000000002,{"$f":"E58*H58","v":0},0,null,0,{"$f":"J58*L58","v":0},2.5704000000000002,{"$f":"+J58-N58","v":0},64.260000000000005,{"$f":"+J58*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",5.931623027018718,null,5.931623027018718,0,0,null,0,{"$f":"J59*L59","v":0},5.931623027018718,0,148.29057567546795,0]
[null,null,"Implements",1,null,"Acre",12.365585601272713,null,12.365585601272713,0,0,null,0,{"$f":"J60*L60","v":0},12.365585601272713,0,309.13964003181781,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",17.748000000000001,null,"Dollars",5.2499999999999998E-2,null,0.93176999999999999,{"$f":"E62*H62","v":0},0,null,0,{"$f":"J62*L62","v":0},0.93176999999999999,{"$f":"+J62-N62","v":0},23.294249999999998,{"$f":"+J62*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",46.209256807258726,null,"Dollars",5.2499999999999998E-2,null,2.425985982381083,0,0,null,0,{"$f":"J63*L63","v":0},2.425985982381083,0,60.649649559527077,0]
[null,null,"Implements",52.897227294357144,null,"Dollars",5.2499999999999998E-2,null,2.7771044329537498,0,0,null,0,{"$f":"J64*L64","v":0},2.7771044329537498,0,69.42761082384375,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J65*L65","v":0},0,{"$f":"+J65-N65","v":0},0,{"$f":"+J65*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"None",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,{"$f":"E69*H69","v":0},0,null,0,0,0,0,0,{"$f":"+J69*E$7","v":0}]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,27.002469043626263,{"$f":"+SUM(J58:J72)","v":0},null,null,0,{"$f":"+SUM(N58:N72)","v":0},27.002469043626263,{"$f":"+SUM(P58:P72)","v":0},675.06172609065663,{"$f":"+SUM(R58:R72)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,453.14158602439016,{"$f":"+J52+J73","v":0},null,null,0,{"$f":"+N52+N73","v":0},453.14158602439016,{"$f":"+P52+P73","v":0},11328.539650609755,{"$f":"+R52+R73","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-453.14158602439016,{"$f":"+J13-J74","v":0},null,null,0,{"$f":"+N13-N74","v":0},-453.14158602439016,{"$f":"+P13-P74","v":0},-11328.539650609755,{"$f":"+R13-R74","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","","Costs",null,null,"Costs"]
[null,0.75,0,0,null,null,0]
[null,0.9,0,0,null,null,0]
[null,1,0,0,null,null,0]
[null,1.1000000000000001,0,0,null,null,0]
[null,1.25,0,0,null,null,0]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"LargeRoundHay","index":2,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[[78,3,78,8],[88,3,88,8],[98,0,98,9],[100,0,100,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Coastal Bermudagrass Hay, Large Bales"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",25,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(25 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Bermuda Hay, Large Bales",null,3,null,"Ton",90,null,270,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},270,{"$f":"+J10-N10","v":0},6750,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,270,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},270,{"$f":"SUM(P10:P12)","v":0},6750,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Custom Round Baling",3,null,"Ton",50,null,150,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},150,{"$f":"+J18-N18","v":0},3750,{"$f":"+J18*E$7","v":0}]
[null,"","Custom Round Bale Hauling",3,null,"Ton",2,null,6,0,0,null,0,0,6,0,150,0]
[null,"Fertilizer"]
[null,"","Nitrogen",240,null,"Pound",0.42499999999999999,null,102,0,0,null,0,0,102,0,2550,0]
[null,"","Phosphate",48,null,"Pound",0.5,null,24,0,0,null,0,0,24,0,600,0]
[null,"","Potash",192,null,"Pound",0.25,null,48,0,0,null,0,0,48,0,1200,0]
[null,"","Lime",0.33333299999999999,null,"Ton",60,null,19.999980000000001,0,0,null,0,0,19.999980000000001,0,499.99950000000001,0]
[null,"Herbicide"]
[null,"","Glyphosphate",32,null,"Ounce",0.109375,null,3.5,0,0,null,0,0,3.5,0,87.5,0]
[null,"","Pasture Herbicide",4,null,"Acre",8,null,32,0,0,null,0,0,32,0,800,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E30*H30","v":0},0,null,0,{"$f":"J30*L30","v":0},0,{"$f":"+J30-N30","v":0},0,{"$f":"+J30*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.41,null,"Hour",15,null,6.1499999999999995,{"$f":"E32*H32","v":0},0,null,0,{"$f":"J32*L32","v":0},6.1499999999999995,{"$f":"+J32-N32","v":0},153.75,{"$f":"+J32*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",15,null,0,{"$f":"E33*H33","v":0},0,null,0,{"$f":"J33*L33","v":0},0,{"$f":"+J33-N33","v":0},0,{"$f":"+J33*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},0,{"$f":"+J36-N36","v":0},0,{"$f":"+J36*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1.32,null,"Gallon",2,null,2.64,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},2.64,{"$f":"+J37-N37","v":0},66,{"$f":"+J37*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.9,null,1.9,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},1.9,{"$f":"+J40-N40","v":0},47.5,{"$f":"+J40*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,null,0,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},0,{"$f":"+J41-N41","v":0},0,{"$f":"+J41*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.224,null,1.224,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},1.224,{"$f":"+J44-N44","v":0},30.599999999999998,{"$f":"+J44*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",1.7123053994870303,null,1.7123053994870303,0,0,null,0,0,1.7123053994870303,0,42.80763498717576,0]
[null,null,"Implements",1,null,"Acre",0.57779183673469392,null,0.57779183673469392,0,0,null,0,0,0.57779183673469392,0,14.444795918367348,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,4.7500000000000001E-2,null,5.6428425883976514,{"$f":"+SUM(J17:J49)/2*H50","v":0},null,null,0,{"$f":"+SUM(N17:N49)/2*L50","v":0},5.6428425883976514,{"$f":"+SUM(P17:P49)/2*L50","v":0},141.07106470994128,{"$f":"+J50*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,405.34691982461931,{"$f":"SUM(J18:J50)","v":0},null,null,0,{"$f":"SUM(N18:N50)","v":0},405.34691982461931,{"$f":"SUM(P18:P50)","v":0},10133.672995615483,{"$f":"SUM(R18:R50)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-135.34691982461931,{"$f":"+J13-J51","v":0},null,null,0,{"$f":"+N13-N51","v":0},-135.34691982461931,{"$f":"+P13-P51","v":0},-3383.6729956154832,{"$f":"+R13-R51","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,135.11563994153977,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.2852000000000001,null,1.2852000000000001,{"$f":"E57*H57","v":0},0,null,0,{"$f":"J57*L57","v":0},1.2852000000000001,{"$f":"+J57-N57","v":0},32.130000000000003,{"$f":"+J57*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",1.4155057969092784,null,1.4155057969092784,0,0,null,0,{"$f":"J58*L58","v":0},1.4155057969092784,0,35.387644922731958,0]
[null,null,"Implements",1,null,"Acre",0.52001265306122457,null,0.52001265306122457,0,0,null,0,{"$f":"J59*L59","v":0},0.52001265306122457,0,13.000316326530614,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",8.8740000000000006,null,"Dollars",5.2499999999999998E-2,null,0.46588499999999999,{"$f":"E61*H61","v":0},0,null,0,{"$f":"J61*L61","v":0},0.46588499999999999,{"$f":"+J61-N61","v":0},11.647124999999999,{"$f":"+J61*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",11.027246772696476,null,"Dollars",5.2499999999999998E-2,null,0.57893045556656497,0,0,null,0,{"$f":"J62*L62","v":0},0.57893045556656497,0,14.473261389164124,0]
[null,null,"Implements",2.2244985714285712,null,"Dollars",5.2499999999999998E-2,null,0.11678617499999998,0,0,null,0,{"$f":"J63*L63","v":0},0.11678617499999998,0,2.9196543749999995,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J64*L64","v":0},0,{"$f":"+J64-N64","v":0},0,{"$f":"+J64*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Bermuda Pasture Rent",null,1,null,"Acre",20,null,20,0,0,null,0,0,20,0,500,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E71*H71","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,24.382320080537067,{"$f":"+SUM(J57:J71)","v":0},null,null,0,{"$f":"+SUM(N57:N71)","v":0},24.382320080537067,{"$f":"+SUM(P57:P71)","v":0},609.55800201342663,{"$f":"+SUM(R57:R71)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,429.72923990515636,{"$f":"+J51+J72","v":0},null,null,0,{"$f":"+N51+N72","v":0},429.72923990515636,{"$f":"+P51+P72","v":0},10743.230997628911,{"$f":"+R51+R72","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-159.72923990515636,{"$f":"+J13-J73","v":0},null,null,0,{"$f":"+N13-N73","v":0},-159.72923990515636,{"$f":"+P13-P73","v":0},-3993.2309976289107,{"$f":"+R13-R73","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,143.24307996838544,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Ton","Costs",null,null,"Costs"]
[null,0.75,2.25,180.15418658871968,null,null,190.9907732911806]
[null,0.9,2.7,150.12848882393305,null,null,159.15897774265051]
[null,1,3,135.11563994153977,null,null,143.24307996838544]
[null,1.1000000000000001,3.3000000000000003,122.83239994685432,null,null,130.22098178944131]
[null,1.25,3.75,108.09251195323182,null,null,114.59446397470836]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Ton",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"SmallSquareHay","index":3,"n_rows":98,"n_cols":18,"rows_kept":98,"cut":false,"hidden":false,"merged":[[75,3,75,8],[85,3,85,8],[95,0,95,9],[97,0,97,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Coastal Bermudagrass Hay, Small Square Bales (60 lbs.)"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",25,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(25 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Bermuda Hay, 60 lbs. Square Bales(in field)",null,100,null,"Bale",6,null,600,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},600,{"$f":"+J10-N10","v":0},15000,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,600,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},600,{"$f":"SUM(P10:P12)","v":0},15000,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Fertilizer"]
[null,"","Nitrogen",240,null,"Pound",0.42499999999999999,null,102,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},102,{"$f":"+J18-N18","v":0},2550,{"$f":"+J18*E$7","v":0}]
[null,"","Phosphate",48,null,"Pound",0.5,null,24,0,0,null,0,0,24,0,600,0]
[null,"","Potash",192,null,"Pound",0.25,null,48,0,0,null,0,0,48,0,1200,0]
[null,"","Lime",0.33333299999999999,null,"Ton",60,null,19.999980000000001,0,0,null,0,0,19.999980000000001,0,499.99950000000001,0]
[null,"Herbicide"]
[null,"","Glyphosphate",32,null,"Ounce",0.109375,null,3.5,0,0,null,0,0,3.5,0,87.5,0]
[null,"","Pasture Herbicide",4,null,"Acre",8,null,32,0,0,null,0,0,32,0,800,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E27*H27","v":0},0,null,0,{"$f":"J27*L27","v":0},0,{"$f":"+J27-N27","v":0},0,{"$f":"+J27*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",2.0099999999999998,null,"Hour",15,null,30.15,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},30.15,{"$f":"+J29-N29","v":0},753.75,{"$f":"+J29*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",15,null,0,{"$f":"E30*H30","v":0},0,null,0,{"$f":"J30*L30","v":0},0,{"$f":"+J30-N30","v":0},0,{"$f":"+J30*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E33*H33","v":0},0,null,0,{"$f":"J33*L33","v":0},0,{"$f":"+J33-N33","v":0},0,{"$f":"+J33*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",6.54,null,"Gallon",2,null,13.08,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},13.08,{"$f":"+J34-N34","v":0},327,{"$f":"+J34*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",9.5,null,9.5,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},9.5,{"$f":"+J37-N37","v":0},237.5,{"$f":"+J37*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,null,0,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},0,{"$f":"+J38-N38","v":0},0,{"$f":"+J38*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",6.12,null,6.12,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},6.12,{"$f":"+J41-N41","v":0},153,{"$f":"+J41*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.4998965036705858,null,8.4998965036705858,0,0,null,0,0,8.4998965036705858,0,212.49741259176466,0]
[null,null,"Implements",1,null,"Acre",5.3885664262983779,null,5.3885664262983779,0,0,null,0,0,5.3885664262983779,0,134.71416065745944,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,4.7500000000000001E-2,null,4.6658316587682043,{"$f":"+SUM(J17:J46)/2*H47","v":0},null,null,0,{"$f":"+SUM(N17:N46)/2*L47","v":0},4.6658316587682043,{"$f":"+SUM(P17:P46)/2*L47","v":0},116.64579146920511,{"$f":"+J47*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,306.90427458873711,{"$f":"SUM(J18:J47)","v":0},null,null,0,{"$f":"SUM(N18:N47)","v":0},306.90427458873711,{"$f":"SUM(P18:P47)","v":0},7672.6068647184293,{"$f":"SUM(R18:R47)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,293.09572541126289,{"$f":"+J13-J48","v":0},null,null,0,{"$f":"+N13-N48","v":0},293.09572541126289,{"$f":"+P13-P48","v":0},7327.3931352815707,{"$f":"+R13-R48","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,3.069042745887371,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Bale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",6.4260000000000002,null,6.4260000000000002,{"$f":"E54*H54","v":0},0,null,0,{"$f":"J54*L54","v":0},6.4260000000000002,{"$f":"+J54-N54","v":0},160.65,{"$f":"+J54*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",7.0265811097010182,null,7.0265811097010182,0,0,null,0,{"$f":"J55*L55","v":0},7.0265811097010182,0,175.66452774252545,0]
[null,null,"Implements",1,null,"Acre",6.5281093672702593,null,6.5281093672702593,0,0,null,0,{"$f":"J56*L56","v":0},6.5281093672702593,0,163.20273418175648,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",44.37,null,"Dollars",5.2499999999999998E-2,null,2.3294249999999996,{"$f":"E58*H58","v":0},0,null,0,{"$f":"J58*L58","v":0},2.3294249999999996,{"$f":"+J58-N58","v":0},58.235624999999992,{"$f":"+J58*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",54.739333483638568,null,"Dollars",5.2499999999999998E-2,null,2.8738150078910247,0,0,null,0,{"$f":"J59*L59","v":0},2.8738150078910247,0,71.845375197275615,0]
[null,null,"Implements",51.385333262786595,null,"Dollars",5.2499999999999998E-2,null,2.697729996296296,0,0,null,0,{"$f":"J60*L60","v":0},2.697729996296296,0,67.443249907407392,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J61*L61","v":0},0,{"$f":"+J61-N61","v":0},0,{"$f":"+J61*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Bermuda Pasture Rent",null,1,null,"Acre",20,null,20,0,0,null,0,0,20,0,500,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E68*H68","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,47.881660481158598,{"$f":"+SUM(J54:J68)","v":0},null,null,0,{"$f":"+SUM(N54:N68)","v":0},47.881660481158598,{"$f":"+SUM(P54:P68)","v":0},1197.0415120289649,{"$f":"+SUM(R54:R68)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,354.78593506989569,{"$f":"+J48+J69","v":0},null,null,0,{"$f":"+N48+N69","v":0},354.78593506989569,{"$f":"+P48+P69","v":0},8869.6483767473947,{"$f":"+R48+R69","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,245.21406493010431,{"$f":"+J13-J70","v":0},null,null,0,{"$f":"+N13-N70","v":0},245.21406493010431,{"$f":"+P13-P70","v":0},6130.3516232526053,{"$f":"+R13-R70","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,3.5478593506989569,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Bale"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Bale","Costs",null,null,"Costs"]
[null,0.75,75,4.0920569945164944,null,null,4.7304791342652761]
[null,0.9,90,3.4100474954304123,null,null,3.9420659452210631]
[null,1,100,3.069042745887371,null,null,3.5478593506989569]
[null,1.1000000000000001,110.00000000000001,2.7900388598976096,null,null,3.2253266824535967]
[null,1.25,125,2.4552341967098967,null,null,2.8382874805591656]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Bale",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CoastalPasture","index":4,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":false,"merged":[[74,3,74,8],[84,3,84,8],[94,0,94,9],[96,0,96,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Coastal Bermudagrass Pasture Grazing"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",100,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(100 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,0,null,0,null,"",0,null,0,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},0,{"$f":"+J10-N10","v":0},0,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,0,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},0,{"$f":"SUM(P10:P12)","v":0},0,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Fertilizer"]
[null,"","Nitrogen",180,null,"Pound",0.42499999999999999,null,76.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},76.5,{"$f":"+J18-N18","v":0},7650,{"$f":"+J18*E$7","v":0}]
[null,"","Phosphate",15,null,"Pound",0.5,null,7.5,0,0,null,0,0,7.5,0,750,0]
[null,"","Potash",60,null,"Pound",0.25,null,15,0,0,null,0,0,15,0,1500,0]
[null,"","Lime",0.33333299999999999,null,"Ton",60,null,19.999980000000001,0,0,null,0,0,19.999980000000001,0,1999.998,0]
[null,"Herbicide"]
[null,"","Pasture Herbicide",1,null,"Acre",8,null,8,0,0,null,0,0,8,0,800,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E26*H26","v":0},0,null,0,{"$f":"J26*L26","v":0},0,{"$f":"+J26-N26","v":0},0,{"$f":"+J26*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.13,null,"Hour",15,null,1.9500000000000002,{"$f":"E28*H28","v":0},0,null,0,{"$f":"J28*L28","v":0},1.9500000000000002,{"$f":"+J28-N28","v":0},195.00000000000003,{"$f":"+J28*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",15,null,0,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},0,{"$f":"+J29-N29","v":0},0,{"$f":"+J29*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E32*H32","v":0},0,null,0,{"$f":"J32*L32","v":0},0,{"$f":"+J32-N32","v":0},0,{"$f":"+J32*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0.42,null,"Gallon",2,null,0.84,{"$f":"E33*H33","v":0},0,null,0,{"$f":"J33*L33","v":0},0.84,{"$f":"+J33-N33","v":0},84,{"$f":"+J33*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.95,null,0.95,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},0.95,{"$f":"+J36-N36","v":0},95,{"$f":"+J36*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,null,0,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},0,{"$f":"+J37-N37","v":0},0,{"$f":"+J37*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.61199999999999999,null,0.61199999999999999,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},0.61199999999999999,{"$f":"+J40-N40","v":0},61.199999999999996,{"$f":"+J40*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",0.54619896297102843,null,0.54619896297102843,0,0,null,0,0,0.54619896297102843,0,54.619896297102841,0]
[null,null,"Implements",1,null,"Acre",0.14444795918367359,null,0.14444795918367359,0,0,null,0,0,0.14444795918367359,0,14.444795918367358,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,4.7500000000000001E-2,null,2.3957371566722507,{"$f":"+SUM(J17:J45)/2*H46","v":0},null,null,0,{"$f":"+SUM(N17:N45)/2*L46","v":0},2.3957371566722507,{"$f":"+SUM(P17:P45)/2*L46","v":0},239.57371566722509,{"$f":"+J46*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,134.43836407882694,{"$f":"SUM(J18:J46)","v":0},null,null,0,{"$f":"SUM(N18:N46)","v":0},134.43836407882694,{"$f":"SUM(P18:P46)","v":0},13443.836407882696,{"$f":"SUM(R18:R46)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-134.43836407882694,{"$f":"+J13-J47","v":0},null,null,0,{"$f":"+N13-N47","v":0},-134.43836407882694,{"$f":"+P13-P47","v":0},-13443.836407882696,{"$f":"+R13-R47","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.64260000000000006,null,0.64260000000000006,{"$f":"E53*H53","v":0},0,null,0,{"$f":"J53*L53","v":0},0.64260000000000006,{"$f":"+J53-N53","v":0},64.260000000000005,{"$f":"+J53*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",0.45152447605605017,null,0.45152447605605017,0,0,null,0,{"$f":"J54*L54","v":0},0.45152447605605017,0,45.152447605605019,0]
[null,null,"Implements",1,null,"Acre",0.13000316326530623,null,0.13000316326530623,0,0,null,0,{"$f":"J55*L55","v":0},0.13000316326530623,0,13.000316326530623,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",4.4370000000000003,null,"Dollars",5.2499999999999998E-2,null,0.2329425,{"$f":"E57*H57","v":0},0,null,0,{"$f":"J57*L57","v":0},0.2329425,{"$f":"+J57-N57","v":0},23.294249999999998,{"$f":"+J57*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",3.5175213215334229,null,"Dollars",5.2499999999999998E-2,null,0.1846698693805047,0,0,null,0,{"$f":"J58*L58","v":0},0.1846698693805047,0,18.466986938050471,0]
[null,null,"Implements",0.5561246428571438,null,"Dollars",5.2499999999999998E-2,null,2.919654375000005E-2,0,0,null,0,{"$f":"J59*L59","v":0},2.919654375000005E-2,0,2.9196543750000048,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J60*L60","v":0},0,{"$f":"+J60-N60","v":0},0,{"$f":"+J60*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Bermuda Pasture Rent",null,1,null,"Acre",20,null,20,0,0,null,0,0,20,0,2000,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E67*H67","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,21.670936552451863,{"$f":"+SUM(J53:J67)","v":0},null,null,0,{"$f":"+SUM(N53:N67)","v":0},21.670936552451863,{"$f":"+SUM(P53:P67)","v":0},2167.0936552451863,{"$f":"+SUM(R53:R67)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,156.10930063127881,{"$f":"+J47+J68","v":0},null,null,0,{"$f":"+N47+N68","v":0},156.10930063127881,{"$f":"+P47+P68","v":0},15610.930063127882,{"$f":"+R47+R68","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-156.10930063127881,{"$f":"+J13-J69","v":0},null,null,0,{"$f":"+N13-N69","v":0},-156.10930063127881,{"$f":"+P13-P69","v":0},-15610.930063127882,{"$f":"+R13-R69","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","","Costs",null,null,"Costs"]
[null,0.75,0,0,null,null,0]
[null,0.9,0,0,null,null,0]
[null,1,0,0,null,null,0]
[null,1.1000000000000001,0,0,null,null,0]
[null,1.25,0,0,null,null,0]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CoastalOverseed","index":5,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":false,"merged":[[77,3,77,8],[87,3,87,8],[97,0,97,9],[99,0,99,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Coastal Bermudagrass Pasture, Overseeded Rye and Ryegrass"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",100,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(100 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,0,null,0,null,"",0,null,0,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},0,{"$f":"+J10-N10","v":0},0,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,0,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},0,{"$f":"SUM(P10:P12)","v":0},0,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Fertilizer"]
[null,"","Nitrogen",300,null,"Pound",0.42499999999999999,null,127.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},127.5,{"$f":"+J18-N18","v":0},12750,{"$f":"+J18*E$7","v":0}]
[null,"","Phosphate",15,null,"Pound",0.5,null,7.5,0,0,null,0,0,7.5,0,750,0]
[null,"","Potash",60,null,"Pound",0.25,null,15,0,0,null,0,0,15,0,1500,0]
[null,"","Lime",0.33333299999999999,null,"Ton",60,null,19.999980000000001,0,0,null,0,0,19.999980000000001,0,1999.998,0]
[null,"Herbicide"]
[null,"","Pasture Herbicide",1,null,"Acre",8,null,8,0,0,null,0,0,8,0,800,0]
[null,"Seed"]
[null,"","Seed - Elbon Rye",100,null,"Pound",0.32,null,32,0,0,null,0,0,32,0,3200,0]
[null,"","Seed - Ryegrass",25,null,"Pound",0.8,null,20,0,0,null,0,0,20,0,2000,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},0,{"$f":"+J29-N29","v":0},0,{"$f":"+J29*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.75,null,"Hour",15,null,11.25,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},11.25,{"$f":"+J31-N31","v":0},1125,{"$f":"+J31*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",15,null,0,{"$f":"E32*H32","v":0},0,null,0,{"$f":"J32*L32","v":0},0,{"$f":"+J32-N32","v":0},0,{"$f":"+J32*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},0,{"$f":"+J35-N35","v":0},0,{"$f":"+J35*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",2.64,null,"Gallon",2,null,5.28,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},5.28,{"$f":"+J36-N36","v":0},528,{"$f":"+J36*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.95,null,0.95,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},0.95,{"$f":"+J39-N39","v":0},95,{"$f":"+J39*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,null,0,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},0,{"$f":"+J40-N40","v":0},0,{"$f":"+J40*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.61199999999999999,null,0.61199999999999999,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},0.61199999999999999,{"$f":"+J43-N43","v":0},61.199999999999996,{"$f":"+J43*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",3.6524727454416164,null,3.6524727454416164,0,0,null,0,0,3.6524727454416164,0,365.24727454416166,0]
[null,null,"Implements",1,null,"Acre",8.3716763917702615,null,8.3716763917702615,0,0,null,0,0,8.3716763917702615,0,837.1676391770261,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,4.7500000000000001E-2,null,7.6993783766150674,{"$f":"+SUM(J17:J48)/2*H49","v":0},null,null,0,{"$f":"+SUM(N17:N48)/2*L49","v":0},7.6993783766150674,{"$f":"+SUM(P17:P48)/2*L49","v":0},769.93783766150671,{"$f":"+J49*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,267.81550751382696,{"$f":"SUM(J18:J49)","v":0},null,null,0,{"$f":"SUM(N18:N49)","v":0},267.81550751382696,{"$f":"SUM(P18:P49)","v":0},26781.550751382696,{"$f":"SUM(R18:R49)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-267.81550751382696,{"$f":"+J13-J50","v":0},null,null,0,{"$f":"+N13-N50","v":0},-267.81550751382696,{"$f":"+P13-P50","v":0},-26781.550751382696,{"$f":"+R13-R50","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.64260000000000006,null,0.64260000000000006,{"$f":"E56*H56","v":0},0,null,0,{"$f":"J56*L56","v":0},0.64260000000000006,{"$f":"+J56-N56","v":0},64.260000000000005,{"$f":"+J56*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",3.0193774695650695,null,3.0193774695650695,0,0,null,0,{"$f":"J57*L57","v":0},3.0193774695650695,0,301.93774695650694,0]
[null,null,"Implements",1,null,"Acre",10.623158534278959,null,10.623158534278959,0,0,null,0,{"$f":"J58*L58","v":0},10.623158534278959,0,1062.3158534278959,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",4.4370000000000003,null,"Dollars",5.2499999999999998E-2,null,0.2329425,{"$f":"E60*H60","v":0},0,null,0,{"$f":"J60*L60","v":0},0.2329425,{"$f":"+J60-N60","v":0},23.294249999999998,{"$f":"+J60*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",23.521924480644007,null,"Dollars",5.2499999999999998E-2,null,1.2349010352338103,0,0,null,0,{"$f":"J61*L61","v":0},1.2349010352338103,0,123.49010352338104,0]
[null,null,"Implements",45.44351150774888,null,"Dollars",5.2499999999999998E-2,null,2.385784354156816,0,0,null,0,{"$f":"J62*L62","v":0},2.385784354156816,0,238.57843541568161,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J63*L63","v":0},0,{"$f":"+J63-N63","v":0},0,{"$f":"+J63*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Bermuda Pasture Rent",null,1,null,"Acre",20,null,20,0,0,null,0,0,20,0,2000,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E70*H70","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,38.138763893234653,{"$f":"+SUM(J56:J70)","v":0},null,null,0,{"$f":"+SUM(N56:N70)","v":0},38.138763893234653,{"$f":"+SUM(P56:P70)","v":0},3813.8763893234654,{"$f":"+SUM(R56:R70)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,305.95427140706158,{"$f":"+J50+J71","v":0},null,null,0,{"$f":"+N50+N71","v":0},305.95427140706158,{"$f":"+P50+P71","v":0},30595.427140706161,{"$f":"+R50+R71","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-305.95427140706158,{"$f":"+J13-J72","v":0},null,null,0,{"$f":"+N13-N72","v":0},-305.95427140706158,{"$f":"+P13-P72","v":0},-30595.427140706161,{"$f":"+R13-R72","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","","Costs",null,null,"Costs"]
[null,0.75,0,0,null,null,0]
[null,0.9,0,0,null,null,0]
[null,1,0,0,null,null,0]
[null,1.1000000000000001,0,0,null,null,0]
[null,1.25,0,0,null,null,0]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"SmallGrainPasture","index":6,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":false,"merged":[[74,3,74,8],[84,3,84,8],[94,0,94,9],[96,0,96,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Small Grains - Ryegrass Winter Pasture"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",100,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(100 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,0,null,0,null,"",0,null,0,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},0,{"$f":"+J10-N10","v":0},0,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,0,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},0,{"$f":"SUM(P10:P12)","v":0},0,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Fertilizer"]
[null,"","Nitrogen",180,null,"Pound",0.42499999999999999,null,76.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},76.5,{"$f":"+J18-N18","v":0},7650,{"$f":"+J18*E$7","v":0}]
[null,"","Phosphate",30,null,"Pound",0.5,null,15,0,0,null,0,0,15,0,1500,0]
[null,"","Potash",60,null,"Pound",0.25,null,15,0,0,null,0,0,15,0,1500,0]
[null,"Seed"]
[null,"","Seed - Elbon Rye",100,null,"Pound",0.32,null,32,0,0,null,0,0,32,0,3200,0]
[null,"","Seed - Ryegrass",25,null,"Pound",0.8,null,20,0,0,null,0,0,20,0,2000,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E26*H26","v":0},0,null,0,{"$f":"J26*L26","v":0},0,{"$f":"+J26-N26","v":0},0,{"$f":"+J26*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.65,null,"Hour",15,null,9.75,{"$f":"E28*H28","v":0},0,null,0,{"$f":"J28*L28","v":0},9.75,{"$f":"+J28-N28","v":0},975,{"$f":"+J28*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",15,null,0,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},0,{"$f":"+J29-N29","v":0},0,{"$f":"+J29*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E32*H32","v":0},0,null,0,{"$f":"J32*L32","v":0},0,{"$f":"+J32-N32","v":0},0,{"$f":"+J32*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",2.31,null,"Gallon",2,null,4.62,{"$f":"E33*H33","v":0},0,null,0,{"$f":"J33*L33","v":0},4.62,{"$f":"+J33-N33","v":0},462,{"$f":"+J33*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.95,null,0.95,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},0.95,{"$f":"+J36-N36","v":0},95,{"$f":"+J36*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,null,0,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},0,{"$f":"+J37-N37","v":0},0,{"$f":"+J37*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.61199999999999999,null,0.61199999999999999,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},0.61199999999999999,{"$f":"+J40-N40","v":0},61.199999999999996,{"$f":"+J40*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",3.2243963955698587,null,3.2243963955698587,0,0,null,0,0,3.2243963955698587,0,322.43963955698587,0]
[null,null,"Implements",1,null,"Acre",8.2272284325865872,null,8.2272284325865872,0,0,null,0,0,8.2272284325865872,0,822.72284325865871,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,4.7500000000000001E-2,null,4.8413125584452708,{"$f":"+SUM(J17:J45)/2*H46","v":0},null,null,0,{"$f":"+SUM(N17:N45)/2*L46","v":0},4.8413125584452708,{"$f":"+SUM(P17:P45)/2*L46","v":0},484.13125584452706,{"$f":"+J46*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,190.72493738660174,{"$f":"SUM(J18:J46)","v":0},null,null,0,{"$f":"SUM(N18:N46)","v":0},190.72493738660174,{"$f":"SUM(P18:P46)","v":0},19072.493738660174,{"$f":"SUM(R18:R46)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-190.72493738660174,{"$f":"+J13-J47","v":0},null,null,0,{"$f":"+N13-N47","v":0},-190.72493738660174,{"$f":"+P13-P47","v":0},-19072.493738660174,{"$f":"+R13-R47","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.64260000000000006,null,0.64260000000000006,{"$f":"E53*H53","v":0},0,null,0,{"$f":"J53*L53","v":0},0.64260000000000006,{"$f":"+J53-N53","v":0},64.260000000000005,{"$f":"+J53*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",2.6655010203377492,null,2.6655010203377492,0,0,null,0,{"$f":"J54*L54","v":0},2.6655010203377492,0,266.55010203377492,0]
[null,null,"Implements",1,null,"Acre",10.493155371013653,null,10.493155371013653,0,0,null,0,{"$f":"J55*L55","v":0},10.493155371013653,0,1049.3155371013654,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",4.4370000000000003,null,"Dollars",5.2499999999999998E-2,null,0.2329425,{"$f":"E57*H57","v":0},0,null,0,{"$f":"J57*L57","v":0},0.2329425,{"$f":"+J57-N57","v":0},23.294249999999998,{"$f":"+J57*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",20.765112787469889,null,"Dollars",5.2499999999999998E-2,null,1.0901684213421692,0,0,null,0,{"$f":"J58*L58","v":0},1.0901684213421692,0,109.01684213421692,0]
[null,null,"Implements",44.887386864891738,null,"Dollars",5.2499999999999998E-2,null,2.3565878104068161,0,0,null,0,{"$f":"J59*L59","v":0},2.3565878104068161,0,235.65878104068162,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J60*L60","v":0},0,{"$f":"+J60-N60","v":0},0,{"$f":"+J60*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"None",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E67*H67","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,17.480955123100387,{"$f":"+SUM(J53:J67)","v":0},null,null,0,{"$f":"+SUM(N53:N67)","v":0},17.480955123100387,{"$f":"+SUM(P53:P67)","v":0},1748.0955123100387,{"$f":"+SUM(R53:R67)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,208.20589250970212,{"$f":"+J47+J68","v":0},null,null,0,{"$f":"+N47+N68","v":0},208.20589250970212,{"$f":"+P47+P68","v":0},20820.589250970213,{"$f":"+R47+R68","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-208.20589250970212,{"$f":"+J13-J69","v":0},null,null,0,{"$f":"+N13-N69","v":0},-208.20589250970212,{"$f":"+P13-P69","v":0},-20820.589250970213,{"$f":"+R13-R69","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","","Costs",null,null,"Costs"]
[null,0.75,0,0,null,null,0]
[null,0.9,0,0,null,null,0]
[null,1,0,0,null,null,0]
[null,1.1000000000000001,0,0,null,null,0]
[null,1.25,0,0,null,null,0]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CowCalf","index":7,"n_rows":93,"n_cols":14,"rows_kept":93,"cut":false,"hidden":false,"merged":[[67,7,67,8],[67,10,67,12],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[66,2,66,12],[79,7,79,8],[79,10,79,12],[68,7,68,8],[68,10,68,12],[69,7,69,8],[69,10,69,12],[70,7,70,8],[70,10,70,12],[71,7,71,8],[71,10,71,12],[72,7,72,8],[72,10,72,12],[78,2,78,12],[80,7,80,8],[80,10,80,12],[81,7,81,8],[81,10,81,12],[82,7,82,8],[82,10,82,12],[83,7,83,8],[83,10,83,12],[84,7,84,8],[84,10,84,12],[92,0,92,13],[89,0,90,13]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Animal Unit"]
["Cow-Calf Production"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Cows"]
[null,"Animal Units (AU)",null,40,null,"Animal Unit",null,null,null,null,null,null,null,"Your"]
[null,"Breeding Females",null,40,null,"Calf","Your",null,null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your","Quantity","Quantity",null,null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Head","Head","Per Head","Per Head","Units","$/Unit","$/Unit","Total","Total",{"$f":"\"(\" & D7 & \" AUs)\"","v":"(40 AUs)"},{"$f":"\"(\" & E7 & \" AUs)\"","v":"( AUs)"}]
[null,"Steer",null,0.42499999999999999,null,5.5,null,"CWT",140,null,327.25,{"$f":"+E11*G11*J11","v":0},13090,{"$f":"+L11*E$7","v":0}]
[null,"Heifer",null,0.3,null,5.2,null,"CWT",126,null,196.56,{"$f":"+E12*G12*J12","v":0},7862.4,{"$f":"+L12*E$7","v":0}]
[null,"Cull Cow",null,0.15,null,10.5,null,"CWT",45,null,70.875,0,2835,0]
[null,"Cull Bull",null,1.2500000000000001E-2,null,18,null,"CWT",65,null,14.625,0,585,0]
[null,null,null,0,null,0,null,null,0,null,0,0,0,0]
[null,null,null,0,null,0,null,null,0,null,0,0,0,0]
["Total Revenue",null,null,null,null,389.75,null,null,null,null,609.30999999999995,{"$f":"+SUM(L11:L16)","v":0},24372.400000000001,{"$f":"+SUM(N11:N16)","v":0}]
[null,null,null,null,null,569.75]
[null,null,null,null,null,180,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
["Production Costs"]
[null,"Miscellaneous"]
[null,null,"Miscellaneous - Cow",null,null,1,null,"Head",10,null,10,{"$f":"+J23*G23","v":0},400,{"$f":"+L23*E$7","v":0}]
[null,null,null,null,null,1,null,null,0,null,0,0,0,0]
[null,null,null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Marketing Expense",null,null,null,1,null,"AU",31.95,null,31.95,0,1278,0]
[null,"Feed"]
[null,null,"Salt and Mineral - Cow",null,null,1,null,"Head",45,null,45,{"$f":"+J28*G28","v":0},1800,{"$f":"+L28*E$7","v":0}]
[null,null,"Hay ",null,null,0.5,null,"Ton",90,null,45,0,1800,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Vet. Medicine"]
[null,null,"Vet Medicine - Cow",null,null,1,null,"Head",42,null,42,0,1680,{"$f":"+L34*E$7","v":0}]
[null,null,null,null,null,0,null,null,0,null,0,{"$f":"+J35*G35","v":0},0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Fuel",null,null,null,1,null,"AU",2.875,null,2.875,0,115,0]
[null,"Lube (As a % of fuel)",null,null,null,0.1,null,"Percent",2.875,null,0.28750000000000003,0,11.500000000000002,0]
[null,"Repairs ",null,null,null,1,null,"AU",2.7906874999999998,null,2.7906874999999998,0,111.6275,0]
[null,"Labor",null,null,null,0,null,"Hours",0,null,0,0,0,0]
[null,"Utilities",null,null,null,1,null,"AU",0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+J43*G43","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,null,null,4.7500000000000001E-2,null,12.136621328430747,{"$f":"+SUM(L21:L45)/2*J46","v":0},485.46485313722991,0]
["Total Variable Costs",null,null,null,null,null,null,null,null,null,192.03980882843072,{"$f":"+SUM(L23:L46)","v":0},7681.5923531372291,{"$f":"+SUM(N23:N46)","v":0}]
[]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,null,null,417.27019117156919,{"$f":"+L17-L47","v":0},16690.807646862773,{"$f":"+N17-N47","v":0}]
[null,"Average Calf Breakeven Price to Cover Variable Costs",null,null,null,null,null,null,27.335422406268307,{"$f":"IF((E11*G11+E12*G12)=0,\"n/a\",(L47-SUM(L13:L16))/(E11*G11+E12*G12))","v":"n/a"},"CWT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
[null,"Depreciation - Equipment",null,null,null,1,null,"AU",22.802187499999999,null,22.802187499999999,{"$f":"+G53*J53","v":0},912.08749999999998,{"$f":"+L53*E$7","v":0}]
[null,"Depreciation - Livestock",null,null,null,1,null,"AU",70.714285714285708,null,70.714285714285708,0,2828.5714285714284,0]
[null,"Equipment Investment",null,null,null,461.94843750000001,null,"dollars",5.2499999999999998E-2,null,24.252292968749998,0,970.09171874999993,0]
[null,"Insurance",null,null,null,1,null,"AU",0,null,0,0,0,0]
[null,"Management Fee, Owner/Operator Labor",null,null,null,1,null,"AU",0,null,0,{"$f":"+J57*G57","v":0},0,0]
[null,"Salaried Labor",null,null,null,1,null,"AU",0,null,0,{"$f":"+J58*G58","v":0},0,0]
[null,"Pasture Cost",null,null,null,2.5,null,"Acres",156.10930063127881,null,390.27325157819701,0,15610.93006312788,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+G60*J60","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,null,null,508.04201776123273,{"$f":"+SUM(L53:L59)","v":0},20321.680710449309,{"$f":"+SUM(N53:N59)","v":0}]
["Total Costs",null,null,null,null,null,null,null,null,null,700.08182658966348,{"$f":"+L47+L62","v":0},28003.273063586537,{"$f":"+N47+N62","v":0}]
["Planned Returns to Management, Risk, and Profit:",null,null,null,null,null,null,null,null,null,-90.771826589663533,{"$f":"+L17-L63","v":0},-3630.8730635865359,{"$f":"+N17-N63","v":0}]
[null,"Average Calf Breakeven Price to Cover Total Costs",null,null,null,null,null,null,157.686164615693,{"$f":"IF((E11*G11+E12*G12)=0,\"n/a\",(L63-SUM(L13:L16))/(E11*G11+E12*G12))","v":"n/a"},"CWT"]
[]
[null,null,"Sensitivity Analysis for Example"]
[null,null,"Example Weaning Percent","Example Gross Sales per Animal Unit",null,"Pounds Produced per Animal Unit",null,"Example Breakeven Calf Pay Weight to Cover Total Cost",null,null,"Example Average Breakeven Price to Cover Total Cost"]
[null,null,0.91,646.2848235294116,null,597.26176470588234,null,601.69785075072753,null,null,147.28927464103191]
[null,null,0.88,627.79741176470588,null,583.50588235294117,null,626.42515968568898,null,null,152.31049991288529]
[null,null,0.85,609.30999999999995,null,569.75,null,653.27195224364709,null,null,157.686164615693]
[null,null,0.82,590.82258823529401,null,555.99411764705883,null,682.52293517992985,null,null,163.45517063821836]
[null,null,0.78999999999999992,572.33517647058807,null,542.23823529411766,null,714.51619776648909,null,null,169.66232901688488]
[]
[null,null,null,{"$f":"\"Example Male \"&F8&\" Price\"","v":"Example Male Calf Price"},null,null,null,null,null,null,{"$f":"+I11","v":140}]
[null,null,null,{"$f":"\"Example Female \"&F8&\" Price\"","v":"Example Female Calf Price"},null,null,null,null,null,null,{"$f":"+I12","v":126}]
[null,null,null,{"$f":"\"Example Weighted Average \"&F8&\" Price ($/cwt)\"","v":"Example Weighted Average Calf Price ($/cwt)"},null,null,null,null,null,null,{"$f":"+(K11+K12)/(D11*F11+D12*F12)","v":134.39640795381655}]
[]
[null,null,"Sensitivity Analysis for Your Values"]
[null,null,"Your Weaning Percent",{"$f":"\"Your Gross Sales per \"&F7","v":"Your Gross Sales per Animal Unit"},null,{"$f":"\"Pounds Produced per \"&F7","v":"Pounds Produced per Animal Unit"},null,{"$f":"\"Your Breakeven \"&F8&\" Pay Weight to Cover Total Cost\"","v":"Your Breakeven Calf Pay Weight to Cover Total Cost"},null,null,"Your Average Breakeven Price to Cover Total Cost"]
[null,null,{"$f":"+C82+C69-C70","v":1.06},{"$f":"+IF($C$83=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C81/$C$83)","v":0},null,{"$f":"IF($C$83=0,0,$M$87*C81/$C$83+$M$88)","v":0},null,{"$f":"IF($D$83=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C81-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F81-$M$88=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F81-$M$88)*100)","v":0}]
[null,null,{"$f":"+C83+C70-C71","v":1.0299999999999998},{"$f":"+IF($C$83=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C82/$C$83)","v":0},null,{"$f":"IF($C$83=0,0,$M$87*C82/$C$83+$M$88)","v":0},null,{"$f":"IF($D$83=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C82-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F82-$M$88=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F82-$M$88)*100)","v":0}]
[null,null,1,{"$f":"+L17","v":0},null,{"$f":"M87+M88","v":0},null,{"$f":"IF($D$83=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C83-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F83-$M$88=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F83-$M$88)*100)","v":0}]
[null,null,{"$f":"+C83+C72-C71","v":0.96999999999999986},{"$f":"+IF($C$83=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C84/$C$83)","v":0},null,{"$f":"IF($C$83=0,0,$M$87*C84/$C$83+$M$88)","v":0},null,{"$f":"IF($D$83=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C84-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F84-$M$88=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F84-$M$88)*100)","v":0}]
[null,null,{"$f":"+C84+C73-C72","v":0.93999999999999984},{"$f":"+IF($C$83=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C85/$C$83)","v":0},null,{"$f":"IF($C$83=0,0,$M$87*C85/$C$83+$M$88)","v":0},null,{"$f":"IF($D$83=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C85-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F85-$M$88=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F85-$M$88)*100)","v":0}]
[]
[null,null,null,{"$f":"\"Your Male \"&F8&\" Price\"","v":"Your Male Calf Price"},null,null,null,null,null,null,{"$f":"+J11","v":0},null,{"$f":"(E11*G11+E12*G12)*100","v":0}]
[null,null,null,{"$f":"\"Your Female \"&F8&\" Price\"","v":"Your Female Calf Price"},null,null,null,null,null,null,{"$f":"+J12","v":0},null,{"$f":"(E13*G13+E14*G14)*100","v":0}]
[null,null,null,{"$f":"\"Your Weighted Average \"&F8&\" Price ($/cwt)\"","v":"Your Weighted Average Calf Price ($/cwt)"},null,null,null,null,null,null,{"$f":"+IF((E11*G11+E12*G12)=0,0,(L11+L12)/(E11*G11+E12*G12))","v":0}]
["Developed by Gerald Cornforth, Extension Economist; Vanessa Olson, Extension Forage Specialist; and, Jason Banta, Extension Beef Cattle Specialist, Texas A&M AgriLife Extension Service.  For more information, contact:  Vanessa Olson or Jason Banta at 903-834-6191. "]
[]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"Livestock Budget","index":8,"n_rows":116,"n_cols":8,"rows_kept":116,"cut":false,"hidden":false,"merged":[[94,4,94,5],[94,6,94,7],[0,0,0,6],[2,0,2,6],[92,1,92,7],[93,4,93,5],[93,6,93,7],[95,4,95,5],[95,6,95,7],[96,4,96,5],[96,6,96,7],[97,4,97,5],[97,6,97,7],[98,4,98,5],[98,6,98,7],[104,2,104,7],[108,2,110,2],[108,3,110,3],[108,4,110,4],[108,5,108,7]]}
["Estimated Costs and Returns per Animal or Breeding Female"]
[]
["Livestock Enterprise"]
[]
["Number of Head of Livestock",null,null,0]
[]
["Enter Your Values in the cells highlighed in MAROON.",null,null,null,null,null,null,"Enterprise"]
["REVENUE",null,"Head","Quantity","Units","$/Unit","Total","Total"]
[null,"Males Sold",0,0,"CWT",0,{"$f":"IF($D$5=0,0,C9/$D$5*D9*F9)","v":0},{"$f":"+G9*$D$5","v":0}]
[null,"Females Sold",0,0,"CWT",0,{"$f":"IF($D$5=0,0,C10/$D$5*D10*F10)","v":0},{"$f":"+G10*$D$5","v":0}]
[null,"Cull Breeding Females",0,0,"CWT",0,0,0]
[null,"Cull Breeding Males",0,0,"CWT",0,0,0]
[null,"Stocker or Feed Animal",0,0,"CWT",0,0,0]
[null,"Other Revenue",0,0,"CWT",0,0,0]
[null,"Other Revenue",0,0,"CWT",0,0,0]
[null,"Other Revenue",0,0,"CWT",0,0,0]
[]
["Total Revenue",null,null,null,null,null,{"$f":"+SUM(G9:G17)","v":0},{"$f":"+SUM(H9:H17)","v":0}]
[]
[null,null,null,null,null,null,null,"Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Units","$/Unit","Total","Total"]
["Production Costs"]
[null,"Animal Purchase Price, if applicable",null,0,"Cwt",0,{"$f":"D23*F23","v":0},{"$f":"+G23*$D$5","v":0}]
[null,"Pasture",{"$f":"+SUM(G25:G28)","v":0}]
[null,null,"Pasture 1",0,"Acre",0,{"$f":"D25*F25","v":0},{"$f":"+G25*$D$5","v":0}]
[null,null,"Pasture 2",0,"Acre",0,0,0]
[null,null,"Pasture 3",0,"Acre",0,0,0]
[null,null,"Pasture 4",0,"Acre",0,0,0]
[null,"Feed",{"$f":"SUM(G30:G37)","v":0}]
[null,null,"Hay",0,"Bales",0,{"$f":"D30*F30","v":0},{"$f":"+G30*$D$5","v":0}]
[null,null,"Supplement",0,"Cwt,lb,etc",0,{"$f":"D31*F31","v":0},{"$f":"+G31*$D$5","v":0}]
[null,null,"Salt Minerals",0,"Cwt",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,"Health",{"$f":"SUM(G39:G48)","v":0}]
[null,null,"Vet/Medicine 1",0,"Visit,dose,cc's, etc.",0,{"$f":"D39*F39","v":0},{"$f":"+G39*$D$5","v":0}]
[null,null,"Vet/Medicine 2",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 3",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 4",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 5",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 6",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 7",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 8",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 9",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 10",0,"Visit,dose,cc's, etc.",0,0,0]
[]
[null,"Fuel, lube, repair",null,1,"Head",0,0,0]
[]
[null,"Labor",null,0,"Hours",0,0,0]
[]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[]
[null,"Operating Interest",null,null,null,0,{"$f":"+SUM(G23:G59)/2*F61","v":0},0]
[]
["Total Variable Costs",null,null,null,null,null,{"$f":"+SUM(G23:G62)","v":0},{"$f":"+SUM(H23:H62)","v":0}]
[]
["Planned Returns Above Variable Costs",null,null,null,null,null,{"$f":"+G18-G63","v":0},{"$f":"+H18-H63","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,{"$f":"IF((H101/100+C13*D13)=0,0,(G63-SUM(G11:G12,G14:G16))/(H101/100+C13*D13))","v":0},{"$f":"+E9","v":"CWT"}]
[]
[null,null,null,null,null,null,null,"Enterprise"]
["FIXED COSTS",null,null,"Quantity","Units","$/Unit","Total","Total"]
[null,"Depreciation - Equipment",null,0,"Head,$,etc",0,{"$f":"D71*F71","v":0},{"$f":"+G71*$D$5","v":0}]
[null,"Depreciation - Livestock",null,0,"Head,$,etc",0,{"$f":"D72*F72","v":0},0]
[null,"Equipment Investment",null,0,"Head,$,etc",0,0,0]
[null,"Insurance",null,0,"Head,$,etc",0,0,0]
[null,"Management Fee",null,0,"Head,$,etc",0,0,0]
[null,"Owner/Operator Labor",null,0,"Head,$,etc",0,0,0]
[null,"Salaried Labor",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[]
[null,null,null,"Total Fixed Costs",null,null,{"$f":"+SUM(G71:G83)","v":0},{"$f":"+SUM(H71:H83)","v":0}]
[]
[null,null,null,"Total Specified Costs",null,null,{"$f":"+G63+G84","v":0},{"$f":"+H63+H84","v":0}]
[]
[null,null,null,"Returns Above Specifiied Costs",null,null,{"$f":"+G18-G86","v":0},{"$f":"+H18-H86","v":0}]
[]
[null,"Breakeven Price to Cover Total Costs",null,null,{"$f":"IF((H101/100+C13*D13)=0,0,(G86-SUM(G11:G12,G14:G16))/(H101/100+C13*D13))","v":0},{"$f":"+F67","v":"CWT"}]
[]
[]
[null,"Sensitivity Analysis for Your Breeding Herd or Flock Values"]
[null,"Your Weaning Percent",{"$f":"\"Your Gross Sales per \"&F18","v":"Your Gross Sales per "},"Pounds Produced per AU",{"$f":"\"Your Breakeven \"&F19&\" Pay Weight to Cover Total Cost\"","v":"Your Breakeven  Pay Weight to Cover Total Cost"},null,"Your Average Breakeven Price to Cover Total Cost"]
[null,{"$f":"+B96-0.03","v":0.94},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B95/$B$97)","v":0},{"$f":"IF($B$97=0,0,$H$101*B95/$B$97+$H$102)","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B95-C9/D5))","v":0},null,{"$f":"IF(D95-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D95-$H$102)*100)","v":0}]
[null,{"$f":"+B97-0.03","v":0.97},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B96/$B$97)","v":0},{"$f":"IF($B$97=0,0,$H$101*B96/$B$97+$H$102)","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B96-C10/D5))","v":0},null,{"$f":"IF(D96-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D96-$H$102)*100)","v":0}]
[null,1,{"$f":"+YTotRet","v":0},{"$f":"H101+H102","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B97-C11/D5))","v":0},null,{"$f":"IF(D97-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D97-$H$102)*100)","v":0}]
[null,{"$f":"+B97+0.03","v":1.03},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B98/$B$97)","v":0},{"$f":"IF($B$97=0,0,$H$101*B98/$B$97+$H$102)","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B98-C12/D5))","v":0},null,{"$f":"IF(D98-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D98-$H$102)*100)","v":0}]
[null,{"$f":"+B98+0.03","v":1.06},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B99/$B$97)","v":0},0,{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B99-C13/D5))","v":0},null,{"$f":"IF(D99-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D99-$H$102)*100)","v":0}]
[]
[null,null,"Your Male Price",null,null,{"$f":"+F9","v":0},null,{"$f":"(C9*D9+C10*D10)*100","v":0}]
[null,null,"Your Female Price",null,null,{"$f":"+F10","v":0},null,{"$f":"(C11*D11+C12*D12)*100","v":0}]
[null,null,"Your Weighted Average Price ($/cwt)",null,null,{"$f":"+IF((C9*D9+C10*D10)=0,F13,(G9+G10)/(C9*D9+C10*D10))","v":0}]
[]
[null,null,"Your Stocker or Feeder Break Even Sensitivity Analysis"]
[null,null,"Your Average Daily Gain",null,0,"Pounds per Day"]
[null,null,{"$f":"+\"Your Animal\"&IF(M25=\"Stocker\",\" Grazing\",\" Feeding\")&\" Days\"","v":"Your Animal Feeding Days"},null,0,"Days"]
[null,null,"Your Sale Shrink",null,0]
[null,null,"Average Daily Gain    (Pounds/day)","Net Pay Weight with Shrink   (Pounds)",null,{"$f":"+\"Purchase Weight (Pounds/Head): \"&D23*100","v":"Purchase Weight (Pounds/Head): 0"},null,"Sales Price/Cwt of $Total"]
[null,null,null,null,null,{"$f":"\"Sales Price        \"&IF(F13=\"\",\".00\",TEXT(F13,\"#.00\"))","v":"Sales Price        .00"},null,{"$f":"\"Purchase Price        \"&IF(F23=\"\",\".00\",TEXT(F23,\"#.00\"))","v":"Purchase Price        .00"}]
[null,null,null,null,null,"B/E Purchase Price ($/CWT)",null,"B/E Sales Price ($/CWT)"]
[null,null,{"$f":"+C114*1.2","v":0},{"$f":"+C112*$E$107+$D$23*100*(1-$E$108)","v":0},null,{"$f":"IF($D$23=0,0,(((D112*$F$13/100*$C$13)-($G$63-SUM($F$14:$F$16)-$G$23)-$G$84)/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($F$14:$F$16))/(D112*$C$13/100))","v":0}]
[null,null,{"$f":"+C114*1.1","v":0},{"$f":"+C113*$E$107+$D$23*100*(1-$E$108)","v":0},null,{"$f":"IF($D$23=0,0,(((D113*$F$13/100*$C$13)-($G$63-SUM($F$14:$F$16)-$G$23)-$G$84)/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($F$14:$F$16))/(D113*$C$13/100))","v":0}]
[null,null,{"$f":"+E106","v":0},0,null,0,null,0]
[null,null,{"$f":"+C114*0.9","v":0},0,null,0,null,0]
[null,null,{"$f":"+C114*0.8","v":0},0,null,0,null,0]

{"sheet":"Crop Budget","index":9,"n_rows":155,"n_cols":7,"rows_kept":155,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,5],[146,1,146,6]]}
["Estimated Costs and Returns per Acre"]
[]
["Crop Enterprise"]
[]
["Number of Acres of Crop",null,null,0]
[]
["Enter Your Values in the cells highlighed in MAROON.",null,null,null,null,null,"Enterprise"]
["REVENUE",null,"Quantity","Units","$/Unit","Total","Total"]
[null,"Primary Product",0,"Cwt,lb,etc",0,{"$f":"C9*E9","v":0},{"$f":"+F9*$D$5","v":0}]
[null,"Secondary Product",0,"Cwt,lb,etc",0,{"$f":"C10*E10","v":0},{"$f":"+F10*$D$5","v":0}]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[]
["Total Revenue",null,null,null,null,{"$f":"+SUM(F9:F16)","v":0},{"$f":"+SUM(G9:G16)","v":0}]
[]
[null,null,null,null,null,null,"Enterprise"]
["VARIABLE COSTS",null,"Quantity","Units","$/Unit","Total","Total"]
[]
["Custom Field and Harvest Operations"]
[null,"Custom Field Operation 1",0,"Acre",0,{"$f":"C24*E24","v":0},{"$f":"+F24*$D$5","v":0}]
[null,"Custom Field Operation 2",0,"Acre",0,0,0]
[null,"Custom Field Operation 3",0,"Acre",0,0,0]
[null,"Custom Field Operation 4",0,"Acre",0,0,0]
[null,"Custom Field Operation 5",0,"Acre",0,0,0]
[null,"Custom Field Operation 6",0,"Acre",0,0,0]
["Machinery Expenses"]
[null,"Diesel",0,"Gallon",0,{"$f":"C31*E31","v":0},0]
[null,"Gasoline",0,"Gallon",0,0,0]
[null,"Lube",0,"Acre",0,0,0]
[null,"Repairs",0,"Acre",0,0,0]
[null,"Other Machinery Expense 1",0,"Acre",0,0,0]
[null,"Other Machinery Expense 2",0,"Acre",0,0,0]
["Labor"]
[null,"Labor 1",0,"Hour",0,{"$f":"C38*E38","v":0},0]
[null,"Labor 2",0,"Hour",0,0,0]
[null,"Labor 3",0,"Hour",0,0,0]
[null,"Labor 4",0,"Hour",0,0,0]
[null,"Labor 5",0,"Hour",0,0,0]
[null,"Irrigation Labor",0,"Hour",0,0,0]
["Seed or Transplants"]
[null,"Seed",0,"Pound",0,{"$f":"C45*E45","v":0},0]
[null,"Seed Treatment",0,"Pound",0,0,0]
[null,"Seed Fee",0,"Pound",0,0,0]
[null,"Transplants",0,"Thousand",0,0,0]
[null,"Mulch",0,"Foot",0,0,0]
[null,"Other Seed or Transplant",0,"Pound",0,0,0]
["Fertilizer and Lime"]
[null,"Fertlizer 1",0,"Pound",0,{"$f":"C52*E52","v":0},0]
[null,"Fertlizer 2",0,"Pound",0,0,0]
[null,"Fertlizer 3",0,"Pound",0,0,0]
[null,"Fertlizer 4",0,"Pound",0,0,0]
[null,"Fertlizer 5",0,"Pound",0,0,0]
[null,"Lime",0,"Ton",0,0,0]
[null,"Other Soil Amendment 1",0,"Pound",0,0,0]
[null,"Other Soil Amendment 2",0,"Pound",0,0,0]
["Herbicides"]
[null,"Herbicide 1",0,"Lb,Oz,Acre",0,{"$f":"C61*E61","v":0},0]
[null,"Herbicide 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 6",0,"Lb,Oz,Acre",0,0,0]
["Insecticides"]
[null,"Insecticide 1",0,"Lb,Oz,Acre",0,{"$f":"C68*E68","v":0},0]
[null,"Insecticide 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 6",0,"Lb,Oz,Acre",0,0,0]
["Fungicides"]
[null,"Fungicide 1",0,"Lb,Oz,Acre",0,{"$f":"C75*E75","v":0},0]
[null,"Fungicide 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 6",0,"Lb,Oz,Acre",0,0,0]
["Growth Regulators"]
[null,"Growth Regulator 1",0,"Lb,Oz,Acre",0,{"$f":"C82*E82","v":0},0]
[null,"Growth Regulator 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 6",0,"Lb,Oz,Acre",0,0,0]
["Other Chemicals"]
[null,"Fumigant",0,"Lb,Oz,Acre",0,{"$f":"C89*E89","v":0},0]
[null,"Other Chemical 1",0,"Lb,Oz,Acre",0,0,{"$f":"+F90*$D$5","v":0}]
[null,"Other Chemical 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Other Chemical 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Other Chemical 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Other Chemical 5",0,"Lb,Oz,Acre",0,0,0]
["Irrigation"]
[null,"Well Expense",0,"Acre",0,{"$f":"C96*E96","v":0},{"$f":"+F96*$D$5","v":0}]
[null,"Pump Fuel",0,"Mcf,kWh,Gallon",0,0,0]
[null,"Pump Expense",0,"Acre",0,0,0]
[null,"Irrigation Equipment Expense",0,"Acre",0,0,0]
[null,"Repairs",0,"Acre",0,0,0]
[null,"Drip Tape",0,"Foot,Acre",0,0,0]
[null,"Water Cost",0,"AcIn,Gallon",0,0,0]
[null,"Other Irrigation Expense 1",0,"Acre",0,0,0]
[null,"Other Irrigation Expense 2",0,"Acre",0,0,0]
["Miscellaneous Expenses"]
[null,"Crop Insurance",0,"Acre",0,{"$f":"C106*E106","v":0},0]
[null,"Other Variable Expense 1",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 2",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 3",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 4",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 5",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 6",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 7",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 8",0,"Enter Unit",0,0,0]
[]
[null,"Operating Interest",null,null,0,{"$f":"+SUM(F23:F115)/2*E116","v":0},{"$f":"+F116*$D$6","v":0}]
[]
["Total Variable Costs",null,null,null,null,{"$f":"+SUM(F23:F116)","v":0},{"$f":"+SUM(G23:G116)","v":0}]
[]
["Planned Returns Above Variable Costs",null,null,null,null,{"$f":"+F18-F118","v":0},{"$f":"+G18-G118","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,{"$f":"+IF(C9=0,0,F118-SUM(F10:F16)/C9)","v":0},{"$f":"+D9","v":"Cwt,lb,etc"}]
[]
[null,null,null,null,null,null,"Enterprise"]
["FIXED COSTS",null,"Quantity","Units","$/Unit","Total","Total"]
[null,"Land Rent or Expense",0,"Acre",0,{"$f":"C126*E126","v":0},{"$f":"+F126*$D$6","v":0}]
[null,"Depreciation - Equipment",0,"Acre,$,etc",0,{"$f":"C127*E127","v":0},0]
[null,"Equipment Investment",0,"Acre,$,etc",0,0,0]
[null,"Insurance",0,"Acre,$,etc",0,0,0]
[null,"Management Fee",0,"Acre,$,etc",0,0,0]
[null,"Owner/Operator Labor",0,"Acre,$,etc",0,0,0]
[null,"Salaried Labor",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[]
[null,null,null,"Total Fixed Costs",null,{"$f":"+SUM(F126:F137)","v":0},{"$f":"+SUM(G126:G137)","v":0}]
[]
[null,null,null,"Total Specified Costs",null,{"$f":"+F118+F139","v":0},{"$f":"+G118+G139","v":0}]
[]
[null,null,null,"Returns Above Specifiied Costs",null,{"$f":"+F18-F141","v":0},{"$f":"+G18-G141","v":0}]
[]
[null,"Breakeven Price to Cover Total Costs",null,null,{"$f":"+IF(C9=0,0,F141-SUM(F10:F16)/C9)","v":0},{"$f":"+D9","v":"Cwt,lb,etc"}]
[]
[null,"Breakeven Prices for Your Crop"]
[null,null,null,null,"To Cover",null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,"Total"]
[null,"Percent",{"$f":"+D9","v":"Cwt,lb,etc"},null,"Costs",null,"Costs"]
[null,0.75,{"$f":"+$C$153*B151","v":0},null,{"$f":"+IF(C151=0,0,($F$118-SUM($F$10:$F$16))/C151)","v":0},null,{"$f":"+IF(C151=0,0,($F$141-SUM($F$10:$F$16))/C151)","v":0}]
[null,0.9,{"$f":"+$C$153*B152","v":0},null,0,null,{"$f":"+IF(C152=0,0,($F$141-SUM($F$10:$F$16))/C152)","v":0}]
[null,1,{"$f":"+C9","v":0},null,{"$f":"+IF(C153=0,0,($F$118-SUM($F$10:$F$16))/C153)","v":0},null,{"$f":"+IF(C153=0,0,($F$141-SUM($F$10:$F$16))/C153)","v":0}]
[null,1.1000000000000001,0,null,{"$f":"+IF(C154=0,0,($F$118-SUM($F$10:$F$16))/C154)","v":0},null,{"$f":"+IF(C154=0,0,($F$141-SUM($F$10:$F$16))/C154)","v":0}]
[null,1.25,0,null,0,null,{"$f":"+IF(C155=0,0,($F$141-SUM($F$10:$F$16))/C155)","v":0}]

{"sheet":"Comparative Returns - Cash Rent","index":10,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,7,2,10],[2,4,2,5],[2,1,2,2]]}
["Comparative Returns - Cash Rent"]
[]
[null,"Returns Above Total Specified Expenses",null,null,"Total Direct Expenses",null,null,"Break-Even Yield to Cover Total Costs at Price Entered"]
[null,"Total","Variable",null,"Total","Variable",null,"Price","Units","Total","Variable"]
["FORAGE CROPS"]
[]
[{"$f":"+CoastalEstablish!A3","v":"Coastal Bermudagrass Establishment"},{"$f":"+CoastalEstablish!TotRet","v":-453.14158602439016},{"$f":"+CoastalEstablish!VarRet","v":-426.1391169807639},null,{"$f":"+CoastalEstablish!TotExp","v":453.14158602439016},{"$f":"+CoastalEstablish!VarExp","v":426.1391169807639},null,{"$f":"+CoastalEstablish!Price","v":0},{"$f":"+CoastalEstablish!Unit","v":""},{"$f":"+IF($H7=0,0,E7/$H7)","v":0},0]
[{"$f":"+LargeRoundHay!A3","v":"Coastal Bermudagrass Hay, Large Bales"},{"$f":"+LargeRoundHay!TotRet","v":-159.72923990515636},{"$f":"+LargeRoundHay!VarRet","v":-135.34691982461931},null,{"$f":"+LargeRoundHay!TotExp","v":429.72923990515636},{"$f":"+LargeRoundHay!VarExp","v":405.34691982461931},null,{"$f":"+LargeRoundHay!Price","v":90},{"$f":"+LargeRoundHay!Unit","v":"Ton"},4.7747693322795151,4.5038546647179922]
[{"$f":"+SmallSquareHay!A3","v":"Coastal Bermudagrass Hay, Small Square Bales (60 lbs.)"},{"$f":"+SmallSquareHay!TotRet","v":245.21406493010431},{"$f":"+SmallSquareHay!VarRet","v":293.09572541126289},null,{"$f":"+SmallSquareHay!TotExp","v":354.78593506989569},{"$f":"+SmallSquareHay!VarExp","v":306.90427458873711},null,{"$f":"+SmallSquareHay!Price","v":6},{"$f":"+SmallSquareHay!Unit","v":"Bale"},59.13098917831595,51.150712431456185]
[{"$f":"+CoastalPasture!A3","v":"Coastal Bermudagrass Pasture Grazing"},{"$f":"+CoastalPasture!TotRet","v":-156.10930063127881},{"$f":"+CoastalPasture!VarRet","v":-134.43836407882694},null,{"$f":"+CoastalPasture!TotExp","v":156.10930063127881},{"$f":"+CoastalPasture!VarExp","v":134.43836407882694},null,{"$f":"+CoastalPasture!Price","v":0},{"$f":"+CoastalPasture!Unit","v":""},0,0]
[{"$f":"+CoastalOverseed!A3","v":"Coastal Bermudagrass Pasture, Overseeded Rye and Ryegrass"},{"$f":"+CoastalOverseed!TotRet","v":-305.95427140706158},{"$f":"+CoastalOverseed!VarRet","v":-267.81550751382696},null,{"$f":"+CoastalOverseed!TotExp","v":305.95427140706158},{"$f":"+CoastalOverseed!VarExp","v":267.81550751382696},null,{"$f":"+CoastalOverseed!Price","v":0},{"$f":"+CoastalOverseed!Unit","v":""},0,0]
[{"$f":"+SmallGrainPasture!A3","v":"Small Grains - Ryegrass Winter Pasture"},{"$f":"+SmallGrainPasture!TotRet","v":-208.20589250970212},{"$f":"+SmallGrainPasture!VarRet","v":-190.72493738660174},null,{"$f":"+SmallGrainPasture!TotExp","v":208.20589250970212},{"$f":"+SmallGrainPasture!VarExp","v":190.72493738660174},null,{"$f":"+SmallGrainPasture!Price","v":0},{"$f":"+SmallGrainPasture!Unit","v":""},{"$f":"+IF($H12=0,0,E12/$H12)","v":0},0]
[]
["LIVESTOCK"]
[]
[{"$f":"+CowCalf!A3","v":"Cow-Calf Production"},{"$f":"+CowCalf!TotRet","v":-90.771826589663533},{"$f":"+CowCalf!VarRet","v":417.27019117156919},null,{"$f":"+CowCalf!TotExp","v":700.08182658966348},{"$f":"+CowCalf!VarExp","v":192.03980882843072},null,{"$f":"+CowCalf!Price","v":134.39640795381655},{"$f":"+CowCalf!Unit","v":"CWT"},{"$f":"+IF($H16=0,0,E16/$H16)","v":5.209081382816696},1.4289058149115303]

{"sheet":"Your Returns - Cash Rent","index":11,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,5,2,6],[2,8,2,11]]}
["Your Returns - Cash Rent"]
[]
[null,"Quantity ","Returns Above Total Specified Expenses",null,null,"Total Direct Expenses",null,null,"Break-Even Yield to Cover Total Costs at Price Entered"]
[null,"Acres, AUs,  or Head","Total","Variable",null,"Total","Variable",null,"Price","Units","Total","Variable"]
["FORAGE CROPS"]
[]
[{"$f":"+CoastalEstablish!A3","v":"Coastal Bermudagrass Establishment"},{"$f":"+CoastalEstablish!E7","v":0},{"$f":"+CoastalEstablish!YTotRet","v":0},{"$f":"+CoastalEstablish!YVarRet","v":0},null,{"$f":"+CoastalEstablish!YTotExp","v":0},{"$f":"+CoastalEstablish!YVarExp","v":0},null,{"$f":"+CoastalEstablish!YPrice","v":0},{"$f":"+CoastalEstablish!Unit","v":""},{"$f":"+IF($I7=0,0,F7/$I7)","v":0},0]
[{"$f":"+LargeRoundHay!A3","v":"Coastal Bermudagrass Hay, Large Bales"},{"$f":"+LargeRoundHay!E7","v":0},{"$f":"+LargeRoundHay!YTotRet","v":0},{"$f":"+LargeRoundHay!YVarRet","v":0},null,{"$f":"+LargeRoundHay!YTotExp","v":0},{"$f":"+LargeRoundHay!YVarExp","v":0},null,{"$f":"+LargeRoundHay!YPrice","v":0},{"$f":"+LargeRoundHay!Unit","v":"Ton"},0,0]
[{"$f":"+SmallSquareHay!A3","v":"Coastal Bermudagrass Hay, Small Square Bales (60 lbs.)"},{"$f":"+SmallSquareHay!E7","v":0},{"$f":"+SmallSquareHay!YTotRet","v":0},{"$f":"+SmallSquareHay!YVarRet","v":0},null,{"$f":"+SmallSquareHay!YTotExp","v":0},{"$f":"+SmallSquareHay!YVarExp","v":0},null,{"$f":"+SmallSquareHay!YPrice","v":0},{"$f":"+SmallSquareHay!Unit","v":"Bale"},0,0]
[{"$f":"+CoastalPasture!A3","v":"Coastal Bermudagrass Pasture Grazing"},{"$f":"+CoastalPasture!E7","v":0},{"$f":"+CoastalPasture!YTotRet","v":0},{"$f":"+CoastalPasture!YVarRet","v":0},null,{"$f":"+CoastalPasture!YTotExp","v":0},{"$f":"+CoastalPasture!YVarExp","v":0},null,{"$f":"+CoastalPasture!YPrice","v":0},{"$f":"+CoastalPasture!Unit","v":""},0,0]
[{"$f":"+CoastalOverseed!A3","v":"Coastal Bermudagrass Pasture, Overseeded Rye and Ryegrass"},{"$f":"+CoastalOverseed!E7","v":0},{"$f":"+CoastalOverseed!YTotRet","v":0},{"$f":"+CoastalOverseed!YVarRet","v":0},null,{"$f":"+CoastalOverseed!YTotExp","v":0},{"$f":"+CoastalOverseed!YVarExp","v":0},null,{"$f":"+CoastalOverseed!YPrice","v":0},{"$f":"+CoastalOverseed!Unit","v":""},0,0]
[{"$f":"+SmallGrainPasture!A3","v":"Small Grains - Ryegrass Winter Pasture"},{"$f":"+SmallGrainPasture!E7","v":0},{"$f":"+SmallGrainPasture!YTotRet","v":0},{"$f":"+SmallGrainPasture!YVarRet","v":0},null,{"$f":"+SmallGrainPasture!YTotExp","v":0},{"$f":"+SmallGrainPasture!YVarExp","v":0},null,{"$f":"+SmallGrainPasture!YPrice","v":0},{"$f":"+SmallGrainPasture!Unit","v":""},{"$f":"+IF($I12=0,0,F12/$I12)","v":0},0]
[]
["LIVESTOCK"]
[]
[{"$f":"+CowCalf!A3","v":"Cow-Calf Production"},{"$f":"+CowCalf!E7","v":0},{"$f":"+CowCalf!YTotRet","v":0},{"$f":"+CowCalf!YVarRet","v":0},null,{"$f":"+CowCalf!YTotExp","v":0},{"$f":"+CowCalf!YVarExp","v":0},null,{"$f":"+CowCalf!YPrice","v":0},{"$f":"+CowCalf!Unit","v":"CWT"},{"$f":"+IF($I16=0,0,F16/$I16)","v":0},0]
[]
["OTHER BUDGETS"]
[]
[{"$f":"+'Livestock Budget'!A3","v":"Livestock Enterprise"},{"$f":"+'Livestock Budget'!D5","v":0},{"$f":"+'Livestock Budget'!YTotRet","v":0},{"$f":"+'Livestock Budget'!YVarRet","v":0},null,{"$f":"+'Livestock Budget'!YTotExp","v":0},{"$f":"+'Livestock Budget'!YVarExp","v":0},null,{"$f":"+'Livestock Budget'!YPrice","v":0},{"$f":"+'Livestock Budget'!Unit","v":"CWT"},{"$f":"+IF($I20=0,0,F20/$I20)","v":0},{"$f":"+IF($I20=0,0,G20/$I20)","v":0}]
[{"$f":"+'Crop Budget'!A3","v":"Crop Enterprise"},{"$f":"+'Crop Budget'!D5","v":0},{"$f":"+'Crop Budget'!YTotRet","v":0},{"$f":"+'Crop Budget'!YVarRet","v":0},null,{"$f":"+'Crop Budget'!YTotExp","v":0},{"$f":"+'Crop Budget'!YVarExp","v":0},null,{"$f":"+'Crop Budget'!YPrice","v":0},{"$f":"+'Crop Budget'!Unit","v":"Cwt,lb,etc"},0,0]