Discounted Cash Flow (DCF)

Step 1 of 150%
Instructor

Unlevered Free Cash Flow

Row 24 — Unlevered Free Cash Flow. Start from EBIT, tax it as if the company had no debt (that's what makes it *unlevered*), then add back D&A and subtract CapEx and the change in NWC. In C24: `=C16*(1-$B$8)+C17-C18-C19` — EBIT (row 16), the tax rate (B8), D&A (17), CapEx (18), and ΔNWC (19). Drag across to G24.

Target cell

C24

Loading spreadsheet…