Forecasting the Cash Flow Statement: A Core Financial Modeling Skill

Forecasting the Cash Flow Statement is a critical component of financial modeling, providing insights into a company's ability to generate cash, meet its obligations, and fund its operations and growth. It's a forward-looking projection that helps analysts, investors, and management understand the future financial health of a business.

Understanding the Three Sections of the Cash Flow Statement

The Cash Flow Statement is typically divided into three main sections: Cash Flow from Operations (CFO), Cash Flow from Investing (CFI), and Cash Flow from Financing (CFF). Each section captures different types of cash movements.

Section	Focus	Key Components
Cash Flow from Operations (CFO)	Cash generated from a company's core business activities.	Net Income, Depreciation & Amortization, Changes in Working Capital (Accounts Receivable, Inventory, Accounts Payable).
Cash Flow from Investing (CFI)	Cash used for or generated from investments in long-term assets.	Purchase/Sale of Property, Plant, and Equipment (PP&E), Investments in Securities.
Cash Flow from Financing (CFF)	Cash flows related to debt, equity, and dividends.	Issuance/Repayment of Debt, Issuance/Repurchase of Stock, Payment of Dividends.

Forecasting Methodology: The 'Build-Up' Approach

The most common method for forecasting the Cash Flow Statement is the 'build-up' approach, which starts with projected Net Income and then adjusts for non-cash items and changes in working capital. This method leverages the Income Statement and Balance Sheet forecasts.

Forecasting CFO involves adjusting Net Income for non-cash items and working capital changes.

To forecast Cash Flow from Operations (CFO), you begin with projected Net Income. Then, you add back non-cash expenses like Depreciation and Amortization. Next, you account for changes in working capital accounts, such as increases in Accounts Receivable (a cash outflow) or decreases in Inventory (a cash inflow).

The forecasting process for CFO typically involves the following steps:

Project Net Income: This is derived from the forecasted Income Statement.
Add back Non-Cash Expenses: Depreciation and Amortization are added back because they reduce Net Income but do not involve an actual cash outflow.
Adjust for Changes in Working Capital:
- Accounts Receivable (AR): An increase in AR means customers owe more, representing a cash outflow. A decrease means more cash collected, a cash inflow.
- Inventory: An increase in inventory means cash was spent to acquire it (outflow). A decrease means inventory was sold, generating cash (inflow).
- Accounts Payable (AP): An increase in AP means the company owes more to suppliers, delaying cash outflow (inflow). A decrease means more cash was paid to suppliers (outflow).
- Other Current Assets/Liabilities: Similar adjustments are made for prepaid expenses, accrued liabilities, etc.

Why is Depreciation added back when forecasting Cash Flow from Operations?

Depreciation is added back because it is a non-cash expense that reduces Net Income but does not represent an actual outflow of cash.

Forecasting Cash Flow from Investing (CFI)

CFI forecasts typically involve projecting capital expenditures (CapEx) for property, plant, and equipment (PP&E) and any anticipated sales of long-term assets. These are usually driven by management's strategic plans for growth and asset management.

CFI reflects investments in and divestments from long-term assets.

Forecasting CFI involves projecting spending on new long-term assets (like machinery or buildings) and any cash received from selling existing assets. This is often linked to the company's growth strategy and capital investment plans.

Forecasting Cash Flow from Investing (CFI) requires understanding the company's capital expenditure (CapEx) plans and its strategy for managing its asset base. Key elements include:

Capital Expenditures (CapEx): This is the cash spent on acquiring or upgrading physical assets like property, plant, and equipment. CapEx forecasts are often derived from management projections, historical spending trends, and planned expansion or replacement cycles.
Sales of Long-Term Assets: If a company plans to sell off assets (e.g., a division, old equipment), the cash proceeds from these sales are included as a cash inflow.
Investments in Other Companies: Purchases or sales of securities in other entities are also part of CFI.

Forecasting Cash Flow from Financing (CFF)

CFF forecasts focus on how the company plans to raise or repay capital. This includes projections for debt issuance and repayment, equity issuance and buybacks, and dividend payments.

CFF captures cash flows related to debt, equity, and dividends.

Forecasting CFF involves projecting how the company will manage its debt and equity. This includes expected new borrowings, debt repayments, stock issuances or repurchases, and dividend payouts to shareholders.

Forecasting Cash Flow from Financing (CFF) involves projecting the company's activities related to its capital structure:

Debt Financing: This includes forecasting new debt issuances (cash inflow) and scheduled debt repayments (cash outflow). Interest payments are typically handled in the Income Statement and adjusted for in CFO.
Equity Financing: This includes cash received from issuing new stock (inflow) and cash spent on repurchasing its own stock (outflow).
Dividends: Projected dividend payments to shareholders are a cash outflow.

Connecting the Forecasts: The Cash Flow Statement Model

The final step is to integrate these forecasted components into a coherent Cash Flow Statement. The sum of CFO, CFI, and CFF, plus the beginning cash balance, should equal the ending cash balance, which must then reconcile with the projected Balance Sheet.

The Cash Flow Statement links the Income Statement and Balance Sheet. Forecasting involves projecting changes in balance sheet accounts (working capital, PP&E, debt, equity) and non-cash items (depreciation) to derive cash flows. Net Income from the Income Statement is the starting point for CFO. Changes in operating assets and liabilities (like AR, Inventory, AP) directly impact CFO. Capital expenditures (changes in PP&E) and asset sales impact CFI. Changes in debt and equity accounts, along with dividends, impact CFF. The sum of these cash flows, added to the beginning cash balance, must equal the ending cash balance shown on the projected Balance Sheet.

📚

Text-based content

Library pages focus on text content

A robust cash flow forecast is essential for understanding a company's liquidity, solvency, and its capacity for future investment and growth.

Key Considerations for Accurate Forecasting

Accuracy in cash flow forecasting relies on sound assumptions about economic conditions, industry trends, company-specific strategies, and the relationships between different financial statement items. Sensitivity analysis and scenario planning are crucial for understanding the potential range of outcomes.

What are the three main sections of the Cash Flow Statement?

Cash Flow from Operations (CFO), Cash Flow from Investing (CFI), and Cash Flow from Financing (CFF).

Learning Resources

Financial Modeling & Valuation Analyst (FMVA) Certification(tutorial)

Offers comprehensive courses on financial modeling, including detailed modules on building cash flow statements from scratch.

Investopedia: How to Build a Cash Flow Statement(documentation)

Provides a foundational understanding of the cash flow statement's structure and purpose, with examples.

Corporate Finance Institute: Cash Flow Statement(documentation)

Explains the components of the cash flow statement and how to prepare it, including direct and indirect methods.

Khan Academy: Statement of cash flows(video)

A clear video introduction to the statement of cash flows and its importance in financial analysis.

Accenture: Financial Modeling Best Practices(blog)

Discusses best practices in financial modeling, which implicitly covers robust cash flow forecasting techniques.

The Financial Modeling Handbook(paper)

A highly regarded book that covers the intricacies of financial modeling, including detailed sections on cash flow forecasting.

Wikipedia: Cash flow statement(wikipedia)

Offers a broad overview of the cash flow statement, its history, and its accounting principles.

BIWS: Financial Modeling Training(tutorial)

Provides practical, hands-on training in financial modeling, with a strong emphasis on building integrated financial statements including cash flow.

McKinsey & Company: The art of financial forecasting(blog)

Explores the nuances and challenges of accurate financial forecasting, offering strategic insights.

CFI: How to Build a 3-Statement Model(tutorial)

A step-by-step guide on building an integrated three-statement model, which is fundamental for cash flow forecasting.