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:
Most agriculture metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:
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.
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:
Formula: (Trading Revenue - (Expenses - Tax - Interest Expenses)) / Interest Expenses = EBIT
Report codes used: REV.TRA, EXP, EXP.TAX, EXP.INT
Formula: (Interest Expense / (Total Expenses - Cost of Sales)) * 100
Report codes used: EXP.INT, EXP, EXP.COS
Formula: Assets / Liabilities
Report codes used: ASS, LIA
Formula: Total Liabilities / (Total Assets - Total Liabilities)
Report codes used: LIA, ASS
Formula: Volume / Stock
Report codes used: OPR.VOL, OPR.STO
Report codes used: OPR.VOL
Formula: Weight / Stock
Report codes used: OPR.WEI and OPR.STO
Formula: Weight / Size
Report codes used: OPR.WEI and OPR.SIZ