Home / Central Data Catalog / IMPACT_EVALUATION / EGY_2011_MMIE_V01_M_V01_A_PUF
impact_evaluation

Macroinsurance for Microenterprises: A Randomized Experiment in Post-Revolution Egypt 2011

Egypt, Arab Rep., 2011 - 2012
Get Microdata
Reference ID
EGY_2011_MMIE_v01_M_v01_A_PUF
DOI
https://doi.org/10.48529/drza-b779
Producer(s)
Matthew Groh, David McKenzie, Tara Vishwanath
Collection(s)
Impact Evaluation Surveys
Metadata
Documentation in PDF DDI/XML JSON
Created on
Sep 15, 2014
Last modified
Oct 07, 2014
Page views
91061
Downloads
14886

Data file: MacroinsuranceforMicroentrepreneurs

Business Owner Questionnaire - Baseline
Section 1: Enterprise owner background
Section 2: Business information
Section 3: Finance
Section 4: Attitudes towards risk
Section 5: Assets and inventory
Section 6: Income
Section 7: Other finance
Section 8: Discounting and saving
Section 9: Expectations
Section 10: Financial literacy
Section 11: Obstacles to business
Section 12: Consumption information
Section 13: Tracking information
Section 14: Games

Business Owner Questionnaire - Follow-up
Section 1: Enterprise owner background
Section 2: Business information
Section 3: Wage employment
Section 4: Loans
Section 5: Epp and economic outlook
Section 6: Assets
Section 7: Inventory
Section 8: Discount rate
Section 9: Business profits
Section 10: Investment proclivity
Section 11: Obstacles to business
Section 12: Discount rate
Section 13: Consumption information

Cases: 2972
Variables: 682

Variables

b_1102_18
Judgment on "Corruption" problem severity
b_1101_19
"Illegal competition":problem for the growth of the enterprise
b_1102_19
Judgment on "Illegal competition" problem severity
b_1101_20
"Legal system/conflict resolution":problem for the growth of the enterprise
b_1102_20
Judgment on "Legal system/conflict resolution" problem severity
b_1101_21
"Smuggling/dumping":problem for the growth of the enterprise
b_1102_21
Judgment on "Smuggling/dumping" problem severity
b_1201_1
Amount spent last week on "Drinks" (L.E)
b_1201_2
Amount spent last week on "Vegetables and fruits" (L.E)
b_1201_3
Amount spent last week on "Meat/Chickens/Fish" (L.E)
b_1201_4
Amount spent last week on "Bread" (L.E)
b_1201_5
Amount spent last week on "Carbohydrates" (L.E)
b_1201_6
Amount spent last week on "Legumes" (L.E)
b_1201_7
Amount spent last week on "Eggs/Milk/Cheese" (L.E)
b_1201_8
Amount spent last week on "Cigarettes and Shisha" (L.E)
b_1201_9
Amount spent last week on "Other food and drink" (L.E)
b_1201_10
Total amount spent last week (L.E)
b_1202_1
Amount spent last month on "Rent" (L.E)
b_1202_2
Amount spent last month on "Water" (L.E)
b_1202_3
Amount spent last month on "Electricity" (L.E)
b_1202_4
Amount spent last month on "Gas" (L.E)
b_1202_5
Amount spent last month on "Non-Durable Goods" (L.E)
b_1202_6
Amount spent last month on "Transport" (L.E)
b_1202_7
Amount spent last month on "Maintenance and Fuel" (L.E)
b_1202_8
Amount spent last month on "Communication" (L.E)
b_1202_9
Amount spent last month on "Leisure Activities" (L.E)
b_1202_10
Amount spent last month on "Hair Cuts" (L.E)
b_1202_11
Amount spent last month on "Monthly Installment" (L.E)
b_1202_12
Amount spent last month on "Loan" (L.E)
b_1202_13
Total amount spent last month (L.E)
b_1203_1
Amount spent last year on "Clothing, Textiles, Bedding" (L.E)
b_1203_2
Amount spent last year on "Footwear" (L.E)
b_1203_3
Amount spent last year on "Funerals, Weddings, Ceremonies" (L.E)
b_1203_4
Amount spent last year on "Electronic" (L.E)
b_1203_5
Amount spent last year on "Furnishings" (L.E)
b_1203_6
Amount spent last year on "Appliances" (L.E)
b_1203_7
Amount spent last year on "Vehicles" (L.E)
b_1203_8
Amount spent last year on "Health" (L.E)
b_1203_9
Amount spent last year on "Education" (L.E)
b_1203_10
Amount spent last year on "Household Renewal" (L.E)
b_1203_11
Total amount spent last year (L.E)
b_1204
In which step of the ladder of standard of living
b_1205_1
Household own "Electricity"
b_1205_2
Household own "Natural Gas"
b_1205_3
Household own "Water"
b_1205_4
Household own "Refrigerator"
b_1205_5
Household own "Freezer"
b_1205_6
Household own "Television"
b_1205_7
Household own "Satellite Dish"
b_1205_8
Household own "Computer"
b_1205_9
Household own "DVD player"
b_1205_10
Household own "Mobile Telephone"
b_1205_11
Household own "Automatic Washing Machine"
b_1205_12
Household own "Dishwasher"
b_1205_13
Household own "Sewing Machine"
b_1205_14
Household own "Fan"
b_1205_15
Household own "Air Conditioning"
b_1205_16
Household own "Toilet with flush"
b_1205_17
Household own "Stove/ Oven"
b_1205_18
Household own "Water Heater"
b_1205_19
Household own "Motorcycle"
b_1205_20
Household own "Car, Van or Truck"
b_1206
Having an "E-mail" address
b_1207
Period for checking the e-mail address
b_1301
Any plans to relocate this business in the next year
b_1401
Selected business
b_1402
Head or Tail
b_1403
Total payout (L.E)
b_1404
Selected bag
b_1405
Selected color
b_1406
Pulled color
b_1407
Money paid or not
b_1408
Total payout of both games (L.E)
b_1409H
End hours
b_1409M
End minutes
m_GOV
Governorate
m_DAY
Day of interview
m_MONTH
Month of interview
m_YEAR
Year of interview
m_INTERV
Interviewer
m_RESULT
Result
m_VISITS
Total number of visits
m_ASYACC
Easy access to client
m_OEDIT
Office editor
m_CODER
Coder
m_KEYER
Keyer
m_100
Respondent agreement to be interviewed
m_101
Who supplied the information
m_102
Enterprise owner still running the business till now
m_103
What the enterprise owner currently do
m_201
Old business still the main business
m_202TEXT
Nature of main current business (Text)
m_202CODE
Nature of main current business (Code)
m_202SEC
Nature of main current business (Sector)
m_202A
Number of business you own or jointly own
m_203
Started a business since March 2012 and closed down permanently
m_204
Reason for closing the business
m_205
Closed / Sold the main business you worked in March 2012
m_206
Main reason for closing your main business
m_207
Main activity you engaged in now after closing / selling the business
m_208
Opened a new business since March 2012
m_209TEXT
Nature of new business (Text)
m_209CODE
Nature of new business (Code)
m_209SEC
Nature of new business (Sector)
m_210
New business owned by yourself or Jointly owned
m_211
Month of starting the new business
m_213_1
Total hours you personally spent working in your business(es) last week
m_213_2
Total days you personally spent working in your business(es) last week
m_213A
Operating your main business in different location since March 2012
m_214
Expanding your main business or your other business since March 2012
m_215
How did you expand your main business or your other business
m_216
Introducing new product/ service since March 2012
m_217
Name of new service/ product (Code)
m_218
Name of main service/ product (Code)
m_219_1
Current price for selling this main product/ service (L.E)
m_219_2
Unit of scale for selling this main product/ service
m_220_1
Price you were selling this main product/ service in march 2012 (L.E)
m_220_2
Unit of scale for selling this main product/ service in march 2012 (L.E)
m_221_1
Your business(es) expenses on "Benzene" in typical month (L.E)
m_221_2
Your business(es) expenses on "Natural Gas" in typical month (L.E)
m_221_3
Your business(es) expenses on "LPG" in typical month (L.E)
m_222_1
Hired new "Full time workers" since march 2012
m_222_2
Hired new "Part time workers" since march 2012
m_223_1
Number of male employees
m_223_2
Number of female employees
m_223_3
Number of employees related to you
m_301
Currently employed in a job in which you receive wages
m_302
Kind of Institution you work in
m_303TEXT
Institution description (Text)
m_303CODE
Institution description (Code)
m_303SEC
Institution description (Sector)
m_304
No. of workers in the institution where you are employed including "project owne
m_305_1
Total working hours last week as a wage worker
m_305_2
Total working days last week as a wage worker
m_306
Amount of earned money from this work last month (L.E)
m_307
In this job, you supervise other employees
m_308
Number of workers under your control
m_309
Any other family member work in the same institution you work in
m_310
You left your business activity to do wage work
m_311
Main two reasons for leaving your business activity for wage work
m_311_A
Order of option "A" if exist
m_311_B
Order of option "B" if exist
m_311_C
Order of option "C" if exist
m_311_D
Order of option "D" if exist
m_311_E
Order of option "E" if exist
m_311_F
Order of option "F" if exist
m_311_G
Order of option "G" if exist
m_311_H
Order of option "H" if exist
m_311_I
Order of option "I" if exist
m_311_J
Order of option "J" if exist
m_311_X
Order of option "X" if exist
m_312
Intend to reenter self-employment or your business activity within the next year
m_313
Intend to start the business in the same activity or different activity
m_314
Looking for a wage job, or another opportunity to enter self-employment
m_315
Duration to find work as you think
m_316TEXT
Sector you intend to look for work or engage in self-employment (Text)
m_316CODE
Sector you intend to look for work or engage in self-employment (Code)
m_316SEC
Sector you intend to look for work or engage in self-employment (Sector)
m_401_1
Renewed a loan with ABA since march 2012
m_401_2
Loan taken with another microfinance organization since march 2012
m_401_3
Loan taken from family and friends since march 2012
m_401_4
Loan taken from a bank since march 2012
m_401_5
Loan taken from another source since march 2012
m_402
Total amount you currently owe to ABA
m_403A
Initial value of the loan (L.E)
m_403B
Monthly installment of the loan (L.E)
m_403C
Duration of the loan (Months)
m_403D
Amount of the loan you have spent
m_404_1
Amount you spent from the loan of ABA on equipments for business
m_404_2
Amount you spent from the loan of ABA on raw materials for business
m_404_3
Amount you spent from the loan of ABA on education
m_404_4
Amount you spent from the loan of ABA on household needs
m_404_5
Amount you spent from the loan of ABA on wedding expenses
m_404_6
Amount you spent from the loan of ABA on other
m_404_7
Total amount you spent from the loan of ABA on all previous
m_404A_1
Amount from the loan of ABA you plan to spend on equipments for business
m_404A_2
Amount from the loan of ABA you plan to spend on raw materials for business
m_404A_3
Amount from the loan of ABA you plan to spend on education
m_404A_4
Amount from the loan of ABA you plan to spend on household needs
m_404A_5
Amount from the loan of ABA you plan to spend on wedding expenses
m_404A_6
Amount from the loan of ABA you plan to spend on other
m_404A_7
Total amount from the loan of ABA you plan to spend on all previous
m_405_1
"ABA wouldnt let me renew": importance of this factor in not renewing a loan wit
m_405_2
"No need for another loan": importance of this factor in not renewing a loan wit
m_405_3
"Interest rates were too high": importance of this factor in not renewing a loan
m_405_4
"Another lender offered a better deal": importance of this factor in not renewin
m_405_5
"Concerned about ability to repay": importance of this factor in not renewing a
m_405_6
"Waiting to see what happens in Egypts economy": importance of this factor in no
m_405_7
"Other": importance of this factor in not renewing a loan with ABA
m_406
Plan on taking a new loan with ABA during next 6 months
m_407_1
Experienced the feeling of "I continuously have struggled to repay my loan on ti
m_407_2
Experienced the feeling of "I sometimes have had to miss at least one meal per m
m_407_3
Experienced the feeling of "The sacrifices i have to make in order to have enoug
m_407_4
Experienced the feeling of "I often worry about how i will come up with money to
m_408
Total amount you currently owe to all lenders not including ABA
m_501
Heard about the EPP offered to some ABA clients by their loan officers that help
m_502
Your loan officer give you the opportunity to participate in the EPP
m_503
You understand the EPP
m_504
Feel any pressure to join the EPP
m_505
Intend to renew your loan if you didn't join the EPP
m_506
You join the EPP
m_507
Reason for joining the EPP
m_508
Feel more comfortable when making investment decisions with the EPP
m_509
Amount you paid to join the EPP
m_510
Intend to renew your loan if you didn't have the opportunity to purchase the EPP
m_511
Percentage that the EPP will payout from 0 to 100
m_512
Reason for not joining the EPP
m_513_1
In what scenario will the EPP payout "Low sales for your business and normal eco
m_513_2
In what scenario will the EPP payout "Depreciation of Egyptian pound to 7 L.E"
m_513_3
In what scenario will the EPP payout "Stock market suspension of 5 days or more"
m_513_4
In what scenario will the EPP payout "Increase in price of benzene 80 to over 2L
m_513_5
In what scenario will the EPP payout "Tourism below 50% of its pre-revolution le
m_513_6
In what scenario will the EPP payout "Increase in the price of subsidized LPG cy
m_514_1
Feeling more/ less confident about "Your business future" compared to march 2012
m_514_2
Feeling more/ less confident about "The economic situation in Egypt" compared to
m_514_3
Feeling more/ less confident about "The political situation in Egypt" compared t
m_515_1
Likelihood of suspension of the stock
m_515_2
Likelihood of higher inflation than anytime in the last 5 years
m_515_3
Likelihood of increasing in price of benzene 80 to over 2L.E/Litre
m_515_4
Likelihood of increasing in price of benzene 90 to over 4L.E/Litre
m_515_5
Likelihood of increasing in price of subsidized LPG cylinder to 30L.E/Cylinder
m_515_6
Likelihood of curfew for 14 hours or more a day
m_516
Likelihood that at least one of the above events will happen during next year
m_601_1
Invest in "New tools and utensils" since March 2012
m_601_1VA
Amount invested in "New tools and utensils" since March 2012
m_601_2
Invest in "New machinery and equipment" since March 2012
m_601_2VA
Amount invested in "New machinery and equipment" since March 2012
m_601_3
Invest in "New furniture" since March 2012
m_601_3VA
Amount invested in "New furniture" since March 2012
m_601_4
Invest in "New vehicles" since March 2012
m_601_4VA
Amount invested in "New vehicles" since March 2012
m_601_5
Invest in "New business site (including land and buildings)" since March 2012
m_601_5VA
Amount invested in "New business site (including land and buildings)" since Marc
m_601_6
Invest in "Other assets" since March 2012
m_601_6VA
Amount invested in "Other assets" since March 2012
m_602_1
Sold any "Tools and utensils" since March 2012
m_602_1VA
Value you sold the "Tools and utensils" since March 2012
m_602_2
Sold any "Machinery and equipment" since March 2012
m_602_2VA
Value you sold the "Machinery and equipment" since March 2012
m_602_3
Sold any "Furniture" since March 2012
m_602_3VA
Value you sold the "Furniture" since March 2012
m_602_4
Sold any "Vehicles" since March 2012
m_602_4VA
Value you sold the "Vehicles" since March 2012
m_602_5
Sold any "Business site (including land and buildings)" since March 2012
m_602_5VA
Value you sold the "Business site (including land and buildings)" since March 20
m_602_6
Sold any "Other assets" since March 2012
m_602_6VA
Value you sold the "Other assets" since March 2012
m_604_1
Own savings: Source you financed the purchase of new assets
m_604_1P
Percentage of own savings as a source in purchasing new assets
m_604_2
Investment by members of household: Source you financed the purchase of new ass
m_604_2P
Percentage of investment by members of household as a source in purchasing new a
m_604_3
Investment by other relatives and friends: Source you financed the purchase of
m_604_3P
Percentage of investment by other relatives and friends as a source in purchasin
m_604_4
Money gifted by parents/ family members/ friends: Source you financed the purch
m_604_4P
Percentage of money gifted by parents/ family members/ friends as a source in pu
m_604_5
Remittances from abroad: Source you financed the purchase of new assets
m_604_5P
Percentage of remittances from abroad as a source in purchasing new assets
m_604_6
Sale of household assets: Source you financed the purchase of new assets
m_604_6P
Percentage of sale of household assets as a source in purchasing new assets
m_604_7
Loans from ABA: Source you financed the purchase of new assets
m_604_7P
Percentage of loans from ABA as a source in purchasing new assets
m_604_8
Loans from any other source: Source you financed the purchase of new assets
m_604_8P
Percentage of loans from any other source as a source in purchasing new assets
m_604_9
Cash received from gamaee'as: Source you financed the purchase of new assets
m_604_9P
Percentage of cash received from gamaee'as as a source in purchasing new assets
m_604_10
Money from sale of asset or equipment of the business: Source you financed the
m_604_10P
Percentage of money from sale of asset or equipment of the business as a source
m_604_11
Profits of this business: Source you financed the purchase of new assets
m_604_11P
Percentage of profits of this business as a source in purchasing new assets
m_604_12P
Total of all sources you financed the purchase of new assets
m_605
Currently delay investing in any machinery or equipment until the economic and p
m_701
Currently hold inventory (products for sale,raw materials, products in productio
m_702
Value of your inventory (products for sale,raw materials, products in production
m_703
Value of the goods/ things you have on hand to sell at the beginning of the day
m_704
Amount you currently have for your enterprise (include cash held at home for bus
m_705
Currently delaying expanding your inventory until the economic and political ins
m_801
Preferring 500L.E after six months or 475L.E after five months
m_801NO
Lowest acceptable amount (L.E)
m_901_1
Revenue of your enterprise in september 2012 before paying any expenses (L.E)
m_901_2
Revenue of your enterprise in augest 2012 before paying any expenses (L.E)
m_901_3
Revenue of your enterprise in july 2012 before paying any expenses (L.E)
m_902_1
Percent of profit from your revenue in september 2012
m_902_2
Percent of profit from your revenue in augest 2012
m_902_3
Percent of profit from your revenue in july 2012
m_903_1
Profit of business (including expenses,wages) but not including income you paid
m_903_2
Profit of business (including expenses,wages) but not including income you paid
m_903_3
Profit of business (including expenses,wages) but not including income you paid
m_904
Percent of monthly profit re-invested in business
m_905
Earning income from anywhere else apart from your enterprise
m_906_1
Amount (L.E) earned in september 2012 (Excluding profits from your business whic
m_906_2
Amount (L.E) earned in augest 2012 (Excluding profits from your business which w
m_906_3
Amount (L.E) earned in july 2012 (Excluding profits from your business which we
m_907
Total household income (L.E) in september 2012
m_1001_1
Investing 25L.E today for a 1% chance of making of 800L.E profit
m_1001_2
Investing 25L.E today for a 5% chance of making of 800L.E profit
m_1001_3
Investing 25L.E today for a 25% chance of making of 800L.E profit
m_1001_4
Investing 25L.E today for a 50% chance of making of 800L.E profit
m_1001_5
Investing 25L.E today for a 90% chance of making of 800L.E profit
m_1101_1
"Labor regulations":problem for the growth of the enterprise
m_1102_1
Judgment on "Labor regulations" severity as a problem
Total: 682
Back to Catalog

This site uses cookies to optimize functionality and give you the best possible experience. If you continue to navigate this website beyond this page, cookies will be placed on your browser. To learn more about cookies, click here.