Module VI· DCF Model BuildBasic
Question
How is a standard DCF tab structured in Excel?
Answer
A standard DCF tab includes operating forecast, EBIT, tax, NOPAT, D&A, capex, working capital, unlevered free cash flow, discount factors, present value of FCF, terminal value, enterprise value, net debt adjustments, equity value, shares, and implied share price. Put key assumptions and sensitivity outputs clearly near the top or bottom.