ISA 520 · ISA 570 · Agriculture

Financial Ratio Calculator
for Agriculture

Pre-configured for agricultural entities. IAS 41 biological asset fair value adjustments, EU Common Agricultural Policy subsidies, and seasonal production cycle considerations.

Financial Data

Enter the essential financial figures below. Expand the additional sections for a comprehensive analysis.

Financial Ratio Analysis Guide for European Auditors — free PDF

ISA 520 & ISA 570 practical workbook: all formulas with visual explanations, industry benchmark reference tables from BACH for 15 industries, ratio interpretation guide, and template narrative paragraphs for audit working papers.

No spam. Unsubscribe anytime.

ISA 520.5 — Design and perform analytical procedures near the end of the audit that assist in forming an overall conclusion.

ISA 520.A1 — Analytical procedures may include ratios such as gross margin percentages and ratio of sales to accounts receivable.

ISA 570.A3 — Negative working capital, adverse key financial ratios, operating losses, and other indicators may cast doubt on going concern.

Financial Ratio Analysis for Agriculture

Agricultural financial ratio analysis must contend with IAS 41 biological asset fair value measurement, extreme seasonal working capital patterns, and commodity price volatility. IAS 41 requires biological assets (livestock, crops, orchards) to be measured at fair value less costs to sell, creating unrealised gains and losses that distort traditional profitability ratios in ways unique to agriculture. A dairy farm's net margin may swing from 20% to -10% based purely on biological asset revaluation, with no change in underlying milk production economics.

The Common Agricultural Policy (CAP) provides significant subsidy income to European agricultural entities, accounting for 30–60% of net income for many farms. This creates a unique dependency that standard ratio analysis may not capture: a profitable agricultural entity that appears financially healthy may be entirely dependent on CAP payments, with negative profitability on a pre-subsidy basis. For ISA 520 analytical procedures, auditors should analyse ratios both with and without subsidy income to assess the underlying commercial viability of the farming operation.

Seasonal working capital patterns in agriculture are more extreme than any other sector. Planting seasons require significant cash outflows for seeds, fertiliser, and labour, while revenue from harvest may not materialise for 3–8 months. Livestock operations have different but equally seasonal patterns related to breeding, feeding, and sales cycles. BACH benchmarks show wide quartile ranges for agricultural ratios (Q1 inventory days: 40, Q3: 140) reflecting this diversity. The cash conversion cycle should be assessed against the specific crop or livestock cycle, not annual averages.

Regulatory Context

IAS 41 biological asset fair value measurement. IAS 20 government grants (CAP subsidies). EU Common Agricultural Policy reforms. Nitrogen regulation (Netherlands: stikstofbeleid). CSRD sustainability reporting for large agricultural entities.

Industry-Specific Going Concern Indicators (ISA 570)

Consecutive harvest failures or livestock disease outbreaks

CAP subsidy changes reducing income beyond replacement ability

Commodity prices below production cost for extended periods

Water rights disputes or access restrictions

Nitrogen regulation compliance costs exceeding capacity (Netherlands)

Biological asset fair values declining significantly

Worked Example: European Arable Farm

Van der Berg Landbouw BV — Dutch arable farm with €4.5M revenue

Key results: Current Ratio: 2.00, Quick Ratio: 0.91, Gross Margin: 30.0%, Net Margin: 7.0%, ROE: 7.3%, ROA: 3.7%, D/E: 0.98, Interest Coverage: 2.5x, Inventory Days: 139 (grain storage — seasonal), Altman Z'-Score: 2.35 (Grey Zone — assess seasonal timing)

Frequently Asked Questions — Agriculture

How does IAS 41 affect agricultural financial ratios?
IAS 41 requires biological assets to be measured at fair value less costs to sell, which creates unrealised gains and losses in profit or loss. This distorts net margin, ROE, and ROA because paper gains from livestock growth or crop development are included in income before any sale occurs. For meaningful ratio analysis, strip out IAS 41 fair value adjustments to see operational profitability. Note that not all jurisdictions apply IAS 41 equally — some use modified approaches for bearer plants (IAS 16 amendment).
How should CAP subsidies be treated in ratio analysis?
CAP subsidies should be separately identified to assess underlying commercial viability. Calculate profitability ratios both including and excluding CAP income. An entity showing positive margin only because of subsidies is vulnerable to policy changes. Under IAS 20, government grants related to income are recognised in profit or loss, while grants related to assets reduce the carrying amount — different treatment affects different ratios.
What inventory days are normal for agriculture?
Agricultural inventory days vary dramatically by operation type: arable farms holding grain post-harvest may show 100–180 days (waiting for optimal selling prices), livestock operations show 60–120 days (breeding to sales cycles), and perishable produce shows 5–15 days. BACH data shows median inventory days of 80 for agriculture with a very wide Q1–Q3 range (40–140). Always interpret against the specific agricultural activity, not aggregate benchmarks.
How does weather risk factor into agricultural going concern assessment?
Weather and climate events (drought, flooding, frost, disease) can cause sudden, material losses for agricultural entities. For ISA 570 going concern assessment, consider: crop insurance coverage, geographic diversification, water access rights, historical yield volatility, and climate change adaptation plans. A farm that has experienced consecutive poor harvests without adequate insurance may face going concern issues even if historical ratios appeared healthy.
What are agriculture-specific going concern indicators?
ISA 570 indicators for agriculture include: consecutive harvest failures or livestock disease outbreaks, CAP subsidy changes reducing income beyond replacement, commodity prices below production costs for extended periods, water rights disputes or restrictions, loan covenant breaches on agricultural land financing, nitrogen regulation compliance costs (particularly relevant in the Netherlands), and biological asset valuations declining significantly below carrying amounts.