Question: A B C D E F G Outcome 3 Week 4 Allocation 1 Income Expense 4 Cash 603,020.00 0.00% Securities S 800,777.92 0.25% 2.001.94 O

A B C D E F G Outcome 3 Week 4 Allocation 1 Income Expense 4 Cash 603,020.00 0.00% Securities S 800,777.92 0.25% 2.001.94 O Consumer Loans 5 4,000,000.00 6.00% $ 240.000.00 Residential Mortgage $ 4,000,000.00 2.00% 80.000.00 C&I $ 4,000,000.00 3.00% 120.000.00 Euro C&I $ 7,000,000.00 4.00% $ 280.000.00 10 Deposits 5 6,000,000.00 2.00% 120.000.00 11 Borrowed S 6,000,000.00 1.00% 60.000.00 12 Euro Deposits $ 3,900,000.00 0.90% 35.100.00 13 Euro Borrowing $ 3,099,999.69 1.50% 46.500.00 14 Total Net Income 460,402 $ 722.001.94 $ 261.600.00 15 Retained Earnings S 461,001.94 16 2535 36 Balance Sheet t=4: End of Round 5 37 Assets Liabilities & Equity 38 Cash $ 1.063.421.95 Deposits $ 6.000.000.00 39 Securities $ 802.779.86 Borrowed $ 6.000.000.00 40 Lending Euro Deposit $ 3.900.000.00 41 Cons. Loans* $ 4.000.000.00 Euro Borrowing $ 3.099.999.69 42 Residential Mortgage $ 4.000.000.00 Total Liabilities $ 18,999.999.69 43 C&I* 6 4,000,000.00 Comm Stock $ 1,000,000.00 44 Euro C&I $ 7,000,000.00 Ret Earnings 921.403.89 45 Total Lending $ 19,000.000.00 Total Equity $ 1,921.403.89 46 47 Total Assets $ 20.866 201.81 Total L&E $ 20,921.403.58 48 Sheet1Balance Sheet: End of Round 4 Total Equity 1,921, 403.89 Consumer Loans 4,000, 000.00 Residential Loans 4,000, 000.00 Euro Denominated C&I Loans (in U.SS) 7,000, 000.00 C&I 4,000,000.00 Tier 1 Capital =Equity/(Total Loans) 10.113%

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 Accounting Questions!

John and Shannon O'Banion, who live at 3222 Pinon Drive, Mesa, CO 81643, file as married filing jointly. John's Social Security number is 412-34-5670 (date of birth 5/12/1985), and Shannon's is...

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

A602 financial analysis template (colgate-Palmolive) I only need help with Common size and Financial Ratio. Note: Use care not to delete, hide or reorder workbook tabs (worksheets) in this workbook....

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

In need of some assistance with an assignment. The financial data for Buffalo Wild Wings needs to be added to the following Excel workbook tabs. ONLY 2014 INFORMATION IS NEEDED. The company's Form...

Hi There, I need someone to help me with the attached finance worksheet. There are 3 problems in this excel file - one problem on each individual tab. I am attaching a couple of additional files as...

I need, I am working on GENERAL ELECTRIC AND UNITED TECHNOLOGIES CORP, I need help GE and UTC Financial Statements Forecast for the next 5 year using the attachment. Throughout this course you will...

All these are in proper sequence. please solve it. I Cannot increase the Font Size more, So can you please manage to answer. Please see below for your group project variables. A B C D E F G H 1 K L M...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

You are riding in a school bus. As the bus rounds a flat curve at constant speed, a lunch box with mass O.SOO kg, suspended from the ceiling of the bus by a string 1.80 m long, is found to hang at...

The text outlines three basic assumptions underlying the labor relations process in the United States. To what extent do you agree or disagree with these assumptions? Does your response differ any...

31. For each of the following independent situations, prepare the adjusting entry that must be made at December 31, 20X1. Omit descriptions. a. On December 31, 20X1, the Notes Receivable account at...

The following is the adjusted trial balance of Sierra Company. (Click on the Graded Worksheet Tab below.) Sierra Company Adjusted Trial Balance December 31 Account Title Debit Credit Cash $15,000...