{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Prices","Feed","Lease with Raised Repl","Lease with Purchased Repl"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,1,55,10],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[28,1,29,11],[31,1,31,4],[32,1,33,11],[41,1,42,11],[47,6,47,8],[51,1,54,11],[30,1,30,11],[35,1,38,11]]}
[]
[]
[null,"KSU-Beef Cow Lease"]
[]
[null,"Excel spreadsheet for estabishing a calf-income split or cash rental rate for leasing a beef cow herd"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 9.6.2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"The KSU-Beef Cow Lease spreadsheet takes a budgeting approach to estimate the costs and returns for a year-long lease of a beef cow herd.  The Cattle Owner and Livestock Operator need to determine who will be contributing each expense and calf income will be shared accordingly.  Note: If the cowherd will be transitioning from the Cattle Owner to the Livestock Operator the spreadsheet should be re-evaluated every year as cattle ownership changes."]
[]
[null,"This spreasheet is directly linked to the K-State Beef Farm Management Guides and will be updated quarterly.  Users still need to enter prices/costs for their own production scenario."]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly.  Blue values are inputs that should be changed from the defaults to match your operation.  Black values are automatically calculated."]
[]
[]
[null,"There are two spreadsheets for cow leasing: Lease with Raised Repl assumes that heifers will be retained for replacements from the cowherd and expenses in developing them are split the same as other cowherd expenses.  Lease with Purchased Repl assumes that all calves will be sold or transitioned out of the herd at weaning and bred heifers will be purchased for replacements."]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"Developed by:"]
[]
[null,"Robin Reid",null,null,null,null,"Glynn T. Tonsor, Ph.D."]
[null,"Extension Associate",null,null,null,null,"Agricultural Economist"]
[null,"Department of Agricultural Economics",null,null,null,null,"Department of Agricultural Economics"]
[null,"Kansas State University",null,null,null,null,"Kansas State University"]
[null,"robinreid@ksu.edu",null,null,null,null,"gtonsor@k-state.edu"]
[null,"785-532-0964",null,null,null,null,"785-532-1518"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"The developers would like to thank the K-State Beef Team for their contributions: Dr. Sandy Johnson, Dr. Dale Blasi, Dr. Joel DeRouchey, Dr. Jaymelynn Farney, Dr. Christopher Reinhardt, Dr. Justin Waggoner, and Dr. Bob Weaber  www.KSUBeef.org\n"]
[]
[]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Prices","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["2016 Production Year"]
["Five Years Out Prices"]
[null,{"$f":"A1","v":"2016 Production Year"},{"$f":"A2","v":"Five Years Out Prices"}]
[null,"(as of Sept 1st, 2016)","(Nov. 2015 USDA)"]
["Corn ($/bu)",2.9249999999999998,3.7,"http://www.usda.gov/oce/commodity/projections/"]
["Soybean Meal ($/ton)",311.2,330,"http://www.usda.gov/oce/commodity/projections/"]
["DDGS ($/ton)",132.5,167.60683760683762,"Adjust off of Corn Price"]
[]
["Silage ($/ton)",23.4,29.6,"Equal to 8X the corn price"]
["Prairie Hay ($/ton)",60,75.897435897435912,"Adjust off of Corn Price"]
["Alfalfa ($/ton)",105,132.82051282051285,"Adjust off of Corn Price"]
["Pasture Rental ($/acre)",19.22,21.141999999999999,"Current price *1.10"]
["Crop Residue ($/acre)",15,16.5,"Current price *1.10"]
["Beef Cow Mineral ($/ton)",800,880.00000000000011,"Current price *1.10"]
["Other Beef Mineral ($/ton)",550,605,"Current price *1.10"]
[]
["Oct. Heifer Calf Price ($/cwt)*",131.62,174.49508479366872,"Adjust off of Steer Calf price"]
["Oct. Steer Calves Price ($/cwt)*",141.52000000000001,187.62,"http://www.usda.gov/oce/commodity/projections/"]
["Beef Cull cow ($/cwt)*****",67.75,82.250461478674822,"Fed cattle change imposed"]
[]
["* This a predicted October price for the budget year"]
["*****This a current cull cow price for the date of the latest price update"]

{"sheet":"Feed","index":2,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,8,2,15],[12,8,12,15],[21,8,21,15],[0,8,0,15]]}
[null,"CATTLE RATIONS TO SET FEED AND GRAZING COSTS",null,null,null,null,null,null,"These tables will be hidden when posted"]
[]
[null," Feed Requirements with Raised Replacements","(per cow unit + 16% of developing heifer + 4% of bull)",null,null,null,null,null,"Cow Ration"]
[null,null,"Qty","Unit",null,null,null,null,"Date Range","Days","Hay (pounds)","Supplement (DDGS) (pounds)","Grain (pounds)","Mineral (pounds)","Pasture (acres)","Corn Stalks (acres)"]
[null,"Pasture",{"$f":"O10+(0.04*O19)+(0.16*O28)","v":9.5400000000000009},"total acres per year",null,null,null,null,"1/1-3/1",60,31,2,null,0.25]
[null,"Crop Residue Grazing",{"$f":"P10+(0.04*P19)+(0.16*P28)","v":2.08},"total acres per year",null,null,null,null,"3/1-5/1",61,32,7,null,0.25]
[null,"Prairie/Brome Hay",{"$f":"(K10+(0.04*K19)+(0.16*K28))/2000","v":2.2483200000000001},"total tons per year",null,null,null,null,"5/1-10/31",183,null,null,null,0.25,8.5]
[null,"Silage",0,"total tons per year",null,null,null,null,"11/1-12/31",61,null,3,null,0.25,null,2]
[null,"Alfalfa",0,"total tons per year"]
[null,"Total Harvested Forage",{"$f":"SUM(C7:C9)","v":2.2483200000000001},"total tons per year",null,null,null,null,"Total ",{"$f":"SUM(J5:J8)","v":365},{"$f":"SUMPRODUCT($J$5:$J$8,K5:K8)","v":3812},{"$f":"SUMPRODUCT($J$5:$J$8,L5:L8)","v":730},{"$f":"SUMPRODUCT($J$5:$J$8,M5:M8)","v":0},{"$f":"SUMPRODUCT($J$5:$J$8,N5:N8)","v":91.25},{"$f":"SUM(O5:O8)","v":8.5},{"$f":"SUM(P5:P8)","v":2}]
[null,"Corn",{"$f":"M10+(0.04*M19)+(0.16*M28)","v":95.04},"total lbs per year",null,null,null,null,null,"Tons",{"$f":"K10/2000","v":1.9059999999999999}]
[null,"DDG's",{"$f":"L10+(0.04*L19)+(0.16*L28)","v":737.54600000000005},"total lbs per year"]
[null,"Soybean Meal",0,"total lbs per year",null,null,null,null,"Bull Ration"]
[null,"Total Grain/Protein Supplements",{"$f":"SUM(C11:C13)","v":832.58600000000001},"total lbs per year",null,null,null,null,"Date Range","Days","Hay (pounds)","Supplement (DDGS) (pounds)","Grain (pounds)","Mineral (pounds)","Pasture (acres)","Corn Stalks (acres)"]
[null,"Salt and Mineral",{"$f":"N10+(0.04*N19)+(0.16*N28)","v":100.74000000000001},"total lbs per year",null,null,null,null,"1/1-4/30",121,40,0.25,null,0.25]
[null,null,null,null,null,null,null,null,"5/1-10/31",183,null,null,null,0.25,8]
[null,null,null,null,null,null,null,null,"11/1-12/31",61,null,null,null,0.25,null,2]
[null,"Feed Requirements without Purchased Replacements","(per cow unit + 16% of developing heifer + 4% of bull)"]
[null,null,"Qty","Unit",null,null,null,null,"Total ",{"$f":"SUM(J15:J17)","v":365},{"$f":"SUMPRODUCT($J$15:$J$17,K15:K17)","v":4840},{"$f":"SUMPRODUCT($J$15:$J$17,L15:L17)","v":30.25},{"$f":"SUMPRODUCT($J$15:$J$17,M15:M17)","v":0},{"$f":"SUMPRODUCT($J$15:$J$17,N15:N17)","v":91.25},{"$f":"SUM(O15:O17)","v":8},{"$f":"SUM(P15:P17)","v":2}]
[null,"Pasture",{"$f":"O10+(0.04*O19)","v":8.82},"total acres per year",null,null,null,null,null,"Tons",{"$f":"K19/2000","v":2.42}]
[null,"Crop Residue",{"$f":"P10+(0.04*P19)","v":2.08},"total acres per year"]
[null,"Prairie/Brome Hay",{"$f":"K11+(0.04*K20)","v":2.0027999999999997},"total tons per year",null,null,null,null,"Heifer Ration"]
[null,"Silage",0,"total tons per year",null,null,null,null,"Date Range","Days","Hay (pounds)","Supplement (DDGS) (pounds)","Grain (pounds)","Mineral (pounds)","Pasture (acres)","Corn Stalks (acres)"]
[null,"Alfalfa",0,"total tons per year",null,null,null,null,"1/1-4/30",121,15.5,0.2,3,0.1]
[null,"Total Harvested Forage",{"$f":"SUM(C22:C24)","v":2.0027999999999997},"total tons per year",null,null,null,null,"5/1-10/15",167,null,null,null,{"$f":"N24","v":0.1},4.5]
[null,"Corn",{"$f":"M10+(0.04*M19)","v":0},"total lbs per year",null,null,null,null,"10/15-12/31",77,15.5,0.2,3,{"$f":"N25","v":0.1}]
[null,"DDG's",{"$f":"L10+(0.04*L19)","v":731.21},"total lbs per year"]
[null,"Soybean Meal",0,"total lbs per year",null,null,null,null,"Total ",{"$f":"SUM(J24:J26)","v":365},{"$f":"SUMPRODUCT($J$24:$J$26,K24:K26)","v":3069},{"$f":"SUMPRODUCT($J$24:$J$26,L24:L26)","v":39.6},{"$f":"SUMPRODUCT($J$24:$J$26,M24:M26)","v":594},{"$f":"SUMPRODUCT($J$24:$J$26,N24:N26)","v":36.5},{"$f":"SUM(O24:O26)","v":4.5},{"$f":"SUM(P24:P26)","v":0}]
[null,"Total Grain/Protein Supplements",{"$f":"SUM(C26:C28)","v":731.21},"total lbs per year",null,null,null,null,null,"Tons",{"$f":"K28/2000","v":1.5345}]
[null,"Salt and Mineral",{"$f":"N10+(0.04*N19)","v":94.9},"total lbs per year"]

{"sheet":"Lease with Raised Repl","index":3,"n_rows":235,"n_cols":14,"rows_kept":235,"cut":false,"hidden":false,"merged":[[233,0,233,9],[234,8,234,9],[227,5,227,9],[228,3,228,4],[228,5,228,9],[229,3,229,4],[229,5,229,9],[223,3,223,4],[224,3,224,4],[225,3,225,4],[226,3,226,4],[227,3,227,4],[219,3,219,4],[220,3,220,4],[221,3,221,4],[222,3,222,4],[214,3,214,4],[215,3,215,4],[216,3,216,4],[217,3,217,4],[218,3,218,4],[209,3,209,4],[210,3,210,4],[211,3,211,4],[212,3,212,4],[213,3,213,4],[204,3,204,4],[205,3,205,4],[206,3,206,4],[207,3,207,4],[208,3,208,4],[199,3,199,4],[200,3,200,4],[201,3,201,4],[202,3,202,4],[203,3,203,4],[194,3,194,4],[195,3,195,4],[196,3,196,4],[197,3,197,4],[198,3,198,4],[1,11,5,12],[40,13,40,16],[41,13,41,16],[42,13,42,16],[188,0,188,1],[188,2,188,5],[188,6,188,9],[122,2,122,3],[123,2,123,3],[44,0,44,9],[92,8,92,9],[133,8,133,9],[125,2,125,3],[126,2,126,3],[132,0,132,9],[94,0,94,1],[0,0,0,1],[0,2,0,5],[0,6,0,9],[91,0,91,9],[47,0,47,1],[47,2,47,5],[47,6,47,9],[45,8,45,9],[4,2,4,5],[4,6,4,7],[94,2,94,5],[94,6,94,9],[117,2,117,3],[118,2,118,3],[119,2,119,3],[192,2,192,5],[192,6,192,7],[120,2,120,3],[121,2,121,3],[124,2,124,3]]}
[" KSU Beef Cow Lease",null,"2016 Production Year",null,null,null,{"$f":"IF(C1=Prices!B3,TEXT(Prices!B4,\"MMM-YYYY\"),TEXT(Prices!C4,\"MMM-YYYY\"))","v":"(as of Sept 1st, 2016)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Change percentages to reflect which party is contributing the expense or receiving the income"]
["Production Efficiency Information"]
["Weaning Percentage",0.91]
["Cow Replacement Percentage",0.16,"Cow Culling Percentage",null,null,null,0.16]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Cow",null,"Cattle Owner","Livestock Operator"]
["Weaned Calf Sale",{"$f":"0.5*(IF(C1=Prices!A1,Prices!B18,Prices!C18))+0.5*(IF(C1=Prices!A1,Prices!B17,Prices!C17))","v":136.57},"per cwt"," x",550,"lbs"," x",{"$f":"B4","v":0.91}," =",{"$f":"B8*(E8/100)*H8","v":683.53285000000005},null,"Split","Split"]
["Cull Cows",{"$f":"IF(C1=Prices!A1,Prices!B19,Prices!C19)","v":67.75},"per cwt"," x",1250,"lbs"," x",{"$f":"G5","v":0.16}," =",{"$f":"B9*(E9/100)*H9","v":135.5},null,1,{"$f":"1-L9","v":0}]
["Other Income",null,null,null,null,null,null,null,null,0,null,1,{"$f":"1-L10","v":0}]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J10)","v":819.03285000000005}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B12,Prices!C12)","v":19.22},"per acre"," x",{"$f":"Feed!C5","v":9.5400000000000009},"total acres",null,null," =",{"$f":"B14*E14","v":183.3588},null,0,{"$f":"1-L14","v":1}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!B13,Prices!C13)","v":15},"per acre"," x",{"$f":"Feed!C6","v":2.08},"total acres",null,null," =",{"$f":"B15*E15","v":31.200000000000003},null,0,{"$f":"1-L15","v":1}]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!C7/Feed!C10)*Prices!B10)+((Feed!C8/Feed!C10)*Prices!B9)+((Feed!C9/Feed!C10)*Prices!B11)),((Feed!C7/Feed!C10)*Prices!C10)+((Feed!C8/Feed!C10)*Prices!C9)+((Feed!C9/Feed!C10)*Prices!C11))","v":60},"per ton"," x",{"$f":"Feed!C10","v":2.2483200000000001},"total tons",null,null," =",{"$f":"B16*E16","v":134.89920000000001},null,0,1]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!C13/Feed!C14)*Prices!B6)+((Feed!C12/Feed!C14)*Prices!B7)+((Feed!C11/Feed!C14)*(Prices!B5*2000)/56)),(((Feed!C13/Feed!C14)*Prices!C6)+((Feed!C12/Feed!C14)*Prices!C7)+((Feed!C11/Feed!C14)*(Prices!C5*2000)/56)))","v":129.29971283961743},"per ton"," x",{"$f":"Feed!C14","v":832.58600000000001},"total lbs",null,null," =",{"$f":"(B17/2000)*E17","v":53.826565357142854},null,0,1]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B14,Prices!C14)","v":800},"per ton"," x",{"$f":"Feed!C15","v":100.74000000000001},"total lbs",null,null," =",{"$f":"(B18/2000)*E18","v":40.296000000000006},null,0,1]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B19*E19","v":0},null,0,1]
["Labor",20,"per hour","x",8,"total hours",null,null," =",{"$f":"B20*E20","v":160},null,0.05,0.95]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,29,null,0.5,0.5]
["Replacement Females",{"$f":"((IF(C1=Prices!A1, Prices!B17,Prices!C17))/100)*E8","v":723.91},"per head"," x",{"$f":"B5","v":0.16},"hd",null,null," =",{"$f":"B22*E22","v":115.82559999999999},null,1,0]
["Annual Bull Charge or A.I.",null,null,null,null,null,null,null,null,{"$f":"((6000-1700)/4)*0.04","v":43},null,1,0]
["Other Livestock Breeding/Marketing",null,null,null,null,null,null,null,null,23,null,0,1]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,44,null,0,1]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,56,null,0,1]
["Other variable costs",null,null,null,null,null,null,null,null,17,null,0.5,0.5]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J14:J27)","v":931.40616535714287},null,{"$f":"SUMPRODUCT(J14:J27,L14:L27)","v":189.82560000000001},{"$f":"SUMPRODUCT(J14:J27,M14:M27)","v":741.58056535714286}]
[]
["Fixed Costs"]
["Cattle Ownership Interest",2000,"avg. value","x",0.06,"interest rate",null,null,"=",{"$f":"B31*E31","v":120},null,1,{"$f":"1-L31","v":0}]
["Cow Death Loss",2000,"avg. value","x",0.01,"cow death loss",null,null,"=",{"$f":"B32*E32","v":20},null,{"$f":"L31","v":1},{"$f":"1-L32","v":0}]
["Cow Depreciation",null,null,null,null,null,null,null,null,0,null,1,0]
["Equipment/Building Depreciation",null,null,null,null,null,null,null,null,57,null,0,1]
["Taxes",null,null,null,null,null,null,null,null,7,null,0,1]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,13,null,0.5,{"$f":"1-L36","v":0.5}]
["Other fixed costs",null,null,null,null,null,null,null,null,0,null,0.5,0.5]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J31:J37)","v":217},null,{"$f":"SUMPRODUCT(J31:J37,L31:L37)","v":146.5},{"$f":"SUMPRODUCT(J31:J37,M31:M37)","v":70.5}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J28+J38","v":1148.406165357143},null,{"$f":"SUM(L28,L38)","v":336.32560000000001},{"$f":"SUM(M28,M38)","v":812.08056535714286}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L40-SUMPRODUCT(L9:L10,J9:J10)","v":200.82560000000001},{"$f":"M40-SUMPRODUCT(M9:M10,J9:J10)","v":812.08056535714286},"Expenses Contributed Less Cull Cow and Other Income"]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J11-J28","v":-112.37331535714281},null,{"$f":"L41/SUM(L41,M41)","v":0.19826673671118436},{"$f":"M41/(SUM(L41,M41))","v":0.80173326328881567},"Percentage of calves to split "]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J11-J40","v":-329.37331535714293},null,{"$f":"L42*J8","v":135.5218276043955},{"$f":"M42*J8","v":548.01102239560464},"Anticipated Income per cow"]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-CowLease",null,null,null,null,null,null,null,{"$f":"TEXT(Introduction!L8,\"MMM. DD, YYYY\")","v":"Version- 9.6.2016"}]
[]
[{"$f":"A1","v":" KSU Beef Cow Lease"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A46","v":"Publication: AM-FMG-CowLease"},null,null,null,null,null,null,null,{"$f":"I46","v":"Version- 9.6.2016"}]
[]
[{"$f":"A1","v":" KSU Beef Cow Lease"}]
[]
[]
[]
[]
["Budget Assumptions"]
[]
["Cow-Calf Feed Requirements ","(per cow unit + 16% of developing heifer + 4% of bull)"]
[null,"Qty","Unit"]
["Pasture",{"$f":"Feed!C5","v":9.5400000000000009},"total acres per year"]
["Crop Residue Grazing",{"$f":"Feed!C6","v":2.08},"total acres per year"]
["Prairie/Brome Hay",{"$f":"Feed!C7","v":2.2483200000000001},"total tons per year"]
["Silage",{"$f":"Feed!C8","v":0},"total tons per year"]
["Alfalfa",{"$f":"Feed!C9","v":0},"total tons per year"]
["Total Harvested Forage",{"$f":"Feed!C10","v":2.2483200000000001},"total tons per year"]
["Corn",{"$f":"Feed!C11","v":95.04},"total lbs per year"]
["DDG's",{"$f":"Feed!C12","v":737.54600000000005},"total lbs per year"]
["Soybean Meal",{"$f":"Feed!C13","v":0},"total lbs per year"]
["Total Grain/Protein Supplements",{"$f":"Feed!C14","v":832.58600000000001},"total lbs per year"]
["Salt and Mineral",{"$f":"Feed!C15","v":100.74000000000001},"total lbs per year"]
[]
[]
["Default Cow-Calf Prices"]
[null,2016,"Five Years Out"]
[{"$f":"Prices!A5","v":"Corn ($/bu)"},{"$f":"Prices!B5","v":2.9249999999999998},{"$f":"Prices!C5","v":3.7}]
[{"$f":"Prices!A7","v":"DDGS ($/ton)"},{"$f":"Prices!B7","v":132.5},{"$f":"Prices!C7","v":167.60683760683762}]
[{"$f":"Prices!A10","v":"Prairie Hay ($/ton)"},{"$f":"Prices!B10","v":60},{"$f":"Prices!C10","v":75.897435897435912}]
[{"$f":"Prices!A12","v":"Pasture Rental ($/acre)"},{"$f":"Prices!B12","v":19.22},{"$f":"Prices!C12","v":21.141999999999999}]
[{"$f":"Prices!A13","v":"Crop Residue ($/acre)"},{"$f":"Prices!B13","v":15},{"$f":"Prices!C13","v":16.5}]
[{"$f":"Prices!A14","v":"Beef Cow Mineral ($/ton)"},{"$f":"Prices!B14","v":800},{"$f":"Prices!C14","v":880.00000000000011}]
[{"$f":"Prices!A17","v":"Oct. Heifer Calf Price ($/cwt)*"},{"$f":"Prices!B17","v":131.62},{"$f":"Prices!C17","v":174.49508479366872}]
[{"$f":"Prices!A18","v":"Oct. Steer Calves Price ($/cwt)*"},{"$f":"Prices!B18","v":141.52000000000001},{"$f":"Prices!C18","v":187.62}]
[{"$f":"Prices!A19","v":"Beef Cull cow ($/cwt)*****"},{"$f":"Prices!B19","v":67.75},{"$f":"Prices!C19","v":82.250461478674822}]
[]
[{"$f":"Prices!A21","v":"* This a predicted October price for the budget year"}]
[{"$f":"Prices!A22","v":"*****This a current cull cow price for the date of the latest price update"}]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A93","v":"Publication: AM-FMG-CowLease"},null,null,null,null,null,null,null,{"$f":"I93","v":"Version- 9.6.2016"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" KSU Beef Cow Lease",null,{"$f":"C1","v":"2016 Production Year"},null,null,null,{"$f":"G1","v":"(as of Sept 1st, 2016)"}]
[]
["Production Efficiency Information"]
["Weaning Percentage",{"$f":"B4","v":0.91}]
["Cow Replacement Percentage",{"$f":"B5","v":0.16},"Cow Culling Percentage",null,null,null,{"$f":"G5","v":0.16}]
[]
["Revenue","Total per Year per Cow","Cattle Owner","Livestock Operator"]
["Weaned Calf Sale",{"$f":"J8","v":683.53285000000005},{"$f":"L8","v":"Split"},"Split"]
["Cull Cows",{"$f":"J9","v":135.5},{"$f":"L9","v":1},{"$f":"1-C197","v":0}]
["Other Income",{"$f":"J10","v":0},{"$f":"L10","v":1},{"$f":"1-C198","v":0}]
["  Gross Income",{"$f":"J11","v":819.03285000000005}]
[]
["Variable Costs"]
["Pasture",{"$f":"J14","v":183.3588},{"$f":"L14","v":0},{"$f":"1-C202","v":1}]
["Crop Residue",31.200000000000003,0,{"$f":"1-C203","v":1}]
["Harvested Forage",134.89920000000001,0,1]
["Grain/Protein Supplements",53.826565357142854,0,1]
["Mineral",40.296000000000006,0,1]
["Other Feed",0,0,1]
["Labor",160,0.05,0.95]
["Vet Medicine/Drugs",29,0.5,0.5]
["Replacement Females",115.82559999999999,1,0]
["Annual Bull Charge or A.I.",43,1,0]
["Other Livestock Breeding/Marketing",23,0,1]
["Utilities,Gas, Fuel, Oil",44,0,1]
["Machinery, Facility/Equip. Repairs",56,0,1]
["Other variable costs",17,0.5,0.5]
["  Total Variable Costs",931.40616535714287,189.82560000000001,{"$f":"M28","v":741.58056535714286}]
[]
["Fixed Costs"]
["Cattle Ownership Interest",{"$f":"J31","v":120},{"$f":"L31","v":1},{"$f":"1-C219","v":0}]
["Cow Death Loss",{"$f":"J32","v":20},{"$f":"L32","v":1},{"$f":"1-C220","v":0}]
["Equipment/Building Depreciation",{"$f":"J34","v":57},{"$f":"L35","v":0},1]
["Taxes",7,{"$f":"L36","v":0.5},0.5]
["Farm/Livestock Insurance",13,{"$f":"L37","v":0.5},{"$f":"1-C223","v":0.5}]
["Other fixed costs",0,{"$f":"L37","v":0.5},{"$f":"1-C224","v":0.5}]
["  Total Fixed Costs",{"$f":"J38","v":217},{"$f":"L38","v":146.5},{"$f":"M38","v":70.5}]
[]
["Total Costs",{"$f":"J40","v":1148.406165357143},{"$f":"L40","v":336.32560000000001},812.08056535714286]
[null,null,200.82560000000001,812.08056535714286,null,"Expenses Contributed Less Cull Cow and Other Income"]
["Income Over Variable Costs",{"$f":"J42","v":-112.37331535714281},0.19826673671118436,0.80173326328881567,null,"Percentage of calves to split "]
["Income Over Total Costs ",{"$f":"J43","v":-329.37331535714293},135.5218276043955,548.01102239560464,null,"Anticipated Income per cow"]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A134","v":"Publication: AM-FMG-CowLease"},null,null,null,null,null,null,null,{"$f":"I134","v":"Version- 9.6.2016"}]

{"sheet":"Lease with Purchased Repl","index":4,"n_rows":236,"n_cols":14,"rows_kept":236,"cut":false,"hidden":false,"merged":[[40,13,40,16],[41,13,41,16],[42,13,42,16],[228,3,228,4],[229,3,229,4],[223,3,223,4],[224,3,224,4],[225,3,225,4],[226,3,226,4],[218,3,218,4],[219,3,219,4],[220,3,220,4],[221,3,221,4],[222,3,222,4],[213,3,213,4],[214,3,214,4],[234,0,234,9],[235,8,235,9],[227,5,227,9],[228,5,228,9],[229,5,229,9],[227,3,227,4],[215,3,215,4],[216,3,216,4],[217,3,217,4],[208,3,208,4],[209,3,209,4],[210,3,210,4],[211,3,211,4],[212,3,212,4],[203,3,203,4],[204,3,204,4],[205,3,205,4],[206,3,206,4],[207,3,207,4],[198,3,198,4],[199,3,199,4],[200,3,200,4],[201,3,201,4],[202,3,202,4],[193,3,193,4],[194,3,194,4],[195,3,195,4],[196,3,196,4],[197,3,197,4],[1,11,5,12],[132,0,132,9],[133,8,133,9],[121,2,121,3],[122,2,122,3],[123,2,123,3],[124,2,124,3],[125,2,125,3],[126,2,126,3],[92,0,92,9],[93,8,93,9],[95,0,95,1],[95,2,95,5],[0,0,0,1],[0,2,0,5],[0,6,0,9],[45,0,45,9],[46,8,46,9],[4,2,4,5],[4,6,4,7],[191,2,191,5],[191,6,191,7],[48,0,48,1],[48,2,48,5],[48,6,48,9],[95,6,95,9],[117,2,117,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[187,0,187,1],[187,2,187,5],[187,6,187,9]]}
[" KSU Beef Cow Lease",null,"2016 Production Year",null,null,null,{"$f":"IF(C1=Prices!B3,TEXT(Prices!B4,\"MMM-YYYY\"),TEXT(Prices!C4,\"MMM-YYYY\"))","v":"(as of Sept 1st, 2016)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Change percentages to reflect which party is contributing the expense or receiving the income"]
["Production Efficiency Information"]
["Weaning Percentage",0.91]
["Cow Replacement Percentage",0.16,"Cull Cow Percentage",null,null,null,0.16]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Cow",null,"Cattle Owner","Livestock Operator"]
["Weaned Calf Sale",{"$f":"0.5*(IF(C1=Prices!A1,Prices!B18,Prices!C18))+0.5*(IF(C1=Prices!A1,Prices!B17,Prices!C17))","v":136.57},"per cwt"," x",550,"lbs"," x",{"$f":"B4","v":0.91}," =",{"$f":"B8*(E8/100)*H8","v":683.53285000000005},null,"Split","Split"]
["Cull Cows",{"$f":"IF(C1=Prices!A1,Prices!B19,Prices!C19)","v":67.75},"per cwt"," x",1250,"lbs"," x",{"$f":"G5","v":0.16}," =",{"$f":"B9*(E9/100)*H9","v":135.5},null,1,{"$f":"1-L9","v":0}]
["Other Income",null,null,null,null,null,null,null,null,0,null,1,{"$f":"1-L10","v":0}]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J10)","v":819.03285000000005}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B12,Prices!C12)","v":19.22},"per acre"," x",{"$f":"Feed!C20","v":8.82},"total acres",null,null," =",{"$f":"B14*E14","v":169.5204},null,0,{"$f":"1-L14","v":1}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!B13,Prices!C13)","v":15},"per acre"," x",{"$f":"Feed!C21","v":2.08},"total acres",null,null," =",{"$f":"B15*E15","v":31.200000000000003},null,0,{"$f":"1-L15","v":1}]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!C7/Feed!C10)*Prices!B10)+((Feed!C8/Feed!C10)*Prices!B9)+((Feed!C9/Feed!C10)*Prices!B11)),((Feed!C7/Feed!C10)*Prices!C10)+((Feed!C8/Feed!C10)*Prices!C9)+((Feed!C9/Feed!C10)*Prices!C11))","v":60},"per ton"," x",{"$f":"Feed!C25","v":2.0027999999999997},"total tons",null,null," =",{"$f":"B16*E16","v":120.16799999999998},null,0,1]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!C13/Feed!C14)*Prices!B6)+((Feed!C12/Feed!C14)*Prices!B7)+((Feed!C11/Feed!C14)*(Prices!B5*2000)/56)),(((Feed!C13/Feed!C14)*Prices!C6)+((Feed!C12/Feed!C14)*Prices!C7)+((Feed!C11/Feed!C14)*(Prices!C5*2000)/56)))","v":129.29971283961743},"per ton"," x",{"$f":"Feed!C29","v":731.21},"total lbs",null,null," =",{"$f":"(B17/2000)*E17","v":47.272621512728328},null,0,1]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B14,Prices!C14)","v":800},"per ton"," x",{"$f":"Feed!C30","v":94.9},"total lbs",null,null," =",{"$f":"(B18/2000)*E18","v":37.96},null,0,1]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B19*E19","v":0},null,0,1]
["Labor",20,"per hour","x",6,"total hours",null,null," =",{"$f":"B20*E20","v":120},null,0.1,0.9]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"0.87*'Lease with Raised Repl'!J21","v":25.23},null,0.5,0.5]
["Replacement Females",1500,"per head"," x",{"$f":"B5","v":0.16},"hd",null,null," =",{"$f":"B22*E22","v":240},null,1,0]
["Annual Bull Charge or A.I.",null,null,null,null,null,null,null,null,{"$f":"0.87*'Lease with Raised Repl'!J23","v":37.409999999999997},null,1,0]
["Other Livestock Breeding/Marketing",null,null,null,null,null,null,null,null,{"$f":"0.87*'Lease with Raised Repl'!J24","v":20.010000000000002},null,0,1]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"0.87*'Lease with Raised Repl'!J25","v":38.28},null,0,1]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"0.87*'Lease with Raised Repl'!J26","v":48.72},null,0,1]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"0.87*'Lease with Raised Repl'!J27","v":14.79},null,0.5,0.5]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J14:J27)","v":950.56102151272819},null,{"$f":"SUMPRODUCT(J14:J27,L14:L27)","v":309.41999999999996},{"$f":"SUMPRODUCT(J14:J27,M14:M27)","v":641.14102151272823}]
[]
["Fixed Costs"]
["Cattle Ownership Interest",2000,"avg. value","x",0.06,"interest rate",null,null,"=",{"$f":"B31*E31","v":120},null,1,{"$f":"1-L31","v":0}]
["Cow Death Loss",2000,"avg. value","x",0.01,"cow death loss",null,null,"=",{"$f":"B32*E32","v":20},null,{"$f":"L31","v":1},{"$f":"1-L32","v":0}]
["Cow Depreciation",null,null,null,null,null,null,null,null,0,null,{"$f":"L31","v":1},0]
["Equipment/Building Depreciation",null,null,null,null,null,null,null,null,57,null,0,1]
["Taxes",null,null,null,null,null,null,null,null,7,null,0,1]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,{"$f":"0.87*'Lease with Raised Repl'!J36","v":11.31},null,0.5,{"$f":"1-L36","v":0.5}]
["Other fixed costs",null,null,null,null,null,null,null,null,0,null,0.5,0.5]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J31:J37)","v":215.31},null,{"$f":"SUMPRODUCT(J31:J37,L31:L37)","v":145.655},{"$f":"SUMPRODUCT(J31:J37,M31:M37)","v":69.655000000000001}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J28+J38","v":1165.8710215127282},null,{"$f":"SUM(L28,L38)","v":455.07499999999993},{"$f":"SUM(M28,M38)","v":710.7960215127282}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L40-SUMPRODUCT(L9:L10,J9:J10)","v":319.57499999999993},{"$f":"M40-SUMPRODUCT(M9:M10,J9:J10)","v":710.7960215127282},"Expenses Contributed Less Cull Cow and Other Income"]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J11-J28","v":-131.52817151272814},null,{"$f":"L41/SUM(L41,M41)","v":0.31015526769262142},{"$f":"M41/(SUM(L41,M41))","v":0.68984473230737875},"Percentage of calves to split "]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J11-J40","v":-346.8381715127282},null,{"$f":"L42*J8","v":212.00131406845045},{"$f":"M42*J8","v":471.53153593154968},"Anticipated Income per cow"]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-CowLease",null,null,null,null,null,null,null,{"$f":"TEXT(Introduction!L8,\"MMM. DD, YYYY\")","v":"Version- 9.6.2016"}]
[]
[{"$f":"A1","v":" KSU Beef Cow Lease"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A47","v":"Publication: AM-FMG-CowLease"},null,null,null,null,null,null,null,{"$f":"I47","v":"Version- 9.6.2016"}]
[]
[{"$f":"A1","v":" KSU Beef Cow Lease"}]
[]
[]
[]
[]
["Budget Assumptions"]
[]
["Cow-Calf Feed Requirements ","(per cow unit + 4% of bull)"]
[null,"Qty","Unit"]
["Pasture",{"$f":"Feed!C20","v":8.82},"total acres per year"]
["Crop Residue Grazing",{"$f":"Feed!C21","v":2.08},"total acres per year"]
["Prairie/Brome Hay",{"$f":"Feed!C22","v":2.0027999999999997},"total tons per year"]
["Silage",{"$f":"Feed!C23","v":0},"total tons per year"]
["Alfalfa",{"$f":"Feed!C24","v":0},"total tons per year"]
["Total Harvested Forage",{"$f":"Feed!C25","v":2.0027999999999997},"total tons per year"]
["Corn",{"$f":"Feed!C26","v":0},"total lbs per year"]
["DDG's",{"$f":"Feed!C27","v":731.21},"total lbs per year"]
["Soybean Meal",{"$f":"Feed!C28","v":0},"total lbs per year"]
["Total Grain/Protein Supplements",{"$f":"Feed!C29","v":731.21},"total lbs per year"]
["Salt and Mineral",{"$f":"Feed!C30","v":94.9},"total lbs per year"]
[]
["Default Cow-Calf Prices"]
[null,2016,"Five Years Out"]
[{"$f":"Prices!A5","v":"Corn ($/bu)"},{"$f":"Prices!B5","v":2.9249999999999998},{"$f":"Prices!C5","v":3.7}]
[{"$f":"Prices!A7","v":"DDGS ($/ton)"},{"$f":"Prices!B7","v":132.5},{"$f":"Prices!C7","v":167.60683760683762}]
[{"$f":"Prices!A10","v":"Prairie Hay ($/ton)"},{"$f":"Prices!B10","v":60},{"$f":"Prices!C10","v":75.897435897435912}]
[{"$f":"Prices!A12","v":"Pasture Rental ($/acre)"},{"$f":"Prices!B12","v":19.22},{"$f":"Prices!C12","v":21.141999999999999}]
[{"$f":"Prices!A13","v":"Crop Residue ($/acre)"},{"$f":"Prices!B13","v":15},{"$f":"Prices!C13","v":16.5}]
[{"$f":"Prices!A14","v":"Beef Cow Mineral ($/ton)"},{"$f":"Prices!B14","v":800},{"$f":"Prices!C14","v":880.00000000000011}]
[{"$f":"Prices!A17","v":"Oct. Heifer Calf Price ($/cwt)*"},{"$f":"Prices!B17","v":131.62},{"$f":"Prices!C17","v":174.49508479366872}]
[{"$f":"Prices!A18","v":"Oct. Steer Calves Price ($/cwt)*"},{"$f":"Prices!B18","v":141.52000000000001},{"$f":"Prices!C18","v":187.62}]
[{"$f":"Prices!A19","v":"Beef Cull cow ($/cwt)*****"},{"$f":"Prices!B19","v":67.75},{"$f":"Prices!C19","v":82.250461478674822}]
[]
[{"$f":"Prices!A21","v":"* This a predicted October price for the budget year"}]
[{"$f":"Prices!A22","v":"*****This a current cull cow price for the date of the latest price update"}]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A94","v":"Publication: AM-FMG-CowLease"},null,null,null,null,null,null,null,{"$f":"I94","v":"Version- 9.6.2016"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" KSU Beef Cow Lease",null,{"$f":"C1","v":"2016 Production Year"},null,null,null,{"$f":"G1","v":"(as of Sept 1st, 2016)"}]
[]
["Production Efficiency Information"]
["Weaning Percentage",{"$f":"B4","v":0.91}]
["Cow Replacement Percentage",{"$f":"B5","v":0.16},"Cull Cow Percentage",null,null,null,{"$f":"G5","v":0.16}]
[]
["Revenue","Total per Year per Cow","Cattle Owner","Livestock Operator"]
["Weaned Calf Sale",{"$f":"J8","v":683.53285000000005},{"$f":"L8","v":"Split"},"Split"]
["Cull Cows",{"$f":"J9","v":135.5},{"$f":"L9","v":1},{"$f":"1-C196","v":0}]
["Other Income",0,1,{"$f":"1-C197","v":0}]
["  Gross Income",{"$f":"J11","v":819.03285000000005}]
[]
["Variable Costs"]
["Pasture",169.5204,0,{"$f":"1-C201","v":1}]
["Crop Residue",31.200000000000003,0,{"$f":"1-C202","v":1}]
["Harvested Forage",120.16799999999998,0,1]
["Grain/Protein Supplements",47.272621512728328,0,1]
["Mineral",37.96,0,1]
["Other Feed",0,0,1]
["Labor",120,0.1,0.9]
["Vet Medicine/Drugs",25.23,0.5,0.5]
["Replacement Females",240,1,0]
["Annual Bull Charge or A.I.",37.409999999999997,1,0]
["Other Livestock Breeding/Marketing",20.010000000000002,0,1]
["Utilities,Gas, Fuel, Oil",38.28,0,1]
["Machinery, Facility/Equip. Repairs",48.72,0,1]
["Other variable costs",14.79,0.5,0.5]
["  Total Variable Costs",950.56102151272819,{"$f":"L28","v":309.41999999999996},{"$f":"M28","v":641.14102151272823}]
[]
["Fixed Costs"]
["Cattle Ownership Interest",120,1,{"$f":"1-C218","v":0}]
["Cow Death Loss",20,1,{"$f":"1-C219","v":0}]
["Cow Depreciation",0,1,0]
["Equipment/Building Depreciation",57,0,1]
["Taxes",7,0,1]
["Farm/Livestock Insurance",11.31,0.5,{"$f":"1-C223","v":0.5}]
["Other fixed costs",0,0.5,{"$f":"1-C224","v":0.5}]
["  Total Fixed Costs",215.31,145.655,{"$f":"M38","v":69.655000000000001}]
[]
["Total Costs",1165.8710215127282,455.07499999999993,{"$f":"M40","v":710.7960215127282}]
[null,null,319.57499999999993,{"$f":"M41","v":710.7960215127282},null,"Expenses Contributed Less Cull Cow and Other Income"]
["Income Over Variable Costs",-131.52817151272814,0.31015526769262142,{"$f":"M42","v":0.68984473230737875},null,"Percentage of calves to split "]
["Income Over Total Costs ",-346.8381715127282,212.00131406845045,{"$f":"M43","v":471.53153593154968},null,"Anticipated Income per cow"]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A134","v":"Publication: AM-FMG-CowLease"},null,null,null,null,null,null,null,{"$f":"I134","v":"Version- 9.6.2016"}]