{"id":2026100420,"date":"2021-03-03T08:15:16","date_gmt":"2021-03-03T01:15:16","guid":{"rendered":"https:\/\/danieel.id\/?p=2026100420"},"modified":"2026-10-04T10:08:29","modified_gmt":"2026-10-04T03:08:29","slug":"how-to-calculate-cost-of-equity-capm","status":"publish","type":"post","link":"https:\/\/danieel.id\/en\/how-to-calculate-cost-of-equity-capm\/","title":{"rendered":"How to Calculate Cost of Equity with CAPM: A Practical Guide"},"content":{"rendered":"
\n

How do we calculate cost of equity<\/strong> when shareholders\u2019 capital does not carry interest like a bank loan? I usually start with a simple question: what return should investors require for taking on the risk of owning that stock?<\/p>\n

Equity still has a cost: the required return<\/em>, or the return shareholders demand. One way to estimate it is the Capital Asset Pricing Model (CAPM)<\/strong>. This model links returns to systematic risk\u2014the market risk that diversification alone cannot eliminate.<\/p>\n

Disclaimer:<\/strong> all figures for Company X and Company Y in this article are dummy data for learning purposes. They do not represent listed companies or current market conditions. The choice of examples does not constitute advice to buy, sell, or hold shares, or a positive or negative judgment about any company. CAPM results are estimates based on assumptions, not promises of investment gains.<\/p>\n

The formula to calculate cost of equity with CAPM<\/h2>\n
Ke<\/sub> = Rf<\/sub> + \u03b2 \u00d7 [E(Rm<\/sub>) \u2212 Rf<\/sub>]<\/strong><\/div>\n

Ke<\/sub> is the cost of equity; Rf<\/sub> is the risk-free rate; \u03b2 is the stock\u2019s beta; and E(Rm<\/sub>) is the expected market return. The difference E(Rm<\/sub>) \u2212 Rf<\/sub> is the equity risk premium<\/em> (ERP), also called the market risk premium. We can therefore also write the formula as Ke<\/sub> = Rf<\/sub> + \u03b2 \u00d7 ERP.<\/p>\n

When you calculate cost of equity, use a single currency and a consistent time basis. Do not mix an annual Rf<\/sub> with a monthly premium. Beta has no units, but you should record the observation period and the frequency of the data used to estimate it.<\/p>\n

Risk-free rate: choose a consistent benchmark<\/h2>\n

For valuations in Indonesian rupiah, the yield on rupiah-denominated government bonds is often used as an initial proxy. Choose a maturity close to the cash flow horizon. Ten-year bonds are commonly used for long-term valuations, but they are not a rule for every situation. Use the yield to maturity rather than the coupon rate<\/strong>, and specify the valuation date.<\/p>\n

You can check yield curve data at Penilai Harga Efek Indonesia (PHEI)<\/a>. . Record the source, date, currency, and maturity whenever you update the model.<\/p>\n

Government bonds are not automatically free of every risk, either. Their prices can change as interest rates move, and the issuer may still face default risk. In a valuation approach that adjusts for country risk, the risk-free rate can be estimated by subtracting an appropriate sovereign default spread from the government bond yield. Keep this approach consistent with the ERP framework so that country risk is not counted twice. You can find a discussion in Aswath Damodaran\u2019s discount rate materials at NYU Stern<\/a>.<\/p>\n

Beta coefficient: understand the risk it measures<\/h2>\n

Beta measures how sensitive a stock\u2019s return is to market returns. A beta of 1 means its average sensitivity to the market is roughly one-to-one, not that the correlation is perfect. A beta of 0.8 indicates lower sensitivity, while a beta of 1.5 indicates higher sensitivity. A negative beta means less than zero, not merely less than one.<\/p>\n

\"Two
Two boats on the same waves represent different sensitivities to market movements. This is an analogy, not a measure of investment safety.<\/figcaption><\/figure>\n

However, a low beta does not automatically make a stock safe. A company may still face debt, liquidity, governance, or business risks. Beta also does not measure all of a stock\u2019s volatility. Likewise, a high beta does not guarantee high realized returns or success in beating the market.<\/p>\n

A portfolio\u2019s beta is the weighted average of its stocks\u2019 betas, with weights based on the market value of each position:<\/p>\n

\u03b2portfolio<\/sub> = \u03a3(wi<\/sub> \u00d7 \u03b2i<\/sub>), where \u03a3wi<\/sub> = 1<\/strong><\/div>\n

A portfolio beta of around one indicates market sensitivity of around one; it does not automatically mean the portfolio is safe. Read this figure alongside concentration, liquidity, and the risks of each business.<\/p>\n

Calculating beta from paired returns<\/h3>\n
\u03b2 = Cov(Ri<\/sub>, Rm<\/sub>) \u00f7 Var(Rm<\/sub>)<\/strong><\/div>\n

Ri<\/sub> is the stock return, and Rm<\/sub> is the benchmark index return. For a more rigorous CAPM estimate, regress the stock\u2019s excess returns against the market\u2019s excess returns: subtract the risk-free rate for the same period from each return. If the risk-free rate per period is constant, subtracting that constant does not change the slope.<\/p>\n

Use stock and index prices from matching dates. Five years of monthly data can be a starting point, but a longer period is not always better when the business structure changes. To obtain 60 monthly returns, we need 61 price observations. Do not use data after the valuation date to estimate historical beta.<\/p>\n

Price returnt<\/sub> = (Pt<\/sub> \u00f7 Pt\u22121<\/sub>) \u2212 1<\/strong><\/div>\n
Total returnt<\/sub> = (Pt<\/sub> \u2212 Pt\u22121<\/sub> + Dt<\/sub>) \u00f7 Pt\u22121<\/sub><\/strong><\/div>\n

P is the price, and D is the dividend during the period. If the price rises from 1,000 to 1,030 and the dividend is 20, the price return is 3%, while the total return is 5%. Adjust for stock splits and corporate actions. If you use an adjusted close series that already accounts for dividends, do not add the dividends again. Aim to use comparable return measures for the stock and the index.<\/p>\n

A dummy example and Excel formulas<\/h3>\n

The table below uses six fictional monthly return observations to make the calculation easy to check. This is an arithmetic exercise, not an adequate sample size for estimating a real company\u2019s beta.<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n
Dummy period<\/th>\nMarket (column B)<\/th>\nX (column C)<\/th>\nY (column D)<\/th>\n<\/tr>\n<\/thead>\n
M1<\/td>\n\u22124%<\/td>\n\u22122.4%<\/td>\n\u22126.5%<\/td>\n<\/tr>\n
M2<\/td>\n2%<\/td>\n2.4%<\/td>\n2.5%<\/td>\n<\/tr>\n
M3<\/td>\n5%<\/td>\n4.8%<\/td>\n7%<\/td>\n<\/tr>\n
M4<\/td>\n\u22121%<\/td>\n0%<\/td>\n\u22122%<\/td>\n<\/tr>\n
M5<\/td>\n3%<\/td>\n3.2%<\/td>\n4%<\/td>\n<\/tr>\n
M6<\/td>\n\u22123%<\/td>\n\u22121.6%<\/td>\n\u22125%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

If the header is in row 1, calculate X\u2019s beta with =SLOPE(C2:C7,B2:B7)<\/code>, which returns 0.8<\/strong>. For Y, use =SLOPE(D2:D7,B2:B7)<\/code>, which returns 1.5<\/strong>. The first argument contains stock returns; the second contains market returns.<\/p>\n

For X, =COVARIANCE.S(C2:C7,B2:B7)\/VAR.S(B2:B7)<\/code> gives the same beta as SLOPE. The COVARIANCE.P and VAR.P pair also works. Do not mix population covariance with sample variance<\/strong>, because their denominators differ. If the results do not match, check the dates, number of observations, empty cells, and rounding. Replace commas with semicolons if your Excel settings require it; see Microsoft\u2019s SLOPE documentation<\/a>.<\/p>\n

Market return and the market risk premium<\/h2>\n

CAPM requires an expectation of future returns. Historical returns help us develop assumptions, but they do not automatically become expected returns. Also remember that a price index does not include dividends in the way a total return index does.<\/p>\n

Arithmetic average = (R1<\/sub> + \u2026 + Rn<\/sub>) \u00f7 n<\/strong><\/div>\n
Geometric average = [(1 + R1<\/sub>) \u00d7 \u2026 \u00d7 (1 + Rn<\/sub>)]1\/n<\/sup> \u2212 1<\/strong><\/div>\n

The arithmetic average is often used to estimate a single-period return. The geometric average summarizes historical compound growth. For example, a return of +20% followed by \u221220% gives an arithmetic average of 0%, but a geometric average of approximately \u22122.02% per period. The geometric average is therefore not automatically the best input for CAPM.<\/p>\n

In Excel, create a gross return column containing 1 + return, then use =GEOMEAN(range_gross_return)-1<\/code>. Do not apply GEOMEAN directly to raw returns. All factors entered must be positive.<\/p>\n

Annual geometric return = (1 + gmonthly<\/sub>)12<\/sup> \u2212 1<\/strong><\/div>\n

This formula annualizes the monthly geometric result; it does not turn it into a forecast. An alternative way to estimate ERP is the implied premium approach. For updates, read NYU Stern\u2019s country risk premium data and methodology<\/a>. Match the date, market, and risk framework before using the figures. Do not add a country risk premium again if it is already included.<\/p>\n

The Security Market Line and examples for Company X and Company Y<\/h2>\n

Now let\u2019s calculate cost of equity using dummy annual assumptions<\/strong>: Rf<\/sub> = 5% and ERP = 6%, so E(Rm<\/sub>) = 11%. The betas come from the earlier exercise. These figures do not represent the Indonesian market on any particular date.<\/p>\n

Ke,X<\/sub> = 5% + 0.8 \u00d7 6% = 9.8% per year<\/strong><\/div>\n
Ke,Y<\/sub> = 5% + 1.5 \u00d7 6% = 14% per year<\/strong><\/div>\n

The Security Market Line<\/em> (SML) plots beta on the horizontal axis and required return on the vertical axis. In this example, the line starts at 5% when beta is zero, with a slope equal to the ERP of 6%.<\/p>\n

When beta = 1, the cost of equity = 11%, which is the expected market return, not the 6% ERP.<\/strong> With a positive ERP and other assumptions unchanged, a beta greater than one produces a required return above the expected market return. The SML describes a relationship within the model, not a guarantee of returns for every stock on the Indonesia Stock Exchange.<\/p>\n

Try a sensitivity check: if ERP rises to 7%, the result for X becomes 10.6%, and Y becomes 15.5%. Changes in assumptions can materially affect valuation. When you calculate cost of equity for a real company, document the inputs and check several scenarios.<\/p>\n

Applying the result to WACC and wrapping up<\/h2>\n

Cost of equity is a component of WACC, alongside the after-tax cost of debt. For a simple capital structure without preferred stock:<\/p>\n

WACC = [E \u00f7 (D + E)] \u00d7 Ke<\/sub> + [D \u00f7 (D + E)] \u00d7 Kd<\/sub> \u00d7 (1 \u2212 T)<\/strong><\/div>\n

E and D are the market values of equity and debt; Kd<\/sub> is the pre-tax cost of debt; and T is the relevant tax rate. The tax benefit of interest depends on the applicable rules and the company\u2019s ability to use it. We can continue with how to calculate cost of debt<\/a> and read about company financial ratios<\/a> to understand the business\u2019s financial condition.<\/p>\n

For me, the value of learning to calculate cost of equity is that it makes risk assumptions clear and testable. Choose consistent benchmarks, estimate beta using well-organized data, and distinguish historical returns from expectations. Use the result as an analytical tool, then check actual data and the nature of the business before drawing investment conclusions.<\/p>\n

Sources<\/h2>\n

To learn about benchmark indices, see the Indonesia Stock Exchange\u2019s information on stock indices<\/a>. The IHSG, or Jakarta Composite Index, is a proxy for the domestic market, not the entire theoretical market portfolio in CAPM. You can also use vendor data, but check definitions, price adjustments, access permissions, and the beta methodology. Download options may change.<\/p>\n