Opagio Intangibles vs Manual Excel Valuation
Opagio vs spreadsheet-based intangible valuation. Comparing platform automation, consistency, and collaboration with traditional Excel models.
Introduction
The vast majority of intangible asset valuations today are still performed in Microsoft Excel. Bespoke spreadsheets, built by individual analysts, containing formulas refined over years of practice. For a profession rooted in financial modelling, Excel is the hammer and every valuation looks like a nail.
The approach works — until it does not. Version control breaks down when multiple stakeholders edit the same file. Formula errors propagate silently. Each analyst's model is structured differently, making peer review difficult and knowledge transfer risky. When the senior analyst leaves, their models become archaeological artefacts requiring careful excavation.
The Opagio Intangibles was built to address these exact problems — not by replacing the valuation expertise, but by providing a structured, collaborative, and repeatable environment for it. This comparison examines when each approach makes sense and where the trade-offs lie.
The Case for Excel
Excel remains the default valuation tool for good reasons. It provides unmatched flexibility for financial modelling. Any formula, any structure, any assumption can be modelled. The learning curve is well-understood, the tool is universally available, and the installed base of existing models is enormous.
Excel strengths
| Strength | Detail |
|---|---|
| Flexibility | Any model structure, any level of complexity |
| Familiarity | Every finance professional knows Excel |
| Transparency | Every formula is visible and auditable |
| Cost | No additional software licensing (assuming Microsoft 365 is already in use) |
| Customisation | Fully bespoke models tailored to specific transactions |
Excel limitations for recurring valuation
The problems emerge with scale, repetition, and collaboration:
- Version control: "Valuation_v3_final_FINAL_revised.xlsx" is a symptom, not a joke
- Formula errors: Errors in complex models are difficult to detect and can propagate across linked sheets
- Consistency: Every analyst builds models differently — comparability across the team or portfolio is poor
- Collaboration: Real-time multi-user editing in Excel is limited; most teams resort to file sharing
- Audit trail: Tracking who changed what, when, and why requires external documentation discipline
- Knowledge risk: When the model builder leaves, institutional knowledge goes with them
A 2023 European Spreadsheet Risks Interest Group study found that 94% of operational spreadsheets contained errors, with a median error rate of 1-5% of all cells. In financial models with hundreds of formula cells, this translates to multiple errors per model — some of which may materially affect the valuation conclusion.
The Case for a Platform Approach
A purpose-built valuation platform like Opagio addresses the structural limitations of Excel while preserving the analytical rigour:
Platform strengths
| Strength | Detail |
|---|---|
| Consistency | Standardised methodology applied uniformly across all valuations |
| Collaboration | Multi-user access with role-based permissions and org-level views |
| Audit trail | Every change automatically logged with timestamp and user |
| Portfolio view | Dashboard showing all assets across entities with benchmarking |
| Speed | Guided workflows reduce setup time from hours to minutes |
| Knowledge retention | Methodology and data persist in the platform regardless of team changes |
Platform limitations
- Less flexible for highly bespoke, one-off analysis
- Learning curve for teams accustomed to Excel-only workflows
- Subscription cost versus Excel's perceived "free" status
- Methodology constraints — the platform implements specific approaches that may not cover every edge case
The choice is not binary. Most effective teams use a platform for structured, recurring valuation work and reserve Excel for bespoke analysis that falls outside standard methodologies. The platform handles 80% of valuations consistently; Excel handles the remaining 20% that require full modelling flexibility.
Side-by-Side Comparison
Detailed feature comparison
| Capability | Opagio Intangibles | Manual Excel |
|---|---|---|
| Setup time | Minutes (onboarding wizard) | Hours to days (model building) |
| Methodology consistency | Guaranteed — same approach every time | Variable — depends on analyst |
| Multi-entity portfolio | Built-in dashboard and aggregation | Separate files, manual consolidation |
| Scenario modelling | Structured scenarios with comparison views | Full flexibility, manual setup |
| Audit trail | Automatic timestamped change log | Manual track-changes discipline |
| Collaboration | Real-time multi-user with role permissions | File sharing with version conflicts |
| Reporting output | Professional reports generated automatically | Manual report assembly from model outputs |
| Benchmarking | Built-in industry and peer benchmarks | Manual research and input |
| Cost | Platform subscription | Analyst time (significant per valuation) |
| Scalability | Linear — handles hundreds of entities | Each entity requires separate model work |
Choose Opagio When
- Recurring valuations (quarterly, annual)
- Portfolio of multiple entities or asset classes
- Team-based workflow needing consistency
- Board or investor reporting requirements
- Building internal intangible asset visibility
Choose Excel When
- One-off, highly bespoke analysis
- Academic research needing full formula transparency
- Prototyping a new valuation approach
- Platform subscription not justified by volume
- Complex scenario modelling beyond standard methods
The Cost Equation
Excel's hidden costs
Excel is "free" only if you ignore the labour cost. A senior valuation analyst earning £90,000 per year (fully loaded with benefits, office space, and management overhead) costs approximately £50 per hour. Building a bespoke valuation model takes 8-20 hours depending on complexity. Maintaining, updating, and documenting it adds another 4-8 hours per quarter.
| Cost Component | Per Valuation (Excel) | Per Valuation (Platform) |
|---|---|---|
| Initial model build | £400-£1,000 | £0 (pre-built) |
| Data input | £150-£300 | £50-£100 |
| Quality review | £200-£400 | £50-£100 (automated checks) |
| Quarterly update | £200-£400 | £50-£100 |
| Annual cost (10 entities, quarterly) | £38,000-£84,000 | Platform subscription + £4,000-£8,000 |
A mid-market PE fund with 12 portfolio companies, each valued quarterly, will spend £46,000-£100,000 annually in analyst time on Excel-based valuations. A platform subscription at a fraction of that cost frees analyst time for interpretation and strategic analysis rather than model maintenance.
Practical Example: PE Fund Portfolio
A PE fund manages 15 portfolio companies across five sectors. Each company requires quarterly intangible asset tracking and annual formal valuation.
Excel approach
- 15 separate Excel models, each maintained by a different analyst
- Quarterly updates require 3-4 hours per model (45-60 hours total per quarter)
- Annual consolidation for fund reporting takes 2 weeks
- When an analyst leaves, the replacement spends 2-3 weeks understanding the models
- No consistent benchmarking across the portfolio
Platform approach
- All 15 companies on a single platform with standardised inputs
- Quarterly updates require 30-45 minutes per company (8-11 hours total per quarter)
- Fund-level dashboard shows portfolio benchmarks in real time
- New team members are productive within days, not weeks
- Cross-portfolio analysis (which companies invest most in customer capital? R&D? Brand?) is immediate
Decision Framework
1. Assess your valuation frequency
If you value intangible assets more than twice a year, the consistency and speed benefits of a platform compound quickly. One-off valuations favour Excel's flexibility.
2. Count your entities
Single entity? Excel is probably fine. Multiple entities requiring portfolio-level views? A platform provides aggregation and benchmarking that would take weeks to build in Excel.
3. Evaluate your team
Is valuation expertise concentrated in one person? A platform reduces knowledge risk. Is the team large and distributed? A platform provides consistency across contributors.
4. Consider your audience
Board and investor reports benefit from the professional, consistent output a platform provides. Internal analysis for your own decision-making may be fine in Excel.
Conclusion
Excel remains an indispensable tool for bespoke financial modelling and will not be replaced for highly customised, one-off analysis. For recurring intangible asset valuation, portfolio tracking, and collaborative reporting, a purpose-built platform eliminates the version control, consistency, and scalability problems that plague spreadsheet-based approaches.
The most effective teams use both — the platform for the 80% of work that benefits from structure and consistency, and Excel for the 20% that requires full modelling flexibility. To explore how Opagio handles this, see our valuator tool and calculator for hands-on experience.
The Bottom Line
Excel is free until you count the analyst hours, the formula errors, and the knowledge risk. A platform is an investment that pays for itself through consistency, speed, and scalability. For most organisations, the question is not whether to adopt a platform but when — and the answer is usually "before the next portfolio review."
Related Glossary Terms
Learn More
Ready to Value Your Intangible Assets?
Use Opagio's valuation tools to apply these methods to your own business.