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.

Eligibility criteria

A loan that fails a criterion is left out and counted under the first one it fails. Missing columns are not checked. The criteria are your own.

Score bands and PD

The tape’s own PD and LGD are used when available, and the band PD and this LGD are used when they are missing. These are your assumptions.

Concentration limits

The limits are your own. The page counts borrowers and regions above them.

Expected loss of eligible pool

1.44%
Eligible balance€8.44m
Loans excluded41
Weighted average score707

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 bandLoansBalanceShare of balancePDExpected lossShare of expected loss
Below 64054€971,76011.5%8.00%€34,98328.8%
640 to 699156€2,921,22034.6%4.00%€52,58243.3%
700 to 759173€3,248,09038.5%2.00%€29,23324.1%
760 and above76€1,302,67015.4%0.80%€4,6903.9%
Total459€8,443,740100.0%3.20%€121,488100.0%

Excluded loans

ReasonLoansBalance
More than 30 days past due10€159,560
Score below 600, or no score15€219,880
More than 84 months of remaining term16€263,280
Total41€642,720

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.