CES Exercise 23-16 The controller of Trenshaw 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 July 31, 2017. June 30, 2017, cash balance Dividends to be declared on July 15 Cash expenditures to be paid in July for operating expenses Amortization expense in July Cash collections to be received in July Merchandise purchases to be paid in cash in July $45,000 12,900 37,900 4,400 83,700 55,100 20,800 Equilement to be purchased for cash in July Dividends are payable 30 days after declaration to shareholders of record on the declaration date. Trenshaw Company wants to keep a minimum cash balance of $25,000. udy Prepare a cash budget for the month ended July 31, 2017, and indicate how much money, if any, Trenshaw Company will need to borrow to meet its minimum cash requirement. TRENSHAW COMPANY Cash Budget 6 MacBo ca NEXT CES Prepare a cash budget for the month ended July 31, 2017, and indicate how much money, if any, Trenshaw minimum cash requirement. Company will need to borrow to meet its Cash Budget dy Click if you would like to Show Work for this question: Open Show Work MacBook Pro Merchandise Purchases Ending Cash Balance Equipment Purchase Beginning Cash Balance Payment of Dividends Total Cash Available Operating Expenses Total Cash Disbursements Receipts Excess of available cash over disbursements Borrowings Cash Disbursements estion: Ope Cash Collections Repayments Sale of Equipment Selling and Administrative Expenses 6 : F2 F1 F3 F4 F5 CES Exercise 23-16 The controller of Trenshaw 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 July 31, 2017. June 30, 2017, cash balance Dividends to be declared on July 15 Cash expenditures to be paid in July for operating expenses Amortization expense in July Cash collections to be received in July Merchandise purchases to be paid in cash in July $45,000 12,900 37,900 4,400 83,700 55,100 20,800 Equilement to be purchased for cash in July Dividends are payable 30 days after declaration to shareholders of record on the declaration date. Trenshaw Company wants to keep a minimum cash balance of $25,000. udy Prepare a cash budget for the month ended July 31, 2017, and indicate how much money, if any, Trenshaw Company will need to borrow to meet its minimum cash requirement. TRENSHAW COMPANY Cash Budget 6 MacBo ca NEXT CES Prepare a cash budget for the month ended July 31, 2017, and indicate how much money, if any, Trenshaw minimum cash requirement. Company will need to borrow to meet its Cash Budget dy Click if you would like to Show Work for this question: Open Show Work MacBook Pro Merchandise Purchases Ending Cash Balance Equipment Purchase Beginning Cash Balance Payment of Dividends Total Cash Available Operating Expenses Total Cash Disbursements Receipts Excess of available cash over disbursements Borrowings Cash Disbursements estion: Ope Cash Collections Repayments Sale of Equipment Selling and Administrative Expenses 6 : F2 F1 F3 F4 F5