Whole Farm -- Decision Tools
| Cost & Return | ||||
|---|---|---|---|---|
 xls files | ||||
| Crop and Livestock Land Use Analyzer Use this decision tool to analyze and compare the potential long-term effects for various land use choices. |
 |
C1-15 | ||
| Partial Budgeting Use this decision tool to evaluate the financial effect of incremental changes for a farm business |
|
C1-50 |  | |
| Market Comparison Use this calculator to estimate costs for various produce delivery markets. | |
C1-55 | ||
| Leasing & Land Values | ||||
|---|---|---|---|---|
| xls/xlsx files |
||||
| Estimated Returns by Farm Lease Arrangement Use this decision tool to estimate returns to a landowner and tenant under different rental agreements, including cash rent, flexible rent, crop-share, or a custom farming agreement. |
|
C2-01 | ||
| Cash Rental Rate Estimation Use this decision tool to compare different methods of computing Cropland Cash Rent. |
|
C2-20 | ||
| Flexible Lease Agreement Worksheet Use this decision tool to analyze a flexible lease arrangement. |
|
C2-21 | ||
| Calculating Hay and Pasture Cash Rents Use this decision tool to compare different methods of computing rent for hay and pasture ground. |
|
C2-23 | ||
Computing a Grain Storage Rental Rate |
|
C2-24 | ||
| Computing a Livestock Building Cash Rental Rate Use this decision tool to estimate a livestock building rental rate. |
|
C2-26 | ||
| Crop Share Analysis Use this decision tool to analysis a crop-share lease arrangement based on the percentage of inputs provided by the tenant and owner. |
|
C2-30 | ||
| Beef Cow Share Agreement Analysis Use this decision tool to estimate costs and returns for each party in a beef cow share agreement. |
|
C2-36 | ||
| Farmland Purchase Analysis Use this decision tool to compare the economic and financial impacts of purchasing a parcel of farmland. |
|
C2-70 | ||
| Historic Farmland Value Survey (Iowa State University) This spreadsheet provides historic Iowa land values for county, district, and state beginning in 1950. |
|
C2-70 | ||
|
C2-72 | |||
| Calculating a Weighted Average Corn Suitability Rating Use this decision tool to find the weighted CSR2 based on information from the Web Soil Survey. |
|
C2-87 | ||
| Iowa Township Names and Geographic Locations by County This electronic spreadsheet provides a listing of the political townships for every county in Iowa. |
|
C2-88 | ||
| Farmland Tile Drainage Investment Analysis Use this decision tool to analyze returns from a tile drainage investment. |
|
C2-90 | ||
| Financial | ||||
|---|---|---|---|---|
| xls files |
||||
| Cash Flow Budget (short form - 12 periods) Use this decision tool to make a simple cash flow projection over 12 periods. |
|
C3-14 | ||
| Cash Flow Budget (corn, soybeans and livestock) Use this decision tool to calculate a detailed cash-flow budget for your farm. |
|
C3-15 | ||
| Net Worth Statement (short form) Use this decision tool to make a simple net worth statement. |
|
C3-19 | ||
| Cash to Accrual Net Farm Income Worksheet Prepares an accrual net income statement from income tax schedules and net worth statements. |
|
C3-26 | ||
| Computing Benefits from Adding Additional Off-farm Work Use this decision tool to compare various income and expenses from multiple options of employment |
|
C3-51 | ||
| Financial Performance Measures Use this decision tool to calculate financial performance measures for your farm that can be compared to industry standards. |
|
C3-55 | ||
| Interpreting Financial Performance Measures Use this decision tool to create a five-year trend analysis. |
|
C3-56 | ||
| Farm Financial Performance Analysis Allows you to enter information from a Schedule F for up to 5 years and calculate multiple financial ratios to determine the financial health of a farm operation. |
|
C3-59 | ||
| Comprehensive Financial Statements Use this decision tool to calculate a comprehensive set of financial statements including the beginning and ending net worth statements, the income statement, the cash-flow statement, the statement of owner equity, and the financial performance measures. Also available as an Example of Farm Financial Statements. |
|
C3-20 | ||
| Dividing Business Income Use this decision tool to calculate how to divide income between different parties. |
|
C4-16 | ||
| Weights & Measurements | ||||
|---|---|---|---|---|
| xls files |
||||
| Metric Conversions Use this decision tool for converting between English and Metric units. |
|
C6-80 | ||
| Estimated Storage Capacity for Grains, Forages, and Liquids Use this decision tool to estimate the storage capacity for grain bins, bales storage, water and fuel tanks. |
|
C6-82 | ||
| Legend | ||||
|---|---|---|---|---|
| Download file in pdf format | |
|||
| Decision tool | |
|||
| Teaching activity |  |
|||
| Voiced media |  |
|||
