Data Sources in Financial Modeling
Collecting and using the right data sources in financial modeling is crucial to the success of financial analysis. Financial modeling requires gathering and analyzing lots of information; the collection of data is a crucial step in creating a financial model. There is a wide range of data that must be used in a financial model. A company’s historical results are the key input to prepare a three-statement model, which is the setup for all other financial models.
Management discussion and analysis from corporate filings, industry reports, and research reports of professional analysts are some of the resources that may improve the accuracy of your forecasting assumptions. Finally, you need to find the appropriate inputs for your valuation. Knowledge of relevant data sources is critical for an analyst to develop a precise and up-to-date model.
Data sources: Company reports and regulatory filings
Governments place special attention on public companies. There are mandatory reporting standards for public companies that are regulated by government entities.
Due to its nature, a public company bears a responsibility to its shareholders. Governments regulate the actions of public companies through mandatory reporting requirements and standards. In accord with existing legislation, public companies must disclose all material information about their operations and performance to the public.
Companies must prepare an annual report to the shareholders, in which corporate information is disclosed. These reports include financial data, results of operations, market segment information, new product plans, subsidiary activities, and research and development activities. The annual reports to shareholders are usually posted on the company’s website.
In the United States, the primary regulatory entity is the Securities and Exchange Commission (SEC). Public companies must submit their filings to the SEC on a regular basis. SEC filings are comprehensive documents that include fundamental information about the company and its operations. For the purpose of financial modeling, the most relevant filings for an analyst are:
|Registration Statements||A description of the company’s properties and business; a description of the security to be offered for sale; information about the management of the company; financial statements certified by independent accountants|
|10-K||Annual report outlining a comprehensive overview of the company’s business and financial condition. 10-K includes audited financial statements.|
|10-Q||Quarterly report with a continuing view of the company’s financial position during the year. 10-Q includes unaudited financial statements.|
|8-K||Report of current events to announce major events that shareholders should know about.|
|Schedule 13-D||Reports acquisition of beneficial ownership of more than 5% of a voting class of a company’s equity securities by a person or a group of persons.|
|Proxy Statements||Statements filed by companies prior to shareholders meetings to provide shareholders with information necessary to make informed decisions.|
|Form 3||Filed by the corporate insiders (company’s officers and directors) who are registering equity securities for the first time.|
|Form 4||Filed after a material change in the holdings of company insiders.|
|Form 5||Filed by an insider who conducted insider transactions during the year that were not previously reported in a Form 4.|
All the submitted filings may be retrieved from the EDGAR database maintained by the SEC.
In Canada, public companies follow a similar process to that of US-based public companies. Even though the Canadian system of securities regulation is not unified, and each province has its own regulatory entity, there is a single database (SEDAR) that contains all the forms filed by the publicly traded companies across the country. The U.S. and Canadian filings comparison is provided in the table below:
|U.S. Filings||Canadian Filings|
|10-K||Annual Report, Annual Information Form, Management Proxy Circular|
|10-Q||Interim Financial Statement|
|8-K||Material Change Report|
In the U.K., all publicly traded companies (Public Limited Companies or PLC’s) must submit required filings to Companies House, which is a registrar of the companies. On the Companies House website, you can find the database of the filings submitted by companies registered in the U.K. The companies submit annual reports, statements of annual return, and announcements of major events.
In Japan, one of the largest financial markets in Asia, the regulation of public companies is very strict. Every public company must comply with the Financial Instruments and Exchange Act and submit its financial statements, internal control reports, and quarterly reports, audited by CPAs, to the Financial Services Agency (FSA). The FSA is a Japanese government agency and regulator of the country’s financial system. Companies provide the necessary filings to FSA online, through the EDINET system. This system is available online to the public.
Data sources: Financial databases
Companies such as Bloomberg, Capital IQ, and Thompson Reuters provide powerful databases of financial data. These databases provide access to various types of financial information, including historical financials from financial statements. Financial databases allow you to analyze the historical data and easily export the data into Excel. However, financial statements retrieved from these databases tend to be in a standardized format. Thus, if the company uses an accounting system unique to its business operations, you will not grasp it from data retrieved and that will affect your analysis.
Nevertheless, financial databases are great sources of various types of data that can be helpful in financial modeling. Key economic factors, M&A transactions, comparables analysis, analysis of securities – including equities, bonds, and derivatives, and reports of analysts are some of the many useful tools that may be used in financial modeling.
CFI is the official provider of the Financial Modeling & Valuation Analyst designation and on a mission to help you advance your career. To continue learning and developing your skills, these additional free CFI resources will be helpful: