There is no specific formula in Excel or other spreadsheet applications that will calculate a company's weighted average cost of capital (WACC) for you. Instead, the sheet must be populated with ...

The discount rate refers to the interest rate used when calculating the net present value (NPV ... capital equals the return of capital. The Excel formula for calculating the discount rate ...