Manufacturing has $10,200 cash on hand on January 1. The company requires a minimum cash balance of $7,600. January cash collections are $554,000. Total cash payments for January are $584,000. cash budget for January. How muchcash, ifany, will Coles need to borrow by the end of January?

Complete the cash budget below

Coles Manufacturing

Cash Budget

For the Month Ended January 31

Beginning cash balance

Cash collections from customers

Cash available before financing

Total cash payments

Ending cash balance before financing

Minimum cash balance desired

Cash excess (deficiency)