Configuring the Business Formulas

Business Formulas processes different inputs from your digital journey in order to generate desired outputs. The formulas developed for this journey are to filter the customers that do not meet the minimum standards, to determine the scoring of each applicant and the maximum debt-to-value to increase the mortgage offer. The formulas can be modified and extended to fit business requirements for any financial institution, even the trigger for them can be modified.

The formulas used are:

The system triggers the calculations in the form driven flow FTOS_BARET_MortgageDIPAnalysis > step MortgageDIPAnalysis > Advanced > After Events > script FTOS_BNKAP_FinancialAnalysis:

1. executes the formula MORTGAGE_KO_DIP. Two eligibility criteria are defined in MORTGAGE_KO_DIP:
   • If the time employed in the current job is less than 6 months for any applicant, the applicant is rejected
   • If the citizenship is not British, then the loan application is rejected.

   Both criteria must be met for the application to be accepted.

2. Then, the system determines how incomes and spending are weight in and compounded after tax in United Kingdom (calculates all the incomes: yearly income before tax including secondary sources of income for each applicant, then calculates the income after tax, then merges the income with the co-applicant to result the total income before tax in a year). Weight in every income using the following proportions:

   For employed persons:

   • Income type
   • Weight in
   • salary 100%
   • Overtime 100%
   • Allowances 90%
   • Commission 90%
   • Bonuses 80%
   • Pension 100%
   • Investments 50%
   • Maintenance 50%
   • Trust Funds 50%.

   For self-employed persons, to determine the income on a monthly basis:

   • Net profit in most recent complete tax year/12
   • Net profit in previous complete tax year/12.
3. calculates monthly net income for each applicant:

   Then, the system calculates the average between the two indicators. This determines our monthly eligible profit (before applying tax). Then, the system adds the secondary sources of income using the same weight in as for employed persons. After, the system applies the weigh in for every income source, the system adds them all together for each applicant. Finally, the total income before taxes per month for each applicant is saved in the database. The system calculates the income after tax by apply tax brackets by applying the tax brackets to calculate the monthly income after tax and insurance.

   UK Income Tax (excluding Scotland)
   Tax Band	Tax Rate	Taxable Income
   Personal Allowance	0%	Up to £12,570
   Basic Rate	20%	£12,571 to £50,270
   Higher Rate	40%	£50,271 to £150,000
   Additional Rate	45%	£150,001 or more
   National Insurance (Class 1 — for Employees Only)
   How much you earn	How much you are going to pay
   Less than £9,568	0%
   £9,569 to £50,270	12%
   More than £50,270	2%

   The result is the monthly total income after tax and insurance.

4. calculates the value of the spendings on a monthly bases and calculates the spendings on dependents. Then, the system aggregates expenses and calculate the existing DTI. Based on the expenses:
   • For credit card and overdraft that the applicants have declared, the system takes into account a monthly cost/instalment equal to 3% of the declared credit limit.
   • Council tax, Ground rent, Service charge: the system determines the monthly spending amount for them
   • Number of dependants: for every dependent that the user has declared, the system calculates an expense of 300 GBP per month.
5. using the simulation Credit Bureau integration to get all the existing credit(s) the applicant has and adds all the monthly instalments to expenses for both applicants. The result is the monthly expenses.
   IMPORTANT!  
   The integration is mocked. It is subject to internal implementation.
6. calculates the scoring for each applicant using MORTGAGE_SCORING_DIP to get the current DTI, if it is bigger than 50% the application fails. If the current DTI is smaller than 50%, the system calculates the maximum DTI. The applicants fall into a risk level category used in RWM_MAXDTI_DIP to determine the maximum offer. Finally, the monthly available amount for loan is determined, i.e., the maximum monthly instalment.
   Calculate Debt-To-Income (DTI)

   The incomes/expenses for both applicants are added to create one income/expenses for the DIP for Mortgage application. The result is the income/expenses for the application. Using these two values, the system calculates existing DTI at an application level:

   application expenses / application income = current DTI

   Calculations based on DTI

   Using the current DTI, the system can determine whether the loan is rejected. If the DTI is bigger than 50%, it is rejected: if current DTI > 50% - Loan request is rejected

   Scoring Calculations

   Each applicant has to pass the scoring calculations.

   Maximum DTI Calculations

   Use the scoring matrix and establish maximum DTI permitted for the customer by combining FICO score The FICO score is an algorithm used internationally, mainly by banks, to determine the degree of risk for a person who applies for a loan, and is collected by the Credit Bureau. and applicant score. To establish the maximum DTI, the system uses the long term DTI for the calculated performance category (A,B,C,D). In case there are two applicants, the system uses the performance category graded the lowest between the 2 applicants.

   Using the maximum permitted DTI by the matrix for the mortgage application, the system calculates the requested offer.

MORTGAGE_KO_DIP

This formula determines whether the applicant can continue the process by meeting the standards needed for citizenship and employment.

Formula steps:

result = DataSet("MORTGAGE_KO_DIP_Employment", ("MORTGAGE_KO_DIP_Employment", experienceMonths)) == 1;

result = DataSet("MORTGAGE_KO_DIP_Citizenship", ("Citizenship", citizenship)) == 1;

result = MORTGAGE_KO_DIP_Citizenship || MORTGAGE_KO_DIP_Employment;

Data set MORTGAGE_KO_DIP_Citizenship

This matrix sets values for each citizenship available.

Data set MORTGAGE_KO_DIP_Employment

This matrix discriminates between the users, those who have been working under 6 months fail the application.

Mortgage_DIP_WeightIncome

This formula determines the weight of the income.

Formula steps:

result = DataSet("Mortgage_DIP_WeightIncome", ("IncomeType", incomeType));

result = incomeAmount * DIP_IncomeType;

Data set Mortgage_DIP_WeightIncome

Depending on the source of income, the application scores higher with salary, pension and overtime being the highest scoring.

MORTGAGE_SCORING_DIP

This formula determines the scoring based on the age, marital status, employment status, the number of dependants, the time spent in employment, the days past due Days Past Due (DPD) indicates your financial history,i.e., whether you have been consistent in your repayments and if you have missed any, how many instalments you have missed and by how many days. It also reflects your credit card repayment history., the number of active loans. If the application has two applicants, the system calculates the scoring for all the applicants.

Formula steps:

result = DataSet("SCORING_DIP_Age", ("Age", age));

result = DataSet("SCORING_DIP_MaritalStatus", ("MaritalStatus", maritalStatus));

result = DataSet("SCORING_DIP_EmploymentStatus", ("EmploymentStatus", employmentStatus));

result = DataSet("SCORING_DIP_DependantsNo", ("DependantsNo", dependantsNo));

result = DataSet("SCORING_DIP_TimeAtCurrentEmployer", ("TimeSpentCurrentEmployer", employmentTime));

result = DataSet("SCORING_DIP_DPD", ("DPD", DPD));

result = DataSet("SCORING_DIP_ActiveLoansNo", ("ActiveLoansNo", activeLoansNo));

result = DIP_Age + DIP_MaritalStatus + DIP_EmploymentStatus + DIP_DependantsNo + DIP_EmploymentTime + DIP_DPD + DIP_ActiveLoansNo;

if (FICOScore != 0)
    result = DataSet("SCORING_DIP_FICOScore", ("FICOScore", FICOScore));
else result = "Approved";

result = DataSet("SCORING_DIP_ApplicationScore", ("ApplicationScore", ApplicationScore));

if (FICOScore_Decision == "Rejected" || ApplicationScore_Decision == "Rejected")
    result = "Rejected";
else if (FICOScore_Decision == "Derogation" || ApplicationScore_Decision == "Derogation")
    result = "Derogation";
else result = "Approved";

result = DataSet("SCORING_DIP_ClientCategory", ("UserScore", ApplicationScore));

Data set SCORING_DIP_ActiveLoansNo

This matrix determines a value depending on the number of active loans a customer has.

Data set SCORING_DIP_Age

This matrix determines a value depending on the age the customer has.

Data set SCORING_DIP_ApplicationScore

This matrix determines a value depending on the application score.

Data set SCORING_DIP_ClientCategory

This matrix determines a value depending on the user score the customer received.

Data set SCORING_DIP_DependantsNo

This matrix determines a value depending on the number of dependents a customer has, the higher the number, the higher the value.

Data set SCORING_DIP_DPD

This matrix determines a value depending on the days-past-due.

Data set SCORING_DIP_EmploymentStatus

This matrix determines a value depending on the type of employment declared by the customer.

Data set SCORING_DIP_FICOScore

This matrix determines a value depending on the FICO score The FICO score is an algorithm used internationally, mainly by banks, to determine the degree of risk for a person who applies for a loan, and is collected by the Credit Bureau. the customer has.

Data set SCORING_DIP_MaritalStatus

This matrix determines a value depending on the marital status declared by the customer.

Data set SCORING_DIP_TimeAtCurrentEmployer

This matrix determines a value depending on the time the customer has been employed at the present job.

RWM_MAXDTI_DIP

This formula determines the maximum debt-to-income the applicant can support with their current income-expenses situation.

Formula steps:

result = DataSet("RWM_MaxDTI_DIP", ("ClientCategory", clientCategory));

Data set RWM_MaxDTI_DIP

This matrix determines a value depending on the client category.

Mechanism for calculating the maximum loan amount

• Determine the total income of all applicants
• calculate the debt-to-income (DTI) by dividing expenses to the total income value
• compare the DTI to the maximum DTI available in the scoring matrix. If DTI is bigger than maximum DTI from scoring matrix, then the user is not eligible to a loan. If the DTI is smaller than the maximum DTI in the scoring matrix, then the system displays the next step
• calculate available DTI = Max DTI in the matrix - DTI
• based on available DTI, calculate the maximum loan amount the user is eligible for
• the result is the maximum loan amount.