Return calculations Subordinated loan with EBITDA participation
Grey cells contain hard inputs. Other cells contain references
1 Determine structure
A Fill in loan amount/tranches and expected disbursement/repayment dates
B Determine interest. Fixed during period or dependent on EBITDA or Net profit?
C EBITDA from financial model company to determine exit value with EBITDA multiple
If other exit multiple is used, this should be adapted
D Calculation enterprise value using EBITDA multiple. Use realistic exit multiple, in line with market multiples and entry multiple
E Enterprise value calculation EBITDA multiple * EBITDA
F Equity value calculation deducting net debt (LT debt minus cash) from enterprise value
In addition to DEMF debt, other debt should be deducted as well, if existing
G Fill in number of warrants/equity received (i.e. less than 5% has tax effects)
H Fill in expected exit date
I Calculation of the return received by selling warrants at exit date
2 Calculate blended return DEMF investment
Total cash flow to DEMF consists of four elements: A Loan disbursment/cash outflow
B Interest received (also account for accruals or bullet payment)
C Exit value warrants/equity
D Repayment of loan
E Sum of all cash flows
F Calculation internal rate of return of DEMF investment
3 For comparison, check what return to other investors is
Risk/return profile should be balanced and in line with DEMF's return A Calculation share other investors after warrant
B Return calculation other shareholders
year 0 year 1 year 2 year 3 year 4 year 5 year 6 year 7 year 8
1. 12/31/2006 12/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012 12/31/2013 12/31/2014 12/31/2015
Outstanding loan amount 1,250 3,750 3,750 3,250 2,750 2,250 1,750 1,250 1,250
A Drawdown/DEMF disbursment -1,250 -2,500 500 500 500 500 500
B Base interest 12.50% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5%
Base interest payment 156 469 469 406 344 281 219 156 156
EBITDA related margin 0% 0% 3% 3% 7% 7% 9% 9%
Additional interest 0 0 98 83 158 123 113 113
C EBITDA 36 417 2,068 2,107 4,213 4,195 5,174 5,103
D EBITDA multiple 7
E EV 252 2,919 14,476 14,749 29,491 29,365 36,218 35,721
Net DEMF debt 3,750 3,750 3,250 2,750 2,250 1,750 1,250 1,250
Net other LT debt company 8,000 7,000 6,000 4,000 3,500 3,500 3,500 3,500
F Equity value 100% -11,498 -7,831 5,226 7,999 23,741 24,115 31,468 30,971
G Equity share 12.0%
H Exit date 12/31/2012
J Return equity on exit 0 0 0 0 2,849 0 0 0
2. Total CF DEMF 12/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012 12/31/2013 12/31/2014 12/31/2015
A Debt amount -1,250 -2,500 0 500 500 0 0 0 0
B Interest 156 468.75 468.75 406.25 343.75 281.25 0 0 0
EBITDA interest 0 0 0 98 83 158 0 113 113
C Equity -1,000 0 0 0 0 2,849 0 0 0
D Repayment debt 0 0 0 0 0 2,750 0 0 0 0
CF -2,094 -2,031 469 1,004 926 6,038 0 113 113
IRR equity 23%
Total IRR DEMF 20.4%
3. Total CF shareholders 12/31/2006 12/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012 12/31/2013 12/31/2014 12/31/2015
A Share shareholders 38.0%
Investment shareholders -1200
Return equity stake 0 0 20,892 0 0 0
Total CF shareholders -1,200 0 0 0 0 20,892 0 0 0
B IRR Shareholders 77.1%
EBITDA related margin
EBITDA treshold (max) Margin
2000 0%
3000 3%
4000 5%
5000 7%
6000 9%
7000 11%