Improving your farm lease contract spreadsheet

Iowa State University Extension and Outreach - Ag Decision Maker Series

Type: Excel
Knowledge level: Intermediate

Farm Table says:

US-based and acre-based, but once data entered, the spreadsheet compares difference lease structures and estimated returns to operator and owner.
  • Number of crop input options, rather than just overall gross income
  • Great links out to applicable data and supporting information
  • Based on input data, it then compares the impacts of different lease options (fixed cash, flexible cash, crop-share)
One of best excel templates we have seen to enable informed conversations between owner and lessee. There are also separate and dedicated templates for Flexible Rent Analysis and Crop-Share Lease Analysis

This spreadsheet helps to calculate the estimated returns to a farm lease under different lease terms:

  • Fixed cash rent lease
  • Flexible cash rent lease
  • Crop-share rent
  • Custom farming.

The excel tool provides the net returns to both the lessee and lessor under the different scenarios and provides gross revenue sensitivity analysis.

Prefilled data is available for corn, oats and soybean production.

2017 - United States - Iowa State University Extension and Outreach - Ag Decision Maker Series
Visit WebsiteSave For Later

Related Resources