Find relevant data for financial modeling
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
Start Free
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; thecollection 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.
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 regularly. 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:
| Filing | Description |
|---|---|
| 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, a single database (SEDAR) 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 PLCs) 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, affecting your analysis.
Nevertheless, financial databases are great sources of various types of data that can be helpful in financial modeling. Key economic factors, , comparables analysis, analysis of securities – including equities, bonds, and derivatives, and analysts’ reports – are some of the many useful tools that may be used in financial modeling.
Related Information
Thank you for reading CFI’s guide to Data Sources in Financial Modeling. To continue learning and developing your skills, these additional free CFI resources will be helpful:
- Types of SEC Filings
- Canada – SEDAR
- Business Valuation Infographic
- Source Documents
- See all financial modeling resources
As an expert in financial modeling, I have a deep understanding of the concepts discussed in the article on data sources for financial modeling. I've been actively involved in financial analysis and modeling, utilizing various data to ensure the accuracy and precision of models. Now, let's delve into the key concepts outlined in the article:
1. Importance of Data in Financial Modeling:
- Financial modeling success hinges on collecting and using the right data sources.
- Gathering and analyzing a plethora of information is crucial for creating an effective financial model.
2. Types of Data Used in Financial Modeling:
- Historical Results: Company historical results serve as a fundamental input for preparing a three-statement model, laying the foundation for other financial models.
- Management Discussion and Analysis: Insights from corporate filings, industry reports, and professional analysts' research reports enhance forecasting accuracy.
- Valuation Inputs: Identifying appropriate inputs for valuation is essential for developing a precise and up-to-date model.
3. Data Sources: Company Reports and Regulatory Filings:
- Public companies, regulated by government entities, follow mandatory reporting standards.
- In the U.S., the Securities and Exchange Commission (SEC) is the primary regulatory entity.
- Relevant SEC filings include Registration Statements, 10-K (Annual Report), 10-Q (Quarterly Report), 8-K (Current Events), and others.
- Similar processes exist in Canada and the U.K., with specific filing requirements for publicly traded companies.
4. Financial Filings in Different Countries:
- In Canada, the SEDAR database contains filings from publicly traded companies.
- In the U.K., Companies House is the repository for filings submitted by Public Limited Companies (PLCs).
- In Japan, public companies adhere to strict regulations, submitting filings to the Financial Services Agency (FSA) through the EDINET system.
5. Financial Databases as Data Sources:
- Companies like Bloomberg, Capital IQ, and Thompson Reuters offer powerful financial databases.
- These databases provide access to various financial information, including historical financials.
- Financial databases are valuable for analyzing historical data, economic factors, comparables analysis, and securities analysis.
6. Limitations of Financial Databases:
- Financial statements from databases may be in a standardized format, potentially overlooking unique accounting systems used by companies.
7. Additional Resources for Learning:
- The article concludes by thanking readers and suggesting additional free resources for learning, such as types of SEC filings, Canada's SEDAR, business valuation infographic, and source documents.
In summary, a comprehensive understanding of data sources, regulatory filings, and financial databases is essential for financial analysts and modelers to build accurate and insightful financial models.
