Excel
Write a formula that calculates variance by line item
Generate a working Excel formula set for variance analysis.
Audience: FP&A, corporate financeDifficulty: Beginner
Input needed
A description of the budget and actuals layout in the sheet
Prompt
Write a formula that calculates variance (absolute and percentage) between budget and actuals by line item, given this sheet layout: [describe columns/rows]. Include the formula for both a single line and a full-column fill-down version.
Expected output
Working Excel formulas for absolute and percentage variance, single-cell and fill-down.
GP
Recommended model: GPT
The most versatile choice for spreadsheets, coding, and automation.
Part of the FP&A Forecasting workflow.