T-REX data dictionaries ensure users quick access to assess and gain insights into a variety of different metrics. The dictionaries allow users to match their original fields with the standardized T-REX field and definition they will see on the platform.
| Titan Field Name | Calculated or Raw | Asset Type | Field Description | Conditions | Calculation | Data_Type | Notes |
| Total Excess | Raw | Borrowing Base | CURRENCY | ||||
| Current Balance | Calc | Borrowing Base | Amount of loan outstanding as of pool cut off date, This should include any amounts that are secured by the mortgage and will be classed as principal in the transaction. | If X =< 30 AND Z = "Yes" | Sum Y | CURRENCY | X: Days Past Due Y: Outstanding Balance Z: Eligible Loan Flag |
| Required Interest Reserve | Calc | Borrowing Base | If Y > (First day of month of T) AND Y < X | Sum Z | CURRENCY | X: Funding Date T: Prior Payment Date Y: Date Z: Require Interest Reserve | |
| Concentration + Ineligible Balance | Calc | Borrowing Base | X+Y | CURRENCY | X: Total Ineligible Balance Y: Total Excess | ||
| Outstanding Balance | Raw | Borrowing Base | The unpaid, interest-bearing balance of a loan or loan portfolio. | CURRENCY | |||
| Utilization Rate | Calc | Borrowing Base | the number of billable hours divided by the total number of available hours (x 100). | X/Y * 100 | NUMBER | X: Credit After Funding Y: Total Commitments | |
| Cash Balance | Raw | Borrowing Base | CURRENCY | ||||
| Interest Shortfall | Raw | Borrowing Base | accrued interest due that remains after a borrower has made their monthly payment | CURRENCY | |||
| Alternate Advance Rate | Raw | Borrowing Base | An alternate advance rate to be used for comparisons | *100 | NUMBER | ||
| Collection Account Withdrawn | Raw | Borrowing Base | CURRENCY | ||||
| Proceeds Released | Calc | Borrowing Base | X+Y | CURRENCY | Additional Borrowing Collection Account Withdrawn | ||
| Credit Before Funding | Raw | Borrowing Base | CURRENCY | ||||
| Eligible Balance | Calc | Borrowing Base | T - Z | CURRENCY | T: Cash Balance Z: Interest Shortfall | ||
| Total Commitments | Raw | Borrowing Base | CURRENCY | ||||
| Net Cash Receipts | Calc | Borrowing Base | This represents the net proceeds from the sale of the asset | X-Y | CURRENCY | X: Cash Balance Y: Cash Withdrawn | |
| Adjusted Pool Balance | Calc | Borrowing Base | Pool Balance adjusted | X-Y | CURRENCY | X: Outstanding Balance Y: Concentration + Ineligible Balance | |
| Cash Withdrawn | Raw | Borrowing Base | The amount of cash withdrawn. | CURRENCY | |||
| Beginning Balance | Raw | Borrowing Base | Beginning Balance of a note or account. | CURRENCY | |||
| Advance Request | Calc | Borrowing Base | X-Y | CURRENCY | X: Credit After Funding Y: Credit Before Funding | ||
| Advance Rate | Raw | Borrowing Base | The maximum percentage of the value of a collateral that a lender is willing to extend for a loan | *100 | NUMBER | ||
| Net Pledged Balance | Calc | Borrowing Base | X - Y | CURRENCY | X: Outstanding Balance Y: Beginning Balance | ||
| 31-60 Balance | Calc | Borrowing Base | 31-60 day (1 month) delinquency Balance | If X > 30 AND =<60 AND Z = "Yes" | Sum Y | CURRENCY | X: Days Past Due Y: Outstanding Balance Z: Eligible Loan Flag |
| Additional Borrowing | Raw | Borrowing Base | CURRENCY | ||||
| Borrowing Base | Calc | Borrowing Base | X*A + Y*B + Z | CURRENCY | X: Current Balance Y: 31-60 Balance Z: Eligible Balance A: Advance Rate B: Alternate Advance Rate | ||
| Credit After Funding | Raw | Borrowing Base | CURRENCY | ||||
| Adjusted Balance | Calc | Borrowing Base | Outstanding Balance of an asset, bond, pool, deal, facility adjusted by a pre-determined factor | A + B + C + D + E + F | CURRENCY | A: Outstanding Receivable Amount B: Excess Concentration Amount C: Delinquent - Ineligible Balance D: Default - Ineligible Balance E: Collection Account Balance F: Reserve Account Balance | |
| Collection Account Balance | Raw | Borrowing Base | CURRENCY | ||||
| Excess Concentration Amount | Calc | Borrowing Base | The overall excess found | A + B + C + D + E + F | CURRENCY | A: Max Debtor Sr Advance Rate Outstanding - EC Calc B: Max N Debtor Sr Advance Rate Outstanding - EC Calc C: Max Supplier Sr Advance Rate Outstanding - EC Calc D: Max N Supplier Sr Advance Rate Outstanding - EC Calc E: Max Debtor_Supplier Sr Advance Rate Outstanding - EC Calc F: Max N Debtor_Supplier Sr Advance Rate Outstanding - EC Calc | |
| Program Limit | Raw | Borrowing Base | Maximum available (funding) for a given program | 40000000 | CURRENCY | ||
| Borrowing Base - Test | Calc | Borrowing Base | Borrowing Base test results | If Y > X then "pass" else "fail" | TEXT | X: Sr Advance Rate Outstanding Amount - Current Y: Borrowing Base | |
| Reserve Account Balance | Raw | Borrowing Base | CURRENCY | ||||
| Advanced Rate | Raw | Borrowing Base | *100 | ||||
| Adjusted Collateral Balance | Calc | Borrowing Base | The adjusted balance of a pool of assets. | X-Y-Z | CURRENCY | X: Eligible Receivables Y: Total - EC Calc Z: Total Ineligible | |
| Non DK % | Raw | Concentration Calculation | Non DK exposure percentage. | *100 for Actual % and Limits % | NUMBER | ||
| Max Debtor Sr Advance Rate Outstanding % | Raw | Concentration Calculation | *100 for Actual % and Limits % | NUMBER | |||
| Max N Debtor Sr Advance Rate Outstanding % | Raw | Concentration Calculation | *100 for Actual % and Limits % | NUMBER | |||
| Amended Outstanding | Raw | Concentration Calculation | Balance for loans which have been amended. | CURRENCY | |||
| Non EU Outstanding | Raw | Concentration Calculation | Non EU exposure balance. | CURRENCY | |||
| Total Delinquencies | Raw | Concentration Calculation | Total value of delinquencies. | CURRENCY | |||
| Max N Supplier Sr Advance Rate Outstanding % | Raw | Concentration Calculation | *100 for Actual % and Limits % | NUMBER | |||
| Non EU % | Raw | Concentration Calculation | Non EU exposure percentage. | *100 for Actual % and Limits % | NUMBER | ||
| High Balance - EC Calc | Raw | Concentration Calculation | For Excess Concentrations - if High Balance limit is breached $ amount affected | CURRENCY | |||
| High Balance % | Raw | Concentration Calculation | Percentage of loans with a high original balance. | *100 for Actual % and Limits % | NUMBER | ||
| Amended % | Raw | Concentration Calculation | Percentage of balance for loans which have been amended | *100 for Actual % and Limits % | NUMBER | ||
| Max Supplier Sr Advance Rate Outstanding % | Raw | Concentration Calculation | *100 for Actual % and Limits % | NUMBER | |||
| Non DK Outstanding | Raw | Concentration Calculation | Non DK exposure balance. | CURRENCY | |||
| Monthly Vintage Defaulted Receivables Ratio | Both | Concentration Limits | Actual: Max X for each name Limit: 1% | NUMBER | X: Defaulted Receivable Balance | ||
| 3rd Max Oustanding Exposure | Both | Concentration Limits | If X = "Yes" | Actual: 3rd Max Y / Z Limit: 15% | X: Eligible Loan Flag Y: Outstanding Exposure Z: Total Eligible Balance (from pool) | ||
| Produce Ratio | Both | Concentration Limits | If X = "Yes" and Y = "Yes" | Actual: (Sum Z / T) *100 Limit: 35% | NUMBER | X: Eligible Loan Flag Y: Perishable Flag Z: Outstanding Balance T: Total Eligible Balance (from pool) | |
| Approved Debtor Ratio | Both | Concentration Limits | If X = "Yes" and Y = "No" | Actual: (Sum Z / T) *100 Limit: 10% | NUMBER | X: Eligible Loan Flag Y: Approved Debtor Flag Z: Outstanding Balance T: Total Eligible Balance (from pool) | |
| Max Oustanding Exposure | Both | Concentration Limits | If X = "Yes" | Actual: Max Y / Z Limit: 35% | X: Eligible Loan Flag Y: Outstanding Exposure Z: Total Eligible Balance (from pool) | ||
| WA Interest Rate | Both | Concentration Limits | If X = "Yes" | Actual: (Sum Y * Z for each loan) / T Limit: 1% | NUMBER | X: Eligible Loan Flag Y: APY Z: Outstanding Balance T: Outstanding Balance (from pool) | |
| Max Uninsured Exposure | Both | Concentration Limits | If X = "Yes" | Actual: (Max Z / T) *100 Limit: 35% | NUMBER | X: Eligible Loan Flag Z: Uninsured Exposure T: Total Eligible Balance (from pool) | |
| Delinquency Ratio | Both | Concentration Limits | As of any date of determination, a ratio (expressed as a percentage) computed by dividing (i) the aggregate amount of payments due and unpaid on a PACE Asset through such date by (ii) the PACE Asset Balance of all Eligible PACE Assets. | If Y = "Yes" | Actual: (Sum Z / T) *100 Limit: 10% | NUMBER | Y: Delinquency Eligibility Flag Z: Current Balance T: Total Eligible Balance (from pool) |
| 2nd Max Oustanding Exposure | Both | Concentration Limits | If X = "Yes" | Actual: 2nd Max Y / Z Limit: 20% | X: Eligible Loan Flag Y: Outstanding Exposure Z: Total Eligible Balance (from pool) | ||
| Original Term to Maturity Ratio | Both | Concentration Limits | If Y = "Yes" | Actual: (Sum Z / T) *100 Limit: 10% | NUMBER | Y: Original Term to Maturity Flag Z: Outstanding Balance T: Total Eligible Balance (from pool) | |
| Delinquency Receivable Ratio | Both | Concentration Limits | If X = "Yes" and Y = "Yes" | Actual: (Sum Z / T) *100 Limit: 10% | NUMBER | X: Eligible Loan Flag Y: 30+ Days Past Due Flag Z: Outstanding Balance T: Total Eligible Balance (from pool) | |
| Insured Balance | Both | Concentration Limits | Balance of insured collateral. | If X = "Yes" and Y = "Yes" | Actual: Sum Z Limit: 6,000,000 | CURRENCY | X: Eligible Loan Flag Y: Insurance Flag Z: Outstanding Balance |
| 2nd Max Uninsured Exposure | Both | Concentration Limits | If X = "Yes" | Actual: (2nd Max Z / T) *100 Limit: 20% | NUMBER | X: Eligible Loan Flag Z: Uninsured Exposure T: Total Eligible Balance (from pool) | |
| WA Original Term | Both | Concentration Limits | If X = "Yes" | Actual: (Sum Y * Z for each loan) / T Limit: 75 | NUMBER | X: Eligible Loan Flag Y: Loan Term Z: Outstanding Balance T: Outstanding Balance (from pool) | |
| 3rd Max Uninsured Exposure | Both | Concentration Limits | If X = "Yes" | Actual: (2nd Max Z / T) *100 Limit: 15% | NUMBER | X: Eligible Loan Flag Z: Uninsured Exposure T: Total Eligible Balance (from pool) | |
| Max Debtor Sr Advance Rate Outstanding | Calc | Concentration Limits | Actual: Sum(B) on A, then select the greatest Sum(B) Limit: X * 0.15 | CURRENCY | A: Obligor B: Sr Advance Rate Outstanding Amount X: Program Limit | ||
| Seller Country Loc2 Conc Sr Advance Rate Outstanding | Calc | Concentration Limits | Advance Outstanding for all seller's in a given country - named in the specific mapping file | When X = "PK" | Actual: Sum(Y) Limit: Z * 0.10 | CURRENCY | X: Original Lender Establishment Country Y: Sr Advance Rate Outstanding Amount Z: Program Limit |
| Seller Country Loc1 Conc Sr Advance Rate Outstanding | Calc | Concentration Limits | Advance Outstanding for all seller's in a given country - named in the specific mapping file | When X = "BD" | Actual: Sum(Y) Limit: Z * 0.15 | CURRENCY | X: Original Lender Establishment Country Y: Sr Advance Rate Outstanding Amount Z: Program Limit |
| Max N Debtor_Supplier Sr Advance Rate Outstanding | Calc | Concentration Limits | Actual: Sum(B) on A, then select the greatest 3 and report the total Sum(B) of those 3 Limit: X * 0.30 | CURRENCY | A: Original Lender - Obligor ID B: Sr Advance Rate Outstanding Amount X: Program Limit | ||
| Max Supplier Sr Advance Rate Outstanding | Calc | Concentration Limits | Actual: Sum(B) on A, then select the greatest Sum(B) Limit: X * 0.15 | CURRENCY | A: Original Lender Name B: Sr Advance Rate Outstanding Amount X: Program Limit | ||
| Debtor_Supplier Sr Advance Rate Outstanding | Calc | Concentration Limits | Advance Outstanding for a given debtor_supplier relationship | When X = "Lighthouse%" and Y = "Amazon%" | Actual: Sum (Z) Limit: 500,000 | CURRENCY | X: Original Lender Name Y: Obligor Z: Sr Advance Rate Outstanding Amount |
| Max Debtor_Supplier Sr Advance Rate Outstanding | Calc | Concentration Limits | Actual: Sum(B) on A, then select the greatest and report the total Sum(B) Limit: X * 0.12 | CURRENCY | A: Original Lender - Obligor ID B: Sr Advance Rate Outstanding Amount X: Program Limit | ||
| Max N Debtor Sr Advance Rate Outstanding | Calc | Concentration Limits | Actual: Sum(B) on A, then select the greatest 3 and report the total Sum(B) of those 3 Limit: X * 0.30 | CURRENCY | A: Obligor B: Sr Advance Rate Outstanding Amount X: Program Limit | ||
| Small Debtor Outstanding Receivables | Calc | Concentration Limits | Actual: when Y = "2M-10M", Sum(X) Limit: [(A + B + C) / 3] * 0.15 | CURRENCY | X: Sr Advance Rate Outstanding Amount Y: Obligor Annual Revenue A: Sr Advance Rate Outstanding Amount - Current B: Sr Advance Rate Outstanding Amount - 1 Month Prior C: Sr Advance Rate Outstanding Amount - 2 Months Prior | ||
| Max N Supplier Sr Advance Rate Outstanding | Calc | Concentration Limits | Actual: Sum(B) on A, then select the greatest 3 and report the total Sum(B) of those 3 Limit: X * 0.30 | CURRENCY | A: Original Lender Name B: Sr Advance Rate Outstanding Amount X: Program Limit | ||
| Non DK - EC Assess | Raw | EC Asses | Whether the DK balance exceeds the excess threshold. | TEXT | |||
| Non EU - EC Assess | Raw | EC Asses | Whether the EU balance exceeds the excess threshold. | TEXT | |||
| Amended - EC Assess | Raw | EC Asses | Whether the amended loans balance exceeds the excess threshold. | TEXT | |||
| High Balance - EC Assess | Raw | EC Asses | For Excess Concentrations - determination of whether High Balance limit is breached. Value is Pass/Fail | TEXT | |||
| Voided - Ineligible Balance | Calc | Eligibility Criteria | The ineligible balance tied to voided loans. | CURRENCY | X: Voided Flag Y: Outstanding Balance | ||
| Multiple Ineligible Balance | Calc | Eligibility Criteria | CURRENCY | X: Fraudulent Flag Y: Outstanding Balance | |||
| Bankruptcy - Ineligible Balance | Calc | Eligibility Criteria | Ineligible Balance due to bankruptcy | CURRENCY | X: Currently Bankrupt Flag Y: Outstanding Balance | ||
| Total Ineligible Balance | Calc | Eligibility Criteria | Total principal balance minus approved ineligible loan amount | CURRENCY | |||
| Regulatory Event - Ineligible Balance | Calc | Eligibility Criteria | CURRENCY | X: Regulatory Event Flag Y: Outstanding Balance | |||
| Refunded - Ineligible Balance | Calc | Eligibility Criteria | CURRENCY | X: Refunded Flag Y: Outstanding Balance | |||
| Fraudulent - Ineligible Balance | Calc | Eligibility Criteria | Ineligible Balance due to fraudulent receivables | CURRENCY | X: Fraudulent Flag Y: Outstanding Balance | ||
| Delinquent - Ineligible Balance | Calc | Eligibility Criteria | Ineligible Balance due to Delinquent Receivable | CURRENCY | X: Delinquency Eligibility Flag Y: Outstanding Balance | ||
| Counterparty Country - Ineligible Balance | Calc | Eligibility Criteria | CURRENCY | X: Approved Country Flag Y: Outstanding Balance | |||
| Maturity - Ineligible Balance | Calc | Eligibility Criteria | Balance of Loans identified as ineligible due to Original Term > client defined years | CURRENCY | X: Original Term Eligible Flag Y: Outstanding Balance | ||
| Defaulted - Ineligible Balance | Calc | Eligibility Criteria | Balance of Loans identified as ineligible due to loan status of charged off | CURRENCY | X: Defaulted Flag Y: Outstanding Balance | ||
| Currency - Inelgible Balance | Raw | Eligibility Criteria | |||||
| Debtor 120 Days - Ineligible Balance | Raw | Eligibility Criteria | CURRENCY | ||||
| Insurance - Ineligible Balance | Raw | Eligibility Criteria | Ineligible balance related to Insurance thresholds. | CURRENCY | |||
| Monthly Vintage Defaulted Receivables Ratio - EC Assess | Calc | Excess Concentration | If X > Y, "FAIL" Else "PASS" | TEXT | X: Monthly Vintage Defaulted Receivables Ratio(Actual) Y: Monthly Vintage Defaulted Receivables Ratio(Limit) | ||
| 2nd Max Debtor Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: 2nd Max Oustanding Exposure(Actual) Y: 2nd Max Oustanding Exposure(Limit) | ||
| 3rd Max Debtor Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: 3rd Max Oustanding Exposure(Actual) Y: 3rd Max Oustanding Exposure(Limit) Z: Total Eligible Balance | ||
| WA APR - EC Assess | Calc | Excess Concentration | For Excess Concentrations - determination of whether WA APR limit is breached. Value is Pass/Fail | If Y > X, "FAIL" Else "PASS" | TEXT | X: WA Interest Rate(Actual) Y: WA Interest Rate(Limit) Z: Total Eligible Balance | |
| Approvecd Debtor - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: Approved Debtor Ratio(Actual) Y: Approved Debtor Ratio(Limit) | ||
| 3rd Max Debtor Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: 3rd Max Oustanding Exposure(Actual) Y: 3rd Max Oustanding Exposure(Limit) Z: Total Eligible Balance | |
| 2nd Max Debtor Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: 2nd Max Oustanding Exposure(Actual) Y: 2nd Max Oustanding Exposure(Limit) Z: Total Eligible Balance | |
| Maturity - Ineligible Balance - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | TEXT | X: Original Term to Maturity Ratio(Actual) Y: Original Term to Maturity Ratio(Limit) | ||
| Delinquency - EC Calc | Calc | Excess Concentration | If row above = "FAIL" | X - Y * Z | CURRENCY | X: Delinquency Ratio(Actual) Y: Delinquency Ratio(Limit) Z: Total Eligible Balance | |
| Delinquency Receivable Ratio - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | TEXT | X: Delinquency Receivable Ratio(Actual) Y: Delinquency Receivable Ratio(Limit) Z: Total Eligible Balance | |
| 3rd Max Uninsured Exposure - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: 3rd Max Uninsured Exposure(Actual) Y: 3rd Max Uninsured Exposure(Limit) | ||
| Produce - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: Produce Ratio(Actual) Y: Produce Ratio(Limit) Z: Total Eligible Balance | |
| Max Debtor Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: Max Oustanding Exposure(Actual) Y: Max Oustanding Exposure(Limit) | ||
| 2nd Max Uninsured Exposure - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: 2nd Max Uninsured Exposure(Actual) Y: 2nd Max Uninsured Exposure(Limit) | ||
| Maturity - Ineligible Balance - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: Original Term to Maturity Ratio(Actual) Y: Original Term to Maturity Ratio(Limit) Z: Total Eligible Balance | |
| Produce - EC Asses | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: Produce Ratio(Actual) Y: Produce Ratio(Limit) | ||
| Max Debtor Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: Max Oustanding Exposure(Actual) Y: Max Oustanding Exposure(Limit) Z: Total Eligible Balance | |
| WA Original Term - EC Assess | Calc | Excess Concentration | Assessment of WA Original Term | If X > Y, "FAIL" Else "PASS" | TEXT | X: WA Original Term(Actual) Y: WA Original Term(Limit) | |
| Insured Balance - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: Insured Balance(Actual) Y: Insured Balance(Limit) | ||
| Max Uninsured Exposure - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | LIST | X: Max Uninsured Exposure(Actual) Y: Max Uninsured Exposure(Limit) | ||
| Insured Balance - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: Insured Balance(Actual) Y: Insured Balance(Limit) Z: Total Eligible Balance | |
| Delinquency Ratio - EC Assess | Calc | Excess Concentration | If X > Y, "FAIL" Else "PASS" | TEXT | X: Delinquency Ratio(Actual) Y: Delinquency Ratio(Limit) | ||
| 3rd Max Uninsured Exposure - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: 3rd Max Uninsured Exposure(Actual) Y: 3rd Max Uninsured Exposure(Limit) Z: Total Eligible Balance | |
| Monthly Vintage Defaulted Receivables Ratio - EC Calc | Calc | Excess Concentration | If row above = "FAIL" | X - Y * Z | CURRENCY | X: Monthly Vintage Defaulted Receivables Ratio(Actual) Y: Monthly Vintage Defaulted Receivables Ratio(Limit) Z: Total Eligible Balance | |
| Delinquency Receivable Ratio - EC Assess | Calc | Excess Concentration | If X > Y, "Fail" Else "Pass" | TEXT | X: Delinquency Receivable Ratio(Actual) Y: Delinquency Receivable Ratio(Limit) | ||
| Max Uninsured Exposure - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: Max Uninsured Exposure(Actual) Y: Max Uninsured Exposure(Limit) Z: Total Eligible Balance | |
| 2nd Max Uninsured Exposure - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: 2nd Max Uninsured Exposure(Actual) Y: 2nd Max Uninsured Exposure(Limit) Z: Total Eligible Balance | |
| Approvecd Debtor - EC Calc | Calc | Excess Concentration | If row above = "Fail" | X - Y * Z | CURRENCY | X: Approved Debtor Ratio(Actual) Y: Approved Debtor Ratio(Limit) Z: Total Eligible Balance | |
| WA APR - EC Calc | Calc | Excess Concentration | For Excess Concentrations - if WA APR limit is breached $ amount affected | If row above = "FAIL" | Y - X * Z | CURRENCY | X: WA Interest Rate(Actual) Y: WA Interest Rate(Limit) Z: Total Eligible Balance |
| WA Original Term - EC Calc | Calc | Excess Concentration | If row above = "FAIL" | X - Y * Z | CURRENCY | X: WA Original Term(Actual) Y: WA Original Term(Limit) Z: Total Eligible Balance | |
| Max Debtor_Supplier Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Max Debtor_Supplier Sr Advance Rate Outstanding - EC Assess A: Max Debtor_Supplier Sr Advance Rate Outstanding (Actual) B: Max Debtor_Supplier Sr Advance Rate Outstanding (Limit) | ||
| Max N Debtor_Supplier Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | IF Y > X THEN pass ELSE fail | LIST | X: Max N Debtor_Supplier Sr Advance Rate Outstanding (Actual) Y: Max N Debtor_Supplier Sr Advance Rate Outstanding (Limit) | ||
| Seller Country Loc1 Conc Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | Seller Loc1 Country Concentration limit breach determination | IF Y > X THEN pass ELSE fail | LIST | X: Seller Country Loc1 Conc Sr Advance Rate Outstanding (Actual) Y: Seller Country Loc1 Conc Sr Advance Rate Outstanding (Limit) | |
| Small Debtor Outstanding Receivables - EC Assess | Calc | Excess Concentration | Small Debtor Concentration Calc breach determination | IF Y > X THEN pass ELSE fail | LIST | X: Small Debtor Outstanding Receivables (Actual) Y: Small Debtor Outstanding Receivables (Limit) | |
| Max Debtor_Supplier Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | IF Y > X THEN pass ELSE fail | LIST | X: Max Debtor_Supplier Sr Advance Rate Outstanding (Actual) Y: Max Debtor_Supplier Sr Advance Rate Outstanding (Limit) | ||
| Max Supplier Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | IF Y > X THEN pass ELSE fail | LIST | X: Max Supplier Sr Advance Rate Outstanding (Actual) Y: Max Supplier Sr Advance Rate Outstanding (Limit) | ||
| Max N Debtor Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | IF Y > X THEN pass ELSE fail | LIST | X: Max N Debtor Sr Advance Rate Outstanding (Actual) Y: Max N Debtor Sr Advance Rate Outstanding (Limit) | ||
| Max N Supplier Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | IF Y > X THEN pass ELSE fail | LIST | X: Max Debtor Sr Advance Rate Outstanding (Actual) Y: Max Debtor Sr Advance Rate Outstanding (Limit) | ||
| Max N Supplier Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Max N Supplier Sr Advance Rate Outstanding - EC Assess A: Max N Supplier Sr Advance Rate Outstanding (Actual) B: Max N Supplier Sr Advance Rate Outstanding (Limit) | ||
| Seller Country Loc1 Conc Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | Seller Loc1 Country Excess Concentration | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Seller Country Loc1 Conc Sr Advance Rate Outstanding - EC Assess A: Seller Country Loc1 Conc Sr Advance Rate Outstanding (Actual) B: Seller Country Loc1 Conc Sr Advance Rate Outstanding (Limit) | |
| Max Supplier Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Max Supplier Sr Advance Rate Outstanding - EC Assess A: Max Supplier Sr Advance Rate Outstanding (Actual) B: Max Supplier Sr Advance Rate Outstanding (Limit) | ||
| Small Debtor Outstanding Receivables - EC Calc | Calc | Excess Concentration | Small Debtor Concentration Excess | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Small Debtor Outstanding Receivables - EC Assess A: Small Debtor Outstanding Receivables (Actual) B: Small Debtor Outstanding Receivables (Limit) | |
| Seller Country Loc2 Conc Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | Seller Loc2 Country Excess Concentration | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Seller Country Loc2 Conc Sr Advance Rate Outstanding - EC Assess A: Seller Country Loc2 Conc Sr Advance Rate Outstanding (Actual) B: Seller Country Loc2 Conc Sr Advance Rate Outstanding (Limit) | |
| Max N Debtor_Supplier Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Max N Debtor_Supplier Sr Advance Rate Outstanding - EC Assess A: Max N Debtor_Supplier Sr Advance Rate Outstanding (Actual) B: Max N Debtor_Supplier Sr Advance Rate Outstanding (Limit) | ||
| Max N Debtor Sr Advance Rate Outstanding - EC Calc | Calc | Excess Concentration | IF X = "pass" THEN 0 ELSE A - B | CURRENCY | X: Max N Debtor Sr Advance Rate Outstanding - EC Assess A: Max N Debtor Sr Advance Rate Outstanding (Actual) B: Max N Debtor Sr Advance Rate Outstanding (Limit) | ||
| Seller Country Loc2 Conc Sr Advance Rate Outstanding - EC Assess | Calc | Excess Concentration | Seller Loc2 Country Concentration limit breach determination | IF Y > X THEN pass ELSE fail | LIST | X: Seller Country Loc2 Conc Sr Advance Rate Outstanding (Actual) Y: Seller Country Loc2 Conc Sr Advance Rate Outstanding (Limit) | |
| Non EU - EC Calc | Raw | Excess Concentration | Excess Concentration Balance for Non EU | CURRENCY | |||
| Amended - EC Calc | Raw | Excess Concentration | CURRENCY | ||||
| Non DK - EC Calc | Raw | Excess Concentration | Excess Concentration Balance for Non DKK | CURRENCY | |||
| Custom Credit Score | Raw | Loan | A custom created score which indicates an individual's capacity to repay a loan. | TEXT | |||
| Number of Invoices | Raw | Loan | The number of invoices for an individual. | NUMBER | |||
| Importer Name | Raw | Loan | The name of the importer. | TEXT | |||
| Insurance | Calc | Loan | The cost of both insurance and Insurance Premium Tax combined | LOOKUP X IN Intl. Debtor Data tab in Column B. Produce Value in Column E on same tab (Insurance Coverage) | CURRENCY | X: Importer Name IFERROR THEN 0 | |
| Seller Invoice - Face Value | Raw | Loan | The total (face) value of a Seller's invoice - currency | CURRENCY | |||
| Country | Raw | Loan | The country where the underlying exposure originator is established. | TEXT | |||
| Loan Term | Raw | Loan | Original contractual term (use units to define days, months, years) | NUMBER | |||
| Fee Payment | Raw | Loan | Fees paid by the borrower to a lender. | CURRENCY | |||
| Ineligible Flag Count | Calc | Loan | Count number of "Yes" in rows 32-34,37,44-48 | NUMBER | |||
| Industry Type | Raw | Loan | The type of industry. | TEXT | |||
| Uninsured Flag | Calc | Loan | IF Y = 1 OR X = "P2" AND X = (("P3" OR "P1") , (Z = "USA" OR "CAN")), Then "Yes" ELSE "No" | LIST | X: Custom Credit Score Y: Revenue Target Flag Z: Country | ||
| Cancelled/Removed Flag | Raw | Loan | A flag indicating if an asset was canceled or removed. Field output is Yes/No. | 0: "No" 1: "Yes" | TEXT | ||
| Revenue Flag | Calc | Loan | LOOKUP X IN Intl. Debtor Data tab in Column B. Produce Value in Column D on same tab (Previous Year Revenue >$100m) | TEXT | X: Importer Name | ||
| Application ID | Raw | Loan | Unique identifier for application that gets shared to MOHELAs servicing system | TEXT | |||
| Refunded Flag | Raw | Loan | 0: "No" 1: "Yes" | LIST | |||
| Final Stage Payment | Raw | Loan | The payment made at the final stage, when the billing commences. | CURRENCY | |||
| Approved Debtor Country Flag | Calc | Loan | If X = "USA" OR "MEX" OR "CAN" OR Y = "Aaa", OR "Aa1" OR "Aa2" OR "Aa3" OR "A1" , Then "Yes", ELSE "No" | LIST | X: Country Y: Country Rating | ||
| Last Payment Date | Raw | Loan | The last scheduled payment date. | DATE | |||
| 30+ Days Past Due Flag | Calc | Loan | Mapped to Yes/No. Identifies assets that are 30+ days past due. | IF X > 30 THEN "Yes", ELSE "No" | TEXT | X: Days Past Due | |
| Perishable Flag | Calc | Loan | If X = "Vegetable Products (Fresh) OR "Produce" then "Yes" ELSE "No" | LIST | X: Industry Type | ||
| Loan ID | Raw | Loan | ID of a loan. | TEXT | |||
| Original Lender Establishment Country | Raw | Loan | The country where the original lender is established. | TEXT | |||
| Defaulted Flag | Calc | Loan | IF X > 120 THEN "Yes", ELSE "No" | TEXT | X: Days Past Due | ||
| Exporter Name | Raw | Loan | The name of the exporter. | TEXT | |||
| Funded Balance | Raw | Loan | CURRENCY | ||||
| Outstanding Exposure | Calc | Loan | Groupby Y and Sum on X | CURRENCY | X: Outstanding Balance Y: Exporter Name | ||
| Eligible Loan Flag | Calc | Loan | A flag indicating an asset meets all the of the key eligibility criteria of the facility. | If Rows 39,46-48,34-36 AND 44-50 = "No", then "Yes" ELSE "No" | TEXT | ||
| Original Term to Maturity Flag | Calc | Loan | A field used to identify if an asset meets a defined criteria. The flag values can define the flag criteria | If X > 90 AND Y DOES NOT EQUAL "P1" then "Yes", ELSE "No" | TEXT | X: Loan Term Y: Custom Credit Score | |
| Loan Status | Raw | Loan | The current status of the underlying exposure that has been securitized. Restructuring refers to any changes made to the contractual terms of the underlying exposure agreement due to forbearance. | TEXT | |||
| Insurance Flag | Calc | Loan | A flag whether the borrower has insurance. | IF X = "P4", Then "Yes", ELSE "No" | TEXT | X: Custom Credit Score | |
| Importer ID | Raw | Loan | The identifier for the importer. | TEXT | |||
| Revenue Target Flag | Calc | Loan | IF Country = "USA" OR "CAN", then "N/A", ELSE Y | TEXT | X: Country Y: Revenue Flag | ||
| Original Term Eligible Flag | Calc | Loan | A flag to indicate long loan terms. | IF X > 180 THEN "Yes", ELSE "No" | TEXT | X: Loan Term | |
| Fraudulent Flag | Raw | Loan | 0: "No" 1: "Yes" | LIST | |||
| Approved Lender Country Flag | Calc | Loan | If X = "USA" OR "MEX", "Yes", ELSE "No" | LIST | X: Original Lender Establishment Country | ||
| Maturity Date | Raw | Loan | The date of maturity of the underlying exposure or expiry of the lease. | DATE | |||
| APY | Raw | Loan | Annual Percentage Yield. | *100 | NUMBER | ||
| Cumulative Principal Repayment | Raw | Loan | The total amount of monies paid by a borrower has made to the lender above the scheduled payments due. | CURRENCY | |||
| Uninsured Exposure | Calc | Loan | If Calc is <0, then 0 else calculation | (Groupby X and Sum on Y) - Z | CURRENCY | X: Importer Name Y: Outstanding Balance Z: Insurance | |
| Partially Insured Flag | Calc | Loan | IF X = "P2" OR "P3" AND Y DOES NOT EQUAL "USA" OR "CAN" Then "Yes", ELSE "No" | LIST | X: Custom Credit Score Y: Country | ||
| Monthly Vintage | Raw | Loan | DATE | ||||
| Days Past Due | Raw | Loan | The number of days in which a payment has not been made as of its due date. | NUMBER | |||
| Country Rating | Raw | Loan | TEXT | ||||
| Late Fees | Raw | Loan | Fees accrued from late payments. | CURRENCY | |||
| Dealer Discount Fee | Raw | Loan | CURRENCY | ||||
| Receivable Settled Amount Cncy | Raw | Loan | Final Settlement for outstanding receivable in original currency. Can be used for multi currency. | NUMBER | |||
| Regulatory Event Flag | Calc | Loan | 0 = "No" 1 = "Yes" | LIST | |||
| Adjusted APY | Raw | Loan | Adjusted Annual Percentage Yield. | *100 | NUMBER | ||
| Currently Bankrupt Flag | Calc | Loan | A flag indicating if the borrower is currently bankrupt. | 0 = "No" 1 = "Yes" | TEXT | ||
| Delinquency Eligibity Flag | Calc | Loan | IF X > 60 AND =<120 THEN "Yes", ELSE "No" | X: Days Past Due | |||
| Approved Debtor Flag | Calc | Loan | If X = ("USA" OR "CAN") OR (X = "MEX" AND Y = "Yes") , Then "Yes", ELSE "No" | TEXT | X: Country Y: Revenue Target Flag | ||
| Exporter ID | Raw | Loan | The identifier for the exporter. | TEXT | |||
| Origination Date | Raw | Loan | The date of original underlying exposure advance. | DATE | |||
| Processing Fee | Calc | Loan | Fees charged for processing | X * Y | CURRENCY | X: Processing Fee Y: Conversion Rate - to USD | |
| Original Lender Name | Raw | Loan | The full legal name of the original lender. | TEXT | |||
| Seller Invoice - Face Value Cncy | Raw | Loan | The total (face) value of a Seller's invoice in original currency. Can be used for multi currency. | NUMBER | |||
| SPV Initial Purchase Price | Calc | Loan | SPV Initial Purchase Price - Currency | X * Y | CURRENCY | X: SPV Initial Purchase Price Y: Conversion Rate - to USD | |
| Conversion Rate - to USD | Raw | Loan | Conversion rate from given currency to USD in original currency. Can be used for multi currency. | NUMBER | |||
| Invoice Date | Raw | Loan | Each invoice date. This should be for a specific transaction so, while there may be many invoices for a given seller/buyer - each invoice date should be assigned to a specific transaction based on a transaction ID and thus is static. | DATE | Pull this value from '4. Sales report' tab. If value is not available, leave as NULL. | ||
| Total Fees Percent | Calc | Loan | Total fees as a percent of the Original Loan (Face Value of Loan) | Round(X / Y, 2 decimals) | NUMBER | X: Total Fees Y: Seller Invoice - Face Value Cncy | |
| Net Advance Amount | Calc | Loan | Advance Rate net fees | X - (A + B) | CURRENCY | X: Advance Rate Amount A: Transaction Fee Cncy B: Processing Fee Cncy | |
| Risk Deposit Settled Amount Cncy | Raw | Loan | Settlement amount for the Risk Deposit in original currency. Can be used for multi currency. | NUMBER | |||
| Outstanding Receivable Amount Cncy | Raw | Loan | Outstanding receivable amount until settled then adjusts to 0 | NUMBER | |||
| Currency Settlement Flag | Calc | Loan | Identifies if the Currency of the Settlement is in the approved list | If X ε (EUR, USD, GBP, CNY, or CAD) then "True" else "False" | LIST | X: Currency of Settlement | |
| Seller Risk Deposit | Calc | Loan | The risk amount assumed by the seller. Often calculated as (1-Advance Rate) X Face Value of Asset - currency | X * Y | CURRENCY | X: Seller Risk Deposit Y: Conversion Rate - to USD | |
| Currency of Settlement | Raw | Loan | Currency in which the settlement was performed | TEXT | |||
| Vintage Yr | Calc | Loan | Year (X) | TEXT | X: Original Product Purchase Date | ||
| Outstanding Receivable LTV Amount | Calc | Loan | Outstanding receivable adjusted for the LTV rate which is determined based on the Loan Status as per the master agreement | X * Y | CURRENCY | X: Outstanding Receivable LTV Amount Y: Conversion Rate - to USD | |
| Obligor Country | Raw | Loan | The country where the obligor is located. | TEXT | |||
| Advance Rate Amount | Calc | Loan | The amount that a lender has extended for a loan | X * Y | CURRENCY | X: Advance Amount Y: Conversion Rate - to USD | |
| Risk Deposit Settled Amount | Calc | Loan | Settlement amount for the risk deposit | X * Y | CURRENCY | X: Risk Deposit Settled Amount Y: Conversion Rate - to USD | |
| Collection Period Begin Date | Raw | Loan | The beginning date for current period collection | DATE | |||
| Loan Identifier | Raw | Loan | Unique identifier (ID) for each loan. The loan ID should not change through the life of the transaction. If the original loan ID cannot be maintained in this field enter the original ID followed by the new ID, comma delimited. | TEXT | |||
| Collection Period End Date | Raw | Loan | The end date for current period collection | DATE | |||
| Advance Transfer Date | Raw | Loan | Date of transfer of the Advance from Lender to Borrower/Seller | DATE | |||
| Loan Status - 1 Month Prior | Calc | Loan | loan status from prior month for given asset | TEXT | |||
| Outstanding Receivable LTV Amount Cncy | Raw | Loan | Outstanding receivable adjusted for the LTV rate which is determined based on the Loan Status as per the master agreement | NUMBER | |||
| Transaction Fee Cncy | Raw | Loan | Fees charged for the transaction in original currency. Can be used for multi currency. | NUMBER | |||
| Sector Eligibility Flag | Raw | Loan | Identifies if the sector is an eligible sector | Map value as follows: Y to Yes N to No NULL, leave NULL | LIST | If value is not available, leave as NULL | |
| Sr Advance Rate Outstanding Amount Cncy | Raw | Loan | Outstanding receivable amount until settled adjusted based on the Sr Advance Rate in original currency. Can be used for multi currency. | NUMBER | |||
| Currency of Transaction | Raw | Loan | Currency in which the transaction was performed | TEXT | |||
| Vintage Mnth | Calc | Loan | Month (X) | TEXT | X: Original Product Purchase Date | ||
| Currency Transaction Flag | Calc | Loan | Identifies if the Currency of the Transaction is in the approved list | If X ε (EUR, USD, GBP, CNY, or CAD) then "True" else "False" | LIST | X: Currency of Transaction | |
| Invoice Age | Calc | Loan | The age (in units identified) of an invoice | X - Y, if Y is NULL, this value should be NULL | NUMBER | X: Receivable Due Date Y: Invoice Date | |
| Total Fees | Calc | Loan | Total fees for transaction | X + Y | CURRENCY | X: Transaction Fee Cncy Y: Processing Fee Cncy | |
| Risk Deposit Settlement Date | Raw | Loan | Date Risk Deposit was settled, if applicable | DATE | |||
| Advance Amount Cncy | Raw | Loan | The amount advanced to the Supplier (Seller). Often calculated as Advance Rate X Face Value of Asset in original currency. Can be used for multi currency. | NUMBER | |||
| Obligor Annual Revenue | Raw | Loan | Annual Revenue categories for the obligor | TEXT | Pull this value from the '7. Daily balances' tab using o_external_id to map | ||
| Counter | Calc | Loan | A value to allow for CRT calculations based on count | 1 | NUMBER | Assign each loan the value of 1 | |
| SPV Identifier | Raw | Loan | Identifier of SPV asset was sold to | TEXT | |||
| Lender Risk Retention - Repaid | Calc | Loan | Risk Retention for the supplier in a receivables financing deal or other arrangement where there is a lender in the middle that has been repaid. | X * .05 | CURRENCY | X: Net Advance Amount | |
| Seller Risk Deposit Cncy | Raw | Loan | The risk amount assumed by the seller. Often calculated as (1 - Advance Rate) X Face Value of Assetin original currency. Can be used for multi currency. | NUMBER | |||
| SPV Sale Date | Raw | Loan | Date of Sale of the asset to the SPV | DATE | |||
| Original Product Purchase Date | Raw | Loan | DATE | ||||
| Data as of Date | Raw | Loan | This is the 'default' as-of date for static data of an element. This is mandatory for Root Elements for them to show up in TRA. | DATE | |||
| Receivable Due Date | Raw | Loan | Due Date of Receivable | DATE | |||
| Transaction Fee | Calc | Loan | Fees charged for the transaction | X * Y | CURRENCY | X: Transaction Fee Y: Conversion Rate - to USD | |
| Processing Fee Cncy | Raw | Loan | Fees charged for processing in original currency. Can be used for multi currency. | NUMBER | |||
| Original Lender - Obligor ID | Calc | Loan | A name for the unique combination of Original Lender (Seller) and Obligor (buyer) | Concatenate(X," - ",Y) | TEXT | X: Original Lender Name Y: Obligor | |
| Receivable LTV | Calc | Loan | Based on deal criteria, determine LTV for each receivable | When X ε ("Not Yet Due", "Repaid", "1 -30 DPD", "31 -60 DPD") then 100% When X = "61 -90 DPD" then 50% When X = "90+ DPD" then 0% | NUMBER | X: Loan Status | |
| Obligor | Raw | Loan | A person or entity who is legally or contractually obliged to provide a benefit or payment to another. | TEXT | |||
| SPV Initial Purchase Price Cncy | Raw | Loan | SPV Initial Purchase Price in original currency. Can be used for multi currency. | NUMBER | |||
| Receivable Settled Amount | Calc | Loan | Final Settlement for outstanding receivable | X * Y | CURRENCY | X: Receivable Settled Amount Y: Conversion Rate - to USD | |
| Sr Advance Rate Outstanding Amount | Calc | Loan | Outstanding receivable amount until settled adjusted based on the Sr Advance Rate | X * Y | CURRENCY | X: Sr Advance Rate Outstanding Amount Y: Conversion Rate - to USD | |
| Number of Obligors | Calc | Monthly KPIs | When A <> "Repaid" | Count Unique (X) | NUMBER | A: Loan Status X: Obligor | |
| Average Outstanding Receivable Amount | Calc | Monthly KPIs | X / Y If Y = 0, then 0 | CURRENCY | X: Outstanding Receivable Amount Y: Number of Receivables Outstanding | ||
| Number of Receivables Outstanding | Calc | Monthly KPIs | When A <> "Repaid" | Count(A) | NUMBER | A: Loan Status | |
| Risk Retention Amount - Current | Calc | Monthly KPIs | When Month(A) = Month(B) | Sum(X) - Y | CURRENCY | A: Report Date B: SPV Sale Date X: Net Advance Amount Y: SPV Initial Purchase Price - Current | |
| Average Total Fees Rate | Calc | Monthly KPIs | X / Y If Y = 0, then 0 | NUMBER | X: Total Fees Y: Seller Invoice - Face Value | ||
| Org Calculated LTV - Test | Calc | Monthly KPIs | If X > .8 THEN fail ELSE pass | TEXT | X: Org Calculated LTV | ||
| SPV Initial Purchase Price - Current | Calc | Monthly KPIs | When Month(A) = Month(B) | Sum(X) | CURRENCY | A: Report Date B: SPV Sale Date X: SPV Initial Purchase Price | |
| Number Sold to SPV | Calc | Monthly KPIs | When Month(A) = Month(B) | Count(B) | NUMBER | A: Report Date B: SPV Sale Date | |
| Cash Burn Rate - Current | Calc | Monthly KPIs | X / Y | NUMBER | X: Servicer Cash Reserves Y: Net Cash Burn - Current | ||
| Repurchased Exposures Count | Raw | Monthly KPIs | NUMBER | ||||
| Sr Advance Rate Outstanding Amount - 1 Month Prior | Calc | Monthly KPIs | X from prior month For Apr 2021 file, this value is 10,523,446.83 | CURRENCY | X: Sr Advance Rate Outstanding Amount - Current (from prior month) | ||
| Net Cash Burn - Current | Raw | Monthly KPIs | CURRENCY | ||||
| Org Calculated LTV | Calc | Monthly KPIs | The LTV as calculated by the organization. | X / Y | NUMBER | X: Sr Advance Rate Outstanding Amount - Current Y: Outstanding Receivable Amount | |
| Average Advance Rate | Calc | Monthly KPIs | X / Y If Y = 0, then 0 | NUMBER | X: Average Advance Rate Amount Y: Average Outstanding Receivable Amount | ||
| Repurchased Exposures | Raw | Monthly KPIs | The total outstanding principal balance of exposures of this type that have been repurchased (i.e. removed from the pool of underlying exposures by being bought back) by the originator/sponsor in this period. | CURRENCY | |||
| Outstanding Receivable Amount | Calc | Monthly KPIs | Outstanding receivable amount until settled then adjusts to 0 | Sum(X) | CURRENCY | X: Outstanding Receivable Amount | |
| Average Advance Rate Amount | Calc | Monthly KPIs | X / Y If Y = 0, then 0 | CURRENCY | X: Advance Rate Amount Y: Number of Receivables Outstanding | ||
| Servicer Cash Reserves | Raw | Monthly KPIs | CURRENCY | ||||
| Number of Sellers | Calc | Monthly KPIs | When A <> "Repaid" | Count Unique (X) | NUMBER | A: Loan Status X: Original Lender Name | |
| Conversion Rate - EUR to USD | Raw | Monthly KPIs | Conversion rate for EUR to USD | NUMBER | |||
| Sr Advance Rate Outstanding - 2 Months Prior | Calc | Monthly KPIs | X from prior month For Apr 2021 file, this value is NULL | X: Sr Advance Rate Outstanding Amount - 1 Month Prior (from prior month) | |||
| Sr Advance Rate Outstanding Amount - Current | Calc | Monthly KPIs | When A <> "Repaid" | Sum(X) | CURRENCY | A: Loan Status X: Sr Advance Rate Outstanding Amount | |
| Amount Sold to SPV | Calc | Monthly KPIs | When Month(A) = Month(B) | Sum(X) | CURRENCY | A: Report Date B: SPV Sale Date X: Oustanding Receivable Amount | |
| Total Eligible Balance | Calc | Pool | Y = "Yes" | Sum X | CURRENCY | X: Outstanding Balance Y: Eligible Loan Flag | |
| Total Current Balance | Calc | Pool | Sum X for all loans | CURRENCY | X: Current Balance | ||
| Report Date | Raw | Vintage | The date of the servicer report/cashflow report | DATE | |||
| Defaulted Receivable Balance | Calc | Vintage | Total current period defaulted receivables (cumulative) | If Y and Z = "Yes" | Sum X for Each Name | CURRENCY | X: Outstanding Balance Y: Fraud Flag Z: Defaulted Flag M: Monthly Vintage |
| Name | Raw | Vintage | Each Unique Monthly Vintage from Collateral Collection | ||||
| Original Balance | Calc | Vintage | The initial balance of each loan at the cut-off date or pre-funded month. | Sum X for each Name | CURRENCY | X: Funded Balance | |
| Defaulted Receivable Ratio | Calc | Vintage | (Sum of current and prior 2 months names x / sum of current and prior months names y) * 100 | NUMBER | X: Defaulted Balance Y: Origination Balance |