Corp Dev LBO returns question: Levered and Unlevered IRR

Working on my first LBO case study for a Corp Dev/M&A role. Firm has sent me a CIM and asked me to prepare 10yr Base Case projections to stress test: 1) Purchase Price, 2) EBITDA CAGR, 3) Exit Multiple, 4) Leverage.

In showing the above sensitivity tables, they are looking for the resulting Levered IRR and Unlevered IRR as the ultimate factor to evaluate.

Below is my first attempt to showcase Lev/Unlev FCF (and calculated IRR). Wanted to make sure I wasn't missing anything as my sensitivity tables are looking weird and it's being driven by my Lev/Unlev FCF calculations. As a reference, within 10yrs I assume the amortizing senior debt will be repaid (5y term) and dividends will start to be paid out of FCF to keep minimum cash balance.

Can someone confirm that my tired brain isn't missing something?

Career Resources

+30	What's Next?	PE	6	8h
+28	To all associates coming up on the 2 year mark, how bad is it to have no deals done?	PE	7	2d
+27	Easiest way to make about $2mm/y	PE	19	15h
+26	VP Level - when to follow up after final round	PE	10	20h
+22	What happens if you go for on-cycle and don’t land an offer?	PE	24	7h
+17	Vista Lateral Associate	PE	4	9h
+16	IB/PE Lifers, Was It Worth It?	PE	5	5h
+14	EBITDA walkdown to cash flow for debt service	PE	10	4d
+14	What do you hate the most about second round diligence?	PE	9	4d
+13	Why is Blackstone so dominant?	PE	9	2d

1	redever	99.2
2	Secyh62	99.0
3	BankonBanking	99.0
4	Betsy Massar	99.0
5	GameTheory	98.9
6	CompBanker	98.9
7	kanon	98.9
8	dosk17	98.9
9	Jamoldo	98.8
10	DrApeman	98.8

Corp Dev LBO returns question: Levered and Unlevered IRR

Trending Content