Equity Ventures MBO What is your company worth? Project: MBO 22   Date: Time:  
         
DEAL         PROFIT & LOSS A/C       CASHFLOW      
Price/value: Valuation now     Yr 1 Yr 2 Yr 3     Yr 1 Yr 2 Yr 3  
Add: debt Existing borrowings   Year end: 2023 2024 2025     2023 2024 2025  
Deal costs Estimate     Sales          
TOTAL MBO Funds required             EBITDA  
        EBITDA   OtherP&L  
Funded:   Base Variation   Depreciation   Capex (-)  
Shares:   Equity Equity   Other P&L   Stocks  
Ords-Mgt   Int:O/D   Debtors  
Ords-VC   Int: Bank   Creditors  
All Ords   Int: VC   Other Cr.  
Prefs-VC       PBT   Tax paid  
VC loan       Tax   Cash  
Bank loan       Pref Div VC   Int:O/D  
Overdraft       Ord Div  VC   Int:term  
TOTAL       Profit ret   Bank  
                Free Cash  
RATES Yr 1 Yr 2 Yr 3   RATIOS 2023 2024 2025   Int: VC  
  2023 2024 2025   Sales growth   Divs: Pref  
Bank/OD   EBITDA %    Divs: Ords  
VC int   EBITDA cover   NetFlow  
Pref div   Cash cover  
Tax rate   Debtor days   Copyright 2022: Equity Ventures Limited  
 
Call Equity Ventures  0207 859 4106     Web: www.equityventures.co.uk  
      Email: David.Tallboys@equityventures.co.uk  
 
DEAL and EXIT RATIOS     BALANCE SHEETS         Yr 1 Yr 2 Yr 3  
Last 12 months sales pre-deal     Before Deal Pro-forma MBO 2023 2024 2025  
Last 12 m  EBITDA pre-deal   F.Assets 0   F.Assets  
Last 12m EBITDA %     Stock 0   Stock  
Deal total (price + debt + fees)   Debtors 0   Debtors  
Deal PE (deal total/EBITDA )   Trade Crs 0   Creditors  
Deal PE (based Yr 1 EBITDA)   Other Crs 0   Other  
Bank risk/EBITDA     Tax due 0   Tax due  
Bank risk to Yr1 EBITDA   NTA 0   NTA  
Exit PE (Yr 3 EBITDA)     Goodwill 0 0   Goodwill  
NTA less net debt - pre-deal   Total 0   Total  
VC cash multiple            
Management multiple on exit   Ord Shares 0   Ord Shares  
VC multiple  (var)     P/L a/c 0 0 0   P/L a/c  
Management multiple (var)   Pref shares 0   Pref shares  
  VC loan 0   VC loan  
  Bank loan 0   Bank loan  
EXIT VALUATION OF SHARES ON EXIT   Overdraft 0   O/D/(cash)  
        Total 0   Total  
                  roundings  
Exit at end of year 3 Base Variation  
EBITDA (year 3)   VC CASHFLOW & IRR       Year: 2023 2024 2025  
Exit multiple of EBITDA     Ordinary Shares        
Value of company     Ordinary dividends   0  
Less:Bank loan     Preference Shares          
Net (O/D)/Cash     VC loan              
Less: VC loan repaid     Pref dividends    
Value of equity     Prefs redeemed x    
Less: Prefs-VC     Loan interest    
Value of Ords     VC loan repaid x    
Management's ords     Ords value on exit          
VC's ords value   Base case IRR & cash flow    
Value of Ords   Variation IRR & cash flow    
 
What to do: replace the blue variables with figures for the company you are looking at.  
Press calculate. Note changes.  
This is only indicative:  call Equity Ventures for help with a real deal.       David.Tallboys@equityventures.co.uk  
Contact: Equity Ventures.0207 859 4106   www.equityventures.co.uk  

Powered By SpreadsheetConverter