XML 37 R26.htm IDEA: XBRL DOCUMENT v3.10.0.1
Impact of Adopting Topic 606 (Tables)
6 Months Ended
Sep. 30, 2018
New Accounting Pronouncements and Changes in Accounting Principles [Abstract]  
Impact on financial statements from adoption of Topic 606
As a result of applying the modified retrospective method to adopt Topic 606, the following adjustments were made to the opening balances of the Condensed Consolidated Balance Sheet accounts:
Condensed Consolidated Balance Sheet
(in millions)
As Reported
March 31, 2018
 
Adjustments Due to Topic 606
 
Adjusted
April 1, 2018
Assets
 
 
 
 
 
Current assets:
 
 
 
 
 
Cash and cash equivalents
$
3,405

 
$

 
$
3,405

Trade accounts receivable, net
793

 
9

 
802

Contract assets

 
772

 
772

Other current assets
210

 
(38
)
 
172

Total current assets
$
4,408

 
$
743

 
$
5,151

Property and equipment, net
237

 

 
237

Goodwill
6,804

 

 
6,804

Capitalized software and other intangible assets, net
1,111

 

 
1,111

Deferred income taxes
346

 
(221
)
 
125

Contract assets

 
159

 
159

Contract costs

 
427

 
427

Other noncurrent assets, net
154

 
(19
)
 
135

Total assets
$
13,060

 
$
1,089

 
$
14,149

Liabilities and stockholders’ equity
 
 
 
 
 
Current liabilities:
 
 
 
 
 
Current portion of long-term debt
$
269

 
$

 
$
269

Accounts payable
85

 

 
85

Accrued salaries, wages and commissions
242

 

 
242

Accrued expenses and other current liabilities
340

 
(8
)
 
332

Deferred revenue and advanced payments
2,289

 
(1,067
)
 
1,222

Taxes payable, other than income taxes payable
55

 

 
55

Federal, state and foreign income taxes payable
41

 
170

 
211

Total current liabilities
$
3,321

 
$
(905
)
 
$
2,416

Long-term debt, net of current portion
2,514

 

 
2,514

Federal, state and foreign income taxes payable
311

 
110

 
421

Deferred income taxes
111

 
80

 
191

Deferred revenue and advanced payments
820

 
(291
)
 
529

Other noncurrent liabilities
88

 

 
88

Total liabilities
$
7,165

 
$
(1,006
)
 
$
6,159

Stockholders’ equity:
 
 
 
 
 
Preferred stock
$

 
$

 
$

Common stock
59

 

 
59

Additional paid-in capital
3,744

 

 
3,744

Retained earnings
6,971

 
2,104

 
9,075

Accumulated other comprehensive loss
(290
)
 
(9
)
 
(299
)
Treasury stock
(4,589
)
 

 
(4,589
)
Total stockholders’ equity
$
5,895

 
$
2,095

 
$
7,990

Total liabilities and stockholders’ equity
$
13,060

 
$
1,089

 
$
14,149


In connection with the adoption of Topic 606, the Company increased its retained earnings by approximately $2,104 million. This increase was a result of a decrease in deferred revenue of approximately $1,358 million and the establishment of contract assets of approximately $931 million for amounts that would have been recognized under Topic 606 prior to April 1, 2018. In addition, upon adoption of Topic 606, the Company capitalized contract costs of approximately $427 million relating to commissions incurred to obtain customer contracts. Refer to Note 2 “Revenue from Contracts with Customers” for additional details on contract costs.
The net change in deferred income taxes of approximately $301 million and income taxes payable of approximately $280 million is primarily due to the current and deferred tax effects resulting from the aforementioned items.
In addition, the Company made other changes, primarily due to professional services, to our Condensed Consolidated Balance Sheet on April 1, 2018 to comply with Topic 606.
The following table compares the Condensed Consolidated Balance Sheet at September 30, 2018 to the proforma amounts had the previous standard of Topic 605 been in effect:
 
At September 30, 2018
Condensed Consolidated Balance Sheet
(in millions)
As Reported under Topic 606
 
Proforma as if the previous accounting of Topic 605 was in effect
 
Effect of Change
Higher/(Lower)
Assets
 
 
 
 
 
Current assets:
 
 
 
 
 
Cash and cash equivalents
$
2,931

 
$
2,931

 
$

Trade accounts receivable, net
507

 
502

 
5

Contract assets
817

 

 
817

Other current assets
107

 
183

 
(76
)
Total current assets
$
4,362

 
$
3,616

 
$
746

Property and equipment, net
213

 
213

 

Goodwill
6,790

 
6,790

 

Capitalized software and other intangible assets, net
981

 
981

 

Deferred income taxes
124

 
338

 
(214
)
Contract assets
112

 

 
112

Contract costs
400

 

 
400

Other noncurrent assets, net
121

 
136

 
(15
)
Total assets
$
13,103

 
$
12,074

 
$
1,029

Liabilities and stockholders’ equity
 
 
 
 
 
Current liabilities:
 
 
 
 
 
Current portion of long-term debt
$
20

 
$
20

 
$

Accounts payable
81

 
81

 

Accrued salaries, wages and commissions
201

 
201

 

Accrued expenses and other current liabilities
309

 
319

 
(10
)
Deferred revenue and advanced payments
1,002

 
1,826

 
(824
)
Taxes payable, other than income taxes payable
25

 
25

 

Federal, state and foreign income taxes payable
72

 

 
72

Total current liabilities
$
1,710

 
$
2,472

 
$
(762
)
Long-term debt, net of current portion
2,506

 
2,506

 

Federal, state and foreign income taxes payable
297

 
187

 
110

Deferred income taxes
171

 
98

 
73

Deferred revenue and advanced payments
419

 
638

 
(219
)
Other noncurrent liabilities
98

 
98

 

Total liabilities
$
5,201

 
$
5,999

 
$
(798
)
Stockholders’ equity:
 
 
 
 
 
Preferred stock
$

 
$

 
$

Common stock
59

 
59

 

Additional paid-in capital
3,735

 
3,735

 

Retained earnings
9,156

 
7,263

 
1,893

Accumulated other comprehensive loss
(463
)
 
(397
)
 
(66
)
Treasury stock
(4,585
)
 
(4,585
)
 

Total stockholders’ equity
$
7,902

 
$
6,075

 
$
1,827

Total liabilities and stockholders’ equity
$
13,103

 
$
12,074

 
$
1,029

The following tables compare the Condensed Consolidated Statement of Operations for the three and six months ended September 30, 2018 to the proforma amounts had the previous standard of Topic 605 been in effect:
 
For the Three Months Ended September 30, 2018
Condensed Consolidated Statement of Operations
(in millions)
As Reported under Topic 606
 
Proforma as if the previous accounting of Topic 605 was in effect
 
Effect of Change
Higher/(Lower)
Revenue:
 
 
 
 
 
Software licenses and maintenance
$
824

 
$
971

 
$
(147
)
Professional services
71

 
74

 
(3
)
Total revenue
$
895

 
$
1,045

 
$
(150
)
Expenses:
 
 
 
 
 
Costs of licensing and maintenance
$
74

 
$
74

 
$

Cost of professional services
64

 
70

 
(6
)
Amortization of capitalized software costs
49

 
49

 

Selling and marketing
252

 
246

 
6

General and administrative
99

 
99

 

Product development and enhancements
158

 
158

 

Depreciation and amortization of other intangible assets
28

 
28

 

Other expenses, net
4

 
4

 

Total expenses before interest and income taxes
$
728

 
$
728

 
$

Income before interest and income taxes
$
167

 
$
317

 
$
(150
)
Interest expense, net
19

 
19

 

Income before income taxes
$
148

 
$
298

 
$
(150
)
Income tax expense
19

 
53

 
(34
)
Net income
$
129

 
$
245

 
$
(116
)
 
 
 
 
 
 
Basic income per common share
$
0.31

 
$
0.59

 
$
(0.28
)
Basic weighted average shares used in computation
413

 
413

 

 
 
 
 
 
 
Diluted income per common share
$
0.31

 
$
0.58

 
$
(0.27
)
Diluted weighted average shares used in computation
416

 
416

 

 
For the Six Months Ended September 30, 2018
Condensed Consolidated Statement of Operations
(in millions)
As Reported under Topic 606
 
Proforma as if the previous accounting of Topic 605 was in effect
 
Effect of Change
Higher/(Lower)
Revenue:
 
 
 
 
 
Software licenses and maintenance
$
1,694

 
$
1,949

 
$
(255
)
Professional services
139

 
148

 
(9
)
Total revenue
$
1,833

 
$
2,097

 
$
(264
)
Expenses:
 
 
 
 
 
Costs of licensing and maintenance
$
150

 
$
150

 
$

Cost of professional services
134

 
143

 
(9
)
Amortization of capitalized software costs
109

 
109

 

Selling and marketing
487

 
471

 
16

General and administrative
203

 
202

 
1

Product development and enhancements
320

 
320

 

Depreciation and amortization of other intangible assets
54

 
54

 

Other expenses, net
107

 
112

 
(5
)
Total expenses before interest and income taxes
$
1,564

 
$
1,561

 
$
3

Income before interest and income taxes
$
269

 
$
536

 
$
(267
)
Interest expense, net
39

 
39

 

Income before income taxes
$
230

 
$
497

 
$
(267
)
Income tax benefit
(65
)
 
(9
)
 
(56
)
Net income
$
295

 
$
506

 
$
(211
)
 
 
 
 
 
 
Basic income per common share
$
0.70

 
$
1.21

 
$
(0.51
)
Basic weighted average shares used in computation
414

 
414

 

 
 
 
 
 
 
Diluted income per common share
$
0.70

 
$
1.20

 
$
(0.50
)
Diluted weighted average shares used in computation
416

 
416

 

The following table provides a summary of the Company’s revenue amounts under Topic 605 for the three and six months ended September 30, 2018 and 2017 in a manner consistent with its presentation prior to the adoption of Topic 606. Refer to Note 1, “Accounting Policies,” for additional information on the current year reclassification.
 
For the Three
Months Ended
September 30,
 
For the Six
Months Ended
September 30,
(in millions)
2018
 
2017
 
2018
 
2017
Revenue:
 
 
 
 
 
 
 
Subscription and maintenance
$
829

 
$
826

 
$
1,667

 
$
1,643

Professional services
74

 
75

 
148

 
150

Software fees and other
142

 
133

 
282

 
266

Total revenue
$
1,045

 
$
1,034

 
$
2,097

 
$
2,059

The adoption of Topic 606 had no impact on the Company’s net cash provided by operating activities. The impacts of adoption resulted in offsetting shifts in cash flows throughout the components of net income and various changes in working capital balances. The following table compares the operating activities within the Condensed Consolidated Statement of Cash Flows for the six months ended September 30, 2018 to the proforma amounts had the previous standard of Topic 605 been in effect:
 
For the Six Months Ended September 30, 2018
Condensed Consolidated Statement of Cash Flows
(in millions)
As Reported under Topic 606
 
Proforma as if the previous accounting of Topic 605 was in effect
 
Effect of Change
Higher/(Lower)
Operating activities:
 
 
 
 
 
Net income
$
295

 
$
506

 
$
(211
)
Adjustments to reconcile net income to net cash provided by operating activities:
 
 
 
 

Depreciation and amortization
163

 
163

 

Deferred income taxes
(12
)
 
(10
)
 
(2
)
Provision for bad debts

 
(1
)
 
1

Share-based compensation expense
68

 
68

 

Other non-cash items
5

 
5

 

Foreign currency transaction (gains) losses
(4
)
 
2

 
(6
)
Changes in other operating assets and liabilities, net of effect of acquisitions:
 
 
 
 

Decrease in trade accounts receivable
279

 
275

 
4

Increase in contract assets
(26
)
 

 
(26
)
Decrease in contract costs
18

 

 
18

Decrease in deferred revenue and advanced payments
(314
)
 
(598
)
 
284

Decrease in taxes payable, net
(258
)
 
(204
)
 
(54
)
Increase in accounts payable, accrued expenses and other
33

 
35

 
(2
)
Decrease in accrued salaries, wages and commissions
(34
)
 
(34
)
 

Changes in other operating assets and liabilities, net
38

 
44

 
(6
)
Net cash provided by operating activities
$
251

 
$
251

 
$