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
Even the Lone Ranger Didn’t Ride Alone
Jul 20 Have you ever heard the expression, "It’s not what you know but who you know"? The workplace of today is far different than it was even a few ye...
Tech Tip: Using Top Records Extraction
May 26 One of the critical advantages data analytics delivers is the ability to slice and dice data, then search for any anomolies or anything else out of place that m...
Expensive Expenses: Identifying Fraud in T&E
Nov 13 Expense Reports and Travel and Entertainment expenses are both common areas for fraud and challenging to find. These frauds are complex and contain a mix of pre...
BROWSER NOT SUPPORTED

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

×