OSU Farm Management Software

Excel Spreadsheet Tools

All of these spreadsheets require Microsoft Office Excel or equivalent.  If you do not have Microsoft Office, you can OpenOffice.org from http://www.OpenOffice.org for free.  While these programs SHOULD work, we cannot guarantee that all functionality will remain intact.  For the full experience, please use Microsoft Office Excel.

Flexible Cash Lease Calculator

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.

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.

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.

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.

Custom Rate Calculator based on Change in Fuel Prices

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.

Machinery Rental Rates Calculator from Custom Rate 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.

 

Computer Program Download

All programs will run on  Windows 95, 98, NT & 2000 operating systems

Questions/Comments contact Barry Ward - 614-688-3959

LANDBID MACH_BUILD_FIN MACHINERY COSTS

To download and install programs:

  1. click on file, and select "save" to save on computer

  2. Once saved on computer, double click on file to "unzip", you must have WinZip or another compression file program

  3. Once unzipped, three files will be present.  Click on install.exe and follow instructions.

 

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

LandBid -download program

LandBid Explanation and Instructions (Word)
LandBid Explanation and Instructions (.pdf)

MACHFIN
"An Analysis of Machine Financing Alternatives"

Mach_Build_Fin - download program

Mach_Build _Fin Instructions (Word)
Mach_Build _Fin Instructions (pdf)

 

MACHINERY COSTS
"An Estimation of the Costs of Operating Farm Equipment"

Machinery Costs - download program

 

Machinery Costs Explanation and Instructions (Word)
Machinery Costs Explanation and Instructions (.pdf)