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.
Farm Management Canada would like to acknowledge Alberta Agriculture as the creators of the Agriculture Business Analyser.
To Download the ABA, please click on the ‘Downloadable Spreadsheets’ button above.
User Guide
Purpose of User Guide:
- To provide an overview that users of the program can read to better understand the overall working of the ABA program
- 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.
Download the complete ABA User Guide – 3.9MB .xls