10 Inputs You Must Get Right Before Running a DCF
To run a successful DCF, you must get 10 key inputs right, including realistic revenue growth, operating margins, and an appropriate discount rate. These inputs are more important than the model itself, as they determine the accuracy of your valuation.
Why Your DCF Inputs Matter More Than the Model Itself
You have probably heard the phrase "Garbage In, Garbage Out." This is especially true for financial models. A investing/intrinsic-value-stock-investing">Discounted Cash Flow (DCF) model looks complex and precise. But it is only as good as the assumptions you put into it. This is the first thing to learn about fcf-yield-vs-pe-ratio-myth">valuation-methods/best-valuation-frameworks-indian-it-stocks">how to value a stock in India.
Many investors spend hours building a fancy spreadsheet. They spend only minutes thinking about the growth rate or the profit mcx-and-commodity-trading/trading-mcx-base-metals-limited-capital-risk-tips">margins. This is a mistake. Your time should be spent the other way around. Spend 80% of your time researching the business and its industry. Spend just 20% of your time putting those numbers into the model.
A bad assumption can lead to a valuation that is wildly wrong. This can cause you to overpay for a stock or miss a great opportunity. Getting the inputs right means you understand the business deeply. It forces you to think like a business owner, not just a number cruncher.
The 10-Point Checklist for a Solid Stock Valuation in India
Before you open that spreadsheet, go through this checklist. These ten inputs are the foundation of any good DCF analysis. Getting them right will give you much more confidence in your final valuation.
Revenue Growth Rate
Do not just pluck a number out of the air. Your growth assumption must be realistic. Look at the company's past growth over 5-10 years. Read the management's guidance in their esg-and-sustainable-investing/best-esg-scores-indian-companies">governance/best-tools-director-credentials-board-quality">annual reports and investor calls. Research the industry's growth prospects. Is the company gaining or losing market share?
Operating Margins
This shows the profitability of the company's core business. Look at the historical operating margin (EBIT margin). Is it stable, improving, or getting worse? A company with a strong competitive advantage, or a "moat," can often maintain high and stable margins. A company in a competitive industry may struggle.
Tax Rate
Using the standard fd-interest-tax-company-partnership">corporate tax rate is an easy mistake. Instead, look at the company's revenue/use-eps-compare-companies-sector">financial statements to find its effective tax rate. This is the actual tax the company pays. It can be lower due to government incentives or tax credits. Be aware if these benefits are set to expire, as that will impact future cash flows.
Reinvestment Rate
Growth is not free. A company must invest money to grow. This is called reinvestment. You need to estimate how much the company will reinvest from its profits. You can calculate it by looking at capital expenditures (capex), depreciation, and changes in working capital. A high growth rate requires a high reinvestment rate.
Return on Invested Capital (ROIC)
This is a measure of how well the company invests its money. A high ROIC means the company generates a lot of profit from its savings-schemes/scss-maximum-investment-limit">investments. For a company to create value, its ROIC must be higher than its cost of capital. Growth at a low ROIC can actually destroy equity-as-asset-class">shareholder value.
Discount Rate (WACC)
The discount rate, or Weighted Average Cost of Capital (WACC), is used to calculate the present value of future cash flows. It represents the risk of the investment. It has two main parts: the cost of debt and the cost of equity. For the cost of equity, you need a portfolio/use-sharpe-ratio-compare-mutual-funds">risk-free rate. You can use the yield on Indian bonds/1-lakh-rbi-floating-rate-savings-bond-income">government bonds for this, which you can find on the Reserve Bank of India website. You also need an equity risk premium specific to India and the company's beta (its volatility relative to the market).
Terminal Growth Rate
You cannot forecast cash flows forever. After a period of high growth (usually 5-10 years), you assume the company grows at a stable, perpetual rate. This is the terminal growth rate. This number must be conservative. It should not be higher than the long-term growth rate of India's economy. A rate between 3% and 5% is typical.
Existing Debt and Cash
Your DCF first calculates the Enterprise Value. To find the Equity Value (the value for shareholders), you must subtract all debt and add any cash on the balance sheet. Make sure to use the most recent figures. Remember to include items like capital leases as part of the debt.
Share Count
To get a per-share value, you divide the equity value by the number of shares. Always use the diluted number of shares. This includes shares that could be created from employee stock options or convertible bonds. Using the basic share count will make your per-share value look higher than it really is.
Management Quality
This is not a number, but it is critical. Is the management honest and capable? Do they allocate capital wisely? Read past annual reports. Look for signs of poor sebi/maximum-fines-sebi-impose-corporate-governance-violations">corporate governance, like high executive pay or unfair transactions with related companies. You can reflect poor management quality by using more conservative growth assumptions or a higher discount rate.
Common Mistakes to Avoid When Valuing Indian Stocks
Even with a checklist, it's easy to fall into common traps. The biggest one is being too optimistic. Every investor wants to find the next big winner, but this bias can cloud your judgment. Always test your assumptions and ask yourself, "What could go wrong?"
Another mistake is using the same discount rate for every company. A small, risky startup in a new industry should have a much higher discount rate than a large, stable blue-chip company.
Look at how small changes in your key assumptions can dramatically change the final valuation. This is why spending time on your inputs is so important.
| Input | Optimistic Case | Realistic Case | Impact on Value |
|---|---|---|---|
| Revenue Growth (5 Yrs) | 25% per year | 15% per year | High |
| Terminal Growth Rate | 6% | 4% | Very High |
| Operating Margin | 20% (improving) | 18% (stable) | Medium |
| Discount Rate (WACC) | 10% | 12% | Very High |
Putting It All Together: From Inputs to Insight
A DCF model is a powerful tool. But it is a tool for thinking, not a machine that gives you the right answer. The final number you get is an estimate. The true value lies in the process.
By working through these inputs, you gain a deep understanding of the business. You learn what drives its value. Is it growth? Is it profitability? Or is it how efficiently it reinvests its capital?
Use your model to run different scenarios. What happens if growth is slower than you expect? What if margins fall? This helps you understand the range of possible outcomes and the risks involved. This process, born from solid and well-researched inputs, is how you truly find value in the stock market.
Frequently Asked Questions
- What is the most important input in a DCF model?
- While all inputs are connected, the discount rate (WACC) and the terminal growth rate often have the biggest impact on the final valuation because they affect the present value of all future cash flows.
- How do I choose a terminal growth rate for an Indian company?
- A safe terminal growth rate for an Indian company should not exceed the long-term nominal GDP growth forecast for India. A rate between 3% and 5% is generally considered reasonable.
- Can I use DCF for loss-making companies?
- Yes, but it's more difficult. You need to forecast when the company will become profitable and generate positive cash flows. The assumptions for growth and margins become even more critical and speculative.
- What is a good ROIC for a company?
- A good Return on Invested Capital (ROIC) is one that is consistently higher than the company's Weighted Average Cost of Capital (WACC). An ROIC above 15% is often considered a sign of a high-quality business.