Question

Sweeney 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 Sweeney Health Center for the third quarter, with a column for each month and for the quarter total. (If a box is not used in the table leave the box empty; do not enter a zero. Use parentheses or a minus sign for negative ending cash balances.) Sweeney Health Center Combined Cash Budget For the Months of July through September July Beginning balance of cash Plus: Cash collections Total cash available Less: Cash payments Ending cash balance before financing Financing: Plus: New borrowings Less: Debt repayments Less: Interest payments Ending cash balance

Answer 1

Sweeney Health Center Combined Cash Budget For the Months of July through September
	July	August	September	Quarter
Beginning balance of cash	32000	23000	30740	32000
Plus: Cash collections	98000	156000	128000	382000
Total cash available	130000	179000	158740	414000
Less: Cash payments	149000	105000	139000	393000
Ending cash balance before financing	(19000)	74000	19740	21000
Financing:
Plus: New borrowings	42000		0	42000
Less: Debt repayments		(42000)	0	(42000)
Less: Interest payments (42000*3%)		(1260)	0	(1260)
Ending cash balance	23000	30740	19740	19740