Financial Models in Practice · Part 1 of 16
Free Cash Flow Explained: The Number Every Analyst Needs to Understand
There is a moment in every finance student’s journey when they realise that the profit figure on an income statement is, in some sense, an opinion. A very carefully calculated, auditor-verified opinion — but an opinion nonetheless. Accounting rules give companies significant flexibility in when they recognise revenue, how quickly they depreciate assets, and whether certain costs are expensed immediately or capitalised over many years. All of these choices affect profit without necessarily affecting the cash sitting in the bank account.
Free Cash Flow strips out that noise. It measures the actual cash a business generates after funding its operations and maintaining or growing its asset base. It is the cash available to pay dividends, repay debt, make acquisitions, or simply accumulate on the balance sheet.
If you want to understand why investors pay the prices they do for businesses, why some profitable companies go bankrupt, and how virtually every valuation model works — start here.
Why “Profit” Can Mislead You
Consider two companies, both reporting £500,000 of net profit.
Company A is a software business. Its main costs are salaries, which are paid in cash. It receives payment upfront from customers. It has almost no physical assets to maintain. Its £500,000 profit is closely aligned with actual cash generated.
Company B is a manufacturer. To support the same profit, it has spent heavily on new machinery (capital expenditure), built up a large inventory ahead of a seasonal peak, and extended generous payment terms to new customers. The cash it collected this year is significantly less than its profit — and it may actually need to borrow to fund its operations.
Profit alone cannot tell you which company is in a stronger position. Free Cash Flow can.
This distinction is not academic. Companies like Enron and WorldCom posted impressive profits right up until their collapse. The cash flow statements told a different story for anyone who was paying attention. At the other extreme, Amazon reported near-zero profits for over a decade while generating substantial free cash flow — and the market valued it accordingly.
What Exactly Is Free Cash Flow?
At its most intuitive, FCF answers this question:
“After the business has paid for everything it needs to keep running and growing, how much real money is left over?”
You will encounter two closely related versions of this concept throughout your finance career:
Free Cash Flow to Firm (FCFF) — sometimes called unlevered FCF — measures the cash available to all capital providers: both debt holders and equity holders. This is the number used in a DCF valuation because it represents total cash generation before any financing decisions. It is independent of how the business is funded.
Free Cash Flow to Equity (FCFE) — sometimes called levered FCF — measures the cash left over specifically for equity shareholders, after paying interest and net debt repayments. This is the number a founder or equity investor focuses on when thinking about dividends or share buybacks.
For this guide we will focus on FCFF, since it is the most widely used version in coursework, interviews, and professional models. Once you understand FCFF, FCFE is a short extension (you simply deduct after-tax interest and net debt repayments).
The FCF Formula — Two Approaches
There are two standard routes to calculating FCFF. They arrive at the same answer; which one you use depends on what data is available to you.
Approach 1 — Starting from EBIT (most common in financial models)
FCFF = EBIT × (1 − Tax Rate) + D&A − CapEx − ΔNWC
Let us break down each component:
EBIT × (1 − Tax Rate) = NOPAT NOPAT stands for Net Operating Profit After Tax. We start from EBIT (earnings before interest and tax) rather than net income so that the result is unaffected by the company’s financing structure — a company with no debt and a company with heavy borrowings will have the same NOPAT if their underlying operations are identical. We then apply the tax rate to arrive at what the business would pay in taxes if it had no interest deductions.
+ Depreciation & Amortisation (D&A) D&A is a non-cash accounting charge. When a company buys a machine for £1 million and depreciates it over 10 years, it records £100,000 of depreciation expense each year — but no cash leaves the business in years 2 through 10. Because D&A reduced EBIT (and therefore NOPAT), we add it back to recover the non-cash portion.
− Change in Net Working Capital (ΔNWC) Net Working Capital = Current Assets (receivables + inventory) − Current Liabilities (payables). When a business grows, it typically needs to tie up more cash in working capital — more stock on the shelves, more credit extended to customers. That tied-up cash is real money leaving the business. A positive increase in NWC is a cash outflow. This is one of the most frequently mis-signed items in student models — pay careful attention to the sign convention.
− Capital Expenditure (CapEx) Money spent on buying or maintaining tangible assets: machinery, vehicles, buildings, servers. This is real cash out the door. It does not appear on the income statement (instead it is capitalised on the balance sheet and then depreciated), so we must subtract it explicitly in the FCF calculation.
Approach 2 — Starting from Net Income (useful when reading published accounts)
FCFF = Net Income + D&A + Interest × (1 − Tax Rate) − CapEx − ΔNWC
Here we add back after-tax interest to “un-lever” the metric — removing the financing effect that is already embedded in net income — and arrive at the same firm-level figure as Approach 1.
A Simple Worked Example: WidgetCo Ltd
Let us make this concrete with a fictional UK manufacturer, WidgetCo Ltd. The numbers are deliberately simple — you should be able to recreate this on a single spreadsheet in under 20 minutes.
Income Statement Extract — Year 1 (£000s)
| Line Item | £000 |
|---|---|
| Revenue | 5,000 |
| Cost of Goods Sold | (3,000) |
| Gross Profit | 2,000 |
| Operating Expenses | (1,050) |
| EBITDA | 950 |
| Depreciation & Amortisation | (200) |
| EBIT | 750 |
| Tax @ 25% | (188) |
| NOPAT | 562 |
FCF Bridge (£000s)
| Item | £000 |
|---|---|
| NOPAT | 562 |
| + Depreciation & Amortisation | 200 |
| − Increase in Net Working Capital | (80) |
| − Capital Expenditure | (300) |
| Free Cash Flow to Firm | 382 |
Interpreting the numbers:
The D&A add-back (£200k) recovers the non-cash charge that reduced EBIT. The NWC build (£80k outflow) reflects WidgetCo launching a new product line: it needed to build inventory ahead of launch and extended credit to several new retail customers. The CapEx (£300k) covers both replacing worn-out equipment — roughly £150k of maintenance CapEx — and buying a second production press to support the new product — roughly £150k of growth CapEx.
The resulting FCF of £382k means WidgetCo generated this much real, distributable cash from its operations. A FCF yield of 7.6% on £5m of revenue is entirely plausible for a capital-light manufacturer.
Tip for students: When working through a case study and CapEx is not disclosed directly, back it out from the balance sheet:
CapEx ≈ Closing PP&E − Opening PP&E + D&A. This is a standard technique used in equity research.
Step-by-Step Build in Excel (or Google Sheets)
Here is a structured approach for building a clean FCF model. Work through these steps in order — the structure matters as much as the formulas.
Step 1 — Create your tab structure
Open a new workbook and create four tabs: Assumptions, P&L, Working Capital, and FCF Bridge. Keeping inputs on a dedicated Assumptions tab is the single most important structural habit you can develop. It means anyone reviewing your model can find every hardcoded number in one place.
Step 2 — Enter the P&L drivers in Assumptions
Hardcode the following (using blue font, the professional convention for inputs):
- Revenue: £5,000k
- COGS as % of revenue: 60%
- Operating expenses: £1,050k
- D&A: £200k
- Tax rate: 25%
In P&L, build each line by referencing Assumptions — never type the same number twice.
Step 3 — Model CapEx and Working Capital
In Assumptions, add:
- CapEx: £300k
- Receivable days: 45
- Inventory days: 60
- Payable days: 30
In Working Capital, calculate:
Accounts Receivable = Revenue / 365 × Receivable Days
Inventory = COGS / 365 × Inventory Days
Accounts Payable = COGS / 365 × Payable Days
Net Working Capital = AR + Inventory − AP
ΔNWC = Current Year NWC − Prior Year NWC
For Year 1, assume ΔNWC = £80k (as given). From Year 2 onwards it will calculate automatically.
Step 4 — Build the FCF Bridge
In FCF Bridge:
- Row 1: NOPAT — link from
P&L - Row 2: + D&A — link from
Assumptions - Row 3: − ΔNWC — link from
Working Capital - Row 4: − CapEx — link from
Assumptions - Row 5: Free Cash Flow = Sum of rows 1–4
Format the bridge with consistent spacing and clear labels. Add a subtotal line after the D&A add-back (this is “Cash NOPAT” and is a useful sense-check row).
Step 5 — Sense-check your output
Ask yourself:
- Is FCF / Revenue in a reasonable range? For manufacturers: 5–15%. For software: 15–35%. For capital-intensive businesses: 2–8%.
- Is FCF less than EBITDA? (It should be, unless CapEx < D&A and NWC is releasing cash.)
- Does FCF improve over time as the business scales? (Usually yes, because CapEx is partially fixed and margins expand.)
WidgetCo passes all three checks.
Three Mistakes Every Beginner Makes
Mistake 1: Confusing FCF with Operating Cash Flow
The operating cash flow section of a published cash flow statement includes working capital movements but does not deduct CapEx. CapEx appears in the investing section. FCF = Operating Cash Flow − CapEx. This distinction trips up many students in exams and interviews.
Mistake 2: Getting the sign wrong on NWC changes
An increase in receivables or inventory is a cash outflow (you are tying up more money). An increase in payables is a cash inflow (you are deferring payments). Write the formula out longhand the first few times to internalise the logic: ΔNWC = ΔReceivables + ΔInventory − ΔPayables. If ΔNWC is positive, subtract it from FCF.
Mistake 3: Forgetting to tax-affect EBIT
If you start from EBIT and forget to apply the tax rate, you are calculating pre-tax FCF — overstating the cash flow by the tax amount. The correct starting point is always NOPAT = EBIT × (1 − t). This is non-negotiable in professional models.
Key Takeaways
- Profit is an accounting figure; cash is a fact. FCF cuts through accounting choices to show what a business actually generates.
- FCFF is for the whole firm; FCFE is for equity shareholders. Use FCFF for DCF valuation; use FCFE when thinking about dividends and buybacks.
- The four drivers of FCF are NOPAT, D&A, CapEx, and ΔNWC. Understand what moves each of these and you understand any cash flow model.
- Working capital is the hidden driver most students ignore. A fast-growing business can have strong profits but terrible FCF because it funds its own growth with cash.
- FCF is the foundation of DCF valuation. Once you can calculate it cleanly, the DCF is the natural next step.
Next in this series → How to Build a DCF Model: A Beginner’s Step-by-Step Guide
Related reading → Scenario and Sensitivity Analysis: How to Stress-Test Any Financial Model
Topics
Related posts
A step-by-step walkthrough of Discounted Cash Flow valuation for students and junior analysts — from projecting free cash flows to deriving an implied share price, with a worked Excel example.
Beginner Basics Scenario and Sensitivity Analysis: How to Stress-Test Any Financial ModelLearn the difference between sensitivity and scenario analysis, how to build both in Excel using data tables and the scenario manager, and why every financial model needs them before anyone relies on it.