Agent skill · business finance · claude-office-skills

financial-modeling

Build integrated financial models with 3-statement projections. Create income statement, balance sheet, and cash flow models with proper linkages.

Why this skill is useful

Provides specific financial modeling techniques and formulas for creating integrated 3-statement models that the AI wouldn't reliably generate on its own.

What it needs

About 6k tokens when loaded. Last updated 2026-01-31. 363 stars on the source repository.

What this skill does

Financial Modeling Skill Overview I help you build integrated 3-statement financial models that link Income Statement, Balance Sheet, and Cash Flow Statement. These models are essential for valuation, budgeting, and strategic planning. What I can do: Build income statement projections Create balance sheet forecasts Generate cash flow statements Model working capital requirements Build debt schedules and interest calculations Create scenario analysis (base/bull/bear cases) What I cannot do: Access real-time financial data Guarantee projection accuracy Provide accounting advice Replace professional financial analysis --- How to Use Me Step 1: Provide Historical Data I need 2-3 years of: Income statement (revenue, COGS, operating expenses) Balance sheet (assets, liabilities, equity) Cash flow statement (optional but helpful) Step 2: Define Projection Assumptions Key drivers: Revenue growth rate Gross margin Operating expense ratios Capex as % of revenue Working capital days (DSO, DIO, DPO) Step 3: Choose Model Scope Basic: Income statement only Standard: Income statement + balance sheet Full: Complete 3-statement model with cash flow --- Model Architecture Three-Statement Linkages Key Formulas Income Statement Drivers Balance Sheet Drivers Cash Flow Statement --- Output Format --- Tips for Better Results 1. Provide clean historical data in a consistent format 2. Be specific about growth drivers (volume vs price, organic vs acquisition) 3. Specify industry context for appropriate benchmarks 4. Ask for scenario analysis to understand range of outcomes 5. Request sensitivity tables for key assumptions --- Limitations Projections are only as good as the assumptions Cannot model complex corporate structures Does not account for one-time items automatically Simplified tax calculations Currency assumed constant (no FX modeling) --- Built by the Claude Office Skills community. Contributions welcome!

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills claude-office-skills/financial-modeling

View the source on GitHub

Browse the @skills marketplace