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

Compare versions

FY27GroupActuals to Sep-26Grid basis: Partner cross-sales are a memo lineGBPk
toSwap

FY27 EBITDA: Best-guess forecast to FY27 budget

Full year, May-26 to Apr-27 · green bars are better in FY27 budget, red worse

TotalFavourableAdverse

By line and month

GBPk · difference is FY27 budget minus Best-guess forecast; a positive figure is more income or less cost · shaded months are forecast

LineBest-guess forecastFY27 budgetDifferenceMay-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27
Revenue9,315.39,316.91.6−6.77.85.54.713.919.0−4.019.8−29.1−19.6−2.1−7.7
Revenue: Orbit Logistics120.0350.0230.00.00.035.035.035.035.015.015.015.015.015.015.0
Total revenue9,435.39,666.9231.6−6.77.840.539.748.954.011.034.8−14.1−4.612.97.3
Direct costs−1,244.7−1,154.690.112.410.110.08.55.15.04.96.26.56.87.17.5
Direct costs: Orbit Logistics−15.50.015.50.00.00.00.00.00.02.62.62.62.62.62.6
Total cost of sales−1,260.2−1,154.6105.612.410.110.08.55.15.07.58.89.19.49.710.1
Gross margin8,175.28,512.3337.25.718.050.548.254.058.918.543.6−5.04.822.617.4
Sales staff−2,684.2−2,867.6−183.5−9.7−8.1−18.0−17.2−18.5−16.3−14.1−14.1−21.0−21.0−12.6−12.6
Technology staff−4,390.7−4,515.6−124.8−15.2−12.3−8.3−10.0−7.9−8.17.97.9−19.8−19.8−19.8−19.8
Total staff costs−7,074.9−7,383.2−308.3−24.9−20.4−26.3−27.2−26.5−24.4−6.2−6.2−40.8−40.8−32.4−32.4
Sales & marketing−870.4−818.352.11.5−6.70.0−5.52.510.68.38.38.38.38.38.3
Technology−596.4−580.316.14.33.52.62.53.32.22.01.7−1.0−1.3−1.6−2.0
Office & general−765.2−510.0255.214.4−27.62.3−6.529.036.036.036.035.927.935.935.8
Total other operating costs−2,232.0−1,908.6323.420.2−30.94.9−9.534.848.946.345.943.234.942.542.2
EBITDA−1,131.7−779.5352.31.1−33.329.111.562.383.558.683.3−2.6−1.132.727.2
Exceptionals−67.00.067.01.348.01.31.41.81.91.91.91.91.91.91.9
Interest & depreciation−109.2−108.01.20.00.00.00.00.00.10.20.20.20.20.20.2
Total below EBITDAC−176.2−108.068.21.348.01.31.41.82.02.12.12.12.12.12.1
Result before excluded items−1,307.9−887.5420.42.414.730.412.964.285.460.685.4−0.51.034.829.2
Revenue: Partner cross-sales (memo, not in revenue or EBITDA)92.8492.0399.28.014.020.026.032.032.434.840.838.844.850.856.8
Direct costs: Partner cross-sales (memo, not in revenue or EBITDA)−23.2−58.2−35.0−1.0−1.8−2.4−3.1−3.8−3.0−2.9−3.4−2.4−3.1−3.6−4.3