Exercise 1010 Cash Budget Analysis, Managerial Accounting, Asia Global Edition, 2e by Garisson, Noreen, Brewer, Cheng, Yuen.

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.

Required:

Fill in the missing amounts in the above table.

Quarter 1 4 Year 6 96 323 Total cash available 71 Less Disbursements: 35 35 45 30 8 30 10 113 36 8 85 Excess (deficiency) of cash available Financing 15 (17) Repayments (including interest)* Total financing Cash balance, ending nterest will total $1,000 for the year