1. A bank has two, 3-year commercial loans with a present value of $70 million. The first is a $30 million loan that requires a single payment of $37.8 million in 3 years, with no other payments until then. The second is for $20 million. It requires an annual interest payment of $1.6 million. The principal of $20 million is due in 3 years. a. Using excel calculate the duration the duration of the bank's commercial loan portfolio interest rates is 9%? b. What will happen to the value of its portfolio if the general level of interest rates increased from 9% to 9.5%? t CR FV i t CF PV OFCF weight tipy of ctbond price 1 2 3 Total 0.00 0.0 0.00