BTHE BARATELLI INSTITUTE · Mentoring at Scale
The Baratelli Financial Modeling Toolkit — 26 Excel tabs, 60-page methodology PDF, 900+ live formulas, $99 introductory pricing
PRACTITIONER TOOLKIT · NEW · JULY 2026

The Baratelli Financial Modeling Toolkit

Built by CPAs, MBAs, and career practitioners. · Philip A. Baratelli, CPA, MBA · Baratelli Institute · Edition 1

Wall Street–standard templates for practitioners. Twenty-six rigorously formatted Excel tabs — DCF, LBO, Merger (accretion / dilution), Trading Comps, Precedent Transactions, Football Field, WACC, SOTP, Dividend Recap, Roll-Up, Take-Private, Distressed, Fund Waterfall, Return Attribution, Sensitivity, and a full 6-tab integrated 3-statement model — plus a 60-page methodology PDF explaining each model's use, line-by-line walkthrough, common pitfalls, and Practitioner Tips in every chapter: senior-partner-to-analyst voice teaching what to do with the model's output, not just how to build it. Every tab: color-coded to Wall Street convention, print-ready page setup, freeze panes, headers and footers, check figures in red, key outputs shaded gold.

Print-ready formatting. Compatible with Excel, Google Sheets, and Numbers.

17model templates
26Excel tabs
60page methodology PDF
900+live formulas
$99Buy on Gumroad → See what's inside on Gumroad →
$99 USD — Also available in your local currency at Gumroad checkout.
Regional pricing: $99 USD (US, Canada, Australia) · £79 GBP (UK) · €89 EUR (EU) · $99 USD equivalent (emerging markets pending review) — payment auto-converts via Gumroad.

What's included

Every tab in the workbook follows the industry-standard color-coding convention — blue for inputs, black for calculations, green for cross-sheet links, red for check figures, gold-shaded for key outputs. Every tab is print-ready: landscape page setup on wide tables, print areas explicitly set, print titles that repeat headers on every printed page, freeze panes so labels stay visible while scrolling, and headers and footers with page numbering and Baratelli brand strip.

Section 1 · Valuation Core

Tab 05
DCF
10-year projection, unlevered FCF, WACC discounting, terminal value both methods, WACC × g sensitivity, bridge to per-share equity value.
Tab 06
Trading Comps
Peer set with EV/Rev, EV/EBITDA, P/E, gross margin. Statistics block (min / 25th / median / mean / 75th / max). Implied valuation at peer median.
Tab 07
Precedent Transactions
Historical deal comps with target, acquirer, announce date, deal value, LTM EBITDA, EV/EBITDA, premium %, structure. Statistics summary.
Tab 08
Football Field
Aggregate valuation ranges across 52-week range, trading comps (EV/EBITDA and EV/Revenue), precedents, DCF, and LBO. Overlap zone diagnostic.
Tab 09
WACC Calculator
CAPM cost of equity, after-tax cost of debt, market-value weighting. Sensitivity table: beta × ERP. Methodology notes for every input.

Section 2 · Transaction Models

Tab 10
Standard LBO
Sources & uses, 5-tranche debt schedule (revolver, TLB, second lien, mezz, HY), 5-year operating build, exit & returns, entry × exit sensitivity.
Tab 11
Merger Model
Acquirer + target standalone, deal financing (cash / stock mix), pro-forma combined financials, EPS accretion / dilution, breakeven synergies.
Tab 12
Dividend Recap
Pre-recap capital structure, target leverage sizing, post-recap financials, DPI impact, sponsor returns bridge. Belron-anchored.
Tab 13
Roll-Up / Platform
Platform financials, add-on acquisition cadence, cumulative revenue and EBITDA, synergy phasing, multiple arbitrage summary.
Tab 14
Sum-of-the-Parts
Segment-level build with independent multiples per segment, corporate overhead capitalized deduction, bridge to equity value. Comcast-anchored.
Tab 15
Take-Private
Public company baseline, buyout premium analysis, financing structure, 5-year returns. IRR and MOIC.
Tab 16
Distressed Turnaround
Pre-restructuring cap structure, reorg EV, scenario recoveries (Ch11 / Ch7 / out-of-court), fulcrum-security returns.

Section 3 · Return & Waterfall

Tab 17
Fund Waterfall (European)
European (whole-fund) waterfall: return of capital, preferred return (hurdle), GP catch-up, 80/20 split. LP net MOIC and IRR.
Tab 17b
Fund Waterfall (American)
American (deal-by-deal) waterfall: per-deal carry mechanics across a 5-deal illustrative fund. European vs. American comparison box quantifies the GP-favorable delta.
Tab 17b
Fund Waterfall (American)
American (deal-by-deal) waterfall: per-deal carry mechanics across a 5-deal illustrative fund. European vs. American comparison box quantifies the GP-favorable delta.
Tab 17b
Fund Waterfall (American)
American (deal-by-deal) waterfall: per-deal carry mechanics across a 5-deal illustrative fund. European vs. American comparison box quantifies the GP-favorable delta.
Tab 18
Return Attribution
MOIC decomposition into revenue growth, margin expansion, multiple expansion, deleveraging, and cash yield. Kaplan-Schoar multiplicative form.
Tab 19
Sensitivity & Scenarios
Two-way data tables for revenue growth × exit multiple, margin × hold period. Coherent downside / base / upside scenarios.

Plus front matter

Tab 01
Cover
Title page with edition, contact, and section index.
Tab 02
Table of Contents
Hyperlinked TOC to every tab. Section-organized.
Tab 03
Style Guide
Cell color code legend, number format reference, page setup conventions, model workflow guidance.
Tab 04
Sources & Methodology
Every convention grounded: Damodaran (NYU Stern), CFA Institute, ILPA, SEC EDGAR, Baratelli case studies.

And a 60-page methodology PDF

A companion methodology document that walks through each of the fifteen models: what the model is for, line-by-line walkthrough, when to use it and when not to, common pitfalls, and typical M&A interview questions the model answers. Includes case-study anchors to the Baratelli Institute Belron, Danaher, Comcast, LVMH, Samsung, and Penske / Berkshire case studies.

The Baratelli difference

Practitioner Tips — what to do with the results

Every methodology chapter closes with a Practitioner Tips callout — senior-partner-to-analyst voice, teaching what to do with the model's output, not just how to build it.

Any modeling book will teach you how to construct a DCF, an LBO, a merger model. Almost none teach you what happens next — what a senior MD asks in the review, which assumptions actually move the answer, how to communicate to a Board, when to trust the output and when to override it. That interpretation layer is the difference between an analyst who can build and a practitioner who can decide.

DCF

You got a share price of $X. Compare to market. Which assumptions move the answer most (typically WACC + terminal growth = 60-70% of DCF variability). When to trust it, when to override.

Standard LBO

You got 22% IRR. Compare to fund hurdle. What tuck-in acquisitions could improve the base case. Reverse-engineering seller's assumptions. How to use the sensitivity for negotiating purchase price.

Trading Comparables

You got EV/EBITDA = 8.5x median. Which peers are outliers and why. When to exclude a peer (recent M&A, distressed, different growth profile). How to justify inclusion/exclusion to a boss or committee.

Precedent Transactions

You got median control premium 25%. Contextualize by strategic vs financial buyer split. Which specific deals set the market vs. outliers. How to negotiate downward if seller cites a rich comp.

Merger Model

You got 5% accretion. Timing of synergy realization matters more than magnitude. How to explain to shareholders and the Board. Key sensitivities the Board will ask about.

Every model type

All 17 chapters — from DCF and LBO through 3-statement, Waterfall, SOTP, Distressed — carry a Practitioner Tips section. Interpretation, communication, senior-partner catches, common committee questions.

The Practitioner Tips are the feature that turns the Baratelli Toolkit from a template package into a decision-support reference. They're the reason to buy this over any collection of templates you could assemble yourself.

Who this toolkit is for

USE 1

Investment banking analysts

Prepping M&A models on live deals. The templates are the starting point — overwrite blue inputs, keep formulas intact.

USE 2

PE associates

Reviewing incoming CIMs and sizing bids. LBO template, waterfall, and return attribution templates cover the full deal-team workflow.

USE 3

Corporate development

Building acquisition cases for the board. Merger model handles accretion / dilution; SOTP handles multi-segment targets.

USE 4

Family office CFOs

Evaluating co-invest opportunities alongside sponsor decks. Sanity-check sponsor LBO returns and waterfall structure.

USE 5

MBA students

Supplementing valuation and M&A coursework with practitioner-grade templates. Case-anchored methodology maps to what recruiters ask.

USE 6

CFA candidates

Level II and III valuation, corporate finance, and alternative investments. The methodology PDF reinforces curriculum with worked models.

How the models are anchored

The methodology PDF references the Baratelli Institute's own case studies as worked examples. If you already own the case files, the templates plug directly into those models. If you don't, the case studies are freely available on the site.

Danaher — SOTP + DCF (21 tabs) Belron — Dividend Recap Comcast — SOTP LVMH — Holdco / Succession Samsung — Succession Structure Penske — Berkshire Take-Private

Related guides

The toolkit is a working set of templates. If you want the underlying practitioner narrative — the checklist for the LOI, the working-capital peg mechanics, the family-office coordination question — these guides carry the framework.

CFO & Controller's Guide — $349 Private Equity Guide — $349 Liquidity Event Playbook — $349 Business Buyer's Guide Business Operators' Blueprint Belron Recap Case Study WACC Reference Hub — free

Enterprise licensing

For firm-wide deployment, MBA cohorts, and analyst-training programs, the toolkit is available under three seat-based licenses. Every tier includes the full 26-tab workbook, the 60-page methodology PDF, and free updates to future editions.

Tier Seats Price Best for
Team 5 seats $2,500 Boutique advisory firms, MBA study groups, small deal teams
Department 15 seats $5,000 Mid-market investment banks, PE firms, corporate development departments
Enterprise 50+ seats $12,500 Bulge-bracket analyst training, MBA finance programs, global rollouts

For pricing on 100+ seats or global multi-region deployment, contact enterprise@baratelliinstitute.com or use the inquiry form below.

Enterprise inquiry

Roadmap: Video walkthroughs of each Excel tab are being produced for Edition 2 (planned 2027). A certification track is under evaluation for the same edition. Enterprise buyers can request pre-release access at the contact above.

Baratelli Financial Modeling Toolkit

$99 Single-user license · 26-tab Excel workbook + 60-page methodology PDF · Compatible with Excel, Google Sheets, Numbers
Buy on Gumroad → See what's inside on Gumroad →

About the author

PB

Philip A. Baratelli, CPA, MBA — Founder, Baratelli Institute. Ponte Vedra Beach, Florida.

Three decades in operating finance and M&A (CPA since 1995, MBA). Ran the Excel that these templates now formalize on live deals across public-company M&A, PE LBOs, family-office direct investing, and dividend recaps. The toolkit is the mentoring at scale — the coloring standard, the print setup, the sensitivity table, the check figures — that used to happen in person with an analyst next to the model.

Educational references and tools — not legal, tax, accounting, or investment advice, and not a recommendation to buy or sell any security. The Baratelli Institute operates under the Lowe v. SEC publisher exception (472 U.S. 181, 1985). Consult a qualified professional about your specific situation.