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  
Proceeds from sale of fixed assets     100.0     100.0     100.0  
Sales Tax 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  
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  
Sales Tax 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  
Sales Tax 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) 2.3 2.3 11.7 7.0 2.9 2.9 14.3 8.6 2.7 2.7 13.3 8.0  
Proceeds of new stock issues       5.0        
Increases in longterm debt/notes           10.0  
Proceeds from sale of fixed assets           6.0  
Sales Tax recovered from State       0.7   0.7  
Capital grants/subsidies received              
Revenue grants/subsidies received                          
Miscellaneous income received   1.0     1.0     1.0    
Interest received 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0  
Total cash receipts 2.3 2.3 12.7 7.0 2.9 2.9 20.3 9.3 2.7 2.7 14.3 24.7  
     
CASH PAYMENTS    
Materials/goods accounts payable (Note 2) 8.6 5.1 1.7 1.7 7.3 4.4 1.5 1.5 7.3 4.4 1.5 1.5  
Total direct cost payments (Note 3) 0.9 0.9 0.9 0.9 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0  
Total overhead expense payments (Note 4) 1.3 1.3 1.3 1.3 1.6 1.6 1.6 1.6 1.6 1.6 1.6 1.6  
Taxes paid                          
Dividends paid              
Capital expenditure payments                   4.5   4.5  
Operating lease  payments   0.6 0.6   0.6 0.6   0.6 0.6  
Longterm debt/note repayments   5.0          
Sales Tax paid on overheads, capex etc.                          
Sales Tax paid to State              
Opening payroll taxes/benefits paid   5.0            
Changes in prepaid expenses (0.5) (0.5) (0.5) (0.5)          
Changes in accrued expenses     1.0 1.0 1.0 1.0      
Interest paid       0.6       0.6       0.6  
Total cash payments 10.3 7.4 8.4 9.6 10.9 8.5 5.0 6.2 9.9 12.0 4.0 9.7  
     
Net cashflow (7.9) (5.0) 4.3 (2.5) (8.0) (5.7) 15.3 3.1 (7.2) (9.3) 10.2 15.0  
     
Opening net cash balance (deficit) (22.0) (29.9) (34.9) (30.6) (33.1) (41.1) (46.8) (31.5) (28.5) (35.7) (45.0) (34.8)  
Closing net cash balances (deficit) (29.9) (34.9) (30.6) (33.1) (41.1) (46.8) (31.5) (28.5) (35.7) (45.0) (34.8) (19.8)  
                             
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   (7.9) (5.0) 4.3 (2.5) (8.0) (5.7) 15.3 3.1 (7.2) (9.3) 10.2 15.0
Closing net cash balance (deficit)   (29.9) (34.9) (30.6) (33.1) (41.1) (46.8) (31.5) (28.5) (35.7) (45.0) (34.8) (19.8)
Initial 3 months (12 weeks) commencing in Jan 2004