WACC Calculation Template

Replies to This Discussion

Permalink Reply by Thanh Daoquang on May 18, 2008 at 7:45am

I study in Vietnam. My teachers only teach theory and theory. Thank you so much for models in excel

• ▶ Reply

Permalink Reply by Anh Duc Nguyen on January 27, 2010 at 10:37am

Hi guys,

Which university are you studying in Vietnam? I am working in Vietnam too,

Nice to see u on Finance 3.0

• ▶ Reply

Permalink Reply by Dipu James on June 28, 2008 at 3:28am

THANK YOU FOR SAVING TIME

DIPU JAMES
INDIA

• ▶ Reply

Permalink Reply by sxr on October 13, 2008 at 5:23pm

Thank you very much, for share this file with all of us. it is simple and great help!!

• ▶ Reply

Permalink Reply by James on November 2, 2008 at 2:03pm

I am having trouble applying this method to my particular problem. Here it goes I am attempting to calculate the minimum expected rate of return from a new capital project to satisfy the suppliers of capital given the current capital structure

Total Assets 600,000
Debt 300,000
pref stock 100,000
Common Equity 200,000

Tax rate 40%
YTM on debt 11%
Flotation cost per share on Pref. Stock .75
Flotation cost per share on common stock $4
CMV Pref $26
CMV Common $143

Expepected dividend growth 13% per year

If the firm is looking to forgo the current capital strucutre to finance the new project.

• ▶ Reply

Permalink Reply by Fazil Gadzhiev on November 2, 2008 at 3:06pm

While calculating the cost of equity I would add additional premiums for the country risk, size of the company and liquidity of the shares (traded or non-traded on stock exchange).

• ▶ Reply

Permalink Reply by Yen Yong on January 25, 2010 at 8:15pm

i think you could adjust this when you completed the calculation . it is a good idea.

i have this file for almost a year plus. it is good and your point also good for other countries..

• ▶ Reply

Permalink Reply by Brent Wheeler on January 26, 2010 at 7:35am

Yes indeed Yen... the issue is "what are the adjustments" !!!!

• ▶ Reply

Permalink Reply by SEETOHUL VIMI on April 12, 2009 at 2:54am

THANKS U FOR SENDING ME EXCEL SHEET

• ▶ Reply

Permalink Reply by Amrit Sukhani on May 20, 2009 at 5:51am

I am uploading an excel file for the calculation of FCFE containing projections for future years. Hopefully it may be useful to the users.

Attachments:

• FCFE Calculation.xlsx, 31 KB

• ▶ Reply

Permalink Reply by Fazil Gadzhiev on May 21, 2009 at 2:18pm

Amrit, could you pls upload a file in Excel 2003?

• ▶ Reply

Permalink Reply by helen on January 25, 2010 at 9:48pm

It's really good unfortunately I couldn't change anything.
Could you upload the excel version?

Thanks

• ▶ Reply

• ‹ Previous
• 1
• 2
• 3
• …
• 6
• Next ›
• Page