Scribd Logo
Upload

Welcome to Scribd!

  • 39 views

    CFM Lbo Model

    Uploaded by

    Reus
    The document outlines the assumptions and projections for a transaction including: 1) Key assumptions around entry and exit multiples of 5x, sales growth of 10% annually, and EBITDA margin of 40%. 2) Projected financials over 5 years including sales, EBITDA, net income, and free cash flow. 3) Calculation of transaction value at $200 million, debt of $120 million at 10% rate, and equity value of $80 million. 4) Additional assumptions around a term loan with annual repayments and revolving credit facility.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    CFM Lbo Model

    Uploaded by

    Reus
    39 views3 pages
    The document outlines the assumptions and projections for a transaction including: 1) Key assumptions around entry and exit multiples of 5x, sales growth of 10% annually, and EBITDA margin of 40%. 2) Projected financials over 5 years including sales, EBITDA, net income, and free cash flow. 3) Calculation of transaction value at $200 million, debt of $120 million at 10% rate, and equity value of $80 million. 4) Additional assumptions around a term loan with annual repayments and revolving credit facility.

    Original Title

    Cfm Lbo Model

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines the assumptions and projections for a transaction including: 1) Key assumptions around entry and exit multiples of 5x, sales growth of 10% annually, and EBITDA margin of 40%. 2) Projected financials over 5 years including sales, EBITDA, net income, and free cash flow. 3) Calculation of transaction value at $200 million, debt of $120 million at 10% rate, and equity value of $80 million. 4) Additional assumptions around a term loan with annual repayments and revolving credit facility.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    39 views3 pages

    CFM Lbo Model

    Uploaded by

    Reus
    The document outlines the assumptions and projections for a transaction including: 1) Key assumptions around entry and exit multiples of 5x, sales growth of 10% annually, and EBITDA margin of 40%. 2) Projected financials over 5 years including sales, EBITDA, net income, and free cash flow. 3) Calculation of transaction value at $200 million, debt of $120 million at 10% rate, and equity value of $80 million. 4) Additional assumptions around a term loan with annual repayments and revolving credit facility.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    Transaction Assumptions

    Entry multiple 5 Exit multiple 5


    FTM EBITDA 40 FTM EBITDA 64.4204
    Transaction Value 200 322.102
    -120
    Rate 33.9459
    Debt 0.6 120 10% 236.0479
    Equity 0.4 80 IRR 0.241601
    MOIC 2.416009
    1 2 3 4 5 6
    Sales 100 110 121 133.1 146.41 161.051
    growth 0.1 0.1 0.1 0.1 0.1

    EBITDA 40 44 48.4 53.24 58.564 64.4204


    Margin 40% 40% 40% 40% 40% 40%

    D&A 20 20 20 20 20 20
    EBIT 20 24 28.4 33.24 38.564 44.4204
    Int Exp 12 12 12 12 12 12
    EBT 8 12 16.4 21.24 26.564 32.4204
    TAXES 0.4 3.2 4.8 6.56 8.496 10.6256 12.96816
    NI 4.8 7.2 9.84 12.744 15.9384 19.45224

    NI 4.8 7.2 9.84 12.744 15.9384 19.45224


    D&A 20 20 20 20 20 20
    W/C -5 -5 -5 -5 -5 -5
    CapEx 0.15 -15 -16.5 -18.15 -19.965 -21.9615 -24.15765
    FCF 4.8 5.7 6.69 7.779 8.9769 10.29459
    Total FCF 4.8 10.5 17.19 24.969 33.9459 44.24049
    LTM EBI 20
    Multiple 10
    EQITY 100 T 200

    10%
    Sales 100 110 120 130 140 150
    EBITDA 20% 20 22 24 26 28 30
    D&A 10% (10) (11) (12) (13) (14) (15)
    EBIT 10 11 12 13 14 15
    INTEREST 5% (10) (10) (10) (10) (10) (10)
    EBT 0 1 2 3 4 5
    TAX 40% 0 (0) (1) (1) (2) (2)
    NET INCOME 0 1 1 2 2 3

    Est. Projected
    FCFE: 2022 2023 2024 2025 2026 2027
    NET INCOME 0 1 1 2 2 3
    D&A 10 11 12 13 14 15
    CAPEX -5 -5 -5 -5 -5 -5
    W/C 0 0 0 0 0 0
    FCF 5 7 8 10 11 13
    TOTAL FCFE 49

    EXIT LTM EBITDA 30 IRR 0.148698


    EXIT Multiple 10 MOIC 1.486984
    TEV 300
    DEBT (100)
    CASH 0
    EXIT EQUITY LTM 200

    TERM LOAN
    BEGINNING BALA 200 193 185 175 164
    CASH SWEEP (7) (8) (10) (11) (13)
    ENDING BALANCE 193 185 175 164 151
    Revolver 200 Assumptions
    Bank debt Entry Multiple 10
    Equity 0 sales growth 10
    Total Sour 200 EBITDA Margin 20%

    You might also like