Complete Private Equity Model

Complete financial model for valuing, forecasting, and acquiring companies in the form of private equity investments.

by Spencer Dobson
Private Equity ProfessionalFollow 94

47 reviews2,755 views|Start the discussion!|Bookmark Add to cart - $50.00

Description
This detailed private equity model runs a comprehensive leveraged buyout analysis - accompanied by a multitude of additional tools, including:
- a three-statement model (income statement, cash flow statement, and balance sheet)
- different cases available to run a wide variety of potential scenarios
- various valuation tools (discounted cash flow, comparable companies, and precedent transactions)
- output charts to visualize the deal (interest coverage, profitability growth, value creation bridge, and more)

Highlights:
- All changes needed to be made are grouped together on the 'Assumptions' sheet, making this tool incredibly straightforward and easy to use.
- Returns are calculated for practically any hold period (up to 10 years) to show different lengths of time for the investment.
- The debt schedule allows you to optionally include up to four types of debt (revolver, term loan A, term loan B, mezzanine debt), which enhances this model's usefulness and ability to analysis a wide variety of deals.
- The summary sheet allows the entire model to be digested and understood briefly on a single page.
- The sensitivity tables and output charts allow investors to see the potential investment outcomes in a visually engaging way.

This model was built by a private equity professional to ensure its usefulness and ability to help investors evaluate businesses and companies effectively, and in the end make high-quality investment decisions.

This Best Practice includes
1 Excel File