AGENT SKILL

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

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

  1. 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)?
  2. 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).
  3. 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

  1. Segmentation (Grouping similar assets - e.g., by geography or product).
  2. Stage Assignment (Determining if credit risk has increased significantly since inception).
  3. Parameter Estimation (Calculating PD, LGD, EAD).
  4. Scenario Weighting (Applying macroeconomic forecasts).
  5. 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.py to self-test; import the functions for actual computations.

References


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

GAJETOso
GAJETOso/financeskills

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."

★ 47
GAJETOso
GAJETOso/financeskills

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."

★ 47
GAJETOso
GAJETOso/financeskills

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."

★ 47
GAJETOso
GAJETOso/financeskills

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."

★ 47
GAJETOso
GAJETOso/financeskills

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."

★ 47
GAJETOso
GAJETOso/financeskills

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."

★ 47