Spreadsheet estimation of bequests Miguel Snchez-Romero Max Planck - PowerPoint PPT Presentation

Max Planck Institute for Demographic Research Spreadsheet estimation of bequests Miguel Sánchez-Romero †† † Max Planck Institute for Demographic Research (MPIDR) † Project financed by University of California, Berkeley

Outline Outline Overview Issues Method Data How to use the Spreadsheet Extensions () June 6h 2013 Global NTA Conference, Barcelona 2 / 20

Overview Overview ◮ Using data of 17 countries, Mason et al. (2011) found that asset income of working-age adults is much greater than can be attributed to their observed saving. They rely on bequests and asset transfers. () June 6h 2013 Global NTA Conference, Barcelona 3 / 20

Issues Issues ◮ Lack of available datasets to estimate assets transferred at death ◮ The law of inheritance differs by country () June 6h 2013 Global NTA Conference, Barcelona 4 / 20

Method Representative household reconstruction () June 6h 2013 Global NTA Conference, Barcelona 5 / 20

Method Data - UN demographic data 1950-2010 (fertility, mortality, and population) Assumptions - Individuals are paired at age 12 with people of the same cohort - Exit from marriage only occurs because of death - Children have two representative parents - Bequest is given either to children, or spouse, or both. () June 6h 2013 Global NTA Conference, Barcelona 6 / 20

Method Method caveats Sources of estimation biases - Limited demographic information (don’t use this method before 1990 with UN data!) - High correlation between inter-vivos transfers and mortality - High proportion of bequests given to individuals other than children and spouses - Significant age disparity between spouses - Annuitized wealth - Polygamy - Heterogeneous households and inequality(?) () June 6h 2013 Global NTA Conference, Barcelona 7 / 20

Method Bequest: Part I/II ... Bequest given at age x depends on p t ( x ) p t ( x ) 2 p t ( x ) q t ( x ) ◮ Age p t ( x ) ◮ Partnership status {married, widow/er} q t ( x ) q t ( x ) ◮ Number of eligible offspring q t ( x ) ◮ Assets holding ◮ Inheritance law Figure: Expected bequest given, by partnership status and age () June 6h 2013 Global NTA Conference, Barcelona 8 / 20

� ✁ ✂ ✄ Method Bequest: Part II/II ... f t ( x + α ) Bequest received at age x depends on ◮ Age of the expected parent f t ( x + α + 1) ◮ Status of the parent {married, widow/er} f t ( x + α + 2) ◮ Assets held by parent(s) ◮ Own marriage status ◮ Assets held by spouse f t ( x + β ) ◮ Inheritance law Figure: Expected bequest received from parent(s), by age () June 6h 2013 Global NTA Conference, Barcelona 9 / 20

Data Data I/II 0.10 First parent Cases = 216 Both parents Exposures = 3946 Second parent 0.08 Spouse Total (sum) Hazard rate JSTAR raw data 0.06 JSTAR smoothed 0.04 0.02 0 20 40 60 80 100 120 Age Figure: Inheritance hazard rate, year 2009 () June 6h 2013 Global NTA Conference, Barcelona 10 / 20

Data Data II/II 0.3 Bequest motive I Cases = 216 Bequest motive II Exposures = 3946 Bequest motive III Relative to labor income JSTAR raw data JSTAR smoothed 0.2 ages 30−50 0.1 0 20 40 60 80 100 120 Age Figure: Average bequest received, year 2009 () June 6h 2013 Global NTA Conference, Barcelona 11 / 20

How to use the Spreadsheet How to start using the Bequests template v2: I/II Starting ⋆ Go to the NTA wiki and download the Bequest package in http://www.ntaccounts.org/web/nta/show/Bequests%20and%20other%20capital%20transfers ⋆ Follow the steps contained in Bequest template v2 , worksheet READ ME () June 6h 2013 Global NTA Conference, Barcelona 12 / 20

How to use the Spreadsheet How to start using the Bequests template v2: I/II Key variables ⋆ Choose the proportion of inheritance given to children (according to country’s inheritance law, or survey data) ⋆ Choose the appropriate interest rate ( r ) Asset holdings x = Priv. asset income x r - Rule of thumb (closed-economy) Total labor income α r ⋆ ≈ Total asset holdings − 0 . 05 1 − α where 1 − α is equal to Compensation of Employees to Value Added ratio. - Assume a constant capital-to-labor income ratio () June 6h 2013 Global NTA Conference, Barcelona 13 / 20

How to use the Spreadsheet Interface Figure: Bequests template (Summary worksheet) () June 6h 2013 Global NTA Conference, Barcelona 14 / 20

How to use the Spreadsheet Bequest profile Figure: Proportion of inheritance given to children, α = 0 % () June 6h 2013 Global NTA Conference, Barcelona 15 / 20

How to use the Spreadsheet Bequest profile Figure: Proportion of inheritance given to children, α = 50 % () June 6h 2013 Global NTA Conference, Barcelona 16 / 20

How to use the Spreadsheet Bequest profile Figure: Proportion of inheritance given to children, α = 100 % () June 6h 2013 Global NTA Conference, Barcelona 17 / 20

How to use the Spreadsheet How to save the results Macro “ Save bequest profiles ” ⋆ Clicking on the macro, all the information is saved in SavedProfiles v2.xlsx Legend - BIP1 per capita bequest inflow from the death of the first parent - BIP12 per capita bequest inflow from the simultaneous death of both parents - BIP2 per capita bequest inflow from the death of the second parent - BIPS per capita bequest inflow from the death of the spouse - BI total per capita bequest inflow - BO per capita bequest outflow - BWx per capita bequest wealth () June 6h 2013 Global NTA Conference, Barcelona 18 / 20

Extensions Extensions How to introduce your own demographic information Step 1. Paste ASFR in worksheet fx Step 2. Paste ASMR, qx, Lx, px, and the population distribution in worksheet Data Step 3. Paste asset income, asset holdings, and labor income data in worksheet “ a t ( x ) ” Please, maintain the format and the age range as in the original version Step 4. Go to worksheet Summary and change the Database information ( Cells D7:E9 ) Step 5. Run Macros “Generate population” and “Generate bequest profile” () June 6h 2013 Global NTA Conference, Barcelona 19 / 20

Extensions Thank you for your attention () June 6h 2013 Global NTA Conference, Barcelona 20 / 20