Study guide
10.3 Building the Balance Sheet and Cash Flow Statement
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
10.3 Building the Balance Sheet and Cash Flow Statement
Key Takeaways Explain This Topic AI
Ending net PP&E = beginning + capex − D&A; Clearwater Year 1 is $400,000 + $60,000 − $42,000 = $418,000.
Ending retained earnings = beginning + NI − dividends; Year 1 is $120,000 + $121,500 − $36,450 = $205,050.
Year 1 CFO = $121,500 + $42,000 − $12,000 ΔNWC = $151,500; ending cash = $50,000 + $151,500 − $60,000 − $56,450 = $85,050.
Cash is calculated as beginning cash + CFO + CFI + CFF, not independently forecast, unless you later model minimum cash and a revolver (circularity, Chapter 11).
When every roll-forward is linked, Year 1 total assets equal total liabilities and equity at $701,050 — that equality is the plug test, not a formatting check.
Last updated: August 2026
Building the Stocks, Then Reconciling Cash
The balance sheet is a snapshot. Every forecast year must still satisfy Assets = Liabilities + Equity . CFI's linking article is specific about which stocks carry the income-statement and cash-flow traffic: working-capital accounts, PP&E, debt, retained earnings, and cash.
Cash is calculated. You do not independently forecast it as a percent of sales in this chapter. The exception is a minimum-cash plus revolver structure, where excess cash or a short-term draw absorbs the residual so cash never falls below a floor. That structure creates a circular reference: interest depends on debt, debt depends on cash, cash depends on interest via NI. Chapter 11 covers circularity and iteration. Until then, ending cash = beginning cash + CFO + CFI + CFF, and that amount is the cash line on the balance sheet.
CFI also reminds you that the balance displayed is always the closing balance. Forecast the closing stocks. The cash flow statement uses the changes in those stocks.
Operating Working Capital: AR, Inventory, AP, and Other NWC
Operating net working capital in a compact FMVA model is:
NWC = Accounts receivable + Inventory − Accounts payable
A fuller model adds other operating current assets (prepaids, other current assets) and other operating current liabilities (accrued expenses, deferred revenue). Exclude cash and interest-bearing debt. Cash is the plug the cash flow statement explains. Debt is the debt schedule. Mixing them into NWC double-counts financing.
Clearwater uses a simple percent-of-sales structure that matches Year 0, which is the invert: historical percents become forecast drivers.
- Account Year 0 $ Year 0 % of sales Year 1 $ Year 2 $
- Accounts receivable $100,000 10.0% $110,000 $118,800
- Inventory $80,000 8.0% $88,000 $95,040
- Accounts payable $60,000 6.0% $66,000 $71,280
- Operating NWC $120,000 12.0% $132,000 $142,560
Year 1 ΔNWC = 132,000 − 120,000 = +$12,000 , a use of cash. Year 2 ΔNWC = 142,560 − 132,000 = +$10,560 . An increase in NWC is always a cash outflow on the indirect CFS; a decrease is a source.
If the case specifies days instead of percents: AR = DSO × revenue / 365, inventory = DIO × COGS / 365, AP = DPO × COGS / 365. Percents of sales are acceptable when the case is silent and the historical ratios are stable. What is not acceptable is holding AR, inventory, and AP in dollars while revenue grows 10%. That silently assumes a massive tightening of the cash conversion cycle and overstates cash.
Other NWC (prepaids, accruals, deferred revenue) follows the same rule: forecast the stock on the BS, then take the change on the CFS. An increase in prepaids is a use of cash. An increase in accrued expenses or deferred revenue is a source of cash. Clearwater's stub has none of these, so the ΔNWC line is a single number. In a case that has them, do not dump them into "other" on the BS without a matching CFS line — that is a classic cash break point hiding as a formatting choice.
- PP&E Roll-Forward
- Ending net PP&E = Beginning net PP&E + Capex − D&A
If assets are sold, subtract book value of disposals; any gain or loss goes to the income statement and is reversed on the CFS. Clearwater has no disposals.
- PP&E schedule Year 0 Year 1 Year 2
- Beginning net PP&E — $400,000 $418,000
- + Capex — $60,000 $55,000
- − D&A $40,000 $42,000 $45,000
- Ending net PP&E $400,000 $418,000 $428,000
Capex adds to PP&E and is a CFI outflow . D&A reduces PP&E, reduces EBIT on the income statement, and is added back on the cash flow statement because it was non-cash. All three D&A cells — P&L, CFS add-back, PP&E schedule — must be the same $42,000 in Year 1. Capex of $60,000 appears in the PP&E schedule and in CFI, not on the income statement.
Year 1 check: 400,000 + 60,000 − 42,000 = $418,000 . This is the first of the three common break points from 10.1. If you expense capex on the P&L, NI is too low, PP&E does not rise, and CFI still subtracts capex — a triple error. If you add D&A to PP&E instead of subtracting it, assets are $84,000 too high.
- Debt Roll-Forward and the Debt Schedule
- Ending debt = Beginning debt + draws − repayments
Interest lives on the income statement. Principal lives on the balance sheet. The change in principal lives in CFF. You need a debt schedule ; you cannot infer principal from the interest line alone (the coupon could change, or the firm could have drawn and repaid inside the year).
- Debt schedule Year 0 Year 1 Year 2
- Beginning debt — $200,000 $180,000
- Draws — $0 $0
- Repayments — $20,000 $20,000
- Ending debt $200,000 $180,000 $160,000
- Interest rate 8% 8% 8%
- Interest expense (on beginning) $16,000 $16,000 $14,400
Year 1 CFF includes −$20,000 of principal. Interest of $16,000 is already inside NI, so you do not put interest in CFF in a standard US GAAP indirect presentation (interest paid is an operating item in the starting NI). Putting interest in CFF and leaving it in NI double-counts the cash cost. Dividends, by contrast, are never an expense; they belong only in CFF and in the RE roll-forward.
- Retained Earnings Roll-Forward
- Ending RE = Beginning RE + NI − Dividends
CFI's projecting guidance is explicit: you do not forecast retained earnings as a percent of sales. You forecast NI (from the income statement) and dividends, then compute the closing RE. Dividends are not an expense. They do not hit EBIT. They reduce RE and they are a CFF outflow.
Clearwater pays 30% of NI: Year 1 dividends = 0.30 × 121,500 = $36,450 . Year 2 = 0.30 × 133,650 = $40,095 .
- RE schedule Year 0 Year 1 Year 2
- Beginning RE — $120,000 $205,050
- + Net income — $121,500 $133,650
- − Dividends — $36,450 $40,095
- Ending RE $120,000 $205,050 $298,605
Year 1: 120,000 + 121,500 − 36,450 = $205,050 . This is the second common break point. Forgetting dividends leaves RE at $241,500 and the BS will not balance by $36,450. Using EBITDA of $220,000 instead of NI leaves RE even further off.
Common stock is hardcoded at $250,000 in this stub (no issuance, no buybacks). If a case issues equity, the increase is CFF inflow and an increase in the equity stock, not income.
Indirect Cash Flow Statement
CFI models use the indirect method for CFO:
CFO = NI + D&A − ΔNWC (plus other non-cash and operating-accrual adjustments as the case requires)
Then CFI ≈ −Capex , and CFF = Δdebt − dividends (plus equity issues or buybacks if any).
- Change in cash = CFO + CFI + CFF
- Ending cash = Beginning cash + change in cash
- Cash flow Year 1 Year 2
- Net income $121,500 $133,650
- + D&A $42,000 $45,000
- − ΔNWC ($12,000) ($10,560)
- CFO $151,500 $168,090
- Capex ($60,000) ($55,000)
- CFI ($60,000) ($55,000)
- Debt repayment ($20,000) ($20,000)
- Dividends ($36,450) ($40,095)
- CFF ($56,450) ($60,095)
- Change in cash $35,050 $52,995
- Beginning cash $50,000 $85,050
- Ending cash $85,050 $138,045
Year 1: 121,500 + 42,000 − 12,000 = $151,500 ; 151,500 − 60,000 − 56,450 = $35,050 ; 50,000 + 35,050 = $85,050 . That $85,050 is the cash line on the Year 1 balance sheet. It is not a forecast assumption. This is the third common break point from 10.1.
Notice the quality gap the three statements were built to show: Year 1 NI is $121,500, EBITDA is $220,000, CFO is $151,500, and cash after capex, debt paydown, and dividends rises only $35,050. Those four numbers answer four different questions. Treating any one of them as "cash" is the accrual error from 10.1.
The Year 1 Balance Sheet Must Balance
- Balance sheet Year 0 Year 1 Year 2
- Cash (from CFS) $50,000 $85,050 $138,045
- Accounts receivable $100,000 $110,000 $118,800
- Inventory $80,000 $88,000 $95,040
- Net PP&E $400,000 $418,000 $428,000
- Total assets $630,000 $701,050 $779,885
- Accounts payable $60,000 $66,000 $71,280
- Debt $200,000 $180,000 $160,000
- Common stock $250,000 $250,000 $250,000
- Retained earnings $120,000 $205,050 $298,605
- Total liabilities and equity $630,000 $701,050 $779,885
Year 1 assets $701,050 = liabilities and equity $701,050. The plug test passed: CFS ending cash equals BS cash. RE rolled. PP&E rolled. Debt rolled. That is a finished Year 1 three-statement model, not a formatted income statement with a disconnected balance sheet.
Year 2 cross-check: cash $138,045 + AR $118,800 + inventory $95,040 + PP&E $428,000 = $779,885 . AP $71,280 + debt $160,000 + common stock $250,000 + RE $298,605 = $779,885 .
What Cash Is Not
Do not forecast cash as 5% of sales (Year 1 would be $55,000, not $85,050). Do not set cash equal to NI. Do not set cash equal to the change in RE. The only time you target a cash number is when you introduce a minimum cash balance and a revolver (or cash sweep) that draws or repays to hit the floor. That is Chapter 11, because interest, NI, cash, and the revolver all depend on each other. For the FMVA core three-statement build, cash is an output.
If the Year 1 sheet is off by $36,450 , look at dividends in RE and CFF. If it is off by $12,000 , look at the sign of ΔNWC. If it is off by $60,000 , look at whether capex hit PP&E and CFI once each. If it is off by $42,000 , look at whether D&A is the same on the P&L, the CFS, and the PP&E schedule. Articulation errors in this stub are almost always one of those four amounts — the exact dollars you already computed.