How do you build a three-statement financial model?

Start with income statement projections, then build supporting balance sheet and cash flow statements with proper linking and balancing checks.

Building a three-statement model requires systematic construction linking income statement, balance sheet, and cash flow statement. Start with historical data analysis to understand key drivers and relationships.

Step 1: Income Statement Begin with revenue projections based on underlying drivers (units, pricing, market growth). Build out cost structure including COGS, operating expenses, and non-operating items. Calculate EBITDA, depreciation, interest, taxes, and net income.

Step 2: Balance Sheet Project working capital items (receivables, inventory, payables) as percentages of relevant income statement items. Model PP&E based on capex assumptions and depreciation schedules. Build debt schedules and equity sections reflecting financing decisions.

Step 3: Cash Flow Statement Link operating cash flow starting with net income, adding back non-cash items, and incorporating working capital changes. Include investing activities (capex, acquisitions) and financing activities (debt, equity, dividends).

Critical Links:

• Net income flows to retained earnings
• Depreciation affects both income statement and PP&E
• Interest expense links to debt balances
• Cash flow ending balance equals balance sheet cash

Implement robust error checks ensuring balance sheet balances and cash flows tie properly. Include sensitivity analysis and scenario planning capabilities.

Emile Vincent-De Sloover from SDM-BlueBridge emphasizes the importance of maintaining model integrity through careful formula construction and regular validation.

For personalized guidance, consult a Financial Modeling specialist on TinRate.