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 in the table.(Enter your answers in thousands of dollars. Show deficiencies, repayments, and total financing preceded by a minus sign when appropriate. Enter all other amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) |
Quarter (000 omitted) | |||||
1 | 2 | 3 | 4 | Year | |
Cash balance, beginning | $6 | $ | $ | $ | $ |
Add collections from customers | 96 | 323 | |||
Total cash available | 71 | ||||
Less disbursements: | |||||
Purchases of inventory | 35 | 45 | 35 | ||
Operating expenses | 30 | 30 | 113 | ||
Equipment purchases | 8 | 8 | 10 | 36 | |
Dividends | 2 | 2 | 2 | 2 | |
Total disbursements | 85 | ||||
Excess (deficiency) of cash available over disbursements | -2 | 11 | |||
Financing: | |||||
Borrowings | 15 | ||||
Repayments (including interest)* | -17 | ||||
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