First batch of analytical models. Same gating rules as /pnl (include_in_pnl accounts, P&L items only). Per-class allocates COGS & OpEx pro-rata by revenue share — a heuristic, not direct attribution.
Member LTV
| Member |
Status |
Joined |
Last Purchase |
Purchases |
Membership LTV |
Ancillary LTV |
Days Since |
Cohort Retention
Rows = join cohort (month members first joined). Columns = months since join. Value = % of cohort still active (any Cash-In txn).
CapEx Portfolio IRR
Treats the entity as one project. Outflows = capex acquisitions on their dates. Inflows = monthly net operating cash flow (revenue − expenses, P&L scope). IRR computed via Newton's method on the monthly series, annualized.
Assets
| Asset |
Acquired |
Cost |
Accum. Dep |
NBV |
Status |
Per-Class P&L (LTM)
Revenue uses canonical /pnl logic (hybrid cash + accrual). COGS & OpEx allocated pro-rata by revenue share — margins identical by construction. Real per-class margins require tagging expenses with their class.
| Class |
Revenue |
Share |
COGS (alloc) |
Gross Profit |
GM % |
OpEx (alloc) |
Net Profit |
NM % |
Budget vs Actual
YTD actuals vs annual targets (from kpi_targets). Pace = % of year elapsed. Status: on track ≥ pace−5pp, at risk ≥ pace−20pp, behind otherwise.
| Metric |
Target |
YTD Actual |
Pace Expected |
Variance |
% of Target |
Status |
Break-even Analysis
Contribution margin = 1 − (COGS / Revenue). Break-even Revenue = Fixed Costs / CM. Members needed = Break-even Revenue / annualized ARPU (90-day, P&L-scope cash-in).
Cash Runway
Months of operating cash at trailing-3M average burn rate. Cash = bank balances. Burn = |trailing 3M avg monthly net|, only if negative.
13-Week Cash Forecast
Opening bank balance + recurring inflows/outflows expanded into weekly buckets. Recurring only — non-recurring variable cash flow is not projected.
| Wk |
Start |
End |
In |
Out |
Net |
Cumulative Cash |
Revenue Forecast (12 months)
Driver-based: Active members × monthly ARPU × monthly retention. Defaults from data; override with the inputs below.
| Mo |
Active Members |
Monthly Revenue |
Cumulative |
Expense Forecast (12 months)
Recurring monthly (from recurring_templates with cash-out items) + variable estimate (trailing 3M actual − recurring). Apply uniform growth %.
| Mo |
Recurring |
Variable |
Total |
Cumulative |
DCF Valuation
5-year DCF on LTM net cash flow with Gordon-growth terminal value. Defaults: growth 5%, WACC 12%, terminal growth 2%, horizon 5y. Adjust assumptions below.
| Year |
Projected CF |
Discount Factor |
Present Value |
Consolidated NK P&L (LTM, all entities)
LTM P&L summed across every active entity in the ledger. Totals are naive sums; multi-currency entities are not FX-normalized (KNG SGD, Crowd Joy JPY/USD etc all added at face).
| Entity |
Ccy |
Revenue |
COGS |
OpEx |
Net Profit |
NM % |
Scenario / What-If
Slide the multipliers to flex price, member volume, COGS, OpEx — recomputes baseline LTM P&L live.