Sales Purchases Rent Drawings Wages  
  Jan            
  Feb            
  Mar 39500 18500 1500 2000 4900  
  Apr 45800 26700 1700 1000 5100  
  May 37600 25000 2000 1500 5500  
  June 52300 29500 2100 2500 4500  
  July 58000 25000 1900 2000 6000  
  Rent is paid one month in advance
  30% of sales are on a cash basis, the remainder is received 1 month later
  40% of purchases are on a cash basis, the remainder is paid 1 months after purchase
  Wages are paid one month in arrears
  The company buys a new asset with payments: £8000 in May and £8000 in June.
  The company sells equipment with 2000 payment received in May and 3000 received in June
  The bank balance on 1st April is 5600
      April   May   June
  Receipts            
  Sales Cash    
    Credit    
    Equipment    
  Total Receipts      
               
  Payments            
  Purchases Cash    
    Credit    
    Rent    
    Drawings    
    Wages    
    New Asset    
  Total Payments      
               
  Net Cash Flow      
  Opening Balance      
  Closing Balance