I need help with the formula for 'cash balance beginning'

For the 6 months ending June 2020 Jan 20 Feb 20 Mar '20 Apr '20 May 20 Jun 20 6 mos total Cash balance, beginning S 15,000 Add collections from customers 104,200 106,132 112,300 134,328 171,315 214,572 Total cash available 119,200 Less disbursements: Cash disbursements for merchandise purch 43,200 43,968 50,515 61,690 76,306 87,847 S 363,526 Cash disbursements for operating expenses 50,000 51,820 52,600 57,280 63,325 69,175 344,200 Equipment purchases 50,000 30,000 80,000 Dividends 12,000 12,000 Total cash disbursements 143,200 125,788 115,115 118,970 139,631 157,022 799,726 Excess of receipts over disbursements (24,000) Financing: Borrowing-note Repayments-note Total financing