help on how to find preliminary cash balance

B B $5,100 A 1 2 Expected cash collections: 3 March cash collections 4 March collections on account: 5 January sales 6 February sales 7 March sales 8 Total cash collections 9 H0 Payments to suppliers: 11 Accounts payable for inventory purchases, beginning balance 12 March purchases 13 Total cash payments 14 15 5,500 18,000 6,000 $34,600 $10,500 14,100 $24,600 $11,500 34,600 46,100 4 5 S&P Enterprises 6 Cash Budget 7 For the Month of March 8 Cash balance, March 1 9 Add cash receipts: 0 Collections from customers 1 Total cash available 2 Less disbursements: -3 Payments to suppliers 24 Selling and administrative expenses 25 Equipment purchases 26 Dividends paid 27 Total disbursements 28 Preliminary cash balance 29 Financing 30 Additional loan 31 Loan repayments 32 Interest 33 Total financing 34 Cash balance, March 31 35 $24,600 9,300 14,000 2,000 49,900 0 $0