plesse answer both questions and show the work for the answers. if you use excel please include formulas so I can follow. thank you

6.1 A bank has two assets outstanding, denominated in U.S. dollars. The correlation between the two assets is 0.4. Other details are as follows: Calculate the unexpected loss of each asset: EAD PD LGD A B C D OD OLR 6.2 Calculate the unexpected loss of the portfolio as well as the risk contribution of each asset: Unexpected Loss 118,350 125,800 120,000 119,308 Asset A 1,600,000 1% 30% 6% 20% SHOW YOUR WORK IN THIS QUESTION!! Risk Cont. A 18,350 102,600 98,000 29,302 Asset B 2,000,000 2% 40% 8% 25% Risk Cont. B 100,000 23,200 22,000 90,006

6.1A bank has two assets outstanding, denominated in U.S, dollars. The correlation between the two assets is 0.4, Other details are as follows: Calculate the unexpected loss of each asset: 6.2 Calculate the unexpected loss of the portiolio as well as the nisk contribution of each asset: SHOW YOUR WORK IN THIS QUESTIONI