Please provide excel formulas. Thank you

2.11 Calculate the loan interest for each month. a. The loan interest is equal to the loan balance for that month times the monthly interest rate in cell (3). b. This calculation will create a circular reference. Configure Excel to appropriately handle the circular reference. c. Reuse your formula to complete the loan interest for each month. (2.12 Calculate the line of credit needed. a. The line of credit needed is the credit limit the company needs to negotiate with the bank. b. It is calculated as the maximum loan balance that the company expects to carry over the course of the six month period