This article is intended for banks, insurance companies and licensed non-bank credit providers, including organizations going through a licensing process, that are evaluating a mortgage management system. It presents a practical checklist for the five areas in which a mortgage system is actually tested: interest and amortization schedules, indexation, fees, arrears and collection, and regulatory reporting.
In short: a vendor presentation is not enough to know whether a system calculates correctly. The way to check is to ask the vendor to run scenarios from your own portfolio in the system, such as a mix of several tracks, the publication of a new index, a partial early repayment and a missed payment, and to compare the results with calculations you already know. Any calculation the vendor suggests performing outside the system, in a spreadsheet or as a future “customization”, is a sign that the system was not built for the Israeli market.
We covered which system suits a non-bank lender and which capabilities it should include in the article Recommended Mortgage Management System for Non-Bank Lenders in Israel. This article deals with the next stage: how to test those capabilities in practice, before you choose.
How to Structure the Evaluation
A mortgage system is tested on the complex cases, not the simple one. Almost any system will produce a correct amortization schedule for a single loan on a single track. The differences appear in a mix of several tracks, in a change midway through the life of the loan, in arrears that roll into a debt arrangement, and in a regulatory change that requires the calculation method to change.
It is therefore worth preparing a few sample cases from your own activity in advance, together with the results you expect, and asking the vendor to run them in the demo. This makes it possible to compare vendors on the same data, rather than on a general description of capabilities.
1. Interest and Amortization Schedules
Check that the system calculates every interest type used in Israel, prime, fixed and variable, indexed and non-indexed, and produces amortization schedules using the Spitzer method and any other methods the organization offers its customers. Scenarios worth running:
- A single loan with a mix of several tracks, checking that the total monthly payment and the amortization schedule of each track match your calculation.
- A change in the prime rate, checking that payments on the affected tracks update automatically, without manual intervention.
- A track switch or a payment freeze midway through the life of the loan, checking that the new schedule is built correctly from that point.
In CAV Mortgages by CAV Systems, interest calculations and amortization schedules cover every type commonly used in Israel. At the pre-mortgage stage the system includes track planning and simulations for building the loan mix, and in ongoing management it supports track changes and payment freezes.
2. Indexation
Tracks linked to the Consumer Price Index are a common part of mortgage portfolios in Israel, and indexation affects the balance, the monthly payment and the early repayment amount. Scenarios worth running:
- The publication of a new index, checking that the balances and payments of all indexed loans in the portfolio update together.
- An early repayment of an indexed track, checking that the repayment amount correctly includes the indexation differences.
- A question for the vendor: what happens when the regulator changes the indexation mechanism. In a system built for the local market this is a version update; in another system it may be a development project.
CAV Mortgages includes CPI indexation as part of its core calculation engine. Assaf Bardach, CEO of CAV Systems, notes that a change in the indexation mechanism is one example of the changes that require an immediate update to the business logic, and that when the platform was built for the Israeli market, the response to such a change is almost immediate.
3. Fees
Fees in a mortgage portfolio are charged at different points over the life of the loan, and their calculation, especially the capitalization fee on early repayment, is one of the places where an error reaches the customer directly. Scenarios worth running:
- A full and a partial repayment of a loan, including the capitalization fee and the repayment fee, compared with the calculation you know.
- Charging a setup fee when the loan is executed, checking that it appears in the documents the system produces for the customer.
- A question for the vendor: how long it takes to change the way the capitalization fee is calculated, if the relevant rules change.
CAV Mortgages calculates capitalization, repayment and setup fees, handles early repayments and partial and full settlements, and produces the related documents and confirmations directly from the system.
4. Arrears and Hard Collection
Managing arrears is more than calculating arrears interest. It is a process that starts with a missed payment and may end in a debt arrangement or legal action, and every stage of it is subject to the law, including the Fair Credit Law. Scenarios worth running:
- A monthly payment that was not collected through Masav or a standing order, checking that the system identifies it, calculates arrears interest and produces a warning letter.
- A debt arrangement or rescheduling of the arrears balance, checking that the new schedule and the arrangement are recorded in the loan file.
- Transferring a file to legal action, checking that the handling with the lawyer is recorded in the system and not outside it.
- A portfolio-wide payment deferral under a regulatory decision, for example during wartime, checking how quickly it can be applied to the entire portfolio.
The hard collection stage in CAV Mortgages includes managing loans in arrears, arrears interest, debt arrangements, rescheduling, warning letters and recording legal handling with a lawyer. Ongoing collection is carried out through Masav, standing orders and debit cards.
5. Regulatory Reporting and Compliance
An organization that provides mortgages in Israel is subject, depending on its type, to the directives of the Bank of Israel or to the Capital Market, Insurance and Savings Authority, as well as to the Credit Data Law, the Fair Credit Law and anti-money laundering regulations. Questions worth checking with the vendor:
- Which reports are produced directly from the system, and which require collecting data from several sources.
- Whether the system is connected to the Credit Data Register, and how ongoing reporting to it is carried out.
- What happens when a new directive is issued: who updates the system, how quickly, and whether the update arrives as a version update or as a separate project.
- Whether any data point on any loan can be retrieved from the system with a query, without requesting a special report from the vendor.
CAV Systems' banking systems were built for the Israeli market and comply with the directives of the Bank of Israel, the Capital Market, Insurance and Savings Authority, the Credit Data Law, the Fair Credit Law, anti-money laundering regulations and the Proper Conduct of Banking Business directives. CAV Mortgages produces regulatory reports for the Bank of Israel alongside profitability and fair value reports, and connects to the Credit Data Register and to Masav. A smart version update mechanism makes it possible to implement regulatory changes within a few days.
Signs That a System Was Not Built for the Israeli Market
If one or more of the following signs comes up in a demo, it is worth asking for details before moving forward:
- Some calculations are performed in an external spreadsheet, or presented as a capability that will be added later.
- A change in the indexation mechanism or in the way a fee is calculated is described as a development project rather than a version update.
- Reports to the regulator are assembled manually from data in several systems.
- The arrears process stops at a warning letter, and the arrangement or legal handling is managed outside the system.
- There is no answer for a portfolio-wide payment deferral under a regulatory decision.
Summary
A mortgage management system is judged by the accuracy of its calculations and by how quickly it is updated when the rules change. The five areas above are where the gaps between systems become visible, and scenarios from your own portfolio are the direct way to see them before you choose.
CAV Mortgages by CAV Systems has been implemented and running at institutional organizations for more than 25 years, and covers the entire loan lifecycle, from pre-mortgage through hard collection. Organizations that have chosen it include Bank of Jerusalem, Clal Insurance, Harel Insurance, The Phoenix and Mimun Yashir. We covered the decision between buying a system and developing one in-house in the article Build or Buy a Loan and Mortgage Management System.