Analytics & Modeling Commands
FundAdmin AI provides quantitative tools for fund performance measurement, cash flow projection, scenario analysis, and fee verification. These commands implement industry-standard methodologies (ILPA, CFA Institute, GIPS) and produce auditable calculation workpapers.
/fund performance-calc
Description: Calculates a comprehensive set of fund performance metrics using industry-standard methodologies. Implements Newton-Raphson iteration for IRR, Kaplan-Schoar methodology for PME, and supports since-inception and interim period calculations. All results include calculation detail sufficient for audit verification.
Usage
bash
/fund performance-calc <data>Inputs
| Parameter | Type | Required | Description |
|---|---|---|---|
data | File path or JSON | Yes | Cash flow data: dates, contributions, distributions, NAV (JSON, CSV, or XLSX) |
Data Fields
| Field | Type | Required | Description |
|---|---|---|---|
fund_name | String | Yes | Name of the fund |
inception_date | Date | Yes | Fund inception or first cash flow date |
cash_flows | Array | Yes | Array of {date, amount} where contributions are negative and distributions are positive |
current_nav | Number | Yes | Current net asset value (residual value) |
nav_date | Date | Yes | As-of date for current NAV |
benchmark_index | String | No | Public market index for PME calculation (e.g., S&P 500, MSCI World) |
Output
Generates PERFORMANCE-[fund-name]-[date].md containing:
- IRR (Internal Rate of Return) -- since-inception net IRR using Newton-Raphson iteration, gross IRR, interim period IRRs (quarterly, annual), convergence detail
- TVPI (Total Value to Paid-In) -- (distributions + NAV) / contributions, gross and net of fees
- DPI (Distributions to Paid-In) -- realized return multiple, distributions / contributions
- RVPI (Residual Value to Paid-In) -- unrealized return multiple, NAV / contributions
- MOIC (Multiple on Invested Capital) -- total value / total invested, gross and net
- PME (Public Market Equivalent) -- Kaplan-Schoar PME against specified benchmark, Long-Nickels PME, Direct Alpha calculation
- J-Curve Analysis -- time to breakeven (TVPI > 1.0x), maximum drawdown point, J-curve shape classification
- Vintage Year Comparison -- performance relative to vintage year peer group (quartile ranking)
- Calculation Workpapers -- step-by-step computation detail for each metric, suitable for auditor review
Example
bash
/fund performance-calc fund-iv-cashflows.csvRelated Commands
/fund cashflow-forecast-- project future cash flows/fund scenario-model-- model performance under different scenarios/fund report-pdf-- generate PDF report with performance charts
/fund cashflow-forecast
Description: Projects future fund cash flows using the Yale Model (Takahashi-Alexander framework), the industry-standard methodology for private capital cash flow forecasting. Generates quarterly projections for contributions, distributions, and NAV with configurable parameters and sensitivity analysis.
Usage
bash
/fund cashflow-forecast <data>Inputs
| Parameter | Type | Required | Description |
|---|---|---|---|
data | File path or JSON | Yes | Fund parameters, commitment data, and historical cash flows (JSON, CSV, or XLSX) |
Data Fields
| Field | Type | Required | Description |
|---|---|---|---|
fund_name | String | Yes | Name of the fund |
total_commitment | Number | Yes | Total fund commitment |
vintage_year | Number | Yes | Fund vintage year |
strategy | String | Yes | Fund strategy: buyout, venture, growth, real_estate, credit, infrastructure |
fund_term | Number | No | Fund term in years (default: 10) |
investment_period | Number | No | Investment period in years (default: 5) |
growth_rate | Number | No | Expected annual growth rate (default: strategy-specific) |
yield_rate | Number | No | Expected annual yield/distribution rate (default: strategy-specific) |
bow_factor | Number | No | Takahashi-Alexander bow factor controlling pace of contributions (default: strategy-specific) |
Output
Generates CASHFLOW-FORECAST-[fund-name]-[date].md containing:
- Model Parameters -- all input assumptions, strategy-specific defaults applied, Takahashi-Alexander parameters (RC, RD, bow, growth, yield)
- Quarterly Projections -- period-by-period forecast of contributions (capital calls), distributions (realizations + yield), net cash flow, and NAV
- Annual Summary -- annual aggregation with cumulative totals
- Peak Exposure -- maximum unfunded commitment draw, timing of peak NAV, peak cash outflow quarter
- Sensitivity Analysis -- projections under alternative assumptions:
- Growth rate: -2%, base, +2%
- Pace: accelerated, base, delayed
- Yield: low, base, high
- Liquidity Planning -- quarterly net cash flow requirements, cumulative funding needs, suggested cash reserve schedule
- Comparison to Actuals -- if historical data provided, variance analysis between model and actual cash flows with model calibration suggestions
Example
bash
/fund cashflow-forecast fund-v-commitment-data.jsonRelated Commands
/fund performance-calc-- calculate performance on historical cash flows/fund scenario-model-- model specific scenarios beyond standard sensitivity/fund draft-capital-call-- draft capital calls based on forecast
/fund scenario-model
Description: Models fund economics under Base, Downside, and Upside scenarios. Calculates waterfall impact, LP returns, and GP economics under each scenario. Includes breakeven analysis showing the minimum performance required to achieve preferred return, carried interest threshold, and target returns.
Usage
bash
/fund scenario-model <data>Inputs
| Parameter | Type | Required | Description |
|---|---|---|---|
data | File path or JSON | Yes | Fund terms, portfolio data, and scenario assumptions (JSON or XLSX) |
Data Fields
| Field | Type | Required | Description |
|---|---|---|---|
fund_name | String | Yes | Name of the fund |
fund_size | Number | Yes | Total fund commitments |
waterfall_type | String | Yes | american or european |
management_fee | Number | Yes | Annual management fee rate |
carried_interest | Number | Yes | Carry percentage |
preferred_return | Number | Yes | Preferred return hurdle rate |
gp_commitment | Number | Yes | GP commitment amount or percentage |
scenarios | Object | No | Custom scenario definitions (defaults to standard Base/Down/Up) |
Output
Generates SCENARIO-MODEL-[fund-name]-[date].md containing:
- Scenario Definitions -- assumptions for each scenario (entry multiples, exit multiples, hold periods, loss rates, growth rates)
- Base Case -- expected returns: gross/net IRR, TVPI, DPI, GP carry, LP net distributions
- Downside Case -- stressed returns: typically 20-30% lower realizations, higher loss rates, extended hold periods
- Upside Case -- optimistic returns: higher exit multiples, faster realizations, lower loss rates
- Waterfall Impact -- full waterfall calculation under each scenario showing amounts at each tier
- Breakeven Analysis -- minimum portfolio gross multiple to achieve: (1) return of capital, (2) preferred return, (3) carried interest threshold, (4) target net return
- GP Economics -- management fees, carried interest, GP commitment return, and total GP compensation under each scenario
- LP Net Returns -- net IRR, net multiple, and cash-on-cash return under each scenario by LP class (if multiple classes)
- Fee Drag Analysis -- impact of management fees and carry on gross-to-net return spread under each scenario
Example
bash
/fund scenario-model fund-iv-portfolio-data.jsonRelated Commands
/fund waterfall-review-- validate waterfall logic used in scenarios/fund performance-calc-- calculate actual performance for comparison/fund cashflow-forecast-- project cash flows under each scenario
/fund fee-audit
Description: Performs a comprehensive audit of all fund fees and economics. Independently recalculates management fees, carried interest, preferred return, GP catch-up, clawback obligations, and fee offsets. Compares calculated amounts against stated amounts and flags any discrepancies.
Usage
bash
/fund fee-audit <file>Inputs
| Parameter | Type | Required | Description |
|---|---|---|---|
file | File path | Yes | Fee data, financial statements, or LPA with capital account statements (PDF, DOCX, JSON, or XLSX) |
Output
Generates FEE-AUDIT-[fund-name]-[date].md containing:
- Management Fee Verification -- fee rate, fee basis (committed vs. invested capital), calculation period, step-down timing, fee holiday analysis, independently calculated amount vs. stated amount, variance
- Carried Interest Calculation -- waterfall tier analysis, preferred return accrual (simple vs. compound), GP catch-up calculation (typically 100% to GP until 20/80 achieved), carry split, total carry amount, verification against stated
- Preferred Return Accrual -- rate, accrual methodology, compounding frequency, accrual balance roll-forward, underpayment/overpayment status
- Catch-Up Verification -- catch-up percentage, catch-up completion status, amount remaining, proper sequencing verification
- Clawback Analysis -- GP clawback obligation, lifetime carry received, lifetime preferred return shortfall, clawback amount due (if any), escrow adequacy
- Fee Offset Verification -- transaction fees, monitoring fees, director fees, broken deal fees collected; offset percentage per LPA; amount credited to LPs; net fee impact
- Organizational Expense Review -- total organizational expenses, cap per LPA, amortization schedule, amount charged to fund
- Discrepancy Summary -- all variances between independently calculated and stated amounts, with materiality classification and likely cause
- Cumulative Fee Impact -- total fees paid since inception as percentage of committed capital, comparison to projected fees at commitment
Example
bash
/fund fee-audit fund-iv-annual-financials.pdfRelated Commands
/fund waterfall-review-- validate the full waterfall including fee tiers/fund benchmark-- compare fee levels against market benchmarks/fund audit-support-- prepare fee workpapers for external audit