Finance AI Skill

Financial Planning Analysis

Execute financial planning and analysis (FP&A) including budgeting, forecasting, variance analysis, and strategic financial modeling to support executive decision-making. Use when building annual budgets, creating rolling forecasts, performing variance analysis, preparing board packages, or developing strategic financial models. Triggers on phrases like 'FP&A', 'budgeting process', 'rolling forecast', 'variance analysis', 'financial model', 'board deck', 'KPI reporting', 'scenario planning', 'driver-based modeling', 'operating plan'.

Financial Planning & Analysis (FP&A)

Execute comprehensive financial planning, budgeting, forecasting, and variance analysis to provide actionable financial insights for strategic decision-making across the organization.

Workflow

Phase 1: Annual Planning & Budgeting

Top-down guidance setting:

CEO/CFO strategic objectives and revenue targets
Market outlook and macroeconomic assumptions
Historical performance analysis and trend lines
Industry benchmarks and competitive positioning

Bottom-up budget development:

Department-level budget submissions with headcount plans
Revenue forecasting by product line, segment, geography
OPEX planning by category (SG&A, R&D, marketing, operations)
CAPEX planning (technology, facilities, equipment)

Consolidation & reconciliation:

Aggregate departmental budgets into enterprise forecast
Identify variances between top-down and bottom-up
Iterative negotiation with department heads
Board presentation and approval

Budget lock and distribution:

Finalize approved budget by cost center
Set spending limits and approval authorities
Configure ERP/budgeting system with approved figures
Communicate budgets to department owners

Phase 2: Forecasting & Continuous Planning

Monthly actuals reporting:

Close actuals by month-end (within 5 business days)
Reconcile GL accounts and investigate anomalies
Prepare monthly variance report (actual vs. budget vs. prior year)
Draft management commentary for each variance >5% or >$50K

Rolling forecast updates:

Update 12-month rolling forecast monthly
Incorporate actuals for completed months
Re-forecast remaining months based on current trends
Update assumptions (market conditions, pricing, volume)

Variance analysis:

Revenue variances: volume, price, mix, currency effects
Cost variances: rate, usage, efficiency, structural
Headcount variances: timing, rate, attrition, hiring
One-time vs. recurring variance classification

Phase 3: Strategic Analysis & Reporting

KPI dashboard development:

Revenue metrics: ARR, MRR, growth rate, retention
Profitability: gross margin, EBITDA, operating margin, free cash flow
Efficiency: CAC, LTV, CAC payback, burn multiple
Operational: headcount, revenue per employee, utilization

Board & executive reporting:

Monthly management meeting deck (10-15 slides)
Quarterly board package (comprehensive financial review)
Annual strategic plan update
Special presentations (fundraising, M&A, major investments)

Scenario & sensitivity analysis:

Base case, upside, downside scenarios
Key driver sensitivity (price ±5%, volume ±10%, cost ±3%)
Stress testing (recession, supply chain disruption, competitor response)
Breakeven and cash runway analysis

Templates

Budget Planning Framework

ANNUAL BUDGET PLANNING — Framework
====================================
Fiscal Year: [2025] | Version: [Draft 3] | Date: [2024-11-15]

TOP-DOWN GUIDANCE:
  Revenue target: $120M (↑ 25% from $96M FY24)
  Gross margin target: 72% (↑ 2pts from 70%)
  EBITDA target: $18M (15% margin, ↑ from 12%)
  Headcount target: 450 FTEs (↑ 25% from 360)
  Free cash flow target: $15M
  Strategic initiatives: New product launch, APAC expansion

ASSUMPTIONS:
  Macro: GDP growth 2.5%, inflation 3%, FX USD/EUR 1.08
  Market: TAM growth 15%, competitive share stable
  Pricing: ASP increase 5% (announced Jan 1)
  Volume: New logo growth 30%, expansion revenue 20%
  Hiring: 90 new hires (30 Sales, 25 Eng, 20 Support, 15 G&A)

BUDGET BY CATEGORY:
┌────────────────────────┬──────────┬──────────┬──────────┬──────────────┐
│ Category              │ FY24 Act │ FY25 Bud │ Change   │ Notes        │
├───────────────────────┼──────────┼──────────┼──────────┼──────────────┤
│ Revenue              │  $96.0M  │ $120.0M  │  +25%   │ New product, │
│                       │          │          │          │  APAC launch  │
├───────────────────────┼──────────┼──────────┼──────────┼──────────────┤
│ COGS                 │  $28.8M  │  $33.6M  │  +16%   │ Infra scale  │
│ Gross Profit         │  $67.2M  │  $86.4M  │  +29%   │ GM: 72%     │
├───────────────────────┼──────────┼──────────┼──────────┼──────────────┤
│ R&D                  │  $18.0M  │  $24.0M  │  +33%   │ New product  │
│ Sales & Marketing    │  $32.0M  │  $42.0M  │  +31%   │ Headcount +  │
│                       │          │          │          │  new markets  │
│ G&A                  │   $8.0M  │  $10.0M  │  +25%   │ Systems,     │
│                       │          │          │          │  compliance   │
│ EBITDA               │  $9.2M   │  $10.4M  │  +13%   │ Margin: 9%  │
│ Depreciation/Amort   │   $2.0M  │   $2.4M  │  +20%   │ CAPEX related │
│ EBIT                 │  $7.2M   │   $8.0M  │  +11%   │              │
│ Interest/Tax         │   $1.0M  │   $1.2M  │  +20%   │              │
│ Net Income           │  $6.2M   │   $6.8M  │  +10%   │ Margin: 6%  │
└───────────────────────┴──────────┴──────────┴──────────┴──────────────┘

HEADCOUNT BUDGET BY DEPARTMENT:
  Engineering: 120 FTEs (↑ 25, avg salary: $145K)
  Sales:      100 FTEs (↑ 15, avg salary: $95K + commission)
  Marketing:  30 FTEs  (↑ 5, avg salary: $110K)
  Customer Success: 60 FTEs (↑ 10, avg salary: $85K)
  Support:    80 FTEs (↑ 10, avg salary: $70K)
  Finance:    15 FTEs (↑ 3, avg salary: $120K)
  HR:         12 FTEs (↑ 2, avg salary: $100K)
  Executive:   8 FTEs (↑ 0)
  Legal/Ops:  25 FTEs (↑ 5, avg salary: $110K)
  Total:     450 FTEs (↑ 69 from 381)

BUDGET APPROVAL PROCESS:
  1. Department heads submit drafts → Due: Nov 30
  2. FP&A consolidates and reviews → Due: Dec 7
  3. CFO review and feedback → Due: Dec 14
  4. Department revisions → Due: Dec 21
  5. Executive team review → Due: Jan 4
  6. Board presentation and approval → Due: Jan 18
  7. Budget lock and system load → Due: Jan 31

Monthly Variance Report

MONTHLY VARIANCE REPORT — December 2024
=========================================
Reporting Period: Dec 1-31, 2024 | Prepared by: FP&A Team

EXECUTIVE SUMMARY:
  Revenue: $11.2M (vs $10.8M budget) → +$400K favorable (+3.7%)
  Gross Profit: $8.1M (vs $7.8M budget) → +$300K favorable
  EBITDA: $1.4M (vs $1.2M budget) → +$200K favorable (+16.7%)
  Free Cash Flow: $0.8M (vs $0.5M budget) → +$300K favorable
  Headcount: 378 (vs 375 budget) → +3 over budget

REVENUE VARIANCE ANALYSIS:
  Total revenue variance: +$400K FAVORABLE
    Volume effect: +$250K (↑ 8 new logos vs 6 expected)
    Price effect: +$100K (ASP 4% above budget)
    Mix effect: +$50K (more enterprise deals)
    Currency effect: $0 (all USD)

COST VARIANCE ANALYSIS (items >$50K or >5%):
┌────────────────────────┬──────────┬──────────┬──────────┬────────────────────┐
│ Category              │ Actual   │ Budget   │ Variance │ Commentary         │
├───────────────────────┼──────────┼──────────┼──────────┼────────────────────┤
│ Cloud infrastructure │  $1.2M   │  $1.0M   │  -$200K │ AWS usage 20%      │
│                       │          │          │  ADVERSE │ above plan due to  │
│                       │          │          │          │  new product beta  │
├───────────────────────┼──────────┼──────────┼──────────┼────────────────────┤
│ Sales commissions    │  $1.8M   │  $1.6M   │  -$200K │ Higher deals =     │
│                       │          │          │  ADVERSE │ higher commissions │
├───────────────────────┼──────────┼──────────┼──────────┼────────────────────┤
│ Marketing spend      │  $2.8M   │  $3.0M   │  +$200K │ Reduced event      │
│                       │          │          │  FAVORABLE│ spend (virtual)   │
├───────────────────────┼──────────┼──────────┼──────────┼────────────────────┤
│ R&D salary           │  $2.4M   │  $2.3M   │  -$100K │ 2 senior hires     │
│                       │          │          │  ADVERSE │ joined early       │
├───────────────────────┼──────────┼──────────┼──────────┼────────────────────┤
│ Travel & entertain.  │  $0.1M   │  $0.2M   │  +$100K │ Remote-first       │
│                       │          │          │  FAVORABLE│ policy continues   │
└───────────────────────┴──────────┴──────────┴──────────┴────────────────────┘

HEADCOUNT VARIANCE:
  Budget: 375 | Actual: 378 | Variance: +3
    Engineering: +2 (joined early per project needs) — approved by VP Eng
    Sales: +1 (urgent hire to cover territory gap) — approved by CRO
  Total incremental salary cost: ~$45K/month

12-MONTH ROLLING FORECAST UPDATE:
  FY25 Revenue forecast: $118.5M (was $120.0M) — ↓ $1.5M
    Reason: Q1 pipeline below target; APAC launch delayed to Q2
  FY25 EBITDA forecast: $9.8M (was $10.4M) — ↓ $0.6M
    Reason: Higher infra costs; hiring ahead of plan
  Cash runway: 24 months (unchanged)
  Breakeven: Q3 2025 (unchanged)

RECOMMENDATIONS:
  1. Monitor cloud infra costs — engage cloud cost optimization team
  2. Accelerate APAC launch prep to recover Q1 revenue gap
  3. Review sales compensation plan for margin protection
  4. No immediate cost reduction needed — on track overall

Integration Points

ERP systems: NetSuite, SAP, Oracle, Microsoft Dynamics
FP&A platforms: Adaptive Insights, Anaplan, Vena, Planful, Hyperion
BI/analytics: Tableau, Power BI, Looker, Sigma Computing
Data warehouse: Snowflake, BigQuery, Redshift
Spreadsheets: Excel, Google Sheets (modeling, ad-hoc analysis)
CRM: Salesforce, HubSpot (pipeline/revenue data)
HR systems: Workday, Rippling (headcount, compensation data)
Expense management: Rippling, Expensify, Concur (OPEX data)
Board reporting: Boardable, Datasite, Firmex (board packages)

Edge Cases

| Scenario | Handling | |----------|----------| | Department head misses budget submission deadline | Escalate to VP; use prior year actuals as placeholder; flag for post-lock adjustment | | Major variance discovered after board approval | Emergency variance report; root cause analysis; corrective action plan | | Rapid market change invalidates budget assumptions | Trigger special forecast update; scenario analysis; communicate to stakeholders | | Budget vs. forecast disagreement between CFO and CEO | Present data-driven analysis; multiple scenarios; board committee resolution | | Headcount budget exceeded mid-year | Freeze non-critical hiring; reallocate from underspent departments; executive approval | | Revenue significantly above budget | Analyze sustainability; assess capacity constraints; adjust cost forecasts | | System migration during budget cycle | Parallel run; data validation; extended close timeline; manual reconciliation | | Budget data security concerns | Role-based access; audit trail; approval workflows; data encryption |

Output

FP&A Executive Dashboard

FP&A EXECUTIVE DASHBOARD — Live View
======================================
As of: 2025-01-15 | FY25 YTD (Jan-Dec forecast)

FINANCIAL SNAPSHOT:
  Revenue YTD:       $118.5M forecast (Budget: $120.0M) — 98.8% of plan
  Gross Margin:      71.8% (Target: 72.0%) — 0.2pts below target
  EBITDA YTD:        $9.8M forecast (Budget: $10.4M) — 94.2% of plan
  Operating Cash:    $28.5M (Budget: $30.0M) — 95.0% of plan
  Cash Balance:      $42.3M | Cash Runway: 24 months

REVENUE PERFORMANCE (by quarter):
  Q1: $26.5M (95% of budget) ██████████████████████████░░░░
  Q2: $30.2M (98% of budget) █████████████████████████████░░
  Q3: $32.1M (102% of budget) ████████████████████████████████
  Q4: $29.7M (103% of budget) ████████████████████████████████
  ─────────────────────────────────────────────────────
  FY: $118.5M (99% of budget)

KEY METRICS:
  ARR: $92.4M (↑ 28% YoY)
  NRR: 112% (target: 110%) ✓
  Gross retention: 96% (target: 95%) ✓
  CAC payback: 14 months (target: 12) ⚠
  LTV:CAC: 4.2:1 (target: 4.0:1) ✓
  Burn multiple: 1.8 (target: < 2.0) ✓

VARIANCE ALERTS (This Month):
  ⚠ Cloud infra: -$200K adverse (AWS overage) — action: cost optimization review
  ⚠ Sales comp: -$200K adverse (higher deal volume) — acceptable
  ✓ Marketing: +$200K favorable (event savings) — reallocation opportunity
  ✓ Revenue: +$400K favorable (strong new logo activity)

SCENARIO OUTLOOK (12-month):
  Base case:   $118.5M revenue, $9.8M EBITDA [60% probability]
  Upside:      $128.0M revenue, $12.2M EBITDA [20% probability]
  Downside:    $108.0M revenue, $7.5M EBITDA  [20% probability]

NEXT 30-DAY PRIORITIES:
  1. Q1 forecast update (due Jan 25) — pipeline review
  2. Cloud cost optimization plan (due Jan 31)
  3. APAC launch financial impact assessment (due Feb 5)
  4. Q4 board deck preparation (due Feb 10)

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.