Tools & Data

Downloadable Tools and Data

The TIAA Center for Farmland Research provides several data analysis tools and decision aids, developed in the Center and in the Department of Agricultural and Consumer Economics. Farmland related tools and data are provided to assist in understanding and analyzing issues related to farmland investments.

US Ag Sector Balance Sheet data through time with Lender Shares (Excel spreadsheet)

  • Based on USDA data, the composition of the US Ag Sector balance sheet is provided along with formatted graphs to show important financial ratios and lender shares through time.

Land Purchase Evaluation Tool (FAST) (Excel spreadsheet)

  • A comprehensive tool to evaluate returns characteristics associated with the purchase of real assets. Financial structure terms, transactions costs, and holding period differences are reflected along with a budgeting tool to assess the sensitivity to important conditions of the purchase are involved.

Returns to Alternative Investments by holding intervalĀ (Excel spreadsheet)

  • This utility allows a novel view of returns across all possible combinations of purchase and sales dates for farmland in more than 30 states, as well as a collection of important alternative investment classes. A set of technical features related to risk and convergence in the volatility through time is provided as well.

Farmland Correlation with other assets by holding interval (Excel spreadsheet)

  • This utility allows a user to consider the impact of holding period definitions on the relationship between farmland returns and major alternative asset classes as well as to inflation.

Farmland Index Construction Utility CenterĀ (Excel spreadsheet)

  • This utility allows a user to retrieve USDA state level data on cropland and farm real estate values and calculate the rates of return over selected intervals. It also allows relative values to be recovered at any date based on a known value at a given date.

State Level Values and Returns to Agricultural Investments through time (Excel spreadsheet)

  • This utility provides a quick and convenient means to visually compare aggregate state level farmland information with returns and levels based on USDA data. It is maintained at the TIAA Center for farmland research at the University of Illinois and is updated annually after the release of USDA survey information on farmland values and rental statistics.

Illinois Society of Farm Managers and Rural Appraisers Representative Parcel Transfer Information (Excel spreadsheet)

  • This utility provides a powerful comparison of land market transactions through time by region of Illinois. Property characteristics can be used to sort the type of property and track actual sales data through time.