Almost every large organisation uses spreadsheets to govern capital investment decisions. Not because they are the right tool for the job, but because they are familiar, accessible, and already in place.
The question is not whether Microsoft Excel and Google Sheets are useful. They indisputably are. But are they fit for purpose for governing the most consequential decisions an organisation makes?
For most CFOs and boards, the honest answer is no.
The Default Process (And Why It Persists)
Ask most large organisations how they prioritise capital investment and the process looks something like this:
- Departments submit Excel scoring sheets.
- Weighted matrices are built and rebuilt each planning cycle.
- Business cases are assembled in PowerPoint.
- Decisions are negotiated through email chains and committee meetings.
These tools and processes are familiar and feel structured. But familiarity is not the same as rigour, and a process that is time-consuming is not automatically a process that is defensible.
The real issue is that Excel and Sheets were never designed for complex, ever-evolving matters like capital governance.
Familiar, Flexible, and Not Built for Governance
Excel and Google Sheets can handle financial modelling, data organisation, scenario analysis, and reporting across countless business functions very well. For much of what finance teams do day to day, they are entirely appropriate.
The problem is not the tools. It is asking those tools to do something they were never designed for: govern the process by which an organisation decides which investments should proceed, which should be deferred, and which represent the greatest value relative to strategy.
Where the Process Breaks Down
The limitations of spreadsheet-based capital governance are well documented. Research into CapEx processes finds that nearly 75% of participants rate inefficiency as a primary challenge, and nearly 40% distrust the quality of information these processes produce. These statistics reflect structural problems that spreadsheet sophistication alone can’t resolve.
Five specific gaps emerge consistently across organisations:
- No structured methodology for evaluating investments against multiple value criteria simultaneously
- No mechanism for detecting or correcting bias in how priorities are weighted
- No audit trail of decision rationale, only the numbers that resulted from it
- No formal process for capturing and reconciling stakeholder perspectives
- No long-horizon forecasting capability beyond the current planning cycle
A weighted matrix can rank options. It cannot tell you whether the ranking is defensible, unbiased, or aligned with what the organisation actually values.
The Question a Spreadsheet Cannot Answer
When a capital decision is challenged by a board, an auditor, or a regulator, a spreadsheet can show the numbers. It cannot show the rationale behind them. It cannot show which stakeholder perspectives were captured, which trade-offs were considered, or what evidence was weighed against what criteria.
That is the question a spreadsheet cannot answer. And it is the question that matters most under scrutiny.
APO replaces each element of the default, spreadsheet-led process with governance focused features. Weighted matrices become scientific value modelling. Static planning becomes long-horizon forecasting. Committee negotiation becomes structured governance with full decision traceability. Negotiated compromise becomes evidence-based prioritisation. PowerPoint justifications become an audit-grade record of every assumption and trade-off.
For organisations accountable to boards, auditors, and regulators, that shift is not cosmetic, it makes managing risk and answering the toughest questions possible.
Frequently Asked Questions
Can Excel be used for capital investment prioritisation? Excel can model financial data and rank options, but it has no structured methodology for multi-criteria value assessment, no bias detection, and no audit trail of decision rationale.
What are the limitations of spreadsheet-based capital planning? Nearly 75% of CapEx participants rate inefficiency as a primary challenge, and nearly 40% distrust the quality of information spreadsheet processes produce. The core limitation is structural: spreadsheets were built for calculation, not governance.
What does APO do that Excel cannot? APO applies scientific value modelling, long-horizon forecasting, and audit-grade decision traceability to capital allocation decisions. These capabilities do not exist in any spreadsheet environment.
Is APO suitable for organisations currently using Excel for capital planning? Yes. APO can both replace and work together with Excel. Our onboarding process is intentionally designed to make it easy for organisations to transition without disrupting existing financial reporting systems.
