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

2026 Cash Rents: Why Aren’t Rents Falling More?

September 10, 2026

Cash rents have softened in some parts of Indiana in 2026, but overall, rents remain relatively stable. So why aren’t they falling more, even after several years of weaker returns to land? Michael Langemeier and Todd Kuethe examine the latest cash rent results from the 2026 Purdue Farmland Values and Cash Rents Survey and look at what the numbers could mean for 2027.

2026 Trends in Farmland Price to Rent Ratios in Indiana

September 9, 2026

Indiana farmland values remain elevated relative to the cash rent they generate. Purdue agricultural economist Michael Langemeier examines what the farmland price-to-rent ratio can tell us about land values, future returns and the risks facing buyers.

Comparison of Long-Run Rates of Return for Crop and Livestock Farms

August 13, 2026

Have crop farms or livestock farms generated better long-run returns? Michael Langemeier compares rates of return for beef, dairy, diversified, and crop farms from 2007–2025, revealing why recent livestock price strength hasn’t translated into a clear long-run advantage.

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.