kayforkind/skill-slice/3-statement-model
Claude Code and agent skill by kayforkind/skill-slice
- community
Checking that the SKILL.md file is still in the repository.
Builds fully linked income-statement, balance-sheet, and cash-flow workbooks in openpyxl with working-capital, D&A, debt, and NOL schedules plus cash/RE tie-outs. Use for filling 3-statement templates or debugging a BS that will not balance. Do not use for DCF valuation or LBO debt waterfalls.
Install
npx vskill@latest install kayforkind/skill-slice/3-statement-modelSKILL.md
The same SKILL.md was published earlier as kayforkind/skill-slice/3-statement-model.
Overview
This skill produces fully-integrated 3-statement financial models as .xlsx files on disk using headless openpyxl. It covers template analysis, historical data population, projection formulas, supporting schedules (working capital, D&A, debt, NOL), cross-statement integrity checks, scenario toggles, and audit dashboards.
Environment: Headless openpyxl producing .xlsx on disk. Follow the excel-author skill's conventions for cell coloring, formulas, named ranges, and sensitivity tables. Recalculate before delivery by opening the workbook in Excel (full calculate + save). This folder does not ship a recalc helper.
Windows host is primary (PowerShell). Adjust path separators for macOS/Linux as needed.
When to Use
- User asks to build or complete an integrated 3-statement financial model (IS + BS + CF)
- User provides a template
.xlsxand asks to populate it with historicals and projections - User needs working capital schedules, D&A roll-forwards, debt schedules, or NOL schedules linked to main statements
- User wants scenario analysis (Base / Upside / Downside) with a toggle
- User needs cross-statement integrity checks (balance check, cash tie-out, RE roll-forward)
- User asks to debug a broken model where BS doesn't balance or cash doesn't tie
Trigger keywords: 3-statement, integrated model, income statement, balance sheet, cash flow, working capital schedule, D&A roll-forward, debt schedule, NOL, balance check, cash tie-out, scenario toggle, financial model template
Prerequisites
excel-authorskill installed (for cell coloring conventions, formula patterns, recalc script)- Python with openpyxl available
- Template
.xlsxfile (if user provides one) or ability to build from scratch - Historical financial data (from SEC filings, user-provided, or MCP data source)
Reference files (load when needed):
references/formulas.md— Load when writing projection formulas, cross-statement linkages, or building the checks/audit tab. Contains all formula details for core linkages.references/sec-filings.md— Load ONLY when populating templates with public company data from SEC filings (10-K, 10-Q). Contains extraction guidance for EDGAR.
Procedure
Step 1: Analyze the Template Structure
Before entering any data, thoroughly review the template to understand its architecture.
Identify tabs and their contents:
| Common Tab Names | Contents to Look For | |
|---|---|---|
| IS, P&L, Income Statement | Income Statement | |
| BS, Balance Sheet | Balance Sheet | |
| CF, CFS, Cash Flow | Cash Flow Statement | |
| WC, Working Capital | Working Capital Schedule | |
| DA, D&A, Depreciation, PP&E | Depreciation & Amortization Schedule | |
| Debt, Debt Schedule | Debt Schedule | |
| NOL, Tax, DTA | Net Operating Loss Schedule | |
| Assumptions, Inputs, Drivers | Driver assumptions and inputs | |
| Checks, Audit, Validation | Error-checking dashboard |
Template Review Checklist:
- Identify which tabs exist (not all templates include every schedule)
- Note any template-specific tabs not listed above
- Understand tab dependencies (e.g., which schedules feed into the main statements)
- Locate input cells vs. formula cells on each tab
Identify row structure:
- Locate the model title at top of each tab
- Identify section headers and their visual separation
- Find the units row indicating $ millions, %, x, etc.
- Note column headers distinguishing Actuals vs. Estimates periods
- Confirm period labels (e.g., FY2024A, FY2025E)
- Identify input cells vs. formula cells (typically distinguished by font color)
Identify column structure:
- Confirm line item labels in leftmost column
- Verify historical years precede projection years
- Note the visual border separating historical from projected periods
- Check for consistent column order across all tabs
Review named ranges:
- Check existing named ranges (Formulas → Name Manager in Excel, or via openpyxl
wb.defined_names) - Common named ranges: Revenue growth rates, cost percentages, key outputs (Net Income, EBITDA, Total Debt, Cash), scenario selector cell
- Ensure inputs are entered in cells that feed into these named ranges
Map the template's flow:
- Identify which tabs feed into others (e.g., Assumptions → IS → BS → CF)
- Note any supporting schedules and their linkages to main statements
- Document the template's specific line items and structure before populating
VERIFY WITH USER: After mapping the template, show the user which tabs/sections you've identified and confirm before touching any cells.
Step 2: Populate Historical Data
Golden Rules for Data Entry:
| Rule | Description | |
|---|---|---|
| Only edit input cells | Never overwrite cells containing formulas unless intentionally replacing the formula | |
| Preserve cell references | When copying data, use Paste Values (Ctrl+Shift+V) to avoid overwriting formulas with source formatting | |
| Match the template's units | Verify if template uses thousands, millions, or actual values before entering data | |
| Respect sign conventions | Follow the template's existing sign convention (e.g., expenses as positive or negative) | |
| Check for circular references | If the template uses iterative calculations, ensure Enable Iterative Calculation is turned on |
Safe data entry process:
- Identify the exact cells designated for input (usually highlighted or labeled)
- Enter historical data first, then verify formulas are calculating correctly for those periods
- Enter assumption drivers that feed forecast calculations
- Review calculated outputs to confirm formulas are working as intended
- If a formula cell must be modified, document the original formula before making changes
Handling pre-built formulas:
- If formulas reference cells you haven't populated yet, expect temporary errors (#REF!, #DIV/0!) until all inputs are complete
- When formulas produce unexpected results, trace precedents to identify missing or incorrect inputs
- Never delete rows/columns without checking for formula dependencies across all tabs
VERIFY WITH USER: After populating historicals, show the user the historical block and confirm values/periods match source data.
Step 3: Build Income Statement Projections
CRITICAL — Formulas over hardcodes (non-negotiable):
- Every projection cell, roll-forward, linkage, and subtotal MUST be an Excel formula — never a pre-computed value
- When using Python/openpyxl: write formula strings (
ws["D15"] = "=D14*(1+Assumptions!$B$5)"), NOT computed results (ws["D15"] = 12500) - The ONLY cells that should contain hardcoded numbers are: (1) historical actuals, (2) assumption drivers in the Assumptions tab
- If you find yourself computing a value in Python and writing the result to a cell — STOP. Write the formula instead.
- Why: the model must flex when scenarios toggle or assumptions change. Hardcodes break every downstream integrity check silently.
Projection period:
- Templates typically project 5 years forward from last historical year
- Verify historical (A) vs. projected (E) columns are clearly separated
- Confirm columns use fiscal year notation (e.g., FY2024A, FY2025E)
IS Quality Checks:
- Revenue figures match source data for historical periods
- All expense line items sum to reported totals
- Subtotals (Gross Profit, EBIT, EBT, Net Income) calculate correctly
- Tax calculation logic is appropriate (handles losses correctly)
- Forecast drivers reference assumptions tab (no hardcodes)
- Period-over-period changes are directionally reasonable
VERIFY WITH USER: After building IS projections, run the subtotal checks, show the user the projected IS, confirm before moving to BS.
Step 4: Build Balance Sheet Projections
BS Quality Checks:
- Assets = Liabilities + Equity for every period (primary check)
- Cash balance matches Cash Flow Statement ending cash
- Working capital accounts tie to supporting schedules (if applicable)
- Retained Earnings rolls forward correctly: Prior RE + Net Income - Dividends +/- Adjustments = Ending RE
- Debt balances tie to debt schedule (if applicable)
- All balance sheet items have appropriate signs (assets positive, most liabilities positive)
VERIFY WITH USER: After building BS, show the user the balance check (Assets = L+E) for every period, confirm before moving to CF.
Step 5: Build Cash Flow Statement Projections
CF Quality Checks:
- Net Income at top of CFO matches Income Statement Net Income
- Non-cash add-backs (D&A, SBC, etc.) tie to their source schedules/statements
- Working capital changes have correct signs (increase in asset = use of cash = negative)
- CapEx ties to PP&E schedule or fixed asset roll-forward
- Financing activities tie to changes in debt and equity accounts on BS
- Ending Cash matches Balance Sheet Cash
- Beginning Cash equals prior period Ending Cash
Sign Convention Reference:
| Statement | Item | Sign Convention | |
|---|---|---|---|
| CFO | D&A, SBC | Positive (add-back) | |
| CFO | ΔAR (increase) | Negative (use of cash) | |
| CFO | ΔAP (increase) | Positive (source of cash) | |
| CFI | CapEx | Negative | |
| CFF | Debt issuance | Positive | |
| CFF | Debt repayments | Negative | |
| CFF | Dividends | Negative |
VERIFY WITH USER: After building CF, show the user the cash tie-out (CF ending cash = BS cash), confirm before finalizing.
Step 6: Build Supporting Schedules
Working Capital Schedule:
- AR, Inventory, AP tie to BS
- DSO, DIO, DPO reasonability checks (flag if outside normal ranges)
- Opening balances equal prior period closing balances
D&A / PP&E Schedule:
- Roll-forward logic: Beginning PP&E + CapEx - Disposals = Ending PP&E
- D&A ties to IS and CF (as non-cash add-back)
- CapEx ties to CF (investing activities)
Debt Schedule:
- Total Debt ties to BS (Current + LT Debt)
- Interest calculation ties to IS
- Roll-forward: Beginning Debt + Issuances - Repayments = Ending Debt
NOL Schedule:
- Beginning NOL (Year 1 / Formation) = 0 (new business starts with zero NOL)
- NOL increases only when EBT < 0 (losses must be realized to generate NOL)
- DTA ties to BS (NOL Schedule DTA = BS Deferred Tax Asset)
- NOL utilization ≤ 80% of EBT (post-2017 federal limitation)
- NOL balance is non-negative (cannot utilize more than available)
- NOL generated only when EBT < 0
- Tax expense = 0 when taxable income ≤ 0
Equity Financing:
- Equity issuance proceeds tie to BS Common Stock/APIC increase
- Cash increase from equity = Equity account increase (must balance)
- Equity Raise Tie-Out: ΔCommon Stock/APIC (BS) = Equity Issuance (CFF) (must = 0)
- Year 0 Equity Tie-Out: Equity Raised (Year 0) = Beginning Equity Capital (Year 1)
Step 7: Cross-Statement Integrity Checks
After validating individual sheets, confirm the three statements are properly integrated:
| Check | Formula | Expected Result | |
|---|---|---|---|
| Balance Sheet Balance | Assets - Liabilities - Equity | = 0 | |
| Cash Tie-Out | CF Ending Cash - BS Cash | = 0 | |
| Cash Monthly vs Annual | Closing Cash (Monthly) - Closing Cash (Annual) | = 0 | |
| Net Income Link | IS Net Income - CF Starting Net Income | = 0 | |
| Retained Earnings | Prior RE + NI + SBC - Dividends - BS Ending RE | = 0 | |
| Equity Financing | ΔCommon Stock/APIC (BS) - Equity Issuance (CFF) | = 0 | |
| Year 0 Equity | Equity Raised (Year 0) - Beginning Equity Capital (Year 1) | = 0 |
Load references/formulas.md for all formula details when building the Checks/Audit tab.
Step 8: Scenario Analysis (Base / Upside / Downside)
Use a scenario toggle (dropdown) in the Assumptions tab with CHOOSE or INDEX/MATCH formulas.
| Scenario | Description | |
|---|---|---|
| Base Case | Management guidance or consensus estimates | |
| Upside Case | Above-guidance growth, margin expansion | |
| Downside Case | Below-trend growth, margin compression |
This is the start of the file. Read the full SKILL.md on GitHub.
Security
- Security scanPassed, 95 of 100Pattern checks on the skill's files.
- Model reviewPassed
Quality evaluation
- Task evaluationNot runNo evaluation yet. Run one in Skill Studio.
Source
- SKILL.md in the repositoryCheckingskills/3-statement-model/SKILL.md
Popularity
- 7-day trend score
- 5
Not refreshed yet.
Works with
Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.
- Claude Code
- Cursor
- GitHub Copilot
- Windsurf
- Codex
- Gemini CLI
- Cline
- Amp
- Roo Code
- Goose
- Continue
- Kilo Code
- Junie
- Trae
- OpenHands
- Qwen Code
- AI Agent
- Tabnine Chat
- Sourcegraph Cody
- Amazon Q
- Firebase Genkit
- Sweep
- Devin
- Phind
- Mentat
- Claude Desktop
- Aider
- GPT Pilot
- Plandex
- bolt.new
- v0
- Replit Agent
- Anse
- TypingMind
- BetterChatGPT
- LibreChat
- Warp AI
- Pieces
- Fig AI
Embed badge
[](https://verified-skill.com/skills/kayforkind/skill-slice/3-statement-model)