ISA (UK) 520 / ISA (UK) 570

Financial Ratio Calculator
United Kingdom

Financial ratio calculator with United Kingdom-specific regulatory context, FRC 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 United Kingdom — ISA (UK) 520 / ISA (UK) 570

Financial ratio analysis forms a cornerstone of analytical procedures under ISA (UK) 520, which requires auditors to design and perform substantive analytical procedures that are suitable for the purpose. In the United Kingdom, the Financial Reporting Council has established clear expectations for how auditors should apply ratio analysis as part of both planning analytics and substantive testing. The FRC's Audit Quality Review team consistently emphasises that analytical procedures should not be a mechanical exercise but rather a thoughtful evaluation of financial relationships, grounded in the auditor's understanding of the entity and its environment. UK auditors must consider industry-specific benchmarks, macroeconomic conditions, and entity-specific factors when setting expectations for financial ratios, and must investigate significant deviations with appropriate professional scepticism.

Regulatory Context — FRC

The FRC's thematic reviews have repeatedly highlighted analytical procedures as an area requiring improvement in UK audit quality. ISA (UK) 520 requires that when analytical procedures identify fluctuations or relationships inconsistent with other relevant information or that differ from expected values by a significant amount, the auditor shall investigate such differences by making inquiries of management and obtaining appropriate corroborative evidence. The FRC has clarified through its Annual Audit Quality Inspection Reports that auditors should set precise expectations, use disaggregated data where possible, and define acceptable thresholds before comparing actual results. For going concern assessments under ISA (UK) 570, the FRC expects auditors to evaluate financial ratios indicative of solvency distress, including current ratio deterioration, interest coverage declines, and negative working capital trends, alongside cash flow forecasting and covenant compliance analysis.

Practical Guidance for United Kingdom

UK practitioners should leverage data from Companies House filings, FAME database, and sector-specific publications from bodies such as the Office for National Statistics and the Bank of England when establishing ratio benchmarks. For private companies, the ICAEW's Financial Reporting Faculty provides guidance on common ratios and their interpretation in the context of UK GAAP and IFRS reporters. When performing ratio analysis for planning purposes, auditors should compute current ratio, quick ratio, debt-to-equity, interest coverage, gross margin, net margin, inventory turnover, receivables days, payables days, and return on capital employed, comparing each against prior periods, budgets, and industry norms. The precision of the expectation should be commensurate with the materiality of the balance and the reliability of the data used to form the expectation.

Audit Expectations

The FRC Audit Quality Review team has identified several recurring deficiencies in how UK firms apply analytical procedures. These include failure to develop sufficiently precise expectations before comparing to actual results, use of overly broad thresholds that fail to identify material misstatements, inadequate investigation of identified variances where auditors accept management explanations without corroboration, and insufficient documentation of the auditor's rationale for concluding that analytical procedures provide sufficient appropriate audit evidence. The FRC expects that where ratio analysis is used as a substantive procedure, the auditor must document the expectation, the threshold for investigation, the actual result, any variance analysis performed, and the conclusion reached. Audit working papers should demonstrate genuine intellectual engagement rather than rote calculation.

United Kingdom-Specific Considerations

The United Kingdom's insolvency framework under the Insolvency Act 1986 and the Companies Act 2006 establishes specific tests relevant to going concern ratio analysis. The cash flow test asks whether the company can pay its debts as they fall due, while the balance sheet test considers whether liabilities exceed assets. Auditors should evaluate financial ratios in light of these statutory tests, particularly the current ratio, quick ratio, and cash conversion cycle. The wrongful trading provisions under Section 214 of the Insolvency Act create director liability where directors knew or ought to have concluded there was no reasonable prospect of avoiding insolvent liquidation. This legal framework underpins the importance of ratio analysis in going concern assessments. Additionally, the UK Corporate Governance Code requires boards of premium-listed companies to assess prospects over a longer period, creating demand for forward-looking ratio projections that extend beyond the standard twelve-month going concern assessment window.

Common Inspection Findings

Auditors failed to set precise quantitative expectations before comparing actual ratios to benchmarks, treating analytical procedures as a confirmatory rather than investigative exercise.

Thresholds for investigating ratio variances were set too broadly, meaning material fluctuations went uninvestigated in the audit working papers.

Management explanations for significant ratio movements were accepted without corroborative evidence, particularly for gross margin changes and receivables days increases.

Insufficient disaggregation of data meant that offsetting variances in different business segments were not identified through entity-level ratio analysis.

Going concern ratio analysis was performed mechanically without connecting deteriorating financial ratios to the specific insolvency tests under the Insolvency Act 1986.

Documentation of the auditor's independent expectation was absent, with working papers suggesting the expectation was reverse-engineered from the actual results.

Frequently Asked Questions — United Kingdom

What financial ratios does the FRC expect auditors to calculate under ISA (UK) 520?
The FRC does not prescribe a specific list of ratios, but expects auditors to select ratios appropriate to the entity and industry. Common ratios examined in FRC inspections include profitability metrics such as gross and net margin, liquidity ratios including current and quick ratio, leverage ratios such as debt-to-equity and interest coverage, and efficiency metrics including inventory turnover and receivables days. The key expectation is that the selection is tailored rather than generic.
How should UK auditors document analytical procedures involving ratio analysis?
The FRC requires documentation of the expectation developed by the auditor, the threshold for investigation, the actual ratio computed, the comparison and variance analysis, and the conclusion reached. Where variances exceed the threshold, the auditor must document the inquiries made and corroborative evidence obtained. Working papers should demonstrate that the auditor formed an independent expectation before seeing the actual results.
What going concern ratios are relevant under the UK Insolvency Act 1986?
The Insolvency Act establishes both a cash flow test and a balance sheet test for insolvency. Ratios supporting the cash flow test include the current ratio, quick ratio, and operating cash flow coverage. Ratios supporting the balance sheet test include debt-to-equity, net asset position, and total liabilities relative to total assets. Auditors should also consider interest coverage and debt service coverage ratios when assessing going concern.
Where can UK auditors obtain industry benchmark data for ratio analysis?
UK auditors commonly use the FAME database for company-level financial data and peer comparison, the Office for National Statistics for sector-level economic data, and publications from the ICAEW, ICAS, and sector-specific bodies. The Bank of England publishes credit conditions surveys and sectoral lending data that provide macroeconomic context for ratio trends.
Does the FRC distinguish between analytical procedures at planning and substantive stages?
Yes. Planning-stage analytical procedures under ISA (UK) 315 help the auditor understand the entity and identify risks, and may use high-level ratio comparisons. Substantive analytical procedures under ISA (UK) 520 must meet more rigorous standards, including precise expectations, defined thresholds, and documented investigation of variances. The FRC has criticised firms that blur these distinctions or rely on planning analytics as substantive evidence without the required rigour.
How does the UK Corporate Governance Code affect going concern ratio analysis?
The UK Corporate Governance Code requires premium-listed companies to make a viability statement assessing prospects over a period significantly longer than twelve months. This creates demand for extended ratio projections including forecast profitability ratios, projected leverage ratios, and forward-looking liquidity metrics. Auditors should evaluate whether the entity's projected ratios support the viability statement and going concern basis.