analysis of financial data may 15, 2012 this presentation has been prepared to help constituents...
TRANSCRIPT
![Page 1: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/1.jpg)
Analysis of Financial Data
May 15, 2012
This presentation has been prepared to help constituents understand the current status of projects of the FASB. The views expressed in this presentation are those of the presenter. Official positions of the FASB and the IASB are reached only after extensive due process and deliberations.
![Page 2: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/2.jpg)
Analysis of Financial Data
2
![Page 3: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/3.jpg)
Number of companies filed– Almost 10,000
Number of filings– Over 33,000
Fact values reported– 18 million facts
All (except for filers using IFRS) will be detail tagging with June 2012 filing
Current State – XBRL
3
![Page 4: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/4.jpg)
XBRL Data Consumption
Various tools for analysis Use of data – internal (filer)− Peer group comparisons− Acquisition targets− Company trends Use of data – external− Buy/sell decisions− Data collection− Research
4
![Page 5: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/5.jpg)
Consistency Suite
5
![Page 6: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/6.jpg)
Consistency Suite (C Suite) is an XBRL database of SEC-submitted filings, maintained by XBRL US
Updated shortly after each filing is submitted to the SEC Free tool for use for anyone with a FAF, FASB or GASB
email account Site Address:- http://xbrl.us/research/pages/Csuite.aspx
Consistency Suite
6
![Page 7: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/7.jpg)
Tools for Analysis
7
![Page 8: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/8.jpg)
XBRL Data Example 1 - XBRL US Tool
2010 filings - Debt by SIC Code
8
![Page 9: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/9.jpg)
XBRL DataExample 1 – XBRL US Tool
2011 filings - Debt by SIC Code
9
![Page 10: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/10.jpg)
XBRL Data Example 1 - XBRL US Tool
Data for financial sector further disaggregated
10
![Page 11: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/11.jpg)
XBRL Data Example 2 - XBRL US Tool
2010 filings - Revenue for retail trade sectorWal-Mart has $408,085,000,000 of the $1,894,815,271,079 total for retail trade (22%)
11
![Page 12: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/12.jpg)
XBRL Data Example 2 - XBRL US Tool
2011 filings - Revenue for retail sector, total revenue for sector increased 6% over prior year
Wal-Mart has $421,849,000,000 of the $2,023,911,506,915 total for retail trade (21%), increased 3% over prior year
12
![Page 13: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/13.jpg)
XBRL to XL Example 3
13
![Page 14: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/14.jpg)
XBRL to XL Example 3
14
![Page 15: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/15.jpg)
XBRL to XL Example 3
15
![Page 16: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/16.jpg)
CalcbenchExample 4
16
![Page 17: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/17.jpg)
Issue: Expected Return on Pension Assets
17
![Page 18: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/18.jpg)
715-20-50-1(k)(3)
US GAAP Codification
18
![Page 19: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/19.jpg)
Link to the UGT
19
![Page 20: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/20.jpg)
Getting to the US GAAP Taxonomy (UGT)
20
![Page 21: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/21.jpg)
Getting to the UGT
21
![Page 22: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/22.jpg)
Getting to the UGT
22
![Page 23: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/23.jpg)
Searching the UGT
23
![Page 24: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/24.jpg)
Navigating the UGT
24
![Page 25: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/25.jpg)
Key: Element Name
25
![Page 26: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/26.jpg)
Log in
26
![Page 27: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/27.jpg)
Run Query
27
![Page 28: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/28.jpg)
Results Exported to Excel
28
![Page 29: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/29.jpg)
Results - Table
2008 2009 2010 2011 2012Average 7.74% 7.49% 7.34% 7.08% 7.23%
Median 8.00% 8.00% 7.75% 7.50% 7.50%
Mode 8.00% 8.00% 8.00% 8.00% 7.50%
Max 12.30% 12.30% 15.00% 14.25% 9.20%
Min 2.50% 1.40% 0.40% 0.24% 3.00%
Count 379 1126 1309 1288 57
29
![Page 30: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/30.jpg)
Fair Value Option
30
![Page 31: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/31.jpg)
Fair Value Option
31
![Page 32: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/32.jpg)
If You Click on the Element in the Cod:
32
![Page 33: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/33.jpg)
Highlight the Element Name & Copy
33
![Page 34: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/34.jpg)
Search for element in the UGT
34
![Page 35: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/35.jpg)
Returns Element
35
![Page 36: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/36.jpg)
C Suite Search Results
36
![Page 37: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/37.jpg)
Standard Setting Considerations
37
![Page 38: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/38.jpg)
We are in a paradigm shift from print/PDF to electronic data, but …
- The “narrative” is still grounded in presentation
- Many still use print statements
- Many requirements are set in SEC Rules
Our aim is to shift the narrative more towards electronic data to better anticipate change
Transforming Financial Reporting
38
![Page 39: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/39.jpg)
Three key dimensions- Presentation- Relationships, disaggregation, recognition- Metadata/attributes
XBRL changes the geography question
39
![Page 40: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/40.jpg)
69. Upon initial recognition of the receivable, any difference between the measurement of the receivable in accordance with Topic 310 and the corresponding amount of revenue recognized shall be presented in profit or loss as a separate line item adjacent to the revenue line item. If the contract does not have a significant financing component in accordance with paragraph 58, an entity shall present any impairment of the receivable (or change in the measurement of an impairment) in profit or loss as a separate line item adjacent to the revenue line item.
Revenue Recognition (Topic 605) Proposed Accounting Standards Update (Revised)
40
![Page 41: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/41.jpg)
OCI - Potential Classification Models
Degree of Persistence Core / Non-core Management Control (Stewardship) Remeasurements Degree of Measurement Uncertainty Time Horizon until Realization Operating v. Investing & Financing Other?
Instead of classifying, could we just provide the attributes?
41
![Page 42: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/42.jpg)
Organization, Formatting, and Style
The Board indicated that a Discussion Paper would present a number of ways that a reporting entity could organize information within the notes to the financial statements. Organization of information would not only apply to the ordering of individual notes but also to the information within each note.
The Discussion Paper also would provide ideas pertaining to the formatting and style of information in the notes with the intent of establishing clear communication of the information that an entity provides.
Disclosure Framework
42
![Page 43: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/43.jpg)
The project will include ways reporting entities can improve the organization and formatting of their disclosures
Organization would not only apply to the order of the notes but to the order of the information within the notes
Discussion paper will include guidance pertaining to:
• Referencing/cross-referencing
• Use of headings and tables
• Entity specific disclosures
Organization and Formatting
43
![Page 44: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/44.jpg)
Encourage tabular disclosures over narrative
Deemphasize presentation centric view Identify key attributes that should be
disclosed and consider how we can shape the outcome using XBRL
Taking advantage of XBRL
44
![Page 45: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/45.jpg)
A song on iTunes is to an ‘album’ what cash is to assets.
If people no longer buy albums and only buy the songs, what does that mean for assets?
Final thoughts
45
![Page 46: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/46.jpg)
“David Weinberger attacks the complexity of the real world, not by making it simple, but by making it clear. Once he explains how things can be in more than one place at a time-and make sense-you’ll never look at a humble bookshelf or store shelf the same way again.”
-- Esther Dyson, author of Release 2.0
www.everythingismiscellaneous.com
46
![Page 47: Analysis of Financial Data May 15, 2012 This presentation has been prepared to help constituents understand the current status of projects of the FASB](https://reader036.vdocuments.us/reader036/viewer/2022070403/56649f295503460f94c4241a/html5/thumbnails/47.jpg)
QuestionsQuestions
??
47