Discounted Cash Flow (DCF) Method Calculation

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 TFC approach is omitted in the following.

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.

Global Management Consultancy for Business Valuation (DCF Method) from Rhine-Ruhr (Wuppertal, Cologne, Düsseldorf, Essen, Dortmund)

DCF - Table of Contents

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 Makrowitz’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 market portfolio – risk-free rate)/ standard deviation 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 line in the CAPM model is:

expected return = risk-free interest rate + (expected return on market portfolio- risk-free interest rate)/standard deviation market portfolio^2 * covariance of the investment relative to the market portfolio

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

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

The beta factor represents the covariance of the investment relative to the market portfolio / standard deviation market portfolio^2.
 

 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.

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 10000-(12000)*0.3 = 8400 MU (equity-financed net cash flow).

(A HGB profit and loss would show a profit of 8700-1000=7700 MU).

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 on the planning horizon. The data for each of the first three years follow. 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 piecewise inductive explanation, please refer to the example of the capitalised earnings method, for this moment only available in German.

Formula Discounting (DCF Method)

The formula for the discount factor is shown here. ρ 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.

Abzinsungsfaktor

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 on 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.

Unternehmenswert Formel (mit ewiger Rente)

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.

Unternehmenswert Formel (mit ewiger Rente)

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 the APV approach, WACC and equity approach.

The owner expects a return of 10%.

For the APV approach, the self-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% (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 net present value of the tax shield together result in the company value including debts of 84000 + 6000 = 90000 MU.

If the net present value of the debt is subtracted, the value of the equity (“company value”) is 90000 – 20000 = 70000 MU.

From this the equity costs 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 formulas described above are used, whereby this is done using the function npv. In the function, the interest vector is specified first, then the self-financed net cash flow vector and then a perpetual growth rate.

The basic cash 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.34 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.34 = 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.34/81666.67) = 0.1142857142857143.

The data here was chosen so that the cost of equity 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 equity capital costs are 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%

The last two terms are often summarised.

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

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

From the total company value of 9000 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 net 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 Modigliani and Miller’s (1958) equilibrium model.

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. At the end of the period, the perpetuity with growth corresponding to equity-financed cash flow/(WACC – growth rate) is applied and discounted with a discount factor. It may be that many practical users are not really aware of the problem and “simply” apply the formulas.

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 debt cash flow must be subtracted from the net cash flow (incl. tax advantage). If the data from the APV approach is used, this would be (8700-1000)/0.11 = 70000 MU.

Equivalence can be established between the equity approach and the APV approach.

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

Equity Approach with Detailed Planning Period

The interest rate is again taken from the APV approach. The result of the equity approach and the APV approach match.

npv([0.1142857142857143,0.1142857142857143,0.1142857142857143], [8700.0, 8874.0, 9051.48] – [1000.0, 1020.0, 1040.4],0.02) = 81666.67 MU

Equity Approach Calculator

Here you have the option of using a calculator for the equity approach. To do this, enter the cost of equity and the (total) net cash flow. 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:

Capitalised Earnings Method DCF Method Comparison Example

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

The data are from the given scenario with growth rate. Inflation and thus cash flow increase of 2% are assumed, which results in a perpetual growth rate at the planning horizon. The interest rate is 5% but must be taxed at 25% on private assets, so the net interest rate is 3.75%. There is no tax on the profit from the sale of the company.

The seller subjectively sees the expectations about the company’s development as certain. Furthermore, he is risk averse and wants to invest the proceeds from the sale of the company at the bank.

Excursus: Risk can generally be taken into account either via the discount factor (risk premium method) or via a correction in the cash flow (security equivalent method). Both can be mathematically reconciled (Terstege, 2023). In my opinion, it makes sense to adjust the cash flow by using different scenarios. This simplifies a correct determination of taxes, because taxation is often not linear and includes for example allowances. Moreover, one has to think about the risk explicitly instead of indirectly including it. In the above example, however, the seller sees his forecasts as subjectively safe.
 

According to the capitalised earnings method, the company value is 7700/(0.0375-0.02) = 440000 MU. In order to get the same net cash flow as from the company shares, the seller must invest an amount of 497142.86 MU at the bank.

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

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

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

Year 3: 8011.08/(0.0375-0.02) * (1+0.0375)^-1 * (1+0.0375)^-1 = 425281.812 MU

The sum is exactly 440000 MU.

Capitalised Earnings Method Example

Name Year 1 Year 2 Year 3 Year...
capital 440000 448800 457776 ...
interest revenue (gross) 22000 22440 22888.8 ...
taxes -5500 -5610 -5722.2 ...
withdrawal -7700 -7854 -8011.08 ...

Source: own representation.

The calculations show that every year he receives the same cash flow as through his former company. Since the cash flow grows forever, the invested capital also increases in each period.

The company value is now 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) = 81666.67 MU.

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

Year 1: (8700-1000)* (1+0.1142857142857143)^-1 = 6910.26 MU

Year 2: (8874-1020)* (1+0.1142857142857143)^-1 * (1+0.1142857142857143)^-1 = 6325.54 MU

Year 3: (9051.48-1040.4)/(0.1142857142857143-0.02) * (1+0.1142857142857143)^-1 * (1+0.1142857142857143)^-1 = 68430.87 MU

The sum equals 81666.67 MU.

The seller sold his company for this amount because he relied on an external advisor. However, he does not invest his money on the capital market, but with his house bank at 5% gross, because he is risk averse. He tries to get the same cash flow as through the company. However, he is not able to do so and his capital decreases year by year. The problem is that the calculation was not made with the endogenous marginal interest rate of the person in question. A value was calculated for a hypothetical investor on the capital markets. The external advisor simply fell back on the textbook formulas he was familiar with, without taking the individual situation of his client into account.

DCF Method Example

Name Year 1 Year 2 Year 3 Year...
capital 81666.67 77029.16 72063.76 ...
interest revenue gross 4083.33 3851.46 3603.19 ...
taxes -1020.83 -962.86 -900.8 ...
withdrawl -7700 -7854 -8011.08 ...

Source: own representation.

The DCF method is based on theoretical models of the capital market, which do not correspond to the real world. In the above example, the alternative investment was the interest rate given by the bank (endogenous marginal interest rate) and not an interest rate derived from the CAPM model. The extreme example shows that the decision value of the subject only coincidentally corresponds to the company value, which is calculated using the DCF method.

The divergence of the company value according to the DCF method can occur both upwards and downwards in comparison to the capitalised earnings method or functional business valuation.

Conclusion

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

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 perpetuity including a growth rate is not unproblematic. 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 assumptions than the WACC approach and is therefore preferable.
 

What is generally problematic about DCF methods is that they do not take into account the individual situation of the investor with his real investment opportunities, his tax rates and his withdrawal preferences. A fictive company value is calculated for a fictive investor who operates on perfect capital markets. However, this value will only very rarely match the decision value of the actual investor. To calculate this, we must apply the functional business valuation or the closely related capitalised earnings method. Only this method allows the integration of these subtleties into a valuation model. For a detailed critique, please refer to Hering (2017), Hering (2021) and Matschke and Brösel (2013).

In practice, the decision value, which marks the cut-off point for advantageousness, should be determined according to the functional business valuation. In addition, argumentation values can be calculated on the basis of different DCF approaches and other methods for business valuation. This provides an excellent information basis with a respective negotiating position.

References