looking for a step by step solution not done on excel please. it would help a lot

Assets $ 30 53 133 16 $ 232 Use the data provided for Gotbucks Bank, Incorporated, to answer this question. Gotbucks Bank, Incorporated. (dollars in millions) Liabilities and Equity Cash $ 33 Core deposits Federal funds 23 Federal funds Loans (floating) 108 Euro CDs Loans (fixed) 68 Equity Total assets $ 232 Total liabilities and equity Notes to the balance sheet Currently, the fed funds rate is 8,8 percent. Variable-rate loans are priced at 4 percent over LIBOR (currently at 11 percent). Fixed-rate loans are selling at par and have five-year maturities with 12 percent interest paid annually. Assume that fixed rate loans are non-amortizing. Core deposits are all fixed rate for two years at 8 percent pald annually. Euro CDs currently yield 9 percent a. What is the duration of Gotbucks Bank's (Gel) fixed-rate loan portfolio of the loans are priced at par? (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g., 32.161)) b. If the average duration of Ger's floating-rate loans (including fed fund assets) is 0.39 year, what is the duration of the bank's assets? (Note that the duration of cash is zero.) (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g.. 32.161)) c. What is the duration of Gel's core deposits if they are priced at pur? (Do not round Intermediate calculations. Round your answer to 3 decimal places. (0.9.32.161)) d. If the duration of GBI's Euro CDs and fed fund liabilities is 0.404 year, what is the duration of the bank's liabilities? (Do not round Intermediate calculations. Round your answer to 4 decimal places. (e.g., 32.1616)) e-1. What is GBI's duration gap? (Do not round intermediate calculations. Round your answer to 4 decimal places. (e.g., 32.1616)) e-2. What is the expected change in equity value if all yields increase by 200 basis points? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest dollar amount.) e-3. Given the equity change in e-2, what is the expected new market value of equity after the interest rate change? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign. Do not round intermediate calculations, Round your answer to the nearest dollar amount.) a b 4.037 years 1.403 years 1.926 years c d Duration Duration (assets) Duration (deposits) Duration (labilities Duration gap Expected change in equity value New market value years years 02 0-3 Assets $ 30 53 133 16 $ 232 Use the data provided for Gotbucks Bank, Incorporated, to answer this question. Gotbucks Bank, Incorporated. (dollars in millions) Liabilities and Equity Cash $ 33 Core deposits Federal funds 23 Federal funds Loans (floating) 108 Euro CDs Loans (fixed) 68 Equity Total assets $ 232 Total liabilities and equity Notes to the balance sheet Currently, the fed funds rate is 8,8 percent. Variable-rate loans are priced at 4 percent over LIBOR (currently at 11 percent). Fixed-rate loans are selling at par and have five-year maturities with 12 percent interest paid annually. Assume that fixed rate loans are non-amortizing. Core deposits are all fixed rate for two years at 8 percent pald annually. Euro CDs currently yield 9 percent a. What is the duration of Gotbucks Bank's (Gel) fixed-rate loan portfolio of the loans are priced at par? (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g., 32.161)) b. If the average duration of Ger's floating-rate loans (including fed fund assets) is 0.39 year, what is the duration of the bank's assets? (Note that the duration of cash is zero.) (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g.. 32.161)) c. What is the duration of Gel's core deposits if they are priced at pur? (Do not round Intermediate calculations. Round your answer to 3 decimal places. (0.9.32.161)) d. If the duration of GBI's Euro CDs and fed fund liabilities is 0.404 year, what is the duration of the bank's liabilities? (Do not round Intermediate calculations. Round your answer to 4 decimal places. (e.g., 32.1616)) e-1. What is GBI's duration gap? (Do not round intermediate calculations. Round your answer to 4 decimal places. (e.g., 32.1616)) e-2. What is the expected change in equity value if all yields increase by 200 basis points? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest dollar amount.) e-3. Given the equity change in e-2, what is the expected new market value of equity after the interest rate change? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign. Do not round intermediate calculations, Round your answer to the nearest dollar amount.) a b 4.037 years 1.403 years 1.926 years c d Duration Duration (assets) Duration (deposits) Duration (labilities Duration gap Expected change in equity value New market value years years 02 0-3