Quarter (000 omitted) | (000 omitted) | ||||
1 | 2 | 3 | 4 | Year | |
Cash balance, beginning | 6 | 5 | 5 | 11 | 6 |
Add: Collections from customers | 65 | 70 | 96 | 92 | 323 |
Total cash available | 71 | 75 | 101 | 103 | 329 |
Less: Disbursements: | |||||
Purchase of inventory | 35 | 45 | 48 | 35 | 163 |
Selling and administrative expense | 28 | 30 | 30 | 25 | 113 |
Equipment purchase | 8 | 8 | 10 | 10 | 36 |
Dividends | 2 | 2 | 2 | 2 | 8 |
Total disbursements | 73 | 85 | 90 | 72 | 320 |
Excess(deficiency) of cash available over disbursements | -2 | -10 | 11 | 31 | 9 |
Financing: | |||||
Borrowings | 7 | 15 | 22 | ||
Repayments (including interest) | -17 | -17 | |||
Total financing | |||||
Cash balance, ending | 5 | 5 | 11 | 14 | 14 |
Explanation:
Calculations made as per the following bases.
Beg. Cash balance + Collections from customers = Total cash available
Sum of disbursements should be 'Total disbursements'
Total cash available - total disbursements = Excess (deficiency) of cash
Deficiency + Minimum cash balance = Borrowing
In the 4th quarter,
Collections from customers, Selling and administrative expense and equipment purchase brought down by deducting 1st, 2nd and 3rd quarter's amount from Total amount which is already given.
A cash budget, by quarters, is given below for a retail company (000 omitted). The company...
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $8,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.) Quarter (000 omitted) (000 omitted) Year Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends...
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $10,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.) Quarter (000 omitted) (000 omitted) 3891 6034 45 301 9 251 119 Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling...
A cash budget, by quarters, is given below for a retail company
(000 omitted). The company requires a minimum cash balance of at
least $4,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.)
Quarter (000 omitted) 2 3 1000 omitted) Year 1 4 Cash balance, beginning Add collections from customers 108 369 Total cash available Less disbursements: 57 | 31 |...
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) 2 3 1 4 Year 113 391 72 Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory...
A cash budget, by quarters, is given below for retail
company (000 omitted) The company requires a minimum cash balance
of at least 6,000 to start each quarter. fill in the missing
amounts. ( enter your answers in thousands of dollars. Cash
deficiencies in repayments should be indicated by a minus
sign.)
Quarter (000 omitted) (000 omitted) Year S 8 325 ol LE37 47 30 10 2 103 9 12 2 2 Cash balance, beginning Add collections from customers Total...
A cash budget, by quarters, is given below for a retail company
(000 omitted). The company requires a minimum cash balance of at
least $3,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.)
Quarter (000 omitted) 1 2 Year Cash balance, beginning Add collections from customers Total cash available Less disbursements: $ 9 $ 3 3 $ 3 $ 9 77...
A cash budget, by quarters, is given below for a retail company
(000 omitted). The company requires a minimum cash balance of at
least $4,000 to start each quarter. Fill in the missing
amounts.
Quarter (000 omitted) 2 Year Cash balance, beginning Add collections from customers Total cash available Less disbursements 7 109 392 89 Purchase of inventory Selling and administrative expenses Equipment purchases Dividends 48 58 32 30 23 2 45 127 53 2 2 2 Total disbursements Excess...
A cash budget, by quarters, is given below for a retail company
(000 omitted). The company requires a minimum cash balance of at
least $4,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.)
Quarter (000 omitted) 1 2 3 4 Year Cash balance, beginning Add collections from customers Total cash available 7 109 392 89 Less disbursements: Purchase of inventory 48...
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.)
1 - $ Cash balance, beginning Add collections from customers Total cash available Less disbursements: Quarter (000 omitted) (000 omitted) 2 3 4 Year 61 $ 5 $...