Base Case 1 Downside Case 2 Upside Case 3: Inputs
Base Case 1 Downside Case 2 Upside Case 3: Inputs
Base Case 1 Downside Case 2 Upside Case 3: Inputs
Base Case 1
Downside case 2
Upside case 3
Inputs
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
5.0% 6.0% 7.0% 8.0% 10.0% 8.0% 6.0% 4.0% 3.0% 1.0%
5.0% 6.0% 7.0% 8.0% 10.0% 8.0% 6.0% 4.0% 3.0% 1.0%
2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0%
6.0% 7.0% 8.0% 9.0% 11.0% 9.0% 7.0% 5.0% 4.0% 2.0%
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
4.0% 5.0% 6.0% 7.0% 8.0% 7.0% 6.0% 5.0% 3.0% 1.0%
4.0% 5.0% 6.0% 7.0% 8.0% 7.0% 6.0% 5.0% 3.0% 1.0%
2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0%
5.0% 6.0% 7.0% 8.0% 9.0% 8.0% 7.0% 6.0% 4.0% 2.0%
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
4.5% 5.0% 5.5% 6.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0%
4.5% 5.0% 5.5% 6.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0%
2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0%
5.5% 6.0% 6.5% 7.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0%
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
10.0% 11.0% 12.0% 14.0% 15.0% 12.0% 8.0% 5.0% 3.0% 1.0%
10.0% 11.0% 12.0% 14.0% 15.0% 12.0% 8.0% 5.0% 3.0% 1.0%
5.0% 4.0% 3.0% 2.0% 2.0% 2.0% 2.0% 2.0% 1.0% 1.0%
11.0% 12.0% 13.0% 15.0% 16.0% 13.0% 9.0% 6.0% 4.0% 2.0%
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0%
71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0% 71.0%
72.0% 72.0% 72.0% 72.0% 72.0% 72.0% 72.0% 72.0% 72.0% 72.0%
70.0% 70.0% 70.0% 70.0% 70.0% 70.0% 70.0% 70.0% 70.0% 70.0%
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%
3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%
3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5%
2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5%
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0%
12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0% 12.0%
12.5% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5% 12.5%
11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5%
2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
2.0% 2.0% 2.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0% 1.0%
2.0% 2.0% 2.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0% 1.0%
1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0%
3.0% 3.0% 3.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0% 1.0%
Income Statement
Taxes -- -- -- --
99.2
10%
30%
-- -- -- -- -- -- -- -- --
492.0 501.9
86% 86%
4% 2%
258.6 263.8
53% 53%
4% 2%
48.9 49.4
3% 1%
5.3 5.3
1.0% 1.0%
122.3 124.7
25% 25%
4% 2%
185.1 186.9
3% 1%
0.7 0.7
1.0% 1.0%
111.2 113.4
23% 23%
3% 2%
56.1 56.7
2% 1%
2.0 2.0
1.0% 1.0%
79.5 81.1
14% 14%
4% 2%
6.0 6.1
3% 1%
13.2 13.3
1.0% 1.0%
(17.1) (17.5)
3% 3%
554.4 565.6
4% 2%
(405.8) (414.0)
71% 71%
148.6 151.6
27% 27%
(16.6) (17.0)
3% 3%
(66.5) (67.9)
12% 12%
65.4 66.8
12% 12%
(5.3) (5.5)
1% 1%
92% 95%
(5.7) (5.8)
1% 1%
70.7 72.3
13% 13%
-- --
65.4 66.8
12% 12%
-- --
65.4 66.8
12% 12%
Balance Sheet
Assets
Liabilities
Current Liabilities
Accounts Payables 42.5 52.1 68.4 69.4
Current Ratio
Industry Average - GCC 3.0
Assumed Current Ratio of Company 3.0
Assumed Current Assets 127.6
Balance Cash 68.0
-- -- --
65.4 66.8
-- --
5.3 5.5
2.6 1.4
(1.1) (0.6)
5.3 2.9
(1.6) (0.9)
-- --
-- --
73.3 73.7
(5.7) (5.8)
(5.7) (5.8)
-- --
-- --
67.6 67.9
85.5 153.1
153.1 221.0
PPE Schedule
Interest Rate 6%
Taxes -- -- -- -- -- --
WACC 11%
PGR 2%
PV of CF 296.2
EV 569.4
Net Debt 235.0
Minority Interest --
Equity Value 334.4
-- -- -- --
2.0%
2.5%
3.0%
LBO Modelling
($m)
LTM EBITDA (2011A) 39
EBITDA FY+1 (2012) 40
Assumed Valuation (FY+1 EV/EBITDA) 12.0x
Assumed Leverage Level (LTM EBITDA) 6.0x
LBO Net Debt (Total) 235
Senior Debt 4.5x 176 5.5% 7 years
Sub Debt 1.5x 59 7.5% 8 years
Enterprise Value 475
Equity Value in BS 240
51%
(YE 31-Dec, USDm) 2012E 2013E 2014E 2015E
Less:
Interest Payments (12.9) (12.9) (12.9) (12.9)
Repayments -- -- -- --
Cash utilised to make repayments
Senior Debt
1.0 2.0 3.0 4.0
(YE 31-Dec, USDm) 2012E 2013E 2014E 2015E
Opening Balance 176.2 176.2 176.2 176.2
(+) Additions
(-) Repayment -- -- -- --
Closing Balance 176.2 176.2 176.2 176.2
Interest Rate 6%
Subordinated Debt
1.0 2.0 3.0 4.0
(YE 31-Dec, USDm) 2012E 2013E 2014E 2015E
Opening Balance 58.7 58.7 58.7 58.7
(+) Additions
(-) Repayment -- -- -- --
Closing Balance 58.7 58.7 58.7 58.7
Interest Rate 8%
10
4
6.0% Average Cost of debt
-- -- (176.2)
176.2 176.2 -- -- -- --
-- -- -- (58.7)
58.7 58.7 58.7 -- -- --
COE 15%
PGR 2%
PV of CF 159.6
Sensitivity Table
WACC
543 13% 14%
1.0%
1.5%
PGR
2.0%
2.5%
3.0%
Sensitivity Table
WACC
15% 16% 17%
Juice Co.
IRR Returns Analysis
Returns in 5 years
Entry Multiple (FY1 EBITDA) 12.0x
EBITDA FY1 39.6x
EXIT Multiple (5 years) 12.0x
EBITDA FY1 (EXIT) 59.8
Enterprise Value (EXIT) $m 717.3
Less: Net Debt 78.0
Equity Value (EXIT) $m 639.3
IRR 22%
1 2 3 4
2011A 2012E 2013E 2014E 2015E
Total Cashflows
Discounted FCF -- -- -- --
IRR 22%
639.3
639.3
5
2016E 2017E 2018E 2019E 2020E 2021E
639.3
0.4
240.8 -- -- -- -- --
Debt 40.0%
Equity 60.0%
WACC 11.4%