it is solved but I don't know how it is solved can you explain it ?

Problem 3: As the new analytics hire at First Band \& Trust, you have been asked to conduct an analysis of the bank's mortgage loans. The data includes the customer's name, the loan date, loan amount, loan duration (in years), Annual Percentage Rate (APR), number of completed payments by the customer (all loans are paid monthly), and the date in which the loan will be fully paid. Note that if the date is in the past, e.g., in a previous year, it means the loan has been paid off. a. For each loan, calculate the amount of interest paid to date. Place your answer in cell H5. Auto-fill the column. You should not hard-code any values in your formula. b. For each Ioan, calculate the amount of principal paid to date. Place your answer in cell 15. Auto-fill the column. You should not hard-code any values in your formula. c. Calculate the loan balance. Place your answer in cell J5. The bank is considering making refinancing offers to customers with outstanding loans, e.g., loans that have not been fully paid yet. The messages will focus on two themes: 1. Offering a 1% drop on the customer's Loan APR 2. Suggesting that customers pay an additional $150 monthly d. Create a refinancing message that states "We can offer you a new loan with a 1% drop in interest. Your new loan will have payments of: new loan payment over loan term years." Problem 3: As the new analytics hire at First Band \& Trust, you have been asked to conduct an analysis of the bank's mortgage loans. The data includes the customer's name, the loan date, loan amount, loan duration (in years), Annual Percentage Rate (APR), number of completed payments by the customer (all loans are paid monthly), and the date in which the loan will be fully paid. Note that if the date is in the past, e.g., in a previous year, it means the loan has been paid off. a. For each loan, calculate the amount of interest paid to date. Place your answer in cell H5. Auto-fill the column. You should not hard-code any values in your formula. b. For each Ioan, calculate the amount of principal paid to date. Place your answer in cell 15. Auto-fill the column. You should not hard-code any values in your formula. c. Calculate the loan balance. Place your answer in cell J5. The bank is considering making refinancing offers to customers with outstanding loans, e.g., loans that have not been fully paid yet. The messages will focus on two themes: 1. Offering a 1% drop on the customer's Loan APR 2. Suggesting that customers pay an additional $150 monthly d. Create a refinancing message that states "We can offer you a new loan with a 1% drop in interest. Your new loan will have payments of: new loan payment over loan term years