A bank has DA $=3$ years, DL $=0\mathrm{.}5$ years and k $=92\%.$ Assets are equal to $$500$ million. According to the duration gap model, what size interest rate change would make the institution insolvent if rates are currently $8\%?$

Ans: $+340$ basis points

do it in excel please