DDI_PAK_1992_HIES_v01_M_WB World Bank, Development Economics Data Group 2011-05-25 NADA Version 1.0 (August 2013) Household Income and Expenditure Survey 1992 HIES 1992 PAK_1992_HIES_v01_M Federal Bureau of Statistics NADA Federal Bureau of Statistics Microdata Library Income/Expenditure/Household Survey [hh/ies] Pakistan National Sample survey data [ssd] Face-to-face [f2f] It will be ensured that the statistics supplied will not disclose in any way the identity and state of affairs of any individual, firm or institution in strict compliance of the General Statistics Act, 1975. Federal Bureau of Statistics Use of the dataset must be acknowledged using a citation which would include: - the Identification of the Primary Investigator - the title of the survey (including country, acronym and year of implementation) - the survey reference number - the source and date of download a. The user shall provide an undertaking that the data collected from PBS will not be supplied to any other person/organization either free of cost or on payment. b. The user shall acknowledge the source of data and supply copies of the research work/articles (published/unpublished) to PBS. The user of the data acknowledges that the original collector of the data, the authorized distributor of the data, and the relevant funding agency bear no responsibility for use of the data or for interpretations or inferences based upon such uses. sec-1 Coding schemes for province and regions (Urban /Rural) 14594 11 sec-2 Household composition and demographic information including education (formal and technical) and nature of work and industry where members of the household work 95221 44 sec-3-food Household consumption information on food 434752 9 sec-3-mnd Household consumption information on other monthly non-durable consumption items 180116 9 sec-3-yd Household consumption information on yearly durable consumption items 30908 9 sec-3-ynd Household consumption information on yearly non-durable consumption items 303117 9 sec-4.1 Selected durable items resold by household 14593 61 sec-4 Information on durable consumption items owned by members of the household 14593 61 sec-5 Information on the social security paid and received by the members of the household 14593 13 sec-6 Property and land owned by the members of the household and income received on the property and land and financial assets 14593 31 sec-7 Information regarding currency, deposits, stocks, shares and gold owned by the members of the household / Financial assets and liabilities 14593 127 weights 14593 2 HOUSEHOLD ID CODE HOUSEHOLD ID CODE HOUSEHOLD ID CODE HOUSEHOLD ID CODE HOUSEHOLD ID CODE 14594 110100301 420404616 214545153.203 104672298.632 PROVINCE PROVINCE PROVINCE PROVINCE PROVINCE 14594 1 PUNJAB 2 SINDH 3 N.W.F.P. 4 BALOCHIS URBAN OR RURAL URBAN OR RURAL URBAN OR RURAL URBAN OR RURAL URBAN OR RURAL 14594 1 URBAN 2 RURAL 14594 1201 ISLAMABA 1202 ATTOCK 1203 RAWALPIN 1204 JEHLUM 1205 CHAKWAL 1206 SARGODHA 1207 KHUSHAB 1208 MIANWALI 1209 BHAKKAR 1210 FAISALAB 1211 T.T.SING 1212 JHANG 1213 GUJRANWA 1214 GUJRAT 1215 SIALKOT 1216 LAHORE 1217 KASURE 1218 SHEIKHPU 1219 OKARA 1220 VEHARI 1221 SAHIWAL 1222 MULTAN 1223 KHANEWAL 1224 D.G.KHAN 1225 RAJANPUR 1226 MUZAFFAR 1227 LAYYAHA 1228 BAHAWALP 1229 BAHAWAL 1230 R.Y.KHAN 2201 KHAIRPUR 2202 SUKKUR 2203 NAWAB SH 2204 JACOBABA 2205 SHIKARPU 2206 LARKANA 2207 DADU 2208 HYDERABA 2209 BADIN 2210 SANGHAR 2211 THARPARK 2212 THATTA 2213 KARACHI 3101 MALAKAND 3105 HAZARA 3201 SWAT 3202 DIR 3203 MARDAN 3204 PESHAWAR 3205 KOHAT 3206 KARAK 3207 BANNU 3208 D.I.KHAN 3209 MANSEHRA 3210 ABBOTABA 4201 QUETTA 4202 SIBI 4203 KALAT 4204 MAKRAN PRIMARY SAMPLING UNIT PRIMARY SAMPLING UNIT PRIMARY SAMPLING UNIT PRIMARY SAMPLING UNIT PRIMARY SAMPLING UNIT 14594 1101003 4204046 2145451.456 1046722.986 SERIAL NUMBER SERIAL NUMBER SERIAL NUMBER SERIAL NUMBER SERIAL NUMBER 14594 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 QUARTER OF INTERVIEW QUARTER OF INTERVIEW QUARTER OF INTERVIEW QUARTER OF INTERVIEW QUARTER OF INTERVIEW 14594 1 1st' 2 2nd 3 3rd 4 4th RESPONDENT SEX RESPONDENT SEX RESPONDENT SEX RESPONDENT SEX RESPONDENT SEX 14594 1 MALE 2 FEMALE RELATIONSHIP WITH HEAD RELATIONSHIP WITH HEAD RELATIONSHIP WITH HEAD RELATIONSHIP WITH HEAD RELATIONSHIP WITH HEAD 14594 1 HEAD HIM 2 OTHER ME 9 OTHERS Household Size Household Size Household Size Household Size Household Size 14594 1 30 6.525 3.178 Agri\Non-Agri Agri\Non-Agri Agri\Non-Agri Agri\Non-Agri Agri\Non-Agri 14594 1 2 Household ID code Household ID code Household ID code Household ID code Household ID code 95221 110100301 420404616 215738477.684 104353025.341 Province Province Province Province Province 95221 1 PUNJAB 2 SINDH 3 N.W.F.P. 4 BALOCHIS Urban or Rural Urban or Rural Urban or Rural Urban or Rural Urban or Rural 95221 1 URBAN 2 RURAL Primary Sampling Unit Primary Sampling Unit Primary Sampling Unit Primary Sampling Unit Primary Sampling Unit 95221 1101003 4204046 2157384.701 1043530.253 Household Serial Number Household Serial Number Household Serial Number Household Serial Number Household Serial Number 95221 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Relation to the head of the hou Relation to the head of the hou Relation to the head of the hou Relation to the head of the hou Relation to the head of the hou 95221 1 Head him 2 Spouse 3 Son/Daug 4 Son/Daug 5 Father/M 6 Brother/ 7 Other re 8 Servant 9 Non-Rela Residential status Residential status Residential status Residential status Residential status 95221 1 Present 2 Temporar Sex of the member of the househ Sex of the member of the househ Sex of the member of the househ Sex of the member of the househ Sex of the member of the househ 95221 1 Male 2 Female Age Age Age Age Age 95221 99 21.634 18.371 Marital status Marital status Marital status Marital status Marital status 95221 1 Never ma 2 Currentl 3 Widow/Wi 4 Divorced Literacy Literacy Literacy Literacy Literacy 95221 1 Yes 2 No Formal education Formal education Formal education Formal education Formal education 95221 1 No forma 2 Kg-Nurse 3 Primary 4 Middle 5 Matric 6 Intermed 7 B.A, B.S 8 M. A., M 9 M.B.B.S. 10 M. Phil. Vocational or technical educati Vocational or technical educati Vocational or technical educati Vocational or technical educati Vocational or technical educati 95221 1 No forma 2 1 to 3 m 3 4 to 6 m 4 7 to 9 m 5 10 to 12 6 1 to les 7 2 to les 8 3 to les 9 4 years Has got on the job training Has got on the job training Has got on the job training Has got on the job training Has got on the job training 95221 1 Yes 2 No Skill level Skill level Skill level Skill level Skill level 95221 98 1.849 12.302 Did work during last month Did work during last month Did work during last month Did work during last month Did work during last month 95221 1 Yes 2 No How many days worked How many days worked How many days worked How many days worked How many days worked 95221 33 6.602 11.611 If not work did have a job If not work did have a job If not work did have a job If not work did have a job If not work did have a job 95221 1 Yes 2 No, but 3 No, not Main occupation in first job Main occupation in first job Main occupation in first job Main occupation in first job Main occupation in first job 95221 999 156.033 291 Nature of work in first job Nature of work in first job Nature of work in first job Nature of work in first job Nature of work in first job 95221 99300 184.267 3104.868 Type of enterprise of the first Type of enterprise of the first Type of enterprise of the first Type of enterprise of the first Type of enterprise of the first 95221 1 Form 2 Non-Fina 3 Non-Fina 4 Financia 5 Governme 6 Househol 7 Non prof Employment status in first job Employment status in first job Employment status in first job Employment status in first job Employment status in first job 95221 1 Employer 2 Employer 3 Own acco 4 Paid emp 5 Unpaid f 6 Others Can report income in first job Can report income in first job Can report income in first job Can report income in first job Can report income in first job 95221 1 Monthly 2 Annual Yearly income in first job Yearly income in first job Yearly income in first job Yearly income in first job Yearly income in first job 95221 920000 4621.075 16940.391 Monthly income in first job Monthly income in first job Monthly income in first job Monthly income in first job Monthly income in first job 95221 600000 311.809 2447.613 Number of months worked in firs Number of months worked in firs Number of months worked in firs Number of months worked in firs Number of months worked in firs 95221 1 2 3 4 5 6 7 8 9 10 11 12 Did work in a second job Did work in a second job Did work in a second job Did work in a second job Did work in a second job 95221 1 Yes 2 No Number of days worked in second Number of days worked in second Number of days worked in second Number of days worked in second Number of days worked in second 95221 30 0.194 2.101 Did have additional job if did Did have additional job if did Did have additional job if did Did have additional job if did Did have additional job if did 95221 1 Yes 2 No Description of occupation in se Description of occupation in se Description of occupation in se Description of occupation in se Description of occupation in se 95221 990 6.526 68.183 Nature of work in second job Nature of work in second job Nature of work in second job Nature of work in second job Nature of work in second job 95221 93000 19.968 991.597 Type of enterprise in second jo Type of enterprise in second jo Type of enterprise in second jo Type of enterprise in second jo Type of enterprise in second jo 95221 1 Form 2 Non-Fina 3 Non-Fina 4 Financia 5 Governme 6 Househol 7 Non prof Employment status in second job Employment status in second job Employment status in second job Employment status in second job Employment status in second job 95221 1 Employer 2 Employer 3 Own acco 4 Paid emp 5 Unpaid f 6 Others Can report income by second job Can report income by second job Can report income by second job Can report income by second job Can report income by second job 95221 1 Monthly 2 Annual Yearly income by second job Yearly income by second job Yearly income by second job Yearly income by second job Yearly income by second job 95221 252000 79.598 1614.694 Monthly income by second job Monthly income by second job Monthly income by second job Monthly income by second job Monthly income by second job 95221 21000 5.667 150.962 Number of days worked in second Number of days worked in second Number of days worked in second Number of days worked in second Number of days worked in second 95221 9012 2.826 54.675 Did work in another job Did work in another job Did work in another job Did work in another job Did work in another job 95221 1 Yes 2 No How much cash was earned by oth How much cash was earned by oth How much cash was earned by oth How much cash was earned by oth How much cash was earned by oth 95221 200000 66.309 1946.088 Did receive any pension or soci Did receive any pension or soci Did receive any pension or soci Did receive any pension or soci Did receive any pension or soci 95221 1 Yes 2 No How much received by pension How much received by pension How much received by pension How much received by pension How much received by pension 95221 2000001 20982.466 203197.462 How much received by social sec How much received by social sec How much received by social sec How much received by social sec How much received by social sec 95221 300000 40.554 3202.686 Was income used to pay expenses Was income used to pay expenses Was income used to pay expenses Was income used to pay expenses Was income used to pay expenses 95221 1 Yes 2 No 3 No incom Individual identifier Individual identifier Individual identifier Individual identifier Individual identifier 95221 1 30 4.536 3.092 434752 110100301 420404616 205936770.508 100708651.374 434752 1 2 3 4 434752 1 2 434752 1101003 4204046 2059367.63 1007086.513 434752 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 commodity code commodity code commodity code commodity code commodity code 434752 3001 3227 3105.826 59.699 field code field code field code field code field code 434752 1 Paid and 2 In-Kind 3 Own prod 4 Received quantity consumed quantity consumed quantity consumed quantity consumed quantity consumed 434752 9500 109.841 334.063 value of expenditure value of expenditure value of expenditure value of expenditure value of expenditure 434752 3600 58.796 106.98 180116 110100301 420404616 206014002.261 99534386.138 180116 1 2 3 4 180116 1 2 180116 1101003 4204046 2060139.947 995343.861 180116 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 commodity code commodity code commodity code commodity code commodity code 180116 3231 3305 3261.295 22.859 field code field code field code field code field code 180116 1 Paid and 2 In-Kind 3 Own prod 4 Received quantity consumed quantity consumed quantity consumed quantity consumed quantity consumed 180116 3000 12.039 50.21 value of expenditure value of expenditure value of expenditure value of expenditure value of expenditure 180116 50000 52.483 184.648 30908 110100301 420404615 205219231.337 95388342.45 30908 1 2 3 4 30908 1 2 30908 1101003 4204046 2052192.239 953883.424 30908 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 commodity code commodity code commodity code commodity code commodity code 30908 3491 3644 3538.805 36.397 field code field code field code field code field code 30908 1 Paid and 2 In-Kind 3 Own prod 4 Received quantity consumed quantity consumed quantity consumed quantity consumed quantity consumed 30908 1 2 3 4 5 8.16 value of expenditure value of expenditure value of expenditure value of expenditure value of expenditure 30908 350000 534.148 3088.024 303117 110100301 420404616 204922334.386 98910195.592 303117 1 2 3 4 303117 1 2 303117 1101003 4204046 2049223.269 989101.955 303117 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 commodity code commodity code commodity code commodity code commodity code 303117 3321 3484 3378.341 49.363 field code field code field code field code field code 303117 1 Paid and 2 In-Kind 3 Own prod 4 Received quantity consumed quantity consumed quantity consumed quantity consumed quantity consumed 303117 26 0.000125 0.049 value of expenditure value of expenditure value of expenditure value of expenditure value of expenditure 303117 525000 709.204 3590.446 14593 110100301 420404616 214531053.336 104662024.47 14593 5011 203.712 888.519 14593 135000 66.621 1832.429 14593 5009 29.128 343.907 14593 16500 2.272 141.604 14593 4082 10.061 202.33 14593 600 0.228 7.827 14593 5019 4.818 141.285 14593 12001 0.966 99.632 14593 4082 0.839 58.514 14593 1000 0.11 9.068 14593 4082 0.559 47.786 14593 1200 0.103 10.239 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 100 0.00685 0.828 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 5011 14.868 246.393 14593 20000 3.541 203.239 14593 4082 1.119 67.554 14593 150 0.0212 1.537 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 14593 110100301 420404616 214531053.336 104662024.47 14593 4041 3503.786 1330.559 14593 81 1.171 1.761 14593 4038 820.756 1618.931 14593 40 0.286 0.827 14593 4039 676.845 1503.954 14593 1 2 3 4 5 6 7 8 9 10 11 12 14 14593 4035 535.992 1366.797 14593 40 0.164 0.64 14593 4039 407.199 1213.419 14593 40 0.123 0.629 14593 4036 307.231 1068.727 14593 40 0.0908 0.501 14593 4036 230.874 935.946 14593 40 0.0704 0.485 14593 4038 173.045 816.728 14593 40 0.0511 0.413 14593 4036 131.44 715.701 14593 1 2 3 4 14593 4035 94.723 610.561 14593 1 2 3 4 10 14593 4038 56.563 473.913 14593 21 0.0167 0.22 14593 4035 41.425 406.495 14593 1 2 3 4 5 14593 4038 30.936 351.78 14593 21 0.00966 0.2 14593 4039 22.376 299.521 14593 1 2 3 14593 4036 16.024 253.67 14593 1 2 3 14593 4038 11.05 210.779 14593 1 2 3 4 14593 4039 8.567 185.679 14593 1 2 3 14593 4039 5.804 152.891 14593 1 2 14593 5003 90.627 596.81 14593 1 2 3 4 10 20 14593 4038 20.389 285.6 14593 1 2 3 14593 4039 15.717 250.998 14593 1 2 3 5 14593 4036 9.651 196.838 14593 1 2 3 14593 4038 7.45 173.043 14593 1 2 4 14593 4039 6.903 166.642 14593 1 2 14 14593 4039 4.973 141.523 14593 1 2 3 14593 4039 3.317 115.64 14593 1 2 14593 4036 1.658 81.773 14593 1 14593 4037 1.106 66.805 14593 1 14593 14593 14593 14593 Household ID code Household ID code Household ID code Household ID code Household ID code 14593 110100301 420404616 214531053.336 104662024.47 Income from border or lodger Income from border or lodger Income from border or lodger Income from border or lodger Income from border or lodger 14593 200000 77.158 2247.124 Income from zakat or usher Income from zakat or usher Income from zakat or usher Income from zakat or usher Income from zakat or usher 14593 48000 58.537 889.338 Remittances received from withi Remittances received from withi Remittances received from withi Remittances received from withi Remittances received from withi 14593 372000 1561.754 7248.68 Remittances received from outsi Remittances received from outsi Remittances received from outsi Remittances received from outsi Remittances received from outsi 14593 480000 1395.762 11414.37 Receipts from insurance claims Receipts from insurance claims Receipts from insurance claims Receipts from insurance claims Receipts from insurance claims 14593 65000 29.089 1158.593 Gift or assistance Gift or assistance Gift or assistance Gift or assistance Gift or assistance 14593 89000 159.705 1948.823 Total income received from zaka Total income received from zaka Total income received from zaka Total income received from zaka Total income received from zaka 14593 480000 3280.428 13881.127 Nazrana, Zakat paid Nazrana, Zakat paid Nazrana, Zakat paid Nazrana, Zakat paid Nazrana, Zakat paid 14593 25000 226.054 802.333 Remittances paid within Pakista Remittances paid within Pakista Remittances paid within Pakista Remittances paid within Pakista Remittances paid within Pakista 14593 125000 195.946 2312.861 Remittances paid outside Pakist Remittances paid outside Pakist Remittances paid outside Pakist Remittances paid outside Pakist Remittances paid outside Pakist 14593 25000 5.818 283.196 Gift assistance paid Gift assistance paid Gift assistance paid Gift assistance paid Gift assistance paid 14593 15000 12.895 238.518 Total amount paid Total amount paid Total amount paid Total amount paid Total amount paid 14593 125000 460.771 2764.195 Household ID code Household ID code Household ID code Household ID code Household ID code 14593 110100301 420404616 214531053.336 104662024.47 Is building owned Is building owned Is building owned Is building owned Is building owned 14593 1 2 Is land owned Is land owned Is land owned Is land owned Is land owned 14593 1 2 3 Present value building-1 Present value building-1 Present value building-1 Present value building-1 Present value building-1 14593 10000000 113779.69 308001.933 Present value building-2 Present value building-2 Present value building-2 Present value building-2 Present value building-2 14593 20000000 3467.896 170732.673 Present value building-3 Present value building-3 Present value building-3 Present value building-3 Present value building-3 14593 1800000 161.721 15047.481 Present value building-4 Present value building-4 Present value building-4 Present value building-4 Present value building-4 14593 60000 4.797 503.528 Present value land-1 Present value land-1 Present value land-1 Present value land-1 Present value land-1 14593 20000000 47704.219 362229.815 Present value land-2 Present value land-2 Present value land-2 Present value land-2 Present value land-2 14593 7500000 1516.481 73277.459 Present value land-3 Present value land-3 Present value land-3 Present value land-3 Present value land-3 14593 805000 161.721 8541.005 Present value land-4 Present value land-4 Present value land-4 Present value land-4 Present value land-4 14593 Present value land-5 Present value land-5 Present value land-5 Present value land-5 Present value land-5 14593 1 Total property value Total property value Total property value Total property value Total property value 14593 13700000 162682.566 458017.325 Rent received on building Rent received on building Rent received on building Rent received on building Rent received on building 14593 216000 292.098 3778.038 Rent received on land Rent received on land Rent received on land Rent received on land Rent received on land 14593 2000000 2132.604 47592.243 Total value of rent Total value of rent Total value of rent Total value of rent Total value of rent 14593 380000 1328.286 9551.747 Value of building sold Value of building sold Value of building sold Value of building sold Value of building sold 14593 215000 129.747 3583.857 Value of land sold Value of land sold Value of land sold Value of land sold Value of land sold 14593 680000 318.549 9895.112 Total value of property sold Total value of property sold Total value of property sold Total value of property sold Total value of property sold 14593 680000 458.575 10759.557 Building purchased Building purchased Building purchased Building purchased Building purchased 14593 600000 137.566 5806.036 Land purchased Land purchased Land purchased Land purchased Land purchased 14593 560000 107.188 5328.085 Total value of property purchas Total value of property purchas Total value of property purchas Total value of property purchas Total value of property purchas 14593 600000 255.033 8166.378 Building gifted Building gifted Building gifted Building gifted Building gifted 14593 300000 38.032 2677.42 Land gifted Land gifted Land gifted Land gifted Land gifted 14593 150000 12.335 1266.28 Total value of gifted property Total value of gifted property Total value of gifted property Total value of gifted property Total value of gifted property 14593 150000 29.809 1613.999 Building lost Building lost Building lost Building lost Building lost 14593 25000 10.93 377.777 Land lost Land lost Land lost Land lost Land lost 14593 40000 4.797 356.224 Total value of lost property Total value of lost property Total value of lost property Total value of lost property Total value of lost property 14593 40000 15.727 519.14 Building improvement Building improvement Building improvement Building improvement Building improvement 14593 500000 356.853 7383.614 Land improvement Land improvement Land improvement Land improvement Land improvement 14593 16000 5.996 245.537 Total value of property improve Total value of property improve Total value of property improve Total value of property improve Total value of property improve 14593 500000 362.858 7391.311 Household ID code Household ID code Household ID code Household ID code Household ID code 14593 110100301 420404616 214531053.336 104662024.47 PLS present value PLS present value PLS present value PLS present value PLS present value 14593 60000000 6647.565 497174.646 PLS last year PLS last year PLS last year PLS last year PLS last year 14593 600000 752.897 9634.927 PLS withdrawn PLS withdrawn PLS withdrawn PLS withdrawn PLS withdrawn 14593 800000 783.785 12691.295 PLS interest PLS interest PLS interest PLS interest PLS interest 14593 3326000 294.343 27550.064 Small saving present value Small saving present value Small saving present value Small saving present value Small saving present value 14593 300000 161.593 4168.533 Small saving last year Small saving last year Small saving last year Small saving last year Small saving last year 14593 50000 8.703 469.716 Small saving withdrawn Small saving withdrawn Small saving withdrawn Small saving withdrawn Small saving withdrawn 14593 90000 18.571 1004.034 Small saving interest Small saving interest Small saving interest Small saving interest Small saving interest 14593 42000 6.241 371.228 Deposit abroad Deposit abroad Deposit abroad Deposit abroad Deposit abroad 14593 2000000 189.265 17096.777 CCA domestic CCA domestic CCA domestic CCA domestic CCA domestic 14593 400000 306.758 5659.071 Cash in hand Cash in hand Cash in hand Cash in hand Cash in hand 14593 500000 1368.896 6108.575 Cash foreign Cash foreign Cash foreign Cash foreign Cash foreign 14593 100000 82.672 1700.501 Gold present value Gold present value Gold present value Gold present value Gold present value 14593 1000000 6468.608 18206.087 Gold saving Gold saving Gold saving Gold saving Gold saving 14593 120000 246.777 2655.296 Gold withdrawn Gold withdrawn Gold withdrawn Gold withdrawn Gold withdrawn 14593 47000 37.272 852.609 Total present (7.1) Total present (7.1) Total present (7.1) Total present (7.1) Total present (7.1) 14593 4600000 11113.397 49609.886 Total saved (7.1) Total saved (7.1) Total saved (7.1) Total saved (7.1) Total saved (7.1) 14593 600000 1008.377 10034.844 Total withdrawn (7.1) Total withdrawn (7.1) Total withdrawn (7.1) Total withdrawn (7.1) Total withdrawn (7.1) 14593 800000 825.922 12649.72 Total interest (7.1) Total interest (7.1) Total interest (7.1) Total interest (7.1) Total interest (7.1) 14593 52500 72.666 1058.418 Security 1 present value Security 1 present value Security 1 present value Security 1 present value Security 1 present value 14593 500000 113.136 5065.9 Security 1 value last year Security 1 value last year Security 1 value last year Security 1 value last year Security 1 value last year 14593 400000 29.754 3316.264 Security 1 value purchased Security 1 value purchased Security 1 value purchased Security 1 value purchased Security 1 value purchased 14593 100000 22.929 1367.259 Security 1 dividend Security 1 dividend Security 1 dividend Security 1 dividend Security 1 dividend 14593 62500 14.091 746.376 Security 2 present value Security 2 present value Security 2 present value Security 2 present value Security 2 present value 14593 200000 15.076 1663.855 Security 2 value last year Security 2 value last year Security 2 value last year Security 2 value last year Security 2 value last year 14593 Security 2 value purchased Security 2 value purchased Security 2 value purchased Security 2 value purchased Security 2 value purchased 14593 20000 1.371 165.561 Security 2 dividend Security 2 dividend Security 2 dividend Security 2 dividend Security 2 dividend 14593 25000 2.056 211.047 Security 3 present value Security 3 present value Security 3 present value Security 3 present value Security 3 present value 14593 Security 3 value last year Security 3 value last year Security 3 value last year Security 3 value last year Security 3 value last year 14593 Security 3 value purchased Security 3 value purchased Security 3 value purchased Security 3 value purchased Security 3 value purchased 14593 Security 3 dividend Security 3 dividend Security 3 dividend Security 3 dividend Security 3 dividend 14593 463 0.0317 3.833 Total security present value Total security present value Total security present value Total security present value Total security present value 14593 500000 143.98 5746.792 Total security value last year Total security value last year Total security value last year Total security value last year Total security value last year 14593 400000 29.781 3316.266 Total security value purchased Total security value purchased Total security value purchased Total security value purchased Total security value purchased 14593 30031000 2082.204 248601.656 Total security value dividend Total security value dividend Total security value dividend Total security value dividend Total security value dividend 14593 50000004 4812.968 445776.505 Security type 1 Security type 1 Security type 1 Security type 1 Security type 1 14593 53 0.0119 0.484 Security type 2 Security type 2 Security type 2 Security type 2 Security type 2 14593 2 3 4 Security type 3 Security type 3 Security type 3 Security type 3 Security type 3 14593 21 0.00144 0.174 Loan 1 owed currently Loan 1 owed currently Loan 1 owed currently Loan 1 owed currently Loan 1 owed currently 14593 1100000 3327.563 21061.342 Loan 1 advanced last year Loan 1 advanced last year Loan 1 advanced last year Loan 1 advanced last year Loan 1 advanced last year 14593 320000 1442.054 8599.017 Loan 1 repaid Loan 1 repaid Loan 1 repaid Loan 1 repaid Loan 1 repaid 14593 150000 429.592 3461.699 Loan 1 duration Loan 1 duration Loan 1 duration Loan 1 duration Loan 1 duration 14593 1 2 Loan 1, is paying interest Loan 1, is paying interest Loan 1, is paying interest Loan 1, is paying interest Loan 1, is paying interest 14593 1 2 Loan 1 interest rate Loan 1 interest rate Loan 1 interest rate Loan 1 interest rate Loan 1 interest rate 14593 600 0.246 7.236 Loan 1 purpose Loan 1 purpose Loan 1 purpose Loan 1 purpose Loan 1 purpose 14593 1 2 3 4 5 6 Loan 1 whom Loan 1 whom Loan 1 whom Loan 1 whom Loan 1 whom 14593 1 2 3 4 5 6 7 Loan 2 owed currently Loan 2 owed currently Loan 2 owed currently Loan 2 owed currently Loan 2 owed currently 14593 6306410 584.408 52461.481 Loan 2 advanced last year Loan 2 advanced last year Loan 2 advanced last year Loan 2 advanced last year Loan 2 advanced last year 14593 550000 99.516 4929.086 Loan 2 repaid Loan 2 repaid Loan 2 repaid Loan 2 repaid Loan 2 repaid 14593 490000 46.333 4093.285 Loan 2 duration Loan 2 duration Loan 2 duration Loan 2 duration Loan 2 duration 14593 1 2 Loan 2, is paying interest Loan 2, is paying interest Loan 2, is paying interest Loan 2, is paying interest Loan 2, is paying interest 14593 1 2 7 Loan 2 interest rate Loan 2 interest rate Loan 2 interest rate Loan 2 interest rate Loan 2 interest rate 14593 21000 1.448 173.839 Loan 2 purpose Loan 2 purpose Loan 2 purpose Loan 2 purpose Loan 2 purpose 14593 1 2 3 6 Loan 2 whom Loan 2 whom Loan 2 whom Loan 2 whom Loan 2 whom 14593 1 2 3 4 6 7 Loan 3 owed currently Loan 3 owed currently Loan 3 owed currently Loan 3 owed currently Loan 3 owed currently 14593 46800 21.868 733.265 Loan 3 advanced last year Loan 3 advanced last year Loan 3 advanced last year Loan 3 advanced last year Loan 3 advanced last year 14593 309510 31.101 2597.94 Loan 3 repaid Loan 3 repaid Loan 3 repaid Loan 3 repaid Loan 3 repaid 14593 330004 25.733 2738.469 Loan 3 duration Loan 3 duration Loan 3 duration Loan 3 duration Loan 3 duration 14593 1 2 Loan 3, is paying interest Loan 3, is paying interest Loan 3, is paying interest Loan 3, is paying interest Loan 3, is paying interest 14593 1 2 3 Loan 3 interest rate Loan 3 interest rate Loan 3 interest rate Loan 3 interest rate Loan 3 interest rate 14593 30000 2.388 251.538 Loan 3 purpose Loan 3 purpose Loan 3 purpose Loan 3 purpose Loan 3 purpose 14593 1 2 3 6 Loan 3 whom Loan 3 whom Loan 3 whom Loan 3 whom Loan 3 whom 14593 1 2 4 6 7 Loan 4 owed currently Loan 4 owed currently Loan 4 owed currently Loan 4 owed currently Loan 4 owed currently 14593 1000300 78.583 8291.396 Loan 4 advanced last year Loan 4 advanced last year Loan 4 advanced last year Loan 4 advanced last year Loan 4 advanced last year 14593 27000 7.257 346.779 Loan 4 repaid Loan 4 repaid Loan 4 repaid Loan 4 repaid Loan 4 repaid 14593 312210 22.651 2585.996 Loan 4 duration Loan 4 duration Loan 4 duration Loan 4 duration Loan 4 duration 14593 1 2 Loan 4, is paying interest Loan 4, is paying interest Loan 4, is paying interest Loan 4, is paying interest Loan 4, is paying interest 14593 1 2 Loan 4 interest rate Loan 4 interest rate Loan 4 interest rate Loan 4 interest rate Loan 4 interest rate 14593 10 Loan 4 purpose Loan 4 purpose Loan 4 purpose Loan 4 purpose Loan 4 purpose 14593 1 2 5 6 Loan 4 whom Loan 4 whom Loan 4 whom Loan 4 whom Loan 4 whom 14593 1 4 Loan total owed Loan total owed Loan total owed Loan total owed Loan total owed 14593 6031231 3924.946 54651.091 Loan total advanced last year Loan total advanced last year Loan total advanced last year Loan total advanced last year Loan total advanced last year 14593 610087018168320 216355563868.981 7825399093678.55 Loan total repaid Loan total repaid Loan total repaid Loan total repaid Loan total repaid 14593 150000 444.105 3580.978 Advanced 1 owed Advanced 1 owed Advanced 1 owed Advanced 1 owed Advanced 1 owed 14593 3124100 721.888 28483.677 Advanced 1 last year Advanced 1 last year Advanced 1 last year Advanced 1 last year Advanced 1 last year 14593 100000 137.81 2295.925 Advanced 1repaid Advanced 1repaid Advanced 1repaid Advanced 1repaid Advanced 1repaid 14593 50000 36.393 841.04 Advanced 1duration Advanced 1duration Advanced 1duration Advanced 1duration Advanced 1duration 14593 1 2 Advanced 1, is interest Advanced 1, is interest Advanced 1, is interest Advanced 1, is interest Advanced 1, is interest 14593 1 2 6 Advanced 1interest rate Advanced 1interest rate Advanced 1interest rate Advanced 1interest rate Advanced 1interest rate 14593 10001 0.702 82.805 Advanced 1purpose Advanced 1purpose Advanced 1purpose Advanced 1purpose Advanced 1purpose 14593 1 2 3 4 5 6 Advanced 2 owed Advanced 2 owed Advanced 2 owed Advanced 2 owed Advanced 2 owed 14593 150000 13.644 1250.254 Advanced 2 last year Advanced 2 last year Advanced 2 last year Advanced 2 last year Advanced 2 last year 14593 312710 23.498 2591.282 Advanced 2 repaid Advanced 2 repaid Advanced 2 repaid Advanced 2 repaid Advanced 2 repaid 14593 1000 0.0685 8.278 Advanced 2 duration Advanced 2 duration Advanced 2 duration Advanced 2 duration Advanced 2 duration 14593 1 2 Advanced 2, is interest Advanced 2, is interest Advanced 2, is interest Advanced 2, is interest Advanced 2, is interest 14593 2 Advanced 2 interest rate Advanced 2 interest rate Advanced 2 interest rate Advanced 2 interest rate Advanced 2 interest rate 14593 831 0.0569 6.879 Advanced 2 purpose Advanced 2 purpose Advanced 2 purpose Advanced 2 purpose Advanced 2 purpose 14593 1 2 4 6 Advanced 3 owed Advanced 3 owed Advanced 3 owed Advanced 3 owed Advanced 3 owed 14593 9100010 634.257 75340.428 Advanced 3 last year Advanced 3 last year Advanced 3 last year Advanced 3 last year Advanced 3 last year 14593 1200 0.151 12.93 Advanced 3 repaid Advanced 3 repaid Advanced 3 repaid Advanced 3 repaid Advanced 3 repaid 14593 831321 56.967 6881.711 Advanced 3 duration Advanced 3 duration Advanced 3 duration Advanced 3 duration Advanced 3 duration 14593 1 2 Advanced 3, is interest Advanced 3, is interest Advanced 3, is interest Advanced 3, is interest Advanced 3, is interest 14593 2 Advanced 3 interest rate Advanced 3 interest rate Advanced 3 interest rate Advanced 3 interest rate Advanced 3 interest rate 14593 1000 0.0685 8.278 Advanced 3 purpose Advanced 3 purpose Advanced 3 purpose Advanced 3 purpose Advanced 3 purpose 14593 1 2 4 6 Advanced 4 owed Advanced 4 owed Advanced 4 owed Advanced 4 owed Advanced 4 owed 14593 6315 0.686 55.262 Advanced 4 last year Advanced 4 last year Advanced 4 last year Advanced 4 last year Advanced 4 last year 14593 110001 7.579 910.606 Advanced 4 repaid Advanced 4 repaid Advanced 4 repaid Advanced 4 repaid Advanced 4 repaid 14593 Advanced 4 duration Advanced 4 duration Advanced 4 duration Advanced 4 duration Advanced 4 duration 14593 1 2 Advanced 4, is interest Advanced 4, is interest Advanced 4, is interest Advanced 4, is interest Advanced 4, is interest 14593 2 4 Advanced 4 interest rate Advanced 4 interest rate Advanced 4 interest rate Advanced 4 interest rate Advanced 4 interest rate 14593 31571 2.163 261.346 Advanced 4 purpose Advanced 4 purpose Advanced 4 purpose Advanced 4 purpose Advanced 4 purpose 14593 1 4 Advanced total owed Advanced total owed Advanced total owed Advanced total owed Advanced total owed 14593 5000000 875.002 43242.876 Advanced total last year Advanced total last year Advanced total last year Advanced total last year Advanced total last year 14593 100000 138.929 2298.225 Advanced total repaid Advanced total repaid Advanced total repaid Advanced total repaid Advanced total repaid 14593 701000 84.318 5863.227 Is Life insurance paid Is Life insurance paid Is Life insurance paid Is Life insurance paid Is Life insurance paid 14593 1 2 5 How many received as life insur How many received as life insur How many received as life insur How many received as life insur How many received as life insur 14593 20000000 6174.234 320559.233 Policy 1 paid Policy 1 paid Policy 1 paid Policy 1 paid Policy 1 paid 14593 318110 41.23 2646.548 Policy 1 installment Policy 1 installment Policy 1 installment Policy 1 installment Policy 1 installment 14593 5000 1.01 58.129 Policy 1 installment made Policy 1 installment made Policy 1 installment made Policy 1 installment made Policy 1 installment made 14593 7800 4.535 153.473 Policy 2 paid Policy 2 paid Policy 2 paid Policy 2 paid Policy 2 paid 14593 60323 7.25 511.326 Policy 2 installment Policy 2 installment Policy 2 installment Policy 2 installment Policy 2 installment 14593 1301 0.181 15.225 Policy 2 installment made Policy 2 installment made Policy 2 installment made Policy 2 installment made Policy 2 installment made 14593 8000 1.659 102.643 Policy 3 paid Policy 3 paid Policy 3 paid Policy 3 paid Policy 3 paid 14593 130011 9.168 1076.599 Policy 3 installment Policy 3 installment Policy 3 installment Policy 3 installment Policy 3 installment 14593 3232 0.225 26.757 Policy 3 installment made Policy 3 installment made Policy 3 installment made Policy 3 installment made Policy 3 installment made 14593 1000 0.0704 8.28 Policy 4 paid Policy 4 paid Policy 4 paid Policy 4 paid Policy 4 paid 14593 200000 15.464 1661.605 Policy 4 installment Policy 4 installment Policy 4 installment Policy 4 installment Policy 4 installment 14593 2200 0.732 37.895 Policy 4 installment made Policy 4 installment made Policy 4 installment made Policy 4 installment made Policy 4 installment made 14593 3188 0.535 37.507 Provident fund paid Provident fund paid Provident fund paid Provident fund paid Provident fund paid 14593 1 2 Provident fund received Provident fund received Provident fund received Provident fund received Provident fund received 14593 50000000 13783.67 561318.445 Contribution 1 contributed Contribution 1 contributed Contribution 1 contributed Contribution 1 contributed Contribution 1 contributed 14593 91000 91.906 1028.216 Contribution 1 current balance Contribution 1 current balance Contribution 1 current balance Contribution 1 current balance Contribution 1 current balance 14593 20000000 2915.391 189039.296 Contribution 2 contributed Contribution 2 contributed Contribution 2 contributed Contribution 2 contributed Contribution 2 contributed 14593 330111 32.615 2738.204 Contribution 2 current balance Contribution 2 current balance Contribution 2 current balance Contribution 2 current balance Contribution 2 current balance 14593 32611000 2643.113 273110.533 Contribution 3 contributed Contribution 3 contributed Contribution 3 contributed Contribution 3 contributed Contribution 3 contributed 14593 4800 1.827 62.202 Contribution 3 current balance Contribution 3 current balance Contribution 3 current balance Contribution 3 current balance Contribution 3 current balance 14593 31100020 2282.089 257996.057 14593 110100301 420404616 214531053.336 104662024.47 14593 29392 994.697 1193.302