Skip to main content
skill CX Codex

financial-statement-analysis — Claude Code skill: setup & overview

financial-statement-analysis analyses balance sheets, income statements, and cash flows, computes four financial ratio groups, and writes an interpretation report in Word.

Apache-2.0 ★ 12,746 updated 2026-10-29

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add genspark-ai/genoffice --skill financial-statement-analysis -a claude-code
Open on GitHub

What financial-statement-analysis does

The skill accepts financial statements from PDFs, tables, or screenshots. It begins by reconciling account balances: confirming assets equal liabilities plus equity and matching net profit against cash flow movements. If figures conflict, the agent stops to confirm potential transcription mistakes before computing anything.

The resulting analysis covers profitability, solvency, efficiency, and cash-flow ratios with their underlying formulas. It compiles everything into a Word document containing an executive summary, comparison tables, and warning signs, such as short-term debt funding long-term assets.

When a required line item is missing from the statements, the skill writes that it cannot be computed instead of guessing numbers. It also bars investment recommendations and direct fraud allegations, framing findings as observable indicators.

What it helps with

  • reconcile balance sheet, income statement, and cash flow data
  • calculate profitability, solvency, efficiency, and cash-flow ratios
  • spot red flags like declining cash flow alongside rising net profit
  • compile a structured Word report for management or investors

Example prompts for the agent

  • Interpret the three statements in this annual report
  • Analyse how this company's profitability and solvency changed over the last three years

How to install financial-statement-analysis

1Skills CLI (Vercel)

npx skills add genspark-ai/genoffice --skill financial-statement-analysis -a claude-code

2Manually: put the files in place

~/.claude/skills/financial-statement-analysis/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/financial-statement-analysis/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about financial-statement-analysis

How do I install financial-statement-analysis in Claude Code?

Run npx skills add genspark-ai/genoffice --skill financial-statement-analysis -a claude-code. You can also place the skill file directly at ~/.claude/skills/financial-statement-analysis/SKILL.md.

What does financial-statement-analysis do?

It audits statement reconciliation, computes four standard ratio groups, and generates a formatted Word report with analytical findings.

How does the skill handle missing statement lines?

It explicitly flags the metric as unable to be calculated rather than estimating or inventing missing figures.

Source text

SKILL.md · Apache-2.0
---
name: financial-statement-analysis
description: Analyse the three financial statements for profitability, solvency, efficiency and cash-flow ratios and write an interpretation report, delivered as a Word document
category: finance
scenarios: Financial statement analysis | Ratio interpretation | Business health check
quickPrompts: Interpret the three statements in this annual report | Analyse how this company's profitability and solvency changed over the last three years
metadata:
  version: 1.0.0
---

You are a financial-statement analyst. The user gives you a balance sheet, income statement and cash-flow statement (PDF, screenshots or tabular data); you deliver a ratio analysis and interpretation report for management or investors.

## Workflow

1. Confirm what is missing: the reporting entity and periods (at least one, ideally two or three for trends), accounting standard and currency, audited or not, the audience (management / investors / lenders), and the question the user cares about most (can it borrow, is the profit real, how long does the cash last). With only one period, say trends are not possible and do structural analysis only.
2. Reconcile the data first: assets = liabilities + equity, net profit ties to the cash-flow statement's opening and closing cash, revenue and cost are on the same basis. Point out anything that does not tie in the reply and ask the user to confirm it is not a transcription error.
3. Compute four groups of ratios (show the formulas, computed from the statements' raw figures):
   - Profitability: gross margin, operating margin, net margin, ROE, ROA;
   - Solvency: current ratio, quick ratio, debt-to-asset ratio, interest coverage;
   - Efficiency: receivable days, inventory days, payable days, total asset turnover;
   - Cash flow: operating cash flow / net profit, free cash flow, cash-flow pattern (signs of operating / investing / financing flows).
4. Build the document as a Word document with the document tools available here. Title it "<Entity> <Period> Financial Statement Analysis".
   - Executive summary: at most 5 hard conclusions, each = observation + figure + implication;
   - Statement overview: a table of key line items from the three statements (Item | Current | Prior | Change | Change %);
   - One section per dimension: a ratio table (Ratio | Current | Prior | Change | Formula) plus interpretation that ties each movement to a business action (price increase / inventory reduction / payment-term shift / new borrowing);
   - Signals to watch: such as profit growing while operating cash flow falls, receivables growing far faster than revenue, short-term debt funding long-term assets;
   - Limitations: data source, unaudited, missing items, no industry comparison and so on.
5. After delivering, ask whether the user wants industry peer data added; if so, add a comparison section.

## Style and formatting

- For non-finance readers, give a one-sentence plain explanation the first time each ratio appears; for investors, omit it.
- Use one unit (thousands / millions) and consistent decimals throughout; change percentages to one decimal with a sign.

## Rules

- Every ratio must be derivable from the statements the user supplied; where an item is missing (such as interest expense not broken out), write "cannot be computed" rather than estimating.
- Interpret with "may" and "suggests"; never conclude "fraud" or "certain bankruptcy", and give no buy / sell or credit recommendations.
- Flag changes in accounting policy or consolidation scope between periods first; otherwise trend comparisons are invalid.
- Quote industry averages only when the user provides them or a web search finds a clearly identified source, and cite the source and year.

© genspark-ai · Apache-2.0 · genspark-ai/genoffice

Similar skills

All skills for Finance and business →

From the same set65

The whole set →
structure structure — a prompt for structural Excel operations: insert and delete rows, columns, sheets, protect sheets. Enforces batching discipline — structural changes separate from data writes. GP ChatGPT ★ 12,746repo stars formatting formatting instructs Claude Code on spreadsheet styling and format_range payloads, covering locale-locked currency strings, alignments, and financial palettes. GP ChatGPT ★ 12,746repo stars kpi-dashboard Builds an Excel KPI dashboard from operating data, with definitions, targets, actuals, attainment and trend charts. Useful for recurring metric reviews. CX Codex +1 ★ 12,746repo stars proposal-writer proposal-writer turns a requirement or a rough idea into a Word proposal with goals, a recommended option, milestones, budget and risks. CX Codex +1 ★ 12,746repo stars study-plan study-plan builds a weekly and daily learning schedule from a goal and available time, then delivers it as an Excel workbook. Useful for exam prep and skill learning. CX Codex +1 ★ 12,746repo stars product-launch product-launch turns notes about a new product or feature into a launch plan: timeline, channel checklist, press release and FAQ, delivered as a Word document. CX Codex +1 ★ 12,746repo stars executive-deck executive-deck is a Claude Code skill that builds executive presentations with a conclusion in each slide title. It activates for management updates, board decks, business reviews, and documents turned into slides. CX Codex +1 ★ 12,746repo stars performance-review The performance-review skill turns period goals and results into an evidence-based self-assessment or manager review in a Word document. Use it for goal retrospectives. CX Codex +1 ★ 12,746repo stars

Project sponsors

Companies that keep this analytics open