Audimation Services has been acquired by CaseWare International Learn More.

X
Icon


Blog Image

Loans and Mortgages

CaseWare IDEA Applications


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.


Areas of Applications , CaseWare IDEA



Posted By

By Audimation Team


Related Posts
Applying Fuzzy Logic to Acquire Clear Results
Oct 01 Fuzzy logic techniques are an effective way to normalize data to identify potential matches, duplicates, errors or fraud. Here are some tips and techniques from...
No Image
Nov 07 The SmartAnalyzer Financial App and other Audimated Apps are very powerful additions to IDEA. However, some users may find that they need a little assistance us...
5 Ways Manufacturers are Using Analytics to Make Data-Driven Decisions
Nov 20 At times, any manufacturing enterprise can feel like a web of mysteries and riddles. Just keeping track of all the moving parts—from supplier relationships to...
BROWSER NOT SUPPORTED

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

×