A B D Input Area: 4,000.00 90.00 535.00 45.00 2,900.00 200.00 2,700.00 20.00 Report of Condition Total assets Cash and due from depository institutions Securities Federal funds sold & reverse repurchase agreeme Gross loans & leases Loan loss allowance Net loans and leases Trading account assets Bank premises and fixed assets Other real estate owned Goodwill and other intangibles All other assets Total liabilities and capital Total liabilities Total deposits Federal funds purchased & repurchase agreemen Trading liabilities Other borrowed funds Subordinated debt All other liabilities Total Equity capital Perpetual preferred stock Common stock Surplus Undivided profits 15.00 200.00 175,00 ? ? ? 80.00 10.00 50.00 480.00 40.00 420.00 5.00 25.00 320.00 70.00 5 B mat Painter ad Alignment Font fx ? 2 D B Chapter 05 Problem 02 Input Area: Report of Income Total interest income Total interest expense Net interest income Provision for loan and lease losses Total noninterest income Fiduciary activities Service charges on deposit accounts Trading account gains & fees Additional noninterest income Total noninterest expense Salaries and employee benefits Premises and equipment expense Additional noninterest expense Pre-tax net operating income Securities gains (losses) Applicable income taxes Income before extraordinary items Extraordinary gains - net Net income 200.00 140.00 60.00 ? 100.00 20.00 25.00 ? 30.00 125.00 ? 10.00 20.00 15.00 5.00 3.001 ? 2.00 2 File Home Insert Page Layout Formulas Data Review * Cut Arial - 10 AN Copy Paste BIU A: Format Painter Clipboard Font 119 B D Chapter 05 Problem 03 Input Area: Total interest income Total interest expenses Total noninterest income Total noninterest expenses Provision for loan losses Income taxes Increases in bank's undivided profits $1401 $100 $75 $90 $5 $4 $6 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Output Area: $40 $15 Net interest income Net noninterest income Pretax net operating income Net income after taxes Total operating revenues Total operating expenses Dividends to common stockholders AL Merge & BIUDAEEEE Copy " Paste Format Painter Clipboard Alignment Font xv fx E26 F E D B 5 DO $300 $15 $36 $5 $15 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Input Area: Gross loans Allowance for loan losses Investment Securities Common stock Surplus Total equity capital Cash and due from banks Miscellaneous assets Bank premises and equipment, gross Trading-account securities Other real estate owned Goodwill and other intangibles Total liabilities Preferred stock Nondeposit borrowings Bank premises and equipment, net $30 $10 $25 $25 $2 $4 $3 $375 $3 $40 $20 Output Area: Total assets Net loans Undivided profits Fed Funds Sold Depreciation Total deposits * Cut Be Copy Arial 10 AA = = Wrap Text BIU A a Merge & Center Format Painter Font Alignment Clipboard F20 Chapter 05 Problem 05 fi B C D E Input Area: Gross loans Allowance for loan losses Original Loan Amount Amount Repaid Market Value of Real Estate Auction Value of Real Estate (part c) $800 $45 $12 $2 $7 $10 Output Area: 3 4 5 16 17 18 19 20 21 22 23 24 25 25 27 28 Outstanding Loan Balance Net Loans before charge-off Amount of charge-off Gross Loans after charge-off ALL after charge-off Net Loans after charge-off Gross Loans after auction ALL after after auction (recovery) Net Loans after auction (recovery) A B D Input Area: 4,000.00 90.00 535.00 45.00 2,900.00 200.00 2,700.00 20.00 Report of Condition Total assets Cash and due from depository institutions Securities Federal funds sold & reverse repurchase agreeme Gross loans & leases Loan loss allowance Net loans and leases Trading account assets Bank premises and fixed assets Other real estate owned Goodwill and other intangibles All other assets Total liabilities and capital Total liabilities Total deposits Federal funds purchased & repurchase agreemen Trading liabilities Other borrowed funds Subordinated debt All other liabilities Total Equity capital Perpetual preferred stock Common stock Surplus Undivided profits 15.00 200.00 175,00 ? ? ? 80.00 10.00 50.00 480.00 40.00 420.00 5.00 25.00 320.00 70.00 5 B mat Painter ad Alignment Font fx ? 2 D B Chapter 05 Problem 02 Input Area: Report of Income Total interest income Total interest expense Net interest income Provision for loan and lease losses Total noninterest income Fiduciary activities Service charges on deposit accounts Trading account gains & fees Additional noninterest income Total noninterest expense Salaries and employee benefits Premises and equipment expense Additional noninterest expense Pre-tax net operating income Securities gains (losses) Applicable income taxes Income before extraordinary items Extraordinary gains - net Net income 200.00 140.00 60.00 ? 100.00 20.00 25.00 ? 30.00 125.00 ? 10.00 20.00 15.00 5.00 3.001 ? 2.00 2 File Home Insert Page Layout Formulas Data Review * Cut Arial - 10 AN Copy Paste BIU A: Format Painter Clipboard Font 119 B D Chapter 05 Problem 03 Input Area: Total interest income Total interest expenses Total noninterest income Total noninterest expenses Provision for loan losses Income taxes Increases in bank's undivided profits $1401 $100 $75 $90 $5 $4 $6 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Output Area: $40 $15 Net interest income Net noninterest income Pretax net operating income Net income after taxes Total operating revenues Total operating expenses Dividends to common stockholders AL Merge & BIUDAEEEE Copy " Paste Format Painter Clipboard Alignment Font xv fx E26 F E D B 5 DO $300 $15 $36 $5 $15 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Input Area: Gross loans Allowance for loan losses Investment Securities Common stock Surplus Total equity capital Cash and due from banks Miscellaneous assets Bank premises and equipment, gross Trading-account securities Other real estate owned Goodwill and other intangibles Total liabilities Preferred stock Nondeposit borrowings Bank premises and equipment, net $30 $10 $25 $25 $2 $4 $3 $375 $3 $40 $20 Output Area: Total assets Net loans Undivided profits Fed Funds Sold Depreciation Total deposits * Cut Be Copy Arial 10 AA = = Wrap Text BIU A a Merge & Center Format Painter Font Alignment Clipboard F20 Chapter 05 Problem 05 fi B C D E Input Area: Gross loans Allowance for loan losses Original Loan Amount Amount Repaid Market Value of Real Estate Auction Value of Real Estate (part c) $800 $45 $12 $2 $7 $10 Output Area: 3 4 5 16 17 18 19 20 21 22 23 24 25 25 27 28 Outstanding Loan Balance Net Loans before charge-off Amount of charge-off Gross Loans after charge-off ALL after charge-off Net Loans after charge-off Gross Loans after auction ALL after after auction (recovery) Net Loans after auction (recovery)