How do I format the cash budget?
Cash balance, November 1 24,000
Sales 250,000
Gross profit percentage( based on sales) 45%
Increase in accounts Receivable during month 24,000
Increase in accts. Payable during month 51,000
Increase in inventory during month 98,000
Selling expenses total 32,000 per month plus 15% of sales. Depreciation expense of 5,000 per month is included in fixed selling expenses. Prepare a worksheet to compute projected cash balance of 1,000 at end of November.
