Question

The following information is available for Wildhorse Co. for the month of January: expected cash receipts $59,320; expected cash disbursements $66,850; and cash balance on January 1, $11,890. Management wishes to maintain a minimum cash balance of $8,230. Prepare a basic cash budget for the month of January.

Answer 1

Ending cash balance$8,230

Step-by-step explanation:

Preparation of basic cash budget for the month of January.

Wildhorse Co CASH BUDGET for the month of January

Beginning cash balance$11,890

Add: Cash receipts $59,320

Total cash available $71,210

($59,320+$11,890)

Less: Cash disbursements ($66,850)

Excess of available cash over cash disbursements $4,360

Financing needed $3,870

($8,230-$4,360)

Ending cash balance$8,230

Therefore the basic cash budget for the month of January will be $8,230