This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Sales
Purchases
Rent
Drawings
Wages
Jan
Feb
Mar
39500
18500
1500
2000
4900
Apr
45800
26700
1700
1000
5100
May
37600
25000
2000
1500
5500
June
52300
29500
2100
2500
4500
July
58000
25000
1900
2000
6000
Rent is paid one month in advance
30% of sales are on a cash basis, the remainder is received 1 month later
40% of purchases are on a cash basis, the remainder is paid 1 months after purchase
Wages are paid one month in arrears
The company buys a new asset with payments: £8000 in May and £8000 in June.
The company sells equipment with 2000 payment received in May and 3000 received in June
The bank balance on 1st April is 5600
April
May
June
Receipts
Sales
Cash
Credit
Equipment
Total Receipts
Payments
Purchases
Cash
Credit
Rent
Drawings
Wages
New Asset
Total Payments
Net Cash Flow
Opening Balance
Closing Balance
Reset
Print