prepare a cash budget for the month of march based on the following information:

a) the company had a cash balance of $10,000 at the beginning of the month.

b) accounts receivable totaled $21,000 at the beginning of the month of which $14,000 will be received during march.

Prepare a cash budget for the month of March based on the following information: (10 pts.) a) b) c) d) The company had a cash balance of $10,000 at the beginning of the month Accounts receivable totaled $21,000 at the beginnine of the month of which $14,000 will be received during March Sales for March are budgeted at $220,000, Past experience has shown that 70% are received in the month of sale, 18% in the next month, 10% in the third month, and 2% are uncollectible. Fifty percent of a month's merchandise purchased are paid for within the month and 50% in the following month: Merchandise Purchases February $80,000 March $70,000 $76,000 rnish April e) Payments on equipment of $10,000 are due during the month. 1) Common stock of $15,000 is expected to be sold during March ) Monthly depreciation totals $18,000. h) Other operating expenses total $49,000 If the company wants to maintain a $10,000 cash balance, what financing recommendation would you make as a result of the above? 10,000 Beg. Cash Balance Add: Cash Collections Total cash available less: Cash Disbursements Inventory Expenses Equipment Total Cash Disbursements Exess Deficiency