XML 24 R37.htm IDEA: XBRL DOCUMENT v3.19.3
Guarantor Financial Information (Tables)
6 Months Ended
Sep. 30, 2019
Condensed Financial Information Disclosure [Abstract]  
Condensed Balance Sheet
CONDENSED CONSOLIDATING BALANCE SHEET
 
September 30, 2019
 
Parent/Issuer
 
Subsidiary Guarantor
 
Non-Guarantor
Subsidiaries
 
Eliminations
 
Consolidated
 
(in millions)
ASSETS
Current assets:
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
$

 
$
3,876

 
$
386

 
$

 
$
4,262

Short-term investments

 
61

 

 

 
61

Accounts and notes receivable, net
96

 
220

 
3,723

 
(316
)
 
3,723

Current portion of notes receivable from consolidated affiliates

 
424

 

 
(424
)
 

Device and accessory inventory

 

 
963

 

 
963

Prepaid expenses and other current assets

 
9

 
1,188

 

 
1,197

Total current assets
96

 
4,590

 
6,260

 
(740
)
 
10,206

Investments in subsidiaries
25,567

 
17,144

 

 
(42,711
)
 

Property, plant and equipment, net

 

 
20,562

 

 
20,562

Costs to acquire a customer contract

 

 
1,712

 

 
1,712

Operating lease right-of-use assets

 

 
6,885

 

 
6,885

Due from consolidated affiliates
290

 
5,215

 

 
(5,505
)
 

Notes receivable from consolidated affiliates
11,895

 
23,143

 

 
(35,038
)
 

Intangible assets
 
 
 
 
 
 
 
 
 
Goodwill

 

 
4,598

 

 
4,598

FCC licenses and other

 

 
41,481

 

 
41,481

Definite-lived intangible assets, net

 

 
1,413

 

 
1,413

Other assets

 
40

 
1,031

 

 
1,071

Total assets
$
37,848

 
$
50,132

 
$
83,942

 
$
(83,994
)
 
$
87,928

 
 
 
 
 
 
 
 
 
 
LIABILITIES AND EQUITY
Current liabilities:
 
 
 
 
 
 
 
 
 
Accounts payable
$

 
$

 
$
3,918

 
$

 
$
3,918

Accrued expenses and other current liabilities
103

 
228

 
3,183

 
(316
)
 
3,198

Current operating lease liabilities

 

 
1,835

 

 
1,835

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

 
2,574

 
1,527

 

 
4,101

Current portion of notes payable to consolidated affiliates

 

 
424

 
(424
)
 

Total current liabilities
103

 
2,802

 
10,887

 
(740
)
 
13,052

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

 
9,105

 
12,268

 

 
33,268

Long-term operating lease liabilities

 

 
5,667

 

 
5,667

Notes payable to consolidated affiliates

 
11,895

 
23,143

 
(35,038
)
 

Deferred tax liabilities

 

 
7,489

 

 
7,489

Other liabilities

 
763

 
1,792

 

 
2,555

Due to consolidated affiliates

 

 
5,505

 
(5,505
)
 

Total liabilities
11,998

 
24,565

 
66,751

 
(41,283
)
 
62,031

Commitments and contingencies

 

 

 

 

Total stockholders' equity
25,850

 
25,567

 
17,144

 
(42,711
)
 
25,850

Noncontrolling interests

 

 
47

 

 
47

Total equity
25,850

 
25,567

 
17,191

 
(42,711
)
 
25,897

Total liabilities and equity
$
37,848

 
$
50,132

 
$
83,942

 
$
(83,994
)
 
$
87,928

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
 
Six Months Ended September 30, 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
$

 
$
(88
)
 
$
4,898

 
$

 
$
4,810

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

 

 
(2,298
)
 

 
(2,298
)
Capital expenditures - leased devices

 

 
(3,302
)
 

 
(3,302
)
Expenditures relating to FCC licenses

 

 
(16
)
 

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

 
67

 

 

 
67

Purchases of short-term investments

 
(61
)
 

 

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

 
(2,743
)
 

 
2,710

 

Proceeds from sales of assets and FCC licenses

 

 
599

 

 
599

Proceeds from intercompany note advance to consolidated affiliate

 
424

 

 
(424
)
 

Other, net

 
3

 
(12
)
 

 
(9
)
Net cash provided by (used in) investing activities
33

 
(2,310
)
 
(5,029
)
 
2,286

 
(5,020
)
Cash flows from financing activities:
 
 
 
 
 
 
 
 
 
Proceeds from debt and financings

 

 
3,364

 

 
3,364

Repayments of debt, financing and finance lease obligations

 
(330
)
 
(5,496
)
 

 
(5,826
)
Debt financing costs

 
(2
)
 
(10
)
 

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

 

 

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

 

 
2,710

 
(2,710
)
 

Repayments of intercompany note advance from parent

 

 
(424
)
 
424

 

Net cash (used in) provided by financing activities
(33
)
 
(332
)
 
144

 
(2,286
)
 
(2,507
)
Net (decrease) increase in cash, cash equivalents and restricted cash

 
(2,730
)
 
13

 

 
(2,717
)
Cash, cash equivalents and restricted cash, beginning of period

 
6,606

 
457

 

 
7,063

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

 
$
3,876

 
$
470

 
$

 
$
4,346


CONDENSED CONSOLIDATING STATEMENT OF CASH FLOWS
 
Six Months Ended September 30, 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
$

 
$
(209
)
 
$
5,566

 
$

 
$
5,357

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

 

 
(2,398
)
 

 
(2,398
)
Capital expenditures - leased devices

 

 
(3,524
)
 

 
(3,524
)
Expenditures relating to FCC licenses

 

 
(70
)
 

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

 
4,002

 

 

 
4,002

Purchases of short-term investments

 
(4,834
)
 

 

 
(4,834
)
Change in amounts due from/due to consolidated affiliates
(248
)
 
(320
)
 

 
568

 

Proceeds from sales of assets and FCC licenses

 

 
272

 

 
272

Proceeds from deferred purchase price from sale of receivables

 

 
223

 

 
223

Proceeds from intercompany note advance to consolidated affiliate

 
424

 

 
(424
)
 

Other, net

 

 
42

 

 
42

Net cash (used in) provided by investing activities
(248
)
 
(728
)
 
(5,455
)
 
144

 
(6,287
)
Cash flows from financing activities:
 
 
 
 
 
 
 
 
 
Proceeds from debt and financings

 

 
2,944

 

 
2,944

Repayments of debt, financing and finance lease obligations

 
(20
)
 
(2,908
)
 

 
(2,928
)
Debt financing costs
(28
)
 
(9
)
 
(211
)
 

 
(248
)
Proceeds from issuance of common stock, net
276

 

 

 

 
276

Change in amounts due from/due to consolidated affiliates

 

 
568

 
(568
)
 

Repayments of intercompany note advance from parent

 

 
(424
)
 
424

 

Net cash provided by (used in) financing activities
248

 
(29
)
 
(31
)
 
(144
)
 
44

Net (decrease) increase in cash, cash equivalents and restricted cash

 
(966
)
 
80

 

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

 
6,222

 
437

 

 
6,659

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

 
$
5,256

 
$
517

 
$

 
$
5,773