Please help I can't figure out the formula's

3rd Qtr. 4th Qtr. 2nd Qtr. 670000 450000 410000 430000 470000 480000 0.03 4 The Tracey Company is a retailer that is preparing its budget for the upcoming fi 5 summary of its budgeted cash flows: 1st Otr. 7 Total cash receipts 340000 8 Total cash disbursements 530000 9 10 Beginning cash balance, 1st quarter 50000 11 Minimum cash balance required 30000 12 Quarterly interest rate on borrowings 13 If nothing is req'd in a financing cell 0 14 15 The company requires a minimum cash balance of $30,000. The company may be 16 and may repay its loans, or any part of its loans, and the END of any quarter. Inte 17 it is repaid. Repayments of principal and interest should be shown as NEGATIVE 18 19 Required: PLEASE, PLEASE, PLEASE read all of the stuff on this page. 20 Prepare the company's cash budget for the upcoming fiscal year in the spaces be 21 reference. (Hint: We need to borrow in the first quarter and we have enough to 22 Look at the formulas that I did in the pinkish cells. You do not need to change th 23 Formulas and/or cell references must be used for the yellow cells. Repayments 24 1st Quarter 25 Cash balance, beginning =B10 26 Total cash receipts 340000 27 Total cash available =B25+B26 28 Total cash disbursements -530000 29 Excess (deficiency) of cash 30 available over cash disbursements 31 Financing: 32 Borrowings (at beginning of qtr.) 170000 33 (Repayments) (at end of qtr.) =B13 34 (Interest) =B13 35 Total financing =SUM(B32:B34) 2nd Quarter =B36 670000 =E25+E26 -450000 3rd Quarter =E36 410000 =H25+H26 -430000 4th Quarter =H36 470000 =K25+K26 -480000 =E27+E28 (A) =B13 =B32 =E33*3%*2 =SUM(E32:E34) (B) (C) =B13 =B13 =B13 =SUM(H32:H34) =B13 =B13 =B13 =SUM(K32:K34) =B30+B35 =E30+E35 =H30+H35 =K30+K35 36 Cash balance, ending 37 38 39 HINTS: (A) This formula will be