X
Icon

The 21st Minute


Blog


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 Team Audimation


Related Posts
Tech Tip: Duplicate Identification
Aug 28 Raw data is often incomplete, messy and inconsistent. One of the first steps in the data preparation process is the detection and removal of duplicate records. ...
Wayfair Woes One Year Later
Jul 24 The rise in online shopping has sharply impacted state sales tax revenue. Rather than increasing the tax rate, states are setting parameters to define nexus, wh...
Importing Date Fields
Jul 24 There are times when you import a date field and it just does not work out as expected. Here are ways to address the problem before or after the import.  ...
BROWSER NOT SUPPORTED

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

×