Navigation
Topline Model                Îê  
Supporting Calculations                                                  
Cashflow Waterfall Schedule
            Projected Fiscal Period Ending
(USD in 000s, except otherwise stated)         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 Mar.19
Beginning Cash Balance USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   23 845.7  106 646.3  199 414.5  301 947.7  414 052.4  535 543.3  666 243.4 
Required Minimum Cash Balance[1] USD 000s                              -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Cash From Operations USD 000s   (80 770.0) (59 165.5) (43 952.1) (28 928.2) (19 308.1) (8 631.2) 3 195.1  14 899.0  26 491.2  37 982.4  49 382.5  60 701.6  71 949.1  82 800.6  92 768.2  102 533.3  112 104.7  121 490.9  130 700.1  139 740.2 
Less: Dividend Payments USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Funds Available to Repay Debt USD 000s   (80 770.0) (59 165.5) (43 952.1) (28 928.2) (19 308.1) (8 631.2) 3 195.1  14 899.0  26 491.2  37 982.4  49 382.5  60 701.6  71 949.1  106 646.3  199 414.5  301 947.7  414 052.4  535 543.3  666 243.4  805 983.7 
Interest Income on Cash Balances 1.0% %  
Cash BoP USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   23 845.7  106 646.3  199 414.5  301 947.7  414 052.4  535 543.3  666 243.4 
Cash EoP USD 000s                    -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   23 845.7  106 646.3  199 414.5  301 947.7  414 052.4  535 543.3  666 243.4  805 983.7 
Interest Income USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   59.6  266.6  498.5  754.9  1 035.1  1 338.9  1 665.6 
Debt Funding (New Debt Financing)
Annual Cost of Facility 8.0% %  
Beginning Balance USD 000s                            -   80 770.0  139 935.5  183 887.6  212 815.8  232 123.9  240 755.1  237 560.0  222 661.1  196 169.8  158 187.5  108 805.0  48 103.4                           -                            -                            -                            -                            -                            -                            -  
Borrowings (Payments) USD 000s   80 770.0  59 165.5  43 952.1  28 928.2  19 308.1  8 631.2  (3 195.1) (14 899.0) (26 491.2) (37 982.4) (49 382.5) (60 701.6) (48 103.4)                          -                            -                            -                            -                            -                            -                            -  
Ending Balance USD 000s                    -   80 770.0  139 935.5  183 887.6  212 815.8  232 123.9  240 755.1  237 560.0  222 661.1  196 169.8  158 187.5  108 805.0  48 103.4                           -                            -                            -                            -                            -                            -                            -                            -  
Interest Expense USD 000s                            -   1 615.4  2 798.7  3 677.8  4 256.3  4 642.5  4 815.1  4 751.2  4 453.2  3 923.4  3 163.7  2 176.1  962.1                           -                            -                            -                            -                            -                            -                            -  
Tax Schedule
            Projected Fiscal Period Ending
(USD in 000s, except otherwise stated)         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 Mar.19
Taxable Income Calculation
EBT USD 000s   (22 900.0) (8 371.4) 5 511.9  19 242.1  32 834.2  46 197.7  59 371.1  72 393.9  85 279.4  98 040.6  110 690.3  123 240.6  135 703.5  147 673.2  158 539.9  169 155.2  179 530.2  189 675.3  199 600.8  209 316.5 
Manual Tax Adjustments 1 USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Manual Tax Adjustments 2 USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Total Taxable Income USD 000s   (22 900.0) (8 371.4) 5 511.9  19 242.1  32 834.2  46 197.7  59 371.1  72 393.9  85 279.4  98 040.6  110 690.3  123 240.6  135 703.5  147 673.2  158 539.9  169 155.2  179 530.2  189 675.3  199 600.8  209 316.5 
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   0.0  0.0  0.0  0.0  (5 263.4) (9 239.5) (11 874.2) (14 478.8) (17 055.9) (19 608.1) (22 138.1) (24 648.1) (27 140.7) (29 534.6) (31 708.0) (33 831.0) (35 906.0) (37 935.1) (39 920.2) (41 863.3)
Statutory Charge for the Period USD 000s   4 580.0  1 674.3  (1 102.4) (3 848.4) (6 566.8) (9 239.5) (11 874.2) (14 478.8) (17 055.9) (19 608.1) (22 138.1) (24 648.1) (27 140.7) (29 534.6) (31 708.0) (33 831.0) (35 906.0) (37 935.1) (39 920.2) (41 863.3)
Loss Carry Forward Calculation
Accumulated Tax Shield - BoP USD 000s                            -   4 580.0  6 254.3  5 151.9  1 303.5                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Tax Shield Created USD 000s   4 580.0  1 674.3                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Tax Shield Used USD 000s                            -                            -   (1 102.4) (3 848.4) (1 303.5)                          -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Accumulated Tax Shield - EoP USD 000s   4 580.0  6 254.3  5 151.9  1 303.5                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Working Capital Schedule
            Projected Fiscal Period Ending
(USD in 000s, except otherwise stated)         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 Mar.19
Revenue USD 000s   78 700.0  99 141.0  118 780.8  137 984.7  156 773.4  175 167.1  193 185.3  210 846.7  228 169.3  245 170.8  261 868.0  278 277.1  294 414.0  310 293.8  325 931.1  341 340.3  356 535.1  371 528.7  386 334.0  400 963.4 
Net Working Capital, % Revenue 10.0%
Net Working Capital USD 000s   7 870.0  9 914.1  11 878.1  13 798.5  15 677.3  17 516.7  19 318.5  21 084.7  22 816.9  24 517.1  26 186.8  27 827.7  29 441.4  31 029.4  32 593.1  34 134.0  35 653.5  37 152.9  38 633.4  40 096.3 
CapEx and Depreciation Schedule
            Projected Fiscal Period Ending
(USD in 000s, except otherwise stated)         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 Mar.19
CapEx Input Depreciation Rate Insert Capex Programme As Negative
New Investments 10.00  Years   USD 000s   (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0) (50 000.0)
Depreciation USD 000s   Remaining Life
Existing Long Term Assets                   -   7.50  Years   USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
New Investments  Quarters   Date:      Amount 
1  Jun.14 50 000.0  USD 000s                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
2  Sep.14 50 000.0  USD 000s                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
3  Dec.14 50 000.0  USD 000s                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
4  Mar.15 50 000.0  USD 000s                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
5  Jun.15 50 000.0  USD 000s                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
6  Sep.15 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
7  Dec.15 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
8  Mar.16 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
9  Jun.16 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
10  Sep.16 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
11  Dec.16 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
12  Mar.17 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
13  Jun.17 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
14  Sep.17 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
15  Dec.17 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0  1 250.0 
16  Mar.18 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0  1 250.0 
17  Jun.18 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0  1 250.0 
18  Sep.18 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0  1 250.0 
19  Dec.18 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   1 250.0 
20  Mar.19 50 000.0  USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Total Depreciation for Long Term Assets       USD 000s                            -   1 250.0  2 500.0  3 750.0  5 000.0  6 250.0  7 500.0  8 750.0  10 000.0  11 250.0  12 500.0  13 750.0  15 000.0  16 250.0  17 500.0  18 750.0  20 000.0  21 250.0  22 500.0  23 750.0 
  >> End of Sheet                                                  
[1]
FinRobot:
Insert as negative, this would dissallow repaying revolving debt from minimum cash balance