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
To Securitize or To Price Credit Risk?
Danny McGowan, Huyen Nguyen
Journal of Financial and Quantitative Analysis,
Vol. 58 (1),
2023
Abstract
Do lenders securitize or price loans in response to credit risk? Exploiting exogenous variation in regional credit risk due to foreclosure law differences along US state borders, we find that lenders securitize mortgages that are eligible for sale to the Government Sponsored Enterprises (GSEs) rather than price regional credit risk. For non-GSE-eligible mortgages with no GSE buyback provision, lenders increase interest rates as they are unable to shift credit risk to loan purchasers. The results inform the debate surrounding the GSEs' buyback provisions, the constant interest rate policy, and show that underpricing regional credit risk increases the GSEs' debt holdings.
Read article
30.11.2022 • 28/2022
Stricter rules for banks can relieve real estate markets
Exuberant price levels in the German real estate market could further exacerbate an economic crisis. Fiscal instruments exert too little influence to contain this danger, shows a study by the Halle Institute for Economic Research (IWH).
Michael Koetter
Read
European Real Estate Prices
Michael Koetter, Felix Noth
IWH Technical Reports,
No. 3,
2022
Abstract
Real estate markets are pivotal to financial stability given their dual role as the underlying asset of crucial financial products in financial systems, such as mortgage loans and asset-backed securities, and the primary source of household wealth alike. As such, they also play traditionally a crucial role for the transmission of monetary policy. Imbalances and sudden corrections in real estate markets have been the root cause of many financial crises over the last decades. But whereas some national, often survey-based indicators of real estate prices are provided by central banks and statistical offices, a comprehensive collection of purchase prices, rents, and proxies for the liquidity of European real estate markets is lacking. The IWH European Real Estate Index (EREI) seeks to fill this void for residential property. This technical report describes the gathering and processing of sale and rental prices for properties in 18 European countries. We provide the general scrapeing step in the section before describing country-specific details for each country in separated sub-sections.
Read article
Wirtschaftliche Folgen des Gaspreisanstiegs für die deutsche Industrie
Matthias Mertens, Steffen Müller
IWH Policy Notes,
No. 2,
2022
Abstract
Diese Analyse nutzt amtliche Mikrodaten für die deutsche Industrie. Auf Ebene fein untergliederter Produkte werden der Verbrauch an Erdgas und der heimische Produktumsatz mit Daten der Vereinten Nationen zu Exporten und Importen verknüpft. Es zeigt sich, dass die 300 Produkte mit dem höchsten Gasverbrauch innerhalb der deutschen Industrie für knapp 90% des Gasverbrauchs der Industrie stehen, dass bei Gaspreiserhöhungen um das Vierfache gegenüber den Jahren 2015-2017 die Kosten für das durchschnittliche Produkt um 12 Cent pro Euro Umsatz steigen und dass ein Produktionsstopp der Produkte, die sowohl überdurchschnittlich gasintensiv sind als auch überdurchschnittlich leicht durch Importe substituiert werden können, 26% des Gesamtgasverbrauchs der Industrie einspart, aber weniger als 3% des Umsatzes der Industrie kostet.
Read article
Trading away Incentives
Stefano Colonnello, Giuliano Curatola, Shuo Xia
IWH Discussion Papers,
No. 23,
2022
Abstract
Equity pay has been the primary component of managerial compensation packages at US public firms since the early 1990s. Using a comprehensive sample of top executives from 1992-2020, we estimate to what extent they trade firm equity held in their portfolios to neutralize increments in ownership due to annual equity pay. Executives accommodate ownership increases linked to options awards. Conversely, increases in stock holdings linked to option exercises and restricted stock grants are largely neutralized through comparable sales of unrestricted shares. Variation in stock trading responses across executives hardly appears to respond to diversification motives. From a theoretical standpoint, these results challenge (i) the common, generally implicit assumption that managers cannot undo their incentive packages, (ii) the standard modeling practice of treating different equity pay items homogeneously, and (iii) the often taken for granted crucial role of diversification motives in managers’ portfolio choices.
Read article
Wirtschaftliche Folgen des Gaspreisanstiegs für die deutsche Industrie
Matthias Mertens, Steffen Müller
Sachverständigenrat Wirtschaft,
No. 4,
2022
Abstract
Diese Analyse nutzt amtliche Mikrodaten für die deutsche Industrie. Auf Ebene fein untergliederter Produkte werden der Verbrauch an Erdgas und der heimische Produktumsatz mit Daten der Vereinten Nationen zu Exporten und Importen verknüpft. Es zeigt sich, dass die 300 Produkte mit dem höchsten Gasverbrauch innerhalb der deutschen Industrie für knapp 90% des Gasverbrauchs der Industrie stehen, dass bei Gaspreiserhöhungen um das Vierfache gegenüber den Jahren 2015-2017 die Kosten für das durchschnittliche Produkt um 12 Cent pro Euro Umsatz steigen und dass ein Produktionsstopp der Produkte, die sowohl überdurchschnittlich gasintensiv sind als auch überdurchschnittlich leicht durch Importe substituiert werden können, 26% des Gesamtgasverbrauchs der Industrie einspart, aber weniger als 3% des Umsatzes der Industrie kostet.
Read article
Public Bank Guarantees and Allocative Efficiency
Reint E. Gropp, Andre Guettler, Vahid Saadi
Journal of Monetary Economics,
Vol. 116 (December),
2020
Abstract
A natural experiment and matched bank/firm data are used to identify the effects of bank guarantees on allocative efficiency. We find that with guarantees in place unproductive firms receive larger loans, invest more, and maintain higher rates of sales and wage growth. Moreover, firms produce less productively. Firms also survive longer in banks’ portfolios and those that enter guaranteed banks’ portfolios are less profitable and productive. Finally, we observe fewer economy-wide firm exits and bankruptcy filings in the presence of guarantees. Overall, the results are consistent with the idea that guaranteed banks keep unproductive firms in business for too long.
Read article
Corona Shutdown and Bankruptcy Risk
Oliver Holtemöller, Yaz Gulnur Muradoglu
IWH Online,
No. 3,
2020
Abstract
This paper investigates the consequences of shutdowns during the Corona crisis on the risk of bankruptcy for firms in Germany and United Kingdom. We use financial statements from the period 2014 to 2018 to predict how pervasive risk of bankruptcy becomes for micro, small, medium, and large firms due to shutdown measures. We estimate distress for firms using their capacity to service their debt. Our results indicate that under three months of shutdown almost all firms in shutdown industries face high risk of bankruptcy. In Germany, about 99% of firms in shutdown industries and in the UK about 98% of firms in shutdown industries are predicted to be under distress. The furlough schemes reduce the risk of bankruptcy only marginally to 97% of firms in shutdown industries in Germany and 95% of firms in shutdown industries in the United Kingdom in case of a three-month shutdown. In sectors that are not shutdown under conservative estimates of contagion of sales losses, our results indicate considerable risk of widespread bankruptcies ranging from 76% of firms in Germany to 69% of firms in the United Kingdom. These early findings suggest that the impact of corona crisis on corporate sector via shutdowns can be severe and subsequent policy should be designed accordingly.
Read article
Intangible Capital and Productivity. Firm-level Evidence from German Manufacturing
Wolfhard Kaus, Viktor Slavtchev, Markus Zimmermann
IWH Discussion Papers,
No. 1,
2020
Abstract
We study the importance of intangible capital (R&D, software, patents) for the measurement of productivity using firm-level panel data from German manufacturing. We first document a number of facts on the evolution of intangible investment over time, and its distribution across firms. Aggregate intangible investment increased over time. However, the distribution of intangible investment, even more so than that of physical investment, is heavily right-skewed, with many firms investing nothing or little, and a few firms having very large intensities. Intangible investment is also lumpy. Firms that invest more intensively in intangibles (per capita or as sales share) also tend to be more productive. In a second step, we estimate production functions with and without intangible capital using recent control function approaches to account for the simultaneity of input choice and unobserved productivity shocks. We find a positive output elasticity for research and development (R&D) and, to a lesser extent, software and patent investment. Moreover, the production function estimates show substantial heterogeneity in the output elasticities across industries and firms. While intangible capital has small effects for firms with low intangible intensity, there are strong positive effects for high-intensity firms. Finally, including intangibles in a gross output production function reduces productivity dispersion (measured by the 90-10 decile range) on average by 3%, in some industries as much as nearly 9%.
Read article