Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Npl Percentage Calculator
Finance Calculators

Npl Percentage Calculator

Published onAugust 30, 2025 Updated onOctober 25, 2026 8:56 am

The non-performing loan percentage is the single number that tells you whether a loan book is healthy or heading for trouble, and it is the ratio regulators from the IMF to the ECB watch first. One ratio never tells the whole story, though: provisions, recoveries, past-due buckets and restructured loans all change the picture. This calculator computes the headline NPL percentage plus ten supporting credit-quality metrics, then rates the portfolio against thresholds for banking, microfinance, corporate, mortgage or consumer books, with a plain-language risk rating and recommendation.

NPL Percentage Calculator
Headline NPL ratio, ten supporting credit-quality metrics and a segment-aware risk rating
Portfolio credit-quality dashboard
0.00%

NPL percentage (headline ratio)

Total loan portfolio$
Non-performing loans$
Performing loans
Reserves and net exposure
Provision coverage ratio%
Net NPL$
Net NPL percentage%
Credit risk exposure
Early-warning ratios
Past due 90+ days ratio%
Restructured loans ratio%
Problem loans ratio
Write-offs and score
Recovery rate%
Net write-offs$
Portfolio quality score / 100

Recommendation:

The risk bands are this tool’s house view per segment, not regulatory thresholds. The reporting-period choice labels your copied summary only.

Quick Answer

A bank with a $500,000,000 book, $25,000,000 of non-performing loans, $10,000,000 of provisions, $5,000,000 of write-offs, $1,000,000 of recoveries, $8,000,000 past due 90+ days and $12,000,000 restructured reports an NPL percentage of 5.00%. Provision coverage is 40.00%, net NPL is $15,000,000 (3.00%), the problem-loans ratio is 9.00%, the recovery rate is 20.00% and the portfolio quality score is 85.20 out of 100. Against banking thresholds that is MODERATE RISK: acceptable quality, but the 9.00% problem-loans ratio says monitoring and stronger provisioning are warranted. Every line above is a live run of the calculator, pre-filled for you.

Key takeaways

  • The headline ratio is NPL divided by the total book at gross value, before provisions. The World Bank and IMF define non-performing as 90+ days past due or unlikely to be repaid in full.
  • Net NPL is what actually threatens capital: NPL minus provisions already set aside. A 5% gross book with 40% coverage leaves 3% unreserved.
  • The problem-loans ratio (NPL + past-due-90 + restructured, over total) catches deterioration migrating toward NPL status before it arrives.
  • A 5% NPL means different things in different books: moderate for microfinance, high for a mortgage portfolio. The calculator switches thresholds by segment instead of judging every book by one line.
On this page
  • Quick Answer
  • How to use the NPL percentage calculator
  • The formulas: from gross NPL to the portfolio quality score
  • Worked example: a $500 million banking book
  • What is a good NPL percentage?
  • Why the supporting metrics matter
  • What competing NPL calculators miss
  • Frequently asked questions
  • Add This Calculator to Your Website
  • References

How to use the NPL percentage calculator

Enter the portfolio figures, pick the analysis type, and click Calculate. The results panel shows eleven metrics, color-codes the headline ratio against your segment's thresholds, and issues a risk rating with a plain-language recommendation. Results stay hidden until you calculate.

  1. Enter the total loan portfolio. The aggregate outstanding balance of all loans at gross book value, in dollars. This is the denominator of every ratio, so a wrong total corrupts the whole dashboard.
  2. Enter non-performing loans. The balance of loans past due 90 days or more, or otherwise classified as non-performing under your policy. If a borrower is 60 days late on a delinquency watchlist, those balances belong in the past-due-90 field only once they cross 90 days.
  3. Add provisions, write-offs and recoveries. Provisions are the reserves set aside against losses; write-offs and recoveries cover the current reporting period. These drive net NPL, coverage and recovery metrics.
  4. Add past-due-90 and restructured balances. These feed the early-warning ratios that catch deterioration before it becomes NPL. Restructured loans flatter the headline ratio, which is why the problem-loans ratio adds them back.
  5. Choose the analysis type and reporting period. Thresholds differ by book: mortgage books are judged more strictly than microfinance. The reporting period labels your copied summary; it does not change any ratio.

Inputs must be non-negative, and non-performing loans cannot exceed the total portfolio. The date of first delinquency calculator helps pin down when a loan crossed into past-due territory if your aging buckets are disputed.

The formulas: from gross NPL to the portfolio quality score

Every metric on the dashboard is a ratio against the total book or a simple combination of the inputs. NPL percentage is non-performing loans divided by the total portfolio, times 100, both at gross book value without deducting provisions. That gross-value convention is the IMF standard: the amount recorded as non-performing is the full balance-sheet value of the loan, not just the overdue instalments.

NPL % = (Non-performing loans ÷ Total portfolio) × 100
Net NPL = max(0, NPL − Provisions)  |  Coverage = (Provisions ÷ NPL) × 100
Problem loans % = ((NPL + Past due 90+ + Restructured) ÷ Total) × 100
Recovery rate = (Recoveries ÷ Write-offs) × 100  |  Credit risk exposure = Net NPL + Net write-offs
Quality score = max(0, 100 − 2×NPL% − 1.5×PastDue% − 1×Restructured%)

Net NPL is the exposure left after reserves, and investors watch it because it is the loss that would actually hit capital if nothing is recovered. Credit risk exposure adds net write-offs to net NPL for the fullest loss picture. The quality score is the tool's own 0–100 composite: it penalizes the headline ratio most (times two), past-due-90 next (times 1.5) and restructured balances least, so two books with the same headline ratio can score very differently. The expected default frequency calculator takes the forward-looking view this dashboard's backward-looking ratios complement.

Worked example: a $500 million banking book

The calculator opens with this example pre-filled: a bank reports, for the quarter, a $500,000,000 portfolio with $25,000,000 non-performing, $10,000,000 of provisions, $5,000,000 of write-offs, $1,000,000 of recoveries, $8,000,000 past due 90+ days and $12,000,000 restructured, analyzed as a banking book.

MetricCalculationResult
NPL percentage25 ÷ 500 × 1005.00%
Provision coverage10 ÷ 25 × 10040.00%
Net NPL25 − 10$15,000,000.00
Net NPL percentage15 ÷ 500 × 1003.00%
Past due 90+ ratio8 ÷ 500 × 1001.60%
Restructured ratio12 ÷ 500 × 1002.40%
Problem loans ratio(25 + 8 + 12) ÷ 500 × 1009.00%
Recovery rate1 ÷ 5 × 10020.00%
Net write-offs5 − 1$4,000,000.00
Performing loans500 − 25$475,000,000.00
Credit risk exposure15 + 4$19,000,000.00
Portfolio quality score100 − 10 − 2.4 − 2.485.20

Against banking thresholds (good at or below 3%, moderate at or below 5%, high at or below 10%), 5.00% rates MODERATE RISK. The number that should worry the risk committee is the 9.00% problem-loans ratio sitting behind the headline: nearly twice the NPL figure is stressed, migrating or renegotiated. Type these figures into the calculator to reproduce every line.

What is a good NPL percentage?

It depends on the market and the book. Below 3% is generally healthy for a developed-market bank, up to 5–6% can be acceptable in emerging markets, above 10% signals serious credit-quality problems anywhere, and a rise of a percentage point or more quarter-on-quarter is an early warning regardless of the level. The calculator applies its own rating bands per segment, which mirror how supervisors think: mortgage books are judged most strictly because the collateral is standardized, microfinance most leniently because the business model prices in higher delinquency.

SegmentGoodModerateHighAbove high
Banking≤ 3%≤ 5%≤ 10%Critical
Microfinance≤ 5%≤ 10%≤ 15%Critical
Corporate lending≤ 2%≤ 4%≤ 8%Critical
Mortgage portfolio≤ 1%≤ 3%≤ 6%Critical
Consumer credit≤ 4%≤ 8%≤ 12%Critical

These bands are the tool's house view, not regulatory thresholds: supervisors set expectations bank by bank. The ECB, for example, runs a calendar-provisioning framework that pushes banks toward full coverage of non-performing exposures over two to nine years depending on collateral, which is the institutional version of the same instinct behind the coverage ratio on the dashboard.

Why the supporting metrics matter

The headline ratio can flatter a book. A bank can hold NPL at 3% while past-due-90 climbs, which the problem-loans ratio catches. Provision coverage tells you whether the bad book is actually reserved: 40% coverage on a 5% NPL book is a very different position from 90% coverage, and the tool pairs coverage with net NPL rather than reporting either alone. The recovery rate shows whether the collections team earns back what gets written off, and credit risk exposure rolls the unreserved book plus net write-offs into the figure a CFO actually has to fund. That is why this calculator reports the full dashboard instead of one number.

What competing NPL calculators miss

Every rival page stops at one ratio. Calculator Ultra's NPL tool is a three-way rearrangement of the same formula with no supporting metrics and no risk rating. BraveCalculator's NPL and net-NPL pages each compute a single ratio from two or three inputs. Calculator.dev's tool computes the headline ratio with decent educational content around it, but nothing on provisions, recoveries or segment thresholds. The glossary pages (Familiarize's worked example is the best of them) explain the ratio well without offering an interactive calculator at all.

The gap this page fills is the combination: gross and net NPL side by side, provision coverage, past-due and restructured ratios, the problem-loans ratio, recovery rate, net write-offs, credit risk exposure and a 0–100 quality score, all rated against per-segment thresholds with an automated risk rating and recommendation. Nobody else turns the inputs into a risk-committee-ready dashboard.

Frequently asked questions

Gross NPL is the full balance of non-performing loans divided by the total book. Net NPL subtracts the provisions already set aside, so it measures the unreserved exposure. Investors watch net NPL because it shows the loss that would actually hit capital if nothing is recovered.

There is no universal target, but higher means the bank has already absorbed more of the expected loss. A 40% coverage ratio, as in the worked example, leaves 60% of the bad book unreserved, which is why the tool pairs coverage with net NPL rather than reporting either alone.

Ninety days past due is the international convention used by regulators and the IMF: beyond that point, the probability of full repayment drops sharply enough that the loan is classified as impaired. The World Bank's indicator defines NPLs as loans past due by 90 days or more, or otherwise unlikely to be repaid in full. Some institutions use stricter internal cutoffs.

The durable ways are tighter underwriting, earlier intervention on delinquent accounts, restructuring viable borrowers, selling or writing off hopeless exposures, and improving collections to lift the recovery rate. Shrinking the denominator by growing the book also lowers the ratio, but it masks rather than fixes the problem.

It is a 0–100 composite that penalizes the headline NPL ratio most (times two), past-due-90 next (times 1.5), and restructured balances least (times one). It lets you compare two books at a glance: a score of 85 with a 5% NPL is a cleaner book than a score of 70 with the same headline ratio.

Yes. The analysis-type selector switches the rating thresholds, because a 5% NPL means something very different in microfinance (moderate) than in a mortgage book (high). The underlying metric math is identical across segments.

The broadest stress measure on the dashboard: NPL plus past-due-90 plus restructured, over the total book. It catches deterioration migrating toward NPL status before it arrives, which is exactly what a risk committee wants to see trending down.

Both. A rolling twelve-month view smooths seasonality, segment analysis finds pockets of stress, and peer comparison tells you whether a 6% ratio is a house problem or a market problem. A single quarter's ratio, in isolation, says the least.

Add This Calculator to Your Website

Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.

Powered by Calculator Zilo

References

  1. World Bank DataBank. Bank Nonperforming Loans to Total Gross Loans (%), Indicator FB.AST.NPER.ZS: NPLs defined as loans past due by 90 days or more or unlikely to be repaid in full, reported at gross book value. Accessed October 23, 2026.
  2. Federal Reserve Bank of St. Louis (FRED). Bank Non-Performing Loans to Gross Loans for World: ratio of defaulting loans (90+ days past due) to total gross loans, sourced from the World Bank and IMF. Accessed October 23, 2026.
  3. Familiarize Docs. Non-Performing Loan Ratio: worked NPL ratio example with provisioning impact on net income. Accessed October 23, 2026.
  4. European Central Bank. The Economic Impact of the NPL Coverage Expectations in the Euro Area: supervisory coverage expectations pushing banks toward full provisioning of legacy NPLs. Accessed October 23, 2026.
  5. ECB Banking Supervision. Public Consultation FAQ on the Draft Addendum to the ECB Guidance on Non-Performing Loans: the NPL vintage concept and the two/seven-year prudential provisioning backstops. Accessed October 23, 2026.
  6. Malta Financial Services Authority. ECB Publishes Guidance to Banks on Tackling Non-Performing Loans: the ECB's final NPL guidance and its supervisory expectations for NPL strategies. Accessed October 23, 2026.

Related calculators

Finance CalculatorsZakat CalculatorThis Zakat calculator totals the wealth Zakat is charged on (cash, gold, silver, investments, business...Finance CalculatorsNet Worth Percentile CalculatorWhere does your net worth rank among households your age?Finance CalculatorsNet Worth By Age CalculatorWhat should your net worth be at your age? Two honest benchmarks exist, and this calculator applies both.Finance CalculatorsDaily Profit CalculatorA business can feel busy and still lose money.Finance CalculatorsProfit Interest Units CalculatorProfit interest units are how LLCs taxed as partnerships grant equity-like upside without giving away the...Finance CalculatorsCost Of Interest CalculatorHow much will a loan really cost you in interest?

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search