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今天更新