Create a cash budget

for month July, august, september

beginning balance for July is 33,000

receipts from customer: july 39375, august 73500, september 116375

Payment for merchandise: July 48000, august 126,000, september 125000

operations and sales: july 21400, august 21400, september 21400

loans from bank in July 55,000 in the month of July with an interest of 1.5% of the borrowed amount per month starting from August. The loan is to be paid in full at the end of September, 2020.

create cash budget that has beginning balance, receipts from customer, total cash available, payment for merchandise, operations and sales, liability, dividends, equipment, interest, total disbusements, preliminary balance, loans from bank, repayment of loan, ending cash balance.

Thanks