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