Loan to Value Report

Description

Loan Details

(Optional)  To include only accounts with a specific business unit code on the report, use the Select button to reveal a screen to select one or more loan security codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button. Learn more about business unit configuration.  Default is ALL.

(Optional)  To include only accounts with a specific loan category on the report, use the Select button to reveal a screen to select one or more loan security codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button.  Default is ALL.

(Optional) Select a range of dates.  Only loans opened during this date range will be included in the results.

Leave this checked to include written-off loans. unchecking this will not include written-off loans in the results.

Collateral

(Required) Select from the following collateral types: real estate, stock, vehicle, medallion or other.  You may select one or multiple collateral types.  Only loans with these collateral types will be included in the results.  

• If Real Estate is selected, the report will include "CLTV" and "Other Debt" figures, unless specific Escrow Types are selected.  In this case the final columns will include "Payee" and "Certificate #" information.

(Optional) Select to only view loans with an LTV percentage equal to, above or below the percentage amount entered in the equal to field. This allows you to narrow the number of loans that appear on the report.

If an LTV% range is indicated above, then select which LVT %, either LTV % based on original balance or LTV % based on current loan balance.  (Defaults to original balance.)

Then for collateral select whether this should be based on current value or pledged value (defaults to current).

Options are; 1) using other debt manually entered on the real estate collateral record, 2) using all loans sharing the collateral (entire portfolio).  The default is 1.  Option 2  considers all loans that share the same collateral.  For example, the same real estate loan could be used as collateral for more than one loan.

(Optional) Select this option to display only those loans that have a calculated CLTV on the report.  Depending on the CLTV calculation (see previous field), you will only see real estate loans that have other debt entered on the collateral record (option 1) or loans whose collateral is being shared with one or multiple loans.

Escrow

(Optional)  To include only accounts with a specific Escrow Type code on the report, use the Select button to reveal a screen to select one or more loan security codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button.  Default is ALL.

(Optional) To include only accounts with a specific Payee Code, use the Select button to reveal a screen to select one or more loan security codes. SEE ALSO:  Filter and selection directions.  When you return to the screen, the count of the items selected with appear next to the button.  Default is ALL.

Report Options

Select whether to sort the report results by account base, LTV or loan category. LTV based on original balance is the default.  

• NOTE:  To sort the report by LTV % based on current loan balance, the "Current loan balance" box must be checked under the "Include loans with LTV%" section.

Use “Export details to file” go to the screen where you can choose to create a file that lets you use Member Connect to communicate instantly with these members via email and online banking messages, set up a marketing outreach via mailing labels and selective statement inserts, and track the responses via a telemarketing Tracker. This file will contain account base only. Or choose to export more data to use with CU*BASE Report Builder.