Office Arcade
← Levels

LBO Lab · Level 8: Rollover and the MIP

Time 0:00 / 12:00 targetHints 0Base 1400 pts
Blue: typed inputBlack: formulaGreen: link to another sheet
ABCDEFGHIJKL
1Sources & uses, exit and returns ($m)
2
3Sources & uses at close
4Enterprise value (entry multiple x LTM EBITDA)985.6
5Transaction fees19.7
6Minimum cash funded
7Total uses1,015.3
8Senior debt313.6
9Sub / mezzanine debt134.4
10Total equity (balancing figure)567.3
11Total sources1,015.3
12Total debt / LTM EBITDA at close5.00x
13
14Exit at end of Year 5
15Year 5 EBITDA
16Exit enterprise value1,577.5
17less: net debt at exit
18Exit equity value1,389.2
19less: management incentive pool (% of gain)82.2
20Equity value to shareholders after MIP1,307.0
21
22Sponsor returns
23YearYear 0Year 1Year 2Year 3Year 4Year 5
24Sponsor equity invested (after management rollover)453.8
25Management rollover equity113.5
26Sponsor exit proceeds1,045.6
27Sponsor cash flows(453.8)0.0 0.0 0.0 0.0 1,045.6
28Sponsor IRR18.2%
29Sponsor MOIC2.30x
30Total equity MOIC (before MIP)2.45x
31Total equity IRR (before MIP)19.6%
32
33Covenant summary (Years 1-5)
34Peak net debt / EBITDA4.12x
35Lowest EBITDA / cash interest3.07x
36Covenant statusPASS
37
38
TextReady
Personal practice tool · all companies and numbers are fictional · runs entirely in your browser