Farmdoc Search Subscribe About Contact Us friends of farmdoc
Home
Finance
Marketing & Outlook
Management
Law & Taxation
Policy
FASTtools
Crop Insurance
Presentations
Prices & Weather
Web Resources
Visit farmdoc daily

farmdoc Sponsors


farmdoc Sponsors

farmdoc Sponsors


January 27, 2003
FEFO 03-01

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

Interpretation

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 | AgMAS | Crop Insurance | Prices & Weather | Ag Links
Search | Subscribe | About farmdoc | Contact Us | friends of farmdoc
E-mail: farmdoc@illinois.edu
University of Illinois