|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Case Builder Model |
Îê |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Funding and Tax
Calculations - Base Case |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debt Schedule |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Year Ending |
|
(in USD 000s, except otherwise stated) |
|
|
|
|
Dec-13 |
Mar-14 |
Jun-14 |
Sep-14 |
Dec-14 |
Mar-15 |
Jun-15 |
Sep-15 |
Dec-15 |
Mar-16 |
Jun-16 |
Sep-16 |
Dec-16 |
Mar-17 |
Jun-17 |
Sep-17 |
Dec-17 |
Mar-18 |
Jun-18 |
Sep-18 |
Dec-18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Cash Balance |
|
USD 000s |
|
|
|
1 000.0 |
- |
- |
- |
- |
- |
2 543.0 |
4 324.5 |
9 372.9 |
11 654.6 |
17 130.5 |
18 790.5 |
4 637.4 |
6 651.6 |
12 856.0 |
13 536.7 |
18 407.7 |
19 469.2 |
24 224.4 |
24 676.2 |
|
Required Minimum Cash Balance[1] |
|
USD 000s |
|
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Cash From Operations |
|
USD 000s |
|
|
|
(1
081.2) |
3 623.3 |
1 203.2 |
4 907.6 |
2 692.0 |
6 198.2 |
3 531.5 |
6 798.4 |
4 031.6 |
7 226.0 |
3 410.0 |
(12
403.1) |
3 764.2 |
7 954.4 |
2 430.7 |
6 620.9 |
2 811.5 |
6 505.2 |
2 201.8 |
6 402.0 |
|
Less: Net. contractual borrowing |
|
USD 000s |
|
|
|
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
750.0) |
(1
250.0) |
|
Less: Dividend Payments |
|
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Funds Available to Repay Debt |
|
USD 000s |
|
|
|
(1
081.2) |
2 623.3 |
203.2 |
3 907.6 |
1 692.0 |
5 198.2 |
4 324.5 |
9 372.9 |
11 654.6 |
17 130.5 |
18 790.5 |
4 637.4 |
6 651.6 |
12 856.0 |
13 536.7 |
18 407.7 |
19 469.2 |
24 224.4 |
24 676.2 |
29 828.1 |
|
Interest Income on Cash Balances |
1.0% |
% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash BoP |
|
USD 000s |
|
|
|
1 000.0 |
- |
- |
- |
- |
- |
2 543.0 |
4 324.5 |
9 372.9 |
11 654.6 |
17 130.5 |
18 790.5 |
4 637.4 |
6 651.6 |
12 856.0 |
13 536.7 |
18 407.7 |
19 469.2 |
24 224.4 |
24 676.2 |
|
Cash EoP |
|
USD 000s |
|
|
1 000.0 |
- |
- |
- |
- |
- |
2 543.0 |
4 324.5 |
9 372.9 |
11 654.6 |
17 130.5 |
18 790.5 |
4 637.4 |
6 651.6 |
12 856.0 |
13 536.7 |
18 407.7 |
19 469.2 |
24 224.4 |
24 676.2 |
29 828.1 |
|
Cash Interest Income |
|
USD 000s |
|
|
|
2.5 |
- |
- |
- |
- |
- |
6.4 |
10.8 |
23.4 |
29.1 |
42.8 |
47.0 |
11.6 |
16.6 |
32.1 |
33.8 |
46.0 |
48.7 |
60.6 |
61.7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Short Term Revolver (New Debt Financing) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Cost of Facility |
8.0% |
% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Balance |
|
USD 000s |
|
|
|
10 000.0 |
11 081.2 |
8 458.0 |
8 254.8 |
4 347.2 |
2 655.1 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Borrowings (Payments) |
|
USD 000s |
|
|
|
1 081.2 |
(2
623.3) |
(203.2)
|
(3
907.6) |
(1
692.0) |
(2
655.1) |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Ending Balance |
|
USD 000s |
|
|
10 000.0 |
11 081.2 |
8 458.0 |
8 254.8 |
4 347.2 |
2 655.1 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Cash Interest Expense |
|
USD 000s |
|
|
|
200.0 |
221.6 |
169.2 |
165.1 |
86.9 |
53.1 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Available for Bank Debt |
|
USD 000s |
|
|
|
- |
- |
- |
- |
- |
2 543.0 |
4 324.5 |
9 372.9 |
11 654.6 |
17 130.5 |
18 790.5 |
4 637.4 |
6 651.6 |
12 856.0 |
13 536.7 |
18 407.7 |
19 469.2 |
24 224.4 |
24 676.2 |
29 828.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bank Debt Tranche A |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Cost of Facility |
6.0% |
% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Balance |
|
USD 000s |
|
|
|
20 000.0 |
19 000.0 |
18 000.0 |
17 000.0 |
16 000.0 |
15 000.0 |
14 000.0 |
13 000.0 |
12 000.0 |
11 000.0 |
10 000.0 |
9 000.0 |
8 000.0 |
7 000.0 |
6 000.0 |
5 000.0 |
4 000.0 |
3 000.0 |
2 000.0 |
1 000.0 |
|
Mandatory (Repayment) |
|
USD 000s |
|
|
|
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
(1
000.0) |
|
Discretionary Borrowings / (Repayment) |
|
USD 000s |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ending Balance |
|
USD 000s |
|
|
20 000.0 |
19 000.0 |
18 000.0 |
17 000.0 |
16 000.0 |
15 000.0 |
14 000.0 |
13 000.0 |
12 000.0 |
11 000.0 |
10 000.0 |
9 000.0 |
8 000.0 |
7 000.0 |
6 000.0 |
5 000.0 |
4 000.0 |
3 000.0 |
2 000.0 |
1 000.0 |
- |
|
Cash Interest Expense |
|
USD 000s |
|
|
|
300.0 |
285.0 |
270.0 |
255.0 |
240.0 |
225.0 |
210.0 |
195.0 |
180.0 |
165.0 |
150.0 |
135.0 |
120.0 |
105.0 |
90.0 |
75.0 |
60.0 |
45.0 |
30.0 |
15.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bank Debt Tranche B |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Cost of Facility |
5.0% |
% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Balance |
|
USD 000s |
|
|
|
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
9 250.0 |
8 500.0 |
7 750.0 |
7 000.0 |
6 250.0 |
5 500.0 |
4 750.0 |
4 000.0 |
3 250.0 |
2 500.0 |
1 750.0 |
1 000.0 |
250.0 |
|
Mandatory (Repayment) |
|
USD 000s |
|
|
|
|
|
|
|
|
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(750.0)
|
(250.0)
|
|
Discretionary Borrowings / (Repayment) |
|
USD 000s |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ending Balance |
|
USD 000s |
|
|
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
10 000.0 |
9 250.0 |
8 500.0 |
7 750.0 |
7 000.0 |
6 250.0 |
5 500.0 |
4 750.0 |
4 000.0 |
3 250.0 |
2 500.0 |
1 750.0 |
1 000.0 |
250.0 |
- |
|
Cash Interest Expense |
|
USD 000s |
|
|
|
125.0 |
125.0 |
125.0 |
125.0 |
125.0 |
125.0 |
125.0 |
115.6 |
106.3 |
96.9 |
87.5 |
78.1 |
68.8 |
59.4 |
50.0 |
40.6 |
31.3 |
21.9 |
12.5 |
3.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bank Debt Tranche C |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Annual Cost of Facility |
7.0% |
% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Balance |
|
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Mandatory (Repayment) |
|
USD 000s |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Discretionary Borrowings / (Repayment) |
|
USD 000s |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ending Balance |
|
USD 000s |
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Cash Interest Expense |
|
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tax Schedule |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected
Fiscal Year Ending |
|
(in USD 000s, except otherwise stated) |
|
|
|
|
Dec-13 |
Mar-14 |
Jun-14 |
Sep-14 |
Dec-14 |
Mar-15 |
Jun-15 |
Sep-15 |
Dec-15 |
Mar-16 |
Jun-16 |
Sep-16 |
Dec-16 |
Mar-17 |
Jun-17 |
Sep-17 |
Dec-17 |
Mar-18 |
Jun-18 |
Sep-18 |
Dec-18 |
|
Taxable Income Calculation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EBT |
|
USD 000s |
|
|
|
6.1 |
(164.0)
|
583.0 |
1 254.0 |
2 008.5 |
2 181.5 |
2 360.5 |
2 429.0 |
2 481.2 |
2 457.4 |
2 464.6 |
2 417.4 |
2 278.8 |
2 235.7 |
10 822.6 |
10 779.5 |
10 795.0 |
10 756.2 |
10 756.9 |
10 695.0 |
|
Manual Tax Adjustments 1 |
|
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Manual Tax Adjustments 2 |
|
USD 000s |
|
|
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Total Taxable Income |
|
USD 000s |
|
|
|
6.1 |
(164.0)
|
583.0 |
1 254.0 |
2 008.5 |
2 181.5 |
2 360.5 |
2 429.0 |
2 481.2 |
2 457.4 |
2 464.6 |
2 417.4 |
2 278.8 |
2 235.7 |
10 822.6 |
10 779.5 |
10 795.0 |
10 756.2 |
10 756.9 |
10 695.0 |
|
Income Tax Rate |
|
% |
|
|
|
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
20.0% |
|
Income Taxes - Actual Cash Payments |
|
USD 000s |
|
|
|
(1.2) |
0.0 |
(83.8) |
(250.8) |
(401.7) |
(436.3) |
(472.1) |
(485.8) |
(496.2) |
(491.5) |
(492.9) |
(483.5) |
(455.8) |
(447.1) |
(2 164.5) |
(2 155.9) |
(2 159.0) |
(2 151.2) |
(2 151.4) |
(2 139.0) |
|
Total Tax for Income Statement |
|
USD 000s |
|
|
|
(1.2) |
32.8 |
(116.6) |
(250.8) |
(401.7) |
(436.3) |
(472.1) |
(485.8) |
(496.2) |
(491.5) |
(492.9) |
(483.5) |
(455.8) |
(447.1) |
(2 164.5) |
(2 155.9) |
(2 159.0) |
(2 151.2) |
(2 151.4) |
(2 139.0) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Loss Carry Forward Calculation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accumulated Tax Shield - BoP |
|
USD 000s |
|
|
|
- |
- |
32.8 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Tax Shield Created |
|
USD 000s |
|
|
|
- |
32.8 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Tax Shield Used |
|
USD 000s |
|
|
|
- |
- |
(32.8)
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Accumulated Tax Shield - EoP |
|
USD 000s |
|
|
- |
- |
32.8 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|