From Calculation to Board Pack: How the Intangible Asset Valuator Generates Audit-Ready Reports

A valuation is only useful if someone reads it. The calculator that produces the number is the start of the workflow, not the end. By the time an intangible asset valuation reaches its real audience — a board reviewing a capital-allocation decision, a lender deciding whether to advance against IP, an acquirer running diligence — the number itself is the easy part. The hard part is producing a document that lets each of those audiences interrogate the number, trust the methodology, and use it for the decision in front of them. Most spreadsheet-based valuations fail that test. They produce a fair value figure, but no defensible trail from inputs to output, no consistent treatment across asset classes, and no format that survives transfer between the valuer who built it and the partner who has to sign off.

The reporting layer inside the Opagio Intangible Asset Valuator was built to close that gap. Every valuation produced in the tool — whether a single-asset Relief from Royalty run or a full portfolio across The Opagio 12 — generates two outputs by default: a structured Excel workbook for the valuer and any diligence team, and a branded PDF report for the board, lender, or buyer on the other side of the table. Both are produced from the same underlying calculation, with the same audit trail, and both are designed to be reviewed without the original spreadsheet ever leaving the platform.

This guide walks through what the report layer produces, who each output is for, and what the format means for the engagement.

Why Reports Are the Real Deliverable

A valuation that lives only inside the platform is a working file, not a deliverable. The board paper that sits in front of an Audit Committee, the data room exhibit that an acquirer's lawyers comb through, the lender pitch pack that goes to a credit committee — those are documents. They have to print correctly, hand over cleanly, and stand up to questions weeks or months after the original calculation was run.

Three audiences shape the design of the report layer, and each needs a different cut of the same valuation:

The reporting layer in the Valuator is the artefact that lets the same calculation serve all three. The number on the cover page is the same number an acquirer's diligence team will trace back through the audit trail. Nothing is recomputed in the handover.

What the Excel Workbook Contains

The default Excel export is the working artefact for the valuer and any technical reviewer. It is structured the way a Big Four PPA workbook is structured — a separate sheet for each major component, named ranges throughout, no hard-coded values where a formula or a named input would do the job.

A typical single-method workbook contains:

For a multi-method or portfolio valuation, the workbook expands. Each method gets its own Calculation and Assumptions sheet, and a Portfolio Rollup sheet ties them together — feeding aggregated fair value, asset-class concentration, and contributory-asset reconciliation into a single view. The methodology audit checks that contributory asset charges are consistent across MPEEM and Replacement Cost, that the same discount rate is used wherever a DCF is computed, and that no asset is double-counted between methods.

The workbook is downloadable in .xlsx format with all formulas live. A reviewer can change an assumption, watch the fair value update, and see the sensitivity table recalculate. The audit trail does not break — every formula remains traceable back to the named input that feeds it.

What the PDF Report Contains

The PDF report is the deliverable for the audience that will never open the workbook. It is the document that lands in a board pack, sits in a data room folder, or attaches to a lender pitch. The PDF is generated from the same calculation as the workbook, so the headline numbers always match. What differs is the framing.

The default PDF report is structured as follows:

The branded version of the PDF carries the engagement's customer branding — logo, colours, footer — and is suitable for direct delivery to a board, lender, or acquirer. The watermarked free version is suitable for internal review and indicative work, and is clearly labelled as an indicative estimate rather than a formal valuation.

The Methodology Audit Section

The single most important section of the report — and the one most often missing from spreadsheet-based valuations — is the methodology audit. This is the page that confirms the valuation has been run correctly, that the method chosen is appropriate for the asset class, and that the inputs and outputs conform to the relevant standard.

Each report's methodology audit checks:

Method selection. The chosen method is the conventional method for the asset class under IFRS 3 / ASC 805 — Relief from Royalty for brands and patents, MPEEM for customer relationships, Replacement Cost for assembled workforces and proprietary software, With-and-Without for non-competes, Greenfield for franchise rights, Market for licensing arrangements with comparable transactions.

Discount rate consistency. Where multiple DCF-based methods are used (typically MPEEM and With-and-Without on the same engagement), the discount rate is the same across both, with documented adjustments only where the risk profile of a specific asset justifies a different rate.

Contributory asset charges. Where MPEEM has been used, the contributory asset charges for workforce, brand, and technology reconcile to the standalone Replacement Cost valuations of those same assets. This is the single most common source of inconsistency in spreadsheet-based PPA work, and the audit catches it.

Useful economic life. The amortisation period assigned to each intangible is consistent with the customer attrition curve, the technology refresh cycle, the brand investment trajectory, or the contractual life — whichever is appropriate for the asset class.

Tax amortisation benefit (TAB). Where TAB has been applied, it is applied consistently across all DCF-based methods on the engagement, and the assumed tax rate is the same in the TAB calculation as in the underlying DCF.

Portfolio coverage against The Opagio 12. The valuation identifies which of the 12 value drivers have been valued in the engagement, which have been deliberately excluded (with reasoning), and which have been flagged as material but unquantified. This is the section that turns a list of asset valuations into a coherent portfolio statement.

A valuation that passes the methodology audit is not necessarily right — assumptions can still be wrong, and benchmarks can still be inappropriate. But a valuation that passes the audit is internally consistent and conformant with the relevant standard. That is the floor every defensible intangible asset valuation has to clear, and the methodology audit makes the floor explicit.

How Reports Differ by Use Case

The same calculation produces different reports for different use cases. The structure stays consistent — Excel workbook plus branded PDF, methodology audit included — but the framing, the appendices, and the level of disclosure shift to match the audience.

The board pack variant prioritises the executive summary and the sensitivity table. It is short — typically 8–12 pages — and is designed to be read in 15 minutes by a non-specialist board member. The detailed calculation and the contributory-asset reconciliation move to the appendix. The narrative leads.

The data room variant prioritises the methodology audit and the audit trail. It is longer — typically 25–40 pages — and is designed to be interrogated by an acquirer's diligence team. Every input is sourced, every methodology choice is justified, and the appendix contains the traceability matrix from ledger line through to fair value.

The lender pitch variant prioritises collateral suitability. It pulls the same fair value out of the same calculation, but frames it against the loan-to-value benchmarks the lender will apply. Brand-attributable revenue concentration, customer book churn, IP registration status, and contractual lock-in are all flagged in the executive summary — these are the questions a credit committee will ask first.

The financial reporting variant prioritises IFRS 3 / ASC 805 compliance. It maps each valuation back to the relevant standard, flags any judgmental areas, and produces the disclosure schedule the auditor will work from. The variant is suitable for both initial recognition (PPA at acquisition) and subsequent impairment review.

What This Means for the Engagement

A reporting layer that separates the calculation from the deliverable changes the shape of an intangible asset engagement in three ways.

The deliverable is decoupled from the analyst. When a valuer leaves the engagement, the spreadsheet they built often leaves with them — the assumptions are in their head, the cell references are idiosyncratic, the formatting choices were personal. A platform-generated report does not have that dependency. The next analyst on the engagement opens the workbook, reads the audit trail, and sees exactly what was done.

The report can be re-run. Because the report is generated from a stored calculation rather than a hand-built spreadsheet, it can be re-run when the inputs change. New chart-of-accounts data arrives at month-end; refresh the data import; re-run the report. The version hash on the PDF changes; the audit trail updates; the board sees the same format every quarter with the underlying numbers refreshed.

The handover survives diligence. The most common failure mode in spreadsheet-based PPA work is the handover from valuer to diligence team. The valuer produced a workbook, the diligence team has questions, the valuer is no longer engaged, and the workbook is illegible without them. Reports generated from the Valuator do not have that handover problem. Every input, every assumption, every formula is traceable from the PDF through the workbook back to the data layer underneath. The diligence team interrogates the report, not the analyst.

Worked Example: A Series B Data Room

A growth-stage SaaS company is closing a Series B and needs an intangible asset valuation for the data room. The CFO has previously connected Xero to the Valuator and built a portfolio valuation across MPEEM (customer relationships), RFR (brand), and Replacement Cost (proprietary software, assembled workforce).

Step 1 — Report generation. The CFO selects the data room variant. The platform generates a 34-page branded PDF (Series B branding applied), an Excel workbook with eight sheets, and a traceability matrix linking every input to its source. Total elapsed time: 90 seconds.

Step 2 — Internal review. The CFO reads the executive summary, checks the methodology audit, and confirms the contributory-asset reconciliation between MPEEM and Replacement Cost. The audit flags one item — the technology contributory asset charge in MPEEM is set 8% below the standalone Replacement Cost valuation of the same asset. The CFO investigates, agrees the standalone Replacement Cost number is right, and refreshes the MPEEM run. The audit re-runs clean.

Step 3 — Distribution. The branded PDF goes into the data room under "Intangible Asset Portfolio Valuation." The Excel workbook goes into the diligence sub-folder, accessible only to the acquirer's technical reviewer. The traceability matrix is referenced in the cover page of the PDF, with a link to where it sits in the data room.

Step 4 — Diligence response. The acquirer's technical reviewer asks two questions: how was brand-attributable revenue derived, and why was the discount rate for the customer book set 50bps above the WACC. Both answers are visible in the audit trail without anyone needing to open the original calculation. The diligence pack closes with no further questions.

What previously took a week of spreadsheet wrangling and a back-and-forth diligence cycle has produced a defensible, reviewable, audit-ready report in under an hour — and survived diligence without the CFO or the original valuer needing to re-engage.

How Reports Connect to The Opagio Method

Reporting is the visible output of The Opagio Method, but it is not a step on its own. Every step of the method produces an artefact, and the report layer composes those artefacts into the deliverable the audience consumes.

A report that arrives in a board pack without a Discover step looks thin — it values what it values, but the audience cannot tell what was missed. A report that contains a portfolio coverage map shows which assets were valued, which were deliberately scoped out, and which were flagged but unquantified. That coverage map is the difference between a useful valuation and a defensible one.

Getting Started

Single-asset reports are produced automatically in the free Intangible Asset Valuator — every calculation generates a watermarked PDF and an Excel workbook on demand, with no sign-up required. The free reports are suitable for internal review, indicative work, and management-level scoping.

For branded reports, portfolio rollup, the methodology audit, multiple report variants, and the full audit-trail traceability matrix, Opagio Intangibles provides the complete workflow. It is the right tool for any engagement where the report will be delivered externally — to a board, a lender, an acquirer, or an auditor.

If you have a transaction or a reporting cycle in scope and want to discuss whether a managed reporting workflow is the right fit, contact the Opagio team for a complimentary scoping conversation.

Ivan Gowan is the CEO of Opagio. He previously spent 15 years at IG Group (LSE: IGG), where he was part of the senior leadership team during the company's growth from £300m to £2.7bn — a transformation driven overwhelmingly by intangible assets that traditional accounting did not capture. He holds an MSc in neural networks from the University of Edinburgh (2001).