Realpage, inc (RP)
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, at Carrying Value

184,309

197,154

270,154

261,571

252,657

228,159

279,872

373,174

101,646

69,343

109,334

324,591

59,516

104,886

69,090

46,688

57,499

30,911

18,566

29,322

27,787

26,936

30,670

39,217

42,096

34,502

43,980

34,319

22,761

33,804

36,220

45,837

49,575

51,273

47,491

111,985

118,010

Restricted Cash and Cash Equivalents, Current

241,310

243,323

158,865

113,359

103,768

154,599

90,919

102,518

112,478

96,002

92,560

106,479

96,430

83,654

92,284

76,335

85,168

85,461

94,086

99,494

104,207

85,543

81,049

46,927

49,492

71,941

44,450

28,394

28,936

35,202

22,443

24,170

22,557

19,098

20,334

15,909

15,346

Accounts receivable, less allowances of $10,622 and $10,271 at March 31, 2020 and December 31, 2019, respectively

131,613

143,127

131,392

128,080

125,068

123,596

114,441

112,484

101,005

124,505

101,164

89,727

88,052

92,367

83,444

80,209

76,164

74,192

68,460

65,478

60,805

64,845

63,731

59,979

62,588

66,635

58,430

58,929

54,652

51,937

45,351

43,750

42,648

43,883

36,739

33,612

29,577

Prepaid expenses

26,886

24,539

21,304

17,411

19,702

19,214

20,215

15,493

15,400

12,107

14,554

13,293

13,033

10,836

11,286

11,166

10,362

8,294

9,610

8,524

8,737

7,647

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred tax asset, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

17,635

11,111

11,089

-

2,868

6,836

5,278

3,284

8,723

0

197

0

276

387

225

272

601

1,539

1,529

Other current assets

27,519

27,387

17,699

17,046

11,383

15,185

17,834

15,812

9,838

6,622

6,043

6,061

4,654

5,712

7,866

22,414

25,828

23,085

2,571

1,203

1,928

1,848

9,566

8,308

8,038

7,453

8,320

8,357

9,633

6,541

7,101

10,919

10,069

10,232

12,111

8,207

6,060

Total current assets

611,637

635,530

599,414

537,467

512,578

540,753

523,281

619,481

340,367

308,579

323,655

540,151

261,685

297,455

263,970

236,812

255,021

221,943

210,928

215,132

214,553

186,819

187,884

161,267

167,492

183,815

163,903

129,999

116,179

127,484

111,391

125,063

125,074

124,758

117,276

171,252

170,522

Property, equipment, and software, net

165,957

163,282

159,605

156,213

153,956

153,528

151,213

145,340

145,522

148,428

147,069

138,241

138,379

130,428

122,119

114,757

94,188

82,198

71,944

70,831

73,142

72,616

71,464

66,515

58,422

54,775

48,191

42,603

40,845

32,487

36,163

31,453

28,224

27,974

26,552

23,607

24,515

Right-of-use assets

118,741

121,941

106,942

99,122

91,023

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Goodwill

1,663,142

1,611,749

1,104,006

1,070,828

1,052,725

1,053,119

1,009,462

918,785

751,017

751,052

565,425

359,420

312,837

259,938

261,768

261,768

255,398

220,097

220,104

220,555

193,385

193,378

193,468

197,658

160,484

152,422

139,025

139,666

141,693

134,025

134,818

130,540

131,901

129,292

128,632

87,163

73,885

Intangible Assets, Net (Excluding Goodwill)

369,942

372,996

260,680

262,711

271,642

287,378

293,382

276,983

238,704

252,337

143,447

110,318

94,381

74,976

84,579

91,624

91,723

81,280

87,287

113,550

94,757

100,085

105,192

106,382

108,698

108,815

102,104

105,942

103,129

104,640

106,212

106,123

110,507

112,308

115,141

58,402

54,361

Deferred tax assets, net

34,249

33,812

35,482

38,999

40,295

42,602

42,397

42,607

45,205

44,887

69,589

63,260

59,195

15,665

15,456

18,863

20,918

12,051

0

1,445

3,952

8,337

4,553

-

-

0

-

0

846

-

2,342

4,641

2,008

2,539

2,760

18,079

17,322

Other assets

28,819

30,507

25,781

23,783

22,197

20,393

18,992

20,710

19,533

11,010

9,643

10,057

10,430

9,636

8,642

5,870

5,571

5,632

5,201

4,895

4,889

5,059

5,023

4,167

3,811

3,386

3,530

3,602

3,731

3,561

3,887

3,973

4,439

3,194

2,855

2,673

2,187

Total assets

2,992,487

2,969,817

2,291,910

2,189,123

2,144,416

2,097,773

2,038,727

2,023,906

1,540,348

1,516,293

1,258,828

1,221,447

876,907

788,098

756,534

729,694

722,819

623,201

595,464

626,408

584,678

566,294

567,584

535,989

498,907

503,213

456,753

421,812

406,423

402,197

394,813

401,793

402,153

400,065

393,216

361,176

342,792

Liabilities and stockholders’ equity
Current liabilities:
Accounts payable

40,210

40,092

35,677

32,673

29,756

25,312

27,422

28,394

29,020

26,733

27,388

24,400

28,742

21,421

20,041

26,879

27,499

17,448

15,670

17,323

15,647

14,830

17,444

21,579

16,224

11,978

14,136

12,764

12,697

9,805

10,448

11,655

8,043

12,218

8,259

7,381

4,787

Accrued expenses and other current liabilities

87,337

89,038

79,598

70,819

85,956

95,482

94,588

97,484

76,284

79,379

77,451

53,316

42,460

50,464

44,201

42,911

39,675

28,294

33,582

33,929

25,250

22,905

25,995

27,436

26,635

23,122

19,491

22,323

22,774

19,246

20,515

28,903

29,029

25,816

27,401

22,699

15,436

Current portion of deferred revenue

137,904

134,148

123,062

124,726

121,536

120,704

110,507

111,238

109,965

116,622

103,243

101,100

98,270

89,583

81,852

83,288

82,805

84,200

77,217

74,650

72,161

73,485

68,321

66,695

63,398

66,085

61,341

61,190

58,992

60,633

56,372

56,989

55,075

57,325

51,204

51,541

47,717

Current portion of term loans

22,500

18,750

7,500

20,166

16,133

16,133

16,133

16,133

16,133

14,116

4,600

3,833

3,125

5,469

4,688

3,906

3,125

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,768

10,781

10,781

Convertible notes, net

-

-

302,032

298,927

295,862

-

289,868

286,908

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Customer deposits held in restricted accounts

241,759

243,316

158,870

113,358

103,763

154,601

91,010

102,512

112,334

96,057

92,571

106,616

96,313

83,590

92,207

76,281

85,119

85,405

93,956

99,618

104,145

85,489

81,015

46,895

49,460

71,910

44,420

28,363

29,103

35,171

22,317

24,133

22,478

19,017

20,278

15,833

15,253

Deferred tax liability

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

1,275

-

2

-

-

-

-

-

-

-

Total current liabilities

529,710

525,344

706,739

660,669

653,006

412,232

629,528

642,669

343,736

332,907

305,253

289,265

268,910

250,527

242,989

233,265

238,223

215,347

220,425

225,520

217,203

196,709

192,775

162,605

155,717

173,095

139,388

125,915

123,566

124,857

109,652

121,680

114,625

114,376

117,910

108,235

93,974

Deferred revenue

4,490

4,793

4,861

3,924

4,160

4,902

5,079

5,181

5,457

5,538

5,640

5,896

6,173

6,308

6,582

6,922

6,992

6,979

7,107

7,063

7,000

6,903

6,764

6,838

6,392

5,671

6,544

10,003

10,121

9,446

9,947

9,534

9,579

8,693

8,910

8,778

7,947

Deferred tax liability, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,439

3,202

4,596

-

0

1,081

2,382

1,379

3,956

2,562

-

10

-

-

-

-

-

-

-

Revolving facility

230,000

230,000

-

-

-

0

0

0

50,000

50,000

-

-

-

0

0

0

0

40,000

44,000

50,000

15,000

20,000

38,572

25,000

-

0

0

-

-

10,000

-

-

45,000

50,312

-

-

0

Term loans, net

567,942

575,313

291,064

275,701

283,659

287,582

291,504

295,382

299,343

303,261

114,719

116,143

117,746

116,657

118,167

119,678

121,188

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Convertible notes, net

308,389

305,188

0

0

0

292,843

0

0

284,046

281,199

278,392

275,673

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lease liabilities, net of current portion

131,099

133,313

120,527

113,511

105,795

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Long-term debt, less current portion

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

25,000

35,000

-

-

47,173

49,867

55,258

Other long-term liabilities

30,014

22,940

19,407

14,999

12,421

37,190

36,893

41,299

35,739

41,513

38,134

34,899

32,739

29,843

35,288

35,382

33,451

34,423

10,574

13,259

12,135

13,902

14,931

14,647

12,255

8,564

5,233

5,541

5,927

2,813

3,143

3,672

3,649

3,803

5,926

5,258

13,029

Total liabilities

1,801,644

1,796,891

1,142,598

1,068,804

1,059,041

1,034,749

963,004

984,531

1,018,321

1,014,418

742,138

721,876

425,568

403,335

403,026

395,247

399,854

296,749

283,545

299,044

255,934

237,514

253,042

210,171

176,746

188,709

155,121

144,021

139,614

147,126

147,742

169,886

172,853

177,184

179,919

172,138

170,208

Commitments and contingencies

-

-

-

-

-

-

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

0

0

Stockholders’ equity:
Preferred stock, $0.001 par value: 10,000,000 shares authorized and zero shares issued and outstanding at March 31, 2020 and December 31, 2019, respectively

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

0

0

0

0

0

0

0

0

0

Common stock, $0.001 par value: 250,000,000 shares authorized, 96,288,420 and 96,100,296 shares issued and 96,277,515 and 94,744,157 shares outstanding at March 31, 2020 and December 31, 2019, respectively

96

96

96

96

96

96

97

96

87

87

87

87

86

86

85

85

84

83

82

83

84

83

83

82

81

81

80

79

78

77

76

74

74

73

72

71

69

Additional paid-in capital

1,199,209

1,222,356

1,209,299

1,189,875

1,167,950

1,187,683

1,190,110

1,159,831

651,996

637,851

622,224

601,836

552,412

534,348

508,756

492,509

478,150

471,668

456,707

451,316

449,165

437,664

422,414

415,127

401,354

390,854

378,446

366,406

358,877

347,203

342,078

328,270

322,712

316,964

306,220

280,530

263,219

Treasury stock, at cost: 10,905 and 1,356,139 shares at March 31, 2020 and December 31, 2019, respectively

104

39,483

36,224

34,109

33,753

65,470

70,319

67,360

68,407

61,260

51,545

41,364

33,934

30,358

28,117

26,517

25,600

24,338

23,496

21,814

43,164

33,398

32,305

17,007

13,176

11,183

9,486

8,388

7,256

6,323

5,526

4,762

4,184

3,138

1,741

1,431

958

Accumulated deficit

-2,090

-7,695

-21,371

-33,075

-47,546

-58,793

-44,372

-53,445

-61,924

-75,046

-54,181

-61,015

-67,228

-119,260

-126,621

-130,831

-129,140

-120,415

-120,898

-101,776

-76,968

-75,360

-75,470

-72,213

-65,922

-65,086

-67,264

-80,150

-84,760

-85,778

-89,500

-91,613

-89,241

-90,961

-91,202

-90,096

-89,730

Accumulated other comprehensive loss

-6,268

-2,348

-2,488

-2,468

-1,372

-492

207

253

275

243

105

27

3

-53

-595

-799

-529

-546

-476

-445

-373

-209

-180

-171

-176

-162

-144

-156

-130

-108

-57

-62

-61

-57

-52

-36

-16

Stockholders' Equity Attributable to Parent

1,190,843

1,172,926

1,149,312

1,120,319

1,085,375

1,063,024

1,075,723

1,039,375

522,027

501,875

516,690

499,571

451,339

384,763

353,508

334,447

322,965

326,452

311,919

327,364

328,744

328,780

314,542

325,818

322,161

314,504

301,632

277,791

266,809

255,071

247,071

231,907

229,300

222,881

213,297

189,038

172,584

Total liabilities and stockholders’ equity

2,992,487

2,969,817

2,291,910

2,189,123

2,144,416

2,097,773

2,038,727

2,023,906

1,540,348

1,516,293

1,258,828

1,221,447

876,907

788,098

756,534

729,694

722,819

623,201

595,464

626,408

584,678

566,294

567,584

535,989

498,907

503,213

456,753

421,812

406,423

402,197

394,813

401,793

402,153

400,065

393,216

361,176

342,792