kayforkind/skill-slice/3-statement-model

Claude Code and agent skill by kayforkind/skill-slice

Trust tier 3
  • community
Source check pending

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-model

SKILL.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 .xlsx and 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-author skill installed (for cell coloring conventions, formula patterns, recalc script)
  • Python with openpyxl available
  • Template .xlsx file (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 NamesContents to Look For
IS, P&L, Income StatementIncome Statement
BS, Balance SheetBalance Sheet
CF, CFS, Cash FlowCash Flow Statement
WC, Working CapitalWorking Capital Schedule
DA, D&A, Depreciation, PP&EDepreciation & Amortization Schedule
Debt, Debt ScheduleDebt Schedule
NOL, Tax, DTANet Operating Loss Schedule
Assumptions, Inputs, DriversDriver assumptions and inputs
Checks, Audit, ValidationError-checking dashboard

Template Review Checklist:

  1. Identify which tabs exist (not all templates include every schedule)
  2. Note any template-specific tabs not listed above
  3. Understand tab dependencies (e.g., which schedules feed into the main statements)
  4. 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:

RuleDescription
Only edit input cellsNever overwrite cells containing formulas unless intentionally replacing the formula
Preserve cell referencesWhen copying data, use Paste Values (Ctrl+Shift+V) to avoid overwriting formulas with source formatting
Match the template's unitsVerify if template uses thousands, millions, or actual values before entering data
Respect sign conventionsFollow the template's existing sign convention (e.g., expenses as positive or negative)
Check for circular referencesIf the template uses iterative calculations, ensure Enable Iterative Calculation is turned on

Safe data entry process:

  1. Identify the exact cells designated for input (usually highlighted or labeled)
  2. Enter historical data first, then verify formulas are calculating correctly for those periods
  3. Enter assumption drivers that feed forecast calculations
  4. Review calculated outputs to confirm formulas are working as intended
  5. 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:

StatementItemSign Convention
CFOD&A, SBCPositive (add-back)
CFOΔAR (increase)Negative (use of cash)
CFOΔAP (increase)Positive (source of cash)
CFICapExNegative
CFFDebt issuancePositive
CFFDebt repaymentsNegative
CFFDividendsNegative
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:

CheckFormulaExpected Result
Balance Sheet BalanceAssets - Liabilities - Equity= 0
Cash Tie-OutCF Ending Cash - BS Cash= 0
Cash Monthly vs AnnualClosing Cash (Monthly) - Closing Cash (Annual)= 0
Net Income LinkIS Net Income - CF Starting Net Income= 0
Retained EarningsPrior RE + NI + SBC - Dividends - BS Ending RE= 0
Equity FinancingΔCommon Stock/APIC (BS) - Equity Issuance (CFF)= 0
Year 0 EquityEquity 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.

ScenarioDescription
Base CaseManagement guidance or consensus estimates
Upside CaseAbove-guidance growth, margin expansion
Downside CaseBelow-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

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
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/kayforkind/skill-slice/3-statement-model/badge)](https://verified-skill.com/skills/kayforkind/skill-slice/3-statement-model)

Something wrong with this skill or its page? Tell us.