Cash Budgets

6140 Week 7 assignment template

		October (actual)	November (actual)	December (actual)	January	February	March
Expected sales		$300,000	$325,000	$450,000	$310,000	$350,000	$400,000
Cash receipts:
Cash sales	0%				0	0	0
Collection from sales:
One month ago	60%				270000	186000
Two months ago	25%				81250
Three months ago	10%				30000
Bad debts	5%
	100%				381250
Other cash receipts						20000	4000
Beginning of month cash					14000	10750	10000
Total cash available					395250

Cash disbursements:
Materials					92500
Labor and wages
Selling costs
G & A costs
Income taxes
Capital equipment					50000
Interest expense
Total cash disbursements					384500
Ending cash balance (deficiency) before borrowings/ (repayments) or (investments)/redemptions					10750
Bank borrowings/(repayments) (investments)/redemptions
Ending cash balance (deficiency)					10750