| TASK. 2 J Smith Cash Budget 2011 | ||||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |||
| Receipts | ||||||||||||||
Opening balance | -1160 | |||||||||||||
Cash sales | 1400 | 1400 | 1150 | 1150 | 1150 | 1150 | 1150 | 1150 | 1150 | 1150 | 1150 | 1150 | ||
Debtors | 900 | 900 | 650 | 650 | 650 | 650 | 650 | 650 | 650 | 650 | 650 | |||
| Total receipts for month | 240 | 2300 | 2050 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | ||
| Payments | ||||||||||||||
Car credit agreement | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | ||
Petrol | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | ||
Insurance and breakedown cover | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | ||
Car tax | 100 | |||||||||||||
Wages | 1300 | 1300 | 1300 | 1300 | 1300 | 1300 | 1300 | 1300 | 1300 | 1300 | 1300 | 1300 | ||
Advertising | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | ||
| Total Payments | 1610 | 1610 | 1610 | 1710 | 1610 | 1610 | 1610 | 1610 | 1610 | 1610 | 1610 | 1610 | ||
| Summery of bank account | ||||||||||||||
Net cashflow | -1370 | 690 | 440 | 90 | 190 | 190 | 190 | 190 | 190 | 190 | 190 | 190 | ||
Bank balance (overdraft) at beginning | 0 | -1370 | -680 | -240 | -150 | 40 | 230 | 420 | 610 | 800 | 990 | 1180 | ||
| Bank balance (overdraft) at end of month | -1370 | -680 | -240 | -150 | 40 | 230 | 420 | 610 | 800 | 990 | 1180 | 1370 | ||
