Discounted cash flow (DCF) - Why it matters and how to use it

Capital allocation is one of the hardest decisions in business. Most financial tools tell you what something costs, very few tell you what it is genuinely valued at. Discounted cash flow (DCF) analysis is one of them. It takes projected future cash flows and converts them into a present-day value, so the decisions are fundamentally strong and not assumed. In this blog let's learn more about DCF in detail.

What is discounted cash flow (DCF)?

Discounted cash flow (DCF) is a valuation method that determines what an investment is worth today by estimating its future cash flows and bringing them back to their present value using a discount rate.

Investment analysts use DCF to evaluate stocks, securities, and acquisition targets. Business leaders and finance teams rely on it to assess capital projects, plan budgets and make major spending decisions with clarity.

How the discounted cash flow method works

The discounted cashflow method works by taking the future cash flows a business or investment is expected to generate and converting them into their present-day equivalent. This conversion is done using a discount rate, the weighted average cost of capital (WACC), which reflects both the cost of capital and the risk associated with those future cash flows.

The forecast period is usually five to ten years. Beyond that point, a terminal value is calculated to account for cash flows the business is expected to generate after the forecast window closes. The forecast period cash flows and terminal value then discounted back to the present and added together to arrive at the total value of the investment.

The discounted cash flow formula explained

Where:

• CF1 = Cash flow for first year, the net cash the investment is expected to generate
• CF2 = Cash flow for second year, the net cash the investment is expected to generate
• CFn = Cash flow for additional years
• r = Discount rate, the weighted average cost of capital (WACC)
• n = Number of periods, usually measured in years

Also read: An Intro to Startup Valuation Methods

Step-by-step: How to calculate DCF

Calculating DCF requires a few clear steps to arrive at a reliable valuation.

• ‍Forecast your future cash flows: Estimate the net cash flows the business is projected to generate over the projection period. Factor in revenue growth assumptions, operating expenses, and capital expenditure to make the forecast as realistic as possible

• Determine your discount rate: Select a rate that reflects the cost of capital and the risk profile of the investment. This is commonly the WACC, adjusted for factors such as market conditions and industry risk

• Calculate the present value of each cash flow: Use the discount rate to convert each forecasted cash flow to convert them into today's equivalent value

• Sum all present values: Add all discounted cash flows together to get the total present value of the investment

• Account for terminal value: Estimate the value of the business beyond the forecast period using either the Gordon Growth Model or the Exit Multiple Method

• Calculate the net present value (NPV): Deduct the initial investment from the total present value of all discounted cash flows. A positive NPV indicates the investment is expected to generate returns above the required rate of return, making it a viable consideration

Discounted cash flow example

Assume you are evaluating an investment opportunity with a discount rate of 12% that is expected to generate $150 per year over the next three years. The goal is to calculate what that future income stream is worth in today's terms.

Since future cashflows are worth less than present cash flows, each year's return is discounted back using the 12% rate:

• Year 1: $150 / (1 + 0.12)¹ = $133.93

• Year 2: $150 / (1 + 0.12)² = $119.58

• Year 3: $150 / (1 + 0.12)³ = $106.77

Adding all three discounted cash flows together:

$133.93 + $119.58 +$106.77 = $360.28

Types of discounted cash flow models

There are four types of DCF models, each designed for a specific valuation context

• Discounted dividend model: A method used to value a stock by calculating the present value of its expected future dividends. When this value exceeds what the stock is currently trading at, it could signal that the stock is priced below its true worth. making it a useful tool for equity investors evaluating dividend-paying companies.

• Discounted free cash flow model: A method used to value an entire business by discounting the free cash it generates, after all expenses and investments, back to today's value. It reflects the worth of the whole business, not just shareholder returns.

• Adjusted present value method: A method that calculates business value in two parts, first by valuing the business as if it carries no debt, then separately adding the tax benefits that come from debt financing. Both figures are combined to arrive at the final value.

• Economic value added model: A method that measures whether a business is genuinely creating value by measuring how much profit remains after accounting for the full cost of capital. A positive result means value is being created, a negative result means capital is being consumed faster than it is being earned.

Also read: Your guide to 409A valuation methodology 

DCF vs NPV: Are they the same?

DCF and NPV are closely linked, so closely that they are often used interchangeably. The total DCF value of an investment is frequently referred to as its Net Present Value.

However, there is a technical difference. DCF calculates the total present value of all projected cash flows. NPV goes one step further by deducting the initial cost of the investment from that total.

This can be expressed as:

NPV = DCF − Initial Investment

If the NPV is positive, the investment generates returns above its cost. If negative, the cost outweighs the returns.

Who uses DCF analysis and why

DCF analysis is used across finance, investment and business, each with a different objective

• ‍Investment analysts and equity researchers: Use DCF to determine whether a stock is over priced, valued, or available at a discount to its intrinsic worth, informing buy, hold or sell decisions

• Investment bankers: Rely on DCF as a core valuation method in mergers, acquisitions and capital raising transactions to determine a fair price for a business

• Corporate finance teams: Use DCF to evaluate capital projects, justify major spending decisions and support strategic planning within the business

• Business owners and entrepreneurs: Apply DCF to understand the value of their own business, particularly when preparing for fundraising, a sale or a strategic partnership

• Private equity and venture capital firms: Use DCF models to assess potential investments, stress test assumptions and determine whether projected returns justify the risk

Advantages and limitations of DCF analysis

Here are the advantages and limitations of DCF analysis. Let's break them down

Advantages of DCF analysis

• Applicable across a wide range of assets, businesses, stocks, projects, bonds and any asset that generates measurable cash flows

• Forward looking by nature, built on projected future performance rather than historical data

• Scenario flexibility, assumptions can be adjusted to model best case, expected case and worst-case outcomes

• Independent of market price, grounded in cash flow fundamentals, not short-term market fluctuations

Limitations of DCF analysis

• Highly sensitive to assumptions, small changes in discount rate, growth rate or terminal value can produce significantly different outputs

• Difficult to apply to early-stage companies, businesses without stable cash flow history make forecasting unreliable

• Terminal value risk, errors in long term growth assumptions can distort the entire valuation

• Vulnerable to external factors economic downturns, inflation, interest rate changes and geopolitical events can impact actual cash flows in ways projections cannot anticipate

• The quality of a DCF valuation is only as strong as the data behind it, unreliable inputs will always produce unreliable results

Conclusion

There is a reason DCF has remained a core valuation tool across investment banking, private equity, corporate finance and strategic planning for as long as it has. DCF requires assumptions, judgment and a willingness to project into an uncertain future. But that is what makes it valuable. Any tool that forces you to think carefully about projected returns, risk and the time value of money is a tool that improves the quality of financial decisions, even when the output turns out to be wrong. 

Alongside other valuation methods, tested against different scenarios and grounded in realistic assumptions, DCF gives you something most financial tools cannot, a clear, structured view of what an investment is genuinely worth today, before the decision is made.

How can Qapita help you value your business?

Our international valuations team delivers DCF-based, audit-ready valuations aligned with IFRS 13, Fair Value Measurement, so founders and finance teams always have a credible equity journey, from cap table management and ESOP administration to audit-ready evaluations, defensible numbers to stand behind.

Dealing with messy cap tables and complex valuations? Qapita manages every aspect of your equity journey, from cap table management and ESOP administration to audit-ready valuations and financial reporting. Book a demo to learn more.

FAQs on discounted cash flow method (DCF)

Where do you get the forecasted values from in a DCF?

Forecasted values are typically drawn from historical financial statements, management guidance, industry analyst reports and bottom-up revenue analysis. The quality of these inputs directly determines the reliability of the DCF output.

How do you do a DCF analysis on Microsoft Excel?

Excel provides two functions for DCF, the standard NPV formula for regular cash flow intervals and the XNPV formula for irregular intervals. Set up your projected cash flows with corresponding dates, enter your discount rate, and apply either formula depending on your cash flow timing:

• Regular cash flows: =NPV (discount rate, cash flow range) + initial investment
• Irregular cash flows: =XNPV (discount rate, cash flows, dates)

How accurate is the DCF method to value a company?

DCF is only as accurate as the assumptions behind it. When cash flow projections are realistic and the discount rate is well chosen, DCF produces a reliable valuation. Small changes in growth rate, discount rate or terminal value assumptions can significantly shift the output. This is why DCF is best used alongside other valuation methods rather than as a standalone figure.

How do you calculate DCF with negative cash flows?

Negative cash flows can still be included in a DCF calculation. Simply applying the same discount rate to the negative cash flow for that period, it will reduce the total present value rather than increase it. This is common in early-stage businesses where initial years show negative cash flows before the investment starts generating positive returns. The total DCF value is derived by combining all discounted cash flows, positive and negative, gives you the final DCF value.