ECL Workspace

← AccountsExample BankReporting date31 Mar 2027RunQ4 FY27 reportingCalculated

Account HL0000

Mortgage · M. Iyer · Borrower BR-40122 · Reporting date 31 Mar 2027 · Run 01

Outstanding balance

₹25,00,000

Stage

Stage 3 · lifetime, 180 months

NPA (credit-impaired) · Staging policy v1

Model ECL

₹10,72,603

Bank reference

₹10,72,603

Difference

₹-0

Inspect calculation Compare with bank

1 · Why this stage?

Account is credit-impaired (NPA). Evidence: seed_loan_master.csv, 31 Mar 2027.

2 · What exposure was used?

Contractual amortising schedule, 180 months remaining. EAD at each period is the expected outstanding balance after scheduled repayments; no undrawn commitment on this facility.

3 · What default risk was used?

HOME_LOAN v1 v1, rating grade B, lifetime horizon (Stage 3). Marginal default probability per period, conditioned on each scenario.

4 · What recoveries were assumed? Workout LGD v1 — secured by property.

Recovery assumptions
Assumption	Value	Assumption	Value
Collateral valuation	₹27,50,000	Valuation date	31 Mar 2027
Haircut	25.0%	Recovery lag	—
Recovery costs	—	Effective LGD	42.9%

5 · How was ECL calculated? Period contributions, discounted at the effective interest rate of 9.5%. Base scenario shown; weighted result below.

Period contributions to expected credit loss
Period	Scen.	Marginal PD	Cum. PD	EAD	LGD	Discount	ECL contrib.
Year 1 (Mar 27–Mar 28)	base	100.00%	100.00%	₹25,00,000	42.9%	1.000	₹10,72,603

Traceability

Where each input came from
Input	Source
Outstanding balance	seed_loan_master.csv · 31 Mar 2027
Days past due / rating	seed_loan_master.csv · 31 Mar 2027
Collateral value	seed_loan_master.csv · 31 Mar 2027
PD parameters	HOME_LOAN v1 v1
LGD parameters	Workout LGD v1

Borrower exposures

No other exposures for this borrower.

Reconciliation

Bank reference ECL ₹10,72,603 · difference ₹-0 · within tolerance

Open comparison