Question

Howard ​Services, Inc., has $ 8 comma 600 cash on hand on January 1. The company requires a minimum cash balance of $ 7 comma 600. January cash collections are $ 548 comma 570. Total cash payments for January are $ 567 comma 610. Prepare a cash budget for January. How much​ cash, if​ any, will Howard need to borrow by the end of January​?

Answer 1

The amount of cash to be borrowed = $18,040

Step-by-step explanation:

The cash budget shows the expected cash payments and expected cash receipts and cash balance at the end of a particular period.

Note that in the cash budget only items of the cash are considered, therefore items like depreciation, amortization of intangible assets and apportionment of fixed costs are not included because they are not cash based.

The balance at the end = opening cash balance + cash receipts -cash payment

Applying this to Howard ​Services, Inc.

The amount of cash to be borrowed = Minimum cash balance required - Net cash balance

DATA

Opening cash balance - 8600

Cash receipts- 548,570

Cash payment - 567,610

Net cash balance = 8600 + 548,570 - 567,610 = (10,440)

The amount of cash to be borrowed = 7,600 - (10,440)

=7,600+10,440=18040

The amount of cash to be borrowed = $18,040

Note a negative amount of 10,400 would mean that that would be first borrowed to balance the deficit, and to take the balance to the minimum required cash balance, an addition 7,600 would need to be borrowed.