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…