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: FY27 budget to Best-guess forecast

Full year, May-26 to Apr-27 · green bars are better in Best-guess forecast, red worse

TotalFavourableAdverse

By line and month

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

LineFY27 budgetBest-guess forecastDifferenceMay-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27
Revenue9,316.99,315.3−1.66.7−7.8−5.5−4.7−13.9−19.04.0−19.829.119.62.17.7
Revenue: Orbit Logistics350.0120.0−230.00.00.0−35.0−35.0−35.0−35.0−15.0−15.0−15.0−15.0−15.0−15.0
Total revenue9,666.99,435.3−231.66.7−7.8−40.5−39.7−48.9−54.0−11.0−34.814.14.6−12.9−7.3
Direct costs−1,154.6−1,244.7−90.1−12.4−10.1−10.0−8.5−5.1−5.0−4.9−6.2−6.5−6.8−7.1−7.5
Direct costs: Orbit Logistics0.0−15.5−15.50.00.00.00.00.00.0−2.6−2.6−2.6−2.6−2.6−2.6
Total cost of sales−1,154.6−1,260.2−105.6−12.4−10.1−10.0−8.5−5.1−5.0−7.5−8.8−9.1−9.4−9.7−10.1
Gross margin8,512.38,175.2−337.2−5.7−18.0−50.5−48.2−54.0−58.9−18.5−43.65.0−4.8−22.6−17.4
Sales staff−2,867.6−2,684.2183.59.78.118.017.218.516.314.114.121.021.012.612.6
Technology staff−4,515.6−4,390.7124.815.212.38.310.07.98.1−7.9−7.919.819.819.819.8
Total staff costs−7,383.2−7,074.9308.324.920.426.327.226.524.46.26.240.840.832.432.4
Sales & marketing−818.3−870.4−52.1−1.56.70.05.5−2.5−10.6−8.3−8.3−8.3−8.3−8.3−8.3
Technology−580.3−596.4−16.1−4.3−3.5−2.6−2.5−3.3−2.2−2.0−1.71.01.31.62.0
Office & general−510.0−765.2−255.2−14.427.6−2.36.5−29.0−36.0−36.0−36.0−35.9−27.9−35.9−35.8
Total other operating costs−1,908.6−2,232.0−323.4−20.230.9−4.99.5−34.8−48.9−46.3−45.9−43.2−34.9−42.5−42.2
EBITDA−779.5−1,131.7−352.3−1.133.3−29.1−11.5−62.3−83.5−58.6−83.32.61.1−32.7−27.2
Exceptionals0.0−67.0−67.0−1.3−48.0−1.3−1.4−1.8−1.9−1.9−1.9−1.9−1.9−1.9−1.9
Interest & depreciation−108.0−109.2−1.20.00.00.00.00.0−0.1−0.2−0.2−0.2−0.2−0.2−0.2
Total below EBITDAC−108.0−176.2−68.2−1.3−48.0−1.3−1.4−1.8−2.0−2.1−2.1−2.1−2.1−2.1−2.1
Result before excluded items−887.5−1,307.9−420.4−2.4−14.7−30.4−12.9−64.2−85.4−60.6−85.40.5−1.0−34.8−29.2
Revenue: Partner cross-sales (memo, not in revenue or EBITDA)492.092.8−399.2−8.0−14.0−20.0−26.0−32.0−32.4−34.8−40.8−38.8−44.8−50.8−56.8
Direct costs: Partner cross-sales (memo, not in revenue or EBITDA)−58.2−23.235.01.01.82.43.13.83.02.93.42.43.13.64.3