Finance AI Toolkit — 25 Excel Models: DCF, LBO, DDM, SOTP, Cohort LTV + AI Prompts

Description
A complete library of 25 financial models built to Wall-Street modeling conventions, each paired with a pre-tested AI prompt that auto-populates with your inputs.


VALUATION: Full 5-year DCF with terminal sensitivity, LBO with sources/uses + debt schedule + returns waterfall, two-stage DDM, sum-of-the-parts with conglomerate discount, comparable companies with applied multiples.


ANALYSIS: 14-ratio DuPont decomposition from raw financials, scenario analyzer with decision tree and VaR, sensitivity interpreter with cliff detection, Monte Carlo reader with histogram, variance commentary with FY forecast roll. 


FP&A: 13-week direct cash flow with covenant flag, hiring plan with monthly burn ramp, pricing change with quarterly ARR build, runway with 24-month cash trajectory, unit economics with 36-month cohort LTV. 


REPORTING: Earnings summary with 4-quarter momentum, board deck with RAG scorecards, investor update with rolling 12-month metrics, KPI auditor with 3-axis scoring, earnings call tone reader with QoQ hedge-word counts.


MARKETS: Futures curve analyzer, COT positioning tracker with 52-week percentiles, inventory tracker, hedging scenarios with P&L grid, daily trading plan with expectancy. 


Modeling conventions: blue inputs, green links, black formulas, check rows, gold-accent verdicts. 2,853 formulas across 25 templates. Tested for Claude Sonnet 4.6, Opus 4.7, and GPT-5.