X
Icon

The 21st Minute


Blog

Loans and Mortgages

CaseWare IDEA Applications


Here are some examples of analyses that can be performed using IDEA. Data from different systems can be brought together for complete analysis. Ultimately, you are only limited by your imagination.

The following tests are relevant where the accounts are either commercial or personal loans.

Analyses

  • Stratify balances and create a summary file
  • Analyze balances and interest rates by risk rating
  • Analyze the file over internal accounts and customer account types
  • Analyze interest margin on accounts by type
  • Analyze load portfolio by servicing officer, location, loan type, etc.
  • Review and analyze underlying collateral on loans secured by Accounts Receivable and Inventory
  • Summarize load portfolio information based on data in any field
  • Summarize loans by collateral and purpose to analyze portfolio risk

Calculations

  • Cast (or total) accrued interest, balance
  • Reprove arrears calculations and reporting
  • Check interest and service fee calculations

Matching and Comparing

  • Use cross-matching techniques to pick up multiple loans to the same address
  • Compare balances at different periods to identify movements

Exception Tests

  • Identify staff loans
  • Identify large loans
  • Identify loans with unusual interest rates
  • Identify balances greater than original advances
  • Identify negative balances
  • Create custom reports on new, renewed and past due loans

Other useful tests include stratifying interest rates against each risk rating. Generally higher risk loans should bear a higher rate of interest. The analysis followed by exception testing can pick up anomalies or branches/individuals that are either risky or particularly prudent in their lending.


Applications , CaseWare IDEA



Posted By

By


Related Posts
Give Python a Go
Mar 29 Python is considered the official programming language for non-programmers. It gives you increased flexibility and expansive access to your data. For those usin...
Unconventional Analysis
Jan 24 Data is often underutilized. The opportunity to use data analytics to gain insights, add more value and unravel opportunities are endless. We’ve rounded u...
5 Avenues for Importing Data into IDEA
Nov 21 One of the greatest benefits to CaseWare IDEA is the sheer amount of data it can read and make universally consumable – both in file types and in data...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×