Study guide
10.2 Building the Income 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.2 Building the Income Statement
Key Takeaways Explain This Topic AI
Clearwater Tools Year 1 net income is $121,500: EBIT $178,000 minus interest $16,000 equals EBT $162,000, tax at 25% is $40,500.
Year 1 D&A is $42,000 from the PP&E schedule, not 4.0% of $1,100,000 revenue ($44,000).
Interest is $16,000 from beginning debt $200,000 × 8%, not a percent of sales; Year 2 interest falls to $14,400 after the $20,000 principal repayment.
Do not forecast NI as 10.8% of revenue while also independently forecasting COGS%, SG&A, D&A, interest, and tax — the residual NI is $121,500, not the forced $118,800.
CFI projecting order: build the P&L through SG&A, complete PP&E and debt schedules for D&A and interest, then finish tax and NI, then retained earnings and cash.
Last updated: August 2026
Building a Driver-Based Income Statement
The income statement in a three-statement model is not a list of independently guessed dollars. It is a driver-based calculation: you set a small number of assumptions, and every P&L line is a formula. CFI's standard walk is:
Revenue → COGS → Gross profit → SG&A → D&A → EBIT → Interest → EBT → Tax → Net income
Some models fold D&A into SG&A on the face of the P&L and show it separately only in the notes and on the cash flow statement. Either presentation is fine if D&A is still sourced from the PP&E schedule , not from a free percent of revenue, and if the same D&A number is added back in CFO.
The drivers that belong on an assumptions tab, or in a clearly marked blue-input row, are:
- Driver Typical construction What it is not
- Revenue growth (Rev_t / Rev_{t-1}) − 1 Not a hardcoded revenue dollar in the forecast years
- COGS % COGS / Revenue Not a COGS dollar that ignores the percent when sales change
- SG&A % SG&A excluding D&A / Revenue Not a dump of every overhead dollar with no link to sales
- D&A From the PP&E / depreciation schedule Not a free percent of revenue
- Interest From the debt schedule Not a free percent of revenue or a copy of last year's interest
- Tax rate Tax / EBT (effective rate) Not tax as a percent of revenue
Do not circularly pick NI as a percent of revenue while also independently forecasting everything above it. Year 0 Clearwater NI is $108,000 on $1,000,000 of sales, a 10.8% net margin. If you force Year 1 NI = 10.8% × $1,100,000 = $118,800 and you also forecast COGS 58%, SG&A 22%, D&A $42,000, interest $16,000, and tax at 25%, you have two different net incomes. The residual NI is $121,500 . The forced-margin NI is $118,800. The $2,700 gap has nowhere honest to go: you will break RE, plug the gap into a mystery "other expense," or the balance sheet will not balance. Net margin is an output. You may use it as a sense-check (is 11.0% plausible versus 10.8% history?) but you do not type it as a forecast input when the lines above NI are already determined.
The Model Inverts at the Last Historical Year
Clearwater Tools has one historical year (Year 0) and two forecast years (Year 1 and Year 2). In the workbook, Year 0 income-statement dollars are hardcoded from the financials . Formulas compute the drivers:
Revenue growth is not computed in Year 0 (this stub has no Year −1); it becomes an input starting in Year 1.
- COGS % = 580,000 / 1,000,000 = 58.0%
- SG&A excluding D&A % = 220,000 / 1,000,000 = 22.0%
D&A = $40,000 from the PP&E schedule, which happens to be 4.0% of sales in Year 0 — a coincidence, not a driver.
- Interest = $16,000 (beginning debt $200,000 × 8%)
- Effective tax rate = 36,000 / 144,000 = 25.0%
- Net margin (output, not a driver) = 108,000 / 1,000,000 = 10.8%
Forecast years invert: you hardcode 10% then 8% revenue growth, hold COGS at 58% and SG&A at 22% , pull D&A from the schedule ( $42,000 then $45,000 ), pull interest from the debt schedule ( $16,000 then $14,400 ), and hold tax at 25% . The statements compute. Copying Year 0's $580,000 of COGS into Year 1 is the invert failure: you treated a forecast year as if it were historical.
Worked Three-Year Income-Statement Stub
Revenue path: Year 0 $1,000,000 (hardcoded). Year 1 = 1,000,000 × 1.10 = $1,100,000 . Year 2 = 1,100,000 × 1.08 = $1,188,000 .
COGS = 58% of revenue. Year 0 $580,000 (hardcoded, which implies 58%). Year 1 = 0.58 × 1,100,000 = $638,000 . Year 2 = 0.58 × 1,188,000 = $689,040 .
SG&A excluding D&A = 22% of revenue. Year 0 $220,000. Year 1 = $242,000 . Year 2 = $261,360 .
D&A from the PP&E schedule in section 10.3: Year 0 $40,000 , Year 1 $42,000 , Year 2 $45,000 . Do not replace these with 4.0% of sales. That shortcut would put Year 1 D&A at $44,000 and immediately desync the P&L from PP&E and from the CFS add-back. D&A is a function of the asset base, useful lives, and capex timing, not of this year's revenue.
Interest from the debt schedule: beginning Year 1 debt $200,000 × 8% = $16,000 . After a $20,000 Year 1 repayment, beginning Year 2 debt $180,000 × 8% = $14,400 . Using beginning-of-year principal avoids circularity (interest depends on debt; cash depends on interest via NI; a revolver would make debt depend on cash). Minimum-cash and revolver circularity is Chapter 11. This chapter uses beginning debt so the income statement can close without iteration.
Tax = 25% × EBT. There is no tax on a percent of revenue. Interest tax-shields EBT, so a firm with more debt has a lower tax dollar even at the same EBIT. Year 1 tax of $40,500 is 3.7% of sales and 22.8% of EBIT — neither percentage is a driver.
- Line Year 0 (historical) Year 1 (forecast) Year 2 (forecast)
- Revenue $1,000,000 $1,100,000 $1,188,000
- COGS (58%) $580,000 $638,000 $689,040
- Gross profit $420,000 $462,000 $498,960
- SG&A ex-D&A (22%) $220,000 $242,000 $261,360
- D&A (schedule) $40,000 $42,000 $45,000
- EBIT $160,000 $178,000 $192,600
- Interest (debt schedule) $16,000 $16,000 $14,400
- EBT $144,000 $162,000 $178,200
- Tax (25%) $36,000 $40,500 $44,550
- Net income $108,000 $121,500 $133,650
- Gross margin 42.0% 42.0% 42.0%
- EBIT margin 16.0% 16.2% 16.2%
- Net margin (output) 10.8% 11.0% 11.3%
- Year 1 arithmetic
- Gross profit = 1,100,000 − 638,000 = $462,000
- EBIT = 462,000 − 242,000 − 42,000 = $178,000
- EBT = 178,000 − 16,000 = $162,000
- Tax = 0.25 × 162,000 = $40,500
- NI = 162,000 − 40,500 = $121,500
Net margin rose from 10.8% to 11.0% without any extra "margin improvement" lever. Revenue grew, COGS% and SG&A% were held flat, D&A rose only $2,000 (less than 10% of the revenue increase), and interest was unchanged in Year 1 because the repayment is modeled at year-end. Operating leverage plus a lagging interest line is enough to lift net margin. Year 2 lifts it again because interest falls to $14,400 after the Year 1 principal paydown. If you had locked NI at 10.8% of sales, you would have erased that real, mechanical improvement and booked $118,800 instead of $121,500.
EBITDA is not on the face of this P&L, but it is a useful cross-check: Year 1 EBITDA = EBIT $178,000 + D&A $42,000 = $220,000 . That $220,000 is still not cash. Section 10.3 will show Year 1 CFO of $151,500 after ΔNWC, and cash after capex, debt paydown, and dividends rising only $35,050.
Order of Operations
CFI's guide to projecting balance-sheet line items gives the practical sequence, because D&A and interest are not free P&L inputs:
Project the income statement down to, but not including, D&A and interest (revenue, COGS, SG&A excluding D&A).
Project the balance-sheet working-capital accounts and the PP&E and debt schedules , which produce D&A and interest.
Finish the income statement: D&A, interest, tax, NI.
Finish the balance sheet: retained earnings (needs NI) and cash (needs the cash flow statement).
You will feel this order in Excel. You cannot type Year 1 D&A on the P&L until the PP&E schedule exists. You cannot type Year 1 interest until the opening debt balance is known. You cannot close RE until NI is known. You cannot close cash until CFO, CFI, and CFF are known. That is not a formatting preference. It is the dependency graph of an articulated model.
Exam Traps on the Income Statement Build
D&A as a percent of sales. History may look like 4.0% ($40,000 / $1,000,000). Using 4.0% in Year 1 gives $44,000, not the schedule's $42,000. The BS and CFS then disagree with the P&L.
Interest as a percent of sales. Interest is a function of debt and the coupon, not of revenue. Clearwater's sales rise 10% in Year 1; interest does not.
Tax as a percent of sales or of EBIT. Tax is on EBT. Interest tax-shields the tax line.
Hardcoding forecast dollars that should be drivers. If the case changes growth from 10% to 12% and your COGS does not move, you hardcoded the wrong thing.
Forcing NI or EBITDA as a percent of revenue in addition to the line-item drivers. One residual, not two.
Mixing historical hardcodes into forecast formulas by copying Year 0 dollars across instead of copying Year 0 percents.
The income statement is now a residual machine that will feed RE and CFO. Section 10.3 builds the stocks and the cash reconciling statement that make the residual land on a balanced sheet.