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 anal...

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)