please type the answers in excel to make sure i dont get the wrong answer

Onshore Bank has $31 million in assets, with risk-adjusted assets of $21 million. Core Equity Tier 1 (CETcapital is $1,050,000, additional Tier I capital is $270,000, and Tier Il capital is $422,000. The current value of the CET1 ratio is 5 percent, the Tier I ratio is 6.29 percent, and the total capital ratio is 8.3 percent. Calculate the new value of CET1, Tier I, and total capital ratlos for the following transactions percent. a. The bank repurchases $111.000 of common stock with cash. b. The bank Issues $3.1 million of CDs and uses the proceeds to issue category 1 mortgage loans with a loan-to-value ratio of 70 c. The bank receives $511,000 in deposits and invests them in T-bills. d. The bank issues $811.000 in common stock and lends it to help finance a new shopping mall. The developer has an A+ credit rating e. The bank issues $2.1 million in nonqualifying perpetual preferred stock and purchases general obligation municipal bonds. f. Homeowners pay back $5.1 million of mortgages with loan-to-value ratios of 50 percent and the bank uses the proceeds to build new ATMs Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required Required The bank repurchases $111,000 of common stock with cash. (Round your answers to 2 decimates. (12.10) CET1 ratio Tier I ratio Total capital ratio % % Onshore Bank has $31 million in assets, with risk-adjusted assets of $21 million. Core Equity Tier 1 (CET) capital is $1,050,000, additional Tier I capital is $270,000, and Tier Il capital is $422,000. The current value of the CET1 ratio is 5 percent, the Tier I ratio is 6.29 percent, and the total capital ratio is 8.3 percent. Calculate the new value of CET1, Tier I, and total capital ratios for the following transactions. percent. a. The bank repurchases $111,000 of common stock with cash. b. The bank issues $3.1 million of CDs and uses the proceeds to issue category 1 mortgage loans with a loan-to-value ratio of 70 c. The bank receives $511,000 in deposits and invests them in T-bills. d. The bank issues $811,000 in common stock and lends it to help finance a new shopping mall. The developer has an A+ credit rating. e. The bank issues $2.1 million in nonqualifying perpetual preferred stock and purchases general obligation municipal bonds. f. Homeowners pay back $5.1 million of mortgages with loan-to-value ratios of 50 percent and the bank uses the proceeds to build new ATMs Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Required F The bank issues $3.1 million of CDs and uses the proceeds to issue category 1 mortgage loans with a loan-to-value ratio of 70 percent. (Round your answers to 2 decimal places. (e.g., 32.16)) CET1 ratio Tier I ratio Total capital ratio % % % ed Onshore Bank has $31 million in assets, with risk-adjusted assets of $21 million. Core Equlty Tler 1 (CET1 ) capital is $1,050,000, additional Tier I capital is $270,000, and Tier Il capital is $422,000. The current value of the CET1 ratlo is 5 percent, the Tier I ratio is 6.29 percent, and the total capital ratio is 8.3 percent. Calculate the new value of CET1, Tier , and total capital ratios for the following transactions. a. The bank repurchases $111,000 of common stock with cash. b. The bank issues $3.1 million of CDs and uses the proceeds to Issue category 1 mortgage loans with a loan-to-value ratio of 70 percent. c. The bank receives $511,000 in deposits and invests them in T-bills. d. The bank issues $811,000 in common stock and lends it to help finance a new shopping mall. The developer has an A+ credit ram e. The bank Issues $2.1 million in nonqualifying perpetual preferred stock and purchases general obligation municipal bonds. f. Homeowners pay back $5.1 million of mortgages with loan-to-value ratios of 50 percent and the bank uses the proceeds to bulle new ATMs. Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Required F The bank issues $2.1 million in nonqualifying perpetual preferred stock and purchases general obligation municipal bonds. (Round your answers to 2 decimal places. (e.9., 32.16)) CET1 ratio Tier I ratio Total capital ratio % % % He Onshore Bank has $31 million in assets, with risk-adjusted assets of $21 million. Core Equity Tier 1 (CET) capital is $1,050,000, additional Tier I capital is $270,000, and Tier il capital is $422,000. The current value of the CET1 ratio is 5 percent, the Tieti ratio is 6.29 percent, and the total capital ratio is 8.3 percent. Calculate the new value of CET1, Tier I and total capltal ratios for the following transactions a. The bank repurchases $111,000 of common stock with cash. b. The bank issues $3.1 million of CDs and uses the proceeds to issue category 1 mortgage loans with a loan-to-value ratio of 70 percent. c. The bank receives $511,000 in deposits and invests them in T-bills. d. The bank Issues $811,000 in common stock and lends it to help finance a new shopping mall. The developer has an A+ credit rating. e. The bank issues $2.1 million in nonqualifying perpetual preferred stock and purchases general obligation municipal bonds. f. Homeowners pay back $5.1 million of mortgages with loan-to-value ratios of 50 percent and the bank uses the proceeds to build new ATMs. Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required Required F Homeowners pay back $5.1 million of mortgages with loan-to-value ratios of 50 percent and the bank uses the proceeds to build new ATMS. (Round your answers to 2 decimal places. (e.g., 32.16)) % CET1 rati Tier I ratio % % Total capital ratio