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

Budget vs actual

GroupNWESNWHLNWUK
YTD & full yearMonthlyBy quarterBy entityLast 12 monthsAccountsReview
⤓ Export (.xlsx)
FY27Actuals to May-26Budget: FY27 budgetNWUK · entity budgetGrid basis: Partner cross-sales are a memo lineGBP thousandsXero

P&L by quarter · FY27

Latest forecast: actuals for closed months and the best guess after them, as on Forecast & scenarios · variance is latest less budget, positive is favourable · click a figure in a closed quarter to see its accounts

GBPkQ1 · May-26 to Jul-26
Actual
Q2 · Aug-26 to Oct-26
2 of 3 months actual
Q3 · Nov-26 to Jan-27
Forecast
Q4 · Feb-27 to Apr-27
Forecast
Full year
LatestBudgetVarLatestBudgetVarLatestBudgetVarLatestBudgetVarLatestBudgetVar
Revenue
Revenue1,679.01,706.2−27.21,758.81,805.1−46.41,881.51,890.4−8.91,955.31,960.0−4.77,274.67,361.8−87.2
Revenue: Orbit Logistics0.035.0−35.00.0105.0−105.00.0105.0−105.00.0105.0−105.00.0350.0−350.0
Total revenue1,679.01,741.2−62.21,758.81,910.1−151.41,881.51,995.4−113.91,955.32,065.0−109.77,274.67,711.8−437.2
Revenue excl. Orbit Logistics1,679.01,706.2−27.21,758.81,805.1−46.41,881.51,890.4−8.91,955.31,960.0−4.77,274.67,361.8−87.2
Cost of sales
Direct costs−244.5−218.2−26.3−239.7−226.7−12.9−244.6−234.8−9.8−254.2−243.1−11.1−982.9−922.8−60.1
Direct costs: Orbit Logistics0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Total cost of sales−244.5−218.2−26.3−239.7−226.7−12.9−244.6−234.8−9.8−254.2−243.1−11.1−982.9−922.8−60.1
Gross margin1,434.51,523.0−88.51,519.11,683.4−164.31,637.01,760.6−123.61,701.11,821.9−120.86,291.76,789.0−497.2
Staff costs
Sales staff−507.2−518.8+11.6−515.9−544.0+28.1−523.7−549.2+25.6−523.7−559.6+36.0−2,070.4−2,171.7+101.3
Technology staff−1,065.5−1,101.2+35.7−1,075.3−1,101.2+25.9−1,125.0−1,128.9+3.9−1,125.0−1,184.3+59.3−4,390.7−4,515.6+124.8
Total staff costs−1,572.6−1,620.0+47.3−1,591.2−1,645.2+54.1−1,648.7−1,678.1+29.5−1,648.7−1,743.9+95.3−6,461.1−6,687.2+226.1
Other operating costs
Sales & marketing−162.4−171.0+8.6−188.5−171.0−17.5−211.6−180.0−31.6−211.6−180.0−31.6−774.0−702.0−72.0
Technology−149.3−138.8−10.4−149.4−141.3−8.0−148.9−146.3−2.6−148.9−153.8+4.9−596.4−580.3−16.1
Office & general−96.0−106.1+10.1−138.0−106.4−31.6−132.0−106.8−25.2−132.0−107.1−24.9−498.0−426.4−71.6
Total other operating costs−407.7−416.0+8.3−475.8−418.8−57.0−492.5−433.1−59.4−492.5−440.9−51.6−1,868.5−1,708.7−159.7
EBITDA−545.8−512.9−32.9−547.9−380.6−167.3−504.2−350.6−153.6−440.0−362.9−77.1−2,037.9−1,607.0−430.8
Below EBITDAC
Exceptionals−50.60.0−50.6−5.10.0−5.1−5.60.0−5.6−5.60.0−5.6−67.00.0−67.0
Interest & depreciation−27.0−27.00.0−27.1−27.0−0.1−27.5−27.0−0.5−27.5−27.0−0.5−109.2−108.0−1.2
Total below ebitdac−77.6−27.0−50.6−32.2−27.0−5.2−33.2−27.0−6.2−33.2−27.0−6.2−176.2−108.0−68.2
Result before excluded items−623.4−539.9−83.5−580.1−407.6−172.5−537.4−377.6−159.8−473.2−389.9−83.3−2,214.0−1,715.0−499.0
Memo: Partner cross-sales, not in revenue or EBITDA
Revenue: Partner cross-sales0.042.0−42.05.696.0−90.435.6150.0−114.451.6204.0−152.492.8492.0−399.2
Direct costs: Partner cross-sales0.0−5.2+5.2−1.4−11.4+10.0−8.9−17.7+8.8−12.9−24.0+11.1−23.2−58.3+35.1

Shaded figures include forecast months. Quarters follow the fiscal year from May-26.

Commentary · May-26

What explains the lines for May-26, NWUK. Lines with a comment show ✱ in the table above.

No comments for May-26 yet.