From grimoire
Constructs integrated three-statement financial models linking income, balance sheet, and cash flow. Useful for corporate finance, valuation, and scenario analysis.
How this skill is triggered — by the user, by Claude, or both
Slash command
/grimoire:write-financial-modelThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Construct an integrated three-statement financial model linking income statement, balance sheet, and cash flow statement.
Construct an integrated three-statement financial model linking income statement, balance sheet, and cash flow statement.
Adopted by: Investment banks (Goldman Sachs, JP Morgan), management consulting firms (McKinsey, Bain), corporate finance teams at Fortune 500 companies Impact: McKinsey "Valuation" research demonstrates that integrated three-statement models reduce forecasting errors by forcing accounting consistency; broken links between statements are the primary source of model errors in practice.
Why best: Three-statement integration ensures that every assumption flows consistently through all financial statements. A model where cash flow does not reconcile to the balance sheet is fundamentally unreliable. Sensitivity analysis built into the structure allows real-time scenario toggling without rebuilding the model.
SaaS company model: Revenue drivers = ARR × net revenue retention + new ARR bookings. Gross margin = 72% (stable). S&M = 40% of revenue declining to 30% over 5 years as CAC payback improves. R&D = 20% of revenue. G&A = 10% declining to 7%. EBITDA margin: year 1 = 2%, year 5 = 23%. D&A = 5% of revenue. CapEx = 3%. Working capital: DSO 45 days, DPO 30 days, no inventory.
Finance disclaimer: This skill encodes professional best practices for educational purposes. It is not financial advice. Consult a licensed financial advisor before making investment decisions.
npx claudepluginhub jeffreytse/grimoire --plugin grimoireCompletes and populates 3-statement financial model templates (Income Statement, Balance Sheet, Cash Flow Statement) in Excel using Office JS or Python/openpyxl with formula linkages and projections.
Builds 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.
Builds 3-5 year financial models for early-stage startups with cohort-based revenue projections, cost structures, cash flow analysis, headcount planning, and scenario analysis. Useful for strategy, fundraising, and operations.