The controller of Coronado 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,2027.$

June $30,2027,$ cash balance

$$53,100$

Dividends to be declared on July $15*$

$14,160$

Cash expenditures to be paid in July for operating expenses

$48,144$

Amortization expense in July

$5,310$

Cash collections to be received in July

$106,200$

Merchandise purchases to be paid in cash in July

$66,316$

Equipment to be purchased for cash in July

$23,600$

$*$Dividends are payable $30$ days after declaration to shareholders of record on the declaration date.

Coronado Company wants to keep a minimum cash balance of $$29,500.$

$($a$)$

Prepare a cash budget for the month ended July $31,2027,$ and indicate how much money, if any, Coronado Company will need to borrow to meet its minimum cash

requirement.

CORONADO COMPANY

Cash Budget

$

$