## How to Calclulate WACC in Excel

The __formula for calculating WACC__ in Excel is as follows:

=Wd*(1-Tc)*Rd + We*Re

Where:

Wd: Weight of Debt

Tc: Corporate Tax Rate

Rd: Cost of Debt

We: Weight of Equity

Re: Cost of Equity

To calculate the weights of debt and equity, use the following formulas:

Wd = D / (D + E)

We = E / (D + E)

Where:

D: Market value of Debt

E: Market value of Equity

You can also use the built-in function in Excel for calculating WACC, which is as follows:

=WACC(E, Re, D, Rd, Tc)

Where:

E: Market value of Equity

Re: Cost of Equity

D: Market value of Debt

Rd: Cost of Debt

Tc: Corporate Tax Rate

Note that the order of the inputs may vary depending on the version of Excel you are using.

## What is Weighted Average Cost of Capital(WACC)?

In simple terms, it means that a company needs to make enough money from its investments to pay back the people who have invested in the company (like shareholders and bondholders).

__WACC__ is calculated by looking at how much money a company has borrowed (debt) and how much money it has raised by selling shares (equity). The cost of debt and equity are then weighted by their proportions in the company's capital structure. The result is a single number that represents the minimum return the company must earn to satisfy its investors and creditors.

In practice, WACC is used by companies to help them make decisions about which investment projects are worth pursuing. If a project is expected to earn less than the __WACC__, it may not be worth pursuing because it won't be able to generate enough return to satisfy the investors and creditors.

## Comments