All in One Private Equity Model
Originally published: 27/10/2016 12:49
Last version published: 24/04/2018 11:48
Publication number: ELQ-80034-2
View all versions & Certificate

All in One Private Equity Model

Used by Investment Professionals at Private Equity and IB Firms

-> Run Advanced Leveraged Buyout Scenarios with Pro Forma Income Statement, Balance Sheet and Cash Flow
-> Estimate the High Yield Capacity your firm can carry
-> Run Additional Economic Value Add (EVA) analysis, made popular by McKinsey and Company
-> Run 5 and 10 Year Discounted Cash Flow Analysis on Separate Sheets
-> Run Premium Analysis Run Comparable Analysis
Compatible with Excel 2016
Much much more…

This Best Practice includes
1 Excel File (25 tabs)

Acquire business license for $180.00

Add to cart

Add to bookmarks


Further information

What is an Integrated Financial Model?

An Integrated Financial Model outputs a ten year P&L, Balance Sheet and Cash Flow forecast for a business. It takes into account growth and cost assumptions, working capital requirements and a firm’s capital structure in its analysis.

Private Equity and Investment Bankers do not build separate financial models for each deal. They rely on excel templates such as this one to run complex valuations, discounted cash flows and leveraged buyout scenarios that can be edited on the fly.

Professionally formatted to easily cut and paste key analysis into pitch books and presentation decks

DCF (Discounted Cash Flow)
LBO (Leveraged Buyout)

Knowledge of excel and valuation is helpful.

5.0 / 5 (5 votes)

please wait...