1 and 2 please

in Microsoft Excel in order to be considered for full credits. Please name your Excel Your FirstName Last Name final.xlsx. Please bear in mind the academic honesty code Good luck! 1. A bank has an average asset duration of 2.25 years, the average duration of the 1 1.25 years, and the bank has total assets of $2 billion and $200 million in equity. TH a ROE of 9.00 percent. If all interest rates decrease 50 basis points, find the predic in the bank's market value of equity (in percentage terms). A bank has DA = 2.4 years and Du= 0.9 years. The bank has total equity of $82 total assets of $850 million. Interest rates are at 6 percent. If interest rates increa points, find the predicted dollar change in equity value in dollars. An insurance line has a loss ratio of 72 percent and an expense ratio of 35 percent ays 2 percent of premiums to policyholders as dividends. Find out the level Feld needed to make the P&C firm break even? a investor has a 38 percent ordinary income tax rate and a 20 percent long-terr rate. The investor holds stock in a firm that could pay its usual $1 ner sha vest the cash in the firm TL in Microsoft Excel in order to be considered for full credits. Please name your Excel Your FirstName Last Name final.xlsx. Please bear in mind the academic honesty code Good luck! 1. A bank has an average asset duration of 2.25 years, the average duration of the 1 1.25 years, and the bank has total assets of $2 billion and $200 million in equity. TH a ROE of 9.00 percent. If all interest rates decrease 50 basis points, find the predic in the bank's market value of equity (in percentage terms). A bank has DA = 2.4 years and Du= 0.9 years. The bank has total equity of $82 total assets of $850 million. Interest rates are at 6 percent. If interest rates increa points, find the predicted dollar change in equity value in dollars. An insurance line has a loss ratio of 72 percent and an expense ratio of 35 percent ays 2 percent of premiums to policyholders as dividends. Find out the level Feld needed to make the P&C firm break even? a investor has a 38 percent ordinary income tax rate and a 20 percent long-terr rate. The investor holds stock in a firm that could pay its usual $1 ner sha vest the cash in the firm TL