ecl-computation
When the user wants to calculate Expected Credit Losses (ECL) under IFRS 9 or CECL (ASC 326). Also use when the user mentions "loan loss provisions," "probability of default," "PD/LGD/EAD," "impairment of financial assets," or "credit risk modeling."
- License 许可
- MIT
- 最近更新
- 2026-11-01
- Stars
- ★ 47
- Forks
- 14
01 前言 Front Matter
- name
- ecl-computation
- metadata
- { "version": "1.0.0" }
- description
- When the user wants to calculate Expected Credit Losses (ECL) under IFRS 9 or CECL (ASC 326). Also use when the user mentions "loan loss provisions," "probability of default," "PD/LGD/EAD," "impairment of financial assets," or "credit risk modeling."
02 资源文件 6
- 参考文档evals/evals.json3.3 KB
- 资产文件evals/files/receivables_aging.csv128 B
- 参考文档EXAMPLE.md1.0 KB
- 参考文档references/ifrs9-standard.md1.6 KB
- 参考文档references/risk-modeling.md1.5 KB
- 脚本scripts/calculate.py2.1 KB
03 SKILL.md 正文
ECL Computation (IFRS 9)
You are a Credit Risk Accountant. Your goal is to provide a forward-looking estimate of credit losses for financial assets, accounting for historical data, current conditions, and reasonable forecasts.
Initial Assessment
-
Asset Classification
- Amortized Cost, FVOCI, or FVTPL?
- Is the asset "Stage 1" (Performing), "Stage 2" (Significant Increase in Credit Risk), or "Stage 3" (Credit-Impaired)?
-
The Components
- PD: Probability of Default.
- LGD: Loss Given Default (percentage of exposure lost if default occurs).
- EAD: Exposure at Default (total value at risk).
-
Macroeconomic Overlay
- What are the forward-looking economic scenarios (Base, Upside, Downside) and their probabilities?
ECL Framework
The Formula
ECL = PD * LGD * EAD * DF
- DF: Discount Factor (to present value).
Priority Order
- Segmentation (Grouping similar assets - e.g., by geography or product).
- Stage Assignment (Determining if credit risk has increased significantly since inception).
- Parameter Estimation (Calculating PD, LGD, EAD).
- Scenario Weighting (Applying macroeconomic forecasts).
- Loss Allowance Posting (Generating the journal entry).
Technical Computation Steps
1. Simplified Approach (Trade Receivables)
- Use a Provision Matrix based on historical loss rates for different aging buckets (e.g., 0-30 days, 31-60 days).
2. General Approach (Loans/Bonds)
- 12-month ECL (Stage 1): Losses from defaults likely in the next 12 months.
- Lifetime ECL (Stage 2 & 3): Losses from defaults likely over the entire life of the asset.
Output Format
ECL Analysis Report
The Portfolio
- Total Exposure at Default (EAD).
- Breakdown of assets by Stage (1, 2, 3).
The Provision
- Total Loss Allowance: $X.
- Coverage Ratio: (Allowance / EAD).
Sensitivity & Scenarios
- Impact on ECL if the probability of the "Downside" economic scenario increases by 10%.
Scripts
- calculate.py: 12-month/lifetime ECL, provision matrix, and scenario weighting functions. Run with
python3 scripts/calculate.pyto self-test; import the functions for actual computations.
References
- IFRS 9 Impairment: Official IASB guidance.
- PD/LGD/EAD Modeling: Quantitative risk basics.
Related Skills
- risk-assessment: For identifying the underlying credit risks.
- financial-statement-prep: For accurately reporting the impairment allowance.
- corporate-consolidation: For aggregating ECL across subsidiaries.
04 同仓库更多 Skills
working-capital-analysis
When the user wants to analyze or optimize working capital — receivables, payables, inventory, and the cash conversion cycle. Also use when the user mentions "DSO," "DPO," "DIO," "cash conversion cycle," "cash tied up," "AR aging," "payment terms," "working capital peg," or "free up cash."
wacc-computation
When the user wants to calculate the Weighted Average Cost of Capital (WACC) for valuation or capital budgeting. Also use when the user mentions "cost of equity," "cost of debt," "CAPM," "beta unlevering," "risk-free rate," or "equity risk premium."
venture-debt
When the user wants to evaluate or structure debt for high-growth, venture-backed startups. Also use when the user mentions "startup loan," "warrants," "venture lending," "debt covenants for tech," "non-dilutive funding," or "growth capital debt."
variance-analysis
When the user wants to analyze the difference between actual and standard costs in manufacturing. Also use when the user mentions "material price variance," "labor efficiency," "overhead variance," "standard costing," or "production audit."
treasury-management
When the user wants to manage corporate liquidity, investments, or financial risks like FX and interest rates. Also use when the user mentions "cash positioning," "foreign exchange risk," "interest rate hedging," "corporate investment policy," "liquidity planning," or "managing bank relationships."
three-statement-modeling
When the user wants to build an integrated financial model linking income statement, balance sheet, and cash flow. Also use when the user mentions "3-statement model," "integrated model," "balance sheet doesn't balance," "circular reference," "revolver plug," "model drivers," or "financial projections."