This article will cover the available Market Insights reports in the Data Library Catalog.

 

In this Article

 

Market Insights Folder

Note: Market Insights is a premium service for clients. If you are interested in adding Market Insights for your organization, please reach out to our support team at support@precisionlender.com.

 

Opportunity Market Report

Market quartiles and loan percentiles for eligible loan accounts in pipeline scenarios of opportunities.

Opportunity Market Report
Field Name Data Type Description
Opportunity Id guid The unique PrecisionLender identifier for the opportunity.
Account Id guid The unique PrecisionLender identifier for the account.
Last Modified date The date the opportunity containing the account was last saved.
Stage Name string The name of the bank assigned stage.
Relationship string The name of the associated business relationship.
Region Name string The name of the Bank region for the loan.
Product Name string The name of the product associated with the loan.
Owner Full Name string The full name of the account owner.
Owner Email string The Email of the account owner.
Tax Exemption Option string The tax exemption option on an account, if applicable.
Risk Rating string The risk rating for a loan account.
Amount float The balance of a loan account at origination.
Rate Type string The rate type associated with the loan.
Rate float The total Interest rate on the loan at the time of pricing.
Spread Over Index float The spread from the index rate to the total interest rate charged on a loan at pricing.
Index Rate float The rate of the index used as of the pricing date.
Index Name string The name of the index used.
Market Available string The Indicator for whether a market of comparable loans exists for a given loan.
Market Availability Reason string If a market does not exist, the reason why no comparable market exists for a given loan.
Market Percentile Of Loan float The market percentile of the loan.
Market Rate 25th Percentile float The interest rate at the 25th percentile of the market for a given loan.
Market Rate 50th Percentile float The interest rate at the 50th percentile of the market for a given loan.
Market Rate 75th Percentile float The interest rate at the 75th percentile of the market for a given loan.

 

 

Portfolio Market Report

Market quartiles and loan percentiles at origination and at current market conditions for portfolio loans originated since you've had Market Insights. Tracks loans over a maximum of 3 years.

Portfolio Market Report
Field Name Data Type Description
Core Account Id GUID The unique PrecisionLender identifier for the account.
Owner Full Name string The full name of the account owner.
Owner Email string The Email of the account owner.
Relationship string The name of the associated business relationship.
Region Name string The name of the Bank region for the loan.
Product Name string The name of the product associated with the loan.
Tax Exemption Option string The tax exemption option on an account, if applicable.
Risk Rating string The risk rating for a loan account.
Maturity Date date The date of loan maturity.
Amount float The balance of a loan account at origination.
Latest Balance float The current balance of the loan.
Latest Average Balance float The average balance of the loan over the life of the loan.
Rate Type string The rate type associated with the loan.
Rate float The total Interest rate on the loan at the time of pricing.
Adjustable Rate Spread float The spread from the index rate to the current rate charged on a loan.
Adjustable Rate Index Rate float The current value of the underlying index rate of the loan.
Fees Initial Percent Of Amount  float The origination fees as a percent of the amount of the loan. In addition to Fees Initial Dollars.
Fees Initial Dollars  float The origination fees of the loan.  In addition to Fees Initial Percent of Amount.
Fees Annual Dollars  float The annual fees of the loan.
Fees Unused LOC  float The unused line of credit fee, expressed as a percent.
Loan Zip Code string The zipcode associated with the loan.
Industry Code string The industry code associated with the loan.
Origination Date date The date of loan origination.
Origination Market Available string The indicator for whether a market of comparable loans exists for a given loan at its origination.
Origination Market Availability Reason string If a market does not exist, the reason why no comparable market exists for a given loan at its origination.
Origination Market Scored Date string The date following origination when the loan was scored against its comparable market.
Origination Market Percentile Of Loan float The market percentile of the loan at its origination.
Origination Market Rate 25th Percentile float The interest rate at the 25th percentile of the market for a given loan at its origination.
Origination Market Rate 50th Percentile float The interest rate at the 50th percentile of the market for a given loan at its origination.
Origination Market Rate 75th Percentile float The interest rate at the 75th percentile of the market for a given loan at its origination.
Latest Market Available string The indicator for whether a market of comparable loans exists for a given loan at the present.
Current Market Availability Reason string If a market does not exist, the reason why no comparable market exists for a given loan at the present.
Latest Market Scored Date string The date when the loan was scored against its current comparable market.
Latest Market Percentile Of Loan float The market percentile of the loan at the present.
Latest Market Rate 25th Percentile float The interest rate at the 25th percentile of the market for a given loan at the present.
Latest Market Rate 50th Percentile float The interest rate at the 50th percentile of the market for a given loan at the present.
Latest Market Rate 75th Percentile float The interest rate at the 75th percentile of the market for a given loan at the present.
External Account Id guid The unique bank identifier for the account.
Term int The length of the loan in months.

 

US Commercial Banking Credit Migration Matrix

Matrix of credit rating transitions for US-based PrecisionLender client's loans over the past year.

US Commercial Banking Credit Migration Matrix
Field Name Data Type Description
NULL string Row labels (AAA - CCC/C) for risk of default rating at beginning of 1 year period.
AAA float Proportion of loans with initial rating matching row name and final rating AAA.
AA+ float Proportion of loans with initial rating matching row name and final rating AA+.
AA float Proportion of loans with initial rating matching row name and final rating AA.
AA- float Proportion of loans with initial rating matching row name and final rating AA-.
A+ float Proportion of loans with initial rating matching row name and final rating A+.
A float Proportion of loans with initial rating matching row name and final rating A.
A- float Proportion of loans with initial rating matching row name and final rating A-.
BBB+ float Proportion of loans with initial rating matching row name and final rating BBB+.
BBB float Proportion of loans with initial rating matching row name and final rating BBB.
BBB- float Proportion of loans with initial rating matching row name and final rating BBB-.
BB+ float Proportion of loans with initial rating matching row name and final rating BB+.
BB float Proportion of loans with initial rating matching row name and final rating BB.
BB- float Proportion of loans with initial rating matching row name and final rating BB-.
B+ float Proportion of loans with initial rating matching row name and final rating B+.
B float Proportion of loans with initial rating matching row name and final rating B.
B- float Proportion of loans with initial rating matching row name and final rating B-.
CCC/C float Proportion of loans with initial rating matching row name and final rating CCC/C.
Paid float Proportion of loans with initial rating matching row name which were paid off within 1 year.
Unknown float Proportion of loans with initial rating matching row name with unknown status after 1 year.
Default float Proportion of loans with initial rating matching row name which defaulted within 1 year.