Skip to content
Assessment
LibraryPlanning

Which seven dated numbers belong on a farm dashboard?

Two US university guides use the same five financial criteria, yet one rates a current ratio of 1.20 stable and the other danger. Four columns beside each number turn seven numbers into a dashboard: the date, the formula, last year's value and the action level, the value at which you act.

Published Updated 20 min read
In this article

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.

The seven rows of the example dashboard and the criterion each one answers. Filled square: position at a date. Outlined square: result over a period
Seven rows: five ratios, one per financial criterion, and two the farm already followsCurrent ratio and debt-to-asset are positions at a date. Operating profit margin, term debt coverage, operating expense ratio, yield against the five-year average and months on the job of those who left are results over a period.Seven rows, one pageCurrent ratioLiquidityDebt-to-assetSolvencyOperating profit marginProfitabilityTerm debt coverageRepayment capacityOperating expense ratioFinancial efficiencyYield vs five-year averageYour own rowMonths on the job, leaversYour own rowPosition at a dateResult over a period

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.

The current ratio of the same farm on two dates, with invented values. Each pair of strips reads the value against two guides: the upper strip is the Mississippi State guide, the lower strip is the Cornell scorecard
The same farm has 1.20 before harvest and 2.50 after itBefore harvest, on Sep 30, the current ratio is 1.20: stable at Mississippi State and danger at Cornell. After harvest it is 2.50: strong at Mississippi State and comfort at Cornell.Current ratio, same farm, two datesBefore harvest, Sep 301.20Mississippi: stable · Cornell: dangerAfter harvest2.50Mississippi: strong · Cornell: comfortWeak or dangerStable or cautionStrong or comfortDark mark: the farm's value

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.

Three ratios of the example farm read against two guides, with invented values. In each pair of strips, the upper one is the Mississippi State guide and the lower one is the Cornell scorecard
Three of five ratios change rating from one guide to the otherCurrent ratio 1.20, operating profit margin 0.12 and term debt coverage 1.20 are stable at Mississippi State and danger at Cornell.Same farm, same date, two guidesCurrent ratio1.20Mississippi: stable · Cornell: dangerMississippi 1.0 / 2.0 · Cornell 1.3 / 2.0Operating profit margin0.12Mississippi: stable · Cornell: dangerMississippi 0.10 / 0.25 · Cornell 0.15 / 0.25Term debt coverage1.20Mississippi: stable · Cornell: dangerMississippi 1.10 / 1.50 · Cornell 1.25 / 1.75Weak or dangerStable or cautionStrong or comfortDark mark: the farm's value

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

Read the rows at their action level first, then the rows that moved most since last year, and only then the bands.
The finished dashboard of the example farm, last year against this year, with invented values. Each row shows the change and the action level. An outlined square marks a row that reached its action level
Six of seven rows are worse than last year, and one of the six has reached its action levelCurrent ratio 1.35 to 1.20, margin 0.17 to 0.12, coverage 1.45 to 1.20, expense ratio 0.66 to 0.70, yield against average 1.03 to 0.94 and months on the job 9 to 5 are worse. Debt-to-asset 0.46 to 0.45 is better. Months on the job reached its action level.Seven rows, last year to this yearCurrent ratio1.35 → 1.20 · act below 1.10Debt-to-asset0.46 → 0.45 · act above 0.55Operating profit margin0.17 → 0.12 · act below 0.10Term debt coverage1.45 → 1.20 · act below 1.10Operating expense ratio0.66 → 0.70 · act above 0.75Yield vs five-year average1.03 → 0.94 · act below 0.90Months on the job, leavers9 → 5 · act at 6 or fewerWorse than last yearBetter than last yearOutlined: reached its action level

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?.

Provenance

Derives from
  1. Griffith, Mills, Kim and Johnson, Farm Financial Analysis Series: Ratios to Measure Farm Financial Health, Mississippi State University Extension, Publication P3712, 2024 (Farm Financial Standards Council measures)
  2. Cornell Small Farms Program, Financial Scorecard, Cornell University
  3. Wantoch and Bernhardt, Financial measurement, Farm Pulse program, University of Wisconsin-Madison Extension (undated)
  4. Langemeier and Yeager, The Incidence of Financial Stress on Kansas Farms, Center for Commercial Agriculture, Purdue University, December 2019
  5. Scoponi and Cordisco, Costos, márgenes y control en empresas ganaderas con visión interdisciplinaria, Revista CEA vol. VII n.2, Universidad Nacional del Sur, 2023 (in Spanish, beef cattle in Argentina)
  6. Taramuel-Taramuel, Montoya-Restrepo and Barrios, Drivers linking farmers' decision-making with farm performance: A systematic review and future research agenda, Heliyon 9(10):e20820, 2023, DOI 10.1016/j.heliyon.2023.e20820 (peer reviewed, open access)
What this article covers
Choosing seven rows for one page, five ratios from the standard financial criteria and two you already follow; dating each as a position or a period; writing the formula; filling in last year's column; and setting the action level at which you act.
What it does not cover
How to work each ratio out from the books, which you will find in the debt and reserve articles of this library, and what values your farm should reach. It does not forecast or compare the farm with others, and none of its sources tests whether a one-page dashboard improves results.
Published
Updated
Error found
Point out an error and the article is corrected with a note on what changed.

How to cite this article

Rurivia. (2026, October 27). Which seven dated numbers belong on a farm dashboard? https://rurivia.com/en/library/planning/one-page-farm-dashboard/


Keep reading

Planning

Two field jobs, one crew: which one gets the day?

Each day of delay costs every acre the machine has not reached yet, and that cost differs between jobs and climbs as each window closes. You can write down before the rush which job waits.

Sep 5, 2026
Planning

How long does it take you to find out something went wrong?

How often you check something sets the shortest average delay in finding a problem. Check every 30 days and a problem is 15 days old, on average, when you find it.

Aug 24, 2026
Planning

Farm management diagnosis: find the empty area first

A bank, a buyer or a partner will ask which parts of the farm have a written rule. One page, six areas and one mark each answer that, and show where to write the first rule.

Sep 5, 2026
Planning

Revenue diversification: how many sources do you lean on?

Counting a farm's activities is easy and tells you little. The effective number of sources says how many equal sources would split your revenue the way it is actually split, and the largest group of sources that fail together says how much cash to hold for a bad year.

Sep 1, 2026

Farm Management

If this article were a plant, farm management would be the whole field.

Planning, organizing, leading and controlling: the four functions, what each one decides, and a farm example for each, all on one page.