National housebuilder
Financial planning & appraisal models
Our client is a £3bn national logistics and housebuilding developer following their acquisition by a private equity investor and FTSE delisting. We created a suite of financial models including consolidation, forecasting and reporting, investment appraisals and capital spend models.
Regional public sector body
Capital expenditure forecasting model
We developed a forecasting model for an £871m programme of infrastructure projects. The scalable model consolidated capex spend forecasts for 100+ projects to produce affordability-tested borrowing requirement profiles. The scenario-planning outputs were central to the organisation’s treasury management strategy.
Transport operator
Predictive demand & revenue model
We derived demand predictions from historic passenger count data, expected future network expansions and demographic trends. The model applies ticket price inflation assumptions to estimate long-term future operating revenues. The outputs informed the decision making for capital investment options.
PE-owned logistics company
Business process automation
We held client workshops to re-design the process for raising new supplier requests, then developed and rolled out a set of tools to automate the production of order forms, reducing the time spent on each order from hours to minutes. We created an interactive tracker dashboard for users to monitor the approval status of each requisition.
Care provider group
Financial reporting & consolidation
We designed and developed a suite of Excel-based financial reporting models for the business during a period of significant expansion through acquisitions. The models report at board level for each subsidiary and provide consolidated reporting at group level, with visual dashboards to clearly communicate the key information.
Industrial property developer
Commercial cashflow modelling
Our client required better reporting of financial positions during the construction of commercial developments. We designed and developed a suite of cashflow modelling solutions used to budget and report cost-to-complete financials. The tools are used by finance and non-finance staff across the business.
National housebuilder
Cashflow forecasting models
We designed and developed a highly scalable suite of property cashflow models that integrated Excel, SQL and PowerQuery for financial forecasting. This included granular site-level cashflows, KPI reporting, and dashboards for operational, management and financial reporting.
National tyre distributor
Restructuring options model
We developed a turnaround implementation model for a 300-site national tyre distributor. The model forecasts the site-level incremental P&L impact of an array of restructuring initiatives across multiple subsets of sites.