...
...
Aapplication

ARBUTUS ANALYZER

Data Analysis in Banking and Finance...

A Few of the Ways You can Put Arbutus Analytics to Work in Banking & Finance

  • Loans by Bank
    or Branch
  • Real Estate
    Loans
  • Investment
    Securities
  • Pensions and
    Other Trusts
  • Credit Card
    Management

Loans By Bank or Branch

  • Subtotal, total, and print outstanding loan balances by any categories
  • Calculate unearned revenues from interest, discounts, insurance, etc.
  • Isolate delinquent accounts issued prior to a specific date
  • Identify loans over or under specified amount, terms, or interest rate
  • Test liability (by branch, location, etc.) in excess of lending limits
  • Identify accounts with balances exceeding credit limits by overage

Real Estate Loans

  • Print a schedule of pre-paid accounts in any order or selection
  • Verify daily interest accrued, detail or summary, by any criteria
  • Track activity and market value of collateral of non-performing loans

Investment Security

  • Calculate average yield by investment type and show detail variances
  • Select samples of purchases and sales since last audit
  • Identify investments for which no dividends or interest have been received
  • Compare computed interest to amount actually received on investments

Pension and Other Trusts

  • Scan and total the schedule of investments (year-end or year-to-date)
  • Verify accrued interest calculations for assets in trust accounts
  • Select trust assets for auditing current market value
  • Extract trust asset information based on any criteria
  • Check participants’ file for nonallowable data (age, seniority, gender)
  • Verify interest and capital gain income/loss distributed to accounts

Credit Card Management

  • Identify and list accounts past due for specified time, order by amount
  • Extract accounts with balances over credit limit and sort by any criteria
  • Test for specific conditions (excessive adjustments, credits, etc.) by account
  • Select and print detail activity for auditing selected accounts
  • Recalculate and verify current month’s interest charges