Office Arcade
← Levels

LBO Lab · Level 2: What a cash sweep is worth

Time 0:00 / 7:00 targetHints 0Base 700 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)675.0
5Transaction fees13.5
6Minimum cash funded
7Total uses698.5
8Senior debt337.5
9Sub / mezzanine debt0.0
10Total equity (balancing figure)361.0
11Total sources698.5
12Total debt / LTM EBITDA at close4.50x
13
14Exit at end of Year 5
15Year 5 EBITDA
16Exit enterprise value993.6
17less: net debt at exit
18Exit equity value888.2
19less: management incentive pool (% of gain)0.0
20Equity value to shareholders after MIP888.2
21
22Sponsor returns
23YearYear 0Year 1Year 2Year 3Year 4Year 5
24Sponsor equity invested (after management rollover)361.0
25Management rollover equity0.0
26Sponsor exit proceeds888.2
27Sponsor cash flows(361.0)0.0 0.0 0.0 0.0 888.2
28Sponsor IRR19.7%
29Sponsor MOIC2.46x
30Total equity MOIC (before MIP)2.46x
31Total equity IRR (before MIP)19.7%
32
33Covenant summary (Years 1-5)
34Peak net debt / EBITDA3.66x
35Lowest EBITDA / cash interest2.83x
36Covenant statusPASS
37
38
TextReady
Personal practice tool · all companies and numbers are fictional · runs entirely in your browser