Write the qualitative factor memo for our CECL allowance
Documented support for qualitative adjustments to the credit loss allowance, tied to evidence, direction, and size.
The prompt
Help me document the qualitative factor (Q-factor) adjustments to our current expected credit loss (CECL) allowance.
Period end: [DATE]
Portfolio segments: [e.g. "CRE non-owner occupied", "C&I", "residential mortgage", "consumer"]
Quantitative model results by segment: [PASTE reserve amounts and loss rates]
Current Q-factor adjustments and prior period values: [PASTE]
Evidence available: [changes in underwriting standards, portfolio concentrations, delinquency and classified trends, collateral values, economic forecast changes, staff experience, external factors]
Reasonable and supportable forecast period and reversion method: [DETAILS]
For each segment, write:
1. Which factors are adjusted and why the quantitative model does not already capture them (avoid double-counting with the economic forecast).
2. The evidence supporting each adjustment, with the data source.
3. The direction and size of each adjustment, and how the size was determined (a stated framework, not judgment alone).
4. Changes from the prior period and the reason.
Also include:
- A summary table: segment, model reserve, Q-factor adjustment (bps and dollars), total reserve, change from prior period.
- A directional consistency check: flag any adjustment that moves opposite to the trend in the evidence.
- Questions an auditor or examiner is likely to ask, with where the answer is documented.
Use only my figures; mark gaps [CONFIRM]. Accounting conclusions should be reviewed by our accounting policy team and external auditors.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Finance & Accounting prompts
What to fill in
- DATE
- PASTE reserve amounts and loss rates
- PASTE
- DETAILS
- CONFIRM
How this prompt is built
This prompt follows the RTF structure (Role, Task, Format). RTF tells the model who to be, what to do and what shape the answer should take. It is the quickest structure that still gives noticeably better results than a bare request.
Related prompts
- Write ALCO commentary on interest rate risk and net interest marginClear asset-liability committee commentary explaining NIM drivers, rate sensitivity, deposit behavior, and recommended actions.
- Write a budget request for a new or expanded public programA budget decision package with the need, costed options, performance measures, and consequences of not funding, ready for budget office review.
- Write a corrective action plan for a government audit findingAn audit finding response and corrective action plan that addresses root cause, names owners and dates, and satisfies federal and state reviewers.
- Write an appeal letter for a denied medical claimA point-by-point appeal that answers the payer's denial reason with policy criteria and documentation, plus a check on whether a corrected claim is faster.