Setting up Loan Support
Contents
Overview of Loan Support
Loan Support, or LSP, is a configuration within DDI-Connect that allows loans to be supported by investments. There are multiple steps involved in configuring your system for loan support.
Configure your Loan System Settings for LSP Margin and LSP Frequency
- Within Loan System Settings, on the Settings tab, click the drop down arrow to set the LSP margin that you want the system to use in calculating LSP Base Rate
- On the same tab, click the drop down arrow to select the LSP Frequency that you wish to use. This tells the system the frequency with which the Loan Support Processing should calculate and adjust rates for LSP loans
Modify Loan Type Maintenance
Configure Loan Type Maintenance to have a base/current interest rate on the settings tab
Configure Loan Add/Maintenance for LSP Loans
Configure each loan for loan support information within Loan Add/Maintenance
- On the Adjust tab, modify the following:
- Update the Adjustment method to Classic LSP
- Set the first adjustment date in the Adjustment Date field
- For the Adjustment Freq(Months), enter the number of months you want to have the LSP calculated. For example, if you wish to have the LSP calculated every three months, you would enter a 3 in this field
- In the Per Adjust Max, if you wish to establish a maximum percentage that the loan support rate can be adjusted each time the calculation is performed, enter it here. If you do not wish to establish a maximum percentage amount, leave this field at 0
- In the Lifetime Adjust Max field, you have the ability to set a maximum percentage that the loan support rate can adjust over the lifetime of the loan. If you do not wish to establish a maximum lifetime adjustment rate, leave the field at 0
- On the Due tab
- In the Required Support field, enter a percentage of the required amount of investment support a borrower has to have before the Base LSP support rate kicks in. If you do not wish to establish a minimum required support amount and want to calculate based on any loan support, leave this field at 0
Configure Investment Maintenance
For any investments that will be providing loan support, you will have to update the investment via Investment Maintenance.
- Open the investment in the Investment Maintenance area
- Click the Support tab
- Update the LSP loan # field with the loan number that this investment is supporting
Loan Support Reports
Run the following reports to update Loan Support Rates. These reports are typically run as part of your Periodic Job Processing
- IL454 - Loan Base Rate Update
- IL501 - Loan Support Processing
- IL448 - Adjustable Mortgage Processing (if applicable). This report is run if you wish to have the loan payment amount recalculated as part of LSP
Viewing Loan Support
To view a loan's LSP information, go to the Detailed Loan Inquiry for that loan and click the LSP tab. This tab provides all of the information regarding the loan's LSP:
An example calculation:
In the above example, if the loan did not have any loan support, the rate on the loan would be 9%. However, since the loan is 60% supported, it means 60% of the loan is based off of a 7% rate (5% Weighted Avg Investment Rate + Margin). The interest rate is a total of 7.80% for the whole loan when loan support is figured in.
