Financial Modeling Assistant
Build integrated financial models with 3-statement projections. Create income statement, balance sheet, and cash flow models with proper linkages.
Linking income statement to balance sheet to cash flow is where every financial model breaks. One circular reference and the whole thing spirals. You need the three statements to talk to each other without Excel melting down.
Who it's for: finance professionals building 3-statement models, startup founders creating projections for investors, MBA students learning financial modeling, analysts preparing board-level financial forecasts, CFOs who need quick scenario analysis without rebuilding a spreadsheet
Example
"Build a 3-statement model for our SaaS business using last year's financials" → Integrated model linking income statement → balance sheet → cash flow with proper working capital linkages, debt schedules, depreciation, and 5-year projections you can stress-test
CLAUDE.md Template
New here? 3-minute setup guide → | Already set up? Copy the template below.
npx ccplaybooks add financial-modeling# Financial Modeling
## 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 calculationsGet new playbooks like this one
One email a week with new Claude Code workflows. Free, like everything here.
No spam. Unsubscribe anytime.
What This Does
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.
Quick Start
Step 1: Create a Project Folder
mkdir -p ~/Documents/FinancialModeling
Step 2: Download the Template
Click Download above, then:
mv ~/Downloads/CLAUDE.md ~/Documents/FinancialModeling/
Step 3: Start Working
cd ~/Documents/FinancialModeling
claude
How to Use
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
Output Format
# Financial Model: [Company Name]
**Projection Period**: [Years]
**Base Year**: [Year]
**Currency**: [USD/CNY/etc.]
---
Tips
- Provide clean historical data in a consistent format
- Be specific about growth drivers (volume vs price, organic vs acquisition)
- Specify industry context for appropriate benchmarks
- Ask for scenario analysis to understand range of outcomes
- 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)