📈 F&A Process Guide

Budgeting & Forecasting — Complete Guide

Budgeting sets the financial target; forecasting tells you if you’ll hit it. Together they are the most powerful tools a Finance professional has to influence business decisions, allocate resources, and drive profitable growth.

▶ Start: What is Budgeting & Forecasting?

🔷 Annual Budget Process

• 📅 Sep–Oct: CFO issues budget guidelines — growth targets, inflation assumptions, capex limits, headcount freeze
• 🔷 Oct–Nov: Business units build bottom-up budgets — revenue, opex, capex, headcount by department
• 🔷 Nov: Finance consolidates — challenge sessions with business heads to remove wish-list items
• 🔷 Dec: Draft budget presented to CEO/CFO — iterations until aligned
• ✅ Jan 1: Approved budget locked — becomes the benchmark for the year
• Budget Types: Operating Budget (P&L), Capital Budget (Capex), Cash Budget, Master Budget (all combined)

🔷 Rolling Forecasts

A Rolling Forecast (RF) always looks 12–18 months ahead, updated monthly or quarterly. Unlike a static annual budget, it reflects the latest business reality.

• Format: As you close Month 1 actuals, add Month 13 forecast — always 12 months forward-looking
• Driver-Based: Forecast revenue using leading indicators (sales pipeline, orders received, capacity utilisation) — not just last year +5%
• Scenario Planning: Build Base, Bull, and Bear scenarios — sensitivity to key assumptions (FX rate, commodity prices, demand)
• Frequency: Most companies update quarterly — best-in-class update monthly with high automation
• Tool: Anaplan, Adaptive Insights, Oracle EPM, Excel with Power Query for smaller teams

🔷 Variance Analysis

Variance Analysis compares actual results to budget/forecast and explains the why behind the gap. This is the most important skill for a FP&A professional.

• Favourable (F): Revenue above budget or cost below budget — good outcome
• Adverse (A): Revenue below budget or cost above budget — needs explanation
• Revenue Variance = Price Variance + Volume Variance (decompose both)
• Cost Variance = Spend Variance + Volume Variance + Efficiency Variance
• Bridge Chart (Waterfall): Visually show starting position, each variance driver, ending position — CFO’s favourite chart
• Threshold: Only investigate variances >5% or >₹5L — focus management attention where it matters

🔷 Zero-Based Budgeting (ZBB)

In ZBB, every expense must be justified from zero each year — no item carries forward automatically. Pioneered by AB InBev and 3G Capital, ZBB eliminates budget padding and drives cost discipline.

• Step 1: Define Decision Units (departments/cost centres)
• Step 2: Each unit builds a “decision package” justifying every cost from scratch
• Step 3: Packages ranked by priority — funded from highest to lowest until budget is exhausted
• Pros: Eliminates incremental thinking, forces prioritisation, drives 15–25% cost reduction
• Cons: Very time-intensive — best applied every 3–5 years or to specific cost categories

✅ End: Financial Modelling Basics

• 3-Statement Model: Integrated P&L, Balance Sheet, and Cash Flow model — the foundation of all financial modelling
• DCF Model: Discounted Cash Flow — value a business by discounting future free cash flows at WACC
• LBO Model: Leveraged Buyout — used in private equity to assess returns from debt-funded acquisitions
• Excel Best Practices: Hard-code inputs in blue; formulas in black; links from other sheets in green; no merged cells; use named ranges
• Sensitivity Analysis: One-variable and two-variable data tables to stress-test key assumptions
• Model Audit: Use F2 to trace precedents; CTRL+[ to navigate; Error checking via FORMULATEXT and IFERROR