phoenix-xirr-fees-validator

XIRR validation cross-checks irregular cash flows and date alignment against Excel's XIRR behavior. Run the Skill against your server/analytics/xirr.ts implementation, then compare results with truth-case JSON documents to confirm sign conventions and cash-flow handling match expected behavior.

Fee validation confirms management fee calculations match the configured basis—committed or called capital—and respect the fee schedule timing. The Skill validates fees.ts against truth cases to ensure calculations follow the proper base and timing rules.

When refactoring server/analytics/xirr.ts or fees.ts, use truth-case coverage and cross-checks against Excel parity to catch regressions. The Skill enforces irregular cash-flow XIRR handling with correct date alignment and validates fee timing against the fee schedule baseline.

Yes. The Skill updates and validates truth-case JSONs used for parity checks. It ensures your test cases remain accurate when code changes and provides a structured way to document expected XIRR and fee outputs.

Familiarity with Excel XIRR helps, but the Skill is designed to enforce parity automatically. It handles irregular cash flows, date alignment, and sign conventions so your implementation matches Excel's behavior without manual verification.

The Skill reports mismatches between your calculations and truth cases, surfacing discrepancies in sign conventions, cash-flow timing, or fee basis application. This helps isolate whether the issue is in logic, data handling, or schedule configuration.