Sales Purchases Rent Drawings Expenses Wages
Mar 4500 900 900 90 250 600
Apr 5400 850 850 50 350 620
May 6200 1200 1200 120 400 650
June 5900 900 1100 200 400 700
July 4600 1100 1000 170 240 670
Rent is paid one month in advance and will remain constant after July until the end of the year.
20% of sales are on a cash basis, the remainder is received one month later.
30% of purchases are on a cash basis, the remainder is paid two months after purchases.
Wages are paid one month in arrears.
The company buys a new van paying £2000 in June and £3000 in July
The company sells its old van receiving £600 in May and £1000 in June from the buyer.
The bank balance on 1st May is £2300
Q1) How much rent will be paid in the following months:
May June July
Q2) How much will be paid in wages in the following months:
May June July
Q3) How much will be received through sales in the following months:
May June  July
Q4) How much in total will be received in the following months:
May  June July
Q5) How much will be paid out in purchases in the following months:
May June July
Q6) How much will be spent on buying a new van in the following months:
May June July
Q6) How much will be paid out in total in the following months (include drawings, expenses, etc):
May June July
Q7) What is the net cash flow for the following months:
May June July
Q8) What is the bank balance at the start of each month?
May June July
Q9) What is the bank balance at the end of each month?
May June July