The Private Equity Acquisition Model provides a business valuation of a target company for investment. The Private Equity Acquisition Model allows for multiple payment scenarios and Entry/Exit Multiple while analyzing a target business for acquisition. Included in the template, you will find:
• The Income Statement, Balance Sheet, and Cash Flow Statement
• An Assumptions Section with key drivers for the target company
• Supporting Schedules Section for PPE and Working Capital
• Deal Assumptions section highlighting payment structure, Entry/Exit Multiples, Terminal Value, and Purchase Price
• Levered and Unlevered Free Cash Flows using Discounted Cash Flows and Leveraged Buyout, respectively
• IRR Sensitivity Analysis using Entry/Exit multiples and Purchase Price
First is the Assumptions section, where Assumptions are entered in the cells for the projection periods. All assumptions can be modified to fit specific key drivers of the business to see their impact on the Private Equity Model. Up to 5 years of historical data can be entered into the income statement, balance sheet, and cash flow statement; the following projected years are driven by formulas from the Assumptions section. The Supporting Schedules section consists of all formulas that are tied to the Assumptions and 3 Statement sections so no editing is necessary.
The Valuation & Returns section consists of a separate set of assumptions pertaining to the Timing of Payments, Terminal Value, and Other Assumptions to drive the valuation along with projected Unlevered Free Cash Flow. There is a Returns Analysis that will give you Net Present Value, IRR, and Cash on Cash multiple based on the DCF Valuation. The levered returns follow a Leveraged Buyout (LBO) structure where the terms of the loan can be input to determine the IRR and Cash on Cash multiple of the Levered Free Cash Flow. Lastly, the Sensitivity Analysis measures the impact of the Entry/Exit Multiple and Purchase on the IRR of the acquisition.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model. Sections are grouped to condense the model to view sections individually.
Similar Products
Other customers were also interested in...
Leveraged Buyout (LBO) Model Template
The Leveraged Buyout (LBO) Model provides a business valuation of a target company for investment. T... Read more
Mergers & Acquisitions (M&A) Model
The Mergers & Acquisition (M&A) Model provides a projection for a company looking to potentially... Read more
Basic Founder’s Package – Business Valuati...
To help you get a discount out of buying multiple financial model templates for business valuation, ... Read more
Basic Founder’s Package – Financial Foreca...
This is a bundle of financial model templates best suited for financial forecasting and for startups... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
3 Statement Financial Modeling with DCF & Rel...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Private Equity Fund Financial Model & Economic...
Introducing our Comprehensive Excel Financial Model Template, a versatile and robust tool designed t... Read more
You must log in to submit a review.