FP&A workbench
The question
What budget can this bank adopt from its latest quarter, and how does the adopted budget compare with each new quarter?
The answer in brief
A quarterly budget for this bank that starts from its latest quarter: actual quarterly results, then eight plan quarters, with an adopted budget followed against each new quarter.
How the page builds the answer
- Actual quarterly results, then budget against actual once a budget is adopted
- The plan builder: eight plan quarters from the inputs you set
- The budget grid, quarter by quarter
- The plan against the peer group
- Plan odds across reruns of the plan
How to use it
- Read the actual quarterly results. Each quarter is split out of the year-to-date figures.
- Pick a growth pace and a yield and cost starting point, then drag any input: growth, each yield and cost, fee income, each expense line, provision, tax and dividends.
- Compare plan years 1 and 2 with the last four quarters in the table, and pin a scenario to keep it on the bar while you try another.
- Save the inputs as a plan. Plans are shared with everyone at the bank who has Bank Desk access.
- Set the plan beside the bank's peer group, and take the peer median for any input with one click.
- Read the plan odds: the range of results across reruns of the plan, and the share of runs that reach the plan, the peer medians and 5% leverage.
- Adopt a plan as the budget. As each new quarter arrives, budget against actual shows the difference by line, and the rolling forecast carries the budget's inputs over the quarters still to come. The adopted budget also appears in the board packet.
- Download the quarters or the budget comparison as CSV, or print the workbench to PDF.
Then
Adopt the plan as the budget and follow budget against actual in each new quarter's board packet.
Access
Needs a free account. Signed in, the full view is open on the sample bank, First Fidelity Bank; other banks show a preview, and their full view is part of Bank Desk.
What it does not do
The figures are quarterly and consolidated, so the plan has no monthly view and no branch, product or cost-center detail. Yields and costs are averages over the bank's balances, not instrument by instrument.
What Save keeps
Plans and adopted budgets, shared across the bank; every plan input in your workspace.
Related