Portfolio · Foobar · v20260320-o

📂 Portfolio — Holdings, capital calls, distributions and deployment pipeline

Sub-tab / View	What it shows	Data source
Funds	All fund commitments with NAV (capital balance), TVPI, DPI, called capital, status and vintage. Expandable row for fund details.	Airtable
Direct	Foobar's own direct equity investments by company — sector, sub-asset class, invested amount, status.	Airtable
SPVs	Special-purpose vehicle investments — same structure as Directs.	Airtable
Semi-Liquid	Public / semi-liquid fund positions (evergreen structures, hedge funds, listed vehicles) with NAV and performance.	Airtable
Vintage	Vintage-year analysis across all fund commitments — committed capital, NAV and DPI grouped by year of first close.	Airtable
Impairments & Write-offs	Companies and funds with impairments, write-offs or distressed status. Amount written down and reason where available.	Airtable
Capital Calls	Scheduled and actual capital calls per fund by year (2020–2030). Year-picker filter. Total committed vs called.	Airtable
Distributions / Exits	Cash distributions received from funds and realisations from direct/SPV exits, by year. Filterable by asset type and sector.	Airtable
Deployment	Investment pipeline — companies at various stages with expected deployment amounts and timing.	Airtable
Capital Flow Plan	Integrated view of committed capital calls vs expected distributions by fund for the 2026–2030 Airtable forecast window.	Airtable

🔍 Fund Look-Through — Underlying company-level detail from fund statements

Sub-tab / View	What it shows	Data source
Overview	Portfolio-wide company count, fair value summary and latest statement dates across all funds in the look-through universe.	Airtable
By Fund	Per-fund company roster with cost, fair value, and movement since prior statement. Collapsible fund sections.	Airtable
All Companies	Flat list of every underlying company across all funds — sortable by fair value, cost, or fund. Identifies cross-fund overlaps.	Airtable

📊 Financial Reporting — Firm-level P&L, liquidity, Unity position and board snapshot

Sub-tab / View	What it shows	Data source
Board Snapshot	Executive summary — total assets, liquidity breakdown (cash / fixed income / money market / equities), OPEX, capital call obligations and Unity position. The primary KPI view.	Airtable
Liquidity	Runway scenarios: Base (liquid assets ÷ obligations), Upside (+ all liquidity pools), and Upside + Unity ($20M/yr Unity sales). Shows monthly burn horizon under each scenario.	Airtable
Quarterly P&L	Revenue, OPEX, management fees and net income by quarter — GAS/accounting data overlaid with Airtable actuals where available.	Airtable GAS
Unity Position	Unity Software (NYSE: U) shareholding — shares held, current PPS (live or latest known), total value, YTD sales and remaining position.	Airtable

📐 Planning — 10-year forward models for Unity sales, existing portfolio and new investments

Sub-tab / View	What it shows	Data source
Sale of Shares	Year-by-year Unity share sale model — planned shares sold, PPS trajectory, cash proceeds and remaining position 2026–2035. Configurable pace and PPS growth rate. Sensitivity sliders for live scenario testing.	Model Airtable
Existing Portfolio	NAV and distribution forecast for the current fund portfolio — J-curve lifecycle model per fund class, capital calls, distribution harvest and total wealth trajectory (including directs, SPVs, semi-liquid). Investment picker to toggle individual holdings.	Model Airtable
Future Portfolio	Allocation engine for new commitments 2026–2035. Gap-fills vs target allocation (VC Fund 51%, US Equities 25%, Real Assets 18% etc.), models J-curve draws and distributions on future funds, and produces a 10-year Sources & Uses cashflow integrating Unity proceeds, existing distributions, new commitment costs and capital calls. Sensitivity sliders for IRR and budget cap. Configurable investment inputs.	Model Airtable

💡 Insights — On-demand AI analysis cards across financial, portfolio, look-through and planning data

Card	What it generates	Type
Financial Insights
Firm-level financial review	Reads the Board Snapshot and produces partner-ready commentary on liquidity health, OPEX trajectory, capital call coverage and recommendations.	AI
Material changes since last board	Compares the current portfolio against a locked baseline (you set the date) and surfaces material moves in NAV, TVPI, invested amounts or company status.	AI
Portfolio Insights
Direct & SPV portfolio review	Scans active direct and SPV holdings for breakouts, at-risk positions, concentration patterns and portfolio composition signals.	AI
Runway & cash-out risk	Identifies active portfolio companies that haven't raised in 18+ months — the primary proxy for runway risk. Segments by risk tier and recommends partner check-ins.	AI
Look-Through Insights
Underlying company changes	Diffs the latest fund statements vs prior periods — marks up/down, new positions, exits and write-offs at the individual company level across all funds.	AI
Fund-level performance review	Assesses each fund's TVPI/DPI relative to its vintage-year benchmark. Flags funds that are ahead of or behind typical pace for their age.	AI
Data Quality
Reporting hygiene & data gaps	Deterministic scan for missing fields — funds without NAV, companies without status, rounds without amounts, orphaned investment records.	Auto
Planning Insights
Sale of Shares pacing	Reads the SoS model and assesses whether the Unity sale pace, PPS assumptions and total proceeds are adequate given Foobar's investment programme. Flags concentration risk.	AI
10-year liquidity health	Runs the Sources & Uses cashflow model and flags deficit years, pressure points, Unity dependency and buffer years across the full decade.	AI
FP deployment & allocation quality	Assesses whether the Future Portfolio target allocation makes sense, which gaps are being filled, and whether the deployment pace fits the cash profile.	AI

💬 Oddny — AI Financial Analyst

Oddny is the dashboard's built-in AI financial analyst, powered by Claude (Anthropic). She has full read access to your portfolio data — funds, directs, SPVs, financial reporting, and planning models — and can answer questions, run quick analyses, and explain anything you're looking at.

To open Oddny, click the chat bubble button in the bottom-right corner of the screen (visible on every tab). She appears as a floating panel you can open and close without leaving your current view.

Oddny works best for ad-hoc questions: "What is our total capital call exposure in 2027?", "Which funds have the highest DPI relative to vintage?", "Summarise our liquidity position", "What should I look at before tomorrow's board meeting?"

Example questions

📊 "What's our current runway under the base scenario?"

📐 "Which asset classes are most underweight vs target?"

🔍 "Are there any fund positions I should be concerned about?"

💡 "Explain the J-curve model used in Planning."

🚀 "What's the biggest risk to our 10-year cash plan?"

Note: Oddny uses only data visible in the dashboard — she cannot access Airtable directly or read documents outside the platform. For deep analysis across multiple tabs, the Insights tab runs structured AI analysis cards with a full portfolio-state context.

🚩 Reporting an Issue

If you spot incorrect data, a broken chart, or want to suggest an improvement, click the 🚩 Report issue button in the top-right of the header bar (visible on every tab). This opens a form where you can describe the problem — submissions are sent directly to the development team via Slack.

When reporting, it helps to include:

Which tab and sub-tab the issue is on (e.g. "Portfolio → Capital Calls")
What you expected to see vs what you actually see
Any specific fund, company or year involved

⬇️ Exporting Data

Export type	How to use it
This tab — PDF	Click This tab in the header bar. Exports a clean PDF of whichever tab you're currently viewing — no other tabs included. Best for sharing a single section (e.g. just the Financial Reporting board snapshot).
Full dashboard — PDF	Click Export PDF in the header bar. Produces a multi-page PDF covering all major tabs. Charts and tables are formatted for print. Note: AI Insights cards are included only if they have been generated in the current session.
Table data — copy	Most tables in the dashboard support text selection. Select cells and copy (⌘C / Ctrl+C) to paste into Excel or a document.
Airtable (source)	All underlying data lives in the Foobar Airtable base. For bulk data exports or historical snapshots, export directly from Airtable (CSV download per table).

Dashboard Guide