You are supporting the quarterly forecast process for a mid-sized asset servicing and treasury services business. The CFO asks how familiar you are with financial modeling techniques, but wants a concrete answer tied to an actual planning decision rather than a generic list. You need to compare a simple run-rate forecast with a driver-based forecast for next quarter fee revenue and show which method is more reliable. Assume no acquisitions, no FX impact, and that revenue is recognized under a consistent accounting policy across periods.
| Metric | Q1 | Q2 | Q3 | Q4 Forecast Input |
|---|---|---|---|---|
| Assets under custody/admin ($B) | 1,820 | 1,860 | 1,910 | 1,950 |
| Fee yield (bps) | 4.8 | 4.7 | 4.5 | 4.4 |
| Actual fee revenue ($M) | 218.4 | 218.6 | 214.9 | — |
| Simple run-rate forecast revenue ($M) | — | — | — | 214.9 |
| Planned expense to build driver-based model ($M) | — | — | — | 0.6 |
How would you explain the financial modeling techniques you are familiar with using this example, and which forecasting approach would you recommend for Q4 based on the numbers? Quantify the forecast output, error risk, and whether the added modeling effort is justified.