Kindly help with the problem and if you can also provide the above in an excel sheet with calculations and formulae. Also, provide a text calculation if possible.

A local bank has found the following Rate Sensitive Assets and Rate Sensitive Liabilities. Item 1 day 2-8 9-30 31-180 181- days 1-5 year days days days to 1 year Deposits (in Rs. mill) 450 500 450 200 550 200 Loans (in Rs. mill) 650 600 600 400 200 350 Borrowings (in Rs. mill) 200 150 200 250 200 75 Investments (in Rs. mill) 260 250 250 150 350 120 Foreign currency borrowings (in Rs. mill) 250 250 350 350 350 160 Foreign currency loans (in Rs. mill) 250 175 150 210 125 125 a. Identify the interest sensitive gap and cumulative gap all maturity periods b. What will be the impact of interest rate up of 50 basis points, and interest rates down of 25 basis points on Net Interest Income