ISA 520 · ISA 570 · Retail

Financial Ratio Calculator
for Retail

Pre-configured with BACH retail benchmarks. Optimised for thin-margin, high-volume operations with emphasis on inventory management and same-store performance.

ISA 520 · ISA 570v2026.04Manufacturing

30+ ratios, benchmarked.
Not just calculated.

Session
0x8C54
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 for Retail

Retail financial ratio analysis demands particular attention to margin efficiency, inventory velocity, and working capital management. Retail operates on thin margins — European BACH data shows median net margins of just 2.5% for the sector — meaning even small absolute misstatements in COGS or inventory can have a disproportionate impact on profitability ratios. This makes ratio analysis under ISA 520 especially powerful for detecting material misstatements in retail audits.

The gross margin percentage is the single most important analytical procedure for retail entities. ISA 520.A1 specifically names gross margin as an example ratio. A consistent gross margin that suddenly shifts by more than 1–2 percentage points warrants immediate investigation: common causes include unrecorded shrinkage, markdown timing errors, vendor rebate misclassification, or inventory valuation errors (NRV write-downs under IAS 2). Omnichannel retailers require separate margin analysis for in-store vs. online channels, as fulfilment costs differ materially.

Days Sales Outstanding (DSO) in retail is typically very low — median 10 days in European BACH data — because most revenue is collected at point of sale. An increasing DSO may indicate growing trade receivables from B2B wholesale channels, loyalty programme liabilities, or gift card redemption timing. Days Payable Outstanding (DPO) is a critical negotiation leverage metric: large retailers often achieve DPO of 60–90 days, effectively financing inventory through supplier credit. A deteriorating DPO may signal supplier confidence issues or lost payment term advantages.

Regulatory context

Omnichannel revenue recognition under IFRS 15. Loyalty programme liabilities. Gift card breakage estimation. IFRS 16 lease impact on balance sheet ratios — most retail store leases are now on-balance sheet.

Industry-specific going concern indicators (ISA 570)

Same-store sales declining for 3+ consecutive quarters

Gross margin erosion exceeding 3 percentage points year-on-year

Inventory days exceeding 100 days (fashion/seasonal goods)

DPO shortening — losing supplier payment term advantages

Covenant breaches on revolving credit facilities

Planned or forced store closures

Worked Example: European Fashion Retailer

StyleHaus BV — mid-size fashion retailer with €28M revenue across 12 stores

Key results: Current Ratio: 1.20, Quick Ratio: 0.29, Gross Margin: 36.0%, Net Margin: 3.0%, ROE: 10.5%, D/E: 1.75, Inventory Days: 114 (above Q3 of 85 — investigate), DSO: 10 days, DPO: 45 days, CCC: 79 days

Frequently asked questions: Retail

Which ratios are most critical for retail companies?
Gross margin, inventory turnover, and the cash conversion cycle are the three most critical ratios. Gross margin reveals pricing power and shrinkage levels. Inventory turnover (median 7.3x for European retail) indicates whether stock is moving or becoming obsolete. The cash conversion cycle shows how effectively the retailer finances its working capital — negative CCC is common for large retailers who collect cash before paying suppliers.
How should I assess inventory risk for retail audits?
Compare inventory days to BACH benchmarks: European retail median is 50 days. Inventory days exceeding the Q3 benchmark of 85 days signals potential obsolescence, particularly for fashion and seasonal goods. Perform a vintage analysis — slow-moving inventory aged more than 6 months likely needs NRV assessment under IAS 2. Also compare gross margin trends: declining margin with stable inventory days may indicate needed but unrecorded write-downs.
What DSO is normal for retail?
European BACH data shows median retail DSO of just 10 days, reflecting the cash-heavy nature of retail sales. DSO above 30 days (Q3 benchmark) is unusual and likely indicates significant B2B or wholesale operations, or potentially misclassified receivables. For omnichannel retailers, separately analyse in-store (near-zero DSO) and online (2–5 day settlement) channels.
How does IFRS 16 affect retail financial ratios?
IFRS 16 has a significant impact on retail ratios because retailers typically have extensive store lease portfolios. Right-of-use assets inflate total assets (reducing ROA and asset turnover), while lease liabilities increase total liabilities (worsening D/E ratio and interest coverage). When comparing to pre-IFRS 16 benchmarks, adjust accordingly. The BACH 2023 data includes IFRS 16 effects.
What going concern indicators are specific to retail?
Key retail-specific going concern indicators under ISA 570 include: same-store sales declining for 3+ consecutive quarters, gross margin erosion exceeding 3 percentage points, inventory days increasing above 100 (fashion/seasonal), supplier payment terms shortening (losing negotiation leverage), store closure announcements, and covenant breaches on revolving credit facilities. The seasonal nature of retail means Q4 performance is disproportionately important.

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.