XML 52 R38.htm IDEA: XBRL DOCUMENT v3.19.3.a.u2
Guarantor Financial Information (Tables)
9 Months Ended
Dec. 31, 2019
Condensed Financial Information Disclosure [Abstract]  
Condensed Balance Sheet
CONDENSED CONSOLIDATING BALANCE SHEET
 
December 31, 2019
 
Parent/Issuer
 
Subsidiary Guarantor
 
Non-Guarantor
Subsidiaries
 
Eliminations
 
Consolidated
 
(in millions)
ASSETS
Current assets:
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
$

 
$
2,932

 
$
247

 
$

 
$
3,179

Short-term investments

 
62

 

 

 
62

Accounts and notes receivable, net
233

 
473

 
3,873

 
(706
)
 
3,873

Current portion of notes receivable from consolidated affiliates

 
424

 

 
(424
)
 

Device and accessory inventory

 

 
1,117

 

 
1,117

Prepaid expenses and other current assets

 
15

 
1,209

 

 
1,224

Total current assets
233

 
3,906

 
6,446

 
(1,130
)
 
9,455

Investments in subsidiaries
25,471

 
17,021

 

 
(42,492
)
 

Property, plant and equipment, net

 

 
20,827

 

 
20,827

Costs to acquire a customer contract

 

 
1,808

 

 
1,808

Operating lease right-of-use assets

 

 
6,713

 

 
6,713

Due from consolidated affiliates
290

 
6,109

 

 
(6,399
)
 

Notes receivable from consolidated affiliates
11,902

 
23,143

 

 
(35,045
)
 

Intangible assets
 
 
 
 
 
 
 
 
 
Goodwill

 

 
4,598

 

 
4,598

FCC licenses and other

 

 
41,492

 

 
41,492

Definite-lived intangible assets, net

 

 
918

 

 
918

Other assets

 
40

 
1,051

 

 
1,091

Total assets
$
37,896

 
$
50,219

 
$
83,853

 
$
(85,066
)
 
$
86,902

 
 
 
 
 
 
 
 
 
 
LIABILITIES AND EQUITY
Current liabilities:
 
 
 
 
 
 
 
 
 
Accounts payable
$

 
$

 
$
3,396

 
$

 
$
3,396

Accrued expenses and other current liabilities
239

 
346

 
3,456

 
(706
)
 
3,335

Current operating lease liabilities

 

 
1,860

 

 
1,860

Current portion of long-term debt, financing and finance lease obligations

 
2,569

 
1,311

 

 
3,880

Current portion of notes payable to consolidated affiliates

 

 
424

 
(424
)
 

Total current liabilities
239

 
2,915

 
10,447

 
(1,130
)
 
12,471

Long-term debt, financing and finance lease obligations
11,902

 
9,085

 
12,520

 

 
33,507

Long-term operating lease liabilities

 

 
5,423

 

 
5,423

Notes payable to consolidated affiliates

 
11,902

 
23,143

 
(35,045
)
 

Deferred tax liabilities

 

 
7,038

 

 
7,038

Other liabilities

 
846

 
1,862

 

 
2,708

Due to consolidated affiliates

 

 
6,399

 
(6,399
)
 

Total liabilities
12,141

 
24,748

 
66,832

 
(42,574
)
 
61,147

Commitments and contingencies

 

 

 

 

Total stockholders' equity
25,755

 
25,471

 
17,021

 
(42,492
)
 
25,755

Noncontrolling interests

 

 

 

 

Total equity
25,755

 
25,471

 
17,021

 
(42,492
)
 
25,755

Total liabilities and equity
$
37,896

 
$
50,219

 
$
83,853

 
$
(85,066
)
 
$
86,902

CONDENSED CONSOLIDATING BALANCE SHEET
 
March 31, 2019
 
Parent/Issuer
 
Subsidiary Guarantor
 
Non-Guarantor
Subsidiaries
 
Eliminations
 
Consolidated
 
(in millions)
ASSETS
Current assets:
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
$

 
$
6,605

 
$
377

 
$

 
$
6,982

Short-term investments

 
67

 

 

 
67

Accounts and notes receivable, net
96

 
233

 
3,554

 
(329
)
 
3,554

Current portion of notes receivable from consolidated affiliates

 
424

 

 
(424
)
 

Device and accessory inventory

 

 
999

 

 
999

Prepaid expenses and other current assets

 
9

 
1,280

 

 
1,289

Total current assets
96

 
7,338

 
6,210

 
(753
)
 
12,891

Investments in subsidiaries
25,785

 
17,363

 

 
(43,148
)
 

Property, plant and equipment, net

 

 
21,201

 

 
21,201

Costs to acquire a customer contract

 

 
1,559

 

 
1,559

Due from consolidated affiliates
288

 
2,418

 

 
(2,706
)
 

Notes receivable from consolidated affiliates
11,883

 
23,567

 

 
(35,450
)
 

Intangible assets
 
 
 
 
 
 
 
 
 
Goodwill

 

 
4,598

 

 
4,598

FCC licenses and other

 

 
41,465

 

 
41,465

Definite-lived intangible assets, net

 

 
1,769

 

 
1,769

Other assets

 
52

 
1,066

 

 
1,118

Total assets
$
38,052

 
$
50,738

 
$
77,868

 
$
(82,057
)
 
$
84,601

 
 
 
 
 
 
 
 
 
 
LIABILITIES AND EQUITY
Current liabilities:
 
 
 
 
 
 
 
 
 
Accounts payable
$

 
$

 
$
3,961

 
$

 
$
3,961

Accrued expenses and other current liabilities
97

 
230

 
3,599

 
(329
)
 
3,597

Current portion of long-term debt, financing and finance lease obligations

 
1,373

 
3,184

 

 
4,557

Current portion of notes payable to consolidated affiliates

 

 
424

 
(424
)
 

Total current liabilities
97

 
1,603


11,168


(753
)

12,115

Long-term debt, financing and finance lease obligations
11,883

 
10,660

 
12,823

 

 
35,366

Notes payable to consolidated affiliates

 
11,883

 
23,567

 
(35,450
)
 

Deferred tax liabilities

 

 
7,556

 

 
7,556

Other liabilities

 
807

 
2,630

 

 
3,437

Due to consolidated affiliates

 

 
2,706

 
(2,706
)
 

Total liabilities
11,980

 
24,953

 
60,450

 
(38,909
)
 
58,474

Commitments and contingencies

 

 

 

 

Total stockholders' equity
26,072

 
25,785

 
17,363

 
(43,148
)
 
26,072

Noncontrolling interests

 

 
55

 

 
55

Total equity
26,072

 
25,785

 
17,418

 
(43,148
)
 
26,127

Total liabilities and equity
$
38,052

 
$
50,738

 
$
77,868

 
$
(82,057
)
 
$
84,601


Condensed Cash Flow Statement
CONDENSED CONSOLIDATING STATEMENT OF CASH FLOWS
 
Nine Months Ended December 31, 2019
 
Parent/Issuer
 
Subsidiary Guarantor
 
Non-Guarantor
Subsidiaries
 
Eliminations
 
Consolidated
 
(in millions)
Cash flows from operating activities:
 
 
 
 
 
 
 
 
 
Net cash (used in) provided by operating activities
$

 
$
(197
)
 
$
6,962

 
$

 
$
6,765

Cash flows from investing activities:
 
 
 
 
 
 
 
 
 
Capital expenditures - network and other

 

 
(3,360
)
 

 
(3,360
)
Capital expenditures - leased devices

 

 
(5,449
)
 

 
(5,449
)
Expenditures relating to FCC licenses

 

 
(24
)
 

 
(24
)
Proceeds from sales and maturities of short-term investments

 
79

 

 

 
79

Purchases of short-term investments

 
(74
)
 

 

 
(74
)
Change in amounts due from/due to consolidated affiliates
29

 
(3,560
)
 

 
3,531

 

Proceeds from sales of assets and FCC licenses

 

 
819

 

 
819

Proceeds from corporate owned life insurance policies

 
5

 

 

 
5

Proceeds from intercompany note advance to consolidated affiliate

 
424

 

 
(424
)
 

Other, net

 

 
(27
)
 

 
(27
)
Net cash provided by (used in) investing activities
29

 
(3,126
)
 
(8,041
)
 
3,107

 
(8,031
)
Cash flows from financing activities:
 
 
 
 
 
 
 
 
 
Proceeds from debt and financings

 

 
4,731

 

 
4,731

Repayments of debt, financing and finance lease obligations

 
(345
)
 
(6,843
)
 

 
(7,188
)
Debt financing costs

 
(3
)
 
(9
)
 

 
(12
)
Proceeds from issuance of common stock, net
(29
)
 

 

 

 
(29
)
Acquisition of noncontrolling interest

 
(3
)
 
(30
)
 

 
(33
)
Change in amounts due from/due to consolidated affiliates

 

 
3,531

 
(3,531
)
 

Repayments of intercompany note advance from parent

 

 
(424
)
 
424

 

Other, net

 

 
1

 

 
1

Net cash (used in) provided by financing activities
(29
)
 
(351
)
 
957

 
(3,107
)
 
(2,530
)
Net decrease in cash, cash equivalents and restricted cash

 
(3,674
)
 
(122
)
 

 
(3,796
)
Cash, cash equivalents and restricted cash, beginning of period

 
6,606

 
457

 

 
7,063

Cash, cash equivalents and restricted cash, end of period
$

 
$
2,932

 
$
335

 
$

 
$
3,267


CONDENSED CONSOLIDATING STATEMENT OF CASH FLOWS
 
Nine Months Ended December 31, 2018
 
Parent/Issuer
 
Subsidiary Guarantor
 
Non-Guarantor
Subsidiaries
 
Eliminations
 
Consolidated
 
(in millions)
Cash flows from operating activities:
 
 
 
 
 
 
 
 
 
Net cash (used in) provided by operating activities
$

 
$
(408
)
 
$
7,990

 
$

 
$
7,582

Cash flows from investing activities:
 
 
 
 
 
 
 
 
 
Capital expenditures - network and other

 

 
(3,814
)
 

 
(3,814
)
Capital expenditures - leased devices

 

 
(5,739
)
 

 
(5,739
)
Expenditures relating to FCC licenses

 

 
(145
)
 

 
(145
)
Proceeds from sales and maturities of short-term investments

 
6,619

 

 

 
6,619

Purchases of short-term investments

 
(5,152
)
 

 

 
(5,152
)
Change in amounts due from/due to consolidated affiliates
(253
)
 
(1,285
)
 

 
1,538

 

Proceeds from sales of assets and FCC licenses

 

 
416

 

 
416

Proceeds from deferred purchase price from sale of receivables

 

 
223

 

 
223

Proceeds from corporate owned life insurance policies

 
110

 

 

 
110

Proceeds from intercompany note advance to consolidated affiliate

 
424

 

 
(424
)
 

Other, net

 

 
52

 

 
52

Net cash (used in) provided by investing activities
(253
)
 
716

 
(9,007
)
 
1,114

 
(7,430
)
Cash flows from financing activities:
 
 
 
 
 
 
 
 
 
Proceeds from debt and financings

 
1,100

 
5,316

 

 
6,416

Repayments of debt, financing and finance lease obligations

 
(1,783
)
 
(5,154
)
 

 
(6,937
)
Debt financing costs
(28
)
 
(47
)
 
(211
)
 

 
(286
)
Proceeds from issuance of common stock, net
281

 

 

 

 
281

Change in amounts due from/due to consolidated affiliates

 

 
1,538

 
(1,538
)
 

Repayments of intercompany note advance from parent

 

 
(424
)
 
424

 

Net cash provided by (used in) financing activities
253

 
(730
)
 
1,065

 
(1,114
)
 
(526
)
Net (decrease) increase in cash, cash equivalents and restricted cash

 
(422
)
 
48

 

 
(374
)
Cash, cash equivalents and restricted cash, beginning of period

 
6,222

 
437

 

 
6,659

Cash, cash equivalents and restricted cash, end of period
$

 
$
5,800

 
$
485

 
$

 
$
6,285