Financial Metrics — Ratios & Analytics Inline

Last updated: April 17, 2026

Computes standard financial ratios from Numeric report data and layers them inline on your source statement. Covers profitability, covenant/liquidity/solvency, and operational/working-capital metrics — margins, EBITDA, current ratio, DSO, DPO, DIO, and more.

Before You Begin

  • Numeric MCP connected.

  • Numeric Toolkit installed.

How It Works

  1. Ask Claude for ratios. Example prompts:

    • "Add financial ratios to this report."

    • "What's our gross margin?"

    • "Check covenant compliance."

    • "Full financial health check."

  2. Claude detects mode: IS mode (margins, EBITDA), BS mode (liquidity, working capital), or Full (both).

  3. Claude pulls IS and BS data plus the chart of accounts for ratio mapping.

  4. Claude computes only the requested ratios (or all three categories for "full" / "health check").

  5. Claude produces an Excel workbook with the source statement + inline metric rows (blue background, italic text).

What You Get

An Excel workbook with inline ratios inserted directly into the report. Claude will look at ratios from three categories:

Profitability / Margin

Metric

Formula

Gross Margin

(Revenue − COGS) / Revenue

Operating Margin

Operating Income / Revenue

Net Margin

Net Income / Revenue

EBITDA

Operating Income + D&A

EBITDA Margin

EBITDA / Revenue

Staff Cost Ratio

Personnel / Revenue

Liquidity / Solvency

Metric

Formula

Current Ratio

Current Assets / Current Liabilities

Quick Ratio

(Current Assets − Inventory) / Current Liabilities

Debt-to-Equity

Total Liabilities / Total Equity

Interest Coverage

EBIT / Interest Expense

Net Debt / EBITDA

(Total Debt − Cash) / Annualized EBITDA

Working Capital

Metric

Formula

DSO — Days Sales Outstanding. Average days it takes to collect cash after a sale.

(AR / Revenue) × Days in Period

DPO — Days Payable Outstanding. Average days you take to pay vendors.

(AP / COGS) × Days in Period

DIO — Days Inventory Outstanding. Average days inventory sits before being sold.

(Inventory / COGS) × Days in Period

Cash Conversion Cycle

DSO + DIO − DPO

Troubleshooting

Issue

What to Check

Required account couldn't be identified

The skill will ask you directly rather than guessing (e.g., "Which account should I use for Interest Expense?"). Answer and re-run.

Trend arrows feel wrong

Direction is interpreted per metric (higher GM = good, higher D/E = bad). If you're seeing the wrong direction on a custom metric, confirm the ratio definition.

Wrong account feeding a ratio

Check the "Account Mapping Notes" section at the bottom of the sheet. Tell Claude which account to use and re-run.

FAQ

  • Custom ratios? Yes — ask Claude to add the metric definition.

  • Trend mode? Use month_over_month_3 or _6 comparison to compute ratios across periods.

  • Industry-specific ratios (SaaS, manufacturing)? Ask Claude to add ARR multiples, MRR growth, CAC ratio, etc.

  • Covenant reporting? Yes — add thresholds as input; skill color-codes passing/failing.

  • Layering onto an existing workbook? Yes — if you just ran executive-report or similar, ask Claude to add metrics to that workbook and it'll layer them into the IS sheet in place.

Download & Install

Download the full Numeric Toolkit (15 community skills, including this one):

🔗 numeric-mcp-toolkit.zip

Install via Claude Code CLI:

/plugin marketplace add geoff-lew/numeric-toolkit
/plugin install numeric-mcp-toolkit

Direct link to the Skill

🔗 financial-metrics.skill

In Cowork, go to Customize in the left sidebar, click +, select the Skills tab, and click Install to upload the downloaded skill file.

Need help? Reach out to support@numeric.io.