WACC-Weighted Average Cost of Capital
Copyright 2013 ACBA - All Rights Reserved
Fill in all cells even if the company has no debt

XL    Name Date     WACC
InputInputWeightOutput
D/(D+PS+CE) % Tax Rate % Debt % (KDAT) %
PS/(D+PS+CE) % Cost of Preferred % Pref % (KPS) %
Cost of Debt % Equity Premium % % Equity % (KDEP) %
Dividend Yield % Growth Rate % % Equity % (DDM) %
Risk-free Rate % % Equity % (CAPM) %
Beta Market Return % Equity before adj %
Firm specific risk % Size premium % Cost of Equity %

#1 Factors affecting Firm Specific Risk (Up to 6%)
   Key customer dependancy      Key personel dependancy      Key supplier dependancy  
   Potential lawsuits    Potential regulatory changes      Potential new competition  
   #2 Size Premium up to 4% for firms of less than $2 billion in Capital   

Unlev Beta Debt Equity Tax % Lev Beta
x ( 1 + ( ( $ / $ ) x ( 1 - % ) ) =
Lev Beta Debt Equity Tax % Unlev Beta
/ ( 1 + ( ( $ / $ ) x ( 1 - % ) ) =


Enter Inputs in the YELLOW boxes