Navigation
Base Model                Îê  
Funding and Tax Calculations                                                                                    
Debt Schedule
            Projected Fiscal Year Ending
(GBP in 000s , except otherwise stated)         Aug.14 Sep.14 Oct.14 Nov.14 Dec.14 Jan.15 Feb.15 Mar.15 Apr.15 May.15 Jun.15 Jul.15 Aug.15 Sep.15 Oct.15 Nov.15 Dec.15 Jan.16 Feb.16 Mar.16 Apr.16 May.16 Jun.16 Jul.16 Aug.16 Sep.16 Oct.16 Nov.16 Dec.16 Jan.17 Feb.17 Mar.17 Apr.17 May.17 Jun.17 Jul.17 Aug.17 Sep.17
Beginning Cash Balance GBP 000s  200.0                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   2 398.8  8 887.8  11 847.6  18 529.0  23 469.6  26 614.5  33 593.2  36 865.4  44 048.1  49 403.0  48 507.0  60 367.3  63 972.3  71 686.6  75 430.7  83 366.4  89 345.0 
Required Minimum Cash Balance[1] GBP 000s                             -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Cash From Operations GBP 000s  (45 423.8) 726.3  2 190.4  5 304.8  3 849.0  (1 620.5) 8 441.3  1 958.0  5 207.8  2 093.6  5 408.6  3 884.8  2 305.1  5 720.6  2 451.7  5 935.7  4 337.2  807.8  8 132.2  2 838.3  6 489.0  2 959.8  6 681.4  4 940.6  3 144.9  6 978.6  3 272.2  7 182.7  5 354.9  (896.0) 11 860.3  3 605.0  7 714.2  3 744.1  7 935.7  5 978.6  3 959.4 
Less: Net Mandatory Debt (Repayment) GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Less: Dividend Payments GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Funds Available to Repay Debt GBP 000s  (45 223.8) 726.3  2 190.4  5 304.8  3 849.0  (1 620.5) 8 441.3  1 958.0  5 207.8  2 093.6  5 408.6  3 884.8  2 305.1  5 720.6  2 451.7  5 935.7  4 337.2  807.8  8 132.2  2 838.3  8 887.8  11 847.6  18 529.0  23 469.6  26 614.5  33 593.2  36 865.4  44 048.1  49 403.0  48 507.0  60 367.3  63 972.3  71 686.6  75 430.7  83 366.4  89 345.0  93 304.4 
Interest Income on Cash Balances 1.0%
Cash BoP GBP 000s  200.0                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   2 398.8  8 887.8  11 847.6  18 529.0  23 469.6  26 614.5  33 593.2  36 865.4  44 048.1  49 403.0  48 507.0  60 367.3  63 972.3  71 686.6  75 430.7  83 366.4  89 345.0 
Cash EoP GBP 000s  200.0                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   2 398.8  8 887.8  11 847.6  18 529.0  23 469.6  26 614.5  33 593.2  36 865.4  44 048.1  49 403.0  48 507.0  60 367.3  63 972.3  71 686.6  75 430.7  83 366.4  89 345.0  93 304.4 
Interest Income GBP 000s  0.2                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   2.0  7.4  9.9  15.4  19.6  22.2  28.0  30.7  36.7  41.2  40.4  50.3  53.3  59.7  62.9  69.5  74.5 
Short Term Revolver (New Debt Financing)
Annual Cost of Facility 8.0%
Beginning Balance GBP 000s  22 350.0  67 573.8  66 847.6  64 657.2  59 352.4  55 503.4  57 123.9  48 682.6  46 724.6  41 516.8  39 423.2  34 014.6  30 129.8  27 824.7  22 104.1  19 652.5  13 716.7  9 379.5  8 571.7  439.5                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Borrowings (Payments) GBP 000s  45 223.8  (726.3) (2 190.4) (5 304.8) (3 849.0) 1 620.5  (8 441.3) (1 958.0) (5 207.8) (2 093.6) (5 408.6) (3 884.8) (2 305.1) (5 720.6) (2 451.7) (5 935.7) (4 337.2) (807.8) (8 132.2) (439.5)                          -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Ending Balance GBP 000s  22 350.0  67 573.8  66 847.6  64 657.2  59 352.4  55 503.4  57 123.9  48 682.6  46 724.6  41 516.8  39 423.2  34 014.6  30 129.8  27 824.7  22 104.1  19 652.5  13 716.7  9 379.5  8 571.7  439.5                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Interest Expense GBP 000s  149.0  450.5  445.7  431.0  395.7  370.0  380.8  324.6  311.5  276.8  262.8  226.8  200.9  185.5  147.4  131.0  91.4  62.5  57.1  2.9                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Cash Available for Bank Debt GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -   2 398.8  8 887.8  11 847.6  18 529.0  23 469.6  26 614.5  33 593.2  36 865.4  44 048.1  49 403.0  48 507.0  60 367.3  63 972.3  71 686.6  75 430.7  83 366.4  89 345.0  93 304.4 
Bank Debt Tranche A
Annual Cost of Facility 6.0%
Beginning Balance GBP 000s  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0 
Mandatory (Repayment) GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Discretionary Borrowings / (Repayment) GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Ending Balance GBP 000s  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0  20 000.0 
Interest Expense GBP 000s  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0 
Bank Debt Tranche B
Annual Cost of Facility 5.0%
Beginning Balance GBP 000s  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0 
Mandatory (Repayment) GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Discretionary Borrowings / (Repayment) GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Ending Balance GBP 000s  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0  10 000.0 
Interest Expense GBP 000s  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7 
Interest Charges Summary
                                                                                     
(GBP in 000s , except otherwise stated)           Sep.14 Oct.14 Nov.14 Dec.14 Jan.15 Feb.15 Mar.15 Apr.15 May.15 Jun.15 Jul.15 Aug.15 Sep.15 Oct.15 Nov.15 Dec.15 Jan.16 Feb.16 Mar.16 Apr.16 May.16 Jun.16 Jul.16 Aug.16 Sep.16 Oct.16 Nov.16 Dec.16 Jan.17 Feb.17 Mar.17 Apr.17 May.17 Jun.17 Jul.17 Aug.17 Sep.17
Short Term Revolver GBP 000s  149.0  450.5  445.7  431.0  395.7  370.0  380.8  324.6  311.5  276.8  262.8  226.8  200.9  185.5  147.4  131.0  91.4  62.5  57.1  2.9                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Bank Debt Tranche A GBP 000s  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0  100.0 
Bank Debt Tranche B GBP 000s  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7  41.7 
Total Period Interest Charges GBP 000s  290.7  592.2  587.3  572.7  537.3  511.7  522.5  466.2  453.2  418.4  404.5  368.4  342.5  327.2  289.0  272.7  233.1  204.2  198.8  144.6  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7  141.7 
Tax Schedule
                                                                                     
(GBP in 000s , except otherwise stated)           Sep.14 Oct.14 Nov.14 Dec.14 Jan.15 Feb.15 Mar.15 Apr.15 May.15 Jun.15 Jul.15 Aug.15 Sep.15 Oct.15 Nov.15 Dec.15 Jan.16 Feb.16 Mar.16 Apr.16 May.16 Jun.16 Jul.16 Aug.16 Sep.16 Oct.16 Nov.16 Dec.16 Jan.17 Feb.17 Mar.17 Apr.17 May.17 Jun.17 Jul.17 Aug.17 Sep.17
EBT GBP 000s  (10 183.8) 2 726.3  2 811.2  2 906.7  3 024.0  3 132.6  3 205.7  3 346.9  3 445.9  3 567.5  3 669.5  3 794.6  3 910.6  4 017.2  4 147.6  4 257.3  4 391.4  4 516.0  4 618.1  4 770.3  4 874.3  4 980.0  5 084.0  5 192.2  5 300.2  5 408.0  5 520.2  5 630.6  5 745.6  5 860.3  5 971.1  6 093.8  6 211.1  6 333.1  6 453.2  6 578.1  6 702.8 
Manual Tax Adjustments 1 GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Manual Tax Adjustments 2 GBP 000s                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Total Taxable Income GBP 000s  (10 183.8) 2 726.3  2 811.2  2 906.7  3 024.0  3 132.6  3 205.7  3 346.9  3 445.9  3 567.5  3 669.5  3 794.6  3 910.6  4 017.2  4 147.6  4 257.3  4 391.4  4 516.0  4 618.1  4 770.3  4 874.3  4 980.0  5 084.0  5 192.2  5 300.2  5 408.0  5 520.2  5 630.6  5 745.6  5 860.3  5 971.1  6 093.8  6 211.1  6 333.1  6 453.2  6 578.1  6 702.8 
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% 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 GBP 000s                           -                            -                            -                            -   (56.9) (626.5) (641.1) (669.4) (689.2) (713.5) (733.9) (758.9) (782.1) (803.4) (829.5) (851.5) (878.3) (903.2) (923.6) (954.1) (974.9) (996.0) (1 016.8) (1 038.4) (1 060.0) (1 081.6) (1 104.0) (1 126.1) (1 149.1) (1 172.1) (1 194.2) (1 218.8) (1 242.2) (1 266.6) (1 290.6) (1 315.6) (1 340.6)
Total Tax for Income Statement GBP 000s  2 036.8  (545.3) (562.2) (581.3) (604.8) (626.5) (641.1) (669.4) (689.2) (713.5) (733.9) (758.9) (782.1) (803.4) (829.5) (851.5) (878.3) (903.2) (923.6) (954.1) (974.9) (996.0) (1 016.8) (1 038.4) (1 060.0) (1 081.6) (1 104.0) (1 126.1) (1 149.1) (1 172.1) (1 194.2) (1 218.8) (1 242.2) (1 266.6) (1 290.6) (1 315.6) (1 340.6)
Loss Carry Forward Calculation
Accumulated Tax Shield - BoP GBP 000s  200.0  2 236.8  1 691.5  1 129.3  547.9                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Tax Shield Created GBP 000s  2 036.8                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Tax Shield Used GBP 000s                           -   (545.3) (562.2) (581.3) (547.9)                          -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
Accumulated Tax Shield - EoP GBP 000s  200.0  2 236.8  1 691.5  1 129.3  547.9                           -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -                            -  
>> End of Sheet                                                                                    
[1]
FinRobot:
Insert as negative, this would dissallow repaying revolving debt from minimum cash balance