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.

ISA 520 · ISA 570v2026.04Manufacturing

30+ ratios, benchmarked.
Not just calculated.

Session
0x1B4C
Fiscal Year
FY 2026
Benchmark
BACH 2023
inputs.conf
methodology.conf
README.md
01// engagement— ISA 520.4
02entity_name=
03fiscal_year_end=
04currency=
05industry=
09// income_statement— current year
10revenue=
11cogs=
12ebit=
13net_income=
17// balance_sheet— period end
18total_assets=
19current_assets=
20current_liabilities=
21total_liabilities=
22total_equity=
awaiting input·3 sections · 2/13 fields · 0 errors·ISA 520 compliantEUR·Manufacturing
01liquidity
current_ratio
quick_ratio
cash_ratio
working_capital
02profitability
gross_margin
net_margin
roe
roa
ebitda_margin
roic
03leverage
debt_to_equity
debt_to_assets
interest_coverage
dscr
equity_multiplier
04activity
inventory_days
dso
dpo
asset_turnover
cash_conversion_cycle
05going_concern
altman_z_score
beneish_m_score
piotroski_f_score
isa_570_flags0
benchmark_source
Manufacturing
BACH database · 2023
Bank for the Accounts of Companies Harmonized. European industry medians (Q1 / median / Q3) from the ECB/ECCBSO aggregated database covering 12 European countries by NACE sector.
≥ median between q1 and median < q1
ONE EMAIL · UNLOCKS EVERYTHING · FREE FOREVER

Enter your email to unlock the full ratio analysis.

One email. One time. Unlocks revenue sensitivity analysis, DuPont 5-factor decomposition, cross-ratio intelligence warnings, covenant headroom, and the full working paper download — everything at once, forever, on this device.

No payment. No upsell. No "premium tier" pop-ups. Ever.

One audit insight a week. Unsubscribe any time. GDPR-compliant (MailerLite, EU servers).
Your email unlocks every section below automatically.
ADVANCED ANALYSIS

Deeper ratio analysis, styled the same.

01// sensitivity— revenue stress ±25%
Enter revenue and COGS to run sensitivity.
02// dupont_decomposition— 3-factor ROE breakdown
Enter revenue, net income, and balance sheet to compute DuPont.
03// cross_ratio_intelligence— pattern detection warnings
Enter inputs to run pattern detection.
04// covenant_headroom— typical mid-market covenants
Enter EBIT, debt, and current assets/liabilities to test covenants.
🔒
4 advanced sections · sensitivity · DuPont · cross-ratio · covenants
Enter your email above to unlock all of this. It's free — no payment, ever.
Scroll up to unlock ↑
EXPORT (EMAIL TO UNLOCK)

Email unlocks the free download.

No payment required. Enter your email above to unlock the full working paper download.

Format
HTML → PDF
Pages
4–8
Price
FREE
or CtrlE

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.

Get practical audit insights, weekly.

No exam theory. Just what makes audits run faster.

290+ guides published20 free toolsBuilt by practicing auditors

No spam. We’re auditors, not marketers.