X AutoSave On g - - mgmnt4000 . Saved v Search briana martinez BM X File Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share Calibri 11 A" A = Insert General EV AY O Ex Delete Paste B IUV = $ % 9 08 20 Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting Table v Styles v Format D Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity U24 vi XVfx Finanical Ratios for Bank of America & Wells Fargo Bank of America Wells Fargo 3 Formulas Used 2022 2021 2020 2022 2021 2020 4 Total liabilitiessets Total Debt Ratio 0.110846229 0.09911486 0.15757388 Total Debt Ratio 0.903310232 0.90241100 0.904905037 Total liabilitiesal assets Current Ratio 0.910467576 0.914792104 0.903205637 Current Ratio 0.903310232 0.902411004 0.904905037 6 Net income/Total Revenue Profit Margin 0.289921011 0.358847755 0.209218034 Profit Margin 0.457152766 0.50448341 0.098431853 7 Total Revenue/Total assets Total Asset Turnover $1.11711933 8.11583549 30.33309016 Total Asset Turnover 15.3294815 21.925826 7.56762085 8 Net Income/ Total assets Return on Assets (ROA) .021506698 10.08930445 6.346229484 Return on Assets (ROA) .007914872 1.06121552 1.729213466 9 Non-Interest Expense/Revenue Efficiency Ratio .647056345 0.670283797 0.645554672 Efficiency Ratio 1.98654413 1.26029546 1.679783141 10 Interest Inc-Interest Exp./Total Assets Net Interest Margin 17.19290484 13.54600654 15.37792055 Net Interest Margin 23.8966601 18.36640199 20.45971373 11 12 Companies Financials Bank of America 2022 2021 2020 Companies Financials Wells Fargo 2022 2021 2020 13 Net Income 27,528,000.00 5 31,978,000.00 $ 17,894,000.00 Net Income 13,182,000.00 $ 21,548,000.00 $ 3,377,000.00 Total Assets S 3,051,375.00 $ 3,169,495.00 S 2,819,627.00 otal Assets 1,881,016.00 $ 1,948,068.00 $ 1,952,911.00 15 Total Liabilities 2,778,178.00 $ 2,899,429.00 $ 2,546,703.00 Total Liabilities 1,699,141.00 $ 1,757,958.00 $ 1,767,199.00 Total Revenue, net int. expense 94,950,000.00 $ 89,113,000.00 $ 85,528,000.00 Total Revenue 28,835,000.00 $ 42,713,000.00 $ 34,308,000.00 Non Interest Expense $ 61,438,000.00 $ $9,731,000.00 $ 55,213,000.0 Non Interest Expense 57,282,000.00 $ 53,831,000.00 $ 57,630,000.00 Interest Income $ 72,565,000.00 $ 47,672,000.00 S 51,585,000.00 Interest Income 54,024,000.00 $ 39,694,000.00 $ 47,919,000.00 Interest Expense $ 20,103,000.00 $ 4,738,000.00 $ 8,225,000.00 Interest Expense S 9,074,000.00 $ 3,915,000.00 $ 7,963,000.00 Comparing Ratios Within the 3 years For Bank of America Comparing Ratios within the 3 years for Wells 30 2022 2021 2020 Fargo 25 2022 2021 2020 20 30 15 25 10 20 15 --- 10 Total Debt Current Profit Total Asset Return on Efficiency Net Ratio Ratio Margin Turnover Assets Ratio interest (ROA) Margin Total Debt Current Profit Total Asset Return on Efficiency Net Interest Ratio Ratio Margin Turnover Assets Ratio Margin (ROA) 39 40 Sheet1 + Ready TX Accessibility: Investigate - - + + 71% 85F 2:38 PM Windy Q Search W 8/11/2023 1