Find

Weighted YTM

Pre-tax cost of debt

Adjustment for tax rates

After-tax cost of debt

Average tax rate

Pre tax cost of debt (bonds)

After tax cost of debt (bonds)

Total market value of equity and debt

Weight for equity

Weight for debt

Weighted average cost of capital

(USING EXCEL and EXCEL FUNCTIONS)

Microsoft outstanding bonds as of 06/30/22 Face amounts are in millions. Microsoft outstanding bonds as of 06/30/22 Face amounts are in millions