Common Mistakes in DCF Valuation and How to Avoid Them — Build Better Models

The most common and dangerous mistake in DCF valuation is using unrealistic growth assumptions. Analysts often project high revenue growth rates for 5-10 years without considering competitive dynamics, market saturation, or reversion to the mean. The reality is that sustained high growth is exceptionally rare. Studies show that companies growing at 20% or more have a high probability of seeing growth decelerate within 3-5 years as competitors enter the market and the law of large numbers takes effect.

A typical error is projecting a company like Bajaj Finance to grow at 25% for a decade. Even if the company executes perfectly, its massive size makes such growth mathematically challenging. A ’10,000 crore company can easily double, but a ’3,00,000 crore company growing at 25% would need to generate ’75,000 crore in additional revenue each year — an unrealistic expectation in most industries. Always use a declining growth curve where growth gradually converges to the economy's long-term growth rate.

To avoid growth rate bias, anchor your assumptions in three sources: (1) the company's own historical growth rates over multiple cycles, (2) industry growth rates from credible research reports, and (3) analyst consensus estimates from reputable sources. If your assumed growth rate is significantly above all three, you need strong justification. For a framework on analyzing growth, see our guide on revenue growth rate.

Terminal value errors are particularly damaging because terminal value typically accounts for 60-80% of total DCF value. The most common mistake is using a terminal growth rate that is too high. A terminal growth rate should never exceed the long-term nominal GDP growth rate of the economy. For India, a reasonable terminal growth rate is between 3% and 5%. Using 6% or higher implies the company will eventually grow faster than the entire economy, which is mathematically impossible in perpetuity.

Another frequent error is forgetting to discount the terminal value. The terminal value is calculated as of the end of the forecast period and must be discounted back to the present using the same discount rate applied to other cash flows. An even more subtle mistake is using an exit multiple that is inconsistent with the perpetuity growth method. The implied growth rate from your exit multiple should be reasonable. For example, if you use a 15x EV/EBITDA exit multiple, the implied perpetual growth rate should be in the 3-5% range, not 8-10%.

To avoid terminal value errors, always calculate terminal value using both methods (perpetuity growth and exit multiple), and verify that the results are consistent. If the two methods give vastly different answers, revisit your assumptions. Also check that your terminal value represents a reasonable percentage of the total DCF value. For mature companies, 60-80% is typical. If terminal value is 95%+ of total value, your forecast period is probably too short. Learn more in our terminal value guide.

Using the wrong discount rate is one of the most consequential errors in DCF analysis. Many analysts use a generic discount rate (like 10% or 15%) without properly calculating the company-specific WACC. The discount rate must reflect the company's cost of equity, cost of debt, capital structure, and risk profile. A 1% error in the discount rate can change the valuation by 10-20%, making this one of the most important inputs to get right.

Common errors include: using the cost of equity as the discount rate for all cash flows (ignoring the tax shield from debt), using the book value of debt instead of market value for capital structure weights, using a global average equity risk premium for Indian stocks, and not updating the discount rate when the company's risk profile changes. For example, a company that takes on significant debt should have a higher WACC reflecting higher financial risk.

To avoid discount rate errors, always calculate WACC specifically for the company you are valuing. Use the current risk-free rate (10-year government bond yield), a beta appropriate for the company's industry and leverage, and an equity risk premium that reflects the Indian market. Review your assumptions against industry peers and update your discount rate regularly. For a detailed WACC tutorial, see our WACC guide.

Cash flow calculation errors are surprisingly common even in professional DCF models. The most frequent mistake is using net income instead of free cash flow. Net income includes non-cash charges and does not account for capital expenditures needed to sustain the business. A company might report high profits but generate negative free cash flow because it must reinvest heavily in equipment, inventory, or receivables. Always use free cash flow (operating cash flow minus capital expenditure) in your DCF.

Another common error is incorrect treatment of working capital changes. Growth companies typically require increasing working capital (more inventory and receivables), which consumes cash. Many analysts overlook this and overstate free cash flow. For a growing company like Avenue Supermarts (DMart), working capital requirements can be significant as it opens new stores. Also, be careful with one-time items — exclude non-recurring expenses and income from your normalized cash flow projections.

Stock-based compensation is another area of confusion. While it is a non-cash expense, it represents a real cost to shareholders through dilution. Some analysts add it back to free cash flow (treating it as non-cash) while others treat it as a real expense. The best practice is to include stock-based compensation as an expense in your DCF because it represents real economic value transferred to employees. For a deeper understanding of cash flow analysis, refer to our free cash flow guide.

Double counting occurs when a cash flow is counted in two different places in a DCF model. The most common example is counting interest expense as both a deduction in net income and separately in the discount rate. Since WACC already accounts for the cost of debt through the weighted average, cash flows should be calculated on a debt-free basis. Using levered cash flows (after interest) with WACC effectively counts the cost of debt twice, artificially reducing the valuation.

Circular references happen when an input in a formula depends on the output of the same formula. For example, if you use market values of equity and debt in your WACC calculation, but the market value of equity is the result of your DCF valuation, you have a circular reference. This must be resolved iteratively — start with a reasonable estimate, calculate the DCF value, update the capital structure weights, and repeat until the value stabilizes.

To avoid these issues, always use unlevered free cash flows (free cash flow to the firm) in your DCF model when using WACC as the discount rate. Use a target capital structure rather than the current structure if the company is expected to change its leverage. And be methodical about checking your formulas for circular references. Excel will warn you about circular references, but it may not catch all of them. For a broader view of valuation techniques, read our guide on DCF valuation.

The simplest models are often the best, but oversimplification can lead to serious errors. A common mistake is using only 3-5 years of projections when the company needs 7-10 years to reach steady state. Another is ignoring competitive dynamics — assuming margins stay constant forever when competition will naturally compress margins over time. The best DCF models strike a balance between rigor and practicality, capturing the key value drivers without unnecessary complexity.

Best practices for DCF modeling include: (1) always present your result as a valuation range, not a single number, (2) perform sensitivity analysis on your two or three most critical assumptions, (3) cross-check your DCF output with relative valuation methods, (4) document all your assumptions with clear justifications, (5) check that your implied multiples are reasonable, and (6) review your model for errors by using sanity checks like checking that the terminal value percentage and implied growth rates make sense.

Finally, remember that DCF is a thinking tool, not a precision instrument. The value of DCF lies not in the final number but in the discipline of systematically thinking about a business's cash flows, risks, and growth prospects. A DCF model forces you to articulate your investment thesis in quantitative terms and identify the key assumptions that drive value. Combined with sensitivity analysis and margin of safety, it is one of the most powerful tools in an investor's arsenal.

Ready to build better DCF models? Use our stock market data to research financial statements, or explore our stock screeners to find investment opportunities. This content is educational and does not constitute financial advice.