21vianet group, inc. (VNET)
CashFlow / Yearly
Dec'17Dec'16Dec'15Dec'14Dec'13Dec'12Dec'11
Bonds 6.875% Due 2017
CASH FLOWS FROM OPERATING ACTIVITIES
Net loss

-141,040

-134,224

-61,946

-52,942

-7,763

-

-

Adjustments to reconcile net loss to net cash generated from operating activities:
Net profit/(loss) from continuing operations

-

-

-

-

-

9,252

7,299

Foreign exchange (gain) loss

-2,636

8,115

11,176

-2,620

1,168

-64

5,203

Changes in the fair value of contingent purchase consideration payables

144

-13,439

6,688

3,647

-

-

-

Changes in the fair value of contingent purchase consideration payable

-

-

-

-

9,231

2,798

10,039

Depreciation of property and equipment

80,460

69,150

62,064

44,964

23,339

14,893

9,354

Amortization of intangible assets

22,071

26,496

28,427

20,577

9,730

5,678

4,783

Loss (gain) on disposal of property and equipment and intangible assets

505

-1,743

-

-

-

-

-

Loss (gain) on disposal of property and equipment

-

-

-16

429

-57

-287

-65

Allowance for doubtful debt

5,752

16,933

5,063

1,598

-

86

29

Provision for doubtful accounts and other receivables

-

-

-

-

91

-

-

Share based compensation expense

7,244

17,101

29,335

37,671

11,195

10,856

6,667

Deferred income tax benefits

-19,677

-9,496

-3,128

-4,630

-3,235

-1,496

-2,938

Bargain purchase gain

-

-

-

0

0

1,692

-

Gain from equity method investments

8,266

5,135

8,082

-108

-227

-177

-

Loss on debt extinguishment

-

-4,298

-

-6,702

-

-

-

Dividend income of cost method investments

280

-

-

-

-

-

-

Gain from disposal of subsidiaries

76,393

-

-

-

-

-

-

Impairment of long-lived assets

61,757

-

-

-

-

-

-

Impairment of goodwill

117,800

-

-

-

-

-

-

Impairment of long-term investment

3,114

-

-

-

-

-

-

Gain from cost method investments

-

743

-

-

-

-

-

Impairment of long-lived assets

-

56,596

-

-

-

-

-

Changes in operating assets and liabilities, net of effects of acquisitions and disposals:
Restricted cash

13,048

-4,978

12,954

7,603

144

-

-

Accounts and notes receivable

-2,809

5,903

-2,329

13,175

-

-

-

Inventories

174

-1,312

537

377

-

-

-

Accounts receivable

-

-

-

-

50,117

21,153

10,555

Prepaid expenses and other current assets

47,675

21,430

43,043

16,651

7,366

1,145

1,066

Amounts due from related parties

-682

2,442

2,767

283

1,263

-5,736

5,417

Accounts and notes payables

6,527

6,762

14,904

19,614

-

-

-

Unrecognized tax (expense) benefits

-605

2,045

-920

-

-

-

-

Accounts payable

-

-

-

-

10,121

3,243

2,376

Unrecognized tax benefits (expense)

-

-

-

305

1,027

-2,321

3,372

Accrued expenses and other payables

41,511

11,841

14,309

-7,561

17,171

-106

7,673

Deferred revenue

-10,054

-4,045

-1,674

-1,716

-

-

-

Advances from customers

31,023

2,246

13,604

15,655

1,673

-1,148

940

Income taxes payable

-1,006

-4,041

2,307

1,442

-2,110

2,831

332

Deferred government grants

-766

-954

625

-

-

-

-

Deferred government grants

-

-

-

2,161

-124

2,082

67

Amounts due to related parties

-2,206

512

30

746

89

-1,005

-1,422

Net cash generated from operating activities

61,835

12,046

33,474

52,443

10,661

-

-

CASH FLOWS FROM INVESTING ACTIVITIES
Net cash generated from operating activities

-

-

-

-

-

27,917

26,395

Purchases of property and equipment

60,864

82,745

162,444

129,019

69,235

71,704

40,635

Assets acquisition of BJ Yichengtaihe

-

-

-

-22,152

-

-

-

Purchases of intangible assets

2,914

5,473

7,335

9,381

5,977

21,489

127

Proceeds from disposal of property and equipment

879

7

263

2,682

40

32

1,207

Disposal of subsidiaries

-9,926

-

-

-

-

-

-

Payments for short-term investments

116,176

41,067

258,600

24,521

181,421

42,926

262,205

Loans to related parties

-

-

-

19,119

6,120

2,412

-

Loans to third parties

-

-

11,342

31,980

-

-

-

Receipt of loan to a related party

-

-

-

6,285

201

-

-

Receipt of loan to a third party

15,370

6,233

-

8,059

-

-

-

Proceeds received from maturity of short-term investments

74,533

16,175

385,444

71,398

36,200

150,764

118,709

Proceeds from disposal of long-term investments

-

1,623

-

-

-

-

-

Proceeds from dividend income of cost method investments

280

-

-

-

-

-

-

Loans to seller

-

-

-

-

-

2,068

-

Deposit for acquisition of BJ Yichengtaihe

-

-

-

0

165

-

-

Restricted cash

-20,109

-

-

0

0

19,523

-

Payments for business acquisitions, net of cash acquired (Note 4)

-

-

-

210,847

10,208

10,765

6,414

Acquisition of the remaining 49% equity interest of Managed Network Entities (Note 4(b))

-

-

-

-

-

-

10,705

Payments for long-term investments

24,926

7,014

3,125

5,941

8,342

8,106

1,303

Payments for available-for-sale investments

-

767

-

-

-

-

-

Payments for assets acquisition, net of cash acquired

3,851

8,104

-

-

-

-

-

Net cash used in investing activities

-107,486

-121,132

-57,139

-364,536

-248,992

-

-

CASH FLOWS FROM FINANCING ACTIVITIES
Net cash used in investing activities

-

-

-

-

-

-28,197

-201,473

Restricted cash

261,622

-244,766

7,770

13,079

-63

-46,097

-22

Proceeds from exercise of stock options

142

650

1,134

480

1,069

530

1,557

Proceeds from issuance of ordinary shares

-

367,088

279,184

0

88,095

-

211,777

Payments for contingent consideration in relation to acquisitions

-

377

-

-

-

-

-

Repayment of 2016 bonds/ 2017 bonds

64,645

38,067

-

-

-

-

-

Consideration paid to selling shareholders

-

-

2,981

0

12,998

-

-

Proceeds received on behalf of selling shareholders

-

-

-

0

12,998

-

-

Proceeds from issuance of preferred shares

-

-

-

-

0

-

-

Proceeds from issuance of preferred shares

-

-

-

-

-

-

36,578

Dividends paid to a noncontrolling shareholders of subsidiary

-

-

-

0

574

-

606

Repurchase of 2017 bonds

-

-

-

122,588

-

-

-

Proceeds from issuance of 2020 bonds (Note 16)

297,581

-

-

319,221

160,702

-

-

Payment of issuance cost of 2020 bonds

1,496

-

-

-

-

-

-

Proceeds from long-term bank borrowings

6,830

30,912

13,155

7,748

154,593

-

-

Proceeds from short-term bank borrowings

10,759

248,549

46,312

58,493

33,045

-

-

Repayment of long-term bank borrowings

14,453

7,104

148,247

31,555

661

-

-

Repayment of short-term bank borrowings

257,239

45,802

28,433

61,312

33,579

-

-

Payments for business acquisitions, net of cash acquired (Note 4)

-

-

-

785

-

-

-

Payments for purchase of noncontrolling interest/mandatorily redeemable noncontrolling interests

-

14,403

1,235

-

-

-

-

Payments for purchase of property and equipment through capital leases

30,605

3,405

12,589

5,155

-

-

-

Advance of loan from a third party

-

-

-

24,176

-

-

-

Repayment of loan from a third party

-15,370

-

-

-8,059

-

-

-

Proceeds from sales and leaseback transactions

-

-

20,069

26,432

-

-

-

Rental prepayment and deposits for sales and leaseback transactions

25,314

21,996

2,007

4,951

-

-

-

Contribution from noncontrolling interest in a subsidiary

20,693

576

-

0

16,519

-

-

Prepayment for future share repurchase plan

585

5,621

-

-

-

-

-

Payments for share repurchase plan

20,461

6,145

-

34,437

9,882

-

30,191

Net cash generated from financing activities

167,459

30,169

172,132

180,787

409,264

-

-

Proceeds from long-term bank borrowings

-

-

-

-

-

37,219

-

Proceeds from short-term bank borrowings

-

-

-

-

-

28,404

17,477

Repayment of long-term bank borrowings

-

-

-

-

-

161

-

Repayment of short-term bank borrowings

-

-

-

-

-

16,051

7,150

Net cash (used in) generated from financing activities

-

-

-

-

-

3,844

229,420

Effect of foreign exchange rate changes on cash and cash equivalents

-21,564

23,086

12,180

42

-1,350

-55

-2,367

Net increase (decrease) in cash and cash equivalents

100,244

-55,831

160,647

-131,264

169,583

3,509

51,975

Supplemental disclosures of cash flow information
Income taxes paid

8,465

7,252

9,697

5,278

6,297

7,141

1,407

Interest paid

14,885

22,422

37,468

36,964

10,262

1,706

699

Interest received

4,435

2,864

9,492

13,438

-

-

-

Interest received

-

-

-

-

4,476

3,146

738

Supplemental disclosures of non-cash activities
Purchase of property and equipment through capital leases

69,746

8,755

20,986

37,372

43,390

-1,739

4,114

Purchase of property and equipment included in accrued expenses and other payables, notes payable, and amounts due to related parties

-2,421

-7,442

-14,632

-

-

-

-

Purchase of property and equipment included in accrued expenses and other payables, notes payable, and amounts due to related parties

-

-

-

20,256

-

-

-

Purchase of intangible assets included in accrued expenses and other payables

-208

189

-215

-797

-

-

-

Contingent consideration related to the acquisitions included in amount due to related parties and accrued expenses and other payables

-144

-44,091

-26,479

59,754

-

-

-

Purchase of property and equipment included in accrued expenses and other payables, notes payable, and amounts due to related parties

-

-

-

-

7,363

2,054

784

Purchase of intangible assets included in accrued expenses and other payables

-

-

-

-

-1,683

3,172

35

Disposal of property and equipment included in amounts due from related parties

-

-

-

-

0

-

939

Contingent consideration related to the acquisitions included in amount due to related parties

-

-

-

-

5,376

-3,620

11,771

Conversion of redeemable convertible preferred shares into ordinary shares concurrent with initial public offering

-

-

-

-

0

-

194,050