Football Field Case Study - LBO Summary

• 03:11
• EV, IRR, LBO, LTM EBITDA, MATCH, OFFSET

How to use the offset and match functions in Excel to calculate the acquisition multiple for a leveraged buyout (LBO) model that will give a certain internal rate of return (IRR) range. How to use the LTM EBITDA and the acquisition multiple to derive the implied enterprise value and the valuation range for the target company.