Consolidated water co. ltd. (CWCO)
Balance Sheet / 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'11Dec'10
ASSETS
Current assets
Cash and cash equivalents

32,310

42,902

41,991

41,878

38,016

31,337

34,367

34,092

43,680

45,482

46,976

45,950

36,532

39,254

37,092

37,081

35,550

44,792

40,766

39,322

36,754

35,713

33,582

34,437

24,693

33,626

30,823

34,855

35,861

33,892

31,644

30,630

24,995

37,624

49,045

50,840

46,130

Restricted cash

-

-

1,610

1,505

1,500

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Certificate of deposit

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

5,637

5,637

5,637

5,637

5,000

5,000

5,000

5,000

-

0

5,000

-

-

-

-

-

-

-

-

-

-

Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

428

433

-

-

456

-

-

-

-

-

-

-

-

0

0

7,500

7,500

-

-

-

Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

473

442

-

498

515

-

0

-

-

-

-

-

-

-

-

-

-

-

Certificate of deposit

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,000

-

-

-

-

-

-

-

-

-

-

-

-

Marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

8,596

8,587

8,586

8,575

8,572

8,570

8,561

8,548

8,537

8,496

-

-

-

Accounts receivable, net

25,624

23,229

22,955

20,190

22,452

22,462

22,996

22,161

17,840

14,687

13,007

14,091

22,614

16,500

15,099

13,717

13,799

9,529

9,914

9,143

12,535

11,773

12,234

11,952

23,815

18,859

15,873

14,450

14,257

12,516

11,138

11,871

15,097

8,537

8,182

10,273

12,132

Inventory

6,282

3,287

3,031

3,764

3,974

2,232

2,538

2,703

1,745

1,583

2,291

3,057

3,450

2,305

2,087

1,988

1,890

1,918

1,745

1,775

1,790

1,738

1,578

1,536

1,370

1,383

1,325

1,590

1,655

1,757

1,531

1,459

1,601

1,451

1,501

1,421

1,434

Prepaid expenses and other current assets

2,353

2,346

2,151

675

995

2,801

1,598

1,880

950

1,069

2,430

1,330

1,353

1,096

1,622

837

800

1,282

1,985

2,793

1,530

1,612

2,771

2,413

2,490

2,435

2,666

3,241

1,923

2,709

3,286

1,272

1,248

1,880

3,268

3,468

2,294

Current portion of loans receivable

-

-

-

0

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,846

1,843

1,815

1,787

1,733

Costs and estimated earnings in excess of billings

1,968

1,675

1,656

3,451

2,826

835

1,396

-

-

238

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Costs and estimated earnings in excess of billings

-

-

-

-

-

-

-

844

199

-

1,673

543

340

85

1,448

1,066

393

0

1,499

771

869

1,090

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

Current assets of discontinued operations

-

-

0

0

0

1,959

-

-

-

2,229

-

154

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total current assets

68,539

73,442

73,396

71,466

70,135

62,364

63,989

63,129

65,839

66,691

67,757

66,483

65,787

60,875

59,119

56,593

59,943

65,430

63,794

61,700

60,678

59,111

57,363

57,527

63,609

66,582

66,012

64,497

64,098

61,258

57,984

55,614

60,826

67,333

63,814

67,791

63,726

Property, plant and equipment, net

61,239

61,248

62,106

62,951

64,294

58,880

47,342

48,476

49,519

49,683

50,759

50,463

52,077

53,084

52,742

54,251

54,817

53,743

53,761

55,221

55,064

56,396

56,041

57,186

57,881

58,602

59,619

57,581

58,429

58,993

60,705

62,046

63,408

64,185

52,378

53,382

55,923

Construction in progress

328

1,335

925

661

-

6,015

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Construction in progress

-

-

-

-

406

-

16,742

11,397

5,230

1,823

1,433

2,804

2,383

885

1,810

2,163

2,769

1,928

2,529

1,677

2,195

1,900

2,860

2,459

1,729

1,450

854

3,603

3,199

2,612

1,164

335

237

141

9,743

2,252

249

Inventory, non-current

4,534

4,404

4,534

4,417

4,435

4,545

4,825

4,706

4,800

4,462

4,408

4,497

4,648

4,606

4,817

4,508

4,594

4,558

4,478

4,572

4,433

4,240

4,341

4,366

4,243

4,204

4,048

3,963

3,956

3,970

4,565

4,055

3,829

3,861

3,649

3,644

3,538

Loans receivable

-

-

-

-

-

-

0

0

370

734

1,093

1,446

1,793

2,135

2,471

2,802

3,289

3,769

4,240

4,704

5,161

5,610

6,052

6,488

6,916

7,337

7,751

8,159

8,560

9,028

9,488

9,942

10,305

10,758

11,230

11,694

12,602

Investment in OC-BVI

1,939

1,903

1,879

2,127

2,604

2,584

2,464

2,501

2,892

2,783

3,124

2,949

2,987

4,086

3,942

4,678

4,578

4,548

4,686

4,810

5,000

5,208

5,956

6,087

5,970

6,623

6,930

6,854

7,243

6,925

6,442

6,342

6,562

6,634

6,701

6,902

7,812

Goodwill

13,325

13,325

8,004

8,004

8,004

8,004

8,384

8,384

8,384

8,003

9,784

9,784

9,784

9,784

9,784

11,534

11,534

3,499

3,499

3,499

3,499

3,499

3,499

3,499

3,499

3,499

3,499

3,499

3,499

3,499

3,587

3,587

3,587

3,587

3,587

3,587

3,587

Land and rights of way held for development

24,162

24,162

24,161

24,161

24,161

24,161

23,673

20,642

20,558

21,505

20,558

20,558

20,558

20,558

20,558

20,558

20,558

20,558

20,558

20,558

-

20,558

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Intangible assets, net

4,785

5,040

1,331

1,499

1,667

1,891

2,710

3,062

3,413

3,231

4,116

4,468

4,820

5,195

5,594

5,993

6,452

771

810

849

888

927

966

1,005

1,044

1,096

1,185

1,275

1,365

1,455

1,544

1,634

1,724

1,501

1,554

1,606

1,710

Operating lease right-of-use assets

4,043

4,439

4,393

4,590

3,409

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Investment in land

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

20,558

-

20,557

20,558

12,175

13,175

12,025

12,025

-

0

-

-

-

-

-

-

-

Other assets

2,794

2,990

2,046

2,079

2,111

2,123

2,369

5,000

4,905

4,492

2,803

2,183

2,341

2,392

2,446

2,717

2,784

2,767

2,793

2,464

2,554

3,005

2,738

2,831

2,683

2,792

2,828

2,829

2,799

2,706

2,610

2,664

2,737

2,855

2,928

2,935

3,049

Long-term assets of discontinued operations

-

-

0

0

0

1,944

-

-

-

2,066

-

154

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total assets

185,692

192,292

182,777

181,959

181,230

172,515

172,502

167,300

165,913

165,480

165,840

165,794

167,183

163,604

163,289

165,802

171,323

161,575

161,152

160,058

160,033

160,459

160,378

162,010

159,754

165,364

164,754

164,289

153,150

150,449

148,094

146,223

153,221

160,859

155,588

153,798

152,201

LIABILITIES AND EQUITY
Current liabilities
Accounts payable, accrued expenses and other current liabilities

4,364

3,672

2,152

2,779

5,025

4,570

-

-

-

3,548

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued compensation

1,077

1,821

1,367

853

1,585

1,286

-

-

-

1,015

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable and other current liabilities

-

-

-

-

-

-

6,539

5,841

5,637

-

5,332

4,878

5,414

4,898

5,298

4,060

3,904

4,829

4,938

4,231

4,914

5,962

5,465

7,464

6,768

7,157

6,378

5,291

5,852

5,883

5,807

4,075

-

4,617

-

-

-

Accounts payable and other current liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,288

-

6,052

4,266

4,316

Dividends payable

1,297

1,292

1,290

1,290

1,288

1,286

1,284

1,285

1,285

1,281

1,189

1,189

1,188

1,187

1,183

1,183

1,177

1,177

1,192

1,192

1,191

1,190

1,165

1,166

1,165

1,164

1,163

1,163

1,162

1,158

1,158

1,157

1,156

1,156

1,155

1,153

1,152

Current maturities of operating leases

761

755

647

647

433

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Current portion of long-term debt

42

17

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

5,205

1,740

1,708

1,677

1,647

1,617

1,588

9,059

17,531

1,503

1,476

1,422

Note payable to related party

-

-

-

-

-

-

1,078

294

294

686

392

392

882

490

490

490

490

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Billings in excess of costs and estimated earnings

903

614

0

0

0

109

21

-

-

1

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Demand loan payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

6,489

6,958

7,500

8,000

8,500

9,000

9,500

10,000

-

0

-

-

-

-

-

-

-

-

-

-

-

Billings in excess of costs and estimated earnings

-

-

-

-

-

-

-

1

0

-

294

1,396

1,470

102

0

1

153

189

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Current liabilities of discontinued operations

-

-

0

0

0

646

-

-

-

1,097

-

55

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Land purchase obligation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

10,050

10,050

10,050

10,050

-

0

-

-

-

-

-

-

-

Total current liabilities

8,447

8,173

5,457

5,570

8,333

7,899

8,924

7,422

7,216

7,631

7,208

7,912

8,956

6,679

6,971

5,735

12,215

13,155

13,631

13,424

14,606

16,152

16,131

18,631

17,983

23,577

19,332

18,214

8,692

8,690

8,583

6,822

14,504

23,304

8,711

6,896

6,891

Long term debt

155

61

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,887

4,335

4,774

5,205

5,628

6,043

6,452

6,852

15,746

16,132

16,883

Deferred tax liabilities

1,448

1,529

494

-

-

659

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred tax liability

-

-

-

540

592

-

757

832

928

1,024

1,502

1,639

1,775

1,915

2,061

2,207

2,378

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Noncurrent operating leases

3,166

3,836

3,809

4,036

3,031

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net liability arising from put/call options

825

664

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other liabilities

75

75

75

75

199

199

778

778

803

803

1,160

752

739

904

882

557

607

224

224

224

224

-

227

264

264

289

319

350

381

435

411

416

414

420

426

431

442

Other liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

224

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total liabilities

14,117

14,339

9,836

10,223

12,156

8,759

10,459

9,033

8,948

9,459

9,871

10,303

11,471

9,499

9,915

8,501

15,201

13,379

13,856

13,649

14,831

16,377

16,358

18,896

18,248

23,866

23,540

22,899

13,847

14,330

14,622

13,282

21,371

30,578

24,883

23,459

24,218

Commitments and contingencies

-

-

-

-

-

-

0

0

0

-

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

-

-

-

0

-

-

-

-

-

-

-

Equity
Consolidated Water Co. Ltd. stockholders' equity
Redeemable preferred stock, $0.60 par value. Authorized 200,000 shares; issued and outstanding 33,751 and 33,751 shares, respectively

20

20

20

24

19

20

21

24

19

20

20

27

21

21

21

27

22

23

23

27

22

22

22

25

22

22

23

23

17

18

18

19

13

13

13

14

10

Additional paid-in capital

86,034

88,356

87,858

87,534

87,335

87,211

86,904

86,717

86,543

86,405

86,106

85,926

85,755

85,621

85,131

84,960

84,745

84,597

84,303

84,159

83,994

83,779

83,691

83,640

83,607

83,381

83,132

83,007

82,847

82,467

82,385

82,262

82,163

81,939

81,772

81,613

81,349

Retained earnings

67,951

66,352

65,847

65,400

64,204

59,298

58,113

54,835

53,921

53,105

52,648

52,606

53,101

51,589

51,139

54,118

53,027

52,084

51,601

50,934

49,814

49,000

49,138

48,360

46,705

-

47,169

47,361

45,608

42,965

40,350

40,141

39,279

38,030

38,220

38,027

36,289

Cumulative translation adjustment

-

-

0

0

-549

-549

-549

-549

-549

-549

-549

-549

-549

-549

-549

-538

-536

-533

-525

-523

-516

-482

-465

-437

-376

-471

-373

-

-

-15

-

-

-

-

-

-

-

Total Consolidated Water Co. Ltd. stockholders' equity

163,075

163,759

162,742

161,970

160,015

154,971

153,469

150,003

148,910

147,932

147,166

146,943

147,262

145,604

144,634

147,451

146,130

145,040

144,253

143,442

142,155

141,149

141,207

140,407

138,778

138,899

138,739

139,178

137,253

134,191

131,503

131,170

130,203

128,724

128,742

128,390

126,382

Non-controlling interests

8,498

14,193

10,198

9,764

9,058

8,784

8,573

8,263

8,054

8,088

8,802

8,546

8,448

8,500

8,738

9,849

9,991

3,154

3,042

2,967

3,046

2,933

2,812

2,706

2,727

2,599

2,475

2,211

2,049

1,927

1,967

1,770

1,646

1,556

1,963

1,947

1,600

Total equity

171,574

177,952

172,940

171,735

169,074

163,755

162,042

158,266

156,965

156,021

155,968

155,490

155,711

154,105

153,373

157,300

156,122

148,195

147,296

146,409

145,202

144,082

144,020

143,114

141,505

141,498

141,214

141,389

139,303

136,118

133,471

132,940

131,850

130,281

130,705

130,338

127,983

Total liabilities and equity

185,692

192,292

182,777

181,959

181,230

172,515

172,502

167,300

165,913

165,480

165,840

165,794

167,183

163,604

163,289

165,802

171,323

161,575

161,152

160,058

160,033

160,459

160,378

162,010

159,754

165,364

164,754

164,289

153,150

150,449

148,094

146,223

153,221

160,859

155,588

153,798

152,201

Common Class A [Member]
Common stock value

9,068

9,029

9,016

9,012

9,005

8,989

-

-

-

8,951

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Common Class B [Member]
Common stock value

0

0

0

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-