Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.)
Quarter (000 omitted) | |||||
1 | 2 | 3 | 4 | Year | |
Cash balance, beginning | $8 | ||||
Add collections from customers | 106 | 367 | |||
Total cash available | 77 | ||||
Less disbursements: | |||||
Purchase of inventory | 45 | 55 | 29 | ||
Selling and administrative expenses | 32 | 30 | 111 | ||
Equipment purchases | 7 | 8 | 20 | 45 | |
Dividends | 2 | 2 | 2 | 2 | |
Total disbursements | 97 | ||||
Excess (deficiency) of cash available over disbursements | (2) | 9 | |||
Financing: | |||||
Borrowings | 7 | ||||
Repayments (including interest) * | (11) | ||||
Total financing | |||||
Cash balance, ending | |||||
*Interest will total $1,000 for the year. |
.
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