Consolidated water co. ltd. (CWCO)
CashFlow / Quarterly
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11
Adjustments to reconcile net income to net cash provided by operating activities:
Distribution of earnings from OC-BVI

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

-

-

-

-

0

242

0

727

189

0

492

757

-

-

-

-

-

-

-

-

Change in:
Net cash provided by operating activities - continuing operations

-

-

-

-

-

2,926

7,486

-3,163

740

-

-

-

-

-

-

3,019

-356

-

3,619

5,606

2,478

4,046

740

15,523

-2,126

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities - discontinued operations

-

-

-

-

-

731

7

378

-61

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) operating activities

-288

4,676

1,974

4,858

3,693

3,658

7,493

-2,784

679

1,592

2,890

11,358

-719

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,182

-

3,351

7,161

-2,063

-6,086

6,756

5,103

2,773

Cash flows from investing activities
Purchase of certificate of deposit

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-5,000

5,000

0

0

-

-

-

-

-

-

-

-

Additions to property, plant and equipment and construction in progress

516

851

856

480

1,336

2,492

4,982

5,857

2,869

1,533

465

785

1,766

893

1,212

401

954

615

1,073

981

442

850

629

1,485

661

1,356

967

861

1,129

1,516

1,428

665

963

3,811

7,865

1,860

519

Proceeds from asset dispositions

0

-95

104

396

46

0

40

0

11

3

0

8

9

0

20

511

15

0

0

9

0

2

0

11

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of discontinued operations, net of cash provided

0

0

265

0

6,706

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of noncontrolling interest in Aerex

8,500

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of PERC, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

7,742

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distribution of earnings from OC-BVI

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

265

242

-

0

0

202

Collections on loans receivable

0

0

0

370

364

358

352

347

341

336

330

487

479

471

464

456

449

442

435

428

421

414

407

401

467

460

453

446

452

470

463

370

450

443

436

430

423

Release of restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities - continuing operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,179

-7,809

-

-639

-1,223

-21

-401

48

-15,433

533

-

-

-

-

-

-

-

-

-

-

-

-

Payment for NSC option agreement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-600

0

0

300

-

-

-

-

Payment for NSC option agreement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

300

-

-

-

-

Collections of loan receivable from OC-BVI

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

350

550

550

Release of restricted cash balance

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

24

-423

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities

-9,015

-4,095

-486

286

5,781

-2,621

-6,731

-5,535

-2,516

-554

-798

-289

-1,276

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

80

-

-965

7,469

-571

-10,868

-7,079

-880

656

Cash flows from financing activities
Dividends paid to common shareholders

1,280

1,270

1,279

1,278

1,275

1,262

1,274

1,274

1,269

1,118

1,115

1,116

1,114

1,110

1,110

1,105

1,107

1,105

1,101

1,107

1,103

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends paid to CWCO shareholders

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,104

1,103

-

1,100

1,098

1,096

1,167

1,095

1,094

1,093

1,575

1,091

1,094

1,090

Dividends paid to preferred shareholders

2

9

0

0

2

11

0

0

2

2

3

2

2

2

3

2

2

2

6

0

2

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchase of redeemable preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6

-

0

2

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchase of redeemable preferred stock

0

0

0

-6

-17

-14

-8

5

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-4

-

-

-

-

-

-

-

-3

Issuance of redeemable preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2

0

-2

-

-

-

-

Proceeds received from exercise of stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

393

31

92

50

212

34

65

145

51

0

0

0

197

0

70

232

0

0

0

0

-

-

-

-

Issuance of note payable to related party

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-490

490

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments made on note payable to related party

-

-

-

-

-

-1,078

0

0

-392

-

-

-

392

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Principal repayments of long-term debt

3

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

5,301

440

434

427

421

415

409

403

8,897

391

385

380

374

Repayments of demand loan payable

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

6,500

500

500

500

500

500

500

500

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-1,287

-1,279

-1,270

-1,277

-1,295

-2,366

-486

-1,268

-1,664

-831

-1,112

-1,602

-725

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,288

-

-1,366

-8,996

-9,993

5,532

-1,471

-1,474

-1,468

Net increase (decrease) in cash and cash equivalents

-10,591

-698

217

3,867

8,179

-1,330

275

-9,588

-3,502

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-7,701

-1,076

-

-1,574

-1,727

-1,460

-1,552

-1,607

8,719

-6,404

-

-

-

-

-

-

-

-

-

-

-

-

Effect of exchange rate changes on cash

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-0

0

1

37

-86

44

38

-37

-65

64

-

-

-

-

-

-

-

-

-

-

-

-

Effect of exchange rate changes on cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-16

-5

-

-

-

-

-

-

-

-

Net increase (decrease) in cash and cash equivalents

-

-

-

-

-

-

-

-

-

206

978

9,465

-2,721

2,162

10

1,530

-9,242

4,026

1,443

2,567

1,041

2,131

-854

8,744

-7,933

2,803

-4,032

-1,006

1,969

2,248

1,013

5,635

-12,628

-11,421

-1,794

2,747

1,962

Interest paid in cash

2

-

0

1

0

-

0

2

4

-

-0

7

0

-

0

34

32

-

36

36

39

-

44

0

110

-

91

98

104

-

116

155

286

-

122

305

310

Non-cash transactions:
Stock Issued

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

82

-

0

0

92

-

0

-4

32

Issuance of 39,986 and 17,833, respectively, shares of common stock for services rendered

-

-

-

-

-

-

-

-

-

-

-

-

203

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Transfer from construction in progress to costs and estimated earnings in excess of billings - construction project

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Dividends declared but not paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

1,095

-

-

-

-

Transfers from inventory to property, plant and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

139

-

-

-

-

Conversion (on a one-to-one basis) of 0 and 454, respectively, shares of redeemable preferred stock to common stock

-

-

-

-

-

-

-

0

0

-

7

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends declared but not paid

1,290

-

0

-0

1,280

-

0

0

1,274

-

0

0

1,119

-

0

2

1,111

-

0

1

1,107

-

-0

0

1,105

-

-

-

-

-

-

-

-

-

-

-

-

Dividends declared but not paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1

1,099

-

-

-

-

-

-

-

-

Transfers from (to) inventory to (from) property, plant and equipment and construction in progress

-71

-

119

91

131

-

111

103

89

-

80

77

70

-

0

64

69

-

-

-

-

-

30

25

57

-

0

0

181

-

-

-

-

-

-

-

-

Transfers from (to) inventory to (from) property, plant and equipment and construction in progress

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

22

93

-0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Transfer from costs and estimated earnings in excess of billings - construction project to accounts receivable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Transfers from construction in progress to property, plant and equipment

1,336

-

492

146

6,769

-

137

111

243

-

1,820

149

140

-

690

1,013

83

-

-186

-1,323

-95

-

0

0

329

-

-

-

-

-

-

-

-

-

-

-

-

Transfers from other assets to construction in progress

-

-

-

-

-

-

0

487

765

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Right-of-use assets obtained in exchange for new operating lease liabilities

78

-

-457

1,386

3,464

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends declared but not paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

1,093

Common Stock [Member]
Stock Issued

-

-

-

-

-

-

-

0

441

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-