Question: table [ [ , ] , [ Outcome , ] , [ , Start of Round 4 ] , [ Allocation , 1 ]

\table[[,],[Outcome,],[,Start of Round 4],[Allocation,1],[Income,Expense],[Cash,$ 315850.00],[0.00%,$ -],[$ -,Securities],[$ 756394.27,0.25%],[$ 1890.99,$ -],[Consumer Loans,$ 4000000.00],[6.00%,$ 240000.00],[$ -,Residential Mortgage],[$ 4000000.00,2.00%],[$ 80000.00,$ -],[C&I,$ -],[3.00%,$ -],[$ -,Total Loans],[$ 8000000.00,],[,],[Deposits,$ 6000000.00],[2.00%,$ -],[$ 120000.00,Borrowed],[$ 6000000.00,1.00%],[$ -,$ 60000.00],[Total Financing,$ 12000000.00],[,],[,Total Income and Expense],[,],[$ 321890.99,$ 180000.00],[Retained Earnings,$ 72244.27],[,],[,],[,],[,],[Balance Sheet: End of Round 3,],[,],[,Assets],[Liabilities & Equity,],[,],[Cash,$ 455850.00],[Deposits,$ 6000000.00],[,Securities],[$ 758285.26,Borrowed],[$ 6000000.00,],[Lending,],[Total Liabilities,$ 12000000.00],[,Cons.Loans*],[$ 4000000.00,],[,],[Residential Mortgage*,$ 4000000.00],[Comm Stock,$ 1000000.00],[,C(&)/(*)],[$ -,Ret Earnings],[$ 214135.26,],[Total Lending,$ 8000000.00],[Total Equity,$ 1214135.26],[,],[,],[,],[Total Assets,$ 9214135.26],[Total L&E,$ 13214135.26],[,],[,],[,]] 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. Revise 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.
\ table [ [ , ] , [ Outcome , ] , [ , Start of

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!