Financial ratio calculator for audit analytics.

Is this entity in good shape, or are there warning signs?

Working capital, inventory turnover, days inventory, DSO, DPO and the cash conversion cycle from one set of figures, with each formula shown.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Figures for the period
Opening and closing balances
Working capital
$2,100,000
11.4% of revenue
Inventory turnover
4.21x
87 days inventory on hand
DSO
44 days
47 days on closing balance
How this was worked out
RatioFormulaResult
Working capitalCurrent assets − current liabilities$2,100,000
Inventory turnoverCOGS ÷ average inventory ($2,875,000)4.21x
Days inventory outstanding365 ÷ inventory turnover86.7 days
Receivables turnoverRevenue ÷ average receivables ($2,215,000)8.31x
Days sales outstanding (DSO)365 ÷ receivables turnover43.9 days
Payables turnoverCOGS ÷ average payables ($1,465,000)8.26x
Days payable outstanding365 ÷ payables turnover44.2 days
Cash conversion cycleDIO + DSO − DPO86.5 days
Gross margin(Revenue − COGS) ÷ revenue34.2%
Work shownrecomputed as you type
DSO on closing balance = closing receivables ÷ revenue × 365 = 47.2 days (ties to the receivables aging report)

Rising DSO with flat sales can point to collection problems, an understated allowance or fictitious revenue; falling inventory turnover can point to obsolete stock. Use the movement against your expectation, not the ratio alone.

Averages use (opening + closing) ÷ 2. For seasonal businesses a monthly average is more reliable. Use credit sales for DSO where cash sales are significant.

Ratios as analytical procedures

AU-C 520 has the auditor develop an expectation, compare the recorded amount with it, and investigate differences above a threshold. Turnover and days ratios are natural expectations: if sales are flat, DSO should be close to last year; if product lines have not changed, inventory turnover should be too. A swing that management cannot explain is a risk indicator under AU-C 315.

Rising DSO can mean slower collections, an understated allowance, or revenue recorded early or fictitious. Falling inventory turnover can mean obsolete or overstated stock. A lengthening cash conversion cycle (DIO + DSO − DPO) ties up working capital and can feed into the going concern assessment.

Common questions

How do you calculate inventory turnover?

Inventory turnover = cost of goods sold ÷ average inventory, where average inventory is (opening + closing) ÷ 2. Days inventory outstanding = days in the period ÷ inventory turnover.

How do you calculate DSO (days sales outstanding)?

DSO = average receivables ÷ credit sales × days in the period, which equals days ÷ receivables turnover. Many reviewers also compute it on the closing balance to compare with the aging.

How do you calculate working capital?

Working capital = current assets − current liabilities. Expressed as a share of revenue it is easier to compare across years and peers.

How are ratios used in an audit?

In planning, ratios help identify risks of material misstatement (AU-C 315); as substantive analytical procedures they test whether balances are consistent with expectations (AU-C 520); and near the end of the audit they support the overall review. Unexpected movements need explanation and corroboration.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required