NEW HERE? USE "AFORUM20" TO GET GET 20 % OFF CLAIM OFFER

UK: +44 748 007-0908 USA: +1 917 810-5386
My Orders
Register
Order Now

Enterprise Value Analysis

  LBO Quick Model € in Millions Sources € Purchase Information Returns 2021 Excess Cash € 496.2 2020 EBITDA € 216.8 2026 EBITDA Revolver – Purchase Multiple 17.0x Exit Multiple 17.0x Term Loan 1,600.0 Enterprise Value € 3,685.6 Enterprise Value Sponsor Equity 2,135.6 Less: Debt (247.3) Less: Debt Total Sources € 4,231.8 Plus: Cash 496.2 Plus: Cash Entry Equity Value € 3,934.5 Exit Equity Value Uses Refinance Existing Debt € 247.3 Purchase Existing Equity 3,934.5 Transaction Expenses 50.0 Financing Fees – Total Uses € 4,231.8 Return 12/31/2020 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2025 12/31/2026 Cash Flow IRR MOIC IRR Sensitivity Entry EBITDA Multiple 15.0x 16.0x 17.0x 18.0x 19.0x 20.0x 15.0x 16.0x Exit 17.0x EBITDA 18.0x Multiple 19.0x 20.0x MOIC Sensitivity Entry EBITDA Multiple 15.0x 16.0x 17.0x 18.0x 19.0x 20.0x 15.0x 16.0x Exit 17.0x EBITDA 18.0x Multiple 19.0x 20.0x INCOME STATEMENT 2020 2020 2021 2022 2023 2024 2025 Sales € 2,000.0 € 1,600.0 € 1,360.0 € 1,292.0 € 1,292.0 € 1,421.2 € 1,705.4 % Growth (20.0%) (15.0%) (5.0%) – 10.0% 20.0% COGS (1,000.0) (800.0) (680.0) (646.0) (646.0) (710.6) (852.7) Gross Margin € 1,000.0 € 800.0 € 680.0 € 646.0 € 646.0 € 710.6 € 852.7 % Margin 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% Selling expenses (200.0) (200.0) (200.0) (200.0) (200.0) (200.0) (200.0) R&D (200.0) (200.0) (200.0) (200.0) (200.0) (200.0) (200.0) G&A (200.0) (200.0) (200.0) (200.0) (200.0) (200.0) (200.0) Operating Profit € 400.0 € 200.0 € 80.0 € 46.0 € 46.0 € 110.6 € 252.7 % Margin 20.0% 12.5% 5.9% 3.6% 3.6% 7.8% 14.8% Interest Expense Pre-tax Profit Taxes Net Income Operating Profit D&A 50.0 50.0 50.0 50.0 50.0 50.0 EBITDA % Margin Taxes 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% BALANCE SHEET 2020 Uses Sources Close PF BS 2020 2021 2022 2023 2024 2025 Assets Cash and Equivalents € 496.2 A/R 297.8 Inventory 310.6 Prepaid & Other 87.1 Total Current Assets € 1,191.7 PP&E € 259.0 Intangibles 423.0 Goodwill – Total Assets € 1,873.7 Liabilities A/P € 402.0 Advances received 72.5 Other liabilities and deferred income 290.6 Total Current Liabilities € 765.1 Revolver – Term Loan 247.3 Total Liabilities € 1,012.4 Total Equity 861.3 Total Liabilities + Equity € 1,873.7 Check – Working Capital Drivers A/R Days Inventory Days Prepaid & Other as % of Revenue A/P Days Advances received as % of Revenue Other liabilities and deferred income as % of Revenue CASH FLOW STATEMENT 2020 2021 2022 2023 2024 2025 Net Income Depreciation Decrease / (Increase) in A/R Decrease / (Increase) in Inventory Decrease / (Increase) in Prepaid & Other Increase / (Decrease) in A/P Increase / (Decrease) in advances received Increase / (Decrease) in other liabilities and deferred income Cash Flow from Operating Activities Capital Expenditures (50.0) (50.0) (50.0) (50.0) (50.0) (50.0) Cash Flow from Investing Activities Issuance / (Repayments) of Outstanding Debt Cash Flow from Financing Activities Beginning Cash Balance Net Change in Cash Ending Cash Balance DEBT SCHEDULE 2020 2021 2022 2023 2024 2025 Beginning Cash Balance Minimum Cash Balance 100.0 (100.0) (100.0) (100.0) (100.0) (100.0) (100.0) Cash Flow before Financing Activities Cash Flow Available for Revolver Paydown Revolver Beginning Balance Issuance / (Paydown) Ending Balance Average Balance Interest Expense 4.00% Cash Flow Available for Term Loan Paydown Term Loan Beginning Balance Issuance / (Paydown) Ending Balance Average Balance Interest Expense 4.00% Net Issuance / (Paydown of Debt) Total Interest Expense