Alderman Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions expected to occur:

$($Click the icon to view the expected transactions.$)$

Requirement

Prepare a combined cash budget for Alderman Health Center for the third quarter, with a column for each month and for the quarter total. $($If an input field is not use the table leave the input field empty; do not enter a zero. Use parentheses or a minus sign for negative ending cash balances.$)$

Alderman Health Center

Combined Cash Budget

For the Months of July through September

Beginning balance of cash

Plus: Cash collections

Total cash available

Less: Cash payments

Ending cash balance before financing

Financing:

Plus: New borrowings