Question

Need help figuring out the question(s) i am getting wrong.

A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $10,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.) (000 omitted) Year 1 4 $ Quarter (000 omitted) 2 3 91 $ 10 $ 10 111 80 $ 10 [ 389 50 60 34 30 9 13 2 2 5 2 21 Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments including interest) * Total financing Cash balance, ending *Interest will total $1,000 for the year. 2 116 (30)

Answer 1

Cash Budget

	1	2	3	4	Year
Cash balance, Beginning	9	10	10	10	9
Add: Collection from customers	71	100	111	107	389
Total cash available	80	110	121	117	398
Less: Cash disbursement
Purchase of inventory	50	60	52	34	196
Selling and administrative expense	20	45	30	24	119
Equipment purchase	13	9	25	10	57
Dividends	2	2	2	2	8
Total disbursements	85	116	109	70	380
Excess (deficiency) of cash available over disbursement	-5	-6	12	47	18
Financing
Borrowings	15	16			31
Repayments (including interest)			-2	-30	-32
Total financing	15	16	-2	-30	-1
Cash balance ending	10	10	10	17	17