FP&A modeling: connect assumptions to the financial plan

FP&A modeling connects business assumptions to revenue, costs and profit, then checks those outputs against actual results. Start with the ledger and operating exports your company already uses, define the drivers and preserve the approved version. A useful planning workbook explains the profit difference through changes that business owners can verify.

1. Define the question and reporting boundary

Choose a decision: whether to add capacity, change pricing or revise spending. Then state the business units, reporting periods, currency and profit subtotal the workbook covers. The broader responsibilities of the function belong in what is FP&A; this page covers the assumptions and reconciliations behind its planning output.

For an illustrative US industrial supplier, the question is why monthly operating profit missed plan across Parts and Service. All amounts are USD. Parts uses units shipped; Service uses billable hours. Their quantities cannot be added, but their revenue and profit can.

Request the approved plan, monthly ledger extract and shipment or billable-hours summaries. Keep business-unit identifiers consistent across files. Summarize actual revenue and expense using the same account definitions as the plan, and retain the source references needed to explain each total.

2. Separate assumptions from calculations

Put each input on an assumption register with its period, unit, owner and evidence. Price means net realized revenue per shipped unit or billable hour. Variable cost means the cost incurred per corresponding unit of activity. Fixed expense means the operating expense that this example holds independent of volume within the period.

Do not hide a desired profit in a variable-cost cell. Each assumption should describe an observable business quantity or rate. Use collaborative FP&A for the broader review process between finance and those owners.

The SBA's financial-projection guidance calls for explaining projections and including prospective financial statements. An assumption register supplies the explanation; the calculated outputs supply the numbers. At a larger company, the same discipline makes a business-unit submission reviewable.

3. Calculate the plan with explicit formulas

Use the following columns on a spreadsheet worksheet, with the first business unit on row 2. Formulas work in common spreadsheet applications without a specialized planning package.

Enter the calculations in F2, G2 and H2, respectively, and fill down through row 3:

=B2*C2
=B2*D2
=F2-G2-E2

Total revenue, variable cost and profit on row 4:

=SUM(F2:F3)
=SUM(G2:G3)
=SUM(H2:H3)

The total check is 420,000 - 250,000 - 90,000 = 80,000. A spreadsheet check cell should equal zero:

=F4-G4-SUM(E2:E3)-H4

This subtotal excludes interest, income tax and any other lines outside the stated example. Variable cost here is a planning classification, not a claim that every variable cost belongs in accounting COGS. Map each expense to the company's reporting policy before comparing financial statements.

4. Compare the same rows with actual results

After close, import actual activity and realized rates without changing the plan. The actual-results worksheet uses the same columns and formulas.

Actual profit checks as 418,600 - 254,000 - 93,000 = 71,600. Revenue is $1,400 below plan, variable cost is $4,000 higher, and fixed expense is $3,000 higher. Therefore the profit gap is -1,400 - 4,000 - 3,000 = -$8,400.

All arithmetic in this example is exact; no rounding is required. In a real workbook, retain unrounded rates until the final presentation, particularly when quantities are large.

5. Reconcile the gap to changed drivers

To avoid overlapping effects, use planned contribution per activity unit for volume, actual activity for price and unit-cost changes, and the direct difference for fixed expense.

Volume effect = (Actual activity - Planned activity) × (Planned price - Planned variable unit cost)

Price effect = Actual activity × (Actual price - Planned price)

Unit-cost effect = -Actual activity × (Actual variable unit cost - Planned variable unit cost)

Fixed-expense effect = Planned fixed expense - Actual fixed expense

Positive effects increase profit. This chosen order assigns the interaction between activity and rate changes to the rate effects.

Parts volume is (1,900 - 2,000) × (150 - 90) = -6,000. Service price is 1,100 × (118 - 120) = -2,200. Every other cell follows the stated formulas from the plan and actual tables.

The complete identity is 80,000 - 1,000 + 1,600 - 6,000 - 3,000 = 71,600. It matches actual profit. For company-wide aggregation and eliminations, follow FP&A consolidation rather than assuming that all business-unit rows can simply be summed.

6. Assign decisions and extend the plan carefully

The unit-cost effect is the largest adverse driver in this example. Operations should substantiate the changed rates; sales should explain realized prices; budget owners should explain fixed spending. A reconciled bridge identifies the questions without proving their business causes.

Use FP&A goals to connect the review to measurable business outcomes. Choose forecast approaches separately: financial forecasting models compares drivers, trends and scenarios.

A profit result does not establish available cash. The SEC's guide to financial statements distinguishes profitability reported in an income statement from cash generation reported in a cash flow statement. Add collection timing, supplier payments and other balance-sheet movements before using this plan for liquidity decisions.

Where it goes wrong

• Mixed events. Comparing planned shipments with actual orders creates a timing gap that looks like a volume problem.
• Changed expense scope. Moving an account between fixed expense and unit cost changes the explanation. Reconcile classifications before interpreting the bridge.
• Duplicate shared costs. A corporate charge included centrally and in a unit submission overstates total expense. Identify allocations and eliminations explicitly.
• Overwritten assumptions. Replacing the approved inputs removes the comparison. Preserve a named plan version and a separate current outlook.
• Unexplained residuals. A bridge that fails to reach actual profit needs correction before management commentary. Do not label its remainder as an operational cause.

Compare your planning workbook in Covirage

Bring your supplied plan outputs, assumption table and matching actual-results export; Covirage maps the columns, and its tools compute and check the differences and reconciliations. The external AI model explains the computed results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See forecast analysis for the comparison context.