Skip to Main Content
Banner Image

MMPA 2025-24M Integrated Case Competition

Research Guide for MMPA Case Competitions

WACC TEMPLATE

FactSet's Weighted Average Cost of Capital template provides an overview of a company's WACC. The template will return WACC models and capital structures for a company's peer group. 

The WACC template uses a default set of comps. To change the list of companies, you will need to edit the =FDS codes that generate the data; contact FactSet Support for assistance in doing this.

To access the WACC report:

  1. Click the Template Library button in the FactSet tab of Microsoft Excel.
  2. In the left pane, select the equity you want to view. You can type the name, abbreviation, or identifier directly in the Identifier box, and a list of matching items will appear below.
  3. Select the Analysis tab in the right pane, then select Wtd. Avg. Cost of Capital in the list.
  4. Click Finish.