Financial Modeling

作者 claude-office-skills9c4c7d5cd281MIT499 个星标收录于 2026年10月8日更新于 2026年10月8日仓库8个月前更新

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

仅含说明Business & Finance
AI 生成的概览

构建包含利润表、资产负债表和现金流量表预测的整合三表财务模型。

功能
指导构建整合的三表财务模型，涵盖利润表、资产负债表和现金流量表预测及其相互勾稽关系。它提供收入、利润率、营运资本、债务和现金的驱动公式，并给出假设、报表和关键指标的输出模板。它还支持基准、乐观和悲观等情景分析。
适用场景
适用于需要面向未来的财务预测以进行估值、预算或战略规划的场景。适合已有历史报表和预测假设、希望获得结构化模型的情况。
运行要求
仅为说明性内容，不附带脚本。需要用户提供历史财务数据和预测假设；其元数据引用了带电子表格工具的 office MCP 服务器。

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 - COGSSG&A = Revenue × SG&A %EBITDA = Gross Profit - SG&AD&A = Prior PP&E × D&A Rate OR Revenue × D&A %EBIT = EBITDA - D&AInterest = Avg Debt × Interest RateEBT = EBIT - InterestTaxes = EBT × Tax RateNet 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&ARetained Earnings = Prior RE + Net Income - DividendsCash = 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

markdown
# 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

  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!

来源与署名

来源：claude-office-skills/skills位于financial-modeling提交9c4c7d5

许可证： MIT

内容归原作者所有。SourceWeft 从公开仓库中收录这些内容。

举报或申请下架

更多来自 claude-office-skills/skills 的技能

Whatsapp Automation

claude-office-skills

指导 WhatsApp Business 自动化，涵盖客服聊天机器人、订单通知、预约提醒和群发活动。

Communication4998个月前更新

Xlsx Manipulation

claude-office-skills

使用 openpyxl 创建和编辑 Excel .xlsx 电子表格，涵盖公式、格式、图表和数据验证。

Documents & Office4998个月前更新

Web Search

claude-office-skills

指导制定网络搜索查询、评估来源并将发现综合为搜索策略。

Research & Analysis4998个月前更新

Weekly Report

claude-office-skills

根据你提供的信息，生成面向经理、团队、高管或客户的结构化每周状态报告。

Productivity & Workflow4998个月前更新

Tiktok Marketing

claude-office-skills

规划 TikTok 营销内容：内容支柱策略、视频脚本、话题标签、发布排期与效果分析。

Marketing & Sales4998个月前更新

Template Engine

claude-office-skills

用数据填充文档模板，支持 Word、Excel 和 PowerPoint 文件的邮件合并。

Documents & Office4998个月前更新

更多Business & Finance技能

Tax Prep

anthropics

精选

基于已结账的账目准备税务材料：季度预估缴税明细，或年终 1099-NEC 清单与会计师资料包。

Business & Finance27K今天更新

Plan Payroll

anthropics

精选

串联现金流预测、逾期发票催款与工资发放准备，让业主在提交前确认工资是否付得起。

Business & Finance27K今天更新

Job Post Builder

anthropics

精选

根据职位需求生成招聘材料包：职位发布、面试指南与评分表、录用通知书模板。

Business & Finance27K今天更新

Contract Review

anthropics

精选

审阅保密协议、主服务协议和供应商合同，用通俗语言标出风险条款，并可导出带修订标记的 DOCX。

Business & Finance27K今天更新

Close Month

anthropics

精选

执行月末结账链条：核对总账、刷新现金流预测，然后发布结账资料包。

Business & Finance27K今天更新

Business Pulse

anthropics

精选

为中小企业主生成一页式跨职能业务快照，整合已连接的财务、销售、管道、日历和收件箱工具数据。

Business & Finance27K今天更新