1 / 54

ACG 4401

ACG 4401. XBRL Instance Documents. XBRL Reports Facts. Financial Information Reported By a Specific Entity For a Specific Period of Time In a Specific Currency How precise is the currency being reported What taxonomy schema is the element defined in. XBRL Specification 2.1.

belita
Download Presentation

ACG 4401

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ACG 4401 XBRL Instance Documents

  2. XBRL Reports Facts • Financial Information Reported • By a Specific Entity • For a Specific Period of Time • In a Specific Currency • How precise is the currency being reported • What taxonomy schema is the element defined in

  3. XBRL Specification 2.1 • Rules and Syntax for • XBRL Instance Documents • XBRL taxonomies • Defines the elements and relationships for financial reporting concepts • Taxonomy Schema for each specific reporting purpose • Commercial & Industrial type company • Banking type company • … • Linkbases • Relationships between the elements

  4. XBRL – The Pieces • Instance Document • Contains the data items which represent the financial data in financial reports • Financial Statements • Disclosures • Taxonomy • Defines elements and relationships • Schema for a particular reporting group • Banking & Savings • Brokers & Dealers • Commercial & Industrial • Insurance • Real Estate • Linkbases • Presentation, Calculation, Reference, Label & Dimension

  5. Types of Taxonomies - FASB • Schedule of Investments • Used to supplement investment holdings for unaffiliated investments • Industry Entry Points (GAAP) • Commercial and Industrial • Banking and Savings Institutions • Brokers and Dealers • Insurance • Real Estate

  6. Types of Taxonomies - SEC • Non-GAAP • Record of Credit Rating Taxonomy • U.S. Mutual Fund Risk/Return Taxonomy • Management Reports • Management Discussion and Analysis • Document and Entity Informaiton

  7. Discoverable Taxonomy Set Source:

  8. XBRL Taxonomies

  9. Linkbases • Label • elements are connected to human readable labels • Presentation • How elements appear • Calculation • How elements are used in calculations • Definition • Pre-defined or self-defined relationships between elements.

  10. Source: Charlie Hoffman, http://xbrl.squarespace.com/journal/2009/6/21/high-level-model-of-xbrl.html

  11. For each fact • Attributes include: • What entity is the data for (contextRef) • What period of time is the data for (contextRef) • What currency is being reported (UnitRef) • What precision is the currency in (decimals) • Which taxonomy is the fact defined in (namespace prefix)

  12. XBRL Instance Document Structure • Root Element • NameSpace Declarations • References • Schema Declarations • Context • Who’s financial data • What Period • Unit • Currency • Shares • Items • Elements of the Financial Statement

  13. 1. Root Element • Element Name = xbrl • All namespace declarations • XBRL usually will contain many • xmlns:us-gaap=“http://xbrl.fasb.org/us-gaap/2013” • xmlns:link=“http://www.w3.org/2003/linkbase” • xmlns:xbrli=“http://www.xbrl.org/2003/instance” • xmlns:xlink=“http://www.w3.org/1999/xlink” • xmlns:iso4217=“http://www.xbrl.org/2003/iso4217 “ <xbrli:xbrl xmlns:us-gaap ... xmlns:link ... xmlns:xbrli .... xmlns:xlink>

  14. XBRL Namespaces • xbrli • Content and structure of XBRL instance • link • Content and structure of linkbases • iso4217 • Standard currency codes • xlink • Xlink schema • US GAAP taxonomy

  15. us-gaap Taxonomy • Was maintained by XBRL-US organization • Now maintained by FASB • Namespaces and Schema URI’s

  16. 2. schemaRef element • Used to link a taxonomy schema to the instance document • Must be at least one Taxonomy Reference used to validate the Instance Document • First Child Element • schemaRef • Attributes: • xlink:type=“simple” • xlink:href=“URI” • <link:schemaRef xlink:type=“simple” xlink:href=“http://xbrl.fasb.org/us-gaap/2013/elts/us-gaap-std-2013-01-31.xsd”/>

  17. 3. Context • Element Name = Context • id attribute • Used later to associate meta-data with financial reporting item • Can be anything, but must start with a letter • Like a namespace prefix <xbrli:context id=“WhateverYouWant”> • Complex element with 4 parent elements • Entity • Uniquely identifies the entity • Period • Instant • Duration • Scenario • What types of facts • Actual, Restated, Budgeted, etc. • Segment • Information about segment being reported

  18. 3a. Context: Entity element • Entity (Parent Element) • Identifier (Child Element) • (attribute) scheme • Depends on reporting purpose • SEC identifier, NYSE symbol, etc. <xbrli:entity> <xbrli:identifier scheme=“http://www.sec.gov/CIK”>SEC CIK id</xbrli:identifier> </xbrli:entity>

  19. 3b. Context: Period Element • <xbrli:period> • <xbrli:instant>2007-11-06</xbrli:instant> or... • <xbrli:startDate>2007-01-01</xbrli:startDate> • <xbrli:endDate>2007-12-31</xbrli:endDate>or... • <xbrli:forever> data</xbrli:forever> • </xbrli:period> • Must use yyyy-mm-dd format

  20. 4. Unit • Unit (Parent Element) • id attribute • Used as a reference • Can be anything, usually logical & human readable • Measure element (child element) • Value describing unit of measure • USD • EUR • JPY • xbrli:shares

  21. 4. Unit: Unit of Measurement code • Currency <xbrli:unit id=“USD” <xbrli:measure>iso4217:USD</xbrli:measure> </xbrli:unit> • Shares <xbrli:unit id=“shares”> <xbrli:mesure>xbrli:shares</xbrli:measure> </xbrli:unit>

  22. Unit for Per Share Value <xbrli:unit id=“EPS”> <xbrli:divide> <xbrli:unitNumerator> <xbrli:measure>iso4217:USD</..> </xbrli:unitNumerator> <xbrli:unitDenominator> <xbrli:measure>xbrli:shares</..> </xbrli:unitDenominator> </xbrli:divide> </xbrli:unit>

  23. 5. Items • Single Fact being reported • Element name comes from US GAAP taxonomy • Determine element names from viewer • Attributes • contextRef (points to context id for fact being reported) • unitRef (points to unit id for fact being reported) • decimals • Instance document fact attribute used to express the number of decimal places to which numbers have been rounded. • or precision • How many digits are significant • label • How should the element be named in report* *When doing homework for chapter 4 use the label attribute

  24. Decimal Attribute Source: http://www.xbrlwiki.info/index.php?title=Best_Practices_on_Data_Definitions

  25. All together <?xml version=“1.0”?> <xbrli:xbrl xmlns:...> <link:schemaRef xlink:... Point to schema> <xbrli:context id=.....> <xbrli:entity> <xbrli:period> <xbrli:unit id=.....> <xbrli:measure> <us-gaap:financial statement items> .... </close tags>

  26. Source: Charlie Hoffman, http://xbrl.squarespace.com/journal/2009/6/22/xbrl-instance-graphic.html

  27. Footnote Tagging

  28. Footnote Tagging • Four Levels: • As of June 2013 all companies are required to include all 4 levels • Each Footnote disclosure is required to have a contextRef for the entire reporting period (<StartDate> <EndDate>) • Level 1 • Block Tagging • Each complete footnote along with formatting is tagged within XBRL Instance • Level 2 • Tag each accounting policy within the Significant Accounting Policies footnote, along with formatting • Level 3 • Tag each table, along with its formatting • Level 4 • Tag each monetary value, % and number in the footnotes.

  29. Level 3 – 3m Goodwill Note3 • <us-gaap:GoodwillAndIntangibleAssetsDisclosureTextBlock contextRef="D2010Q3YTD"></us-gaap:GoodwillAndIntangibleAssetsDisclosureTextBlock> • The rest of the footnote • This is what the footnote looks like

  30. Level 4 – 3M • Note 3: • Purchased goodwill related to the five acquisitions which closed in the first nine months of 2010 totaled $43 million, less than $1 million of which is deductible for tax purposes. The acquisition activity in the following table also includes the impacts of contingent consideration for pre-2009 acquisitions, which increased goodwill by $1 million. The amounts in the “Translation and other” column in the following table primarily relate to changes in foreign currency exchange rates. The goodwill balance by business segment as of December 31, 2009 and September 30, 2010, follow:

  31. 3M’s Goodwill Note 3 (Level 4) • Note 3: • Purchased goodwill related to the five acquisitions which closed in the first nine months of 2010 totaled $43 million, less than $1 million of which is deductible for tax purposes. The acquisition activity in the following table also includes the impacts of contingent consideration for pre-2009 acquisitions, which increased goodwill by $1 million. The amounts in the “Translation and other” column in the following table primarily relate to changes in foreign currency exchange rates. The goodwill balance by business segment as of December 31, 2009 and September 30, 2010, follow:

  32. 3M’s XBRL (Level 4) <us-gaap:GoodwillAcquiredDuringPeriod contextRef="D2010Q3YTD" decimals="-6" unitRef="USD">43000000</us-gaap:GoodwillAcquiredDuringPeriod> <us-gaap:BusinessAcquisitionPurchasePriceAllocationGoodwillExpectedTaxDeductibleAmount contextRef="I2010Q3" decimals="-6" unitRef="USD">1000000</us-gaap:BusinessAcquisitionPurchasePriceAllocationGoodwillExpectedTaxDeductibleAmount> <us-gaap:GoodwillAllocationAdjustment contextRef="D2010Q3YTD" decimals="-6" unitRef="USD">1000000</us-gaap:GoodwillAllocationAdjustment>

  33. 3M Table • Goodwill table from footnote

  34. Beginning Balances (2009) <us-gaap:Goodwill contextRef="I2009_IndustrialAndTransportationMember" decimals="-6" unitRef="USD">1783000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2009_HealthCareMember" decimals="-6" unitRef="USD">1007000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2009_ConsumerAndOfficeMember" decimals="-6" unitRef="USD">155000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2009_DisplayAndGraphicsMember" decimals="-6" unitRef="USD">990000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2009_SafetySecurityAndProtectionServicesMember" decimals="-6" unitRef="USD">1220000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2009_ElectroAndCommunicationsMember" decimals="-6" unitRef="USD">677000000</us-gaap:Goodwill>

  35. Acquisition Activity (2010) <mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments contextRef="D2010Q3YTD_IndustrialAndTransportationMember" decimals="-6" unitRef="USD">8000000</mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments> <mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments contextRef="D2010Q3YTD_HealthCareMember" decimals="-6" unitRef="USD">1000000</mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments> <mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments contextRef="D2010Q3YTD_ConsumerAndOfficeMember" decimals="-6" unitRef="USD">24000000</mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments> <mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments contextRef="D2010Q3YTD_SafetySecurityAndProtectionServicesMember" decimals="0" unitRef="USD">11000000</mmm:GoodwillAcquiredDuringPeriodAndAllocationAdjustments>

  36. Translation and Other <us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments contextRef="D2010Q3YTD_IndustrialAndTransportationMember" decimals="-6" unitRef="USD">15000000</us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments> <us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments contextRef="D2010Q3YTD_HealthCareMember" decimals="-6" unitRef="USD">-11000000</us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments> <us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments contextRef="D2010Q3YTD_ConsumerAndOfficeMember" decimals="-6" unitRef="USD">6000000</us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments> <us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments contextRef="D2010Q3YTD_DisplayAndGraphicsMember" decimals="-6" unitRef="USD">4000000</us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments> <us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments contextRef="D2010Q3YTD_SafetySecurityAndProtectionServicesMember" decimals="-6" unitRef="USD">26000000</us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments> <us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments contextRef="D2010Q3YTD_ElectroAndCommunicationsMember" decimals="-6" unitRef="USD">-17000000</us-gaap:GoodwillTranslationAndPurchaseAccountingAdjustments>

  37. Ending Balance (2010) <us-gaap:Goodwill contextRef="I2010Q3_IndustrialAndTransportationMember" decimals="-6" unitRef="USD">1806000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2010Q3_HealthCareMember" decimals="-6" unitRef="USD">997000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2010Q3_ConsumerAndOfficeMember" decimals="-6" unitRef="USD">185000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2010Q3_DisplayAndGraphicsMember" decimals="-6" unitRef="USD">994000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2010Q3_SafetySecurityAndProtectionServicesMember" decimals="-6" unitRef="USD">1257000000</us-gaap:Goodwill> <us-gaap:Goodwill contextRef="I2010Q3_ElectroAndCommunicationsMember" decimals="-6" unitRef="USD">660000000</us-gaap:Goodwill>

  38. Extension Taxonomies • SEC Requires filers to use an extension taxonomy • Includes only those elements that a company uses for their financial reporting • Naming Convention • Shortcompnayname:ccyy-mm-dd

  39. Extension Taxonomies • Extending XBRL • New element names • Each Company has its preferred • Line Item Name • Hierarchy of line items on the F/S • Unique items that do not correspond to an element in the taxonomy • Items 1 & 2 do NOT impact comparability and reuse

  40. SEC Extension Taxonomy Rules • Follow U.S. GAAP taxonomy whenever possible • If you don’t see an element in the F/S section, look in the disclosures • If you don’t like the label, use the U.S. GAAP element anyway and add a label to the label linkbase (i.e. don’t make up elements because you don’t like the label) • For footnotes use proper tags for respective levels

  41. Taxonomy Viewer Tutorial

  42. The Taxonomy Viewer • Use to find element names to use for tagging data and disclosures • There are 16,000+ elements! • Financial Statement and Disclosures • In choosing an element: • Choose the element with the narrowest definition of the fact you are reporting • If more than one element is available use the element that is part of the financial statement vs. a disclosure element • If using a disclosure element, use software to move it as a financial statement line element. • Types of elements: • Abstract – do not use as a tag in instance doc. • Financial Reporting Concepts • For each element (not abstract items) • Labels • Standard • Documentation • Total • References • To authoritative literature • Properties • Element name • Namespace • Type (monetary, shares, etc.) • Normal Balance (debit or credit) • Time (instant or period)

  43. Taxonomy Viewer Parts

  44. Taxonomy Viewer Information

  45. Linkbase Examples

  46. Reference Linkbase <reference xlink:type="resource"   xlink:role="http://www.xbrl.org/2003/role/presentationRef"   xlink:label="CashFlowsFromUsedInOperationsTotal_ref">        <ref:Name>IAS</ref:Name>        <ref:Number>7</ref:Number>        <ref:Paragraph>14</ref:Paragraph> </reference> <reference xlink:type="resource"   xlink:role="http://www.xbrl.org/2003/role/measurementRef"   xlink:label="CashFlowsFromUsedInOperationsTotal_ref">       <ref:Name>IAS</ref:Name>       <ref:Number>7</ref:Number>       <ref:Paragraph>18</ref:Paragraph>       <ref:Subparagraph>a</ref:Subparagraph> </reference>

  47. Label Linkbase

  48. Presentation Linkbase • uses parent-child relations to organize elements • Assets • Current • Cash • Receivables • Accounts • Interest • Inventory • Long-Term • Property, Plant and Equipment • Intangible Assets • Notes Receivable • The “order” attribute of the presentationArc specifies the order in which child concepts should appear with respect to their sibling concepts.

  49. Marathon Oil Presentation <link:locxlink:href="http://xbrl.us/us-gaap/1.0/elts/us-gaap-2008-03-31.xsd#us-gaap_DueFromRelatedPartiesCurrent" xlink:label="lbl_DueFromRelatedPartiesCurrent" xlink:type="locator"/> <link:presentationArc order="23.3" xlink:arcrole="http://www.xbrl.org/2003/arcrole/parent-child" xlink:from="lbl_AssetsCurrentAbstract" xlink:to="lbl_DueFromRelatedPartiesCurrent" xlink:type="arc"/> <link:locxlink:href="http://xbrl.us/us-gaap/1.0/elts/us-gaap-2008-03-31.xsd#us-gaap_CashAndCashEquivalentsAtCarryingValue" xlink:label="lbl_CashAndCashEquivalentsAtCarryingValue" xlink:type="locator"/> <link:presentationArc order="21.0" xlink:arcrole="http://www.xbrl.org/2003/arcrole/parent-child" xlink:from="lbl_AssetsCurrentAbstract" xlink:to="lbl_CashAndCashEquivalentsAtCarryingValue" xlink:type="arc"/> http://snipr.com/lc15r [www_sec_gov]

More Related