Cash Budgets
monque11
6140_week_7_assignment_template_2017.docx6140 Week 7 assignment template
|
|
|
October (actual) |
November (actual) |
December (actual) |
|
January |
February |
March |
|
Expected sales |
|
$300,000 |
$325,000 |
$450,000 |
|
$310,000 |
$350,000 |
$400,000 |
|
Cash receipts: |
|
|
|
|
|
|
|
|
|
Cash sales |
0% |
|
|
|
|
0 |
0 |
0 |
|
Collection from sales: |
|
|
|
|
|
|
|
|
|
One month ago |
60% |
|
|
|
|
270000 |
186000 |
|
|
Two months ago |
25% |
|
|
|
|
81250 |
|
|
|
Three months ago |
10% |
|
|
|
|
30000 |
|
|
|
Bad debts |
5% |
|
|
|
|
|
|
|
|
|
100% |
|
|
|
|
381250 |
|
|
|
Other cash receipts |
|
|
|
|
|
|
20000 |
4000 |
|
Beginning of month cash |
|
|
|
|
|
14000 |
10750 |
10000 |
|
Total cash available |
|
|
|
|
|
395250 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash disbursements: |
|
|
|
|
|
|
|
|
|
Materials |
|
|
|
|
|
92500 |
|
|
|
Labor and wages |
|
|
|
|
|
|
|
|
|
Selling costs |
|
|
|
|
|
|
|
|
|
G & A costs |
|
|
|
|
|
|
|
|
|
Income taxes |
|
|
|
|
|
|
|
|
|
Capital equipment |
|
|
|
|
|
50000 |
|
|
|
Interest expense |
|
|
|
|
|
|
|
|
|
Total cash disbursements |
|
|
|
|
|
384500 |
|
|
|
Ending cash balance (deficiency) before borrowings/ (repayments) or (investments)/redemptions |
|
|
|
|
|
10750 |
|
|
|
Bank borrowings/(repayments) (investments)/redemptions |
|
|
|
|
|
|
|
|
|
Ending cash balance (deficiency) |
|
|
|
|
|
10750 |
|
|
