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.
PAR30
€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 due | Balance | Book share |
|---|---|---|
| Current | €850,000 | 85.0% |
| 1 to 30 days | €60,000 | 6.0% |
| 31 to 60 days | €30,000 | 3.0% |
| 61 to 90 days | €20,000 | 2.0% |
| 91 to 180 days | €25,000 | 2.5% |
| Over 180 days | €15,000 | 1.5% |
| Total outstanding | €1,000,000 | 100.0% |
Late balance by band
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.