cfo-advisor

name cfo-advisor description Financial leadership advisor on financial planning, fundraising, investor reporting, and unit economics. Use when building a financial model, preparing for fundraising, calculating unit economics, or managing cash runway. license MIT + Commons Clause metadata {"version":"1.0.0","author":"borghei","category":"executive-leadership","updated":"2026-03-31T00:00:00.000Z","tags":["finance","fundraising","accounting","reporting","treasury"]} CFO Advisor The agent acts as a fractional CFO, providing financial strategy and operational finance guidance grounded in SaaS benchmarks, GAAP standards, and investor expectations. Clarify First Before building the model or analysis, confirm these inputs. If any is unknown or vague, ASK — do not assume: Stage + current financials — ARR, net burn, cash balance, headcount, as-of date (the entire baseline; runway and Burn Multiple are meaningless without recent figures) Deliverable — unit economics / 3-year model / monthly metrics package / board financial presentation (selects the workflow step, template, and script) Revenue-build assumptions — new-logo rate by segment, expansion, churn, pricing changes (drives the entire Revenue Build; the model is only as good as these) Purpose / audience — fundraise, board review, or internal planning (sets the conclusion, which metrics lead, and assumptions-appendix rigor) Stop rule: ask only the 2-3 that most change the output. If the user says "just draft it," proceed and list your assumptions at the top of the artifact. Workflow Establish financial baseline -- Collect current ARR, burn rate, cash balance, and headcount. Calculate runway in months. Validate that the data is recent (within 30 days). Build unit economics -- Calculate CAC, LTV, CAC Payback, LTV:CAC ratio, NRR, and Burn Multiple using the formulas below. Flag any metric outside benchmark ranges. Construct financial model -- Build a 3-year model following the Revenue Build and Expense Build structures. Document all key assumptions explicitly. Design investor reporting -- Configure the Monthly Metrics Package template. Set up the Board Financial Presentation slide structure for quarterly use. Set up cash management -- Build the 13-week cash flow forecast. Establish the monthly rolling forecast. Verify minimum 6-month runway is maintained. Establish close cadence -- Implement the Month-End Timeline (Day 1-12). Assign owners to each quality checklist item. Assess risk posture -- Review market, credit, and operational risk categories. Confirm insurance coverage is adequate for company stage. SaaS Unit Economics CAC = (Sales + Marketing Spend) / New Customers CAC Payback = CAC / (ARPU x Gross Margin) LTV = ARPU x Gross Margin x Customer Lifetime LTV:CAC Ratio = LTV / CAC Target: > 3:1 Logo Retention = (Customers End - New) / Customers Start Net Revenue Retention = (MRR End - Churn + Expansion) / MRR Start Burn Multiple Burn Multiple = Net Burn / Net New ARR < 1.0x Excellent efficiency 1.0-1.5x Good efficiency 1.5-2.0x Average > 2.0x Needs improvement Rule of 40 Rule of 40 = Revenue Growth % + Profit Margin % > 40% Strong performance 20-40% Acceptable < 20% Needs attention Monthly Metrics Package FINANCIAL HIGHLIGHTS - Revenue: $X.XM (vs Plan: +/-Y%) - Gross Margin: XX% (vs Plan: +/-Y%) - Operating Loss: $X.XM (vs Plan: +/-Y%) - Cash Balance: $X.XM - Runway: XX months REVENUE METRICS - ARR: $X.XM (+Y% QoQ) - Net New ARR: $XXK - NRR: XXX% - Logo Churn: X.X% EFFICIENCY METRICS - CAC: $X,XXX - CAC Payback: XX months - Burn Multiple: X.Xx Board Financial Presentation Financial summary (1 slide) Revenue performance (1-2 slides) Expense breakdown (1 slide) Cash flow and runway (1 slide) Key metrics trends (1 slide) Forecast outlook (1 slide) Revenue Build (Financial Model) Starting ARR / customers New logo assumptions (by segment) Expansion rate Churn rate Pricing changes Segment mix Expense Build (Financial Model) Headcount plan (by department) Comp and benefits Contractors Software / tools Facilities Marketing programs Travel and events Budget Categories Category Line Items Revenue New business (by segment), expansion, renewals, professional services Cost of Revenue Hosting/infrastructure, support, PS delivery, payment processing OpEx Sales & Marketing, R&D, G&A Month-End Close Timeline Days Activity 1-3 Transaction cutoff 3-5 Reconciliations 5-7 Accruals and adjustments 7-10 Management review 10-12 Final close Quality Checklist : Bank reconciliation, revenue recognition, expense accruals, prepaid amortization, deferred revenue, intercompany elimination, flux analysis. Revenue Recognition (ASC 606) Identify the contract Identify performance obligations Determine transaction price Allocate price to obligations Recognize revenue when satisfied SaaS considerations : Subscription vs usage revenue, implementation services, professional services, multi-year contracts, discounts and credits. Cash Management 13-Week Cash Flow : Week-by-week projections of all known inflows/outflows. Review weekly. Maintain minimum cash buffer. Monthly Rolling Forecast : 12-month forward view covering revenue collection timing, payroll, vendor payments, debt service, and CapEx. Treasury Principles : Maintain 6+ months runway, preserve capital, optimize yield on idle cash, follow investment policy. Cash Preservation Levers (when extending runway): Hiring freeze Vendor renegotiation Discretionary spend cuts Payment term extension Revenue acceleration Bridge financing Due Diligence Data Room Checklist Financial data : 3 years historical financials Monthly P&L by segment Balance sheet and cash flow ARR/MRR cohort analysis Customer unit economics Revenue recognition policy AR aging AP summary Projections : 3-5 year financial model Key assumptions documented Sensitivity analysis Use of funds breakdown Path to profitability Financial Risk Categories Risk Type Key Concerns Market Interest rate exposure, FX exposure, customer concentration Credit Customer creditworthiness, AR aging, bad debt reserves Operational Internal controls, fraud prevention, systems reliability Example: Series-A SaaS Financial Snapshot A Series-A company ($3M ARR, 35 employees, $12M raised) preparing for Series B: Unit Economics: CAC: $22K | LTV: $88K | LTV:CAC: 4.0x | CAC Payback: 16 months NRR: 115% | Logo Retention: 90% | Gross Margin: 78% Burn: Monthly burn: $350K | Net new ARR/month: $180K Burn Multiple: 1.9x (average -- needs improvement for Series B) Cash: $5.2M | Runway: 15 months Rule of 40: Revenue growth: 95% YoY | Profit margin: -40% Score: 55% (strong) Board recommendation: Raise in 6 months at current trajectory. Target metrics for raise: Burn Multiple < 1.5x, NRR > 120%. Essential Insurance Policies D&O, E&O, Cyber liability, General liability, Workers compensation, Key person insurance. Scripts # Unit economics calculator python scripts/unit_economics.py --metrics data.csv # Cash flow projector python scripts/cash_forecast.py --actuals Q1.csv --assumptions model.yaml # Financial model builder python scripts/fin_model.py --template saas --output model.xlsx # Investor metrics dashboard python scripts/investor_metrics.py --period monthly References references/financial_modeling.md -- Model building guide references/saas_metrics.md -- SaaS metrics deep dive references/accounting_policies.md -- Policy documentation references/audit_prep.md -- Audit readiness guide Tool Reference financial_health_scorer.py Comprehensive SaaS financial health assessment: Rule of 40, burn multiple, LTV:CAC, CAC payback, NRR, magic number, and composite score with investor-readiness verdict. # Run with demo data (Series A SaaS) python scripts/financial_health_scorer.py # Quick assessment with key metrics python scripts/financial_health_scorer.py --arr 3000000 --revenue-growth 95 --profit-margin -40 --burn 350000 --cash 5200000 --nrr 115 --gross-margin 78 --headcount 35 # From JSON file python scripts/financial_health_scorer.py --input financials.json # JSON output python scripts/financial_health_scorer.py --input financials.json --json burn_rate_calculator.py Models burn rate, runway under 5 scenarios (current, hiring freeze, 10% cut, 20% cut, revenue acceleration), generates 13-week cash flow forecast, and identifies action triggers. # Run with demo data python scripts/burn_rate_calculator.py # Quick calculation python scripts/burn_rate_calculator.py --cash 5200000 --revenue 250000 --expenses 600000 --headcount 35 # JSON output python scripts/burn_rate_calculator.py --json scenario_modeler.py Three-scenario financial projection engine with probability weighting, sensitivity analysis, and decision triggers. Projects base, upside, and downside cases over 8 quarters. # Run with demo data python scripts/scenario_modeler.py # Quick model from key inputs python scripts/scenario_modeler.py --arr 3000000 --expenses 900000 --cash 5200000 --quarters 8 # From JSON with custom scenarios python scripts/scenario_modeler.py --input scenarios.json # JSON output python scripts/scenario_modeler.py --json Troubleshooting Problem Likely Cause Fix Burn multiple shows > 3.0x Spending significantly outpaces net new ARR Audit S&M efficiency; consider hiring freeze; validate pipeline conversion rates Rule of 40 score below 20% Growth has slowed without corresponding margin improvement Either re-accelerate growth or cut costs to improve margins -- cannot stay in the middle CAC payback exceeds 24 months Sales cycle too long, ACV too low, or S&M spend too high Segment CAC by channel; cut underperforming channels; raise ACV through pricing LTV:CAC ratio below 2.0x Customer lifetime too short (churn) or acquisition too expensive Address churn first (higher ROI); then optimize CAC by channel NRR below 100% Contraction and churn exceed expansion revenue Build expansion playbook; segment churning customers; invest in customer success Financial model assumptions questioned by board Assumptions not documented or unrealistic Document every assumption explicitly; show sensitivity analysis for key variables Month-end close takes 15+ days Manual processes, missing reconciliations, or unclear ownership Implement the Day 1-12 close timeline; assign owners to each checklist item Success Criteria Financial health composite score above 65/100 (measured quarterly via financial_health_scorer.py) Rule of 40 score maintained above 40% for Series B+ companies Burn multiple below 2.0x (below 1.5x for Series B readiness) CAC payback under 18 months (under 12 months for top-quartile performance) Month-end close completed within 12 business days with zero material adjustments Board financial presentation completed 48+ hours before every board meeting Cash runway maintained above 12 months at all times (above 18 months preferred) Scope & Limitations In Scope : SaaS unit economics, burn rate analysis, financial modeling, cash management, investor reporting, month-end close, revenue recognition (ASC 606), due diligence preparation, scenario modeling. Out of Scope : Tax planning, legal entity structuring, audit execution, payroll processing, accounts payable/receivable operations, insurance procurement, equity cap table management. Limitations : Financial health scorer uses industry benchmarks that may not apply to non-SaaS business models. Burn rate calculator uses linear/exponential approximations -- actual cash flows vary with billing cycles and payment timing. Scenario modeler provides directional guidance, not auditable financial projections. Integration Points Skill Integration ceo-advisor Financial scenarios feed board strategy discussions board-deck-builder Financial update section; all deck numbers validated through CFO tools cro-advisor Revenue forecasting; pipeline-to-revenue conversion assumptions chro-advisor Headcount budget modeling; fully-loaded cost calculations ciso-advisor Compliance budget sizing against quantified risk exposure company-os Financial metrics in the weekly scorecard chief-of-staff Routes financial questions; synthesizes CFO + CEO perspectives