Sales Purchases Rent Drawings Expenses Wages
Mar 5000 1200 1200 100 300 550
Apr 7000 2000 1300 150 400 600
May 6500 1700 1250 200 300 700
June 5500 500 1200 100 200 650
July 4000 800 1250 50 400 550
Rent is paid one month in advance
30% of sales are on a cash basis, the remainder is received one month later.
15% of purchases are on a cash basis, the remainder is paid two months after purchases.
Wages are paid in the same month.
The company buys a new van in June costing £3000.
The company sells equipment with £500 received in May and £200 received in June.
The bank balance on 1st April is £1000.
Prepare the cash budget for the three months ending 30th June.
`