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
-
The height and weight of football players are in table below, create a scatter plot and find a regression equation between height and weight of football players (1 Mark). Then use the regression...
-
The activity details and their predecessors are given below use the PERT method to calculate the expected time (1 Mark) and construct the network diagram (1 Mark) to find the critical path of the...
-
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...
-
Your supervisor has asked you to research a potential tax deduction for a client, Nancy Fradette. Nancy is a seat-filler at a number of the award shows that are filmed in the greater Los Angeles...
-
Langer Industries had one patent recorded on its books as of January 1, 2008. This patent had a book value of $240,000 and a remaining useful life of 8 years. During 2008, Langer incurred research...
-
Shiek Shoes sold an administrative building to its parent, Pearl Industries, on January 1, 2015, for \($8,000,000.\) At the time of sale, the building was carried on Shiek's books at original cost of...
-
Karen Noonan opened Clean Sweep Inc. on February 1, 2017. During February, the following transactions were completed. Feb. 1 Issued 5,000 shares of Clean Sweep common stock for $13,000. Each share...
-
Exercise 3-31 Manufacturing Cost Flows (LO 3-2, 3-5, 3-6 ) Reimel Furniture Company, Inc. incurred the following costs during 20x2. Direct material used $174,000 Direct labor 324,000 Manufacturing...
-
The Durham Insurance Company sells a five-year term insurance policy with face value of $100,000 to a 47-year-old man for a monthly premium of $63. The mortality table is given below. d. What is the...
-
You need to write a paper about the Responsibilities of a Manager and a Leader In Relation To the Reduction of Workplace Stress
-
Two global leaders in medical technology have formed an alliance. The goals of this new US business collaboration are to develop 'integrated diagnostic tests' to use at home incorporating state of...
-
Given the table below answer the question. Time Value of RF market index 0 1015 1 1125 0.015 2 1200 0.017 3 1190 0.018 1220 0.024 5 1300 0.018 The annual market return for period 1 equals to The...
-
Sthilaire Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.64 direct labor-hours. The direct labor rate is $9 per direct labor-hour. The...
-
What technology is likely to be involved when Ben's organization needs to provide authentication and authorization assertions to their cloud e-commerce application?
-
Why would corporate clients be interested in online technology training for their internal employees? How would they benefit from paying Pluralsight for training?
-
Name the five (5) main roles of a moderator in a focus group? Provide Role and Description
-
The Ranch 888 Noodle Company sells two types of dried noodles:ramen, at $6.50 per box, and chow fun, at $7.70 per box. So farthis year, the company has sold a total of 110,096 boxes ofnoodles,...
-
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...
-
Prove that the inverse hyperbolic functions are the following logarithms: a. \(\cosh ^{-1} x=\ln \left(x+\sqrt{x^{2}-1} ight)\). b. \(\tanh ^{-1} x=\frac{1}{2} \ln \frac{1+x}{1-x}\).
-
Write the following in terms of logarithms: a. \(\cosh ^{-1} \frac{4}{3}\). b. \(\tanh ^{-1} \frac{1}{2}\). c. \(\sinh ^{-1} 2\).
-
Do the following: a. Write \((\cosh x-\sinh x)^{6}\) in terms of exponentials. b. Prove \(\cosh (x-y)=\cosh x \cosh y-\sinh x \sinh y\) using the exponential forms of the hyperbolic functions. c....
Study smarter with the SolutionInn App