Gold by MangoMagic

CEO · Framework · Advanced · Saves 60+ hours

Financial Planning & Analysis Framework

A framework for financial planning and analysis.

Get coached on this — free

What's included

  • Planning Process
    • Annual planning
    • Quarterly reforecasting
    • Scenario planning
  • Budgeting
    • Budget methodology
    • Department budgets
    • Variance analysis
  • Analysis
    • Metric tracking
    • Trend analysis
    • Cohort analysis
    • Unit economics
  • Reporting
    • Management reporting
    • Board reporting
    • Investor reporting

Best used when

  • Building FP&A function
  • Annual planning process
  • Quarterly reforecasting
  • Board financial reporting

Why this is Gold

FP&A provides visibility. This framework creates that visibility.

The template

The Template

FP&A PHILOSOPHY

Understanding FP&A as Strategic Navigation

FP&A FUNDAMENTALS

WHAT FP&A ACTUALLY IS:
☐ Strategic planning support
☐ Financial forecasting and modeling
☐ Performance analysis and insights
☐ Decision support for leadership
☐ Board and investor communication

CEO'S ROLE IN FP&A:
☐ Set strategic direction for planning
☐ Own key assumptions and targets
☐ Drive accountability to plan
☐ Ask questions, understand variances
☐ Make decisions based on analysis

FP&A VS. ACCOUNTING:
Accounting = What happened (backward)
FP&A = What will happen (forward)
Both essential, different purposes.

THE THREE FP&A DELIVERABLES:
1. Annual Budget: The plan
2. Forecast: Updated expectations
3. Analysis: What's driving results

COMMON FP&A MISTAKES:
☐ Building one plan and forgetting it
☐ Not updating forecasts regularly
☐ Analysis without actionable insights
☐ Disconnected from operations
☐ Overly complex models

THE FP&A MINDSET SHIFT:
"FP&A isn't about predicting the future
perfectly. It's about having a framework
for making decisions and understanding
what's driving your business."

COMPREHENSIVE FP&A FRAMEWORK

Financial Planning Framework

═══════════════════════════════════════
FINANCIAL PLANNING & ANALYSIS
═══════════════════════════════════════

COMPANY: _______________
Fiscal Year: _______________
FP&A Owner: _______________

═══════════════════════════════════════
SECTION 1: ANNUAL PLANNING PROCESS
═══════════════════════════════════════

PLANNING CALENDAR:

SEPTEMBER (Pre-Planning):
Week 1-2:
☐ Review strategic plan
☐ CEO communicates priorities
☐ Finance issues planning guidelines
☐ Set preliminary targets

Week 3-4:
☐ Market analysis update
☐ Competitive landscape review
☐ Product roadmap alignment
☐ Headcount planning kickoff

OCTOBER (Department Planning):
Week 1-2:
☐ Departments build bottom-up plans
☐ Revenue team builds pipeline/forecast
☐ Product team aligns roadmap
☐ Finance consolidates first draft

Week 3-4:
☐ Cross-functional reviews
☐ Gap analysis vs targets
☐ Iteration and refinement
☐ Leadership alignment sessions

NOVEMBER (Consolidation):
Week 1-2:
☐ Final department submissions
☐ Consolidated model complete
☐ Scenario analysis (Base/Up/Down)
☐ Key assumptions documented

Week 3-4:
☐ Executive review sessions
☐ Board preview (if needed)
☐ Final adjustments
☐ Documentation finalized

DECEMBER (Approval):
Week 1-2:
☐ Board approval
☐ Department budgets finalized
☐ Communication to organization
☐ Systems/tracking set up

POST-PLANNING:
☐ Monthly review cadence established
☐ Quarterly reforecast schedule set
☐ Variance reporting templates ready

═══════════════════════════════════════
SECTION 2: BUDGET STRUCTURE
═══════════════════════════════════════

REVENUE BUDGET:
| Source | Current | Growth | Budget | Notes |
|--------|---------|--------|--------|-------|
| New Business | $_____ | ___% | $_____ | |
| Expansion | $_____ | ___% | $_____ | |
| Renewal | $_____ | ___% | $_____ | |
| **Total ARR** | $_____ | ___% | $_____ | |
| Services | $_____ | | $_____ | |
| **Total Revenue** | $_____ | ___% | $_____ | |

EXPENSE BUDGET:
| Category | Current | Budget | % of Rev | Industry |
|----------|---------|--------|----------|----------|
| Cost of Revenue | | | | |
| - Hosting/Infra | $_____ | $_____ | ___% | 5-10% |
| - Support | $_____ | $_____ | ___% | 3-8% |
| - Services delivery | $_____ | $_____ | ___% | Varies |
| **Total COGS** | $_____ | $_____ | ___% | 20-30% |
| **Gross Profit** | $_____ | $_____ | ___% | 70-80% |
| | | | | |
| Sales & Marketing | | | | |
| - Sales (quota) | $_____ | $_____ | ___% | |
| - Sales ops | $_____ | $_____ | ___% | |
| - Marketing | $_____ | $_____ | ___% | |
| **Total S&M** | $_____ | $_____ | ___% | 40-60% |
| | | | | |
| R&D | | | | |
| - Engineering | $_____ | $_____ | ___% | |
| - Product | $_____ | $_____ | ___% | |
| **Total R&D** | $_____ | $_____ | ___% | 15-25% |
| | | | | |
| G&A | | | | |
| - Finance | $_____ | $_____ | ___% | |
| - HR | $_____ | $_____ | ___% | |
| - Legal | $_____ | $_____ | ___% | |
| - Facilities | $_____ | $_____ | ___% | |
| **Total G&A** | $_____ | $_____ | ___% | 8-15% |
| | | | | |
| **Total Opex** | $_____ | $_____ | ___% | |
| **Operating Profit** | $_____ | $_____ | ___% | |

HEADCOUNT BUDGET:
| Department | Current | Adds | Budget | % Growth |
|------------|---------|------|--------|----------|
| Sales | ___ | ___ | ___ | ___% |
| Marketing | ___ | ___ | ___ | ___% |
| Engineering | ___ | ___ | ___ | ___% |
| Product | ___ | ___ | ___ | ___% |
| Customer Success | ___ | ___ | ___ | ___% |
| G&A | ___ | ___ | ___ | ___% |
| **Total** | ___ | ___ | ___ | ___% |

═══════════════════════════════════════
SECTION 3: FORECASTING
═══════════════════════════════════════

QUARTERLY REFORECAST PROCESS:

Week 1-2 of Quarter:
☐ Review Q-1 actuals
☐ Assess current quarter trajectory
☐ Update revenue forecast
☐ Update expense forecast

Week 3-4:
☐ Full year reforecast complete
☐ Variance to budget documented
☐ Key assumptions updated
☐ Board materials prepared

FORECAST METHODOLOGY:

Revenue Forecast Inputs:
☐ Pipeline coverage and conversion
☐ Quota capacity and attainment
☐ Renewal rates and timing
☐ Expansion trends
☐ Seasonal patterns

Expense Forecast Approach:
☐ Committed costs (contracts, leases)
☐ Headcount plan × cost/head
☐ Variable costs × revenue
☐ Planned programs/initiatives
☐ Contingency/buffer

═══════════════════════════════════════
SECTION 4: VARIANCE ANALYSIS
═══════════════════════════════════════

MONTHLY VARIANCE ANALYSIS:

Period: _______________

REVENUE VARIANCE:
Actual: $_________ vs Budget: $_________
Variance: $_________ (____%)

Drivers:
☐ New business: $_____ (____%)
☐ Expansion: $_____ (____%)
☐ Churn: $_____ (____%)
☐ Other: $_____ (____%)

Explanation: _______________
Action: _______________

GROSS MARGIN VARIANCE:
Actual: ____% vs Budget: ____%
Variance: ____ pts

Drivers:
☐ Revenue mix: ____ pts
☐ Hosting costs: ____ pts
☐ Support costs: ____ pts
☐ Other: ____ pts

Explanation: _______________
Action: _______________

OPEX VARIANCE:
Actual: $_________ vs Budget: $_________
Variance: $_________ (____%)

By Department:
☐ S&M: $_____ (____%)
☐ R&D: $_____ (____%)
☐ G&A: $_____ (____%)

Key Drivers:
1. _______________
2. _______________
3. _______________

Actions Required:
☐ _______________
☐ _______________

Budget vs Actual Summary

Line Item Budget Actual Variance Var % Commentary
Revenue $ $ $ %
Gross Profit $ $ $ %
S&M $ $ $ %
R&D $ $ $ %
G&A $ $ $ %
Operating Profit $ $ $ %

FP&A Calendar

Month Activity Owner Due Status
Monthly Close + variance analysis Finance Day 5
Monthly Forecast update FP&A Day 10
Monthly CEO finance review CFO Day 15
Quarterly Full reforecast FP&A Q+2 wks
Quarterly Board package CFO Q+3 wks
Sep-Dec Annual planning FP&A Dec 15

Frequently asked questions

What is the Financial Planning & Analysis Framework?

A framework for financial planning and analysis.

Who is the Financial Planning & Analysis Framework for?

It is built for CEOs and their teams working on Finance Operations. The AI coach adapts it to your company, stage, and goals.

How long does the Financial Planning & Analysis Framework take to use?

It saves roughly 60+ hours versus building from scratch. Our AI coach can tailor the framework to your situation in minutes, then hand you a step-by-step plan.

Is the Financial Planning & Analysis Framework free?

Yes. You can read the full framework and start getting coached through it for free. Sign in to save your tailored version and track your next steps.

How does the AI coach help with the Financial Planning & Analysis Framework?

The coach teaches you the framework, asks a few questions about your business, tailors the framework to you, and gives you measurable next steps to execute.