Collateral Tracking
Overview
A collateral is a borrower's pledge of specific property to the financial institution, to secure repayment of a loan. In other words, if the borrower defaults on the loan repayments, the financial institution can seize the collateral to recover the repayments.
Key Concepts
API
-
The APIs createContract, addNewCollateralLiens, changeAppraisedValueOfCollateral, and help you to associate a collateral with a contract during its creation, to associate the collateral with an existing contract, to update the collateral value, and to remove a collateral from a contract respectively.
Note:To learn more about implementing these APIs, see the Global Methods guide.
Loan to Value Ratio (LTV)
This is the ratio of the total amount borrowed to the value of the collaterals.Example:If a borrower borrows $30,000 to purchase a house worth $50,000, then the LTV ratio is 30,000/50,000.
Combined Loan to Value Ratio (CLTV)
This is the ratio of all the loans on a collateral to the value of the collateral.
CLTV = (Loan 1+ Loan 2+ Loan 3+...+ Loan n)/collateral value.
Factors for Calculating LTV and CLTV
-
If a contract is not capitalized, then the LTV and the CLTV are calculated on the principal remaining. But if a contract is capitalized, then the LTV and the CLTV are calculated on the principal remaining, fee capitalized, interest capitalized, and the additional interest (if enabled).
Note:To learn more about this, see Example > Scenario 1 and Scenario 2, explained later.
Lien
A lien is a right to the borrower's property that secures indebtedness. A financial institution has the right to seize the borrower's property in case of non-payment.
Lien Position
-
The lien position is the order in which the financial institutions can claim their right against a property. The financial institution that is in the first lien position against the collateral is the first to be repaid if the borrower defaults on the loan. As liens are filed in succession, whoever is in the second lien position only gets paid after the entity in the first position is paid off. The third lien holder gets paid after the second lien holder, and so on.
Note:To learn more about this, see Associate Collateral with a Contract, explained later.
Lien position is required for calculating the LTV. To learn more about this, see Example > Scenario 1, explained later.
Available Amount
This is the collateral amount that is available for pledging. Example:A collateral is added to the system with an estimated value of $30,000. When you associate the collateral with a contract for the first time, the available amount is $30,000. Let's say you pledge $10,000 for contract 1. The second time when you associate the same collateral with a different contract, the available amount is $(30,000-10,000)=$20,000.
Value
-
This refers to the amount of the collateral that is pledged to secure a loan. So, every time the collateral valuation changes as per the market condition, the Value is updated in the system.
Note:While adding a collateral to the system, the Value and Estimated Value fields are the same. But later when the collateral valuation changes, only the Value field is updated.
This Value is used for calculating the LTV and the CLTV.
UI Enhancements
This section lists the user interface enhancements made in various releases.
Release | UI Enhancements | Additional Details |
---|---|---|
Oxygen |
|
To navigate to the Add/Remove Collateral window, this link is used. |
|
The collateral that needs to be associated or disassociated from a contract is to be selected in this window. | |
|
The criteria based on which the task is auto resolved are to be defined in this section. | |
Manage Collaterals
With the Lithium release, the financial institutions can manage collaterals in the following ways:
Add a collateral using the CL Loan UI
Associate the collateral with an existing contract
Increase or decrease the value of the collateral
Calculate LTV and CLTV using the default formula
Implement custom formula to calculate LTV and CLTV
View LTV and CLTV
Add a Collateral
You can add a collateral to the system by defining the required details. This subsection provides instructions on how to add a new collateralized property.
Prerequisites
The following are the prerequisites to add a collateral:
-
The Collaterals tab is created and added to the home page.
Note:The Object corresponding to the tab is Collateral (Installed Package: CL Common). The API Name is clcommon__Collateral__c.
The Estimated Value, Available Amount, and the Value fields are added to the Collaterals layout.
Steps
Perform the following steps to add a collateral:
Log in to your Salesforce account.
Click the App Launcher .
Search for CL Loan, and then click it.
-
Click the Collaterals tab.
-
Click New, and from the Record Type of new record list, select the collateral record type, and then click Continue.
-
On the New Collateral page, in theCollateral Editsection, perform the following actions, and click Save:
Field Name Action Collateral Name Specify a name for the collateral. Estimated Value Specify the value of the collateral. Note:The Value and the Available Amount fields are updated with the same amount as Estimated Value.
Associate a Collateral with a Contract
A collateral is required when a contract subtype is Secured. You can associate a collateral with multiple contracts or multiple collaterals with a single contract. When a collateral is associated with a contract for the first time, the Lien Position of the collateral is 1. But when the same collateral is associated with a different contract for the second time, then the Lien Position becomes 2, and so on.
Example
A collateral COL-00000020 is pledged for a contract LAI-00000016 for the first time. So, the Lien Position of the collateral is 1, as highlighted in the following image:
If the same collateral COL-00000020 is pledged for the second time for a different contract LAI-00000017, then the Lien Position of the collateral is 2, as highlighted in the following image:
Prerequisites
The following are the prerequisites to associate a collateral with an existing contract:
A collateral is added to the system.
A contract is created.
Steps
Perform the following steps to associate a collateral with an existing contract:
Log in to your Salesforce account.
Click (App Launcher).
Search for CL Loan, and then click it.
-
Go to Servicing Configuration > Product Management > Collateral Lien Setup.
-
On the Collateral Liens page, in the Add new Collateral Lien section, perform the following actions, and then click Save:
Field Name Action Collateral Click theicon and search for the collateral that you want to associate with the contract.
Loan Account Click theicon and search for the contract with which you want to associate the collateral.
Loan Amount Specify an amount if you want to update the amount of the existing contract. Lien Amount Specify the amount of the collateral that you want to pledge for a contract. You can specify a part or full value of the collateral.
Note:The Lien Amount field is populated with an amount that is available for pledging.
It cannot be more than the available amount.
-
Go to Servicing Configuration > Batch Jobs > Run Batch Jobs.
-
In the Select Job for Process section, select ChangeLTVAndCLTVDynamicJob, and then click Next.
To run the job, click Run. The collateral is now associated with the contract.
To view the collateral associated with the contract, click the CL Contracts tab, and from the list of contracts, select the required CL contract ID.
-
On the CL Contract page, click CollateralLiens.In the Collateral Liens section, the collateral associated with the contract is listed.
Appraised Collateral Value
With this release, the financial institution can now do the revaluation of a collateral. With the change of the collateral's value, the available amount of the collateral, the LTV, and the CLTV are also changed.
Let's say a contract is secured by the borrower's publicly traded stock. While adding this collateral to the system, the current market price of those stocks is updated as the Estimated Value of the collateral. The value of those stocks may change in the future depending on the market situation. So, the lender has the authority to revise the value of the collateral whenever it is required.
Prerequisites
The following are the prerequisites to appraise the value of a collateral:
A collateral is added to the system.
The Collateral Valuation tab is created and added to the home page.
Steps
Perform the following steps to appraise the value of a collateral:
Log in to your Salesforce account.
Click the App Launcher.
Search for CL Loan, and then click it.
-
Click the Collateral Valuation tab, and then click New.
-
In the Collateral Valuation Detail section, perform the following actions, and click Save:
Field Name Action Collateral Click theicon and search for the collateral for which you want to update the value.
Appraised Value Specify a new value of the collateral. Appraisal Date Specify the date on which the collateral value is modified. Note:On the Collaterals tab, the Available Amount, Value, and Value Date of the collateral are updated to the new value.
Example
Let's assume that a collateral is created with the following terms and conditions:
Collateral Name | Collateral 26 | |
Value Date | 3/1/2013 | |
Estimated Value | $40,000 | |
Available Amount | $40,000 | |
Value | $40,000 |
Scenario 1
The collateral value is appraised to $10,000.
Action | Result |
---|---|
On the Collateral Valuation tab, specify the Appraised Value as $10,000, and the Appraisal Date as 4/1/2013. |
1. On the Collaterals tab, the Available Amount field is updated to $10,000, the Value field to $10,000, and the Value Date field to 4/1/2013. |
Scenario 2
Associate the collateral mentioned in Scenario 1, with a contract for a lien amount of $5,000. Then appraise the value of the collateral to $50,000.
New Available Amount = Current Available Amount - Lien Amount.
Action | Result |
---|---|
1. Associate the collateral with a contract for a lien amount of $5,000. New Available Amount = Available Amount (Scenario 1) - Lien Amount = $10,000 - $5,000 = $5,000. |
1. On the Collaterals tab, the Available Amount field is updated to $5,000. |
2. On the Collateral Valuation tab, specify the Appraised Value as $50,000, and the Appraisal Date as 5/1/2013. |
1. On the Collaterals tab, the Available Amount field is updated to $45,000, the Value field to $50,000, and the Value Date field to 5/1/2013. |
Implement Custom Formula to Calculate LTV and CLTV
In CL Loan, the LTV and the CLTV are calculated using a default formula. But with this release, financial institutions can create a custom formula to calculate the same.
To customize the LTV and the CLTV calculation formula, perform the following steps:
Create a custom class and extend the clcommon.AbstractCollateralLienCalculator.
-
Override the following methods and write the logic:
setParam
computeLoanToValueRatio
computeCombinedLoanToValueRatio
Specify the class name in Custom Settings > Org Parameters > Custom_CollateralLien_Calculator.
The system picks the class name and uses the defined implementation. If the class is not defined, then the LTV and the CLTV are calculated based on the logic defined in the class DefaultCollateralValuesCalculation.
global class CLASS_NAME extends clcommon.AbstractCollateralLienCalculator {
global override setParam(Map<String,Object> paramMap)
global override Map<Id,SObject> computeLoanToValueRatio(Set<ID> objectID)
global override Map<Id,SObject> computeCombinedLoanToValueRatio(Set<ID> objectID)
{
}
}
View LTV and CLTV
This subsection provides instructions on how to view the LTV and the CLTV calculated for a contract.
Prerequisites
The following are the prerequisites to view the LTV and the CLTV:
A collateral is associated with a contract.
The ChangeLTVAndCLTVDynamicJob is executed.
Steps
Perform the following steps to view the LTV and the CLTV:
Log in to your Salesforce account.
Click the App Launcher.
Search for CL Loan, and then click it.
Click the CL Contracts tab, and then from the list of contracts, select the required CL contract ID.
-
To view the value of LTV and CLTV, search for loan to value ratio.
Example
Let's assume that the following contracts and collaterals are created with the following terms and conditions:
Loan | Loan Amount | Collateral | Collateral Estimated Value |
---|---|---|---|
Loan 1 | $10,000 | Collateral 1 | $40,000 |
Loan 2 | $20,000 | Collateral 2 | $30,000 |
Loan 3 | $30,000 | Collateral 3 | $20,000 |
Loan 4 | $40,000 | Collateral 4 | $25,000 |
Scenario 1: Capitalization is enabled and multiple collaterals are associated with multiple contracts.
Perform the following steps:
1. Associate Collateral 1 with Loan 1. Lien Position of Collateral 1 on Loan 1 = 1.2. Associate Collateral 2 with Loan 2. Lien Position of Collateral 2 on Loan 2 = 1.3. Associate Collateral 1 with Loan 3. Lien Position of Collateral 1 on Loan 3 = 2.4. Associate Collateral 2 with Loan 3. Lien Position of Collateral 2 on Loan 3 = 2.5. Associate Collateral 1 with Loan 4. Lien Position of Collateral 1 on Loan 4 = 3.6. Associate Collateral 3 with Loan 4. Lien Position of Collateral 3 on Loan 4 = 1.7. Associate Collateral 2 with Loan 1. Lien Position of Collateral 2 on Loan 1 = 3.
LTV(Loan n) = ((Principal Remaining of all the loans) + (Fees Capitalized of all the loans) + (Interest Capitalized of all the loans) + (Additional Interest of all the loans (if any)))/Value of all the collaterals associated with Loan n.
Note: Loans in the numerator are the loans for which collaterals associated with Loan n have lien position as 1.
CLTV(Loan n) = ((Principal Remaining of all the loans) + (Fees Capitalized of all the loans) + (Interest Capitalized of all the loans) + (Additional Interest of all the loans (if any)))/Value of all the collaterals associated with Loan n.
Note: Loans in the numerator are the loans that are sharing the same collaterals with Loan n.
Result: Description | Result: Where |
---|---|
|
|
|
|
|
|
|
Scenario 2: Capitalization is disabled and two collaterals are associated with one contract.
Perform the following steps:
1. Associate Collateral 1 with Loan 1. Lien Position of Collateral 1 on Loan 1 = 1.2. Associate Collateral 2 with Loan 1. Lien Position of Collateral 2 on Loan 1 = 1.
Result: Description | Result: Where |
---|---|
|
Scenario 3: Capitalization is disabled and one collateral is associated with two contracts.
Perform the following steps:
1. Associate Collateral 1 with Loan 1. Lien Position of Collateral 1 on Loan 1 = 1.2. Associate Collateral 1 with Loan 2. Lien Position of Collateral 1 on Loan 2 = 2.
Result: Description | Result: Where |
---|---|
|
|
|