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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started