financial-modeling
Build integrated financial models with 3-statement projections. Create income statement, balance sheet, and cash flow models with proper linkages.
- License 许可
- MIT
- 最近更新
- 2026-07-18
- Stars
- ★ 0
- Forks
- 1
01 前言 Front Matter
- mcp
- { "tools": [ "read_xlsx", "create_xlsx", "apply_formula", "create_chart" ], "server": "office-mcp" }
- name
- financial-modeling
- tags
- [ "financial-modeling", "three-statement", "forecasting", "income-statement", "balance-sheet" ]
- author
- claude-office-skills
- models
- { "compatible": [ "claude-3-5-sonnet", "gpt-4", "gpt-4o" ], "recommended": [ "claude-sonnet-4", "claude-opus-4" ] }
- license
- MIT
- version
- 1.0.0
- category
- finance
- languages
- [ "en", "zh" ]
- department
- Finance/FP&A
- description
- Build integrated financial models with 3-statement projections. Create income statement, balance sheet, and cash flow models with proper linkages.
- capabilities
- [ "three_statement_modeling", "revenue_forecasting", "expense_modeling", "working_capital_projections", "debt_schedule_modeling" ]
- related_skills
- [ "dcf-valuation", "stock-analysis", "data-analysis" ]
02 资源文件 1
- 参考文档metadata.json492 B
03 SKILL.md 正文
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
┌─────────────────────────────────────────────────────────────┐
│ INCOME STATEMENT │
│ Revenue → Gross Profit → Operating Income → Net Income │
└─────────────────────────┬───────────────────────────────────┘
│
Net Income flows to Retained Earnings
│
▼
┌─────────────────────────────────────────────────────────────┐
│ BALANCE SHEET │
│ Assets = Liabilities + Equity │
│ (Must balance via Cash as plug) │
└─────────────────────────┬───────────────────────────────────┘
│
Changes in B/S items drive CF Statement
│
▼
┌─────────────────────────────────────────────────────────────┐
│ CASH FLOW STATEMENT │
│ Operating CF + Investing CF + Financing CF = Δ Cash │
│ Ending Cash flows back to Balance Sheet │
└─────────────────────────────────────────────────────────────┘
Key Formulas
Income Statement Drivers
Revenue = Prior Year × (1 + Growth Rate)
COGS = Revenue × (1 - Gross Margin %)
Gross Profit = Revenue - COGS
SG&A = Revenue × SG&A %
EBITDA = Gross Profit - SG&A
D&A = Prior PP&E × D&A Rate OR Revenue × D&A %
EBIT = EBITDA - D&A
Interest = Avg Debt × Interest Rate
EBT = EBIT - Interest
Taxes = EBT × Tax Rate
Net Income = EBT - Taxes
Balance Sheet Drivers
Accounts Receivable = Revenue × (DSO / 365)
Inventory = COGS × (DIO / 365)
Accounts Payable = COGS × (DPO / 365)
PP&E = Prior PP&E + Capex - D&A
Retained Earnings = Prior RE + Net Income - Dividends
Cash = Total Liabilities + Equity - Other Assets (plug)
Cash Flow Statement
Operating Cash Flow:
Net Income
+ D&A (non-cash)
- Increase in AR
- Increase in Inventory
+ Increase in AP
= Cash from Operations
Investing Cash Flow:
- Capex
= Cash from Investing
Financing Cash Flow:
+ Debt Issuance
- Debt Repayment
- Dividends
= Cash from Financing
Net Change in Cash = CFO + CFI + CFF
Output Format
# Financial Model: [Company Name]
**Projection Period**: [Years]
**Base Year**: [Year]
**Currency**: [USD/CNY/etc.]
---
## Key Assumptions
| Driver | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|--------|--------|--------|--------|--------|--------|
| Revenue Growth | XX% | XX% | XX% | XX% | XX% |
| Gross Margin | XX% | XX% | XX% | XX% | XX% |
| SG&A % Revenue | XX% | XX% | XX% | XX% | XX% |
| Capex % Revenue | XX% | XX% | XX% | XX% | XX% |
| DSO (days) | XX | XX | XX | XX | XX |
| DIO (days) | XX | XX | XX | XX | XX |
| DPO (days) | XX | XX | XX | XX | XX |
---
## Income Statement Projection
| ($M) | Base | Y1 | Y2 | Y3 | Y4 | Y5 |
|------|------|-----|-----|-----|-----|-----|
| **Revenue** | | | | | | |
| Growth % | | | | | | |
| COGS | | | | | | |
| **Gross Profit** | | | | | | |
| Gross Margin % | | | | | | |
| SG&A | | | | | | |
| **EBITDA** | | | | | | |
| EBITDA Margin % | | | | | | |
| D&A | | | | | | |
| **EBIT** | | | | | | |
| Interest Expense | | | | | | |
| **EBT** | | | | | | |
| Taxes | | | | | | |
| **Net Income** | | | | | | |
| Net Margin % | | | | | | |
---
## Balance Sheet Projection
| ($M) | Base | Y1 | Y2 | Y3 | Y4 | Y5 |
|------|------|-----|-----|-----|-----|-----|
| **ASSETS** | | | | | | |
| Cash | | | | | | |
| Accounts Receivable | | | | | | |
| Inventory | | | | | | |
| **Current Assets** | | | | | | |
| PP&E (net) | | | | | | |
| Other Assets | | | | | | |
| **Total Assets** | | | | | | |
| | | | | | | |
| **LIABILITIES** | | | | | | |
| Accounts Payable | | | | | | |
| Short-term Debt | | | | | | |
| **Current Liabilities** | | | | | | |
| Long-term Debt | | | | | | |
| **Total Liabilities** | | | | | | |
| | | | | | | |
| **EQUITY** | | | | | | |
| Common Stock | | | | | | |
| Retained Earnings | | | | | | |
| **Total Equity** | | | | | | |
| **Total L + E** | | | | | | |
✓ Balance Check: Assets = Liabilities + Equity
---
## Cash Flow Statement
| ($M) | Y1 | Y2 | Y3 | Y4 | Y5 |
|------|-----|-----|-----|-----|-----|
| **Operating Activities** | | | | | |
| Net Income | | | | | |
| D&A | | | | | |
| Change in AR | | | | | |
| Change in Inventory | | | | | |
| Change in AP | | | | | |
| **Cash from Operations** | | | | | |
| | | | | | |
| **Investing Activities** | | | | | |
| Capex | | | | | |
| **Cash from Investing** | | | | | |
| | | | | | |
| **Financing Activities** | | | | | |
| Debt Changes | | | | | |
| Dividends | | | | | |
| **Cash from Financing** | | | | | |
| | | | | | |
| **Net Change in Cash** | | | | | |
| Beginning Cash | | | | | |
| **Ending Cash** | | | | | |
---
## Key Metrics Summary
| Metric | Base | Y1 | Y2 | Y3 | Y4 | Y5 |
|--------|------|-----|-----|-----|-----|-----|
| Revenue Growth | | | | | | |
| Gross Margin | | | | | | |
| EBITDA Margin | | | | | | |
| Net Margin | | | | | | |
| ROE | | | | | | |
| Debt/Equity | | | | | | |
| FCF | | | | | | |
Tips for Better Results
- 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)
Built by the Claude Office Skills community. Contributions welcome!
04 同仓库更多 Skills
arxiv-search
Search arXiv physics, math, and computer science preprints using natural language queries. Powered by Valyu semantic search.
arxiv-search
Search arXiv physics, math, and computer science preprints using natural language queries. Powered by Valyu semantic search.
working-with-legacy-code
Safely change and test untested codebases using Feathers' "Working Effectively with Legacy Code". Use when the user mentions "legacy code", "no tests", "untested codebase", "how do I test this", "seams", "characterization tests", "golden master", "sprout method", "afraid to change this code", "monster method", "dependency breaking", or "inherited a messy codebase". Also trigger when changing code without tests safely, getting a class under test when constructors, statics, or singletons block it, adding features to tangled modules, or planning incremental test coverage for an old codebase. Covers the legacy-code change algorithm, seams, characterization tests, sprout/wrap, and dependency-breaking techniques. For refactoring code that already has tests, see refactoring-patterns. For day-to-day code quality, see clean-code.
working-with-legacy-code
Safely change and test untested codebases using Feathers' "Working Effectively with Legacy Code". Use when the user mentions "legacy code", "no tests", "untested codebase", "how do I test this", "seams", "characterization tests", "golden master", "sprout method", "afraid to change this code", "monster method", "dependency breaking", or "inherited a messy codebase". Also trigger when changing code without tests safely, getting a class under test when constructors, statics, or singletons block it, adding features to tangled modules, or planning incremental test coverage for an old codebase. Covers the legacy-code change algorithm, seams, characterization tests, sprout/wrap, and dependency-breaking techniques. For refactoring code that already has tests, see refactoring-patterns. For day-to-day code quality, see clean-code.
web-typography
Select, pair, and implement typefaces for web projects. Use when the user mentions "font pairing", "which typeface", "line height", "responsive typography", "web font loading", "type hierarchy", "variable fonts", "FOUT/FOIT", "typographic scale", or "the text is hard to read". Also trigger when choosing between system fonts and web fonts, optimizing font-loading performance, or designing readable long-form content. Covers readability evaluation, CSS implementation, and performance optimization. For overall UI design systems, see refactoring-ui. For dramatic typographic experiences, see top-design.
web-typography
Select, pair, and implement typefaces for web projects. Use when the user mentions "font pairing", "which typeface", "line height", "responsive typography", "web font loading", "type hierarchy", "variable fonts", "FOUT/FOIT", "typographic scale", or "the text is hard to read". Also trigger when choosing between system fonts and web fonts, optimizing font-loading performance, or designing readable long-form content. Covers readability evaluation, CSS implementation, and performance optimization. For overall UI design systems, see refactoring-ui. For dramatic typographic experiences, see top-design.