Answer using Excel, and show formulas please.

Answer the following questions related to the lecture on bond duration and immunization a. Suppose a bank has $2 billion in assets and $1 billion in liabilities. Suppose the duration of assets is 5 years and of liabilities is 0.5 years. By much should the duration of assets be reduced such that its equity is immunized. b. Use the following bond information and calculate the convexity of this bond. (Try not to use the direct convexity formula, use the duration approximation method) i. Coupon rate 9% ii. Maturity -6.5 years iii. Frequency - Semi Annual iv. Yield 3% v. Face Value -1000 Answer the following questions related to the lecture on bond duration and immunization a. Suppose a bank has $2 billion in assets and $1 billion in liabilities. Suppose the duration of assets is 5 years and of liabilities is 0.5 years. By much should the duration of assets be reduced such that its equity is immunized. b. Use the following bond information and calculate the convexity of this bond. (Try not to use the direct convexity formula, use the duration approximation method) i. Coupon rate 9% ii. Maturity -6.5 years iii. Frequency - Semi Annual iv. Yield 3% v. Face Value -1000