$ loading_
Tie an LP statement to the fund's NAV pack — recompute the LP's capital account from the NAV components and flag any line that doesn't agree. Use before LP statements are distributed.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "nav-tieout" skill from askskill: 1. Download https://raw.githubusercontent.com/anthropics/financial-services/main/plugins/vertical-plugins/fund-admin/skills/nav-tieout/SKILL.md 2. Save it as ~/.claude/skills/nav-tieout/SKILL.md 3. Reload skills and tell me it's ready
Given a generated LP statement and the period's NAV pack (via the nav MCP), independently recompute the LP's capital account and compare line by line.
The generated statement is the thing under test. The NAV pack is the source of truth.
Beginning capital (prior statement ending)
+ Contributions (capital calls paid this period)
− Distributions (cash + in-kind)
+ Allocated net income / (loss)
= LP% × (realized + unrealized P&L − management fee − fund expenses)
− Carried interest allocation (if crystallized this period)
Ending capital
Pull each input from the NAV pack: LP commitment %, fund-level P&L components, fee and expense totals, waterfall outputs.
For each line on the statement, compare to your recomputed value. Tolerance: 0.01. For each mismatch, note which input drives it (e.g., "allocated P&L differs — statement used 12.40% ownership, NAV pack shows 12.38% after the Q1 transfer").
A pass/fail per line, the recomputed values alongside the statement values, and a list of flags. Do not edit the statement — the publisher acts on the flags after review.
Build pre-earnings analysis with estimate models, scenario frameworks, and key metrics to watch. Use before a company reports quarterly earnings to prepare positioning notes, set up bull/bear scenarios, and identify what will move the stock. Triggers on "earnings preview", "what to watch for [company] earnings", "pre-earnings", "earnings setup", or "preview Q[X] for [company]".
Root-cause a reconciliation break to its source transaction or posting — follow the audit trail from the break row back to the originating entry on each side and state what differs and why. Use after gl-recon has classified a break.
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model (including financial-model integrity checks like BS balance, cash tie-out, and logic sanity). Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreadsheet", "sanity check this", "debug model", "model check", "model won't balance", "something's off in my model", "model review".
Build institutional-grade comparable company analyses with operating metrics, valuation multiples, and statistical benchmarking in Excel/spreadsheet format. **Perfect for:** - Public company valuation (M&A, investment analysis) - Benchmarking performance vs. industry peers - Pricing IPOs or funding rounds - Identifying valuation outliers (over/under-valued) - Supporting investment committee presentations - Creating sector overview reports **Not ideal for:** - Private companies without comparable public peers - Highly diversified conglomerates - Distressed/bankrupt companies - Pre-revenue startups - Companies with unique business models
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations.
Create professional equity research earnings update reports (8-12 pages, 3,000-5,000 words) analyzing quarterly results for companies already under coverage. Fast-turnaround format focusing on beat/miss analysis, key metrics, updated estimates, and revised thesis. Includes 1-3 summary tables and 8-12 charts. Use when user requests "earnings update", "quarterly update", "earnings analysis", "Q1/Q2/Q3/Q4 results", or post-earnings report.