agentleFS
varunk130varunk130/claude-code-skills/skills/financial-analysis/financial-statement-analyzer/SKILL.md

financial-statement-analyzer

Skill1 starsChanged 20 days agoMITView on GitHub

Performs structured fundamental analysis of annual reports (Form 10-K, Form 10-Q): ratio analysis, quality of earnings, working-capital efficiency, segment decomposition, accounting red flags, and Management's Discussion and Analysis (MD&A) parsing. Use when underwriting an investment; evaluating a competitor; preparing for an earnings call; building peer comparables; or screening for accounting risk.

The file

We split this skill into the rules it gives an agent

4 rules. About 0 are common, 4 are distinctive, and 0 are very specific to this project.

  • ≈0

    Common · estimate

    Many files like this have a rule of this kind.

  • ≈4

    Distinctive · estimate

    This author's own choices. Worth a look.

  • 0

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Distinctive:

    Read footnotes - that's where the disclosures live

    line 150
  2. Distinctive:

    Document data gaps explicitly

    line 153
  3. Distinctive:

    Treat one quarter as a trend

    line 157
  4. Distinctive:

    Use peer multiples without normalizing for accounting policy

    line 159

≈ “Common” is an estimate: at least 1 in 5 of the 350,495 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

Financial Statement Analyzer

A repeatable teardown of public-company financials that produces an institutional-quality analysis.

What this skill is

A structured workflow that reads the full Form 10-K and Form 10-Q stack - income statement, balance sheet, cash flow, Management's Discussion and Analysis (MD&A), footnotes, risk factors, and proxy statement - and produces a one-page summary with margin waterfalls, quality-of-earnings score, segment decomposition, and an accounting red-flag log. Designed to surface the data that the headline numbers hide.

What it solves

  • Headline Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) reviews that ignore non-Generally Accepted Accounting Principles (non-GAAP) adjustments
  • Margin analysis with no waterfall identifying which line item moved
  • Missed red flags hiding in footnotes, risk factors, and Cash Conversion Cycle (CCC) trends
  • Segment data taken at face value (without checking corporate-overhead allocation)
  • Skipping the year-over-year diff of risk factors - the single most under-read disclosure

When to invoke

  • Underwriting a long or short position in a public company
  • Benchmarking a private company against the public peer set
  • Pre-earnings preparation for management question-and-answer
  • Quarterly competitor financial review
  • Diligence on a partnership, vendor, or acquisition target

Phase 1: Source the filings

Confirm the latest:

  • Annual report (Form 10-K, or Form 20-F for foreign issuers) - most recent fiscal year
  • Quarterly report (Form 10-Q) - trailing 4 quarters
  • Current report (Form 8-K) - material events, guidance, restatements (last 12 months)
  • Proxy statement (Form DEF 14A) - executive compensation, related-party transactions, board composition
  • Earnings release plus supplemental (segment data often only here)
  • Earnings call transcript - tone, question-and-answer pressure points

Log filing date and period for each. Note any restatements.

Phase 2: Quality of revenue

  • Revenue recognition policy (Accounting Standards Codification (ASC) 606 adherence)
  • Performance obligation timing - ratable versus point-in-time
  • Deferred revenue trend (balance sheet liability) - should grow with bookings
  • Remaining Performance Obligation (RPO) or backlog - directional read on future revenue
  • Customer concentration (top-10 percent of revenue, footnotes)
  • Geographic and segment mix - where is growth coming from?
  • Channel inventory and sell-in versus sell-through (Consumer Packaged Goods (CPG), hardware) - channel-stuffing risk
  • Non-GAAP adjustments - list each and decide if defensible

Compute organic growth = reported growth − Mergers and Acquisitions (M&A) contribution − foreign exchange − accounting policy change.

Phase 3: Profitability and margin architecture

Margin waterfall year-over-year:

LineY-2Y-1YΔ basis pointsDriver
Revenue$X$X$Xnot applicable
Gross marginxx%xx%xx%± basis pointsmix / pricing / cost
Research and Development (R&D) percentxx%xx%xx%± basis pointsinnovation intensity
Sales and Marketing (S&M) percentxx%xx%xx%± basis pointsgrowth investment
General and Administrative (G&A) percentxx%xx%xx%± basis pointsoperating leverage
Operating marginxx%xx%xx%± basis points
Tax ratexx%xx%xx%± basis pointsmix / one-timers
Net marginxx%xx%xx%± basis points

DuPont decomposition of Return on Equity (ROE):

ROE = Net margin × Asset turnover × Equity multiplier

Identify which lever moved.

Phase 4: Working capital and cash conversion

Cash Conversion Cycle (CCC) = Days Sales Outstanding (DSO) + Days Inventory Outstanding (DIO) − Days Payable Outstanding (DPO)
  • DSO rising → collection problems, channel stuffing, or longer-term contracts
  • DIO rising → demand softness, obsolescence
  • DPO rising → vendor financing, possibly stress

Compare Cash Flow from Operations (CFO) / Net income:

  • Less than 1× across multiple periods → earnings-quality concern
  • Identify the gap (working capital, Stock-Based Compensation (SBC), deferred tax)

Free Cash Flow (FCF) / Adjusted EBITDA conversion: Software as a Service (SaaS) 60-80% healthy; services 80%+.

Phase 5: Balance sheet and capital structure

  • Net debt / Adjusted EBITDA → covenant headroom, refinancing risk
  • Interest coverage = Adjusted EBITDA / interest expense
  • Maturity wall (footnotes) - concentration in next 18 months?
  • Off-balance-sheet items (operating leases on balance sheet under ASC 842, purchase commitments, contingent consideration)
  • Goodwill plus intangibles as percent of equity → impairment risk
  • Pension and Other Post-Employment Benefits (OPEB) underfunded status
  • Tangible book value versus market capitalization → strategic floor

Phase 6: Accounting red flags

Red flagLook forSeverity
DSO jumpingup more than 20% year-over-year without business-model changeHigh
Cost reclassCost of Goods Sold (COGS) moved to operating expenseMedium
Asset quality declinenon-current assets up faster than revenueMedium
Soft revenuerevenue growth much greater than cash collection growthHigh
Selling, General and Administrative (SG&A) growing slower than revenuepossible cost capitalizationMedium
Depreciation rate droppinguseful-life extensionsMedium
Accruals divided by assets risingearnings managementHigh
Recurring one-time chargescookie-jar reservesMedium
Goodwill up without impairmentrolling acquisitions, no testMedium
Restatements in last 3 yearsinternal control weaknessHigh

Cross-check the auditor's report: going concern, Critical Audit Matter (CAM), or auditor change.

Phase 7: Segment decomposition

  • Revenue plus operating earnings (EBIT) by segment with margins
  • Inter-segment eliminations
  • Allocation of corporate overhead - does management hide losses?
  • Segment capital expenditure if disclosed
  • Identify the value-driver and the value-destroyer segments
  • Sum-of-the-parts cross-check on consolidated multiples

Phase 8: MD&A and risk factors

  • MD&A: specific versus vague year-over-year explanations
  • Year-over-year diff of risk factors - new risks added are the most revealing single signal in the filing
  • Critical accounting estimates - where management has the most judgment
  • Earnings call tone - hedging language, Chief Financial Officer (CFO) guidance walk

Output

  • One-page executive summary: bull case, bear case, decisive data point
  • Margin and CCC waterfalls with year-over-year drivers
  • Quality-of-earnings score (1-10) with reasoning
  • Red-flag log with severity and follow-up question
  • Peer comparable table: growth, gross margin, operating margin, FCF margin, Return on Invested Capital (ROIC), leverage
  • 3 questions to ask the CFO on the next earnings call

Operating rules

Always

  • Reconcile non-GAAP to GAAP and judge each adjustment
  • Read footnotes - that's where the disclosures live
  • Compare CFO to net income across multiple years
  • Cross-check segment data against the press release supplemental
  • Document data gaps explicitly

Never

  • Trust headline EBITDA without the bridge
  • Treat one quarter as a trend
  • Skip the year-over-year risk factors diff
  • Use peer multiples without normalizing for accounting policy
  • Confuse organic growth with reported growth

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.