NII and Profit Forecasting Agent
Forecasts net interest income, costs, cost of risk and profit.
- Industry
- Banking
- Department
- Finance
- Team
- Planning and Compliance
- Kind
- Decision-maker
- Approver
- CFO
- Code
- FIN-10
It forecasts the bank's net interest income, fee income, operating costs, cost of risk and profit for the coming quarters from the balance sheet, repricing and the rate curve, loan and deposit growth, and the ECL outlook. It tests the scenarios asked for, such as a 100 basis point rate cut, slower deposit growth or a rise in defaults, and shows the effect on net interest margin.
How it works
7 steps, and a person signs off before step 7.
- 01Looks it up
Finds the record the request is about in the risk data warehouse: the balance sheet by product, repricing profile, rate curves, ECL scenarios and income and cost history..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Forecasts, when it decides
Projects what each option will cost or return before it recommends one.
- 05Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 06Asks a person
Hands the work to CFO with its reasoning before anything goes out.
- 07Acts
Once approved, it acts in the risk data warehouse: it saves the forecast version and scenarios. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The forecasting model: balance-sheet projection, repricing gaps and deposit betas, rate scenarios, fee drivers, cost behaviour, the ECL forward-looking scenarios, and the model risk management rules for the forecasting model.
Reads from
the risk data warehouse: the balance sheet by product, repricing profile, rate curves, ECL scenarios and income and cost history.
Acts in
the risk data warehouse: it saves the forecast version and scenarios.
Hands back
An object with quarters (a list with quarter, net_interest_income_usd, fee_income_usd, costs_usd, cost_of_risk_usd, profit_before_tax_usd and nim_percent), scenarios (a list with name and the same lines), drivers and assumptions.
Asks a person when
The forecast would become the official version, it is for the board or a regulatory stress test, or base-case net interest margin moves more than 10 basis points.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Deposit beta (%) | 40 | The share of a rate change passed to deposit rates. |
| History used (months) | 36 | Data used to fit drivers. |
| Downside haircut on growth (%) | 20 | Applied to the downside scenario. |
| Net interest margin move that needs review (bps) | 10 | A larger move in base case needs the approver. |
| Publish without review | Off | When off, the official forecast needs approval. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Project net interest income from the balance sheet and repricing, passing 40 percent of rate changes to deposits unless the scenario says otherwise.
- Fit drivers on 36 months of history and haircut growth by 20 percent in the downside.
- Cost of risk follows the ECL scenarios; never set it independently of Risk.
- Flag a base-case net interest margin move above 10 basis points.
- When off is false, the official forecast needs the CFO.
See the NII and Profit Forecasting Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.