As shown in the FINA 340 course website, you are asked to adjust your bank's balance...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As shown in the FINA 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 your 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). Money, 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 drop down menu to determine your Bank's balance sheet at the Start of Round 4. Start of Round 4 Cash Securities Consumer Loans Residential Mortgage C&I Total Loans Deposits Borrowed Total Financing Total Income and Expense Retained Earnings Cash Securities Lending Cons. Loons" Residential Mortgage C&I Tocal Lending Total Assets Allocation S 137,900.00 $ 4,852,100.00 S 333,504.00 S 333,504.00 $ 333,503.00 $ 1,000,511.00 $ 6,000,000.00 S $ 6,000,000.00 $(1,009,489.00) 1 Balance Sheet: End of Round 3 S 54,585.41 $ 4,864,230.25 0.00% $ 0.25% S 6.00% $ 2.00% $ 3.00% $ 2.00% $ 1.00% $ Deposits Borrowed Total Uabilities S 5,919,326.66 Total L&E S S 333,504.00 333,504.00 S 333,503.00 $ 1.000,511.00 Total Equity Comm Stock Ret Earnings Income Liabilities & Equity $ 12.130.25 $ 20.010.24 $ 6.670.08 $ 10.005.09 $ - $ 6,000,000.00 S S 6,000,000.00 $ 1,000,000.00 S (1,080,673.34) S (80,673.34) 48.815.66 $120.000.00 S 5,919,326.66 LUILINTY $ Expense $120.000.00 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. c. 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. Exchange 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. Also note that all balance sheet items are ultimately denominated in US$. Week 4 Euro C&I Euro Deposits Euro Borrowing Difference Cash Securities Lending Cons. Loans Residential Mortgage C&I* Euro C& Total Lending Total Assets Assets Balance Sheett-4: Start of Round 4 S S $ S S S $ Allocation S 55,680.30 Deposits 4,852,100.00 Borrowed 1.3 1.3 $ 1.3 S 1.3 S 6,009,342.20 Total L&E Liabilities & Equity S Euro Deposit S 333,504.00 Euro Borrowing S 333,504.00 Total Ulabllitles S 433,553.90 Comm Stock S Ret Eamings S 1,100,561.90 Total Equlty S In $ S 600,000.00 600,000.00 1,000,000.00 (1,090,708.70) (90,708.70) 509,291.30 As shown in the FINA 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 your 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). Money, 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 drop down menu to determine your Bank's balance sheet at the Start of Round 4. Start of Round 4 Cash Securities Consumer Loans Residential Mortgage C&I Total Loans Deposits Borrowed Total Financing Total Income and Expense Retained Earnings Cash Securities Lending Cons. Loons" Residential Mortgage C&I Tocal Lending Total Assets Allocation S 137,900.00 $ 4,852,100.00 S 333,504.00 S 333,504.00 $ 333,503.00 $ 1,000,511.00 $ 6,000,000.00 S $ 6,000,000.00 $(1,009,489.00) 1 Balance Sheet: End of Round 3 S 54,585.41 $ 4,864,230.25 0.00% $ 0.25% S 6.00% $ 2.00% $ 3.00% $ 2.00% $ 1.00% $ Deposits Borrowed Total Uabilities S 5,919,326.66 Total L&E S S 333,504.00 333,504.00 S 333,503.00 $ 1.000,511.00 Total Equity Comm Stock Ret Earnings Income Liabilities & Equity $ 12.130.25 $ 20.010.24 $ 6.670.08 $ 10.005.09 $ - $ 6,000,000.00 S S 6,000,000.00 $ 1,000,000.00 S (1,080,673.34) S (80,673.34) 48.815.66 $120.000.00 S 5,919,326.66 LUILINTY $ Expense $120.000.00 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. c. 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. Exchange 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. Also note that all balance sheet items are ultimately denominated in US$. Week 4 Euro C&I Euro Deposits Euro Borrowing Difference Cash Securities Lending Cons. Loans Residential Mortgage C&I* Euro C& Total Lending Total Assets Assets Balance Sheett-4: Start of Round 4 S S $ S S S $ Allocation S 55,680.30 Deposits 4,852,100.00 Borrowed 1.3 1.3 $ 1.3 S 1.3 S 6,009,342.20 Total L&E Liabilities & Equity S Euro Deposit S 333,504.00 Euro Borrowing S 333,504.00 Total Ulabllitles S 433,553.90 Comm Stock S Ret Eamings S 1,100,561.90 Total Equlty S In $ S 600,000.00 600,000.00 1,000,000.00 (1,090,708.70) (90,708.70) 509,291.30
Expert Answer:
Answer rating: 100% (QA)
To revise the asset allocation and funding source decisions for Round 4 in ligh... View the full answer
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date:
Students also viewed these finance questions
-
Olde World Windows and Doors is a manufacturer of steel windows and doors for both residential and commercial applications. The following problems are decisions that senior management faces in...
-
Assume that a security is selling at INR 217 and American call and American put options are available on the stock with 3 months maturity and an exercise price of INR 210. The call is selling at INR...
-
Consider three axes of rotation for a pencil: along the lead, at right angles to the lead at the middle, and at right angles to the lead at one end. Rate the rotational inertias about each axis from...
-
Do we understand why certain minerals are immobile in plants? What is one essential element that we humans do not recycle well in our own bodies?
-
Calculate the minimum rate of work in watts for the gaseous separation at ambient conditions indicated in Figure 10.32. Figure 10.32:- Feed Separator kmol/hr Cz 30 Cz 200 nC4 370 nC5 350 nC6 50...
-
Arb Corporation acquired 25 percent of Tee Corporation's outstanding common stock on October 1, for $600,000. A summary of Tee's adjusted trial balances on this date and at December 31 follows (in...
-
1. Many courses use group projects. What are some of the things that make positive group project experiences? 2. How can a manager motivate employees? Give some specific ideas. Include when you've...
-
Amanda Autry and Carley Wilson are partners in A & W Gift Shop, which employs the individuals listed below. Paychecks are distributed every Friday to all employees. Based on the information given,...
-
help round to two decimal places as needed Calculate the mean, variance, and standard deviation of following "Population" data: \( 61,83,94,85 \), and \( 97 . \) Round to two decimal places as needed...
-
If Al Bundy's Year-to-Date (YTD) or cumulative earnings are $127,500 and he receives a Christmas Bonus of $2000 how much will be taken out of his current check for social security (given the maximum...
-
25. What type of bonds link the light chain to the heavy chain inimmunoglobulins? A) Hydrogen bonds B) Hydrophobic bonds C) Salt linkages D) Disulfide bonds 26. What differs in their amino acids...
-
Woolard Supplies ( a sole proprietorship ) has taxable income in 2 0 2 3 of $ 2 4 0 , 0 0 0 before any depreciation deductions ( 1 7 9 , bonus, or MACRS ) and placed some office furniture into...
-
Aubrey Beck is single, covered by an employer retirement plan, and she contributed $4,000 to a new Roth IRA on June 16, 2023. On December 29, 2023, she determines that her 2023 modified AGI will...
-
Sandra would like to organize LAB ( a legal corporation ) as either an S corporation or a C corporation for tax purposes. In either form, the entity is expected to generate an 8 percent annual before...
-
Legal definitions of drug use and abuse Group of answer choices May vary from one setting to another. May be inconsistent within a society. May be at variance with public norms. All of the options.
-
Element compound homogeneous mixture (heterogeneous mixture) 4) A piece of gold has a mass of 49.75 g. What should the volume be if it is pure gold? Gold has a density of 19.3 g/cm (3 points) D=m/v...
-
Meals for the Homeless usually experiences seasonality in its cash balances. In December, contributions from donors increase its cash balances, and then these balances are used throughout the...
-
Discuss the four main elements of the Institute of Management Accountants code of ethics.
-
The city museum will have a Picasso exhibit on loan for three years. As part of the conditions of the loan, a specialized alarm and security system must be installed. High Security Company will...
-
Nestls financial statements are presented in Appendix B. Financial statements of Delfi Limited are presented in Appendix C. Instructions Refer to the financial statements and answer the following...
-
Writing Financial statement information about four different companies is as follows. Instructions a. Determine the missing amounts. (Hint: For example, to solve for (a), Assets Liabilities = Equity...
-
The financial statements of TSMC are presented in Appendix A. The complete annual report, including the notes to the financial statements, is available at the companys website. Instructions Refer to...
Study smarter with the SolutionInn App