. I am looking for cell references and solutions.

A B D E F G (link back to main page) Cash Budget 3 Brindle Arts had the following Cash Budget for Quarter 3, 2020: 5 IThe company requires a minimum cash balance of $ 50,000 6 Fill in the missing values: 8 July August September Quarter 3 9 Cash Balance, beginning un 176,520 $ 151,000 $ 176,520 10 Add Collections from customers 682,080 11 Total Cash Available S 858,600 887,000 $ 911,200 $ 2,295,000 12 Less Disbursements: 13 Materials Purchases S 191,100 238,875 14 Payroll $ (238,875) 110,250 116,550 315,000 15 Manufacturing OH Exp 225,125 228,275 667,500 16 Selling & Administrative Exp 154,400 163,850 17 Dividends 18 Purchase of equipment 19 Total Disbursements 647,800 761,200 20 Excess (deficiency) of cash available S 151,000 S 150,000 21 Financing: 22 Borrowings **$1,000 increments 23 Repayments 24 Interest 25 Total Financing 26 Cash Balance, ending S 150,000