Grenoble enterprises had sales of $50,400 in March and $59,800 in April. Forecast sales for May-July are $70,300, $80,000, $100,400 respectively. The firm has a cash bal of $4,800 on May 1 and wishes to maintain cash bal of $4,800, Given the following data prepare and interpret a cash budget for the months of May, June and July.

1. the firm makes 21% of sales for cash, 61% are collected the next month and the remaining 18% are collected in the second month following sale 2. The firm receives other income of $2200 per month 3. The firm's actual or expected purchases, all made for cash are $49,800, $69,600, and $80,400 for the months May through July respectively. 4. Rent is $3,000 per month 5. Wages and salaries are 9% of the previous month's sales 6. Cash dividends of $2,800 will be paid in june 7.Payment of principal and interest of $3.500 is due in June. 8. A cash purchase of equiptment costing $5,600 is scheduled in July 9. Taxes of $6,300 are due in June. _______________________________________________________________________________

Complete the first month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar. Please input all the values in the table before checking your answers.)

	March	April	May
Sales	$50,400	$59,800	$70,300
Cash sales	10,584	12,558	$?
Lag 1 month			$?
Lag 2 months			$?
Other income			$?
Total cash receipts			$?

(Round to the nearest dollar. Please input all the values in the table before checking your answers.)

***ALREADY ANSWERED***

	March	April	May
Disbursments
Purchases			($49,800)
Rent			($3,000)
Wages and salaries			($5382)
Dividends			0
Principal and interest			0
Purchase of new equipment			0
Taxes Due			0
Total cash disbursments			($58182)

(Round to the nearest dollar. Please input all the values in the table before checking your answers.)

	March	April	May
Net Cash Flow			$?
Add: Beginning cash			$?
Ending cash			$?
Minimum cash			$?
Required total financing (notes payable)			$?
Excess cash balance (marketable securities)			$?

Complete the second month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar. Please input all the values in the table before checking your answers.)