Title: XBRL Formula
1XBRL Formula
- December 6th, 2006
- 130pm EST
- Jon Wisnieski Mark Montoya
- Federal Deposit Insurance Corporation
- (FDIC)
2Why XBRL formulas?
- Data consistency
- - Simple calculations
- - Advanced calculations
- Data exchange with software vendors
- - Word and Excel documents
- Limitation of XBRL calculations
- - Required more than basic summations
3Does XBRL solve the problem?
- Central Data Repository (CDR)
- - XBRL as standard for data exchange
- - Meta data source (taxonomy)
- the XBRL data model
- - XML
- - XLink
- Unique process for formulas
- - Process model
- - Additional guidance for software vendors
4Main Presentation
- Formula Types
- From simple to advanced
- Formula Use
- Multiple levels
- Future Work
- Legacy formulas to event-driven formulas
- Summary
- Process model
-
5 Formula Types
Hard Fast ..items must not be
negative Consistency - Data within same
period - Prior period data
Characteristic Financial data provides
patterns through time
6 Formula Use
Meta Data Testing Testing and
verification before publishing Vendor Level
Software incorporates taxonomy formulas
Institution Level Through software,
institution initiates validation CDR Level
Same taxonomy formulas are used for
validation
7Summary
XBRL formula do work and addressed FDICs
business needs - Data exchange - Data
consistency - More advanced calculations
8 Future Work
Inter-Series Formula Across financial
reports Uniform Business Performance Report
(UBPR) Ratios based on peer groups Event
Driven Formula Based on current or prior
event
9Jon Wisnieski
- email - jwisnieski_at_fdic.gov
- office - (1) 202-898-3846
Mark Montoya
email - mmontoya_at_fdic.gov office - (1)
202-898-3829