Consolidated water co. ltd. (CWCO)
CashFlow / TTM
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

-

-

-

-

969

1,158

916

1,408

1,439

0

0

0

-

-

-

-

-

-

-

-

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

-

-

-

-

-

7,990

0

0

0

-

-

-

-

-

-

0

14,484

-

15,750

12,871

22,789

18,184

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities - discontinued operations

-

-

-

-

-

1,055

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) operating activities

11,221

15,203

14,185

19,703

12,061

9,046

6,980

2,377

16,519

15,121

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

2,363

5,767

3,709

8,546

0

0

0

Cash flows from investing activities
Purchase of certificate of deposit

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

-

-

-

-

-

-

-

-

Additions to property, plant and equipment and construction in progress

2,705

3,525

5,166

9,291

14,669

16,202

15,242

10,725

5,653

4,549

3,909

4,657

4,273

3,462

3,184

3,045

3,625

3,113

3,348

2,904

3,407

3,626

4,133

4,471

3,847

4,315

4,474

4,936

4,739

4,574

6,869

13,306

14,502

14,057

0

0

0

Proceeds from asset dispositions

407

453

548

483

87

51

55

15

23

22

18

38

541

547

547

526

24

10

12

12

14

13

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of discontinued operations, net of cash provided

265

6,971

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of noncontrolling interest in Aerex

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of PERC, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

7,742

7,742

7,742

7,742

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distribution of earnings from OC-BVI

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Collections on loans receivable

370

734

1,093

1,446

1,423

1,400

1,377

1,355

1,495

1,633

1,769

1,902

1,871

1,841

1,812

1,783

1,754

1,726

1,698

1,671

1,644

1,691

1,737

1,782

1,828

1,812

1,822

1,831

1,755

1,753

1,726

1,700

1,760

1,733

0

0

0

Release of restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities - continuing operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-9,845

-

-2,285

-1,597

-15,807

-15,253

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payment for NSC option agreement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-300

0

0

0

-

-

-

-

Payment for NSC option agreement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Collections of loan receivable from OC-BVI

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Release of restricted cash balance

-

-

-

-

-

-

-

-

-

-

-

-

-

-398

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities

-13,311

1,485

2,960

-3,284

-9,107

-17,405

-15,339

-9,406

-4,160

-2,920

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-4,935

-11,048

-19,399

-18,171

0

0

0

Cash flows from financing activities
Dividends paid to common shareholders

5,109

5,103

5,095

5,091

5,086

5,081

4,936

4,777

4,619

4,464

4,457

4,451

4,440

4,433

4,428

4,420

4,422

4,417

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends paid to CWCO shareholders

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

4,462

4,457

4,452

4,450

4,858

4,854

4,854

4,850

0

0

0

Dividends paid to preferred shareholders

11

12

14

14

14

14

5

8

11

11

11

11

11

11

12

14

12

11

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchase of redeemable preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

12

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchase of redeemable preferred stock

-6

-24

-38

-47

-35

-17

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

0

Issuance of redeemable preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Proceeds received from exercise of stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

568

387

389

362

456

296

262

197

52

198

197

267

500

302

302

232

0

0

0

0

-

-

-

-

Issuance of note payable to related party

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

490

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments made on note payable to related party

-

-

-

-

-

-1,470

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Principal repayments of long-term debt

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,301

5,741

6,176

6,603

1,724

1,698

1,673

1,649

10,125

10,101

10,077

10,054

1,531

0

0

0

Repayments of demand loan payable

-

-

-

-

-

-

-

-

-

-

-

-

-

7,000

7,500

8,000

2,000

2,000

2,000

2,000

1,500

1,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-5,115

-5,124

-6,211

-5,426

-5,417

-5,786

-4,250

-4,877

-5,211

-4,271

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-14,823

-14,928

-7,406

1,118

0

0

0

Net increase (decrease) in cash and cash equivalents

-7,206

11,565

10,934

10,992

-2,463

-14,145

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-5,795

-

-6,315

-6,348

4,099

-845

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Effect of exchange rate changes on cash

-

-

-

-

-

-

-

-

-

-

-

-

-

0

1

39

-47

-3

34

-40

-18

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Effect of exchange rate changes on cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Net increase (decrease) in cash and cash equivalents

-

-

-

-

-

-

-

-

-

7,928

9,884

8,916

981

-5,538

-3,674

-2,241

-1,204

9,079

7,183

4,885

11,061

2,087

2,759

-418

-10,168

-266

-820

4,224

10,866

-3,731

-17,401

-20,209

-23,097

-8,506

0

0

0

Interest paid in cash

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Non-cash transactions:
Stock Issued

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

0

0

-

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

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

0

-

-

-

-

Transfers from inventory to property, plant and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

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

-

-

-

-

-

-

-

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends declared but not paid

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Dividends declared but not paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

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

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

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

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Transfers from other assets to construction in progress

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

0

-

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends declared but not paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Common Stock [Member]
Stock Issued

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-