Skip to main content
Version: 2.15.X

Compute Weighted Average Cost of Capital in Cogynt

WACC, or weighted average cost of capital, is an important formula used in stock valuation. Without it, precision equity analysis of discount cash flow is challenging.

note

It is possible to use an arbitrary "discounted rate" when calculating discounted cash flow (DCF), but this rate is not as accurate as WACC.

The WACC is the average cost of generating the capital necessary to perform operations. In simple terms, such a figure might represent a 15% interest business loan. In more complex circumstances, WACC can include other forms of company debts (such as IPOs, other kinds of loans, and acquisitions).

Because WACC tells us the cost to generate capital, it is an important component of the DCF formula.

The formula for WACC looks like this:

WACC = (E/V * Ke) + (D/V) * Kd * (1 – Tax rate)

The formula works as follows:

  1. Start with your equity divided by the total equity plus debt.
  2. Multiply that figure by the cost of equity.
  3. Divide debt by equity plus debt. Multiply that value by the cost of debt, and then add the cost of equity and cost of debt figures together.

The final figure is the stock's WACC value.

Computing WACC in Cogynt

The formula for WACC is translated to Cogynt using computations.

Preparing Data

We computed CAPM, or the Capital Asset Pricing Model, in an earlier calculation. The result, called cost of equity, is used in our computations. We also pull in data from income statements, balance sheets, and from the ticker's company profile.

Calculating Market Value of Equity/Capitalization

The market value of equity calculation looks like this:

(E/V * Ke)

This calculation tries to find a company's market capitalization, or the total dollar value of a company's equity. At its heart, this calculation distills the value of a company based on its assets subtracted by its liabilities (debts).

To calculate the market value of equity in Cogynt Authoring:

  1. Pull the market capitalization value, and use PLUS to add it to the ending total debt figure. (This is V.)

Use PLUS to add market capitalization to ending total debt

  1. Divide market capitalization by that result. (This is E/V.)

Use DIVIDE, with the previous output as the denominator, and market capitalization as the numerator.

  1. Multiply the result by the Cost of Equity value. (This is D/V * Ke, the Cost of Equity that was calculated in the CAPM model.)

Use MULTIPLY to multiply the previous output by the Cost of Equity Value

The result is the market value of equity.

Market Value of Debt

Cost of debt is the total amount of interest owed on a debt, and is representative of the company's long term debt obligations.

This part of the formula covers:

(D/V)

To calculate cost of debt in Cogynt Authoring:

Using COMBINE and AVG to combine and average debt.

  1. Use DIVIDE to divide the ending total debt by the sum of ending and beginning total debt.
  2. Use COMBINE to combine the beginning and ending values of known total debt.
  3. Use AVERAGE to get the average value of those two figures.
  4. Use DIVIDE to divide the average of beginning and ending debt by the interest expense.

Cost of Equity

The cost of equity represents the return a company must realize before a given or project is worth investment. It's a figure designed to factor in the possible return on an investment the company decides to take on, and it's the final part of the WACC formula.

The final component of the formula

To calculate cost of equity in Cogynt Authoring:

  1. Use MINUS to subtract 1 from the corporate tax rate.
  2. Multiply this value by the Market value of debt.
  3. Output the result as the WACC value.

Tying WACC Output to DCF

Previously, our DCF model used a flat discount rate of 8%. With WACC properly calculated, we have a much more precise figure for discounting cash flow that will apply to any company we run through our model. Such personalized results are fundamental to stock analysis, but WACC is commonly overlooked. It's a complex formula, and discount rates offer a more convenient solution.

Cogynt's intuitive no-code approach solves this issue. Construct the WACC formula once, run any ticker through it, and the results apply to other parts of the model with minimal analyst input.