TASK 1. J Smith Cash Budget For 2010 | ||||||||||||
Receipts | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
Capital introduced | 1500 | |||||||||||
Cash sales | 850 | 850 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 |
Debtors | 750 | 750 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | |
Sales of assets (training kit) | ||||||||||||
Total receipts | 2350 | 1600 | 1350 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1150 | 1100 |
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 Breakdown cover | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
Car Tax | 100 | |||||||||||
New set of kit | 250 | |||||||||||
Wages | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 |
Advertising last 3 months | 100 | 100 | 100 | |||||||||
Renew membership | 40 | |||||||||||
Total payments | 1310 | 1310 | 1310 | 1410 | 1310 | 1310 | 1310 | 1310 | 1310 | 1410 | 1700 | 1410 |
Summary of bank account | ||||||||||||
Net cash flow | 1040 | 290 | 40 | -310 | -210 | -210 | -210 | -210 | -210 | -310 | -550 | -310 |
Bank balance (overdraft) at beginning of month | 0 | 1040 | 1330 | 1370 | 1060 | 850 | 640 | 430 | 220 | 10 | -300 | -850 |
Bank balance (overdraft) at end of month | 1040 | 1330 | 1370 | 1060 | 850 | 640 | 430 | 220 | 10 | -300 | -850 | -1160 |