SkillHub

Skills claude-office-skills skills

financial-modeling

Use it when:
You need a five-year projection of a company's income statement, balance sheet and cash flow for a valuation, budget or plan.
It does:
Projects each line from drivers such as growth, gross margin, SG&A and capex as shares of revenue, and receivable, inventory and payable days.
You get:
Markdown tables of assumptions, the three statements with a balance check, and a summary of margins, ROE, debt to equity and free cash flow.
Scope:
Income statement only, income statement plus balance sheet, or the full three-statement model.
Limits:
Simplified taxes, no currency effects, no complex corporate structures or automatic one-off items; it isn't accounting advice.

TL;DR

From Claude Office Skills. You provide two or three years of historical income statements and balance sheets (cash flow optional), set the drivers, and choose the model's scope. The agent links the statements the standard way: net income flows into retained earnings, cash is the balancing item on the balance sheet, changes in balance sheet items drive the cash flow statement, and ending cash flows back. It spells out each formula, for example revenue as last year's times one plus growth, receivables as revenue times DSO over 365, PP&E as prior PP&E plus capex minus depreciation, and operating cash flow as net income plus D&A less increases in working capital. The output is a fixed set of Markdown tables, a base year plus five projected years. Its tips suggest asking for scenarios and sensitivity tables. Its frontmatter lists spreadsheet and chart tools of the repo's office-mcp server, but its instructions never call them, so you get tables in the reply, not a spreadsheet.

Summarizes the skill at 9c4c7d5.

npx skills add https://github.com/claude-office-skills/skills --skill financial-modeling

skills.sh pageSource on GitHubAll skills from claude-office-skills/skills

Total Downloads
5,300 on skills.sh, Nov 9, 2026
Repo stars
569 claude-office-skills/skills
First seen
Mar 9, 2026 on skills.sh
Weekly Downloads
83
-7% over the 8 weeks to Nov 9
Weekly values
Week toInstalls
Sep 2189
Sep 2863
Oct 569
Oct 12108
Oct 19235
Oct 26193
Nov 271
Nov 983
Category
category:sciencecategory:business

Research reproduction, financial data, charts and diagrams.

Run a company outside its code and marketing: strategy, sales, finance, operations, legal, management and hiring.
Type
type:guidelines

Knowledge and rules the agent applies while it works: best practices, design principles, API references.
Effect
effect:none

Adds no side effects of its own. It shapes how the agent thinks, writes or reviews. Guidelines and routers are always effect:none, even when the task they support edits code.
Needs
needs:none

Instructions only. Works in any agent that supports skills.
Publisher
by:community

Everyone else. Unverified vendor claims default to community.
Topics
finance

SKILL.md

From claude-office-skills/skills at 9c4c7d5. Checked daily, last changed Nov 6, 2026.

Frontmatter
# ═══════════════════════════════════════════════════════════════════════════════
# CLAUDE OFFICE SKILL - Financial Modeling
# ═══════════════════════════════════════════════════════════════════════════════

name: financial-modeling
description: "Build integrated financial models with 3-statement projections. Create income statement, balance sheet, and cash flow models with proper linkages."
version: "1.0.0"
author: claude-office-skills
license: MIT

category: finance
tags:
  - financial-modeling
  - three-statement
  - forecasting
  - income-statement
  - balance-sheet
department: Finance/FP&A

models:
  recommended:
    - claude-sonnet-4
    - claude-opus-4
  compatible:
    - claude-3-5-sonnet
    - gpt-4
    - gpt-4o

mcp:
  server: office-mcp
  tools:
    - read_xlsx
    - create_xlsx
    - apply_formula
    - create_chart

capabilities:
  - three_statement_modeling
  - revenue_forecasting
  - expense_modeling
  - working_capital_projections
  - debt_schedule_modeling

languages:
  - en
  - zh

related_skills:
  - dcf-valuation
  - stock-analysis
  - data-analysis

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

  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!