Skip to Main Content
Banner Image

MMPA 2024-12M Integrated Case Competition

A guide to company and industry research for MMPA 2024-12M students participating in the Integrated Case Competition

WACC TEMPLATE

FactSet's Weighted Average Cost of Capital Excel template provides an overview of a company's WACC. The template returns WACC calculations for a company using the company's beta and beta derived from comparable companies as well as WACC from broker estimates.

To access the WACC template, click on the Template Library, Select Valuation and then Weighted Average Cost of Capital.

Cells in yellow can be used as Inputs. Be sure to click the Refresh button in the Menu each time you add or change a data point or Input.

 

FactSet Excel template for Weighted Average Cost of Capital