Short-Term Cashflow Projections & Chart
Help Print Projections & Chart
 
 
Covering First Three Months % Profile of Monthly Cashflows Jan Feb Mar  
in Year to Dec 2005 Week 1 Week 2 Week 3 Week 4 Total Week 1 Week 2 Week 3 Week 4 Week 1 Week 2 Week 3 Week 4 Week 1 Week 2 Week 3 Week 4  
  % % % % % $000 $000 $000 $000 $000 $000 $000 $000 $000 $000 $000 $000  
Cash receipts                                  
Cash sales & accounts receivable (Note 1)   25.0 75.0 100.0   43.9 131.7   80.8 242.5 83.2 249.7  
Proceeds of new stock issues   100.0   100.0     1,000.0      
Increases in longterm debt/notes   100.0   100.0       50.0    
Increases in other loans     100.0   100.0                          
Proceeds from disposals of fixed assets   100.0   100.0       25.0    
Sales tax recovered from State   100.0   100.0   5.0        
Miscellaneous income received 25.0 25.0 25.0 25.0 100.0 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5  
Interest received   100.0   100.0   0.0       1.6       2.4      
Total cash receipts         2.5 7.5 46.4 134.2 2.5 4.1 1,083.3 245.0 2.5 29.9 135.7 252.2  
     
Cash payments                                  
Materials/goods accounts payable (Note 2) 75.0 25.0   100.0 82.2 27.4 103.3 34.4   106.1 35.4    
Total direct cost payments (Note 3) 25.0 25.0 25.0 25.0 100.0 5.9 5.9 5.9 5.9 13.7 13.7 13.7 13.7 17.4 17.4 17.4 17.4  
Total overhead expense payments (Note 4) 25.0 25.0 25.0 25.0 100.0 16.1 16.1 16.1 16.1 33.9 33.9 33.9 33.9 42.9 42.9 42.9 42.9  
Taxes paid     100.0   100.0                          
Dividends paid   100.0 100.0          
Lease repayments   100.0 100.0   18.0   10.0 10.0  
Lease interest expense   100.0 100.0   10.0   5.0 5.0  
Total capital expend. payments (Note 5)     100.0   100.0                     45.0    
Operating lease payments 25.0 25.0 25.0 25.0 100.0 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4  
Longterm debt/note repayments   100.0   100.0   25.0        
Purchases of intangible assets    100.0   100.0          
Other loan repayments   100.0   100.0          
Sales tax paid on o/h expense, capex etc. inputs     100.0   100.0     18.4       16.8       13.3    
Sales tax paid to State   100.0   100.0       16.8    
Opening payroll taxes/benefits paid   100.0   100.0   25.0        
Changes in prepaid expenses 25.0 25.0 25.0 25.0 100.0 (2.5) (2.5) (2.5) (2.5)        
Changes in accrued expenses 25.0 25.0 25.0 25.0 100.0   5.0 5.0 5.0 5.0    
Interest paid   100.0   100.0   2.8       3.1       1.8      
Total cash payments         103.1 76.1 64.3 48.9 157.3 91.5 70.8 69.0 167.8 98.8 136.9 76.7  
     
Net cashflow (100.6) (68.6) (17.9) 85.3 (154.8) (87.5) 1,012.5 176.0 (165.3) (68.8) (1.1) 175.5  
     
Opening net cash balances (overdraft) (110.0) (210.6) (279.2) (297.1) (211.8) (366.6) (454.1) 558.4 734.4 569.2 500.3 499.2  
Closing net cash balance (deficit) (210.6) (279.2) (297.1) (211.8) (366.6) (454.1) 558.4 734.4 569.2 500.3 499.2 674.7  
                                     
Notes refer to Monthly Cashflow Projections (M_CF)  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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 (100.6) (68.6) (17.9) 85.3 (154.8) (87.5) 1,012.5 176.0 (165.3) (68.8) (1.1) 175.5    
Closing net cash balance (deficit) (210.6) (279.2) (297.1) (211.8) (366.6) (454.1) 558.4 734.4 569.2 500.3 499.2 674.7