All-in-One Excel Model

26 integrated
worksheets.
One model.

A complete private equity analysis toolkit — three-statement model, LBO, DCF, comps, debt schedules, and more. Built in Excel for immediate use on real deals.

Instant download · Excel (.xlsx) · One-time payment

All.In.One.Model.xlsx
Company Name
Financial Summary
Base Case
B10
fx
=P&L!EBITDA*(1-Assump!tax_rate)
6
(Dollars in millions)
2016
2017
2018
2019
2020
7
Revenues
1,584.0
2,296.8
2,985.8
3,881.6
4,852.0
8
Gross Profit
1,188.0
1,722.6
2,239.4
2,911.2
3,639.0
10
EBITDA
712.8
1,033.6
1,343.6
1,746.7
2,183.4
11
Depreciation
(96.7)
(114.9)
(139.7)
(171.9)
(212.8)
12
EBIT
616.1
918.7
1,204.0
1,574.9
1,970.6
16
Net Income to Common
432.9
647.3
851.3
1,117.5
1,403.2
17
Diluted EPS
$2.50
$3.74
$4.92
$6.46
$8.11
Controls
Sum
LTM
P&L
BS
CFS
Assump
Depr
Amort
Debt
+16 more →
26
Integrated Worksheets
5
Valuation Methods
7
Debt Tranche Types
13
Projection Years
3
Scenarios
Used by professionals at
Citi
KPMG
Barclays
McKinsey & Company
Cisco
Sky
Rogers
ORIX
Guggenheim Partners
Northwestern University
New York University
University of Chicago
Private equity  ·  Investment banks  ·  Search funds  ·  Independent sponsors  ·  Corporate development
★★★★★
Financial models are really at the heart of M&A deals we run across here at our consultancy in Paris. Having this tool just makes it considerably faster and easier to run scenarios with our clients. Above all, it is professionally organized and formatted, making it easy for us to insert each section in our deliverables. Wholeheartedly recommend it to all PE pros!
AD
Antoine Duboscq
M&A Consultancy, Paris
Inside the Model

Everything you need on one deal

All 26 worksheets, organized by function. Click any category to explore.

Firm Value
Enterprise value bridge: EBITDA multiple → EV → less net debt, minority interest, preferred → equity value → implied share price.
Premium
Acquisition premium analysis: 52-week high/low range, consensus analyst price targets, and % premium to current share price.
DCF_10
10-year unlevered DCF: Net Income → +Interest → +D&A → −CapEx → Unlevered FCF, WACC, terminal EBITDA multiple, and dual 5×5 sensitivity tables (Firm Value + Equity Value).
DCF_5
5-year DCF with independent WACC assumption set. Shorter-horizon model suited for high-growth or cyclical businesses.
Comps
Public company trading comps: EV/EBITDA, EV/Revenue, EV/EBIT, P/E, and NTM multiples across a fully customizable peer set.
LBO
Full LBO model: 7-tranche sources & uses (Bank Debt, Sr. Sub, Discount Notes, PIK Preferred, Outside/Rollover Equity), EV bridge, transaction multiples (EV/EBITDA, EV/EBIT, EV/EBITDA−CapEx), and summary credit statistics.
EVA
Economic Value Added: NOPAT build-up (Net Income + After-tax Interest + Rent), ending invested capital rollforward (book equity + debt + capitalized rent), and EVA = NOPAT − (Avg. Capital × WACC) with per-share output.
See all 26 sheets →
Preview

Actual screenshots
from the model

See all 6 sheets →
All.In.One.Model.xlsxSum
Financial Summary worksheet preview
13-year dashboard — revenues, EBITDA, net income, EPS, and key credit ratios in one view.Full size ↗
Why It's Different

Not a template. A working model.

Complete 3-Statement Model

Fully integrated P&L, balance sheet, and cash flow statement across 13 projected years. Every line ties automatically. A 3-scenario toggle (Base / Upside / Downside) lets you stress-test assumptions without rebuilding the model.

Five Valuation Frameworks

DCF (5yr + 10yr with dual sensitivity tables), LBO returns, public comps, and firm value / acquisition premium — all linked to the same operating model. No re-entering numbers between analyses.

Institutional Debt Modeling

Seven debt tranches in the LBO (Bank Debt, Sr. Sub, Discount Notes, PIK Preferred), plus a standalone High Yield analysis with full PIK toggle — rare in off-the-shelf models and critical for buyout deal structuring.

Reviews
★★★★★5.0
5 reviews  ·  15,633+ views
★★★★★

The Most Complete & Easy-to-use

Financial models are really at the heart of M&A deals we run across here at our consultancy in Paris. Having this tool just makes it considerably faster and easier to run scenarios with our clients. Above all, it is professionally organized and formatted, making it easy for us to insert each section in our deliverables. Wholeheartedly recommend it to all PE pros!

AD
Antoine Duboscq
M&A Consultancy, Paris
★★★★★
Brando Hayden
Verified buyer
★★★★★
Jim Thoresen
Verified buyer
★★★★★
Mohd. Faizal Mohd. Zaki
Verified buyer
★★★★★
Antonio Sedino
Verified buyer
Pricing

One price.
Everything included.

No subscription, no upsells. Pay once, download immediately, use forever.

$297$397Launch Price
Free Tools

Run a quick analysis in your browser

Four institutional-grade calculators — LBO returns, DCF valuation, WACC, and debt capacity. No download required, no sign-up.

CALC
LBO Returns
CALC
DCF Valuation
CALC
WACC
CALC
Debt Capacity