Eddie's Bar and Restaurant Supplies expects its cash receipts and cash payments for the part of the year to be:

	Receipts	Payments
March	19,280	19,100
April	22,280	22,400
May	22,480	14,700

Eddie's had a cash balance of $2,000 on March 1, which is also its minimum required cash balance. The company invests any cash in excess of $3,000 into marketable securities. Marketable securities are sold before funds are borrowed when a cash shortage occurs

There is an outstanding loan of $2,000 on March 1. The opening balance of the Marketable Securities on Mar 1 was $0.

Prepare a cash budget for March, April, and May by completing the following tables.

(fill in every cell, even if the number is zero)

Monthly Cash Flow
	March	April	May
Cash Receipts
Cash Payments (enter as positive number)
Net Cash Flow (remember the negative sign, if appropriate)

Cash Budget
	March	April	May
Net Cash Flow
Beginning Cash Bal	$ 2,000
Cumulative cash balance
Borrowing and repayments (enter repayments as negatives)
Marketable securities (enter purchasing investments as negatives)
Ending cash balance

Cumulative Balances
	March	April	May
Bank Loan
Beginning Loan Balance	$ 0
Borrow in the month
Repay in the month (enter repayments as negatives)
Ending Loan Balance
Marketable Securities
Beginning Securities Balance	$ 2,000
Bought in the month
Sold in the month (enter sold as negatives)
Ending Securities Balance