Ratio analysis

Skill Ceschiu/finance-portfolio/claude-skills/ratio-analysis

Technical preparation toolkit for buy-side roles: portfolio analytics in Python, Claude Agent skills, VBA macros for Excel, and SQL exercises

Install

npx -y skills add Ceschiu/finance-portfolio --skill ratio-analysis

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Compute liquidity, leverage, profitability and efficiency ratios of a company from balance-sheet / income-statement items. Trigger if user asks for financial ratios. Not for DCF — see dcf-analyzer.

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

3.0 KB, 730 tokens by cl100k_base, as published. Nobody here has run it

ratio-analysis

Quando usare questa skill

Compute liquidity, leverage, profitability and efficiency ratios of a company from its financial statements (current, quick, D/E, ROE, ROA...). Use when the user asks for a company's financial ratios and provides balance-sheet / income-statement items. Do not use for intrinsic/DCF valuation — see dcf-analyzer.

Input

Revenue (float | null)
NetIncome (float | null)
EBIT (float | null)
InterestExpense (float | null)
TotalAssets (float | null)
CurrentAssets (float | null)
Inventory (float | null)
CurrentLiabilities (float | null)
TotalDebt (float | null)
TotalEquity (float | null)

The user may provide the data in the message or a CSV; the skill assembles them into input.json following the Contract.

Procedura

Validate the input values, considering their metric, values and sign (e.g. no negative revenues).
If all the inputs are correct, convert the ones that need it (e.g. scientific notation, 1e3 -> 1000).
Write the inputs to a temp JSON, run scripts/ratio.py <path> via Bash, parse the JSON from stdout.

Output

Return a table with the following financial ratios: current, quick, D/E, interest coverage, ROE, ROA, net margin, asset turnover. Followed by a brief comment of the results.

Casi limite

If any denominator is equal to 0, the related ratio is returned as null and a warning is added; the other ratios are still computed.
If there are missing values, ask the user whether they are missing and what values to use instead.
Any other error during the computation must return a warning explaining the problem.

Contract

The skill writes input.json, which is the input for the Python script scripts/ratio.py. Run it via Bash: python scripts/ratio.py input.json.

INPUT schema (keys):

{
  "Revenue": float | null,
  "NetIncome": float | null,
  "EBIT": float | null,
  "InterestExpense": float | null,
  "TotalAssets": float | null,
  "CurrentAssets": float | null,
  "Inventory": float | null,
  "CurrentLiabilities": float | null,
  "TotalDebt": float | null,
  "TotalEquity": float | null
}

Use null for any missing value.

The script prints a JSON object to stdout, which the skill parses.

OUTPUT schema (success):

{
  "ok": true, "error": null, "field": null,
  "current_ratio": float | null,
  "quick_ratio": float | null,
  "debt_to_equity": float | null,
  "interest_coverage": float | null,
  "ROE": float | null,
  "ROA": float | null,
  "net_margin": float | null,
  "asset_turnover": float | null
}

OUTPUT schema (error):

{"ok": false, "error": "<message>", "field": "<key>"}

Riferimenti

For all the formulas use references/ratio_methodology.md.