Financial Ratio Analyzer

This financial ratio analyzer turns a set of accounts into the ratios lenders, investors and managers look at. Enter the main income statement and balance sheet figures and it calculates liquidity, leverage, profitability and efficiency ratios — from the current ratio and debt to equity to return on equity and the cash conversion cycle. Paste several years or companies to compare them side by side. It runs in your browser.

Common ratios

RatioFormula
Current ratioCurrent assets ÷ current liabilities
Quick ratio(Current assets − inventory) ÷ current liabilities
Debt to equityTotal liabilities ÷ equity
Interest coverEBIT ÷ interest
Net marginNet profit ÷ revenue
ROENet profit ÷ equity
DSOReceivables ÷ revenue × 365

When to use it

  1. Prepare ratios for a bank loan application.
  2. Compare this year with last year.
  3. Benchmark a company against competitors.
  4. Check working capital health.
  5. Teach financial statement analysis.

How to Use

  1. Enter income statement figures.
  2. Enter balance sheet figures.
  3. Read the ratios by group.
  4. Paste years or companies to compare.

Features

  1. Liquidity ratios
  2. Leverage and interest cover
  3. Margins, ROA and ROE
  4. DSO, DPO, inventory days
  5. Cash conversion cycle
  6. Batch CSV
  7. 100% client-side

FAQs

What is a good current ratio?

Often 1.5–2, but it depends on the industry; below 1 means current liabilities exceed current assets.

How is return on equity calculated?

Net profit ÷ shareholders' equity × 100.

What is the cash conversion cycle?

Inventory days + receivable days − payable days: how long cash is tied up in operations.

Should I use averages?

For turnover ratios, average opening and closing balances are more accurate than year-end figures.

Is anything uploaded?

No. Everything runs in your browser.

Technical Details

From the income statement (revenue, cost of sales, operating expenses, interest and tax) and balance sheet (current assets, inventory, receivables, cash, total assets, current liabilities, payables, total liabilities, equity): liquidity (current, quick = (current assets − inventory) ÷ current liabilities, cash ratio, working capital), leverage (debt to equity, debt ratio, equity multiplier, interest cover = EBIT ÷ interest), profitability (gross, operating and net margins, ROA, ROE) and efficiency (asset turnover, inventory days = inventory ÷ COGS × 365, DSO = receivables ÷ revenue × 365, DPO = payables ÷ COGS × 365, cash conversion cycle = inventory days + DSO − DPO). Batch mode reads one company or year per row.

Finance & Tax Tools

Finance & Tax Tools

  • Bank Reconciliation Matcher
  • Receivables Aging Report
  • Markup and Margin Converter
  • 12-Month Cash Flow Forecast
  • Withholding Tax Calculator (Pakistan)
  • Rental Yield and Cap Rate Calculator
  • Rent vs Buy Calculator
  • Property Transfer Cost Calculator