ExamFinch.com My Study

Study guide

11.2 Auditing and Balancing a 3-Statement Model

Practice this exam

Financial Modeling & Valuation Analyst FMVA

Track your progress as you read

Finished sections get a check mark.

1 Introduction

Current Exam Facts Program Path and How to Use This Guide

2 Chapter 1: Accounting Foundations

1.1 Accounting Principles 1.2 Reading Financial Statements 1.3 Accounting Decisions in Models

3 Chapter 2: Time Value and Capital Budgeting

2.1 Time Value of Money 2.2 NPV, IRR, and Decision Rules 2.3 Capital Budgeting Cash Flows

4 Chapter 3: Cost of Capital

3.1 Capital Structure 3.2 CAPM, Beta, and Cost of Equity 3.3 WACC

5 Chapter 4: Profitability and Returns

4.1 Profitability and Margins 4.2 Returns and DuPont Analysis 4.3 Per-Share Metrics and Growth

6 Chapter 5: Liquidity, Leverage, and Cash Flow

5.1 Liquidity and Working Capital Metrics 5.2 Leverage, Coverage, and Credit 5.3 Cash Flow Statement Analysis

7 Chapter 6: Excel Fundamentals

6.1 Shortcuts, Setup, and Navigation 6.2 Core Formulas and Error Handling 6.3 Named Ranges and Workbook Hygiene

8 Chapter 7: Excel Lookups and Financial Functions

7.1 Lookup Functions 7.2 Conditional Aggregations 7.3 Financial Functions

9 Chapter 8: Excel What-If Analysis and Auditing

8.1 Goal Seek and Data Tables 8.2 Formula Auditing and Protection

10 Chapter 9: Financial Modeling Guidelines

9.1 Model Structure and Layout 9.2 Color Conventions and Formatting 9.3 Integrity Checks and Documentation

11 Chapter 10: Three-Statement Modeling

10.1 Articulating the Three Statements 10.2 Building the Income Statement 10.3 Building the Balance Sheet and Cash Flow Statement

12 Chapter 11: Circularity and Model Audit

11.1 Circular References and Iteration 11.2 Auditing and Balancing a 3-Statement Model

13 Chapter 12: Operational Modeling

12.1 Revenue and Operating Drivers 12.2 Working Capital Modeling 12.3 Capex and Depreciation

14 Chapter 13: Debt Schedules, Scenarios, and Sensitivity

13.1 Debt and Interest Schedules 13.2 Scenario Analysis 13.3 Sensitivity Analysis

15 Chapter 14: Valuation Foundations

14.1 Valuation Methods and Enterprise Value 14.2 Unlevered Free Cash Flow

16 Chapter 15: DCF Valuation

15.1 DCF Structure, WACC, and Mid-Year Convention 15.2 Terminal Value and the Equity Bridge

17 Chapter 16: Comparable Valuation

16.1 Trading Comps and Multiples 16.2 Precedent Transactions and the Football Field

18 Chapter 17: Budgeting and Forecasting

17.1 Budget Types 17.2 Forecasting Techniques 17.3 Rolling Forecasts and Variance Analysis

19 Chapter 18: Presentation and Visuals

18.1 Chart Types and Selection 18.2 Dashboards and Data Visualization 18.3 PowerPoint and Pitchbooks 18.4 Presenting Model Outputs

20 Chapter 19: Professional Ethics and Qualitative Analysis

19.1 Professional Ethics 19.2 Qualitative Business Analysis

11.2 Auditing and Balancing a 3-Statement Model

Key Takeaways Explain This Topic AI

CFI audit order: (1) Assets − L − E = 0, (2) BS cash = CFS ending cash, (3) RE rollforward, (4) PP&E rollforward, (5) debt rollforward, (6) signs and units, (7) hardcoded numbers in forecast formulas (blue vs black), (8) error flags.

A balance sheet that balances is necessary but not sufficient: omitting the same item on both the CFS and RE (classic: dividends) keeps Assets = L+E while cash and equity are both wrong.

Forgetting a $1,000 D&A add-back on the CFS, with BS cash linked to CFS ending cash, produces Assets − L − E = −$1,000 because PP&E and RE already reflect depreciation.

Hunt a residual by changing one driver and watching which check does not move: if a $1,000 hole is unchanged when revenue moves, the break is not in the NI path.

CFI color convention: blue font = inputs/hardcodes (including the Circ Switch); black = formulas. A typed 1000 of D&A in a forecast year is a defect even if today's identity is $0.

Last updated: August 2026

Audit is a sequence, not a glance

Quick Answer: CFI's core course Auditing and Balancing a 3-Statement Model is a sequence , not a stare-at-the-BS moment. Work in this order: (1) Assets − Liabilities − Equity = 0 ; (2) cash on the BS equals CFS ending cash ; (3) retained earnings (RE) rollforward (beginning RE + NI − dividends = ending RE); (4) PP&E rollforward ; (5) debt rollforward ; (6) signs and units ; (7) hardcoded numbers inside forecast formulas (blue inputs vs black formulas); (8) error flags . A BS that balances is necessary but not sufficient — omitting the same item on both the CFS and RE (classic: dividends) keeps Assets = L+E while cash and equity are both wrong. Hunt a residual by changing one driver and watching which check does not move. A forgotten D&A add-back of $1,000 , with BS cash linked to the CFS, produces a $1,000 hole, not a mystery.

After the 27 February 2026 program refresh this course is required core (course 5 of 15), sitting immediately after 3-Statement Modeling . The FMVA final's Excel case studies are scored on whether the three statements still articulate when you toggle a driver — the same skill as this audit list. Circularity (Section 11.1) can create a residual of cents if Maximum Change is loose; a $1,000 residual is almost never iteration. It is a missed flow.

The eight-step order

Step Check Passes when Typical fail

1 BS identity Assets − (Liabilities + Equity) = 0 (tolerance about $0.01, or $1 if you round) Any flow that hit one side of the BS and not the other

2 Cash tie BS cash = CFS ending cash for that period BS cash independently rolled, or CFS missed a line

3 RE rollforward Beg RE + NI − dividends (− buybacks + other equity) = End RE NI linked to the wrong year; dividends on CFS only

4 PP&E rollforward Beg net PP&E + capex − D&A − disposals at net book = End Capex on the BS but not the CFS, or D&A on the IS but not the rollforward

5 Debt rollforward Beg + draws − paydowns (± FX) = End Revolver on the BS not equal to the cash-sweep schedule

6 Signs and units Inflows consistently signed on the CFS; thousands vs millions match the IS Capex entered as +8000 on a statement that expects (8000)

7 Blue vs black Forecast-year calculations are black formulas ; only drivers are blue hardcodes A typed 1000 of D&A in 2028 that no longer equals the depreciation schedule

8 Error flags A visible IF(ABS(balance)>tol,"ERROR","OK") dashboard, not a buried number No flag, so a $1,000 hole ships

Do not start at step 7. Color is how you prevent the next error; it does not tell you why this year is off by $1,000. Always get the identity and the cash tie first. A Circ Switch of 0 will make interest wrong on purpose ; the identity should still be $0. If turning the switch on creates the imbalance, the audit target is the interest/revolver block from 11.1, not the RE rollforward.

Worked balanced year (the control)

Use this as the live control so the two breaks below have a denominator. Opening BS: cash $5,000 , AR $2,000 , inventory $3,000 , net PP&E $10,000 (assets $20,000 ). AP $2,000 , debt $5,000 , common stock $8,000 , RE $5,000 .

Year-1 operations: revenue $20,000 , COGS $12,000 , cash SG&A $3,000 , D&A $1,000 → EBIT $4,000 . Interest $400 (8% on beginning debt — beginning-balance interest, so this control is not circular). EBT $3,600 , tax 25% = $900 , NI = $2,700 . AR +$500, inventory +$200, AP +$300, so ΔNWC = $400 . Capex $2,000 . Dividends $500 . No debt draws or paydowns.

  • CFS line Amount
  • Net income $2,700
  • + D&A 1,000
  • − ΔNWC (400)
  • Cash from operations $3,300
  • Capex (2,000)
  • Cash from investing $(2,000)
  • Dividends (500)
  • Cash from financing $(500)
  • Net change in cash $800
  • Opening cash 5,000
  • Ending cash $5,800

Ending BS: cash $5,800, AR $2,500, inventory $3,200, net PP&E $10,000 + $2,000 − $1,000 = $11,000 . Assets = $22,500 . AP $2,300, debt $5,000, common $8,000, RE $5,000 + $2,700 − $500 = $7,200 . L+E = $22,500 . Steps 1–5 all pass: identity $0, cash tie $5,800 = $5,800, RE/PP&E/debt rollforwards hold.

Keep this $22,500 total in view. Every broken-model example below is this same year with one formula ripped out. If your case file has several errors, still hunt them one driver at a time; stacking three fixes at once is how you create a fourth.

Worked break: forgotten $1,000 D&A add-back

Leave the IS, PP&E rollforward, RE, and every other CFS line alone. Drop only the +$1,000 D&A add-back on the CFS. New CFO = $2,700 − $400 = $2,300 . Net change in cash = $2,300 − $2,000 − $500 = −$200 . CFS ending cash = $4,800 .

If BS cash is linked to CFS ending cash (the CFI-standard construction), the BS becomes:

  • Assets = $4,800 + $2,500 + $3,200 + $11,000 = $21,500
  • L+E still $22,500 (RE still includes NI after D&A; PP&E is still net of D&A)
  • Assets − L − E = −$1,000

The hole equals D&A . Depreciation already reduced NI (and therefore RE) and already reduced net PP&E; those two hits net to zero inside the BS. The CFS must add D&A back so cash does not take the same hit a third time. Miss the add-back, and cash (an asset) is $1,000 too low — the textbook imbalance.

Diagnostic shock. Increase D&A from $1,000 to $2,000. A correct model still balances: NI and RE fall by $750 after tax; cash rises by the $250 tax shield; PP&E falls by another $1,000. With the add-back still missing, the imbalance moves from $1,000 to $2,000 . The check that moves one-for-one with D&A is the CFS add-back, not tax and not capex.

The same $1,000 hole appears if you forget dividends on only one statement , but the dollar amount then equals the dividend, not D&A. Do not memorize $1,000 as a magic constant. Memorize: the imbalance equals the flow that hit one side of the BS and not the other.

Worked break: dividends, including the false balance

Miss dividends only on the CFS (RE correctly subtracts $500): CFS ending cash = $6,300; assets $23,000; L+E $22,500; imbalance +$500 . Cash is too high by the unpaid dividend.

Miss dividends only on RE (CFS correctly pays $500): ending cash $5,800; RE $7,700 instead of $7,200; assets $22,500; L+E $23,000; imbalance −$500 .

Miss dividends on both CFS and RE: cash too high $500 and RE too high $500. Assets still equal L+E. Step 1 passes. Step 2 may also pass, because BS cash is tied to a CFS that is internally consistent with itself. Step 3 — the RE rollforward against NI and the dividend driver — is the check that catches it. This is why CFI's order puts the identity first and the RE rollforward third, and why it balances is not the end of the audit.

The same canceling-error pattern exists for other paired flows. Forget capex on the CFS while still adding it to PP&E and you break the identity by capex (cash too high). Forget a revolver draw on the CFS while still showing the debt on the BS and you break the identity the other way (cash too low). Forget the draw on both the CFS and the debt rollforward and the BS can balance with a silent understatement of leverage — another reason step 5 exists.

Hunting: change one driver

When the identity is a stubborn $1,000 (or $37.12), do not audit 400 formulas in random order. Shock one driver and watch the dashboard:

Shock What should move If it does not

Revenue +$1,000 (hold WC days constant at first) NI, RE, tax, cash; identity stays $0 NI moves but RE does not → RE is not linked to this year's NI

  • NI and RE move, CFS cash does not → CFS is not taking NI (or is hardcoded)
  • CFS cash moves, BS cash does not → step 2 failed; BS cash is a dead number

Everything moves and the $1,000 hole is unchanged → the break is not in the revenue/NI path (look at D&A, dividends, capex, debt, a signed WC line)

D&A +$1,000 Imbalance unchanged if add-back and PP&E rollforward are live Imbalance grows $1,000 → missing CFS add-back (this section's control)

Dividend driver +$500 Cash down $500, RE down $500, identity $0 Identity moves $500 → dividend is on only one of CFS or RE

Circ Switch 1 → 0 Interest and revolver-dependent cash move; identity stays $0 Identity appears only when the switch is 1 → the circle is feeding a stale or signed-wrong interest/revolver cell

Units and signs (step 6) are the cheap remaining traps: a model in $ thousands with capex typed as 2000000 instead of 2000 blows PP&E and cash by three orders of magnitude; a CFS that adds capex instead of subtracting it creates a hole equal to 2 × capex relative to a correctly reduced PP&E (cash too high by capex, PP&E down by capex).

Loading diagram... CFI Audit Order for a Three-Statement Model

Blue vs black and the flag dashboard

CFI / FMVA color convention: blue font = inputs (hardcodes, the Circ Switch, rates, minimum cash); black font = formulas. A forecast-year cell that shows 1000 with no formula, in blue or in black, is a hardcoded number in a forecast formula — step 7. It will not move when you shock D&A, which is exactly how the hunting table exposes it. Finding a blue 1000 inside a D&A line that is supposed to come from a depreciation schedule is an audit fail even if today's identity is $0, because next year's capex shock will not flow.

Put the checks where a reviewer (or you, 40 minutes into a case) can see them: Balance check: =Assets - Liabilities - Equity

  • Cash tie: =BS_Cash - CFS_Ending_Cash
  • RE check: =EndRE - (BegRE + NI - Dividends)
  • PPE check: =EndPPE - (BegPPE + Capex - DA)
  • Debt check: =EndDebt - (BegDebt + Draws - Paydowns)
  • Flag: =IF(OR(ABS(Balance)>0.01,ABS(CashTie)>0.01,ABS(RECheck)>0.01),"ERROR","OK")

Wire the flag to a cell with conditional formatting so ERROR is visible without scrolling to row 200. Cents of residual after a circular interest loop are usually Maximum Change, not a missing $1,000 add-back: tighten max change, or round the check to the nearest dollar if the case is in whole dollars, but do not hide a $1,000 hole inside a $1,000 tolerance.

On the timed Excel case, budget the first minutes after a driver change to this dashboard, not to formatting. If the flag is OK with Circ Switch = 0 and ERROR with Circ Switch = 1, go back to Section 11.1 and inspect average-balance interest and the revolver plug — the statements are articulated until the circle is turned on, which means the circle is feeding a signed-wrong or #REF!-adjacent cell.

Exam close for 11.2

Order: identity, cash tie, RE, PP&E, debt, signs/units, blue vs black, flags.

Forgotten D&A add-back → cash $1,000 too low → Assets − L − E = −$1,000 when PP&E and RE already reflect D&A.

Dividends missed on both CFS and RE can still balance — the RE rollforward is not optional.

Shock one driver; the check that will not move is the broken link.

Blue = input, black = formula; hardcoded forecast D&A is a defect even if today's identity is $0.