ALL Metrics
-
Views
-
Downloads
Get PDF
Get XML
Cite
Export
Track
Data Note

Dataset of companies’ profitability, government debt, financial statements' key indicators and earnings in an emerging market: Developing a panel and time series database of value-added tax rate increase impacts

[version 1; peer review: 2 approved]
PUBLISHED 14 Apr 2023
Author details Author details
OPEN PEER REVIEW
REVIEWER STATUS

Abstract

Company profitability is a crucial indicator that can be used for developing and sustaining trust in accounting information and, thus, inefficient capital markets. Companies with good financial statements' key indicators have a more extensive customer base and can diversify their revenue streams, making them more resilient to economic downturns. Assembling and managing taxes is a critical underpinning to protecting a country's financial intensity and developing a country's tax-system. VAT is a primary source of financial gain in developing nations, which differs from economic income in developed countries, where economic income is primarily derived from tax income. In emerging economies, the existing practice requires firms to effectively and efficiently publish annual-reports and indicators on market-websites, as users rely heavily on timely-information and need it to make decisions. However, these practices fell short of expectations, requiring more research. These variables are crucial for most accounting/economics/taxation research models and the lack of easily attainable data in well-known databases (e.g., ARGAAM; DataStream). This article is primarily a dataset for analysing taxation, performance variables, and key financial-statement indicators. The data describes the raw, combined, and filtered information at the company level, such as company profit and government debt in Saudi Arabia. It combines a firm-level panel dataset sample of company profit that its measures scaled by total assets and include: earnings before interest, taxes, decrease and amortisation, earnings before interest and taxes, earnings after taxes and earnings before taxes—moreover, the time series dataset sample of 11 financial statements' key indicators. The dataset results from 494 company-year observations (226-panel data sample and 268-time series data sample) from 2019 to 2020. Data has been collected from taxation reports, corporate annual reports, ARGAAM database, FinBox database, the Trading Economics database and the Tadawul-market website in Saudi Arabia.

Keywords

Earnings; Government Debt; Performance; Taxation; Shareholders' Equity; Profitability

Introduction

The reasoning and setting behind the creation of this dataset are to help the researcher to perform a comparative analysis across different disciplines to study the role of these variables in a specific phenomenon or the factors enlightening value-added tax (VAT) usefulness and effectiveness. For example, estimate the consequences of a VAT rate increase on profitability, government debt etc. This dataset helps complete two of the few studies investigating the VAT effect in the Kingdom of Saudi Arabia (KSA). There was an encouragement to observe the effect of imposing the new 15% VAT on the profitability of nonfinancial Saudi-listed companies. This dataset is in two types: a firm-level panel dataset sample and a time series sample (Mgammal, 2021; Mgammal, Al-Matari, and Alruwaili, 2023).

Methods

This dataset article contains proxies to measure the economic impacts of VAT as used by several prior researchers (Mgammal, 2021). The representatives for measuring the economic effects of VAT were manually collected and built using secondary data obtained from publicly available data from 2019 to 2020. In Table 1, ProFtEBITDA means company profit measured by earnings before interest, taxes, devaluation, and amortisation (EBITDA) and scaled by total assets and data collected from FinBox database tools. Data were hand collected from companies’ tax reports. We specify companies and identify them with inclusion/exclusion criteria, as mentioned in Table 3. The inclusion/exclusion criteria of all data in this article are as follows: we included nonfinancial companies and excluded finance firms. Then we filtered the sample by excluding companies with annual reports unavailable for two years. The fiscal year-end date is not 31/12/of each year, and the accounting period is over 12 months. Consequently, the final dataset is 494 company-year observations (226-panel data sample and 268-time series data sample) from 2019 to 2020. This final sample is the foundation that can be used for analysis in future research. SIZE2020 and SIZE2019 are the mean company size in 2020 and 2019, measured by the natural logarithm of total assets and data gathered from companies’ annual reports. EAT2020 and EAT2019 are the mean company earnings after tax in 2020 and 2019 and were measured by deducting all expenditures and revenue taxes from the business’s revenues. Following prior research, two variables were added, GvD2020 and GvD2019, which meant government debt in 2020 and 2019 and was measured as government debt over the gross domestic product (GDP). Data for this were extracted from the Trading Economics (https://tradingeconomics.com/) database. Regarding the process for accessing the data, the data was hand collated directly from the Trading Economics website using many Saudi Arabia Indicators reports, especially GDP Indicators reports. In this context, the data collected from the Trading dataset are the same inclusion/exclusion criteria as mentioned above, and we started data collection on 23/01/2021 to 30/03/2021.

Table 1. Definitions of the variables.

VariablesDefinition
ProFtEBITDACompany Profit
SIZE2020Company Size in 2020
EAT2020Company Earnings after tax in 2020
GvD2020Government Debt 2020
EAT2019Company Earnings after tax in 2019
SIZE2019Company Size in 2019
GvD2019Government Debt 2019

As in Table 2 below, an index containing 11 items was included: BALANCE SHEET: total assets, total equity, and liabilities-equity. INCOME STATEMENT: total income, total revenues, total expenses, and net income. CASH FLOW: changes in operation. Activity, changes in investing act, changes in the financing act, and cash at the end of the period. These factors help control for potential impacts when analysing how a VAT increase will affect a firm. We take each into account as each has a component of the likely effect of a VAT increase. Collectively, these classifications were based on data available on the Tadawul market website as we clarify in inclusion/exclusion criteria above. It is a periodic data set of most Saudi registered companies from before the introduction of the new VAT rate of 15% in 2019 to after the introduction of the new VAT rate in 2020. The dataset framework was chosen when the new 15% VAT was introduced due to public access to VAT information for nonfinancial companies. Tadawul requires all public companies to publish their financial statements on the Tadawul website quarterly and annually (https://m5.gs/OXFqam) (Tadawul, 2019-2020). These data in the file can help build additional variables, such as measuring the effect of VAT before and after increasing its rate using unique techniques such as the difference-in-difference (DID) approach and the autoregressive integrated moving average (ARIMA) modelling approach. Nevertheless, since the literature does not provide common definitions or metrics, we leave the creation of these additional variables at the discretion of potential users. Thus, users can use this dataset to create these measurements from their perspective (Baatwah and Aljaaidi, 2021; Mgammal, 2021).

Table 2. Financial statements’ key indicators definitions.

NoVariables abbreviationsBefore (b) in 2019After (a) in 2020
Balance sheetBalance sheet
1TAb & TAa1. Total Assets (TAb)1. Total Assets (TAa)
2SEb & SEa2. Shareholders’ Equity (SEb)2. Shareholders’ Equity (SEa)
3TLSEb & TLSEa3. Total Liabilities and Shareholder Equity (TLSEb)3. Total Liabilities and Shareholder Equity (TLSEa)
Statement of incomeStatement of income
4TIb & TIa4. Total Income (TIb)4. Total Income (TIa)
5TRb & TRa5. Total Revenues (TRb)5. Total Revenues (TRa)
6TEb & TEa6. Total Expenses (TEb)6. Total Expenses (TEa)
7NIb & NIa7. Net Income (NIb)7. Net Income (NIa)
Cash flowCash flow
8COAb & COAa8. Other Changes in Oper. Activity (COAb)8. Other Changes in Oper. Activity (COAa)
9CIAb & CIAa9. Other Changes in Investing Act. (CIAb)9. Other Changes in Investing Act. (CIAa)
10CFAb & CFAa10. Other Changes in Financing Act. (CFAb)10. Other Changes in Financing Act. (CFAa)
11CEPb & CEPa11. Cash at End of Period (CEPb)11. Cash at End of Period (CEPa)

Data description

The dataset included in this article contains three files describing and defining the sample and variables. Excel file 1 consists of all raw and filtered data for the variables for the panel data sample. Excel file 2 depicts time-series and cross-sectional data for nonfinancial firms listed on the Saudi market for the second and third quarters of 2019 and the third and fourth quarters of 2020. Excel file 3 presents the raw material of variables used in measuring the company’s profitability of the panel data sample. The period of this data is selected from an extensive section of registered companies in Saudi Arabia from 2019 before imposing the new VAT rate, 15%, to 2020 after setting the new VAT rate. The major segments are consumer discretionary, information technology, energy, consumer staples, materials, health care, industrials, communication services, real estate, utilities, and financials. The sample framework was chosen due to the time of implementation new 15% VAT rate and the public access to information about VAT if nonfinancial companies, where Tadawul forces all listed companies to publish their financial statements publicly quarterly and annually on the Tadawul website. Financial companies were excluded from the sample framework as they have unique treatments, and some previous studies investigated the effects of VAT on KSA Banks. The final panel data sample framework is 131 listed companies and 268 observations for the time sires’ sample, as depicted in Table 3 below.

Table 3. Descriptive for the samples’ characteristics.

SectorsVAT 5% implementation period*VAT 15% Implementation period*Panel data sample by companiesTime-series sample by quarterly observations
EnergyFrom Jan. 1, 2018, to July 1, 2020From July 1, 2020, ongoing510
Materials4284
Commercial and Professional Services36
Transportation510
Consumer durables and Apparel612
Consumer services1020
Media and entertainment24
Retailing816
Food and staples retailing44
Food and beverages1224
Health care equipment and Service714
Pharma, Biotech and Life Science12
Software and services24
Telecommunication services48
Utilities24
Capital goods-24
Real estate management and development-22
Total113*2
= 226 Obs
268 Obs

* In the Kingdom of Saudi Arabia (KSA), value-added tax (VAT) was first introduced in all industries as a 5% VAT on goods and services as of Jan. 1, 2018, and, because of COVID-19, the Kingdom of Saudi Arabia (KSA) increased the VAT from 5% to 15% on July 1, 2020.

We utilise balanced panel data as it is a more sensitive measurement of the modifications that could occur between points in time (Cavana, Delahaye, & Sekeran, 2001). Additionally, the outcomes created are more robust, consistent, and stable, enabling a generalisation of the population to be more meaningful and representative. Therefore, the final dataset sample is 226 observations were specified to be eligible for implication in the analyses. It is the basis for the research, i.e. multivariate, bivariate, additional tests and descriptive.

Descriptive statistics

To recognise and determine the situation of every concept, descriptive statistics were utilised to clarify. Table 4 displays the statistics of descriptive (standard deviation, median, mean, minimum, maximum values and degrees of freedom) for 113*2 = 226 observations of all variables of the panel data sample and 268 observations for the time series sample.

Table 4. Descriptive statistics.

(A) Penal data sample (Observations = 226)
VariableObsMeanStd. Dev.MinMax
ProFtEBITDA1130.00004750.0000871-0.00021050.000412
ProFtEBIT1130.0000227.0000751-0.0002220.0001892
ProFtEBTUnu1130.0000344.0001461-0.00022150.0013329
2019 (Before Tax Reform)
EAT20191130.00008420.0007884-0.00065020.008303
SIZE20191136.4024160.77628334.7992999.600352
GvD20191132.2242718.3460270.00952567.217121
2020 (After Tax Reform)
EAT20201130.00001710.0000853-0.00029510.0002637
SIZE20201136.4010140.76464444.638279.274225
GvD20201131.27e+147.60e+141.79e+117.75e+15
Chg (ERN)1132.97312425.42851-16.4361264.1
(B) Time series data sample (Observations = 268)
Before (b) in 2019After (a) in 2020
VariableMeanStd. Dev.MinMaxVariableMeanStd. Dev.MinMax
OTAb1.28E+075.08E+07629944.77E+08TAa1.28E+075.17E+07434785.03E+08
SEb47884021.69E+07554571.69E+08SEa46522921.66E+07144941.65E+08
TLSEb1.28E+075.08E+07629944.77E+08TLSEa1.28E+075.17E+07434785.03E+08
TIb331645.61109441-34078375361TIa318024.61206166-2427258970955
TRb347839.81140208-1050278699826TRa338827.11254699-1780259083262
TEb233783.7980947.3-13743257746953β17TEa225897.5996286.7-11997527762214
NIb78985.93356338.2-7245122679387NIa62371.49342734.2-6098032765537
COAb55342.46970096.6-42525749451664COAa86007.48600282.1-13299886184696
CIAb191045.91078954-4558587620294CIAa15994.71268631.9-11406541589257
CFAb-6429432665571-2.03E+07517795CFAa-4393131907536-1.57E+278246
CEPb6987593357006-47643.74E+07CEPa619081.72733571-342203.02E+07

Value of the data

  • This dataset is essential because it covers data on variables rarely overlooked in accounting, taxation and business performance research models, collectively or individually, but appeal to a wide range of stakeholders. For example, it enables capital markets regulators, standard setters, practitioners and users of financial reporting to easily access long-term data to assess the effectiveness and efficiency of VAT in controlling the risk of tax evasion in fast-growth markets.

  • This dataset is valuable for interdisciplinary studies investigating the role of these variables in specific phenomena or factors enlightening VAT and company performance effectiveness.

  • This dataset is beneficial because it contains data on profitability collected to measure company profit using earnings before interest, taxes, depreciation, and amortisation (EBITDA) and scaled by the total assets data set. Further, the dataset has been arranged into individual and multiple measurements.

  • The data allows researchers to scrutinise the influence of VAT increase on various accounting matters, such as corporate governance mechanisms, the performance of companies and the quality of financial reporting. Furthermore, this dataset is valuable to related parties, e.g., investors, stakeholders, tax authorities, decision-makers, managers and market regulators in assessing and reviewing the tax system in Saudi Arabia. This assessment will give them assurance in making different decisions.

  • These data can be analysed and/or compared to other emerging economies and G20 countries (https://www.g20.org/en/). It can be used in discussing the tax system and VAT rate regarding which parties are responsible for adding some VAT incentives in the tax system and updating the tax system sideways with VAT implementation to advantage from the effectiveness of VAT in the KSA. Because KSA could be similar to other countries in G20 and Gulf Cooperation Council (GCC).

  • The data is also beneficial for studies on VAT incentives efficiency using data in the long term.

Comments on this article Comments (0)

Version 1
VERSION 1 PUBLISHED 14 Apr 2023
Comment
Author details Author details
Competing interests
Grant information
Copyright
Download
 
Export To
metrics
Views Downloads
F1000Research - -
PubMed Central
Data from PMC are received and updated monthly.
- -
Citations
CITE
how to cite this article
Mgammal MH and Al-Matari E. Dataset of companies’ profitability, government debt, financial statements' key indicators and earnings in an emerging market: Developing a panel and time series database of value-added tax rate increase impacts [version 1; peer review: 2 approved]. F1000Research 2023, 12:405 (https://doi.org/10.12688/f1000research.132949.1)
NOTE: If applicable, it is important to ensure the information in square brackets after the title is included in all citations of this article.
track
receive updates on this article
Track an article to receive email alerts on any updates to this article.

Open Peer Review

Current Reviewer Status: ?
Key to Reviewer Statuses VIEW
ApprovedThe paper is scientifically sound in its current form and only minor, if any, improvements are suggested
Approved with reservations A number of small changes, sometimes more significant revisions are required to address specific details and improve the papers academic merit.
Not approvedFundamental flaws in the paper seriously undermine the findings and conclusions
Version 1
VERSION 1
PUBLISHED 14 Apr 2023
Views
11
Cite
Reviewer Report 08 Feb 2024
Faozi Almaqtari, A'Sharqiyah University (ASU), Ibra, Oman 
Approved
VIEWS 11
Thank you for giving me chance review of this intriguing data article. I believe that by utilizing this dataset, researchers can explore compelling issues within the realm of value-added tax (VAT) in the specific context of Saudi Arabia. I would ... Continue reading
CITE
CITE
HOW TO CITE THIS REPORT
Almaqtari F. Reviewer Report For: Dataset of companies’ profitability, government debt, financial statements' key indicators and earnings in an emerging market: Developing a panel and time series database of value-added tax rate increase impacts [version 1; peer review: 2 approved]. F1000Research 2023, 12:405 (https://doi.org/10.5256/f1000research.145908.r230650)
NOTE: it is important to ensure the information in square brackets after the title is included in all citations of this article.
  • Author Response 03 Apr 2024
    Mahfoudh Mgammal, Amran University, Amran, Yemen
    03 Apr 2024
    Author Response
    Thank you for your thorough review and insightful comments on our data article. We appreciate your attention to detail and your anticipation of the significant value that this dataset holds ... Continue reading
COMMENTS ON THIS REPORT
  • Author Response 03 Apr 2024
    Mahfoudh Mgammal, Amran University, Amran, Yemen
    03 Apr 2024
    Author Response
    Thank you for your thorough review and insightful comments on our data article. We appreciate your attention to detail and your anticipation of the significant value that this dataset holds ... Continue reading
Views
28
Cite
Reviewer Report 24 May 2023
Saeed Rabea Baatwah, Department of Accounting, College of Business Administration, Shaqra University, Shaqra, Riyadh Province, Saudi Arabia 
Approved
VIEWS 28
Thank you for reviewing this interesting data article. I think that researchers can test interesting issues in the context of VAT and in Saudi Arabia using this dataset. I would suggest to the authors that it will be more reflective ... Continue reading
CITE
CITE
HOW TO CITE THIS REPORT
Baatwah SR. Reviewer Report For: Dataset of companies’ profitability, government debt, financial statements' key indicators and earnings in an emerging market: Developing a panel and time series database of value-added tax rate increase impacts [version 1; peer review: 2 approved]. F1000Research 2023, 12:405 (https://doi.org/10.5256/f1000research.145908.r172936)
NOTE: it is important to ensure the information in square brackets after the title is included in all citations of this article.
  • Author Response 08 Jun 2023
    Mahfoudh Mgammal, Amran University, Amran, Yemen
    08 Jun 2023
    Author Response
    I would like to thank you for this great feedback and suggestions. We agree with you that updating the title to "Dataset of value-added tax, companies’ profitability, government debt, financial ... Continue reading
COMMENTS ON THIS REPORT
  • Author Response 08 Jun 2023
    Mahfoudh Mgammal, Amran University, Amran, Yemen
    08 Jun 2023
    Author Response
    I would like to thank you for this great feedback and suggestions. We agree with you that updating the title to "Dataset of value-added tax, companies’ profitability, government debt, financial ... Continue reading

Comments on this article Comments (0)

Version 1
VERSION 1 PUBLISHED 14 Apr 2023
Comment
Alongside their report, reviewers assign a status to the article:
Approved - the paper is scientifically sound in its current form and only minor, if any, improvements are suggested
Approved with reservations - A number of small changes, sometimes more significant revisions are required to address specific details and improve the papers academic merit.
Not approved - fundamental flaws in the paper seriously undermine the findings and conclusions
Sign In
If you've forgotten your password, please enter your email address below and we'll send you instructions on how to reset your password.

The email address should be the one you originally registered with F1000.

Email address not valid, please try again

You registered with F1000 via Google, so we cannot reset your password.

To sign in, please click here.

If you still need help with your Google account password, please click here.

You registered with F1000 via Facebook, so we cannot reset your password.

To sign in, please click here.

If you still need help with your Facebook account password, please click here.

Code not correct, please try again
Email us for further assistance.
Server error, please try again.