What problem does it solve? Building a fully-linked Income Statement, Balance Sheet, and Cash Flow model in Excel is error-prone: hardcoded values break when assumptions change, balance sheets fail to tie, and cash flow statements drift from the balance sheet. This Skill produces formula-driven .xlsx models where every projection, roll-forward, and linkage is a live Excel formula, with built-in audit checks that catch integrity failures. ## Core Features & Use Cases - Integrated Statement Construction: Populates IS, BS, and CF tabs plus working capital, D&A, debt, and NOL schedules with formula-only projections driven by an Assumptions tab. - Validation & Audit Framework: Enforces balance checks (Assets = L+E), cash tie-outs, retained earnings roll-forwards, scenario hierarchy checks, and a master pass/fail status. - Scenario & Credit Analysis: Supports Base/Upside/Downside toggles, margin analysis, and leverage/coverage credit metrics with threshold flagging. - Use Case: An analyst receives a blank 3-statement template and three years of 10-K data; the Skill maps the tabs, extracts historicals from SEC filings, builds five-year projections, and delivers a recalculated workbook where every check passes. ## Quick Start Build a 5-year 3-statement model for this company using the attached template and its latest 10-K filing, then show me the balance check for each period.
