Data Quality Warden

Data Insight

28-mode analysis for Excel/CSV/SQLite: schema inspection, SQL query, statistical summaries, fraud detection (Benford, counterparty, network topology), large-amount test, Journal Entry Testing (JET), business-finance reconciliation (AR/AP aging, inventory turnover), and BI export.

Offset Transaction Filter

Identify offsetting (positive/negative) pairs in transaction/journal tables by grouping fields. Splits records into matched-offset and remaining. Supports tolerance for rounding diffs and an optional ordering field. Excel/CSV in, Excel out.

Spend Sorter

End-to-end personal finance categorization -- input transactions CSV (alipay/wechat/bank), output Excel with auto-categorization (food/transport/housing/entertainment), monthly cashflow, and savings rate.

Valuation Compass

Discounted cash flow (DCF) valuation: discounts projected free cash flows at WACC plus a perpetuity-growth terminal value to derive enterprise value, equity value and per-share value, with a WACC x terminal-growth sensitivity table and review next-best-actions (actions.json). (Action Co-pilot: generates next-best-actions (actions.json), follow-up tasks and calendar reminders on top of the analysis — what to act on today.)

Equity Modeler

Models equity-incentive retention rate, per-period share-based compensation expense, vested share count and weighted-average shares from a grant schedule, covering graded vesting, forfeiture and acceleration; outputs per-period tables and the assumptions behind them.

Cashflow Radar

Forecast cashflow horizons (30/60/90 days), category breakdown, confidence intervals.