There is no specific formula in Excel or other spreadsheet applications ... Cost of Equity (Equity>Cost) You multiply debt cost and weight, and add it to the product of equity cost and weight ...