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.


  • Rate this Downloadable Best Practice

    Write a review

  • Jim Thoresen(last updated: 07/05/2021 17:07)
  • Antonio Sedino(last updated: 14/01/2021 21:42)
  • Brando Hayden(last updated: 14/05/2019 14:06)
  • Mohd. Faizal Mohd. Zaki(last updated: 18/01/2019 08:36)
  • Antoine Duboscq(last updated: 07/11/2016 16:00)
    The Most Complete & Easy-to-use
    Great work John, thanks for sharing! 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 formated, making it easy for us to insert each section in our deliverables. Wholeheartedly recommend it to all PE pros!

People using this Best Practice also downloaded


Discussion feed for All In One Private Equity Model

The user community and author are here to help. Go ahead!

  • Viktor Desovski
    team, i am curious if there is a case study or tutorial that works with this model. is the model specific for US market or can you apply the australian market.
    1arrow_drop_uparrow_drop_downReply reply
    • Tim Demoures
      Hi Viktor,

      There is no tutorial yet indeed. But good idea! We'll suggest John to build one. Also, he told me he has purchases from all over the world, so should work also fine for the Australian Market.

      Hope that helps and that the model will be useful for you :)


      PS: Don't hesitate to Private Message John here if you have further questions:
      arrow_drop_uparrow_drop_downReply reply

    5.0 / 5 (5 votes)

    please wait...