Citygroup bank project
kmatviychuk
FIN564_Wk7_CourseProject_Statements_Ratios_Team3.xlsxCitigroup 5-year balance sheets
| Citigroup | |||||
| Consolidated Balance Sheet | |||||
| In millions | |||||
| Assets | 2016 | 2017 | 2018 | 2019 | 2020 |
| Cash & due from banks | $ 23,043 | $ 23,775 | $ 23,645 | $ 23,967 | $ 26,349 |
| Deposits with banks | $ 137,451 | $ 156,741 | $ 164,460 | $ 169,952 | $ 283,266 |
| Securities borrowed & purchased under agreement to sell | $ 236,813 | $ 232,478 | $ 270,684 | $ 251,322 | $ 294,712 |
| Brokerage receivables | $ 28,887 | $ 38,384 | $ 35,450 | $ 39,857 | $ 44,806 |
| Trading account assets | $ 243,925 | $ 252,790 | $ 256,117 | $ 276,140 | $ 375,079 |
| Investments: | |||||
| Available for sale debt securities | $ 299,424 | $ 290,725 | $ 288,038 | $ 280,265 | $ 335,084 |
| Held to maturity debt securities | $ 45,667 | $ 53,320 | $ 63,357 | $ 80,775 | $ 104,943 |
| Equity securities | $ 8,213 | $ 8,245 | $ 7,212 | $ 7,523 | $ 7,332 |
| Total Investments | $ 353,304 | $ 352,290 | $ 358,607 | $ 368,563 | $ 447,359 |
| Loans: | |||||
| Consumer | $ 325,063 | $ 333,656 | $ 330,487 | $ 309,548 | $ 288,839 |
| Corporate | $ 299,306 | $ 333,378 | $ 353,709 | $ 389,935 | $ 387,044 |
| Loans, net of unearned income | $ 624,369 | $ 667,034 | $ 684,196 | $ 699,483 | $ 675,883 |
| Allowance for credit losses on loans | $ (12,060) | $ (12,355) | $ (12,315) | $ (12,783) | $ (24,956) |
| Total loans, net | $ 612,309 | $ 654,679 | $ 671,881 | $ 686,700 | $ 650,927 |
| Goodwill | $ 21,659 | $ 22,256 | $ 22,046 | $ 22,126 | $ 22,162 |
| Intangible assets | $ 5,114 | $ 5,146 | $ 5,220 | $ 4,822 | $ 4,747 |
| Other assets | $ 128,008 | $ 103,926 | $ 109,273 | $ 107,709 | $ 110,683 |
| Mortgage servicing rights | $ 1,564 | ||||
| Total Assets | $ 1,792,077 | $ 1,842,465 | $ 1,917,383 | $ 1,951,158 | $ 2,260,090 |
| Liabilities | |||||
| Non-interest-bearing deposits in US | $ 136,698 | $ 126,880 | $ 105,836 | $ 98,811 | $ 126,942 |
| Interest-bearing deposits in US | $ 300,972 | $ 318,613 | $ 361,573 | $ 401,418 | $ 503,213 |
| Non-interest-bearing deposits out of US | $ 77,616 | $ 87,440 | $ 80,648 | $ 85,692 | $ 100,543 |
| Interest-bearing deposits in office out of US | $ 414,120 | $ 426,889 | $ 465,113 | $ 484,669 | $ 549,973 |
| Total deposits | $ 929,406 | $ 959,822 | $ 1,013,170 | $ 1,070,590 | $ 1,280,671 |
| Securities loaned and sold under agreements to repurchase | $ 141,821 | $ 156,277 | $ 177,768 | $ 166,339 | $ 199,525 |
| Brokerage payables | $ 57,152 | $ 61,342 | $ 64,571 | $ 48,601 | $ 50,484 |
| Trading account liabilities | $ 139,045 | $ 125,170 | $ 144,305 | $ 119,894 | $ 168,027 |
| Short-term borrowings | $ 30,701 | $ 44,452 | $ 32,346 | $ 45,049 | $ 29,514 |
| Long-term debt | $ 206,178 | $ 236,709 | $ 231,999 | $ 248,760 | $ 271,686 |
| Other liabilities | $ 61,631 | $ 57,021 | $ 56,150 | $ 57,979 | $ 59,983 |
| Total liabilities | $ 1,565,934 | $ 1,640,793 | $ 1,720,309 | $ 1,757,212 | $ 2,059,890 |
| Stockholders' equity | |||||
| Preferred stock | $ 19,253 | $ 19,253 | $ 18,460 | $ 17,980 | $ 19,480 |
| Common stock | $ 31 | $ 31 | $ 31 | $ 31 | $ 31 |
| Additional paid-in capital | $ 108,042 | $ 108,008 | $ 107,922 | $ 107,840 | $ 107,846 |
| Retained earnings | $ 146,477 | $ 138,425 | $ 151,347 | $ 165,369 | $ 168,272 |
| Treasury stock | $ (16,302) | $ (30,309) | $ (44,370) | $ (61,660) | $ (64,129) |
| Accumulated other comprehensive income | $ (32,381) | $ (34,668) | $ (37,170) | $ (36,318) | $ (32,058) |
| Total Citigroup stockholders' equity | $ 225,120 | $ 200,740 | $ 196,220 | $ 193,242 | $ 199,442 |
| Noncontrolling interests | $ 1,023 | $ 932 | $ 854 | $ 704 | $ 758 |
| Total Equity | $ 226,143 | $ 201,672 | $ 197,074 | $ 193,946 | $ 200,200 |
| Total liabilities and equity | $ 1,792,077 | $ 1,842,465 | $ 1,917,383 | $ 1,951,158 | $ 2,260,090 |
Citigroup 5-year income state
| Citigroup | |||||
| Consolidated Statement of Income | |||||
| In millions, except shares | 2016 | 2017 | 2018 | 2019 | 2020 |
| Revenues | |||||
| Interest revenue | $ 57,988 | $ 61,579 | $ 70,828 | $ 76,510 | $ 58,089 |
| Interest expense | $ 12,512 | $ 16,518 | $ 24,266 | $ 29,163 | $ 14,541 |
| Net interest revenue | $ 45,476 | $ 45,061 | $ 46,562 | $ 47,347 | $ 43,548 |
| Commissions and fees | $ 11,678 | $ 12,707 | $ 11,857 | $ 11,746 | $ 11,385 |
| Principal transactions | $ 7,857 | $ 9,475 | $ 8,905 | $ 8,892 | $ 13,885 |
| Administration and other fiduciary fees | $ 3,294 | $ 3,584 | $ 3,580 | $ 3,411 | $ 3,472 |
| Realized gains on sales of investments, net | $ 949 | $ 778 | $ 421 | $ 1,474 | $ 1,756 |
| Impairment losses on investments: | |||||
| Impairment losses on investments and other assets | $ (620) | $ (63) | $ (132) | $ (32) | $ (165) |
| Provision for credit losses on AFS debt securities | $ (3) | ||||
| Net impairment losses recognized in earnings | $ (620) | $ (63) | $ (132) | $ (32) | $ (168) |
| Other revenue | $ 2,163 | $ 902 | $ 1,661 | $ 1,448 | $ 420 |
| Total non-interest revenues | $ 25,321 | $ 27,383 | $ 26,292 | $ 26,939 | $ 30,750 |
| Total revenues, net of interest expense | $ 70,797 | $ 72,444 | $ 72,854 | $ 74,286 | $ 74,298 |
| Provisions for credit losses and for benefits and claims | $ 6,749 | $ 7,503 | $ 7,354 | $ 8,218 | $ 15,922 |
| Provision for credit losses on held-to-maturity debt securities | $ 7 | ||||
| Provision for credit losses on other assets | $ 7 | ||||
| Policyholder benefits and claims | $ 204 | $ 109 | $ 101 | $ 73 | $ 113 |
| Provision for credit losses on unfunded lending commitments | $ 29 | $ (161) | $ 113 | $ 92 | $ 1,446 |
| Total provisions for credit losses and for benefits and claims | $ 6,982 | $ 7,451 | $ 7,568 | $ 8,383 | $ 17,495 |
| Operating expenses | |||||
| Conpensation and benefits | $ 20,970 | $ 21,181 | $ 21,154 | $ 21,433 | $ 22,214 |
| Premises and equipment | $ 2,542 | $ 2,453 | $ 2,324 | $ 2,328 | $ 2,333 |
| Technology/communication | $ 6,701 | $ 6,909 | $ 7,193 | $ 7,077 | $ 7,383 |
| Advertising and marketing | $ 1,632 | $ 1,608 | $ 1,545 | $ 1,516 | $ 1,217 |
| Other operating | $ 10,493 | $ 10,081 | $ 9,625 | $ 9,648 | $ 10,024 |
| Total operating expenses | $ 42,338 | $ 42,232 | $ 41,841 | $ 42,002 | $ 43,171 |
| Income from continuing operations before income taxes | $ 21,477 | $ 22,761 | $ 23,445 | $ 23,901 | $ 13,632 |
| Provision for income taxes | $ 6,444 | $ 29,388 | $ 5,357 | $ 4,430 | $ 2,525 |
| Income from continuing operations | $ 15,033 | $ (6,627) | $ 18,088 | $ 19,471 | $ 11,107 |
| Discontinued operations | |||||
| Loss from discontinued operations | $ (80) | $ (104) | $ (26) | $ (31) | $ (20) |
| Provision (benefit) for income taxes | $ (22) | $ 7 | $ (18) | $ (27) | |
| Loss from discontinued operations, net of taxes | $ (58) | $ (111) | $ (8) | $ (4) | $ (20) |
| Net income before attribution of noncontrolling interests | $ 14,975 | $ (6,738) | $ 18,080 | $ 19,467 | $ 11,087 |
| Noncontrolling interests | $ 63 | $ 60 | $ 35 | $ 66 | $ 40 |
| Citigroup's net income | $ 14,912 | $ (6,798) | $ 18,045 | $ 19,401 | $ 11,047 |
| Basic earnings per share (2) | |||||
| Income from continuing operations | $ 4.74 | $ (2.94) | $ 6.69 | $ 8.08 | $ 4.75 |
| Loss from discontinued operations, net of taxes | $ (0.02) | $ (0.04) | $ (0.01) | ||
| Net Income | $ 4.72 | $ (2.98) | $ 6.69 | $ 8.08 | $ 4.74 |
| Weighted average common shares outstanding | 2493.3 | 2249.2 | 2085.8 | ||
| Diluted earnings per share (2) | |||||
| Income from continuing operations | $ 4.74 | $ (2.94) | $ 6.69 | $ 8.04 | $ 4.73 |
| Income (loss) from discontinued operations, net of taxes | $ (0.02) | $ (0.04) | $ (0.01) | ||
| Net income | $ 4.72 | $ (2.98) | $ 6.69 | $ 8.04 | $ 4.72 |
| Adjusted weighted average common shares outstanding | $ 2,888.3 | $ 2,698.5 | $ 2,494.8 | $ 2,265.3 | $ 2,099.0 |
WellsFargo 5-year balance sheet
| Wells Fargo | |||||
| Consolidated Balance Sheet | |||||
| In millions | |||||
| Assets | 2016 | 2017 | 2018 | 2019 | 2020 |
| Cash & due from banks | $ 20,729 | $ 23,367 | $ 23,551 | $ 21,757 | $ 28,236 |
| Deposits with banks | $ 192,580 | $ 149,736 | $ 119,493 | $ 236,376 | |
| Total cash, cash equivalents, and restrict cash | $ 20,729 | $ 215,947 | $ 173,287 | $ 141,250 | $ 264,612 |
| Federal funds sold and securities purchased under resale agreements | $ 266,038 | $ 80,025 | $ 80,207 | $ 102,140 | $ 65,672 |
| Debt securities: | |||||
| Trading, at fair value | $ 74,397 | $ 57,624 | $ 69,989 | $ 79,733 | $ 75,095 |
| Available for sale at fair value | $ 308,364 | $ 276,407 | $ 269,912 | $ 263,459 | $ 220,392 |
| Held to maturity at fair value | $ 99,583 | $ 139,335 | $ 144,788 | $ 153,933 | $ 205,720 |
| Mortgage loans held for sale | $ 26,309 | $ 20,070 | $ 15,126 | ||
| Loans held for sale | $ 80 | $ 1,131 | $ 2,041 | $ 24,319 | $ 36,384 |
| Loans | $ 967,604 | $ 956,770 | $ 953,110 | $ 962,265 | $ 887,637 |
| Allowance for loan losses | $ (11,419) | $ (11,004) | $ (9,775) | $ (9,551) | $ (18,516) |
| Net loans | $ 956,185 | $ 945,766 | $ 943,335 | $ 952,714 | $ 869,121 |
| Mortgage servicing rights | $ 12,959 | $ 13,625 | $ 14,649 | $ 12,947 | $ 7,437 |
| Amortized | $ 1,406 | $ 1,424 | $ 1,443 | ||
| Premises servicing rights | $ 8,333 | $ 8,847 | $ 8,920 | $ 9,309 | $ 8,895 |
| Goodwill | $ 26,693 | $ 26,587 | $ 26,418 | $ 26,390 | $ 26,392 |
| Derivate assets | $ 14,498 | $ 12,228 | $ 10,770 | $ 14,203 | $ 25,846 |
| Equity securities | $ 62,497 | $ 55,148 | $ 68,241 | $ 62,260 | |
| Other assets | $ 114,541 | $ 90,244 | $ 79,850 | $ 78,917 | $ 87,337 |
| Total assets | $ 1,930,115 | $ 1,951,757 | $ 1,895,883 | $ 1,927,555 | $ 1,955,163 |
| Liabilities | |||||
| Noninterest bearing deposits | $ 375,967 | $ 373,722 | $ 349,534 | $ 344,496 | $ 467,068 |
| Interest bearing deposits | $ 930,112 | $ 962,269 | $ 936,636 | $ 978,130 | $ 937,313 |
| Total deposits | $ 1,306,079 | $ 1,335,991 | $ 1,286,170 | $ 1,322,626 | $ 1,404,381 |
| Short-term borrowings | $ 96,781 | $ 103,256 | $ 105,787 | $ 104,512 | $ 58,999 |
| Derivative liabilities | $ 14,492 | $ 8,796 | $ 8,499 | $ 9,079 | $ 16,509 |
| Accrued expenses and other liabilities | $ 57,189 | $ 70,615 | $ 69,317 | $ 75,163 | $ 76,404 |
| Long ther debt | $ 255,077 | $ 225,020 | $ 229,044 | $ 228,191 | $ 212,950 |
| Total liabilities | $ 1,729,618 | $ 1,743,678 | $ 1,698,817 | $ 1,739,571 | $ 1,769,243 |
| Equity | |||||
| Wells Fargo stockholders' equity: | |||||
| Preferred stock | $ 24,551 | $ 25,358 | $ 23,214 | $ 21,549 | $ 21,136 |
| Common stock | $ 9,136 | $ 9,136 | $ 9,136 | $ 9,136 | $ 9,136 |
| Additional paid in capital | $ 60,234 | $ 60,893 | $ 60,685 | $ 61,049 | $ 60,197 |
| Retained earnings | $ 133,075 | $ 145,263 | $ 158,163 | $ 166,697 | $ 162,890 |
| Cumulative other comprehensive income | $ (3,137) | $ (2,144) | $ (6,336) | $ (1,311) | $ 194 |
| Treasury stock | $ (22,713) | $ (29,892) | $ (47,194) | $ (68,831) | $ (67,791) |
| Unearned ESOP shares | $ (1,565) | $ (1,678) | $ (1,502) | $ (1,143) | $ (875) |
| Total Wells Fargo stockholders' equity | $ 199,581 | $ 206,936 | $ 196,166 | $ 187,146 | $ 184,887 |
| Noncontrolling interests | $ 916 | $ 1,143 | $ 900 | $ 838 | $ 1,033 |
| Total equity | $ 200,497 | $ 208,079 | $ 197,066 | $ 187,984 | $ 185,920 |
| Total liabilities and equity | $ 1,930,115 | $ 1,951,757 | $ 1,895,883 | $ 1,927,555 | $ 1,955,163 |
WellsFargo 5-year income state
| Wells Fargo | |||||
| Consolidated Statement of Income | |||||
| In millions except for shares | 2016 | 2017 | 2018 | 2019 | 2020 |
| Assets | |||||
| Interest income | |||||
| Debt securities | $ 11,244 | $ 12,946 | $ 14,406 | $ 14,955 | $ 11,234 |
| Mortgage loans held for sale | $ 784 | $ 786 | |||
| Loans held for sale | $ 38 | $ 50 | $ 917 | $ 892 | $ 947 |
| Loans | $ 39,505 | $ 41,388 | $ 43,974 | $ 44,146 | $ 34,109 |
| Equity securities | $ 635 | $ 799 | $ 992 | $ 962 | $ 554 |
| Other interest income | $ 1,457 | $ 2,940 | $ 4,358 | $ 5,128 | $ 954 |
| Total interest income | $ 53,663 | $ 58,909 | $ 64,647 | $ 66,083 | $ 47,798 |
| Interest expense | |||||
| Deposits | $ 1,395 | $ 3,013 | $ 5,622 | $ 8,635 | $ 2,804 |
| Short-term borrowings | $ 330 | $ 758 | $ 1,717 | $ 2,316 | $ 250 |
| Long term debt | $ 3,830 | $ 5,157 | $ 6,703 | $ 7,350 | $ 4,471 |
| Other interest expense | $ 354 | $ 424 | $ 610 | $ 551 | $ 438 |
| Total interest expense | $ 5,909 | $ 9,352 | $ 14,652 | $ 18,852 | $ 7,963 |
| Net interest income | $ 47,754 | $ 49,557 | $ 49,995 | $ 47,231 | $ 39,835 |
| Service charges on deposit accounts | $ 5,372 | $ 5,111 | |||
| Trust and investment fees | $ 14,243 | $ 14,495 | |||
| Card fees | $ 3,936 | $ 3,960 | |||
| Other fees | $ 3,727 | $ 3,557 | |||
| Mortgage banking | $ 6,096 | $ 4,350 | |||
| Insurance | $ 1,268 | $ 1,049 | |||
| Net gains from trading activities | $ 610 | $ 542 | |||
| Net gains on debt securities | $ 942 | $ 479 | |||
| Net gains from equity securities | $ 1,103 | $ 1,779 | |||
| Lease income | $ 1,927 | $ 1,907 | |||
| Other | $ 1,289 | $ 1,603 | |||
| Noninterest income (2) | |||||
| Deposits and lending related fees | $ 7,369 | $ 7,293 | $ 6,602 | ||
| Brokerage fees | $ 9,436 | $ 9,237 | $ 9,375 | ||
| Trust and investment management fees | $ 3,316 | $ 3,038 | $ 2,872 | ||
| Investment banking fees | $ 1,757 | $ 1,797 | $ 1,865 | ||
| Card fees | $ 3,907 | $ 4,016 | $ 3,544 | ||
| Mortgage banking | $ 3,017 | $ 2,715 | $ 3,493 | ||
| Net gains on trading and securities | $ 2,225 | $ 3,976 | $ 2,710 | ||
| Other | $ 5,386 | $ 5,760 | $ 2,044 | ||
| Total noninterest income | $ 40,513 | $ 38,832 | $ 36,413 | $ 37,832 | $ 32,505 |
| Total revenue | $ 88,267 | $ 88,389 | $ 86,408 | $ 85,063 | $ 72,340 |
| Provision for credit losses | $ 3,770 | $ 2,528 | $ 1,744 | $ 2,687 | $ 14,129 |
| Noninterest expense (3) | |||||
| Salaries | $ 16,552 | $ 17,363 | |||
| Commission and incentives compensation | $ 10,247 | $ 10,442 | |||
| Employee benefits | $ 5,094 | $ 5,566 | |||
| Equipment | $ 2,154 | $ 2,237 | |||
| Net occupancy | $ 2,855 | $ 2,849 | |||
| Core deposit and other intangibles | $ 1,192 | $ 1,152 | |||
| FDIC and other deposit assessments | $ 1,168 | $ 1,287 | |||
| Other | $ 13,115 | $ 17,588 | |||
| Personnel | $ 33,085 | $ 35,128 | $ 34,811 | ||
| Technology, telecommunications and equipment | $ 2,903 | $ 3,276 | $ 3,099 | ||
| Occupancy | $ 2,888 | $ 2,945 | $ 3,263 | ||
| Operating losses | $ 3,124 | $ 4,321 | $ 3,523 | ||
| Professional and outside services | $ 6,588 | $ 6,745 | $ 6,706 | ||
| Advertising and promotion | $ 857 | $ 1,076 | $ 600 | ||
| Restructuring charges | $ 1,499 | ||||
| Other | $ 6,681 | $ 4,687 | $ 4,129 | ||
| Total noninterest expense | $ 52,377 | $ 58,484 | $ 56,126 | $ 58,178 | $ 57,630 |
| Income before income tax expense | $ 32,120 | $ 27,377 | $ 28,538 | $ 24,198 | $ 581 |
| Income tax expense | $ 10,075 | $ 4,917 | $ 5,662 | $ 4,157 | $ (3,005) |
| Net income before noncontrolling interests | $ 22,045 | $ 22,460 | $ 22,876 | $ 20,041 | $ 3,586 |
| Less: Net income from noncontrolling interests | $ 107 | $ 277 | $ 483 | $ 492 | $ 285 |
| Wells Fargo net income | $ 21,938 | $ 22,183 | $ 22,393 | $ 19,549 | $ 3,301 |
| Less: Preferred stock dividends and other | $ 1,565 | $ 1,629 | $ 1,704 | $ 1,611 | $ 1,591 |
| Wells Fargo net income applicable to common stock | $ 20,373 | $ 20,554 | $ 20,689 | $ 17,938 | $ 1,710 |
| Per share information | |||||
| Earnings per common share | $ 4.03 | $ 4.14 | $ 4.31 | $ 4.08 | $ 0.42 |
| Diluted earnings per common share | $ 3.99 | $ 4.10 | $ 4.28 | $ 4.05 | $ 0.41 |
| Average common shares outstanding | $ 5,052.8 | $ 4,964.6 | $ 4,799.7 | $ 4,393.1 | $ 4,118.0 |
| Diluted average common shares outstanding | $ 5,108.3 | $ 5,017.3 | $ 4,838.4 | $ 4,425.4 | $ 4,134.2 |
Ratios
| amounts in millions | Citigroup | Wells Fargo |
| Noninterest expense | $ 43,171 | $ 57,630 |
| Noninterest income | $ 30,750 | $ 32,505 |
| Burden | $ 12,421 | $ 25,125 |
| 2020 total assets | $ 1,951,158 | $ 1,955,163 |
| 2019 total assets | $ 2,260,090 | $ 1,927,555 |
| Net noninterest margin | 0.59% | 1.29% |
| Net interest income | $ 43,548 | $ 39,835 |
| Efficiency ratio | 58.11% | 79.67% |
| Total equity capital | $ 200,200 | $ 185,920 |
| Net income | $ 11,047 | 3301 |
| ROE | 5.52% | 1.78% |
| Interest income | 2.23% | 2.04% |
| Noninterest income | 1.58% | 1.66% |
| Overhead efficiency | 71.23% | 56.40% |
| Revenue | $ 74,298 | $ 72,340 |
| Profit margin | 14.87% | 4.56% |
