Retrieving HTML and XBRL Data With Microsoft Excel 2010

Author(s):  
Jianing Fang

The Securities and Exchange Commission (SEC) has upgraded the Electronic Data Gathering, Analysis, and Retrieval (EDGAR) system, to the Interactive Data Electronic Applications (IDEA) platform, or the Next-Generation EDGAR (New EDGAR). The SEC issued its final mandate for XBRL adoption and the conversion target dates for all firms in January 2009. With this conversion, users can retrieve the financial statement information of listed companies at both the document level and data element level. This chapter reviews the fundamental concepts of XBRL and reports on the current compliance status of the SEC XBRL conversion mandate. The main task is to demonstrate how to retrieve data from the New EDGAR and how to process the data with Microsoft Excel 2010.

2010 ◽  
Vol 25 (3) ◽  
pp. 489-511 ◽  
Author(s):  
Ernest Capozzoli ◽  
Stephanie Farewell

ABSTRACT: On January 20, 2009, the U.S. Securities and Exchange Commission (SEC) released Rule 33-9002 for the phase-in of interactive data (SEC 2009a). An important component of this rule is the phase-in of detailed tagging of financial statement note disclosures. Tagging is the process of associating a taxonomy element with a financial statement concept for a particular context. While some of the filers have participated in the SEC Voluntary Filing Project and prepared instance documents tagged at the line item level most have not prepared detail-tagged notes to accompany the financial statements (SEC 2005; Choi et al. 2008). This case discusses the structure of disclosures, as they exist in the 2009 U.S. GAAP Taxonomy, followed by a discussion of dimensional extensions and concludes with an example of block and detailed disclosure tagging using Rivet Software’s Dragon Tag (Rivet 2009). The example uses the capitalized costs disclosure for Anadarko Petroleum, a publicly traded company. Following the example, the case requires students to block and detail tag the capitalized costs disclosure for Dig Deep, a hypothetical oil and gas company. By completing the case, students develop an understanding of the current U.S. GAAP taxonomy, skills relating to mapping and tagging processes, and make use of a commonly used XBRL taxonomy and instance document creation program.


2010 ◽  
Vol 25 (3) ◽  
pp. 465-488 ◽  
Author(s):  
Roger Debreceny ◽  
Stephanie Farewell

ABSTRACT: XBRL, based on XML, is an Internet language for disclosure of business reporting language. XBRL is the technological foundation for the interactive data mandate by the Securities and Exchange Commission (SEC). The mandate requires corporate filers to disclose data in quarterly and annual reports in XBL. A key building block supporting the mandate is a substantial U.S. GAAP XBRL taxonomy that encapsulates most of the reporting concepts found in financial reporting. Filers must align their existing reports to the taxonomy. The accuracy of mapping financial statement line items to the U.S. GAAP taxonomy is of fundamental importance. Mapping errors may be as simple as mapping to an incorrect taxonomy concept, which should be discovered during review. Ineffective mapping may lead to unnecessary extensions, which hinders comparability. This instructional resource guides students through the steps in mapping financial statement line items to the taxonomy. While the case does not require students to create an extended taxonomy, it does require completion of a spreadsheet detailing the mapping process that is typical of practice. In addition, the resource provides a checklist that users can refer to during the mapping process.


2016 ◽  
pp. 55-94
Author(s):  
Pier Luigi Marchini ◽  
Carlotta D'Este

The reporting of comprehensive income is becoming increasingly important. After the introduction of Other Comprehensive Income (OCI) reporting, as required by the 2007 IAS 1-revised, the IASB is currently seeking inputs from investors on the usefulness of unrealized gains and losses and on the role of comprehensive income. This circumstance is of particular relevance in code law countries, as local pre-IFRS accounting models influence financial statement preparers and users. This study aims at investigating the role played by unrealized gains and losses reporting on users' decision process, by examining the impact of OCI on the Italian listed companies RoE ratio and by surveying a sample of financial analysts, also content analysing their formal reports. The results show that the reporting of comprehensive income does not affect the financial statement users' decision process, although it statistically affects Italian listed entities' performance.


2010 ◽  
Vol 6 (02) ◽  
pp. 49
Author(s):  
Syarief Gerald Prasetya

Hospital was established to serve the medical needs of the citizen. In addition to serving, hospitals also need to explore the benefits for the sustainability and the development of the hospital. To achieve financial reports have involved a large role. Accounting information system computer-based accounting will help serving the financial reports, so that more accurate and faster. Errors can be diminished.  Research object is selected by the author to conduct research is Bogor Rumah Sakit Islam. A hospital that is located on Jl. Perdana Raya. 22 Budi Agung, Jakarta Utara. This hospital was established on May 12, 1991. The location is strategic as it is in the center of Bogor. In doing activity, accounting information system based on computerized accounting still not yet common use. Computer already exist but support application to create an accurate and fast financial statement does not exist. So much weaknesses if we still using manual method. Like slowly processing data, still using much worker and much step while processing. The information result is still contained high mistake. To solve all problems above we need accounting software as tool for accounting division. For that I try to apply computerized accounting using Microsoft Excel for helping creating financial statement. By doing observation and interview with related employee, this research can do well. Journalize transaction process by using Microsoft Excel is to make a column for each transaction such as Journal Voucher, General Ledger, Balance Sheet. After making a column, the next step is inputing achievement data to Journal Voucher. After inputing data, General Ledger and Balance Sheet can automatically fill up. By using computer, processing data is more faster, information result is more accurately, human resource is less needed. Related management can get information they need more faster, because amount recalculated every doing transaction.


2021 ◽  
Vol 16 (4) ◽  
pp. 48
Author(s):  
Tamer Bahjat Sabri

This paper examines the nature of interaction between Kida’s model, the cash flows (operating, investing, financing) and the size. It covers the period between 2013 and 2014 based on annual financial statement of Palestinian listed companies in Palestine Stock Exchange. In order to test the hypotheses of the study, the researcher used independent samples T-test. The results show that we accept all null hypotheses, so Kida’s model does not distinguish between high and low cash flow (operating, investing, financing) and the size. Other results show that the model is unable sometimes to predict the failure of companies.


2021 ◽  
Author(s):  
Daniel Ikechukwu Egu ◽  
Anthony John Ilozobhie

Abstract Attrition and paroxysm of highly inflammable petroleum products in storage tanks, pipelines and/or haulage trucks is increasingly becoming a scourging socio-environmental quandary with a detrimental effect on the Nigerian economy. Non availability of a holistic response time analytic master plan is a major enigma while industrial disaster managers perhaps are the major culprits since they are mostly not time cognizant for spry and pragmatic delivery of service. The aim of this exposition is to ruminatively carry out cerebral chronological corollary perusal for blitzing fire paroxysms and pipeline attrition in Nigeria on Microsoft excel spread sheet. Comprehensive data validation was done for all models by substituting all solutions of matrix into the predicted time response model. Results of predicted time response model in minutes for case A gave; 101x1 + 79x2 + 59x3 + 45x4 + 24x5 = 358. The predicted time response model for case B gave 78x1 + 56x2 + 43x3 + 30x4 + 13x5 = 260. The predicted time response model for case C gave; 74x1 + 56x2 + 42x3 + 29x4 + 10x5 = 252. Results of these models shows that the average cumulative response time dropped from 3.58 minutes to 2.52 minutes from case A to case C while the coefficients all reduced in their values from model A to C. Improving the source of data gathering and computational processes is recommended for enhancement of this study.


Author(s):  
Christopher Nobes

‘Financial reports of listed companies’ considers the components of an annual report and the types of financial statement that companies generally provide: balance sheet, income statement, statement of changes in equity, and cash flow statement. It addresses the following questions: what are assets and how are they measured? What is the difference between depreciation and impairment? Why are various expected expenses and losses not accounted for as liabilities? How can an investor decide which company to lend to or buy shares in? How could managers use accounting to mislead investors? Tangible assets, intangible assets, and financial assets are defined along with liabilities and accounting ratios.


2009 ◽  
Vol 28 (1) ◽  
pp. 225-240 ◽  
Author(s):  
Li-Lin Liu ◽  
K. Raghunandan ◽  
Dasaratha Rama

SUMMARY: Regulators and legislators have focused significant attention on financial statement restatements in recent years, and the U.S. Securities and Exchange Commission (SEC) and financial statement users view restatements as audit failures. The SEC (2000, 2003a) suggests that shareholder voting on auditor ratification will be impacted by perceptions of audit quality. In this paper we examine shareholder voting on auditor ratifications in 2005 or 2006 following restatement announcements by SEC registrants. We find that shareholders are more likely to vote against auditor ratification after a restatement when compared with votes at (1) firms without restatements or (2) restating firms in the preceding period. Overall, the results provide empirical support to the SEC's assertion that shareholder voting on auditor ratification will be related to perceptions of audit quality, and also support recent actions by shareholder activists to require all firms to submit the selection of the auditor for a ratification vote by shareholders.


2006 ◽  
Vol 2 (3) ◽  
pp. 25-35
Author(s):  
Zulkarnain Muhamad Sori ◽  
Mohamad Ali Abdul Hamid ◽  
Siti Shaharatulfazzah Mohd Saad ◽  
Jonathan Gerard Evans ◽  
Annuar Md Nassir

This study aimed to investigate the perceptions of senior managers of Malaysian publicly listed companies on issues relating to audit committee authority and effectiveness. Questionnaire survey technique was employed to seek the respondents perceptions on five issues, namely audit committee appoints the auditor, audit committee determines and reviews audit fees, audit committee determines and reviews the auditor’s scope and duties, and audit committee’s reports and meetings. The majority of respondents agreed that auditor would be more effective and independent if audit committee assumed the responsibility to appoint the auditor, determine and review the audit fees, and determine and review the external auditor’s scope and duties. It is also found that disclosure of audit committee report and quarterly meeting would enhance the perceptions of users of financial statement concerning the effectiveness of the committee.


2020 ◽  
Vol 8 (1) ◽  
pp. 227-232
Author(s):  
Makarand Upadhyaya

Purpose of the study: The purpose of this research is to find out the relationship between e-CRM and student satisfaction, to find out the relationship between service quality and student satisfaction, to find out the relationship between brand trust and student satisfaction. Methodology: The questionnaire is used as a data-gathering technique with a total sample of 88 respondents, and it is using a purposive sampling technique. The collected data are then analyzed using Microsoft Excel and SPSS 19. Main Findings: The research result shows that e-CRM is positive and has no relationship with student satisfaction, service quality is negative and has a relationship with student satisfaction, and brand trust is negative and has no relationship with student satisfaction. Applications of this study: This study can be used for the management of the Economy and Business Faculty of Budi Luhur University Jakarta as an evaluation guideline. Novelty/Originality of this study: E-CRM and brand trust variables are negative and have no relationship with student satisfaction. Some recommendations for future research are also made.


Sign in / Sign up

Export Citation Format

Share Document