Originally published: 25/07/2016 11:44
Publication number: ELQ-53963-1

Weighted Average Cost of Capital (WACC)

A model for calculating Weighted Average Cost of Capital using beta's for equity

by Prof. Kerry Back
Professor of Finance at Rice University

with Rice University
We believe nothing is impossible.

28 reviews3,457 views|Start the discussion!|download for free

finance equity capital wacc

Description
The user must define the following inputs:
- Amount of equity
- Amount of debt
- Tax rate
- Equity beta
- Percentage Debt
- Percentage Equity
- Tax rate
- Cost of debt

This Best Practice includes
1 Excel Model

Prof. Kerry Back offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Objectives

Outputs:
- After-tax cost of debt
- Cost of equity
- Weighted average cost of capital

Reviews

- 4.8 / 5 (28 votes)
  - 86%
  - 11%
  - 4%
  - -
  - -
- Rate this Downloadable Best Practice
  Write a review
sk srini tenneti(last updated: 05/07/2021 03:38)
Manoj Varghese(last updated: 24/05/2021 21:35)
Arif Arafat Zahari(last updated: 29/11/2020 08:09)
Fred Esterhuizen(last updated: 02/11/2020 03:58)
hoàng thanh lê(last updated: 16/07/2020 01:35)
Enrico A. Di Dio 409(last updated: 17/05/2020 14:59)
Quy Tan(last updated: 13/03/2020 15:00)
Useful tool
It is really useful template. Thanks
Anil Gundapaneni(last updated: 28/01/2020 01:34)
DESIRE WADE ATCHIKE(last updated: 13/01/2020 18:33)
Mostafa Soliman(last updated: 18/12/2019 13:14)
Helen Crocker(last updated: 26/09/2019 02:56)
Elizabeth Brasier(last updated: 16/09/2019 20:14)
Tonka Golub(last updated: 13/09/2019 07:47)
Laila Aidi(last updated: 22/08/2019 07:30)
Dan Fordyce(last updated: 13/08/2019 05:45)
Alex Zhongbing Yan(last updated: 05/07/2019 13:58)
상철 한(last updated: 05/04/2019 13:12)
Dũng Đặng(last updated: 27/03/2019 10:17)
JC Marais(last updated: 16/03/2019 14:14)
Opal P.(last updated: 16/02/2019 09:55)
Dan Sande(last updated: 07/02/2019 00:31)
Enkhbold Battumur(last updated: 27/12/2018 15:09)
Huyen Ho864(last updated: 26/12/2018 07:43)
Orkhan Rustamov(last updated: 22/11/2018 18:53)
Cornelia Johansson(last updated: 09/11/2018 13:04)
Tien Le Quang(last updated: 03/11/2018 08:02)
Ivan Jovanovic(last updated: 20/09/2018 10:03)
Michael DaCosta, CPA(last updated: 30/07/2018 23:54)