Private Equity (PE) Returns - Excel Model Template
Originally published: 26/06/2019 14:50
Last version published: 04/02/2020 14:57
Publication number: ELQ-25982-2
View all versions & Certificate

Private Equity (PE) Returns - Excel Model Template

This is WSO's Private Equity (PE) Returns model including various IRR parameters

This Private Equity (PE) Returns model is a free excel template. It is a “plug-and-play” template for building your own private equity model that includes various Internal Rate of Return (IRR) parameters. You can use this model to analyse the returns on Private Equity investment of a particular company.

Private Equity is another form of private financing, separate to public markets, in which funds and investors directly invest in companies or engage in buyouts of these companies. Private equity funding can have different forms, from leveraged buyouts to venture capital.

Internal Rate of Return or IRR is a financial metric used to discount capital budgeting and to make the net present value of all future cash flows equal to zero. This is why it is used together with a Discounted Cash Flow (DCF) analysis. IRR estimates the rate of return that an investment will provide. A greater IRR normally means the investment is more profitable.

This template includes the following tabs for financial modelling:
- PE Returns Analysis
- WACC Calculation
- Assumptions
- Income Statement
- Balance Sheet
- Cash Flow Statement
- PPE Schedule
- Debt Schedule
- LBO Modelling
- FCFE Valuation

If you have any questions about this template, feel free to reach out to us by starting a discussion below or via direct message here on Eloquens.

Like this model? Leave us a review or a rating to show your appreciation!

This Best Practice includes
1 Private Equity Returns Excel model

Wall Street Oasis offers you this Best Practice for free!

download for free

Add to bookmarks


4.9 / 5 (30 votes)

please wait...