WACC Calculator Template

Calculate WACC based on capital structure and cost of various sources of funds

Download WSO'sfreeWACC Calculatormodel templatebelow!

This template allows you to计算加权平均based on capital structure, cost of equity, cost of debt, and tax rate.

The template isplug-and-play, and you can enter your own numbers or formulas toauto-populateoutput numbers. The template also includes other tabs forother elements of afinancial model.

According to theWSO 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 aDCF valuation model."

A screenshot below gives youa sneak peekof the template.

WACC Calculator Template

Elite Modeling Package

Everything You Need To Master Financial Modeling

To Help you Thrive in the Most Prestigious Jobs on Wall Street.

354manbetx

More Resources:

我们希望这个模板帮助你擅长的工作!Please check out the following additional resources to help you advance your career:

Attachment Size
WACC Calculator Template.xlsx143.31 KB 143.31 KB