WACC Calculator Template

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

Author: Austin Anderson
Austin Anderson
Austin Anderson
Consulting | Data Analysis

Austin has been working with Ernst & Young for over four years, starting as a senior consultant before being promoted to a manager. At EY, he focuses on strategy, process and operations improvement, and business transformation consulting services focused on health provider, payer, and public health organizations. Austin specializes in the health industry but supports clients across multiple industries.

Austin has a Bachelor of Science in Engineering and a Masters of Business Administration in Strategy, Management and Organization, both from the University of Michigan.

Reviewed By: Patrick Curtis
Patrick Curtis
Patrick Curtis
Private Equity | Investment Banking

Prior to becoming our CEO & Founder at Wall Street Oasis, Patrick spent three years as a Private Equity Associate for Tailwind Capital in New York and two years as an Investment Banking Analyst at Rothschild.

Patrick has an MBA in Entrepreneurial Management from The Wharton School and a BA in Economics from Williams College.

Last Updated:September 15, 2022

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.

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 gives you a sneak peek of the template.

WACC Calculator Template

More Resources:

We hope this template helps you excel at your job! Please check out the following additional resources to help you advance your career:

Attachment Size
WACC Calculator Template.xlsx 143.31 KB 143.31 KB