WACC Calculator - Model Template

Download WSO's free WACC Calculator model template below! This template allows you to calculate WACC based on capital structure, cost of equity, cost of debt and tax rate. The template is plug-and-play, and you can enter your own numbers or formulas to auto-populate output numbers. The template also includes other tabs for other elements of a financial model.

IMPORTANT UPDATE: New WSO Financial Modeling Courses Now Available Here.

According to the WSO Dictionary,

"WACC, or Weighted Average Cost of Capital, is a financial metric used to measure the cost of capital to a firm. It is most usually used to provide a discount rate for a financed project, because the cost of financing the capital is a fairly logical price tag to put on the investment. WACC is used to determine the discount rate used in a DCF valuation model."

A screenshot below shows a sneak peak of the template.

WSO WACC Calculator Template

Start Discussion

Total Avg Compensation

September 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (38) $367
  • Associates (218) $232
  • 2nd Year Analyst (132) $153
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (102) $144
  • 1st Year Analyst (483) $135
  • Intern/Summer Analyst (375) $82