Free Engineering Workbench calculator
Cash forecast variance
Compare forecast and actual cash flow by period to see accuracy and bias.
Finance & unit economicsHow it's worked out
- Accuracy = 1 − Σ|forecast − actual| ÷ Σ|actual|. Bias = Σ(forecast − actual)
- Weighted absolute percentage error across periods
NotePersistent bias matters more than single misses: it means the forecast method, not luck, is off.
Source: AFP treasury cash forecasting guides
Need help acting on this number?
VVnT SeQuor's our services practice helps teams turn this metric into a plan.