The weighted average cost of capital (WACC) is a financial metric that reveals a firm's total cost of capital. To calculate WACC in Excel ... You can enter the prices in column X, and enter ...