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
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
- 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.
- 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.
- Add them Indonesia: 3.2973 + 2.46 = 5.7573%. United States: 3.2973 + 0 = 3.2973%.
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 - rfHere 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 States | Indonesia | |
|---|---|---|
| Mature-market premium | 3.2973 | 3.2973 |
| Country default spread | 0.0000 | 1.6200 |
| Volatility ratio | none | 1.5185 |
| Country risk premium | 0.0000 | 2.4600 |
| Total equity risk premium | 3.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 = risk-free rate + beta x total equity risk premiumTake 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:
- Equity risk premium for the United States
- Equity risk premium for the United Kingdom
- Equity risk premium for Germany
- Equity risk premium for Japan
- Equity risk premium for South Korea
- Equity risk premium for China
- Equity risk premium for Taiwan
- Equity risk premium for Saudi Arabia
- Equity risk premium for India
- Equity risk premium for Indonesia
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:
=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:
| country | mature_erp | country_default_spread | volatility_ratio | country_risk_premium | total_erp |
|---|---|---|---|---|---|
| USA | 3.2973 | 0.0000 | 0.0000 | 3.2973 | |
| DEU | 3.2973 | 0.0000 | 2.5507 | 0.0000 | 3.2973 |
| GBR | 3.2973 | 0.5100 | 1.5294 | 0.7800 | 4.0773 |
| JPN | 3.2973 | 0.6000 | 1.5167 | 0.9100 | 4.2073 |
| IDN | 3.2973 | 1.6200 | 1.5185 | 2.4600 | 5.7573 |
| IND | 3.2973 | 1.8700 | 1.5241 | 2.8500 | 6.1473 |
| BRA | 3.2973 | 2.1300 | 1.5211 | 3.2400 | 6.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:
=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
curl https://api.narwhalapi.com/v1/economics/IDN/equity-risk-premium \
-H "Authorization: Bearer $NARWHAL_API_KEY"{
"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 .