tried to solve but very confusing

The following schedule shows the excess of cash receipts over cash disbursements projected for the Zoptic Company for 2021 01 02 Q 04 Year Excess (deficiency) of cash available over disbursements $(135,300) $(53,680) $139,780 $54,300 $5,100 The company borrows and repays from an open line of credit in round $100 amounts, Loan related payments are made in periods when cash is available with interest paid on only the portion of any principal being repaid. The current balance (principal plus accrued Interest) in the line of credit account is $3,640 for the borrowing that occurred in the last quarter of the previous year. The annual interest rate is 16% A minimum cash reserve of $600 must be maintained each quarter. The opening balance for the year is expected to be $1700 Required: Prepare a cash budget for each quarter and for the year in total and calculate the annual interest expense on the line of credit that would appear on the budgeted income statement for the year 2021 (Any "Repayments" and "Interest" should be indicated by a minus sign.) 04 Year ZOPTIC COMPANY Cash Budget For the Year Ended December 31, 2021 01 02 Cash balance beginning $ 1.700 s 800S Excess deficiency of cash ble over de bursement (185,300) (53.600) Cash balance before reserve requirement (133 800) 153 080) Deduct Minimum required reserve 000 300 Balance available for repayment required borrowing $ 434 2001 (53680s Financing Atout bonowod boginning of period) (134 2001 (53680) Q3 8007 s 139.780 140 380 60075 54 300 54.900 800 543001s 1.700 5.100 6.800 600 +000 139.7807 6.200 12413