Calculate portfolio at risk and PAR30 for loan books

Enter outstanding balances by days past due to see PAR30 and how the loan loss reserve covers balances more than 30 days late.

Days past due balances
Reserve

The demo loan book is made up.

PAR30

9.0%
PAR115.0%
PAR606.0%
PAR904.0%

€90,000 of the €1,000,000 outstanding sits in loans more than 30 days late, a PAR30 of 9.0%.

Book by days late

Days past dueBalanceBook share
Current€850,00085.0%
1 to 30 days€60,0006.0%
31 to 60 days€30,0003.0%
61 to 90 days€20,0002.0%
91 to 180 days€25,0002.5%
Over 180 days€15,0001.5%
Total outstanding€1,000,000100.0%

Late balance by band

1 to 30 days
€60,000
31 to 60 days
€30,000
61 to 90 days
€20,000
91 to 180 days
€25,000
Over 180 days
€15,000

The risk coverage ratio is 77.8%, with the €70,000 reserve set against the €90,000 balance more than 30 days late.

Email your portfolio at risk result

Set what happens at each days past due band in your own rules, such as reminders, restructuring or a stop on repeat loans, then read PAR by branch, loan officer and product. Start your trial

Portfolio at risk calculation

PAR divides the whole outstanding balance of loans late by more than a given number of days by total outstanding. The whole balance counts because it is all at risk.

Total outstanding = Current + 1 to 30 days + 31 to 60 days + 61 to 90 days + 91 to 180 days + Over 180 days
PAR1 = (Total outstanding − Current) ÷ Total outstanding
PAR30 = (31 to 60 days + 61 to 90 days + 91 to 180 days + Over 180 days) ÷ Total outstanding
PAR60 = (61 to 90 days + 91 to 180 days + Over 180 days) ÷ Total outstanding
PAR90 = (91 to 180 days + Over 180 days) ÷ Total outstanding
Risk coverage ratio = Loan loss reserve ÷ (31 to 60 days + 61 to 90 days + 91 to 180 days + Over 180 days)

PAR30 for the numbers above.

(30,000 + 20,000 + 25,000 + 15,000) ÷ 1,000,000 = 9.0%

Restructured and rescheduled loans count in the band you place them in. Read PAR with the reserve and over time by branch, loan officer and product.

Portfolio at risk calculation

Portfolio at risk measures the share of a loan book in loans past due. Enter outstanding balances by days past due to calculate PAR30, PAR1, PAR60 and PAR90.

Each measure counts the whole outstanding balance of loans in the relevant late bands. Read the results with the loan loss reserve and over time by branch, loan officer and product.

Portfolio at risk FAQs

What is portfolio at risk?

Portfolio at risk is the share of total outstanding in loans past due by more than a specified number of days. It counts each late loan’s whole outstanding balance.

How is PAR30 calculated?

Add the outstanding balances of loans more than 30 days late, then divide by total outstanding. This gives the share of the loan book represented by those balances.

What does PAR1 show?

PAR1 is the share of total outstanding in loans in the late bands. The calculation adds those band balances and divides by total outstanding.

How do I calculate the risk coverage ratio?

Divide the loan loss reserve by the outstanding balance of loans more than 30 days late. The result shows the reserve against that balance.

Why does portfolio at risk count the whole loan balance?

The whole outstanding balance of a late loan is at risk. Counting it shows the amount at risk before write-offs.