University of Illinois: Department of Agricultural and Consumer Economics, University of Illinois Urbana-Champaign
Visit Farmdoc

publication archive: Ryan Batts


May 1, 2013

Late Planting and Tools in FAST

Listen to MP3 podcast
Little planting so far this spring and the continued prospects of rain bring on the potential for farmers to shift from corn to soybeans. The Planting Decision Model, a part of FAST Microsoft Excel spreadsheet series, includes a "Returns by Planting Date" module which calculates projected returns from corn and soybeans by planting date in northern, central, and southern Illinois. There also is an online version of this tool. According to projections in this tool, corn will be the more profitable to plant in all areas until late May. In central Illinois, corn is projected more profitable than soybeans into June.

Continue reading...

Posted by Ryan Batts and Gary Schnitkey   Permalink        

March 26, 2013

Release of an Updated FAST Tool: Balance Sheet Program

The Balance Sheet program has been updated to include two new features: 1) saving multiple users and years to a database and 2) preforming trend analysis. The tool allows users to calculate beginning and ending balance sheets, income statement, statement of cash flows, and a report of the user's financial ratios, as well as deferred tax calculation. Users can generate financial statements for a one-year (simple balance sheet) or two-year period (beginning and ending year). The balance sheet program is a Microsoft Excel spreadsheet, part of our FAST series of tools.

Continue reading...

Posted by Ryan Batts   Permalink        

June 15, 2011

Release of an Updated FAST Tool: Balance Sheet & Historical Financial Statements Program

An updated balance sheet & historical financial statements program is available from farmdoc. This tool allows users to generate financial statements for a one-year (simple balance sheet) or two-year period (beginning and ending year). Financial statements include: beginning and ending balance sheets, income statement, statement of cash flows, and a report of the user's financial ratios, as well as deferred tax calculation. This tool can be downloaded from the FAST section of farmdoc.

Continue reading...

Posted by Ryan Batts   Permalink        

May 12, 2011

Corn Replanting Decision Tool Released as Part of FAST

A "Corn Replanting Decision Tool" has been released as part of the FAST series of Microsoft Excel spreadsheets. Mathematical functions in this tool estimate yields from the original and replanted stands. Estimated yields, along with cost and crop insurance information, then are used to calculate net income from replanting. This tool is part of the Planting Decision Model, which can be accessed from the FAST section of farmdoc . A direct link to the model download page model is available here.

Continue reading...

Posted by Gary Schnitkey, Ryan Batts, and Emerson Nafziger   Permalink        

April 27, 2011

Planting Delays and Switching to Soybeans: A New FAST Spreadsheet

Listen to the MP3 podcast
Recent wet weather again raises concerns about planting delays, potentially leading to questions on whether to plant corn or soybeans on farmland that was scheduled to be planted to corn. We have developed a FAST spreadsheet named the Planting Decision Model that calculates corn and soybean returns by date of planting. Using current commodity prices and costs, switching to more soybeans seems several weeks away. For northern and central Illinois, corn is projected to be more profitable than soybeans throughout May. In southern Illinois, corn is projected to be more profitable than soybeans through the last part of May. Commodity prices play a key role in return differentials. Current commodity prices favor corn compared to what one would expect with more typical prices.

Continue reading...

Posted by Gary Schnitkey and Ryan Batts   Permalink