PAR Analysis

PAR Analysis measures Portfolio at Risk, the headline microfinance health metric, by aging the outstanding balance of loans with overdue instalments into 1-30, 31-60, 61-90 and 90+ day buckets. Pivot and graph views let managers track the PAR ratio trend and identify concentrations of risk by product, officer or branch.

Workflow

Open the analysis and group by PAR bucket to size each risk band.
Pivot by officer, product or branch to locate risk concentrations.
Compare the PAR ratio against internal and regulatory thresholds.
Drill into a bucket to list the underlying delinquent loans.
Export for the board and risk committee packs.

Fields reference

Every field on this screen, drawn from the live data model.

Field	Type	Required	Description
Portal Access URL `access_url`	Text	—	Customer Portal URL
Dormant `is_dormant`	Yes/No	—	Flagged when no repayment activity within dormancy period
Status `state`	Choice: Draft, Submitted, Under Appraisal, Appraised, Committee Review, Approved, Disbursed, Active	Yes	Status
Member `member_id`	Link → mfi.member	Yes	Member
Loan Product `product_id`	Link → mfi.loan.product	Yes	Loan Product
Branch `branch_id`	Link → mfi.branch	Yes	Branch
Applied Amount `applied_amount`	Money	Yes	Applied Amount
Loan Term (Months) `loan_term`	Number	Yes	Loan Term (Months)
Access warning `access_warning`	Long text	—	Access warning
Has Message `has_message`	Yes/No	—	Has Message
Loan Number `loan_number`	Text	—	Loan Number
Name `name`	Text	—	Name
Currency `currency_id`	Link → res.currency	—	Currency
Company `company_id`	Link → res.company	—	Company
Loan Officer `officer_id`	Link → res.users	—	Loan Officer
Lending Group `group_id`	Link → mfi.member.group	—	Lending Group
Approved Amount `approved_amount`	Money	—	Approved Amount
Disbursed Amount `disbursed_amount`	Money	—	Disbursed Amount
Loan Purpose `purpose`	Long text	—	Loan Purpose
Loan Type `loan_type`	Choice: Individual Loan, Group Loan, Emergency Loan, Asset Finance, Agriculture Loan, Education Loan, Business Loan, Salary Advance	—	Loan Type
Interest Method `interest_method`	Choice: Flat Rate, Declining Balance (Reducing), Equal Principal Payments	—	Interest Method
Annual Interest Rate (%) `interest_rate`	Decimal	—	Annual Interest Rate (%)
Repayment Frequency `repayment_frequency`	Choice: Daily, Weekly, Bi-Weekly (Fortnightly), Monthly, Quarterly, Bullet (Lump Sum at End)	—	Repayment Frequency
Grace Period - Principal (Months) `grace_period_principal`	Number	—	Grace Period - Principal (Months)
Grace Period - Interest (Months) `grace_period_interest`	Number	—	Grace Period - Interest (Months)
Application Date `application_date`	Date	—	Application Date
Appraisal Date `appraisal_date`	Date	—	Appraisal Date
Approval Date `approval_date`	Date	—	Approval Date
Disbursement Date `disbursement_date`	Date	—	Disbursement Date
First Repayment Date `first_repayment_date`	Date	—	First Repayment Date
Maturity Date `maturity_date`	Date	—	Maturity Date
Closure Date `closure_date`	Date	—	Closure Date
Total Principal `total_principal`	Money	—	Total Principal
Total Interest `total_interest`	Money	—	Total Interest
Total Fees `total_fees`	Money	—	Total Fees
Total Penalties `total_penalties`	Money	—	Total Penalties
Total Repayable `total_repayable`	Money	—	Total Repayable
Principal Paid `principal_paid`	Money	—	Principal Paid
Interest Paid `interest_paid`	Money	—	Interest Paid
Fees Paid `fees_paid`	Money	—	Fees Paid
Penalties Paid `penalties_paid`	Money	—	Penalties Paid
Total Paid `total_paid`	Money	—	Total Paid
Outstanding Principal `outstanding_principal`	Money	—	Outstanding Principal
Outstanding Interest `outstanding_interest`	Money	—	Outstanding Interest
Total Outstanding `outstanding_total`	Money	—	Total Outstanding

Actions & buttons

Buttons available on this screen and what they do:

Submit
Start Appraisal
Complete Appraisal
Approve
Disburse
Split into Tranches
Calculate ECL
Make Repayment
Close Loan
Reject
Cancel
Reset to Draft
Generate NOC
E-Sign Contract

Status lifecycle

Records on this screen move through these statuses:

Draft → Submitted → Under Appraisal → Appraised → Committee Review → Approved → Disbursed → Active → Closed → Written Off

Notes & rules

Model: mfi.loan; pivot/graph analytics.
Buckets: 1-30, 31-60, 61-90, 90+ days.
PAR = at-risk outstanding balance / total OLB.
Core supervisory and risk-management KPI.

Technical model: mfi.loan · Record: Loan