Item 7. Management’s Discussion and Analysis of Financial Condition and Results of Operations
91K characters. Original on sec.gov · Markdown
Item 7. Management’s Discussion and Analysis of Financial Condition and Results of Operations
The following discussion should be read in conjunction with our historical financial statements and the related notes included elsewhere in this annual report on Form 10-K, as well as the discussion under “Selected Consolidated Financial Data.” This discussion contains forward-looking statements that involve risks and uncertainties. Our actual results may differ materially from those discussed in or implied by any of the forward-looking statements as a result of various factors, including but not limited to those listed under “Risk Factors” and “Special Note Regarding Forward-Looking Statements.”
We enable our customers to make better decisions about risk, investments, and operations with greater precision, efficiency, and discipline. We also help customers across the globe protect and grow the value of people, property and financial assets. We provide value to our customers by supplying proprietary data that, combined with our analytic methods, creates embedded decision support solutions. We are one of the largest aggregators and providers of data pertaining to U.S. property and casualty, or P&C, insurance risks. We offer predictive analytics and decision support solutions to customers in rating, underwriting, claims, catastrophe and weather risk, global risk analytics, natural resources intelligence, and many other fields. Refer to Item 1. Business for further discussion.
Our customers use our solutions to make better decisions with greater efficiency and discipline. We refer to these products and services as “solutions” due to the integration among our products and the flexibility that enables our customers to purchase components or the comprehensive package of products. These solutions take various forms, including data, statistical models or tailored analytics, all designed to allow our customers to make more logical decisions. We believe our solutions for analyzing risk positively impact our customers’ revenues and help them better manage their costs.
We organize our business in two segments: Decision Analytics and Risk Assessment. Our Decision Analytics segment provides solutions to our customer in insurance, energy and specialized markets, and financial services. Our Decision Analytics segment revenues represented approximately 64.1% and 63.7% of our revenues for the years ended December 31, 2017 and 2016, respectively. Our Risk Assessment segment provides statistical, actuarial and underwriting data for the U.S. P&C insurance industry. Our Risk Assessment segment revenues represented 35.9% and 36.3% of our revenues for the years ended December 31, 2017 and 2016, respectively.
On June 1, 2016, we sold our healthcare business, Verisk Health. Results of operations for the healthcare business are reported as discontinued operations for the year ended December 31, 2016 and for all prior periods presented. See Note 9 of our consolidated financial statements included in this annual report on Form 10-K. As necessary, the amounts have been retroactively adjusted in all periods presented to give recognition to the discontinued operations.
Executive Summary
Key Performance Metrics
We believe our business’s ability to grow recurring revenue and generate positive cash flow is the key indicator of the successful execution of our business strategy. We use year-over-year revenue and EBITDA growth as metrics to measure our performance. EBITDA and EBITDA margin are non-GAAP financial measures (see Note 2 within Item 6. Selected Financial Data section of Management’s Discussion and Analysis of Financial Condition and Results of Operations). The respective GAAP financial measures are net income and net income margin.
Revenue growth. We use year-over-year revenue growth as a key performance metric. We assess revenue growth based on our ability to generate increased revenue through increased sales to existing customers, sales to new customers, sales of new or expanded solutions to existing and new customers, and strategic acquisitions of new businesses.
EBITDA growth. We use EBITDA growth as a proxy for the cash generated by the business. EBITDA growth serves as a measure of our ability to balance the size of revenue growth with cost management and investing for future growth.
EBITDA margin. We use EBITDA margin as a metric to assess segment performance and scalability of our business. We assess EBITDA margin based on our ability to increase revenues while controlling expense growth.
Revenues
We earn revenues through subscriptions, long-term agreements and on a transactional basis, recurring and non-recurring. Subscriptions for our solutions are generally paid in advance of rendering services either quarterly or in full upon commencement of the subscription period, which is usually for one year and automatically renewed each year. As a result, the timing of our cash flows generally precedes our recognition of revenues and income and our cash flow from operations tends to be higher in the first quarter as we receive subscription payments. Examples of these arrangements include subscriptions that allow our customers to access our standardized coverage language, our claims fraud database or our actuarial services throughout the subscription period. In general, we experience minimal revenue seasonality within the business. Our long-term agreements are generally for periods of three to five years. We recognize revenue from subscriptions ratably over the term of the subscription and most long-term agreements are recognized ratably over the term of the agreement.
Certain of our solutions are also paid for by our customers on a transactional basis. For example, we have solutions that allow our customers to obtain property-specific rating and underwriting information to price a policy on a commercial building, or compare a P&C insurance, medical or workers’ compensation claim with information in our databases. We also provide advisory services, which help our customers get more value out of our analytics and their subscriptions. For the years ended December 31, 2017 and 2016, 19.2% and 16.5% of our revenues were derived from providing transactional recurring and non-recurring solutions, respectively. We earn these revenues as our solutions are delivered or services performed. In general, they are billed monthly at the end of each month.
For the years ended December 31, 2017 and 2016, 75.2% and 78.6% of the revenues in our Decision Analytics segment were derived from subscriptions and long-term agreements for our solutions, respectively. For the years ended December 31, 2017 and 2016, 90.8% and 92.0% of the revenues in our Risk Assessment segment were derived from subscriptions and long-term agreements for our solutions, respectively. Our customers in this segment include most of the P&C insurance providers in the U.S.
Principal Operating Costs and Expenses
Personnel expenses are a major component of both our cost of revenues and selling, general and administrative expenses. Personnel expenses, which represented 50.1% and 47.7% of our total expenses for the years ended December 31, 2017 and 2016, respectively, include salaries, benefits, incentive compensation, equity compensation costs, sales commissions, employment taxes, recruiting costs, and outsourced temporary agency costs.
We allocate personnel expenses between two categories, cost of revenues and selling, general and administrative costs, based on the actual costs associated with each employee. We categorize employees who maintain our solutions as cost of revenues, and all other personnel, including executive managers, sales people, marketing, business development, finance, legal, human resources, and administrative services, as selling, general and administrative expenses. A significant portion of our other operating costs, such as facilities and communications, are either captured within cost of revenues or selling, general and administrative expense based on the nature of the work being performed.
While we expect to grow our headcount over time to take advantage of our market opportunities, we believe that the economies of scale in our operating model will allow us to grow our personnel expenses at a lower rate than revenues.
Historically, our EBITDA margin has improved because we have been able to increase revenues without a proportionate corresponding increase in expenses. However, part of our corporate strategy is to invest in new solutions, which may offset margin expansion.
Cost of Revenues. Our cost of revenues consists primarily of personnel expenses. Cost of revenues also includes the expenses associated with the acquisition and verification of data, the maintenance of our existing solutions and the development and enhancement of our next-generation solutions. Our cost of revenues excludes depreciation and amortization.
Selling, General and Administrative Expense. Our selling, general and administrative expense also consists primarily of personnel costs. A portion of the other operating costs such as facilities, insurance and communications are allocated to selling, general and administrative costs based on the nature of the work being performed by the employee. Our selling, general and administrative expenses excludes depreciation and amortization.
Trends Affecting Our Business
We serve customers in three primary vertical markets: P&C insurance, energy, and financial services. The industry trends in each of those markets can affect our business.
A significant change in P&C insurers’ profitability could affect the demand for our solutions. For insurers, the keys to profitability include increasing investment income, premium growth and disciplined underwriting of risks. Investment income remains under pressure as a result of low interest rates. Growth in P&C insurers’ direct written premiums is cyclical, with total industry premium growth receding from a peak of 14.8% in 2002 to a trough of negative 3.1% in 2009 and subsequently recovering to 4.4% in 2012, 4.3% in 2013, 4.4% in 2014, 3.7% in 2015 and 3.7% in 2016. In recent years, we have signed multi-year contracts with certain customers, and pricing is fixed at the beginning of each multi-year period; pricing for other customers is still linked to prior years' premiums.
Based on our experience, insurers more closely scrutinize their spending in periods of more challenging growth and tend to focus on making an underwriting profit. In addition, 2017 has been a challenging year for insurers with the catastrophe losses related to the three major hurricanes - Harvey, Irma, and Maria - making landfall in the U.S. in the third quarter 2017 causing insurance industry’s net income to decline. These events also illustrate the need for broader coverages, such as flood to meet the changing needs of communities. We continue to provide the necessary resources to meet insurer needs.
Trends in catastrophe and non-catastrophe weather losses can have an effect on our customers’ profitability, and therefore on their appetite for buying analytics to help them manage their risks. Any increase or decrease in frequency or severity of weather events over time could lead to an increased or decreased demand for our catastrophe modeling, catastrophe loss information, and repair cost solutions. Likewise, any structural changes in the reinsurance and related brokerage industry from the recent influx of alternative capital or newer technologies could affect demand for our products. We also have a portion of our revenue related to the number of claims processed due to losses, which can be impacted by seasonal storm activity. The need by our customers to fight insurance fraud - both in claims and at policy inception - could lead to increased demand for our underwriting and claims solutions.
Trends in the energy, chemicals, and metals and mining sectors and activity in financial markets can influence our revenues. During 2017, oil prices showed a modest improvement and we expect a continued sense of optimism in the energy markets in 2018. In the upstream sector there are five global trends. First, capital investments are anticipated to grow moderately in 2018, signaling an end to the period of reductions since 2014. Second, there is a surge in tight oil production in 2018 driven by a considerable increase from the Permian Basin in the U.S. (a region benefiting from new fracking production technology). Third, over-supplies in the service sector provide an opportunity for operators to lock in prices below historical market rates. Fourth, opportunities from discovered resources and exploration have been increasingly undertaken. Several Middle Eastern countries expect to award significant contracts to further develop discovered resources. In addition, there will likely be growing interest in Latin American opportunities. Fifth, many countries are reviewing their existing fiscal policies to ensure that they are competitive, as well as developing new terms to attract investment in new opportunities. In terms of the wider energy sector, we foresee the continued growth of the electric vehicle market, albeit from a low base, which is anticipated to develop into one of the most disruptive forces in the sector. Falling renewable energy costs around the world will also underpin the ongoing shift towards a low carbon economy. We will continue to evolve our offerings to meet the needs of our customers in a dynamic market and remain increasingly well positioned to serve our customers' information and analytical needs.
Market trends continue to influence our financial services vertical in important ways. As we look forward towards 2018, increasing trends in delinquency and fraud rates have resulted in an increased demand for robust risk solutions. In order to better serve our customers, add to our data asset, and expand our expertise, we made a number of strategic acquisitions in the
past year, most importantly (1) G2, which provides merchant risk intelligence solutions for acquirers, commercial banks and their value chain partners. G2 provides solutions to manage and monitor merchant and business risk within an increasingly complex payments ecosystem using advanced artificial intelligence technologies combined with expert analysts. (2) LCI, a company that provides bankruptcy management solutions to improve customer's profitability through recovery of bankrupt accounts while protecting the customer's brand by conforming to industry compliance. LCI maintains bankruptcy data (servicing more than 1.3 billion accounts), bankruptcy process automation software, expert services, and research to automate expensive processes in the bankruptcy lifecycle. (3) Fintellix, a company that provides Risk and Regulatory Reporting solutions to enterprise banks at a significantly lower cost of compliance, as well as jumpstarting analytics capabilities in smaller and regional banks. We stand confident of our position with these acquisitions, with the proprietary data and solutions we offer, to help our customers achieve their business and regulatory objectives.
Description of Acquisitions
We acquired twenty-one businesses since January 1, 2015. These acquisitions affect the comparability of our consolidated results of operations between periods. See Note 8 to our consolidated financial statements included in this annual report on Form 10-K for further discussions on the below acquisitions.
2017 Acquisitions
On December 29, 2017, we acquired 100 percent of the stock of PowerAdvocate, Inc., or PowerAdvocate, a provider of market, cost intelligence, and supply chain solutions serving the energy sector. Within our Decision Analytics segment, PowerAdvocate expands our offerings to the energy sector by adding proprietary spend data and cost models and providing insight into customers' cost savings opportunities.
On December 22, 2017, we acquired the net assets of Service Software, LLC., or Service Software, a provider of business management software for the construction industry. Within our Decision Analytics segment, Service Software expands our offerings to the insurance sector by integrating with the existing loss quantification solutions, which makes it possible for restoration professionals to save time by sharing job information, reducing duplicate data entry, and increasing productivity.
On November 9, 2017, we acquired 100 percent of the stock of Rebmark Legal Solutions Ltd., or Rebmark, a provider of injury claims solutions, within the Decision Analytics segment. Rebmark’s solutions aid claimant and defendant lawyers, barristers, and claims handlers with the preparation of schedules of loss, which is useful in complex, high-value injury claims where calculations can be time-consuming and there is greater potential for error.
On August 31, 2017, we acquired 100 percent of the stock of Lundquist Consulting, Inc., or LCI, a provider of risk insight, prediction, and management solutions for banks and creditors. LCI has become part of the financial services vertical within the Decision Analytics segment. This acquisition brings together our proprietary data assets and LCI's proprietary time-series data, including consumer and commercial bankruptcies, consumer behavior, and legal and technical terms associated with debtor settlements.
On August 23, 2017, we acquired 100 percent of the stock of Sequel Business Solutions Ltd., or Sequel, a provider of commercial and specialty insurance and reinsurance software based in the U.K. Sequel has become part of the insurance vertical within the Decision Analytics segment. The acquisition of Sequel further enhances our comprehensive offerings to the global complex commercial and specialty insurance industry, enabling integrated global data analytics through a specialized end-to-end workflow solution.
On August 3, 2017, we acquired 100 percent of the stock of G2 Web Services LLC, or G2, a provider of merchant risk intelligence solutions for acquirers, commercial banks, and other payment system providers. G2 has become part of the financial services vertical within the Decision Analytics segment. The acquisition of G2 positions us to further enhance our offerings to clients and partners, by providing solutions that help fight fraud, transaction laundering, and reputational risk within the global payments and e-commerce ecosystem.
During the three months ended June 30, 2017, we acquired the net assets of Blue Skies Consulting, LLC, ControlCam, LLC, Krawietz Aerial Photography, LLC, Richard Crouse & Associates, Inc., Rocky Mountain Aerial Surveys, Inc., Skyview Aerial Photo, Inc., and Valley Air Photos, LLC , altogether the Aerial Imagery acquisitions, a group of similar but unrelated companies, which give us broad geographic coverage of the U.S. for aerial image capture purposes. The Aerial Imagery acquisitions provide multi-spectral aerial photographic services with expertise in offering digital photogrammetric and remote sensing data for mapping and surveying applications. Within our Decision Analytics segment, the Aerial Imagery acquisitions enable us to enhance and maintain its database of images with the required frequency, resolution, and coverage across the U.S. to support our objective as the leading provider of loss quantification data, analytics, and decision-support solutions to the insurance industry, and the photogrammetry, surveying, mapping, and other related markets.
On May 19, 2017, we acquired 100 percent of the stock of MAKE Consulting A/S, or MAKE, a research and advisory business specializing in wind power. MAKE has become part of the energy and specialized markets vertical within the Decision Analytics segment. MAKE enhances our offering to existing customers and forms a market analysis and advisory consortium on renewables and the transformation of the global electricity industry. With detailed coverage of power market fundamentals, solar, wind, energy storage, and grid edge technologies, the energy and specialized markets vertical is positioned to bring customers market analysis and insight on the evolution of the energy landscape and provide a comprehensive platform for the future.
On March 31, 2017, we acquired 100 percent of the stock of Fintellix Solutions Private Limited, or Fintellix, a Bangalore-based data solutions company specializing in the development of data management platforms and regulatory reporting solutions for financial institutions. Fintellix has become part of the financial services vertical within the Decision Analytics segment. The acquisition of Fintellix positions us to expand the data hosting and regulatory platforms and better address the increasingly complex needs of its customers.
On February 24, 2017, we acquired 100 percent of the stock of Emergent Network Intelligence Limited, or ENI, a developer in insurance claims efficiency and fraud detection solutions based in the U.K.. With the acquisition of ENI within the Decision Analytics segment, our customers in the U.K. can take advantage of technologically advanced tools that allow them to improve motor vehicle claims workflow and reduce their costs and exposure to fraud.
On February 16, 2017, we acquired 100 percent of the stock of Healix International Holdings Limited, or Healix, a software analytics provider in automated medical risk assessment for the travel insurance industry. Healix is within our Risk Assessment segment. The acquisition further expands our offerings for the global insurance industry, providing solutions that are embedded with customer workflows and can help underwrite medical coverage for travelers with greater speed, accuracy, and efficiency.
On January 21, 2017, we acquired 100 percent of the stock of Arium Limited, or Arium. Arium specializes in liability risk modeling and decision support. Arium has become part of the insurance vertical within the Decision Analytics segment, and enables us to provide its customers with additional modeling solutions and analytics for the casualty market.
2016 Acquisitions
On November 23, 2016, we acquired the net assets of IntelliStance, LLC, or MarketStance, a provider of market intelligence data and analytics to the property/casualty insurance market. MarketStance has become part of our Risk Assessment segment. MarketStance has built a proprietary analytics model to provide actionable insights on customer's profitability that enhances our existing offerings.
On November 11, 2016, we acquired 100 percent of the stock of The GeoInformation Group Limited, or GeoInformation, a provider of geographic data solutions. GeoInformation offers mapping services and geospatial data and analytic solutions to companies and public sector organizations. GeoInformation's resources complement the risk management and predictive analytics capabilities internationally within the Risk Assessment segment.
On October 20, 2016, we acquired 100 percent of the stock of Analyze Re, Inc., or Analyze Re, a software analytics provider for the reinsurance and insurance industries. Analyze Re has become part of our insurance vertical within the Decision Analytics segment and enables us to provide our customers with additional real-time pricing, exposure management, and enterprise portfolio roll-up capabilities.
On August 19, 2016, we acquired the net assets of data and subscriptions business of Quest Offshore Resources, Inc, or Quest Offshore, which supplies market intelligence to the offshore oil and gas sector. The data and subscriptions business has become part of the energy vertical within the Decision Analytics segment and complements its existing upstream analysis expertise.
On July 26, 2016, we acquired 100 percent of the stock of Greentech Media, Inc., or Greentech Media, an information services provider for the electricity and renewables sector. Greentech Media has become part of the energy vertical within the Decision Analytics segment and enables us to provide our customers with market intelligence across several categories, including solar generation, energy storage, and smart grids that react to changes in supply and demand.
On April 14, 2016, we acquired 100 percent of the stock of Risk Intelligence Ireland Limited, or RII, a provider of fraud detection, compliance, risk control, and process automation services to the Irish insurance industry. RII enhances the ability of our Risk Assessment segment to serve the international insurance market.
2015 Acquisitions
On November 20, 2015, we acquired 100 percent of the stock of The PCI Group, or PCI. PCI is a consortium of five specialist companies that offer integrated data and subscriptions research in the chemicals, fibers, films, and plastics sectors. PCI has become part of the energy vertical, and continues to provide services to enhance our chemicals capabilities in the Decision Analytics segment.
On November 6, 2015, we acquired 100 percent of the stock of Infield Systems Limited, or Infield. Infield is a provider of business intelligence, analysis, and research to the oil, gas, and associated marine industries. Infield has become part of the energy vertical and continues to provide services to enhance our upstream and supply chain capabilities in the Decision Analytics segment.
On May 19, 2015, we acquired 100 percent of the stock of Wood Mackenzie. Wood Mackenzie is a global provider of data analytics and commercial intelligence for the energy, chemicals, metals and mining verticals. This acquisition advances our strategy to expand internationally and positions ourselves in the global energy market. Wood Mackenzie is included in the energy and specialized markets vertical, formerly named the specialized markets vertical, of the Decision Analytics segment.
Description of Discontinued Operations
On June 1, 2016, we sold our healthcare business, Verisk Health, for a price of $714.6 million. Results of operations for the healthcare business are reported as discontinued operations for the year ended December 31, 2016 and for all prior periods presented. See Note 9 to our consolidated financial statements included in this annual report on Form 10-K.
Year Ended December 31, 2017 Compared to Year Ended December 31, 2016
Consolidated Results of Continuing Operations
Revenues
Revenues were $2,145.2 million for the year ended December 31, 2017 compared to $1,995.2 million for the year ended December 31, 2016, an increase of $150.0 million or 7.5%. Excluding revenues of $61.3 million from RII, Greentech Media, Quest Offshore, Analyze Re, GeoInformation, MarketStance, Arium, Healix, ENI, Fintellix, MAKE, Aerial Imagery acquisitions, G2, Sequel, LCI, Rebmark, and Service Software, collectively referred to as our recent acquisitions, our revenue growth was $88.7 million or 4.5%. Revenues within our Decision Analytics segment, excluding our recent acquisitions of Greentech Media, Quest Offshore, Analyze Re, Arium, ENI, Fintellix, MAKE, Aerial Imagery acquisitions, G2, Sequel, LCI, Rebmark, and Service Software, increased by $54.7 million or 4.3%. Revenue growth within Decision Analytics was primarily driven by our insurance categories. Revenues in our Risk Assessment segment, excluding our recent acquisitions of RII, GeoInformation, MarketStance, and Healix increased by $34.0 million or 4.7%. Both types of categories within Risk Assessment, industry-standard insurance programs and property-specific rating and underwriting information, contributed to its revenue growth. Refer to the Results of Continuing Operations by Segment within this section for further information regarding our revenues.
Cost of Revenues
Cost of revenues was $783.8 million for the year ended December 31, 2017 compared to $714.4 million for the year ended December 31, 2016, an increase of $69.4 million or 9.7%. Our recent acquisitions accounted for an increase of $45.3 million in cost of revenues, primarily related to salaries and employee benefits. Excluding the impact of our recent acquisitions, our cost of revenues increased $24.1 million or 3.4%. The increase was primarily due to increases in salaries and employee benefits cost of $30.7 million, data costs and data processing fees of $6.1 million, information technology expense of $1.7 million and other operating costs of $0.1 million. These increases were offset by a decrease in a nonrecurring ESOP charge of $14.5 million which occurred in 2016. The ESOP charge was related to the stretch-out of our ESOP loan, which was paid off in 2015.
Selling, General and Administrative Expenses
Selling, general and administrative expenses, or SGA, were $322.8 million for the year ended December 31, 2017 compared to $301.6 million for the year ended December 31, 2016, an increase of $21.2 million or 7.0%. Our recent acquisitions accounted for an increase of $13.7 million in SGA, primarily related to salaries and employee benefits and transaction costs. Excluding the impact of our recent acquisitions, SGA increased $7.5 million or 2.5%. The increase was primarily due to increases in salaries and employee benefits of $8.8 million, professional consulting fees of $4.0 million and other general and administrative of $0.2 million. These increases were offset by a decrease in information technology expense of $1.2 million and a 2016 ESOP charge of $4.3 million.
Depreciation and Amortization of Fixed Assets
Depreciation and amortization of fixed assets was $135.6 million for the year ended December 31, 2017 compared to $119.1 million for the year ended December 31, 2016, an increase of $16.5 million or 13.8%. The increase in depreciation and amortization of fixed assets includes depreciation and amortization related to our recent acquisitions of $3.8 million. The remaining increase primarily relates to depreciation and amortization of hardware and software development costs placed into production to support data capacity expansion and revenue growth.
Amortization of Intangible Assets
Amortization of intangible assets was $101.8 million for the year ended December 31, 2017 compared to $92.5 million for the year ended December 31, 2016, an increase of $9.3 million or 10.1%. The increase in amortization of intangible assets was primarily related to our recent acquisitions of $13.5 million offset by currency fluctuations impacting amortization denominated in currencies other than U.S. dollars.
Investment Income and Others, Net
Investment income and others, net was a gain of $9.2 million for the year ended December 31, 2017 compared to $6.1 million for the year ended December 31, 2016, an increase of $3.1 million. The increase was primarily related to an increase in interest income of $5.1 million generated from the subordinated promissory note associated with the divestiture of our healthcare business. This increase was offset by a gain on sale of equity investments of $1.5 million in 2016.
Interest Expense
Interest expense was $119.4 million for the year ended December 31, 2017 compared to $120.0 million for the year ended December 31, 2016, a decrease of $0.6 million or 0.5%. As a result of the Second Amendment to the Credit Facility in May 2016, which reduced the borrowing capacity from $1,750.0 million to $1,500.0 million.
Provision for Income Taxes
The provision for income taxes was $135.9 million for the year ended December 31, 2017 compared to $202.2 million for the year ended December 31, 2016, a decrease of $66.3 million or 32.8%. The effective tax rate was 19.7% for the year ended December 31, 2017 compared to 30.9% for the year ended December 31, 2016. The decrease in the effective tax rate in 2017 compared to 2016 was primarily due to lowered federal income tax rates as a result of U.S. Tax Reform and the adoption of ASU No. 2016-09, partially offset by legislation enacted in the U.K.
Net Income
The net income margin for our consolidated results, including discontinued operations, was 25.9% for the year ended December 31, 2017 compared to 28.1% for the year ended December 31, 2016. Our net income margin for the year ended December 31, 2017 was positively impacted by the 2017 tax reform legislation of 4.2%. Our net income margin for the year ended December 31, 2016 was positively impacted by the discontinued operations, including the gain on sale of our healthcare business of 5.5% and lowered by an ESOP charge of 0.6%.
EBITDA
The EBITDA margin for our consolidated results, including discontinued operations, was 48.8% for the year ended December 31, 2017 compared to 59.4% for the year ended December 31, 2016. Our EBITDA margin for the year ended December 31, 2016 was positively impacted by the discontinued operations, including the gain on sale of our healthcare business, of 10.0%, which was partially offset by the impact from an ESOP charge of 0.9%.
Results of Continuing Operations by Segment
Decision Analytics
Revenues
Revenues for our Decision Analytics segment were $1,374.9 million for the year ended December 31, 2017 compared to $1,270.9 million for the year ended December 31, 2016, an increase of $104.0 million or 8.2%. Excluding revenues of $49.3 million from our recent acquisitions of Greentech Media, Quest Offshore, Analyze Re, Arium, ENI, Fintellix, MAKE, Aerial Imagery acquisitions, G2, Sequel, LCI, Rebmark, and Service Software, Decision Analytics revenues increased $54.7 million or 4.3%.
Our revenue by category for the periods presented is set forth below for the years ended December 31:
| 2017 | 2016 | Percentage Change | ||||||||
| (In millions) | ||||||||||
| Insurance | $ | 784.7 | $ | 699.8 | 12.1 | % | ||||
| Energy and specialized markets | 444.7 | 442.8 | 0.4 | % | ||||||
| Financial services | 145.5 | 128.3 | 13.4 | % | ||||||
| Total Decision Analytics | $ | 1,374.9 | $ | 1,270.9 | 8.2 | % |
Our insurance revenue increased $84.9 million or 12.1%. Excluding revenues of $17.1 million from our recent acquisitions of Analyze Re, Arium, ENI, Aerial Imagery acquisitions, Sequel, Rebmark, and Service Software, our insurance revenue increased $67.8 million or 9.7%. The increase was primarily due to an increase within our loss quantification solutions, insurance anti-fraud claims revenue, catastrophe modeling services, and underwriting solutions.
Our energy and specialized markets revenue increased $1.9 million or 0.4%. Excluding revenues of $11.4 million from our recent acquisitions of Greentech Media, Quest Offshore, and MAKE, our energy and specialized markets revenue decreased $9.5 million or 2.2% due to the continuing end-market and currency tailwinds affecting the energy business and declines in our environmental health and safety services.
Our financial services revenue increased $17.2 million or 13.4%. Excluding revenues of $20.8 million from our recent acquisitions of Fintellix, G2, and LCI, our financial services revenue decreased $3.6 million or 2.8%. The decrease was primarily due to several contract completions in 2016 partially offset by growth in media effectiveness solutions.
Cost of Revenues
Cost of revenues for our Decision Analytics segment was $557.0 million for the year ended December 31, 2017 compared to $490.7 million for the year ended December 31, 2016, an increase of $66.3 million or 13.5%. Our recent acquisitions within the Decision Analytics segment represented an increase of $39.6 million in cost of revenues, which was primarily related to salaries and employee benefits. Excluding the impact of our recent acquisitions, our cost of revenues increased $26.7 million or 5.5%. The increase was primarily due to increases in salaries and employee benefits of $22.9 million, data costs and data processing fees of $5.8 million, information technology expense of $2.6 million, and other operating costs of $1.6 million. These increases were offset by a decrease in an ESOP charge of $6.2 million that occurred in 2016.
Selling, General and Administrative Expenses
Selling, general and administrative expenses for our Decision Analytics segment were $238.3 million for the year ended December 31, 2017 compared to $214.9 million for the year ended December 31, 2016, an increase of $23.4 million or 10.9%. Our recent acquisitions within the Decision Analytics segment, accounted for an increase of $12.2 million in SGA, was primarily related to salaries and employee benefits and transaction costs. Excluding costs associated with our recent acquisitions, SGA increased $11.2 million or 5.3%. The increase was primarily due to increases in salaries and employee benefits of $8.3 million, professional consulting fees of $3.7 million, and other general expenses of $1.8 million. These increases were offset by a decrease in information technology expense of $0.7 million and a decrease in an ESOP charge of $1.9 million that occurred in 2016.
EBITDA
The EBITDA margin for our Decision Analytics segment was 42.8% for the year ended December 31, 2017 and including our discontinued operations 60.4% for the year ended December 31, 2016. Our EBITDA margin for the year ended December 31, 2016 was positively impacted by the discontinued operations, including the gain on sale of our healthcare business, of 15.6%.
Risk Assessment
Revenues
Revenues for our Risk Assessment segment were $770.3 million for the year ended December 31, 2017 compared to $724.3 million for the year ended December 31, 2016, an increase of $46.0 million or 6.4%. Excluding revenues of $12.0 million from our recent acquisitions of RII, GeoInformation, MarketStance, and Healix, revenues for our Risk Assessment increased $34.0 million or 4.7% for the year ended December 31, 2017. Our industry-standard insurance programs revenue, excluding revenues of $11.3 million from our recent acquisitions of RII, MarketStance and Healix, increased $28.3 million or 5.1%. Our property-specific rating and underwriting information revenue, excluding revenue of $0.7 million from our recent acquisition of GeoInformation, increased $5.7 million or 3.3%. Revenue growth within this segment primarily resulted from an increase in prices derived from continued enhancements to the content of the solutions within our industry-standard insurance programs as well as selling expanded solutions to existing customers.
Our revenue by category for the periods presented is set forth below for the years ended December 31:
| 2017 | 2016 | Percentage Change | ||||||||
| (In millions) | ||||||||||
| Industry-standard insurance programs | $ | 593.6 | $ | 554.1 | 7.1 | % | ||||
| Property-specific rating and underwriting information | 176.7 | 170.2 | 3.8 | % | ||||||
| Total Risk Assessment | $ | 770.3 | $ | 724.3 | 6.4 | % |
Cost of Revenues
Cost of revenues for our Risk Assessment segment was $226.8 million for the year ended December 31, 2017 compared to $223.7 million for the year ended December 31, 2016, an increase of $3.1 million or 1.4%. Our recent acquisitions within this segment represented an increase of $5.7 million in cost of revenues, which was primarily related to salaries and employee benefits. Excluding the impact of our recent acquisitions, our cost of revenues decreased $2.6 million or 1.2%. The decrease was primarily due to a decrease in an ESOP charge of $8.3 million that occurred in 2016, decreases in information technology expense of $0.9 million and other operating costs of $1.5 million. These decreases were offset by increases in salaries and employee benefit costs of $7.8 million and data costs and data processing fees of $0.3 million.
Selling, General and Administrative Expenses
Selling, general and administrative expenses for our Risk Assessment segment were $84.5 million for the year ended December 31, 2017 compared to $86.7 million for the year ended December 31, 2016, a decrease of $2.2 million or 2.6%. Our recent acquisitions within this segment accounted for the $1.5 million in SGA expenses, which was primarily related to salaries and employee benefits and transaction costs. Excluding costs associated with our recent acquisitions, SGA decreased $3.7 million or 4.3%. The decrease was primarily due to the elimination of an ESOP charge of $2.4 million that occurred in 2016, decreases in information technology expenses of $0.5 million, and other general expense of $1.6 million. These decreases were offset by increases in salaries and employee benefit costs of $0.5 million and professional consulting costs of $0.3 million.
EBITDA
The EBITDA margin for our Risk Assessment segment was 59.5% for the year ended December 31, 2017 compared to 57.4% for the year ended December 31, 2016. The margin for the year ended December 31, 2016 was negatively impacted by an ESOP charge of 1.5%.
Year Ended December 31, 2016 Compared to Year Ended December 31, 2015
Consolidated Results of Continuing Operations
Revenues
Revenues were $1,995.2 million for the year ended December 31, 2016 compared to $1,760.7 million for the year ended December 31, 2015, an increase of $234.5 million or 13.3%. Excluding revenues of $151.0 million from Wood Mackenzie (for the first and second quarters), Infield, PCI, RII, Greentech Media, Quest Offshore, Analyze Re, GeoInformation, and MarketStance, collectively referred to as our recent acquisitions, our revenue growth was $83.5 million or 4.9%. Revenues within our Decision Analytics segment, excluding our recent acquisitions of Wood Mackenzie (for the first and second quarters), Infield, PCI, Greentech Media, Quest Offshore and Analyze Re, increased by $49.3 million or 4.8%. Revenue growth within Decision Analytics was primarily driven by our financial services and insurance categories. Revenues in our Risk Assessment segment, excluding our recent acquisitions of RII, GeoInformation and MarketStance, increased by $34.2 million or 5.0%. Both categories, industry-standard insurance programs and property-specific rating and underwriting information, within Risk Assessment contributed to its revenue growth. Refer to the Results of Continuing Operations by Segment within this section for further information regarding our revenues.
Cost of Revenues
Cost of revenues was $714.4 million for the year ended December 31, 2016 compared to $612.0 million for the year ended December 31, 2015, an increase of $102.4 million or 16.7% . Our recent acquisitions accounted for an increase of $56.1 million in cost of revenues, primarily related to salaries and employee benefits. Excluding the impact of our recent acquisitions, our cost of revenues increased $46.3 million or 7.8%. The increase was primarily due to increases in salaries and employee benefits cost of $27.2 million and an ESOP charge of $14.5 million. Other increases include information technology expense of $5.3 million and data costs and data processing fees of $0.9 million. These increases were offset by a decrease in other operating costs of $1.6 million.
Selling, General and Administrative Expenses
Selling, general and administrative expenses, or SGA, were $301.6 million for the year ended December 31, 2016 compared to $278.3 million for the year ended December 31, 2015, an increase of $23.3 million or 8.3%. Our recent acquisitions accounted for an increase of $12.2 million in SGA, primarily related to salaries and employee benefits. Excluding the impact of our recent acquisitions, SGA increased $11.1 million or 4.5%. The increase was primarily due to increases in salaries and employee benefits of $5.6 million, an ESOP charge of $4.3 million, and professional consulting fees of $3.0 million. These increases were offset by decreases in information technology expense of $0.9 million and other general and administrative of $0.9 million.
Depreciation and Amortization of Fixed Assets
Depreciation and amortization of fixed assets was $119.1 million for the year ended December 31, 2016 compared to $96.6 million for the year ended December 31, 2015, an increase of $22.5 million or 23.2%. The increase in depreciation and amortization of fixed assets includes depreciation and amortization related to our recent acquisitions of $11.3 million. The remaining increase primarily relates to hardware and software development costs placed into production to support data capacity expansion and revenue growth.
Amortization of Intangible Assets
Amortization of intangible assets was $92.5 million for the year ended December 31, 2016 compared to $70.4 million for the year ended December 31, 2015, an increase of $22.1 million or 31.2%. The increase in amortization of intangible assets was primarily related to our recent acquisitions of $20.1 million.
Investment Income and Others, Net
Investment income and others, net was a gain of $6.1 million for the year ended December 31, 2016 compared to $16.9 million for the year ended December 31, 2015, a decrease of $10.8 million. The decrease was primarily related to a gain of $15.6 million in connection with the exercise and payout of common stock warrants for the year ended December 31, 2015. This decrease was partially offset by increases attributable to interest income of $6.5 million generated from the subordinated promissory note related to the divestiture of our healthcare business.
Gain on Derivative instruments
Gain on derivative instruments decreased $85.2 million or 100% due to a one-time foreign currency hedge gain realized in 2015 relating to the acquisition of Wood Mackenzie, which did not recur in 2016.
Interest Expense
Interest expense was $120.0 million for the year ended December 31, 2016 compared to $121.4 million for the year ended December 31, 2015, a decrease of $1.4 million or 1.1%. The decrease is primarily due to the net payments of our credit facility of $770.0 million mostly funded by the net proceeds from the divestiture of our healthcare business.
Provision for Income Taxes
The provision for income taxes was $202.2 million for the year ended December 31, 2016 compared to $196.6 million for the year ended December 31, 2015, an increase of $5.6 million or 2.8%. The effective tax rate was 30.9% for the year ended December 31, 2016 compared to 28.7% for the year ended December 31, 2015.
Net Income
The net income margin for our consolidated results, including discontinued operations, was 28.1% for the year ended December 31, 2016 compared to 24.5% for the year ended December 31, 2015. Our net income margin for the year ended December 31, 2016 was positively impacted by the discontinued operations, including the gain on sale of our healthcare business of 5.5% and lowered by an ESOP charge of 0.6%. Our net income margin for the year ended December 31, 2015 was lowered by the discontinued operations of 3.2% and positively impacted by the derivative gain and the transaction costs related to the Wood Mackenzie acquisition and the gain on the exercise and payout of the common stock warrants of 3.2%.
EBITDA
The EBITDA margin for our consolidated results, including discontinued operations, was 59.4% for the year ended December 31, 2016 compared to 51.0% for the year ended December 31, 2015. Our EBITDA margin for the year ended December 31, 2016 was positively impacted by the discontinued operations, including the gain on sale of our healthcare business, of 10.0%, which was partially offset by the impacts from an ESOP charge of 0.9%. Our EBITDA margin for the year ended December 31, 2015 was lowered by the discontinued operations of 4.2% and positively impacted by the derivative gain and the transaction costs related to the Wood Mackenzie acquisition and the warrant exercise of 3.6%.
Results of Continuing Operations by Segment
Decision Analytics
Revenues
Revenues for our Decision Analytics segment were $1,270.9 million for the year ended December 31, 2016 compared to $1,072.5 million for the year ended December 31, 2015, an increase of $198.4 million or 18.5%. Excluding revenues of $149.1 million from Wood Mackenzie (for the first and second quarters) and our recent acquisitions of Infield, PCI, Greentech Media, Quest Offshore, and Analyze Re, Decision Analytics revenues increased $49.3 million or 4.8%.
Our revenue by category for the periods presented is set forth below for the years ended December 31:
| 2016 | 2015 | Percentage Change | ||||||||
| (In millions) | ||||||||||
| Insurance | $ | 699.8 | $ | 647.2 | 8.1 | % | ||||
| Energy and specialized markets | 442.8 | 308.8 | 43.4 | % | ||||||
| Financial services | 128.3 | 116.5 | 10.1 | % | ||||||
| Total Decision Analytics | $ | 1,270.9 | $ | 1,072.5 | 18.5 | % |
Our insurance revenue increased $52.6 million or 8.1%. Excluding revenues of $0.5 million from our recent acquisition, our insurance revenue increased $52.1 million or 8.1%. The increase was primarily due to an increase within our loss quantification solutions, underwriting solutions, insurance anti-fraud claims revenue, and catastrophe modeling services.
Our energy and specialized markets revenue increased $134.0 million or 43.4%. Excluding revenues of $148.6 million from Wood Mackenzie (for the first and second quarters) and our recent acquisitions of Infield, PCI, Greentech Media, and Quest Offshore, our energy and specialized markets revenue decreased $14.6 million or 5.5% due to the continuing end-market and currency headwinds affecting the energy business and declines in our environmental health and safety services.
Our financial services revenue increased $11.8 million or 10.1%, primarily due to the continued demand for our media effectiveness services and analytic solutions.
Cost of Revenues
Cost of revenues for our Decision Analytics segment was $490.7 million for the year ended December 31, 2016 compared to $412.0 million for the year ended December 31, 2015, an increase of $78.7 million or 19.1%. Our recent acquisitions within the Decision Analytics segment represented an increase of $54.8 million in cost of revenues, which was primarily related to salaries and employee benefits. Excluding the impact of our recent acquisitions, our cost of revenues increased $23.9 million or 6.1%. The increase was primarily due to increases in salaries and employee benefits of $16.9 million, an ESOP charge of $6.2 million, and information technology expense of $4.2 million. These increases were offset by decreases in data costs and data processing fees of $0.2 million and other operating costs of $3.2 million.
Selling, General and Administrative Expenses
Selling, general and administrative expenses for our Decision Analytics segment were $214.9 million for the year ended December 31, 2016 compared to $196.5 million for the year ended December 31, 2015, an increase of $18.4 million or 9.4%. Our recent acquisitions within the Decision Analytics segment, accounted for an increase of $11.5 million in SGA, which was primarily related to salaries and employee benefits. Excluding costs associated with our recent acquisitions, SGA increased $6.9 million or 4.2%. The increase was primarily due to increases in salaries and employee benefits of $6.8 million, an ESOP charge of $1.9 million, and professional consulting fees of $1.4 million. These increases were offset by decreases in information technology expense of $1.3 million and other general expenses of $1.9 million.
EBITDA
The EBITDA margin for our Decision Analytics segment, including our discontinued operations, was 60.4% for the year ended December 31, 2016 and 46.9% for the year ended December 31, 2015. Our EBITDA margin for the year ended December 31, 2016 was positively impacted by the discontinued operations, including the gain on sale of our healthcare business, of 15.6%, which was partially offset by the impact from an ESOP charge of 0.6%. The nonrecurring derivative gain, net of transaction costs related to the Wood Mackenzie acquisition and the warrant exercise and payout, positively impacted our EBITDA margin by 5.4%, which was offset by the impact from the discontinued operations of 5.9% for year ended December 31, 2015.
Risk Assessment
Revenues
Revenues for our Risk Assessment segment were $724.3 million for the year ended December 31, 2016 compared to $688.2 million for the year ended December 31, 2015, an increase of $36.1 million or 5.2%. Excluding revenues of $1.9 million from our recent acquisitions of RII, GeoInformation and MarketStance, revenues for our Risk Assessment increased $34.2 million or 5.0% for the year ended December 31, 2016. Revenue growth within this segment primarily resulted from an increase in prices derived from continued enhancements to the content of the solutions within our industry-standard insurance programs as well as selling expanded solutions to existing customers.
Our revenue by category for the periods presented is set forth below for the years ended December 31:
| 2016 | 2015 | Percentage Change | ||||||||
| (In millions) | ||||||||||
| Industry-standard insurance programs | $ | 554.1 | $ | 524.6 | 5.6 | % | ||||
| Property-specific rating and underwriting information | 170.2 | 163.6 | 4.0 | % | ||||||
| Total Risk Assessment | $ | 724.3 | $ | 688.2 | 5.2 | % |
Cost of Revenues
Cost of revenues for our Risk Assessment segment was $223.7 million for the year ended December 31, 2016 compared to $200.0 million for the year ended December 31, 2015, an increase of $23.7 million or 11.9%. Our recent acquisitions within this segment represented an increase of $1.3 million in cost of revenues, which was primarily related to salaries and employee benefits. Excluding the impact of our recent acquisitions, our cost of revenues increased $22.4 million or 11.2%. The increase was primarily due to increases in salaries and employee benefit costs of $10.3 million, an ESOP charge of $8.3 million, data costs and data processing fees of $1.1 million, information technology expense of $1.1 million, and other operating costs of $1.6 million.
Selling, General and Administrative Expenses
Selling, general and administrative expenses for our Risk Assessment segment were $86.7 million for the year ended December 31, 2016 compared to $81.8 million for the year ended December 31, 2015, an increase of $4.9 million or 5.9%. Our recent acquisitions within this segment, accounted for an increase of $0.7 million in SGA, which was primarily related to salaries and employee benefits. Excluding costs associated with our recent acquisitions, SGA increased $4.2 million or 5.1%. The increase was primarily due to an ESOP charge of $2.4 million, increases in professional consulting costs of $1.6 million, information technology expenses of $0.4 million, and other general expense of $1.0 million. These increases were offset by a decrease in salaries and employee benefit costs of $1.2 million.
EBITDA
The EBITDA margin for our Risk Assessment segment was 57.4% for the year ended December 31, 2016 compared to 59.1% for the year ended December 31, 2015. The margin for the year ended December 31, 2016 was negatively impacted by an ESOP charge of 1.5%.
Quarterly Results of Operations
The following table sets forth our quarterly unaudited consolidated statement of operations data for each of the eight quarters in the period ended December 31, 2017. In management’s opinion, the quarterly data has been prepared on the same basis as the audited consolidated financial statements included in this annual report on Form 10-K, and reflects all necessary adjustments for a fair presentation of this data. The results of historical periods are not necessarily indicative of the results of operations for a full year or any future period.
| For the Quarters Ended | |||||||||||||||
| March 31, | June 30, | September 30, | December 31, | Full Year | |||||||||||
| 2017 | 2017 | ||||||||||||||
| (in millions, except for per share data) | |||||||||||||||
| Statement of operations data: | |||||||||||||||
| Revenues | $ | 502.6 | $ | 523.2 | $ | 549.1 | $ | 570.3 | $ | 2,145.2 | |||||
| Operating income | $ | 187.7 | $ | 195.0 | $ | 208.4 | $ | 210.1 | $ | 801.2 | |||||
| Net income | $ | 108.8 | $ | 121.0 | $ | 120.7 | $ | 204.6 | $ | 555.1 | |||||
| Basic net income per share: | $ | 0.65 | $ | 0.73 | $ | 0.73 | $ | 1.24 | $ | 3.36 | |||||
| Diluted net income per share: | $ | 0.64 | $ | 0.72 | $ | 0.72 | $ | 1.22 | $ | 3.29 | |||||
| For the Quarters Ended | |||||||||||||||
| March 31, | June 30, | September 30, | December 31, | Full Year | |||||||||||
| 2016 | 2016 | ||||||||||||||
| (in millions, except for per share data) | |||||||||||||||
| Statement of operations data: | |||||||||||||||
| Revenues | $ | 492.7 | $ | 498.3 | $ | 498.1 | $ | 506.1 | $ | 1,995.2 | |||||
| Operating income | $ | 192.6 | $ | 191.1 | $ | 198.4 | $ | 185.5 | $ | 767.6 | |||||
| Income from continuing operations | $ | 109.7 | $ | 106.7 | $ | 127.6 | $ | 107.5 | $ | 451.5 | |||||
| Income from discontinued operations | $ | (17.1 | ) | $ | 155.0 | $ | — | $ | 1.8 | $ | 139.7 | ||||
| Net income | $ | 92.6 | $ | 261.7 | $ | 127.6 | $ | 109.3 | $ | 591.2 | |||||
| Basic net income per share: | $ | 0.55 | $ | 1.56 | $ | 0.76 | $ | 0.65 | $ | 3.51 | |||||
| Diluted net income per share: | $ | 0.54 | $ | 1.53 | $ | 0.74 | $ | 0.64 | $ | 3.45 |
Liquidity and Capital Resources
As of December 31, 2017 and 2016, we had cash and cash equivalents and available-for-sale securities of $146.1 million and $138.5 million, respectively. Subscriptions for our solutions are billed and generally paid in advance of rendering services either quarterly or in full upon commencement of the subscription period, which is usually for one year. Subscriptions are automatically renewed at the beginning of each calendar year. We have historically generated significant cash flows from operations. As a result of this factor, as well as the availability of funds under our syndicated revolving credit facility, we believe we will have sufficient cash to meet our working capital and capital expenditure needs, and to fuel our future growth plans.
We have historically managed the business with a working capital deficit due to the fact that, as described above, we offer our solutions and services primarily through annual subscriptions or long-term contracts, which are generally prepaid quarterly or annually in advance of the services being rendered. When cash is received for prepayment of invoices, we record an asset (cash and cash equivalents) on our balance sheet with the offset recorded as a current liability (deferred revenues). This current liability is deferred revenue that does not require a direct cash outflow since our customers have prepaid and are obligated to purchase the services. In most businesses, growth in revenue typically leads to an increase in the accounts receivable balance causing a use of cash as a company grows. Unlike these businesses, our cash position is favorably affected by revenue growth, which results in a source of cash due to our customers prepaying for most of our services.
Our consolidated capital expenditures as a percentage of consolidated revenues for the years ended December 31, 2017 and 2016, were 8.6% and 7.4%, respectively. We estimate our capital expenditures for 2018 will be approximately $230.0 million, which primarily consists of expenditures on our technology infrastructure and our continuing investments in developing and enhancing our solutions. Expenditures related to developing and enhancing our solutions are predominately related to internal-use software and are capitalized in accordance with ASC 350-40, “Accounting for Costs of Computer
Software Developed or Obtained for Internal Use.” We also capitalize amounts in accordance with ASC 985-20, “Software to be Sold, Leased or Otherwise Marketed.”
We have also historically used a portion of our cash for repurchases of our common stock from our stockholders. For the years ended December 31, 2017, 2016 and 2015, we repurchased $276.3 million, $326.8 million and $20.4 million, respectively, of our common stock.
Financing and Financing Capacity
We had total debt, excluding capital lease obligations, the discounts and debt issuance costs on our senior notes and our committed senior unsecured Syndicated Revolving Credit Facility, or the Credit Facility, of $3,015.0 million and $2,400.0 million at December 31, 2017 and 2016, respectively. The debt at December 31, 2017 primarily consists of senior notes issued in 2015, 2012 and 2011 and borrowings outstanding under the Credit Facility described below. Interest on the senior notes is payable semi-annually each year. The discount and debt issuance costs were recorded as "Long-term debt" in the accompanying consolidated balance sheets, and will be amortized to "Interest expense" in the accompanying consolidated statements of operations within this Form 10-K over the life of the respective senior note. The indenture governing the senior notes restricts our ability to, among other things, create certain liens, enter into sale/leaseback transactions and consolidate with, sell, lease, convey, or otherwise transfer all or substantially all of our assets, or merge with or into, any other person or entity. As of December 31, 2017, we had senior notes with an aggregate principal amount of $2,300.0 million outstanding, and we were in compliance with our financial debt covenants.
We have a credit facility with Bank of America N.A., JP Morgan Chase, N.A., Sun Trust Bank, Wells Fargo Bank, N.A., Citizens Bank, N.A., Morgan Stanley, N.A., HSBC Bank USA, N.A., Royal Bank of Canada, BNP Paribas, TD Bank, N.A., and The Northern Trust Company. On May 18, 2017, we entered into the third amendment to the Credit Facility, which, among other things, extended the maturity date one year to May 15, 2022. The Credit Facility may be used for general corporate purposes, including working capital needs and capital expenditures, acquisitions and the share repurchase program, or the Repurchase Program. The Credit Facility contains certain financial and other covenants that, among other things, impose certain restrictions on indebtedness, liens, investments, and capital expenditures. These covenants also place restrictions on mergers, asset sales, sale/leaseback transactions, payments between us and our subsidiaries, and certain transactions with affiliates. The financial covenants require that, at the end of any fiscal quarter, we have a consolidated interest coverage ratio of at least 3.0 to 1.0 and that we maintain, during any period of four fiscal quarters, a consolidated funded debt leverage ratio of 3.5 to 1.0. We were in compliance with all financial covenants under the Credit Facility as of December 31, 2017. Interest on borrowings under the Credit Facility is payable at an interest rate of LIBOR plus 1.125% to 1.625%, depending upon the consolidated funded debt leverage ratio. During the year ended December 31, 2017, we had borrowings of $870.0 million and repayments of $255.0 million under the credit facility. As of December 31, 2017 and 2016, we had outstanding borrowings under the Credit Facility of $715.0 million and $100.0 million, respectively. In January 2018, we repaid a total of $110.0 million of the $715.0 million outstanding borrowings at December 31, 2017 under the Credit Facility. On May 18, 2017, we entered into the third amendment to the Credit Facility, which, among other things, extended the maturity date one year to May 15, 2022.
On March 10, 2015, in connection with our agreement to acquire Wood Mackenzie, we entered into a commitment letter for a $2,300.0 million 364-day bridge financing arrangement with Bank of America N.A. and Morgan Stanley Bank N.A. acting as joint lead arrangers. This financing arrangement was only to be utilized in the event we did not complete the debt and equity offerings relating to its acquisition of Wood Mackenzie by a certain date, and was terminated upon the closing of the acquisition. We paid fees associated with this financing arrangement of $9.1 million. Due to the completion of the debt and equity offerings, this arrangement was terminated and the full $9.1 million of fees were recorded to "Interest expense" for the year ended December 31, 2015.
Cash Flow
The following table summarizes our cash flow data for the years ended December 31:
| 2017 | 2016 | 2015 | |||||||||
| (In millions) | |||||||||||
| Net cash provided by operating activities | $ | 743.5 | $ | 577.5 | $ | 663.8 | |||||
| Net cash (used in) provided by investing activities | $ | (1,105.5 | ) | $ | 493.2 | $ | (3,006.3 | ) | |||
| Net cash provided by (used in) financing activities | $ | 362.5 | $ | (1,064.2 | ) | $ | 2,440.9 |
Operating Activities
Net cash provided by operating activities increased to $743.5 million for the year ended December 31, 2017 compared to $577.5 million for the year ended December 31, 2016. The increase of $166.0 million in net cash provided by operating activities was primarily due to an increase in cash receipts from customers driven by an increase in revenues and operating profit. Our net cash provided by operating activities for the year ended December 31, 2016 also included a $99.9 million tax payment related to the gain on the sale of our healthcare business and a one time cash funding of our ESOP plan of $18.8 million. These operating cash expenditures in 2016 did not occur in 2017.
Net cash provided by operating activities decreased to $577.5 million for the year ended December 31, 2016 compared to $663.8 million for the year ended December 31, 2015. The decrease of $86.3 million in net cash provided by operating activities was primarily due to the additional income tax payments of $99.9 million related to the gain on the sale of our healthcare business and a one time cash funding of our ESOP plan of $18.8 million, partially offset by an increase in cash receipts from customers driven by an increase in revenues and operating profit as well as additional operating cash flow from the acquisition of Wood Mackenzie in May 2015.
Investing Activities
Net cash used in investing activities of $1,105.5 million for the year ended December 31, 2017 was primarily related to acquisitions, including escrow funding, of $914.9 million and capital expenditures of $183.5 million.
Net cash provided by investing activities of $493.2 million for the year ended December 31, 2016 was primarily related to proceeds from the sale our healthcare business of $714.6 million, partially offset by capital expenditures of $156.5 million and acquisitions including escrow payments of $74.1 million.
Net cash used in investing activities of $3,006.3 million for the year ended December 31, 2015 was primarily due to acquisitions including escrow payments of $2,856.4 million, which includes the acquisition of Wood Mackenzie, net of a gain on derivative instruments and capital expenditures of $166.1 million.
Financing Activities
Net cash provided by financing activities of $362.5 million for the year ended December 31, 2017 was primarily related to $615.0 million of borrowings, net under our Credit Facilities and proceeds from stock option exercises, net of net share settlement of taxes from restricted stock, of $32.1 million, partially offset by share repurchases of $276.3 million.
Net cash used in financing activities of $1,064.2 million for the year ended December 31, 2016 was primarily related to a $770.0 million repayments of borrowings under our Credit Facilities and share repurchases of $326.8 million, partially offset by proceeds from stock option exercises and other option-related items of $38.0 million.
Net cash provided by financing activities of $2,440.9 million for the year ended December 31, 2015 was primarily related to the net proceeds from the debt and equity offerings of $1,244.0 million and $720.8 million, respectively, and other borrowings from our old and new credit facilities of 830.0 million and proceeds from stock option exercises and other option-related items of $36.4 million, partially offset by repayments of short-term and long-term debt of $340.0 million, and repurchases of common stock of $20.4 million.
Contractual Obligations
The following table summarizes our contractual obligations at December 31, 2017 and the future periods in which such obligations are expected to be settled in cash:
| Payments Due by Period | |||||||||||||||||||
| Total | Less than 1 year | 2-3 years | 4-5 years | More than 5 years | |||||||||||||||
| (In millions) | |||||||||||||||||||
| Contractual obligations | |||||||||||||||||||
| Long-term debt, current portion of long-term debt and interest | $ | 3,319.8 | $ | 110.4 | $ | 454.3 | $ | 974.2 | $ | 1,780.9 | |||||||||
| Operating leases | 365.3 | 40.6 | 84.7 | 66.1 | 173.9 | ||||||||||||||
| Pension and postretirement plans (1) | 33.4 | 2.6 | 5.0 | 4.3 | 21.5 | ||||||||||||||
| Capital lease obligations | 18.0 | 10.0 | 6.6 | 1.4 | — | ||||||||||||||
| Other long-term liabilities (2) | 1.2 | 0.4 | 0.3 | — | 0.5 | ||||||||||||||
| Total (3) | $ | 3,737.7 | $ | 164.0 | $ | 550.9 | $ | 1,046.0 | $ | 1,976.8 |
| (1) | Our funding policy is to contribute at least equal to the minimum legal funding requirement. |
| (2) | Other long-term liabilities consist of our employee-related deferred compensation plan. We also have a deferred compensation plan for our Board of Directors; however, based on past performance and the uncertainty of the dollar amounts to be paid, if any, we have excluded such amounts from the above table. |
| (3) | Unrecognized tax benefits of approximately $16.3 million have been recorded as liabilities in accordance with ASC 740, which have been omitted from the table above, and we are uncertain as to if or when such amounts may be settled, with the exception of those amounts subject to a statute of limitation. Related to the unrecognized tax benefits, we also have recorded a liability for potential penalties and interest of $4.5 million. |
Off-Balance Sheet Arrangements
We have no off-balance sheet arrangements.
Critical Accounting Policies and Estimates
Our management’s discussion and analysis of financial condition and results of operations are based on our consolidated financial statements, which have been prepared in accordance with accounting principles generally accepted in the United States. The preparation of these financial statements require management to make estimates and judgments that affect reported amounts of assets and liabilities and related disclosures of contingent assets and liabilities at the dates of the financial statements and revenue and expenses during the reporting periods. These estimates are based on historical experience and on other assumptions that are believed to be reasonable under the circumstances. On an ongoing basis, management evaluates its estimates, including those related to revenue recognition, goodwill and intangible assets, pension and other post retirement benefits, stock based compensation, and income taxes. Actual results may differ from these assumptions or conditions.
Revenue Recognition
The Company’s revenues are primarily derived from sales of services and revenue is recognized as services are performed and information is delivered to our customers. Revenue is recognized when persuasive evidence of an arrangement exists, delivery has occurred or services have been rendered, fees and/or price are fixed or determinable, and collectability is reasonably assured. Revenues for subscription services are recognized ratably over the subscription term, usually one year. Revenues from transaction-based fees are recognized as information is delivered to customers, assuming all other revenue recognition criteria are met.
The Company also has term-based software licenses where the only remaining undelivered element is post-contract customer support, or PCS, including unspecified upgrade rights on a when-and-if available basis. The Company recognizes revenue for these licenses ratably over the duration of the license term. The PCS associated with these arrangements is coterminous with the duration of the license term. The Company also provides hosting or software solutions that provide continuous access to information and include PCS and recognizes revenue ratably over the duration of the license term. In addition, the determination of certain of our services revenues requires the use of estimates, principally related to transaction volumes in instances where these volumes are reported to us by our customers on a monthly basis in arrears. In these instances,
we estimate transaction volumes based on average actual volumes reported by our customers in the past. Differences between our estimates and actual final volumes reported are recorded in the period in which actual volumes are reported. We have not experienced significant variances between our estimates of these services revenues reported to us by our customers and actual reported volumes in the past.
We invoice our customers in annual, quarterly, or monthly installments. Amounts billed and collected in advance are recorded as deferred revenues on the balance sheet and are recognized as the services are performed and revenue recognition criteria are met.
Stock-Based Compensation
The fair value of equity awards is measured on the date of grant using a Black-Scholes option-pricing model, which requires the use of several estimates, including expected term, expected risk-free interest rate, expected volatility, and expected dividend yield.
Stock-based compensation cost is measured at the grant date, based on the fair value of the awards granted, and is recognized as expense over the requisite service period. Option grants and restricted stock awards are generally expensed ratably over the four-year vesting period. We follow the substantive vesting period approach for awards granted after January 1, 2005, which requires that stock-based compensation expense be recognized over the period from the date of grant to the date when the award is no longer contingent on the employee providing additional service.
We estimate expected forfeitures of equity awards at the date of grant and recognize compensation expense only for those awards expected to vest. The forfeiture assumption is ultimately adjusted to the actual forfeiture rate.
Goodwill and Intangibles
Goodwill represents the excess of acquisition costs over the fair value of tangible net assets and identifiable intangible assets of the businesses acquired. Goodwill and intangible assets deemed to have indefinite lives are not amortized. Intangible assets determined to have definite lives are amortized over their useful lives. Goodwill and intangible assets with indefinite lives are subject to impairment testing annually as of June 30, or whenever events or changes in circumstances indicate that the carrying amount may not be fully recoverable, using the guidance and criteria described in the accounting standard for Goodwill and Other Intangible Assets. This testing compares carrying values to fair values and, when appropriate, the carrying value of these assets is reduced to fair value.
As of December 31, 2017, we had goodwill of $3,368.7 million, which represents 56.0% of our total assets. During 2017, we performed an impairment test as of June 30, 2017 and confirmed that no impairment charge was necessary. As part of this process, we conducted the annual impairment test of our energy reporting unit at June 30, 2017, at which time the fair value exceeded its carrying value by less than 10.0%. This outcome is consistent with our expectation due to the decline in the GBP/USD exchange rate as well as current energy market conditions. The carrying value of the goodwill associated with our energy reporting unit was $1,841.8 million as of June 30, 2017.
There are many assumptions and estimates used that directly impact the results of impairment testing, including an estimate of future expected revenues, earnings and cash flows, useful lives and discount rates applied to such expected cash flows in order to estimate fair value. We have the ability to influence the outcome and ultimate results based on the assumptions and estimates we choose for determining the fair value of our reporting units. To mitigate undue influence, we set criteria and benchmarks that are reviewed and approved by various levels of management and reviewed by other independent parties. The determination of whether or not goodwill or indefinite-lived acquired intangible assets have become impaired involves a significant level of judgment in the assumptions and estimates underlying the approach used to determine the value of our reporting units. Changes in our strategy or market conditions could significantly impact these judgments and require an impairment to be recorded to intangible assets and goodwill. There have been no goodwill impairment indicators subsequent to the impairment test performed as of June 30, 2017. For the year ended December 31, 2017, there were no impairment indicators related to our intangible assets.
We allocate the fair value of the purchase consideration to the tangible assets acquired, liabilities assumed and intangible assets acquired based on their estimated fair values. The excess of the fair value of the purchase consideration over the fair values of these identifiable assets and liabilities is recorded as goodwill. Such valuations require management to make significant estimates and assumptions, especially with respect to intangible assets. The estimates used in valuing the intangible assets are determined with the assistance of third party specialists, a discounted cash flow analysis and estimates made by management. Management’s estimates of fair value are based upon assumptions believed to be reasonable, but which are inherently uncertain and unpredictable and, as a result, actual results may differ from estimates. During the measurement period, which is not to exceed one year from the acquisition date, we may record adjustments to the assets acquired and
liabilities assumed, with the corresponding offset to goodwill. Upon the conclusion of the measurement period, any subsequent adjustments are recorded to earnings.
Pension and Postretirement
We account for our pension and postretirement benefit plans in accordance with the accounting standard for Employers’ Accounting for Defined Benefit Pension and Other Postretirement Plans. This standard requires that employers recognize on a prospective basis the funded status of their defined benefit pension and other postretirement benefit plans on their consolidated balance sheets and recognize as a component of other comprehensive loss, net of tax, the gains or losses and prior service costs or credits that arise during the period but are not recognized as components of net periodic benefit (credit) cost.
Certain assumptions are used in the determination of our annual net period benefit (credit) cost and the disclosure of the funded status of these plans. The principal assumptions concern the discount rate used to measure the projected benefit obligation and the expected return on plan assets. We revise these assumptions based on an annual evaluation of long-term trends and market conditions that may have an impact on the cost of providing retirement benefits.
In determining the discount rate, we utilize quoted rates from long-term bond indices, and changes in long-term bond rates over the past year, cash flow models and other data sources we consider reasonable based upon the life expectancy and mortality rate of eligible employees. As part of our evaluation, we calculate the approximate average yields on securities that were selected to match our separate projected cash flows for both the pension and postretirement plans. Our separate benefit plan cash flows are input into actuarial models that include data for corporate bonds rated AA or better at the measurement date. The output from the actuarial models are assessed against the prior year’s discount rate and quoted rates for long-term bond indices. For our pension plans at December 31, 2017, we determined this rate to be 3.50%, a decrease of 0.49% from the 3.99% rate used at December 31, 2016. Our postretirement rate was 3.00% at December 31, 2017, a decrease of 0.25% from the 3.25% rate used at December 31, 2016.
The expected return on plan assets is determined by taking into consideration our analysis of our actual historical investment returns to a broader long-term forecast adjusted based on our target investment allocation, and the current economic environment. Our pension asset investment guidelines target an investment portfolio allocation of 40.0% debt securities and 60.0% equity securities. As of December 31, 2017, the pension plan assets were allocated 37.9% debt, 54.0% equity securities and 8.1% other. The VEBA Plan target allocation is 100% debt. We have used our target investment allocation to derive the expected return as we believe this allocation will be retained on an ongoing basis that will be commensurate with the projected cash flows of the plan. The expected return for each investment category within our target investment allocation is developed using average historical rates of return for each targeted investment category, considering the projected cash flow of the qualified pension plan and postretirement plan. The difference between this expected return and the actual return on plan assets is generally deferred and recognized over subsequent periods through future net periodic benefit (credits) costs. We believe these considerations provide the basis for reasonable assumptions with respect to the expected long-term rate of return on plan assets.
The measurement date used to determine the benefit obligation and plan assets is December 31. The future benefit payments for the postretirement plan are net of the federal medical subsidy. As a result of the Patient Protection and Affordable Care Act and the Health Care and Education Reconciliation Act of 2010, the tax treatment of federal subsidies paid to sponsors of retiree health benefit plans that provide prescription drug benefits that are at least actuarially equivalent to the corresponding benefits provided under Medicare Part D was effectively changed. This legislative change reduces future tax benefits of the coverage we provided to participants in the postretirement plan. We are required to account for this change in the period during which the law is enacted.
A one percent change in discount rate and future rate of return on plan assets would have the following effects:
| Pension | Postretirement | ||||||||||||||||||||||||||||||
| 1% Decrease | 1% Increase | 1% Decrease | 1% Increase | ||||||||||||||||||||||||||||
| Benefit (Credit) Cost | Projected Benefit Obligation | Benefit Cost (Credit) | Projected Benefit Obligation | Benefit Cost | Projected Benefit Obligation | Benefit (Credit) | Projected Benefit Obligation | ||||||||||||||||||||||||
| (In millions) | |||||||||||||||||||||||||||||||
| Discount Rate | $ | (0.7 | ) | $ | 50.1 | $ | 0.4 | $ | (41.9 | ) | $ | — | $ | 0.8 | $ | — | $ | (0.7 | ) | ||||||||||||
| Expected Rate of Return on Assets | $ | 4.3 | $ | — | $ | (4.3 | ) | $ | — | $ | 0.1 | $ | — | $ | (0.1 | ) | $ | — |
Income Taxes
In projecting future taxable income, we develop assumptions including the amount of future state, federal and foreign pretax operating income, the reversal of temporary differences, and the implementation of feasible and prudent tax planning strategies. These assumptions require significant judgment about the forecasts of future taxable income and are consistent with the plans and estimates we use to manage the underlying businesses. The calculation of our tax liabilities also involves dealing with uncertainties in the application and evolution of complex tax laws and regulations in other jurisdictions.
We account for uncertain tax positions in accordance with Accounting for Uncertainty in Income Taxes — an interpretation of ASC 740, which addresses the determination of whether tax benefits claimed or expected to be claimed on a tax return should be recorded in the financial statements. Under this interpretation, we may recognize the tax benefit from an uncertain tax position only if it is more likely than not that the tax position will be sustained upon examination by the taxing authorities, based on the technical merits of the position.
We recognize and adjust our liabilities when our judgment changes as a result of the evaluation of new information not previously available. Due to the complexity of some of these uncertainties, the ultimate resolution may result in a payment that is materially different from our current estimate of the tax liabilities. These differences will be reflected as increases or decreases to income tax expense in the period in which they are determined.
On December 22, 2017, President Trump signed comprehensive tax legislation commonly referred to as the Tax Cuts and Job Act, or Tax Act. The Tax Act makes complex changes to the tax law which will impact the 2017 year, including but not limited to 1) a re-measurement of deferred tax assets and liabilities as a result of the corporate tax rate change from 35.0% to 21.0%, 2) 100% bonus depreciation on qualifying property placed in service after September 27, 2017, and 3) requiring a one-time repatriation tax on foreign earnings.
Based on our initial analysis of the Tax Act, we have made reasonable estimates of its 2017 impact and have recorded provisional adjustments as follows:
| 1) | Due to the federal corporate rate reduction, a re-measurement of deferred tax assets and liabilities resulted in the recording of a benefit of approximately $89.1 million. |
| 2) | 100% bonus depreciation on qualifying assets resulted in an estimated decrease to the current income tax payable of approximately $8.0 million. |
| 3) | We are not expected to be impacted by the one-time repatriation tax on foreign earnings. |
The Tax Act will also affect 2018 and forward, including but not limited to 1) a reduction in the federal corporate rate from 35.0% to 21.0%, 2) elimination of the corporate alternative minimum tax, 3) creation of a new minimum tax - the base erosion anti-abuse tax, or BEAT, 4) a general elimination of U.S. federal income taxes on dividends from foreign subsidiaries, 5) a new provision designed to tax global intangible low-taxed income, or GILTI, 6) a new limitation on deductible interest expense, 7) the repeal of Section 199 domestic production activity deduction, 8) a new limitation on the deductibility of certain executive compensation, 9) limitations on net operating losses, or NOL’s, generated after December 31, 2017, 10) a special deduction for Foreign Derived Intangible Income, or FDII, and various other items. We have evaluated the above provisions and other than the reduction in corporate tax rate, we do not believe that the new provisions will have a material impact on the provision for income taxes.
We estimate unrecognized tax positions of $0.5 million that may be recognized by December 31, 2018, due to expiration of statutes of limitations and resolution of audits with taxing authorities, net of additional uncertain tax positions.
As of December 31, 2017, we have gross federal, state, and foreign income tax net operating loss carryforwards of $211.5 million, which will expire at various dates from 2018 through 2037. Such net operating loss carryforwards expire as follows:
| (In millions) | |||
| 2018 - 2025 | $ | 1.9 | |
| 2026 - 2030 | 3.8 | ||
| 2031 - 2037 | 205.8 | ||
| $ | 211.5 |
The net deferred income tax liability of $321.9 million consists primarily of timing differences involving depreciation and amortization.
Recent Accounting Pronouncements
For a discussion of recent accounting pronouncements, refer to Note 2(r) to the audited consolidated financial statements included elsewhere in this annual report on Form 10-K.
Previous: Item 6. Selected Financial Data · Next: Item 7A. Quantitative and Qualitative Disclosures about Market Risk