InFoRex / Corporate treasury / Management reports
From the daily position to forward-looking forecasts
01 / Liquidity forecast
When and where will financing be needed?
Bank statement data, items received from the ERP system and cash flows from treasury transactions can be brought together in a single cash flow forecast.
- Group and group company
- Currency and selectable time buckets
- Planned and actual items
Example / Group-wide cash flow, HUF m
| Item | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Opening cash balance | 600 | 450 | 50 |
| Inflows | 1,100 | 1,000 | 1,300 |
| Outflows | 1,250 | 1,400 | 1,050 |
| Closing cash balance | 450 | 50 | 300 |
DECISION | Raise funding, transfer funds internally or reschedule expenditure?
01 / 04
InFoRex / Corporate treasury / Management reports
What has changed against the plan? How much FX risk remains open?
Cash flow variances and hedging transactions together provide a basis for reviewing the plan and hedging needs.
02 / Plan vs actual report
Example: previous closed month / HUF m
| Cash flow | Plan | Actual | Variance |
|---|---|---|---|
| Inflows | 1,000 | 900 | -100 |
| Outflows | 850 | 880 | +30 |
| Net cash flow | 150 | 20 | -130 |
Net cash inflow is HUF 130m lower. Inflow and outflow variances can be examined separately.
DECISION | How do we respond to an unexpected deterioration in liquidity?
03 / FX position and hedge coverage
Example: next 90 days / EUR thousands
| Position | Amount |
|---|---|
| Expected EUR receipts | 2,000 |
| Expected EUR payments | 1,200 |
| Net EUR receipts | 800 |
| Forward EUR sales | 500 |
| Unhedged EUR receipts | 300 |
Hedging can be assessed in light of the remaining EUR 300,000 and the expected settlement dates.
DECISION | Hedge amount and timing
02 / 04
InFoRex / Corporate treasury / Management reports
Monitor credit facilities: facility amount, utilisation and maturity
Cash flows from the financing portfolio are integrated into the liquidity plan.
04 / Financing, credit facilities and maturities
Example: current facility utilisation / HUF m
| Facility | Amount | Drawn | Undrawn | Maturity |
|---|---|---|---|---|
| Bank A / revolving | 500 | 300 | 200 | Month 2 |
| Bank B / revolving | 300 | 180 | 120 | Month 12 |
| Bank C / working capital | 200 | 120 | 80 | Month 8 |
| Total | 1,000 | 600 | 400 |
HUF 400m undrawn facilities today
HUF 300m repayment in Month 2 on the maturing Bank A facility
DECISION | Renew the maturing facility or seek alternative funding?
03 / 04
InFoRex / Corporate treasury / Management reports
Beyond a single plan: comparable scenarios
Scenario analysis shows the financial consequences of different assumptions. It does not predict the future or make decisions for management.
05 / Comparing scenarios
| Scenario | Month 2 closing balance | Month 3 closing balance | Buffer shortfall* |
|---|---|---|---|
| Base case | 50 | 300 | 100 |
| HUF 200m receipt delayed | -150 | 300 | 300 |
| HUF 250m investment postponed | 300 | 550 | 0 |
| Both changes combined | 100 | 550 | 50 |
* Shortfall against the assumed HUF 150m cash buffer in Month 2. Figures in HUF m.
What changes in the model?
- The HUF 200m receipt shifts from Month 2 to Month 3.
- The HUF 250m investment outflow shifts from Month 2 to Month 4.
- The decision must also take account of the business implications, not just the cash flow.
DECISION | Is postponing the investment acceptable?
Which management question are you trying to answer?
04 / 04
