Farm Progress is part of the Informa Markets Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Serving: United States
Building a Balance Sheet

Building a Balance Sheet

This simple balance sheet program can generate financial statements.

This Simple Balance Sheet program, provided by the Ag Economics department at University of Illinois, will easily generate financial statements for a two-year period. This program generates a balance sheet, income statement, statement of cash flows, as well as reporting the user's financial ratios.

The Balance Sheet program consists of two tools: The first allows the user to assemble complete balance sheets, database them, do single year ratio analysis and examine ratios over time. The second part of the tool allows the user to enter just the data used for the ratio analysis, database the information, and perform ratio analysis.

Simple balance sheet program can generate financial statements.

You'll need Microsoft Excel version 2007 or higher to use the spreadsheet.

This is one of several FAST (Farm Analysis Solution Tools) found at the U. of I.'s FarmDoc website (, all available for download.  These spreadsheets are designed to help farmers make better financial and management decisions.

We're featuring the spreadsheet as our Farm Futures Financial Tool-of-the-month. Download it using the link below.

Do you have a spreadsheet that's made a difference on your operation that you'd be willing to share with other readers? Drop us a line at with a description of the spreadsheet. We'll pay $100 if we feature your farmer-written noncommercial program as our Financial Tool of the Month.

To celebrate Farm Futures' ten-year anniversary, we're opening up the archives of our online Spreadsheet of the Month files. Just go to and enjoy.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.