This article will cover the available Market Insights reports in the Data Library Catalog.
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.
In this Article
Market Insights Folder
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 (YYYY-MM-DD HH:MM:SS AM/PM). |
| 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. |
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. |