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 (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. |
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. |
