Private Equity Valuation and IRR Algorithm
DOI:
https://doi.org/10.33423/jaf.v24i2.6981Keywords:
accounting, finance, private equity, valuation, carried interest, IRR, EBITDA multipleAbstract
An algorithm is developed that calculates the IRR for various private equity entities within a private equity leveraged transaction. The algorithm calculates the total anticipated value for a transaction and then produces the associated IRRs based on the exit EBITDA, the EBITDA multiple, and the available cash. The benefits of the algorithm are that multiple programming formats become available, insights emerge that are difficult to perceive using an equivalent spreadsheet pro forma analysis, and other types of analyses become possible for examining individual parameters.
References
Alexander, M., Kusleika, R., & Walkenbach, J. (2019). Excel 2019 Bible: The Comprehensive Tutorial Resource. Indianapolis, IN: John Wiley and Sons Inc.
Ang, A., Chen, B., Goetzmann, W., & Phalippou, L. (2018). Estimating private equity returns from limited partner cash flows. The Journal of Finance, 73(4), 1751–1783.
Arnold, T., & James, J. (2000). Finding firm value without a pro forma analysis. Financial Analysts Journal, 56(2), 77–84.
Arnold, T., & James, J. (2003, Winter). Finding firm value quickly with an analysis of debt. Journal of Financial Education, 29, 65–82.
Arnold, T., & North, D. (2009). Programming a firm value calculator on your PDA. The Investment Professional, 2(3), 30–31.
Arnold, T., & North, D. (2011). Firm valuation with long-run business cycles. The Journal of Private Equity, 14(3), 86–95.
Block, J., Fisch, C., Vismara, S., & Andres, R. (2019). Private equity investment criteria: An experimental analysis of venture capital, business angels, and family offices. Journal of Corporate Finance, 58, 329–352.
Harrison, R., Bock, A., & Gregson, G. (2020). Stairway to heaven? Rethinking angel investment policy and practice. Journal of Business Venturing Insights, 14, 1–10.
Ivashina, V., & Lerner, J. (2019). Pay now or pay later? The economics within the private equity partnership. Journal of Financial Economics, 131, 61–87.
McFedries, P. (2019). Microsoft Excel 2019 Formulas and Functions. New York, N.Y.: Pearson Education Inc.
Phalippou, L. (2020). An inconvenient fact: Private equity returns and the billionaire factory. The Journal of Investing, 30(1), 123–143.
Zeisberger, C., Prahl, M., & White, B. (2017). Mastering Private Equity. West Sussex, UK: John Wiley and Sons Limited.
