Long-Run Cash Rent Spreadsheet Tool

by Michael Langemeier

Updated October 2025

This spreadsheet uses enterprise budget information, projected yields, and projected prices to examine breakeven prices, earnings per acre, breakeven cash rents, and trends in working capital.

Farmers typically find that rental rates don’t adjust rapidly during a downturn and consequently they lose money on rented land. But most farmers don’t want to give up rented land even if it is not profitable because it is difficult to find another parcel to replace it. They continue to hold on to rented land waiting for better prices, lower costs, and/or higher yields. The fundamental question is how long can they delay the decision. In other words, when should they hold them and when should they fold them? This question has become even more relevant today, given the financial pressure currently faced by crop producers across the Corn Belt, including lower commodity prices, tighter margins, and higher interest rates. Read more on using the spreadsheet tool here!

TAGS:

TEAM LINKS:

RELATED RESOURCES

Convergence of Financial Performance

October 29, 2026

Do larger crop farms have a financial advantage over smaller operations? FINBIN data from 2007 to 2025 reveal where farm size matters most, and where it doesn’t.

How Much Could Corn Prices Raise Hog Feed Costs in 2027?

October 13, 2026

Corn prices can have a substantial impact on swine finishing feed costs. Michael Langemeier explains what different corn and soybean meal price scenarios could mean for hog feed costs and margins in 2027.

Liquidity and Repayment Capacity

October 1, 2026

Purdue analysis of FINBIN data shows how liquidity and repayment capacity have differed across crop farm sizes from 2007 to 2025, with notable changes in the gap between smaller and larger farms.

UPCOMING EVENTS

Weathering Water Extremes: Connecting Soil Health, Drainage, Irrigation, and Farm Resilience

Join educators from across the Midwest to build skills for communicating soil health concepts on Nov. 4-5, 2026. In the field, we’ll evaluate the relationship between soil health and water management focusing on irrigation and edge of field practices. The in-service will have both classroom and on farm demonstrations.

Land of Opportunity: A Conference for Farmland Owners!

The Land of Opportunity: A Conference for Farmland Owners will be held at two locations on October 5 and October 6, providing farmland owners with valuable information and resources to help them make informed decisions about their land. The conference will feature keynote presentations, educational breakout sessions, and networking opportunities designed specifically for those who own, manage, or have an interest in farmland.