Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Banner Image

MMPA 2022 Integrated Case Competition

A guide to company and industry research for MMPA 2022 students participating in the Integrated Case Competition

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. 

1. There are two kinds of template inputs. Most of these are identified by the default 'Disable' mode and are in blue.  Please review the Instructions worksheet for more information.  Once enabled,  'Enable Mode Calculations' worksheet is used to change the input, using 1 and 0 to select/unselect options.
2. The other kind of input is marked in blue and have pull-down menus.  These are the cost of debt and the risk free rate.

FactSet's WACC Template

 

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.  To do this:

  • Click on the 'Show or Hide Sidebar' button included in the FactSet add-in ribbon to display the sidebar if not already active
  •  Select the cell with the company ticker you wish to change and then select the 'Edit' tab in the FactSet Sidebar; the existing identifier will be listed underneath the 'Identifier' search box.
  • Enter the desired ticker or company name in the 'Identifier' box and it will now appear below. 
  • Click the 'Modify' button and select the option to overwrite the existing company OR the option to append or add this company to the list of comps. 
  • For major changes to the comps list, please contact FactSet Support for assistance.