WACC Calculation Template

An Excel template for calculating the Weighted Average Cost of Capital (WACC) using beta's for equity.

Attachments:

Permalink Reply by Bernard Kiarie on January 26, 2010 at 5:12am: Thanks alot.I havent looked at it but it looks simple and great.
Can somebody assist on how i can come up with the equity beta for certain stock; ▶ Reply to This

Permalink Reply by Anoop Prakash on January 26, 2010 at 5:17am: Thank you very much for such a file.... I am really happy to be a member of such a wonderful site...

Thanks & regards

Anoop Prakash; ▶ Reply to This

Permalink Reply by Trân Thoai Ly on January 26, 2010 at 5:19am: Thank you for your sharing. This is a good excel template; ▶ Reply to This

Permalink Reply by Brent Wheeler on January 26, 2010 at 7:03am: Can I encourage people to try the template in their work please... and give us the feedback!!!! Things that are really helpful to know are:

1. What Risk free rate you use and why
2. What Rm- Rf (ERP) equity risk premium you like and why
3. Where you source industry risk and why

It is also really useful to know what is different in your part of the world....Mumbai? How is it riskier / the same / better / worse.... New York? Africa.... oh boy... help us here. what values make sense, where do we start, how do these values differ across the vast continent.....

In a wide world, with massive differences any data you have is important. This is a good place to share it...

I can start... here in KL Malaysia at present working... energy subsidies are an issue. They drive down short term risk but - it has to be - they drive up long term risk in gas, electricity, petrol..... long run I would add 150 basis points for when they disappear. There is, then, one opinion.

B; ▶ Reply to This

Permalink Reply by Eric Kwame Tsekpo on January 26, 2010 at 8:22am: This is really smart and handy. Thanks for sharing it.; ▶ Reply to This

Permalink Reply by Siyanda on January 26, 2010 at 12:12pm: I am a third year MBL student. I love what I see right now. Cool Staff!; ▶ Reply to This

Permalink Reply by Afsar Shahi on January 27, 2010 at 1:38am: THANK YOU SO MUCH FOR YOUR HELP SAVING OUR TIME; ▶ Reply to This

Permalink Reply by Brent Wheeler on January 27, 2010 at 1:54am: Cool... tell us how it works out for you.; ▶ Reply to This

Permalink Reply by Anh Duc Nguyen on January 27, 2010 at 10:39am: Thanks for your sharing!!; ▶ Reply to This

Permalink Reply by yogesh s k on January 29, 2010 at 11:26am: its really great!!

yogesh; ▶ Reply to This

Permalink Reply by Reny Kimberly on February 3, 2010 at 3:11am: Thank you for finance system tools calculation, keep up the good work...good luck for these site; ▶ Reply to This

Permalink Reply by Bhalchandra Moghe on February 4, 2010 at 12:20pm: Thank you very much ... IT saved my lot of Time; ▶ Reply to This

Sign in

Loading…

	Accounting
	Banking Regulations
	Certification Training
	Commercial Bank Management
	Corporate Finance & Valuation
	Treasury Management
	Credit Risk Management
	Financial Derivatives
	Financial Institution Management
	Financial Markets
	Financial Modeling
	Financial Planning
	Market Risk Management
	Operational Risk Management
	Operations & Compliance
	Quantitative Analysis
	Strategic Financial Management