Popularized by William Jarvis and Dr. Ian C MacMillan in a series of articles in the Harvard Business Review, the consumer leverage ratio quantifies the average consumer's relative debt burden and disposable income. That is,
Ratio = (Total household debt / Disposable personal income)*100
If debt and income are equal, the ratio will equal 100; values greater than 100 indicate that debt exceeds income.
Using existing historical series in Data Buffet, Moody's Analytics intends to compute this ratio for a range of countries to facilitate comparative analysis. Initial country availability is listed below. Depending on the inputs, the frequency, adjustment, start and end dates of the derived time series will vary (note: baskets can contain mixed frequencies). The unified concept code DM%CHHDPI permits access despite the differences; for example, the ratio for Canada has the mnemonic DM%CHHDPI.ICAN.
Country |
Freq |
Formula |
Source |
|
|
Global concept alias |
|
Various |
|
DM%CHHDPI.? |
Various |
|
|
North America |
|
Canada |
Q |
MB%DPDIAQ.ICAN |
Statistics Canada: CANSIM II, vector V52020747 |
U.S. |
Q |
((ZLA154104005Q.US/ZFA156012005Q.US)*100) |
FRB: Z.1 Flow of Funds Accounts |
|
|
The euro zone and 15 of 17 countries |
|
The euro zone |
A |
EUENA%DIRHNPIUA.IEZ17 |
Eurostat |
Austria |
A |
EUENA%DIRHNPIUA.IAUT |
Eurostat |
Belgium |
A |
EUENA%DIRHNPIUA.IBEL |
Eurostat |
Cyprus |
|
not available |
|
Estonia |
A |
EUENA%DIRHNPIUA.IEST |
Eurostat |
Finland |
A |
EUENA%DIRHNPIUA.IFIN |
Eurostat |
France |
A |
EUENA%DIRHNPIUA.IFRA |
Eurostat |
Germany |
A |
EUENA%DIRHNPIUA.IDEU |
Eurostat |
Ireland |
A |
EUENA%DIRHNPIUA.IIRL |
Eurostat |
Italy |
A |
EUENA%DIRHNPIUA.IITA |
Eurostat |
Luxembourg |
A |
EUENA%DIRHNPIUA.ILUX |
Eurostat |
Netherlands |
A |
EUENA%DIRHNPIUA.INLD |
Eurostat |
Malta |
|
not available |
|
Norway |
A |
EUENA%DIRHNPIUA.INOR |
Eurostat |
Portugal |
A |
EUENA%DIRHNPIUA.IPRT |
Eurostat |
Slovakia |
A |
EUENA%DIRHNPIUA.ISLV |
Eurostat |
Slovenia |
A |
EUENA%DIRHNPIUA.ISVN |
Eurostat |
Spain |
A |
EUENA%DIRHNPIUA.IESP |
Eurostat |
|
|
Non-euro zone EU countries |
|
Czech Republic |
A |
EUENA%DIRHNPIUA.ICZE |
Eurostat |
Denmark |
A |
EUENA%DIRHNPIUA.IDNK |
Eurostat |
Hungary |
A |
EUENA%DIRHNPIUA.IHUN |
Eurostat |
Latvia |
A |
EUENA%DIRHNPIUA.ILVA |
Eurostat |
Lithuania |
A |
EUENA%DIRHNPIUA.ILTU |
Eurostat |
Poland |
A |
EUENA%DIRHNPIUA.IPOL |
Eurostat |
Sweden |
A |
EUENA%DIRHNPIUA.ISWE |
Eurostat |
Switzerland |
A |
EUENA%DIRHNPIUA.ICHE |
Eurostat |
U.K. |
Q |
((ONSNNREQ.IGBR/(ONSRPHQQ.IGBR*4))*100) |
U.K. Office for National Statistics (ONS) |
You can do it too! With Data Buffet formulas (introduced here), you can combine one or more native time series with arithmetic operators to synthesize your own custom measures. Formulas can be used with baskets, charts and maps.
|