Bank Income Statement | Tableau Exchange

Bank Income Statement

by Tableau

Description

An income statement is one of the major financial statements of a bank and shows the company’s income and expenses during a particular period. It indicates how the interest and noninterest incomes are transformed into net income.

This Tableau Accelerator allows you to:

  • Appraise your financial results (income & expense): Income Statement, Waterfall, Annual Report, Branches
  • Leverage what-if analysis to simulate different business scenarios and explore possible outcomes on your bottom-line results

Demo video

Answer key business questions

  • What are the results and performance of the bank?
  • Which branches drive this performance?
  • What would be the impact of a 2.5% growth in net interest income on our bottom line results?
  • How much income has the bank generated?
  • How does it trend?

Monitor and improve KPIs

Client Assets & Liabilities

  • Total Loans: Total amount of money loaned at interest to borrowers (expressed in currency)
  • Total Deposits: Total amount of money placed in a bank account (expressed in currency)

Interests

  • Total Interest Income: Total income generated by Interests over the period, i.e. earned by lending money (expressed in currency)
  • Total Interest Expense: Total costs incurred for borrowed funds over the period (expressed in currency)
  • NII (Net Interest Income): Total amount of the difference between the interest income earned from lending activities and the cost incurred for borrowed funds (expressed in currency)

Noninterest

  • Noninterest Income: Total income that noninterest-related activities have generated over the period (expressed in currency)
  • Total Revenue: Total amount of the net-interest income and non-interest income over the period (expressed in currency)
  • Noninterest Expense: Total operating expense that is classified separately from interest expense and provision for credit losses (expressed in currency)
  • Provision: Expense set aside to allow for uncollected loans and loan payments (expressed in currency)

Income

  • Income Before Income Taxes: Net income after payment of all operating expenses, except income tax (expressed in currency)
  • Total Income Taxes: Total levy imposed on the basis of income received (expressed in currency)
  • Net Income: Total amount of the difference between income from lending activities and all the associated expenses, taxes included (expressed in currency)

Efficiency Ratios

  • Loan-to-deposit Ratio: Assess the bank’s liquidity by comparing its total loans to its total deposits. The ideal loan-to-deposit ratio is 80% to 90% (expressed in %)
  • NIM (Net Interest Margin): Amount of money that a bank is earning in interest on loans compared to the amount it is paying in interest on deposits (expressed in %)
  • Efficiency Ratio: It shows how well back-office expenses are controlled, by dividing non-interest expenses by revenues. The lower the efficiency ratio, the better (expressed in %)

Required attributes

  • Month (date): Date of the period
  • Branch (string): Designation of the branch
  • Measure Name (string)*: Name of the measure
  • Measure Breakdown (string): Level of detail you want to add to your measure
  • Measure Value (numeric)*: Amount associated with the “Measure” attribute

* [Measure Name] is an attribute where specific values are expected. For each [Measure Name], the corresponding value must be set in [Measure Value] attribute

Expected values in [Measure] attribute:

  • “Loans”: Amount of money loaned at interest to borrowers (expressed in currency)
  • “Deposits”: Amount of money placed in a bank account (expressed in currency)
  • “Interest Income”: Income generated by Interests over the period, i.e. earned by lending money (expressed in currency)
  • “Interest Expense”: Costs incurred for borrowed funds over the period (expressed in currency)
  • “Noninterest Income”: Income that noninterest-related activities have generated over the period (expressed in currency)
  • “Noninterest Expense”: Operating expense that is classified separately from interest expense and provision for credit losses (expressed in currency)
  • “Provision”: Expense set aside to allow for uncollected loans and loan payments (expressed in currency)
  • “Income Taxes”: Levy imposed on the basis of income received (expressed in currency)

Features

Supports data mapping

Resources

Developer WebsitePrivacy PolicyTerms of Service

Download and start your free trial of Tableau today.

Try Tableau Now