Discount rate - 1: Weighted Average Cost of Capital using Excel

Describes how to calculate the weighted average cost of capital for a company, using its equity, debt, and tax rate, using Excel.

[@hinshaq]

Very well explained, thanks for the video!!!

[@shriram2u]

Very well explained. Thank you.

[@tanzinsultana3370]

Thank you

[@PangBoyify]

May i know how to get the total debt?

[@patrickbellefleur5508]

+kah hao Pang I would look at the balance sheet for information on equity and liabilities/(ST debt, LT debt, Notes)

[@aadilexcels3063]

i also need to know

[@amogh4077]

Go on company's annual sheet and search for total liabilities or you can also use screener.in for instant.

[@msayim1]

Exclude the short-term liabilities such as AP, Accruals, Deferred taxes etc..