Since you made two trades, you divide by two, for an average trade price of $110. Here's the formula used to calculate the average trade price in the example above. How to calculate the weighted ...

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 ...