ABS loan tape pool eligibility check and expected loss
Paste your loan tape to see which loans your criteria exclude and the eligible pool’s score mix, expected loss and concentration.
Loan tape
Use one loan per row with columns loan_id, borrower_id, balance, score, pd, lgd, rate, remaining_term, dpd and region. Balance and score are needed. The other columns are optional. Enter PD, LGD and rate as percentages.
500 loans read, 0 rows skipped because the balance was not a number.
The tape is read in your browser and is not uploaded.
The 500 auto loans in the demo tape are made up.
Expected loss of eligible pool
459 loans with €8,443,740 meet the criteria, 41 loans with €642,720 do not, and the expected loss of the eligible pool is €121,488. The eligible pool’s weighted average interest rate is 6.15%.
Eligible pool score mix
Eligible pool concentration by region
The largest borrower holds 1.00% of the eligible pool, with borrowers over the 0.50% borrower limit: 1.
The largest region holds 34.0% of the eligible pool, with regions over the 25.0% region limit: 1.
Score band results
| Score band | Loans | Balance | Share of balance | PD | Expected loss | Share of expected loss |
|---|---|---|---|---|---|---|
| Below 640 | 54 | €971,760 | 11.5% | 8.00% | €34,983 | 28.8% |
| 640 to 699 | 156 | €2,921,220 | 34.6% | 4.00% | €52,582 | 43.3% |
| 700 to 759 | 173 | €3,248,090 | 38.5% | 2.00% | €29,233 | 24.1% |
| 760 and above | 76 | €1,302,670 | 15.4% | 0.80% | €4,690 | 3.9% |
| Total | 459 | €8,443,740 | 100.0% | 3.20% | €121,488 | 100.0% |
Excluded loans
| Reason | Loans | Balance |
|---|---|---|
| More than 30 days past due | 10 | €159,560 |
| Score below 600, or no score | 15 | €219,880 |
| More than 84 months of remaining term | 16 | €263,280 |
| Total | 41 | €642,720 |
More pool tools
Get your result by email
Run the same eligibility criteria and scoring as a decision flow on every loan tape, so each new cut of the pool gets the same check before it goes to investors. Start your trial
Pool checks and expected loss
Eligible = Days past due ≤ Maximum days past due & Score ≥ Minimum score & Remaining term ≤ Maximum remaining term PD = Loan’s own PD | Score bands and PD Expected loss = Σ Balance × PD × LGD Expected loss of eligible pool = Expected loss ÷ Eligible balance Weighted average score = Σ (Balance × Score) ÷ Eligible balance Borrower limit = Borrower balance ÷ Eligible balance Region limit = Region balance ÷ Eligible balance
Your criteria, band PDs, LGD and limits are your own assumptions. The page applies them as written and does not rate the pool or say whether it can be securitised.
ABS loan tape analysis
An ABS loan tape lists the loans in an asset-backed security pool. This tool applies your eligibility criteria, groups eligible loans by score and works out expected loss from balance, PD and LGD.
The results show which loans are excluded and how the eligible balance and expected loss are distributed across score bands. You can also review borrower and region concentration before assessing the pool.
Loan tape questions
How do you analyse an ABS loan tape?
Apply eligibility criteria to each loan, then review the eligible pool’s score mix, expected loss and concentration. This tool shows excluded loans and the results for the eligible pool.
What is ABS pool stratification?
Pool stratification groups eligible loans into score bands and shows the loans and balance in each band. This tool also shows each band’s PD and expected loss.
How is expected loss calculated for a loan pool?
Expected loss is the sum of each loan’s balance multiplied by its PD and LGD. The tool shows expected loss for the eligible pool in euros and as a share of its balance.
What are eligibility criteria for a securitisation pool?
Eligibility criteria specify which loans are included in a pool. This tool checks days past due, score and remaining term when the relevant columns are present in the tape.
How do you check concentration in an ABS pool?
Borrower and region concentration are each calculated as a share of the eligible pool’s balance. The tool shows the largest share and counts borrowers and regions above your limits.