Latest / ModeLoop: Financial Modelling in Excel

AI in LBO and M&A model work: sponsor returns versus EPS | P3E20
Fictional teaching cases: keep sponsor cash returns separate from buyer earnings per share. All transaction figures are in millions of pounds unless stated otherwise.Reconcile enterprise value to seller equity, sources to uses and sponsor cash flows. Entry enterprise value is £80m; sources and uses are £90m. Assumed five-year exit equity is £74m at 8x or £62m at 7x. Debt paydown is an explicit assumption, not demonstrated by a complete operating forecast here.A separate merger case keeps earnings and share counts distinct: £2 EPS is initially neutral, then falls to £1.875 with an assumed…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.