financial-model-building

Builds auditable three-statement financial models with driver-based forecasts, scenarios, and validation checks.

Updated Jun 21, 2026
One-click install
npx skills add https://github.com/lwokeray/cowork-plugins --skill financial-model-building-lwokeray
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: financial-model-building
Source: https://github.com/lwokeray/cowork-plugins/tree/main/plugins/finance-cowork/skills/financial-model-building
Command: npx skills add https://github.com/lwokeray/cowork-plugins --skill financial-model-building-lwokeray

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Building or extending integrated financial models often results in hardcoded outputs, broken formulas, unexplained plugs, and workbooks that no other analyst can audit or update. This Skill enforces a disciplined architecture so models remain traceable, formula-consistent, and verifiable from sources through outputs. ## Core Features & Use Cases - Three-Statement Model Construction: Links Income Statement, Balance Sheet, and Cash Flow with roll-forward schedules for debt, equity, working capital, capex, and depreciation. - Existing Workbook Extension: Inspects formulas, named ranges, external links, and hidden structures before making minimal, non-destructive changes such as extending forecast periods or adding downside scenarios. - Built-in Model Checks: Validates A=L+E balance, cash flow tie-outs, roll-forwards, formula errors, and unexplained plugs, reporting a clear MODEL STATUS: PASS/FAIL. - Use Case: A user provides historical financial statements and asks for a five-year three-statement model with base and downside scenarios; the Skill builds driver-based schedules, scenario tables, a checks sheet, and a version log. ## Quick Start Ask the assistant to turn your historical financial statements into a five-year three-statement model with scenario and sensitivity schedules and a checks sheet.

Frequently Asked Questions about financial-model-building

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a three-statement financial model from historical statements?▼

Provide the historical income statement, balance sheet, and cash flow with fiscal periods, currency, and forecast horizon. The Skill ties historical data to sources, builds driver-based forecast schedules, links the three statements, and adds checks confirming A=L+E and cash flow tie-outs.

How to extend an existing Excel financial model to more forecast years?▼

The Skill first inspects existing formulas, named ranges, external links, and the actual/forecast boundary, then extends date headers and copy-across formulas with minimal changes. It updates debt, cash, working capital, and checks schedules, then saves a new version with a change summary.

When should I not use this financial modeling approach?▼

Do not use it for budget collection workflows, standalone DCF valuations, or simple ratio and trend analysis, which belong to separate skills. It also refuses to fabricate bottom-up models without historical, driver, or policy data.

Why does my balance sheet balance but cash is a plug?▼

A cash plug indicates missing three-statement logic where cash flow is not derived from income statement and balance sheet movements. The Skill flags this as a failed check and rebuilds the schedules so ending cash ties to the balance sheet.

Can the model handle circular references from cash sweeps and revolvers?▼

Yes, but the Skill prefers iterative schedules or helper logic to avoid circularity. If circular references are retained, the iteration settings and a corresponding check are documented so another analyst can audit the behavior.

What checks validate a financial model before delivery?▼

Required checks include historical statement tie-outs, A=L+E balance, cash flow to ending cash, retained earnings and debt roll-forwards, formula error scans, and detection of unexplained plugs. A checks sheet reports Actual, Expected, Difference, and a PASS/FAIL model status.