leadership and management materials with questions
Bader2012
CashFlowExercise.docxCash Flow for Period Ended:
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
Receipts |
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Sales (inclusive of GST) |
1000 |
1200 |
|
|
|
|
|
|
|
|
|
|
|
Credit Sales |
11645 |
11895 |
|
|
|
|
|
|
|
|
|
|
|
Total Cash Receipts |
12645 |
13095 |
|
|
|
|
|
|
|
|
|
|
|
Payments (inclusive of GST) |
|
|
|
|
|
|
|
|
|
|
|
|
|
Purchases |
5500 |
6000 |
|
|
|
|
|
|
|
|
|
|
|
New Plant and equipment |
|
|
|
|
2200 |
2200 |
|
|
|
|
|
|
|
General expenses |
1100 |
1100 |
|
|
|
|
|
|
|
|
|
|
|
Company Tax |
|
|
700 |
|
|
700 |
|
|
700 |
|
|
700 |
|
Wages (GST free) |
3200 |
3200 |
|
|
|
|
|
|
|
|
|
|
|
GST BAS transfer payments (quarterly) from worksheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Cash Payments |
9800 |
10300 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash at Bank |
|
|
|
|
|
|
|
|
|
|
|
|
|
Opening Balance |
-1000 |
1845 |
4640 |
|
|
|
|
|
|
|
|
|
|
TC Receipts - TC Payments |
2845 |
2795 |
|
|
|
|
|
|
|
|
|
|
|
Closing Balance |
1845 |
4640 |
|
|
|
|
|
|
|
|
|
|
