A farm repays its loans from one year's crop and livestock sales, and nobody knows the price, the yield or the interest rate when the loan is renewed. So the lender rebuilds the farm's planned year with worse numbers: corn ten percent cheaper, a short crop, a costlier operating line. What is left after costs and family living, set against the year's loan payments, says whether the farm still repays. The break-even price, the lowest price at which it still does, says how much room it has.
This guide is for anyone who builds, reads, signs or pays for these tests: ag loan officers, credit analysts, ag lending managers and chief credit officers, loan committee members, loan review, and the leaders deciding whether to automate the work. No background needed.
Imagine you are an ag loan officer at a community bank in central Illinois, and you already know the question your loan committee will ask on Thursday: what does cheaper corn do to this farm? It is Monday, October 12, 2026. Voss Family Farms grows corn and soybeans on 2,400 acres in Ford County, 1,000 owned and 1,400 rented from six landlords. Mark Voss wants his $1,450,000 operating line renewed for 2027, and the committee meets Thursday at 2:00 p.m.
The farm's own plan says it repays comfortably. On the bank's planning prices of $4.35 corn and $10.40 soybeans, the year leaves $440,714 to pay $309,036 of mortgage, equipment notes and a planter lease. That is coverage of 1.43, or $1.43 for every $1.00 due, above the bank's 1.25 policy line. Then you drop corn 15%, to $3.70, and leave everything else alone.
The farm's plan · 2027
Corn
$4.35 a bushel
Left to repay
$440,714
Payments due
$309,036
Coverage
1.43
Corn down 15% · same year
Corn
$3.70 a bushel
Left to repay
$250,836
Payments due
$309,036
Coverage
0.81
Stops repaying below $3.90Crop insurance holds 0.69 at worstthe plan sits at 1.43.
The farm's 1,340 acres of corn at 218 bushels an acre lose $189,878 of revenue, and the year falls $58,200 short of its payments. Its working capital, the $742,000 of cash and grain it held above its short-term debts at the end of 2025, would cover that shortfall for years, so the bank would still be paid. Even so, the farm stops paying its debt from its own year once corn is under $3.90, only 10% below the bank's price. Its crop insurance does not help until corn is below about $3.57, because the policy pays only when an acre's revenue falls under the $778 it guarantees.
A stress test finds that $3.90 line, and the gap between it and the insurance floor, before the committee asks.
What a farm cash flow stress test measures, and what the 2026 farm economy asks of it
The repayment arithmetic, where each shock comes from, how crop insurance and government payments change the answer, what the Federal Reserve's 2026 surveys show, and how lenders do the work today. Nothing here sells anything. If you are new to ag credit, start here.
01 · In plain words
Why a lender reruns a farm's year with cheaper corn and a short crop before renewing its line
A grain farm earns most of its money in a few months after harvest, and spends it all year: seed and fertilizer in spring, rent in March and November, machinery payments whenever they fall due. A bank bridges the gap with an operating line, a revolving loan the farm draws in spring and pays down after harvest, and lends on longer terms for land, machinery and grain bins. Every year, usually in the fall or winter, the operating line comes up for renewal, and the bank decides whether to lend again for next season.
To decide, the lender looks at two things. The first is history: five years of the farm's records, restated in the bank's format (a spread), show how much it earned and how its cash cushion moved.
The second is the plan: the farmer's acres, expected yields, prices, costs, rent, insurance and loan payments for the coming year, turned into a projected income and cash flow. From the plan the lender works out how much money the year leaves to pay term debt after operating costs, family living and taxes. That amount is the capital debt repayment capacity, and dividing it by the year's scheduled principal and interest gives the coverage ratio.
The plan is one guess about a year nobody has seen. Corn might sell for less, the crop might come up short, fertilizer might cost more, and a variable-rate operating line costs more when rates rise. A stress test rebuilds the same year with those worse numbers, one at a time and together, and reads the coverage again.
It also asks the reverse question: how far can the corn price, the yield or the rate move before coverage falls to the bank's policy line, and to 1.00, where the farm no longer pays its debt from the year's income? Those values are the break-evens. Bank examiners ask for exactly this: the FDIC calls it evaluating baseline cash flows "under significantly modified projections for key variables, such as input costs, interest rates, and sale prices".1
Two things soften a bad year, and both are easy to misjudge. Crop insurance guarantees a level of revenue per acre, but it pays only when revenue falls below that level, which a price drop on a normal crop often does not reach. Government programs pay when prices or county revenue fall, but they pay about a year later.
What carries a farm through a short year is its working capital, the cash and grain it holds above what it owes in the next twelve months. A good stress test therefore ends with liquidity: how much of that cushion one bad year would use, and what two would leave.
Where the stress test sits in a farm's renewal, from harvest records to committee
The year closes and the records come inVoss Family Farms sends its 2025 Schedule F (the farm page of its tax return), balance sheet and grain inventory. An analyst spreads five years into the bank's format.
The farmer signs next year's planAcres, yields, rent, inputs and insurance for 2027, signed October 2, 2026, with the loan payments that fall due.
The lender stress-tests the planPrice, yield, cost and rate shocks, break-evens and a two-year liquidity check. This is where the $3.90 corn break-even is found, or missed.
The officer writes the recommendationRenew as asked, renew with conditions, or decline; below 1.00 in the bank's downside, the chief credit officer reviews first.
Committee decides, and the year happensHarvest, the October insurance price and next fall's government payments decide what the farm really repays.
Step 3 is the subject of this guide. The farm, the bank and the figures in the example are fictional.
Insurance that pays little, payments a year late: stress test surprises
A price drop on a normal crop often pays no insurance
In 2025 the corn harvest price for crop insurance came in 10.2% below the spring price, yet an 80% Revenue Protection policy paid only where yields were more than 10.9% below the farm's history.2 Most of a price-only shock goes straight to repayment.
Government payments arrive a year late
ARC and PLC, the federal programs that pay when crop prices or county revenue fall, made record payments for the 2025 crop, and they reach farmers in October 2026.3 In a 2027 cash flow, the money that softens a bad 2027 arrives in 2028, after the line has to be paid down.
Working capital hides the trouble for a year or two
After three weaker years, the average Illinois grain farm's working cash fell almost 40% from 2022 to 2025, back to 2020 levels.4 Repayment looks fine while the cushion lasts, and the shortfall shows up later as carryover debt: operating debt the year's sales could not repay.
A 200-point rate shock is mild by recent history
The prime rate went from 3.25% in early 2022 to 8.50% in 2023.5 A 200-point shock adds two percentage points. On a farm whose operating line averages $792,000, each point costs $7,920 a year; most of the risk in a farm budget still sits in price and yield.
Repayment capacity, coverage, working capital and the RP guarantee
Capital debt repayment capacity
What the year leaves to pay term debt: net farm income plus depreciation, term interest and off-farm income, less family living and income taxes.
Term debt coverage
Repayment capacity divided by the year's scheduled principal and interest on term loans and capital leases. 1.25 means $1.25 for every $1.00 due.
Working capital
Current assets (cash, grain, prepaid inputs) less current liabilities (the operating line, accrued rent, this year's principal). The farm's cushion.
Revenue Protection guarantee
The insured revenue per acre: the farm's history yield, times the coverage level, times the higher of the spring and harvest futures prices.
Base case, standard shocks and break-evens: the three parts of a farm stress test
In shortThe base case is the farm's own signed plan at the bank's prices. Standard shocks move one thing at a time by a fixed amount, then several together, and the same set is applied to every borrower. Break-evens run the question backwards and find the price, yield, rent or rate at which coverage meets the policy line and 1.00. A two-year test then asks how much working capital would be left.
Every stress test starts from a base case, and the base case decides how honest the rest is. The FDIC's examination procedures ask whether "Cash flow projections use supportable production yields and price assumptions" and whether "Operating income/expense projections realistically compare to historical averages", before they ask about stress.6
Farm Service Agency rules for guaranteed loans say the same in regulatory language: a standard eligible lender's projections must rest on "the applicant's proven record of production and financial management", and "Lenders must use price forecasts that are reasonable and defensible."7 In practice a lender caps plan yields at the farm's own average and uses its own price deck, a table of planning prices approved by credit administration, so that two officers testing two farms start from the same prices.
Three kinds of test, and what each answers
One at a time
Sensitivity
Corn and soybeans 10% under the deck; yields 15% under plan; the operating rate 200 basis points (two percentage points) higher. Each shows which assumption the farm leans on. Voss: 0.78, 0.45 and 1.37 against a plan of 1.43.
Several together
Downside
A milder move in each, together: price and yield 7.5% lower and the rate 100 points higher. Bad years usually bring more than one bad number. Voss: 0.47.
Backwards
Break-even
Hold everything at plan and solve for the corn price, yield, rent or rate where coverage meets 1.25 and 1.00. Voss: corn $4.16 and $3.90; rent $307 and $362 an acre.
Sensitivity tests are easy to explain and easy to compare across borrowers. Their weakness is that they treat each risk alone, while a drought year brings a short crop and, often, a higher price, and a big national crop brings a normal yield and a low price. The combined downside tries to capture the second kind of year.
The two-year test addresses what a single year cannot: the FDIC's examination manual warns that carryover debt, the operating debt a farm cannot repay from one year's sales, "tends to contain a greater degree of credit risk".8 A farm that survives one bad year on its working capital may not survive two.
Which shock bites which kind of farm
The shock that matters most depends on what the farm sells and what it owns
How hard each standard shock typically hits five kinds of operation, before insurance
LowMediumHigh
Crop price −10%Short crop −15%Inputs +10%Rate +200 bpLivestock price −15%Grain farm, mostly cash-rented landHighHighHighMediumLowGrain farm, mostly owned landMediumMediumMediumMediumLowGrain plus a cow-calf herdMediumMediumMediumMediumHighDairyMediumMediumHighMediumHighHog finishing under contractLowLowMediumHighLow
Our reading of the sources1,6,9,10 · Our judgment from the sources' descriptions of each risk. Cash rent and borrowed land raise fixed costs, so price and yield shocks bite harder; contract finishers are paid a fee and carry building debt, so rates matter more than prices.
Show the numbers
Crop price −10%
Short crop −15%
Inputs +10%
Rate +200 bp
Livestock price −15%
Grain farm, mostly cash-rented land
High
High
High
Medium
Low
Grain farm, mostly owned land
Medium
Medium
Medium
Medium
Low
Grain plus a cow-calf herd
Medium
Medium
Medium
Medium
High
Dairy
Medium
Medium
High
Medium
High
Hog finishing under contract
Low
Low
Medium
High
Low
The same shocks for every borrower, the farm's own numbers in each. A shock set is credit policy: who approves it, when it changes, and which prices it starts from. A set applied to the bank's average farm says little about any one borrower, because the same 10% price drop moves a cash-renter with thin margins far more than a farm that owns its land. The test is only as good as the farm's own acres, yields, insurance and debt underneath it.
03 · The rules and their dates
What examiners, FSA and the 2025 farm law ask of a farm cash flow test, as of October 2026
Status as of October 2026
In shortNo regulation sets a coverage number. Bank supervisors expect lenders to analyze each borrower's cash flow on supportable assumptions and to test it under worse ones, and they examine the bank against its own policy. FSA requires a feasible plan for guaranteed loans. The 2025 reconciliation law changed the commodity programs and crop insurance that every farm cash flow now contains, and the farm bill itself was still unfinished at the end of October 2026.
The rules and programs under a 2027 farm budget changed between July 2025 and October 2026
Jul 4, 2025Reconciliation law signed
P.L. 119-21: higher reference prices, ARC at 90%, bigger crop insurance subsidies, 2025–2031 crop years.
Feb 20262026 insurance prices set
Corn $4.62, soybeans $11.09 from February futures.
Apr 17, 2026SR 26-2 replaces SR 11-7
Model risk guidance revised; spreadsheet arithmetic outside the definition.
Apr 30, 2026House passes a farm bill
H.R. 7567, 224–200.
May 1, 2026Section 1071 rewritten
Agricultural lending excluded from small business data collection.
Sep 30, 2026Farm bill extension ends
The one-year extension of 2018 provisions runs out; the Senate committee bill is not law.
Oct 1, 2026FSA delegated feasibility
Lenders with delegated authority certify financial feasibility for guarantees.
Oct 2026Record ARC/PLC payments
2025 crop payments, about $13.2B to $13.8B, reach farmers.
Dec 11, 2026ARC/PLC election deadline
Farmers choose a program for 2026 base acres.
Feb 20272027 insurance prices set
The bank's planning prices give way to the real projected prices.
Analysis "that centers on a borrower's cash flow and repayment capacity and that does not overly rely on collateral values"; sound practice evaluates baseline cash flows "under significantly modified projections for key variables".1
January 28, 2020, in force (FIL-39-2014 is now on the FDIC's inactive list)
FDIC examination module, agricultural lending
Supportable yields and prices; projections compared with history; baseline cash flows "evaluated using modified/stressed projections for key variables, such as input costs, interest rates, yield assumptions, and sale prices"; carryover debt "clearly identified in loan files".6
Module dated 05/18, current
FDIC examination manual, loans
"The primary repayment source for intermediate and long-term agricultural loans is not collateral but cash flow from ordinary operations"; financial information "updated not less than annually".8
Section 3.2, revised 3-2026
Federal Reserve SR 11-14
Names "cash flow stress test analysis" and "A sensitivity analysis that determines a farm operation's ability to withstand risk and uncertainty".17
2011, revised February 26, 2021, active
FSA guaranteed loans, 7 CFR 761.2 and 762.125
A feasible plan, "sufficient cash inflow to pay all cash outflow"; price forecasts "reasonable and defensible".7 From October 1, 2026, lenders with delegated authority certify feasibility themselves.16
2026 CFR; rule effective October 1, 2026
Crop insurance, 7 CFR 457.8 and 457.113
Defines the Revenue Protection guarantee and how a loss is settled, which is what a lender may count as a floor.18,19
Last printed in the 2026 CFR; since May 1, 2026 the policies are no longer printed in the CFR and continue as contracts published by USDA's Risk Management Agency20
P.L. 119-21, Title I
New reference prices, ARC terms and payment limits for 2025–2031; higher premium subsidies and wider area coverage.11
Signed July 4, 2025
SR 26-2 / OCC 2026-13 / FDIC FIL-15-2026
Model risk guidance; "simple arithmetic calculations, such as those found within spreadsheets" fall outside its definition of a model.13
April 17, 2026
CFPB section 1071 rule
Small business lending data collection; the 2026 rewrite "excludes merchant cash advances (MCAs), agricultural lending, and small dollar loans".14
91 FR 23530, May 1, 2026
What the 2025 law changed in a farm's cash flow
Commodity programs, 2025–2031 crop years
Statutory reference prices from the 2025 crop: corn $4.10, soybeans $10.00, wheat $6.35.11
ARC-CO guarantee raised to 90% of benchmark revenue and the payment cap to 12% of it.11
Payment limit raised from $125,000 to $155,000, adjusted for inflation each year.11
For the 2025 crop only, farms get the higher of the ARC-CO and PLC payment whatever they enrolled in.11,3
Crop insurance
Premium subsidy for basic and optional units up 3 to 5 points: 80% coverage from 48% to 51%, 85% coverage from 38% to 41%.11
The Supplemental Coverage Option covers to 90% with an 80% subsidy, and can be bought on ARC acres.11
farmdoc's 2026 decision tools built in the higher subsidies, which "should result in lower farmer premium costs for most policies".12
A farm bill still in progress. The House passed its farm bill on April 30, 2026; the Senate Agriculture Committee reported its own on September 16; the one-year extension of 2018 farm bill provisions ran to September 30, 2026.15 The commodity programs a crop budget depends on were already written into P.L. 119-21 through the 2031 crop year, so a stress test can count ARC and PLC on today's terms. Programs outside that law, and any new disaster aid, should be treated as unknown until enacted.
04 · The repayment math
How to calculate term debt coverage and working capital for a farm, line by line
In shortStart from net farm income, add back depreciation and the interest on term debt, add off-farm income, take off family living and income taxes. That is what the year leaves to pay term debt. Divide it by the year's scheduled principal and interest on term loans and capital leases. Then roll working capital forward: last year's balance plus or minus the year's margin.
Capital debt repayment capacity = net farm income + depreciation + interest on term debt + off-farm income − family living − income taxes Term debt and capital lease coverage = repayment capacity ÷ scheduled principal and interest on term debt and capital leases
These are the Farm Financial Standards Council measures that extension economists and most ag lenders use.21,22 Purdue's Michael Langemeier describes the coverage ratio simply: "divide capital debt repayment capacity by principal and interest on term debt", and a ratio above one means the payments can be covered.22 A replacement margin goes one step further and also subtracts the cash a farm needs to keep its machinery from wearing out, which he suggests measuring as depreciation plus 10 to 20 percent.22
The fictional case used through this guide. Every line traces to a document: the signed crop plan, the 2025 spread, the debt statements.
The margin, $131,678, is the number a stress test spends. Each shock is a dollar amount taken out of it: a 10% drop in both crop prices removes $198,370, more than the whole margin, which is why coverage falls to 0.78. A 15% short crop removes $302,597 of revenue. A 200-point rate rise on an operating line that averages $792,000 removes $15,840. Writing each shock as dollars against the margin makes the result easy to explain to a committee and to the borrower.
Liquidity: the second half of the test
Working capital is the farm's cushion. Iowa State's extension economists note that working capital "measured at the beginning of the year is typically equal to about 50–70% of the farm's annual gross revenue" on the Iowa farms they track, and that "cash grain farms may need as much as 50%".21 Lenders set their own floors; many use a share of gross revenue so that the floor scales with the farm. A two-year test subtracts the stressed margin twice from today's working capital and compares what is left with that floor.
Iowa farms' working capital fell to 51 cents per dollar of revenue in 2025, the lowest in a decade
Working capital in cents per $1 of gross revenue, Iowa Farm Business Association farms, December 31
Illinois shows the same slide. Across 2,018 Illinois farms in the Farm Business Farm Management association, average working capital was $361,826 at the end of 2025 and the current ratio 2.49, against 3.52 in 2022; on grain farms, "working cash has decreased almost 40 percent from 2022 on the average farm to 2020 levels".4 A cushion that thin turns a one-year shortfall into a renewal problem quickly.
05 · Price shocks
Where a lender's price deck comes from, and how big a price shock history supports
In shortLenders build next year's planning prices from futures for the harvest months, less the local basis, and check them against USDA's WASDE and university budgets. In October 2026 those sources pointed to about $5 corn and $12 soybeans for 2027 in central Illinois. History says a 10% price shock is gentle: corn's harvest price fell by more than 18% in a single year four times since 2006.
A bank's price deck is its planning price for each commodity next year. The usual starting point is the futures contract for the harvest month (December corn, November soybeans), less the typical difference between that futures price and the cash price local elevators pay at harvest, the basis.
The University of Illinois economists who publish the state's crop budgets build theirs the same way: "Price assumptions are based on current harvest futures for the 2027 crop, adjusted for typical basis in Illinois."9 USDA's monthly World Agricultural Supply and Demand Estimates (WASDE) give a second, national view of the season-average price.
$4.70 corn
USDA's season-average price forecast for the 2026/27 crop, down 10 cents from September; $4.16 for 2025/26. Soybeans: $12.00, against $10.50.23
WASDE-676, October 9, 2026
$5.00 corn
The 2027 planning price in the University of Illinois budgets for central Illinois, with $12.00 soybeans, 245-bushel corn and $321 cash rent.9
farmdoc daily, September 1, 2026
~$5 break-even
"Total costs, including cash rent on rented farmland, imply break-even prices of around $5 per bushel for corn and $11 per bushel for soybeans" in northern and central Illinois.9
farmdoc daily, September 1, 2026
The last two numbers together explain the mood of 2026: planning prices sit only just above the cost of growing the crop on rented land. The same authors warn that "a $0.50 move in corn prices, which is less than what has been experienced in harvest futures just over the past month, results in a more than $100 shift in returns."9 A deck set a little below the futures curve, as many banks prefer, already builds in some caution; the stress test adds the rest.
How big a shock history supports
Corn's harvest price fell more than 18% in a single year four times since 2006
Largest one-year falls in the U.S. corn price at harvest, ERS cost-and-returns series
2013 ($6.79 → $4.61)32%
2023 ($6.48 → $4.92)24%
2014 ($4.61 → $3.54)23%
2024 ($4.92 → $3.97)19%
2009 ($4.36 → $3.59)18%
2016 ($3.66 → $3.29)10%
Source24 · Our arithmetic from ERS's published harvest prices, rounded to whole percent.
Show the numbers
Year of the fall
Fall in price (%)
2013 ($6.79 → $4.61)
32%
2023 ($6.48 → $4.92)
24%
2014 ($4.61 → $3.54)
23%
2024 ($4.92 → $3.97)
19%
2009 ($4.36 → $3.59)
18%
2016 ($3.66 → $3.29)
10%
Read against that history, a 10% price shock is a common year, and the bank downside of 7.5% is milder still, because it adds yield and rate moves on top. Two lessons follow. First, show the break-even price beside every shock, so the committee sees the room as a distance: Voss stops repaying 10.4% below the deck. Second, test the next year as well, because the big falls of 2013–2014 and 2023–2024 came in pairs.
Cash, futures and the basis. The farm sells at the local cash price; crop insurance values the crop at a futures average (section 07). When the basis widens, cash revenue falls further than insured revenue. Keep the two prices apart in the cash flow: the deck in cash terms for sales, futures terms for the insurance guarantee, and a basis assumption between them.
06 · Yield and cost shocks
Short crops and costlier inputs: sizing the yield and cost shocks from USDA's own data
In shortA 15% yield shock is roughly what the 2012 drought did to the national corn yield; on one farm, losses can be far deeper. Input costs moved even more: USDA's corn operating cost per acre rose 47% from 2021 to 2022 and is forecast near $473 for 2026 and 2027. A cost shock matters most to farms that rent their land, because their margin is thinnest.
National yields hide most of a single farm's risk, yet they show the scale. ERS's series puts the U.S. corn yield at 146 bushels an acre in 2011 and 118 in the 2012 drought, a 19% fall.24
On one farm a hailstorm or a dry July can take more than that, which is what crop insurance exists for. A sound plan yield is the farm's own average, capped there even when the borrower expects more; the FDIC's examiners look for "supportable production yields".6 The Voss plan uses 218 bushels against a five-year average of 219 and an insurance history of 221.
What it costs to grow an acre of corn
Corn's value at harvest barely covered operating costs in 2024 and 2025
U.S. corn, dollars per planted acre: harvest price × yield against operating costs (seed, fertilizer, chemicals, fuel, repairs, custom work, interest)
Operating costsValue at harvest
2021$353$943
2022$519$1,166
2023$480$915
2024$435$754
2025$456$778
Source24 · Value at harvest = ERS harvest price × ERS yield per planted acre, our arithmetic. Land, machinery ownership and overhead are not in operating costs; ERS's total costs listed for 2025 were $900.52 an acre.
Show the numbers
Operating costs
Value at harvest
2021
$353
$943
2022
$519
$1,166
2023
$480
$915
2024
$435
$754
2025
$456
$778
The gap between the two bars is what pays for land, machinery, the family and the debt. In 2025 it was about $322 an acre, while ERS put the total cost of an acre, land and machinery included, at $900.52.24 For 2027 ERS forecasts operating costs of $473.34 an acre and total costs of $952.09.25
Fertilizer and seed make up 62% of the corn operating bill forecast for 2027
U.S. corn operating costs per planted acre, 2027 forecast
$473per acre
Fertilizer$179.12
Seed$114.66
Repairs$52.15
Chemicals$49.25
Custom operations$39.69
Fuel, interest and other$38.47
Source25 · Fuel, lube and electricity $30.59, interest on operating capital $7.57, other $0.31.
Show the numbers
Part
Value
Fertilizer
$179.12
Seed
$114.66
Repairs
$52.15
Chemicals
$49.25
Custom operations
$39.69
Fuel, interest and other
$38.47
A cost shock is usually written as a percentage of seed, fertilizer and chemicals, the inputs whose prices swing. For Voss those come to $802,360 in the plan, so each 1% costs about $8,000. The farm's fader in Part B shows it stops repaying once those inputs rise 16%. Cash rent is the other big fixed cost. Voss rents 1,400 acres at an average $268; its rent break-even is $362 an acre for 1.00 coverage.
Fertilizer is the swing item. ERS's 2026 income forecast has fertilizer, lime and soil conditioner spending up $5.3 billion, or 15.3%, nationally.26 A plan signed in October before fertilizer is priced carries that risk, and a cost shock is the place to show it.
07 · Crop insurance as a floor
How Revenue Protection puts a floor under a farm's revenue, and where the floor sits
In shortRevenue Protection guarantees the farm's history yield, times its coverage level, times the higher of the spring and harvest futures prices. It pays the difference only when the crop's value at the harvest price falls below that guarantee. A modest price drop on a normal crop usually stays above the guarantee and pays nothing; a deep drop or a short crop meets the floor. That floor is why a farm's coverage curve goes flat.
Revenue Protection guarantee per acre = approved yield (APH) × coverage level × the higher of the projected price and the harvest price Indemnity = guarantee − (bushels harvested × harvest price), when positive
The definitions are in the policy's Basic Provisions, last printed in the federal regulations in the 2026 edition; since May 1, 2026 USDA publishes the policies on its Risk Management Agency site instead, with coverage unchanged.20 The Basic Provisions define the revenue protection guarantee as the production guarantee multiplied "by the greater of your projected price or your harvest price", and the harvest price as the price "used to value production to count".18 The coarse grains provisions settle a claim by subtracting the value of the production to count, at the harvest price, from the guarantee.19
For corn the projected price is the average of the December futures contract over February and the harvest price its average over October.12,2 In February 2026 those rules set corn at $4.62 and soybeans at $11.09.12
The 2025 example: a 10% price fall that paid little
In 2025 the corn projected price was $4.70 and the harvest price $4.22, 10.2% lower; soybeans fell 1.8%, from $10.54 to $10.35. University of Illinois economists worked out that at 80% coverage, corn yields had to be "more than 10.9% below APH" before Revenue Protection paid, and soybean yields more than 18.5% below.2 They wrote that payments in Illinois "are not expected to be widespread or large".2 A lender who had counted insurance as covering a 10% price fall would have been wrong in most of the state.
The floor on one farm
Voss stops repaying below $3.90 corn, and insurance holds coverage at 0.69 below about $3.57
Term debt coverage in 2027 as the corn price moves, everything else at plan, Revenue Protection 80% on 221-bushel history
00.511.521.85
$3.30$3.57$3.80$4.00$4.25$4.50$4.80
Fictional example from this guide · Guarantee 221 × 80% × $4.40 = $778 an acre; insurance pays once 218 bushels × price falls below it, about $3.57. The example treats the cash price as the harvest price; with a negative basis the floor sits lower.
Show the numbers
Coverage of term debt
$3.30
0.69
$3.45
0.69
$3.57
0.69
$3.70
0.81
$3.80
0.91
$3.90
1
$4.00
1.1
$4.16
1.25
$4.25
1.33
$4.35
1.43
$4.50
1.57
$4.65
1.71
$4.80
1.85
The curve has three parts. Above $4.16 the farm meets the bank's 1.25. Between $3.90 and $4.16 it repays, with less room than policy wants. Below $3.90 it no longer covers its term payments from the year, and below about $3.57 insurance makes up the corn revenue lost, so coverage stops falling at 0.69. Soybeans behave the same way at their own guarantee, $563 an acre: Voss's soybean price alone cannot push coverage under 1.00, because the floor catches it first.
What changes the floor
Coverage level (85% raises Voss's corn guarantee to $827 an acre for about $20,000 more premium across both crops), unit structure (enterprise units pool every field in the county), the area add-ons SCO and ECO, and the harvest price option. The 2025 law made higher coverage cheaper by raising subsidies.11
What a lender should count
Only the policy on file: plan, units, coverage, approved yield, and an assignment of indemnity to the bank if policy requires one. FDIC guidance treats "informed use of crop insurance and appropriate hedging products" as reducing risk to the farm and the lender.1 Forward sales count only as contracts on file.
Livestock has no automatic floor. Calves, fed cattle, hogs and milk are outside Revenue Protection. Feeder cattle can be covered by Livestock Risk Protection, which pays when prices fall below the coverage price bought; its premium subsidy runs from 35% at the highest coverage levels to 55% at 70% to 80%, and losses to the buyer are capped at the premium.10 A stress test should show a livestock price shock with no floor unless the farm holds such a policy or a contract.
08 · Government payments
ARC, PLC and ad hoc aid after the 2025 law: what to count in a farm cash flow, and when
In shortGovernment payments made up much of 2026 farm income: ERS forecasts $47.4 billion, of which $26.5 billion is ad hoc and disaster aid. ARC and PLC are written in law to 2031 and pay a year after the crop. A stress test should count ARC and PLC in the year the cash arrives, estimated at the stressed price where the program would pay more, and leave unenacted aid out.
Government payments rose to $47.4 billion in 2026 while net farm income held near $158 billion
U.S. net farm income and direct government payments, $ billions, 2026 forecast
Net farm incomeDirect government payments
050100150200158.447.4
20192020202120222023202420252026F
Source27 · Nominal dollars. ERS, data as of September 3, 2026.
Show the numbers
Net farm income
Direct government payments
2019
82
22.4
2020
98.9
45.6
2021
146.3
26
2022
182
15.6
2023
146.8
12.3
2024
128.3
10.1
2025
162.6
27.9
2026F
158.4
47.4
ERS's September forecast puts net farm income at $158.4 billion in 2026, down 2.6% from 2025, with direct government payments up 69.8% to $47.4 billion.28,26
Of that, $26.5 billion is supplemental and ad hoc disaster assistance, mainly the Farmer Bridge Assistance Program and the American Relief Act's supplemental disaster assistance, and $15.6 billion is commodity program payments tied to prices or revenue, mostly ARC and PLC, up $13.4 billion largely because the 2025 law changed the 2025 crop year ARC and PLC programs.26 A Kansas banker told the Kansas City Fed that "Government ad hoc disaster payments are keeping conditions manageable for most producers."29
The 2025 crop's record payments, paid in October 2026
2025 ARC/PLC payments averaged $51 per base acre of corn, paid a year after the crop
Average 2025 ARC-CO or PLC payment per base acre, after the 85% payment factor and before 5.7% sequestration
farmdoc estimates total 2025 payments at just over $13.2 billion against USDA's publicized $13.8 billion; either is a record. Corn base acres collect about $4.7 billion, soybeans $1.5 billion and wheat $2.9 billion, and "producers should receive by the end of October".3 For 2026 farms choose ARC or PLC again by December 11, 2026.3
Count
ARC and PLC, in the right year
The payment for crop year 2026 arrives in late 2027; for 2027, in late 2028. Use base acres and the program on file, and the marketing-year price behind the payment.
Recompute
At the stressed price
PLC pays when the season-average price falls below the effective reference price, so a price shock raises a later PLC payment. Show it as cash in the year after the crop.
Leave out
Aid that is not law
Ad hoc and disaster programs arrive by separate act and on their own timing. Count them only once enacted, and mark them as one-off in a multi-year test.
Some summaries still quote an April 2026 reading of USDA's earlier forecast, with $624.7 billion of farm debt and $44.3 billion of payments.30 ERS's September 3, 2026 forecast replaced those figures.28
09 · Interest-rate shocks
Interest-rate shocks on a farm operating line: what 2022–2026 rates teach about the right size
In shortMost farm operating lines float over prime, so a rate shock passes straight into interest expense on the average balance. Prime rose 5.25 points in about sixteen months in 2022–2023, fell back to 6.75%, and rose to 7.00% in September 2026. Farm interest expense is forecast at a record $33.4 billion in 2026, 76% above 2021.
The prime rate went from 3.25% to 8.50% in about 16 months, then eased to 7.00%
Bank prime loan rate, January and July of each year, and October 2026
0%2.5%5%7.5%10%7%
Jan 21Jan 22Jan 23Jan 24Jan 25Jan 26Oct 26
Source5 · Monthly averages (MPRIME); October 2026 from the daily series (DPRIME), 7.00% since September 17, 2026.
Show the numbers
Prime rate (%)
Jan 21
3.25%
Jul 21
3.25%
Jan 22
3.25%
Jul 22
4.85%
Jan 23
7.5%
Jul 23
8.29%
Jan 24
8.5%
Jul 24
8.5%
Jan 25
7.5%
Jul 25
7.5%
Jan 26
6.75%
Jul 26
6.75%
Oct 26
7%
Ag lenders in the Seventh Federal Reserve District reported average operating-loan rates of 7.63% in the second quarter of 2025, 7.08% in the first quarter of 2026 and 7.12% in the second.31,32 A farm with a $792,000 average balance pays $7,920 more interest a year for each percentage point. That is why a 200-point shock barely moves Voss (1.43 to 1.37) while a 10% price move takes it under 1.00. The farms that rates do hurt are those with large variable-rate term debt, big carried inventories financed on the line, or a carryover balance that has stopped revolving.
U.S. farm interest expense is forecast at a record $33.4 billion in 2026
Against ERS's earnings before interest, taxes and capital consumption of $241.0 billion for 2026, interest takes about 13.8%, up from 9.3% in 2021 (our arithmetic from ERS's data).27 Farm debt is forecast at $605.1 billion and the sector's debt-to-asset ratio at 13.54%.28 The sector average is low; the farms a lender stress-tests hardest are the leveraged ones within it.
10 · What the Fed surveys say
Weaker repayment, more renewals, thinner working capital: the Fed's 2024–2026 ag credit surveys
In shortRepayment weakened through 2025 and early 2026 and then eased a little. In the Chicago Fed's district, 38% of lenders saw lower repayment in the first quarter of 2026, renewals and extensions hit their highest level since 2020, and 17% of borrowers carried more carryover debt. By the second quarter the share seeing lower repayment had fallen to 27%. Lenders describe 2026 cash flows at or below breakeven, funded from working capital.
Fewer Midwest lenders reported weaker repayment in the second quarter of 2026 than in the first
Seventh District ag lenders reporting each change from a year earlier, % of respondents
Q1 2026Q2 2026
Lower loan repayment rates38%27%
More loan renewals and extensions38%27%
Source31,32 · From Q1 2026 the survey includes Farm Credit System institutions as well as banks, so 2026 is not strictly comparable with earlier years.
Show the numbers
Q1 2026
Q2 2026
Lower loan repayment rates
38%
27%
More loan renewals and extensions
38%
27%
The Chicago Fed's May AgLetter quoted an Iowa lender: "cash flow projections for many operations are at or below breakeven for 2026." Lenders reported many borrowers drawing down working capital to cover the shortfalls, a repayment index of 63, down from a year earlier for the tenth quarter running, and a renewals and extensions index of 136, the highest since the second quarter of 2020.31 By August the repayment index was 73 and renewals 124, still worse than a year earlier but less so.32
About 17 in 100 Midwest farm borrowers carried more carryover debt into 2026
17 in 100
farm borrowers with more carryover debt in 2026 than in 2025, on average across Seventh District lenders
farm borrowers with more carryover debt in 2026 than in 2025, on average across Seventh District lenders
17 of 100
Other districts tell a similar story with local twists. In Minneapolis and St. Louis, the share of lenders reporting lower repayment fell "from an average of around 50% in 2025 to about 30%" by mid-2026, and in the Kansas City district "cattle revenues have been particularly supportive".33 There, "less than 10%" of farm loan balances had major or severe repayment problems in the second quarter, and a Nebraska banker described row-crop producers with "very strained cash flows for 2026".29
The Minneapolis Fed's October survey found 41% of bankers flagging a potential decline in agricultural loan quality, and one expected "operating loan renewals heading into 2027 being more closely scrutinized".34
Losses are still low, which is when stress tests earn their keep
Problem loans remain modest. At June 30, 2026, FDIC-insured institutions held $89.1 billion of farm loans, and at agricultural banks the noncurrent rate in the category the FDIC calls all other loans and leases, which holds farm production loans, was 0.68%.35 Farm Credit System nonperforming assets were $5.0 billion, 1.09% of loans.36
In Illinois, net farm income on Farm Business Farm Management farms recovered to an average $97,674 in 2025 from $18,358 in 2024, though returns to the operator's labor and management were still negative.37 Credit trouble in agriculture usually lags the income squeeze by a year or two, as working capital runs down; the surveys describe that middle stage.
11 · What goes wrong
Ten ways a farm stress test flatters the borrower, and the check that catches each
In shortMost errors make a farm look safer. Insurance counted where it would not pay, government money counted in the wrong year, yields above the farm's history, family living left low, and a one-year test where two bad years are the real risk. Each has a simple check, and most can be built into the template once.
#
Error
Why it happens
The check
In the base case
1
Plan yields above the farm's own history
The borrower's plan is optimistic, and nobody caps it
Cap at the five-year average or the insurance history; examiners want "supportable" yields6
2
Family living and taxes too low
Last year's figure carried forward
Bank floor per household; off-farm income from documents
3
A capital lease or a guaranteed obligation left out of payments
It is not on the bank's own loan system
Payments built from every statement and the balance sheet
In the shocks
4
Insurance counted against a price-only shock
"The farm is insured" is read as "the revenue is insured"
Compute the indemnity from the policy; it is often zero2
5
Cash prices used for the insurance guarantee
One price column in the spreadsheet
Futures for insurance, cash for sales, basis between
6
ARC/PLC or ad hoc aid counted in the crop year
Payments are tied to the crop, cash arrives a year later3
Count in the year received; leave out aid not yet law
7
Rate shock applied only to new borrowing
Variable term debt and the existing line are forgotten
Shock every variable rate on its average balance
8
Livestock left out of a crop shock set
Standard shocks move crops only
A livestock price shock for every farm with animals to sell
In the conclusion
9
One bad year tested, two not
The first year is carried by working capital
Subtract the stressed margin twice; compare with the floor
10
Carryover debt not identified
It is rolled into the new line
Separate it, as examiners expect: "clearly identified in loan files"6
Fix first the common errors that move coverage most: insurance on a price shock and yields above history
How far it can move coverage →
Check on large credits
Fix first
Sample in loan review
Build into the template
Insurance on a price fallYields above historySecond year untestedRate on new debtLease left outAid in wrong yearFamily living low
How often we would expect it →
Illustrative · replace with your own numbers · Positions are our judgment; no public study counts errors in farm cash flow projections.
Show the numbers
Item
How often we would expect it (0–1)
How far it can move coverage (0–1)
Insurance on a price fall
0.80
0.76
Yields above history
0.72
0.56
Second year untested
0.12
0.64
Rate on new debt
0.10
0.22
Lease left out
0.19
0.15
Aid in wrong year
0.28
0.09
Family living low
0.88
0.18
Langemeier's 2016 case farm shows how fast the arithmetic turns. On a 3,000-acre west central Indiana farm with 2,250 acres cash-rented, a price 10% below futures took projected net farm income from about $48,000 to a loss of about $127,000, and made repayment capacity "worrisome".38 The more of a farm's costs are fixed in rent and payments, the more of a price move reaches net income.
12 · Automation and AI
Software and AI in farm stress testing: what the 2026 model guidance covers, and what stays with the lender
Status as of October 2026
In shortReading the farm's records, rebuilding the cash flow and solving break-evens are arithmetic and fixed rules, which the April 2026 model risk guidance places outside its definition of a model. Generative AI is outside that guidance altogether and falls to the bank's own governance. What supervisors still examine is the analysis: supportable assumptions, documented shocks, and a person accountable for the recommendation.
SR 26-2, issued on April 17, 2026 with OCC Bulletin 2026-13 and FDIC FIL-15-2026, defines a model as "a complex quantitative method, system, or approach that applies statistical, economic, or financial theories to process input data into quantitative estimates", and excludes "simple arithmetic calculations, such as those found within spreadsheets, as well as deterministic rule-based processes".13 A footnote places generative AI, and AI that acts on its own, outside the guidance's scope, while the bank's own risk management "should guide the determination of appropriate governance and controls" for them.13
Most of a farm stress test is arithmetic outside the model guidance; forecasts and AI reading are not
Does the 2026 model risk guidance, or the bank's own governance, apply to each part of an automated stress test?
NoYes
Model guidanceBank's own governanceExaminer review of the analysisReading spreads, plans and policiesNoYesYesRebuilding the cash flow line by lineNoYesYesApplying fixed shocks and solving break-evensNoYesYesStatistical yield or price forecastsYesYesYesDrafting the scenario note with generative AINoYesYesThe recommendation and signatureNoYesYes
Our reading of the sources13,6 · Our reading of SR 26-2 for a tool that reads documents and computes by fixed rules. Your counsel and model risk team decide.
Show the numbers
Model guidance
Bank's own governance
Examiner review of the analysis
Reading spreads, plans and policies
No
Yes
Yes
Rebuilding the cash flow line by line
No
Yes
Yes
Applying fixed shocks and solving break-evens
No
Yes
Yes
Statistical yield or price forecasts
Yes
Yes
Yes
Drafting the scenario note with generative AI
No
Yes
Yes
The recommendation and signature
No
Yes
Yes
Three properties make an automated test checkable. Every line of the rebuilt cash flow should show its formula and the document it came from, so a committee member can follow the $440,714 to the plan, the spread and the statements. Prices should come only from the bank's approved deck or from a value an officer typed, labeled as such. And the software should test and draft while a named officer recommends, because the FDIC's guidance puts the analysis on the bank's management, whoever builds the spreadsheet.1
Software reads documents and does arithmetic. Judging the farmer's management, a landlord's plans or a family's succession remains the officer's work.
Insurance and hedges count only when the policy and contracts are on file.
A shock set is credit policy. Its owner, its version and its approval belong to the chief credit officer or a committee.
13 · How teams do it today
Who rebuilds the farm spreadsheet for every what-if today, and where the analyst's day goes
In shortAn analyst spreads the farm, a loan officer gathers the plan, someone rebuilds the cash flow in a spreadsheet for each scenario, and the officer carries the result to committee. The rebuilding is where the day goes, and it happens again for every new question. Renewals bunch up between harvest and planting, when every farm's question is asked at once.
Five roles around one farm renewal
LO
Ag loan officer
Owns the relationship, collects the plan and the insurance summary, meets the borrower, writes the recommendation and its conditions.
Cares about: an answer while the borrower is still in the meeting.
CA
Credit analyst
Spreads five years of records, builds the projection, reruns it for each shock and each question the committee raises.
Cares about: building each farm's projection once and reusing it for every question.
LM
Ag lending manager
Owns the renewal calendar and the committee packet; sees which borrowers are thin.
Cares about: every renewal tested the same way before it goes in.
CC
Chief credit officer
Sets the price deck and the standard shocks, reviews weak downsides, chairs committee.
Cares about: the price where each farm stops covering its debt.
LR
Loan review and examiners
Test whether assumptions were supportable and whether carryover was identified.
Cares about: evidence that follows from number to document.
From renewal file to committee, re-keyed for each scenario
A renewal's stress test passes through three people and is rebuilt for every new question
Five years into the bank's format, accrual-adjusted.
Credit analyst
Hours
Projection built
Revenue, costs, interest, family living, payments, working capital.
Credit analyst
Half a day
Shocks and break-evens
Each scenario re-keyed or copied; break-evens by trial.
Credit analyst
Hours per set
Memo and committee
Recommendation, conditions, questions that send it back.
Officer, committee
By calendar
An illustrative day, most of it re-keying
Most of a spreadsheet stress test is re-keying, before any judgment
Hours for one farm's what-if by spreadsheet, about a day
Re-keying spreads, plan and leasesDebt schedule and insurance guaranteeRunning shocks and break-evensWriting up for committeeOfficer review
By spreadsheet3 h1.5 h2 h1 h
Illustrative · replace with your own numbers · An estimate of about eight hours; no public source measures it. Time three of your own renewals.
Show the numbers
Re-keying spreads, plan and leases
Debt schedule and insurance guarantee
Running shocks and break-evens
Writing up for committee
Officer review
By spreadsheet
3 h
1.5 h
2 h
1 h
0.5 h
The fall calendar adds pressure. Farm records for the year just ended arrive in winter; many renewals are decided between harvest and the spring input purchases, and committees ask new what-ifs as markets move. A question asked on Thursday, such as "what does $3.90 corn do?", often comes back the following week, after the committee has decided.
Spreadsheets, university tools or lending software
In house
Spreadsheets
A projection workbook per borrower, copied each year. Flexible; the weak points are formulas overwritten with typed numbers, shocks applied differently by different analysts, and no link from a figure to its document.
University tools
Farm financial software
Extension and university programs offer spreading, projections and portfolio shocks built on the Farm Financial Standards Council measures. Consistent; still keyed by hand from the farm's records.
Lending software
Loan origination and credit analysis
Modules that spread statements and run scenarios. They differ most on farm specifics: insurance guarantees, government payment timing, livestock and break-evens.
Part B · See it working
Botminds Farm Cash Flow Stress Testing at a fictional Illinois bank, from break-even curve to signed scenario note
Part A described the work without naming a product. This part shows how Botminds does it, at a fictional community bank in central Illinois with an ag book and a renewal season under way. Every farm, person, number and document in the screens is sample data, and the bank's 2027 price deck is part of the fiction.
14 · One renewal, start to finish
Voss Family Farms' $1.45 million line: stress-tested on Monday morning, signed for Thursday's committee
In shortThis is the example from the top of the page, inside the product. Six agents build Voss Family Farms' 2027 cash flow from its own records before the officer arrives, run the bank's standard shocks and solve the break-evens. Erin Kowalski, the ag loan officer, tries corn 15% lower in her meeting with Mark Voss, asks for conditions to be tested, writes her recommendation and signs the note for committee.
1
Every borrower going to committee, already tested
Monday morning, October 12, the renewal list holds nine borrowers and $12.67 million of operating lines. Eight are tested against the bank's standard shocks; one is waiting for its 2025 tax return. Seven pass on their own plans at 1.25, and six fall below 1.00 in the bank's downside, so each needs working capital or conditions to carry it.
Voss Family Farms is first: plan 1.43, downside 0.47, debt break-even at $3.90 corn, note ready to sign. A dairy below 1.00 in the downside is already with the chief credit officer.
The renewal list. Each borrower's request, committee date, coverage on plan and in the bank's downside, the price or yield where it stops repaying, and where its note stands.
2
The farm, built from its own records in 45 seconds
At 7:12 a.m. the agents read the farm's 14 documents. The spread reader restated five years: coverage of 2.31, 2.96 and 2.04 from 2021 to 2023, then about 1.00 in 2024 and 1.12 in 2025, and working capital down from $1,212,000 at the end of 2022 to $742,000, 36% of revenue.
The crop plan and insurance reader took the signed 2027 plan and the Revenue Protection policy; the debt schedule builder listed $309,036 of payments. The base case: 1.43 against the bank's 1.25.
The borrower file. The request and four key measures, five years from the spreads, the 2027 crop plan, and each agent's step with what it found. The sample spread prints 0.96 for 2024; its own 2024 lines work out to 1.00.
3
In the meeting: corn 15% lower, and the curve crosses 1.00
The what-if screen shows the farm's 2027 cash flow on seven faders, with coverage drawn as a curve against the corn price. The corn fader already carries a red tick at $3.90 and an amber one at $4.16. Erin moves corn down 15%, to $3.70: capacity falls to $250,836 against $309,036, coverage to 0.81, a margin of −$58,200.
Below about $3.57 the curve turns flat at 0.69, where the insurance policy makes up the lost revenue. She saves "Corn $3.70" to the credit file, and it joins the comparison and the note.
Corn down 15%. Coverage 0.81, the stop-repaying line at $3.90, and the insurance floor at 0.69 as the screen computes it, with the cash price standing in for the harvest price.
4
Conditions, tested before they go in the note
In the bank's downside the farm covers 0.47, and working capital would fall to $413,230 after two such years, 23% of revenue, under the bank's 25%. Erin asks the assistant to add three conditions: 85% Revenue Protection, 35% of expected corn forward-sold at the co-op's $4.52 bid, and the combine note re-amortized over seven years.
They land as a new column: insurance pays $31,254, payments drop to $283,595, and coverage in the downside rises to 0.73. Two such years leave $588,838 of working capital, 32% of revenue. She adds a fourth condition: working capital of at least $500,000 at each year end.
Scenarios side by side. The plan, the four standard shocks, the downside with conditions and the saved corn scenario, each rebuilt from the same plan, leases, insurance and debt, and judged against policy.
5
A cited note, signed for Thursday
The note drafter wrote the request, base case, stress table, break-evens and liquidity, and the four conditions, with their sources. The recommendation is Erin's, in her words: renew with the four conditions, because the plan meets policy and, with them, working capital carries two downside years.
She signs at 10:35 a.m. with the meaning "Reviewed and recommended". The note goes to the credit file and the October 15 committee packet, and the activity record shows each agent's step and each person's action with the time.
The signed note. Stress table, break-evens and liquidity, the conditions with sources, the officer's own recommendation and signature, and who did what, when.
Voss's conditions keep two downside years above the bank's 25% working capital floor
Working capital after one and two years of the bank's downside, with and without the four conditions
After one yearAfter two years
Bank downside$577.6K$413.2K
Downside with conditions$665.4K$588.8K
Fictional example from this guide · From the comparison screen. The 25% floor is about $443,000 on downside revenue of $1,771,163 and $463,000 with the conditions.
Show the numbers
After one year
After two years
Bank downside
$577.6K
$413.2K
Downside with conditions
$665.4K
$588.8K
The solution's design target is under a minute from a borrower's file to a full stress test, against about a day by spreadsheet; it is a target, to be measured on your own renewals.
15 · Every screen
Twelve screens behind the Voss answer: line-by-line working, a cattle farm with no insurance floor, break-evens and shock settings
In shortOne renewal is the story. These screens show the rest: the what-if on plan, the cash flow worked out line by line, the stress calculator, a cattle farm with no insurance floor, the break-even grid, the coverage chart, the crop plan and debt, the standard shocks and price deck, the bank's thresholds, the signature and the saved scenario.
The what-if, on plan. Every fader carries this farm's own danger zone and its stop-repaying tick; the calf fader is greyed out because Voss has no cattle.
Every line worked out. Each line of the cash flow with its formula, this scenario against plan, and the document it came from: crop plan, 2025 spread, debt statements, insurance policy.
The stress calculator. Presets for the plan and four shocks, any assumption typed or slid, and coverage, margin, working capital and insurance recomputed with each change.
A cattle farm, no floor. Quillmoor Farms covers 1.27 on plan; with no cover on its calves it stops repaying below $303 per hundredweight and falls under 1.25 below $338, $4 under the deck.
The cattle farm, worked out. 220 calves at 5.6 hundredweight and $342 bring $421,344; every line shows how it is built.
Signing. The officer sees what the note says before signing, and the signature records its meaning.
Break-evens. Corn $4.16 and $3.90, yield 209 and 195 bushels, rent $307 and $362, the operating rate 14.0% and 23.7%, and a corn price × yield grid.
What the comparison says. Coverage under each scenario against the policy lines, and plain findings for the officer to judge: price is the risk, rates much less.
Crop plan and debt. Acres, plan and history yields, the insurance guarantee per acre, and every term payment due in 2027.
Saved to the credit file. The officer's scenario, who saved it and when, and each agent's step with a source.
Standard shocks and price deck. One versioned shock set approved by the chief credit officer, the bank's October 1 price deck, and the insurance assumptions every test starts from.
Your thresholds. Coverage on plan and in the downside, working capital, the two-year test and how numbers are built, versioned and on the audit trail.
Select any screen to open it larger. The bank, farms, people and figures are fictional; the price deck and insurance planning prices are the bank's sample assumptions; real market prices are in Part A.
16 · Agents, and who signs
Who does what in a stress-tested renewal: six agents compute and draft, the loan officer signs, the committee rules
In shortEach agent has one job and a limit it does not cross. None writes the recommendation or changes the bank's shocks, and none counts insurance or forward sales that are not on file. The loan officer writes the recommendation and signs; the committee decides; renewals below 1.00 in the bank's downside go to the chief credit officer first.
Agents that read spreads, shock plans and find break-evens
Spread reader
Reads five years of farm spreads, balance sheets and Schedule F into the bank's repayment format, and recomputes coverage, working capital and debt-to-asset for every year.
Never changes a figure from the signed statements; flags a missing year instead of filling it.
Crop plan and insurance reader
Reads the signed crop plan, cash leases, insurance summary and acreage report, and checks plan yields against the farm's own five-year history.
Never assumes coverage that is not on the policy on file; caps plan yields at the five-year average.
Debt schedule builder
Lists every payment due in the year: term notes, capital leases and the operating line's interest, from the loan system and statements.
Never omits a lease or a guaranteed obligation.
Scenario engine
Rebuilds the year under the plan, the standard shocks and any what-if: revenue with any indemnity the policy would pay, costs, interest, repayment capacity, coverage and working capital, every line with its formula and source.
Never uses a price outside the bank's deck or the officer's typed value, and labels which.
Break-even finder
Solves the price, yield, rent and rate at which coverage reaches the policy line and 1.00, one assumption at a time and in pairs, and marks them on every fader.
Never moves another assumption silently; holds the rest at plan and says so.
Scenario note drafter
Writes the scenario note for the credit file: request, base case, stress tests, break-evens, liquidity and any conditions the officer asks for, with their effect and sources.
Never writes the recommendation, or recommends approval or decline.
The officer's signature, the credit chief's review, the committee's decision
Recommends and signsAg loan officerTries what-ifs in the meeting, asks for conditions, writes the recommendation and signs the note "Reviewed and recommended".
Reviews first, below 1.00Chief credit officerSees every renewal whose bank downside is under 1.00 before committee, and alone approves changes to the standard shocks and price deck.
DecidesLoan committeeReads the signed note, with every figure traced to its document, and decides the renewal and its conditions.
Every agent run, saved scenario and signature is on the borrower's activity record with who, what and when; threshold changes are versioned. Agent steps and people's decisions are kept apart.
Erin, Ruth and Mark: the fictional people on the screens
Fictional, from the sample data
EK
Erin Kowalski · ag loan officer, Champaign office
64 borrowers, $96.8 million committed; six renewals to committee on Thursday.
"The committee always asks what four-dollar corn does. I want the answer in the room."
CA
The credit analyst
Spreads every renewal and reviews each note before it is signed.
"I rebuild that spreadsheet forty times a renewal season."
RA
Ruth Abernathy · chief credit officer
Sets the standard shocks and the price deck; chairs loan committee.
"Show me the price where they stop covering their debt."
MV
Mark Voss · Voss Family Farms
Farms 2,400 acres of corn and soybeans with his wife, Jenna, near Paxton.
"What happens to us if corn's under four?"
17 · What goes in and out
What the stress test reads from a renewal file and your credit policy, and the signed scenario note it leaves
In shortIt reads the documents the bank already collects at renewal, uses the bank's price deck, shocks and thresholds, and leaves behind the farm's base case, every scenario with its working, break-evens, a two-year liquidity view and a signed, cited note. The loan system and the credit file stay where they are.
From the borrower
Five years of spreads, balance sheets and Schedule F
The signed crop and livestock plan
Cash leases and the acreage report
The crop insurance summary: plan, units, coverage, history yield
Forward contracts with the elevator
From the bank
The approved price deck and standard shocks
Coverage, working capital and family living thresholds
Term debt and lease statements from the loan system
Who signs, and who changes the shocks
Agents build, shock and solveEach farm's year from its own documents, under your deck, shocks and thresholds
The officer recommends and signs
Every line linked to its document
Outputs
The base case and every scenario, line by line with sources
Break-even prices, yields, rent and rate for 1.25 and 1.00
Working capital after one and two years
Scenarios side by side, judged against policy
A cited scenario note, signed, in the credit file and the committee packet
For each, check whether it has an API, a file feed, or only screens, and who owns it.
Your deck, shocks, thresholds and loan system stay yours
Your spreads
Read as they are, in your format; every year's coverage recomputed from the lines.
Your price deck
Used as approved, versioned; officers' typed prices are labeled as theirs.
Your standard shocks
One set, owned by your chief credit officer, applied to every renewal.
Your thresholds
Coverage on plan and in the downside, working capital, family living and the two-year test as settings.
Your loan system
Stays the system of record for notes and balances; payments are read from it.
Your committee
Receives the same note it reads today, with every figure traced and the officer's own recommendation.
Three rules behind every coverage number
1
Every line shows its working
A formula and a source document for each line, for the officer, the committee and the examiner.
2
Only what is on file counts
Insurance from the policy on file, forward sales from contracts on file, prices from the deck or the officer.
3
Agents test; people decide
Agents build, shock, solve and draft. The officer recommends and signs, and the committee decides.
Part C · Are you ready to automate?
Automating farm cash flow stress tests: what the spreadsheet costs your ag desk, and how to decide
You run an ag lending desk, sit on loan committee, or answer for the credit quality of an ag book. This part is written for you: what slow or wrong stress tests cost today, what automating them could return, whether your team is ready, and what to ask any vendor, including us.
18 · What slow tests cost
What a stress test rebuilt by hand costs an ag lender in hours, late answers and missed carryover
In shortStart from your own numbers, because nobody publishes the hours a farm stress test takes or how often projections are wrong. A few published figures frame them: what an analyst hour costs, how many lenders saw repayment weaken in 2026, and how much interest the farm sector now carries.
$57/hr
a credit analyst's median pay, $83,510 a year or $40.15 an hour, loaded for benefits at a 70% wage share of employer costs.39,40
BLS 2025 wages via O*NET, BLS ECEC June 2026 · our arithmetic
38%
of Seventh District ag lenders saw lower loan repayment rates in the first quarter of 2026 than a year earlier; 27% in the second.31,32
Federal Reserve Bank of Chicago, 2026
$33.4B
of farm interest expense forecast for 2026, a record and 76% more than in 2021.27
USDA ERS, September 3, 2026
The hours are in re-keying and re-running, which software can take
Hours for one farm's stress test and what-ifs, by spreadsheet and with automation
By spreadsheet (estimate)With automation (design target)
Re-keying spreads, plan and leases3 h0.1 h
Debt schedule and insurance guarantee1.5 h0.1 h
Running shocks and break-evens2 h0.1 h
Writing up for committee1 h0.3 h
Officer review0.5 h0.5 h
Illustrative · replace with your own numbers · Neither column is a measurement. Time three of your own renewals; measure the target in a pilot.
Show the numbers
By spreadsheet (estimate)
With automation (design target)
Re-keying spreads, plan and leases
3 h
0.1 h
Debt schedule and insurance guarantee
1.5 h
0.1 h
Running shocks and break-evens
2 h
0.1 h
Writing up for committee
1 h
0.3 h
Officer review
0.5 h
0.5 h
What nobody publishes. There is no public figure for hours per farm stress test, the share of renewals that reach committee with a documented downside, how often a plan's yields exceed the farm's history, or how often counted insurance would not have paid. Vendor claims for these come without a dataset. Measure your own.
Clocking analyst re-keying and next-day committee answers
Cost
Where it hides
How to find your number in a week
Analyst time
Re-keying each farm and re-running each what-if
Time three renewals from file to committee, step by step
Late answers
Committee questions answered the following week
Count last season's renewals that went back for another scenario
Uneven testing
Different shocks on different desks
Pull ten memos; list the shocks each one used
Counted insurance that would not pay
Price shocks treated as insured
Recompute the indemnity from the policy on five files
Carryover found late
Working capital used up before anyone saw it
Borrowers whose working capital fell two years running
Exam and review findings
Assumptions without support, carryover not identified
Your last two exam reports and loan review findings on ag credits
What a thin farm renewal costs that no calculator counts
The renewal approved on a plan nobody stressedOne thin farm carried into a second bad year can outweigh a season of analyst time.
The borrower who wanted the answer in the roomA farmer asking about four-dollar corn hears "we'll get back to you".
Conditions guessed instead of testedHigher coverage, forward sales or a longer note proposed without knowing what each buys.
Knowledge in one spreadsheetWhen the analyst leaves, so do the formulas behind last year's renewals.
Your officers' winterSpent waiting on scenarios, with farm visits put off.
19 · Your return
Analyst hours released per renewal, and how many renewals pay for automated stress testing
In shortPut in your own numbers. The calculator starts from a published analyst wage and asks for the rest: how many renewals you test, the hours a test takes now and after, how many extra what-ifs each renewal brings, and what the tool and your testing cost a year. Every default marked illustrative is an assumption to replace.
Six places automated farm stress tests return value
Analyst time
Built once, from the documents
The farm's year is assembled from its records, and the analyst's time goes to review.
renewals × hours saved per test × loaded hourly cost
What-ifs
Answered in the meeting
Each committee or borrower question becomes a fader move in the meeting.
renewals × extra what-ifs × hours each × hourly cost
Consistency
One shock set, every file
The same versioned shocks on every renewal, and the same break-evens shown to committee.
share of renewals with a documented downside, before and after
Accuracy
Insurance computed from the policy
Each shock gets the indemnity the policy on file would pay, which for a price-only shock is often zero.
files where counted insurance differed from the policy
Early warning
A second downside year tested
Working capital tested over two downside years shows carryover risk before it is carryover.
borrowers under the working capital floor after two years
Exams
Evidence to hand
Every line's formula and document, every scenario's source of prices, every signature's meaning.
hours assembling support for loan review and exams
The calculator: renewals, hours and the volume that covers the cost
Only the hourly cost is built from published figures: the median wage for credit analysts, $83,510, divided by 2,080 hours and by a 70% wage share of employer costs.39,40 Every input marked illustrative is an assumption.
Your volumeHoursYour cost
Illustrative yearly value
Stress-testing time today, valued$0
Analyst time released, valued$0
After your yearly cost$0
Analyst hours released a year0
Renewals a year to cover your cost0
Formulas, per year: Time today = renewals × (hours per test + extra what-ifs × hours each) × hourly cost Time released = renewals × (hours saved per test + extra what-ifs × hours each) × hourly cost After your cost = time released − yearly cost Break-even renewals = yearly cost ÷ (hours released per renewal × hourly cost)
The calculator treats an extra what-if with automation as a fader move of a few minutes, counted as zero. Not counted: officers' and committee time, earlier warning of carryover, insurance assumptions corrected, and exam evidence. Released hours are value only when you decide what they are for: more borrowers per analyst, more farm visits, or deeper review of the thin credits.
The hours released per renewal decide how many renewals pay for the tool
Renewals a year to cover $60,000 of yearly cost, at $57 an analyst hour
Releases 11 hours a renewal96 renewals
Releases 6 hours a renewal175 renewals
Releases 3 hours a renewal351 renewals
Illustrative · replace with your own numbers
Show the numbers
Hours released
Renewals a year
Releases 11 hours a renewal
96 renewals
Releases 6 hours a renewal
175 renewals
Releases 3 hours a renewal
351 renewals
At the defaults (eight hours today, one after, two extra what-ifs of two hours each), a renewal releases eleven hours. A bank testing 150 farm credits a year passes the 96 it needs; a bank testing 40 large, simple credits may not cover the cost, and should know that before buying anything.
Start here20 · Readiness check
How ready your shock set, price deck and renewal files are for automated farm stress testing
In shortPick the answer closest to your team today. Eight questions score 0 to 2; the last is for reflection. The meter adds up your score as you go, and each question says why it matters and what a strong answer sounds like.
1
Volume
How many farm renewals and new ag credits does your team stress-test in a year?
Why it mattersVolume turns hours per test into analyst capacity, and renewals come every year.
A strong answer"About 200, most of them operating lines renewed between November and March."
2
Standard shocks
Is there one written set of shocks and a price deck that every renewal is tested against?
Why it mattersSoftware applies your policy; a policy that lives in each analyst's head has to be written first.
A strong answer"Version 2026-3, approved by the chief credit officer in September, with an October 1 deck."
3
Your baseline
Do you know how long a stress test takes, how often committee sends one back, and how many renewals had a documented downside?
Why it mattersNo public benchmark exists, so your own baseline is the only way to prove an improvement.
A strong answer"About a day each; one in four went back for another scenario last season."
4
Documents
Do renewal files reliably hold the spread, the signed plan, the leases, the insurance summary and the debt statements?
Why it mattersA test can only count what is on file; missing insurance summaries are the commonest gap.
A strong answer"Yes, collected on a checklist; the insurance summary comes from the agent with the assignment."
5
Findings
Have examiners or loan review commented on ag cash flow assumptions, stress testing or carryover in the last two years?
Why it mattersFindings bring deadlines and budget. FDIC examiners look for supportable yields and prices and stressed projections.6
A strong answer"Loan review found plan yields above history on a third of the files it sampled."
6
Systems
Can software reach your spreads, loan system and document store?
Why it mattersFiles in one place with an API set up in weeks; scattered drives take longer.
A strong answer"Spreads export from our tool, the loan system has an API, documents are in one store."
7
Owner and budget
Is there a named owner of ag credit analysis with a budget to change how it is done?
Why it mattersThe work crosses officers, analysts, credit administration and IT; without one owner it stalls.
A strong answer"The ag lending manager owns it, and the chief credit officer sponsors it."
8
Governance
Do you have a way to approve AI in credit work: vendor due diligence, a view under SR 26-2, a named signer and an audit trail?
Why it mattersThe April 2026 guidance leaves generative AI to your own governance.13
A strong answer"Vendor management and model risk have a path for AI tools, and every note needs a named signer."
9
Vision · for reflection
If a committee member asked, mid-meeting, what $3.90 corn does to a borrower, what would have to be true for the officer to answer before the next agenda item?
Why it mattersYour answer lists the gaps: the documents, the deck, the shocks, the people. Each is a candidate job for software or for policy.
A strong answerA short, specific list, for example: "every renewal built from its own documents, one shock set, insurance from the policy on file, and the officer signing."
What your readiness score says about the next step
0–6
Explore
Write down your standard shocks and price deck, time three renewals, and name an owner. Start narrow, for example with the insurance indemnity and the two-year working capital test on every file.
7–11
Ready to pilot
Run a measured pilot on 30 to 50 of this season's renewals beside your current process. Compare hours, questions answered in the meeting, and every difference in coverage, with officers signing every note.
12–16
Ready to implement
Plan the whole desk: your deck, shocks and thresholds as settings, signing roles, links to the loan system and spreads, committee packets, and the evidence loan review and examiners will ask for.
21 · Questions for any vendor
Vendor questions that expose a weak farm stress test: insurance floors, payment timing, whose price deck, and evidence
In shortAsk every vendor the same questions, us included. The answers show how the farm's year is built, how insurance and government payments are counted, whose prices and shocks apply, what evidence you keep, and how you would measure it on your own files.
Ask
A good answer
A warning sign
Building the farm's year
Is the base case built from each farm's own spreads, plan, leases and debt, or from a template farm?
The farm's own documents, each line linked to one
"Enter the key figures"
How are plan yields checked?
Against the farm's history and insurance yield, capped by your rule
The borrower's plan taken as given
Does it handle livestock, contract production and mixed farms?
Each enterprise with its own price and shock
Crops only
Insurance and government payments
How is the crop insurance floor computed?
From the policy on file: plan, units, coverage, approved yield, projected and harvest prices
A flat percentage of revenue
Does it keep cash prices and insurance futures prices apart?
Yes, with a basis assumption you set
One price column
When are ARC and PLC counted, and what about ad hoc aid?
In the year received; aid only once enacted
In the crop year, ad hoc treated as recurring
Your policy
Whose price deck and shocks does it use, and who can change them?
Yours, versioned, changed only by the owner you name
The vendor's defaults, editable by any user
Can officers try their own what-ifs without changing the standard set?
Yes, labeled as the officer's
What-ifs overwrite the standard results
Does it test two downside years against working capital?
Yes, against your floor
One year only
Evidence
Can every number in the note be traced to a formula and a document?
Every line, in one click, for the officer and the examiner
A summary score
Who writes the recommendation?
Your officer, in their own words, with the signature's meaning recorded
"The system recommends"
What is recorded on the audit trail?
Every run, saved scenario, signature and threshold change, with who and when
Final results only
Your data, AI and proof
Which AI models do you use, where do they run, and does our data train them?
Named models, a region you choose, no training on your data, in writing
"Proprietary AI"
How should we classify each part under SR 26-2 and our vendor program?
A part-by-part answer your model risk team can use
"It's all a model" or "none of it is"
Can we test it on our own renewals before we sign?
Yes, beside our current process, with every difference explained
Demo farms only
What will you report from the test?
Hours per test, differences in coverage by cause, and documents it could not read
One accuracy percentage
We found no published independent test of any farm stress testing tool's accuracy, as of October 2026. A side-by-side run on your own renewals is the fairest comparison, and the same run measures your current process.
22 · How to start
A twelve-week side-by-side run on this season's renewals, ending in three numbers
In shortWrite down your shocks and measure your baseline, then run beside your current process on live renewals, then decide on three numbers. Renewal season is the right time: the files are fresh and every committee asks the question.
Write down your standard shocks and price deck, with an owner and a version, and the thresholds the committee uses.
Time three renewals from complete file to committee, and count how many went back for another scenario last season.
Choose 30 to 50 renewals across grain, livestock and mixed farms, with complete files and an approval path to share them.
Run in parallel for six weeks, with officers signing every note and analysts checking every difference.
Decide on three numbers: hours per renewal, questions answered in the meeting, and differences in coverage explained by cause.
A twelve-week pilot ends with a decision on three numbers
Your teamVendor
Write down shocks, deck, thresholds
Time three renewals; pull review findings
Load your policy and connect the files
Choose 30 to 50 renewals
Parallel run on live renewals
Explain every coverage difference
Decide
Week 04812
Illustrative · replace with your own numbers
Show the numbers
Activity
From
To
Write down shocks, deck, thresholds
0
2
Time three renewals; pull review findings
0
3
Load your policy and connect the files
1
4
Choose 30 to 50 renewals
2
4
Parallel run on live renewals
4
10
Explain every coverage difference
6
11
Decide
11
12
Five numbers to record during the side-by-side run
Measure
How
Why
Hours per renewal
Stopwatch from complete file to signed note
The cost case rests on it
Questions answered in the meeting
Committee and borrower what-ifs answered on the spot ÷ asked
The officers' and borrowers' number
Coverage differences
Each difference from the current memo, by cause: yield cap, insurance, payments, arithmetic
Shows which errors you had
Documents not read
Count and type
Sets the file checklist
Downsides documented
Renewals with a downside and two-year test ÷ all renewals
Exam evidence
The full working-session questions: 18 questions in six groups
Bring ag lending, credit analysis, credit administration, loan review, model risk, vendor management and IT into one room. Each question says why it matters, what a strong answer looks like, and the warning sign.
A
Renewals and new ag credits tested a year, by farm type
A1
How many renewals and new ag credits do we test a year, by farm type and size?
Why it mattersMixed and livestock farms need more than crop shocks.
Strong answer · warning sign
Counts by type.
One number, mix unknown.
A2
Above what exposure is a stress test required, and below it what do we do?
Why it mattersThe threshold becomes a setting.
Strong answer · warning sign
Written in policy.
"Officer's call."
A3
Who signs the note, and who reviews weak downsides before committee?
Why it mattersSigning roles become settings.
Strong answer · warning sign
Named roles.
Whoever is free.
B
Prices and shocks
B1
How is our price deck built, and how often is it updated?
Why it mattersFSA asks for price forecasts that are "reasonable and defensible".7
Strong answer · warning sign
Futures less basis, monthly, approved.
Last year's deck.
B2
Which shocks do we apply, and when did we last check them against history?
Why it mattersCorn's harvest price fell more than 18% in four single years since 2006.24
Strong answer · warning sign
Reviewed this year.
Set in 2015.
B3
Do we test livestock prices for farms with animals to sell?
Why it mattersNo insurance floor unless a policy is held.10
Strong answer · warning sign
Yes, with their own shock.
Crops only.
C
Indemnities and program payment timing
C1
Do we compute indemnities from the policy, or assume insurance covers a price fall?
Why it mattersIn 2025 a 10% corn price fall paid little at 80% coverage.2
Strong answer · warning sign
Computed from the policy.
"They're insured."
C2
When do we count ARC, PLC and ad hoc aid?
Why it mattersPayments arrive a year after the crop.3
Strong answer · warning sign
In the year received; aid when enacted.
In the crop year.
C3
Do we hold an assignment of indemnity where policy requires it?
Why it mattersThe floor only protects the bank if the payment reaches it.
Strong answer · warning sign
On file, checked at renewal.
Unknown.
D
Working capital floors and carryover in the test
D1
What working capital floor do we use, and over how many years?
Why it mattersWorking capital carried 2026's shortfalls for many farms.31
Strong answer · warning sign
A share of revenue, two years.
None.
D2
How do we identify and track carryover debt?
Why it mattersExaminers expect it "clearly identified in loan files".6
Strong answer · warning sign
Separate note, tracked.
Rolled into the new line.
D3
Which borrowers lost working capital two years running?
Why it mattersThey are next year's carryover.
Strong answer · warning sign
A list today.
Nobody knows.
E
Where spreads and plans live, and the model risk review
E1
Where do spreads, plans, policies and loan balances live, and can software reach them?
Why it mattersSets the integration work.
Strong answer · warning sign
Named systems with owners.
"Somewhere on the drive."
E2
Has our model risk policy moved from SR 11-7 to SR 26-2?
Why it mattersThe old letter was replaced on April 17, 2026.13
Strong answer · warning sign
Updated, with a view on AI tools.
Still cites SR 11-7.
E3
What does vendor management need before a pilot sees borrower data?
Why it mattersThe due diligence is the bank's.
Strong answer · warning sign
A known path and timeline.
First time anyone asked.
F
Break-even prices for every renewal on one page
F1
What if every renewal reached committee with its break-even prices on one page?
Why it mattersTests the appetite for one standard.
Strong answer · warning sign
"Committee would spend its time on the farm and its conditions."
"Nobody reads them."
F2
What if the borrower could see the same what-if in the meeting?
Why it mattersConditions are easier to agree when both sides see the numbers.
Strong answer · warning sign
"Better conversations about marketing and insurance."
"We'd never show them."
F3
Which steps would we never let software do without a person?
Why it mattersTells you where the signatures belong.
In shortThe questions ag lenders, analysts and farm borrowers search for most, each answered on its own.
What is a farm cash flow stress test?
A farm cash flow stress test rebuilds a borrower's projected year with worse assumptions than the plan, such as lower prices, a short crop, higher input costs or a higher interest rate, and reads whether the farm still covers its term debt payments. Lenders apply a standard set of shocks to every borrower, solve break-even prices and yields, and check how much working capital one or two bad years would use. Bank examiners expect it for agricultural credits.
How do you calculate capital debt repayment capacity?
Start from net farm income, add depreciation, interest on term debt and off-farm income, then subtract family living expenses and income taxes. For example, $200,448 of net farm income plus $168,000 of depreciation and $132,266 of term interest, plus $52,000 off-farm, less $98,000 family living and $14,000 tax, leaves $440,714. That is the money the year provides to pay term debt and capital leases.
What is a good term debt coverage ratio for a farm loan?
No regulation sets one; each lender sets its own floor in credit policy. Many ag lenders want about 1.25 on the borrower's plan and at least 1.00 in a downside, and extension economists treat anything above 1.0 as covering the payments. Turning the ratio into a dollar margin shows how much income can fall before the floor is crossed.
What shocks should an ag lender use?
Common sets move crop prices about 10% below the deck, yields about 15% below plan, input costs 10% or more higher and the operating rate 200 basis points higher, plus a combined downside of smaller moves together. Livestock farms need their own price shock. History supports these sizes: corn's harvest price fell more than 18% in a single year four times since 2006.
Does crop insurance cover a drop in corn prices?
Only partly. Revenue Protection guarantees the farm's approved yield times its coverage level times the higher of the spring and harvest futures prices, and pays only when the crop's value at the harvest price falls below that guarantee. In 2025 the corn harvest price was 10.2% below the spring price, yet at 80% coverage a policy paid only where yields were more than 10.9% below history.
How do ARC and PLC payments affect a farm cash flow?
ARC and PLC payments add revenue, but a year late: payments for a crop year arrive after the marketing year ends, so 2025 crop payments reached farmers in October 2026. The 2025 law raised reference prices to $4.10 for corn and $10.00 for soybeans and the ARC guarantee to 90%. Count them in the year received, and recompute PLC at a stressed price if it would pay more.
How much working capital should a farm have?
It depends on the farm and the lender's policy. Iowa State extension reports beginning-of-year working capital typically around 50% to 70% of gross revenue on the farms it tracks, with cash grain farms needing as much as 50%; Iowa farms averaged 51 cents per dollar of revenue at the end of 2025. Lenders often set a floor as a share of gross revenue and test whether it survives two bad years.
What is a farm break-even price?
It is the price at which the farm's year exactly covers a chosen target with every other assumption held at plan. Lenders solve it for their policy coverage line and for 1.00, the point where the farm no longer pays its term debt from the year. For central Illinois in 2027, university budgets put the price that covers all costs on rented land near $5 for corn and $11 for soybeans.
What do the Federal Reserve ag credit surveys show for 2026?
Repayment weakened into early 2026 and then eased a little. In the Chicago Fed's district, 38% of lenders saw lower repayment rates in the first quarter and 27% in the second, renewals and extensions reached their highest level since 2020, and about 17% of borrowers carried more carryover debt. Lenders describe 2026 cash flows at or below breakeven, funded by working capital.
What is carryover debt on a farm loan?
Carryover debt is operating debt a farm could not repay from the year's sales, carried into the next year. Examiners treat it as a sign of weaker repayment capacity and expect it to be clearly identified, usually restructured on a separate note with collateral and a realistic repayment term. A two-year stress test shows which borrowers are likely to create it.
How much does a 2% rate increase cost a farm?
Multiply the increase by the average balance of the variable-rate debt. On an operating line averaging $792,000, two percentage points cost $15,840 a year. For most grain farms that is smaller than a 10% price shock, but it matters more for farms with large variable-rate term debt or a carryover balance that no longer revolves.
Is farm stress testing software a model under SR 26-2?
Mostly not. SR 26-2, issued April 17, 2026, excludes simple spreadsheet arithmetic and deterministic rule-based software from its definition of a model, and places generative and agentic AI outside its scope, leaving them to the bank's own governance. Statistical yield or price forecasts inside a tool can still be models.
How often should a farm borrower's cash flow be stress-tested?
At least at each renewal or annual review, and again when prices, rates or the farm's plan change materially. The FDIC's examination manual expects financial information on agricultural borrowers to be updated not less than annually. Many lenders also re-run their standard shocks across the whole ag book when the price deck changes.
24 · One-page summary
The farm stress test on one page: six steps, the October 2026 numbers that change it, and 14 terms
Print this page
In shortThe whole guide on one screen: the method, the 2026 facts that change the answer, the readiness bands and the terms.
The method
Build the base case from the farm's own records: yields capped at history, the bank's price deck, every payment due.
Compute repayment capacity, coverage and the dollar margin.
Apply the standard shocks one at a time and together; add livestock where there are animals to sell.
Count insurance only as the policy on file would pay, and government payments in the year received.
Solve break-evens for the policy line and 1.00, and test working capital over two downside years.
Write conditions, test them, and let the officer recommend and sign; committee decides.
Readiness: score 0–2 on eight questions: 0–6 explore · 7–11 pilot · 12–16 implement.
As of October 2026: P.L. 119-21 sets ARC/PLC for 2025–2031 (corn $4.10, soybeans $10.00 reference prices) · record 2025 ARC/PLC payments in October 2026 · WASDE 2026/27 corn $4.70, soybeans $12.00 · prime 7.00% since September 17, 2026 · SR 26-2 since April 17, 2026 · no new farm bill enacted.
14 terms
Spread
A farm's records restated in the bank's format, year beside year.
Base case
The farm's signed plan at the bank's prices.
Price deck
The bank's approved planning prices, usually futures less basis.
Basis
Local cash price minus the futures price.
Repayment capacity
Net farm income + depreciation + term interest + off-farm income − family living − taxes.
Term debt coverage
Repayment capacity ÷ scheduled term and capital lease payments.
Margin
Repayment capacity minus the payments; what a shock spends.
Working capital
Current assets minus current liabilities; the cushion.
Break-even
The price, yield, rent or rate where coverage meets a target.
APH
Actual production history: the farm's insured yield.
Revenue Protection
Insurance guaranteeing APH × coverage × the higher of projected and harvest price.
ARC · PLC
Federal county-revenue and price programs paid on base acres a year after the crop.
Carryover debt
Operating debt not repaid from the year, carried forward.
Downside
Several smaller shocks applied together.
25 · Sources
Sources
Accessed October 2026. Regulatory status statements are as of October 2026.
FDIC, FIL-5-2020, "Advisory: Prudent Management of Agricultural Lending During Economic Cycles", January 28, 2020. fdic.gov
N. Paulson, G. Schnitkey and C. Zulauf, "2025 Crop Insurance Harvest Prices for Corn and Soybeans", farmdoc daily (15):203, November 4, 2025. farmdocdaily.illinois.edu
N. Paulson, H. Monaco, G. Schnitkey and C. Zulauf, "2025 Final ARC/PLC Payments", farmdoc daily (16):185, October 13, 2026. farmdocdaily.illinois.edu
B. Zwilling, "Illinois Farm Financial Trends in 2025: Summary and Analysis", farmdoc daily (16):188, October 16, 2026. farmdocdaily.illinois.edu
Federal Reserve Bank of St. Louis, FRED, Bank Prime Loan Rate (MPRIME monthly, DPRIME daily), read October 31, 2026. fred.stlouisfed.org
N. Paulson, G. Schnitkey, C. Zulauf and B. Zwilling, "Illinois Crop Budgets for 2027", farmdoc daily (16):157, University of Illinois, September 1, 2026. farmdocdaily.illinois.edu
J. Parsons, "LRP-Feeder Cattle Insurance: Recent Enhancement and Performance History", Center for Agricultural Profitability, University of Nebraska–Lincoln, July 15, 2026. cap.unl.edu
Public Law 119-21, 139 Stat. 72 (July 4, 2025), Title I, Subtitle C (Commodities, secs. 10301–10307) and Subtitle E (Crop Insurance, secs. 10501–10504). govinfo.gov
N. Paulson, G. Schnitkey, H. Monaco, B. Sherrick and C. Zulauf, "Projected Prices and Volatility Factors for 2026", farmdoc daily (16):35, March 3, 2026. farmdocdaily.illinois.edu
Federal Reserve, SR 26-2, "Revised Guidance on Model Risk Management", and attachment, April 17, 2026 (issued with OCC Bulletin 2026-13 and FDIC FIL-15-2026). federalreserve.gov
Consumer Financial Protection Bureau, "Small Business Lending Under the Equal Credit Opportunity Act (Regulation B)", final rule, 91 FR 23530, May 1, 2026. govinfo.gov
Congressional Research Service, R45210, "Farm Bills: Major Legislative Actions, 1965–2026", updated September 23, 2026. everycrsreport.com
USDA Farm Service Agency, "Driving Efficiency in Farm Loan Delivery", final rule, 91 FR 56741, September 4, 2026, effective October 1, 2026. federalregister.gov
Federal Reserve, SR 11-14, "Supervisory Expectations for Risk Management of Agricultural Credit Risk", October 26, 2011, revised February 26, 2021. federalreserve.gov
7 CFR 457.8, Common Crop Insurance Policy Basic Provisions, definitions (2026 edition, the last printed in the CFR). govinfo.gov
7 CFR 457.113, Coarse Grains Crop Insurance Provisions, section 12, settlement of claim (2026 edition, the last printed in the CFR). govinfo.gov
Federal Crop Insurance Corporation, "Removal of Regulatory Overreach and Federal Crop Insurance Policy Provisions", final rule, 91 FR 16151, April 1, 2026, effective May 1, 2026. federalregister.gov
A. Plastina and J. Han, "Financial Performance Measures for Iowa Farms", Ag Decision Maker File C3-55, Iowa State University Extension, revised September 2026. extension.iastate.edu
M. Langemeier, "Measuring Repayment Capacity and Farm Growth Potential", farmdoc daily (8):175, September 20, 2018 (Farm Financial Standards Council measures). farmdocdaily.illinois.edu
USDA World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates, WASDE-676, October 9, 2026. usda.gov
USDA Economic Research Service, Commodity Costs and Returns: corn, U.S. total, updated October 1, 2026. ers.usda.gov
USDA Economic Research Service, "Cost-of-production forecasts for major U.S. field crops, 2026F–2027F", June 18, 2026. ers.usda.gov
USDA Economic Research Service, "Farm Sector Income Forecast" (cash receipts, government payments, expenses), September 3, 2026. ers.usda.gov
USDA Economic Research Service, Farm Income and Wealth Statistics data files: U.S. farm sector financial indicators 2019–2026F and the September 3, 2026 release (interest expenses). ers.usda.gov
USDA Economic Research Service, "Highlights From the 2026 Farm Income Forecast", September 3, 2026. ers.usda.gov
Federal Reserve Bank of Kansas City, T. Kreitman, "Steady Tightening of Agricultural Credit Conditions Persists", Ag Credit Survey, August 14, 2026. kansascityfed.org
Farmer Mac, "Farm income holds up in 2026 thanks to record government support", April 20, 2026. farmermac.com
Federal Reserve Bank of Chicago, AgLetter No. 2012, "First Quarter Midwest Farmland Values Up Some from a Year Ago", May 2026. chicagofed.org
Federal Reserve Bank of Chicago, AgLetter No. 2013, "Second Quarter Midwest Farmland Values Unchanged", E. Kepner and D. Oppedahl, August 2026. chicagofed.org
Federal Reserve Bank of Kansas City, T. Kreitman, "Farm Finance Deterioration Eases Slightly", August 26, 2026. kansascityfed.org
Federal Reserve Bank of Minneapolis, E. Beishir and C. Ringgenberg, "Bankers detail stable conditions in new survey", October 7, 2026. minneapolisfed.org
FDIC, Quarterly Banking Profile, Second Quarter 2026. fdic.gov
Federal Farm Credit Banks Funding Corporation, "Farm Credit System Reports 2026 Second Quarter and Six-Month Net Income", July 31, 2026. farmcreditfunding.com
B. Zwilling, "2025 Illinois Farm Earnings Improve but Remain Below Recent Averages", farmdoc daily (16):168, September 18, 2026. farmdocdaily.illinois.edu
M. Langemeier, "Stress Testing Financial Performance", farmdoc daily (6):43, March 4, 2016. farmdocdaily.illinois.edu
O*NET OnLine, Credit Analysts (13-2041.00), median wage from the Bureau of Labor Statistics, 2025. onetonline.org
U.S. Bureau of Labor Statistics, "Employer Costs for Employee Compensation — June 2026", September 9, 2026: private industry wages and salaries 70.0% of compensation ($32.82 of $46.89 an hour). bls.gov
Next step
See it on your own renewal files.
Explore the solution, or bring a few of this season's operating line renewals with your price deck and standard shocks, and we will stress-test them with you, every line linked to the document it came from.
We use essential cookies to make this site work, and cookieless, anonymised analytics to understand how it's used. "Accept all" also turns on Google Analytics, which sets cookies. Privacy policy