what’s included
Each section below is its own reference file. Open a heading to read it.
Valuation
read →unlevered FCF discounted at WACC, dual terminal value
Trading comps
relative value off public-peer multiples
Precedent transactions
past-deal multiples and control premia
Dividend discount model
value a dividend payer off its dividend stream
Sum-of-the-parts
value each segment on its own method, bridge to equity
Football field
every method's low–high range as one floating-bar chart
Deal & banking
read →integrated IS/BS/CF that balances
LBO
entry debt, cash sweep, exit, sponsor IRR & MOIC
Debt schedule
multi-tranche paydown with a cash-sweep waterfall
Accretion / dilution
pro-forma EPS, mix, synergies, breakeven
Sources & uses
funding table with a balancing equity plug
Credit stats & covenants
leverage/coverage with pass/fail headroom
PE & returns
read →return of capital, preferred, catch-up, carry
Value-creation bridge
split returns into EBITDA, multiple, deleveraging
Management incentive plan
sweet equity, preferred stack, ratchet
Fund (J-curve)
calls, fees, NAV, DPI/RVPI/TVPI, net IRR
IRR / MOIC
returns engine on any dated cash-flow stream
Dividend recap
size debt to a target, fund a dividend, IRR impact
Strategy & market
read →TAM/SAM/SOM top-down and bottom-up, triangulated
Revenue build
driver-based forecast with a customer roll-forward
Unit economics
CAC, LTV, payback from a cohort grid
Pricing
price-volume elasticity to the contribution peak
Analysis & decision
read →one- and two-variable data tables on any output
auditable Base/Bull/Bear toggle
Monte Carlo
distribution of outcomes, no add-in
Build engine
shared conventions, named ranges, recalc-and-verify