Item 7. MANAGEMENT'S DISCUSSION AND ANALYSIS OF FINANCIAL CONDITION AND RESULTS OF OPERATIONS
43K characters. Original on sec.gov · Markdown
Item 7. MANAGEMENT'S DISCUSSION AND ANALYSIS OF FINANCIAL CONDITION AND RESULTS OF OPERATIONS
You should read the following discussion in conjunction with "Selected Financial Data" and our Consolidated Financial Statements and related notes included in this Annual Report.
Overview
We are a diversified technology company. We operate businesses that design and develop software (both license and software-as-a-service) and engineered products and solutions for a variety of niche end markets.
We pursue consistent and sustainable growth in earnings and cash flow by emphasizing continuous improvement in the operating performance of our existing businesses and by acquiring other carefully selected businesses. Our acquisitions have represented both additions to existing businesses and new strategic platforms.
Application of Critical Accounting Policies
Our Consolidated Financial Statements are prepared in conformity with generally accepted accounting principles in the United States ("GAAP"). A discussion of our significant accounting policies can also be found in the notes to our Consolidated Financial Statements for the year ended December 31, 2017 included in this Annual Report.
GAAP offers acceptable alternative methods for accounting for certain issues affecting our financial results, such as determining inventory cost, depreciating long-lived assets and recognizing revenue. We have not changed the application of acceptable accounting methods or the significant estimates affecting the application of these principles in the last three years in a manner that had a material effect on our financial statements.
The preparation of financial statements in accordance with GAAP requires the use of estimates, assumptions, judgments and interpretations that can affect the reported amounts of assets, liabilities, revenues and expenses, the disclosure of contingent assets and liabilities and other supplemental disclosures.
The development of accounting estimates is the responsibility of our management. Our management discusses those areas that require significant judgments with the Audit Committee of our Board of Directors. The Audit Committee has reviewed all financial disclosures in our annual filings with the SEC. Although we believe the positions we have taken with regard to uncertainties are reasonable, others might reach different conclusions and our positions can change over time as more information becomes available. If an accounting estimate changes, its effects are accounted for prospectively or through a cumulative catch up adjustment.
Our most significant accounting uncertainties are encountered in the areas of accounts receivable collectibility, inventory valuation, future warranty obligations, revenue recognition (percentage-of-completion), income taxes and goodwill and indefinite-lived impairment analyses. These issues affect each of our business segments and are evaluated using a combination of historical experience, current conditions and relatively short-term forecasting.
Accounts receivable collectibility is based on the economic circumstances of customers and credits given to customers after shipment of products, including in certain cases credits for returned products. Accounts receivable are regularly reviewed to determine customers who have not paid within agreed upon terms, whether these amounts are consistent with past experiences, what historical experience has been with amounts deemed uncollectible and the impact that economic conditions might have on collection efforts in general and with specific customers. The returns and other sales credit allowance is an estimate of customer returns, exchanges, discounts or other forms of anticipated concessions and is treated as a reduction in revenue. The returns and other sales credits histories are analyzed to determine likely future rates for such credits. At December 31, 2017, our allowance for doubtful accounts receivable was $10.3 million and our allowance for sales returns and sales credits was $2.4 million, for a total of $12.7 million, or 1.9% of total gross accounts receivable, as compared to a total of $14.5 million, or 2.3% of total gross accounts receivable, at December 31, 2016. This percentage is influenced by the risk profile of the underlying receivables, and the timing of write-offs of accounts deemed uncollectible.
We regularly compare inventory quantities on hand against anticipated future usage, which we determine as a function of historical usage or forecasts related to specific items in order to evaluate obsolescence and excessive quantities. When we use historical usage, this information is also qualitatively compared to business trends to evaluate the reasonableness of using historical information as an estimate of future usage. At December 31, 2017, inventory reserves for excess and obsolete inventory were $38.1 million, or 15.7% of gross inventory cost, as compared to $37.2 million, or 17.0% of gross inventory cost, at December 31,
- The inventory reserve as a percent of gross inventory cost will continue to fluctuate based upon specific identification of reserves needed based upon changes in our business as well as the physical disposal of obsolete inventory.
Most of our product-based revenues are covered by warranty provisions that generally provide for the repair or replacement of qualifying defective items for a specified period after the time of sale, typically 12 to 24 months. Future warranty obligations are evaluated using, among other factors, historical cost experience, product evolution and customer feedback. Our expense for warranty obligations was less than 1% of net revenues for each of the years ended December 31, 2017, 2016 and 2015.
Revenues related to the use of the percentage-of-completion method of accounting are dependent on total costs incurred compared with total estimated costs for a project. During the years ended December 31, 2017, 2016 and 2015 we recognized revenue of $249 million, $241 million and $253 million, respectively, using this method. Percentage-of-completion is used primarily for major turn-key, longer term toll and traffic and energy projects and installations of large software application projects. At December 31, 2017, $253 million of revenue related to unfinished percentage-of-completion contracts had yet to be recognized.
Income taxes can be affected by estimates of whether and within which jurisdictions future earnings will occur and if, how and when cash is repatriated to the U.S., combined with other aspects of an overall income tax strategy. Additionally, taxing jurisdictions could retroactively disagree with our tax treatment of certain items, and some historical transactions have income tax effects going forward. Accounting rules require these future effects to be evaluated using current laws, rules and regulations, each of which can change at any time and in an unpredictable manner. During 2017, our effective income tax rate was 6.1%, as compared to the 2016 rate of 30.0%. The decrease was due primarily to the recognition of a $215 million net income tax benefit related to the Tax Act as well as increased excess tax benefits related to equity compensation in 2017 as compared to 2016. We expect the effective tax rate for 2018 to be between 21% and 23%.
We account for goodwill in a purchase business combination as the excess of the cost over the estimated fair value of net assets acquired. Goodwill, which is not amortized, is tested for impairment on an annual basis in conjunction with our annual forecast process during the fourth quarter (or an interim basis if an event occurs or circumstances change that would more likely than not reduce the fair value of a reporting unit below its carrying value).
When testing goodwill for impairment, we have the option to first assess qualitative factors to determine whether the existence of events or circumstances leads to a determination that it is more likely than not that the estimated fair value of a reporting unit is less than its carrying amount. If we elect to perform a qualitative assessment and determine that an impairment is more likely than not, we are then required to perform the quantitative impairment test; otherwise, no further analysis is required. Under the qualitative assessment, we consider various qualitative factors, including macroeconomic conditions, relevant industry and market trends, cost factors, overall financial performance, other entity-specific events and events affecting the reporting unit that could indicate a potential change in the fair value of our reporting unit or the composition of its carrying values. We also consider the specific future outlook for the reporting unit.
We also may elect not to perform the qualitative assessment and, instead, proceed directly to the quantitative impairment test. The quantitative assessment utilizes both an income approach (discounted cash flows) and a market approach consisting of a comparable company earnings multiples methodology to estimate the fair value of a reporting unit. To determine the reasonableness of the estimated fair values, we review the assumptions to ensure that neither the income approach nor the market approach provides significantly different valuations. If the estimated fair value exceeds the carrying value, no further work is required and no impairment loss is recognized. If the carrying value exceeds the estimated fair value, a non-cash impairment loss is recognized in the amount of that excess.
Key assumptions used in the income and market approaches are updated when the analysis is performed for each reporting unit. Various assumptions are utilized including forecasted operating results, strategic plans, economic projections, anticipated future cash flows, the weighted-average cost of capital, comparable transactions, market data and earnings multiples. While we use reasonable and timely information to prepare our cash flow and discount rate assumptions, actual future cash flows or market conditions could differ significantly and could result in future non-cash impairment charges related to recorded goodwill balances.
Recently acquired reporting units generally represent a higher inherent risk of impairment, which typically decreases as the businesses are integrated into our enterprise. Negative industry or economic trends, disruptions to our business, actual results significantly below projections, unexpected significant changes or planned changes in the use of the assets, divestitures and market capitalization declines may have a negative effect on the fair value of our reporting units.
We have 33 reporting units with individual goodwill amounts ranging from zero to $2.3 billion. In 2017, we performed our annual impairment test in the fourth quarter for all reporting units. We conducted our analysis qualitatively and assessed whether it was more likely than not that the respective fair value of these reporting units was less than the carrying amount. We determined that
impairment of goodwill was not likely in 31 of our reporting units and thus we were not required to perform a quantitative analysis for these reporting units. For the remaining two reporting units, the Company performed its quantitative analysis and concluded that the fair value of each of these two reporting units was substantially in excess of its carrying value, with no impairment indicated as of October 1, 2017.
Business combinations can also result in other intangible assets being recognized. Amortization of intangible assets, if applicable, occurs over their estimated useful lives. Trade names that are determined to have an indefinite useful economic life are not amortized, but separately tested for impairment during the fourth quarter of the fiscal year or on an interim basis if an event occurs that indicates the fair value is more likely than not below the carrying value. We first qualitatively assess whether the existence of events or circumstances leads to a determination that it is more likely than not that the estimated fair value of the indefinite-lived trade name is less than its carrying amount. If necessary, we conduct a quantitative review using the relief-from-royalty method, which we believe to be an acceptable methodology due to its common use by valuation specialists in determining the fair value of intangible assets. This methodology assumes that, in lieu of ownership, a third-party would be willing to pay a royalty in order to exploit the related benefits of these assets. The fair value of each trade name is determined by applying a royalty rate to a projection of net revenues discounted using a risk-adjusted rate of capital. Each royalty rate is determined based on the profitability of the trade name to which it relates and observed market royalty rates. Revenue growth rates are determined after considering current and future economic conditions, recent sales trends, discussions with customers, planned timing of new product launches or other variables. Trade names resulting from recent acquisitions generally represent the highest risk of impairment, which typically decreases as the businesses are integrated into our enterprise and positioned for improved future sales growth.
The assessment of fair value for impairment purposes requires significant judgments to be made by management. Although our forecasts are based on assumptions that are considered reasonable by management and consistent with the plans and estimates management uses to operate the underlying businesses, there is significant judgment in determining the expected results attributable to the reporting units. Changes in estimates or the application of alternative assumptions could produce significantly different results. No impairment resulted from the annual reviews performed in 2017.
We evaluate whether there has been an impairment of identifiable intangible assets with definite useful economic lives, or of the remaining life of such assets, when certain indicators of impairment are present. In the event that facts and circumstances indicate that the cost or remaining period of amortization of any asset may be impaired, an evaluation of recoverability would be performed. If an evaluation is required, the estimated future gross, undiscounted cash flows associated with the asset would be compared to the asset's carrying amount to determine if a write-down to fair value or a revision in the remaining amortization period is required.
Results of Operations
The following table sets forth selected information for the years indicated. Dollar amounts are in thousands and percentages are of net revenues. Percentages may not foot due to rounding.
| Years ended December 31, | |||||||||||
| 2017 | 2016 | 2015 | |||||||||
| Net revenues: | |||||||||||
| RF Technology (1) | $ | 1,862,126 | $ | 1,210,264 | $ | 1,033,951 | |||||
| Medical & Scientific Imaging (2) | 1,410,349 | 1,362,813 | 1,215,318 | ||||||||
| Industrial Technology (3) | 783,707 | 706,625 | 745,381 | ||||||||
| Energy Systems & Controls (4) | 551,289 | 510,223 | 587,745 | ||||||||
| Total | $ | 4,607,471 | $ | 3,789,925 | $ | 3,582,395 | |||||
| Gross margin: | |||||||||||
| RF Technology | 61.1 | % | 56.7 | % | 53.4 | % | |||||
| Medical & Scientific Imaging | 72.0 | 73.2 | 74.0 | ||||||||
| Industrial Technology | 50.6 | 50.6 | 49.8 | ||||||||
| Energy Systems & Controls | 57.4 | 57.1 | 58.1 | ||||||||
| Total | 62.2 | % | 61.5 | % | 60.4 | % | |||||
| Segment operating margin: | |||||||||||
| RF Technology | 25.7 | % | 30.8 | % | 30.2 | % | |||||
| Medical & Scientific Imaging | 34.5 | 35.0 | 36.4 | ||||||||
| Industrial Technology | 30.0 | 28.7 | 28.8 | ||||||||
| Energy Systems & Controls | 27.4 | 25.4 | 27.6 | ||||||||
| Total | 29.3 | % | 31.2 | % | 31.6 | % | |||||
| Corporate administrative expenses | (3.1 | )% | (3.4 | )% | (2.9 | )% | |||||
| Income from continuing operations | 26.3 | 27.8 | 28.7 | ||||||||
| Interest expense, net | (3.9 | ) | (2.9 | ) | (2.4 | ) | |||||
| Other income/(expense) | 0.1 | (0.1 | ) | 1.6 | |||||||
| Income from continuing operations before taxes | 22.5 | 24.8 | 28.0 | ||||||||
| Income taxes | (1.4 | ) | (7.4 | ) | (8.5 | ) | |||||
| Net earnings | 21.1 | % | 17.4 | % | 19.4 | % |
| (1) | Includes results from the acquisitions of Foodlink Holdings Inc. from July 2, 2014, On Center Software LLC from July 20, 2015, RF Ideas Inc. from September 1, 2015, Aderant Holdings Inc. from October 21, 2015, Black Diamond Advanced Technologies through March 20, 2015, ConstructConnect from October 31, 2016, Deltek, Inc. from December 28, 2016, Handshake Software, Inc. from August 4, 2017, Workbook Software A/S from September 15, 2017 and Onvia, Inc. from November 17, 2017. |
| (2) | Includes results from the acquisitions of Strata Decision Technologies LLC from January 21, 2015, SoftWriters Inc. from February 9, 2015, Data Innovations LLC from March 4, 2015, Atlantic Health Partners LLC from September 4, 2015, Atlas Database Software Corp. from October 26, 2015, CliniSys from January 7, 2016, PCI Medical from March 17, 2016, GeneInsight from April 1, 2016 and UNIConnect from November 10, 2016. |
| (3) | Includes results from Abel Pumps through October 2, 2015. |
| (4) | Includes results from the acquisition of Phase Technology from June 21, 2017. |
Year Ended December 31, 2017 Compared to Year Ended December 31, 2016
Net revenues for the year ended December 31, 2017 were $4.61 billion as compared to $3.79 billion for the year ended December 31, 2016, an increase of 21.6%. The increase was the result of contributions from acquisitions of 16.3%, organic growth of 5.3% and no impact from foreign exchange.
In our RF Technology segment, net revenues for the year ended December 31, 2017 increased by $651.9 million or 54% over the year ended December 31, 2016. Acquisitions accounted for 51% and organic revenues increased by 3%. The increase in organic revenues was due primarily to growth in our software businesses. Gross margin was 61.1% for the year ended December 31, 2017 as compared to 56.7% for the year ended December 31, 2016, due primarily to an increased percentage of revenues from our software businesses, which have a higher gross margin. Selling, general and administrative ("SG&A") expenses as a percentage of revenues in the year ended December 31, 2017 increased to 35.3%, as compared to 25.9% in the year ended December 31, 2016, due primarily to an increased percentage of revenues from our software businesses, which have a higher SG&A structure, including amortization of acquired intangibles. The resulting operating margin was 25.7% in 2017 as compared to 30.8% in 2016.
Our Medical & Scientific Imaging segment reported a $47.5 million or 3% increase in net revenues for the year ended December 31, 2017 over the year ended December 31, 2016, all of which was attributable to organic growth. The growth in organic revenues was due primarily to increased sales in our medical products businesses, led by NDI, and our alternate site healthcare businesses. Gross margin decreased to 72.0% for the year ended December 31, 2017 from 73.2% for the year ended December 31, 2016, due primarily to an unfavorable sales mix at both our software and medical products businesses. SG&A expenses as a percentage of net revenues decreased to 37.5% in the year ended December 31, 2017, as compared to 38.2% in the year ended December 31, 2016, due primarily to operating leverage on higher sales. The resulting operating margin was 34.5% in the year ended December 31, 2017 as compared to 35.0% in the year ended December 31, 2016.
Net revenues for our Industrial Technology segment increased by $77.1 million or 11% for the year ended December 31, 2017 from the year ended December 31, 2016, all of which was attributable to organic growth. The growth in organic revenues was broad-based, due primarily to our fluid handling, water meter technology and materials testing businesses. Gross margin was consistent at 50.6% for the years ended December 31, 2017 and 2016. SG&A expenses as a percentage of net revenues were 20.6% in the year ended December 31, 2017, as compared to 21.9% in the year ended December 31, 2016, due primarily to operating leverage on higher sales volume. The resulting operating margin was 30.0% in the year ended December 31, 2017 as compared to 28.7% in the year ended December 31, 2016.
In our Energy Systems & Controls segment, net revenues for the year ended December 31, 2017 increased by $41.1 million or 8% from the year ended December 31, 2016. Organic sales increased by 7% and the benefit from foreign exchange and acquisitions totaled 1%. The growth in organic revenues was due primarily to increased sales in pressure sensors and valves businesses serving energy markets as well as businesses serving industrial end markets. Gross margin increased to 57.4% in the year ended December 31, 2017 as compared to 57.1% in the year ended December 31, 2016 and SG&A expenses as a percentage of net revenues decreased to 30.0% in the year ended December 31, 2017, as compared to 31.7% in the year ended December 31, 2016, both of which were due to operating leverage on higher sales volume. As a result, operating margin was 27.4% in the year ended December 31, 2017 as compared to 25.4% in the year ended December 31, 2016.
Corporate expenses increased by $14.3 million to $141.8 million, or 3.1% of revenues, in 2017 as compared to $127.5 million, or 3.4% of revenues, in 2016. The dollar increase was due primarily to increased incentive compensation and professional services.
Interest expense increased $69.0 million, or 61.9%, for the year ended December 31, 2017 as compared to the year ended December 31, 2016. The increase was due primarily to higher average debt balances to fund acquisitions at the end of 2016.
Other income, net, of $5.0 million for the year ended December 31, 2017 was composed primarily of a $9.4 million gain on sale of a product line in our Energy Systems & Controls segment, offset in part by a $1.8 million charge on a minority investment and foreign exchange losses at our non-U.S. based companies. Other expense of $1.5 million for the year ended December 31, 2016 was composed primarily of foreign exchange losses at our non-U.S. based companies, offset in part by royalty income.
During 2017, our effective income tax rate was 6.1% as compared to our 2016 rate of 30.0%. The decrease was due primarily to the recognition of a $215 million net income tax benefit related to the Tax Act as well as increased excess tax benefits related to equity compensation in 2017 as compared to 2016.
The following table summarizes order backlog information at December 31, 2017 and 2016 (dollar amounts in thousands). We include in backlog only orders that are expected to be recognized as revenue within twelve months.
| 2017 | 2016 | change | ||||||||
| RF Technology | $ | 991,382 | $ | 991,212 | — | % | ||||
| Medical & Scientific Imaging | 467,836 | 423,616 | 10.4 | |||||||
| Industrial Technology | 110,841 | 65,259 | 69.8 | |||||||
| Energy Systems & Controls | 102,293 | 92,309 | 10.8 | |||||||
| Total | $ | 1,672,352 | $ | 1,572,396 | 6.4 | % |
Year Ended December 31, 2016 Compared to Year Ended December 31, 2015
Net revenues for the year ended December 31, 2016 were $3.79 billion as compared to $3.58 billion for the year ended December 31, 2015, an increase of 5.8%. The increase was the result of contributions from acquisitions of 6.8%, negative organic growth of 0.3% and a negative foreign exchange impact of 0.7%.
In our RF Technology segment, net revenues for the year ended December 31, 2016 increased by $176 million or 17% over the year ended December 31, 2015. Acquisitions net of the divestiture of the Black Diamond Advanced Technology business added 15%, organic revenues increased by 3%, and the negative foreign exchange impact was 1%. The increase in organic revenues was due primarily to increased sales in our software businesses, offset in part by the completion of large service contracts in our toll and traffic businesses in 2015. Gross margin was 56.7% in 2016 as compared to 53.4% in the prior year due to product mix in our toll and traffic businesses as well as an increased percentage of revenues at our software businesses which have a higher gross margin. SG&A expenses as a percentage of net revenues in the year ended December 31, 2016 increased to 25.9%, as compared to 23.3% in the prior year due primarily to an increased percentage of net revenues at our software businesses which have a higher SG&A structure. Operating margin was 30.8% in 2016 as compared to 30.2% in 2015.
Our Medical & Scientific Imaging segment reported a $147 million or 12% increase in net revenues for the year ended December 31, 2016 over the year ended December 31, 2015. Acquisitions contributed 9%, organic revenues increased 4% and the negative foreign exchange impact was 1%. The increase in organic revenues was due to increased sales in our medical businesses, led by NDI and Verathon. Gross margin decreased to 73.2% in the year ended December 31, 2016 from 74.0% in the year ended December 31, 2015, due primarily to product mix. SG&A expenses as a percentage of net revenues increased to 38.2% in the year ended December 31, 2016 as compared to 37.7% in the year ended December 31, 2015, due to a higher SG&A structure in our medical businesses. Operating margin was 35.0% in the year ended December 31, 2016 as compared to 36.4% in the year ended December 31, 2015.
Net revenues for our Industrial Technology segment decreased by $39 million or 5.2% for the year ended December 31, 2016 from the year ended December 31, 2015. The divestiture of the Abel Pumps business in 2015 accounted for a negative 3.1%, organic revenues decreased by 1.5% and the negative foreign exchange impact was 0.6%. The decrease in organic revenues was due primarily to decreased sales in those fluid handling businesses that serve oil and gas markets, offset in part by increased sales in our water metering business. Gross margin increased to 50.6% for the year ended December 31, 2016 as compared to 49.8% in the year ended December 31, 2015 due to product mix. SG&A expenses as a percentage of net revenues were 21.9%, as compared to 21.0% in the prior year, due primarily to negative leverage on lower sales volume. The resulting operating margin was 28.7% in the year ended December 31, 2016 as compared to 28.8% in the year ended December 31, 2015.
In our Energy Systems & Controls segment, net revenues for the year ended December 31, 2016 decreased by $78 million or 13% from the year ended December 31, 2015. Organic revenues decreased by 12% due to decreased sales in oil and gas products, including safety systems and valves, and the negative foreign exchange impact was 1%. Gross margin decreased to 57.1% in the year ended December 31, 2016 as compared to 58.1% in the year ended December 31, 2015 and SG&A expenses as a percentage of net revenues increased to 31.7% as compared to 30.5% in the prior year, both of which were due to negative leverage on lower sales volume. Operating margin was 25.4% in the year ended December 31, 2016 as compared to 27.6% in the year ended December 31, 2015.
Corporate expenses increased by $24.7 million to $127.5 million, or 3.4% of net revenues, in 2016 as compared to $102.8 million, or 2.9% of net revenues, in 2015. The increase was due primarily to increased equity compensation costs as a result of both an increase in the number of shares granted in the current year and increases in our common stock price and increased costs related to acquisitions.
Interest expense increased $27.3 million, or 32.5%, for the year ended December 31, 2016 as compared to the year ended December 31, 2015. The increase was due primarily to higher average debt balances to fund current year acquisitions as well as higher average interest rates throughout 2016.
Other expense of $1.5 million for the year ended December 31, 2016 was composed primarily of foreign exchange losses at our non-U.S. based companies, offset in part by royalty income. Other income of $58.7 million for the year ended December 31, 2015 was composed primarily of the $70.9 million gain from the divestiture of Abel Pumps (see Note 2 of the Notes to Consolidated Financial Statements included in this Annual Report), offset in part by a $9.5 million impairment charge on a minority investment.
During 2016, our effective income tax rate was 30.0%, which was 60 basis points lower than the 2015 rate of 30.6%. The decrease was due to the recognition of $15.3 million in excess tax benefits in the current year in accordance with an ASU related to stock compensation adopted in the first quarter of 2016 (see Note 1 of the Notes to Consolidated Financial Statements included in this Annual Report), as well as the non-recurrence of the 2015 taxable gain on the divestiture of Abel Pumps which was partially offset by discrete tax benefits from settlements of tax matters in 2015.
The following table summarizes order backlog information at December 31, 2016 and 2015 (dollar amounts in thousands). We include in backlog only orders that are expected to be recognized as revenue within twelve months.
| 2016 | 2015 | change | ||||||||
| RF Technology | $ | 991,212 | $ | 538,877 | 83.9 | % | ||||
| Medical & Scientific Imaging | 423,616 | 373,213 | 13.5 | % | ||||||
| Industrial Technology | 65,259 | 68,002 | (4.0 | )% | ||||||
| Energy Systems & Controls | 92,309 | 90,365 | 2.2 | % | ||||||
| Total | $ | 1,572,396 | $ | 1,070,457 | 46.9 | % |
Financial Condition, Liquidity and Capital Resources
Selected cash flows for the years ended December 31, 2017, 2016 and 2015 are as follows (in millions):
| 2017 | 2016 | 2015 | |||||||||
| Cash provided by/(used in): | |||||||||||
| Operating activities | $ | 1,234 | $ | 964 | $ | 929 | |||||
| Investing activities | (210 | ) | (3,753 | ) | (1,698 | ) | |||||
| Financing activities | (1,170 | ) | 2,805 | 996 |
Operating activities - The increase in cash provided by operating activities in 2017 and in 2016 was primarily due to increased earnings net of non-cash expenses and higher deferred revenue balances due to an increased percentage of revenue from software and other subscription based products. The increase in cash provided by operating activities in 2016 was offset in part by income tax payments in the first quarter of 2016 related to the gain on the sale of the Abel Pumps business in the fourth quarter of 2015.
Investing activities - Cash used in investing activities during 2017, 2016 and 2015 was primarily for business acquisitions. Cash received from investing activities in 2015 was primarily proceeds from the sale of the Abel Pumps business.
Financing activities - Cash used in/provided by financing activities in all periods presented was primarily debt repayments/borrowings as well as dividends paid to stockholders. Cash used in financing activities during 2017 was primarily from the pay-down of revolving debt borrowings of $660 million and the repayment of $400 million of senior notes. Cash provided by financing activities during 2016 was primarily from the issuance of $1.2 billion of senior notes and revolving debt borrowings for acquisitions.
Cash and cash equivalents increased as a result of the effects of foreign currency exchange rate changes during the year ended December 31, 2017 by $59 million as compared to decreases during the years ended December 31, 2016 and 2015 of $38 million and $59 million, respectively. The increase for the year ended December 31, 2017 was due primarily to the strengthening of functional currencies of our European subsidiaries against the U.S. dollar, while the decreases for the years ended December 31, 2016 and 2015 were due primarily to the weakening of functional currencies of our European subsidiaries against the U.S. dollar.
Net working capital (current assets, excluding cash, less total current liabilities, excluding debt) was a negative $140 million at December 31, 2017 compared to negative $25 million at December 31, 2016, due primarily to increased deferred revenues. This deferred revenue increase is due to a higher percentage of revenue from software and subscription-based services along with the impact of fair value purchase accounting resulting from 2016 acquisitions.
Total debt was $5.2 billion at December 31, 2017 (43.0% of total capital) compared to $6.2 billion at December 31, 2016 (51.8% of total capital). Our decreased debt at December 31, 2017 compared to December 31, 2016 was due primarily to the pay-down of revolving debt borrowings of $660 million and the repayment of $400 million of senior notes.
On September 23, 2016, we entered into a five-year unsecured credit facility (the "2016 Facility") with JPMorgan Chase Bank, N.A., as administrative agent, and a syndicate of lenders, which replaced our previous unsecured credit facility, dated as of July 27, 2012, as amended as of October 28, 2015 (the "2012 Facility"). The 2016 Facility comprises a five year $2.5 billion revolving credit facility, which includes availability of up to $150 million for letters of credit. We may also, subject to compliance with specified conditions, request term loans or additional revolving credit commitments in an aggregate amount not to exceed $500 million.
The 2016 Facility contains various affirmative and negative covenants which, among other things, limit our ability to incur new debt, enter into certain mergers and acquisitions, sell assets and grant liens, make restricted payments (including the payment of dividends on our common stock) and capital expenditures, or change our line of business. We also are subject to financial covenants which require us to limit our consolidated total leverage ratio and to maintain a consolidated interest coverage ratio. The most restrictive covenant is the consolidated total leverage ratio which is limited to 3.5 to 1.
On December 2, 2016, we amended the 2016 Facility to allow the consolidated total leverage ratio be increased, no more than twice during the term of the 2016 Facility, to 4.0 to 1 for a consecutive four quarter fiscal period per increase (or, for any portion of such four quarter fiscal period in which the maximum would be 4.25 to 1 pursuant to the 2016 facility amendment, 4.25 to 1). In conjunction with the Deltek acquistion (see Note 2 of the Notes to Consolidated Financial Statements included in this Annual Report), we increased the maximum consolidated total leverage ratio covenant to 4.25 to 1 through June 30, 2017 and 4.00 to 1 through December 31, 2017.
At December 31, 2017, we had $3.9 billion of senior unsecured notes and $1.3 billion of outstanding revolver borrowings. In addition, we had $3.1 million of other debt in the form of capital leases and several smaller facilities that allow for borrowings or the issuance of letters of credit in foreign locations to support our non-U.S. businesses. We had $75.9 million of outstanding letters of credit at December 31, 2017, of which $33.1 million was covered by our lending group, thereby reducing our revolving credit capacity commensurately.
We may redeem some or all of these notes at any time or from time to time, at 100% of their principal amount, plus a make-whole premium based on a spread to U.S. Treasury securities.
We were in compliance with all debt covenants related to our credit facility throughout the years ended December 31, 2017 and 2016.
See Note 8 of the Notes to Consolidated Financial Statements included in this Annual Report for additional information regarding our credit facility and senior notes.
Cash and cash equivalents at our foreign subsidiaries at December 31, 2017 totaled $592 million. The Tax Act included a one-time deemed mandatory repatriation tax on all undistributed foreign earnings, resulting in a charge of $110.7 million as of December 31, 2017. The Company will elect to pay the liability over 8 years. In addition, the introduction of a modified territorial taxation system resulted in a one-time estimated charge of $28.7 million due to the Company’s change in its indefinite reinvestment assertion on foreign earnings. The Company now intends to distribute all historical earnings subject to the deemed repatriation tax and has provided for deferred taxes related to the future state and foreign tax cost to repatriate. See Note 7 of the Notes to Consolidated Financial Statements included in this Annual Report for additional information regarding income taxes.
Capital expenditures of $48.8 million, $37.3 million and $36.3 million were incurred during 2017, 2016 and 2015, respectively. Capitalized software expenditures of $10.8 million, $2.8 million and $2.4 million were incurred during 2017, 2016 and 2015, respectively. The increases in 2017 as compared to 2016 was due primarily to our 2016 acquisitions. In the future, we expect the aggregate of capital expenditures and capitalized software expenditures as a percentage of annual net revenues to be between 1.0% and 1.5%.
Contractual Cash Obligations and Other Commercial Commitments and Contingencies
The following tables quantify our contractual cash obligations and commercial commitments at December 31, 2017 (in thousands).
| Payments Due in Fiscal Year | |||||||||||||||||||||||||||
| Contractual Cash Obligations 1 | Total | 2018 | 2019 | 2020 | 2021 | 2022 | Thereafter | ||||||||||||||||||||
| Total debt | $ | 5,170,009 | $ | 800,009 | $ | 500,000 | $ | 600,000 | $ | 1,770,000 | $ | 500,000 | $ | 1,000,000 | |||||||||||||
| Senior note interest | 579,657 | 129,325 | 106,608 | 85,025 | 67,269 | 51,822 | 139,608 | ||||||||||||||||||||
| Capital leases | 3,140 | 1,494 | 1,061 | 529 | 47 | 9 | — | ||||||||||||||||||||
| Operating leases | 272,285 | 61,109 | 49,563 | 42,109 | 35,473 | 26,014 | 58,017 | ||||||||||||||||||||
| Total | $ | 6,025,091 | $ | 991,937 | $ | 657,232 | $ | 727,663 | $ | 1,872,789 | $ | 577,845 | $ | 1,197,625 |
| Amounts Expiring in Fiscal Year | |||||||||||||||||||||||||||
| Other Commercial Commitments | Total Amount Committed | 2018 | 2019 | 2020 | 2021 | 2022 | Thereafter | ||||||||||||||||||||
| Standby letters of credit and bank guarantees | $ | 75,898 | $ | 28,614 | $ | 1,921 | $ | 723 | $ | 34,006 | $ | 10,351 | $ | 283 |
1 We have excluded the liability for uncertain tax positions and other income tax liabilities resulting from the Tax Act considered "provisional." See Note 7 of the Notes to Consolidated Financial Statements included in this Annual Report.
As of December 31, 2017, we had $573.4 million of outstanding surety bonds. Certain contracts, primarily those involving public sector customers, require us to provide a surety bond as a guarantee of its performance of contractual obligations.
We believe that internally generated cash flows and the remaining availability under our credit facility will be adequate to finance normal operating requirements. Although we maintain an active acquisition program, any future acquisitions will be dependent on numerous factors and it is not feasible to reasonably estimate if or when any such acquisitions will occur and what the impact will be on our activities, financial condition and results of operations. We may also explore alternatives to attract additional capital resources.
We anticipate that our businesses will generate positive cash flows from operating activities, and that these cash flows will permit the reduction of currently outstanding debt in accordance with the repayment schedule. However, the rate at which we can reduce our debt during 2018 (and reduce the associated interest expense) will be affected by, among other things, the financing and operating requirements of any new acquisitions and the financial performance of our existing companies. None of these factors can be predicted with certainty.
Off-Balance Sheet Arrangements
At December 31, 2017 and 2016, we did not have any relationships with unconsolidated entities or financial partnerships, such as entities often referred to as structured finance or special purpose entities, which would have been established for the purpose of facilitating off-balance sheet arrangements or other contractually narrow or limited purposes.
Recently Issued Accounting Standards
See Note 1 of the Notes to Consolidated Financial Statements included in this Annual Report for information regarding the effect of new accounting pronouncements on our consolidated financial statements.
Previous: Item 6. SELECTED FINANCIAL DATA · Next: Item 7A. QUANTITATIVE AND QUALITATIVE DISCLOSURES ABOUT MARKET RISK