Agriculture - Dairy Template


Spotlight has two agriculture specific templates; Dairy and Livestock.

The Agriculture - Dairy template combines some of the key metrics dairy agriculture businesses should focus on. These metrics are split across the Dairy Debt Metrics and Dairy Yield Metrics pages in Spotlight.

To make the most of the template, you will need to:

  1. Source non-financial data.
  2. Assign specific report codes to key accounts
  3. Evaluate the formulae and customise using the formula builder if necessary.
    Note: Some Dairy 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:

  • Volume - Milk yield
  • Stock - Number of cows
  • Weight - Milksolids in kg
  • Size - Number of hectares

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 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)

Dairy Debt Metrics

Interest coverage ratio

interest coverage ratio

Formula:  (Trading Revenue - (Expenses - Tax - Interest Expenses)) / Interest Expenses = EBIT

Report codes used: REV.TRA, EXP, EXP.TAX, EXP.INT

Debt Burden Percentage

debt burden percentage

Formula: (Interest Expense / (Total Expenses - Cost of Sales)) * 100

Report codes used: EXP.INT, EXP, EXP.COS

Asset to Debt Ratio

asset to debt ratio

Formula: Assets / Liabilities

Report codes used: ASS, LIA

Debt to Equity

debt to equity

Formula: Total Liabilities / (Total Assets - Total Liabilities)

Report codes used: LIA, ASS

Dairy Yield Metrics

Average Milk Yield

average milk yield

Formula: Volume / Stock

Report codes used: OPR.VOL, OPR.STO

Total Milk Yield

total milk yield

Formula: Volume

Report codes used: OPR.VOL

Average KG Milksolids per Cow

avg kg milksolids per cow

Formula: Weight / Stock

Report codes used: OPR.WEI and OPR.STO

Average KG Milksolids per Hectare

avg kg milksolids per hectare

Formula: Weight / Size

Report codes used: OPR.WEI and OPR.SIZ

Still need help?
Get in touch!