Agricultural Business Analyzer: information page


User guide | User Tutorial | Frequently Asked Questions | Excel Hints | Downloadable spreadsheet | Webinar

The Agricultural Business Analyzer (ABA) is a financial analysis tool designed to aid users to do review up to 5 years of historical financial data and prepare and analyze a financial plan for the upcoming year. Projections done start with an Opening Net Worth Statement, and look forward for 1 year. Incomes and expenses are considered along with expected cash flows. From this data, ABA creates a Closing Financial Statement illustrating what the financial situation of the farm operation will be at the end of 1 year based on the projections. In addition, the program calculates key ratios in the areas of liquidity, solvency, profitability and efficiency for both the past and projected income and financial statements, and compares them to industry benchmarks.

The template is an Excel spreadsheet made up of 25 sheets in the overall workbook. The individual sheets are identified by tabs at the bottom of the window and can be accessed by clicking on them.

ABA can be accessed by completing the required user information and then saving the template to directory on your own computer.

ABA will be continuously enhanced and updated. New versions of ABA will be posted as they become available.


User Guide:

Date Updated: December 2014

Purpose of User Guide:
  1. To provide an overview that users of the program can read to better understand the overall working of the ABA program
  2. To provide a quick reference guide that users can access to answer questions they might have regarding any functions of the program

ABA Statement:
ABA is a financial analysis tool designed to aid users in reviewing up to 5 years of historical financial data, and to prepare and analyze a financial plan for the upcoming year. Projections done start with an Opening Net Worth Statement, and look forward for 1 year. Incomes and expenses are considered along with expected cash flows. From this data, ABA creates a Closing Financial Statement illustrating what the financial situation of the farm operation will be at the end of 1 year based on the projections. In addition, the program calculates key ratios in the areas of liquidity, solvency, debt servicing, profitability and efficiency, for both the past and projected income and financial statements, and compares them to industry benchmarks.

General Comments about the Template: To Access: ABA can be accessed can be from "Ropin' the Web." Complete the required user information. Access will then be given to ABA, and the template can be saved to your user file.

In an effort to provide the best product possible, ABA will be periodically enhanced and updated. New versions of ABA will be placed on the "Ropin' the Web" site as they become available and you will be notified.

Download the complete ABA User Guide - 3.9MB .xls

Video Tutorial:



ABA Webinar:



Project Leader:Rick Dehod P.Ag., Farm Financial Specialist, Edmonton AB
Others involved in Project and Original Project developers:Larry Lindquist P.Ag. Consultant, Edmonton, AB,
Ron Lyons , Manager, Business Incubation, Leduc Alberta


This information is maintained by Rick Dehod

Last Revised/Reviewed June 29, 2015

Top of Document