A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $4,000 to start each quarter. Required: Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign. Quarter (000 omitted) (000 omitted) Year 2 3 Cash balance, beginning $ $ 5 $ Add collections from customers 63 95 108 Total cash available 69 100 Less disbursements: 369 375 Purchase of inventory 47 57 31 Selling and administrative expenses 15 32 30 98 Equipment purchases 10 9 22 51 Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings 2 2 2 74 100 (5) Repayments (including interest) Total financing Cash balance, ending (13)

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 18E
icon
Related questions
icon
Concept explainers
Question
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of
$4,000 to start each quarter.
Required:
Fill in the missing amounts.
Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.
Quarter (000 omitted)
2
3
(000 omitted)
Year
Cash balance, beginning
$
$
5 $
$
$
6
Add collections from customers
63
95
108
369
Total cash available
69
100
375
Less disbursements:
Purchase of inventory
47
57
31
Selling and administrative expenses
15
32
30
98
Equipment purchases
10
9
22
51
Dividends
Total disbursements
Excess (deficiency) of cash available over disbursements
Financing:
Borrowings
Repayments (including interest)*
Total financing
2
2
2
2
74
100
(5)
(13)
Cash balance, ending
$
"Interest will total $1,000 for the year.
Transcribed Image Text:A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $4,000 to start each quarter. Required: Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign. Quarter (000 omitted) 2 3 (000 omitted) Year Cash balance, beginning $ $ 5 $ $ $ 6 Add collections from customers 63 95 108 369 Total cash available 69 100 375 Less disbursements: Purchase of inventory 47 57 31 Selling and administrative expenses 15 32 30 98 Equipment purchases 10 9 22 51 Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest)* Total financing 2 2 2 2 74 100 (5) (13) Cash balance, ending $ "Interest will total $1,000 for the year.
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub