Skip to content
Assessment

Tools

Price and weather shock resilience calculator

How far can price and harvest fall before this cycle turns a loss?

Worked out by switching value, with the room measured against your own farm’s swing.

However you write money in your own books.
The cycle
Everything this cycle should take in for what it sells. It has to be greater than zero. Example: 900,000.
Everything this cycle costs, from ground preparation to the sale, including the share of structure it carries. Example: 720,000.
Optional, and it is the field that changes the arithmetic: harvest, freight, drying, commission, per-bag royalty. Seed, fertilizer and spray do not belong here, because they are already spent when the crop fails. Example: 120,000.
The ruler
From your own book, the sales invoice or the co-op statement. At least three years, separated by a space. Example: 92 78 115 104 88 130 96 85.
From the same field, in the same unit, at least three years. A total loss year goes in as a zero. Example: 58 62 49 66 61 55 63 60.
As a percentage, if the series is not at hand. The series is better: the figure people estimate from memory usually comes out narrower than the one in the book. Example: 17.
As a percentage, if the series is not at hand. The same warning applies as on the price field. Example: 9.
The shock to test
As a percentage. Pick a drop that has already happened to you, not the worst one you can imagine. Example: 15.
As a percentage, in the same year as the price drop. It is the combination that takes a farm down, not either one alone. Example: 10.

The math runs in your browser. We do not send or store anything you type.

Your result

Enter the revenue you expect and the total cost to see the three room figures. With your own record, or with the typical swing, the index appears; with a drop to test, the result under shock appears.

Take the cycle’s endurance sheet

The report carries your three room figures with a reading for each, the index against your own record, the whole map of the loss with its step written out, the result of the shock you tested and the method caveat, in a document you can print and take to the table where the call gets made.

ArticleHow bad a year can this cycle take before it stops paying?Why the room on yield is larger than the room on price, why the two together are worth half of either one, and why the natural offset between price and weather barely exists at your own farm gate. With the same worked example as this tool, to the number.Read the full article

Room is how far a figure can worsen before the cycle stops paying. Enter the revenue you expect, the total cost and the part of the cost that moves with the harvest, and see the room on price, the room on yield and the room with both at once, plus the whole map of the loss and what that room is worth measured against your own years.

A cycle expecting 900,000 of revenue against 720,000 of cost leaves 180,000, and that room absorbs a 20 percent fall in price alone, a 23.1 percent fall in harvest alone, but only 11.4 percent of each when both fall in the same year, about half of either one on its own.

Read against eight years of this farm’s own prices and yields, that same room held only 0.84 of an ordinary bad year, which is why the tool asks for your own history rather than a generic band, following the USDA method for measuring price and yield risk. A margin that looks comfortable against one shock can vanish against two.