Bill's Stereo Shop wants to borrow $50,000 from April 1st. until April 30th. It sales equipment in an area where its typical customer is a member of the armed services or a veteran. Prepare a cash budget for Bill's Stereo Shop for April using the following data:

a. March 30th. cash balance $5,000

b. Merchandise purchases: $50,000 in February, and $55,000 in March. (Bill's history suggests that 50% of purchases is paid in cash 30 days after purchase and 50% is paid in 60 days after purchase.

c. Merchandise sales: $100,000 in February, and $125,000 in March.

Side Note for c. (All sales are 20% of the sales are collected in 60 days. The other 5% are never collected.)

d. Interest on bank loan $1,000

e. Bill's expects sequestration to cause somewhere between 5% and 10% of additional customers not to pay.