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: