← Back to Curriculum

Intermediate

Practice Drills: Building an FP&A Variance Analysis Report

A practice-first course for corporate finance and treasury professionals, growth-stage founders and strategy teams who own the monthly budget vs actual conversation. You already know what a budget is; this course makes you explain why the numbers missed it. Working with sample data from Indian businesses, from a D2C brand selling on its own site, Amazon and Flipkart to a mid-sized manufacturer, you will structure budget and actual data for a clean comparison, split revenue variances into price, volume and mix, drill material, employee cost and opex variances, flex the budget to separate volume effects from true overspends, and build gross margin, EBITDA and cash bridges. Then you write the report itself: set materiality thresholds, draft commentary that names causes and owners, build a one-page summary with a waterfall chart, and turn variances into reforecast actions. Three full drills close the course, including reviewing and fixing a flawed variance report.

FP&ABudget vs ActualVariance AnalysisPrice Volume MixManagement Reporting

MODULES

5

DURATION

4 Hours

TRACK

Corporate Finance

What You'll Master

Structure budget and actual data so every line compares like with like, across the April to March financial year

Apply a consistent favourable and adverse sign convention across revenue and cost lines

Split revenue variance into price, volume and mix effects, by product, channel and region

Calculate material price and usage variances and flex the budget to isolate genuine overspends

Build gross margin, EBITDA and cash bridges from budget to actual

Set materiality thresholds and write variance commentary with causes, owners and next actions

Produce a one-page variance summary with a waterfall chart and feed variances into the reforecast

Access Level

LEARNER

Start Learning Now →Sign in to resume

Everything included

Full Text Playbooks

Actionable Exercises

Mobile Reading Mode

Lifetime Updates

Curriculum Breakdown

Chapter 1: Setting Up the Drill

3 Lessons

What a Variance Analysis Report Is and Who Actually Reads It9 min read

Drill: Structuring Budget and Actual Data for a Like-for-Like Comparison13 min read

Drill: Favourable, Adverse and Getting the Sign Convention Right11 min read

Chapter 2: Drilling Revenue Variances

3 Lessons

Drill: Splitting Revenue Variance into Price, Volume and Mix14 min read

Drill: Channel and Region Variances for a Multi-Channel Business13 min read

Drill: Separating Timing Variances from Permanent Ones11 min read

Chapter 3: Drilling Cost, Margin and Cash Variances

5 Lessons

Drill: Material Price and Usage Variances on Cost of Goods Sold13 min read

Drill: Flexing the Budget to Separate Volume Effects from Overspends13 min read

Drill: Employee Cost and Operating Expense Variances Line by Line12 min read

Drill: Building Gross Margin and EBITDA Bridges from Budget to Actual14 min read

Drill: Working Capital and Cash Flow Variances12 min read

Chapter 4: Writing the Variance Report

4 Lessons

Drill: Setting Materiality Thresholds and Choosing Which Variances to Explain10 min read

Drill: Writing Variance Commentary That Names Causes, Owners and Actions12 min read

Drill: Building the One-Page Variance Summary and Waterfall Chart13 min read

Drill: Turning Variances into Reforecast Decisions12 min read

Chapter 5: Full Practice Drills

3 Lessons

Full Drill: Monthly Variance Report for an Indian D2C Brand16 min read

Full Drill: Quarterly Variance Review for a Mid-Sized Manufacturer16 min read

Full Drill: Reviewing and Correcting a Flawed Variance Report14 min read