{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Home","Ratios"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Home","index":0,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,42,8],[7,0,7,9],[15,0,19,13],[22,0,24,13]]}
[]
[]
[]
[]
[]
[]
["Instructions"]
["Use the yellow shaded cells found on the Ratios tab to fill in values for each input. "]
[]
["Each ratio will be automatically calculated in the orange shaded cells."]
[]
["Enter data in the yellow shaded cells only. "]
["Orange shaded cells will be calculated automatically from numbers entered in yellow shaded cells. "]
[]
["Sources of Information"]
["Ideally, the numbers used in calculating these ratios come from current financial statements (cash flow statement, balance sheet, income statement) developed in a manner consistent with Farm Financial Standards guidelines (www.FFSC.org). Any financial measure is only as good as the information used in calculating it. Listed below are links to OCES fact sheets with instructions on creating financial statements. OSU spreadsheet tools that match these fact sheets may be used to create financial statements and may be accessed through the link below. "]
[]
[]
[]
[]
[]
["Stoplight Indicator"]
["The stoplight Indicator uses ratios based on Farm Financial Standards guidelines to help users visually interpret the degree of farm stress based on the inputs used to calculate these ratios. This indicator shows the stregth and performance or lack thereof based on these calculated ratios."]
[]
[]
[]
["OCES Fact Sheets"]
["AGEC-790, Evaluating Financial Performance and Position"]
["AGEC-237, Farm and Ranch Stress Test"]
["AGEC-751, Developing a Cash Flow Statement"]
["AGEC-752, Developing a Balance Sheet"]
["AGEC-753, Developing an Income Statement"]
[]
["Additional Spreadsheet Tools"]
["OSU spreadsheet tools"]
["www.beefextension.com/"]
["KSU spreadsheet tools"]
["ISU spreadsheet tools"]
[]
["Disclaimer: This spreadsheet is provided by the Oklahoma Cooperative Extension Service for educational use and is provided solely on an “AS IS” basis. Oklahoma Cooperative Extension Service assumes no liability for the use of these programs. "]

{"sheet":"Ratios","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Ratio Sheet","* Please fill in the yellow shaded cells. Orange shaded cells will fill in automatically."]
[]
[null,"Input","Source of Information",null,"Input","Source of Information"]
["Current Farm Assets",0,"Balance Sheet 10","Total Non-Farm Income",0,"Cash Flow 13 + 15"]
["Current Farm Liabilities",0,"Balance Sheet 40","Interest on Term Debt",0,"Cash Flow 51 + 53"]
["Farm Equity",0,"Balance Sheet 56","Interest on Capital Leases",0,"Financial Records"]
["Farm Assets",0,"Balance Sheet 10 + 24","Total Income and Social Security Tax Expenses",0,"Cash Flow 46"]
["Farm Liabilities",0,"Balance Sheet 40 + 48","Withdrawals for Family Living",0,"Cash Flow 45"]
["Net Farm Income from Operations",0,"Income Statement 58","Annual Principal and Interest Payments on Term Debt",0,"Cash Flow 51 + 52 + 53 + 54"]
["Farm Interest Expense",0,"Income Statement 56","Annual Principal and Interest Payments on Capital Leases",0,"Financial Records"]
["Gross Farm Revenue",0,"Income Statement 20","Payments on unpaid operating debt from a prior period",0,"Financial Records"]
["Total Operating Expenses",0,"Income Statement 53","Prinicipal payments on current portions of term debt",0,"Financial Records"]
["Depreciations Expense",0,"Income Statement 52","Principal payments on current portions of capital leases",0,"Financial Records"]
[null,null,null,"Total annual payments on personal liabilities not included in withdrawals",0,"Cash Flow 55 + 56"]
[null,null,null,"Value of Unpaid operator and family labor and management",0,"Estimate"]
[]
[]
["Ratios:","Output",null,"Formula","Stoplight Indicator with Low Stress and High Stress Threshholds"]
["Current",{"$f":"B4/B5","v":{"$error":"#DIV/0!"}},null,"Total current farm assets/Total current farm liabilities",2,null,"1.0 or less"]
[]
["Equity-to-Asset",{"$f":"B6/B7","v":{"$error":"#DIV/0!"}},null,"Total farm equity/Total farm assets",0.5,null,"40% or less"]
[]
["Debt-to-Asset",{"$f":"B8/B7","v":{"$error":"#DIV/0!"}},null,"Total farm liabilities/Total farm assets",0.3,null,"60% or more"]
[]
["Debt-to-Equity",{"$f":"B8/B6","v":{"$error":"#DIV/0!"}},null,"Total liabilities/Total farm equity",1,null,"1.5 or more"]
[]
["ROA Farm",{"$f":"(B9+B10-E15)/B7","v":{"$error":"#DIV/0!"}},null,"(Net farm income from operations + Farm interest Expense -Value of unpaid operator and family labor and management)/Average total farm assets",0.05,null,"1% or less"]
[]
["ROE Farm",{"$f":"(B9-E15)/B6","v":{"$error":"#DIV/0!"}},null,"(Net farm income from operations - Value of unpaid operator and family labor and management)/Average total farm equity",0.1,null,"5% or less"]
[]
["Operating Profit Margin",{"$f":"(B9+B10-E15)/B11","v":{"$error":"#DIV/0!"}},null,"(Net farm income from operations + Farm interest expense -Value of unpaid operator and family labor and management)/Gross farm revenue or value of farm production",0.25,null,".10 or less"]
[]
["Asset Turnover",{"$f":"B11/B7","v":{"$error":"#DIV/0!"}},null,"Gross farm revenues/Average total farm assets",0.4,null,"20% or more"]
[]
["Operating Expense",{"$f":"(B12-B13)/B11","v":{"$error":"#DIV/0!"}},null,"(Total operating expenses - Depreciations expense)/Gross farm revenues",0.6,null,"80% or more"]
[]
["Depreciation Expense",{"$f":"B13/B11","v":{"$error":"#DIV/0!"}},null,"Depreciation expense/Gross farm revenues"]
[]
["Farm Interest Expense",{"$f":"B10/B11","v":{"$error":"#DIV/0!"}},null,"Total farm interest expense/Gross farm revenues",0.1,null,"20% or more"]
[]
["Net Farm Income from Operations",{"$f":"B9/B11","v":{"$error":"#DIV/0!"}},null,"Net farm income from operations/Gross farm revenues",0.2,null,".05 or less"]
[]
["Term Debt and Capital Lease Coverage",{"$f":"(B9+E4+B13+E5+E6-E7-E8)/(E9+E10)","v":{"$error":"#DIV/0!"}},null,"(Net farm income from operations + Total nonfarm income + Depreciation expense + Interest on term debt + Interest on capital leases - Total income and Social Security tax expenses - Withdrawals for family living)/(Annual scheduled principal and interest payments on term debt + Annual scheduled principal and interest payments on capital leases)",1.5,null,"1.0 or less"]
[]
["Capital Replacement and Term Debt Repayment Margin",{"$f":"B9+E4+B13-E7-E8-E11-E12-E13-E14","v":0},null,"(Net farm income from operations + Total nonfarm income + Depreciation expense  - Total income and Social Security tax expenses - Withdrawals for family living - Payments on unpaid operating debt from a prior period - Prinicipal payments on current portions of term debt - Principal payments on current portions of capital leases - Total annual payments on personal liabilities not included in withdrawals)"]