Bank Portfolio - Round 4 As shown in the FNNA 340 course website, you are asked to adjust your bank's balance sheet to include different sources of funding and investment. In Round 4, you have expanded opportunities to lend overseas and fund operations in the Eurodollar market and in Euros. Specifically, you will now be able to 1) make and fund C\&I loans denominated in Euros and/or 2) fund your USS operations in Eurodollars. Importantly, the responses in this worksheet are what determine veur evaluation on the assignment. Refer to: 1) the instructions in this worksheet, 2) the simulation handbook for previous versions of the exercise provided to you by your instructor (in PDF), and 3) information in the text, Cecchetti, S. G. and Schoenholtz, K (5e). Moncy, Banking, and Financial Markets. In Round 4 of the Simulation, you are asked to apply the Outcome, determined by chance, to your bank's portfolio. Use the embedded Excel worksheet below to complete the assignment. To enter your values, place the cursor onto the table. Next, right click the mouse. Choose "Worksheet Object, Edit." You will want to save your work and make sure it appears in the Word document you upload. 1. Refer to your End of Round 3 Bank Balance Sheet (previous assignment). With the Outcome determined by chance, complete the spreadsheet by opening it and using the drondomn menu to determine your Bank's balance sheet at the Start of Round 4. In Round 4 you have expanded opportunities to lend overseas and fund your operations in the Eurodollar market and in foreign currencies. Specifically, you will now be able to 1) make and fund C\&I loans denominated in Euros and/or 2) fund your US\$ operations in Eurodollars. 3. Revige your asset allocation and funding source decisions for Round 4 in light of these new lending and funding alternatives and the possible outcomes ( 1 through 7 ). a. Notice that the outcomes in the LMS assume euro interest rates are not perfectly correlated with U.S. dollar interest rates. b. Observe that sourcing US\$ in the Eurodollar market is generally cheaper than sourcing dollars domestically, with the exception of an occurrence of a liquidity crisis. c. Also note that all balance sheet items are ultimately denominated in US\$ d. Open the embedded excel spreadsheet and load the items from the End of Round 3 but also make allocations in euros and Eurodollars. Make sure your balance sheet balances correctly