Tools
Asset Visibility Gap Calculator
Execs tend to react faster to uncertainty than to efficiency slides alone. This worksheet sizes how much of the portfolio is not reliably known under your assumptions—then puts a dollar figure and a simple risk score beside it.
Inputs
Exec-facing view of uncertainty in the portfolio—not a substitute for inventory or audit work, but a structured starting point.
Combined book / fair-value estimate you would defend in a board conversation.
Share of material assets (by value or count—pick one lens and stay consistent) with an authoritative record.
Places asset truth can diverge (ERPs, CMMS, spreadsheets, drives, shadow tools).
Common for roll-ups and manual reconciliations.How often material positions become trustworthy again—not how often exports run.
Outputs
Reframed as risk exposure—how much of the portfolio is effectively unknown or untrusted under your own assumptions.
- % of assets at risk(not reliably represented in a coherent view)
- 71.5%
- Estimated value of “untrusted” data
- $34,320,000
- Operational risk scoreComposite 0–100 (coverage, fragmentation, staleness)
- 65
Methodology (short)
- We compute an effective trusted coverage = (tracked % ÷ 100) × coherence(systems) × freshness(update cadence).
- % at risk ≈ 100% minus that coverage (capped at 95% for realism).
- Untrusted value = portfolio value × (% at risk ÷ 100).
- Risk score blends % at risk, disconnected-system load, and staleness—scaled to 0–100.
Effective trusted coverage for your inputs: 28.5%.
See also: Record bottleneckIntegration debtAsset continuity ROI
Illustrative model only. Inventory methods, legal definitions of “asset,” and control environments differ; use this to start a conversation—not as audit evidence.