B-3 Completed Cash Budget

ABC Company Cash Budget July-September 1993

  July August September
       
Cash Receipts      
Cash Sales $ 20,000 $ 15,000 $ 18,000
Accounts Receivable 78,750 142,500 126,000
Investment Income 100 100  
Investment Maturities 20,000 20,000  
Sale of Fixed Assets   5,000  
  _______________ _______________ _______________
Total Receipts $ 118,850 $ 182,600 $ 144,000
       
Cash Disbursements      
Purchases-Inventory $ 69,350 $ 227,100 $ 46,000
General Payables 20,000 24,000 20,000
Payroll (incl. taxes) 22,000 25,000 23,000
Taxes (Income)     10,000
Debt Repayment     10,000
Purchase of Fixed Assets      
Investment Purchases 10,000    
Other      
  _______________ _______________ _______________
Total Disbursement $ 121,350 $ 276,100 $ 109,000
       
Recap:      
Beginning Cash $ 71,000 $ 68,500 $ ( 25,000)
Add: Total Receipts 118,850 182,600 144,000
Less:      
Total Disbursments 121,350 276,100 109,000
       
Ending Cash 68,500 (25,000) 10,000
Less: Minimum Cash (37,500) (37,500) (37,500)
  _______________ _______________ _______________
Available Cash $ 31,000 $ (62,500) $ (27,500)