Create a vertical and horizontal analysis report for PNC Bank's income statement and balance sheet and A full ratio analysis of the company using your weekly analysis assignments. (1 spreadsheet) A research paper containing: Company overview(1-2 pages) Industry and competitive analysis (1-2 pages) Conclusions (1 page) Copies of the financial statements or the URL where the financial statements can be found. Your final paper should be 4-6 pages in length. Your spreadsheets should be contained onto 5 separate tabs of a single Excel file.

2018 2017 2016 FINANCIAL RESULTS Net interest income $ 9,721 $ 9,108 $ 8,391 Noninterest income 7,411 7,221 6,771 Total revenue 17,132 16,329 15,162 Noninterest expense 10,296 10,398 9,476 Pretax, pre-provision earnings (non-GAAP) 6,836 5,931 5,686 Provision for credit losses 408 441 433 Income taxes 1,082 102 1,268 Net income $ 5,346 $ 5,388 $ 3,985 PER COMMON SHARE Diluted earnings $ 10.71 $ 10.36 $ 7.30 Cash dividends 3.40 2.60 2.12 Closing price 116.91 144.29 116.96 Book value 95.72 91.94 85.94 Tangible book value (non-GAAP) 75.42 72.28 67.26 BALANCE SHEET At year end Assets $ 382,315 $ 380,768 $ 366,380 Loans 226,245 220,458 210,833 Deposits 267,839 265,053 257,164 Common shareholders equity 43,742 43,530 41,723 Common shares outstanding 457 473 485 SELECTED RATIOS Return on average common shareholders equity 11.83 % 12.09 % 8.85 % Return on average assets 1.41 1.45 1.10 Net interest margin 2.97 2.87 2.73 Noninterest income to total revenue 43 44 45 Effi ciency 60 64 62 Basel III common equity Tier 1 capital ratio 9.6 9.8 10.0 Transitional Basel III common equity Tier 1 capital ratio 10.4 10.6