Kerwin Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Kerwin Health Center for the third quarter, with a column for each month and fom the quarter total. (If an input field is not used in the table leave the input field empty; do not enter a zero. Use parentheses or a minus sign for negative ending cash balances.) Kerwin Health Center Combined Cash Budget For the Months of July through September July August September Quarter Beginning balance of cash 31000 27000 30470 Plus: Cash collections 94000 156000 129000 Total cash available 125000 183000 159470 Less: Cash payments 149000 100000 134000 Ending cash balance before financing (24000) 83000 25470 Financing: Plus: New borrowings 51000 1530 Less: Debt repayments 0 (51000) Less: Interest payments 0 (1530) Ending cash balance 27000 30470