Question: A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.)
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.)
| Cash Budget |
|
| Quarter (000 omitted) |
|
| ||
|
|
| 1 |
| 2 | 3 | 4 | Year |
| Cash balance, beginning | $ |
| 9 |
|
|
|
|
| Add collections from customers |
|
| 71 |
| 111 |
| 389 |
| Total cash available |
|
| 80 |
|
|
|
|
| Less disbursements: |
|
|
|
|
|
|
|
| Purchase of inventory |
|
| 50 | 60 |
| 34 |
|
| Selling and administrative expenses |
|
|
| 45 | 30 |
| 119 |
| Equipment purchases |
|
| 13 | 9 | 25 |
| 57 |
| Dividends |
|
| 2 | 2 | 2 | 2 |
|
| Total disbursements |
|
|
| 116 |
|
|
|
| Excess (deficiency) of cash available over disbursements |
|
| (5) |
| 7 |
|
|
| Financing: |
|
|
|
|
|
|
|
| Borrowings |
|
|
| 16 |
|
|
|
| Repayments (including interest) * |
|
|
|
|
| (25) |
|
| Total financing |
|
|
|
|
|
|
|
| Cash balance, ending |
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
