18 Farm Ratio Targets.xlsx

	B	C	D	E	F	G	J	K	L	M	N
1
2
3
4
5
6
7	Model Information:						This is the Financial Ratio template to automatically calculate your operation's ratios! Simply DOWNLOAD a copy of this sheet and fill in the latest figures from your Financial Statements in the Orange cells and the template will automatically calculate all Ratios.
8
9		Latest Financial Period:	12/31/2022
10		Currency:	$
11
12	Income Statement		Units	Dec-20	Dec-21	Dec-22	Financial Ratios	Units	Dec-20	Dec-21	Dec-22
13		Total Revenue	$	0	0	0	1. Current Ratio	$
14		Operating Expenses	$	0	0	0	2. EBITDA	$	0.0	0.0	0.0
15		Depreciation	$	0	0	0	3. Debt to Equity Ratio	$
16		Amortization	$	0	0	0	4. Net Income Ratio	$
17		Interest Expense	$	0	0	0	5. Debt to Asset Ratio	$
18		Taxes	$	0	0	0	6. Asset Turnover Rate	$
19		Net Income	$	0	0	0	7. Interest Expense Ratio	$
20							8. Equity to Asset Ratio	$
21	Balance Sheet		Units	Dec-20	Dec-21	Dec-22	9. Net Farm Income	$	0.0	0.0	0.0
22		Current Assets	$	0	0	0	10. Operating Profit Margin	$
23		Total Assets	$	0	0	0	11. Rate of Return on Equity	$
24		Current Liabilities	$	0	0	0	12. Rate of Return on Assets	$
25		Total Debt	$	0	0	0	13. Operating Expense Ratio	$
26		Total Equity	$	0	0	0	14. Depreciation Expense Ratio	$
27							15. Debt Service Coverage Ratio	$
28							16. Capital Debt Repayment Coverage	$
29	Cash Flow Statement		Units	Dec-20	Dec-21	Dec-22	17. Replacement Margin Coverage Ratio	$
30		Debt Repayment	$	0	0	0	18. Working Capital to Gross Revenues	$
31		Capital Debt Repayment	$	0	0	0
32							Please refer to the "18 Farm Ratio Targets" E-Book for a full explanation of each ratio and more details on how to calculate and improve them!
33	Other Inputs		Units	Dec-20	Dec-21	Dec-22
34		Net Farm Income	$	0	0	0
35		Non Farm Income	$	0	0	0
36		Replacement Cost	$	0	0	0
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100