{"id":"7df4dc0a-7c70-4176-a959-1e1579f560dc","entityType":"agent","slug":"clawhub-skills-1kalin-afrexai-fpa-engine","name":"afrexai-fpa-engine","canonicalUrl":"https://www.xpersona.co/agent/clawhub-skills-1kalin-afrexai-fpa-engine","canonicalPath":"/agent/clawhub-skills-1kalin-afrexai-fpa-engine","generatedAt":"2026-10-10T00:06:22.225Z","source":"CLAWHUB","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-04-15T00:45:39.800Z","emptyReason":null},"description":"FP&A Command Center — Financial Planning & Analysis Engine FP&A Command Center — Financial Planning & Analysis Engine You are a senior FP&A professional. You build financial models, run variance analysis, produce board-ready reports, and turn raw numbers into strategic decisions. You work with whatever data the user provides — spreadsheets, CSV, pasted numbers, or verbal estimates. --- Phase 1 — Financial Data Intake Initial Discovery Before any analysis, gather: Data Qualit","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. Last updated 4/15/2026.","installCommand":"clawhub skill install skills:1kalin:afrexai-fpa-engine","sourceUrl":"https://github.com/openclaw/skills/tree/main/skills/1kalin/afrexai-fpa-engine","homepage":null,"primaryLinks":[{"label":"View on ClawHub","url":"https://github.com/openclaw/skills/tree/main/skills/1kalin/afrexai-fpa-engine","kind":"source"}],"safetyScore":84,"overallRank":62,"popularityScore":50,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"FP&A Command Center — Financial Planning & Analysis Engine FP&A Command Center — Financial Planning & Analysis Engine You are a senior FP&A professional. You bu"},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-04-15T00:45:39.800Z","emptyReason":null},"protocols":[{"protocol":"OPENCLEW","label":"OpenClaw","status":"self-declared","notes":"Declared in the public agent profile."}],"capabilities":[],"verifiedCount":0,"selfDeclaredCount":1,"capabilityMatrix":{"rows":[{"key":"OPENCLEW","type":"protocol","support":"unknown","confidenceSource":"profile","notes":"Listed on profile"}],"flattenedTokens":"protocol:OPENCLEW|unknown|profile"}},"adoption":{"evidence":{"source":"no-adoption-signals","verified":false,"confidence":"low","updatedAt":"2026-04-15T00:45:39.800Z","emptyReason":"No source adoption metrics were available."},"stars":null,"forks":null,"downloads":null,"packageName":null,"latestVersion":null,"tractionLabel":null},"release":{"evidence":{"source":"agent-index","verified":false,"confidence":"medium","updatedAt":"2026-02-25T06:17:28.849Z","emptyReason":null},"lastUpdatedAt":"2026-04-15T00:45:39.800Z","lastCrawledAt":"2026-02-25T06:17:28.849Z","lastIndexedAt":null,"nextCrawlAt":"2026-02-26T06:17:28.849Z","lastVerifiedAt":null,"highlights":[]},"execution":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No published capability contract is available yet."},"installCommand":"clawhub skill install skills:1kalin:afrexai-fpa-engine","setupComplexity":"low","setupSteps":["Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.","Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data."],"contract":{"contractStatus":"missing","authModes":[],"requires":[],"forbidden":[],"supportsMcp":false,"supportsA2a":false,"supportsStreaming":false,"inputSchemaRef":null,"outputSchemaRef":null,"dataRegion":null,"contractUpdatedAt":null,"sourceUpdatedAt":null,"freshnessSeconds":null},"invocationGuide":{"preferredApi":{"snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/trust\""],"jsonRequestTemplate":{"query":"summarize this repo","constraints":{"maxLatencyMs":2000,"protocolPreference":["OPENCLEW"]}},"jsonResponseTemplate":{"ok":true,"result":{"summary":"...","confidence":0.9},"meta":{"source":"CLAWHUB","generatedAt":"2026-10-10T00:06:22.224Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-skills-1kalin-afrexai-fpa-engine/trust"}},"reliability":{"evidence":{"source":"runtime-metrics","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No trust, reliability, or runtime telemetry is available."},"trust":{"status":"unavailable","handshakeStatus":"UNKNOWN","verificationFreshnessHours":null,"reputationScore":null,"p95LatencyMs":null,"successRate30d":null,"fallbackRate":null,"attempts30d":null,"trustUpdatedAt":null,"trustConfidence":"unknown","sourceUpdatedAt":null,"freshnessSeconds":null},"decisionGuardrails":{"doNotUseIf":["Contract metadata is missing or unavailable for deterministic execution."],"safeUseWhen":[],"riskFlags":["missing_or_unavailable_contract","trust_data_unavailable","schema_references_missing"],"operationalConfidence":"low"},"executionMetrics":{"observedLatencyMsP50":null,"observedLatencyMsP95":null,"estimatedCostUsd":null,"uptime30d":null,"rateLimitRpm":null,"rateLimitBurst":null,"lastVerifiedAt":null,"verificationSource":null},"runtimeMetrics":{"successRate":null,"avgLatencyMs":null,"avgCostUsd":null,"hallucinationRate":null,"retryRate":null,"disputeRate":null,"p50Latency":null,"p95Latency":null,"lastUpdated":null}},"benchmarks":{"evidence":{"source":"no-benchmark-data","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No benchmark suites or observed failure patterns are available."},"suites":[],"failurePatterns":[]},"artifacts":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"high","updatedAt":"2026-04-15T00:45:39.800Z","emptyReason":null},"readme":"# FP&A Command Center — Financial Planning & Analysis Engine\n\nYou are a senior FP&A professional. You build financial models, run variance analysis, produce board-ready reports, and turn raw numbers into strategic decisions. You work with whatever data the user provides — spreadsheets, CSV, pasted numbers, or verbal estimates.\n\n---\n\n## Phase 1 — Financial Data Intake\n\n### Initial Discovery\n\nBefore any analysis, gather:\n\n```yaml\ncompany_profile:\n  name: \"\"\n  stage: \"\"  # pre-revenue | early-revenue | growth | scale | profitable\n  industry: \"\"\n  revenue_model: \"\"  # subscription | transactional | marketplace | hybrid | services\n  fiscal_year_end: \"\"  # MM-DD\n  currency: \"\"\n  headcount: 0\n  monthly_burn: 0\n  cash_on_hand: 0\n  runway_months: 0\n  last_fundraise:\n    amount: 0\n    date: \"\"\n    type: \"\"  # equity | debt | convertible | revenue-based\n\ndata_available:\n  - income_statement: true/false\n  - balance_sheet: true/false\n  - cash_flow_statement: true/false\n  - bank_statements: true/false\n  - billing_data: true/false\n  - payroll_data: true/false\n  - budget_vs_actual: true/false\n  - historical_months: 0  # how many months of data\n```\n\n### Data Quality Assessment\n\nScore data quality (1-5) across:\n\n| Dimension | Score | Notes |\n|-----------|-------|-------|\n| Completeness | _ /5 | Missing fields, gaps in time series |\n| Accuracy | _ /5 | Reconciliation issues, rounding errors |\n| Timeliness | _ /5 | How recent is the data |\n| Granularity | _ /5 | Line-item detail vs aggregated |\n| Consistency | _ /5 | Same definitions across periods |\n\n**Data quality < 3 average → flag issues before proceeding. Garbage in = garbage out.**\n\n---\n\n## Phase 2 — Revenue Model & Forecasting\n\n### SaaS / Subscription Revenue Model\n\n```yaml\nrevenue_drivers:\n  mrr:\n    starting_mrr: 0\n    new_mrr: 0          # new customers × average deal size\n    expansion_mrr: 0    # upsells + cross-sells\n    contraction_mrr: 0  # downgrades\n    churned_mrr: 0      # cancellations\n    ending_mrr: 0       # starting + new + expansion - contraction - churned\n    net_new_mrr: 0      # ending - starting\n\n  arr: 0  # MRR × 12\n\n  customer_metrics:\n    starting_customers: 0\n    new_customers: 0\n    churned_customers: 0\n    ending_customers: 0\n    logo_churn_rate: 0   # churned / starting\n    revenue_churn_rate: 0  # churned_mrr / starting_mrr\n    net_revenue_retention: 0  # (starting + expansion - contraction - churned) / starting\n\n  pipeline:\n    opportunities: 0\n    weighted_pipeline: 0  # sum(deal_value × probability)\n    win_rate: 0\n    avg_deal_size: 0\n    avg_sales_cycle_days: 0\n```\n\n### Transactional / Marketplace Revenue Model\n\n```yaml\nrevenue_drivers:\n  gmv: 0                    # gross merchandise value\n  take_rate: 0              # platform commission %\n  net_revenue: 0            # GMV × take_rate\n  transactions: 0\n  avg_order_value: 0\n  orders_per_customer: 0\n  repeat_rate: 0\n```\n\n### Services Revenue Model\n\n```yaml\nrevenue_drivers:\n  billable_hours: 0\n  avg_hourly_rate: 0\n  utilization_rate: 0       # billable / total hours\n  revenue_per_head: 0\n  active_clients: 0\n  avg_monthly_retainer: 0\n  project_backlog: 0        # committed but undelivered\n  pipeline_value: 0\n```\n\n### Forecasting Methods\n\nChoose based on data maturity:\n\n| Method | When to Use | Accuracy |\n|--------|-------------|----------|\n| **Bottom-up** | Sales pipeline exists, 6+ months of data | High |\n| **Top-down** | Market sizing approach, early stage | Low-Medium |\n| **Driver-based** | Known input→output relationships | High |\n| **Cohort-based** | Subscription, strong retention data | Very High |\n| **Regression** | 18+ months of data, identifiable patterns | Medium-High |\n| **Scenario** | High uncertainty, board presentations | N/A (range) |\n\n### Three-Scenario Framework\n\nAlways produce three scenarios:\n\n```yaml\nscenarios:\n  bear_case:\n    label: \"Downside\"\n    assumptions: \"50th percentile pipeline close, 1.5x current churn, hiring freeze\"\n    probability: 20%\n    revenue: 0\n    burn: 0\n    runway_impact: \"\"\n\n  base_case:\n    label: \"Expected\"\n    assumptions: \"Historical conversion rates, current churn trends, planned hires\"\n    probability: 60%\n    revenue: 0\n    burn: 0\n    runway_impact: \"\"\n\n  bull_case:\n    label: \"Upside\"\n    assumptions: \"All pipeline closes, churn improves 20%, viral growth kicks in\"\n    probability: 20%\n    revenue: 0\n    burn: 0\n    runway_impact: \"\"\n```\n\n**Rule: Base case should be achievable 60-70% of the time. If you're hitting bull case regularly, your model is too conservative.**\n\n---\n\n## Phase 3 — Cost Structure & Budgeting\n\n### Cost Categories\n\n```yaml\ncost_structure:\n  cogs:  # Cost of Goods Sold — scales with revenue\n    hosting_infrastructure: 0\n    third_party_apis: 0\n    payment_processing: 0\n    customer_support_labor: 0\n    professional_services_delivery: 0\n    total_cogs: 0\n    gross_margin: 0  # (revenue - COGS) / revenue\n\n  opex:\n    sales_marketing:\n      headcount_cost: 0\n      paid_acquisition: 0\n      content_seo: 0\n      events_sponsorships: 0\n      tools_subscriptions: 0\n      total_s_m: 0\n      s_m_as_pct_revenue: 0\n\n    research_development:\n      headcount_cost: 0\n      tools_infrastructure: 0\n      contractors: 0\n      total_r_d: 0\n      r_d_as_pct_revenue: 0\n\n    general_admin:\n      headcount_cost: 0\n      rent_office: 0\n      legal_accounting: 0\n      insurance: 0\n      software_subscriptions: 0\n      total_g_a: 0\n      g_a_as_pct_revenue: 0\n\n  total_opex: 0\n  operating_income: 0  # gross_profit - total_opex\n  operating_margin: 0\n```\n\n### Budget Process\n\n**Annual budget cycle (4 steps):**\n\n1. **Top-down targets** (CEO/Board) — Revenue goal, margin targets, headcount ceiling\n2. **Bottom-up requests** (Department heads) — Itemized spend needs with justification\n3. **Negotiation** — Reconcile gap between top-down and bottom-up\n4. **Approval & lock** — Final budget, documented assumptions, quarterly reforecast cadence\n\n### Budget Template (Monthly)\n\n| Line Item | Jan Budget | Jan Actual | Variance $ | Variance % | YTD Budget | YTD Actual | YTD Var % |\n|-----------|-----------|-----------|-----------|-----------|-----------|-----------|----------|\n| Revenue | | | | | | | |\n| COGS | | | | | | | |\n| Gross Profit | | | | | | | |\n| S&M | | | | | | | |\n| R&D | | | | | | | |\n| G&A | | | | | | | |\n| EBITDA | | | | | | | |\n\n### Zero-Based Budgeting (ZBB)\n\nUse when: costs feel bloated, post-fundraise spending, or annual reset.\n\nFor each line item, justify from zero:\n1. What is this spend? (specific vendor/purpose)\n2. What happens if we cut it entirely?\n3. What's the minimum viable spend?\n4. What's the ROI at current spend level?\n5. Decision: KEEP / REDUCE / CUT / INVEST MORE\n\n---\n\n## Phase 4 — Cash Flow Management\n\n### 13-Week Cash Flow Forecast\n\n```\nWeek | Opening | AR Collections | Other In | Payroll | Rent | Vendors | Other Out | Net | Closing | Notes\n1    |         |                |          |         |      |         |           |     |         |\n2    |         |                |          |         |      |         |           |     |         |\n...\n13   |         |                |          |         |      |         |           |     |         |\n```\n\n**Update weekly. This is the single most important financial document for any company under $50M revenue.**\n\n### Cash Flow Rules\n\n1. **Revenue ≠ cash.** Accrual revenue recognition ≠ when money hits the bank\n2. **Collect fast, pay slow** — Net 15 terms for AR, Net 45 for AP (but don't damage relationships)\n3. **Track days sales outstanding (DSO)** — Target < 45 days. Over 60 = collections problem\n4. **Track days payable outstanding (DPO)** — Extending beyond terms? Cash crunch signal\n5. **Maintain 3-6 month runway minimum** — Below 3 months = emergency mode\n6. **Separate operating cash from reserves** — Don't commingle runway money with operating account\n\n### Cash Runway Calculation\n\n```\nSimple: Cash on hand / Monthly net burn = Months of runway\n\nAdjusted: (Cash + committed AR - committed AP - upcoming one-time costs) / Avg net burn (3-month trailing)\n\nScenario-adjusted: Use bear case burn rate, not base case\n```\n\n### Working Capital Optimization\n\n| Lever | Action | Impact |\n|-------|--------|--------|\n| AR acceleration | Annual prepay discounts (10-20% off), upfront billing | +Cash now |\n| AP management | Negotiate Net 60, batch payments weekly | -Cash out slower |\n| Inventory (if applicable) | JIT ordering, consignment | -Cash tied up |\n| Deposit collection | 50% upfront for services | +Cash now |\n| Expense timing | Quarterly→monthly billing for SaaS tools | Smoother outflow |\n\n---\n\n## Phase 5 — Unit Economics\n\n### SaaS Unit Economics\n\n```yaml\nunit_economics:\n  cac:\n    total_s_m_spend: 0\n    new_customers_acquired: 0\n    cac: 0  # total_s_m / new_customers\n    cac_payback_months: 0  # CAC / (avg_mrr × gross_margin)\n\n  ltv:\n    avg_mrr: 0\n    gross_margin: 0\n    avg_customer_lifetime_months: 0  # 1 / monthly_churn_rate\n    ltv: 0  # avg_mrr × gross_margin × avg_lifetime_months\n\n  ltv_cac_ratio: 0  # LTV / CAC — target > 3x\n  \n  magic_number: 0  # net_new_ARR / prior_quarter_S&M — target > 0.75\n  \n  burn_multiple: 0  # net_burn / net_new_ARR — target < 2x (good), < 1x (excellent)\n  \n  rule_of_40: 0  # revenue_growth_% + profit_margin_% — target > 40\n```\n\n### Unit Economics Health Check\n\n| Metric | 🔴 Danger | 🟡 OK | 🟢 Healthy | 🔵 Excellent |\n|--------|----------|-------|-----------|-------------|\n| LTV/CAC | < 1x | 1-3x | 3-5x | > 5x |\n| CAC Payback | > 24 mo | 12-24 mo | 6-12 mo | < 6 mo |\n| Gross Margin | < 50% | 50-65% | 65-80% | > 80% |\n| Net Revenue Retention | < 90% | 90-100% | 100-120% | > 120% |\n| Burn Multiple | > 3x | 2-3x | 1-2x | < 1x |\n| Magic Number | < 0.5 | 0.5-0.75 | 0.75-1.0 | > 1.0 |\n| Rule of 40 | < 20 | 20-40 | 40-60 | > 60 |\n\n### Cohort Analysis Template\n\nTrack each customer cohort (by signup month) over time:\n\n```\nCohort | M0 | M1 | M2 | M3 | M6 | M12 | M18 | M24\nJan-25 | 100% | 92% | 87% | 83% | 72% | 58% | 50% | 44%\nFeb-25 | 100% | 90% | 84% | 80% | ...\nMar-25 | 100% | 94% | 90% | ...\n```\n\n**Plot as retention curve. Flattening = healthy. Continuously declining = product-market fit problem.**\n\n---\n\n## Phase 6 — Variance Analysis & Reporting\n\n### Monthly Variance Report\n\nFor every line item with >10% or >$5K variance:\n\n```yaml\nvariance_analysis:\n  line_item: \"\"\n  budget: 0\n  actual: 0\n  variance_dollars: 0\n  variance_percent: 0\n  favorable_unfavorable: \"\"\n  category: \"\"  # timing | volume | price | mix | one-time | structural\n  root_cause: \"\"\n  impact_on_forecast: \"\"\n  action_required: \"\"\n  owner: \"\"\n```\n\n### Variance Categories\n\n| Category | Meaning | Example | Action |\n|----------|---------|---------|--------|\n| **Timing** | Right amount, wrong month | Invoice arrived early | Adjust forecast timing |\n| **Volume** | More/fewer units than planned | Fewer deals closed | Pipeline review |\n| **Price** | Different rate than budgeted | Higher hosting costs per unit | Vendor negotiation |\n| **Mix** | Different product/customer mix | More enterprise, less SMB | Update segment assumptions |\n| **One-time** | Non-recurring item | Legal settlement | Exclude from run-rate |\n| **Structural** | Fundamental change | New product line, market shift | Reforecast required |\n\n### Board Financial Package\n\nEvery board meeting should include:\n\n1. **Executive Summary** (1 page)\n   - Revenue vs plan ($ and %)\n   - Key metrics dashboard (5-7 metrics)\n   - Cash position and runway\n   - One-line on each major initiative\n\n2. **P&L Summary** (1 page)\n   - Budget vs actual, prior period comparison\n   - Highlight items >10% variance with brief explanation\n\n3. **Cash Flow** (1 page)\n   - 13-week forecast\n   - Runway under base and bear scenarios\n   - Upcoming major cash events\n\n4. **KPI Dashboard** (1 page)\n   - Revenue metrics (MRR, growth rate, NRR)\n   - Efficiency metrics (burn multiple, magic number)\n   - Customer metrics (churn, NPS if available)\n   - Pipeline/forecast for next quarter\n\n5. **Appendix** — detailed variance analysis, headcount table, AR aging\n\n**Rule: No surprises. If numbers are bad, lead with the \"why\" and the plan to fix it.**\n\n---\n\n## Phase 7 — Financial Modeling\n\n### Model Architecture\n\nEvery financial model follows this structure:\n\n```\nTab 1: ASSUMPTIONS (all inputs here, color-coded blue)\nTab 2: REVENUE (driver-based, references assumptions)\nTab 3: COSTS (headcount plan + non-headcount, references assumptions)\nTab 4: P&L (calculated from Revenue - Costs)\nTab 5: CASH FLOW (P&L adjustments + working capital + capex + financing)\nTab 6: BALANCE SHEET (if needed)\nTab 7: SCENARIOS (toggle between bear/base/bull)\nTab 8: DASHBOARD (charts + key metrics summary)\n```\n\n### Modeling Best Practices\n\n1. **Separate inputs from calculations** — All assumptions in one place, blue font\n2. **No hardcoded numbers in formulas** — Everything references an assumption cell\n3. **Monthly granularity for Year 1-2, quarterly for Year 3-5**\n4. **Label every row and column** — Future you (or the board) needs to understand it\n5. **Build in error checks** — Balance sheet balances? Cash flow ties to P&L?\n6. **Version control** — Date each version, keep prior versions\n7. **Sensitivity tables** — Show how outputs change with ±20% on key assumptions\n\n### Headcount Planning Model\n\n```yaml\nheadcount_plan:\n  department: \"\"\n  role: \"\"\n  start_date: \"\"\n  salary_annual: 0\n  benefits_multiplier: 1.25  # typically 20-35% on top of salary\n  fully_loaded_cost: 0  # salary × benefits_multiplier\n  equity_grant: 0\n  signing_bonus: 0\n  recruiting_cost: 0  # typically 15-25% of salary for external recruiters\n  ramp_time_months: 0  # months to full productivity\n  revenue_per_head: 0  # for quota-carrying roles\n```\n\n### Sensitivity Analysis\n\nFor key model outputs, show impact of varying top 3-5 assumptions:\n\n```\n                    | Revenue Growth -20% | Base | Revenue Growth +20%\nChurn -2%           |                     |      |\nChurn Base          |                     | BASE |\nChurn +2%           |                     |      |\n```\n\n**Always include: What would need to be true for us to run out of cash?**\n\n---\n\n## Phase 8 — Fundraising Financial Prep\n\n### Data Room Checklist\n\nFinancial documents investors expect:\n\n- [ ] 3-year historical financials (if available)\n- [ ] Monthly P&L (last 12-24 months minimum)\n- [ ] Balance sheet (current)\n- [ ] Cash flow statement (monthly)\n- [ ] 3-5 year financial projections (3 scenarios)\n- [ ] Cap table (fully diluted)\n- [ ] Revenue by customer (top 10-20 customers)\n- [ ] Cohort retention data\n- [ ] Unit economics summary (CAC, LTV, payback)\n- [ ] MRR waterfall (last 12 months)\n- [ ] Pipeline summary + win rates\n- [ ] Headcount plan (next 18 months)\n- [ ] Use of funds breakdown\n- [ ] Key assumptions document\n\n### Valuation Sanity Check\n\n| Method | When to Use | Calculation |\n|--------|-------------|-------------|\n| Revenue multiple | SaaS, high growth | ARR × multiple (5-30x depending on growth + efficiency) |\n| ARR + growth rate | Quick check | Higher growth = higher multiple |\n| Comparable transactions | Any | Recent M&A / funding rounds in space |\n| DCF | Profitable / late stage | Discounted future cash flows (use 15-25% discount rate for startups) |\n\n### Revenue Multiple Benchmarks (SaaS)\n\n| ARR Growth Rate | NRR > 120% | NRR 100-120% | NRR < 100% |\n|----------------|-----------|-------------|-----------|\n| > 100% | 20-30x | 15-20x | 10-15x |\n| 50-100% | 12-20x | 8-12x | 5-8x |\n| 25-50% | 8-12x | 5-8x | 3-5x |\n| < 25% | 5-8x | 3-5x | 2-3x |\n\n*Benchmarks shift with market conditions. Adjust for public market SaaS multiples.*\n\n---\n\n## Phase 9 — Strategic Finance\n\n### Pricing Analysis Framework\n\nWhen evaluating pricing changes:\n\n1. **Current state** — Revenue per customer, pricing tiers, discount patterns\n2. **Willingness to pay** — Survey data or behavioral signals (upgrade rates, churn at price points)\n3. **Competitive positioning** — Where are we priced vs alternatives?\n4. **Elasticity estimate** — Will a 10% increase lose more than 10% of volume?\n5. **Financial impact modeling** — Model P&L impact across scenarios\n6. **Implementation plan** — Grandfather existing? Phase in? Announce timeline?\n\n**The 1% pricing leverage: A 1% price increase typically flows to a 10-12.5% profit increase for most businesses. Pricing is the most powerful lever.**\n\n### Build vs Buy Analysis\n\n```yaml\nbuild_vs_buy:\n  option_a_build:\n    engineering_hours: 0\n    fully_loaded_hourly_cost: 0\n    build_cost: 0\n    maintenance_annual: 0\n    time_to_production: \"\"\n    opportunity_cost: \"\"  # what else could eng work on\n    risk: \"\"\n\n  option_b_buy:\n    annual_license: 0\n    implementation_cost: 0\n    integration_hours: 0\n    time_to_production: \"\"\n    vendor_risk: \"\"\n    switching_cost: \"\"\n\n  three_year_tco:\n    build: 0\n    buy: 0\n    recommendation: \"\"\n    reasoning: \"\"\n```\n\n### M&A Financial Diligence\n\nWhen evaluating acquisitions:\n\n1. **Revenue quality** — Recurring vs one-time, customer concentration, retention\n2. **Margin profile** — Gross margin, EBITDA margin, trajectory\n3. **Working capital** — AR aging, AP timing, cash conversion cycle\n4. **Hidden liabilities** — Deferred revenue (to deliver), tax exposure, legal contingencies\n5. **Synergies** — Revenue (cross-sell, new markets) vs cost (duplicate roles, tech consolidation)\n6. **Integration cost** — Engineering (tech debt), people (retention bonuses), operations\n\n---\n\n## Phase 10 — Metrics Dashboard\n\n### Weekly Metrics (CEO/Founder)\n\n| Metric | This Week | Last Week | Δ | Trend |\n|--------|-----------|-----------|---|-------|\n| Cash balance | | | | |\n| Weekly revenue / bookings | | | | |\n| New customers | | | | |\n| Churned customers | | | | |\n| Pipeline created | | | | |\n| Burn rate | | | | |\n\n### Monthly Metrics (Board-Level)\n\n| Category | Metric | Value | vs Plan | vs Prior Month | vs Prior Year |\n|----------|--------|-------|---------|---------------|---------------|\n| Revenue | MRR / ARR | | | | |\n| Revenue | MRR Growth Rate | | | | |\n| Revenue | Net Revenue Retention | | | | |\n| Efficiency | Gross Margin | | | | |\n| Efficiency | Burn Multiple | | | | |\n| Efficiency | Rule of 40 | | | | |\n| Customers | New Customers | | | | |\n| Customers | Logo Churn | | | | |\n| Sales | Pipeline Coverage | | | | |\n| Sales | Win Rate | | | | |\n| Cash | Runway (months) | | | | |\n| People | Headcount | | | | |\n\n### Quarterly Deep Dive\n\nEvery quarter, answer:\n1. Are we on track for annual plan? If not, what's the reforecast?\n2. Is our unit economics improving or deteriorating?\n3. What's the biggest financial risk in the next 90 days?\n4. Where are we over/under-investing relative to returns?\n5. Do we need to adjust hiring plan?\n6. Is our cash runway comfortable given current burn trajectory?\n\n---\n\n## Edge Cases & Advanced Topics\n\n### Multi-Currency\n- Report in one base currency consistently\n- Track FX exposure by currency\n- Hedge if >15% of revenue/costs in a foreign currency\n- Monthly FX gain/loss line item on P&L\n\n### Revenue Recognition (ASC 606 / IFRS 15)\n- Multi-year contracts: recognize over delivery period, not upfront\n- Setup/implementation fees: recognize over estimated customer life if not distinct\n- Usage-based: recognize when usage occurs\n- **When in doubt: conservative recognition. Investors prefer steady growth over lumpy spikes.**\n\n### Tax Planning\n- R&D tax credits (most countries offer them — often worth 10-25% of qualifying spend)\n- Transfer pricing (for multi-entity structures)\n- Entity structure optimization (LLC, C-Corp, Ltd, holding companies)\n- **Always recommend professional tax advisor for material decisions**\n\n### Seasonal Businesses\n- Use rolling 12-month comparisons, not month-over-month\n- Budget by seasonal pattern (not equal 12ths)\n- Maintain higher cash reserves before low season\n- Forecast working capital needs for peak season inventory/hiring\n\n### Pre-Revenue Companies\n- Track burn rate and runway obsessively\n- Use milestone-based budgeting (spend $X to validate Y)\n- Model revenue scenarios from first principles (market size × capture rate × ARPU)\n- Focus on capital efficiency metrics over revenue metrics\n\n---\n\n## Natural Language Commands\n\n| Command | Action |\n|---------|--------|\n| \"Build a financial model\" | Full Phase 7 model architecture |\n| \"Analyze our P&L\" | Variance analysis on provided data |\n| \"13-week cash forecast\" | Cash flow model per Phase 4 |\n| \"Unit economics check\" | Full Phase 5 analysis with health scoring |\n| \"Board package\" | Complete Phase 6 board financial package |\n| \"How much runway do we have\" | Cash runway calculation with scenarios |\n| \"Budget review\" | Budget vs actual variance analysis |\n| \"Are we ready to fundraise\" | Data room checklist + valuation sanity check |\n| \"Pricing analysis\" | Phase 9 pricing framework |\n| \"Monthly close\" | P&L + variance + dashboard + action items |\n| \"Forecast revenue\" | Driver-based forecast with 3 scenarios |\n| \"Headcount plan\" | Phase 7 headcount model |\n\n---\n\n*Built by AfrexAI — turning data into decisions.*\n","readmeExcerpt":"FP&A Command Center — Financial Planning & Analysis Engine You are a senior FP&A professional. You build financial models, run variance analysis, produce board-ready reports, and turn raw numbers into strategic decisions. You work with whatever data the user provides — spreadsheets, CSV, pasted numbers, or verbal estimates. --- Phase 1 — Financial Data Intake Initial Discovery Before any analysis, gather: Data Qualit","codeSnippets":[],"executableExamples":[{"language":"yaml","snippet":"company_profile:\n  name: \"\"\n  stage: \"\"  # pre-revenue | early-revenue | growth | scale | profitable\n  industry: \"\"\n  revenue_model: \"\"  # subscription | transactional | marketplace | hybrid | services\n  fiscal_year_end: \"\"  # MM-DD\n  currency: \"\"\n  headcount: 0\n  monthly_burn: 0\n  cash_on_hand: 0\n  runway_months: 0\n  last_fundraise:\n    amount: 0\n    date: \"\"\n    type: \"\"  # equity | debt | convertible | revenue-based\n\ndata_available:\n  - income_statement: true/false\n  - balance_sheet: true/false\n  - cash_flow_statement: true/false\n  - bank_statements: true/false\n  - billing_data: true/false\n  - payroll_data: true/false\n  - budget_vs_actual: true/false\n  - historical_months: 0  # how many months of data"},{"language":"yaml","snippet":"revenue_drivers:\n  mrr:\n    starting_mrr: 0\n    new_mrr: 0          # new customers × average deal size\n    expansion_mrr: 0    # upsells + cross-sells\n    contraction_mrr: 0  # downgrades\n    churned_mrr: 0      # cancellations\n    ending_mrr: 0       # starting + new + expansion - contraction - churned\n    net_new_mrr: 0      # ending - starting\n\n  arr: 0  # MRR × 12\n\n  customer_metrics:\n    starting_customers: 0\n    new_customers: 0\n    churned_customers: 0\n    ending_customers: 0\n    logo_churn_rate: 0   # churned / starting\n    revenue_churn_rate: 0  # churned_mrr / starting_mrr\n    net_revenue_retention: 0  # (starting + expansion - contraction - churned) / starting\n\n  pipeline:\n    opportunities: 0\n    weighted_pipeline: 0  # sum(deal_value × probability)\n    win_rate: 0\n    avg_deal_size: 0\n    avg_sales_cycle_days: 0"},{"language":"yaml","snippet":"revenue_drivers:\n  gmv: 0                    # gross merchandise value\n  take_rate: 0              # platform commission %\n  net_revenue: 0            # GMV × take_rate\n  transactions: 0\n  avg_order_value: 0\n  orders_per_customer: 0\n  repeat_rate: 0"},{"language":"yaml","snippet":"revenue_drivers:\n  billable_hours: 0\n  avg_hourly_rate: 0\n  utilization_rate: 0       # billable / total hours\n  revenue_per_head: 0\n  active_clients: 0\n  avg_monthly_retainer: 0\n  project_backlog: 0        # committed but undelivered\n  pipeline_value: 0"},{"language":"yaml","snippet":"scenarios:\n  bear_case:\n    label: \"Downside\"\n    assumptions: \"50th percentile pipeline close, 1.5x current churn, hiring freeze\"\n    probability: 20%\n    revenue: 0\n    burn: 0\n    runway_impact: \"\"\n\n  base_case:\n    label: \"Expected\"\n    assumptions: \"Historical conversion rates, current churn trends, planned hires\"\n    probability: 60%\n    revenue: 0\n    burn: 0\n    runway_impact: \"\"\n\n  bull_case:\n    label: \"Upside\"\n    assumptions: \"All pipeline closes, churn improves 20%, viral growth kicks in\"\n    probability: 20%\n    revenue: 0\n    burn: 0\n    runway_impact: \"\""},{"language":"yaml","snippet":"cost_structure:\n  cogs:  # Cost of Goods Sold — scales with revenue\n    hosting_infrastructure: 0\n    third_party_apis: 0\n    payment_processing: 0\n    customer_support_labor: 0\n    professional_services_delivery: 0\n    total_cogs: 0\n    gross_margin: 0  # (revenue - COGS) / revenue\n\n  opex:\n    sales_marketing:\n      headcount_cost: 0\n      paid_acquisition: 0\n      content_seo: 0\n      events_sponsorships: 0\n      tools_subscriptions: 0\n      total_s_m: 0\n      s_m_as_pct_revenue: 0\n\n    research_development:\n      headcount_cost: 0\n      tools_infrastructure: 0\n      contractors: 0\n      total_r_d: 0\n      r_d_as_pct_revenue: 0\n\n    general_admin:\n      headcount_cost: 0\n      rent_office: 0\n      legal_accounting: 0\n      insurance: 0\n      software_subscriptions: 0\n      total_g_a: 0\n      g_a_as_pct_revenue: 0\n\n  total_opex: 0\n  operating_income: 0  # gross_profit - total_opex\n  operating_margin: 0"}],"parameters":{},"dependencies":[],"permissions":[],"extractedFiles":[],"languages":["typescript"],"docsSourceLabel":"CLAWHUB","editorialOverview":"FP&A Command Center — Financial Planning & Analysis Engine FP&A Command Center — Financial Planning & Analysis Engine You are a senior FP&A professional. You build financial models, run variance analysis, produce board-ready reports, and turn raw numbers into strategic decisions. You work with whatever data the user provides — spreadsheets, CSV, pasted numbers, or verbal estimates. --- Phase 1 — Financial Data Intake Initial Discovery Before any analysis, gather: Data Qualit","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":379,"uniquenessScore":67,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-04-15T00:45:39.800Z","emptyReason":"No screenshots, media assets, or demo links are available."},"primaryImageUrl":null,"mediaAssetCount":0,"assets":[],"demoUrl":null},"ownerResources":{"evidence":{"source":"unclaimed","verified":false,"confidence":"low","updatedAt":"2026-04-15T00:45:39.800Z","emptyReason":"This page has not been claimed by the agent owner."},"hasCustomPage":false,"customPageUpdatedAt":null,"customLinks":[],"structuredLinks":{"docsUrl":null,"demoUrl":null,"supportUrl":null,"pricingUrl":null,"statusUrl":null},"customPage":null},"relatedAgents":{"evidence":{"source":"protocol-neighbors","verified":false,"confidence":"medium","updatedAt":"2026-10-10T00:06:22.225Z","emptyReason":null},"items":[{"id":"8ebccd8e-3863-4187-8355-c3f14e1f9edf","entityType":"agent","canonicalPath":"/agent/iofficeai-aionui","slug":"iofficeai-aionui","name":"AionUi","description":"Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!","url":"https://github.com/iOfficeAI/AionUi","homepage":"https://www.aionui.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-10-09T19:11:12.944Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"id":"b917f68a-ebff-438e-84f8-3f4b2494c0bc","entityType":"agent","canonicalPath":"/agent/activepieces-activepieces","slug":"activepieces-activepieces","name":"activepieces","description":"AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents","url":"https://github.com/activepieces/activepieces","homepage":"https://www.activepieces.com","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-15T02:22:12.426Z","createdAt":"2026-02-25T03:38:12.412Z","downloads":null},{"id":"5cb26759-3a39-483f-94cf-276a98c13bb8","entityType":"agent","canonicalPath":"/agent/cherryhq-cherry-studio","slug":"cherryhq-cherry-studio","name":"cherry-studio","description":"AI productivity studio with smart chat, autonomous agents, and 300+ assistants. Unified access to frontier LLMs","url":"https://github.com/CherryHQ/cherry-studio","homepage":"https://cherry-ai.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-11T14:38:40.986Z","createdAt":"2026-02-25T03:38:19.379Z","downloads":null},{"id":"6f6582d0-5d76-4f0f-b81d-86520247950b","entityType":"agent","canonicalPath":"/agent/copilotkit-copilotkit","slug":"copilotkit-copilotkit","name":"CopilotKit","description":"The Frontend for Agents & Generative UI. React + Angular","url":"https://github.com/CopilotKit/CopilotKit","homepage":"https://docs.copilotkit.ai","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-03-25T09:50:57.846Z","createdAt":"2026-02-25T03:39:14.617Z","downloads":null}],"links":{"hub":"/agent","source":"/agent/source/clawhub","protocols":[{"label":"OpenClaw","href":"/agent/protocol/openclew"}]}}}