Short-Term Cashflow Projections & Chart
Help with ST Cashflows
Print Projections & Chart
 
 
Covering First 12 Periods   Jan Feb Mar  
in Year to Dec 2004   Week 1 Week 2 Week 3 Week 4 Week 1 Week 2 Week 3 Week 4 Week 1 Week 2 Week 3 Week 4  
     
Table 1 - Percentage Distribution of Cashflows for Initial Three Months    
     
CASH RECEIPTS %    %    %    %    %    %    %    %    %    %    %    %     
Cash sales & accounts receivable (Note 1)   10.0 10.0 50.0 30.0 10.0 10.0 50.0 30.0 10.0 10.0 50.0 30.0  
Proceeds of new stock issues     100.0       100.0       100.0    
Increases in longterm debt/notes     100.0     100.0     100.0  
Increases in other loans         100.0       100.0       100.0  
Proceeds from sale of fixed assets     100.0     100.0     100.0  
VAT recovered from State     100.0     100.0     100.0  
Capital grants/subsidies received     100.0     100.0       100.0      
Revenue grants/subsidies received     100.0       100.0       100.0      
Miscellaneous income received     100.0       100.0       100.0    
Interest received   25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0  
                           
CASH PAYMENTS                          
Materials/goods accounts payable (Note 2)   50.0 30.0 10.0 10.0 50.0 30.0 10.0 10.0 50.0 30.0 10.0 10.0  
Total direct cost payments (Note 3)   25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0  
Total overhead expense payments (Note 4)   25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0  
Taxes paid         100.0       100.0       100.0  
Dividends paid     100.0     100.0     100.0  
Finance lease debt repayments     100.0       100.0       100.0    
Finance lease interest paid     100.0       100.0       100.0    
Capital expenditure payments     50.0   50.0   50.0   50.0   50.0   50.0  
Operating lease  payments     50.0   50.0   50.0   50.0   50.0   50.0  
Longterm debt/note repayments     100.0     100.0     100.0  
'Other loan' repayments     100.0     100.0     100.0  
VAT paid on overheads, capex etc.   25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0  
VAT paid to State     100.0       100.0       100.0    
Opening payroll taxes/benefits paid     100.0       100.0       100.0    
Changes in prepaid expenses   25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0  
Changes in accrued expenses   25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0  
Interest paid     100.0     100.0     100.0  
                           
     
Table 2 - Distribution of Cashflows for Initial Three Months    
     
CASH RECEIPTS $000 $000 $000 $000 $000 $000 $000 $000 $000 $000 $000 $000  
Cash sales & accounts receivable (Note 1) 17.2 17.2 86.1 51.7 30.9 30.9 154.6 92.7 32.8 32.8 164.0 98.4  
Proceeds of new stock issues       25.0        
Increases in longterm debt/notes           50.0  
Increases in other loans                          
Proceeds from sale of fixed assets              
VAT recovered from State       1.3   6.2  
Capital grants/subsidies received              
Revenue grants/subsidies received                          
Miscellaneous income received   10.0     10.0     10.0    
Interest received 0.0 0.0 0.0 0.0                  
Total cash receipts 17.2 17.2 96.1 51.7 30.9 30.9 189.6 94.1 32.8 32.8 174.0 154.6  
     
CASH PAYMENTS    
Materials/goods accounts payable (Note 2) 57.1 34.3 11.4 11.4 76.5 45.9 15.3 15.3 76.8 46.1 15.4 15.4  
Total direct cost payments (Note 3) 1.7 1.7 1.7 1.7 6.7 6.7 6.7 6.7 10.1 10.1 10.1 10.1  
Total overhead expense payments (Note 4) 16.1 16.1 16.1 16.1 34.1 34.1 34.1 34.1 41.0 41.0 41.0 41.0  
Taxes paid                          
Dividends paid              
Finance lease debt repayments   10.0     10.0     10.0    
Finance lease interest paid   5.0     5.0     5.0    
Capital expenditure payments                   22.5   22.5  
Operating lease  payments   2.8 2.8   2.8 2.8   2.8 2.8  
Longterm debt/note repayments   25.0          
'Other loan' repayments              
VAT paid on overheads, capex etc.                          
VAT paid to State   20.0            
Opening payroll taxes/benefits paid   25.0            
Changes in prepaid expenses (2.5) (2.5) (2.5) (2.5)          
Changes in accrued expenses     5.0 5.0 5.0 5.0      
Interest paid       6.8       7.1       7.7  
Total cash payments 72.3 52.2 86.7 61.2 122.3 94.5 76.1 71.0 127.9 122.4 81.4 99.3  
     
Net cashflow (55.1) (35.0) 9.5 (9.5) (91.4) (63.5) 113.5 23.1 (95.1) (89.6) 92.6 55.3  
     
Opening net cash balance (deficit) (110.0) (165.1) (200.1) (190.6) (200.1) (291.5) (355.1) (241.6) (218.5) (313.6) (403.1) (310.5)  
Closing net cash balances (deficit) (165.1) (200.1) (190.6) (200.1) (291.5) (355.1) (241.6) (218.5) (313.6) (403.1) (310.5) (255.2)  
                             
Notes refer to Cashflow Projections at the CASH worksheet.  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Chart Values - These items will not be printed  
  Jan   Feb   Mar  
  Week 1 Week 2 Week 3 Week 4 Week 1 Week 2 Week 3 Week 4 Week 1 Week 2 Week 3 Week 4
Net cashflow   (55.1) (35.0) 9.5 (9.5) (91.4) (63.5) 113.5 23.1 (95.1) (89.6) 92.6 55.3
Closing net cash balance (deficit)   (165.1) (200.1) (190.6) (200.1) (291.5) (355.1) (241.6) (218.5) (313.6) (403.1) (310.5) (255.2)
Initial 3 months (12 weeks) commencing in Jan 2004