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.

Loading diagram... Clearwater Year 1: cash is calculated; PP&E and RE roll; the sheet balances

Clearwater Year 1 cash walk (CFO + CFI + CFF)