In preparation for the quarterly cash budget, the following revenue and cost information have been compiled.

Month	Sales	Purchases
August	2900	3800
September	3400	3000
October	900	900
November	1400	350
December	1900	500

Prepare:

1- A Schedule of Projected Cash Receipts for the months of October, November, and December.

2- A Schedule of Projected Cash Disbursements for the months of October, November, and December.

3- A Cash Budget for the months of October, November, and December.

The firm collects 20 percent of sales for cash, and collects 50 percent of its sales one month later, and collects the remaining 30 percent two months after sales.

Interest income of $180 on marketable securities will be received in December.

Dividends income of $270 on marketable securities will be received in December.

The firm pays cash for 10 percent of its purchases, and pays 30 percent the following month, and the remaining 60 percent two months after purchase.

The firm pays monthly salaries of $970

The firm pays dividends of $680 at the end of December.

the firm pays interest of $170 at the end of December.

The firm intends to make a $1200 cash purchase of fixed assets in November.

The firm has a beginning cash balance in October of $660 and maintains a minimum cash balance of $3000.

Cash Receipts
	Aug.	Sept.	Oct.	Nov.	Dec.
Sales	Answer	Answer	Answer	Answer	Answer
Cash sales	Answer	Answer	Answer	Answer	Answer
Collections of A/R:
After one month		Answer	Answer	Answer	Answer
After two months			Answer	Answer	Answer
Interest					Answer
Dividends					Answer
Total cash receipts			Answer	Answer	Answer
Cash Disbursement
	Aug.	Sept.	Oct.	Nov.	Dec.
Purchases	Answer	Answer	Answer	Answer	Answer
Cash purchases	Answer	Answer	Answer	Answer	Answer
Payments of A/P:
After one month		Answer	Answer	Answer	Answer
After two months			Answer	Answer	Answer
Salaries	Answer	Answer	Answer	Answer	Answer
Interest					Answer
Dividends					Answer
Fixed assets				Answer
Total cash disbursements			Answer	Answer	Answer
Cash Budget
			Oct.	Nov.	Dec.
Total cash receipts			Answer	Answer	Answer
Total cash disbursements			Answer	Answer	Answer
Net cash flow			Answer	Answer	Answer
Beginning cash			Answer	Answer	Answer
Ending cash			Answer	Answer	Answer
Minimum cash balance			Answer	Answer	Answer
Required total financing			Answer	Answer	Answer
Excess cash balance			Answer	Answer	Answer