Microsoft (Microsoft) WACC %

Microsoft Annual Data
	Trend	Jun14	Jun15	Jun16	Jun17	Jun18	Jun19	Jun20	Jun21	Jun22	Jun23
WACC %							7.69	5.63	5.97	8.14	9.76

Microsoft Quarterly Data
	Mar19	Jun19	Sep19	Dec19	Mar20	Jun20	Sep20	Dec20	Mar21	Jun21	Sep21	Dec21	Mar22	Jun22	Sep22	Dec22	Mar23	Jun23	Sep23	Dec23
WACC %																9.06	9.41	9.76	10.31	9.82

For the Software - Infrastructure subindustry, Microsoft's WACC %, along with its competitors' market caps and WACC % data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.

For the Software industry and Technology sector, Microsoft's WACC % distribution charts can be found below:

* The bar in red indicates where Microsoft's WACC % falls into.

Microsoft WACC % Calculation

The weighted average cost of capital (WACC) is the rate that a company is expected to pay on average to all its security holders to finance its assets. The WACC is commonly referred to as the firm's cost of capital. Generally speaking, a company's assets are financed by debt and equity. WACC is the average of the costs of these sources of financing, each of which is weighted by its respective use in the given situation. By taking a weighted average, we can see how much interest the company has to pay for every dollar it finances.

1. Weights:
Generally speaking, a company's assets are financed by debt and equity. We need to calculate the weight of equity and the weight of debt.
The market value of equity (E) is also called "Market Cap". As of today, Microsoft's market capitalization (E) is $3059333.509 Mil.
The market value of debt is typically difficult to calculate, therefore, GuruFocus uses book value of debt (D) to do the calculation. It is simplified by adding the latest one-year quarterly average Short-Term Debt & Capital Lease Obligation and Long-Term Debt & Capital Lease Obligation together. As of Dec. 2023, Microsoft's latest one-year quarterly average Book Value of Debt (D) is $70792.8 Mil.
a) weight of equity = E / (E + D) = 3059333.509 / (3059333.509 + 70792.8) = 0.9774
b) weight of debt = D / (E + D) = 70792.8 / (3059333.509 + 70792.8) = 0.0226

2. Cost of Equity:
GuruFocus uses Capital Asset Pricing Model (CAPM) to calculate the required rate of return. The formula is:
Cost of Equity = Risk-Free Rate of Return + Beta of Asset * (Expected Return of the Market - Risk-Free Rate of Return)
a) GuruFocus uses 10-Year Treasury Constant Maturity Rate as the risk-free rate. It is updated daily. The current risk-free rate is 4.585%. Please go to Economic Indicators page for more information. Please note that we use the 10-Year Treasury Constant Maturity Rate of the country/region where the company is headquartered. If the data for that country/region is not available, then we will use the 10-Year Treasury Constant Maturity Rate of the United States as default.
b) Beta is the sensitivity of the expected excess asset returns to the expected excess market returns. Microsoft's beta is 1.04.
c) (Expected Return of the Market - Risk-Free Rate of Return) is also called market premium. GuruFocus requires market premium to be 6%.
Cost of Equity = 4.585% + 1.04 * 6% = 10.825%

3. Cost of Debt:
GuruFocus uses latest TTM Interest Expense divided by the latest one-year quarterly average debt to get the simplified cost of debt.
As of Dec. 2023, Microsoft's interest expense (positive number) was $2412 Mil. Its total Book Value of Debt (D) is $70792.8 Mil.
Cost of Debt = 2412 / 70792.8 = 3.4071%.

4. Multiply by one minus TTM Tax Rate:
GuruFocus uses the most recent TTM Tax Expense divided by the most recent TTM Pre-Tax Income to calculate the tax rate. The calculated TTM tax rate is limited to between 0% and 100%. If the calculated tax rate is higher than 100%, it is set to 100%. If the calculated tax rate is less than 0%, it is set to 0%.
The latest calculated TTM Tax Rate = 18669 / 101210 = 18.45%.

Microsoft's Weighted Average Cost Of Capital (WACC) for Today is calculated as:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

Microsoft  (NAS:MSFT) WACC % Explanation

Because it costs money to raise capital. A firm that generates higher ROIC % than it costs the company to raise the capital needed for that investment is earning excess returns. A firm that expects to continue generating positive excess returns on new investments in the future will see its value increase as growth increases, whereas a firm that earns returns that do not match up to its cost of capital will destroy value as it grows.

As of today, Microsoft's weighted average cost of capital is 10.64%%. Microsoft's ROIC % is 25.34% (calculated using TTM income statement data). Microsoft generates higher returns on investment than it costs the company to raise the capital needed for that investment. It is earning excess returns. A firm that expects to continue generating positive excess returns on new investments in the future will see its value increase as growth increases.

1. GuruFocus uses book value of debt (D) to do the calculation. It is simplified by adding latest one-year quarterly average Short-Term Debt & Capital Lease Obligation and Long-Term Debt & Capital Lease Obligation together.
For companies that report quarterly, GuruFocus combines all of the most recent year's quarterly debt data from the beginning of the year to the year-end and calculates the average.
For companies that report semi-annually, GuruFocus combines all of the most recent year's semi-annual debt data from the start of the year to the year-end and calculates the average.
For companies that report annually, GuruFocus combines the beginning and ending annual debt data from the most recent year and then calculates the average.

2. The WACC formula discussed above does not include Preferred Stock. Please adjust if preferred stock is considered.

3. (Expected Return of the Market - Risk-Free Rate of Return) is also called market premium. GuruFocus requires market premium to be 6%.

4. GuruFocus uses the latest TTM Interest Expense divided by the latest one-year quarterly average debt to get the simplified cost of debt.

Microsoft (Microsoft) Business Description