EX-99.2 4 d588870dex992.htm EX-99.2 EX-99.2

Exhibit 99.2

UNAUDITED PRO FORMA COMBINED FINANCIAL STATEMENTS

The following unaudited pro forma combined financial data was based on and should be read in conjunction with (i) the historical consolidated financial statements of the Company included in its Annual Report on Form 10-K for the year ended December 29, 2017 and (ii) the audited consolidated financial statements of Viewpoint as of and for the year ended December 31, 2017 included in this Current Report on Form 8-K. The unaudited pro forma combined statements of income and balance sheet give effect to the Viewpoint Acquisition and the related transactions described herein as if such transactions occurred on the first day of the fiscal year ended December 29, 2017 for statement of income purposes and on the last day of the fiscal year ended December 29, 2017 for balance sheet purposes.

Viewpoint is the operating company and an indirect wholly-owned subsidiary of Waterfall. Waterfall was formed solely for the purpose of holding the common stock of Intermediate, which was formed solely for the purpose of holding the common stock of Viewpoint. Neither Waterfall nor Intermediate is engaged in any business activities other than acting as a holding company, and neither Waterfall nor Intermediate has any material tangible assets or liabilities, except ownership of stock in the subsidiary. Audited historical financial statements for Waterfall and its consolidated subsidiaries are not currently available. Following the closing of the Viewpoint Acquisition, the Company will be required to prepare and file with the SEC historical financial information, including quarterly financial information, for Waterfall and its consolidated subsidiaries, which will be prepared in accordance with GAAP applicable to public companies, as well as related pro forma financial information giving effect to the Viewpoint Acquisition on the Company’s financial results for those periods. The historical financial information for Waterfall and its consolidated subsidiaries included in those SEC filings may differ materially from the historical financial information for Viewpoint due to the amortization of intangible assets and the tax effects thereof, purchase price allocation adjustments and changes that may be required to present such statements in accordance with GAAP applicable to public companies.

The Company’s fiscal year ended on December 29, 2017 and Viewpoint’s fiscal year ended on December 31, 2017. The unaudited pro forma combined statement of income for the year ended December 31, 2017 combines the Company’s year ended December 29, 2017 with Viewpoint’s year ended December 31, 2017.

The unaudited pro forma combined financial data should be read in conjunction with the accompanying notes to the unaudited pro forma combined financial statements. The unaudited pro forma combined financial statements are provided for illustrative purposes only and do not purport to represent what the actual consolidated results of operations or the consolidated financial position of the Company would have been had the Viewpoint Acquisition occurred on the date assumed, nor are they necessarily indicative of future consolidated results of operations or consolidated financial position. The unaudited pro forma combined financial statements do not include the realization of cost savings from operating efficiencies or restructuring costs anticipated to result from the Viewpoint Acquisition.

 

1


TRIMBLE INC.

UNAUDITED PRO FORMA COMBINED STATEMENT OF INCOME

(In millions, except per share amounts)

 

Fiscal Year    2017  
     Trimble     Viewpoint     Combined  
     Historical
As Reported
    Adjustments for
Accounting
Changes

(Note 2)
    Historical
As Adjusted
    Historical
As Reported
    Reclassification
and Waterfall
Adjustments
(Note 3)
    Historical
As Adjusted
    Pro Forma
Adjustments
    (Note 7)      Pro Forma  

Revenue:

                   

Product

   $ 1,763.8     $ —       $ 1,763.8     $ 17.8     $ —       $ 17.8     $ 4.4       (a)      $ 1,786.0  

Service

     461.6       13.8       475.4       27.0       —         27.0       1.6       (a)        504.0  

Subscription

     428.8       (21.5     407.3       110.4       —         110.4       (7.1     (a)        510.6  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Total Revenue

     2,654.2       (7.7     2,646.5       155.2       —         155.2       (1.1        2,800.6  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Cost of sales:

                   

Product

     866.5       9.1       875.6       1.3       —         1.3       0.3       (a)        877.2  

Service

     196.3       (1.9     194.4       20.7       —         20.7       1.2       (a)        216.3  

Subscription

     113.0       0.1       113.1       25.4       —         25.4       (4.6     (a)        133.9  

Amortization of purchased intangible assets

     85.8       —         85.8       5.5       6.3       11.8       23.2       (b)        120.8  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Total cost of sales

     1,261.6       7.3       1,268.9       52.9       6.3       59.2       20.1          1,348.2  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Gross margin

     1,392.6       (15.0     1,377.6       102.3       (6.3     96.0       (21.2        1,452.4  

Operating expense:

                   

Research and development

     370.2       —         370.2       20.7       —         20.7       —            390.9  

Sales and marketing

     404.2       (4.1     400.1       37.2       —         37.2       (4.7     (a),(c)        432.6  

General and administrative

     302.3       (0.6     301.7       37.9       (3.0     34.9       0.4       (d)        337.0  

Restructuring charges

     6.9       —         6.9       —         3.0       3.0       —            9.9  

Amortization of purchased intangible assets

     63.0       —         63.0       7.6       5.4       13.0       12.0       (b)        88.0  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Total operating expenses

     1,146.6       (4.7     1,141.9       103.4       5.4       108.8       7.7          1,258.4  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Operating income (loss)

     246.0       (10.3     235.7       (1.1     (11.7     (12.8     (28.9        194.0  

Non-operating income (expense), net:

                   

Interest expense, net

     (25.0     (0.2     (25.2     (12.8     0.5       (12.3     (40.1     (e)        (77.6

Foreign currency transaction gain, net

     3.3       —         3.3       —         —         —         —            3.3  

Income from equity method investments, net

     29.5       —         29.5       —         —         —         —            29.5  

Other income, net

     5.3       (0.4     4.9       3.5       —         3.5       —            8.4  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Total non-operating income (expense), net

     13.1       (0.6     12.5       (9.3     0.5       (8.8     (40.1        (36.4
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Income (loss) before taxes

     259.1       (10.9     248.2       (10.4     (11.2     (21.6     (69.0        157.6  

Income tax provision (benefit)

     137.9       (8.2     129.7       (4.6     (20.0     (24.6     (25.5     (f)        79.6  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Net income (loss)

     121.2       (2.7     118.5       (5.8     8.8       3.0       (43.5        78.0  

Net income attributable to noncontrolling interests

     0.1       —         0.1       —         —         —         —            0.1  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Net income attributable to Trimble Inc.

   $ 121.1     $ (2.7   $ 118.4     $ (5.8   $ 8.8     $ 3.0     $ (43.5      $ 77.9  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

      

 

 

 

Net income per share attributable to Trimble Inc.

                   

Basic

   $ 0.48     $ (0.01   $ 0.47                $ 0.31  
  

 

 

   

 

 

   

 

 

              

 

 

 

Diluted

   $ 0.47     $ (0.01   $ 0.46                $ 0.30  
  

 

 

   

 

 

   

 

 

              

 

 

 

Shares used in calculating net income per share:

                   

Basic

     252.1       252.1       252.1                  252.1  
  

 

 

   

 

 

   

 

 

              

 

 

 

Diluted

     256.7       256.7       256.7                  256.7  
  

 

 

   

 

 

   

 

 

              

 

 

 

 

2


TRIMBLE INC.

UNAUDITED PRO FORMA COMBINED BALANCE SHEET

(In millions)

 

At the End of Fiscal Year   2017  
    Trimble     Viewpoint     Combined  
    Historical
As Reported
    Adjustments
for Accounting
Changes

(Note 2)
    Historical
As Adjusted
    Historical
As Reported
    Reclassification
and Waterfall

Adjustments
(Note 3)
    Historical
As Adjusted
    Pro Forma
Adjustments
    (Note 7)     Pro Forma  

ASSETS

                 

Current assets:

                 

Cash and cash equivalents

  $ 358.5     $ —       $ 358.5     $ 19.2     $ —       $ 19.2     $ (16.6     (g)     $ 361.1  

Short-term investments

    178.9       —         178.9       —         —         —         —           178.9  

Accounts receivable, net

    414.8       12.9       427.7       15.8       (1.5     14.3       2.9       (h)       444.9  

Other receivables

    42.8       —         42.8       —         1.5       1.5       —           44.3  

Inventories

    271.8       (7.2     264.6       —         —         —         —           264.6  

Other current assets

    50.3       (11.1     39.2       11.4       —         11.4       (5.6     (i)       45.0  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

Total current assets

    1,317.1       (5.4     1,311.7       46.4       —         46.4       (19.3       1,338.8  

Property and equipment, net

    174.0       —         174.0       9.5       —         9.5       (2.0     (j)       181.5  

Goodwill

    2,287.1       —         2,287.1       194.7       175.4       370.1       447.2       (k)       3,104.4  

Other purchased intangible assets, net

    364.8       —         364.8       106.3       105.2       211.5       238.5       (b)       814.8  

Deferred costs, non-current

    —         35.0       35.0       —         —         —         —           35.0  

Other non-current assets

    155.2       (11.5     143.7       1.0       —         1.0       3.3       (l)       148.0  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

Total assets

  $ 4,298.2     $ 18.1     $ 4,316.3     $ 357.9     $ 280.6     $ 638.5     $ 667.7       $ 5,622.5  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

LIABILITIES AND STOCKHOLDERS’ EQUITY

                 

Current liabilities:

                 

Short-term debt

  $ 128.4     $ —       $ 128.4     $ 2.6     $ —       $ 2.6     $ (2.6     (e)     $ 128.4  

Accounts payable

    146.1       (0.1     146.0       10.0       (7.4     2.6       —           148.6  

Accrued compensation and benefits

    143.0       0.9       143.9       9.7       —         9.7       —           153.6  

Deferred revenue

    272.4       (34.8     237.6       31.5       —         31.5       (12.1     (m)       257.0  

Accrued warranty expense

    18.3       —         18.3       —         —         —         —           18.3  

Other current liabilities

    101.0       (1.8     99.2       1.5       7.4       8.9       30.5       (n)       138.6  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

Total current liabilities

    809.2       (35.8     773.4       55.3       —         55.3       15.8         844.5  

Long-term debt

    785.5       —         785.5       291.9       —         291.9       900.8       (e)       1,978.2  

Non-current deferred revenue

    41.0       (2.0     39.0       —         —         —         —           39.0  

Deferred income tax liabilities

    40.4       7.4       47.8       2.3       25.8       28.1       32.6       (o)       108.5  

Income tax payable

    94.1       —         94.1       —         —         —         —           94.1  

Other non-current liabilities

    162.0       —         162.0       3.9       (0.9     3.0       (2.6     (l)       162.4  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

Total liabilities

    1,932.2       (30.4     1,901.8       353.4       24.9       378.3       946.6         3,226.7  

Stockholders’ equity:

                 

Common stock

    0.2       —         0.2       —         47.5       47.5       (47.5     (p)       0.2  

Additional paid-in-capital

    1,461.1       —         1,461.1       80.1       207.4       287.5       (287.5     (p)       1,461.1  

Retained earnings

    1,035.9       48.7       1,084.6       (75.6     0.5       (75.1     56.4       (p)       1,065.9  

Accumulated other comprehensive income (loss)

    (131.2     (0.2     (131.4     —         0.3       0.3       (0.3     (p)       (131.4
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

Total Trimble Inc. stockholders’ equity

    2,366.0       48.5       2,414.5       4.5       255.7       260.2       (278.9       2,395.8  

Noncontrolling interests

    —         —         —         —         —         —         —           —    
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

Total stockholders’ equity

    2,366.0       48.5       2,414.5       4.5       255.7       260.2       (278.9       2,395.8  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

Total liabilities and stockholders’ equity

  $ 4,298.2     $ 18.1     $ 4,316.3     $ 357.9     $ 280.6     $ 638.5     $ 667.7       $ 5,622.5  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

     

 

 

 

 

3


NOTES TO UNAUDITED PRO FORMA COMBINED FINANCIAL STATEMENTS

 

1. Basis of Preparation

The unaudited pro forma combined financial data was based on and should be read in conjunction with (i) the historical consolidated financial statements of Trimble Inc. (the “Company”) included in its Annual Report on Form 10-K for the year ended December 29, 2017; and (ii) the audited consolidated financial statements of Viewpoint, Inc. (“Viewpoint”) as of and for the year ended December 31, 2017. The unaudited pro forma combined statement of income and balance sheet give effect to the Company’s acquisition of Waterfall Holdings, Inc. (“Waterfall”), the holding company of Viewpoint (the “Viewpoint Acquisition”), and the related transactions as if such transactions occurred on the first day of the fiscal year ended December 29, 2017 for statement of income purposes and on the last day of the fiscal year ended December 29, 2017 for balance sheet purposes.

Viewpoint is the operating company and an indirect wholly-owned subsidiary of Waterfall. Waterfall was formed solely for the purpose of holding the common stock of Waterfall Intermediate Holdings, Inc. (“Intermediate”), which was formed solely for the purpose of holding the common stock of Viewpoint. Neither Waterfall nor Intermediate is engaged in any business activities other than acting as a holding company and neither Waterfall nor Intermediate has any material tangible assets or liabilities, except ownership of stock in the subsidiary. Audited historical financial statements for Waterfall and its consolidated subsidiaries are not currently available. Following the closing of the Viewpoint Acquisition, the Company will be required to prepare and file with the SEC historical financial information, including quarterly financial information, for Waterfall and its consolidated subsidiaries, which will be prepared in accordance with GAAP applicable to public companies, as well as related pro forma financial information giving effect to the Viewpoint Acquisition on the Company’s financial results for those periods. The historical financial information for Waterfall and its consolidated subsidiaries included in those SEC filings may differ materially from the historical financial information for Viewpoint due to the amortization of intangible assets and the tax effects thereof, purchase price allocation adjustments and changes that may be required to present such statements in accordance with GAAP applicable to public companies.

The unaudited pro forma combined financial data was prepared under existing GAAP standards, which are subject to change and interpretation. The historical financial data has been adjusted to give effect to pro forma events that are directly attributable to the Viewpoint Acquisition, are factually supportable and, for purposes of the unaudited pro forma income statement, are expected to have a continuing impact on the combined results. The unaudited pro forma combined financial statements are provided for illustrative purposes only and do not purport to represent what the actual consolidated results of operations or the consolidated financial position of the Company would have been had the Viewpoint Acquisition occurred on the date assumed, nor are they necessarily indicative of future consolidated results of operations or consolidated financial position. The unaudited pro forma combined financial statements do not include the realization of cost savings from operating efficiencies or restructuring costs anticipated to result from the Viewpoint Acquisition.

The Viewpoint Acquisition will be accounted for as a business combination, and will reflect the application of purchase accounting in accordance with ASC 805, Business Combinations. The pro forma adjustments are based on preliminary estimates of the fair values of assets acquired and liabilities assumed and information available as of the date of this filing. Certain valuations and assessments, including valuations of other intangible assets as well as the assessment of the tax positions and rates of the combined business, are in process and will not be completed until subsequent to the close of the proposed acquisition. Additionally, the consideration for the transaction in the unaudited pro forma combined financial data is based on shares, equity awards and debt outstanding as of a date recent to this filing, which may differ from shares, equity awards, and debt outstanding at the date of the close of the Viewpoint Acquisition. The debt that is anticipated to be incurred to finance the Viewpoint Acquisition is included in the unaudited pro forma combined financial data reflecting the terms and rates the Company expects to achieve based on current market rates. The actual financing and terms of the financing will be subject to market conditions. Actual adjustments may differ from the amounts reflected in the unaudited pro forma combined financial statements, and the differences may be material.

 

4


2. Adjustments for Accounting Changes to the Company’s Historical Consolidated Financial Data

On December 30, 2017 (the first day of fiscal 2018), the Company adopted the new accounting standard, Revenue from Contracts with Customers (“ASC 606”), using the full retrospective method. The Company also adopted Accounting Standards Update No. 2017-07, Improving the Presentation of Net Periodic Pension Cost and Net Periodic Postretirement Benefit Cost (“ASU 2017-07”) and Accounting Standards Update No. 2016-15, Statement of Cash Flows (“ASU 2016-15”). The impact of the full retrospective adoption on the Company’s 2017 and 2016 financial information is presented below.

 

5


TRIMBLE INC.

NEW ACCOUNTING STANDARDS ADOPTION IMPACT

CONSOLIDATED STATEMENTS OF INCOME

(In millions, except per share data)

(Unaudited)

 

     Historical As Reported     ASC 606 & ASU 2017-07
Adjustments
    Historical As Adjusted  
     Fiscal Year
2017
    Fiscal Year
2016
    Fiscal Year
2017
    Fiscal Year
2016
    Fiscal Year
2017
    Fiscal Year
2016
 

Revenue:

            

Product

   $ 1,763.8     $ 1,562.0     $ —       $ 8.6     $ 1,763.8     $ 1,570.6  

Service

     461.6       430.2       13.8       6.5       475.4       436.7  

Subscription

     428.8       370.0       (21.5     (15.2     407.3       354.8  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total revenue

     2,654.2       2,362.2       (7.7     (0.1     2,646.5       2,362.1  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Cost of sales:

            

Product

     866.5       760.8       9.1       3.2       875.6       764.0  

Service

     196.3       169.9       (1.9     0.2       194.4       170.1  

Subscription

     113.0       104.9       0.1       —         113.1       104.9  

Amortization of purchased intangible assets

     85.8       88.6       —         —         85.8       88.6  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total cost of sales

     1,261.6       1,124.2       7.3       3.4       1,268.9       1,127.6  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Gross margin

     1,392.6       1,238.0       (15.0     (3.5     1,377.6       1,234.5  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Operating expense:

            

Research and development

     370.2       349.6       —         —         370.2       349.6  

Sales and marketing

     404.2       377.6       (4.1     (2.9     400.1       374.7  

General and administrative

     302.3       256.0       (0.6     —         301.7       256.0  

Restructuring charges

     6.9       11.6       —         —         6.9       11.6  

Amortization of purchased intangible assets

     63.0       62.2       —         —         63.0       62.2  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total operating expense

     1,146.6       1,057.0       (4.7     (2.9     1,141.9       1,054.1  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Operating income

     246.0       181.0       (10.3     (0.6     235.7       180.4  

Non-operating income (expense), net:

            

Interest expense, net

     (25.0     (25.9     (0.2     —         (25.2     (25.9

Foreign currency transaction gain (loss), net

     3.3       (1.9     —         —         3.3       (1.9

Income from equity method investments, net

     29.5       17.6       —         —         29.5       17.6  

Other income, net

     5.3       5.9       (0.4     —         4.9       5.9  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total non-operating income (expense), net

     13.1       (4.3     (0.6     —         12.5       (4.3
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income before taxes

     259.1       176.7       (10.9     (0.6     248.2       176.1  

Income tax provision

     137.9       44.5       (8.2     (0.6     129.7       43.9  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income

     121.2       132.2       (2.7     —         118.5       132.2  

Net gain (loss) attributable to noncontrolling interests

     0.1       (0.2     —         —         0.1       (0.2
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income attributable to Trimble Inc.

   $ 121.1     $ 132.4     $ (2.7   $ —       $ 118.4     $ 132.4  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income per share attributable to Trimble Inc.

            

Basic

   $ 0.48     $ 0.53     $ (0.01   $ —       $ 0.47     $ 0.53  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Diluted

   $ 0.47     $ 0.52     $ (0.01   $ —       $ 0.46     $ 0.52  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Shares used in calculating net income per share:

            

Basic

     252.1       250.5       —         —         252.1       250.5  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Diluted

     256.7       253.9       —         —         256.7       253.9  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

6


TRIMBLE INC.

NEW ACCOUNTING STANDARDS ADOPTION IMPACT

CONSOLIDATED BALANCE SHEETS

(In millions)

(Unaudited)

 

     Historical
As Reported
    ASC 606 Adjustments     Historical
As Adjusted
 

As of

   Fiscal Year
End 2017
    Fiscal Year
End 2016
    Fiscal Year
End 2017
    Fiscal Year
End 2016
    Fiscal Year
End 2017
    Fiscal Year
End 2016
 

Assets

            

Current assets:

            

Cash and cash equivalents

   $ 358.5     $ 216.1     $ —       $ —       $ 358.5     $ 216.1  

Short term investments

     178.9       111.1       —         —         178.9       111.1  

Accounts receivable, net

     414.8       354.8       12.9       11.4       427.7       366.2  

Other receivables

     42.8       35.4       —         —         42.8       35.4  

Inventories

     271.8       218.8       (7.2     (5.5     264.6       213.3  

Other current assets

     50.3       42.5       (11.1     (2.7     39.2       39.8  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current assets

     1,317.1       978.7       (5.4     3.2       1,311.7       981.9  

Property and equipment, net

     174.0       144.2       —         —         174.0       144.2  

Goodwill

     2,287.1       2,077.6       —         —         2,287.1       2,077.6  

Other purchased intangible assets, net

     364.8       333.3       —         —         364.8       333.3  

Deferred costs, non-current

     —         —         35.0       30.3       35.0       30.3  

Other non-current assets

     155.2       140.0       (11.5     (15.1     143.7       124.9  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total assets

   $ 4,298.2     $ 3,673.8     $ 18.1     $ 18.4     $ 4,316.3     $ 3,692.2  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Liabilities and Stockholders’ Equity

            

Current liabilities:

            

Short-term debt

   $ 128.4     $ 130.3     $ —       $ —       $ 128.4     $ 130.3  

Accounts payable

     146.1       109.8       (0.1     0.1       146.0       109.9  

Accrued compensation and benefits

     143.0       97.5       0.9       0.6       143.9       98.1  

Deferred revenue

     272.4       246.5       (34.8     (34.7     237.6       211.8  

Accrued warranty expense

     18.3       17.2       —         —         18.3       17.2  

Other current liabilities

     101.0       86.9       (1.8     (4.0     99.2       82.9  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current liabilities

     809.2       688.2       (35.8     (38.0     773.4       650.2  

Long-term debt

     785.5       489.6       —         —         785.5       489.6  

Non-current deferred revenue

     41.0       37.7       (2.0     (3.1     39.0       34.6  

Deferred income tax liabilities

     40.4       38.8       7.4       10.0       47.8       48.8  

Income taxes payable

     94.1       —         —         —         94.1       —    

Other non-current liabilities

     162.0       113.8       —         —         162.0       113.8  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total liabilities

     1,932.2       1,368.1       (30.4     (31.1     1,901.8       1,337.0  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Stockholders’ equity:

            

Common stock

     0.2       0.3       —         —         0.2       0.3  

Additional paid-in capital

     1,461.1       1,348.3       —         —         1,461.1       1,348.3  

Retained earnings

     1,035.9       1,177.1       48.7       51.4       1,084.6       1,228.5  

Accumulated other comprehensive loss

     (131.2     (219.9     (0.2     (1.9     (131.4     (221.8
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total Trimble Inc. stockholders’ equity

     2,366.0       2,305.8       48.5       49.5       2,414.5       2,355.3  

Noncontrolling interests

     —         (0.1     —         —         —         (0.1
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total stockholders’ equity

     2,366.0       2,305.7       48.5       49.5       2,414.5       2,355.2  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total liabilities and stockholders’ equity

   $ 4,298.2     $ 3,673.8     $ 18.1     $ 18.4     $ 4,316.3     $ 3,692.2  
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

7


TRIMBLE INC.

NEW ACCOUNTING STANDARDS ADOPTION IMPACT

CONSOLIDATED STATEMENTS OF CASH FLOWS

(In millions)

(Unaudited)

 

    Historical
As Reported
    ASC 606 & ASU 2016-15 Adjustments     Historical
As Adjusted
 
    Fiscal Year
End 2017
    Fiscal Year
End 2016
    Fiscal Year
End 2017
    Fiscal Year
End 2016
    Fiscal Year
End 2017
    Fiscal Year
End 2016
 

Cash flow from operating activities:

           

Net income

  $ 121.2     $ 132.2     $ (2.7   $ —       $ 118.5     $ 132.2  

Adjustments to reconcile net income to net cash provided by operating activities:

           

Depreciation expense

    34.6       37.0       —         —         34.6       37.0  

Amortization expense

    148.8       150.8       —         —         148.8       150.8  

Stock-based compensation

    64.8       52.6       —         —         64.8       52.6  

Income from equity method investments

    (29.5     (17.6     18.1       17.6       (11.4     —    

Other non-cash items

    6.9       19.0       (8.2     (0.6     (1.3     18.4  

Decrease (increase) in assets:

           

Accounts receivable

    (41.6     1.2       (1.1     2.6       (42.7     3.8  

Inventories

    (38.7     24.0       1.4       2.2       (37.3     26.2  

Other current and non-current assets

    (15.5     0.2       5.5       2.0       (10.0     2.2  

Increase (decrease) in liabilities:

           

Accounts payable

    25.9       10.9       (0.2     (0.1     25.7       10.8  

Accrued compensation and benefits

    33.7       0.6       0.3       (0.3     34.0       0.3  

Deferred revenue

    16.4       26.1       2.9       (6.6     19.3       19.5  

Income taxes payable

    88.2       (16.1     —         —         88.2       (16.1

Accrued liabilities

    (3.3     (7.3     1.8       0.7       (1.5     (6.6
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash provided by operating activities

    411.9       413.6       17.8       17.5       429.7       431.1  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Cash flow from investing activities:

           

Acquisitions of businesses, net of cash acquired

    (293.1     (38.8     12.9       15.1       (280.2     (23.7

Acquisitions of property and equipment

    (43.7     (26.0     —         —         (43.7     (26.0

Purchases of short-term investments

    (288.0     (113.3     —         —         (288.0     (113.3

Proceeds from maturities of short-term investments

    122.1       2.4       —         —         122.1       2.4  

Proceeds from sales of short-term investments

    97.7       —         —         —         97.7       —    

Dividends received from equity method investments

    18.1       17.6       (18.1     (17.6     —         —    

Other

    20.9       13.7       —         —         20.9       13.7  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash used in investing activities

    (366.0     (144.4     (5.2     (2.5     (371.2     (146.9
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Cash flow from financing activities:

           

Issuance of common stock, net of tax withholdings

    73.8       67.5       —         —         73.8       67.5  

Repurchases and retirement of common stock

    (285.3     (119.5     —         —         (285.3     (119.5

Proceeds from debt and revolving credit lines

    786.0       355.0       —         —         786.0       355.0  

Payments on debt and revolving credit lines

    (495.4     (465.3     —         —         (495.4     (465.3

Other

    —         —         (12.6     (15.0     (12.6     (15.0
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash provided by (used in) financing activities

    79.1       (162.3     (12.6     (15.0     66.5       (177.3
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Effect of exchange rate changes on cash and cash equivalents

    17.4       (6.8     —         —         17.4       (6.8
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net increase in cash and cash equivalents

    142.4       100.1       —         —         142.4       100.1  

Cash and cash equivalents - beginning of period

    216.1       116.0       —         —         216.1       116.0  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Cash and cash equivalents - end of period

  $ 358.5     $ 216.1     $ —       $ —       $ 358.5     $ 216.1  
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

8


3. Adjustments to Viewpoint’s Historical Reported Financial Data

As part of preparing the unaudited pro forma combined financial statements, the Company conducted a review of the accounting policies of Viewpoint to determine if differences in accounting policies would require pro forma adjustments to conform to the Company’s accounting policies. Certain reclassifications and Waterfall-related adjustments have been made to Viewpoint’s statement of income (loss) and balance sheet presentations for fiscal 2017.

 

(a) Reclassification adjustments

 

  i. Statement of income reclassification – Viewpoint’s restructuring expense of $3.0 million was presented as part of general and administrative expense and has been reclassified as a separate line item to conform to the Company’s statement of income presentation.

 

  ii. Balance sheet reclassification – Viewpoint’s non-trade accounts receivable of $1.5 million were reclassified into other receivables, and Viewpoint’s accrued liabilities of $7.4 million included in accounts payable were reclassified into other current liabilities to conform to the Company’s balance sheet presentation.

 

(b) Waterfall-related adjustments

All other adjustments are for certain Waterfall-related adjustments to the historical consolidated financial data of Viewpoint to reflect the Waterfall holding company structure. Such adjustments primarily include the purchase price allocation in connection with the initial purchase of Waterfall by Bain Capital Private Equity, LP in 2014, to account for the related amortization of intangible assets and the tax effects, and to record the income tax effects of re-measurement of the deferred tax liability (“DTL”) associated with the related acquired intangible assets due to the U.S. federal tax rate reduction from the Tax Cuts and Jobs Act of 2017 (the “2017 Tax Act”). These pro forma adjustments are based on preliminary estimates. The historical as adjusted financial data for Viewpoint and its consolidated subsidiaries may differ materially from Waterfall’s historical consolidated financial data. Accordingly, the pro forma combined financial data of the Company and Waterfall may differ materially from the unaudited pro forma combined financial data.

 

4. Estimate of Consideration Expected to be Transferred

The Viewpoint Acquisition will be accounted for as a business combination, and will reflect the application of purchase accounting in accordance with ASC 805, Business Combinations. The unaudited pro forma combined financial data reflects the purchase price of Viewpoint of $1,200 million, which is derived as follows:

 

(In millions)       

Cash consideration expected to be paid to stockholders

   $ 905.5  

Viewpoint’s expected debt to be repaid

     294.5  
  

 

 

 

Total cash consideration

   $ 1,200.0  
  

 

 

 

The actual debt to be repaid will be subject to unpaid balances existing on the closing date and therefore, actual adjustments may differ from the amounts reflected in the unaudited pro forma combined financial statements. Differences between estimated and actual debt will be adjusted through payments to Waterfall stockholders and are not expected to have any impact on total cash consideration to be paid for this transaction. A portion of the Viewpoint Acquisition will be funded through the issuance of a senior unsecured term loan and other unsecured debt financing described further in Note 7(e).

 

9


5. Estimate of Assets to be Acquired and Liabilities to be Assumed

A preliminary estimate of the assets to be acquired and the liabilities to be assumed by the Company as a result of the Viewpoint Acquisition, reconciled to the estimate of consideration expected to be transferred is provided below. The final valuation of net assets acquired is expected to be completed as soon as possible after the acquisition date.

 

(In millions)    Estimated
Fair Value
        

Fair value of total purchase consideration

   $ 1,200.0     

Less: fair value of net asset acquired:

     

Net tangible asset acquired

     (4.4   

Intangible assets acquired:

        Estimated Useful Life  

Developed product technology

     210.0        6-7 years  

Customer relationships

     230.0        10-15 years  

Trade name and trademarks

     10.0        5 years  
  

 

 

    

Subtotal

     450.0     

Deferred taxes

     (62.9   
  

 

 

    

Goodwill

   $ 817.3     
  

 

 

    

 

6. Keystyle Data Acquisition

On March 30, 2018, Viewpoint acquired 100% of the outstanding shareholders interests in Keystyle Data Solutions, Inc. (“Keystyle”) a privately owned software company based in North America for approximately $6.1 million. Viewpoint funded the entire acquisition, including the purchase of working capital, with its existing cash on hand.

Keystyle’s reported revenue and net income for the year ended December 31, 2017 were $2.4 million and $1.1 million respectively. The acquired net tangible assets from the acquisition of Keystyle are estimated to be $1.0 million. The unaudited pro forma combined financial data does not include the results of Keystyle’s operations or its assets and liabilities, as these are considered immaterial.

 

7. Pro Forma Adjustments

The following items resulted in adjustments reflected in the unaudited pro forma combined financial data:

(a) Revenue and cost of sales – Viewpoint’s historical as adjusted product, service, and subscription revenue and related associated cost of sales have been adjusted to reflect the impact of the adoption of ASC 606. Additionally, Viewpoint’s historical as adjusted service revenue for collections related to user conference fees has been reclassified as a reduction to sales and marketing expense to conform to the Company’s accounting policies.

(b) Intangible assets – Reflects adjustments of $450.0 million to reflect the preliminary purchase accounting of the Viewpoint Acquisition, partially offset by the write-off of $211.5 million to eliminate Viewpoint’s historical as adjusted intangible assets and related amortization. The preliminary purchase accounting of the Viewpoint Acquisition is as follows:

 

(In millions)    Type      Useful Life      Fair Value  

Developed product technology

     Amortizable        6-7 years      $ 210.0  

Customer relationships

     Amortizable        10-15 Years        230.0  

Trade name and trademarks

     Amortizable        5 Years        10.0  
        

 

 

 

Total Intangible assets

         $ 450.0  
        

 

 

 

 

10


Amortization expense, recorded in cost of sales and operating expense, increased by $35.0 million and $25.0 million, respectively, in the fiscal year ended December 31, 2017 to reflect amortization using the asset lives reflected in the table above, partially offset by the elimination of Viewpoint’s historical as adjusted amortization expense of $11.8 million and $13.0 million recorded in costs of sales and operating expense, respectively.

A 10% change in valuation of intangible assets would cause a corresponding increase or decrease in the balance of goodwill and annual amortization expense of approximately $5.6 million, assuming an overall weighted-average useful life of eight years.

(c) Sales and marketing expense – Reflects the incremental cost to obtain customer contracts, which have been deferred and will be amortized over a benefit period, which is the shorter of customer or product life, in conformance with ASC 606.

(d) General and administrative expense Reflects adjustments to conform to the Company’s accounting policies for fixed asset capitalization, accounts receivable allowances, and prepaid expenses.

(e) Debt and interest expense – The $1,200 million purchase price is expected to be funded by the incurrence of new long-term debt, including a three-year, $500.0 million senior unsecured term loan with a variable interest rate, and other unsecured debt financing. The weighted-average interest rate on the senior unsecured term loan and other financing is expected to be 4.4%, based upon current market interest rates as of May 31, 2018 and results in $52.4 million of interest expense in the year ended December 29, 2017. The actual financing and terms of the financing will be subject to market conditions. A 1/8% change in interest rates on the debt expected to be incurred as part of the Viewpoint Acquisition would result in a change in interest expense of $1.5 million annually.

The new interest expense of $52.4 million, partially offset by the elimination of Viewpoint’s interest expense of $12.3 million, is shown as a pro forma adjustment of $40.1 million.

Viewpoint’s outstanding debt, including its revolving credit facility and secured term loans, will be repaid on the closing date for $294.5 million, based on outstanding balances as of December 31, 2017. The debt consists of short-term and long-term debt of $2.6 million and $291.9 million, respectively.

The other unsecured debt financing expected to be incurred by the Company in connection with the Viewpoint Acquisition is reflected net of $7.3 million of expected debt issuance costs and partially offset by the repayment of Viewpoint’s outstanding debt, and is shown as a pro forma adjustment of $898.2 million, including an increase of $900.8 million to long-term debt and a reduction of $2.6 million to short-term debt.

(f) Income taxes – Adjustments to income tax (provision) benefit have been recorded for the pro forma adjustments at the applicable historical statutory rate in effect during the periods for which the pro forma income statement is presented. The income tax effects of the 2017 Tax Act are presented as recorded by the separate companies. The pro forma income statement adjustments exclude the 2017 Tax Act related re-measurement of the deferred tax assets (“DTAs”) and deferred tax liabilities (“DTLs”) recorded in preliminary purchase accounting of the Viewpoint Acquisition.

(g) Cash and cash equivalents – Reflects consideration paid of $1,200.0 million (which includes the consideration paid to Viewpoint’s stockholders and to pay off Viewpoint’s existing short-term and long-term debt), financed by new debt incurred of $1,200.0 million, the anticipated financing cost of $13.1 million and settlement of Viewpoint cash for $3.5 million.

(h) Accounts receivable, net Reflects adjustments to conform to the Company’s accounting policies for doubtful accounts reserves and the impact of the adoption of ASC 606.

(i) Other current assets Reflects adjustments to conform to the Company’s accounting policy for prepaid expenses.

(j) Property and equipment, net Reflects adjustments to conform to the Company’s accounting policy for fixed asset capitalization, and the impact of the preliminary purchase accounting fair value adjustments to internally developed software.

 

11


(k) Goodwill Goodwill, representing the excess of the purchase price over the fair value of assets to be acquired, is $817.3 million, which reflects the preliminary purchase price allocation of the Viewpoint Acquisition, partially offset by the write-off of $370.1 million to eliminate Viewpoint’s historical as adjusted goodwill. The final Viewpoint Acquisition allocation may differ materially from this estimate as changes to the initial valuation of assets and liabilities will be allocated to goodwill.

(l) Other non-current assets and liabilities Reflects adjustments resulting from the impact of preliminary purchase accounting to capitalized commissions and deferred rent.

(m) Deferred revenue Reflects an adjustment of $12.1 million resulting from the impact of the preliminary purchase accounting fair value adjustments to deferred revenue.

(n) Other current liabilities Reflects the accrual of transaction costs of $30.5 million that will be incurred at the close of the Viewpoint Acquisition, of which $15.0 million will be incurred by the Company and $15.5 million will be paid by Viewpoint. Viewpoint’s transaction expense accruals are offset by cash to be acquired to pay off these liabilities.

(o) Deferred income tax liabilities – Reflects the DTLs and DTAs resulting from the preliminary fair value adjustments of the acquired assets and assumed liabilities. The DTLs are primarily related to the preliminary purchase price allocation associated with acquired intangible assets. The DTAs are primarily related to the net operating loss generated in connection with the transaction, of which the largest portion relates to pre-acquisition stock-based compensation vested as part of the acquisition. The DTLs and DTAs have been recognized based on applicable newly enacted statutory tax rates and are subject to change based upon the Company’s final determination of the fair value of assets acquired and liabilities assumed.

(p) Stockholders’ equity Reflects adjustments to eliminate Viewpoint’s historical as adjusted common stock, additional paid-in-capital, retained earnings, and accumulated other comprehensive income (loss).

 

12