Navigation
Iterate Interest?
Topline Model                Îê   No[1]
Financial Schedules                                                  
Income Statement Summary
          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
Revenues 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 
COGS USD 000s   (89 300.0) (91 307.3) (93 359.7) (95 458.5) (97 604.6) (99 799.1) (102 043.0) (104 337.6) (106 683.8) (109 083.0) (111 536.3) (114 044.9) (116 610.1) (119 233.1) (121 915.3) (124 658.0) (127 462.5) (130 330.3) (133 262.8) (136 261.4)
Gross Margin USD 000s   (10 600.0) 7 833.7  25 421.1  42 526.2  59 168.8  75 368.0  91 142.2  106 509.1  121 485.5  136 087.8  150 331.7  164 232.2  177 803.9  191 060.6  204 015.8  216 682.4  229 072.6  241 198.4  253 071.2  264 702.0 
-- gross margin, % %   (13.5%) 7.9% 21.4% 30.8% 37.7% 43.0% 47.2% 50.5% 53.2% 55.5% 57.4% 59.0% 60.4% 61.6% 62.6% 63.5% 64.2% 64.9% 65.5% 66.0%
CC & Overheads USD 000s   (12 300.0) (13 339.7) (14 610.5) (15 856.3) (17 078.3) (18 277.8) (19 456.0) (20 614.0) (21 752.9) (22 873.8) (23 977.7) (25 065.5) (26 138.3) (27 197.1) (28 242.5) (29 275.7) (30 297.3) (31 308.2) (32 309.3) (33 301.1)
EBITDA %   (22 900.0) (5 506.0) 10 810.6  26 669.9  42 090.5  57 090.2  71 686.2  85 895.1  99 732.6  113 214.0  126 354.0  139 166.7  151 665.5  163 863.6  175 773.3  187 406.7  198 775.3  209 890.2  220 762.0  231 400.9 
-- EBITDA margin, % USD 000s   (29.1%) (5.6%) 9.1% 19.3% 26.8% 32.6% 37.1% 40.7% 43.7% 46.2% 48.3% 50.0% 51.5% 52.8% 53.9% 54.9% 55.8% 56.5% 57.1% 57.7%
Depreciation & Amortization %                            -   (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)
EBIT USD 000s   (22 900.0) (6 756.0) 8 310.6  22 919.9  37 090.5  50 840.2  64 186.2  77 145.1  89 732.6  101 964.0  113 854.0  125 416.7  136 665.5  147 613.6  158 273.3  168 656.7  178 775.3  188 640.2  198 262.0  207 650.9 
-- EBIT margin, % %   (29.1%) (6.8%) 7.0% 16.6% 23.7% 29.0% 33.2% 36.6% 39.3% 41.6% 43.5% 45.1% 46.4% 47.6% 48.6% 49.4% 50.1% 50.8% 51.3% 51.8%
Interest Income USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   59.6  266.6  498.5  754.9  1 035.1  1 338.9  1 665.6 
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)                          -                            -                            -                            -                            -                            -                            -  
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 
Tax USD 000s                            -                            -                            -                            -   (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)
Net Exceptional Items & Adjustments USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Net Income USD 000s   (22 900.0) (8 371.4) 5 511.9  19 242.1  27 570.8  36 958.2  47 496.9  57 915.1  68 223.5  78 432.5  88 552.2  98 592.5  108 562.8  118 138.6  126 831.9  135 324.2  143 624.1  151 740.3  159 680.7  167 453.2 
Balance Sheet Statement Summary
            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
Long Term Assets USD 000s                     -   50 000.0  98 750.0  146 250.0  192 500.0  237 500.0  281 250.0  323 750.0  365 000.0  405 000.0  443 750.0  481 250.0  517 500.0  552 500.0  586 250.0  618 750.0  650 000.0  680 000.0  708 750.0  736 250.0  762 500.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 
Net Operating Assets USD 000s                     -   57 870.0  108 664.1  158 128.1  206 298.5  253 177.3  298 766.7  343 068.5  386 084.7  427 816.9  468 267.1  507 436.8  545 327.7  581 941.4  617 279.4  651 343.1  684 134.0  715 653.5  745 902.9  774 883.4  802 596.3 
- financed by
Cash 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 
Debt Funding 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)                          -                            -                            -                            -                            -                            -                            -                            -  
Net Debt 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) 23 845.7  106 646.3  199 414.5  301 947.7  414 052.4  535 543.3  666 243.4  805 983.7 
Net Assets USD 000s                     -   (22 900.0) (31 271.4) (25 759.5) (6 517.4) 21 053.4  58 011.6  105 508.5  163 423.6  231 647.1  310 079.6  398 631.8  497 224.3  605 787.1  723 925.6  850 757.6  986 081.8  1 129 705.9  1 281 446.1  1 441 126.8  1 608 580.0 
Equity & Reserves USD 000s                     -   (22 900.0) (31 271.4) (25 759.5) (6 517.4) 21 053.4  58 011.6  105 508.5  163 423.6  231 647.1  310 079.6  398 631.8  497 224.3  605 787.1  723 925.6  850 757.6  986 081.8  1 129 705.9  1 281 446.1  1 441 126.8  1 608 580.0 
              Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê                         Îê  
Cash Flow Statement Summary
                                                   
(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
EBITDA USD 000s   (22 900.0) (5 506.0) 10 810.6  26 669.9  42 090.5  57 090.2  71 686.2  85 895.1  99 732.6  113 214.0  126 354.0  139 166.7  151 665.5  163 863.6  175 773.3  187 406.7  198 775.3  209 890.2  220 762.0  231 400.9 
Cash Interest Income USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   59.6  266.6  498.5  754.9  1 035.1  1 338.9  1 665.6 
Cash 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)                          -                            -                            -                            -                            -                            -                            -  
Cash Tax USD 000s                            -                            -                            -                            -   (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)
Net Change in WC USD 000s   (7 870.0) (2 044.1) (1 964.0) (1 920.4) (1 878.9) (1 839.4) (1 801.8) (1 766.1) (1 732.3) (1 700.1) (1 669.7) (1 640.9) (1 613.7) (1 588.0) (1 563.7) (1 540.9) (1 519.5) (1 499.4) (1 480.5) (1 462.9)
Operating Cash Flow before Investments USD 000s   (30 770.0) (9 165.5) 6 047.9  21 071.8  30 691.9  41 368.8  53 195.1  64 899.0  76 491.2  87 982.4  99 382.5  110 701.6  121 949.1  132 800.6  142 768.2  152 533.3  162 104.7  171 490.9  180 700.1  189 740.2 
CAPEX 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)
Extraordinary Cash Items USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Change in Cash before Financing 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 
Financed by
  Equity Issue / (Buy Back or Dividend) USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
  Debt Issue / (Retirement) 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)                          -                            -                            -                            -                            -                            -                            -  
Total Financing 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)                          -                            -                            -                            -                            -                            -                            -  
Change in Cash for the Period USD 000s                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   23 845.7  82 800.6  92 768.2  102 533.3  112 104.7  121 490.9  130 700.1  139 740.2 
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 
  >> End of Sheet                                                  
[1]
FinRobot:
If the toggle is set on Yes, then Excel calculation options would need to have iterations option turned on