Financial statement analysis for Regions bank in USA. complete ratios in excel using balance and income statement using Wall Street journal or SEC. Annual rations for 2018 and 2019

1 answer below »
Financial statement analysis for Regions bank in USA. complete ratios in excel using balance and income statement using Wall Street journal or SEC. Annual rations for 2018 and 2019
Answered Same DayOct 31, 2021

Answer To: Financial statement analysis for Regions bank in USA. complete ratios in excel using balance and...

Sumit answered on Oct 31 2021
158 Votes
Sheet1
    Ratios (in millions)     2019    2018
    ROE    9.71%    10.39%
    ROA     1.2532%    1.2475%                    Notes:
2019     2018
    Equity Multiplier    7.747161706    8.3292246521
    Profit Margin    78.05%    79.67%                    net income             total equity capital
    Asset Utilization    1.6057%    1.5658%                    1582    1568        16295    15090
    Net interest Margin    3.399%    3.427%
    Spread    2.739%    3.096%                    operating income
    Overhead Efficiency    60.65%    56.55%                    2027    1968
    Profit Margin Components
    Interest Expense Ratio    23.87%    17.62%
    Provision for loan loss ratio    19.09%    11.64%                    total assets
    Noninterest expense ratio    165.47%    182.57%                    126240    125688
    Tax Ratio    19.882%    19.665%
    Interest Expenses as a Percentage of total operating income
    NOW accounts     39.2131228416    39.806402439                    total liabilities
    MMDAs and other savings    8.8751850025    8.2073170732                    109945    110598
    Foreign deposits     -     -
    Retail CDs    8.8751850025    8.2073170732                    Interest Bearing Liabilities
    Wholesale CDs     ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here