Prepare a cash budget for the month ended July 31, 2020, and indicate how much money, if any, Trens TRENSHAW COMPANY Cash Budget Total Cash Disbursements Equipment Purchase Cash Disbursements Sale of Equipment Receipts Selling and Administrative Expenses Ending Cash Balance Merchandise Purchases Operating Expenses Payment of Dividends Beginning Cash Balance Repayments Borrowings Total Cash Available Excess of available cash over disbursements Cash Collections Ending a TRENSHAW COMPANY Cash Budget $ Ending Cash Balance . The controller of Trent Company wants to improve the company's control system by preparing a month-by-month cash budget. The following information is for the month ending Suly 31, 2020 June 30, 2020, cash balance $43,400 Dividends to be declared on July 15 12.500 Cash expenditures to be paid in July for operating expenses 36,500 Amortization expert in July 4.200 Cash Collections to be received in July 34,600 Merchandise purchases to be paid in cash in July 55,200 Equipment to be purchased for cash in July 20,600 *Olvidends are payable 30 days after declaration to shareholders of record on the declaration date Tretbow Company wants to keep a memum con bolonce of $20,700 Prepare a cash budget for the month anded sly 31, 2020, and indicate how much money, trany. Treniaw Company will need to borrow to meet its minimum cash recuirement. TRENSHAW COMPANY Cash Budget