Research: Farm Management Decision Tools

Decision Tools

Flexible Cash Lease Calculator - Cash Lease with a Bonus Approach

This flexible cash lease tool is intended to help landowners and tenants agree on terms of their flexible cash lease. This Flexible Cash Lease Calculator can assist users in developing a flexible cash rent model.

The flexible cash rent approach used in this calculator allows users to compare actual prices, yields and gross income to base prices, yields and gross revenue. The difference between the base and actual gross revenues can be shared in some proportion between landowner and operator and added to the base cash rent.

The Microsoft Excel spreadsheet is designed to enable the user to input base and year end prices, yields and proportional split to formulate a flex rent at the end of the lease year.

Download


Flexible Cash Lease Calculator - Net Return Approach

This flexible cash lease tool is intended to help landowners and tenants agree on terms of their flexible cash lease. This Flexible Cash Lease Calculator can assist users in developing a flexible cash rent model. Unlike other flexible cash lease calculators, this tool allows the user to incorporate flexible parameters for input costs as well as for price and yield.

The flexible cash rent approach used in this calculator allows users to calculate actual net income for rented land and compare it against a base net income. The difference between the base and actual net revenues can be shared in some proportion between landowner and operator and added to the base cash rent.

The Microsoft Excel spreadsheet is designed to enable the user to input base and year end prices, yields and costs to formulate a flex rent at the end of the lease year.

Download


Flexible Cash Lease Calculator - Ratio Approach

This flexible cash lease tool is intended to help landowners and tenants agree on terms of their flexible cash lease. This Flexible Cash Lease Calculator can assist users in developing a flexible cash rent model. Unlike other flexible cash lease calculators, this tool allows the user to incorporate flexible parameters for input costs as well as for price and yield.

The flexible cash rent approach used in this calculator is to multiply the base rent by: 1) the ratio of the Year End Price to Base Price, 2) the ratio of the Year End Yield to Base Yield and, 3) the ratio of the Base Input Costs to Year End Input Costs.

The Microsoft Excel spreadsheet is designed to enable the user to input base and year end prices, yields and costs to formulate a flex rent at the end of the lease year. There are two tabs for this calculator. Page 1 contains the Flexible Cash Lease Inputs and page 2 contains the Flexible Cash Lease Output.

Download


Crop Share Calculator

The Crop-Share Lease Calculator is a tool designed to allow the user to input costs and shares of each to fairly allocate revenue in a crop share lease arrangement. This tool shows the tenant and landowner returns above total costs given share percentages and costs. This decision aid contains three sections:

  1. Shares
    This section separates various receipt and cost sections out so that the user can input the share percentage of that particular item.  Simply input the percentage that the landowner is responsible for and the tenant percentage is automatically generated.
  2. Costs
    This section allows the user to input the costs and receipts for the particular crops.
  3. Output
    This section separates the sections into 4 broad categories (Receipts, Inputs, Machinery, and Direct Costs) and breaks them down to show the amount (based on the percentages inputted in section 1) that the landowner and the tenant are responsible for.  At the bottom of the sheet, it will show the return to total costs based on the numbers provided.

Download


The Value of Manure

The Value of Manure worksheet shows the amount, and cost/lb unit of N, P, and K in various livestock manure.  Simply select your fertilizer types and type your cost per ton (Yellow cells), and the tool automatically adjusts the value of the manure.

Download


OSU Manure Rate Calculator

The Ohio State University Manure Rate Calculator is a complement to the tool above.  This allows you to select various inputs, and uses to give you a manure rate calculation.  The OSU Manure Rate Calculator was developed by the OSU AgCrops.

Download


Custom Rate Calculator

The Custom Rate Calculator calculates a more accurate portrayal of the current Custom Rates based on the increase in fuel prices.  Using the cost of fuel during the time of 2008 Custom Rate Survey collection, this will calculate newer custom rate numbers based on current fuel prices.  Simply type the current diesel fuel costs, minus taxes in the yellow box at the top to see the new custom rates.

Download


Machinery Rental Rates Calculator

The Machinery Rental Rates Calculator takes user input to determine the recommended rate for renting material.  This uses the 2008 Custom Rates Fact Sheet, and/or the Custom Rate Calculator above to get the current custom rate data to determine these recommendations.

Download


Computer Programs

All programs will run on Windows 95, 98, NT & 2000
For assistance contact Baryy Ward - 614-688-3959

LANDBID

A calculation of the maximum amount that can be paid for farmland, while still having a profitable investment.

To download and install program

  1. Click Download and select "Save" to save the file to your computer
  2. Navigate to the location where you saved the file. double click on the file to "unzip" the compressed files. You must have a compression program on your computer such as "WinZip" or "7-Zip"
  3. Once unzipped, three files will be present. Double click setup.exe to begin installing the program.

Download

LandbBid Explanation and Instructions (.pdf)


MACHFIN

An Analysis of Machine Financing Alternatives

  1. Click Download and select "Save" to save the file to your computer
  2. Navigate to the location where you saved the file. double click on the file to "unzip" the compressed files. You must have a compression program on your computer such as "WinZip" or "7-Zip"
  3. Once unzipped, three files will be present. Double click setup.exe to begin installing the program.

Download

MachBuildFin Instructions (.pdf)


MACHINERY COSTS

An Estimation of the Costs of Operating Farm Equipment

  1. Click Download and select "Save" to save the file to your computer
  2. Navigate to the location where you saved the file. double click on the file to "unzip" the compressed files. You must have a compression program on your computer such as "WinZip" or "7-Zip"
  3. Once unzipped, three files will be present. Double click setup.exe to begin installing the program.

Download

Machinery Costs Explanations and Instructions (.pdf)