excel doing

profilericyru
ICRGSPREADSHEET2017.xlsx

Sheet1

ICRG MODEL (country risk scorecard)
FINANCIAL RISK - 50 pts
Weight Score Data and source
Foreign debt as % of GDP 10
Foreign debt service as % of XGS 10
Current account % XGS 15
Net liquidity as months of import cover 5
Exchange rate stability (appreciation 12 mo) 10
ECONOMIC RISK - 50 pts
Weight Score Data and source
Per capita GDP vs. world pc GDP 5
Real annual GDP growth 10
Annual inflation rate 10
Budget deficit as % of GDP 10
Current account balance as % of GDP 15
POLITICAL RISK - 100 pts
Weight Score Comments - explanation
Government stability (ability to carry on programs and stay in office) 12
Socioeconomic conditions (satisfaction of public with gvt policies) 12
Investment profile - see components 12
risk to operations (0 - 4 pts)
taxation (0 - 4 pts)
repatriation of profits ((0 - 4 pts)
labor costs (0 - 4 pts)
Internal conflict - see components 12
Political violence (sporadic or sustained)
local (1-3 pts)
regional (1-3 pts)
nationwide (1-3 pts)
includes
Terrorism (0 - 1pts)
Kidnapping for ransom (0 or 1 pt)
Civil war ( 0 or 1 pt)
External conflict - risk to investment posed by 12
warfare (0- 4 pts)
border incursions (0 - 2 pts)
geopolitical disputes (0 - 2 pts)
embargoes (0 - 2 pts)
trade restrictions (0 - 2 pts)
Corruption 6
bribes (0 - 2 pts)
nepotism (0 - 2 pts)
excessive tied between business and politics (0 - 2 pts)
Military in politics 6
Religious tensions - see components 6
domination or governance of one religious group (0 - 2 pts)
suppression of religious freedom (0 - 2 pts)
desire of religious group to express their identity separately (0 - 2 pts)
Law and order 6
strength and impartiality of legal system (0 - 3 pts) 3
order - popular obervance of the law (0 - 3 pts) 3
Ethnic tensions - see components 6
racial (0 - 2 pts)
nationality (0 - 2 pts)
language divisions (0 - 2 pts)
Democratic accountability (not necessarily elected - "legitimacy") 6
Bureaucracy (institutional strength - freedom from political pressure) 4
FINANCIAL RISK SCORE 0 SCORE COMPUTES AUTOMATICALLY
ECONOMIC RISK SCORE 0 DO NOT INPUT DATA IN THE HIGHLIGHTED CELLS
POLITICAL RISK SCORE 0
RAW SCORE 0
RISK SCORE 0
RISK CATEGORY
Risk score Risk category
80.0 to 100.0 points Very low risk
70.0 to 79.5 points Low risk
60.0 to 69.5 points Moderate risk
50.0 to 59.5 points High risk
00.0 to 49.5 points Very high risk