# How to Calculate WACC in Excel, Step by Step Guide

## Weighted Average Cost of Capital – WACC Definition

A cost of capital must need to pay against corporate financing recognized weighted average cost of capital. Hence, WACC or Weighted Average Cost of Capital is a sum of all capital sources comprising debt, bonds, equity stocks, and preferred stocks.

Furthermore, it is the sum of the cost of debt, the cost of equity, and the preferred stock values of the corporation. There are two main sources of raising capital equity and debt.

## Cost of Equity (Ke)

The cost of equity is a calculation of common stock to measure the proportion of equity shareholders’ investment in a project. Moreover, the cost of equity is the required rate of return on equity investment in the project.

## Cost of Debt (Kd)

The cost of debt is the required rate of return on debt stock investment by the lenders.

## What Weighted Average Cost of Capital Formula

Firstly and most essentially, we need to understand the theoretical formula of WACC which is calculated as follows:

Where;

E = Equity market value

D = Debt market value

Re = cost of equity

Rd = cost of debt

t = corporate taxation rate

E / (E+D)= Weightage of equity value

D / (E+D)= Weightage of debt value

## How to Calculate WACC in Excel

Now, It will show you how to extract WACC value by using an Excel-based Calculator. For example, LuluLemon has a stock value comprised of both debt and equity capital. Thus, the total debt value is \$1,000,000 acquired at a rate of 7%, and \$2,500,000 as equity value at the rate of 4%, while the corporate tax rate is 25%.

Let’s, divide the above solution into three simple steps to understand it more precisely and effectively.

### Step 1

So, first is to put all the desired data into the following given format total debt value, cost of debt (%), tax rate (%), total equity value, and cost of equity (%).

### Step 2

Now, we need to calculate the total value of capital (debt+equity), and the weightage of both equity and debt values. Hence, the following image is showing the calculation of the weightage of both stocks.

### Step 3

Last and most importantly, we need to use the WACC formula in excel as shown in the following image.

Where,

E14 = Cost of Equity (%)

E22 = Weightage of Equity

E8 = Cost of Debt (%)

E20 = Weightage of Debt

E10 = Tax Rate (%)

## WACC Calculation Excel Template

Also, you can download the template of the WACC calculator in Excel sheet by clicking on the button or using calculator online.

Posted

in

by