{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Instructions","Main","Bermuda","Bahia","Winter_Grazing","Summer_Annual","Hay","Feed","Vet","Auction","Lvstk_Facil","Equipment","Fixed_Cost","Fixed_Payment","J","K","L","M","N","O"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":279,"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":"Instructions","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"       WELCOME TO THE SOUTH GEORGIA",null,null,null,null,null,"REMEMBER"]
[null,null,"COW-CALF  BUDGET"]
[null,null,null,null,null,null,"  In order to Print a specific budget"]
[null,null,"Budget","Button",null,null,"  you must Calculate before you"]
[null,null," Type",null,null,null,"  Print that particular budget."]
[]
[null,null,"TOTAL","  "]
[null,null,"COST",null,null,null,null,"NOTE"]
[]
[null,null,"CASH ",null,null,null,"  All input in red and black is not to"]
[null,null,"FLOW",null,null,null,"  be tampered with! Only type into"]
[null,null,null,null,null,null,"  cells that contain green characters."]
[null,null," VARIABLE "]
[null,null,"COST"]
[]
[null,null,"Note: Be sure to enable all"]
[null,null,"macros on start-up."]

{"sheet":"Main","index":1,"n_rows":278,"n_cols":52,"rows_kept":278,"cut":false,"hidden":false,"merged":[[126,1,126,2],[127,1,127,2],[128,1,128,2],[117,5,117,8],[118,5,118,8],[119,5,119,8],[125,1,125,2],[123,1,123,9],[77,3,77,4],[78,3,78,4],[91,1,91,2],[87,1,87,2],[85,1,85,2],[84,1,84,2],[86,1,86,2],[61,1,61,2],[62,1,62,2],[68,1,68,2],[63,1,63,2],[76,3,76,4],[66,1,66,2],[92,1,92,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[72,1,72,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[83,1,83,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[76,1,76,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[57,1,57,2],[52,1,52,2],[56,1,56,2],[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[43,9,44,9],[43,8,44,8],[12,1,12,11],[14,1,14,9],[13,1,13,9],[17,1,17,2],[9,1,10,2],[30,1,30,2],[31,1,31,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[109,1,109,9],[107,1,107,9],[108,1,108,9],[106,1,106,9],[54,1,54,2],[22,1,22,2],[95,1,95,9],[46,1,46,2],[70,1,70,2],[64,1,64,2],[67,1,67,2],[65,1,65,2],[60,1,60,2],[51,1,51,2],[58,1,58,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[38,1,38,2],[39,1,39,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[40,1,40,2],[59,1,59,2],[53,1,53,2],[55,1,55,2]]}
[null," COW-CALF BUDGET (SOUTH GEORGIA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,3,2,1]
[null,"Revised by R. Curt Lacy, 2010"]
[null,"Extension Agricultural Economics Department, University of Georgia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Total Cost Budget)"]
[null,"Based on Budgets Originally Developed by John C. McKissick",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Cash Cost Budget)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Variable Cost Budget)"]
[]
[]
[null,"INPUT DATA: Your values in the unprotected or highlighted cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECT FIXED COST"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL FIXED PAYMENT"]
[null,"Select Budget Types",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECT FIXED COST"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURNS OVER TOTAL COST ADJUSTED FOR RISK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,3,null,null,null,3,2,1]
[null," COW-CALF BUDGET (SOUTH GEORGIA-2013",null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,3,null,null,null,3,2,1]
[null,{"$f":"+IF(bud_type=3,(Z3),IF(bud_type=2,(Z4),(Z5)))","v":"(Total Cost Budget)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURNS OVER CASH FLOW COST ADJUSTED FOR RISK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURNS OVER VARIABLE COST ADJUSTED FOR RISK"]
[]
[null,"NUMBER OF BROOD COWS",null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null," "]
[null,"PERCENT CALF CROP (DECIMAL)",null,null,null,null,null,{"$f":"85%","v":0.85},null,null,null,null,null,null,null,null,null,null," "]
[null,"COW CULLING PERCENTAGE (DECIMAL)",null,null,null,null,null,0.15,null,null,"",null,null,null,null,null,null,null," "]
[null,"NUMBER OF REPLACEMENT HEIFERS RAISED",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"          "]
[null,"REPLACEMENT HEIFER CULLING PERCENT",null,null,null,null,null,0.15]
[null,"SELLING WEIGHT OF CULL HEIFERS (CWT.)",null,null,null,null,null,7.5]
[null,"PRICE OF CULL HEIFERS ($/CWT.)",null,null,null,null,null,80]
[null,"NUMBER OF CALVES SOLD",null,null,null,null,null,{"$f":"H18*H19-H21","v":85},null,null,""]
[null,"BROOD COW DEATH LOSS (DECIMAL)",null,null,null,null,null,0.02]
[null,"SELLING WEIGHT OF CULL COWS (CWT.)",null,null,null,null,null,11,null,null,""]
[null,"PRICE OF CULL COWS ($/CWT.)",null,null,null,null,null,65]
[null,"NUMBER OF BULLS",null,null,null,null,null,3]
[null,"BULL CULLING PERCENTAGE (DECIMAL)",null,null,null,null,null,0.25]
[null,"SELLING WEIGHT OF CULL BULLS (CWT.)",null,null,null,null,null,18]
[null,"PRICE OF CULL BULLS ($/CWT.)",null,null,null,null,null,60,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"BEST","OPT.","MEDIAN"," PESS.","WORST"]
[null,"STEER WEANING/SALES  WEIGHT (CWT.)",null,null,null,6,{"$f":"+(F36+H36)/2","v":5.75},{"$f":"5.5","v":5.5},{"$f":"+(J36+H36)/2","v":5.2249999999999996},{"$f":"4.95","v":4.95}]
[null,"HEIFER WEANING/SALES WEIGHT (CWT.)",null,null,null,{"$f":"+F36*0.9","v":5.4},{"$f":"+(F37+H37)/2","v":5.1750000000000007},{"$f":"+H36*0.9","v":4.95},{"$f":"+(J37+H37)/2","v":4.7025000000000006},{"$f":"+J36*0.9","v":4.4550000000000001}]
[null,"AVERAGE WEANING/SALES WEIGHT (CWT.)",null,null,null,{"$f":"((H18*H19/2)*F36+(H18*H19/2-H21)*F37)/(H18*H19-H21)","v":5.7},{"$f":"((H18*H19/2)*G36+(H18*H19/2-H21)*G37)/(H18*H19-H21)","v":5.4625000000000004},{"$f":"((H18*H19/2)*H36+(H18*H19/2-H21)*H37)/(H18*H19-H21)","v":5.2249999999999996},{"$f":"((H18*H19/2)*I36+(H18*H19/2-H21)*I37)/(H18*H19-H21)","v":4.9637500000000001},{"$f":"((H18*H19/2)*J36+(H18*H19/2-H21)*J37)/(H18*H19-H21)","v":4.7024999999999997}]
[null,"SELL PRICE OF STEERS($/CWT.)",null,null,null,180,{"$f":"+(F39+H39)/2","v":165},150,{"$f":"+(H39+J39)/2","v":145},140,null,null,null,null,null,null,null,null,"           "]
[null,"SELL PRICE OF HEIFERS($/CWT)",null,null,null,{"$f":"+F39-6","v":174},{"$f":"+(F40+H40)/2","v":159},{"$f":"+H39-6","v":144},{"$f":"+(H40+J40)/2","v":139},{"$f":"+J39-6","v":134},null,null,null,null,null,null,null,null," "]
[null,"WEIGHTED AVE. SELLING PRICE",null,null,null,{"$f":"((H18*H19/2)*H36*F39+(H18*H19/2-H21)*H37*F40)/((H18*H19-H21)*H38)","v":177.15789473684214},{"$f":"((H18*H19/2)*H36*G39+(H18*H19/2-H21)*H37*G40)/((H18*H19-H21)*H38)","v":162.15789473684214},{"$f":"((H18*H19/2)*H36*H39+(H18*H19/2-H21)*H37*H40)/((H18*H19-H21)*H38)","v":147.15789473684214},{"$f":"+(H41+J41)/2","v":142.15789473684214},{"$f":"((H18*H19/2)*H36*J39+(H18*H19/2-H21)*H37*J40)/((H18*H19-H21)*H38)","v":137.15789473684211},null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Item",null,"Unit","Units/Cow","Total Quantity","$/Unit","Total Amount","$/Cow","$/Cwt."]
[]
[null,"VARIABLE COSTS :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,"       "]
["Bermuda Pasture  Detail","Bermuda Pasture",null,"Acre",0.5,{"$f":"+E47*H18","v":50},{"$f":"+bermuda","v":183.26000000000002},{"$f":"F47*G47","v":9163.0000000000018},{"$f":"+H47/$H$18","v":91.630000000000024},{"$f":"+H47/$E$103","v":20.662572806578293}]
["Bahia Pasture  Detail","Bahia Pasture",null,"Acre",0.75,{"$f":"+E48*$H$18","v":75},{"$f":"+bahia","v":120.55},{"$f":"F48*G48","v":9041.25},{"$f":"+H48/$H$18","v":90.412499999999994},20.388026452851243]
["Winter Grazing Detail","Winter Annual Pasture",null,"Acre",0.2,{"$f":"+E49*$H$18","v":20},{"$f":"+winter","v":205.63000000000002},{"$f":"F49*G49","v":4112.6000000000004},41.126000000000005,9.2739165038015798]
["Summer Grazing Detail","Summer Annual Pasture",null,"Acre",0,{"$f":"+E50*$H$18","v":0},{"$f":"+summer","v":222},{"$f":"F50*G50","v":0},0,0]
["Bermuda Hay Detail","Hay Production",null,"Acre",0.25,{"$f":"+E51*H18","v":25},{"$f":"+hay","v":435.53},{"$f":"F51*G51","v":10888.25},108.88249999999999,24.553013026435234]
[null,"Purchased Hay",null,"Tons/Cow",0,{"$f":"+E52*cows","v":0},75,{"$f":"+G52*F52","v":0},{"$f":"+H52/$H$18","v":0},0]
["Supplemental Feed  Detail","Total Supplemental Feed",null,"Cow Unit",null,null,null,{"$f":"+SUM(H54:H57)","v":9216},{"$f":"+SUM(I54:I57)","v":92.16},{"$f":"+SUM(J54:J57)","v":20.782087851732566}]
[null," - Cow Herd",null,"Ton",{"$f":"+cowfeed_lbs","v":0.3},{"$f":"+E54*$H$18","v":30},175,{"$f":"+cowfeed_cost*cows","v":9000},{"$f":"+H54/cows","v":90},{"$f":"+H54/$E$103","v":20.295007667707583}]
[null," - Replacement Heifers",null,"Ton",{"$f":"+cowfeed_lbs","v":0.3},{"$f":"+E55*$H$18","v":30},{"$f":"+IF(F55<>0,(H55/F55),0)","v":0},{"$f":"+hfrfeed_cost*hfrs","v":0},{"$f":"+H55/cows","v":0},{"$f":"+H55/$E$103","v":0}]
[null," - Bulls",null,"Ton",{"$f":"+cowfeed_lbs","v":0.3},{"$f":"+E56*$H$18","v":30},{"$f":"+IF(F56<>0,(H56/F56),0)","v":7.2},{"$f":"+bullfeed_cost*bulls","v":216},{"$f":"+H56/cows","v":2.16},{"$f":"+H56/$E$103","v":0.48708018402498199}]
[null," - Calves",null,"Ton",{"$f":"+cowfeed_lbs","v":0.3},{"$f":"+E57*$H$18","v":30},{"$f":"+IF(F57<>0,(H57/F57),0)","v":0},{"$f":"+calffeed_cost*(cows*calfcrop_pcnt)","v":0},{"$f":"+H57/cows","v":0},{"$f":"+H57/$E$103","v":0}]
[null,"Salt & Minerals",null,"Lbs./Cow",{"$f":"0.25*365","v":91.25},{"$f":"+E58*cows","v":9125},0.28000000000000003,{"$f":"F58*G58","v":2555.0000000000005},25.550000000000004,{"$f":"+H58/$E$103","v":5.7615271767769869}]
["Veterinary Detail","Total Vet & Medicine",null,"Cow Unit",null,null,null,{"$f":"SUM(H60:H63)","v":1914.23},19.142299999999999,4.3165902808617655]
[null," - Cow Herd",null,"Cow",1,{"$f":"+H18","v":100},{"$f":"+cow_vet","v":14},{"$f":"F60*G60","v":1400},14,3.157001192754513]
[null," - Replacement Heifers",null,"Heifer",{"$f":"+H21/H18","v":0},{"$f":"+hfrs","v":0},{"$f":"+hfr_vet","v":8},0,0,0]
[null," - Bulls",null,"Bull",{"$f":"+H29/H18","v":0.03},{"$f":"+bulls","v":3},{"$f":"+bull_vet","v":1.41},4.2299999999999995,4.2299999999999997E-2,9.5386536038225625E-3]
[null," - Calves",null,"calf",{"$f":"+H19","v":0.85},{"$f":"+(cows*calfcrop_pcnt)","v":85},{"$f":"+calf_vet","v":6},510,5.0999999999999996,1.1500504345034297]
[null,"Fence & Facilties Repairs & Maintenance",null,"% of Facilities",null,{"$f":"+(facil_inv+Lvstk_Facil!lvstk_inv)","v":93065.104166666672},0.02,1861.3020833333335,18.613020833333334,{"$f":"+H64/$E$103","v":4.1972377836855665}]
[null,"Labor (including insurance, taxes, and SS)",null,"Hrs./Cow",6,{"$f":"+E65*H18","v":600},10,6000,60,13.530005111805055]
[null,"Pasture Rent",null,"Acres",0,{"$f":"+E66*cows","v":0},20,{"$f":"F66*G66","v":0},0,0]
[null,"Machinery Rent",null,"Year",0,{"$f":"+E67*H20","v":0},0,{"$f":"F67*G67","v":0},0,0]
[null,"Other",null,"Cow",1,{"$f":"+E68*H18","v":100},2,200,2,0.45100017039350188]
[null,"Interest on Operating Capital (8 months)",null,"Percent",null,{"$f":"SUM(H47:H68)-H53-H59","v":54951.632083333338},0.08,{"$f":"(F69*G69)/12*8","v":2930.753711111111},29.30753711111111,6.6088521154624944]
["Marketing Detail","Auction & Hauling",null,"Head",null,{"$f":"H25+(H20*H18)","v":100},{"$f":"+mktng_cst","v":36.965565254166677},{"$f":"F70*G70","v":3696.5565254166677},36.965565254166677,8.335738114160641]
[null,"TOTAL VARIABLE COST",null,null,null,null,null,{"$f":"+(SUM(H64:H70)+H58+H59+SUM(H47:H53))","v":61578.942319861111},615.78942319861108,138.86056739454492]
[]
[null,"FIXED COST SECTION"]
["Livestock  Detail",{"$f":"IF(bud_type=2,\" Annual Livestock Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Livestock Fixed Costs\"))","v":"Annual Livestock Fixed Costs"},null,null,null,null,null,{"$f":"IF(bud_type=3,Lvstk_Facil!lvstk_fc,IF(bud_type=2,(Lvstk_Facil!lvstk_pmt),0))","v":5416.56},{"$f":"+H74/cows","v":54.165600000000005},{"$f":"+H74/exp_wt","v":12.214347414733133}]
["Building & Facilities Detail",{"$f":"IF(bud_type=2,\" Annual Buildings & Facilities Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Buildings & Facilities Fixed Costs\"))","v":"Annual Buildings & Facilities Fixed Costs"},null,null,null,null,null,{"$f":"IF(bud_type=3,Lvstk_Facil!facil_fc,IF(bud_type=2,(Lvstk_Facil!facil_pmt),0))","v":3181.7838293650793},31.817838293650794,7.1749252459946984]
["Equipment Detail",{"$f":"IF(bud_type=2,\" Annual Equipment Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Equipment Fixed Costs\"))","v":"Annual Equipment Fixed Costs"},null,null,null,null,null,{"$f":"IF(bud_type=3,equip_fc+cow_fc,IF(bud_type=2,(equip_pmt),0))","v":9336.6623999999993},93.366623999999987,21.054181666533008]
["Land Detail",{"$f":"IF(bud_type=2,\" Annual Land Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Land Fixed Costs Excluding Taxes\"))","v":"Annual Land Fixed Costs Excluding Taxes"},null,{"$f":"+IF(bud_type<>1,\"Percent of Land Value\",\"\")","v":"Percent of Land Value"},null,{"$f":"+IF(bud_type<>1,Lvstk_Facil!land_inv,\"\")","v":150000},0,{"$f":"+IF(F77<>\"\",G77*F77,0)","v":0},0,0]
[null,{"$f":"IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Real Estate Taxes\")","v":"Annual Real Estate Taxes"},null,{"$f":"+IF(bud_type<>1,\"Percent of Land Value\",\"\")","v":"Percent of Land Value"},null,{"$f":"+IF(bud_type<>1,Lvstk_Facil!land_inv,\"\")","v":150000},{"$f":"+IF(bud_type<>1,0.5%,0)","v":5.0000000000000001E-3},{"$f":"+IF(F78<>\"\",G78*F78,0)","v":750},7.5,1.6912506389756319]
[null,{"$f":"IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Farm Insurance\")","v":"Annual Farm Insurance"},null,{"$f":"+IF(bud_type<>1,\"Pcnt. of Lvstk., Facl, & Eqp.\",\"\")","v":"Pcnt. of Lvstk., Facl, & Eqp."},null,{"$f":"+IF(bud_type<>1,Lvstk_Facil!lvstk_inv+facil_inv+Equipment!B21,\"\")","v":244201.10416666669},{"$f":"+IF(bud_type<>1,0.25%,0)","v":2.5000000000000001E-3},{"$f":"+IF(F79<>\"\",G79*F79,0)","v":610.50276041666677},6.1050276041666676,1.3766842448680998]
[null,{"$f":"IF(bud_type=2,\"TOTAL FIXED PAYMENTS\",\"TOTAL FIXED COST\")","v":"TOTAL FIXED COST"},null,null,null,null,null,{"$f":"SUM(H74:H79)","v":19295.508989781745},{"$f":"+H80/$H$18","v":192.95508989781746},43.511389211104571]
[]
[null,"                       EXPECTED BREAK-EVEN TABLE"]
[]
[null,"ITEM",null,"TOTAL",null,"$/Cwt.",null,"$/Cow"]
[null,"Variable Cost",null,{"$f":"H71","v":61578.942319861111},null,{"$f":"+D85/($H$25*$H$38)","v":138.65227654345313},null,{"$f":"+D85/$H$18","v":615.78942319861108}]
[null,"Less: Value of cull cows, bulls and heifers",null,{"$f":"+(H18*H20*H27*H28)+(H30*H29*H31*H32)+(H21*H22*H23*H24)","v":11535},null,{"$f":"-D86/($H$25*$H$38)","v":-25.972417675204056},null,{"$f":"+D86/$H$18","v":115.35}]
[null,"NET VARIABLE COST",null,{"$f":"D85-D86","v":50043.942319861111},null,{"$f":"+D87/($H$25*$H$38)","v":112.67985886824907},null,{"$f":"+D87/H18","v":500.43942319861111}]
[null,{"$f":"+IF(bud_type<>1,B74,\"\")","v":"Annual Livestock Fixed Costs"},null,{"$f":"+H74","v":5416.56},null,12.196025893611035,null,{"$f":"+D88/H18","v":54.165600000000005}]
[null,{"$f":"+IF(bud_type<>1,B75,\"\")","v":"Annual Buildings & Facilities Fixed Costs"},null,{"$f":"+H75","v":3181.7838293650793},null,7.1641628581257075,null,{"$f":"+D89/H18","v":31.817838293650794}]
[null,{"$f":"+IF(bud_type<>1,B76,\"\")","v":"Annual Equipment Fixed Costs"},null,{"$f":"+H76","v":9336.6623999999993},null,21.022600394033212,null,{"$f":"+D90/H18","v":93.366623999999987}]
[null,{"$f":"+IF(bud_type<>1,B77,\"\")","v":"Annual Land Fixed Costs Excluding Taxes"},null,{"$f":"+H77","v":0},null,0,null,{"$f":"+D91/H18","v":0}]
[null,{"$f":"+IF(bud_type<>1,B78,\"\")","v":"Annual Real Estate Taxes"},null,{"$f":"+H79","v":610.50276041666677},null,1.3746192185007979,null,{"$f":"+D92/cows","v":6.1050276041666676}]
[null," TOTAL COSTS",null,{"$f":"SUM(D87:D91)","v":67978.948549226188},null,{"$f":"D93/((H18*H19-H21)*H38)","v":153.06264801401903},null,{"$f":"+D93/H18","v":679.78948549226186}]
[]
[]
[null,"     EXPECTED RETURNS FROM CALF SALES TABLE"]
[null,null,null,null,{"$f":"+ROUND(H25,0)","v":85}," CALVES SOLD"]
[]
[null,null,"EXP. WEIGHT",null,"TOTAL WEIGHT",null,"  EXP.PRICE",null,"TOTAL RETURN"]
[null,null,"(cwt./cow)",null,"  (cwt.)",null,"   ($/cwt.)"]
[null,null,{"$f":"+exp_wt/cows","v":4.4345881250000003},null,{"$f":"(0.04*F38+0.25*G38+0.42*H38+0.25*I38+0.04*J38)*H25","v":443.45881250000002},null,{"$f":"(0.04*F41+0.25*G41+0.42*H41+0.25*I41+0.04*J41)","v":150.45789473684215},null,{"$f":"+G101*E101","v":66721.87933125002}]
[null,null,"(cwt./calf)",null,"  (cwt.)",null,"   ($/cwt.)"]
[null,null,{"$f":"+E103/calves_sold","v":5.2171625000000006},null,{"$f":"+exp_wt","v":443.45881250000002},null,{"$f":"(0.04*F41+0.25*G41+0.42*H41+0.25*I41+0.04*J41)","v":150.45789473684215},null,{"$f":"+G103*E103","v":66721.87933125002}]
[]
[]
[]
[null,"RETURNS OVER TOTAL COST ADJUSTED FOR RISK"]
[null,"Net return levels (TOP ROW);"]
[null,"The chances of obtaining this level or more (MIDDLE ROW); and"]
[null,"The chances of obtaining this level or less (BOTTOM ROW)."]
[]
[]
[null,null,null,null,"Optimistic",null,"Expected",null,"  Pessimistic"]
[null,"Returns",null,{"$f":"(Q165:Q165)+(1.5*S164:S164)","v":8279.4225291074981},{"$f":"Q165:Q165+S164:S164","v":4926.3831902564216},{"$f":"Q165:Q165+0.5*S164:S164","v":1573.343851405346},{"$f":"Q165:Q165","v":-1779.6954874457297},{"$f":"Q165:Q165-0.5*S165:S165","v":-4377.9111718843278},{"$f":"Q165:Q165-S165:S165","v":-6976.126856322926},{"$f":"Q165:Q165-1.5*S165:S165","v":-9574.342540761525},null,null,null,null,null,"*","*",null,null,null,"*",null,"          "," ",null,null,null,null,"       "]
[null,"Chances",null,{"$f":"IF(R167<1,IF(Q167,V167,1-V167),IF(Q167,V168,1-V168))","v":7.7803167502563247E-2},{"$f":"IF(X167<1,IF(W167,AB167,1-AB167),IF(W167,AB168,1-AB168))","v":0.15856749579250709},{"$f":"IF(AD167<1,IF(AC167,AH167,1-AH167),IF(AC167,AH168,1-AH168))","v":0.27827212797359568},{"$f":"IF(R169<1,IF(Q169,V169,1-V169),IF(Q169,V170,1-V170))","v":0.46659815909517688},{"$f":"IF(X169<1,IF(W169,AB169,1-AB169),IF(W169,AB170,1-AB170))","v":0.65429493035030117},{"$f":"IF(AD169<1,IF(AC169,AH169,1-AH169),IF(AC169,AH170,1-AH170))","v":0.84123379086113736},{"$f":"IF(R171<1,IF(Q171,V171,1-V171),IF(Q171,V172,1-V172))","v":0.94683719236686825},null,null,null,null,null,"*","    Must match budget Entries",null,null,null,"*"]
[null,"Chances",null,{"$f":"IF(R167<1,IF(Q167,1-V167,V167),IF(Q167,1-V168,V168))","v":0.92219683249743678},{"$f":"IF(X167<1,IF(W167,1-AB167,AB167),IF(W167,1-AB168,AB168))","v":0.84143250420749294},{"$f":"IF(AD167<1,IF(AC167,1-AH167,AH167),IF(AC167,1-AH168,AH168))","v":0.72172787202640432},{"$f":"IF(R169<1,IF(Q169,1-V169,V169),IF(Q169,1-V170,V170))","v":0.53340184090482312},{"$f":"IF(X169<1,IF(W169,1-AB169,AB169),IF(W169,1-AB170,AB170))","v":0.34570506964969888},{"$f":"IF(AD169<1,IF(AC169,1-AH169,AH169),IF(AC169,1-AH170,AH170))","v":0.15876620913886258},{"$f":"IF(R171<1,IF(Q171,1-V171,V171),IF(Q171,1-V172,V172))","v":5.3162807633131776E-2},null,null,null,null,null,"*","-",null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",1,"UNIT",null,null,"*"]
[null,"  CHANCE FOR PROFIT ",null,null,{"$f":"IF(X171<1,IF(W171,AB171,1-AB171),IF(W171,AB172,1-AB172))","v":0.35797237247537445},"  BASE BUDGETED NET REVENUE - TOTAL",null,null,null,{"$f":"+Q165","v":-1779.6954874457297},null,null,null,null,null,"*",{"$f":"+H25*F38+(H18*H20*H27)","v":649.5},"  Best Y",{"$f":"(((H18*H19/2)*H36*F39+(H18*H19/2-H21)*H37*F40)+((H28+(F41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":150.83972911963883},"  Best P","*","EXP.CULL WEIGHT",null,{"$f":"H18*H20*H27","v":165}]
[null,null,null,null,null,"  BASE BUDGETED NET REVENUE - $/HEAD MARKETED",null,null,null,{"$f":"+J118/calves_sold","v":-20.937593969949759},null,null,null,null,null,"*",{"$f":"+H25*G38+(H18*H20*H27)","v":629.3125},"  Opt. Y",{"$f":"(((H18*H19/2)*H36*G39+(H18*H19/2-H21)*H37*G40)+((H28+(G41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":137.87133182844244},"  Opt. P","*","EXP.CULL PRICE",null,{"$f":"0.04*(H28+0.5*(F41-H41))+0.25*(H28+0.5*(G41-H41))+0.42*H28+0.25*(H28-0.5*(H41-I41))+0.04*(H28-0.5*(H41-J41))","v":66.650000000000006}]
[null,null,null,null,null,"  BASE BUDGETED NET REVENUE - $/COW",null,null,null,{"$f":"+J118/cows","v":-17.796954874457295},null,null,null,null,null,"*",{"$f":"+H25*H38+(H18*H20*H27)","v":609.125},"  Med. Y",{"$f":"(((H18*H19/2)*H36*H39+(H18*H19/2-H21)*H37*H40)+(H28*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":124.90293453724605},"  Med. P","*",{"$f":"+Q119*S119-D85-D88-D89-D90","v":7250.2039620604901}]
[null,"PROFIT IS RETURN TO RISK AND ALL \"ZERO\" ITEMS IN THE BUDGET.",null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+H25*I38+(H18*H20*H27)","v":586.91875000000005},"  Pess. Y",{"$f":"(((H18*H19/2)*H36*I39+(H18*H19/2-H21)*H37*I40)+((H28+(I41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":120.58013544018058},"  Pess. P","*",{"$f":"Q119*S119","v":86764.15251128668}]
[null,"MAY ENTER YOUR OWN VALUES.",null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+H25*J38+(H18*H20*H27)","v":564.71249999999998},"  Worst Y",{"$f":"(((H18*H19/2)*H36*J39+(H18*H19/2-H21)*H37*J40)+((H28+(J41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":116.25733634311513},"  Worst P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",0,"  H&MC",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"D85","v":61578.942319861111},"  T.C.",null,null,"*"]
[null,null,null,"Total Dollars","$/Cow","$/Calf Marketed",null,null,null,null,null,null,null,null,null,"*","*",null,null,null,"*"]
[null,"Returns to Land, Labor, Capital and Management",null,{"$f":"+Q164-(H71-H66-H65)","v":22155.310741919347},{"$f":"+D126/cows","v":221.55310741919348},{"$f":"+D126/calves_sold","v":260.65071461081584},null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,"Returns to Labor, Capital and Management",null,{"$f":"+D126-H77-H66","v":22155.310741919347},{"$f":"+D127/cows","v":221.55310741919348},{"$f":"+D127/calves_sold","v":260.65071461081584},null,null,null,null,null,null,null,null,null,":",null,"Calculations",null,null,":"]
[null,"Returns to Land, Capital and Management",null,{"$f":"+D126-H65","v":16155.310741919347},{"$f":"+D128/cows","v":161.55310741919348},{"$f":"+D128/calves_sold","v":190.06247931669822},null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.04*Q118+0.25*Q119+0.42*Q120+0.25*Q121+0.04*Q122","v":608.45881249999991},"  Exp. Y",{"$f":"0.04*S118+0.25*S119+0.42*S120+0.25*S121+0.04*S122","v":127.75598194130924},"  Exp. P",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,":",{"$f":"0.25*(Q118-Q129)+0.5*(Q119-Q129)","v":20.687140625000069},"  SYO",{"$f":"0.25*(S118-S129)+0.5*(S119-S129)","v":10.828611738148993},"  SPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(Q129-Q122)+0.5*(Q129-Q121)","v":21.706609374999914},"  SYP",{"$f":"0.25*(S129-S122)+0.5*(S129-S121)","v":6.4625846501128592},"  SPP",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,":",{"$f":"Q130^2","v":427.95778723852823},"  VYO",{"$f":"S130^2","v":117.25883217557815},"  VPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"Q131^2","v":471.17689055883415},"  VYP",{"$f":"S131^2","v":41.76500035987435},"  VPP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",{"$f":"(Q129^2*S132)+(S129-Q123)^2*Q132","v":50396766.135094844},"  VTRHH",{"$f":"(Q129^2*S133)+(S129-Q123)^2*Q133","v":23152683.706379503},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(Q129^2*S132)+(S129-Q123)^2*Q133","v":51102170.659495376},"  VTRHL",{"$f":"Q129^2*S133+(S129-Q123)^2*Q132","v":22447279.181978974},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(Q135)","v":7099.067976508948},"  STRHH",{"$f":"SQRT(S135)","v":4811.7235691984115},"  STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(Q136)","v":7148.5782264374348},"  STRHL",{"$f":"SQRT(S136)","v":4737.8559688934165},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*Q137+0.17*Q138+0.17*S138","v":6706.0786777021513},"  STRO",{"$f":"0.66*S137+0.17*Q138+0.17*S138","v":5196.4313688771963},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","Calculation of NR and for Z values",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"S120","v":124.90293453724605},"  MP",{"$f":"+Q165-Q163","v":498.18361191223084},"ENR_MNR",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",":",{"$f":"Q120","v":609.125},"  MY",{"$f":"+Q137","v":7099.067976508948},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+Q164+0.33*(S165-S164)","v":77236.069449868228},"  MTR",{"$f":"+S137","v":4811.7235691984115},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+D85","v":61578.942319861111},"  MTC",{"$f":"+Q138","v":7148.5782264374348},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"Q161-Q162-(SUM(D88:D91))","v":-2277.8790993579605},"  MNR",{"$f":"+S138","v":4737.8559688934165},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",":",{"$f":"Q129*S129","v":77734.253061780459},"  ETR",{"$f":"Q139","v":6706.0786777021513},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"Q164-Q162-(SUM(D88:D91))","v":-1779.6954874457297},"  ENR",{"$f":"S139","v":5196.4313688771963},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"+D114>=Q163","v":true},{"$f":"ABS((D114-Q165)/IF(Q167,S164,S165))","v":1.5000000000000002},{"$f":"MIN(2.5,ABS((D114-(Q163+S159*ABS(D114-Q163)/ABS(IF(Q167,S164+S159,S165-S159))*MIN(1,R167)))/(MIN(1.52,R167)/1.52*IF(Q167,S160,S161)+(1.52-MIN(1.52,R167))/3.04*S162+(1.52-MIN(1.52,R167))/3.04*S163)))","v":1.3872736094593927},{"$f":"1/(1+(0.2316419*S167))","v":0.75680135788301406},{"$f":"0.398942281*((2.71828)^((-(S167^2)/2)))","v":0.15240681510601728},{"$f":"U167*(0.31938153*T167-0.356563782*T167^2+1.781477937*T167^3-1.821255978*T167^4+1.330274429*T167^5)","v":8.2679281558688061E-2},{"$f":"+E114>=Q163","v":true},{"$f":"ABS((E114-Q165)/IF(W167,S164,S165))","v":1},{"$f":"MIN(2.5,ABS((E114-(Q163+S159*ABS(E114-Q163)/ABS(IF(W167,S164+S159,S165-S159))*MIN(1,X167)))/(MIN(1.52,X167)/1.52*IF(W167,S160,S161)+(1.52-MIN(1.52,X167))/3.04*S162+(1.52-MIN(1.52,X167))/3.04*S163)))","v":1.0003629920975312},{"$f":"1/(1+(0.2316419*Y167))","v":0.81186888386252298},{"$f":"0.398942281*((2.71828)^((-(Y167^2)/2)))","v":0.2418829728357606},{"$f":"AA167*(0.31938153*Z167-0.356563782*Z167^2+1.781477937*Z167^3-1.821255978*Z167^4+1.330274429*Z167^5)","v":0.15856749579250709},{"$f":"+F114>=Q163","v":true},{"$f":"ABS((F114-Q165)/IF(AC167,S164,S165))","v":0.5},{"$f":"MIN(2.5,ABS((F114-(Q163+S159*ABS(F114-Q163)/ABS(IF(AC167,S164+S159,S165-S159))*MIN(1,AD167)))/(MIN(1.52,AD167)/1.52*IF(AC167,S160,S161)+(1.52-MIN(1.52,AD167))/3.04*S162+(1.52-MIN(1.52,AD167))/3.04*S163)))","v":0.5879821296504204},{"$f":"1/(1+(0.2316419*AE167))","v":0.88012573303992392},{"$f":"0.398942281*((2.71828)^((-(AE167^2)/2)))","v":0.33561187929793573},{"$f":"AG167*(0.31938153*AF167-0.356563782*AF167^2+1.781477937*AF167^3-1.821255978*AF167^4+1.330274429*AF167^5)","v":0.27827212797359568}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((D114-Q165)/(MIN(1.52,R167)/1.52*IF(Q167,S160,S161)+(1.52-MIN(1.52,R167))/3.04*S162+(1.52-MIN(1.52,R167))/3.04*S163)))","v":1.4200053150501257},0.75248353662775957,0.14556313034834939,7.7803167502563247E-2,null,null,{"$f":"MIN(2.5,ABS((E114-Q165)/(MIN(1.52,X167)/1.52*IF(W167,S160,S161)+(1.52-MIN(1.52,X167))/3.04*S162+(1.52-MIN(1.52,X167))/3.04*S163)))","v":1.0003629920975312},0.81186888386252298,0.2418829728357606,0.15856749579250709,null,null,{"$f":"MIN(2.5,ABS((F114-Q165)/(MIN(1.52,AD167)/1.52*IF(AC167,S160,S161)+(1.52-MIN(1.52,AD167))/3.04*S162+(1.52-MIN(1.52,AD167))/3.04*S163)))","v":0.53025631677622997},{"$f":"1/(1+(0.2316419*AE168))","v":0.89060710296933865},{"$f":"0.398942281*((2.71828)^((-(AE168^2)/2)))","v":0.34662065236772033},{"$f":"AG168*(0.31938153*AF168-0.356563782*AF168^2+1.781477937*AF168^3-1.821255978*AF168^4+1.330274429*AF168^5)","v":0.29796712087474075}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+G114>=Q163","v":true},{"$f":"ABS((G114-Q165)/IF(Q169,S164,S165))","v":0},{"$f":"MIN(2.5,ABS((G114-(Q163+S159*ABS(G114-Q163)/ABS(IF(Q169,S164+S159,S165-S159))*MIN(1,R169)))/(MIN(1.52,R169)/1.52*IF(Q169,S160,S161)+(1.52-MIN(1.52,R169))/3.04*S162+(1.52-MIN(1.52,R169))/3.04*S163)))","v":8.3823896002036338E-2},0.98095271696944419,0.39754316797234707,0.46659815909517688,{"$f":"+H114>=Q163","v":false},{"$f":"ABS((H114-Q165)/IF(W169,S164,S165))","v":0.5},{"$f":"MIN(2.5,ABS((H114-(Q163+S159*ABS(H114-Q163)/ABS(IF(W169,S164+S159,S165-S159))*MIN(1,X169)))/(MIN(1.52,X169)/1.52*IF(W169,S160,S161)+(1.52-MIN(1.52,X169))/3.04*S162+(1.52-MIN(1.52,X169))/3.04*S163)))","v":0.39694230040906414},0.91579413196100345,0.36871913606469575,0.34570506964969888,{"$f":"+I114>=Q163","v":false},{"$f":"ABS((I114-Q165)/IF(AC169,S164,S165))","v":1},{"$f":"MIN(2.5,ABS((I114-(Q163+S159*ABS(I114-Q163)/ABS(IF(AC169,S164+S159,S165-S159))*MIN(1,AD169)))/(MIN(1.52,AD169)/1.52*IF(AC169,S160,S161)+(1.52-MIN(1.52,AD169))/3.04*S162+(1.52-MIN(1.52,AD169))/3.04*S163)))","v":0.99954180090188482},{"$f":"1/(1+(0.2316419*AE169))","v":0.81199428465240775},{"$f":"0.398942281*((2.71828)^((-(AE169^2)/2)))","v":0.24208167698618493},{"$f":"AG169*(0.31938153*AF169-0.356563782*AF169^2+1.781477937*AF169^3-1.821255978*AF169^4+1.330274429*AF169^5)","v":0.15876620913886258}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"MIN(2.5,ABS((G114-Q165)/(MIN(1.52,R169)/1.52*IF(Q169,S160,S161)+(1.52-MIN(1.52,R169))/3.04*S162+(1.52-MIN(1.52,R169))/3.04*S163)))","v":0},1,0.39894228100000001,0.50000000022538427,null,null,{"$f":"MIN(2.5,ABS((H114-Q165)/(MIN(1.52,X169)/1.52*IF(W169,S160,S161)+(1.52-MIN(1.52,X169))/3.04*S162+(1.52-MIN(1.52,X169))/3.04*S163)))","v":0.46638100135719873},0.90249988574021911,0.35783114074078204,0.32047143968852748,null,null,{"$f":"MIN(2.5,ABS((I114-Q165)/(MIN(1.52,AD169)/1.52*IF(AC169,S160,S161)+(1.52-MIN(1.52,AD169))/3.04*S162+(1.52-MIN(1.52,AD169))/3.04*S163)))","v":0.99954180090188482},{"$f":"1/(1+(0.2316419*AE170))","v":0.81199428465240775},{"$f":"0.398942281*((2.71828)^((-(AE170^2)/2)))","v":0.24208167698618493},{"$f":"AG170*(0.31938153*AF170-0.356563782*AF170^2+1.781477937*AF170^3-1.821255978*AF170^4+1.330274429*AF170^5)","v":0.15876620913886258}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J114>=Q163","v":false},{"$f":"ABS((J114-Q165)/IF(Q171,S164,S165))","v":1.5000000000000002},{"$f":"MIN(2.5,ABS((J114-(Q163+S159*ABS(J114-Q163)/ABS(IF(Q171,S164+S159,S165-S159))*MIN(1,R171)))/(MIN(1.52,R171)/1.52*IF(Q171,S160,S161)+(1.52-MIN(1.52,R171))/3.04*S162+(1.52-MIN(1.52,R171))/3.04*S163)))","v":1.6720117896293112},0.72082047304138386,9.859356296925384E-2,4.7261019738402285E-2,{"$f":"0>=Q163","v":true},{"$f":"ABS((0-Q165)/IF(W171,S164,S165))","v":0.26538541716834513},{"$f":"MIN(2.5,ABS((0-(Q163+S159*ABS(0-Q163)/ABS(IF(W171,S164+S159,S165-S159))*MIN(1,X171)))/(MIN(1.52,X171)/1.52*IF(W171,S160,S161)+(1.52-MIN(1.52,X171))/3.04*S162+(1.52-MIN(1.52,X171))/3.04*S163)))","v":0.36388404763881993},0.92226182055305861,0.37338534831071329,0.35797237247537445]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((J114-Q165)/(MIN(1.52,R171)/1.52*IF(Q171,S160,S161)+(1.52-MIN(1.52,R171))/3.04*S162+(1.52-MIN(1.52,R171))/3.04*S163)))","v":1.6149314739937453},0.72775659542848503,0.10829032248053436,5.3162807633131776E-2,null,null,{"$f":"MIN(2.5,ABS((0-Q165)/(MIN(1.52,X171)/1.52*IF(W171,S160,S161)+(1.52-MIN(1.52,X171))/3.04*S162+(1.52-MIN(1.52,X171))/3.04*S163)))","v":0.28961572603532681},0.93713059157076073,0.38255718337200384,0.38605519177173964]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Bermuda","index":2,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,3],[14,0,14,3],[10,0,10,3],[12,0,12,3],[11,0,11,3],[0,8,0,9],[2,0,2,7],[9,0,9,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[4,0,4,3]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Hybrid Bermuda Pasture Per Acre Cost Detail "]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Prorated Establishment Cost",null,null,null,"YRS.",10,0,{"$f":"+G6/F6","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",150,0.7,{"$f":"+G8*F8","v":105}]
[" Phosphorous (P2O5)",null,null,null,"LBS.",30,0.6,18]
[" Potash (K2O)",null,null,null,"LBS.",65,0.55000000000000004,35.75]
["Lime",null,null,null,"TONS",0.4,35,14]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,1.74,1.74]
["Machinery Fuel",null,null,null,"Gallons",1.45,4,5.8]
["Labor",null,null,null,"Hours",0.33,9,2.97]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H15)","v":183.26000000000002}]

{"sheet":"Bahia","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,3],[14,0,14,3],[4,0,4,3],[0,8,0,9],[9,0,9,3],[10,0,10,3],[12,0,12,3],[11,0,11,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[2,0,2,7]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Bahia Pasture Per Acre Cost Detail"]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Prorated Establishment Cost",null,null,null,"YRS.",10,0,{"$f":"+G6/F6","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",75,0.7,{"$f":"+G8*F8","v":52.5}]
[" Phosphorous (P2O5)",null,null,null,"LBS.",40,0.6,24]
[" Potash (K2O)",null,null,null,"LBS.",40,0.55000000000000004,22]
["Lime",null,null,null,"TONS",0.33,35,11.55]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,1.73,1.73]
["Machinery Fuel",null,null,null,"Gallons",1.45,4,5.8]
["Labor",null,null,null,"Hours",0.33,9,2.97]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H15)","v":120.55}]

{"sheet":"Winter_Grazing","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,3],[4,0,4,3],[0,8,0,9],[12,0,12,3],[13,0,13,3],[15,0,15,3],[14,0,14,3],[6,0,6,3],[9,0,9,3],[7,0,7,3],[10,0,10,3],[11,0,11,3],[2,0,2,7],[16,0,16,3],[8,0,8,3],[5,0,5,3]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Winter Grazing Per Acre Cost Detail"]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Wheat",null,null,null,"Bushel",1,10.5,{"$f":"+G6*F6","v":10.5}]
["Rye",null,null,null,"Bushel",1,13.5,{"$f":"+G7*F7","v":13.5}]
["Ryegrass",null,null,null,"Lbs.",15,0.35,{"$f":"+G8*F8","v":5.25}]
["Clover",null,null,null,"Lbs.",0,1.35,{"$f":"+G9*F9","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",150,0.7,105]
[" Phosphorous (P2O5)",null,null,null,"LBS.",50,0.6,30]
[" Potash (K2O)",null,null,null,"LBS.",50,0.55000000000000004,27.500000000000004]
["Lime",null,null,null,"TONS",0,35,0]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,2.68,2.68]
["Machinery Fuel",null,null,null,"Gallons",1.45,4,5.8]
["Labor",null,null,null,"Hours",0.6,9,5.3999999999999995]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H18)","v":205.63000000000002}]

{"sheet":"Summer_Annual","index":5,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,3],[5,0,5,3],[14,0,14,3],[4,0,4,3],[0,8,0,9],[9,0,9,3],[10,0,10,3],[12,0,12,3],[11,0,11,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[2,0,2,7]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Summer Annual Per Acre Cost Detail"]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Millet/Forage Sorghum",null,null,null,"Lbs.",20,0.8,{"$f":"+G6*F6","v":16}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",180,0.7,{"$f":"+G8*F8","v":125.99999999999999}]
[" Phosphorous (P2O5)",null,null,null,"LBS.",40,0.6,24]
[" Potash (K2O)",null,null,null,"LBS.",80,0.5,40]
["Lime",null,null,null,"TONS",0,35,0]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",2,3.5,7]
["Machinery Fuel",null,null,null,"Gallons",3,3,9]
["Other",null,null,null,"Acre",0,2,0]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H15)","v":222}]

{"sheet":"Hay","index":6,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,7],[9,0,9,3],[10,0,10,3],[1,0,1,1],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[19,0,19,6],[20,0,20,6],[22,0,22,6],[17,0,17,3],[13,0,13,3],[12,0,12,3],[16,0,16,3],[14,0,14,3],[15,0,15,3],[11,0,11,3]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
["Tons per Acre",null,5]
["Hybrid Bermuda Hay Per Acre Cost Detail "]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Prorated Establishment Cost",null,null,null,"YRS.",10,0,{"$f":"+G6/F6","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",250,0.7,{"$f":"+G8*F8","v":175}]
[" Phosphorous (P2O5)",null,null,null,"LBS.",60,0.6,36]
[" Potash (K2O)",null,null,null,"LBS.",200,0.55000000000000004,110.00000000000001]
["Lime",null,null,null,"TONS",0.5,35,17.5]
["Herbicide",null,null,null,"Acre",1,4.5,{"$f":"+G12*F12","v":4.5}]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,18.5,18.5]
["Machinery Fuel",null,null,null,"Gallons",12.5,4,50]
["Labor",null,null,null,"Hours",2.67,9,24.03]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H16)","v":435.53}]
["TOTAL VARIABLE COST PER TON",null,null,null,null,null,null,{"$f":"+hay/hay_tons","v":87.105999999999995}]
[]
["TOTAL FIXED COSTS",null,null,null,null,null,null,{"$f":"+equip_fc","v":6874.2063999999991}]
["TOTAL FIXED COSTS PER TON",null,null,null,null,null,null,{"$f":"IF(Main!F51>0,H20/(hay_tons*Main!F51),\"N/A\")","v":54.993651199999995}]
[]
["TOTAL HAY COSTS PER TON",null,null,null,null,null,null,{"$f":"+IF(H21<>\"N/A\",H21+H18,\"N/A\")","v":142.09965119999998}]

{"sheet":"Feed","index":7,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[38,0,38,6],[0,7,0,8],[1,0,1,6],[14,0,14,6],[26,0,26,6]]}
[null,null,null,null,null,null,null,"Return To Main"]
["Supplemental Feed for Cows"]
["Ingredient","Unit","Days fed","Pounds Fed per Day","Total Tons Fed","$/unit","Cost/Cow"]
["WCS","Tons",100,6,{"$f":"+D4*C4/2000","v":0.3},300,{"$f":"+F4*E4","v":90}]
[null,"Tons",0,22,{"$f":"+D5*C5/2000","v":0},90,{"$f":"+F5*E5","v":0}]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
["Total Feed for Cows",null,null,null,{"$f":"SUM(E4:E10)","v":0.3},{"$f":"+IF(cowfeed_lbs>0,cowfeed_cost/cowfeed_lbs,0)","v":300},{"$f":"SUM(G4:G10)","v":90}]
[]
[]
[]
["Supplemental Feed for Replacement Heifers"]
["Ingredient","Unit","Days fed","Pounds Fed per Day","Total Tons Fed","$/unit","Cost/Cow"]
["WCS","Tons",0,6,{"$f":"+D17*C17/2000","v":0},300,{"$f":"+(E17*F17)","v":0}]
[null,"Tons",0,22,{"$f":"+D18*C18/2000","v":0},90,{"$f":"+(E18*F18)","v":0}]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
["Total Feed for Replacements",null,null,null,{"$f":"SUM(E17:E23)","v":0},{"$f":"+IF(hfrfeed_lbs>0,hfrfeed_cost/hfrfeed_lbs,0)","v":0},{"$f":"SUM(G17:G23)","v":0}]
[]
[]
["Supplemental Feed for Herd Bulls"]
["Ingredient","Unit","Days fed","Pounds Fed per Day","Total Tons Fed","$/unit","Cost/Bull"]
["Soy hulls","Tons",120,4,{"$f":"+D29*C29/2000","v":0.24},300,{"$f":"+(E29*F29)","v":72}]
[null,"Tons",0,22,{"$f":"+D30*C30","v":0},90,{"$f":"+(E30/2000)*F30","v":0}]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
["Total Feed for Herd Bulls",null,null,null,{"$f":"SUM(E29:E35)","v":0.24},{"$f":"+G36/E36","v":300},{"$f":"SUM(G29:G35)","v":72}]
[]
[]
["Supplemental Feed for Calves"]
["Ingredient","Unit","Days fed","Pounds Fed per Day","Total Pounds Fed","$/unit","Cost/Calf"]
[null,"Tons",0,2,{"$f":"+D41*C41/2000","v":0},200,{"$f":"+(E41*F41)","v":0}]
[null,"Tons",0,22,{"$f":"+D42*C42/2000","v":0},90,{"$f":"+(E42*F42)","v":0}]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
[null,"Tons",null,0,0,0,0]
["Total Feed for Calves",null,null,null,{"$f":"SUM(E41:E47)","v":0},{"$f":"+G48/E48","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G41:G47)","v":0}]

{"sheet":"Vet","index":8,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[32,0,32,6],[1,7,1,10],[2,0,2,6],[12,0,12,6],[13,0,13,6],[23,0,23,6]]}
[]
[null,null,null,null,null,null,null,"Return to Main Page"]
["Veterinary Expenses for Cow Herd"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["IBR,BVD,5-way Lepto, Vibrio",2,{"$f":"+IF(B5=1,#REF!,IF(B5=2,#REF!,IF(B5=3,#REF!,IF(B5=4,#REF!,IF(B5=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,4,{"$f":"+F5*E5","v":4}]
["Deworm",1,{"$f":"+IF(B6=1,#REF!,IF(B6=2,#REF!,IF(B6=3,#REF!,IF(B6=4,#REF!,IF(B6=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,3,3]
["Delice",3,{"$f":"+IF(B7=1,#REF!,IF(B7=2,#REF!,IF(B7=3,#REF!,IF(B7=4,#REF!,IF(B7=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",2,2,4]
["Fly Tags",4,{"$f":"+IF(B8=1,#REF!,IF(B8=2,#REF!,IF(B8=3,#REF!,IF(B8=4,#REF!,IF(B8=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",2,0.5,1]
["Preg Check",5,{"$f":"+IF(B9=1,#REF!,IF(B9=2,#REF!,IF(B9=3,#REF!,IF(B9=4,#REF!,IF(B9=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,2,2]
["Other",5,{"$f":"+IF(B10=1,#REF!,IF(B10=2,#REF!,IF(B10=3,#REF!,IF(B10=4,#REF!,IF(B10=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,0,0]
["Total Vet Expenses for Cows",null,null,null,null,null,{"$f":"+SUM(G5:G9)","v":14}]
[]
[]
["Veterinary Expenses for Replacement Heifers"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["5-way Lepto",2,{"$f":"+IF(B16=1,#REF!,IF(B16=2,#REF!,IF(B16=3,#REF!,IF(B16=4,#REF!,IF(B16=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",2,2,{"$f":"+F16*E16","v":4}]
["Synchronization",1,{"$f":"+IF(B17=1,#REF!,IF(B17=2,#REF!,IF(B17=3,#REF!,IF(B17=4,#REF!,IF(B17=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",0,8,{"$f":"+F17*E17","v":0}]
[null,3,{"$f":"+IF(B18=1,#REF!,IF(B18=2,#REF!,IF(B18=3,#REF!,IF(B18=4,#REF!,IF(B18=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",0,1,{"$f":"+F18*E18","v":0}]
[null,4,{"$f":"+IF(B19=1,#REF!,IF(B19=2,#REF!,IF(B19=3,#REF!,IF(B19=4,#REF!,IF(B19=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",1,4,{"$f":"+F19*E19","v":4}]
[null,5,{"$f":"+IF(B20=1,#REF!,IF(B20=2,#REF!,IF(B20=3,#REF!,IF(B20=4,#REF!,IF(B20=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",null,null,{"$f":"+F20*E20","v":0}]
["Total Vet Expenses for Replacements",null,null,null,null,null,{"$f":"+SUM(G16:G20)","v":8}]
[]
[]
["Veterinary Expenses for Herd Bulls"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["IBR,BVD,5-way Lepto, Vibrio",2,{"$f":"+IF(B26=1,#REF!,IF(B26=2,#REF!,IF(B26=3,#REF!,IF(B26=4,#REF!,IF(B26=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",1,4,{"$f":"(+F26*E26*bulls)/cows","v":0.12}]
["Breeding Soundness Exam",1,{"$f":"+IF(B27=1,#REF!,IF(B27=2,#REF!,IF(B27=3,#REF!,IF(B27=4,#REF!,IF(B27=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",1,35,{"$f":"(+F27*E27*bulls)/cows","v":1.05}]
["Deworm",3,{"$f":"+IF(B28=1,#REF!,IF(B28=2,#REF!,IF(B28=3,#REF!,IF(B28=4,#REF!,IF(B28=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",2,3,{"$f":"(+F28*E28*bulls)/cows","v":0.18}]
["Delice",4,{"$f":"+IF(B29=1,#REF!,IF(B29=2,#REF!,IF(B29=3,#REF!,IF(B29=4,#REF!,IF(B29=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",1,2,{"$f":"(+F29*E29*bulls)/cows","v":0.06}]
[null,5,{"$f":"+IF(B30=1,#REF!,IF(B30=2,#REF!,IF(B30=3,#REF!,IF(B30=4,#REF!,IF(B30=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",null,null,{"$f":"(+F30*E30*bulls)/cows","v":0}]
["Total Vet Expenses for Bulls",null,null,null,null,null,{"$f":"+SUM(G26:G30)","v":1.41}]
[]
["Veterinary Expenses for Calves"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["Implant",2,{"$f":"+IF(B35=1,#REF!,IF(B35=2,#REF!,IF(B35=3,#REF!,IF(B35=4,#REF!,IF(B35=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",0,1,{"$f":"+F35*E35","v":0}]
["IBR,PI3,BVD,BRSV",1,{"$f":"+IF(B36=1,#REF!,IF(B36=2,#REF!,IF(B36=3,#REF!,IF(B36=4,#REF!,IF(B36=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",2,3,{"$f":"+F36*E36","v":6}]
[null,3,{"$f":"+IF(B37=1,#REF!,IF(B37=2,#REF!,IF(B37=3,#REF!,IF(B37=4,#REF!,IF(B37=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",0,1,{"$f":"+F37*E37","v":0}]
[null,4,{"$f":"+IF(B38=1,#REF!,IF(B38=2,#REF!,IF(B38=3,#REF!,IF(B38=4,#REF!,IF(B38=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",0,4,{"$f":"+F38*E38","v":0}]
[null,5,{"$f":"+IF(B39=1,#REF!,IF(B39=2,#REF!,IF(B39=3,#REF!,IF(B39=4,#REF!,IF(B39=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",null,null,{"$f":"+F39*E39","v":0}]
["Total Vet Expenses for Calves",null,null,null,null,null,{"$f":"+SUM(G35:G39)","v":6}]

{"sheet":"Auction","index":9,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,2],[5,0,5,2],[2,0,2,6],[2,7,2,9],[6,0,6,2],[9,0,9,2],[10,0,10,2],[7,0,7,2],[8,0,8,2]]}
[]
[]
["Auction & Hauling Cost Detail",null,null,null,null,null,null,"Return to Main Budget"]
[]
["     ITEM",null,null,"UNIT","QUANTITY","PRICE","AMOUNT"]
["Commission",null,null,"%",{"$f":"+Main!C103*Main!G103","v":784.96328625000035},0.03,{"$f":"+F6*E6","v":23.548898587500009}]
["Yardage",null,null,"Day",1,1,{"$f":"+F7*E7","v":1}]
["Hauling",null,null,"MILES",100,2.5,{"$f":"+(E8*F8)/24","v":10.416666666666666}]
["Checkoff",null,null,"Head",1,1,{"$f":"+F9*E9","v":1}]
["Other",null,null,"Head",1,1,{"$f":"+F10*E10","v":1}]
[]
["Total Auction & Hauling Cost",null,null,null,null,null,{"$f":"+SUM(G6:G10)","v":36.965565254166677}]

{"sheet":"Lvstk_Facil","index":10,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[12,1,12,2],[10,1,10,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[7,7,7,8],[4,1,4,2],[2,1,2,13],[5,1,5,2],[6,1,6,2],[24,1,24,2],[44,1,44,3],[32,1,32,3],[37,1,37,3],[33,1,33,3],[31,1,31,8],[27,1,27,3],[46,1,46,3],[35,1,35,3],[34,1,34,3],[38,1,38,3],[39,1,39,3],[42,1,42,3],[43,1,43,3]]}
[]
[]
[null,"INVESTMENT, ANNUAL FIXED COSTS, AND ANNUAL PAYMENTS"]
[null,null,null,null,null,null,null,null,null,""]
[null,"Return to Main Budget"]
[null,"Item",null,"Number","$/Unit","Total Cost","Salvage Value","Years of Useful Life","Annual Depreciation","Percent Financed","Amount Financed","Interest Rate","Years Financed","Annual Payment"]
[null,"LIVESTOCK"]
[null,"Raised Females",null,70,700,{"$f":"D8*E8","v":49000},{"$f":"+((cow_wt*cow_price)*(100%-cow_death))*D8","v":49048.999999999993},"No dep. on raised animals",null,0,{"$f":"+J8*F8","v":0},0.08,7,{"$f":"-PMT(L8,M8,K8)","v":0}]
[null,"Purchased Females",null,0,750,{"$f":"D9*E9","v":0},{"$f":"+((cow_wt*cow_price)*(100%-cow_death))*D9","v":0},{"$f":"1/cow_cull","v":6.666666666666667},{"$f":"+(F9-G9)/H9","v":0},0.5,{"$f":"+J9*F9","v":0},0.08,5,{"$f":"-PMT(L9,M9,K9)","v":0}]
[null,"Bulls",null,3,2500,{"$f":"D10*E10","v":7500},{"$f":"+(bull_wt*bull_price)*bulls","v":3240},{"$f":"1/bull_cull","v":4},{"$f":"+(F10-G10)/H10","v":1065},0.25,{"$f":"+J10*F10","v":1875},0.08,5,{"$f":"-PMT(L10,M10,K10)","v":469.60585231281863}]
[null,"TOTAL LIVESTOCK",null,null,null,{"$f":"+SUM(F8:F10)","v":56500},{"$f":"+SUM(G8:G10)","v":52288.999999999993},null,{"$f":"+SUM(I8:I10)","v":1065},null,{"$f":"+SUM(K8:K10)","v":1875},null,null,{"$f":"SUM(N8:N10)","v":469.60585231281863}]
[]
[null,"BUILDINGS & FACILITIES"]
[null,"Fences (Miles)",null,{"$f":"+(7379+9261+4174+2952+3704)/5280","v":5.2026515151515156},1925,{"$f":"+IF(D14<>0,(D14*E14),0)","v":10015.104166666668},0,30,{"$f":"+(F14-G14)/H14","v":333.8368055555556},0,{"$f":"+J14*F14","v":0},0.08,20,{"$f":"-PMT(L14,M14,K14)","v":0}]
[null,"Head Gate",null,1,400,{"$f":"+IF(D15<>0,(D15*E15),0)","v":400},0,10,{"$f":"F15/H15","v":40},0,0,0.08,20,0]
[null,"Chutes & Pens",null,1,8500,8500,{"$f":"+F16*0.2","v":1700},20,425,0,0,0.08,10,0]
[null,"Barn",null,1,15000,15000,3000,30,500,0,0,0.08,20,0]
[null,"Hay Racks",null,3,250,750,0,7,107.14285714285714,0,0,0.08,10,0]
[null,"Feed Troughs",null,6,150,900,180,15,60,0,0,0.08,10,0]
[null,"Miscellanous Equipment",null,1,1000,1000,200,20,50,0,0,0.08,15,0]
[null,"Other",null,0,null,0,0,15,0,0,0,0.08,10,0]
[null,"Other",null,0,"",0,0,15,0,0,0,0.08,10,0]
[null,"Other",null,0,"",0,0,20,0,0,0,0.08,15,0]
[null,"Other",null,null,"",0,0,5,0,0,0,0.08,5,0]
[null,"TOTAL BUILDINGS &  FACILITIES",null,null,null,{"$f":"+SUM(F14:F24)","v":36565.104166666672},{"$f":"+SUM(G14:G24)","v":5080},null,{"$f":"+SUM(I14:I24)","v":1515.9796626984128},null,{"$f":"+SUM(K14:K24)","v":0},null,null,{"$f":"+SUM(N14:N24)","v":0}]
[]
[]
[null,"LAND"]
[null,"LAND ",null,100,1500,{"$f":"+E29*D29","v":150000},0,null,0,0,{"$f":"+J29*F29","v":0},0.08,20,{"$f":"PMT(Lvstk_Facil!L29,Lvstk_Facil!M29,-K29)","v":0}]
[]
[]
[null,"TOTALS FOR FIXED COSTS"]
[null,"Average Raised Female Investment",null,null,{"$f":"+(F8+G8)/2","v":49024.5}]
[null,"Average Purchased Livestock Investment",null,null,{"$f":"+((F9+G9)/2)+((F10+G10)/2)","v":5370}]
[null,"Interest to Charge on Average Livestock Investment",null,null,0.08]
[null,"Total Livestock Fixed Cost",null,null,{"$f":"+(E33+E34)*livestock_facil_print+lvstk_dep","v":5416.56}]
[]
[null,"Average Buildings & Facilities Investment",null,null,{"$f":"+(F25+G25)/2","v":20822.552083333336}]
[null,"Interest on Average buildings & Facilities Investment",null,null,0.08,null,"",null,""]
[null,"Total Buildings & Facilities Fixed Cost",null,null,{"$f":"+(facil_int*facil_avginv)+build_dep","v":3181.7838293650793}]
[]
[null,null,null,"","","","",null,""]
[null,"Land Investment",null,null,{"$f":"+F29","v":150000}]
[null,"Interest on Land Investment",null,null,{"$f":"+land_int","v":0}]
[null,"Total Land Fixed Cost",null,null,{"$f":"+land_int*E43","v":0}]
[]
[null,"TOTAL ANNUAL FIXED COSTS",null,null,{"$f":"+lvstk_dep+build_dep+lvstk_fc+facil_fc+land_fc","v":11179.323492063493}]

{"sheet":"Equipment","index":11,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,0,29,2],[30,0,30,2],[1,0,1,15],[0,0,0,1],[23,0,23,2],[24,0,24,2],[25,0,25,2],[28,0,28,2]]}
["Return to Main"]
["DETAIL FOR EQUIPMENT USED IN COW-CALF AND HAY OPERATIONS"]
["Item","Cost","Salvage Value","Useful Life","Depreciation","% Used in Cow-Calf","%Used in Hay","Cow-Calf Avg Investment","Hay Investment","Cow-Calf Depreciation","Hay Depreciation","%Financed","Interest Rate","Years","Total Payment","% Cattle or Hay Payment"]
["75 hp Tractor-2wd",{"$f":"37000*0.5","v":18500},{"$f":"+B4*0.2","v":3700},8,{"$f":"+(B4-C4)/D4","v":1850},0.25,0.25,{"$f":"+((B4+C4)/2)*F4","v":2775},{"$f":"+((B4+C4)/2)*G4","v":2775},{"$f":"+F4*E4","v":462.5},{"$f":"+G4*E4","v":462.5},0,0.08,5,{"$f":"IF(L4>0,-PMT(M4,N4,(B4*L4)),0)","v":0},{"$f":"+O4*(F4+G4)","v":0}]
["130 hp Tractor-MFWD",79000,{"$f":"+B5*0.2","v":15800},8,{"$f":"+(B5-C5)/D5","v":7900},0.1,0.1,{"$f":"+((B5+C5)/2)*F5","v":4740},{"$f":"+((B5+C5)/2)*G5","v":4740},{"$f":"+F5*E5","v":790},{"$f":"+G5*E5","v":790},0.5,0.08,5,{"$f":"IF(L5>0,-PMT(M5,N5,(B5*L5)),0)","v":9893.0299553900459},{"$f":"+O5*(F5+G5)","v":1978.6059910780093}]
["Front-end loader w/spear",5500,1100,8,550,0.25,0.25,825,825,137.5,137.5,0,0.08,5,0,0]
["7' Rotary Mower",3500,700,8,{"$f":"+(B7-C7)/D7","v":350},0.25,0.25,525,525,{"$f":"+F7*E7","v":87.5},{"$f":"+G7*E7","v":87.5},0,0.08,5,0,{"$f":"+O7*(F7+G7)","v":0}]
["14' Disk Harrow",9250,1850,10,740,0.1,0,555,0,74,0,0,0.08,5,0,0]
["12' Grain Drill",{"$f":"11500*0.33","v":3795},759,8,379.5,0.1,0,227.70000000000002,0,37.950000000000003,0,0,0.08,5,0,0]
["8' Disc Mower",6500,1300,5,1040,0.2,0.8,780,3120,208,832,0,0.08,5,0,0]
["17' Double Hay Rake",2500,500,8,250,0,1,0,1500,0,250,0,0.08,5,0,0]
["17' Hay Tedder",4500,900,8,450,0,1,0,2700,0,450,0,0.08,5,0,0]
["20' Hay Trailer -2",2750,550,8,275,0.5,0.5,825,825,137.5,137.5,0,0.08,5,0,0]
["Large Round Baler",{"$f":"23000*0.667","v":15341},3068.2000000000003,5,{"$f":"+(B14-C14)/D14","v":2454.56},0,1,0,9204.6,{"$f":"+F14*E14","v":0},{"$f":"+G14*E14","v":2454.56},0.5,0.08,5,1921.12623475492,{"$f":"+O14*(F14+G14)","v":1921.12623475492}]
["Other 1",0,0,5,0,0,1,0,0,0,{"$f":"+G15*E15","v":0},0,0.08,5,0,{"$f":"+O15*(F15+G15)","v":0}]
["Other 2",0,0,5,0,0,1,0,0,0,0,0,0.08,5,0,0]
["Other 3",0,0,5,0,0,1,0,0,0,0,0,0.08,5,0,0]
["Other 4",0,0,5,0,0,1,0,0,0,0,0,0.08,5,0,0]
["Other 5",0,0,5,0,0,1,0,0,0,0,0,0.08,5,0,0]
["Other 6",0,0,5,0,0,1,0,0,0,0,0,0.08,5,0,0]
["Total",{"$f":"+SUM(B4:B20)","v":151136},{"$f":"+SUM(C4:C20)","v":30227.200000000001},null,{"$f":"+SUM(E4:E20)","v":16239.06},null,null,{"$f":"+SUM(H4:H20)","v":11252.7},{"$f":"+SUM(I4:I20)","v":26214.6},{"$f":"+SUM(J4:J20)","v":1934.95},{"$f":"+SUM(K4:K20)","v":5601.5599999999995},null,null,null,{"$f":"+SUM(O4:O20)","v":11814.156190144966},{"$f":"+SUM(P4:P20)","v":3899.7322258329295}]
[]
[]
["Average Cow Equipment Investment",null,null,{"$f":"+(cow_inv+cow_dep)/2","v":6593.8250000000007}]
["Interest rate on Average Investment",null,null,0.08]
["Interest on Average Cow Equipment Investment",null,null,{"$f":"+D25*D24","v":527.50600000000009}]
["Total Cow Equipment Fixed Costs",null,null,{"$f":"+D26+cow_dep","v":2462.4560000000001}]
[]
["Average Hay Equipment Investment",null,null,{"$f":"+(hay_inv+Hay_dep)/2","v":15908.079999999998}]
["Interest rate on Average Investment",null,null,0.08]
["Interest on Average Hay Equipment Investment",null,null,{"$f":"+D30*D29","v":1272.6463999999999}]
["Total Hay Equipment Fixed Costs",null,null,{"$f":"+D31+Hay_dep","v":6874.2063999999991}]

{"sheet":"Fixed_Cost","index":12,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[[8,1,8,2]]}
[]
[]
[null,"INVESTMENT AND ANNUAL FIXED COST"]
[null,"(Check All Entries This Page)"]
[]
[null,"                                        NO. OF C0WS:",null,null,null,null,null,{"$f":"+Main!H18","v":100}]
[null,"                                        INTEREST RATE:",null,null,null,null,null,0.09]
[]
[null,"     ITEM",null,"NUMBER","COST/HEAD","NEW COST","SALVAGE","YEARS","DEPR."]
[null,"COWS",null,60,700,{"$f":"D10*E10","v":42000},{"$f":"Main!H27*Main!H28*D10","v":42900},{"$f":"1/Main!H20","v":6.666666666666667},{"$f":"+(F10-G10)/H10","v":-135}]
[null,"Purchased HEIFERS",null,0,850,{"$f":"D11*E11","v":0},0,6,{"$f":"+(F11-G11)/H11","v":0}]
[null,"BULLS",null,{"$f":"+Main!H29","v":3},1500,{"$f":"D12*E12","v":4500},{"$f":"+(Main!H31*Main!H32)*Main!H29","v":3240},4,315]
[]
[]
[]
[]
[null,"CORRAL & LOADING CHUTE",null,null,null,1200,0,10,120]
[null,"FENCE (MI.)",null,2.5,1800,{"$f":"D18*E18","v":4500},0,15,300]
[null,"FEED RACKS",null,null,null,800,0,10,80]
[null,"MISC. EQUIPMENT",null,null,null,500,0,5,100]
[]
[null,"TOTAL INVESTMENT & DEPRECIATION",null,null,null,{"$f":"SUM(F10:F20)","v":53500},{"$f":"SUM(G10:G20)","v":46140},null,{"$f":"SUM(I12:I20)","v":915}]
[]
[null,"INTEREST ON INVESTMENT (AVE. INV. TIMES INT. RATE)",null,null,null,null,null,null,{"$f":"(F22+G22)/2*H7","v":4483.8}]
[]
[null,"TAXES AND INSURANCE",null,null,null,null,1.4E-2,null,{"$f":"(F22+G22)/2*G26","v":697.48}]
[]
[null,"TOTAL ANNUAL FIXED COST",null,null,null,null,null,null,{"$f":"SUM(I22:I26)","v":6096.2800000000007}]
[]
[null,"TOTAL ANNUAL FIXED COST PER BROOD COW",null,null,null,null,null,null,{"$f":"I28/H6","v":60.962800000000009}]

{"sheet":"Fixed_Payment","index":13,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"ANNUAL ENTERPRISE FIXED PAYMENTS"]
[null," (Check All Entries This Page)"]
[]
[null,null,null,null,"NO. OF ACRES:",null,{"$f":"+Main!F47+Main!F48+Main!F50","v":125}]
[null,null,null,null,"NO. OF COWS:",null,{"$f":"+Main!H18","v":100}]
[]
[null,"DEBT PAYMENT CALCULATION ON NEW INVESTMENT:"]
[null,"(For Use In Calculating Fixed Cash Outlays on New Investment)"]
[]
[null,null,null,"","UNIT","TOTAL","    ----FINANCING----"]
[null,"ITEM",null,"NUMBER","COST","COST","AMOUNT","YEARS","INT.RATE","PAYMENT"]
[null,"COWS",null,100,500,{"$f":"D14*E14","v":50000},0.5,7,0.11,{"$f":"PMT(I14,H14,-F14*G14)","v":5305.3817362524424}]
[null,"HEIFERS",null,20,400,{"$f":"D15*E15","v":8000},0.5,7,0.11,{"$f":"PMT(I15,H15,-F15*G15)","v":848.86107780039072}]
[null,"BULLS",null,3,1500,{"$f":"D16*E16","v":4500},0.5,7,0.11,477.48435626271976]
[null,"FENCE (MI.)",null,2.5,1800,{"$f":"D17*E17","v":4500},0.5,7,0.11,477.48435626271976]
[null,"CORRAL & LOADING CHUTE",null,null,null,1200,0.5,7,0.11,127.32916167005862]
[null,"FEED RACKS",null,null,null,800,0.5,7,0.11,84.886107780039069]
[null,"MISC. EQUIP.",null,null,"",500,0.5,7,0.11,53.05381736252442]
[null,null,null,null,"","","","",""]
[null,"LAND",null,0,500,{"$f":"D22*E22","v":0},1,30,0.1,{"$f":"PMT(I22,H22,-F22*G22)","v":0}]
[null,null,null,null,null,"","","",""]
[]
[]
[null,"CURRENT ANNUAL DEBT PAYMENTS:"]
[null,"(For Use In Totaling Debt Payments on Existing Investment)"]
[]
[null,"LOAN # 1",null,null,null,null,null,null,null,0]
[null,"LOAN # 2",null,null,null,null,null,null,null,0]
[null,"LOAN # 3",null,null,null,null,null,null,null,0]
[null,"LOAN # 4",null,null,null,null,null,null,null,0]
[null,"LOAN # 5",null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,"TOTAL ANNUAL DEBT PAYMENT",null,null,null,null,{"$f":"SUM(J14:J34)","v":7374.4806133908951}]
[null,null,null,null,"TAXES AND INSURANCE",null,null,null,null,{"$f":"+Fixed_Cost!I26","v":697.48}]
[]
[]
[null,null,null,null,"TOTAL ANNUAL FIXED OUTLAY",null,null,null,null,{"$f":"SUM(J37:J38)","v":8071.9606133908947}]
[null,null,null,null,"TOTAL ANNUAL FIXED PAYMENT PER COW",null,null,null,null,{"$f":"J41/G7","v":80.71960613390894}]

{"sheet":"J","index":14,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,-8941.9831759052358,2.2750092654188533E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-6741.1663194289249,6.6807279375848599E-2]
[1,null,null,null,null,null,null,null,null,null,null,null,null,-4540.349462952614,0.15865531316113057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-3439.9410347144585,0.22662732264844102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-2339.5326064763035,0.3085375586179277]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1239.1241782381483,0.40129373468325191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-138.71574999999302,0.49999999977461573]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-138.71574999999302,0.49999999977461573]
[null,null,null,null,null,null,null,null,null,null,null,null,null,961.69267823816199,0.59870626531674809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2062.101106476317,0.69146244138207225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3162.509534714472,0.77337267735155901]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4262.917962952627,0.84134468683886943]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6463.734819428937,0.93319272062415137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8664.551675905248,0.97724990734581152]

{"sheet":"K","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"L","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"M","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"N","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"O","index":19,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[1,1]
[0]