single-dr.php

JDR Vol.18 No.7 pp. 796-805
(2023)
doi: 10.20965/jdr.2023.p0796

Paper:

Estimation of Sales Decline Risk Based on COVID-19 as a Model

Katsumasa Ohori

Graduate School of Software and Information Science, Iwate Prefectural University
152-52 Sugo, Takizawa, Iwate 020-0693, Japan

Corresponding author

Received:
February 21, 2023
Accepted:
July 5, 2023
Published:
October 1, 2023
Keywords:
COVID-19, sales decline, risk analysis, quantile method, excess probability
Abstract

Owing to the coronavirus disease 2019 (COVID-19), many companies experienced a sharp and significant decline in sales, resulting in a major crisis. This study proposes a method for estimating the risk of a sudden and significant decline in sales to tackle the aforementioned issue. The method is based on the distributional characteristics calculated from historical data of companies mainly in the transportation industry, which are vulnerable to disasters, using the damage caused by COVID-19 as a lesson. Furthermore, we conduct an empirical analysis using the proposed stochastic model for the case of the All Nippon Airways Co., Ltd. (ANA), a major Japanese airline company. The results are as follows: (1) the sales change rates are normally distributed before COVID-19, but inclusion of post-COVID-19 data produced asymmetric distribution of sales change rates; (2) the proposed statistic is log-normally distributed (including post-COVID-19 data) for a time interval of two or three years; (3) the probability of actual sales decline was estimated to be between 0.1% and 1.6% in fiscal year (FY) 2020 and FY2021 post-COVID-19; (4) the estimated risk of future sales decline is well-grounded in light of past actual values.

Cite this article as:
K. Ohori, “Estimation of Sales Decline Risk Based on COVID-19 as a Model,” J. Disaster Res., Vol.18 No.7, pp. 796-805, 2023.
Data files:
References
  1. [1] M. Shiiba, Y. Tachikawa, and Y. Ichikawa, “Hydrology and Hydraulic Engineering Planning,” Kyoto University Press, 2013 (in Japanese).
  2. [2] S. A. Klugman, H. H. Panjer, and G. E. Willmot, “Loss Models from Data to Decisions,” 3rd edition, Wiley, 2008.
  3. [3] R. Takahashi and T. Shimura, “Extreme Value Statistics,” Kindai Kagaku Sha, 2016 (in Japanese).
  4. [4] L. Wu and H. Hayashi, “The Impact of Disasters on Japan’s Inbound Tourism Demand,” J. Disaster Res., Vol.9, No.sp, pp. 699-708, 2014. https://doi.org/10.20965/jdr.2014.p0699
  5. [5] A. J. McNeil, R. Frey, and P. Embrechts, “Quantitative Risk Management: Concepts, Techniques and Tools,” Princeton University Press, 2005.
  6. [6] S. Yoshifuji, “Financial Engineering and Risk Management,” Kinzai Institute for Financial Affairs, 2005 (in Japanese).
  7. [7] M. Crouhy, D. Galai, and R. Mark, “The Essentials of Risk Management,” McGraw-Hill, 2000.
  8. [8] M. Allen, “Building a Role Model,” Risk, Vol.7, No.9, pp. 73-80, 1994.
  9. [9] P. Jorion, “Risk: Measuring the Risk in Value at Risk,” Financial Analysts J., Vol.52, No.6, pp. 47-56, 1996.
  10. [10] S. Yoshifuji, “Illustrated Financial Engineering and Risk Management,” Kinzai Institute for Financial Affairs, 2005 (in Japanese).
  11. [11] H. Kaibuchi, Y. Kawaski, and G. Stupfler, “GARCH-UGH: A Bias-Reduced Approach for Dynamic Extreme Value-at-Risk Estimation in Financial Time Series,” Quantitative Finance, Vol.22, No.7, pp. 1277-1294, 2022. https://doi.org/10.1080/14697688.2022.2048061
  12. [12] E. Bobeica and B. Hartwig, “The COVID-19 Shock and Challenges for Inflation Modelling,” Int. J. of Forecasting, Vol.39, No.1, pp. 519-539, 2023. https://doi.org/10.1016/j.ijforecast.2022.01.002
  13. [13] Y. Kajitani, K. Nakano, H. Tatano, and K. Shu, “Economic Impacts on Industrial Sectors by the Niigata Chuetsu-oki Earthquake in 2007: Survey of Firms’ Damages and Responses,” J. of Social Safety Science, No.10, pp. 161-168, 2008 (in Japanese). https://doi.org/10.11314/jisss.10.161
  14. [14] K. Tatebe, K. Tamura, and I. Takahashi, “Study on Estimation of Management-Related Damage to Small and Medium-Sized Companies Due to Large Earthquakes,” J. of Structural and Construction Engineering (Trans. of AIJ), Vol.74, No.644, pp. 1879-1885, 2009 (in Japanese). https://doi.org/10.3130/aijs.74.1879
  15. [15] N. Matsushita and E. Hideshima, “Assessment of Financial Impacts of the Great East Japan Earthquake on the Listed Manufacturing Industries – Mitigation Effect of BCP and Risk Finance –,” J. of Japan Society of Civil Engineers, Ser. F6 (Safety Problem), Vol.70, No.1, pp. 33-43, 2014 (in Japanese). https://doi.org/10.2208/jscejsp.70.33
  16. [16] Y. Nakashima, T. Nakamura, K. Nakagami, and E. Nishizaki, “A Study on Method of Probabilistic Risk Analysis of Airport,” Technical Note of National Institute for Land and Infrastructure Management, No.783, 2014 (in Japanese).
  17. [17] S. Ikebuchi, M. Shiiba, K. Takara, and Y. Tachikawa, “Ace Hydrology,” Asakura Publishing, 2006 (in Japanese).
  18. [18] K. Hoshi, J. R. Stedinger, and S. J. Burges, “Estimation of Log-Normal Quantiles: Monte Carlo Results and First-Order Approximations,” J. of Hydrology, Vol.71, Nos.1-2, pp. 1-30, 1984. https://doi.org/10.1016/0022-1694(84)90069-6
  19. [19] ANA Holdings Inc. (in Japanese). https://www.ana.co.jp/group/investors/irdata/ [Accessed November 26, 2022]
  20. [20] Y. Takao, “1000 Days of ANA Struggle,” Nikkei Business Publication, 2022 (in Japanese).
  21. [21] L. A. Althouse, W. B. Ware, and J. M. Ferron, “Detecting Departures from Normality: A Monte Carlo Simulation of a New Omnibus Test Based on Moments,” Annual Meeting of the American Educational Research Association, 1998.
  22. [22] P. J. Farrell and K. Rogers-Stewart, “Comprehensive Study of Tests for Normality and Symmetry: Extending the Spiegelhalter Test,” J. of Statistical Computation and Simulation, Vol.76, No.9, pp. 803-816, 2006. https://doi.org/10.1080/10629360500109023
  23. [23] N. M. Razali and Y. B. Wah, “Power Comparisons of Shapiro-Wilk, Kolmogorov-Smirnov, Lilliefors and Anderson-Darling Tests,” J. of Statistical Modeling and Analytics, Vol.2, No.1, pp. 21-33, 2011.
  24. [24] Mitsubishi UFJ Financial Group, “MUFG Report 2021,” 2021 (in Japanese). https://www.mufg.jp/dam/ir/report/disclosure/pdf/2021-data_all_ja.pdf [Accessed February 10, 2023]

*This site is desgined based on HTML5 and CSS3 for modern browsers, e.g. Chrome, Firefox, Safari, Edge, Opera.

Last updated on Feb. 19, 2024