Loan Portfolio Analysis
This presentation is the property of its rightful owner.
Sponsored Links
1 / 33

Loan Portfolio Analysis PowerPoint PPT Presentation


  • 129 Views
  • Uploaded on
  • Presentation posted in: General

Loan Portfolio Analysis. Session Objectives. Read and interpret the essential MIS reports, especially the portfolio-at-risk aging report Use portfolio analysis as a tool for helping account officers/branches better monitor and manage their clients

Download Presentation

Loan Portfolio Analysis

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Loan portfolio analysis

Loan Portfolio Analysis


Session objectives

Session Objectives

  • Read and interpret the essential MIS reports, especially the portfolio-at-risk aging report

  • Use portfolio analysis as a tool for helping account officers/branches better monitor and manage their clients

  • Enhance decision-making skills to improve loan portfolio management


Rationale

Rationale

  • Loan portfolio is the largest income-generating

    asset of the bank

  • Loan portfolio has inherent risk

    It requires a focused-attention!

    Focused-attention means that we do regular portfolio analysis


Why do portfolio analysis

Why do portfolio analysis?

  • It is an easy and powerful tool in controlling delinquency

  • It is key to identifying and preventing PAR

  • It is key to planning the work of supervisors and BMs with every AO; planning the work of the product manager with the various Branch MFUs


Mis essential element in portfolio analysis

MIS: Essential Element in Portfolio Analysis

  • A good MIS should be able to provide portfolio performance information on a daily basis.

  • All portfolio information must be broken down by branch and AO.

  • Reports must be updated, simple, easy to access, accurate and reliable.

  • Portfolio performance reports must be easily accessible to all AOs, supervisors and BMs.


Mabs recommended essential reports

MABS Recommended Essential Reports


Mis reports

MIS Reports

Weekly

  • Performance Report By AO

  • Delinquency Report

  • Portfolio-At-Risk Aging Report

    Monthly

  • Performance Report By AO

  • Delinquency Report

  • Portfolio-At-Risk Aging Report

  • Monthly MF Performance Report (MF Performance Indicators plus Statement of Income and Expense)


Definition of terms

Definition of Terms

  • Loans outstanding – refers to the balance of all loan releases that remain outstanding

  • Loans disbursed – refers to the total loans released

  • Arrears – refers to the installments past due and not paid


Definition of terms1

Definition of Terms

  • Portfolio At Risk – refers to the total outstanding balance (principal only) of those accounts with installments past due for one day or more

  • Loan Loss – refers to principal amount written off from the portfolio


Key portfolio ratios

Key Portfolio Ratios:

  • Arrears rate

    = Amounts over 1 day past due X 100 Outstanding portfolio

  • Portfolio at risk rate

    = Outstanding balance of loans over 1 day past due X 100 Outstanding portfolio

  • Loan loss rate

    = Amount written off from the portfolio X 100

    Average outstanding portfolio for the period


Portfolio at risk aging report

Portfolio At Risk Aging Report

  • A tool that allows managers, supervisors and account officers to both identify and assess the quality and risk in their loan portfolios.

  • It provides a “window” into the portfolio so they can see how much principal is at risk and whether risk is serious, moderate, or minor.

  • If the PAR report is done on a weekly and monthly basis and broken down into smaller units (by branch or by account officer), it is probably one of the most useful management tools for senior and middle management.


Portfolio at risk aging report1

Portfolio-At-Risk Aging Report


How to read the par report

How to Read the PAR Report

  • No missed payments

    - (e.g. loans that are current and therefore LOW RISK)

  • PAR 1-7 days

    - (e.g. loans that are MINOR RISK BUT NEED WATCHING)

  • PAR 8–30 days - (e.g. MODERATE RISK)

  • PAR 31–60 days - (e.g. increasingly SERIOUS RISK)

  • PAR 61–90 days

    - (e.g. LOW CHANCE OF REPAYMENT, lots of collection effort)

  • PAR over 91 days - (e.g. LOSS)


How to read and analyze the portfolio at risk report

How to read and analyze the Portfolio at Risk Report

4 main indicators that can help in analyzing PAR

1. What portion of the portfolio is totally current (100% on time repayment on the exact date that the payment was due)

2. What portion of the portfolio has missed at least one payment (this is total loan outstanding minus current loans)?


How to read and analyze the portfolio at risk report1

How to Read and Analyze the Portfolio at Risk Report

3. What is the quality or aging of your delinquent portfolio like?

4. How many of the total number of borrowers are delinquent?

CHECK FOR TRENDS!


Par analysis

PAR Analysis

Who has the best performance?


Par 1 trends

PAR 1 Trends

Who has the best performance?


Par by age

PAR by AGE

Who has the best performance?


Loan loss rate

Loan Loss Rate

Who has the best performance?


Par by age1

PAR by AGE

Who has the best performance?


Par by age2

PAR by AGE

Who has the best performance?


Identifying sources of par

Identifying Sources of PAR

Example:


Identifying sources of par1

Identifying Sources of PAR


Identifying sources of par2

Identifying Sources of PAR


Identifying sources of par3

Identifying Sources of PAR

  • Before any bank wide PAR fighting is undertaken, Managers must isolate/ identify what are the main sources of PAR.

  • The first step is looking at the PAR by branch in order to identify if the problem is endemic to all branches or affecting one branch (or a few) only.


What branch is the par source

What branch is the PAR source?


Identifying sources of par4

Identifying Sources of PAR

  • San Isidro Branch with PAR30 = 20% is the main source

  • Before any action is taken against San Isidro Branch, Managers must isolate/ identify which AOs within the Branch are the main sources of PAR

  • The next step is looking at the PAR by AO in order to identify is the problem is endemic to all AO or one AO (or a few) only


What ao is the par source

What AO is the PAR source?


Identifying sources of par5

Identifying Sources of PAR

  • AO Mary with PAR30 = 36% is the main source

  • Before any action is taken against AO Mary, Managers must isolate/ identify in her portfolio what are the main causes of PAR


Identifying sources of par6

Identifying Sources of PAR

  • A break down of her PAR will further isolate PAR sources

    • First vs. Repeat Loans

    • Concentration on Cycle III and IV


Identifying sources of par7

Identifying Sources of PAR

  • Because her PAR rate is so high (relatively to the rest of the bank and the AOs within the same branch) the Branch Manager must first look into the possibility of FRAUD.


Identifying sources of par8

Identifying Sources of PAR

  • A break down of her PAR will further isolate PAR sources into

    • First vs. Repeat Loans

    • Repeat Loans III and IV

    • Loans with Increases above 30%

    • A particular activity


Identifying sources of par9

Identifying Sources of PAR

Isolating/identifying the source of PAR, will enable Branch Managers and Supervisors to:

  • Implement measures tailored specifically to the cause identified with the AO identified

  • Improve productivity

  • Improve portfolio quality

  • Improve time management


  • Login