Financial Services.

Every deal leaves a paper trail. Graphon answers from your models, calls, filings, memos and more.

deal team asks

Show me ABC Bank’s LBO analyses: the deal, the target IRR and the leverage.

One answer, pulled from the LBO tab of three deal models, the target’s earnings call and the investment committee memo.

answered from 5 of 4,300 workbooks, memos and calls

1 · Harbor model.xlsx2 · Atlas model.xlsx3 · Kestrel model.xlsx4 · Clearwater Q3 earnings call5 · IC memo

Project Harbor, Northfield Packaging: 10.5x entry, 5.25x leverage, a 22% target IRR. Project Atlas, Meridian Dental Group: 12.0x entry, 6.0x leverage, 19%. Project Kestrel, Clearwater Software: 14.5x entry, 4.5x leverage, 25%.

On Clearwater’s Q3 call, the CFO guided to roughly 30% EBITDA margin next year, above the 27% the Kestrel model assumes, so its 25% IRR has room to spare.

Against the investment committee’s 20% hurdle and 6.0x cap, two of the three clear the hurdle and all three stay within the cap; Atlas is the one to take back to committee.

the deal library · 4,300 workbooks, memos and calls
XHarbor model.xlsx
B7fx22%
ABC
1
2Northfield Packaging · LBO
3$ in millionsBase
4
5Entry EV / EBITDA10.5x
6Total leverage / EBITDA5.25x
7Target IRR22%
8MOIC · 5 years2.6x
InputsS&UDebtLBOReturns+96sheet 25 of 104
1 Harbor model.xlsxopening 104 tabs…
XAtlas model.xlsx
B6fx6.0x
ABC
1
2Meridian Dental Group · LBO
3$ in millionsBase
4
5Entry EV / EBITDA12.0x
6Total leverage / EBITDA6.0x
7Target IRR19%
8MOIC · 5 years2.4x
InputsS&UDebtLBOReturns+80sheet 31 of 88
2 Atlas model.xlsxopening 88 tabs…
XKestrel model.xlsx
B7fx25%
ABC
1
2Clearwater Software · LBO
3$ in millionsBase
4
5Entry EV / EBITDA14.5x
6Total leverage / EBITDA4.5x
7Target IRR25%
8MOIC · 5 years3.0x
InputsS&UDebtLBOReturns+88sheet 18 of 96
3 Kestrel model.xlsxopening 96 tabs…
CLEARWATER · Q3 CALL · AUDIO
CFO: Next year we expect EBITDA margin of roughly 30%.
00:00 / 57:00
CC
4 Clearwater Q3 calllistening…

Investment committee memo · ABC Bank

Underwriting guidelines

New platform deals are underwritten to a five-year hold.

Target IRR of at least 20%; total leverage no higher than 6.0x EBITDA.

Exceptions return to committee.

5 IC memoreading…

Three models, one view.

1 · 2 · 3 · 4 · LBO tabs and the call
Northfield22%Meridian19%Clearwater25%hurdle · 20% IRRNorthfield5.25xMeridian6.0xClearwater4.5xcap · 6.0x EBITDAKestrel model27%CFO on the call~30%Clearwater · EBITDA margin next year

LBO tab of each deal model, and the Q3 call, read side by side

What the CFO said 4 · 28:14

CLEARWATER · Q3 CALL · AUDIO
CFO: Next year we expect EBITDA margin of roughly 30%.
28:14 / 57:00
CC

Clearwater Software · Q3 earnings call · 28:14 · CFO, outlook

Transcript

What the committee asks for 4

IC memo · underwriting guidelines

New platform deals are underwritten to a five-year hold. The target IRR must be at least 20%, and total leverage no higher than 6.0x EBITDA. Exceptions return to committee with the sponsor’s case.

Atlas misses the hurdle by a point at the cap, so it goes back to committee.

Memory that persists.