FP&A Engine

Build and analyze financial models from diverse data, produce variance reports, and create multi-scenario forecasts for strategic FP&A decisions.

Audits

Pass

ClawScanPass

Agentic behavior and permission review.

Static analysisPass

Pattern checks against bundled files.

VirusTotalPass

Multi-engine malware detections and file reputation.

Install

openclaw skills install afrexai-fpa-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:

company_profile:
  name: ""
  stage: ""  # pre-revenue | early-revenue | growth | scale | profitable
  industry: ""
  revenue_model: ""  # subscription | transactional | marketplace | hybrid | services
  fiscal_year_end: ""  # MM-DD
  currency: ""
  headcount: 0
  monthly_burn: 0
  cash_on_hand: 0
  runway_months: 0
  last_fundraise:
    amount: 0
    date: ""
    type: ""  # equity | debt | convertible | revenue-based

data_available:
  - income_statement: true/false
  - balance_sheet: true/false
  - cash_flow_statement: true/false
  - bank_statements: true/false
  - billing_data: true/false
  - payroll_data: true/false
  - budget_vs_actual: true/false
  - historical_months: 0  # how many months of data

Data Quality Assessment

Score data quality (1-5) across:

Dimension	Score	Notes
Completeness	_ /5	Missing fields, gaps in time series
Accuracy	_ /5	Reconciliation issues, rounding errors
Timeliness	_ /5	How recent is the data
Granularity	_ /5	Line-item detail vs aggregated
Consistency	_ /5	Same definitions across periods

Data quality < 3 average → flag issues before proceeding. Garbage in = garbage out.

Phase 2 — Revenue Model & Forecasting

SaaS / Subscription Revenue Model

revenue_drivers:
  mrr:
    starting_mrr: 0
    new_mrr: 0          # new customers × average deal size
    expansion_mrr: 0    # upsells + cross-sells
    contraction_mrr: 0  # downgrades
    churned_mrr: 0      # cancellations
    ending_mrr: 0       # starting + new + expansion - contraction - churned
    net_new_mrr: 0      # ending - starting

  arr: 0  # MRR × 12

  customer_metrics:
    starting_customers: 0
    new_customers: 0
    churned_customers: 0
    ending_customers: 0
    logo_churn_rate: 0   # churned / starting
    revenue_churn_rate: 0  # churned_mrr / starting_mrr
    net_revenue_retention: 0  # (starting + expansion - contraction - churned) / starting

  pipeline:
    opportunities: 0
    weighted_pipeline: 0  # sum(deal_value × probability)
    win_rate: 0
    avg_deal_size: 0
    avg_sales_cycle_days: 0

Transactional / Marketplace Revenue Model

revenue_drivers:
  gmv: 0                    # gross merchandise value
  take_rate: 0              # platform commission %
  net_revenue: 0            # GMV × take_rate
  transactions: 0
  avg_order_value: 0
  orders_per_customer: 0
  repeat_rate: 0

Services Revenue Model

revenue_drivers:
  billable_hours: 0
  avg_hourly_rate: 0
  utilization_rate: 0       # billable / total hours
  revenue_per_head: 0
  active_clients: 0
  avg_monthly_retainer: 0
  project_backlog: 0        # committed but undelivered
  pipeline_value: 0

Forecasting Methods

Choose based on data maturity:

Method	When to Use	Accuracy
Bottom-up	Sales pipeline exists, 6+ months of data	High
Top-down	Market sizing approach, early stage	Low-Medium
Driver-based	Known input→output relationships	High
Cohort-based	Subscription, strong retention data	Very High
Regression	18+ months of data, identifiable patterns	Medium-High
Scenario	High uncertainty, board presentations	N/A (range)

Three-Scenario Framework

Always produce three scenarios:

scenarios:
  bear_case:
    label: "Downside"
    assumptions: "50th percentile pipeline close, 1.5x current churn, hiring freeze"
    probability: 20%
    revenue: 0
    burn: 0
    runway_impact: ""

  base_case:
    label: "Expected"
    assumptions: "Historical conversion rates, current churn trends, planned hires"
    probability: 60%
    revenue: 0
    burn: 0
    runway_impact: ""

  bull_case:
    label: "Upside"
    assumptions: "All pipeline closes, churn improves 20%, viral growth kicks in"
    probability: 20%
    revenue: 0
    burn: 0
    runway_impact: ""

Rule: Base case should be achievable 60-70% of the time. If you're hitting bull case regularly, your model is too conservative.

Phase 3 — Cost Structure & Budgeting

Cost Categories

cost_structure:
  cogs:  # Cost of Goods Sold — scales with revenue
    hosting_infrastructure: 0
    third_party_apis: 0
    payment_processing: 0
    customer_support_labor: 0
    professional_services_delivery: 0
    total_cogs: 0
    gross_margin: 0  # (revenue - COGS) / revenue

  opex:
    sales_marketing:
      headcount_cost: 0
      paid_acquisition: 0
      content_seo: 0
      events_sponsorships: 0
      tools_subscriptions: 0
      total_s_m: 0
      s_m_as_pct_revenue: 0

    research_development:
      headcount_cost: 0
      tools_infrastructure: 0
      contractors: 0
      total_r_d: 0
      r_d_as_pct_revenue: 0

    general_admin:
      headcount_cost: 0
      rent_office: 0
      legal_accounting: 0
      insurance: 0
      software_subscriptions: 0
      total_g_a: 0
      g_a_as_pct_revenue: 0

  total_opex: 0
  operating_income: 0  # gross_profit - total_opex
  operating_margin: 0

Budget Process

Annual budget cycle (4 steps):

Top-down targets (CEO/Board) — Revenue goal, margin targets, headcount ceiling
Bottom-up requests (Department heads) — Itemized spend needs with justification
Negotiation — Reconcile gap between top-down and bottom-up
Approval & lock — Final budget, documented assumptions, quarterly reforecast cadence

Budget Template (Monthly)

Line Item	Jan Budget	Jan Actual	Variance $	Variance %	YTD Budget	YTD Actual	YTD Var %
Revenue
COGS
Gross Profit
S&M
R&D
G&A
EBITDA

Zero-Based Budgeting (ZBB)

Use when: costs feel bloated, post-fundraise spending, or annual reset.

For each line item, justify from zero:

What is this spend? (specific vendor/purpose)
What happens if we cut it entirely?
What's the minimum viable spend?
What's the ROI at current spend level?
Decision: KEEP / REDUCE / CUT / INVEST MORE

Phase 4 — Cash Flow Management

13-Week Cash Flow Forecast

Week | Opening | AR Collections | Other In | Payroll | Rent | Vendors | Other Out | Net | Closing | Notes
1    |         |                |          |         |      |         |           |     |         |
2    |         |                |          |         |      |         |           |     |         |
...
13   |         |                |          |         |      |         |           |     |         |

Update weekly. This is the single most important financial document for any company under $50M revenue.

Cash Flow Rules

Revenue ≠ cash. Accrual revenue recognition ≠ when money hits the bank
Collect fast, pay slow — Net 15 terms for AR, Net 45 for AP (but don't damage relationships)
Track days sales outstanding (DSO) — Target < 45 days. Over 60 = collections problem
Track days payable outstanding (DPO) — Extending beyond terms? Cash crunch signal
Maintain 3-6 month runway minimum — Below 3 months = emergency mode
Separate operating cash from reserves — Don't commingle runway money with operating account

Cash Runway Calculation

Simple: Cash on hand / Monthly net burn = Months of runway

Adjusted: (Cash + committed AR - committed AP - upcoming one-time costs) / Avg net burn (3-month trailing)

Scenario-adjusted: Use bear case burn rate, not base case

Working Capital Optimization

Lever	Action	Impact
AR acceleration	Annual prepay discounts (10-20% off), upfront billing	+Cash now
AP management	Negotiate Net 60, batch payments weekly	-Cash out slower
Inventory (if applicable)	JIT ordering, consignment	-Cash tied up
Deposit collection	50% upfront for services	+Cash now
Expense timing	Quarterly→monthly billing for SaaS tools	Smoother outflow

Phase 5 — Unit Economics

SaaS Unit Economics

unit_economics:
  cac:
    total_s_m_spend: 0
    new_customers_acquired: 0
    cac: 0  # total_s_m / new_customers
    cac_payback_months: 0  # CAC / (avg_mrr × gross_margin)

  ltv:
    avg_mrr: 0
    gross_margin: 0
    avg_customer_lifetime_months: 0  # 1 / monthly_churn_rate
    ltv: 0  # avg_mrr × gross_margin × avg_lifetime_months

  ltv_cac_ratio: 0  # LTV / CAC — target > 3x
  
  magic_number: 0  # net_new_ARR / prior_quarter_S&M — target > 0.75
  
  burn_multiple: 0  # net_burn / net_new_ARR — target < 2x (good), < 1x (excellent)
  
  rule_of_40: 0  # revenue_growth_% + profit_margin_% — target > 40

Unit Economics Health Check

Metric	🔴 Danger	🟡 OK	🟢 Healthy	🔵 Excellent
LTV/CAC	< 1x	1-3x	3-5x	> 5x
CAC Payback	> 24 mo	12-24 mo	6-12 mo	< 6 mo
Gross Margin	< 50%	50-65%	65-80%	> 80%
Net Revenue Retention	< 90%	90-100%	100-120%	> 120%
Burn Multiple	> 3x	2-3x	1-2x	< 1x
Magic Number	< 0.5	0.5-0.75	0.75-1.0	> 1.0
Rule of 40	< 20	20-40	40-60	> 60

Cohort Analysis Template

Track each customer cohort (by signup month) over time:

Cohort | M0 | M1 | M2 | M3 | M6 | M12 | M18 | M24
Jan-25 | 100% | 92% | 87% | 83% | 72% | 58% | 50% | 44%
Feb-25 | 100% | 90% | 84% | 80% | ...
Mar-25 | 100% | 94% | 90% | ...

Plot as retention curve. Flattening = healthy. Continuously declining = product-market fit problem.

Phase 6 — Variance Analysis & Reporting

Monthly Variance Report

For every line item with >10% or >$5K variance:

variance_analysis:
  line_item: ""
  budget: 0
  actual: 0
  variance_dollars: 0
  variance_percent: 0
  favorable_unfavorable: ""
  category: ""  # timing | volume | price | mix | one-time | structural
  root_cause: ""
  impact_on_forecast: ""
  action_required: ""
  owner: ""

Variance Categories

Category	Meaning	Example	Action
Timing	Right amount, wrong month	Invoice arrived early	Adjust forecast timing
Volume	More/fewer units than planned	Fewer deals closed	Pipeline review
Price	Different rate than budgeted	Higher hosting costs per unit	Vendor negotiation
Mix	Different product/customer mix	More enterprise, less SMB	Update segment assumptions
One-time	Non-recurring item	Legal settlement	Exclude from run-rate
Structural	Fundamental change	New product line, market shift	Reforecast required

Board Financial Package

Every board meeting should include:

Executive Summary (1 page)
- Revenue vs plan ($ and %)
- Key metrics dashboard (5-7 metrics)
- Cash position and runway
- One-line on each major initiative
P&L Summary (1 page)
- Budget vs actual, prior period comparison
- Highlight items >10% variance with brief explanation
Cash Flow (1 page)
- 13-week forecast
- Runway under base and bear scenarios
- Upcoming major cash events
KPI Dashboard (1 page)
- Revenue metrics (MRR, growth rate, NRR)
- Efficiency metrics (burn multiple, magic number)
- Customer metrics (churn, NPS if available)
- Pipeline/forecast for next quarter
Appendix — detailed variance analysis, headcount table, AR aging

Rule: No surprises. If numbers are bad, lead with the "why" and the plan to fix it.

Phase 7 — Financial Modeling

Model Architecture

Every financial model follows this structure:

Tab 1: ASSUMPTIONS (all inputs here, color-coded blue)
Tab 2: REVENUE (driver-based, references assumptions)
Tab 3: COSTS (headcount plan + non-headcount, references assumptions)
Tab 4: P&L (calculated from Revenue - Costs)
Tab 5: CASH FLOW (P&L adjustments + working capital + capex + financing)
Tab 6: BALANCE SHEET (if needed)
Tab 7: SCENARIOS (toggle between bear/base/bull)
Tab 8: DASHBOARD (charts + key metrics summary)

Modeling Best Practices

Separate inputs from calculations — All assumptions in one place, blue font
No hardcoded numbers in formulas — Everything references an assumption cell
Monthly granularity for Year 1-2, quarterly for Year 3-5
Label every row and column — Future you (or the board) needs to understand it
Build in error checks — Balance sheet balances? Cash flow ties to P&L?
Version control — Date each version, keep prior versions
Sensitivity tables — Show how outputs change with ±20% on key assumptions

Headcount Planning Model

headcount_plan:
  department: ""
  role: ""
  start_date: ""
  salary_annual: 0
  benefits_multiplier: 1.25  # typically 20-35% on top of salary
  fully_loaded_cost: 0  # salary × benefits_multiplier
  equity_grant: 0
  signing_bonus: 0
  recruiting_cost: 0  # typically 15-25% of salary for external recruiters
  ramp_time_months: 0  # months to full productivity
  revenue_per_head: 0  # for quota-carrying roles

Sensitivity Analysis

For key model outputs, show impact of varying top 3-5 assumptions:

                    | Revenue Growth -20% | Base | Revenue Growth +20%
Churn -2%           |                     |      |
Churn Base          |                     | BASE |
Churn +2%           |                     |      |

Always include: What would need to be true for us to run out of cash?

Phase 8 — Fundraising Financial Prep

Data Room Checklist

Financial documents investors expect:

Valuation Sanity Check

Method	When to Use	Calculation
Revenue multiple	SaaS, high growth	ARR × multiple (5-30x depending on growth + efficiency)
ARR + growth rate	Quick check	Higher growth = higher multiple
Comparable transactions	Any	Recent M&A / funding rounds in space
DCF	Profitable / late stage	Discounted future cash flows (use 15-25% discount rate for startups)

Revenue Multiple Benchmarks (SaaS)

ARR Growth Rate	NRR > 120%	NRR 100-120%	NRR < 100%
> 100%	20-30x	15-20x	10-15x
50-100%	12-20x	8-12x	5-8x
25-50%	8-12x	5-8x	3-5x
< 25%	5-8x	3-5x	2-3x

Benchmarks shift with market conditions. Adjust for public market SaaS multiples.

Phase 9 — Strategic Finance

Pricing Analysis Framework

When evaluating pricing changes:

Current state — Revenue per customer, pricing tiers, discount patterns
Willingness to pay — Survey data or behavioral signals (upgrade rates, churn at price points)
Competitive positioning — Where are we priced vs alternatives?
Elasticity estimate — Will a 10% increase lose more than 10% of volume?
Financial impact modeling — Model P&L impact across scenarios
Implementation plan — Grandfather existing? Phase in? Announce timeline?

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.

Build vs Buy Analysis

build_vs_buy:
  option_a_build:
    engineering_hours: 0
    fully_loaded_hourly_cost: 0
    build_cost: 0
    maintenance_annual: 0
    time_to_production: ""
    opportunity_cost: ""  # what else could eng work on
    risk: ""

  option_b_buy:
    annual_license: 0
    implementation_cost: 0
    integration_hours: 0
    time_to_production: ""
    vendor_risk: ""
    switching_cost: ""

  three_year_tco:
    build: 0
    buy: 0
    recommendation: ""
    reasoning: ""

M&A Financial Diligence

When evaluating acquisitions:

Revenue quality — Recurring vs one-time, customer concentration, retention
Margin profile — Gross margin, EBITDA margin, trajectory
Working capital — AR aging, AP timing, cash conversion cycle
Hidden liabilities — Deferred revenue (to deliver), tax exposure, legal contingencies
Synergies — Revenue (cross-sell, new markets) vs cost (duplicate roles, tech consolidation)
Integration cost — Engineering (tech debt), people (retention bonuses), operations

Phase 10 — Metrics Dashboard

Weekly Metrics (CEO/Founder)

Metric	This Week	Last Week	Δ	Trend
Cash balance
Weekly revenue / bookings
New customers
Churned customers
Pipeline created
Burn rate

Monthly Metrics (Board-Level)

Category	Metric	Value	vs Plan	vs Prior Month	vs Prior Year
Revenue	MRR / ARR
Revenue	MRR Growth Rate
Revenue	Net Revenue Retention
Efficiency	Gross Margin
Efficiency	Burn Multiple
Efficiency	Rule of 40
Customers	New Customers
Customers	Logo Churn
Sales	Pipeline Coverage
Sales	Win Rate
Cash	Runway (months)
People	Headcount

Quarterly Deep Dive

Every quarter, answer:

Are we on track for annual plan? If not, what's the reforecast?
Is our unit economics improving or deteriorating?
What's the biggest financial risk in the next 90 days?
Where are we over/under-investing relative to returns?
Do we need to adjust hiring plan?
Is our cash runway comfortable given current burn trajectory?

Edge Cases & Advanced Topics

Multi-Currency

Report in one base currency consistently
Track FX exposure by currency
Hedge if >15% of revenue/costs in a foreign currency
Monthly FX gain/loss line item on P&L

Revenue Recognition (ASC 606 / IFRS 15)

Multi-year contracts: recognize over delivery period, not upfront
Setup/implementation fees: recognize over estimated customer life if not distinct
Usage-based: recognize when usage occurs
When in doubt: conservative recognition. Investors prefer steady growth over lumpy spikes.

Tax Planning

R&D tax credits (most countries offer them — often worth 10-25% of qualifying spend)
Transfer pricing (for multi-entity structures)
Entity structure optimization (LLC, C-Corp, Ltd, holding companies)
Always recommend professional tax advisor for material decisions

Seasonal Businesses

Use rolling 12-month comparisons, not month-over-month
Budget by seasonal pattern (not equal 12ths)
Maintain higher cash reserves before low season
Forecast working capital needs for peak season inventory/hiring

Pre-Revenue Companies

Track burn rate and runway obsessively
Use milestone-based budgeting (spend $X to validate Y)
Model revenue scenarios from first principles (market size × capture rate × ARPU)
Focus on capital efficiency metrics over revenue metrics

Natural Language Commands

Command	Action
"Build a financial model"	Full Phase 7 model architecture
"Analyze our P&L"	Variance analysis on provided data
"13-week cash forecast"	Cash flow model per Phase 4
"Unit economics check"	Full Phase 5 analysis with health scoring
"Board package"	Complete Phase 6 board financial package
"How much runway do we have"	Cash runway calculation with scenarios
"Budget review"	Budget vs actual variance analysis
"Are we ready to fundraise"	Data room checklist + valuation sanity check
"Pricing analysis"	Phase 9 pricing framework
"Monthly close"	P&L + variance + dashboard + action items
"Forecast revenue"	Driver-based forecast with 3 scenarios
"Headcount plan"	Phase 7 headcount model

Built by AfrexAI — turning data into decisions.