When a lender or a partner asks how the farm stands, you hand over a farm dashboard: seven numbers on a single page. Beside each number go four columns: the date the number was taken, its formula, last year’s value and the action level, the value at which you would act. The date goes with the number because the number changes. In the invented example, the current ratio is 1.20 before harvest and 2.50 after it. That ratio sets what can turn into cash within a year against what must be paid within a year.
The numbers are the easy part, because two guides from US universities use the same five financial criteria and offer common ratios to measure them. Yet the two do not rate every value alike. Take a current ratio of 1.20 (what turns into cash within a year, divided by what falls due within a year). The guide that Mississippi State University, a US public university, publishes for farmers rates it stable, and the scorecard of Cornell University rates it danger. Each guide sorts values into bands, ranges of values with a rating such as weak, stable or strong. So the page has to say which guide it used, and the four columns are what make each number usable.
The dashboard has one row per number and is redone on the same date each year. The example is a corn and soybean farm in Story County, Iowa. The farm and every value on it are invented, and the note under each calculation says so.
Which seven numbers go on the page?
Take one ratio for each of five criteria, then add two numbers you already follow. The five criteria are recommended by the Farm Financial Standards Council, a US body that publishes guidelines for farm financial reporting and analysis. The extension service of the University of Wisconsin-Madison (Wisconsin Extension) names them: liquidity, solvency, profitability, repayment capacity and financial efficiency. Cornell’s Small Farms scorecard uses the same five headings. A ratio is one total divided by another. These are the five ratios the page uses, one for each criterion:
- Current ratio: what turns into cash within a year, divided by what falls due within a year.
- Debt-to-asset: what you owe, divided by what you own.
- Operating profit margin: the profit from operations divided by gross revenue, which is all the income of the year before costs. To get that profit, take revenue minus operating costs, then minus a wage for your own work and management, which you do not draw as pay. Count all operating costs, including depreciation (the yearly loss of value of machines and buildings), but leave interest out. You choose that wage, and you write it on the page beside the formula.
- Term debt coverage: cash available for loan payments (profit plus depreciation, minus what the owner withdraws), divided by the principal and interest due in the year on term loans. Term loans are those that run longer than a year.
- Operating expense ratio: operating costs without depreciation and without interest, divided by gross revenue.
The other two rows come from what you already follow. A paper on extensive beef cattle businesses in Argentina, by researchers at the Universidad Nacional del Sur, advises starting with a few key indicators close to what is already monitored. It also advises giving each one a goal, an update frequency and a source of information (Scoponi and Cordisco, in Spanish). The owner of the example farm follows two:
- Yield against the five-year average: this year’s yield of the main crop divided by the average of the farm’s last five years. 1.00 is an average year, and 0.94 is 6 percent below it. The library has an article on field yield year by year.
- Months on the job of those who left: the average number of months the people who left the farm that year had been on the job when they left. A drop from 9 to 5 means people are leaving sooner. The library has an article on tracking tenure instead of the turnover rate.
Seven is the number this page picks, not a finding: it keeps the dashboard to one page. None of the sources gives a right number of rows.
Which date goes beside each number?
Mark each row as a position at a date or as a result over a period, because a number without its date cannot be compared with last year’s. A position is a snapshot of what the farm owns and owes on one day. A result over a period is what the farm earned or spent across a stretch of time. Wisconsin Extension draws the same line: financial position is the strength of the business at a single point in time, and financial performance is measured across months, quarters or years. The current ratio and debt-to-asset are position rows. Margin, coverage, the expense ratio and the two chosen rows are results over a period, and the example uses the twelve months to the same date. That Wisconsin page adds that a ratio is most informative when set against the same ratio in the farm’s previous period or against comparable farm businesses. The dashboard uses the first, which is why it has a column for last year.
A position row moves with the calendar. The Mississippi State guide counts inventories, such as grain in the bin, among current assets, so the same farm, in the same year, has a very different current ratio before harvest and after it. Pick one date, the same every year, and write it on the row. Without that, part of the change from last year comes from the calendar and not from the farm.
Which formula and which band can you trust?
Write the exact formula on the page, name the guide you read the band from, and treat the band as a rough reference. A band is the range of values a guide rates as weak, stable or strong (Mississippi State) or as danger, caution or comfort (Cornell). The cut points are the values where a rating changes. The two guides give different cut points for three of the five ratios:
- Current ratio: Mississippi State rates it stable between 1.0 and 2.0. Cornell puts the caution zone between 1.3 and 2.0, so below 1.3 is danger.
- Operating profit margin: Mississippi State rates it weak below 0.10, which is 10 percent of gross revenue. Cornell rates it danger below 0.15, which is 15 percent of the value of farm production, a total that counts what the farm produced and not only what it sold.
- Term debt coverage: Mississippi State rates it weak below 1.10, and Cornell rates it danger below 1.25.
Only the cut points for debt-to-asset (0.30 and 0.60) and for the operating expense ratio (0.60 and 0.80) coincide, and Mississippi State adds that experts disagree even on the 60 percent line for debt-to-asset.
A third source gives a higher value for the same margin. Researchers at Purdue University cite 20 percent as the long-run benchmark for the operating profit margin of farms in a Kansas sample, against the 10 and 15 percent cut points above. They divide that margin by either the value of farm production or gross revenue.
The formula matters because the same year can read differently under two formulas. The full term debt coverage formula in the Mississippi State guide has seven terms, and a shorter one has three (profit plus depreciation, minus owner withdrawals). In the example of the library’s article on debt, the full formula gives a coverage of 1.063, weak, and the short one gives 1.22, stable, with no figure on the farm changed. The Mississippi State table gives its bands for the full formula, so compare the short one with them only as an approximation. So write beside each result which formula you used, and last year’s column compares only when both years use the same one.
At what value should you act?
Write beside each row the action level, the value at which you will do something, and name the something. It works like the pest count at which a farmer sprays: below it you only watch, at it you act. A dashboard without it only lists numbers. In the example, the owner writes “below 1.10: no new term loan until after harvest” beside the current ratio. Researchers Scoponi and Cordisco ask that every indicator carry a goal; for a row you watch for trouble, that goal can be the action level. None of the sources gives that value, because it depends on the loan terms, the cash on hand and what the owner is willing to do. The published bands can start the conversation, but the number that goes on the page is yours.
The action level can also depend on two rows together. Researchers at Purdue University define financial stress on Kansas farms as two conditions at once: a negative operating profit margin, which means the farm lost money from operations, and a debt-to-asset ratio above 0.70. They use five-year moving averages of records from 1973 to 2018, where each year’s value is the average of that year and the four before it. They call it a warning signal, not a measure of credit quality or of the chance of default, and on average across those periods about 6.6 percent of the sampled farms met both conditions. The sample is from Kansas, so read the rule as an example of how two rows can be combined, not as a limit for your land.
On the example farm neither condition is met: the margin is 0.12, not negative, and debt-to-asset is 0.45, below 0.70 (one year of figures here, not five-year averages). Yet the margin fell from 0.17 to 0.12 and the current ratio from 1.35 to 1.20. A rule with two conditions would not show that fall; the last-year column does.
What does the finished page show, and in what order do you read it?
The finished page has seven rows, each with its date or period, this year’s value, last year’s and the action level. You fill it in starting from last year’s column, as the checklist below says. You read it from the action level: first the rows that reached their action level, then the ones that moved most since last year, and only then the bands. In the example, six of the seven rows are worse than last year, and one of those six, months on the job, has reached its action level. The seventh row, debt-to-asset, improved.
01
Rows at their action level
The rows that reached the value where you act
02
Rows that moved most
Compare with last year's column
03
The published bands
Last, and only as a reference
How far does the evidence go? The ratios and the split between position and performance come from extension guidance, which is advice from universities, not a test. None of the sources above tests one-page dashboards on farms. The closest evidence is a systematic review, a review that collects and compares the studies on one question. The review of 24 studies (Taramuel-Taramuel et al., 2023) finds that planning and monitoring with recordkeeping tools are related to farm performance, and it calls that finding not conclusive. A link of that kind does not show that the tools cause the better results. So the page is a way to see the numbers and agree on what to do, not a proven way to raise results. The current ratio, for one, does not say how long the cash lasts; for that, see how many months of reserve.
A first version takes about two hours. Have three papers on the table: last year’s balance sheet (what the farm owned and owed on one date), last year’s income statement (its revenue and costs over the year) and the loan terms. Fill in last year’s column first, because it needs only those papers.
Give each number on the page a goal from strategic goals with a number and a date, or leave it off, because a number with no goal behind it tells no one what to do. The three-year production plan shows which numbers will matter in seasons two and three. For the planning articles, see the planning section of the library; for the wider practice, farm management. Related: In which month will your farm’s cash run lowest?. Related: Does your number hold up against a public reference?.