Prepare a Cash forecast for the below information

The sales and purchases for Ahemba Ltd are as follows:

Month April May June

Credit Sales $160,000 $140,000 $192,000

Credit Purchase $ 68,000 $64,000 $80,000

The company will pay wages of $8,000, $7,000 and $8,400 in April, May and June respectively. Interest payments are 3,000 per month during the period. The company will purchase equipment costing $50,000 and $4,000 in June. Ahemba Ltd estimates that 10% of its sales will be collected in the month of the sales; and the rest of its sales will be collected in the following month. Purchases on trade accounts will be paid in the month following the purchase. In March the sales were $180,000. The company has $20,000 cash at the end of March and normally keeps $10,000 minimum cash balance each month against contingencies.