Please help me answer this question. I do not understand how to do it. thanks

Homework : Chapter y Homework ( required ) Score : 0.23 of 1 pt 7 of9 15 compote HW Score : 35 47 / . 3. 10 * 9 - 30 A ( similar to ) Question Help Anderson Health Center provides a variety of medical services . The company is preparing its cash budget for the upcoming third quarter . The following transactions are expected to cook @ ( Click the icon to how the expected transactions . ) Requirement Prepare a comb nod cash budget for Anderson sen Health Center for the third quarter . with a column for each month and for the quarter total ( It a box is not used in the table leave the box comply do not enter a z Bro . Use parentheses or a minus sign for negative ending cash ng cash balances ) Anderson Health Center Combined Cast Budget For the Months of July through September aginning balance of Beginning balance of cash Plus : Cash collections @ More into Total cash available Loss : Cash payments Ending cash balance before financing a . Cash co actions from services in Jay August , and September are pro acted to be $95 000 5150.090 , and $122 010 b . Cash payments for the upcoming third quarter are pro , ected to be $147 090 in July $160 090 in August and $131 090 in Plus Now borrowings September ass Debt repayments cash balance as of the first day of the third quarter is pro , coted to be $35 . d . The health center has a soloy that it must maintain a minimum cash balance of 928 000 ass Interest payments The health center has a line of credit with the local bank it at al cus it to borrow funds in months that it would not otherwise Ending cash balance Is minimum balance . If the company has more than its minimum balance at the and of any given month , it uses the excess funds to pay off any outstanding line of credit balance . Each month Anderson Health Center pays interes interest on the prior month's . no of credit ending balance . The actual interest rate that rate that the health center we pay floats since I is tied to the prime rate . However , the interest paid during the budget period is expected to be 1% of the prior month's Un's line of cred lending balance of the company did no I have an outstanding balance at the and of the prior month , then the hochn deris does not have to pay any any interest ) . All line of credit borrowings are taken or paid off on the first day of the month As of the first day of the third quarter , Anderson Health Center do not have a balance on its line of cred