CAN SOMEONE SOLVE THIS

Q1. A bank is planning to make a loan of $4,800,000 to a firm in the steel industry. It expects to charge a servicing fee of 67 basis points. The loan has a maturity of 8.7 years with a duration of 5.35 years. The cost of funds (the RAROC benchmark) for the bank is 10.8 percent. The bank has estimated the maximum change in the risk premium on the steel manufacturing sector to be approximately 5.8 percent, based on two years of historical data. The current market interest rate for loans in this sector is 10 percent. ( 15 marks) a? Using the RAROC model, determine whether the bank should make the loan. b. What should be the duration in order for this loan to be approved? c. Assuming that the duration cannot be changed, how much additional interest and fee income will be necessary to make the loan acceptable? d. Given the proposed income stream and the negotiated duration, what adjustment in the loan rate would be necessary to make the loan acceptable