Financial Metrics — Ratios & Analytics Inline

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.

Reporting & Analysis

Financial Metrics — Ratios & Analytics Inline

Before You Begin

Numeric MCP connected.
Numeric Toolkit installed.

How It Works

Ask Claude for ratios. Example prompts:
- "Add financial ratios to this report."
- "What's our gross margin?"
- "Check covenant compliance."
- "Full financial health check."
Claude detects mode: IS mode (margins, EBITDA), BS mode (liquidity, working capital), or Full (both).
Claude pulls IS and BS data plus the chart of accounts for ratio mapping.
Claude computes only the requested ratios (or all three categories for "full" / "health check").
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 organized in 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.

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

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

Financial Metrics — Ratios & Analytics Inline