Innopharma Education
Dublin-based education technology group specialising in pharma, science and technology programmes · innopharmaeducation.com
The Challenge
A Dublin-based business services group with three distinct revenue streams had a financial planning problem that was holding the executive team back. Their five-year financial model — a critical input for board meetings, investor conversations, and strategic decisions — existed as a patchwork of 14 linked Excel spreadsheets built up over years by different people with different approaches.
Whenever the CFO needed to refresh the forecast or update a key assumption — a change in headcount, a revision to revenue growth, a shift in capital expenditure plans — the finance team had to manually cascade the change through every linked file. A full update took three working days, required two senior finance staff, and was so error-prone that outputs routinely had to be rechecked from scratch before they could be shared with the board.
The deeper problem was strategic: because running a new scenario was so costly in time and effort, the executive team had effectively stopped doing it. Board presentations featured a single set of numbers rather than a range of credible outcomes. Decisions were being made without a clear picture of the downside risks or the upside potential.
The trigger: After an investor meeting where management couldn't answer a straightforward "what happens to cash flow if revenue growth is 5% instead of 8%?" question in real time, the CFO reached out to Data Sensum for a free productivity audit.
The Audit Findings
The free productivity audit mapped every step of the existing forecasting process. The findings were clear:
- 14 separate files were linked in a fragile daisy-chain — breaking one link corrupted the entire model
- No single source of truth for input assumptions — the same figure appeared in multiple places and was often inconsistent
- Scenario modelling was non-existent in practice; the model had no built-in mechanism for switching between scenarios
- Cash flow, P&L and balance sheet outputs were calculated in separate files with no automated reconciliation between them
- Historical actuals had to be entered manually each month, a process that took half a day
- Charts for board packs were rebuilt from scratch each quarter — no live connection to the model
The Solution
Data Sensum redesigned the entire forecasting architecture as a single, unified Excel workbook — structured around a clean separation of inputs, calculations, and outputs — with Power Query handling all data ingestion and refresh.
A Single Source of Truth for Over 100 Variables
The model is driven by a single structured assumptions sheet containing over 100 input variables — spanning product and service pricing, direct and indirect cost factors, sales volumes by channel and product line, headcount trajectory, capex schedule, and working capital ratios. Every calculation across the P&L, cash flow statement, and balance sheet flows from this one place. Changing any variable once updates every output instantly, with no cascading edits across files.
Scenario Engine with Three Simultaneous Views
The model runs three named scenarios in parallel: Base Case, Optimistic, and Conservative. Each scenario has its own column of assumptions that the executive team can adjust independently. A single dropdown on the dashboard selects which scenario drives the visual outputs — but all three are always calculated simultaneously, so comparing outcomes side-by-side takes a single click.
Additional ad-hoc scenarios can be modelled by adjusting any individual assumption in real time. A revenue growth sensitivity table recalculates automatically across a range of values, giving executives an instant view of how the key variables drive profitability and cash — without running the model separately for each input.
Power Query for Automated Actuals Ingestion
The previous process required manual copy-paste of monthly actuals from the accounting system export into each of the 14 files. Power Query replaced this entirely. The finance team now drops the monthly export into a designated folder; the model refreshes in one click, automatically cleaning, mapping, and loading the actuals into the correct positions with variance analysis against forecast calculated immediately.
Fully Integrated P&L, Cash Flow and Balance Sheet
For the first time, the group's five-year P&L, cash flow statement and balance sheet were built from a single shared calculation layer — fully reconciled and consistent across all three statements. Any change to a pricing assumption, cost factor or sales volume flows through automatically to every financial statement simultaneously. The model produces monthly granularity for years one and two, and quarterly for years three through five — matching the level of confidence in the underlying assumptions. A live cash runway indicator flags automatically when any scenario produces a cash low-point that requires attention.
Board-Ready Output Pack
All charts — revenue bridge, EBITDA waterfall, cash flow projection, headcount vs revenue efficiency — are connected directly to the model outputs and update automatically when assumptions change. The board pack, which previously required a half-day of manual chart rebuilding, is now ready the moment the model refresh is complete.
Tools used: Microsoft Excel (Microsoft 365), Power Query (M language), structured table references, named ranges, dynamic array formulas. No macros, no VBA — the model is fully transparent and maintainable by the finance team without specialist support.
The Results
The impact was felt immediately at the first board meeting after go-live, when the executive team fielded three real-time scenario questions from the board — and answered all three live, within the meeting, by adjusting assumptions on screen and showing the updated five-year projection.
- Full forecast refresh reduced from 3 working days to under 30 minutes — a 93% time saving
- Any new scenario can be modelled in under 2 minutes by any member of the executive team, without finance team involvement
- Monthly actuals ingestion reduced from half a day to a single click
- All three financial statements — P&L, cash flow and balance sheet — update simultaneously from a single variable change
- Zero errors in the first three quarters of use — compared to at least one material correction required per quarter previously
- The executive team now runs an average of 6 scenario variations per board meeting, versus 1 previously
Why Excel — Not a Dedicated FP&A Tool?
Purpose-built FP&A platforms can cost €20,000–€80,000 per year in licences alone, require significant implementation time, and demand ongoing vendor support. For a business of this size, that investment wasn't justified — and the flexibility of a well-engineered Excel model actually exceeded what the off-the-shelf alternatives could offer for their specific structure.
The key is the engineering. The model Data Sensum built isn't a sprawling spreadsheet — it's a disciplined, documented financial architecture that happens to run in Excel. Any competent finance professional can maintain it, extend it, and trust it. That's the outcome a good Excel engagement should deliver.