Appendix A – CANSIM references

Appendix A – CANSIM references
Indicator
CANSIM table/ Series vector ID		 Formula and components used in the derivation
Household sector financial indicators
Table 378-0123
1 Household debt to gross domestic product V62698062 = (V62693968/msum(V62295576))*100 1
V62693968 Households; Total financial liabilities; Market value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
2 Household debt to disposable income V62698063 = (V62693968/msum(V62306027 + V105775423))*100
V62693968 Households; Total financial liabilities; Market value
V62306027 Households; Household disposable income; Unadjusted
V105775423 Households; change in pension entitlements; Unadjusted
3 Household credit market debt to disposable income V62698064 = (V626993985/msum(V62306027 + V105775423))*100
V62693985 Households; Loans; Market value
V62306027 Households; Household disposable income; Unadjusted
V105775423 Households; change in pension entitlements; Unadjusted
4 Household consumer credit and mortgage liabilities to disposable income V62698065 = ((V62693986 + V62693988)/msum(V62306027 + V105775423))*100
V62693986 Households; Consumer credit; Market value
V62693988 Households; Mortgages; Market value
V62306027 Households; Household disposable income; Unadjusted
V105775423 Households; change in pension entitlements; Unadjusted
5 Household net worth as a percentage of disposable income V62698066 = (V62694002/msum(V62306027 + V105775423))*100
V62694002 Households; Net worth; Market value
V62306027 Households; Household disposable income; Unadjusted
V105775423 Households; change in pension entitlements; Unadjusted
6 Household debt to total assets V62698067 = (V62693968/V62693919)*100
V62693968 Households; Total financial liabilities; Market value
V62693919 Households; Total assets; Market value
7 Household debt to net worth V62698068 = (V62693968/V62694002)*100
V62693968 Households; Total financial liabilities; Market value
V62694002 Households; Net worth; Market value
8 Household credit market debt to net worth V62698069 = (V62693985/V62694002)*100
V62693985 Households; Loans; Market value
V62694002 Households; Net worth; Market value
9 Household consumer credit and mortgage liabilities to net worth V62698070 = ((V62693986 + V62693988)/V62694002)*100
V62693986 Households; Consumer credit; Market value
V62693988 Households; Mortgages; Market value
V62694002 Households; Net worth; Market value
10 Household total assets to net worth V62698071 = (V62693919/V62694002)*100
V62693919 Households; Total assets; Market value
V62694002 Households; Net worth; Market value
11 Household financial assets to net worth V62698072 = (V62693932/V62694002)*100
V62693932 Households; Total financial assets; Market value
V62694002 Households; Net worth; Market value
12 Household financial asset to non-financial assets V62698073 = (V62693932/V62693920)*100
V62693932 Households; Total financial assets; Market value
V62693920 Households; Non-financial assets; Market value
13 Household owner's equity as a percentage of real estate V62698074 = ((V62693922 + V62693923 + V62693930 - V62693988)/(V62693922 + V62693923 + V62693930))*100
V62693922 Households; Residential structures; Market value
V62693923 Households; Non-residential structures; Market value
V62693930 Households; Land; Market value
V62693988 Households; Mortgage liabilities; Market value
14 Real estate as a percentage of disposable income V62698075 = ((V62693922 + V62693923 + V62693930)/msum(V62306027+V105775423))*100
V62693922 Households; Residential structures; Market value
V62693923 Households; Non-residential structures; Market value
V62693930 Households; Land; Market value
V62306027 Households; Household disposable income; Unadjusted
V105775423 Households; change in pension entitlements; Unadjusted
Combined household and NPISH sectors financial indicators
Table 378-0123
15 Household and non-profit institutions serving households debt to gross domestic product V62698076 = (V62693863/msum(V62295576))*100
V62693863 Households and non-profit institutions serving households; Total financial liabilities; Market value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
16 Household and non-profit institutions serving households debt to disposable income V62698077 = (V62693863/msum(V62306027 + V62306094))*100
V62693863 Households and non-profit institutions serving households; Total financial liabilities; Market value
V62306027 Households; Household disposable income; Unadjusted
V62306094 Non-profit institutions serving households; Non-profit institutions serving households' disposable income; Unadjusted
17 Household and non-profit institutions serving households credit market debt to disposable income V62698078 = ((V62693880)/msum(V62306027 + V62306094))*100
v62693880 Households and non-profit institutions serving households; Loans; Market value
V62306027 Households; Household disposable income; Unadjusted
V62306094 Non-profit institutions serving households; Non-profit institutions serving households' disposable income; Unadjusted
Corporate sector financial indicators
Table 378-0124
1 Private non-financial corporations' total debt to equity V62698054 = (V62694388/V62694411)*100
V62694388 Non-financial private corporations; Total financial liabilities; Market value
V62694411 Non-financial private corporations; Equity and investment fund shares; Market value
2 Private non-financial corporations' credit market debt to equity (at book value) V62698055 = (V62698018/V62694438)*100
V62698018 Non-financial private corporations; Credit market debt; Book value
V62694438 Non-financial private corporations; Equity and investment fund shares; Book value
Government sector financial indicators
Table 378-0125
1 General government gross debt (at book value) to gross domestic product V62698056 = (V62694788/msum(V62295576))*100
V62694788 General governments; Total financial liabilities; Book value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
2 Federal government gross debt (at book value) to gross domestic product V62698057 = (V62695233/msum(V62295576))*100
V62695233 Federal general government; Total financial liabilities; Book value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
3 Other levels of government gross debt (at book value) to gross domestic product V62698058 = (V62695403/msum(V62295576))*100
V62695403 Other levels of general government; Total financial liabilities; Book value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
4 General government net debt (at book value) to gross domestic product V62698059 = (V62694752/msum(V62295576))*100
V62694752 General governments; Net financial assets; Book value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
5 Federal government net debt (at book value) to gross domestic product V62698060 = (V62695197/msum(V62295576))*100
V62695197 Federal general government; Net financial assets; Book value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
6 Other levels of government net debt (at book value) to gross domestic product V62698061 = (V62695367/msum(V62295576))*100
V62695367 Other levels of general government; Net financial assets; Book value
V62295576 Gross domestic product, income-based, at market prices; Unadjusted
1. Where the msum function represents the four-quarter moving sum of the quarterly series.

 

Date modified: