ISA [DE] 520 / IDW PS 270

Financial Ratio Calculator
Germany

Financial ratio calculator with Germany-specific regulatory context, IDW / APAS expectations, and local inspection findings.

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 in Germany — ISA [DE] 520 / IDW PS 270

Financial ratio analysis in Germany operates within a dual-framework environment where publicly listed companies report under EU-adopted IFRS while the vast majority of German enterprises, including the Mittelstand, prepare statutory accounts under the Handelsgesetzbuch. German auditors performing Abschlussprüfungen apply ISA as adopted through EU regulation, supplemented by national standards issued by the Institut der Wirtschaftsprüfer (IDW). IDW Prüfungsstandard 520 aligns with international requirements for analytical procedures but incorporates German-specific implementation guidance. The Abschlussprüferaufsichtsstelle (APAS) inspects audit quality for public interest entity auditors and has identified analytical procedures, including ratio analysis, as a recurring focus area in its inspection programme. German practitioners must navigate both the conservative valuation principles of HGB accounting and the fair-value orientation of IFRS when interpreting financial ratios.

Regulatory Context — IDW / APAS

The IDW has issued substantial guidance on analytical procedures through IDW PS 520 and related practice aids. APAS inspection reports have noted deficiencies in how German auditors apply ratio analysis, including insufficient documentation of expectations formed at the planning stage and inadequate investigation of ratio movements identified during substantive testing. The IDW's going concern standard, IDW PS 270, requires auditors to consider financial indicators of going concern doubt, explicitly referencing liquidity ratios, leverage ratios, and profitability trends. For entities subject to the German Corporate Governance Code (Deutscher Corporate Governance Kodex), the supervisory board's audit committee is expected to monitor financial risk indicators, creating an additional layer of governance around financial ratio assessment. APAS has emphasised that auditors should not rely solely on management-prepared ratio analyses but should develop independent expectations.

Practical Guidance for Germany

German auditors benefit from well-established benchmarking sources. The Deutsche Bundesbank publishes detailed sectoral financial statistics including balance sheet and income statement ratios for German enterprises, disaggregated by industry and company size. Creditreform and Bürgel provide company-specific credit rating data incorporating financial ratios. The IDW's industry-specific audit guides (Branchenspezifische Prüfungshinweise) contain recommended ratio analyses for sectors including manufacturing, retail, banking, and insurance. When analysing HGB financial statements, auditors must account for the conservative measurement principles: hidden reserves from the lower-of-cost-or-market principle (Niederstwertprinzip), provisions measured at settlement amount (Erfüllungsbetrag), and the absence of fair value measurement for most assets. These features mean that HGB-based ratios may systematically differ from IFRS-based ratios for the same entity.

Audit Expectations

APAS inspections have revealed specific patterns of deficiency in German audit firms' application of ratio analysis. Common findings include the use of generic ratio templates without tailoring to the specific entity or industry, acceptance of immaterial ratio movements without investigating whether aggregation effects might conceal material misstatements, failure to consider the impact of HGB-specific accounting policies on ratio comparability over time, and insufficient linkage between ratio analysis findings and the audit strategy. The Wirtschaftsprüferkammer (WPK) peer review programme has similarly identified analytical procedures as an area where smaller and medium-sized firms need improvement. German auditors are expected to demonstrate in their working papers that ratio analysis informed their risk assessment and that identified anomalies were pursued through targeted substantive procedures.

Germany-Specific Considerations

Germany's insolvency framework under the Insolvenzordnung (InsO) establishes two grounds for filing insolvency proceedings: Zahlungsunfähigkeit (inability to pay debts as they fall due) and Überschuldung (over-indebtedness, where liabilities exceed assets at liquidation values). For GmbH and AG entities, directors face personal liability for failing to file insolvency proceedings within three weeks of recognising either ground. The Überschuldung test requires a separate going-concern prognosis (Fortbestehensprognose), which considers projected cash flows and financial ratios. This legal framework makes ratio analysis particularly important in German going concern assessments. The Stabilisierungs- und Restrukturierungsrahmen (StaRUG), introduced in 2021 implementing the EU Restructuring Directive, created early warning obligations for certain entities, requiring ongoing monitoring of financial ratios that might indicate impending insolvency. Auditors should evaluate whether the entity's crisis early-warning system includes appropriate ratio monitoring.

Common Inspection Findings

Analytical procedures used generic ratio templates not tailored to the entity's industry or the specific characteristics of HGB versus IFRS reporting.

The impact of HGB measurement principles on ratio comparability between periods was not considered when investigating ratio movements.

Expectations for substantive analytical procedures were not documented independently of the actual results, undermining the reliability of the procedure.

Going concern ratio analysis did not specifically address the Insolvenzordnung requirements for Zahlungsunfähigkeit and Überschuldung assessments.

Sector benchmark data from the Deutsche Bundesbank was available but not utilised, with auditors instead relying solely on prior-year comparisons.

Ratio analysis at the planning stage did not adequately feed into the risk assessment, with identified anomalies not reflected in the audit strategy.

Frequently Asked Questions — Germany

How does HGB accounting affect financial ratio interpretation for German audits?
HGB's conservative valuation principles, including the Niederstwertprinzip and the formation of Rückstellungen at settlement amounts, tend to understate assets and overstate liabilities compared to IFRS. This means HGB-based ratios may show lower equity ratios, higher leverage, and lower profitability than IFRS equivalents. Auditors must account for these systematic differences when benchmarking ratios against international peers or industry norms derived from IFRS data.
What going concern indicators does IDW PS 270 identify for ratio analysis?
IDW PS 270 references financial indicators including recurring losses, negative working capital, inability to pay creditors on normal terms, adverse key financial ratios, and substantial operating losses. The standard requires auditors to consider these indicators in the context of the Insolvenzordnung's dual tests of Zahlungsunfähigkeit and Überschuldung. Ratio trends over multiple periods are considered more diagnostic than single-period ratios.
Where can German auditors obtain industry benchmark ratios?
The Deutsche Bundesbank's corporate financial statistics provide comprehensive sectoral benchmarks. Creditreform publishes Branchenreport data with industry-specific ratios. The IDW's Branchenspezifische Prüfungshinweise contain recommended ratios by industry. Additionally, the Sparkassen and Volksbanken publish regional economic data that can contextualise ratio analysis for locally-focused businesses.
What is the significance of Überschuldung for ratio analysis in German audits?
Überschuldung occurs when liabilities exceed assets at liquidation values, absent a positive going-concern prognosis. Auditors should compute a modified equity ratio that adjusts for hidden reserves and potential liquidation value differences. If the adjusted net asset position is negative and the Fortbestehensprognose is unfavourable, the entity is legally obliged to file for insolvency within three weeks.
How does the StaRUG framework affect auditor expectations for ratio monitoring?
The StaRUG requires certain entities to implement early warning systems for crisis detection. Auditors should assess whether the entity monitors relevant financial ratios as part of this framework. Key ratios include liquidity forecasts, debt service coverage, and equity ratio trends. The existence and effectiveness of such monitoring may affect the auditor's going concern assessment and risk evaluation.