historical informaon, an analyst esmated the dividend growth rate of XYZ Co. to
be 2%. What is the cost of equity?
D1 $0.50
P0 $5 g
2%
Re = $0.50/$5 2%
Re 12%
The cost of equity for XYZ Co. is 12%.
Cost of Equity Example in Excel (CAPM Approach)
Step 1 Find the RFR (risk-free rate) of the market
Step 2 Compute or locate the beta of each company
Step 3 Calculate the ERP Equity Risk Premium)
ERP E Rm) Rf
lOMoARcPSD| 58562220
The company with the highest beta sees the highest cost of equity and vice versa.
It makes sense because investors must be compensated with a higher return for
the risk of more volality (a higher beta).
Download the Free Template
Enter your name and email in the form below and download
the free template now!

Preview text:


historical information, an analyst estimated the dividend growth rate of XYZ Co. to
be 2%. What is the cost of equity? D1 $0.50 P0 $5 g 2% Re = $0.50/$5 2%
The company with the highest beta sees the highest cost of equity and vice versa. Re 12%
It makes sense because investors must be compensated with a higher return for
the risk of more volatility (a higher beta).
The cost of equity for XYZ Co. is 12%.
Download the Free Template
Cost of Equity Example in Excel (CAPM Approach)
Step 1 Find the RFR (risk-free rate) of the market
Step 2 Compute or locate the beta of each company
Step 3 Calculate the ERP Equity Risk Premium) ERP E Rm) Rf lOMoAR cPSD| 58562220
Enter your name and email in the form below and download the free template now!