Discounted Cash Flow (DCF) Method Calculation

Discounted Cash Flow (DCF) Method Calculation

Your partner for business valuation using the DCF method.

Call Now
Management Consulting

The discounted cash flow (DCF) method is a generic term for various approaches for calculating the company value or the real estate value (valuation object). In summary, the future cash flow is discounted to the present time and expressed as the company value.

The adjusted present value (APV) approach, the weighted average capital cost (WACC) approach and the total cash flow (TCF) approach belong to the entity approaches (gross methods). The flow-to-equity (FTE) approach is an equity approach (net method). The TCF approach is omitted in the following.

Call Now

First, the basics of the DCF method are explained. Then, three different approaches, namely the AVP approach, the WACC approach and the equity approach are presented in more detail. This is followed by a comparison between the capitalised earnings method and the DCF method.

Basics for DCF Methods

DCF methods are based either on the equilibrium model of Modigliani and Miller (1958), or on the capital asset pricing model (Sharpe, 1964; Lintner, 1965; Mossin, 1966).

The Equilibrium Model of Modigliani-Miller

According to the equilibrium model of Modigliani and Miller (1958), investors can invest in shares and bonds of companies on a capital market. The investors’ expectations about the expected return, the risk of the companies’ profit distributions and a risk-free interest rate are identical.

The value of a company results from the discounted profit distributions and bonds. Profit distributions are discounted using the cost of equity and debt using the cost of debt.

  • The total cost of capital always remains the same and thus also the company value (value additivity).
  • The cost of debt capital in the Modigliani and Miller equilibrium model is determined by the risk-free interest rate.
  • The cost of equity capital in the equilibrium model of Modigliani and Miller is a linear function of the debt ratio and takes risk into account.

Basically, this also assumes tax neutrality of equity and debt capital as well as a lack of bankruptcy risk.

By the way, there is a competing model with the classical thesis. In this model, the debt-equity ratio has an impact on the total cost of capital, which is not linear.

The assumptions are, among others:

  • homogeneous expectations
  • an infinite time horizon
  • perfect capital market
  • tax neutrality
  • no insolvency risk
  • risk neutrality

It can be seen that these assumptions are not fulfilled in reality. It is a simplified explanatory model.

Capital Asset Pricing Model

The capital asset pricing model is based on the portfolio theory of Markowitz (1952) and the equilibrium model of Modigliani and Miller (1958). It can be attributed to three authors (Sharpe, 1964; Lintner, 1965; Mossin, 1966).

In Markowitz’s (1952) model, investors have various risky investment opportunities and skillfully combine them so that the expected return is realised with minimal risk. In Markowitz’s model, one speaks of an efficient frontier, which specifies the optimal combination possibilities of expected returns and risks.

The model can be extended to include a risk-free interest rate for investing or borrowing money. One then has a so-called tangential portfolio. In summary, an attempt is made to achieve an expected return with the lowest possible risk (variance) by cleverly combining investments.

The CAPM model now assumes that all investors have the same expectations about the returns on the capital market. Investors can invest money in assets and invest or borrow money on the financial market accordingly. Through an “invisible hand”, the market values and thus the company values are determined for the market equilibrium. The result is a so-called market portfolio with a capital market line.

The expected return is determined by a price of time (risk-free interest rate) and price of risk (risk premium). For the mathematical derivation, please refer to the sources mentioned. They will probably be familiar to some readers. The systematic risk can be expressed as market risk premium * beta factor.

The formula for the capital market line in the CAPM model is:

expected return = risk-free rate + (expected return on market portfolio – risk-free rate)/ standard deviation of market portfolio * standard deviation

For the individual investor, the expected value depends upon the portfolio risk taken (standard deviation). More information on this can be found in the cited literature.

The formula for the security market line in the CAPM model is:

expected return of the asset = risk-free interest rate + (expected return of market portfolio - risk-free interest rate)/variance of market portfolio * covariance of the asset in relation to the market portfolio

However, the formula of the security market line in the CAPM model is often presented as follows:

expected return of the asset = risk-free interest rate + (market risk - risk-free interest rate) * beta factor

The beta factor represents the covariance of the asset in relation to the market portfolio divided by the variance of the market portfolio.

The assumptions of the model are, among others:

  • homogeneous expectations
  • a single period
  • perfect capital market
  • no taxes
  • no transaction costs
  • no time delay
  • risk aversion

When considering the assumptions, it also becomes clear that this is a simplified explanatory model and does not reflect reality. While some assumptions are removed by model extensions, such as in Brennan (1970) for tax integration, the basic critique remains.

The risk measurement based on variance also causes positive desired deviations to lead to greater discounting, which does not seem reasonable from the theoretical side.

It should be noted that the equilibrium model of Modigliani-Miller and CAPM are actually not combinable from the risk propensity and time horizon (Hering, 2021).

Baseline Scenario for the DCF Methods

The gross profit of a company is 12000 MU. The tax rate is 30%. The company has borrowed capital worth (1000/0.05) = 20000 MU. The interest rate in each period is 5% and the interest expense is 1000 MU. Interest is tax deductible. In the example, expenses and income are always cash-effective. (The English notation for numbers is used here, i.e., decimal points and commas are switched.)

Gross profit is 12000 MU and after tax (30%) 12000-(12000-1000)*0.3 = 8700 MU is distributed to the owners and lenders (net cash flow).

However, without the benefit of debt, the net cash flow would only be 12000-(12000)*0.3 = 8400 MU (equity-financed net cash flow).

(In a HGB balance sheet, a profit of 8700-1000=7700 MU would be stated.)

In the following explanations, an equivalence of the three DCF approaches is established so that the connection is easy to understand. In addition, a perpetual annuity is used first for easier understanding, so that problems such as the optimal capital structure can be ignored.

Then the example is extended to include a perpetual growth rate of 2%. The formal presentation here is such that there is a detailed planning period followed by a perpetuity at the planning horizon. The data for each of the first three years follow. The gross profit is [12000.0, 12240.0, 12484.8], the cash flow to lenders equals the interest on debt [1000.0, 1020.0, 1040.4], taxes [3300.0, 3366.0, 3433.32] and net cash flow [8700.0, 8874.0, 9051.48]. Equity-financed, the net cash flow would be [8400.0, 8568.0, 8739.36].

For a similar example with a step-by-step inductive derivation, please refer to the example of the capitalised earnings method.

Formula Discounting (DCF Method)

Here, the formula for the discount factor is presented. ρ stands for the discount factor, t for the respective year, τ is a running variable for the time, i for the interest rate and r for the risk. If the risk in the cash flow is taken into account by a discount, no risk premium may be added to the interest rate.

Formula Discount Factor

The discounting of the cash flow of a company with a perpetual life is represented by the following formula. The first part shows the discounting in the planning period, and the second part represents the annuity at the planning horizon. C stands for the net present value, t for the respective year, T for the planning period, e for the cash flow, ω for the growth rate.

Formula Discounting Perpetual

If a finite lifespan is assumed instead of a perpetual lifespan, a present value is applied to the planning horizon. n stands for the years.

Formula Discounting Finite

APV Approach

The adjusted present value (APV) approach is a variant of the DCF method and is based on the equilibrium model of Modigliani and Miller (1958) and can be traced back to Myers (1974).

The company value results from a basic present value of the debt-free company plus a tax shield. The tax shield arises because debt capital is tax privileged. If the value of the debt is subtracted from the total company value, the cost of equity can be calculated in retrospect. These can also be used to create an equivalence to the WACC approach and the equity approach.

APV Approach as Perpetuity (Steady State)

First, the company value is calculated as a perpetual annuity without growth (steady state). In the case of a steady state, there is a smooth equivalence between APV approach, WACC and equity approach.

The owner expects a return of 10%.

For the APV approach, the equity-financed net cash flow of 8400 MU is used to calculate the basic net present value. This is discounted by the expected return of 10% and results in 8400 / 0.1 = 84000 MU.

The tax shield results from the present value of the tax benefit. This is (1000*0.3)/0.05 = 6000 MU.

The basic net present value and the present value of the tax shield together result in the company value including debts of 84000 + 6000 = 90000 MU.

If the present value of the debt is subtracted, the value of the equity (company value) is 90000 - 20000 = 70000 MU.

From this the cost of equity of 0.1 + (1-0.3)*(0.1-0.05)*(20000/70000) = 11% can be derived. Alternatively, the following calculation method is also possible (8700-1000)/70000 = 11%.

APV Approach with Detailed Planning Period

The approach is now to be extended so that the first two years represent a detailed planning period and then a perpetual annuity with a perpetual growth rate is applied. The procedure is identical to the above example, except that discounting is first carried out on a period-specific basis and then with the help of a perpetual annuity including a growth rate. The above-described formulas are used, and this is done using the function npv. In the function, the interest vector is specified first, then the cash flow vector, and then a perpetual growth rate is specified.

The basic net present value is npv([0.1,0.1,0.1], [8400.0, 8568.0, 8739.36], 0.02) = 105000 MU.

The present value of the debt is npv([0.05,0.05,0.05], [1000.0, 1020.0, 1040.4], 0.02) = 33333.33 MU.

The present value of the tax shield is npv([0.05,0.05,0.05], [1000.0, 1020.0, 1040.4] .* [0.3, 0.3, 0.3], 0.02) = 10000 MU.

The value of the company including debts is 105000 + 10000 = 115000 MU.

The value of the equity (company value) is 115000 - 33333.33 = 81666.67 MU.

The cost of equity must be calculated iteratively per period. In the first period, it is

0.1 + (1-0.3)*(0.1-0.05)*(33333.33/81666.67) = 0.1142857142857143.

The data here was chosen so that the cost of equity also remains the same in the following periods.

APV Approach Calculator

Here you have the option of using a calculator for the APV approach. To do this, enter the cost of equity, the cost of debt, the tax rate, the equity-financed net cash flow, the cash flow to lenders and the cash flow to lenders, which is tax-effective. You can enter the values as a series of figures (vectors). You can also enter a growth rate for the planning horizon. The last input field is optional. If the field remains empty, a perpetual annuity is calculated on the planning horizon. If you enter a number, a present value with the given years is taken into account.

Results:

WACC Approach

The weighted average cost of capital (WACC) approach is a variant of the DCF method and is based on the CAPM model (Sharpe, 1964; Lintner, 1965; Mossin, 1966).

WACC Approach (Steady State)

In addition to the initial data, the cost of equity is taken from the APV approach of 11%. Equivalence to the APV approach can be achieved without any difficulties. The formula for WACC in the steady state is:

WACC = cost of equity * value of equity / value of total capital +

cost of debt * value of debt / value of total capital +

cost of debt * value of the tax shield / value of total capital.

WACC = 0.11*70000/90000 + 0.05*20000/90000 + 0.05*6000/90000 = 9.33%

Often, the last two terms are combined. However, this is only possible under very simplified assumptions regarding tax law.

WACC = 0.11*70000/90000 + (1-0.3)*0.05*20000/90000 = 9.33%

If the equity-financed net cash flow of 8400 MU is discounted with WACC, the result is 8400/0.0933 = 90000 MU.

From the total company value of 90000 MU, the debts of 20000 MU must again be subtracted, so that the equity is worth 70000 MU.

In practice, WACC is not seen as a reformulation of the APV approach, but the cost of equity is derived from the CAPM model.

WACC Approach with Detailed Planning Period

If an attempt is made to establish equivalence with the APV approach in the case of a detailed planning period and a perpetual annuity with a growth rate, the results with the above formula may be unsatisfactory. One way of achieving equivalence between the APV approach and the WACC is to distinguish between the present value of the tax shield and the value of the tax shield. The present value is determined with the interest rate on borrowed capital. The value is first discounted using the borrowing rate (existing debt) and then using the cost of equity (new debt). For a derivation and reconciliation, please refer to Massari et al. (2008).

However, the fact that the tax shield for existing debt is discounted using the cost of debt and that of new debt using the cost of equity is not very convincing to me, especially in view of the theoretical basis of the equilibrium model of Modigliani and Miller (1958).

For equivalence between the APV approach and the WACC approach, the growth rate of the tax shield must be taken into account. WACC stands for the WACC interest rate, i for the cost of equity (debt), i_f for the cost of debt, ω_S for the growth rate of the tax shield and t is a running variable for time.

WACC Formula

In practice, the cost of equity for WACC is not calculated as a reformulation of the APV approach, but is derived from the CAPM model.

WACC Approach Calculator

Here you have the option of using a calculator for the WACC approach. To do this, enter the cost of equity, the cost of debt, the equity-financed net cash flow, the present value of debt, the value of equity, the company value and the present value of the tax shield. You can enter the values as a series of figures (vectors). You can also enter a growth rate for the planning horizon. The last input field is optional. If the field remains empty, a perpetual annuity is calculated on the planning horizon. If you enter a number, a present value with the given years is taken into account.

Results:

Equity Approach

The Flow-to-Equity (FTE) approach is a variant of the DCF method and is based on the CAPM model (Sharpe, 1964; Lintner, 1965; Mossin, 1966).

Equity Approach (Steady State)

The net cash flow is discounted using the cost of equity. However, the cash flow to the debt holders must be subtracted from the total net cash flow (including tax benefits). If we refer back to the data from the APV approach, this would be (8700-1000)/0.11 = 70,000 monetary units.

An equivalence between the Equity approach and the APV approach can be established.

In practice, the cost of equity is not derived from the APV approach but from the CAPM model.

Equity Approach with Detailed Planning Horizon

The interest rate is again taken from the APV approach. The result of the Equity approach and the APV approach are consistent.

npv([0.1142857142857143, 0.1142857142857143, 0.1142857142857143], [8700.0, 8874.0, 9051.48] - [1000.0, 1020.0, 1040.4], 0.02) = 81,666.67 monetary units

Equity Approach Calculator

Here you have the option to use a calculator for the Equity approach. Enter the cost of equity and the total (!) net cash flow. You can input the values as a series of numbers (vectors). You can also enter a growth rate at the planning horizon. The last input field is optional. If the field is left blank, a perpetual annuity is calculated at the planning horizon. If you enter a number, a present value with the given years is considered.

Results:

Comparison of Earnings Value Method and DCF Method Example

In the following, the subjective earnings value method will be compared to the DCF method (APV), and an example will be given for both.

The data are from the initial scenario. An inflation and thus a growth of the net cash flow of 2% is assumed, resulting in a perpetual growth rate at the planning horizon. The interest rate is 5% but must be taxed at 25% in private assets, so the net interest rate is 3.75%. No taxes are due on the profit from the sale of the company.

The seller perceives the expectations about the company's development as subjectively certain. Furthermore, he is risk-averse and wants to invest the proceeds from the sale of the company in the bank.

Excursus: Risk can generally be taken into account either via the discount factor (risk premium method) or via an adjustment in the cash flow (certainty equivalent method). Both can be mathematically converted into each other (Terstege, 2023). It seems sensible to me to capture it as an adjustment in the cash flow using various scenarios. This simplifies a correct tax calculation, as it is based on earnings figures, is often non-linear, and also includes allowances. In addition, one must explicitly think about the risk instead of capturing it indirectly. In the above example, however, the seller sees his forecasts as subjectively certain.

According to the earnings value method, a company value of 7700/(0.0375-0.02) = 440,000 monetary units results. To get the same net cash flow as through the company shares, the seller must invest an amount of 440,000 monetary units in the bank.

If the interest rate or cash flow fluctuates within the planning horizon, the more complicated formula with period-specific discounting must be applied. As an example, it is applied here to the case of the perpetual annuity with a growth rate:

Year 1: 7700 * (1+0.0375)^-1 = 7421.69

Year 2: 7854 * (1+0.0375)^-2 = 7296.50

Year 3: [8011.08/(0.0375-0.02)] * (1+0.0375)^-3 = 425,281.81

The sum also equals 440,000 monetary units.

Earnings Value Method as Base

DescriptionYear 1Year 2Year 3Year...
Assets440,000448,800457,776...
Gross Interest Income22,00022,44022,888.8...
Taxes-5,500-5,610-5,722.2...
Withdrawal-7,700-7,854-8,011.08...

Source: Own representation.

The calculations show that he receives the same cash flow each year as through his company. Since the cash flow grows perpetually, the invested assets also increase in each period.

Now, the company value is calculated using the Equity approach, which is equivalent to the APV approach from above. The data are taken from the above example of the APV approach and the Equity approach with a perpetual growth rate of 2% in the steady state.

(8700-1000)/(0.1142857142857143-0.02) = 81,666.67 monetary units.

If the interest rate or the cash flow fluctuates within the planning horizon, the more complicated formula with period-specific discounting must also be applied here. As an example, it is applied here to the case of the perpetual annuity with a growth rate:

Year 1: (8700-1000) * (1+0.1142857142857143)^-1 = 6,910.26

Year 2: (8874-1020) * (1+0.1142857142857143)^-2 = 6,325.54

Year 3: [(9051.48-1040.4)/(0.1142857142857143-0.02)] * (1+0.1142857142857143)^-3 = 68,430.87

The sum also equals 81,666.67 monetary units.

The seller sold his company for this amount because he relied on an external consultant. However, he does not invest his money in the capital market but in his local bank at 5% gross interest because he is risk-averse. He tries to receive the same cash flow as through the company. However, this is not possible for him, and his assets decrease year after year. The problem is that the calculation was not made using the endogenous marginal interest rates of the party involved. A value was determined for a fictitious investor in the capital markets. The external consultant simply relied on the textbook formulas known to him without taking into account the individual situation of his client.

DCF Method

DescriptionYear 1Year 2Year 3Year...
Assets81,666.6777,029.1672,063.76...
Gross Interest Income4,083.333,851.463,603.19...
Taxes-1,020.83-962.86-900.8...
Withdrawal-7,700-7,854-8,011.08...

Source: Own representation.

The DCF method is based on capital market theoretical explanatory models that do not correspond to real conditions. In the above example, the alternative investment of the bank was the marginal interest rate (endogenous marginal interest rate) and not an interest rate derived from the CAPM model. The extreme example shows that the decision value of the party involved only coincidentally matches the company value determined using a DCF method.

The deviations of the company value according to the DCF method can occur both above and below compared to the earnings value method or functional business valuation.

Conclusion

The different variants of the DCF method are based on the equilibrium model of Modigliani and Miller (1958) and the CAPM model (Sharpe, 1964; Lintner, 1965; Mossin, 1966). The premises for these explanatory models are not given in the real imperfect world. The assumptions of the second model are more restrictive than those of the first.

In theory, the APV approach, the WACC approach, and the Equity approach can be converted into each other. However, deriving the WACC approach from the APV approach with perpetual annuity and growth rate is theoretically somewhat problematic. In practice, however, little attention is paid to the problem, and the cost of equity for WACC is derived directly from the CAPM model. The APV approach is based on fewer premises than the WACC approach and is therefore preferable.

What is generally problematic with the DCF methods is that the individual situation of the investor with his real investment opportunities, tax rates, and withdrawal preferences is not taken into account. A fictitious company value is calculated for a fictitious investor acting on a perfect capital market. However, this value will very rarely coincide with the decision value of the actual investor. To calculate this, one must refer to the functional business valuation and the closely related earnings value method. Only these allow such refinements to be integrated into a valuation model. For detailed criticism, see Hering (2017), Hering (2021), and Matschke and Brösel (2013).

In practice, the decision value, which marks the threshold for profitability, should be determined according to the functional business valuation. Additionally, argumentation values can be determined based on the various DCF approaches and other business valuation methods. This enables an excellent information base with a corresponding negotiating position.

References