Demo workspace · synthetic data · Foresail, FP&A that sets itself up

Direct Debit forecast

FY27: actuals to Sep-26, best guess after2 markets, as proposedAgainst the KPI budget£k

← KPIs

Direct Debit is value withdrawn in a market × its DD %. Click any figure to see how it is made.

Direct Debit by market

Actuals, then the best guess (shaded) · £k · the year against the budget's value withdrawn at the same DD %

MarketMay-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27FY27BudgetVariance
NWES · 11.8%791.2755.3796.5823.4787.5838.5860.5888.4902.9917.6932.3947.210,241.110,111.9+129.2
NWUK · 57.4%10,667.510,018.010,146.510,508.510,631.811,080.811,709.211,935.211,759.111,994.212,234.212,478.8135,163.7133,302.3+1,861.4
Total11,458.610,773.210,943.011,331.811,419.311,919.312,569.712,823.612,662.012,911.813,166.513,425.9145,404.8143,414.2+1,990.6
Budget10,799.210,800.311,009.811,540.111,521.311,577.212,272.212,092.012,776.212,519.613,294.813,211.4143,414.2

Markets shouldn't overlap: a market for the group and one for an entity in it would count that entity twice in the total.

NWES

DD % 11.8% · actuals, then the best guess (shaded) · £k

May-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27FY27BudgetVariance
Value withdrawn6,704.76,400.56,750.46,977.66,673.67,105.77,292.17,528.47,652.07,776.27,901.18,026.786,789.085,693.7+1,095.3
Direct Debit791.2755.3796.5823.4787.5838.5860.5888.4902.9917.6932.3947.210,241.110,111.9+129.2
Budget value withdrawn6,438.46,380.16,526.56,834.46,939.46,990.57,202.57,507.17,329.27,927.37,575.58,042.985,693.7
Budget Direct Debit759.7752.9770.1806.5818.8824.9849.9885.8864.9935.4893.9949.110,111.9

NWUK

DD % 57.4% · actuals, then the best guess (shaded) · £k

May-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27FY27BudgetVariance
Value withdrawn18,584.417,452.917,676.818,307.418,522.319,304.620,399.420,793.120,486.220,895.921,313.921,740.1235,476.8232,234.0+3,242.8
Direct Debit10,667.510,018.010,146.510,508.510,631.811,080.811,709.211,935.211,759.111,994.212,234.212,478.8135,163.7133,302.3+1,861.4
Budget value withdrawn17,490.417,504.317,839.218,699.718,645.418,732.219,899.519,523.020,751.420,181.421,604.321,363.0232,234.0
Budget Direct Debit10,039.510,047.510,239.710,733.610,702.510,752.311,422.311,206.211,911.311,584.112,400.912,262.4133,302.3

Markets and DD %

Proposed from the KPIs loaded: one market per entity with value withdrawn, at 11.8% for euro markets and 57.4% for sterling ones. Finance can change them; not in the demo.

MarketEntitySegmentDD %
NWESNWESAll segments11.8%
NWUKNWUKAll segments57.4%