All in One Private Equity Model

Used by Investment Professionals at Private Equity and IB Firms

dcfevafinancefinancial statementsinvestment bankinglboprivate equityvaluation

Description
-> 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 business tool includes
1 Excel File (25 tabs)

Acquire business licence for $180.00

Add to cart

Ask a question

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)
Valuation

Knowledge of excel and valuation is helpful.

Reviews

  • WMI Consulting(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!

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
    • Timothée Demoures
      Hi Viktor,

      John just told me that unfortunately there is no tutorial as it was built for folks that are versed in financial modeling. However, 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 :)

      Cheers
      Tim

      PS: Don't hesitate to Private Message John here if you have further questions:
      https://www.eloquens.com/profile/john-swan
      arrow_drop_uparrow_drop_downReply reply
    please wait...