Short-Term Cashflow Projections & Chart
Help Print Projections & Chart
 
 
Covering First Three Months % Profile of Monthly Cashflows Feb Mar  Apr  
in Year to Jan 2006 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) 10.0 10.0 50.0 30.0 100.0 17.7 17.7 88.5 53.1 33.5 33.5 167.3 100.4 35.7 35.7 178.4 107.0  
Proceeds of new stock issues   100.0   100.0   25.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     50.0  
Sales Tax recovered from State   100.0 100.0        
Miscellaneous income received   100.0   100.0 10.0   10.0   10.0    
Interest received 25.0 25.0 25.0 25.0 100.0 0.0 0.0 0.0 0.0                  
Total cash receipts         Error 17.7 17.7 98.5 53.1 33.5 33.5 202.3 100.4 35.7 35.7 188.4 207.0  
       
Cash payments                                    
Materials/goods accounts payable (Note 2) 50.0 30.0 10.0 10.0 100.0 59.3 35.6 11.9 11.9 78.0 46.8 15.6 15.6 68.3 41.0 13.7 13.7  
Total direct cost payments (Note 3) 25.0 25.0 25.0 25.0 100.0 6.1 6.1 6.1 6.1 14.3 14.3 14.3 14.3 18.2 18.2 18.2 18.2  
Total overhead expense payments (Note 4) 25.0 25.0 25.0 25.0 100.0 16.8 16.8 16.8 16.8 34.5 34.5 34.5 34.5 43.3 43.3 43.3 43.3  
Taxes paid       100.0 100.0                          
Dividends paid   100.0 100.0        
Lease repayments   100.0   100.0 10.0   10.0   10.0    
Lease interest expense   100.0   100.0 5.0   5.0   5.0    
Total capital expend. payments (Note 5)   50.0   50.0 100.0                   22.5   22.5  
Operating lease payments   50.0   50.0 100.0 2.8 2.8 2.8 2.8 2.8 2.8  
Longterm debt/note repayments   100.0 100.0 25.0      
Other loan repayments   100.0 100.0        
Purchases of intangible assets            
Sales Tax paid on o/h expense, capex etc. inputs 25.0 25.0 25.0 25.0 100.0                          
Sales Tax paid to State   100.0   100.0 20.0   16.8   20.9    
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       3.9       4.5       5.0  
Total cash payments         79.7 58.7 92.2 63.9 131.8 103.4 101.2 76.7 129.8 127.7 111.0 105.4  
     
Net cashflow (62.0) (41.0) 6.3 (10.8) (98.4) (69.9) 101.1 23.7 (94.1) (92.0) 77.4 101.6  
     
Opening net cash balance (deficit) (110.0) (172.0) (213.0) (206.7) (217.5) (315.8) (385.8) (284.6) (260.9) (355.0) (447.0) (369.6)  
Closing net cash balances (deficit) (172.0) (213.0) (206.7) (217.5) (315.8) (385.8) (284.6) (260.9) (355.0) (447.0) (369.6) (268.0)  
                                     
Notes refer to Monthly Cashflow Projections (M_CF)  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Chart Values - These items will not be printed  
  Feb   Mar    Apr  
  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 (62.0) (41.0) 6.3 (10.8) (98.4) (69.9) 101.1 23.7 (94.1) (92.0) 77.4 101.6  
Closing net cash balance (172.0) (213.0) (206.7) (217.5) (315.8) (385.8) (284.6) (260.9) (355.0) (447.0) (369.6) (268.0)