Skip to content

Module 5: Constructing the Normalized 3-Statement Operating Model

Learning objectives and prerequisites

By the end of this lesson, you should be able to integrate statements without cash or equity plugs. Prerequisite knowledge: Normalized earnings and balance-sheet accounts. Work from assumptions to equations, explain the acquisition consequence, and record the evidence needed to rely on the answer.

Why a valuation forecast needs a balance sheet

An earnings forecast can claim that a manufacturer grows without purchasing inventory, extending customer credit, or replacing equipment. The arithmetic may be flawless while the business is impossible. An integrated three-statement model forces those omitted consequences into view. The income statement measures period performance, the balance sheet records accumulated resources and obligations, and the cash-flow statement explains how performance and investment change liquidity.

For an acquirer, integration is a practical discipline. A company may satisfy an EBITDA target while cash falls below payroll needs. Another may generate cash temporarily by delaying suppliers rather than improving operations. Only a linked model reveals which mechanism drives the result and whether the financing structure can tolerate it.

This chapter develops Vanguard Industrial Machining's normalized operating forecast in actual US dollars. It uses the $616,000 adjusted EBITDA base from Module 3, not Module 4's separate $565,000 challenge scenario. The forecast illustrates prospective recurring operations; it does not retroactively replace historical bank movements or complete acquisition purchase accounting.

Separate history, correction, normalization, and forecast

The model should preserve reported historical accounts, identify accounting corrections, and then show economic normalization. Reported EBITDA is $540,000; correcting $40,000 phantom inventory produces $500,000 corrected historical EBITDA. Owner, personal expense, lease, and repair normalization adds a net $116,000, producing $616,000 recurring EBITDA.

The historical inventory correction also reduces the opening inventory balance and accumulated equity by $40,000 in this simplified case. It creates no new cash payment when recognized. Economic normalization differs: replacing the owner's compensation changes the future cost structure, but it does not mean historical cash should be increased as if the owner had never been paid.

Our forecast begins after the inventory correction. The $40,000 loss must not be charged again in Year 1 EBITDA or Year 1 inventory movement. In a transaction, opening balances also depend on the assets acquired, liabilities assumed, closing working-capital mechanism, and purchase accounting. Those require a separate transaction schedule. Here the stated opening balance sheet is the agreed starting point for a standalone operating forecast.

Design a workbook that makes assumptions visible

Use separate sheets for sources, historical accounts, normalization, assumptions, revenue and costs, working capital, fixed assets, debt, statements, and checks. The exact names matter less than the separation between evidence, judgment, and formulas. An input should carry a period, unit, source or rationale, and scenario identifier.

Choose a sign convention and keep it consistent. In supporting schedules, this chapter stores expenses and liabilities as positive balances, then explicitly subtracts expenses in statements. In the cash-flow statement, cash outflows are negative. A negative expense accidentally subtracted again can make the model balance while overstating profit.

Columns should identify Year 0 actual or normalized reference, Year 1 forecast, and later periods. Links should use prior-year ending balances rather than copied opening inputs. A model is dynamic when changing a revenue or collection assumption updates all affected statements without manual repairs. A workbook with three separately typed statements is merely three tables.

Establish a corrected opening balance sheet

Before forecasting, verify that assets equal liabilities plus equity. Vanguard's corrected opening inventory is $500,000, after a $40,000 reduction from the reported $540,000. The corresponding equity reduction takes reported equity from $1,080,000 to $1,040,000. Ignore historical tax effects of that correction for this opening-balance teaching example; actual tax consequences require separate analysis.

Corrected opening balance Amount
Cash $200,000
Accounts receivable $600,000
Inventory $500,000
Operating prepayments $40,000
Net property, plant, and equipment $900,000
Total assets $2,240,000
Trade payables $350,000
Operating accrued liabilities $150,000
Financial debt $700,000
Equity $1,040,000
Total liabilities and equity $2,240,000

Operating NWC is $600,000 + $500,000 + $40,000 − $350,000 − $150,000 = $640,000. Cash and financial debt remain outside this definition. Keeping them separate prevents a financing draw from appearing to improve operating working-capital efficiency.

Forecast operations before financing

Year 0 normalized revenue is $4,500,000 and EBITDA is $616,000. Assume Year 1 revenue grows 5%, with the same normalized EBITDA margin. The margin is $616,000 / $4,500,000, approximately 13.6889%. Year 1 revenue is $4,725,000 and EBITDA is $646,800. Using the full ratio rather than a rounded 13.7% avoids unnecessary differences.

In a detailed factory model, growth would come from machine hours, utilization, realized rates, scrap, labor capacity, and customer orders. The constant-margin assumption is a deliberate simplification, not evidence that costs scale perfectly. It is suitable for teaching integration only if its limitations are explicit.

Year 1 D&A is $160,000 from the supplied fixed-asset schedule. EBIT is $646,800 − $160,000 = $486,800. Debt is $700,000 at the start of the year, and the forecast uses 8% interest on opening debt, producing $56,000 interest. Scheduled principal is handled separately and never deducted in calculating net income.

For prospective planning only, assume combined cash income taxes equal 25% of positive pretax income and are paid currently. This illustrative buyer-tax convention is not a statement that Vanguard's historical S corporation pays such entity taxes. There are no tax losses, deferred taxes, or book-tax depreciation differences in the forecast.

Complete the forecast income statement

Pretax income is $486,800 − $56,000 = $430,800. Taxes are $107,700 and net income is $323,100. These calculations measure the earnings that flow into equity before distributions, not the cash the bank account necessarily receives.

Year 1 income statement Amount
Revenue $4,725,000
Operating expenses before D&A ($4,078,200)
EBITDA $646,800
D&A ($160,000)
EBIT $486,800
Interest ($56,000)
Pretax income $430,800
Income taxes ($107,700)
Net income $323,100

The expense total is revenue less EBITDA. A production-level workbook should link it to underlying cost schedules rather than simply use that residual. For this introductory integration example, the stated margin controls those costs and allows the learner to focus on the movement between statements.

Forecast working capital from economic drivers

A simple first forecast grows each operating balance 5% with revenue. Receivables become $630,000, inventory $525,000, prepayments $42,000, payables $367,500, and accruals $157,500. This preserves opening balance-to-sales relationships. More sophisticated models use collection days, inventory turns, supplier terms, and department-specific drivers.

Year 1 NWC is $630,000 + $525,000 + $42,000 − $367,500 − $157,500 = $672,000. The increase is $32,000, which consumes cash. Do not subtract $672,000 in the cash-flow statement: the opening $640,000 is already embedded in the business.

Working-capital movement Change in balance Cash effect
Receivables +$30,000 −$30,000
Inventory +$25,000 −$25,000
Prepayments +$2,000 −$2,000
Payables +$17,500 +$17,500
Accruals +$7,500 +$7,500
Net cash effect NWC +$32,000 −$32,000

Receivable balances should respond to collection assumptions independently of revenue growth. A client can pay more slowly even when sales stay flat. Inventory may rise faster than sales because of longer lead times or inefficient production. These relationships become important downside drivers once the basic model works.

Fixed assets: connect investment, depreciation, and capacity

Year 1 cash CapEx is $220,000. Opening net PP&E is $900,000 and D&A is $160,000, producing ending net PP&E of $960,000 under the case assumption that all D&A reduces this asset category and there are no disposals or separate intangibles. A real model should split depreciation and amortization when they relate to different balance-sheet accounts.

The roll-forward is opening net PP&E plus capital additions less depreciation and the carrying value of disposals. Cash proceeds from disposals and any gains require separate treatment. Do not reduce PP&E by cash sale proceeds if those differ from book value, and do not leave a gain in operating profit while also counting all proceeds as operating cash.

For Vanguard, the supplied $160,000 is a schedule output, not a claim that CapEx and depreciation are equal. Asset classes, purchase dates, useful lives, and residual values explain the depreciation path. Maintenance and growth CapEx can be separated analytically, but both reduce cash when paid.

Debt and equity: operating consequences of capital decisions

The company repays $100,000 principal and raises no new debt, so ending debt is $600,000. Principal reduces cash and a liability, not earnings. Interest expense is $56,000 under the opening-balance convention. Modeling interest on opening debt avoids a circular reference between cash, debt draws, and interest in this simplified annual schedule.

The owner receives $120,000 in distributions. Ending equity is opening equity of $1,040,000 plus net income of $323,100 less distributions of $120,000, or $1,243,100. Distributions are not a second operating expense. If a forecast deducts them in both net income and financing cash flow, it understates equity and cash inconsistently.

Actual acquisition financing can replace existing debt and create fees, seller notes, or new equity. Those belong in a separate sources-and-uses and opening-transaction schedule. The current example isolates operating integration and should not be interpreted as a recommendation to assume the seller's debt.

Build operating cash flow from net income

The indirect cash-flow method begins with net income, adds back noncash expenses, and adjusts for operating balance changes. Year 1 operating cash flow is $323,100 + $160,000 − $32,000 = $451,100. Cash interest and cash income taxes are already reflected through net income under the stated convention, so they are not subtracted again here.

Net income                                  323,100
Add back D&A                                 160,000
Less increase in operating NWC               (32,000)
Operating cash flow                          451,100

Capital expenditure                         (220,000)
Scheduled debt principal                    (100,000)
Owner distributions                         (120,000)
Net increase in cash                          11,100
Opening cash                                 200,000
Ending cash                                  211,100

The result explains why $646,800 EBITDA becomes only $11,100 additional cash after the stated taxes, interest, investment, principal, and distributions. There is no contradiction. Each measure describes a different stage in allocating operating resources.

Close the balance sheet using calculated cash

Ending cash must link directly to the cash-flow statement's $211,100. It must not be typed as a balancing number. The other balances come from their respective schedules. The final check is then an independent consequence of the links.

Year 1 ending balance sheet Amount
Cash from cash-flow statement $211,100
Receivables $630,000
Inventory $525,000
Prepayments $42,000
Net PP&E $960,000
Assets $2,368,100
Payables $367,500
Accruals $157,500
Debt $600,000
Equity $1,243,100
Liabilities plus equity $2,368,100
Assets minus liabilities minus equity $0

The equality is necessary but does not establish economic plausibility. An unsupported loan can make a model balance. A false inventory figure can appear on both sides through earnings and still pass. The analyst therefore needs source checks, schedule roll-forwards, and business constraints as well as the accounting equation.

Dynamic diagnosis: change an assumption and follow it

Increase ending receivables by $50,000 while keeping earned revenue and collectibility unchanged. Operating NWC increases another $50,000, OCF falls to $401,100, and ending cash falls to $161,100. Receivables rise by exactly the cash decline, leaving total assets unchanged. Earnings and equity do not change.

Increase cash CapEx by $30,000 while keeping current-year D&A fixed for this isolated test. Ending PP&E rises $30,000 and cash falls $30,000. Future depreciation must then reflect the added assets. The assumption of unchanged current-year D&A is a testing convention, not a complete asset-life forecast.

Seller Tricks & Red Flags: “The balance sheet balances, so the model is correct.”

A plug to cash, equity, or miscellaneous liabilities can force equality while concealing omitted payments. Cash should come from the cash-flow statement, equity from its roll-forward, and financing from an explicit funded arrangement.

Liquidity and the bridge back to valuation

Assume minimum operating cash is $180,000. The base ending $211,100 provides a $31,100 buffer, but the additional $50,000 collection delay breaches the floor by $18,900. A model should flag that shortfall rather than silently assume a revolver exists. Monthly timing can produce an even larger intra-year deficit.

For enterprise valuation, use unlevered operating taxes rather than the financing case's tax expense. EBIT of $486,800 at 25% produces NOPAT of $365,100. UFCF is $365,100 + $160,000 − $220,000 − $32,000 = $273,100. OCF less CapEx is $231,100; the $42,000 difference equals after-tax interest of $56,000 × 75%.

This reconciliation connects Course 2 to the DCF framework without confusing cash available to all capital providers with cash left after interest. Different analyses can use the same operating schedules while retaining consistent cash-flow definitions.

Self-Study Problem Set

Using the chapter's Year 1 inputs, calculate OCF, ending cash, ending debt, and ending equity without referring to the final balance sheet.

Solution moved to the separate instructor key.

Problem 2: remove distributions

Assume distributions are zero rather than $120,000, with every other assumption unchanged. Determine cash, equity, and the balance-sheet effect.

Solution moved to the separate instructor key.

Problem 3: use explicit financing

The company borrows $75,000 on the last day of Year 1. Assume no current-year interest on that last-day draw and no fees. What changes?

Solution moved to the separate instructor key.

Problem 4: find the opening-correction error

A learner starts with corrected inventory of $500,000 but also deducts the old $40,000 inventory correction from Year 1 EBITDA and again in the NWC schedule. Explain the problem.

Solution moved to the separate instructor key.

Spreadsheet construction and audit lab

Build operating schedules first, calculate net income, then indirect OCF, investing and financing. Link ending cash into the balance sheet and equity through retained earnings less distributions.

Use named row labels and explicit units. Blue-font inputs should contain assumptions or source data; black-font formulas should calculate results from those inputs. Reproduce the worked example first, then change one economically important assumption and predict the direction of the result before recalculating. Save a base case and a dated challenge case rather than silently replacing assumptions. A zero arithmetic check does not establish an executable deal.

Learning summary and further reading

Integrate statements without cash or equity plugs. The acquisition decision depends on the bridge between source evidence, modeled cash and the claim being valued. Explain what the model includes, what it omits, and which outstanding evidence could reverse your conclusion. Consult the source and alignment references for attributed public reading; fictional case assumptions are not market observations or legal approvals.

Previous module · Course overview · Next module

Independent assessment

Complete the student assignment before consulting the separate instructor key. The chapter's worked examples teach the method; the assignment uses independent inputs.