Free Cash Flow in Excel: FCFF vs FCFE Calculation Guide (2026)

July 4, 2026 · VeloraAI Team
Formulas Financial Modeling Excel

Roughly 70% of the DCFs I audit have a broken free cash flow build — usually a sign flip on working capital, an interest expense left inside FCFF, or lease accounting that never made it out of the P&L. A clean free cash flow calculation in Excel is the single most valuable line item in your valuation model, because every discounted enterprise value, LBO exit, and credit metric rolls off it. Get it wrong and the rest of the model is decoration.

This guide walks through both FCFF (unlevered free cash flow) and FCFE (levered free cash flow) in working Excel syntax. You will see how to reconcile from EBIT and from net income, how to treat leases under ASC 842, and the exact adjustments that make your FCF tie back to cash flow from operations minus capex.

What Is Free Cash Flow?

Free cash flow (FCF) is the cash a business generates after paying the operating expenses and capital expenditures needed to sustain it. Unlike net income, FCF ignores non-cash charges, adjusts for working capital, and captures the real capital reinvestment burden — which is why it drives valuation, credit analysis, and dividend capacity.

Two flavors matter for finance work:

  • Free Cash Flow to the Firm (FCFF) — also called unlevered FCF. Cash available to all capital providers (debt and equity) before financing decisions. This is what you discount at WACC in a DCF model to arrive at enterprise value.
  • Free Cash Flow to Equity (FCFE) — also called levered FCF. Cash left for equity holders after interest, principal, and net borrowing. This is what you discount at the cost of equity to arrive at equity value directly.

ℹ️ Note: A properly built model calculates FCFF from operating cash flow before interest is deducted, and derives FCFE by layering in net financing cash flows. If your FCFF changes when leverage changes, something is wrong.

What Is the Difference Between FCFF and FCFE?

FCFF measures cash generated by the operating business regardless of how it is financed; FCFE measures the residual cash available to shareholders after servicing debt. FCFF is discounted at WACC to yield enterprise value; FCFE is discounted at the cost of equity to yield equity value. Both should reconcile — enterprise value minus net debt should equal equity value.

Use this comparison to keep the two straight:

Dimension FCFF (Unlevered) FCFE (Levered)
Starting point EBIT or CFO + interest Net income or CFO
Interest expense Excluded (added back after-tax) Included
Net borrowing Excluded Included (+ / −)
Discount rate WACC Cost of equity (Ke)
Valuation output Enterprise value Equity value
Best for Cross-capital-structure comps, M&A Financial firms, stable-leverage firms
Sensitivity to leverage None High

The practical rule: if you are valuing a company whose capital structure will change (LBO target, restructuring candidate, growth firm ramping debt), use FCFF. If the capital structure is stable and forecastable — a mature utility, a bank, a REIT — FCFE is often cleaner.

How Do You Calculate FCFF in Excel?

FCFF starts from operating profit, taxes it as if the company had no debt, adds back non-cash charges, and subtracts the working capital and capex investment needed to sustain growth. The canonical formula is EBIT × (1 − t) + D&A − ΔNWC − Capex, where the tax adjustment is critical: you tax operating income, not net income, because interest is deductible in the actual P&L but must be neutralized for unlevered FCF.

Step 1: Lay out the source data

Set up your model with EBIT, tax rate, D&A, working capital items, and capex in a clean block. Assume:

  • Cell B5: EBIT ($M)
  • Cell B6: Marginal tax rate (%)
  • Cell B7: D&A ($M)
  • Cell B8: Increase in accounts receivable ($M)
  • Cell B9: Increase in inventory ($M)
  • Cell B10: Increase in accounts payable ($M)
  • Cell B11: Capex ($M)

Step 2: Compute NOPAT (net operating profit after tax)

=B5*(1-B6)

NOPAT is what the business would earn after tax if it were 100% equity-financed. This step is the whole reason unlevered FCF is capital-structure-agnostic.

Step 3: Build the change in net working capital

Net working capital (NWC) equals operating current assets minus operating current liabilities. An increase in NWC is a use of cash (money tied up in receivables and inventory); an increase in payables is a source of cash. In Excel:

=B8+B9-B10

⚠️ Warning: The sign convention here is the single most common FCF error. If receivables grew by $10M, that is $10M of cash the customers still owe you — subtract it from FCF. Do not blindly copy the balance sheet delta without checking the sign.

Step 4: Assemble FCFF

=B5*(1-B6)+B7-(B8+B9-B10)-B11

Or in a cleaner LET-function build for readability:

=LET(
  NOPAT, B5*(1-B6),
  dNWC, B8+B9-B10,
  NOPAT + B7 - dNWC - B11
)

💡 Pro Tip: Store your operating build in one block and your financing build in another. Never let a formula that computes FCFF reference an interest expense cell — that is how leverage leaks into unlevered cash flow.

Step 5: Reconcile back to cash flow from operations

The audit test every senior reviewer runs:

FCFF ≟ CFO + Interest × (1 − t) − Capex

If your bottom-up FCFF (from EBIT) does not equal your top-down FCFF (from CFO plus after-tax interest, minus capex), you have a working capital classification bug or a missed non-cash item. Add both sides side-by-side in the model and force them to tie.

How Do You Calculate FCFE in Excel?

FCFE starts from net income (which already reflects interest and taxes), adds back non-cash charges, subtracts working capital investment and capex, and then layers in net borrowing — new debt issued minus principal repaid. The formula is Net Income + D&A − ΔNWC − Capex + Net Borrowing.

Step 1: Add the debt schedule inputs

Extend your prior block with:

  • Cell B12: Net income ($M)
  • Cell B13: Debt issued during period ($M)
  • Cell B14: Debt repaid during period ($M)

Step 2: Compute net borrowing

=B13-B14

Positive net borrowing adds to FCFE (new debt is cash to equity holders after being deployed); negative net borrowing (net repayment) reduces FCFE.

Step 3: Assemble FCFE

=B12+B7-(B8+B9-B10)-B11+(B13-B14)

Step 4: Cross-check by walking from FCFF

FCFE = FCFF − Interest × (1 − t) + Net Borrowing

If your FCFF-to-FCFE bridge does not match your direct build, the after-tax interest adjustment is usually the culprit. This bridge is the fastest way to spot whether the model taxed interest incorrectly.

graph TD
    A[EBIT] --> B[NOPAT: EBIT × 1-t]
    B --> C[+ D&A]
    C --> D[− ΔNWC]
    D --> E[− Capex]
    E --> F[FCFF: Unlevered FCF]
    F --> G[− Interest × 1-t]
    G --> H[+ Net Borrowing]
    H --> I[FCFE: Levered FCF]
    F --> J[÷ 1+WACC ^t]
    J --> K[Enterprise Value]
    I --> L[÷ 1+Ke ^t]
    L --> M[Equity Value]

How Do You Handle Leases, SBC, and Deferred Taxes in FCF?

Modern GAAP leaves three items that quietly distort FCF: operating leases under ASC 842, stock-based compensation, and deferred tax movements. Ignoring any of them makes your FCF look better than it is — and analysts who catch it during diligence will discount your projections accordingly.

Operating leases (ASC 842)

Since ASC 842, operating leases produce a right-of-use (ROU) asset, a lease liability, and lease payments split between operating and financing sections of the cash flow statement. For FCFF purposes:

=B5-Lease_Interest_Component - (Principal_Payment_Component)

Treat the lease as debt: subtract the full lease payment from FCFF via the operating build, then add back the principal component when reconciling to FCFE (since principal repayment is a financing outflow). See the ASC 842 lease accounting guide for the full schedule.

Stock-based compensation

SBC is a non-cash expense that hits net income but does not consume cash. Do not add it back to FCF. Adding SBC back overstates FCF because it ignores the dilution shareholders bear when new shares are issued. Instead, deduct SBC through EBIT (i.e., treat it as a true operating expense) and let the dilution flow through your share count in equity value per share.

Example: If a SaaS company reports $200M of GAAP net income and $150M of SBC, a lazy DCF adds back the $150M and produces FCF of $350M. That is $150M of equity-holder dilution disguised as cash. Sophisticated buyers reject models that do this — hold SBC as a real cost.

Deferred taxes

Deferred tax movements are non-cash. Add back an increase in deferred tax liability (cash tax was lower than book tax) and subtract an increase in deferred tax asset. In Excel, if B15 holds the change in net deferred tax liability:

=B12+B7+B15-(B8+B9-B10)-B11+(B13-B14)

What Are the Most Common FCF Errors in Excel?

The five that show up in almost every DCF audit:

  1. Sign flips on working capital. Analysts model an increase in receivables as +$10M but forget it is a use of cash. Always sanity-check: if the business is growing, ΔNWC should typically be negative (subtracting from FCF).
  2. Interest not neutralized in FCFF. Copying net-income-based CFO into FCFF without adding back after-tax interest makes FCFF change with leverage — the whole point of unlevered FCF is that it does not.
  3. Capex mixed with acquisitions. M&A cash outflows are not maintenance capex. Split growth capex, maintenance capex, and acquisitions into three lines, and only include maintenance + organic growth capex in FCF.
  4. Terminal-year working capital ballooning. If ΔNWC scales with revenue growth, the terminal year's NWC change can be unrealistically large. Normalize to a mid-cycle ratio before the perpetuity.
  5. SBC add-back. As above — the single most common way tech DCFs overstate value.

⚠️ Warning: The three-statement model must reconcile. If your FCF does not tie to CFO minus capex on the cash flow statement, do not proceed with the DCF until it does. Every hour spent fixing the FCF is 10 hours saved in defending the valuation.

When Should You Use FCFF vs FCFE?

Use FCFF as the default for corporate finance work — leveraged buyouts, M&A, corporate valuation — because it lets you value the operating business independently of how it happens to be financed. Use FCFE when the capital structure is a defining feature of the business, such as banks, insurance companies, REITs, and utilities where leverage is central to the equity story.

graph TD
    A[Value a company] --> B{Capital structure stable and central to the business?}
    B -->|Yes: banks, REITs, utilities| C[Use FCFE at Ke]
    B -->|No: most corporates, LBO targets, growth firms| D[Use FCFF at WACC]
    D --> E[Enterprise Value]
    E --> F[Less: Net Debt, Pension, Minority Interest]
    F --> G[Equity Value]
    C --> H[Equity Value directly]

The FCFF path gives you two audit points (EV and EV-to-equity bridge). FCFE gives you one direct answer but hides the debt story. For most modeling situations where the reader will ask "what happens if leverage changes," FCFF is the safer default.

How Do You Forecast Free Cash Flow in Excel?

Build FCF forecasts by projecting each driver separately — revenue, margins, working capital as % of revenue, capex as % of revenue — and then re-assemble FCF from those drivers rather than growing prior-period FCF by a single rate.

A five-year FCF forecast template:

Driver Year 1 Year 2 Year 3 Year 4 Year 5
Revenue growth 15% 12% 10% 8% 6%
EBIT margin 18% 19% 20% 20% 20%
Tax rate 25% 25% 25% 25% 25%
D&A / Revenue 6% 6% 5% 5% 5%
ΔNWC / ΔRevenue 12% 12% 12% 10% 10%
Capex / Revenue 8% 7% 7% 6% 6%

Each row is an assumption cell. FCF for each year rolls up from those drivers:

=Revenue*EBIT_Margin*(1-Tax_Rate) + Revenue*DA_pct - (Revenue-Revenue_Prior)*NWC_pct - Revenue*Capex_pct

💡 Pro Tip: Never hardcode FCF growth rates. If reviewers ask "why does year 4 FCF grow 12%?" you should be able to point to the drivers that produced that growth, not to a magic growth cell. Driver-based FCF is defensible; assumption-based FCF is not.

Pair this with a sensitivity analysis on terminal growth and WACC, and you have a valuation you can walk into an investment committee with.

Frequently Asked Questions

What is the difference between free cash flow and cash flow from operations?

Cash flow from operations (CFO) captures cash generated by the operating business before capital reinvestment. Free cash flow subtracts capex — the cash you must reinvest to sustain the business. FCF is what is truly "free" for capital providers, whereas CFO overstates distributable cash because it ignores the ongoing capital investment requirement.

Can free cash flow be negative?

Yes, and it often should be. High-growth companies routinely produce negative FCF because they invest heavily in working capital and capex ahead of revenue realization. Negative FCF is a red flag only if it persists past the growth phase or if it is driven by declining margins rather than growth investment. Amazon ran negative FCF for years while compounding shareholder value.

Do you add back stock-based compensation to free cash flow?

No — despite common practice. SBC is a real economic cost paid in equity rather than cash, and adding it back to FCF systematically overstates value for tech and growth companies. Best practice is to expense SBC through EBIT and then reflect dilution in your share count when converting equity value to price per share.

How do you calculate FCF from EBITDA?

Start from EBITDA, subtract taxes on EBIT (not EBITDA — depreciation is tax-deductible), subtract the change in net working capital, and subtract capex. The formula is EBITDA − Taxes on EBIT − ΔNWC − Capex. Note that using EBITDA directly and taxing it as if it were taxable income is a common error — depreciation must be respected for tax purposes even in an unlevered FCF build.

What discount rate do I use for FCFF vs FCFE?

Discount FCFF at the weighted average cost of capital (WACC) to arrive at enterprise value. Discount FCFE at the cost of equity (Ke), typically derived from CAPM, to arrive at equity value directly. Mixing them — for example discounting FCFF at Ke — double-counts the tax shield and produces a valuation error that can exceed 25% on levered companies.

Building FCF Faster With VeloraAI

Every FCF audit above — sign checks on working capital, the CFO-to-FCFF reconciliation, the FCFF-to-FCFE bridge — can be run in seconds inside Excel with an AI copilot that reads your model structure and flags inconsistencies before they reach your MD. VeloraAI's Excel add-in performs these reconciliations, spots the SBC-add-back trap, and generates the driver-based FCF build directly from your P&L and balance sheet.

The next step is straightforward: rebuild your FCF from EBIT and from net income in parallel, tie both to CFO minus capex, and only then discount. A FCF that reconciles three ways is a FCF you can defend — and it is the difference between a valuation that clears investment committee and one that gets sent back for a rebuild.