330 likes | 462 Views
XBRL: "Exchanging Business Information" 9 th XBRL International Conference. Leveraging XBRL Technology to Improve the Transparency of Financial Information. Don Inscoe Associate Director FDIC Statistics Branch May 12, 2004. Auckland, New Zealand. Topics. Background for XBRL-enabled change
E N D
XBRL: "Exchanging Business Information"9th XBRL International Conference Leveraging XBRL Technology to Improve the Transparency of Financial Information Don Inscoe Associate Director FDIC Statistics BranchMay 12, 2004 Auckland, New Zealand
Topics • Background for XBRL-enabled change • Evidence that demand for information increases as it becomes more timely • Measuring the time value of information • Easier access to information boosts demand
Background • U.S. bank regulators have collected financial information from banks for 70+ years, please seehttp://www2.fdic.gov/hsob/Milestone.asp?EntryTyp=40for information on how information collections have evolved • Banks are “called upon” each quarter to submit financial reports to regulators • Bank financial statements “Call Reports” have been published on www.fdic.gov since 1998 • Data is available in interactive analytical format back to 1992, www2.fdic.gov/sdi • Agencies have electronic databases back to 1972
Today’s Call Report • Nearly 8,400 banks file each quarter • Most banks are required to file reports within 30 days • Each report contains approximately 1,200 variables • The agencies apply about 1,100 tests “edits” to each report to correct errors before publication • More detailed information filed by large and complex banks
Call Report modernization • FFIEC (Federal Financial Institutions Examination Council) Call Report agencies: • FDIC (Federal Deposit Insurance Corporation) • FRB (Federal Reserve Board) • OCC (Office of the Comptroller of the Currency) • What is being created? • CDR (Central Data Repository) • Collection, validation and distribution of Call Report data submitted by banks
Call Report modernization (con’t) • When will it go into effect? • Implementation is planned for the Submission of Call Report data for September 30, 2004 • How will it work? • Call vendors receive XBRL taxonomies from FFIEC • Vendors write collection software • Banks complete Call Reports and file data to FFIEC via Internet
Call Report modernization (con’t) • What benefits are expected from the XBRL-enabled system? • Banks will submit more accurate Call Reports • Agency's mechanical review replaced by more strategic process to identify and improve reporting • Information released sooner and in more useful formats • Easier to make changes, add new data series • Development of new products enabled by more timely data disclosed in open extensible standard
Data users • Public access of Call Report data serves wide spectrum of interests • Users include: banking personnel, investors, corporate treasury managers, news organizations, public policy leaders, academic researchers . . . • Common thread among all is interest in most current possible insight into the financial state of banks and thrifts
Banks’ financial data • Bank Call Report data typifies many classes of information where “fresher” is more useful • The data in these reports is then released to the public • Nearly 8,400 FDIC-insured banks reported at the end of 2003
The demand for information increases as it becomes more timely • Before 2003, Call Reports were not released until all reports had been submitted and edited by regulators • Reports were held until agencies analyzed data and issued press releases • Reports were not released until about 65 days after the quarter ending date • Last year, the process was changed so that reports are released in weekly batches, so almost all reports are now published within 50 days after the quarter ends
Agencies receive most Call Reports within 30 Days… Thisgraph shows the cumulative number of Call Reports received each day after the report date – most are received within 30 days.
… then it takes 30 more days to edit and publish all reports Agencies must resolve edit exceptions before Call Reports are published.
WebTrends shows more users obtaining more data… Three month moving average number of hits to data pages and number of users
… and use increases when new data is posted to website • Interest peaks just before and just after initial release • Bulk Call Report release (3Q02) typified by increased access activity over moderate time span • Staggered Call Report release (3Q03) shows higher, but more irregular use
Demand for Call Reports declines as they become older Number of Hits 180,000 160,322 Hits Both lines indicate use of most-recent and prior quarter Call Reports; note that hits diminished from 160,000 (September 2003 Call) to fewer than fewer than 2,000 (1998) 90,000 “Hits” reflect use of most-recent and prior quarter reports, note that hits diminish sharply as data ages, but year-end data always has higher use 51,269 30,000 ~ ~ ~ ~ ~ ~ 10,000 8,000 6,000 “Unique” = IP Addresses 4,000 2,000 Unique 0 Sep. Mar. Jun. Dec. Mar. Jun. Dec. Mar. Jun. Dec. Mar. Jun. Dec. Mar. Jun. Dec. Mar. Jun. Sep. Sep. Sep. Sep. Sep. 1998 1999 2000 2001 2002 2003
Measuring the time value of information • Thenew XBRL-enabled process will allow banks to fix data problems before they submit their report • This enhanced business process will enable regulators to release data just after it is received • Reports can be published “straight through processing” sooner after receipt, thereby improving timeliness • Analytical model uses WebTrends statistics to provide a relative measure of how the value of information diminishes as information becomes dated (or “stale”)
When CDR is implemented, all Call Reports will be released within 30+ days (blueline) in contrast to 50+ days in current system (green line)
Time value of the data • Given users’ interest in timely data, its value to them declines as time passes • This value reaches a minimum immediately prior to the next quarterly release • User’s interest over the course of a typical quarter is illustrated in the following
Use of FDIC’s Call Report website Data page hits usually drop sharply within 3 – 4 weeks after new Call Report data is published
Rationales for modeling time value • Provides generalized basis for evaluating website use data • Smoothes out variations and artifact observed in website access • Can be independent of particular metric used to measure website use (hits, visits, unique IP addresses, etc.) • Can quantify benefits vs. costs of changes
Modeling assumptions • Value of multi-quarter repository peaks immediately after new quarter of data is added • This value declines continuously, reaching a minimum immediately before the next quarter’s update • Residual value of historical data is small compared to that of current quarter
Other modeling and fitting assumptions • Between updates, value is lost continuously as time passes • Rate of value loss is proportional to current value (fresh data loses value more quickly than stale data) • User interest in accessing website provides appropriate empirical observations of data’s inherent value
Model form • Assumptions described previously lead to exponential model to measure the change in data’s value over the quarter • Model is: V(t) = V0e-Kt + Vres where V(t) is the value of the repository at time, t V0 is the change in value between updates Vresis the residual value of the repository just before an update “e” is the exponential function (2.731…) K is the decay rate (“reciprocal lifetime”)
Model will estimate value gained by efforts to make data more timely • will measure improvement when data is published sooner (“straight-through processing”) • details to be provided at XBRL International presentation
Future strategies • CDR replaces current Call Report collection process • CDR implementation targeted for September 2004 Call Report • Data to be published immediately after receipt (once we are comfortable with the new CDR) • Call Report taxonomy to published using open BASI (Bank and Savings Institutions) standard • Open standard mapped to legacy taxonomy (facilitates data sharing among different users and data sources)
FDIC Call Report concepts for “Cash and Balances Due” vary by form FFIEC Call Report data has been published using Federal Reserve “MDRM” data element names since the early 1980’s Equivalent items can have different prefixes RCON Prefix: RCFD
Equivalent BASI Concepts for “Cash and Balances Due” do not vary Call Reports and BASI have a number of common concepts
Taxonomy tagging: map common concepts to enable comparisons of Call Reports with other GAAP sources XBRL Banking and Savings Institutions Taxonomy Cash and Balances Due FFIEC 031 Call Report Cash and Balances Due FFIEC 041 Call Report Cash and Balances Due
Common concepts can be mapped using FDIC and BASI labels to support legacy systems and enable comparison with other GAAP supply sources Example shows how “Cash and Balances due” taxonomy provides link between different standards
Taxonomy tagging XBRL Banking and Savings Institutions Taxonomy Cash and Balances Due FFIEC 041 Call Report Cash and Balances Due FFIEC 031 Call Report Cash and Balances Due