Agriculture - Livestock Template
- Overview
- Non-financial data required
- Assign specific report codes to key accounts
- Livestock Debt Metrics
- Livestock Stock Metrics
Overview
Spotlight has two agriculture specific templates; Dairy and Livestock.
The Dairy template combines some of the key metrics Livestock Agriculture businesses should focus on. These metrics are split across the Livestock Debt Metrics and Livestock Yield Metrics pages in Spotlight Reporting.
To make the most of the Agriculture - Livestock template, you will need to:
- Source non-financial data
- Assign specific report codes to key accounts
- Evaluate the formulas and customise using the formula builder if necessary.
Note: Some Livestock businesses may measure these metrics differently due to seasonality, setup of accounts or other factors.
Non-financial data required
Most Agriculture metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:
- Size (of area to evaluate)
- Stock
- Number of Sales Transactions
You can manually enter the data into the non-financial tab under Customise Data. Alternatively, enter the data into this Excel template and import it into Spotlight using the excel import function on the Import tab.
Assign specific report codes to key accounts
Most report codes needed for the template are automatically assigned by Spotlight. However, for the metrics to calculate correctly you may need to assign some financial report codes manually. To do this, open Customise Data and locate the following accounts, then to assign the specified report code click the report code button.
- Interest expense - EXP.INT (Expenses > Interest and finance charges)
Livestock Debt Metrics
Interest coverage ratio
Formula: Â (Trading Revenue - (Expenses - Tax - Interest Expenses))Â / Interest Expenses
Report codes used: REV.TRA, EXP, EXP.TAX & EXP.INT
Debt Burden Percentage
Formula: (Interest Expense / (Total Expenses - Cost of Sales)) * 100
Report codes used: EXP.INT, EXP and EXP.COS
Asset to Debt Ratio
Formula: Assets / Liabilities
Report codes used: ASS and LIA
Debt to Equity
Formula: Total Liabilities / (Total Assets - Total Liabilities)
Report codes used: LIA, ASS
Livestock Stock Metrics
Average Revenue Per Transaction
Formula: Trading Revenue / Sales Transactions
Report codes used: REV.TRA and SAL.TRA
Total Stock
Formula: Stock
Report codes used: OPR.STO
Stocking Rate
Formula: Stock / Size
Report codes used: OPR.STO and OPR.SIZ
Revenue Per Hectare
Formula: Trading Revenue / Size
Report codes used: REV.TRA and OPR.SIZ
Â