January 27, 2003
CASH RENT WORKSHEET
Click here to download sheet
A new cash rent worksheet designed to help farmers determine the
amount of cash rent that can be paid for an acre of land is available
on farmdoc (Click here to download sheet).
A user must have Microsoft Excel version 97 or higher to operate
Format of the Worksheet
The worksheet consists of four sheets labeled north, central, southern,
and southernwheat. These sheets respectively contain budgets applicable
to northern Illinois, central Illinois, and southern Illinois. The
southernwheat sheet contains corn, soybean and wheat budgets. The
other tabs only include corn and soybean budgets. These sheets are
indicated by the tab signs listed in the lower left hand corner
of the Excel window, as indicated below.
Clicking on the respective tab will bring up the desired budget.
The sheet containing the northern Illinois budget is shown below.
The sheet has two columns for corn, two for soybeans, and two for
a total. The two columns for each crop and total are labeled "your
figures" and "budget". The budget column gives average
yields, other revenues, and costs taken from farms enrolled in Illinois
Farm Business Farm Management. Entries in blue in the "your
figures" column can be changed to reflect an individual farm
The final row in the sheet is labeled "revenue less expenses".
This is the amount remaining for cash rent after paying all expenses.
The expense category three rows up from the bottom is labeled "operator's
labor & mgmt". This is the amount that a farmer wishes
to receive for their labor and management.
Users of the spreadsheet can change yields, prices, and costs to
examine their impacts on amount left over for cash rent.
Issued by: Dale
Lattz and Gary
Schnitkey, Department of Agricultural and Consumer Economics