Farmdoc Search Subscribe About Contact Us friends of farmdoc

Marketing & Outlook
Law & Taxation
Crop Insurance
Prices & Weather
Ag Links
Visit farmdoc daily
Visit farmdoc webinars
farmdoc Sponsors

January 27, 2003
FEFO 03-01


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 the worksheet.

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 setting.


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


Department of Agricultural and Consumer Economics    College of Agricultural, Consumer and Environmental Sciences
Home | Finance | Marketing & Outlook | Management | Law & Taxation
Policy | FAST Tools | Crop Insurance | Prices & Weather
Search | Subscribe | About farmdoc | Contact Us | friends of farmdoc
University of Illinois