Intuit QuickBooks Small Business Index: A New Employment Series for the US, Canada, and the UK
Ufuk Akcigit, Raman Chhina, Seyit Cilasun, Javier Miranda, Eren Ocakverdi, Nicolas Serrano-Velarde
IWH Discussion Papers,
No. 9,
2023
Abstract
Small and young businesses are essential for job creation, innovation, and economic growth. Even most of the superstar firms start their business life small and then grow over time. Small firms have less internal resources, which makes them more fragile and sensitive to macroeconomic conditions. This suggests the need for frequent and real-time monitoring of the small business sector’s health. Previously this was difficult due to a lack of appropriate data. This paper fills this important gap by developing a new Intuit QuickBooks Small Business Index that focuses on the smallest of small businesses with at most 9 workers in the US and the UK and at most 19 workers in Canada. The Index aggregates a sample of anonymous Quick- Books Online Payroll subscriber data (QBO Payroll sample) from 333,000 businesses in the US, 66,000 in Canada, and 25,000 in the UK. After comparing the QBO Payroll sample data to the official statistics, we remove the seasonal components and use a Flexible Least Squares method to calibrate the QBO Payroll sample data against official statistics. Finally, we use the estimated model and the QBO Payroll sample data to generate a near real-time index of economic activity. We show that the estimated model performs well both in-sample and out-of-sample. Additionally, we use this analysis for different regions and industries. Keywords:
Read article
Robots and Female Employment in German Manufacturing
Liuchun Deng, Steffen Müller, Verena Plümpe, Jens Stegmaier
American Economic Association Papers and Proceedings,
May
2023
Abstract
We analyze the impact of robot adoption on female employment. Our analysis is based on novel micro data on robot use by German manufacturing establishments linked with social security records. An event study analysis for robot adoption shows increased churning among female workers. Whereas hiring rises significantly at robot adoption, separations increase with a smaller magnitude one year later. Overall, employment effects are modestly positive and strongest for medium-qualified women. We find no adverse employment effects for female workers in any of our broad qualification groups.
Read article
Robots, Occupations, and Worker Age: A Production-unit Analysis of Employment
Liuchun Deng, Steffen Müller, Verena Plümpe, Jens Stegmaier
IWH Discussion Papers,
No. 5,
2023
Abstract
We analyse the impact of robot adoption on employment composition using novel micro data on robot use in German manufacturing plants linked with social security records and data on job tasks. Our task-based model predicts more favourable employment effects for the least routine-task intensive occupations and for young workers, with the latter being better at adapting to change. An event-study analysis of robot adoption confirms both predictions. We do not find adverse employment effects for any occupational or age group, but churning among low-skilled workers rises sharply. We conclude that the displacement effect of robots is occupation biased but age neutral, whereas the reinstatement effect is age biased and benefits young workers most.
Read article
A Note on the Use of Syndicated Loan Data
Isabella Müller, Felix Noth, Lena Tonzer
IWH Discussion Papers,
No. 17,
2022
Abstract
Syndicated loan data provided by DealScan is an essential input in banking research. This data is rich enough to answer urging questions on bank lending, e.g., in the presence of financial shocks or climate change. However, many data options raise the question of how to choose the estimation sample. We employ a standard regression framework analyzing bank lending during the financial crisis of 2007/08 to study how conventional but varying usages of DealScan affect the estimates. The key finding is that the direction of coefficients remains relatively robust. However, statistical significance depends on the data and sampling choice and we provide guidelines for applied research.
Read article
Expectations, Infections, and Economic Activity
Martin S. Eichenbaum, Miguel Godinho de Matos, Francisco Lima, Sergio Rebelo, Mathias Trabandt
Abstract
The Covid epidemic had a large impact on economic activity. In contrast, the dramatic decline in mortality from infectious diseases over the past 120 years had a small economic impact. We argue that people's response to successive Covid waves helps reconcile these two findings. Our analysis uses a unique administrative data set with anonymized monthly expenditures at the individual level that covers the first three Covid waves. Consumer expenditures fell by about the same amount in the first and third waves, even though the risk of getting infected was larger in the third wave. We find that people had pessimistic prior beliefs about the case-fatality rates that converged over time to the true case-fatality rates. Using a model where Covid is endemic, we show that the impact of Covid is small when people know the true case-fatality rate but large when people have empirically-plausible pessimistic prior beliefs about the case-fatality rate. These results reconcile the large economic impact of Covid with the small effect of the secular decline in mortality from infectious diseases estimated in the literature.
Read article
Does Working at a Start-up Pay Off?
Daniel Fackler, Lisa Hölscher, Claus Schnabel, Antje Weyh
Small Business Economics,
No. 4,
2022
Abstract
Using representative linked employer-employee data for Germany, this paper analyzes short- and long-run differences in labor market performance of workers joining start-ups instead of incumbent firms. Applying entropy balancing and following individuals over ten years, we find huge and long-lasting drawbacks from entering a start-up in terms of wages, yearly income, and (un)employment. These disadvantages hold for all groups of workers and types of start-ups analyzed. Although our analysis of different subsequent career paths highlights important heterogeneities, it does not reveal any strategy through which workers joining start-ups can catch up with the income of similar workers entering incumbent firms.
Read article
Trade Shocks, Labour Markets and Elections in the First Globalisation
Richard Bräuer, Wolf-Fabian Hungerland, Felix Kersting
Abstract
This paper studies the economic and political effects of a large trade shock in agriculture – the grain invasion from the Americas – in Prussia during the first globalisation (1871-1913). We show that this shock accelerated the structural change in the Prussian economy through migration of workers to booming cities. In contrast to studies using today’s data, we do not observe declining per capita income and political polarisation in counties affected by foreign competition. Our results suggest that the negative and persistent effects of trade shocks we see today are not a universal feature of globalisation, but depend on labour mobility. For our analysis, we digitise data from Prussian industrial and agricultural censuses on the county level and combine it with national trade data at the product level. We exploit the cross-regional variation in cultivated crops within Prussia and instrument with Italian trade data to isolate exogenous variation.
Read article
International Trade Barriers and Regional Employment: The Case of a No-Deal Brexit
Hans-Ulrich Brautzsch, Oliver Holtemöller
Journal of Economic Structures,
No. 11,
2021
Abstract
We use the World Input–Output Database (WIOD) combined with regional sectoral employment data to estimate the potential regional employment effects of international trade barriers. We study the case of a no-deal Brexit in which imports to the United Kingdom (UK) from the European Union (EU) would be subject to tariffs and non-tariff trade costs. First, we derive the decline in UK final goods imports from the EU from industry-specific international trade elasticities, tariffs and non-tariff trade costs. Using input–output analysis, we estimate the potential output and employment effects for 56 industries and 43 countries on the national level. The absolute effects would be largest in big EU countries which have close trade relationships with the UK, such as Germany and France. However, there would also be large countries outside the EU which would be heavily affected via global value chains, such as China, for example. The relative effects (in percent of total employment) would be largest in Ireland followed by Belgium. In a second step, we split up the national effects on the NUTS-2 level for EU member states and additionally on the county (NUTS-3) level for Germany. The share of affected workers varies between 0.03% and 3.4% among European NUTS-2 regions and between 0.15% and 0.4% among German counties. A general result is that indirect effects via global value chains, i.e., trade in intermediate inputs, are more important than direct effects via final demand.
Read article
The Nexus between Loan Portfolio Size and Volatility: Does Bank Capital Regulation Matter?
Franziska Bremus, Melina Ludolph
Journal of Banking and Finance,
June
2021
Abstract
This paper analyzes the effects of bank capital regulation on the link between bank size and volatility. Using bank-level data for 27 advanced economies over the 2000–2014 period, we estimate a power law that relates the volume of a bank’s loan portfolio to the volatility of loan growth. Our analysis reveals, first, that more stringent capital regulation weakens the size-volatility nexus. Hence, in countries with more stringent capital regulation, large banks show, ceteris paribus, lower loan portfolio volatility. Second, the effect of tighter capital requirements on the size-volatility nexus becomes stronger for the upper tail of the bank size distribution. This is in line with capitalization decreasing with bank size, such that larger banks tend to be more affected by increasing capital requirements. Third, in countries with higher sectoral capital buffers, the size-volatility nexus is weaker.
Read article
Measuring the Impact of Household Innovation Using Administrative Data
Javier Miranda, Nikolas Zolas
Measuring and Accounting for Innovation in the Twenty-First Century,
NBER Studies in Income and Wealth, Vol 78 /
2021
Abstract
We link USPTO patent data to U.S. Census Bureau administrative records on individuals and firms. The combined dataset provides us with a directory of patenting household inventors as well as a time-series directory of self-employed businesses tied to household innovations. We describe the characteristics of household inventors by race, age, gender and U.S. origin, as well as the types of patented innovations pursued by these inventors. Business data allows us to highlight how patents shape the early life-cycle dynamics of nonemployer businesses. We find household innovators are disproportionately U.S. born, white and their age distribution has thicker tails relative to business innovators. Data shows there is a deficit of female and black inventors. Household inventors tend to work in consumer product areas compared to traditional business patents. While patented household innovations do not have the same impact of business innovations their uniqueness and impact remains surprisingly high. Back of the envelope calculations suggest patented household innovations granted between 2000 and 2011 might generate $5.0B in revenue (2000 dollars).
Read article
