Analyze Budget Variances and Generate Reports

This skill is a financial-analyst expert in budget variance analysis and reporting - variance calculation methodologies, root cause analysis, and executive-level communication. Core variance types: Absolute Variance (Actual - Budget), Percentage Variance (((Actual - Budget) / Budget) x 100), Favorable vs. Unfavorable (revenue above budget is favorable, expenses above budget is unfavorable), materiality thresholds (typically 5-10% or a dollar amount), and both year-to-date and period-level analysis. Key indicators tracked include variance percentage by department/cost center, multi-period trends, budget accuracy, forecast reliability, and cash-flow impact.

Use it when actual-vs-budget performance needs a structured variance report with root causes and management actions attached, not just a raw number comparison.

// Variance Amount
=C2-B2  // (Actual - Budget)

// Variance Percentage
=IF(B2<>0,(C2-B2)/B2,"N/A")

// Favorable/Unfavorable Logic
=IF(AND(A2="Revenue",C2>B2),"Favorable",
   IF(AND(A2="Expense",C2<B2),"Favorable","Unfavorable"))

The report structure opens with an executive summary (total revenue/expense/net-income variance in dollars and percent, top 3 significant variances, contributing factors, forecasted implications), then a detailed analysis across revenue (volume vs. price decomposition, segment performance, market impacts), expense (fixed vs. variable behavior, efficiency metrics, one-time vs. recurring), and cash flow (working capital, capex variances, debt service coverage). Root cause analysis follows a three-step process - variance quantification, business driver analysis (volume, price, mix, efficiency), and external factor assessment (market, regulatory, competitive, economic) - categorized in a controllability matrix (Volume/Price/Efficiency/One-time, each mapped to a specific review action). Dashboards use waterfall charts, heat maps, trend lines, and pie charts, with a fixed color code: green for favorable-within-tolerance, yellow for 5-10% attention-needed, red for over 10% unfavorable, blue for informational. Executive escalation triggers on a single line item over 15% and $50K, an overall department variance over 10%, a negative trend across 3 periods, or an impact requiring credit-line adjustment or affecting debt-covenant compliance. Advanced Excel functions cover rolling 3-month variance trends, cumulative weighted variance impact, and forecast adjustment calculations, alongside quality-control checkpoints for mathematical accuracy, budget version control, timing differences, and reclassification consistency.

FP&A analysts and finance teams who need a full variance-reporting workflow - calculation formulas, root-cause categorization, dashboard color standards, and explicit executive escalation thresholds - not just a spreadsheet of actual-vs-budget numbers. Forecasting is treated as a downstream extension of the same variance work: variance patterns get applied to remaining periods, known upcoming business changes are folded in, uncertain items get probabilistic risk weighting, and base/optimistic/pessimistic scenarios get modeled - with a full budget revision triggered by a cumulative variance over 20% of the annual budget, a fundamental business-model change, a market disruption event, or a new regulatory requirement.