A cash budget, by quarters, is given below for a retail company (000 omitted). T
ID: 2557457 • Letter: A
Question
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.) 3 Answer is complete but not entirely correct. Cash Budget Quarter (000 omitted) Year Cash balance, beginning 80 104 100 370 869109 105 376 Add collections from customers Total cash available Less disbursements Purchase of inventory Selling and administrative expenses Equipment purchases 43 180 22118 1051 53 3432 15 30 18 Total disbursements Excess (deficiency) of cash available over disbursements 94 959 69357 36 19 (4)0 13 (18 (23) 130 9 (5) (18) Total financing Cash belance, ending Interest will total $1,000 for the year 18 6 9Explanation / Answer
Answer
Working Equation Column
Q1
Q2
Q3
Q4
Year
A
Cash Balance, beginning
6
5
5
5
6
B
Add: Collection from customers
80
86
104
100
370
C=A+B
Total cash available
86
91
109
105
376
Less: Disbursement
D
Purchase of Inventory
43
53
49
35
180
E
Selling & Administrative expenses
34
32
30
22
118
F
Equipment purchases
15
8
18
10
51
G
Dividends
2
2
2
2
8
H=D+E+F+G
Total Disbursements
94
95
99
69
357
I=C-H
Excess (deficiency) of cash available over disbursements
-8
-4
10
36
19
Financing:
J
Borrowings
13
9
0
0
22
K
Repayments (including interest)
0
0
-5
-18
-23
L=J+K
Total Financing
13
9
-5
-18
-1
M=I+L
Cash Balance, ending
5
5
5
18
18
Working Equation Column
Q1
Q2
Q3
Q4
Year
A
Cash Balance, beginning
6
5
5
5
6
B
Add: Collection from customers
80
86
104
100
370
C=A+B
Total cash available
86
91
109
105
376
Less: Disbursement
D
Purchase of Inventory
43
53
49
35
180
E
Selling & Administrative expenses
34
32
30
22
118
F
Equipment purchases
15
8
18
10
51
G
Dividends
2
2
2
2
8
H=D+E+F+G
Total Disbursements
94
95
99
69
357
I=C-H
Excess (deficiency) of cash available over disbursements
-8
-4
10
36
19
Financing:
J
Borrowings
13
9
0
0
22
K
Repayments (including interest)
0
0
-5
-18
-23
L=J+K
Total Financing
13
9
-5
-18
-1
M=I+L
Cash Balance, ending
5
5
5
18
18
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.