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.)
Cash Budget | Quarter | Quarter | Quarter | Quarter | |
1st | 2nd | 3rd | 4th | Year | |
Cash balannce, beg. | $9 | ||||
Add collections from customers | 111 | 389 | |||
Total cash available | 80 | ||||
Less disbursements: | |||||
Purchase of inventory | 50 | 60 | 34 | ||
Selling/Admin. Expenses | 45 | 30 | 119 | ||
Equipment purchases | 13 | 9 | 25 | 57 | |
Dividends | 2 | 2 | 2 | 2 | |
Total disbursements | |||||
Excess (deficiency) of cash avail. over disb. | (5) | 7 | |||
Financing: | |||||
Borrowings | 16 | ||||
Repayments (including interest)* | (25) | ||||
Total Financing | |||||
Cash balance, ending | |||||
*interest will total $1000 for the year | ---------- | ---------- | ---------- | ---------- | -------- |
-Please put explanation on how you got the answer
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