Calculate the equity risk premium

A country's equity risk premium is the mature-market premium plus a country risk premium. The country risk premium is the country's default spread times a volatility ratio. On 1 November 2026 that gives 3.30% for the United States and 5.76% for Indonesia. New here? Create a free account and you get a Sheets key and starting credit to try this.

The formula

Equity risk premium
total equity risk premium = mature-market premium + country risk premium
country risk premium      = country default spread x volatility ratio
  • Mature-market premium: The extra return investors expect from shares in a mature market (the United States) over its 10-year government bond.
  • Country default spread: The extra yield a country pays over a mature-market government bond because it might default.
  • Volatility ratio: How much more shares move than government bonds. Shares carry more risk than bonds, so the default spread is scaled up by this number.

Calculate it by hand

  1. Find the mature-market premium Add up the cash listed companies paid investors in a year, dividends plus share buybacks, and divide by their market value. Let that cash grow at its past rate for five years, then at the risk-free rate for ever. The return at which all that future cash is worth today's market value, minus the risk-free rate, is the premium. In a sheet, Goal Seek finds that return.
  2. Find the country risk premium Multiply the country's default spread by the volatility ratio. For Indonesia that is 1.62 x 1.5185 = 2.46. The United States is the mature market, so its country risk premium is 0.
  3. Add them Indonesia: 3.2973 + 2.46 = 5.7573%. United States: 3.2973 + 0 = 3.2973%.
Mature-market premium
1 = sum for t = 1..5 of y(1+g)^t / (1+r)^t  +  [ y(1+g)^5 (1+rf) / (r - rf) ] / (1+r)^5
mature-market premium = r - rf

Here y is the cash paid out as a share of market value, g the growth rate, rf the risk-free rate and r the return you solve for. The method page lists every input.

Worked example: 1 November 2026

United StatesIndonesia
Mature-market premium3.29733.2973
Country default spread0.00001.6200
Volatility rationone1.5185
Country risk premium0.00002.4600
Total equity risk premium3.2973%5.7573%

See the live figure for the United States, for Indonesia or for every country.

Use it in a cost of equity

Cost of equity
cost of equity = risk-free rate + beta x total equity risk premium

Take an Indonesian company with a beta of 1.1 and a risk-free rate of 4.5%, both chosen for this example. Its cost of equity is 4.5 + 1.1 x 5.7573 = 10.83%.

Country guides

The same calculation with each country's own figures:

Get it in Google Sheets

The steps above need company filings, bond yields and a spread for every country. Narwhal does that work each month and publishes the result for 175 countries. Paste this into an empty cell:

All countries
=IMPORTDATA("https://api.narwhalapi.com/v1/economics/equity-risk-premium?format=csv&key=YOUR_SHEETS_KEY")

You get one row per country. Rows from 16 November 2026:

countrymature_erpcountry_default_spreadvolatility_ratiocountry_risk_premiumtotal_erp
USA3.29730.00000.00003.2973
DEU3.29730.00002.55070.00003.2973
GBR3.29730.51001.52940.78004.0773
JPN3.29730.60001.51670.91004.2073
IDN3.29731.62001.51852.46005.7573
IND3.29731.87001.52412.85006.1473
BRA3.29732.13001.52113.24006.5373

To use one country's figure in a model, look it up by code so a new row cannot shift it. With the table on a tab named ERP:

One country
=VLOOKUP("IDN", ERP!A:H, 8, FALSE)

You need a Sheets key from your dashboard; Use Narwhal in Google Sheets shows the set-up. The link costs its normal price once a day, however often Google refreshes it. For one country only, use /v1/economics/IDN/equity-risk-premium in the same formula.

Get it with the API

Request
curl https://api.narwhalapi.com/v1/economics/IDN/equity-risk-premium \
  -H "Authorization: Bearer $NARWHAL_API_KEY"
Response
{
  "country": "IDN",
  "as_of": "2026-11-01",
  "unit": "percent",
  "mature_erp": "3.2973",
  "country_default_spread": "1.6200",
  "volatility_ratio": "1.5185",
  "country_risk_premium": "2.4600",
  "total_erp": "5.7573",
  "basis": {
    "mature_erp": "observed",
    "country_default_spread": "table",
    "volatility_ratio": "table",
    "country_risk_premium": "table",
    "total_erp": "table"
  },
  "methodology_url": "https://narwhalapi.com/methodology/equity-risk-premium"
}

Where do the numbers come from?

The mature-market premium is our own calculation from public company filings, the US Treasury 10-year yield and market prices. For euro-area countries the default spread is the gap between the country's 10-year bond yield and Germany's. For other countries the spread and the country risk premium come from the public country risk table of Aswath Damodaran (NYU Stern), and the basis fields mark them table.

What does basis mean?

Each figure is marked observed (read from markets or filings), modelled or table (taken from the public table).

Why is Germany's total the same as the United States?

Germany is the reference for euro-area spreads, so its spread is 0 and its country risk premium is 0.

How often does it change?

Once a month. The mature-market premium is recalculated each month, and the country figures follow straight after.

Published .

Next steps