{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Income & Expense","Forage Cost Survey","Balance Sheet ","Dairy Benchmarks Reports ","Scorecard","Data","Hide"],"not_rendered":{"charts":0,"images":43,"macros":1,"external_links":0,"defined_names":24,"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Income & Expense","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[13,1,13,5]]}
["Production Year ",2020,null,null,null,null,null,null,null,null,"Farm Code "]
[null,"Annual Pounds Sold","Number of Cows ","Average Pounds",null,null,null,null,null,null,"State "]
["Milk Production",null,null,{"$f":"B3/C3","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"Hide!C71","v":"Predominate breed "}]
[]
["Income","Total ","Per Cow","Per Cwt."]
["Calves & Heifers ",null,{"$f":"IF(B6>0,B6/$C$3,\" \")","v":" "},{"$f":"IF(B6>0,B6/$B$3*100,\" \")","v":" "}]
["Crops ",null," "," "]
["Cull Income",null," "," "]
["Dividends ",null," "," "]
["Government Payments",null," "," "]
["Milk",null," "," "]
["Other Income",null," "," "]
["Gross Farm Income",{"$f":"SUM(B6:B12)","v":0},{"$f":"SUM(C6:C12)","v":0},{"$f":"SUM(D6:D12)","v":0}]
[]
["Variable Expense","Total ","Per Cow","Per Cwt.","Percent Per CWT Milk","Percent Per CWT Gross "]
["Animal Health ",null,{"$f":"IF(B16>0,B16/$C$3,\" \")","v":" "},{"$f":"IF(B16>0,B16/$B$3*100,\" \")","v":" "},{"$f":"IF(B16>0,D16/$D$11,\" \")","v":" "},{"$f":"IF(B16>0,D16/$D$13,\" \")","v":" "}]
["Bedding",null,{"$f":"IF(B17>0,B17/$C$3,\" \")","v":" "},{"$f":"IF(B17>0,B17/$B$3*100,\" \")","v":" "},{"$f":"IF(B17>0,D17/$D$11,\" \")","v":" "},{"$f":"IF(B17>0,D17/$D$13,\" \")","v":" "}]
["Breeding",null," "," "," "," "]
["Chemicals",null," "," "," "," "]
["Crop Insurance ",null," "," "," "," "]
["Custom Hired ",null," "," "," "," "]
["Feed",null," "," "," "," "]
["Fertilizer",null," "," "," "," "]
["Fuel & Oil",null," "," "," "," "]
["Insurance",null," "," "," "," "]
["Interest",null," "," "," "," "]
["Labor",null," "," "," "," "]
["Machinery Lease ",null,{"$f":"IF(B28>0,B28/$C$3,\" \")","v":" "},{"$f":"IF(B28>0,B28/$B$3*100,\" \")","v":" "}," ",{"$f":"IF(B28>0,D28/$D$13,\" \")","v":" "}]
["Milk Hauling",null,{"$f":"IF(B29>0,B29/$C$3,\" \")","v":" "},{"$f":"IF(B29>0,B29/$B$3*100,\" \")","v":" "}," ",{"$f":"IF(B29>0,D29/$D$13,\" \")","v":" "}]
["Milk Marketing ",null," "," "," "," "]
["Milk Testing ",null," "," "," "," "]
["Other Expenses ",null," "," "," "," "]
["Professional Fees ",null," "," "," "," "]
["Rent",null,{"$f":"IF(B34>0,B34/$C$3,\" \")","v":" "},{"$f":"IF(B34>0,B34/$B$3*100,\" \")","v":" "}," ",{"$f":"IF(B34>0,D34/$D$13,\" \")","v":" "}]
["Repairs",null," "," "," "," "]
["Seed",null," "," "," "," "]
["Supplies",null," "," "," "," "]
["Taxes (Property, Auto) ",null,{"$f":"IF(B38>0,B38/$C$3,\" \")","v":" "},{"$f":"IF(B38>0,B38/$B$3*100,\" \")","v":" "},{"$f":"IF(B38>0,D38/$D$11,\" \")","v":" "},{"$f":"IF(B38>0,D38/$D$13,\" \")","v":" "}]
["Utilities",null," "," "," "," "]
["Total Cash Farm Expense",{"$f":"SUM(B16:B39)","v":0},{"$f":"B40/$C$3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D16:D39)","v":0}," ",{"$f":"D40/$D$13","v":{"$error":"#DIV/0!"}}]
["Net Farm Income From Operations ",{"$f":"B13-B40","v":0},{"$f":"B41/$C$3","v":{"$error":"#DIV/0!"}},{"$f":"IF(B41>0,B41/$B$3*100,\" \")","v":" "},null,{"$f":"D41/$D$13","v":{"$error":"#VALUE!"}}]
["Fixed Cost "]
["Principle Payments ",null,{"$f":"IF(B43>0,B43/$C$3,\" \")","v":" "},{"$f":"IF(B43>0,B43/$B$3*100,\" \")","v":" "},{"$f":"IF(B43>0,D43/$D$11,\" \")","v":" "},{"$f":"IF(B43>0,D43/$D$13,\" \")","v":" "}]
["Depreciation ",null,{"$f":"IF(B44>0,B44/$C$3,\" \")","v":" "},{"$f":"IF(B44>0,B44/$B$3*100,\" \")","v":" "},{"$f":"IF(B44>0,D44/$D$11,\" \")","v":" "},{"$f":"IF(B44>0,D44/$D$13,\" \")","v":" "}]
["Livestock purchased (Cash Exp.)",null,{"$f":"IF(B45>0,B45/$C$3,\" \")","v":" "},{"$f":"IF(B45>0,B45/$B$3*100,\" \")","v":" "},{"$f":"IF(B45>0,D45/$D$11,\" \")","v":" "},{"$f":"IF(B45>0,D45/$D$13,\" \")","v":" "}]
["Equipment purchased (Cash Exp.)",null," "," "," "," "]
["Other Assets purchased (Cash Exp.)",null," "," "," "," "]
["Family Living ",null," "," "," "," "]
["Total Fixed Cost ",{"$f":"SUM(B43:B48)","v":0},{"$f":"SUM(C43:C48)","v":0},{"$f":"SUM(D43:D48)","v":0}]
["Total Cost ",{"$f":"B40+B49","v":0},{"$f":"C40+C49","v":{"$error":"#DIV/0!"}},0]
["Net Farm Cash Flow ",{"$f":"B41-B49","v":0},{"$f":"C41-C49","v":{"$error":"#DIV/0!"}},{"$f":"D41-D49","v":{"$error":"#VALUE!"}}]

{"sheet":"Forage Cost Survey","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Forage Cost  Survey "]
["Variable Expense","Percent Used for Forage","Total ","Per Cow","Per Cwt."]
["Chemicals",null,{"$f":"B4*'Income & Expense'!B19","v":0},{"$f":"C4/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C4/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Crop Insurance ",null,{"$f":"B5*'Income & Expense'!B20","v":0},{"$f":"C5/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C5/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Custom Hired ",null,{"$f":"B6*'Income & Expense'!B21","v":0},{"$f":"C6/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C6/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Fertilizer",null,{"$f":"B7*'Income & Expense'!B23","v":0},{"$f":"C7/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C7/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Fuel & Oil",null,{"$f":"B8*'Income & Expense'!B24","v":0},{"$f":"C8/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C8/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Labor",null,{"$f":"B9*'Income & Expense'!B27","v":0},{"$f":"C9/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C9/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Machinery Lease ",null,{"$f":"B10*'Income & Expense'!B28","v":0},{"$f":"C10/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C10/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Rent",null,{"$f":"B11*'Income & Expense'!B34","v":0},{"$f":"C11/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C11/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Repairs",null,{"$f":"B12*'Income & Expense'!B35","v":0},{"$f":"C12/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C12/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Seed",null,{"$f":"B13*'Income & Expense'!B36","v":0},{"$f":"C13/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C13/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
["Supplies",null,{"$f":"B14*'Income & Expense'!B37","v":0},{"$f":"C14/'Income & Expense'!$C$3","v":{"$error":"#DIV/0!"}},{"$f":"C14/'Income & Expense'!$B$3*100","v":{"$error":"#DIV/0!"}}]
[null,"Total",{"$f":"SUM(C4:C14)","v":0},{"$f":"SUM(D4:D14)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E4:E14)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Balance Sheet ","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Balance Sheet "]
[]
[null,"Current Assets",null,null,"Current Liabilities "]
[null,"Intermediate Assets ",null,null,"Intermediate  Liabilities "]
[null,"Long-Term Assets ",null,null,"Long-Term  Liabilities  "]
[]
[null,"Total Assets ",{"$f":"SUM(C4:C6)","v":0},null,"Total Liabilities ",{"$f":"SUM(F4:F6)","v":0}]
[]
[null,null,null,null,"Net Worth ",{"$f":"C8-F8","v":0}]
[]
[null,"Total Operator Management Fee "]

{"sheet":"Dairy Benchmarks Reports ","index":4,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,1,7,5],[28,15,28,23],[0,7,0,15]]}
[null,null,null,null,null,null,null,"Farm Quick Facts"]
[null,null,null,null,null,null,null,null,null,null,"Total Milk Production ",null,{"$f":"'Income & Expense'!B3","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total Cows",null,{"$f":"'Income & Expense'!C3","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Average Pounds",null,{"$f":"'Income & Expense'!D3","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,"Income ",null,null,null,null,"Variable Expense"]
[null,"Production Year:",{"$f":"IF('Income & Expense'!B1>0,'Income & Expense'!B1,\" \")","v":2020},null,null,null,null,"Gross Farm Income ",null,null,{"$f":"'Income & Expense'!B13","v":0},null,"Total Cash Expense ",null,null,{"$f":"'Income & Expense'!B40","v":0}]
[null,"Balance Sheet ",null,null,null,null,null,"Income Per Cow ",null,null,{"$f":"'Income & Expense'!C13","v":0},null,"Cash Expense Per Cow",null,null,{"$f":"'Income & Expense'!C40","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Balance Sheet '!B4","v":"Current Assets"},{"$f":"'Balance Sheet '!C4","v":0},null,{"$f":"'Balance Sheet '!E4","v":"Current Liabilities "},{"$f":"'Balance Sheet '!F4","v":0},null,"Milk Income Per CWT ",null,null,{"$f":"'Income & Expense'!D11","v":" "},null,"Total Cash Expense Per CWT",null,null,{"$f":"'Income & Expense'!D40","v":0}]
[null,{"$f":"'Balance Sheet '!B5","v":"Intermediate Assets "},{"$f":"'Balance Sheet '!C5","v":0},null,{"$f":"'Balance Sheet '!E5","v":"Intermediate  Liabilities "},{"$f":"'Balance Sheet '!F5","v":0},null,"Total Income Per CWT",null,null,{"$f":"'Income & Expense'!D13","v":0}]
[null,{"$f":"'Balance Sheet '!B6","v":"Long-Term Assets "},{"$f":"'Balance Sheet '!C6","v":0},null,{"$f":"'Balance Sheet '!E6","v":"Long-Term  Liabilities  "},{"$f":"'Balance Sheet '!F6","v":0}]
[null,null,null,null,null,null,null,"Net Farm Income ",null,null,null,null,"Fixed Cost "]
[null,{"$f":"'Balance Sheet '!B8","v":"Total Assets "},{"$f":"'Balance Sheet '!C8","v":0},null,{"$f":"'Balance Sheet '!E8","v":"Total Liabilities "},{"$f":"'Balance Sheet '!F8","v":0},null,"Net Farm Income From Operations ",null,null,{"$f":"'Income & Expense'!B41","v":0},null,"Total Fixed Cost Paid ",null,null,{"$f":"'Income & Expense'!B49","v":0}]
[null,null,null,null,null,null,null,"NFIFO Per Cow ",null,null,{"$f":"'Income & Expense'!C41","v":{"$error":"#DIV/0!"}},null,"Fixed Cost Per Cow ",null,null,{"$f":"'Income & Expense'!C49","v":0}]
[null,null,null,null,{"$f":"'Balance Sheet '!E10","v":"Net Worth "},{"$f":"'Balance Sheet '!F10","v":0},null,"NFIFO Per CWT",null,null,{"$f":"'Income & Expense'!D41","v":" "},null,"Fixed Cost Per CWT",null,null,{"$f":"'Income & Expense'!D49","v":0}]
[]
[null,null,null,null,null,null,null,"Cash Flow ",null,null,null,null,"Total Cost "]
[null,null,null,null,null,null,null,"Net Cash Flow ",null,null,{"$f":"'Income & Expense'!B51","v":0},null,"Total Cost ",null,null,{"$f":"'Income & Expense'!B50","v":0}]
[null,null,null,null,null,null,null,"Net Cash Flow Per Cow",null,null,{"$f":"'Income & Expense'!C51","v":{"$error":"#DIV/0!"}},null,"Total Cost Per Cow ",null,null,{"$f":"'Income & Expense'!C50","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Net Cash Flow Per CWT",null,null,{"$f":"'Income & Expense'!D51","v":{"$error":"#VALUE!"}},null,"Total Cost Per CWT",null,null,{"$f":"'Income & Expense'!D50","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* All Ratios calculated using latest balance sheet information not yearly averages "]

{"sheet":"Scorecard","index":5,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,5],[34,7,34,9],[2,13,2,17],[2,7,2,11],[18,7,18,11],[22,7,22,9]]}
[]
[null,"Production Year:",null,{"$f":"IF('Income & Expense'!B1>0,'Income & Expense'!B1,\" \")","v":2020}]
[null,"Balance Sheet Benchmarks ",null,null,null,null,null,"Feed Benchmarks",null,null,null,null,null,"Income & Expense Benchmarks "]
[]
[null,"Debt Per Cow: Goal- Less than $5,000 Per Cow",null,null,null,null,null,"Purchased Feed Cost (Percent of  Total Income): Goal - Less than 45%",null,null,null,null,null,"Income Per Cow: Goal - Greater than $5,000"]
[null,{"$f":"IF(Hide!$D$50<5000,Hide!$D$50,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$50>5000,Hide!$D$50<10000),+Hide!$D$50,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$50>10000,Hide!$D$50,\" \")","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(Hide!$D$9<0.45,Hide!$D$9,\" \")","v":" "},{"$f":"IF(AND(Hide!$D$9>0.499,Hide!$D$9<0.45),+Hide!$D$9,\" \")","v":" "},{"$f":"IF(Hide!$D$9>0.499,Hide!$D$9,\" \")","v":" "},null,null,null,{"$f":"IF(Hide!$D$24>4999.5,Hide!$D$24,\" \")","v":" "},{"$f":"IF(AND(Hide!$D$24>4500,Hide!$D$24<4999.5),+Hide!$D$24,\" \")","v":" "},{"$f":"IF(Hide!$D$24<4500,Hide!$D$24,\" \")","v":0}]
[null,"Less than $5,000","$5,000 - $10,000","Greater than $10,000",null,null,null,"Less than 45%","45% - 50%","Greater than 50%",null,null,null,"Greater than $5,000 ","$5,000 - $4,500","Less than $4,500"]
[]
[null,"Total Investment Per Cow: Goal - $7,500 to $15,000",null,null,null,null,null,"Total Feed Cost ( Percent of Milk Income): Goal - Less than 60%",null,null,null,null,null,"Livestock Expenses: Goal - Less Than 4%"]
[null,{"$f":"IF(Hide!$D$52<15000,Hide!$D$52,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$52>15000,Hide!$D$52<20000),+Hide!$D$52,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$52>20000,Hide!$D$52,\" \")","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(Hide!$D$11<0.595,Hide!$D$11,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$11>0.595,Hide!$D$11<0.651),+Hide!$D$11,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$11>0.651,Hide!$D$11,\" \")","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(Hide!$D$26<0.04,Hide!$D$26,\" \")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Hide!$D$26>0.04,Hide!$D$26<0.55),+Hide!$D$26,\" \")","v":{"$error":"#VALUE!"}},{"$f":"IF(Hide!$D$26>0.055,Hide!$D$26,\" \")","v":{"$error":"#VALUE!"}}]
[null,"Less than $15,000","$15,000 - $20,000","Greater than $20,000",null,null,null,"Less than 60%","60% - 65%","Greater than 65%",null,null,null,"Less than 4%","4% - 5.5%","Greater than 5.5%"]
[]
[null,"Asset Turnover Ratio: Goal- Greater than 35%",null,null,null,null,null,"Milk Income Over Feed Cost %: Goal - Greater than 40%",null,null,null,null,null,"Operation Cost (As a Percentage of Gross Income): Goal - Less than 80% "]
[null,{"$f":"IF(Hide!$D$54>0.35,Hide!$D$54,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$54>0.25,Hide!$D$54<0.35),+Hide!$D$54,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$54<0.25,Hide!$D$54,\" \")","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(Hide!$D$14>0.395,Hide!$D$14,\" \")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Hide!$D$14<0.395,Hide!$D$14>0.351),+Hide!$D$14,\" \")","v":{"$error":"#VALUE!"}},{"$f":"IF(Hide!$D$14<0.351,Hide!$D$14,\" \")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(Hide!$D$28<0.8,Hide!$D$28,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$28<0.855,Hide!$D$28>0.8),+Hide!$D$28,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$28>0.855,Hide!$D$28,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"Greater than 35%","35% - 25%","Less than 25%",null,null,null,"Greater than 40%","40% - 35%","Less than 35%",null,null,null,"Less than 80%","80% - 85%","Greater than 85%"]
[]
[null,"Current Ratio: Goal - Greater than 1.5",null,null,null,null,null,null,null,null,null,null,null,"Net Farm Income Ratio: Goal - Greater than 20%"]
[null,{"$f":"IF(Hide!$D$56>1.49,Hide!$D$56,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$56>0.9999,Hide!$D$56<1.49),+Hide!$D$56,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$56<0.9999,Hide!$D$56,\" \")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(Hide!$D$30>0.2,Hide!$D$30,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$30>0.145,Hide!$D$30<0.2),+Hide!$D$30,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$30<0.145,Hide!$D$30,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"Greater than 1.5","1.5-1","Less than 1",null,null,null,null,null,null,null,null,null,"Greater than 20%","20% - 15%","Less than 15%"]
[]
[null,"Debt to Asset Ratio: Goal - Less than 40%",null,null,null,null,null,null,null,null,null,null,null,"Labor Expense: Goal - Less than 15%"]
[null,{"$f":"IF(Hide!$D$59<0.4,Hide!$D$59,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$59>0.4,Hide!$D$59<0.6),+Hide!$D$59,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$59>0.6,Hide!$D$59,\" \")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(Hide!$D$32<0.15,Hide!$D$32,\" \")","v":" "},{"$f":"IF(AND(Hide!$D$32>0.15,Hide!$D$32<0.2),+Hide!$D$32,\" \")","v":" "},{"$f":"IF(Hide!$D$32>0.2,Hide!$D$32,\" \")","v":" "}]
[null,"Less than 40%","40% - 60%","Greater than 60%",null,null,null,null,null,null,null,null,null,"Less than 15%","15% - 20%","Greater than 20%"]
[]
[null,"Debt to Equity Ratio: Goal - Less than 50%",null,null,null,null,null,null,null,null,null,null,null,"Interest Expense Ratio: Goal - Less than 5%  "]
[null,{"$f":"IF(Hide!$D$61<0.4999,Hide!$D$61,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$61>0.4999,Hide!$D$61<1.5),+Hide!$D$61,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$61>1.5,Hide!$D$61,\" \")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(Hide!$D$34<0.05,Hide!$D$34,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$34<0.1,Hide!$D$34>0.05),+Hide!$D$34,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$34>0.1,Hide!$D$34,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"Less than 50%","50%-150%","Greater than 150%",null,null,null,null,null,null,null,null,null,"Less than 5%","5% - 10%","Greater than 10%"]
[]
[null,"Rate of Return on Farm Assets (ROA): Goal - Greater than 5%"]
[null,{"$f":"IF(Hide!$D$63>0.04999,Hide!$D$63,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$63>0.00999,Hide!$D$63<0.049999),+Hide!$D$63,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$63<0.00999,Hide!$D$63,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"Greater than 5%","5%-1%","Less than 1%"]
[]
[null,"Operating Profit Margin: Goal - Greater than 25%"]
[null,{"$f":"IF(Hide!$D$65>0.2499,Hide!$D$65,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Hide!$D$65>0.1499,Hide!$D$65<0.2499),+Hide!$D$65,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Hide!$D$65<0.1499,Hide!$D$65,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"Greater than 25%","25% - 15%","Less than 15%"]

{"sheet":"Data","index":6,"n_rows":281,"n_cols":4,"rows_kept":281,"cut":false,"hidden":true,"merged":[]}
["Page","Line","Unit","Data "]
["Income & Expense ","Farm Code",null,{"$f":"'Income & Expense'!L1","v":0}]
[null,"State ",null,{"$f":"'Income & Expense'!L2","v":0}]
[null,"Year",null,{"$f":"'Income & Expense'!B1","v":2020}]
[null,{"$f":"'Income & Expense'!K3","v":"Predominate breed "},null,{"$f":"'Income & Expense'!L3","v":0}]
[null,"Annual Pounds Sold","lbs",{"$f":"'Income & Expense'!B3","v":0}]
[null,"Number of Cows ","cows ",{"$f":"'Income & Expense'!C3","v":0}]
[null,"Average Pounds","Per Cow",{"$f":"'Income & Expense'!D3","v":{"$error":"#DIV/0!"}}]
[null,"Calves & Heifers ","Total",{"$f":"'Income & Expense'!B6","v":0}]
[null,"Crops ","Total",{"$f":"'Income & Expense'!B7","v":0}]
[null,"Cull income ","Total",{"$f":"'Income & Expense'!B8","v":0}]
[null,"Dividends ","Total",{"$f":"'Income & Expense'!B9","v":0}]
[null,"Government Payments","Total",{"$f":"'Income & Expense'!B10","v":0}]
[null,"Milk","Total",{"$f":"'Income & Expense'!B11","v":0}]
[null,"Other Income","Total",{"$f":"'Income & Expense'!B12","v":0}]
[null,"Gross Farm Income","Total",{"$f":"'Income & Expense'!B13","v":0}]
[null,"Calves & Heifers ","Per Cow",{"$f":"'Income & Expense'!C6","v":" "}]
[null,"Crops ","Per Cow",{"$f":"'Income & Expense'!C7","v":" "}]
[null,"Cull income ","Per Cow",{"$f":"'Income & Expense'!C8","v":" "}]
[null,"Dividends ","Per Cow",{"$f":"'Income & Expense'!C9","v":" "}]
[null,"Government Payments","Per Cow",{"$f":"'Income & Expense'!C10","v":" "}]
[null,"Milk","Per Cow",{"$f":"'Income & Expense'!C11","v":" "}]
[null,"Other Income","Per Cow",{"$f":"'Income & Expense'!C12","v":" "}]
[null,"Gross Farm Income","Per Cow",{"$f":"'Income & Expense'!C13","v":0}]
[null,"Calves & Heifers ","Per CWT",{"$f":"'Income & Expense'!D6","v":" "}]
[null,"Crops ","Per CWT",{"$f":"'Income & Expense'!D7","v":" "}]
[null,"Cull  income ","Per CWT",{"$f":"'Income & Expense'!D8","v":" "}]
[null,"Dividends ","Per CWT",{"$f":"'Income & Expense'!D9","v":" "}]
[null,"Government Payments","Per CWT",{"$f":"'Income & Expense'!D10","v":" "}]
[null,"Milk","Per CWT",{"$f":"'Income & Expense'!D11","v":" "}]
[null,"Other Income","Per CWT",{"$f":"'Income & Expense'!D12","v":" "}]
[null,"Gross Farm Income","Per CWT",{"$f":"'Income & Expense'!D13","v":0}]
[null,"Animal Health ","Total",{"$f":"'Income & Expense'!B16","v":0}]
[null,"Bedding","Total",{"$f":"'Income & Expense'!B17","v":0}]
[null,"Breeding","Total",{"$f":"'Income & Expense'!B18","v":0}]
[null,"Chemicals","Total",{"$f":"'Income & Expense'!B19","v":0}]
[null,"Crop Insurance ","Total",{"$f":"'Income & Expense'!B20","v":0}]
[null,"Custom Hired ","Total",{"$f":"'Income & Expense'!B21","v":0}]
[null,"Feed","Total",{"$f":"'Income & Expense'!B22","v":0}]
[null,"Fertilizer","Total",{"$f":"'Income & Expense'!B23","v":0}]
[null,"Fuel & Oil","Total",{"$f":"'Income & Expense'!B24","v":0}]
[null,"Insurance","Total",{"$f":"'Income & Expense'!B25","v":0}]
[null,"Interest","Total",{"$f":"'Income & Expense'!B26","v":0}]
[null,"Labor","Total",{"$f":"'Income & Expense'!B27","v":0}]
[null,"Machinery Lease ","Total",{"$f":"'Income & Expense'!B28","v":0}]
[null,"Milk Hauling","Total",{"$f":"'Income & Expense'!B29","v":0}]
[null,"Milk Marketing ","Total",{"$f":"'Income & Expense'!B30","v":0}]
[null,"Milk Testing ","Total",{"$f":"'Income & Expense'!B31","v":0}]
[null,"Other Expenses ","Total",{"$f":"'Income & Expense'!B32","v":0}]
[null,"Professional Fees ","Total",{"$f":"'Income & Expense'!B33","v":0}]
[null,"Rent","Total",{"$f":"'Income & Expense'!B34","v":0}]
[null,"Repairs","Total",{"$f":"'Income & Expense'!B35","v":0}]
[null,"Seed","Total",{"$f":"'Income & Expense'!B36","v":0}]
[null,"Supplies","Total",{"$f":"'Income & Expense'!B37","v":0}]
[null,"Taxes (Property, Auto) ","Total",{"$f":"'Income & Expense'!B38","v":0}]
[null,"Utilities","Total",{"$f":"'Income & Expense'!B39","v":0}]
[null,"Total Cash Farm Expense","Total",{"$f":"'Income & Expense'!B40","v":0}]
[null,"Net Farm Income From Operations ","Total",{"$f":"'Income & Expense'!B41","v":0}]
[null,"Animal Health ","Per Cow",{"$f":"'Income & Expense'!C16","v":" "}]
[null,"Bedding","Per Cow",{"$f":"'Income & Expense'!C17","v":" "}]
[null,"Breeding","Per Cow",{"$f":"'Income & Expense'!C18","v":" "}]
[null,"Chemicals","Per Cow",{"$f":"'Income & Expense'!C19","v":" "}]
[null,"Crop Insurance ","Per Cow",{"$f":"'Income & Expense'!C20","v":" "}]
[null,"Custom Hired ","Per Cow",{"$f":"'Income & Expense'!C21","v":" "}]
[null,"Feed","Per Cow",{"$f":"'Income & Expense'!C22","v":" "}]
[null,"Fertilizer","Per Cow",{"$f":"'Income & Expense'!C23","v":" "}]
[null,"Fuel & Oil","Per Cow",{"$f":"'Income & Expense'!C24","v":" "}]
[null,"Insurance","Per Cow",{"$f":"'Income & Expense'!C25","v":" "}]
[null,"Interest","Per Cow",{"$f":"'Income & Expense'!C26","v":" "}]
[null,"Labor","Per Cow",{"$f":"'Income & Expense'!C27","v":" "}]
[null,"Machinery Lease ","Per Cow",{"$f":"'Income & Expense'!C28","v":" "}]
[null,"Milk Hauling","Per Cow",{"$f":"'Income & Expense'!C29","v":" "}]
[null,"Milk Marketing ","Per Cow",{"$f":"'Income & Expense'!C30","v":" "}]
[null,"Milk Testing ","Per Cow",{"$f":"'Income & Expense'!C31","v":" "}]
[null,"Other Expenses ","Per Cow",{"$f":"'Income & Expense'!C32","v":" "}]
[null,"Professional Fees ","Per Cow",{"$f":"'Income & Expense'!C33","v":" "}]
[null,"Rent","Per Cow",{"$f":"'Income & Expense'!C34","v":" "}]
[null,"Repairs","Per Cow",{"$f":"'Income & Expense'!C35","v":" "}]
[null,"Seed","Per Cow",{"$f":"'Income & Expense'!C36","v":" "}]
[null,"Supplies","Per Cow",{"$f":"'Income & Expense'!C37","v":" "}]
[null,"Taxes (Property, Auto) ","Per Cow",{"$f":"'Income & Expense'!C38","v":" "}]
[null,"Utilities","Per Cow",{"$f":"'Income & Expense'!C39","v":" "}]
[null,"Total Cash Farm Expense","Per Cow",{"$f":"'Income & Expense'!C40","v":{"$error":"#DIV/0!"}}]
[null,"Net Farm Income From Operations ","Per Cow",{"$f":"'Income & Expense'!C41","v":{"$error":"#DIV/0!"}}]
[null,"Animal Health ","Per CWT",{"$f":"'Income & Expense'!D16","v":" "}]
[null,"Bedding","Per CWT",{"$f":"'Income & Expense'!D17","v":" "}]
[null,"Breeding","Per CWT",{"$f":"'Income & Expense'!D18","v":" "}]
[null,"Chemicals","Per CWT",{"$f":"'Income & Expense'!D19","v":" "}]
[null,"Crop Insurance ","Per CWT",{"$f":"'Income & Expense'!D20","v":" "}]
[null,"Custom Hired ","Per CWT",{"$f":"'Income & Expense'!D21","v":" "}]
[null,"Feed","Per CWT",{"$f":"'Income & Expense'!D22","v":" "}]
[null,"Fertilizer","Per CWT",{"$f":"'Income & Expense'!D23","v":" "}]
[null,"Fuel & Oil","Per CWT",{"$f":"'Income & Expense'!D24","v":" "}]
[null,"Insurance","Per CWT",{"$f":"'Income & Expense'!D25","v":" "}]
[null,"Interest","Per CWT",{"$f":"'Income & Expense'!D26","v":" "}]
[null,"Labor","Per CWT",{"$f":"'Income & Expense'!D27","v":" "}]
[null,"Machinery Lease ","Per CWT",{"$f":"'Income & Expense'!D28","v":" "}]
[null,"Milk Hauling","Per CWT",{"$f":"'Income & Expense'!D29","v":" "}]
[null,"Milk Marketing ","Per CWT",{"$f":"'Income & Expense'!D30","v":" "}]
[null,"Milk Testing ","Per CWT",{"$f":"'Income & Expense'!D31","v":" "}]
[null,"Other Expenses ","Per CWT",{"$f":"'Income & Expense'!D32","v":" "}]
[null,"Professional Fees ","Per CWT",{"$f":"'Income & Expense'!D33","v":" "}]
[null,"Rent","Per CWT",{"$f":"'Income & Expense'!D34","v":" "}]
[null,"Repairs","Per CWT",{"$f":"'Income & Expense'!D35","v":" "}]
[null,"Seed","Per CWT",{"$f":"'Income & Expense'!D36","v":" "}]
[null,"Supplies","Per CWT",{"$f":"'Income & Expense'!D37","v":" "}]
[null,"Taxes (Property, Auto) ","Per CWT",{"$f":"'Income & Expense'!D38","v":" "}]
[null,"Utilities","Per CWT",{"$f":"'Income & Expense'!D39","v":" "}]
[null,"Total Cash Farm Expense","Per CWT",{"$f":"'Income & Expense'!D40","v":0}]
[null,"Net Farm Income From Operations ","Per CWT",{"$f":"'Income & Expense'!D41","v":" "}]
[null,"Animal Health ","%Per CWT Milk",{"$f":"'Income & Expense'!E16","v":" "}]
[null,"Bedding","%Per CWT Milk",{"$f":"'Income & Expense'!E17","v":" "}]
[null,"Breeding","%Per CWT Milk",{"$f":"'Income & Expense'!E18","v":" "}]
[null,"Chemicals","%Per CWT Milk",{"$f":"'Income & Expense'!E19","v":" "}]
[null,"Crop Insurance ","%Per CWT Milk",{"$f":"'Income & Expense'!E20","v":" "}]
[null,"Custom Hired ","%Per CWT Milk",{"$f":"'Income & Expense'!E21","v":" "}]
[null,"Feed","%Per CWT Milk",{"$f":"'Income & Expense'!E22","v":" "}]
[null,"Fertilizer","%Per CWT Milk",{"$f":"'Income & Expense'!E23","v":" "}]
[null,"Fuel & Oil","%Per CWT Milk",{"$f":"'Income & Expense'!E24","v":" "}]
[null,"Insurance","%Per CWT Milk",{"$f":"'Income & Expense'!E25","v":" "}]
[null,"Interest","%Per CWT Milk",{"$f":"'Income & Expense'!E26","v":" "}]
[null,"Labor","%Per CWT Milk",{"$f":"'Income & Expense'!E27","v":" "}]
[null,"Machinery Lease ","%Per CWT Milk",{"$f":"'Income & Expense'!E28","v":" "}]
[null,"Milk Hauling","%Per CWT Milk",{"$f":"'Income & Expense'!E29","v":" "}]
[null,"Milk Marketing ","%Per CWT Milk",{"$f":"'Income & Expense'!E30","v":" "}]
[null,"Milk Testing ","%Per CWT Milk",{"$f":"'Income & Expense'!E31","v":" "}]
[null,"Other Expenses ","%Per CWT Milk",{"$f":"'Income & Expense'!E32","v":" "}]
[null,"Professional Fees ","%Per CWT Milk",{"$f":"'Income & Expense'!E33","v":" "}]
[null,"Rent","%Per CWT Milk",{"$f":"'Income & Expense'!E34","v":" "}]
[null,"Repairs","%Per CWT Milk",{"$f":"'Income & Expense'!E35","v":" "}]
[null,"Seed","%Per CWT Milk",{"$f":"'Income & Expense'!E36","v":" "}]
[null,"Supplies","%Per CWT Milk",{"$f":"'Income & Expense'!E37","v":" "}]
[null,"Taxes (Property, Auto) ","%Per CWT Milk",{"$f":"'Income & Expense'!E38","v":" "}]
[null,"Utilities","%Per CWT Milk",{"$f":"'Income & Expense'!E39","v":" "}]
[null,"Total Cash Farm Expense","%Per CWT Milk",{"$f":"'Income & Expense'!E40","v":" "}]
[null,"Animal Health ","% Per CWT Gross ",{"$f":"'Income & Expense'!F16","v":" "}]
[null,"Bedding","% Per CWT Gross ",{"$f":"'Income & Expense'!F17","v":" "}]
[null,"Breeding","% Per CWT Gross ",{"$f":"'Income & Expense'!F18","v":" "}]
[null,"Chemicals","% Per CWT Gross ",{"$f":"'Income & Expense'!F19","v":" "}]
[null,"Crop Insurance ","% Per CWT Gross ",{"$f":"'Income & Expense'!F20","v":" "}]
[null,"Custom Hired ","% Per CWT Gross ",{"$f":"'Income & Expense'!F21","v":" "}]
[null,"Feed","% Per CWT Gross ",{"$f":"'Income & Expense'!F22","v":" "}]
[null,"Fertilizer","% Per CWT Gross ",{"$f":"'Income & Expense'!F23","v":" "}]
[null,"Fuel & Oil","% Per CWT Gross ",{"$f":"'Income & Expense'!F24","v":" "}]
[null,"Insurance","% Per CWT Gross ",{"$f":"'Income & Expense'!F25","v":" "}]
[null,"Interest","% Per CWT Gross ",{"$f":"'Income & Expense'!F26","v":" "}]
[null,"Labor","% Per CWT Gross ",{"$f":"'Income & Expense'!F27","v":" "}]
[null,"Machinery Lease ","% Per CWT Gross ",{"$f":"'Income & Expense'!F28","v":" "}]
[null,"Milk Hauling","% Per CWT Gross ",{"$f":"'Income & Expense'!F29","v":" "}]
[null,"Milk Marketing ","% Per CWT Gross ",{"$f":"'Income & Expense'!F30","v":" "}]
[null,"Milk Testing ","% Per CWT Gross ",{"$f":"'Income & Expense'!F31","v":" "}]
[null,"Other Expenses ","% Per CWT Gross ",{"$f":"'Income & Expense'!F32","v":" "}]
[null,"Professional Fees ","% Per CWT Gross ",{"$f":"'Income & Expense'!F33","v":" "}]
[null,"Rent","% Per CWT Gross ",{"$f":"'Income & Expense'!F34","v":" "}]
[null,"Repairs","% Per CWT Gross ",{"$f":"'Income & Expense'!F35","v":" "}]
[null,"Seed","% Per CWT Gross ",{"$f":"'Income & Expense'!F36","v":" "}]
[null,"Supplies","% Per CWT Gross ",{"$f":"'Income & Expense'!F37","v":" "}]
[null,"Taxes (Property, Auto) ","% Per CWT Gross ",{"$f":"'Income & Expense'!F38","v":" "}]
[null,"Utilities","% Per CWT Gross ",{"$f":"'Income & Expense'!F39","v":" "}]
[null,"Total Cash Farm Expense","% Per CWT Gross ",{"$f":"'Income & Expense'!F40","v":{"$error":"#DIV/0!"}}]
[null,"Net Farm Income From Operations ","% Per CWT Gross ",{"$f":"'Income & Expense'!F41","v":{"$error":"#VALUE!"}}]
[null,"Principle Payments ","Total",{"$f":"'Income & Expense'!B43","v":0}]
[null,"Deprecation ","Total",{"$f":"'Income & Expense'!B44","v":0}]
[null,"Livestock purchased (Cash Exp.)","Total",{"$f":"'Income & Expense'!B45","v":0}]
[null,"Equipment purchased (Cash Exp.)","Total",{"$f":"'Income & Expense'!B46","v":0}]
[null,"Other Assets purchased (Cash Exp.)","Total",{"$f":"'Income & Expense'!B47","v":0}]
[null,"Family Living ","Total",{"$f":"'Income & Expense'!B48","v":0}]
[null,"Total Fixed Cost ","Total",{"$f":"'Income & Expense'!B49","v":0}]
[null,"Total Cost ","Total",{"$f":"'Income & Expense'!B50","v":0}]
[null,"Net Farm Cash Flow ","Total",{"$f":"'Income & Expense'!B51","v":0}]
[null,"Principle Payments ","Per Cow",{"$f":"'Income & Expense'!C43","v":" "}]
[null,"Deprecation ","Per Cow",{"$f":"'Income & Expense'!C44","v":" "}]
[null,"Livestock purchased (Cash Exp.)","Per Cow",{"$f":"'Income & Expense'!C45","v":" "}]
[null,"Equipment purchased (Cash Exp.)","Per Cow",{"$f":"'Income & Expense'!C46","v":" "}]
[null,"Other Assets purchased (Cash Exp.)","Per Cow",{"$f":"'Income & Expense'!C47","v":" "}]
[null,"Family Living ","Per Cow",{"$f":"'Income & Expense'!C48","v":" "}]
[null,"Total Fixed Cost ","Per Cow",{"$f":"'Income & Expense'!C49","v":0}]
[null,"Total Cost ","Per Cow",{"$f":"'Income & Expense'!C50","v":{"$error":"#DIV/0!"}}]
[null,"Net Farm Cash Flow ","Per Cow",{"$f":"'Income & Expense'!C51","v":{"$error":"#DIV/0!"}}]
[null,"Principle Payments ","Per CWT",{"$f":"'Income & Expense'!D43","v":" "}]
[null,"Deprecation ","Per CWT",{"$f":"'Income & Expense'!D44","v":" "}]
[null,"Livestock purchased (Cash Exp.)","Per CWT",{"$f":"'Income & Expense'!D45","v":" "}]
[null,"Equipment purchased (Cash Exp.)","Per CWT",{"$f":"'Income & Expense'!D46","v":" "}]
[null,"Other Assets purchased (Cash Exp.)","Per CWT",{"$f":"'Income & Expense'!D47","v":" "}]
[null,"Family Living ","Per CWT",{"$f":"'Income & Expense'!D48","v":" "}]
[null,"Total Fixed Cost ","Per CWT",{"$f":"'Income & Expense'!D49","v":0}]
[null,"Total Cost ","Per CWT",{"$f":"'Income & Expense'!D50","v":0}]
[null,"Net Farm Cash Flow ","Per CWT",{"$f":"'Income & Expense'!D51","v":{"$error":"#VALUE!"}}]
[null,"Principle Payments ","%Per CWT Milk",{"$f":"'Income & Expense'!E43","v":" "}]
[null,"Deprecation ","%Per CWT Milk",{"$f":"'Income & Expense'!E44","v":" "}]
[null,"Livestock purchased (Cash Exp.)","%Per CWT Milk",{"$f":"'Income & Expense'!E45","v":" "}]
[null,"Equipment purchased (Cash Exp.)","%Per CWT Milk",{"$f":"'Income & Expense'!E46","v":" "}]
[null,"Other Assets purchased (Cash Exp.)","%Per CWT Milk",{"$f":"'Income & Expense'!E47","v":" "}]
[null,"Family Living ","%Per CWT Milk",{"$f":"'Income & Expense'!E48","v":" "}]
[null,"Principle Payments ","% Per CWT Gross ",{"$f":"'Income & Expense'!F43","v":" "}]
[null,"Deprecation ","% Per CWT Gross ",{"$f":"'Income & Expense'!F44","v":" "}]
[null,"Livestock purchased (Cash Exp.)","% Per CWT Gross ",{"$f":"'Income & Expense'!F45","v":" "}]
[null,"Equipment purchased (Cash Exp.)","% Per CWT Gross ",{"$f":"'Income & Expense'!F46","v":" "}]
[null,"Other Assets purchased (Cash Exp.)","% Per CWT Gross ",{"$f":"'Income & Expense'!F47","v":" "}]
[null,"Family Living ","% Per CWT Gross ",{"$f":"'Income & Expense'!F48","v":" "}]
["Forage Cost Survey","Chemicals","% Used for Forage",{"$f":"'Forage Cost Survey'!B4","v":0}]
[null,"Crop Insurance ","% Used for Forage",{"$f":"'Forage Cost Survey'!B5","v":0}]
[null,"Custom Hired ","% Used for Forage",{"$f":"'Forage Cost Survey'!B6","v":0}]
[null,"Fertilizer","% Used for Forage",{"$f":"'Forage Cost Survey'!B7","v":0}]
[null,"Fuel & Oil","% Used for Forage",{"$f":"'Forage Cost Survey'!B8","v":0}]
[null,"Labor","% Used for Forage",{"$f":"'Forage Cost Survey'!B9","v":0}]
[null,"Machinery Lease ","% Used for Forage",{"$f":"'Forage Cost Survey'!B10","v":0}]
[null,"Rent","% Used for Forage",{"$f":"'Forage Cost Survey'!B11","v":0}]
[null,"Repairs","% Used for Forage",{"$f":"'Forage Cost Survey'!B12","v":0}]
[null,"Seed","% Used for Forage",{"$f":"'Forage Cost Survey'!B13","v":0}]
[null,"Supplies","% Used for Forage",{"$f":"'Forage Cost Survey'!B14","v":0}]
[null,"Chemicals","Total",{"$f":"'Forage Cost Survey'!C4","v":0}]
[null,"Crop Insurance ","Total",{"$f":"'Forage Cost Survey'!C5","v":0}]
[null,"Custom Hired ","Total",{"$f":"'Forage Cost Survey'!C6","v":0}]
[null,"Fertilizer","Total",{"$f":"'Forage Cost Survey'!C7","v":0}]
[null,"Fuel & Oil","Total",{"$f":"'Forage Cost Survey'!C8","v":0}]
[null,"Labor","Total",{"$f":"'Forage Cost Survey'!C9","v":0}]
[null,"Machinery Lease ","Total",{"$f":"'Forage Cost Survey'!C10","v":0}]
[null,"Rent","Total",{"$f":"'Forage Cost Survey'!C11","v":0}]
[null,"Repairs","Total",{"$f":"'Forage Cost Survey'!C12","v":0}]
[null,"Seed","Total",{"$f":"'Forage Cost Survey'!C13","v":0}]
[null,"Supplies","Total",{"$f":"'Forage Cost Survey'!C14","v":0}]
[null,"Total ","Total",{"$f":"'Forage Cost Survey'!C15","v":0}]
[null,"Chemicals","Per Cow",{"$f":"'Forage Cost Survey'!D4","v":{"$error":"#DIV/0!"}}]
[null,"Crop Insurance ","Per Cow",{"$f":"'Forage Cost Survey'!D5","v":{"$error":"#DIV/0!"}}]
[null,"Custom Hired ","Per Cow",{"$f":"'Forage Cost Survey'!D6","v":{"$error":"#DIV/0!"}}]
[null,"Fertilizer","Per Cow",{"$f":"'Forage Cost Survey'!D7","v":{"$error":"#DIV/0!"}}]
[null,"Fuel & Oil","Per Cow",{"$f":"'Forage Cost Survey'!D8","v":{"$error":"#DIV/0!"}}]
[null,"Labor","Per Cow",{"$f":"'Forage Cost Survey'!D9","v":{"$error":"#DIV/0!"}}]
[null,"Machinery Lease ","Per Cow",{"$f":"'Forage Cost Survey'!D10","v":{"$error":"#DIV/0!"}}]
[null,"Rent","Per Cow",{"$f":"'Forage Cost Survey'!D11","v":{"$error":"#DIV/0!"}}]
[null,"Repairs","Per Cow",{"$f":"'Forage Cost Survey'!D12","v":{"$error":"#DIV/0!"}}]
[null,"Seed","Per Cow",{"$f":"'Forage Cost Survey'!D13","v":{"$error":"#DIV/0!"}}]
[null,"Supplies","Per Cow",{"$f":"'Forage Cost Survey'!D14","v":{"$error":"#DIV/0!"}}]
[null,"Total ","Per Cow",{"$f":"'Forage Cost Survey'!D15","v":{"$error":"#DIV/0!"}}]
[null,"Chemicals","Per CWT",{"$f":"'Forage Cost Survey'!E4","v":{"$error":"#DIV/0!"}}]
[null,"Crop Insurance ","Per CWT",{"$f":"'Forage Cost Survey'!E5","v":{"$error":"#DIV/0!"}}]
[null,"Custom Hired ","Per CWT",{"$f":"'Forage Cost Survey'!E6","v":{"$error":"#DIV/0!"}}]
[null,"Fertilizer","Per CWT",{"$f":"'Forage Cost Survey'!E7","v":{"$error":"#DIV/0!"}}]
[null,"Fuel & Oil","Per CWT",{"$f":"'Forage Cost Survey'!E8","v":{"$error":"#DIV/0!"}}]
[null,"Labor","Per CWT",{"$f":"'Forage Cost Survey'!E9","v":{"$error":"#DIV/0!"}}]
[null,"Machinery Lease ","Per CWT",{"$f":"'Forage Cost Survey'!E10","v":{"$error":"#DIV/0!"}}]
[null,"Rent","Per CWT",{"$f":"'Forage Cost Survey'!E11","v":{"$error":"#DIV/0!"}}]
[null,"Repairs","Per CWT",{"$f":"'Forage Cost Survey'!E12","v":{"$error":"#DIV/0!"}}]
[null,"Seed","Per CWT",{"$f":"'Forage Cost Survey'!E13","v":{"$error":"#DIV/0!"}}]
[null,"Supplies","Per CWT",{"$f":"'Forage Cost Survey'!E14","v":{"$error":"#DIV/0!"}}]
[null,"Total ","Per CWT",{"$f":"'Forage Cost Survey'!E15","v":{"$error":"#DIV/0!"}}]
["Balance Sheet ","Current Assets","Total",{"$f":"'Balance Sheet '!C4","v":0}]
[null,"Intermediate Assets ","Total",{"$f":"'Balance Sheet '!C5","v":0}]
[null,"Long-Term Assets ","Total",{"$f":"'Balance Sheet '!C6","v":0}]
[null,"Total Assets ","Total",{"$f":"'Balance Sheet '!C8","v":0}]
[null,{"$f":"'Balance Sheet '!E4","v":"Current Liabilities "},"Total",{"$f":"'Balance Sheet '!F4","v":0}]
[null,{"$f":"'Balance Sheet '!E5","v":"Intermediate  Liabilities "},"Total",{"$f":"'Balance Sheet '!F5","v":0}]
[null,{"$f":"'Balance Sheet '!E6","v":"Long-Term  Liabilities  "},"Total",{"$f":"'Balance Sheet '!F6","v":0}]
[null,{"$f":"'Balance Sheet '!E8","v":"Total Liabilities "},"Total",{"$f":"'Balance Sheet '!F8","v":0}]
[null,{"$f":"'Balance Sheet '!E10","v":"Net Worth "},"Total",{"$f":"'Balance Sheet '!F10","v":0}]
["Dairy Benchmarks Report ",{"$f":"'Balance Sheet '!B12","v":"Total Operator Management Fee "},"Total",{"$f":"'Balance Sheet '!E12","v":0}]
[null,{"$f":"Hide!C50","v":"Debt Per Cow "},"$",{"$f":"Hide!D50","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C52","v":"Total Investment Per Cow "},"$",{"$f":"Hide!D52","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C54","v":"Asset Turnover Ratio "},"%",{"$f":"Hide!D54","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C56","v":"Current Ratio "},null,{"$f":"Hide!D56","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C58","v":"Working Capital "},"$",{"$f":"Hide!D58","v":0}]
[null,{"$f":"Hide!C59","v":"Debt to Asset Ratio "},"%",{"$f":"Hide!D59","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C61","v":"Debt to Equity Ratio"},"%",{"$f":"Hide!D61","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C63","v":"Rate of Return on Farm Assets (ROA) "},"%",{"$f":"Hide!D63","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C65","v":"Operating Profit Margin "},"%",{"$f":"Hide!D65","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C24","v":"Income Per Cow "},"$",{"$f":"Hide!D24","v":0}]
[null,{"$f":"Hide!C26","v":"Livestock Expenses "},"%",{"$f":"Hide!D26","v":{"$error":"#VALUE!"}}]
[null,{"$f":"Hide!C28","v":"Operation Cost (As a Percentage of Gross Income) "},"%",{"$f":"Hide!D28","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C30","v":"Net Farm Income Ratio "},"%",{"$f":"Hide!D30","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C32","v":"Labor Expense "},"%",{"$f":"Hide!D32","v":" "}]
[null,{"$f":"Hide!C34","v":"Interest Expense Ratio "},"%",{"$f":"Hide!D34","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C5","v":"Purchased Feed "},"per CWT",{"$f":"Hide!D5","v":" "}]
[null,{"$f":"Hide!C6","v":"Forage cost "},"per CWT",{"$f":"Hide!D6","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C7","v":"Total Feed Cost per CWT "},"per CWT",{"$f":"Hide!D7","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C9","v":"Purchased Feed Costs"},"%",{"$f":"Hide!D9","v":" "}]
[null,{"$f":"Hide!C11","v":"Total Feed Cost (as a percent of milk income)"},"%",{"$f":"Hide!D11","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C13","v":"Milk Income Over Feed Cost  "},"$ Per Cwt",{"$f":"Hide!D13","v":{"$error":"#VALUE!"}}]
[null,{"$f":"Hide!C14","v":"Milk Income Over Feed Cost %"},"%",{"$f":"Hide!D14","v":{"$error":"#VALUE!"}}]
[null,{"$f":"Hide!C16","v":"Milk Returns per $100 of Purchased Feed"},"$",{"$f":"Hide!D16","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Hide!C17","v":"Milk Returns per $100 of Total Feed "},"$",{"$f":"Hide!D17","v":{"$error":"#DIV/0!"}}]

{"sheet":"Hide","index":7,"n_rows":102,"n_cols":14,"rows_kept":102,"cut":false,"hidden":true,"merged":[[62,6,63,6],[64,6,65,6],[8,6,9,6],[10,6,11,6],[13,6,14,6],[23,6,24,6],[25,6,26,6],[27,6,28,6],[29,6,30,6],[31,6,32,6],[33,6,34,6],[49,6,50,6],[51,6,52,6],[53,6,54,6],[55,6,56,6],[58,6,59,6],[60,6,61,6],[48,2,48,4],[49,3,50,3],[49,4,50,4],[51,3,52,3],[51,4,52,4],[60,3,61,3],[60,4,61,4],[53,3,54,3],[53,4,54,4],[55,3,56,3],[55,4,56,4],[58,4,59,4],[58,3,59,3],[2,2,2,4],[10,3,11,3],[10,4,11,4],[13,3,14,3],[8,4,9,4],[8,3,9,3],[12,4,14,4],[62,3,63,3],[62,4,63,4],[64,3,65,3],[64,4,65,4],[29,3,30,3],[33,3,34,3],[33,4,34,4],[31,3,32,3],[22,2,22,4],[23,4,24,4],[25,4,26,4],[27,4,28,4],[31,4,32,4],[29,4,30,4],[23,3,24,3],[25,3,26,3],[27,3,28,3]]}
[null,null,null,null,null,null,null,"Password ","Cow "]
[]
[null,null,"Feed Benchmarks"]
[null,null,"Feed Cost per CWT ",null,null,null,null,null,null,null,null,null,"Purchased Feed Cost Percent of  total income"]
[null,null,"Purchased Feed ",{"$f":"'Income & Expense'!D22","v":" "},null,null,null,null,null,null,null,null,"Great! The dairy has its purchased feed costs under control. ","<44.5%"]
[null,null,"Forage cost ",{"$f":"'Forage Cost Survey'!E15","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Watch, Purchased feed costs are elevating and the producer should consult with the dairy’s nutritionist and evaluate the forage program. ","44.6% to 49.9%"]
[null,null,"Total Feed Cost per CWT ",{"$f":"SUM(D5:D6)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Investigate, Feed costs are greatly elevated and the producer should evaluate purchased feed costs and consult with the dairy’s nutritionist. ",">50%"]
[]
[null,null,"Purchased Feed Costs",{"$f":"'Income & Expense'!F22","v":" "},{"$f":"IF(D9<0.445,M5,(IF(D9>0.499,M7,M6)))","v":"Investigate, Feed costs are greatly elevated and the producer should evaluate purchased feed costs and consult with the dairy’s nutritionist. "},null,{"$f":"IF(D9<0.445,\"Great\",(IF(D9>0.499,\"Investigate\",\"Watch\")))","v":"Investigate"},null,null,null,null,null,"Total Feed Cost Percent of Milk Income"]
[null,null,"Goal: Less than 45% of Total Income ",null,null,null,null,null,null,null,null,null,"Great! The farm’s feed costs are under control.","<59.5%"]
[null,null,"Total Feed Cost (as a percent of milk income)",{"$f":"D7/'Income & Expense'!D11","v":{"$error":"#DIV/0!"}},{"$f":"IF(D11<0.595,M10,IF(D11>0.651,M12,M11))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D11<0.595,\"Great\",IF(D11>0.651,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Watch, The farm’s feed costs are slightly elevated. Evaluate the nutrition program and forage quality. ","59.6% to 65%"]
[null,null,"Goal: Less than 60% of Milk income ",null,null,null,null,null,null,null,null,null,"Investigate, The farm’s feed costs are too high. Consult with the nutritionists and evaluate the forage program.",">65.1%"]
[null,null,"Milk Income Over Feed Cost  ",{"$f":"'Income & Expense'!D11-Hide!D7","v":{"$error":"#VALUE!"}},{"$f":"IF(D14>0.395,M15,IF(D14<0.351,M17,M16))","v":{"$error":"#VALUE!"}}]
[null,null,"Milk Income Over Feed Cost %",{"$f":"D13/'Income & Expense'!D11","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(D14>0.395,\"Great\",IF(D14<0.351,\"Investigate\",\"Watch\"))","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Milk Income over Feed Cost  "]
[null,null,"Goal: Greater than 40%",null,null,null,null,null,null,null,null,null,"Great! The Farm's IOFC is strong.",">39.5%"]
[null,null,"Milk Returns per $100 of Purchased Feed",{"$f":"'Income & Expense'!B11/('Income & Expense'!B22/100)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Watch, The farm’s feed costs are slightly elevated. It is recommended to analyze the nutrition program and forage quality. ","39.5% to 35%"]
[null,null,"Milk Returns per $100 of Total Feed ",{"$f":"('Income & Expense'!B11/(D7*('Income & Expense'!B3/100)))*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Investigate, The farm’s feed costs are too high and the IOFC is weak. Consult with the nutritionists and evaluate the forage program.","<35%"]
[]
[]
[]
[]
[]
[null,null,"Income & Expense Benchmarks "]
[null,null,"Income Per Cow ",{"$f":"'Income & Expense'!C13","v":0},{"$f":"IF(D24>4999.5,M25,IF(D24<4500,M27,M26))","v":"Investigate, Analyze milk volume per cow. Look at milk components, cull income, and other sources of farm income."},null,{"$f":"IF(D24>4999.5,\"Great\",IF(D24<4500,\"Investigate\",\"Watch\"))","v":"Investigate"},null,null,null,null,null,"Income Per Cow "]
[null,null,"Goal: $5,000 Per Cow ",null,null,null,null,null,null,null,null,null,"Great! Income per cow is over $5,000/cow, which means the cows are generating income at a competitive rate. ",">5000"]
[null,null,"Livestock Expenses ",{"$f":"'Income & Expense'!F16+'Income & Expense'!F18","v":{"$error":"#VALUE!"}},{"$f":"IF(D26<0.04,M30,IF(D26>0.055,M32,M31))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D26<0.04,\"Great\",IF(D26>0.055,\"Investigate\",\"Watch\"))","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Watch, Income per cow is just below the benchmark, evaluate income sources starting with milk production, followed by other revenue streams. ","4500-5000"]
[null,null,"Goal: Breeding and Animal Health Less than 4% Gross Farm Income",null,null,null,null,null,null,null,null,null,"Investigate, Analyze milk volume per cow. Look at milk components, cull income, and other sources of farm income.","<45000"]
[null,null,"Operation Cost (As a Percentage of Gross Income) ",{"$f":"('Income & Expense'!B40-'Income & Expense'!B26)/'Income & Expense'!B13","v":{"$error":"#DIV/0!"}},{"$f":"IF(D28<0.8,M35,IF(D28>0.855,M37,M36))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D28<0.8,\"Great\",IF(D28>0.855,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}}]
[null,null,"Goal: Total Cash Expense Less than 80% of Gross Farm Income",null,null,null,null,null,null,null,null,null,"Livestock Expenses "]
[null,null,"Net Farm Income Ratio ",{"$f":"'Income & Expense'!B41/'Income & Expense'!B13","v":{"$error":"#DIV/0!"}},{"$f":"IF(D30>0.2,M40,IF(D30<0.145,M42,M41))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D30>0.2,\"Great\",IF(D30<0.145,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Great! Livestock expenses are under control.","<4%"]
[null,null,"Goal: 20% ",null,null,null,null,null,null,null,null,null,"Watch, Livestock expenses are slightly elevated above the benchmark, check for decreased revenue streams and observe health program and breeding protocol.","4 to 5.5%"]
[null,null,"Labor Expense ",{"$f":"'Income & Expense'!F27","v":" "},{"$f":"IF(D32<0.15,M45,IF(D32>0.2,M47,M46))","v":"Investigate, Evaluate the farm's labor force to see if it can be more efficient. "},null,{"$f":"IF(D32<0.15,\"Great\",IF(D32>0.2,\"Investigate\",\"Watch\"))","v":"Investigate"},null,null,null,null,null,"Investigate, Analyze the animal health program and breeding protocol. Veterinarian assistance is probably needed. ",">5.6%"]
[null,null,"Goal: Less than 15% Gross Farm income "]
[null,null,"Interest Expense Ratio ",{"$f":"'Income & Expense'!B26/'Income & Expense'!B13","v":{"$error":"#DIV/0!"}},{"$f":"IF(D34<0.05,M50,IF(D34>0.1,M51,M52))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D34<0.05,\"Great\",IF(D34>0.1,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Operation cost as a percentage of gross income"]
[null,null,"Goal: Less than 5% ",null,null,null,null,null,null,null,null,null,"Great! Operation costs are under control.","<80%"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Watch, Operation costs are slightly above the benchmark, check for decreased revenue streams. This can affect cash flow problems in the long run.","80% to 85%"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, Examine the dairy’s variable expenses. Some expenses will need to be decreased.",">85%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Net Farm Income Ratio "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Great! The farm's net farm income is exceeding the benchmarks.",">20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Watch, The farm's net farm income is getting close to the benchmark. This could make it hard to meet future principle & interest payments.","20 to 15"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, Consult the farm's financial advisor(s). Analyze the farm's income sources and expenses to find efficiency issues that are lowering profitability. ","<15"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Labor Expense "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Great! Labor expenses are under control.","<15%"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Watch, Labor expenses are above the benchmark, check for decreased revenue streams and observe labor usage on the farm.","15 to 20%"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, Evaluate the farm's labor force to see if it can be more efficient. ",">20%"]
[]
[null,null,"Balance Sheet & Profitability Benchmarks ",null,null,null,null,null,null,null,null,null,"Interest Expense Ratio "]
[null,null,"Debt Per Cow ",{"$f":"'Dairy Benchmarks Reports '!F13/'Dairy Benchmarks Reports '!M3","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$50<5000,$M$55,IF($D$50>10000,$M$57,$M$56))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($D$50<5000,\"Great\",IF($D$50>10000,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Great! The ratio indicates that less than 5% of gross farm income is used to pay for borrowed capital.","<5"]
[null,null,"Goal: Less than $5,000 Per Cow",null,null,null,null,null,null,null,null,null,"Watch, Interest expense is slightly elevated, check for decreased revenue streams, debt structure, and evaluate prevailing interest rates.","5 to 10 "]
[null,null,"Total Investment Per Cow ",{"$f":"'Dairy Benchmarks Reports '!C13/'Dairy Benchmarks Reports '!M3","v":{"$error":"#DIV/0!"}},{"$f":"IF(D52<15000,M60,IF(D52>20000,M62,M61))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D52<15000,\"Great\",IF(D52>20000,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Investigate, Consult the farm's financial advisor(s). Analyze debt structure, interest rates, and income sources. ",">10"]
[null,null,"Goal: 7,500 to 15,000"]
[null,null,"Asset Turnover Ratio ",{"$f":"'Dairy Benchmarks Reports '!K7/'Dairy Benchmarks Reports '!C13","v":{"$error":"#DIV/0!"}},{"$f":"IF(D54>0.35,M65,IF(D54<0.25,M67,M66))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D54>0.35,\"Great\",IF(D54<0.25,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Debt Per Cow "]
[null,null,"Goal: 35% ",null,null,null,null,null,null,null,null,null,"Great! The business is utilizing debt efficiently.",5000]
[null,null,"Current Ratio ",{"$f":"'Dairy Benchmarks Reports '!C9/'Dairy Benchmarks Reports '!F9","v":{"$error":"#DIV/0!"}},{"$f":"IF(D56>1.49,M70,IF(D56<0.9999,M72,M71))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D56>1.49,\"Great\",IF(D56<0.9999,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Watch, The producer should analyze their liabilities, as the producer might need to adjust their debt structure. ","7500 to 10000"]
[null,null,"Goal: 1.5",null,null,null,null,null,null,null,null,null,"Investigate, The producer should analyze their debt structure and herd size, as the farm’s herd size is not offsetting the debt. ",10000]
[null,null,"Working Capital ",{"$f":"'Dairy Benchmarks Reports '!C9-'Dairy Benchmarks Reports '!F9","v":0}]
[null,null,"Debt to Asset Ratio ",{"$f":" 'Dairy Benchmarks Reports '!F13/'Dairy Benchmarks Reports '!C13","v":{"$error":"#DIV/0!"}},{"$f":"IF(D59<0.4,M75,IF(D59>0.6,M77,M76))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D59<0.4,\"Great\",IF(D59>0.6,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Total Investment Per Cow "]
[null,null,"Goal: Less than 40%",null,null,null,null,null,null,null,null,null,"Great! The dairy is operating financially efficient ",15000]
[null,null,"Debt to Equity Ratio",{"$f":"'Dairy Benchmarks Reports '!F13/'Dairy Benchmarks Reports '!F15","v":{"$error":"#DIV/0!"}},{"$f":"IF(D61<0.49999,M81,IF(D61>1.5,M83,M82))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D61<0.49999,\"Great\",IF(D61>1.5,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Watch, Total investment per cow are restricting the benchmark value. ","15000 to 20000"]
[null,null,"Goal: Less  than 50%",null,null,null,null,null,null,null,null,null,"Investigate, The producer should analyze noncurrent assets usage, unless the driving factor is land values. ",20000]
[null,null,"Rate of Return on Farm Assets (ROA) ",{"$f":"('Income & Expense'!B41+'Income & Expense'!B26-'Balance Sheet '!E12)/'Balance Sheet '!C8","v":{"$error":"#DIV/0!"}},{"$f":"IF(D63>0.049999,M86,IF(D63<0.00999,M88,M87))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D63>0.049999,\"Great\",IF(D63<0.00999,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}}]
[null,null,"Goal: 5%",null,null,null,null,null,null,null,null,null,"Asset Turnover Ratio "]
[null,null,"Operating Profit Margin ",{"$f":"('Income & Expense'!B41+'Income & Expense'!B26-'Balance Sheet '!E12)/'Income & Expense'!B13","v":{"$error":"#DIV/0!"}},{"$f":"IF(D65>0.24999,M91,IF(D65<0.14999,M93,M92))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D65>0.24999,\"Great\",IF(D65<0.14999,\"Investigate\",\"Watch\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Great! The farm is getting great production on assets. Very efficient enterprise.",">35%"]
[null,null,"Goal: 25%",null,null,null,null,null,null,null,null,null,"Watch,  The operation’s assets need to be analyzed, as the enterprise is not using the assets as efficiently as possible. ","35 to 25%"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, The operation is not utilizing its assets efficiently and asset structure should be analyzed. ","<25%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Current Ratio "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Great! The dairy has strong liquidity. ",">1.5"]
[null,null,"Predominate breed ","Holstein ",null,null,null,null,null,null,null,null,"Watch, The liquidity of the dairy is vulnerable; the debt structure should be examined. ","1.5 to 1"]
[null,null,null,"Jersey ",null,null,null,null,null,null,null,null,"Investigate, the operation is not liquid and the debt structure should be analyzed.","<1"]
[null,null,null,"Holstein and Jersey "]
[null,null,null,"Brown Swiss ",null,null,null,null,null,null,null,null,"Debt to Asset Ratio "]
[null,null,null,"Gurnsey ",null,null,null,null,null,null,null,null,"Great! The dairy is solvent and can cover term-debt. ","<40"]
[null,null,null,"Ayrshire ",null,null,null,null,null,null,null,null,"Watch, The business is becoming susceptible to a cash flow restriction if the market declines.","40-60"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, The operation is not solvent. The debt structure should be evaluated and consider selling underutilized assets to decrease debt.  ",">60"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Debt to Equity Ratio"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Great! The business is very solvent and in good position in a market downturn.","<50"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Watch, The business is losing borrowing capacity and is gaining financial risk if the market declines. ","75-150"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, The business is too reliant on debt to finance operations. Consider selling underutilized assets to decrease debt. ",">150"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rate of Return on Farm Assets (ROA) "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Great! The dairy has great profitability. ",">5"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Watch, The cost structure and total assets should be evaluated. ","5 to 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, The operation is not profitable. This could result from bad returns on assets, low income, or a high operator management fee. ","<1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operating Profit Margin "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Great! The dairy has great profitability. ",">25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Watch, The dairies cost structure should be analyzed as gross revenue is probably not covering all expenses. ","15 to 20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investigate, The enterprise is not getting good return on investment and the cost structure and revenue stream need to be analyzed. ","<15"]
[]
[]
[]
[]
[]
[]
[null,null,"Great"]
[null,null,"Watch"]
[null,null,"Investigate"]