{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cows, heifers, & bulls","Calves","Pastures","Feed, vet, & breeding costs","Other revenue","Overhead & interest","Results","calcs"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Cows, heifers, & bulls","index":0,"n_rows":56,"n_cols":19,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,8,55,9],[46,1,47,9],[51,1,51,3],[51,4,51,5],[51,6,51,7],[48,8,48,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[54,8,54,9],[53,1,53,3],[54,1,54,3],[55,1,55,3],[53,4,53,5],[54,4,54,5],[55,4,55,5],[53,6,53,7],[54,6,54,7],[55,6,55,7],[49,1,49,3],[52,4,52,5],[52,6,52,7],[50,6,50,7],[3,12,4,17],[17,1,17,2],[16,4,16,5],[12,4,12,5],[11,4,11,5],[12,1,12,2],[8,10,8,11],[11,10,11,11],[10,8,10,9],[10,10,10,11],[16,8,16,9],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[10,12,10,13],[8,12,8,13],[16,6,16,7],[13,1,13,2],[14,1,14,2],[11,1,11,2],[16,1,16,2],[20,1,20,2],[20,4,20,5],[15,1,15,2],[23,4,23,5],[20,6,20,7],[33,1,33,3],[34,1,34,3],[35,1,35,3],[31,1,31,3],[18,1,18,2],[19,1,19,2],[23,1,23,3],[27,6,27,7],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[24,4,24,5],[21,1,21,2],[21,4,21,5],[22,1,22,2],[22,4,22,5],[27,4,27,5],[21,6,21,7],[20,8,20,9],[15,6,15,7],[17,6,17,7],[15,8,15,9],[18,4,18,5],[18,6,18,7],[19,4,19,5],[19,6,19,7],[18,8,18,9],[19,8,19,9],[10,4,10,5],[10,6,10,7],[8,1,8,2],[11,6,11,7],[11,8,11,9],[15,4,15,5],[17,4,17,5],[12,6,12,7],[12,8,12,9],[17,8,17,9],[44,7,44,8],[40,5,40,6],[40,9,40,10],[1,1,2,10],[3,7,3,8],[4,1,5,6],[4,7,5,10],[8,4,8,5],[8,6,8,7],[8,8,8,9],[13,4,13,5],[14,4,14,5],[14,6,14,7],[14,8,14,9],[13,6,13,7],[13,8,13,9],[7,1,7,13],[9,1,9,2],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[10,1,10,2],[24,6,24,7],[40,11,40,12],[44,11,44,12],[42,5,42,6],[42,9,42,10],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[35,8,35,9],[31,10,31,11],[31,12,31,13],[40,13,40,14],[36,12,36,13],[36,14,36,15],[43,13,43,14],[44,9,44,10],[43,11,43,12],[43,9,43,10],[42,11,42,12],[42,13,42,14],[44,5,44,6],[41,5,41,6],[41,9,41,10],[26,4,26,5],[24,8,24,9],[25,4,25,5],[31,4,31,5],[31,6,31,7],[31,8,31,9],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[27,8,27,9],[25,6,25,7],[25,8,25,9],[26,6,26,7],[26,8,26,9],[21,8,21,9],[22,6,22,7],[22,8,22,9],[23,6,23,7],[23,8,23,9],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[18,10,18,11],[19,10,19,11],[20,10,20,11],[50,1,50,3],[52,1,52,3],[48,1,48,3],[21,10,21,11],[22,10,22,11],[23,10,23,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[34,8,34,9],[35,6,35,7],[36,6,36,7],[36,8,36,9],[33,6,33,7],[33,8,33,9],[34,6,34,7],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,1,32,3],[35,12,35,13],[31,16,31,17],[31,14,31,15],[36,16,36,17],[49,4,49,5],[49,6,49,7],[49,8,49,9],[36,1,36,3],[40,7,40,8],[41,7,41,8],[35,14,35,15],[35,16,35,17],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[40,1,40,3],[38,1,39,14],[41,11,41,12],[41,13,41,14],[44,13,44,14],[43,5,43,6],[42,7,42,8],[43,7,43,8],[35,18,35,19],[50,4,50,5],[48,4,48,5],[48,6,48,7],[36,18,36,19],[29,1,30,19],[31,18,31,19],[32,10,32,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[32,12,32,13],[32,14,32,15],[32,16,32,17],[32,18,32,19],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,18,33,19],[34,12,34,13],[34,14,34,15],[34,16,34,17],[34,18,34,19]]}
[]
[null,"Oklahoma Ranch Calculator--OK Ranch Calc\nOklahoma State University\n\nDeveloped by\nKeith Lusby, Animal Science and Odell Walker, Agricultural Economics\nUpdate by\nEric A. DeVuyst and Damona Doye, Agricultural Economics\nDavid Lalman, Animal Science"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"This program is designed to operate in MS Excel 2007. Earlier versions of Excel WILL generate errors!"]
[null,"type scenario description here",null,null,null,null,null,"2017-05-01"]
[]
[]
[null,"Cow, heifer, and bull inventory"]
[null,null,null,"units","Mature cows",null,"1st Calf heifers",null,"Yearling heifers",null,"Bulls",null,"Totals"]
[null,"Raised",null,"hd",80,null,20,null,25,null,0,null,"XXX"]
[null,"Base value",null,"$/hd",1125,null,1000,null,850,null,0,null,"XXX"]
[null,"Purchased",null,"hd",0,null,0,null,0,null,3,null,"XXX"]
[null,"% financed",null,"%",0,null,0,null,0,null,0.5,null,"XXX"]
[null,"Death loss",null,"%",0.01,null,0.01,null,0.01,null,0.01,null,"XXX"]
[null,"Borrowed",null,"$/hd",0,null,0,null,0,null,875,null,"XXX"]
[null,"Wean percentage",null,"%",0.86,null,0.82,null,"XXX",null,"XXX",null,{"$f":"IF(E10+G10+E12+G12>0,ROUND(((E10+E12)*E16+(G10+G12)*G16)/(E12+G12+E10+G10)*100,0)&\"% avg\")","v":"85% avg"}]
[null,"Calves weaned",null,"hd",{"$f":"(E10+E12)*E16","v":68.8},null,{"$f":"(G10+G12)*G16","v":16.399999999999999},null,"XXX",null,"XXX",null,{"$f":"SUM(E17:H17)","v":85.199999999999989}]
[null,"Steers weaned",null,"hd",34,null,8,null,"XXX",null,"XXX",null,{"$f":"SUM(E18:H18)","v":42}]
[null,"Heifers weaned",null,"hd",{"$f":"E17-E18","v":34.799999999999997},null,{"$f":"G17-G18","v":8.3999999999999986},null,"XXX",null,"XXX",null,{"$f":"SUM(E19:H19)","v":43.199999999999996}]
[null,"Heifers retained",null,"hd",19,null,6,null,"XXX",null,"XXX",null,{"$f":"SUM(E20:H20)","v":25}]
[null,"Initial principal",null,"$",{"$f":"E15*E12","v":0},null,{"$f":"G15*G12","v":0},null,{"$f":"I15*I12","v":0},null,{"$f":"K15*K12","v":2625},null,"XXX"]
[null,"Interest rate",null,"%",0.06,null,0.06,null,0.06,null,0.06,null,"XXX"]
[null,"Loan term",null,"years",4,null,5,null,5,null,3,null,"XXX"]
[null,"Years remaining on loan",null,null,3,null,5,null,4,null,2,null,"XXX"]
[null,"Payment frequency",null,null,"Annually",null,"Annually",null,"Annually",null,"Annually",null,"XXX"]
[null,"Total annual payments",null,null,0,null,0,null,0,null,982.03825857519655,null,{"$f":"SUM(E26:K26)","v":982.03825857519655}]
[null,"Total principal, current year",null,null,0,null,0,null,0,null,874.01055408970842,null,{"$f":"SUM(E27:K27)","v":874.01055408970842}]
[null,"Total interest, current year",null,null,0,null,0,null,0,null,108.02770448548814,null,{"$f":"SUM(E28:K28)","v":108.02770448548814}]
[]
[null,"Breeding stock purchases"]
[]
[null,null,null,null,"Head",null,"$/head",null,"Total $",null,"Percent financed",null,"Interest rate",null,"Month purchased",null,"Downpayment",null,"1st year interest"]
[null,"Mature cows",null,null,0,null,1125,null,{"$f":"E33*G33","v":0},null,0,null,null,null,1,null,{"$f":"I33*(1-K33)","v":0},null,{"$f":"I33*K33*M33*(13-O33)/12","v":0}]
[null,"1st calf heifers",null,null,0,null,1000,null,{"$f":"E34*G34","v":0},null,0,null,null,null,2,null,{"$f":"I34*(1-K34)","v":0},null,{"$f":"I34*K34*M34*(13-O34)/12","v":0}]
[null,"Yearling heifers",null,null,0,null,850,null,{"$f":"E35*G35","v":0},null,0,null,null,null,9,null,0,null,0]
[null,"Bulls",null,null,1,null,2850,null,{"$f":"E36*G36","v":2850},null,0.5,null,0.06,null,4,null,1425,null,64.125]
[null,"Total purchases",null,null,{"$f":"SUM(E33:F36)","v":1},null,null,null,{"$f":"SUM(I33:J36)","v":2850},null,null,null,null,null,null,null,2850,null,0]
[]
[null,"Cull sales"]
[]
[null,null,null,null,"# sold","Average weight\n(lbs)",null,"Average cost basis/base value",null,"Sale price\n($/cwt)",null,"$/head",null,"Total"]
[null,"Cull cows and 1st calf heifers",null,null,24,1150,null,1000,null,82,null,{"$f":"J42*F42/100","v":943},null,{"$f":"E42*L42","v":22632}]
[null,"Cull yearling heifers",null,null,0,825,null,850,null,162,null,{"$f":"J43*F43/100","v":1336.5},null,{"$f":"E43*L43","v":0}]
[null,"Cull bulls",null,null,1,1750,null,1300,null,104,null,{"$f":"J44*F44/100","v":1820},null,{"$f":"E44*L44","v":1820}]
[null,"Total sales",null,null,{"$f":"SUM(E42:E44)","v":25},{"$f":"SUMPRODUCT(E42:E44,F42:F44)","v":29350},null,null,null,null,null,null,null,{"$f":"SUM(N42:O44)","v":24452}]
[]
[null,"Inventory"]
[]
[null,null,null,null,"Mature cows & 1st calf heifers",null,"Yearling heifers",null,"Bulls"]
[null,"Beginning inventory",null,null,{"$f":"E10+G10+E12+G12","v":100},null,{"$f":"I10+G12","v":25},null,{"$f":"K10+K12","v":3}]
[null,"Transferred in",null,null,{"$f":"I10+I12","v":25},null,{"$f":"E20+G20","v":25}]
[null,"Transferred out",null,null,null,null,{"$f":"-E51","v":-25}]
[null,"Purchases",null,null,{"$f":"+E33+E34","v":0},null,{"$f":"E35","v":0},null,{"$f":"E36","v":1}]
[null,"Sales",null,null,{"$f":"-E42","v":-24},null,{"$f":"-E43","v":0},null,{"$f":"-E44","v":-1}]
[null,"Death loss",null,null,{"$f":"-(E10*E14+G10*G14)","v":-1},null,{"$f":"-(I10+I12)*I14","v":-0.25},null,{"$f":"-(K10+K12)*K14","v":-0.03}]
[null,"Ending inventory",null,null,{"$f":"SUM(E50:F55)","v":100},null,{"$f":"SUM(G50:H55)","v":24.75},null,{"$f":"SUM(I50:J55)","v":2.97}]

{"sheet":"Calves","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[16,8,16,9],[16,10,16,11],[16,12,16,13],[20,8,20,9],[20,10,20,11],[20,12,20,13],[18,8,18,9],[18,10,18,11],[18,12,18,13],[19,8,19,9],[13,12,13,13],[14,8,14,9],[14,10,14,11],[14,12,14,13],[15,8,15,9],[15,10,15,11],[15,12,15,13],[17,12,17,13],[17,8,17,9],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[4,10,4,11],[5,8,5,9],[5,10,5,11],[8,8,8,9],[8,10,8,11],[9,8,9,9],[9,10,9,11],[6,8,6,9],[12,8,12,9],[12,10,12,11],[10,8,10,9],[10,10,10,11],[11,8,11,9],[11,10,11,11],[6,10,6,11],[4,8,4,9],[5,12,5,13],[7,8,7,9],[7,10,7,11],[4,4,4,5],[4,6,4,7],[5,4,5,5],[5,6,5,7],[6,12,6,13],[7,12,7,13],[14,1,14,2],[15,1,15,2],[16,1,16,3],[11,1,11,2],[12,1,12,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[17,10,17,11],[19,10,19,11],[19,12,19,13],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[22,1,23,13],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[24,2,24,3],[24,4,24,5],[17,4,17,5],[17,6,17,7],[18,4,18,5],[24,1,29,1],[29,8,29,9],[29,10,29,11],[29,12,29,13],[25,2,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[27,2,27,3],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[1,1,2,13],[3,1,3,2],[3,8,3,9],[3,10,3,11],[3,4,3,5],[14,4,14,5],[14,6,14,7],[15,4,15,5],[15,6,15,7],[12,4,12,5],[12,6,12,7],[9,4,9,5],[9,6,9,7],[10,4,10,5],[10,6,10,7],[11,4,11,5],[11,6,11,7],[6,4,6,5],[6,6,6,7],[7,4,7,5],[7,6,7,7],[8,4,8,5],[8,6,8,7],[13,1,13,2],[36,2,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[3,6,3,7],[3,12,4,13],[31,2,31,3],[34,2,34,3],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[18,6,18,7],[19,4,19,5],[19,6,19,7],[20,4,20,5],[20,6,20,7],[16,4,16,5],[16,6,16,7],[33,2,33,3],[32,2,32,3],[30,1,35,1],[33,4,33,13],[27,4,27,13],[30,4,30,13],[31,10,31,11],[34,10,34,11],[31,12,31,13],[34,12,34,13],[34,8,34,9],[34,4,34,5],[34,6,34,7],[31,6,31,7],[31,4,31,5],[31,8,31,9],[35,12,35,13],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[32,12,32,13],[30,2,30,3],[29,2,29,3],[29,4,29,5],[29,6,29,7]]}
[]
[null,"Stocker inventory"]
[]
[null,null,null,null,"Purchased",null,"Purchased",null,"Retained",null,"Retained",null,"Totals and averages"]
[null,null,null,"units","Stocker 1",null,"Stocker 2",null,"stocker steers",null,"stocker heifers"]
[null,"Number",null,"hd",0,null,0,null,{"$f":"calcs!E86+calcs!E87","v":0},null,{"$f":"calcs!E88+calcs!E89","v":-3.1086244689504371E-15},null,{"$f":"SUM(E6:L6)","v":-3.1086244689504371E-15}]
[null,"% financed",null,"%",1,null,0,null,"xxx",null,"xxx"]
[null,"Initial weight",null,"lbs",525,null,525,null,525,null,500]
[null,"Initial price",null,"$/cwt",190,null,190,null,190,null,190]
[null,"ADG",null,"lb/day",2,null,2.2000000000000002,null,2.4,null,2.2000000000000002]
[null,"Death loss",null,"%",0.02,null,0.01,null,0.01,null,0.01]
[null,"Days owned",null,"days",135,null,135,null,180,null,180]
[null,"Borrowed",null,"$/hd",{"$f":"IF(E6>0,E8*E9/100*E7,0)","v":0},null,{"$f":"IF(G6>0,G8*G9/100*G7,0)","v":0},null,"xxx",null,"xxx",null,{"$f":"IF(SUM(E6:H6)>0,\"$\"&ROUND(SUMPRODUCT(E6:H6,E13:H13)/SUM(E6:H6),0)&\" avg\",\"$0\")","v":"$0"}]
[null,"Initial principal",null,"$",{"$f":"E13*E6","v":0},null,{"$f":"G13*G6","v":0},null,"xxx",null,"xxx",null,{"$f":"SUM(E14:H14)","v":0}]
[null,"Interest rate",null,"%",6.25E-2,null,6.25E-2,null,"xxx",null,"xxx",null,{"$f":"IF(M14>0,ROUND(SUMPRODUCT(E14:G14,E15:G15)/M14 *100,2) & \"% avg\",0)","v":0}]
[null,"Loan term",null,null,{"$f":"E12 & \" days\"","v":"135 days"},null,{"$f":"G12 & \" days\"","v":"135 days"},null,"xxx",null,"xxx"]
[null,"Years remaining on note",null,null,null,null,null,null,"xxx",null,"xxx"]
[null,"Payment frequency",null,null,"Annually",null,"Annually",null,"xxx",null,"xxx"]
[null,"Total annual payments",null,null,{"$f":"E20+E21","v":0},null,{"$f":"G20+G21","v":0},null,"xxx",null,"xxx",null,{"$f":"SUM(E19:H19)","v":0}]
[null,"Total principal current yr",null,null,{"$f":"E14","v":0},null,{"$f":"G14","v":0},null,"xxx",null,"xxx",null,{"$f":"SUM(E20:H20)","v":0}]
[null,"Total interest current year",null,null,{"$f":"E14*E15/365*E12","v":0},null,{"$f":"G14*G15/365*G12","v":0},null,"xxx",null,"xxx",null,{"$f":"SUM(E21:H21)","v":0}]
[]
[null,"Calf and stocker sales"]
[]
[null,"Calf sales","From cows",null,"Head sold",null,"Weight (lbs)",null,"Sale price ($/cwt)",null,"$/head",null,"Total"]
[null,null,"steer calves",null,{"$f":"calcs!D86","v":34},null,525,null,190,null,{"$f":"I26*G26/100","v":997.5},null,{"$f":"E26*K26","v":33915}]
[null,null,"heifer calves",null,{"$f":"calcs!D88","v":15.8},null,500,null,170,null,{"$f":"I27*G27/100","v":850},null,{"$f":"E27*K27","v":13430}]
[null,null,"From 1st calf heifers"]
[null,null,"steer calves",null,{"$f":"calcs!D87","v":8},null,475,null,195,null,{"$f":"I29*G29/100","v":926.25},null,{"$f":"E29*K29","v":7410}]
[null,null,"heifer calves",null,{"$f":"calcs!D89","v":2.4},null,450,null,175,null,{"$f":"I30*G30/100","v":787.5},null,{"$f":"E30*K30","v":1890}]
[null,"Stocker sales","Retained calves"]
[null,null,{"$f":"I5","v":"stocker steers"},null,{"$f":"I6*(1-I11)","v":0},null,{"$f":"I8+I10*I12","v":957},null,150,null,{"$f":"I32*G32/100","v":1435.5},null,{"$f":"E32*K32","v":0}]
[null,null,{"$f":"K5","v":"stocker heifers"},null,{"$f":"K6*(1-K11)","v":-3.0775382242609326E-15},null,{"$f":"K8+K10*K12","v":896},null,155,null,{"$f":"I33*G33/100","v":1388.8},null,{"$f":"E33*K33","v":-4.2740850858535834E-12}]
[null,null,"Purchased calves"]
[null,null,{"$f":"E5","v":"Stocker 1"},null,{"$f":"E6*(1-E11)","v":0},null,{"$f":"E8+E10*E12","v":795},null,0,null,{"$f":"I35*G35/100","v":0},null,{"$f":"E35*K35","v":0}]
[null,null,{"$f":"G5","v":"Stocker 2"},null,{"$f":"G6*(1-G11)","v":0},null,{"$f":"G8+G10*G12","v":822},null,0,null,{"$f":"I36*G36/100","v":0},null,{"$f":"E36*K36","v":0}]
[null,null,"Totals",null,{"$f":"SUM(E26:F36)","v":60.199999999999996},null,{"$f":"SUMPRODUCT(G26:H36,E26:F36)","v":30629.999999999996},null,{"$f":"\"$\" & ROUND(M37/G37,2)*100 & \" avg\"","v":"$185 avg"},null,{"$f":"\"$\" &ROUND(M37/E37,0) & \" avg\"","v":"$941 avg"},null,{"$f":"SUM(M26:N36)","v":56644.999999999993}]

{"sheet":"Pastures","index":2,"n_rows":66,"n_cols":19,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,1,65,3],[65,4,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,11],[65,12,65,13],[65,14,65,15],[64,1,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[64,12,64,13],[64,14,64,15],[63,1,63,3],[63,4,63,5],[63,6,63,7],[63,8,63,9],[63,10,63,11],[63,12,63,13],[63,14,63,15],[58,1,59,15],[60,1,61,3],[62,1,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[62,12,62,13],[62,14,62,15],[60,4,60,5],[61,4,61,5],[60,6,60,7],[60,8,60,9],[60,10,60,11],[60,12,60,13],[60,14,60,15],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,15],[55,6,55,7],[55,10,55,11],[55,12,55,13],[55,16,55,17],[55,8,55,9],[56,8,56,9],[52,1,52,2],[52,4,52,5],[52,6,52,7],[52,10,52,11],[52,12,52,13],[52,16,52,17],[52,14,52,15],[56,16,56,17],[54,1,54,2],[54,4,54,5],[54,6,54,7],[54,10,54,11],[54,12,54,13],[54,16,54,17],[53,1,53,2],[53,4,53,5],[53,6,53,7],[53,10,53,11],[53,12,53,13],[53,14,53,15],[54,14,54,15],[55,14,55,15],[56,14,56,15],[53,16,53,17],[56,1,56,2],[56,4,56,5],[56,6,56,7],[56,10,56,11],[56,12,56,13],[55,1,55,2],[55,4,55,5],[45,18,45,19],[34,1,34,3],[34,6,34,7],[34,8,34,9],[34,10,34,11],[34,12,34,13],[43,18,43,19],[44,18,44,19],[41,4,41,5],[34,4,34,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[45,12,45,13],[39,3,40,3],[41,6,41,7],[41,8,41,9],[39,1,40,2],[43,4,43,5],[42,6,42,7],[42,4,42,5],[39,18,40,19],[27,8,27,9],[28,8,28,9],[27,10,27,11],[28,10,28,11],[27,12,27,13],[28,12,28,13],[29,1,29,3],[30,1,30,3],[31,1,31,3],[30,12,30,13],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[30,10,30,11],[27,1,28,2],[29,4,29,5],[41,18,41,19],[42,18,42,19],[51,1,51,2],[51,4,51,5],[29,6,29,7],[29,8,29,9],[27,4,27,5],[28,4,28,5],[27,6,27,7],[28,6,28,7],[49,14,49,15],[51,14,51,15],[45,1,45,2],[51,6,51,7],[51,10,51,11],[45,4,45,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[51,12,51,13],[47,1,48,17],[27,14,27,15],[28,14,28,15],[27,16,27,17],[28,16,28,17],[50,4,50,5],[50,6,50,7],[50,8,50,9],[49,1,50,2],[29,10,29,11],[29,12,29,13],[32,1,32,3],[33,1,33,3],[32,12,32,13],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[49,4,49,5],[49,6,49,7],[49,12,49,13],[49,8,49,9],[41,10,41,11],[37,1,38,19],[23,14,23,15],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[42,8,42,9],[42,10,42,11],[42,12,42,13],[44,4,44,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[23,1,23,2],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[41,12,41,13],[31,12,31,13],[30,4,30,5],[30,6,30,7],[30,8,30,9],[39,4,40,5],[21,14,21,15],[22,1,22,2],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,14,22,15],[21,1,21,2],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[20,1,20,2],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,14,20,15],[13,14,13,15],[14,14,14,15],[15,14,15,15],[16,14,16,15],[15,1,15,2],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[14,1,14,2],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[13,4,13,5],[13,6,13,7],[13,8,13,9],[14,12,14,13],[3,1,3,2],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[5,1,5,2],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[4,1,4,2],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[8,14,8,15],[9,14,9,15],[10,14,10,15],[11,14,11,15],[12,14,12,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15],[7,14,7,15],[7,1,7,2],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[6,1,6,2],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[9,1,9,2],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[8,1,8,2],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[15,12,15,13],[16,12,16,13],[12,1,12,2],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[10,1,10,2],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,1,11,3],[1,1,2,15],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[18,1,19,15],[13,10,13,11],[13,1,13,3],[16,1,16,2],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[3,12,3,13],[4,12,4,13],[5,12,5,13],[6,12,6,13],[7,12,7,13],[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13],[49,3,50,3],[50,10,50,11],[50,12,50,13],[50,14,50,15],[49,16,50,17],[25,1,26,17],[39,14,40,15],[39,16,40,17],[41,14,41,15],[41,16,41,17],[29,14,29,15],[29,16,29,17],[30,14,30,15],[30,16,30,17],[31,14,31,15],[31,16,31,17],[32,14,32,15],[32,16,32,17],[39,6,40,7],[39,8,40,9],[39,10,40,11],[49,10,49,11],[33,14,33,15],[33,16,33,17],[34,14,34,15],[34,16,34,17],[39,12,40,13],[52,8,52,9],[53,8,53,9],[54,8,54,9],[42,14,42,15],[42,16,42,17],[43,14,43,15],[43,16,43,17],[44,14,44,15],[44,16,44,17],[45,14,45,15],[45,16,45,17],[51,16,51,17],[51,8,51,9]]}
[]
[null,"Owned pasture information"]
[]
[null,"Types",null,"units","Native",null,"Bermuda",null,"Wheat",null,"Native- purch",null,"Fescue",null,"TOTALS"]
[null,"Acres",null,null,1000,null,200,null,0,null,0,null,0,null,{"$f":"SUM(E5:M5)","v":1200}]
[null,"% financed",null,"%",0,null,0.7,null,0.5,null,0.5,null,0.5,null,{"$f":"ROUND(SUMPRODUCT(E6:N6,E5:N5)/SUM(E5:N5)*100,0) & \"% avg\"","v":"12% avg"}]
[null,"Purchase price",null,"$/acre",1100,null,1500,null,2000,null,1100,null,1700,null,{"$f":"\"$\" & ROUND(SUMPRODUCT(E7:N7,E5:N5)/SUM(E5:N5),0) & \" avg\"","v":"$1167 avg"}]
[null,"Financed per acre",null,"$/acre",{"$f":"E7*E6","v":0},null,{"$f":"G7*G6","v":1050},null,{"$f":"I7*I6","v":1000},null,{"$f":"K7*K6","v":550},null,{"$f":"M7*M6","v":850},null,{"$f":"SUM(E8:M8)","v":3450}]
[null,"Taxes ",null,"$/acre",2,null,2,null,2,null,2,null,2,null,{"$f":"\"$\" & ROUND(SUMPRODUCT(E9:M9,E5:M5)/O5,2) & \" avg\"","v":"$2 avg"}]
[null,"Original loan principal",null,"$",{"$f":"E6*E5*E7","v":0},null,{"$f":"G6*G5*G7","v":210000},null,{"$f":"I6*I5*I7","v":0},null,{"$f":"K6*K5*K7","v":0},null,{"$f":"M6*M5*M7","v":0},null,{"$f":"SUM(E10:N10)","v":210000}]
[null,"Interest rate",null,"%",5.5E-2,null,5.7500000000000002E-2,null,0.05,null,5.5E-2,null,0.05,null,{"$f":"ROUND((E11*E8*E5+G11*G8*G5+I5*I8*I11+K5*K8*K11+M5*M8*M11)/SUMPRODUCT(E5:N5,E8:N8),2)*100 & \"% avg\"","v":"6% avg"}]
[null,"Payment frequency",null,null,"Annually",null,"Annually",null,"Annually",null,"Annually",null,"Annually"]
[null,"Loan term",null,"years",20,null,30,null,15,null,20,null,15]
[null,"Years remaining on loan",null,null,10,null,20,null,10,null,5,null,10]
[null,"Total annual payment",null,"$/year",0,null,14850.410109614977,null,0,null,0,null,0,null,{"$f":"SUM(E15:M15)","v":14850.410109614977}]
[null,"Total principal payment",null,"$/year",0,null,4854.3482171217875,null,0,null,0,null,0,null,{"$f":"SUM(E16:M16)","v":4854.3482171217875}]
[null,"Total interest payment",null,"$/year",0,null,9996.0618924931896,null,0,null,0,null,0,null,{"$f":"SUM(E17:M17)","v":9996.0618924931896}]
[]
[null,"Rented pasture information"]
[]
[null,"Types",null,"units",{"$f":"IF(E4<>\"\",E4,\"\")","v":"Native"},null,{"$f":"IF(G4<>\"\",G4,\"\")","v":"Bermuda"},null,{"$f":"IF(I4<>\"\",I4,\"\")","v":"Wheat"},null,{"$f":"IF(K4<>\"\",K4,\"\")","v":"Native- purch"},null,{"$f":"IF(M4<>\"\",M4,\"\")","v":"Fescue"},null,"TOTALS"]
[null,"Acres",null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(E22:M22)","v":0}]
[null,"Annual rent per acre",null,"$/acre",15,null,25,null,40,null,15,null,35,null,{"$f":"IF(O22>0,\"$\" & ROUND(SUMPRODUCT(E23:M23,E22:M22)/O22,2) & \" avg\",0)","v":0}]
[null,"Total rent",null,"$/year",{"$f":"E23*E22","v":0},null,{"$f":"G23*G22","v":0},null,{"$f":"I23*I22","v":0},null,{"$f":"K23*K22","v":0},null,{"$f":"M23*M22","v":0},null,{"$f":"SUM(E24:M24)","v":0}]
[]
[null,"Pasture allocation--head grazed on each pasture type (optional)"]
[]
[null,"Pasture",null,null,{"$f":"E40","v":"Mature cows"},null,{"$f":"G40","v":"1st Calf heifers"},null,{"$f":"I40","v":"Yearling heifers"},null,{"$f":"\"Purchased \" &Calves!E5","v":"Purchased Stocker 1"},null,{"$f":"\"Purchased \" &Calves!G5","v":"Purchased Stocker 2"},null,{"$f":"\"Retained \" &Calves!I5","v":"Retained stocker steers"},null,{"$f":"\"Retained \" &Calves!K5","v":"Retained stocker heifers"}]
[null,null,null,"(head)",{"$f":"\n\" (\"&\n'Cows, heifers, & bulls'!E12 + 'Cows, heifers, & bulls'!E10&\")\"","v":" (80)"},null,{"$f":"\n\" (\"&\n'Cows, heifers, & bulls'!G12 + 'Cows, heifers, & bulls'!G10&\")\"","v":" (20)"},null,{"$f":"\n\" (\"&\n'Cows, heifers, & bulls'!I12 + 'Cows, heifers, & bulls'!I10&\")\"","v":" (25)"},null,{"$f":" \" (\" &Calves!E6 &\")\"","v":" (0)"},null,{"$f":" \" (\" &Calves!G6 &\")\"","v":" (0)"},null,{"$f":" \" (\" &Calves!I6 &\")\"","v":" (0)"},null,{"$f":" \" (\" &Calves!K6 &\")\"","v":" (-3.10862446895044E-15)"}]
[null,{"$f":"E21","v":"Native"}]
[null,{"$f":"G21","v":"Bermuda"}]
[null,{"$f":"I21","v":"Wheat"}]
[null,{"$f":"K21","v":"Native- purch"}]
[null,{"$f":"M21","v":"Fescue"}]
[null,"Head remaining to allocate",null,null,{"$f":"'Cows, heifers, & bulls'!E12+'Cows, heifers, & bulls'!E10-SUM(E30:F34)","v":80},null,{"$f":"'Cows, heifers, & bulls'!G12+'Cows, heifers, & bulls'!G10-SUM(G30:H34)","v":20},null,{"$f":"'Cows, heifers, & bulls'!I12+'Cows, heifers, & bulls'!I10-SUM(I30:J34)","v":25},null,{"$f":"Calves!E6-SUM(K30:L34)","v":0},null,{"$f":"Calves!G6-SUM(M30:N34)","v":0},null,{"$f":"Calves!I6-SUM(O30:P34)","v":0},null,{"$f":"Calves!K6-SUM(Q30:R34)","v":-3.1086244689504371E-15}]
[]
[]
[null,"Pasture allocation--acres per head (optional)"]
[]
[null,"Pasture Types",null,"total acres",{"$f":"'Cows, heifers, & bulls'!E9:F9","v":"Mature cows"},null,{"$f":"'Cows, heifers, & bulls'!G9:H9","v":"1st Calf heifers"},null,{"$f":"'Cows, heifers, & bulls'!I9:J9","v":"Yearling heifers"},null,{"$f":"\"Purchased \" &Calves!E5","v":"Purchased Stocker 1"},null,{"$f":"\"Purchased \" &Calves!G5","v":"Purchased Stocker 2"},null,{"$f":"\"Retained \" &Calves!I5","v":"Retained stocker steers"},null,{"$f":"\"Retained \" &Calves!K5","v":"Retained stocker heifers"},null,"Excess/deficit acres"]
[]
[null,{"$f":"B30","v":"Native"},null,{"$f":"E22+E5","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D42-SUMPRODUCT(E42:Q42,E30:Q30)","v":1000}]
[null,{"$f":"B31","v":"Bermuda"},null,{"$f":"G22+G5","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D43-SUMPRODUCT(E43:Q43,E31:Q31)","v":200}]
[null,{"$f":"B32","v":"Wheat"},null,{"$f":"I22+I5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D44-SUMPRODUCT(E44:Q44,E32:Q32)","v":0}]
[null,{"$f":"B33","v":"Native- purch"},null,{"$f":"K22+K5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D45-SUMPRODUCT(E45:Q45,E33:Q33)","v":0}]
[null,{"$f":"B34","v":"Fescue"},null,{"$f":"M22+M5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D46-SUMPRODUCT(E46:Q46,E34:Q34)","v":0}]
[]
[null,"Pasture cash expense"]
[]
[null,"Cash expense",null,"units",{"$f":"IF(E42>0,E4,\"\")","v":""},null,{"$f":"IF(G5>0,G21,\"\")","v":"Bermuda"},null,{"$f":"IF(I4<>\"\",I4 & \" owned\",\"\")","v":"Wheat owned"},null,{"$f":"IF(I21<>\"\",I21 & \" rented\",\"\")","v":"Wheat rented"},null,{"$f":"K21","v":"Native- purch"},null,{"$f":"M21","v":"Fescue"},null,"TOTALS"]
[null,null,null,null,{"$f":"\"(\" & D42 & \" acres)\"","v":"(1000 acres)"},null,{"$f":"\"(\" & D43 & \" acres)\"","v":"(200 acres)"},null,{"$f":"\"(\" & I5 & \" acres)\"","v":"(0 acres)"},null,{"$f":"\"(\" &I22 & \" acres)\"","v":"(0 acres)"},null,{"$f":"\"(\" &D45 & \" acres)\"","v":"(0 acres)"},null,{"$f":"\"(\" &D46 & \" acres)\"","v":"(0 acres)"}]
[null,"Fertilizer and lime",null,"$/acre",0,null,60,null,13,null,13,null,0,null,60,null,{"$f":"E52*$D$42+G52*$D$43+I52*$I$5+K52*$I$22+M52*$D$45+O52*$D$46","v":12000}]
[null,"Tillage",null,"$/acre",null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"E53*$D$42+G53*$D$43+I53*$I$5+K53*$I$22+M53*$D$45+O53*$D$46","v":0}]
[null,"Seeding",null,"$/acre",null,null,0,null,8,null,8,null,null,null,null,null,0]
[null,"Spraying, burning, other",null,"$/acre",4,null,4,null,null,null,null,null,4,null,4,null,4800]
[null,"Total per acre",null,"$/acre",{"$f":"SUM(E52:F55)","v":4},null,{"$f":"SUM(G52:H55)","v":64},null,{"$f":"SUM(I52:J55)","v":21},null,{"$f":"SUM(K52:L55)","v":21},null,{"$f":"SUM(M52:N55)","v":4},null,{"$f":"SUM(O52:P55)","v":64},null,{"$f":"\"$\" & ROUND(Q57/SUM(D42:D46),2) & \" avg\"","v":"$14 avg"}]
[null,"Total for farm",null,"$",{"$f":"E56*D42","v":4000},null,{"$f":"G56*D43","v":12800},null,{"$f":"I56*I5","v":0},null,{"$f":"K56*I22","v":0},null,{"$f":"M56*D45","v":0},null,{"$f":"O56*D46","v":0},null,{"$f":"SUM(E57:P57)","v":16800}]
[]
[null,"Pasture  rent and overhead allocation"]
[]
[null,"Enterprise",null,null,{"$f":"E50","v":""},null,{"$f":"G50","v":"Bermuda"},null,{"$f":"I50","v":"Wheat owned"},null,{"$f":"K50","v":"Wheat rented"},null,{"$f":"M50","v":"Native- purch"},null,{"$f":"O50","v":"Fescue"}]
[null,null,null,null,{"$f":"E51","v":"(1000 acres)"},null,{"$f":"G51","v":"(200 acres)"},null,{"$f":"I51","v":"(0 acres)"},null,{"$f":"K51","v":"(0 acres)"},null,{"$f":"M51","v":"(0 acres)"},null,{"$f":"O51","v":"(0 acres)"}]
[null,"Cow-calf",null,null,1,null,1,null,0,null,0,null,1,null,0]
[null,"Stocker",null,null,0,null,0,null,1,null,1,null,0,null,0]
[null,"Crops and other",null,null,{"$f":"1-SUM(E63:F64)","v":0},null,{"$f":"1-SUM(G63:H64)","v":0},null,{"$f":"1-SUM(I63:J64)","v":0},null,{"$f":"1-SUM(K63:L64)","v":0},null,{"$f":"1-SUM(M63:N64)","v":0},null,{"$f":"1-SUM(O63:P64)","v":1}]
[null,"Total",null,null,{"$f":"SUM(E63:F65)","v":1},null,{"$f":"SUM(G63:H65)","v":1},null,{"$f":"SUM(I63:J65)","v":1},null,{"$f":"SUM(K63:L65)","v":1},null,{"$f":"SUM(M63:N65)","v":1},null,{"$f":"SUM(O63:P65)","v":1}]

{"sheet":"Feed, vet, & breeding costs","index":3,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,19,15,20],[29,1,29,3],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[28,5,28,6],[28,1,28,3],[29,5,29,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[26,7,26,8],[26,9,26,10],[26,11,26,12],[25,1,25,3],[26,1,26,3],[27,1,27,3],[24,5,24,6],[26,5,26,6],[29,19,29,20],[27,13,27,14],[24,7,24,8],[20,1,20,3],[14,13,14,14],[21,9,21,10],[21,11,21,12],[21,13,21,14],[22,9,22,10],[21,1,21,3],[22,1,22,3],[21,7,21,8],[22,7,22,8],[22,11,22,12],[22,13,22,14],[21,5,21,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,1,15,4],[16,1,16,4],[20,17,20,18],[21,15,21,16],[4,13,5,13],[22,5,22,6],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[4,14,5,14],[16,9,16,10],[16,11,16,12],[16,13,16,14],[16,5,16,8],[4,8,5,8],[4,9,5,9],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,18,5,18],[14,15,14,16],[14,17,14,18],[15,15,15,16],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[23,1,23,3],[14,19,14,20],[4,1,5,2],[4,3,5,3],[4,10,5,10],[4,11,5,11],[4,12,5,12],[23,15,23,16],[23,17,23,18],[15,17,15,18],[16,15,16,16],[16,17,16,18],[21,17,21,18],[22,15,22,16],[22,17,22,18],[18,1,19,20],[4,19,5,19],[4,20,5,20],[20,15,20,16],[24,1,24,3],[26,13,26,14],[27,5,27,6],[27,7,27,8],[27,9,27,10],[24,9,24,10],[24,11,24,12],[24,13,24,14],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[27,11,27,12],[29,15,29,16],[29,17,29,18],[24,15,24,16],[24,17,24,18],[25,15,25,16],[25,17,25,18],[26,15,26,16],[26,17,26,18],[27,15,27,16],[27,17,27,18],[28,15,28,16],[28,17,28,18],[15,21,15,22],[16,21,16,22],[20,19,20,20],[2,9,2,10],[2,11,2,12],[14,1,14,4],[14,5,14,6],[14,7,14,8],[15,5,15,6],[14,9,14,10],[14,11,14,12],[2,13,2,14],[4,5,5,5],[4,6,5,6],[13,1,13,2],[12,1,12,2],[11,1,11,2],[10,1,10,2],[9,1,9,2],[8,1,8,2],[7,1,7,2],[6,1,6,2],[4,7,5,7],[2,17,2,18],[28,21,28,22],[29,21,29,22],[21,19,21,20],[22,19,22,20],[23,19,23,20],[24,19,24,20],[25,19,25,20],[26,19,26,20],[27,19,27,20],[28,19,28,20],[1,1,1,20],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20],[2,1,3,4],[2,19,2,20],[2,5,2,6],[2,7,2,8],[2,15,2,16]]}
[]
[null,"Hay and feed costs per head"]
[null,null,null,null,null,"Mature cows",null,"1st calf Heifers",null,"Yearling heifers\n(replacements)",null,{"$f":"Pastures!K40","v":"Purchased Stocker 1"},null,{"$f":"Pastures!M40","v":"Purchased Stocker 2"},null,{"$f":"Pastures!O40","v":"Retained stocker steers"},null,{"$f":"Pastures!Q40","v":"Retained stocker heifers"},null,"Bulls"]
[null,null,null,null,null,{"$f":"Pastures!E29","v":" (80)"},null,{"$f":"Pastures!G29","v":" (20)"},null,{"$f":"Pastures!I29","v":" (25)"},null,{"$f":"Pastures!K29","v":" (0)"},null,{"$f":"Pastures!M29","v":" (0)"},null,{"$f":"Pastures!O29","v":" (0)"},null,{"$f":"Pastures!Q29","v":" (-3.10862446895044E-15)"},null,{"$f":"\"(\"&'Cows, heifers, & bulls'!K10+'Cows, heifers, & bulls'!K12&\")\"","v":"(3)"}]
[null,"Source",null,"units",null,"lb/day/hd","days fed","lb/day/hd","days fed","lb/day/hd","days fed","lb/day/hd","days fed","lb/day/hd","days fed","lb/day/hd","days fed","lb/day/hd","days fed","lb/day/hd","days fed"]
[null,null,null,null,"$/unit"]
[null,"cubes 38%",null,"tons",390,2,60,2,60,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"cubes 20%",null,"tons",266,4,60,4,60,6,120,null,0]
[null,"prairie hay",null,"tons",65,12,120,12,120,10,120,0,135,null,135,0,135,0,135,18,120]
[null,"bermuda hay",null,"tons",75,0,40,0,120,0,120,0,0,null,null,0,0,null,null,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,0,0]
[null,"salt/minerals",null,"lbs",5.3999999999999999E-2,0.25,365,0.25,365,0.25,365,0.02,135,0.25,135,0.25,135,0.25,135,0.25,365]
[null,"Total feed cost per head",null,null,null,107.0475,null,107.0475,null,139.6875,null,0.14580000000000001,null,1.8225,null,1.8225,null,1.8225,null,75.127499999999998]
[null,"Total herd feed cost",null,null,null,8563.7999999999993,null,2140.9499999999998,null,3492.1875,null,0,null,0,null,0,null,-5.6654680946621716E-15,null,225.38249999999999,null,"Total Feed"]
[null,"Feed cost for:",null,null,null,"Cows and heifers",null,null,null,{"$f":"SUM(F16:K16)","v":14196.9375},null,"Purchased stockers",null,{"$f":"L16+N16","v":0},null,"Retained stockers",null,{"$f":"SUM(P16:S16)","v":-5.6654680946621716E-15},null,"Bulls",{"$f":"T16","v":225.38249999999999},{"$f":"SUM(F16:T16)","v":14422.32}]
[]
[null,"Veterinary and miscellaneous expense"]
[]
[null,"Cost",null,null,"units","Mature cows",null,"1st Calf heifers",null,"Yearling heifers",null,{"$f":"L3","v":"Purchased Stocker 1"},null,{"$f":"N3","v":"Purchased Stocker 2"},null,{"$f":"P3","v":"Retained stocker steers"},null,{"$f":"R3","v":"Retained stocker heifers"},null,{"$f":"T3","v":"Bulls"}]
[null,"Deworm, fly control",null,null,"$/hd",4,null,4,null,3.5,null,null,null,0,null,null,null,0,null,8]
[null,"Vaccines, vet, drugs",null,null,"$/hd",4,null,4,null,4,null,null,null,null,null,null,null,null,null,3]
[null,"Transport",null,null,"$/hd",8,null,5,null,5,null,null,null,null,null,null,null,null,null,8]
[null,"Marketing",null,null,"$/hd",6,null,6,null,6,null,null,null,null,null,null,null,null,null,6]
[null,"Property tax",null,null,"$/hd"]
[null,"Fuel, lube, repairs",null,null,"$/hd"]
[null,"Other",null,null,"$/hd"," ",null," ",null,null,null,0]
[null,"Total per head",null,null,"$hd",{"$f":"SUM(F22:G28)","v":22},null,{"$f":"SUM(H22:I28)","v":19},null,{"$f":"SUM(J22:K28)","v":18.5},null,{"$f":"SUM(L22:M28)","v":0},null,{"$f":"SUM(N22:O28)","v":0},null,{"$f":"SUM(P22:Q28)","v":0},null,{"$f":"SUM(R22:S28)","v":0},null,{"$f":"SUM(T22:U28)","v":25},null,"Total Vet & Misc"]
[null,"Total herd cost",null,null,"$hd",{"$f":"SUM(F22:G28)*('Cows, heifers, & bulls'!E12+'Cows, heifers, & bulls'!E10)","v":1760},null,{"$f":"SUM(H22:I28)*('Cows, heifers, & bulls'!G12+'Cows, heifers, & bulls'!G10)","v":380},null,{"$f":"SUM(J22:K28)*('Cows, heifers, & bulls'!I12+'Cows, heifers, & bulls'!I10)","v":462.5},null,{"$f":"SUM(L22:M28)*Calves!E6","v":0},null,{"$f":"SUM(N22:O28)*Calves!G6","v":0},null,{"$f":"SUM(P22:Q28)*Calves!I6","v":0},null,{"$f":"SUM(R22:S28)*Calves!K6","v":0},null,{"$f":"T29*('Cows, heifers, & bulls'!K10+'Cows, heifers, & bulls'!K12)","v":75},null,{"$f":"SUM(F30:U30)","v":2677.5}]

{"sheet":"Other revenue","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[3,1,3,4],[4,1,4,4],[1,1,2,8],[11,1,11,4],[12,1,12,4]]}
[]
[null,"Other sources of revenue"]
[]
[null,"Description",null,null,null,"Units","Number","Price","Revenue"]
[null,"Hunting lease",null,null,null,"acres",500,6,{"$f":"G5*H5","v":3000}]
[null,"Semen sales",null,null,null,"straws",0,20,{"$f":"G6*H6","v":0}]
[null,"Breeding certificates",null,null,null,"certs",0,25,0]
[null,"Custom baling",null,null,null,"bales",0,20,0]
[null,"other--type over",null,null,null,null,null,null,0]
[null,"other--type over",null,null,null,null,null,null,0]
[null,"other--type over",null,null,null,null,null,null,0]
[null,"other--type over",null,null,null,null,null,null,{"$f":"G12*H12","v":0}]
[null,"other--type over",null,null,null,null,null,null,0]
[null,"Total other revenue",null,null,null,null,null,null,{"$f":"SUM(I5:I13)","v":3000}]

{"sheet":"Overhead & interest","index":5,"n_rows":63,"n_cols":19,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,4,62,5],[62,8,62,9],[62,16,62,17],[62,14,62,15],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[62,6,62,7],[62,10,62,11],[62,12,62,13],[58,12,58,13],[59,12,59,13],[60,12,60,13],[61,12,61,13],[58,10,58,11],[58,4,58,5],[59,4,59,5],[60,4,60,5],[61,4,61,5],[61,10,61,11],[58,8,58,9],[59,8,59,9],[60,8,60,9],[60,18,60,19],[52,16,52,17],[51,12,51,13],[55,12,55,13],[57,12,57,13],[51,10,51,11],[55,10,55,11],[57,10,57,11],[52,18,52,19],[56,14,56,15],[56,16,56,17],[56,18,56,19],[59,10,59,11],[60,10,60,11],[59,18,59,19],[53,16,53,17],[53,18,53,19],[61,18,61,19],[62,18,62,19],[47,14,47,15],[49,14,49,15],[51,14,51,15],[55,14,55,15],[57,14,57,15],[58,14,58,15],[59,14,59,15],[60,14,60,15],[61,14,61,15],[47,16,47,17],[49,16,49,17],[51,16,51,17],[55,16,55,17],[57,16,57,17],[58,16,58,17],[59,16,59,17],[60,16,60,17],[61,16,61,17],[51,18,51,19],[55,18,55,19],[57,18,57,19],[58,18,58,19],[1,1,2,9],[3,4,4,6],[3,7,4,9],[5,4,5,6],[5,7,5,9],[5,1,5,2],[3,3,4,3],[3,1,4,2],[34,1,34,3],[20,1,20,3],[21,1,21,3],[18,1,18,2],[19,1,19,2],[18,7,18,9],[19,7,19,9],[18,4,18,6],[19,4,19,6],[20,4,20,6],[14,1,15,2],[14,3,15,3],[14,4,15,6],[31,1,31,3],[32,8,32,10],[9,1,9,3],[39,1,39,3],[37,1,38,10],[26,1,26,2],[46,8,46,9],[47,8,47,9],[49,8,49,9],[44,1,45,19],[49,4,49,5],[46,6,46,7],[47,6,47,7],[48,6,48,7],[46,4,46,5],[47,4,47,5],[49,6,49,7],[48,12,48,13],[49,12,49,13],[48,4,48,5],[48,8,48,9],[48,10,48,11],[46,16,46,17],[46,18,46,19],[47,18,47,19],[49,18,49,19],[40,1,40,3],[11,1,11,2],[11,4,11,6],[28,1,29,12],[30,1,30,3],[35,1,35,3],[25,1,25,3],[16,1,17,2],[24,1,24,2],[22,1,22,2],[23,1,23,2],[22,4,22,6],[23,4,23,6],[33,1,33,3],[32,1,32,3],[32,5,32,7],[30,5,30,7],[31,5,31,7],[16,3,17,3],[16,4,17,6],[16,7,17,9],[31,8,31,10],[34,8,34,10],[35,8,35,10],[33,8,33,10],[42,1,42,3],[42,5,42,7],[42,8,42,10],[34,11,34,12],[35,11,35,12],[40,5,40,7],[41,5,41,7],[41,1,41,3],[6,1,6,2],[10,4,10,6],[10,7,10,9],[6,4,6,6],[6,7,6,9],[7,4,7,6],[7,7,7,9],[8,4,8,6],[8,7,8,9],[7,1,7,2],[8,1,8,2],[10,1,10,2],[13,1,13,2],[12,1,12,2],[12,4,12,6],[12,7,12,9],[61,8,61,9],[9,4,9,9],[21,4,21,6],[20,7,20,9],[21,7,21,9],[13,4,13,6],[13,7,13,9],[14,7,15,9],[26,4,26,6],[26,7,26,9],[24,4,24,6],[22,7,22,9],[23,7,23,9],[24,7,24,9],[11,7,11,9],[40,8,40,10],[41,8,41,10],[46,10,46,11],[34,5,34,7],[35,5,35,7],[39,5,39,7],[32,11,32,12],[30,11,30,12],[31,11,31,12],[46,14,46,15],[51,8,51,9],[55,8,55,9],[47,10,47,11],[49,10,49,11],[30,8,30,10],[39,8,39,10],[46,12,46,13],[47,12,47,13],[33,5,33,7],[33,11,33,12],[48,14,48,15],[48,16,48,17],[50,16,50,17],[48,18,48,19],[57,4,57,5],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,13],[50,14,50,15],[56,4,56,5],[56,8,56,9],[56,10,56,11],[56,12,56,13],[57,8,57,9],[57,6,57,7],[51,6,51,7],[55,6,55,7],[56,6,56,7],[55,4,55,5],[53,4,53,5],[54,4,54,5],[50,18,50,19],[52,4,52,5],[52,6,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,13],[52,14,52,15],[51,4,51,5],[53,10,53,11],[53,12,53,13],[53,14,53,15],[53,6,53,7],[53,8,53,9],[54,6,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,13],[54,14,54,15],[54,16,54,17],[54,18,54,19]]}
[]
[null,"Machinery, equipment and facilities"]
[]
[null,null,null,"Units","Machinery and equipment",null,null,"Working facilities, fences, buildings"]
[]
[null,"Purchase price",null,"$",57500,null,null,49000]
[null,"% financed",null,"%",0.5,null,null,0.25]
[null,"Useful life",null,"years",10,null,null,25]
[null,"Salvage value",null,"$",5000,null,null,2500]
[null,"Annual costs"]
[null,"Repairs & maintenance",null,"$/yr",850,null,null,550]
[null,"Taxes",null,"$/yr",200,null,null,0]
[null,"Insurance",null,"$/yr",150,null,null,0]
[null,"Fuel, lube, utilities",null,"$/yr",2000,null,null,0]
[null,"Depreciation",null,"$/yr",{"$f":"IF(E8>0,(E6-E9)/E8,0)","v":5250},null,null,{"$f":"IF(H8>0,(H6-H9)/H8,0)","v":1860}]
[]
[null,"Original loan principal",null,"$",{"$f":"E6*E7","v":28750},null,null,{"$f":"H6*H7","v":12250}]
[]
[null,"Interest rate",null,"%",0.06,null,null,0.06]
[null,"Loan term",null,"years",5,null,null,5]
[null,"Years remaining on loan",null,null,3,null,null,3]
[null,"Payment frequency",null,null,"Quarterly",null,null,"Annually"]
[null,"Total Payments",null,"$",6698.2596255636599,null,null,2908.105905282071]
[null,"Total Principal",null,"$",5729.6580051447891,null,null,2441.7017951749353]
[null,"Total Interest",null,"$",968.60162041887111,null,null,466.40411010713564]
[null,"Opportunity cost on investment:"]
[null,"Interest on average investment",null,0.03,{"$f":"(E6+E9)/2*$D$27","v":937.5},null,null,{"$f":"(H6+H9)/2*$D$27","v":772.5}]
[]
[null,"Labor and overhead allocation"]
[]
[null,null,null,null,"Units","Cow herd",null,null,"Stockers",null,null,"total"]
[null,"Hired labor",null,null,"$/yr",0,null,null,0,null,null,{"$f":"I32+F32","v":0}]
[null,"Value of family and own labor",null,null,"$/yr",15000,null,null,0,null,null,{"$f":"I33+F33","v":15000}]
[null,"Miscellaneous expense",null,null,"$/yr",0,null,null,0,null,null,{"$f":"I34+F34","v":0}]
[null,"Machinery & equipment",null,null,"%",1,null,null,0,null,null,{"$f":"I35+F35","v":1}]
[null,"Facilities, fences, buildings",null,null,"%",1,null,null,0,null,null,{"$f":"I36+F36","v":1}]
[]
[null,"Operating note information"]
[]
[null,null,null,null,"units","Cow herd",null,null,"Stockers"]
[null,"Percent financed",null,null,"%",0.75,null,null,1]
[null,"Months borrowed",null,null,"months",9,null,null,4]
[null,"Interest rate",null,null,"%",6.25E-2,null,null,6.25E-2]
[]
[null,"Other overhead costs"]
[]
[null,"Noncurrent asset","Origination","# of units","Salvage value\n($/head)",null,"Investment\n($/unit)",null,"Expected useful life\n(years)",null,"Depreciation\n($)",null,"Insurance\n($)",null,"Taxes\n($)",null,"Interest on average investment",null,"Opportunity cost on investment"]
[null,"Mature cows","Raised",{"$f":"'Cows, heifers, & bulls'!E10 & \" head\"","v":"80 head"},940,null,{"$f":"'Cows, heifers, & bulls'!E11","v":1125},null,"XXX",null,"XXX",null,700,null,900,null,0.03,null,2478]
[null,"Mature cows","Purchased",{"$f":"'Cows, heifers, & bulls'!E12 & \" head\"","v":"0 head"},940,null,1500,null,8,null,0,null,0,null,0,null,0.03,null,0]
[null,"1st calf heifers","Raised",{"$f":"'Cows, heifers, & bulls'!G10 & \" head\"","v":"20 head"},940,null,{"$f":"'Cows, heifers, & bulls'!G$11","v":1000},null,"XXX",null,"xxx",null,200,null,225,null,0.03,null,582]
[null,"1st calf heifers","Purchased",{"$f":"'Cows, heifers, & bulls'!G12  & \" head\"","v":"0 head"},940,null,1500,null,"XXX",null,"xxx",null,0,null,0,null,0.03,null,0]
[null,"Yearling heifers","Raised",{"$f":"'Cows, heifers, & bulls'!I10& \" head\"","v":"25 head"},875,null,{"$f":"'Cows, heifers, & bulls'!$I$11","v":850},null,"XXX",null,"xxx",null,190,null,200,null,0.03,null,646.875]
[null,"Yearling heifers","Purchased",{"$f":"'Cows, heifers, & bulls'!I12& \" head\"","v":"0 head"},875,null,800,null,"XXX",null,"xxx",null,0,null,0,null,0.03,null,0]
[null,"Retained heifers","Mature cows",{"$f":"ROUND('Cows, heifers, & bulls'!E20,0) & \" head\"","v":"19 head"},"xxx",null,800,null,"XXX",null,"xxx",null,0,null,0,null,0.03,null,{"$f":"G54*(13-V54)*Q54/12*'Cows, heifers, & bulls'!E20","v":494}]
[null,"Retained heifers","1st calf heifers",{"$f":"ROUND('Cows, heifers, & bulls'!G20,0) & \" head\"","v":"6 head"},"xxx",null,1750,null,"XXX",null,"xxx",null,0,null,0,null,0.03,null,{"$f":"G55*(13-V55)*Q55/12*'Cows, heifers, & bulls'!G20","v":341.25}]
[null,"Raised bulls","Raised",{"$f":"'Cows, heifers, & bulls'!K10 & \" head\"","v":"0 head"},1825,null,1750,null,"XXX",null,"xxx",null,0,null,0,null,0.03,null,0]
[null,"Purchased bulls","Purchased",{"$f":"'Cows, heifers, & bulls'!K12 & \" head\"","v":"3 head"},1825,null,3000,null,4,null,881.25,null,60,null,85,null,0.03,null,270]
[null,{"$f":"Pastures!E4 & \" pasture\"","v":"Native pasture"},null,{"$f":"Pastures!E5 & \" acres\"","v":"1000 acres"},"XXX",null,{"$f":"Pastures!E7","v":1100},null,"XXX",null,"xxx",null,"XXX",null,{"$f":"Pastures!E9*Pastures!E5","v":2000},null,0.03,null,33000]
[null,{"$f":"Pastures!G4 & \" pasture\"","v":"Bermuda pasture"},null,{"$f":"Pastures!G5 & \" acres\"","v":"200 acres"},"XXX",null,{"$f":"Pastures!G7","v":1500},null,"XXX",null,"XXX",null,"XXX",null,{"$f":"Pastures!G9*Pastures!G5","v":400},null,0.03,null,9000]
[null,{"$f":"Pastures!I4 & \" pasture\"","v":"Wheat pasture"},null,{"$f":"Pastures!I5 & \" acres\"","v":"0 acres"},"XXX",null,{"$f":"Pastures!I7","v":2000},null,"XXX",null,"XXX",null,"XXX",null,{"$f":"Pastures!I9*Pastures!I5","v":0},null,0.03,null,0]
[null,{"$f":"Pastures!K4 & \" pasture\"","v":"Native- purch pasture"},null,{"$f":"Pastures!K5 & \" acres\"","v":"0 acres"},"XXX",null,{"$f":"Pastures!K7","v":1100},null,"XXX",null,"XXX",null,"XXX",null,{"$f":"Pastures!K9*Pastures!K5","v":0},null,0.03,null,0]
[null,{"$f":"Pastures!M4 & \" pasture\"","v":"Fescue pasture"},null,{"$f":"Pastures!M5 & \" acres\"","v":"0 acres"},"XXX",null,{"$f":"Pastures!M7","v":1700},null,"XXX",null,"XXX",null,"XXX",null,{"$f":"Pastures!M9*Pastures!M5","v":0},null,0.03,null,0]
[null,"TOTAL",null,null,null,null,null,null,null,null,{"$f":"K49+K57","v":881.25},null,{"$f":"SUM(M49:N58)","v":450},null,{"$f":"SUM(O48:P62)","v":3810},null,null,null,0]

{"sheet":"Results","index":6,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[43,10,43,11],[43,12,43,13],[47,6,47,9],[47,10,47,11],[47,12,47,13],[28,14,28,15],[28,16,28,17],[29,10,29,13],[29,14,29,15],[29,16,29,17],[31,10,31,13],[31,14,31,15],[31,16,31,17],[41,6,41,9],[31,5,31,6],[31,7,31,8],[32,5,32,6],[32,7,32,8],[33,5,33,6],[33,7,33,8],[3,1,3,4],[17,1,17,4],[1,1,2,8],[3,7,3,8],[5,7,5,8],[6,7,6,8],[5,5,5,6],[6,5,6,6],[8,5,8,6],[13,1,13,4],[13,5,13,6],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[4,1,4,4],[5,1,5,4],[6,1,6,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[8,7,8,8],[10,7,10,8],[23,1,23,4],[23,5,23,6],[23,7,23,8],[12,1,12,4],[9,5,9,8],[14,1,14,4],[20,1,20,4],[20,5,20,6],[20,7,20,8],[15,1,15,4],[16,1,16,4],[11,5,11,6],[12,5,12,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[21,1,21,4],[21,5,21,6],[21,7,21,8],[17,5,17,8],[27,1,27,4],[27,5,27,6],[27,7,27,8],[34,1,34,4],[34,5,34,6],[34,7,34,8],[25,1,25,4],[25,5,25,6],[25,7,25,8],[26,1,26,4],[26,5,26,6],[26,7,26,8],[28,1,28,4],[29,1,29,4],[29,5,29,6],[29,7,29,8],[30,1,30,4],[30,5,30,6],[31,1,31,4],[32,1,32,4],[33,1,33,4],[24,1,24,4],[24,5,24,6],[24,7,24,8],[22,1,22,4],[3,5,3,6],[30,7,30,8],[27,10,27,13],[10,5,10,6],[1,10,2,17],[3,10,3,13],[3,14,3,15],[3,16,3,17],[4,10,4,13],[11,7,11,8],[12,7,12,8],[5,10,5,13],[5,14,5,15],[5,16,5,17],[6,10,6,13],[6,14,6,15],[6,16,6,17],[7,10,7,13],[7,14,7,15],[7,16,7,17],[14,14,14,15],[18,5,18,6],[44,10,44,11],[44,12,44,13],[9,10,9,13],[9,14,9,15],[9,16,9,17],[42,10,42,11],[42,12,42,13],[30,10,30,13],[30,14,30,15],[30,16,30,17],[23,10,23,13],[23,14,23,15],[26,10,26,13],[26,14,26,15],[41,10,41,11],[41,12,41,13],[25,14,25,15],[25,16,25,17],[12,14,12,15],[12,16,12,17],[13,14,13,15],[28,10,28,13],[48,10,48,11],[48,12,48,13],[46,10,46,11],[46,12,46,13],[40,10,40,11],[40,12,40,13],[45,10,45,11],[45,12,45,13],[4,5,4,8],[28,5,28,8],[40,6,40,9],[38,6,39,13],[25,10,25,13],[12,10,12,13],[13,10,13,13],[22,5,22,6],[22,7,22,8],[14,10,14,13],[42,6,42,9],[44,6,44,9],[45,6,45,9],[46,6,46,9],[48,6,48,9],[43,6,43,9],[8,14,8,17],[4,14,4,17],[27,14,27,17],[17,14,17,17],[24,16,24,17],[20,10,20,13],[20,14,20,15],[20,16,20,17],[21,10,21,13],[21,14,21,15],[21,16,21,17],[18,10,18,13],[18,14,18,15],[18,16,18,17],[19,10,19,13],[19,14,19,15],[14,16,14,17],[15,10,15,13],[15,14,15,15],[15,16,15,17],[8,10,8,13],[16,10,16,13],[11,14,11,15],[11,16,11,17],[13,16,13,17],[23,16,23,17],[26,16,26,17],[24,10,24,13],[24,14,24,15],[16,14,16,15],[16,16,16,17],[17,10,17,13],[7,1,7,4],[7,5,7,6],[7,7,7,8],[19,16,19,17],[22,10,22,13],[22,14,22,15],[22,16,22,17],[10,10,10,13],[10,14,10,15],[10,16,10,17],[11,10,11,13],[18,1,18,4],[18,7,18,8],[19,1,19,4],[19,5,19,6],[19,7,19,8]]}
[]
[null,"Cow herd cash flow and profitability analysis",null,null,null,null,null,null,null,null,"Stocker cash flow and profitability analysis"]
[]
[null,null,null,null,null,"Cash flow",null,"Profitability",null,null,null,null,null,null,"Cash flow",null,"Profitability"]
[null,"Revenue",null,null,null,null,null,null,null,null,"Revenue"]
[null,"Calf production",null,null,null,{"$f":"Calves!M26+Calves!M27+Calves!M29+Calves!M30","v":56645},null,{"$f":"F6+Calves!I6*Calves!I8*Calves!I9/100+Calves!K6*Calves!K8*Calves!K9/100+'Cows, heifers, & bulls'!E20*'Overhead & interest'!G54+'Overhead & interest'!G55*'Cows, heifers, & bulls'!G20","v":82345},null,null,"Purchased stockers",null,null,null,{"$f":"Calves!M35+Calves!M36","v":0},null,{"$f":"O6","v":0}]
[null,"Cull sales",null,null,null,{"$f":"'Cows, heifers, & bulls'!N45","v":24452},null,{"$f":"F7-SUM(calcs!K35:K37)","v":21302},null,null,"Retained stockers",null,null,null,{"$f":"Calves!M32+Calves!M33","v":-4.2740850858535834E-12},null,{"$f":"O7","v":-4.2740850858535834E-12}]
[null,"Increase in replacement heifer value",null,null,null,"xxx",null,{"$f":"'Cows, heifers, & bulls'!I10*('Overhead & interest'!G50-'Overhead & interest'!G52)+'Cows, heifers, & bulls'!I12*('Overhead & interest'!G51-'Overhead & interest'!G53)","v":3750},null,null,"Total stocker revenue",null,null,null,{"$f":"O6+O7","v":-4.2740850858535834E-12},null,{"$f":"Q7+Q6","v":-4.2740850858535834E-12}]
[null,"Total cow herd revenue",null,null,null,{"$f":"F6+F7","v":81097},null,{"$f":"SUM(H6:I8)","v":107397},null,null,"Expenses"]
[null,"Expenses",null,null,null,null,null,null,null,null,"Purchased and retained calves",null,null,null,{"$f":"Calves!E6*Calves!E8*Calves!E9/100+Calves!G6*Calves!G8*Calves!G9/100","v":0},null,{"$f":"Calves!E6*Calves!E8*Calves!E9/100+Calves!G6*Calves!G8*Calves!G9/100+Calves!I6*Calves!I8*Calves!I9/100+Calves!K6*Calves!K8*Calves!K9/100","v":-2.9531932455029152E-12}]
[null,"Pasture rent",null,null,null,{"$f":"SUMPRODUCT(calcs!E5:H5,Pastures!E24:H24)+SUMPRODUCT(Pastures!I24:N24,calcs!K7:P7)","v":0},null,{"$f":"F11","v":0},null,null,"Pasture rent",null,null,null,{"$f":"SUMPRODUCT(Pastures!E24:H24,calcs!E6:H6)+SUMPRODUCT(calcs!K6:P6,Pastures!I24:N24)","v":0},null,{"$f":"O11","v":0}]
[null,"Pasture operating",null,null,null,{"$f":"SUMPRODUCT(Pastures!E57:P57,Pastures!E63:P63)","v":16800},null,16800,null,null,"Pasture operating",null,null,null,{"$f":"SUMPRODUCT(Pastures!E57:P57,Pastures!E64:P64)","v":0},null,0]
[null,"Hay and feed",null,null,null,{"$f":"'Feed, vet, & breeding costs'!F16+'Feed, vet, & breeding costs'!H16+'Feed, vet, & breeding costs'!J16+'Feed, vet, & breeding costs'!T16","v":14422.32},null,14422.32,null,null,"Hay and feed",null,null,null,{"$f":"SUM('Feed, vet, & breeding costs'!L16:S16)","v":-5.6654680946621716E-15},null,-5.6654680946621716E-15]
[null,"Veterinary etc.",null,null,null,{"$f":"'Feed, vet, & breeding costs'!F30+'Feed, vet, & breeding costs'!H30+'Feed, vet, & breeding costs'!J30+'Feed, vet, & breeding costs'!T30","v":2677.5},null,2677.5,null,null,"Veterinary etc.",null,null,null,{"$f":"SUM('Feed, vet, & breeding costs'!L30:S30)","v":0},null,0]
[null,"Cash mach, equip, & facilities",null,null,null,{"$f":"SUM('Overhead & interest'!E11:G14)*'Overhead & interest'!F35+SUM('Overhead & interest'!H11:J14)*'Overhead & interest'!F36","v":3750},null,3750,null,null,"Cash mach, equip, & facilities exp",null,null,null,{"$f":"SUM('Overhead & interest'!E11:J14)*'Overhead & interest'!I35","v":0},null,0]
[null,"Hired labor",null,null,null,{"$f":"'Overhead & interest'!F32","v":0},null,{"$f":"F16","v":0},null,null,"Hired labor",null,null,null,{"$f":"'Overhead & interest'!I32","v":0},null,0]
[null,"Miscellaneous",null,null,null,{"$f":"'Overhead & interest'!F34:H34","v":0},null,{"$f":"F17","v":0},null,null,"Miscellaneous",null,null,null,{"$f":"'Overhead & interest'!I34","v":0},null,0]
[null,"Interest on:",null,null,null,null,null,null,null,null,"Interest on:"]
[null,"Operating",null,null,null,{"$f":"SUM(F11:G17)*'Overhead & interest'!F41:H41*'Overhead & interest'!F42:H42/12*'Overhead & interest'!F43:H43","v":1323.6264843749998},null,{"$f":"F19","v":1323.6264843749998},null,null,"Operating",null,null,null,{"$f":"SUM(O10:P17)*'Overhead & interest'!I41*'Overhead & interest'!I42/12*'Overhead & interest'!I43","v":-1.1803058530546192E-16},null,{"$f":"O19","v":-1.1803058530546192E-16}]
[null,"Pasture mortgage",null,null,null,{"$f":"SUMPRODUCT(Pastures!E17:J17,Pastures!E63:J63)+SUMPRODUCT(Pastures!M63:P63,Pastures!K17:N17)","v":9996.0618924931896},null,"xxx",null,null,"Pasture mortgage",null,null,null,{"$f":"SUMPRODUCT(Pastures!E17:J17,Pastures!E64:J64)+SUMPRODUCT(Pastures!M64:P64,Pastures!K17:N17)","v":0},null,"xxx"]
[null,"Breeding stock notes",null,null,null,{"$f":"'Cows, heifers, & bulls'!M28+'Cows, heifers, & bulls'!S37","v":108.02770448548814},null,"xxx",null,null,"Calf notes",null,null,null,{"$f":"SUM(Calves!E21:H21)","v":0},null,"xxx"]
[null,"Mach, equip and facilities notes",null,null,null,{"$f":"'Overhead & interest'!E25*'Overhead & interest'!F35+'Overhead & interest'!H25*'Overhead & interest'!F36","v":1435.0057305260068},null,"xxx",null,null,"Mach, equip and facilities notes",null,null,null,{"$f":"'Overhead & interest'!E25*'Overhead & interest'!I35+'Overhead & interest'!H25*'Overhead & interest'!I36","v":0},null,"xxx"]
[null,"Taxes",null,null,null,{"$f":"SUMPRODUCT(calcs!U10:V14,calcs!M18:N22)+SUM('Overhead & interest'!O48:P57)","v":1410},null,{"$f":"F23","v":1410},null,null,"Taxes",null,null,null,{"$f":"SUMPRODUCT(calcs!S10:T14,calcs!M18:N22)","v":0},null,{"$f":"O23","v":0}]
[null,"Insurance",null,null,null,{"$f":"SUM('Overhead & interest'!M48:M57)","v":1150},null,{"$f":"F24","v":1150},null,null,"Depreciation",null,null,null,"xxx",null,{"$f":"'Overhead & interest'!E15*'Overhead & interest'!I35+'Overhead & interest'!H15*'Overhead & interest'!I36","v":0}]
[null,"Depreciation and death loss",null,null,null,"xxx",null,{"$f":"'Overhead & interest'!K63+calcs!H97+'Overhead & interest'!F35*'Overhead & interest'!E15+'Overhead & interest'!F36*'Overhead & interest'!H15","v":9302.25},null,null,"Opportunity cost on investment",null,null,null,"xxx",null,{"$f":"'Overhead & interest'!I35*'Overhead & interest'!E27+'Overhead & interest'!I36*'Overhead & interest'!H27+calcs!E20","v":0}]
[null,"Opportunity cost on investment",null,null,null,"xxx",null,{"$f":"SUM('Overhead & interest'!S48:T57)+'Overhead & interest'!F35*'Overhead & interest'!E27+'Overhead & interest'!F36*'Overhead & interest'!H27+calcs!E19+SUMPRODUCT('Cows, heifers, & bulls'!I33:J36,'Cows, heifers, & bulls'!O33:P36)/12*'Overhead & interest'!Q49","v":48550.625},null,null,"Value of unpaid labor",null,null,null,"xxx",null,{"$f":"'Overhead & interest'!I33","v":0}]
[null,"Value of unpaid labor",null,null,null,"xxx",null,{"$f":"'Overhead & interest'!F33","v":15000},null,null,"Total expenses",null,null,null,{"$f":"SUM(O10:P17)+SUM(O19:P23)","v":-5.7834986799676335E-15},null,{"$f":"SUM(Q10:R18)+SUM(Q20:Q26)+Q19","v":-2.9589767441828828E-12}]
[null,"Total Expenses",null,null,null,{"$f":"SUM(F12:G18)+SUM(F20:G25)","v":51748.915327504685},null,{"$f":"SUM(H11:I18)+SUM(H20:I27)+H19","v":114386.321484375},null,null,"Other cash flows"]
[null,"Other cash flows",null,null,null,null,null,null,null,null,"Principal payments--real estate",null,null,null,{"$f":"SUMPRODUCT(Pastures!E16:J16,Pastures!E64:J64)+SUMPRODUCT(Pastures!M64:P64,Pastures!K16:N16)","v":0},null,"xxx"]
[null,"Breeding livestock purchases",null,null,null,{"$f":"'Cows, heifers, & bulls'!Q37","v":2850},null,"xxx",null,null,"Principal payments--mach, facilities, etc.",null,null,null,{"$f":"'Overhead & interest'!I35*'Overhead & interest'!E24+'Overhead & interest'!H24*'Overhead & interest'!I36","v":0},null,"xxx"]
[null,"Principal payments--breeding stock",null,null,null,{"$f":"'Cows, heifers, & bulls'!M27","v":874.01055408970842},null,"xxx",null,null,"Net cash flow from stockers",null,null,null,{"$f":"O8-O27-SUM(O29:P30)","v":-4.2683015871736159E-12},null,"xxx"]
[null,"Principal payments--real estate",null,null,null,{"$f":"SUMPRODUCT(Pastures!E16:J16,Pastures!E63:J63)+SUMPRODUCT(Pastures!M63:P63,Pastures!K16:N16)","v":4854.3482171217875},null,"xxx",null,null,"Net income",null,null,null,"xxx",null,{"$f":"Q8-Q27","v":-1.3151083416707007E-12}]
[null,"Principal payments--mach, facilities, etc.",null,null,null,{"$f":"'Overhead & interest'!F35*'Overhead & interest'!E24+'Overhead & interest'!F36*'Overhead & interest'!H24","v":8171.3598003197239},null,"xxx"]
[null,"Net cash flow from cow herd",null,null,null,{"$f":"(F9-F28-SUM(F30:G33))","v":12598.366100964093},null,"xxx"]
[null,"Net income",null,null,null,"xxx",null,{"$f":"H9-H28","v":-6989.3214843750029}]
[]
[]
[]
[null,null,null,null,null,null,"Whole farm cash flow and profitability analysis"]
[]
[null,null,null,null,null,null,null,null,null,null,"Cash flow",null,"Profitability"]
[null,null,null,null,null,null,"Net cash flow from cow herd",null,null,null,{"$f":"F34","v":12598.366100964093},null,"xxx"]
[null,null,null,null,null,null,"Net cash flow from stockers",null,null,null,{"$f":"O31","v":-4.2683015871736159E-12},null,"xxx"]
[null,null,null,null,null,null,"Total other revenue",null,null,null,{"$f":"'Other revenue'!I14","v":3000},null,"xxx"]
[null,null,null,null,null,null,"Net cash flow--whole farm",null,null,null,{"$f":"SUM(K42:L44)","v":15598.366100964089},null,"xxx"]
[null,null,null,null,null,null,"Net income from cow herd",null,null,null,"xxx",null,{"$f":"H35","v":-6989.3214843750029}]
[null,null,null,null,null,null,"Net income from stockers",null,null,null,"xxx",null,{"$f":"Q32","v":-1.3151083416707007E-12}]
[null,null,null,null,null,null,"Total other revenue",null,null,null,"xxx",null,{"$f":"K44","v":3000}]
[null,null,null,null,null,null,"Net income--whole farm",null,null,null,"xxx",null,{"$f":"M47+M46+M48","v":-3989.3214843750038}]

{"sheet":"calcs","index":7,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":true,"merged":[[16,16,16,17],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[16,12,16,13],[18,4,18,5],[14,14,14,15],[14,12,14,13],[16,14,16,15],[10,12,10,13],[10,14,10,15],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[19,4,19,5],[12,14,12,15],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[12,12,12,13],[2,14,2,15],[3,8,3,9],[3,14,3,15],[2,10,2,11],[2,12,2,13],[4,14,4,15],[5,8,5,9],[5,14,5,15],[6,8,6,9],[6,14,6,15],[4,10,4,11],[4,12,4,13],[4,8,4,9],[6,10,6,11],[6,12,6,13],[2,4,2,5],[2,6,2,7],[3,4,3,5],[3,6,3,7],[3,10,3,11],[3,12,3,13],[2,1,3,3],[1,1,1,6],[2,8,2,9],[6,4,6,5],[6,6,6,7],[5,4,5,5],[5,6,5,7],[5,10,5,11],[5,12,5,13],[4,4,4,5],[4,6,4,7],[4,1,4,3],[5,1,5,3],[6,1,6,3],[42,16,42,17],[43,10,43,11],[43,12,43,13],[43,14,43,15],[43,16,43,17],[44,10,44,11],[44,12,44,13],[44,14,44,15],[44,16,44,17],[42,10,42,11],[42,12,42,13],[42,14,42,15],[45,10,45,11],[45,12,45,13],[45,14,45,15],[45,16,45,17],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,16,46,17],[47,8,47,9],[47,10,47,11],[47,12,47,13],[47,14,47,15],[47,16,47,17],[78,5,78,6],[78,7,78,8],[78,9,78,10],[75,1,75,2],[75,3,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[76,1,76,2],[76,3,76,4],[76,5,76,6],[76,7,76,8],[76,9,76,10],[76,11,76,12],[77,1,77,2],[81,1,81,2],[81,3,81,4],[81,5,81,6],[81,7,81,8],[81,9,81,10],[78,11,78,12],[79,1,79,2],[79,3,79,4],[79,5,79,6],[79,7,79,8],[79,9,79,10],[80,1,80,2],[80,3,80,4],[80,5,80,6],[80,7,80,8],[80,9,80,10],[77,3,77,4],[77,5,77,6],[77,7,77,8],[77,9,77,10],[78,1,78,2],[78,3,78,4],[9,1,9,8],[16,10,16,11],[10,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[16,4,16,5],[16,6,16,7],[16,8,16,9],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11]]}
[]
[null,"Use these numbers for allocating ownership costs"]
[null,"Enterprise",null,null,{"$f":"Pastures!E61","v":""},null,{"$f":"Pastures!G61","v":"Bermuda"},null,{"$f":"Pastures!I61","v":"Wheat owned"},null,{"$f":"Pastures!K61","v":"Wheat rented"},null,{"$f":"Pastures!M61","v":"Native- purch"},null,{"$f":"Pastures!O61","v":"Fescue"}]
[null,null,null,null,{"$f":"Pastures!E62","v":"(1000 acres)"},null,{"$f":"Pastures!G62","v":"(200 acres)"},null,{"$f":"Pastures!I62","v":"(0 acres)"},null,{"$f":"Pastures!K62","v":"(0 acres)"},null,{"$f":"Pastures!M62","v":"(0 acres)"},null,{"$f":"Pastures!O62","v":"(0 acres)"}]
[null,"Cow-calf",null,null,{"$f":"Pastures!E63","v":1},null,{"$f":"Pastures!G63","v":1},null,{"$f":"Pastures!I63","v":0},null,{"$f":"Pastures!K63","v":0},null,{"$f":"Pastures!M63","v":1},null,{"$f":"Pastures!O63","v":0}]
[null,"Stocker",null,null,{"$f":"Pastures!E64","v":0},null,{"$f":"Pastures!G64","v":0},null,{"$f":"Pastures!I64","v":1},null,{"$f":"Pastures!K64","v":1},null,{"$f":"Pastures!M64","v":0},null,{"$f":"Pastures!O64","v":0}]
[null,"total",null,null,{"$f":"E5+E6","v":1},null,{"$f":"G5+G6","v":1},null,{"$f":"I5+I6","v":1},null,{"$f":"K5+K6","v":1},null,{"$f":"M5+M6","v":1},null,{"$f":"O5+O6","v":0}]
[]
[]
[null,"Use these number for allocating operating expenses"]
[null,"Enterprise",null,null,{"$f":"E3","v":""},null,{"$f":"G3","v":"Bermuda"},null,{"$f":"I3","v":"Wheat owned"},null,{"$f":"K3","v":"Wheat rented"},null,{"$f":"M3","v":"Native- purch"},null,{"$f":"O3","v":"Fescue"}]
[null,null,null,null,{"$f":"E4","v":"(1000 acres)"},null,"(200 acres)",null,"(0 acres)",null,"(0 acres)",null,"(0 acres)",null,"(0 acres)"]
[null,"Cow-calf",null,null,{"$f":"IF(E$7>0,E5/E$7,0)","v":1},null,{"$f":"IF(G$7>0,G5/G$7,0)","v":1},null,{"$f":"IF(I$7>0,I5/I$7,0)","v":0},null,{"$f":"IF(K$7>0,K5/K$7,0)","v":0},null,{"$f":"IF(M$7>0,M5/M$7,0)","v":1},null,{"$f":"IF(O$7>0,O5/O$7,0)","v":0}]
[null,"Stocker",null,null,{"$f":"IF(E$7>0,E6/E$7,0)","v":0},null,{"$f":"IF(G$7>0,G6/G$7,0)","v":0},null,{"$f":"IF(I$7>0,I6/I$7,0)","v":1},null,{"$f":"IF(K$7>0,K6/K$7,0)","v":1},null,{"$f":"IF(M$7>0,M6/M$7,0)","v":0},null,{"$f":"IF(O$7>0,O6/O$7,0)","v":0}]
[null,"total",null,null,1,null,1,null,1,null,1,null,1,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total"]
[null,"overhead costs",null,null,{"$f":"'Overhead & interest'!S58","v":33000},null,{"$f":"'Overhead & interest'!S59","v":9000},null,{"$f":"'Overhead & interest'!S60","v":0},null,0,null,{"$f":"'Overhead & interest'!S61","v":0},null,{"$f":"'Overhead & interest'!S62","v":0},null,{"$f":"SUM(E17:P17)","v":42000}]
[]
[null,"cow-calf pasture overhead",null,null,{"$f":"SUMPRODUCT(E5:P5,E17:P17)","v":42000}]
[null,"stocker pasture overhead",null,null,{"$f":"SUMPRODUCT(E6:P6,E17:P17)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"cost basis",3000,35]
[null,null,null,"perc fin","own int","borrow","months","opp cost",null,"cows",{"$f":"'Cows, heifers, & bulls'!H42","v":1000},1500,0]
[null,"cash cow",{"$f":"SUM(Results!F11:G17)-Results!F15","v":33899.82},{"$f":"'Overhead & interest'!F41","v":0.75},{"$f":"'Overhead & interest'!F43","v":6.25E-2},{"$f":"'Overhead & interest'!F43","v":6.25E-2},{"$f":"'Overhead & interest'!F42","v":9},{"$f":"C36*(1-D36)*E36*G36/12","v":397.26351562500003},null,"bull",{"$f":"'Cows, heifers, & bulls'!H43","v":850},1750,50]
[null,"mach cash",{"$f":"Results!F15","v":3750},{"$f":"1-'Overhead & interest'!E7","v":0.5},{"$f":"'Overhead & interest'!F43","v":6.25E-2},{"$f":"'Overhead & interest'!L43","v":0},{"$f":"'Overhead & interest'!L42","v":0},{"$f":"C37*(1-D37)*E37*G37/12","v":0},null,"heifer",{"$f":"'Cows, heifers, & bulls'!H44","v":1300},1500,40]
[null,"cows",{"$f":"'Cows, heifers, & bulls'!E12*(L35+K35)/2","v":0},{"$f":"1-'Cows, heifers, & bulls'!E13","v":1},{"$f":"E36","v":6.25E-2},null,null,{"$f":"C38*(1-D38)*E38","v":0},null,null,null,800,45]
[null,"1st heifers",{"$f":"'Cows, heifers, & bulls'!G12*(calcs!L37+calcs!K37)/2","v":0},{"$f":"1-'Cows, heifers, & bulls'!G13","v":1},{"$f":"E38","v":6.25E-2},null,null,{"$f":"C39*(1-D39)*E39","v":0}]
[null,"yearlings",{"$f":"'Cows, heifers, & bulls'!I12","v":0},{"$f":"1-'Cows, heifers, & bulls'!I13","v":1},{"$f":"E39","v":6.25E-2},null,null,{"$f":"C40*(1-D40)*E40","v":0}]
[null,"bulls",{"$f":"'Feed, vet, & breeding costs'!F35*('Feed, vet, & breeding costs'!F36+'Feed, vet, & breeding costs'!F39)/2*'Feed, vet, & breeding costs'!F37+('Feed, vet, & breeding costs'!H36+'Feed, vet, & breeding costs'!H39)/2*'Feed, vet, & breeding costs'!H35*'Feed, vet, & breeding costs'!H37+'Feed, vet, & breeding costs'!J37*'Feed, vet, & breeding costs'!J35*('Feed, vet, & breeding costs'!J36+'Feed, vet, & breeding costs'!J39)/2","v":0},0,{"$f":"E40","v":6.25E-2},null,null,{"$f":"C41*(1-D41)*E41","v":0}]
[null,null,null,null,null,"land opp ",null,{"$f":"L25","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Stockers--steers",null,"Stockers--heifers",null,"Stockers--steers",null,"Stockers--heifers"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Calves!E6","v":0},null,{"$f":"Calves!G6","v":0},null,{"$f":"Calves!I6","v":0},null,{"$f":"Calves!K6","v":-3.1086244689504371E-15}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Calves!E7","v":1},null,{"$f":"Calves!G7","v":0},null,{"$f":"Calves!I7","v":"xxx"},null,{"$f":"Calves!K7","v":"xxx"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Calves!E8","v":525},null,{"$f":"Calves!G8","v":525},null,{"$f":"Calves!I8","v":525},null,{"$f":"Calves!K8","v":500}]
[null,null,null,null,null,null,"total",{"$f":"SUM(H36:H44)","v":397.26351562500003},null,null,{"$f":"Calves!E9","v":190},null,{"$f":"Calves!G9","v":190},null,{"$f":"Calves!I9","v":190},null,{"$f":"Calves!K9","v":190}]
[null,null,null,null,null,null,null,null,null,null,150,null,150,null,150,null,150]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K44*(1-K45)*K46*K47/100","v":0},null,{"$f":"M44*(1-M45)*M46*M47/100","v":0},null,{"$f":"O44*O46*O47/100","v":0},null,{"$f":"Q44*Q46*Q47/100","v":-2.9531932455029152E-12}]
[]
[]
[null,null,null,null,null,"land opp ",null,{"$f":"L26","v":0}]
[null,"cash stkr",{"$f":"SUM(Results!O10:P17)-Results!O15","v":-5.6654680946621716E-15},{"$f":"'Overhead & interest'!I41","v":1},{"$f":"E41","v":6.25E-2},null,null,{"$f":"C53*(1-D53)*E53","v":0}]
[null,"steers",{"$f":"L49+P49","v":0},1,{"$f":"E53","v":6.25E-2},null,{"$f":"Calves!I12","v":180},{"$f":"L49*(1-D54)*E54*G54/365","v":0}]
[null,"heifers",{"$f":"N49+R49","v":-2.9531932455029152E-12},1,{"$f":"E54","v":6.25E-2},null,{"$f":"Calves!K12","v":180},{"$f":"C55*(1-D55)*E55*G55/365","v":0}]
[null,"mach cash",{"$f":"Results!O15","v":0},{"$f":"'Overhead & interest'!L41","v":0},{"$f":"E37","v":6.25E-2},null,null,{"$f":"C56*(1-D56)*E56/2","v":0}]
[null,null,null,null,null,null,"total",{"$f":"SUM(H52:H56)","v":0}]
[]
[null,"operating interest"]
[null,null,null,{"$f":"'Overhead & interest'!F40","v":"Cow herd"},{"$f":"'Overhead & interest'!I40","v":"Stockers"},{"$f":"'Overhead & interest'!L40","v":0},null,null,"cash operating expense",null,null,"cows","intrate","opp equity","stkrs","intrate","opp equity"]
[null,{"$f":"'Overhead & interest'!B41:D41","v":"Percent financed"},null,{"$f":"'Overhead & interest'!F41","v":0.75},{"$f":"'Overhead & interest'!I41","v":1},{"$f":"'Overhead & interest'!L41","v":0},null,null,{"$f":"Results!B11","v":"Pasture rent"},null,null,{"$f":"Results!F11","v":0},{"$f":"$D$63/12*$D$62*(1-$D$61)","v":1.171875E-2},{"$f":"L61*M61","v":0},{"$f":"Results!O11","v":0},{"$f":"(1-$E$61)*$E$62*$E$63/12","v":0},{"$f":"O61*P61","v":0}]
[null,{"$f":"'Overhead & interest'!B42:D42","v":"Months borrowed"},null,{"$f":"'Overhead & interest'!F42","v":9},{"$f":"'Overhead & interest'!I42","v":4},{"$f":"'Overhead & interest'!L42","v":0},null,null,{"$f":"Results!B12","v":"Pasture operating"},null,null,{"$f":"Results!F12","v":16800},{"$f":"$D$63/12*$D$62*(1-$D$61)","v":1.171875E-2},{"$f":"L62*M62","v":196.875},{"$f":"Results!O12","v":0},{"$f":"(1-$E$61)*$E$62*$E$63/12","v":0},{"$f":"O62*P62","v":0}]
[null,{"$f":"'Overhead & interest'!B43:D43","v":"Interest rate"},null,{"$f":"'Overhead & interest'!F43","v":6.25E-2},{"$f":"'Overhead & interest'!I43","v":6.25E-2},{"$f":"'Overhead & interest'!L43","v":0},null,null,{"$f":"Results!B13","v":"Hay and feed"},null,null,{"$f":"Results!F13","v":14422.32},{"$f":"$D$63/12*$D$62*(1-$D$61)","v":1.171875E-2},169.0115625,{"$f":"Results!O12","v":0},0,0]
[null,null,null,null,null,null,null,null,{"$f":"Results!B14","v":"Veterinary etc."},null,null,{"$f":"Results!F14","v":2677.5},{"$f":"$D$63/12*$D$62*(1-$D$61)","v":1.171875E-2},31.376953125,{"$f":"Results!O14","v":0},0,0]
[null,null,null,null,null,null,null,null,{"$f":"Results!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"Results!#REF!","v":{"$error":"#REF!"}},{"$f":"$D$63/12*$D$62*(1-$D$61)","v":1.171875E-2},{"$error":"#REF!"},null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"Results!B15","v":"Cash mach, equip, & facilities"},null,null,{"$f":"Results!F15","v":3750},{"$f":"(1-F61)*F62*(F63)/12","v":0},0,{"$f":"Results!O15","v":0},{"$f":"M66","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"Results!B16","v":"Hired labor"},null,null,{"$f":"Results!F16","v":0},{"$f":"$D$63/12*$D$62*(1-$D$61)","v":1.171875E-2},0,{"$f":"Results!O16","v":0},0,0]
[null,null,null,null,null,null,null,null,{"$f":"Results!B17","v":"Miscellaneous"},null,null,{"$f":"Results!F17","v":0},{"$f":"$D$63/12*$D$62*(1-$D$61)","v":1.171875E-2},0,{"$f":"Results!O17","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N61:N68)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(Q61:Q68)","v":0}]
[null,null,null,null,null,null,null,null,"Depreciation"]
[null,null,null,null,null,null,null,null,"mach","facilities","cows share"]
[]
[]
[]
[null,"principal payments"]
[null,{"$f":"Pastures!E4","v":"Native"},null,{"$f":"Pastures!G4","v":"Bermuda"},null,{"$f":"Pastures!I4","v":"Wheat"},null,{"$f":"Pastures!K4","v":"Native- purch"},null,{"$f":"Pastures!M4","v":"Fescue"}]
["cow perc",{"$f":"B14","v":"Stocker"},null,{"$f":"D14","v":0},null,{"$f":"F14","v":0},null,{"$f":"H14","v":0},null,{"$f":"J14","v":0}]
["payments",{"$f":"Pastures!E16","v":0},null,{"$f":"Pastures!G16","v":4854.3482171217875},null,{"$f":"Pastures!I16","v":0},null,{"$f":"Pastures!K16","v":0},null,{"$f":"Pastures!M16","v":0},null,{"$f":"SUMPRODUCT(B77:K77,B78:K78)","v":0}]
["stk perc",{"$f":"B20","v":"stocker pasture overhead"},null,{"$f":"D20","v":0},null,{"$f":"F20","v":0},null,{"$f":"H20","v":0},null,{"$f":"J20","v":0},null,{"$f":"SUM(B79:K79)","v":0}]
["tot per",{"$f":"B77+B79","v":{"$error":"#VALUE!"}},null,{"$f":"D77+D79","v":0},null,{"$f":"F77+F79","v":0},null,{"$f":"H77+H79","v":0},null,{"$f":"J77+J79","v":0}]
["cow norm",{"$f":"IF(B77>0,B80/B77,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D77>0,D80/D77,0)","v":0},null,{"$f":"IF(F77>0,F80/F77,0)","v":0},null,{"$f":"IF(H77>0,H80/H77,0)","v":0},null,{"$f":"IF(J77>0,J80/J77,0)","v":0}]
["stk norm",{"$f":"IF(B79>0,B80/B79,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D79>0,D80/D79,0)","v":0},null,{"$f":"IF(F79>0,F80/F79,0)","v":0},null,{"$f":"IF(H79>0,H80/H79,0)","v":0},null,{"$f":"IF(J79>0,J80/J79,0)","v":0}]
[]
[null,null,null,null,"stkrs"]
[null,"sex","from ","feeders","retained","replacements",null,null,null,null,null,null,"January"]
[null,"steers","cows",34,0,null,null,null,null,null,null,null,"February"]
[null,"steers","heifers",8,0,null,null,null,null,null,null,null,"March"]
[null,"heifers","cows",15.8,-3.5527136788005001E-15,19,null,null,null,null,null,null,"April"]
[null,"heifers","heifers",2.4,4.4408920985006301E-16,6,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,"avg val",null,"avg val",null,null,null,null,null,null,null,"July"]
[null,"death loss","raised","head","purchased","head","deathlose","$",null,null,null,null,"August"]
[null,"cows",{"$f":"('Overhead & interest'!E48+'Overhead & interest'!G48)/2","v":1032.5},{"$f":"'Cows, heifers, & bulls'!E10","v":80},{"$f":"('Overhead & interest'!E49+'Overhead & interest'!G49)/2","v":1220},{"$f":"'Cows, heifers, & bulls'!E12","v":0},{"$f":"'Cows, heifers, & bulls'!$E$14","v":0.01},{"$f":"SUMPRODUCT(C93:C96,D93:D96,G93:G96)","v":1235.625},null,null,null,null,"September"]
[null,"1st calf",{"$f":"('Overhead & interest'!E50+'Overhead & interest'!G50)/2","v":970},{"$f":"'Cows, heifers, & bulls'!G10","v":20},{"$f":"('Overhead & interest'!E51+'Overhead & interest'!G51)/2","v":1220},{"$f":"'Cows, heifers, & bulls'!G12","v":0},{"$f":"'Cows, heifers, & bulls'!$G$14","v":0.01},{"$f":"SUMPRODUCT(E93:E96,F93:F96,G93:G96)","v":25.125},null,null,null,null,"October"]
[null,"heifers",{"$f":"('Overhead & interest'!E52+'Overhead & interest'!G52)/2","v":862.5},{"$f":"'Cows, heifers, & bulls'!I10","v":25},{"$f":"('Overhead & interest'!E52+'Overhead & interest'!G52)/2","v":862.5},{"$f":"'Cows, heifers, & bulls'!I12","v":0},{"$f":"'Cows, heifers, & bulls'!$I$14","v":0.01},{"$f":"SUMPRODUCT(E94:E97,F94:F97,G94:G97)","v":25.125},"total",null,null,null,"November"]
[null,"bulls",{"$f":"('Overhead & interest'!E53+'Overhead & interest'!G53)/2","v":837.5},{"$f":"'Cows, heifers, & bulls'!K10","v":0},{"$f":"('Overhead & interest'!E53+'Overhead & interest'!G53)/2","v":837.5},{"$f":"'Cows, heifers, & bulls'!K12","v":3},{"$f":"'Cows, heifers, & bulls'!$K$14","v":0.01},25.125,null,null,null,null,"December"]
[null,null,null,null,null,null,null,{"$f":"SUM(H93:H96)","v":1311}]