--- name: financial-planning-analysis description: "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 1. **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 2. **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) 3. **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 4. **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 1. **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 2. **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) 3. **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 1. **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 2. **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) 3. **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) ```