ECL Workspace

← AccountsExample BankReporting date31 Mar 2027RunQ4 FY27 reportingCalculated

Account CR0005

Term · J. Varghese · Borrower BR-40094 · Reporting date 31 Mar 2027 · Run 01

Outstanding balance

₹82,50,000

Stage

Stage 2 · lifetime, 60 months

PD deterioration · Staging policy v1

Model ECL

₹16,85,011

Bank reference

₹19,88,313

Difference

₹-3,03,302

Inspect calculation Compare with bank

1 · Why this stage?

12-month PD rose beyond the configured relative/absolute thresholds against origination PD. Evidence: seed_loan_master.csv, 31 Mar 2027.

2 · What exposure was used?

Contractual amortising schedule, 60 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?

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

4 · What recoveries were assumed? Workout LGD v1 — unsecured.

Recovery assumptions
Assumption	Value	Assumption	Value
Collateral valuation	₹0	Valuation date	31 Mar 2027
Haircut	100.0%	Recovery lag	—
Recovery costs	—	Effective LGD	100.0%

5 · How was ECL calculated? Period contributions, discounted at the effective interest rate of 10.0%. 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	8.94%	8.94%	₹82,50,000	100.0%	0.909	₹6,70,181
Year 2 (Mar 28–Mar 29)	base	8.14%	17.07%	₹68,98,671	100.0%	0.826	₹4,63,937
Year 3 (Mar 29–Mar 30)	base	7.41%	24.48%	₹54,12,209	100.0%	0.751	₹3,01,317
Year 4 (Mar 30–Mar 31)	base	6.75%	31.23%	₹37,77,100	100.0%	0.683	₹1,74,085

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	CORP_RATED v1 v1
LGD parameters	Workout LGD v1

Borrower exposures

No other exposures for this borrower.

Reconciliation

Bank reference ECL ₹19,88,313 · difference ₹-3,03,302 · outside tolerance

Open comparison