You’ve built your business over the years.
Poured in your time, money, and energy.
But if someone asked you today, “What is your business actually worth?”… would you have a number?
Most MSME business owners in India don’t.
They either guess, ask their CA for a rough figure, or worse, leave it to the buyer to decide.
That’s where the discounted cash flow model comes in.
It’s a method that values your business based on what it can earn in the future, not just what it has today.
Whether you’re planning to sell, bring in a partner, or simply want to understand your business better, this blog will walk you through the discounted cash flow method in plain language, with a worked example in rupees.
What is the Discounted Cash Flow Model?
The discounted cash flow model is a way to figure out what your business is worth today, based on the money it is expected to generate in the future.
Here’s the core idea.
| A rupee you receive today is worth more than a rupee you receive next year. Why? Because today’s rupee can be invested, earn interest, and grow. This is called the time value of money, and it’s the foundation of every discounted cash flow analysis. |
So instead of looking at your assets, your turnover, or what competitors sold for, the DCF model asks one question –
How much cash will this business produce in the future, and what is that future cash worth in today’s terms?
This makes it a forward-looking valuation method and one of the most respected ones in finance.
According to SIDBI (2025), over 6.2 crore MSMEs are registered in India.
Yet very few business owners have ever valued their own business properly.
The discounted cash flow model is one way to change that.
What is the Difference Between Discounted Cash Flow and a DCF Model?
These two terms are often used interchangeably, but there’s a subtle difference worth knowing.
Here’s a simple breakdown.
| Difference | Discounted Cash Flow (DCF) | DCF Model |
| What it is | A concept – the idea of reducing future cash to what it’s worth today | A tool – the actual spreadsheet or financial model you build |
| What it does | Explains the logic behind valuation (time value of money) | Takes your inputs (cash flows, discount rate, assumptions) and gives you a number |
| Applies to | Any asset, project, investment, or business | A specific business or investment is being valued |
| Think of it as | The principle | The calculator |
| Example | “Future money is worth less than today’s money” | An Excel sheet that tells you your business is worth Rs 91 lakhs |
For MSME owners, the practical takeaway is this – you need to understand the concept (discounted cash flow) to use the tool (DCF model) well.
One without the other leads to either blind reliance on a spreadsheet or good theory with no usable numbers.
How Does the Discounted Cash Flow Method Work? (Step-by-Step DCF Valuation Steps)
The discounted cash flow method follows a structured process.
Here are the key DCF valuation steps, simplified for business owners.
Step 1 – Gather your historical financial data.
Look at the last 3–5 years of your profit & loss statements, balance sheets, and cash flow statements.
This gives you the baseline.
Step 2 – Project your future cash flows.
Estimate how much free cash flow your business will generate each year for the next 3–5 years.
Free cash flow = operating profit minus taxes, capital expenses, and changes in working capital.
Step 3 – Determine your discount rate.
This is the rate of return you or a buyer would expect.
Most businesses use the Weighted Average Cost of Capital (WACC).
For Indian MSMEs, discount rates typically range between 12–20%, depending on risk.
Step 4 – Calculate the terminal value.
Since your business won’t stop generating cash after 5 years, you calculate a terminal value, the estimated worth of all cash flows beyond the projection period.
Terminal value typically accounts for 60–80% of the total DCF valuation.
Step 5 – Discount everything back to present value.
Apply the discount rate to each year’s projected cash flow and to the terminal value.
This converts future rupees into today’s rupees.
Step 6 – Add it all up.
The sum of all discounted cash flows plus the discounted terminal value gives you the enterprise value of your business.
Discounted Cash Flow Formula (With a Worked DCF Model Example)
The discounted cash flow formula looks like this –
DCF = FCF₁ / (1+r)¹ + FCF₂ / (1+r)² + FCF₃ / (1+r)³ + … + Terminal Value / (1+r)ⁿ
Where FCF = Free Cash Flow for each year, r = Discount rate, and n = Number of years.
Let’s see a discounted cash flow example for a fictional Indian MSME.
Imagine a packaging business in Bangalore with steady growth.
The owner projects free cash flows over 5 years with a 12% discount rate, and a terminal value calculated using a 4% perpetual growth rate.
| Year | Projected FCF (Rs) | Discount Factor (12%) | Present Value (Rs) |
| Year 1 | Rs 10,00,000 | 0.893 | Rs 8,93,000 |
| Year 2 | Rs 12,00,000 | 0.797 | Rs 9,56,400 |
| Year 3 | Rs 14,00,000 | 0.712 | Rs 9,96,800 |
| Year 4 | Rs 16,00,000 | 0.636 | Rs 10,17,600 |
| Year 5 | Rs 18,00,000 | 0.567 | Rs 10,20,600 |
| Terminal Value | — | — | Rs 42,52,500 |
| Total (Enterprise Value) | — | — | Rs 91,36,900 |
So, based on this DCF model example, the business’s estimated enterprise value is approximately Rs 91.37 lakhs.
This number tells the owner (or a potential buyer) what this business is worth today, based on what it’s expected to earn.
Important –
A 1 percentage point change in the discount rate (WACC) can shift this valuation by 10–20%.
That’s why the assumptions you use matter more than the formula itself.
When Should a Business Owner Use Discounted Cash Flow Analysis?
Discounted Cash Flow (DCF) analysis is not only for finance experts.
It helps business owners understand the real value of their business and make smarter financial decisions.
Situations where DCF is useful –
Selling your business
Buyers usually calculate their own valuation.
If you already know your DCF value, you negotiate with confidence instead of guessing.
Bringing in a partner or investor
Investors will ask one key question – What is the business worth?
A DCF gives a clear, data-backed valuation.
Succession planning
If you plan to pass the business to the next generation or sell it externally, knowing the true value helps structure a fair transition.
Raising a loan or credit line
Banks and NBFCs increasingly focus on future cash flows.
A DCF model strengthens your case for funding.
Strategic decisions
Expanding to a new location or launching a new product requires investment.
DCF helps evaluate whether the expected returns justify the cost.
Pros and Cons of Discounted Cash Flow
Let’s be honest about what the discounted cash flow method does well and where it falls short.
Here’s a balanced view of the pros and cons of discounted cash flow.
| Pros of Discounted Cash Flow | Cons of Discounted Cash Flow |
| Based on actual cash generation, not market sentiment | Highly sensitive to small changes, big swings |
| Forward-looking, values future potential | Terminal value drives most of the result (60–80%) |
| Works across industries | Complex for non-finance business owners |
| Not affected by market hype | Two analysts can get very different numbers for the same business |
| Useful for strategic decisions (sell, partner, raise capital) | Requires reliable financial projections, tough for seasonal or volatile businesses |
Here’s the honest truth that most finance content won’t tell you – a DCF is an estimate, not a fact.
The accuracy of the number depends entirely on the quality of your assumptions.
Two CAs can look at the same business and arrive at different valuations because they used different growth rates or discount rates.
Does that make DCF useless? NO. It makes it a powerful thinking tool.
The value of a DCF is not just the final number. It’s the process of thinking through your business’s future in a structured way.
Discounted Cash Flow vs Other Business Valuation Methods
The discounted cash flow method is one of several approaches to valuing a business.
Here’s how it compares with the other common methods.
| Method | What It Values | Best For | Limitation | Who Prefers It |
| DCF (Discounted Cash Flow) | Future cash flows | Stable, growing businesses with predictable cash flows | Needs accurate projections | Analysts, banks, mature businesses |
| Asset-Based | Net assets (own – owe) | Asset-heavy businesses (manufacturing, real estate) | Ignores earning potential | Liquidation scenarios, asset-rich MSMEs |
| Market Multiples | What similar businesses sold for | Businesses with comparable transaction data | Depends on market conditions & available data | VCs, PE firms, quick valuations |
Here’s something no one will tell you – venture capitalists and PE firms often skip DCF entirely.
Why?
Because early-stage businesses don’t have predictable cash flows.
They rely on market multiples or comparable transactions instead.
For most established MSMEs with 3+ years of financial history and steady operations, the discounted cash flow business valuation method gives the most comprehensive picture.
But always cross-check with at least one other method.
Common Mistakes Business Owners Make With DCF
Discounted Cash Flow (DCF) can be powerful, but many business owners make simple mistakes while using it.
These errors can lead to unrealistic valuations and poor decisions.
Most common mistakes include –
Overestimating future growth
Owners often assume very high growth.
If your business grew 12% annually in the last 3 years, projecting 30–40% growth will make the valuation unrealistic and reduce credibility with investors.
Ignoring working capital needs
As revenue grows, businesses usually need more inventory, receivables, and operating cash.
If this is ignored, the projected free cash flow will look higher than reality.
Using the wrong discount rate
A very low rate makes the business look overvalued.
A very high rate makes it look unattractive.
For most Indian MSMEs, a discount rate between 12–20% is more realistic.
Relying too much on the terminal value
If most of the valuation comes from terminal value, it’s a warning sign.
It means the value depends heavily on long-term assumptions that are hard to predict.
Using DCF when it’s not the right method
If cash flows are seasonal, unstable, or unpredictable, DCF may not give reliable results.
Businesses in their first 2–3 years or going through major changes may need other valuation methods.
How to Calculate Discounted Cash Flow in Excel?
You don’t need expensive software to calculate discounted cash flow in Excel.
Here’s a simple approach.
- Step 1 – In Column A, list Year 1 through Year 5. In Column B, enter your projected free cash flow for each year.
- Step 2 – In Cell C1, enter your discount rate (e.g., 12% or 0.12).
- Step 3 – In Column C, calculate the present value of each year’s cash flow using this formula: =B2/(1+$C$1)^A2
- Step 4 – Use Excel’s built-in NPV function – =NPV(discount_rate, cash_flow_range). This gives you the sum of all discounted cash flows in one step.
- Step 5 – Add the discounted terminal value separately. Terminal Value = (Year 5 FCF × (1 + growth rate)) / (discount rate – growth rate). Then discount it back to present value.
For more advanced models, Excel’s XNPV function handles irregular time periods.
But for most MSME owners, the basic NPV function is more than enough.
Done reading? Now try it yourself.
| We’ve built a ready-to-use Excel template that does all the math for you. Just enter your revenue, expenses, and a few assumptions, and it calculates your business’s enterprise value instantly. [DOWNLOAD here] |
Conclusion
Knowing what your business is worth isn’t a luxury.
It’s a practical skill that helps you make better decisions, whether you’re selling, growing, or passing the baton.
Start simple. Project your cash flows. Pick a reasonable discount rate. Run the numbers.
And if the result surprises you in either direction, that’s the real value of doing this exercise.
Learned from this blog?
Click here and head to our blog page for more practical insights on business growth, leadership, and building a business that actually works for you.
FAQs
How does the discounted cash flow (DCF) model work in simple terms?
It values your business today by discounting the cash flows it’s expected to generate in the future.
What is the difference between DCF valuation and NPV?
DCF is the valuation method. NPV is the final number after subtracting your initial investment.
What discount rate should I use for DCF analysis of my business?
Indian MSMEs typically use 12–20%, depending on business risk and cash flow stability.
Can the DCF model be used for small business valuation?
Yes, it works for any business generating cash flow, ideally with 3+ years of financial history.
What is the terminal value in a DCF model, and why does it matter?
It captures your business’s worth beyond the projection period, often 60–80% of the total DCF value.
How many years of cash flow projections are needed for DCF analysis?
3–5 years for MSMEs. Terminal value covers the remaining business value beyond the forecast period.
What are the key limitations of discounted cash flow analysis?
Sensitive to assumptions, small changes in growth or discount rates can greatly alter results.
Is DCF analysis better than market multiples for business valuation?
Neither is universally better. Use both DCF for intrinsic value and multiples for market comparison.
Can I calculate discounted cash flow in Excel without finance knowledge?
Yes, Excel’s NPV and XNPV functions handle the math. Accurate assumptions are the harder part.