Fill This Form To Receive Instant Help
Homework answers / question archive / toland Manufacturing has $11,200 cash on hand on May 1 The company requires a minimum cash balance of $7,400 May cash collections are $547,000 Total cash payments for Aay are $586,000 Prepare a cash budget for May How much cash, if any, will Roland need to borrow by the end of May? :;omplete the cash budget below (Use parentheses or a minus sign for negative ending cash balances or deficiencies
toland Manufacturing has $11,200 cash on hand on May 1 The company requires a minimum cash balance of $7,400 May cash collections are $547,000 Total cash payments for Aay are $586,000 Prepare a cash budget for May How much cash, if any, will Roland need to borrow by the end of May?
:;omplete the cash budget below (Use parentheses or a minus sign for negative ending cash balances or deficiencies.)
Roland Manufacturing Cash Budget For the Month Ended May 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)
Roland Manufacturing | |
Cash Budget | |
For the Month Ended May 31 | |
Particulars | Amount |
Beginning cash balance | $11,200.00 |
Add: Cash collections | $547,000.00 |
Total cash available | $558,200.00 |
Less: Cash payments | $586,000.00 |
Ending cash balance before financing | -$27,800.00 |
Cash excess (deficiency) | $7,400.00 |
Amount to borrow | $35,200.00 |