how do i calculate the beginning cash balance for october and november?

Saved ork Required: Prepare a cash budget for September October, and November. (Round your final answers to the nearest w Calculation of cash receipts from sales Collected in- Total Sales Uncollectible August September October November 30. November Accounts Rec. 0 Credit sales from August September October November $ 170,000 $ 250,000 445,000 500,000 $ 1,365,000 5,100 s 7,500 13,350 15,000 $ 40,800 $ 74,800 $ 35,700 s 13,600 $ 0 60,000 110,000 52,500 0 0 106,800 195,800 0 0 0 120,000 40,800 $ 134,800 $ 252,500 $ 381,900 $ 20,000 129,050 365,000 514,050 Totals Calculation of cash payments for merchandise -Pald in August September October November 30. Total Purchases November Accounts Pay. D Purchases from August September October November Totals $ 110,000 225,000 220,000 192,000 $ 747.000 or $ 77,000 $ 33,000 0 $ 0 0 157,500 67,500 0 0 0 154,000 0 0 0 0 $ 77,000 $ 190,500 $ 221,500 $ 0 65,000 192,000 258,000 to search o E https://ezto.mheducation.com/ext/map/index.html?_con=con&external_browse Saved work ONEIDA COMPANY November 381,900 0 Cash Budget For September, October, and November September October Beginning cash balance $ 4,500 Cash receipts Collection on accounts receivable 134,800 252,500 Receipts from bank loan 109,000 0 Total cash available 248,300 Cash payments Payments on accounts payable 77,000 190,500 Payroll 20,600 22,100 Rent 10,000 10,000 Other cash expenses 34,600 31,600 Repayment on bank loan 0 0 Interest on bank loan 0 0 221,500 24,800 10,000 21,150 109,000 3,270 142,200 254,200 389,720 Total cash payments Ending cash balance