AI Blocks › Handle money and investing
Listed holding look-through NAV
Reconcile quoted ownership stakes and holding-company costs to look-through value per share.
Listed holding look-through NAV is a free AI skill for the job "Handle money and investing". Give the instructions to an AI assistant that supports the required files and tools, then review its output.
Free · No account · Made by AI Blocks · Level: advanced · Thinking: high
What it does
A look-through NAV table with ownership and double-count checks. Public equity valuation. Illustrative figures.200×20%+300×30%+20-50-10=90 NAV, or9 per share. Increasing A by100 adds20 to NAV and2 per share.
You give it
- Dated quoted subsidiary equity values, economic stakes, parent-only cash/debt, holding-cost value and parent shares.
- Reporting date, currency and scale, fiscal calendar, accounting basis and authorized scope.
- Available spreadsheet tools and required native output format.
You get
- A look-through NAV table with ownership and double-count checks.
- An illustrative editable workbook, input schema, executable calculation reference and golden test cases.
- Reconciliation results, unresolved inputs and actual checks completed.
Use it when
- You need a look-through NAV table with ownership and double-count checks.
- You work on public equity valuation and need traceable calculations.
- A reviewer needs to trace the result back to inputs and assumptions.
How to use it
- Download the complete pack and read its governing SKILL.md.
- Share the actual sources and the financial question you need answered.
- Ask your AI to follow the methods, preserve original files and stop affected work on missing evidence.
- Review assumptions, reconciliations and CHECKS MISSED before relying on the result.