Lien management and loan to value ratio calculations

A lien is a claim or legal right against assets that are used as collateral to satisfy a debt. In a secured loan application, it is important to record any existing liens on collateral and to calculate the loan-to-value (LTV) ratio or the combined loan-to-value (CLTV) ratio by considering the proposed debt associated with an application.

With the Hydrogen release of Q2 Origination, the system is enhanced to:

Perform effective lien management on collateral by recording and managing existing liens on a product.
Record any other existing bank liens, and view if the collateral is linked to other applications.
Provide standard LTV/CLTV ratio calculations.
View the LTV ratio considering all the senior liens.
View the CLTV ratio considering all the existing liens.

Key Concepts

Lien Position

It is the ranking of the lien of the bank in relation to that of the other banks. The ranking is based on Static Values, such as First, Second, Third, Fourth, and so on. It is enabled if the nature of the lien is a Fixed Amount. The Lien Position up to 10 is allowed. The position should not be skipped, that is, if a Lien Position of 5 is assigned, the earlier four liens must be captured.

Lien Amount

It is the amount of the lien that the selected bank has on the collateral if the nature of lien is a Fixed Amount.

Lien Disposition

This is an optional field that the user records for any existing liens that may get paid off from the proceeds of the current loan application. This field depicts the status of the lien.

Loan-to-Value (LTV) ratio

It is the ratio of a loan to the value of an asset purchased. The term is commonly used by the financial institutions to represent the ratio of the loan borrowed as a percentage of the total appraised value of a real estate property.

For example, if someone borrows $96,000 to purchase a house worth $120,000, the LTV ratio is $96,000 to $120,000 or $96,000/$120,000, or 80%. The remaining 20% represents the lender's haircut, adding up to 100%, which is covered by the borrower's equity. The higher the LTV ratio, the riskier the loan is for a lender.
LTV ratio is one of the key risk factors that lenders assess when qualifying borrowers for a mortgage. The risk of default is always at the forefront of lending decisions, and the likelihood of a lender absorbing a loss increases as the amount of equity decreases.

CLTV ratio

It is the proportion of loans (secured by a property) in relation to its value. The CLTV ratio adds additional specificity to the basic loan to value, which indicates the ratio between one primary loan and the property value. The term, combined indicates that additional loans on the property have been considered for the calculation of the percentage ratio.

CLTV ratio represents the aggregate principal balance(s) of all mortgages on a property divided by its appraised value or purchase price, whichever is less. Distinguishing CLTV ratio from LTV ratio serves to identify loan scenarios that involve more than one mortgage.

For example, a property valued at $100,000 with a single mortgage of $50,000 has an LTV ratio of 50%. A similar property with a value of $100,000 for a first mortgage of $50,000 and a second mortgage of $25,000 has an aggregate mortgage balance of $75,000, thereby amounting the CLTV ratio to 75%.
CLTV ratio is an amount in addition to the LTV ratio, which represents the first position mortgage, or loan as a percentage of the property's value.

A Collateral Type

It describes the type of collateral being pledged to a loan opportunity and drives the application processing requirements associated with the collateral.

A Collateral Category

It categorizes the assets or collaterals that you associate with a loan opportunity. It serves as a grouping mechanism for a large variety of potential Collateral Type values that you can configure in Q2 Origination and enables you to categorize them into smaller groups. The system administrator can define custom collateral categories, such as, Business Assets or Real Estate. Collateral Types can be considered as sub-categories of collateral categories.

If there are any existing liens, you can capture the lien position, and record the liens, based on the agreement with the borrower. You can view any collaterals that are linked to other applications. The loan amount linked to each of these liens is also recorded. You can also capture the outstanding loan amount in other banks against liens. Considering the existing liens, the values of the LTV ratio and the CLTV ratio vary.

When you have the pledged collateral value on the collateral, enter the lien amount and the lien position, and also update the status of the lien on the application. Any pledged value on the application for a specific collateral is also considered as part of the overall lien position. If the same collateral is linked to other applications, the reference of that application (Application ID) and the application status are displayed on the application.

Manage Liens on the Collateral

Prerequisites

The following is the prerequisite to record a lien on the collateral:

Collateral Valuation Record is created for the collateral.

Steps

Perform the following steps to record a lien on the collateral:

Log in to your Salesforce account.
Select the App Launcher > Q2 Origination.
On the Applications tab, select the required application ID.
On the Collateral tab, select the ellipsis, and then select Pledge Collateral Value.
This section displays the appraised value of the collateral and the remaining value on the collateral.
Remaining Value= AppraisedValue - Total Lien Amount
You can add or edit the lien amount on the application, and also record the lien position for the lien.
In the Associated Liens section, you can manage the liens associated liens with that collateral.

Note:
To understand the terms related to this section, see Associate Lien table.

Select Save.

Field Name	Description
Comments	These are any comments that can be added.
Lien disposition	An option can be selected from the following list: To be paid with proceeds of the loan To be paid at closing To be paid prior to closing Subordinated Satisfied This is an optional field that the user records for any existing liens, which may get paid off from the proceeds of the current loan application. This field depicts the status of the lien.
Lien Status	The status of the lien that the other banks have on the collateral. The options include the following: Proposed: This is the default value until the loan is closed. Open: This is when the lien is in place. Satisfied: This depicts that the loan linked to a lien has been paid off, and the lien no longer exists. When a new lien is added, the status is set to Proposed, and the details are saved the first time. Later, the status needs to be updated as part of the origination and the servicing flow.
Lien ID	It is the unique ID for the lien.
Bank Code	It is the bank code and the name of the bank related to the lien.
Nature of Lien	It is the nature of the lien to be recorded. For example, the values could be Fixed Amount, Percentage, and more.
Lien Position	It is the ranking of the lien of the bank in relation to that of the other banks. The ranking is based on Static Values, such as First, Second, Third, Fourth, and so on. It is enabled if the nature of the lien is a Fixed Amount. The Lien Position up to 10 is allowed. The position should not be skipped, that is, if a Lien Position of 5 is assigned, the earlier four liens must be captured.
Lien Amount	The amount of the lien that the selected bank has on the collateral if the nature of lien is fixed amount. This option is enabled if the nature of lien is Fixed Amount, and is updated in update mode.
Bank Name	This is the Bank Code and/or the Name of the Bank related to the lien, which is a lookup to the Bank Name described earlier.
Application ID	It is the Application ID linked to the lien.
Application Status	It displays the status of the application linked to the lien.

Note:

If CL Loan and Q2 Origination both exist in the same org, the contract details are displayed on the same page. The loan contract ID is displayed on the application, instead of the Application ID.

Calculation of LTV and CLTV Ratios

LTV ratio = Amount of Credit Secured by Senior Lien / Market Value of the Collateral Securing the Credit.

CLTV ratio = Amount of Credit + All Existing Loans Linked to the Collateral Securing the Application / Market Value of the Collateral Securing the Credit.