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 budgetGroup (simple sum of entities)Grid 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
Revenue2,148.32,155.0−6.62,243.92,281.5−37.62,407.62,394.3+13.32,515.62,486.2+29.49,315.39,316.9−1.6
Revenue: Orbit Logistics0.035.0−35.00.0105.0−105.060.0105.0−45.060.0105.0−45.0120.0350.0−230.0
Total revenue2,148.32,190.0−41.62,243.92,386.5−142.62,467.62,499.3−31.72,575.62,591.2−15.69,435.39,666.9−231.6
Revenue excl. Orbit Logistics2,148.32,155.0−6.62,243.92,281.5−37.62,407.62,394.3+13.32,515.62,486.2+29.49,315.39,316.9−1.6
Cost of sales
Direct costs−306.2−273.6−32.6−302.3−283.8−18.5−311.1−293.6−17.6−325.1−303.6−21.4−1,244.7−1,154.6−90.1
Direct costs: Orbit Logistics0.00.00.00.00.00.0−7.80.0−7.8−7.80.0−7.8−15.50.0−15.5
Total cost of sales−306.2−273.6−32.6−302.3−283.8−18.5−318.9−293.6−25.3−332.8−303.6−29.2−1,260.2−1,154.6−105.6
Gross margin1,842.11,916.4−74.21,941.62,102.7−161.12,148.72,205.7−57.02,242.82,287.6−44.88,175.28,512.3−337.2
Staff costs
Sales staff−659.4−695.2+35.8−668.4−720.5+52.1−678.2−727.4+49.2−678.2−724.5+46.3−2,684.2−2,867.6+183.5
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,724.9−1,796.4+71.5−1,743.7−1,821.7+78.0−1,803.2−1,856.3+53.1−1,803.2−1,908.8+105.6−7,074.9−7,383.2+308.3
Other operating costs
Sales & marketing−194.8−200.1+5.3−207.6−200.1−7.6−234.0−209.1−24.9−234.0−209.1−24.9−870.4−818.3−52.1
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−114.1−125.0+10.9−183.9−125.3−58.6−233.6−125.7−107.9−233.6−134.0−99.6−765.2−510.0−255.2
Total other operating costs−458.1−463.9+5.8−540.9−466.8−74.2−616.5−481.0−135.4−616.5−496.9−119.6−2,232.0−1,908.6−323.4
EBITDA−340.9−344.0+3.1−343.0−185.7−157.2−271.0−131.7−139.3−176.9−118.1−58.8−1,131.7−779.5−352.3
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−418.5−371.0−47.5−375.2−212.7−162.5−304.2−158.7−145.5−210.1−145.1−65.0−1,307.9−887.5−420.4
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.6+8.7−12.9−23.9+11.0−23.2−58.2+35.0

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

Commentary · May-26

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

No comments for May-26 yet.