Qcr holdings inc (QCRH)
CashFlow / Yearly
Dec'19Dec'18Dec'17Dec'16Dec'15Dec'14Dec'13Dec'12Dec'11Dec'10Dec'09
Net income

57,408

43,120

35,707

27,686

16,927

14,952

14,938

13,106

10,129

6,807

2,048

Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation

5,225

4,451

3,949

3,424

3,065

2,812

2,695

2,350

2,442

2,533

2,780

Provision for loan/lease losses

7,066

12,658

8,470

7,478

6,870

6,807

5,930

4,370

6,616

7,463

16,975

Deferred income taxes

6,364

6,292

-6,030

-3,066

-2,004

-1,165

-1,021

2,302

3,673

1,256

2,758

Amortization of offering costs on subordinated debentures

-

-

-

-

-

-

-

-

-

14

14

Stock-based compensation expense

2,469

1,443

1,187

947

941

891

792

849

696

488

512

Deferred compensation expense accrued

2,773

1,824

1,426

1,171

-1,023

-1,311

-822

844

604

-

-

Losses on other real estate owned, net

-3,361

-2,585

151

-243

1,021

-447

-545

-1,332

-374

-835

177

Amortization of premiums on securities, net

-1,561

-1,614

-1,839

-1,302

-1,040

-1,809

-3,574

-3,946

-3,487

-3,411

2,044

Securities losses, net

-30

-

-88

4,592

798

92

432

104

1,472

0

1,488

Other-than-temporary impairment losses on securities

-

-

-

-

-

-

-

62

118

113

206

Loans originated for sale

151,692

57,698

49,579

74,329

38,748

58,128

80,027

120,430

100,789

172,623

140,376

Proceeds on sales of loans

152,633

58,353

51,642

77,850

40,362

61,435

86,231

122,143

113,606

167,843

143,295

Gains on sales of residential real estate loans

2,571

901

409

431

322

460

836

1,388

999

3,169

1,677

Gains on sales of government guaranteed portions of loans

748

405

1,164

3,159

1,304

2,040

2,148

1,069

1,565

-

-

Bargain purchase gain on Community National acquisition

-

-

-

-

-

-

1,841

-

-

-

-

Losses on debt extinguishment

-436

-

-

-4,577

-7,185

0

-

-

-

-

-

Gains on sales of premises and equipment

-753

-

-

-

-

-

-

-

-

-

-

Intangibles amortization

2,266

1,692

1,001

442

199

199

178

-

-

-

-

Accretion of acquisition fair value adjustments, net

4,344

5,527

4,941

3,718

367

674

-1,060

-

-

-

-

Prepayment fees on Federal Home Loan Bank advances

-

-

-

-

-

-

-

-

832

-

-

Losses on lease residual values

-

-

-

-

-

-

-

-

-

617

-

Increase in accrued interest receivable

-

-

-

-

-

-

-

-

-

-

-270

Increase in cash value of bank-owned life insurance

1,973

1,632

1,802

1,771

1,762

1,721

1,786

1,609

1,445

1,331

1,243

Gain on sale of credit card loan receivables

-

-

-

-

-

-

495

-

-

-

-

Gain on sale of assets and liabilities of subsidiary

12,286

-

-

-

-

-

-

-

-

-

-

Goodwill impairment

3,000

-

-

-

-

-

-

-

-

-

-

Decrease in other assets

19,152

11,137

-726

943

3,910

1,198

-7,650

-1,153

1,588

-2,248

3,339

Decrease in other liabilities

23,915

7,539

-8,246

10,269

2,721

414

1,017

2,793

1,918

1,406

-660

Net cash provided by operating activities

76,494

64,271

33,713

43,382

30,098

25,599

32,036

30,654

36,640

17,914

14,144

CASH FLOWS FROM INVESTING ACTIVITIES
Net decrease in federal funds sold

16,598

3,799

-7,940

-1,709

26,930

-7,345

-540

-5,775

41,175

-55,361

14,097

Net increase in interest-bearing deposits at financial institutions

-69,984

-14,508

12,138

-12,904

-979

-2,289

-8,660

4,391

12,995

-10,416

-27,215

Proceeds from sales of other real estate owned

840

2,539

1,138

2,084

7,696

1,593

1,345

5,241

9,220

6,038

1,358

Activity in securities portfolio:
Purchases

71,963

84,045

179,786

179,598

232,092

76,256

312,970

474,461

622,245

383,018

316,260

Calls, maturities and redemptions

25,193

23,931

43,010

117,876

211,942

35,247

147,264

374,292

422,870

325,649

169,176

Paydowns

50,830

44,287

38,496

33,169

15,476

23,611

46,098

39,956

9,094

435

406

Sales

30,055

1,938

71,092

134,188

81,410

78,476

37,393

19,215

54,326

-

25,966

Activity in restricted investment securities:
Purchase of derivative instruments

-

-

-

-

-

2,071

-

-

-

-

-

Purchases

5,859

5,409

4,824

1,098

3,752

1,912

7,264

4,584

292

1,710

1,150

Redemptions

7,621

3,157

515

2,450

4,476

3,380

7,244

4,090

1,707

252

-

Purchases of bank-owned life insurance

-

-

-

-

-

-

-

2,000

7,000

3,150

1,000

Decrease in prepaid FDIC insurance

-

-

-

-

-

-

-

-

-

-

-7,801

Surrender of policy

-

-

-

-

-

-

-

-

-

609

-

Net increase in loans/leases originated and held for investment

320,368

292,697

375,226

187,496

172,786

180,325

55,311

91,275

56,096

-63,387

50,077

Purchase of premises and equipment

12,429

11,457

5,761

6,032

4,394

2,035

2,430

1,871

3,064

2,197

2,845

Proceeds from sales of premises and equipment

2,562

-

-

-

-

-

-

-

-

-

-

Purchase of interest rate caps

4,347

-

-

-

-

-

-

-

-

-

-

Net cash received for sale of assets and liabilities of subsidiary

42,587

-

-

-

-

-

-

-

-

-

-

Net cash paid for acquisition

-

5,183

3,369

69,905

0

0

-

-

-

-

-

Proceeds from sale of credit card loan receivables

-

-

-

-

-

-

10,674

-

-

-

-

Net cash received from Community National Acquisition

-

-

-

-

-

-

3,025

-

-

-

-

Net cash paid for Community State Bank acquisition

-

-

-

-

-

-

30,425

-

-

-

-

Net cash (used in) investing activities

-308,664

-333,648

-410,517

-168,975

-66,073

-129,927

-164,557

-132,781

-137,311

-59,482

-187,543

CASH FLOWS FROM FINANCING ACTIVITIES
Net increase in deposit accounts

335,580

271,266

385,082

302,390

200,988

32,695

108,923

168,656

90,641

25,493

30,364

Net increase (decrease) in short-term borrowings

-14,193

13,638

-39,080

-104,691

-123,688

119,058

-21,789

-42,453

72,381

-9,745

49,442

Activity in Federal Home Loan Bank advances:
Term advances

25,000

15,080

1,600

-

5,000

6,000

77,000

13,000

5,000

36,000

11,500

Calls and maturities

35,000

40,000

8,000

24,000

26,000

27,850

82,000

24,400

24,000

13,100

-14,345

Net change in short-term and overnight advances

52,465

-24,765

-60,900

-20,500

47,000

-6,000

34,000

9,000

-

-

-

Prepayments

30,323

-

4,108

31,008

84,401

0

-

-

15,832

-

-

Activity in other borrowings:
Proceeds from other borrowings

-

9,000

7,000

-

-

-

-

-

-

-

-

Calls, maturities and scheduled principal payments

11,937

12,550

21,000

-

-

-

-

-

-

-

-

Net (decrease) increase in other borrowings

-

-

-

-

-

-

-

8

-14,939

7,395

64,477

Proceeds from other borrowings

-

-

-

35,000

0

10,000

10,000

-

-

-

-

Calls, maturities and scheduled principal payments

-

-

-

-

7,350

2,125

5,800

-

-

-

-

Prepayments

46,313

-

-

69,769

34,559

0

-

-

-

-

-

Paydown of revolving line of credit

9,000

-

-

-

-

-

-

-

-

-

-

Proceeds from subordinated notes

63,393

-

-

-

-

-

-

-

-

-

-

Retirement of junior subordinated debentures

-

-

-

3,955

1,762

0

-

-

-

-

-

Advance (payment) on 364-day revolving note

-

-

-

-

-

-

-

-2,000

-1,100

-

-

Repayment of Community National's other borrowings at acquisition

-

-

-

-

-

-

3,950

-

-

-

-

Proceeds from issuance of Series A Subordinated Notes and detachable warrants to purchase 54,000 shares of common stock

-

-

-

-

-

-

-

-

-

2,700

-

Payment of cash dividends on common stock

3,767

3,300

2,494

1,981

782

1,964

4,062

4,088

3,712

4,052

-3,595

Proceeds from issuance of Series D Cumulative Perpetual Preferred Stock and common stock warrant, net

-

-

-

-

-

-

-

-

-

-

38,052

Proceeds from issuance of common stock, net

1,926

1,279

2,056

-

-

620

-

994

-

-

226

Redemption of 29,867 shares of Series F Noncumulative Perpetual Preferred Stock, net

-

-

-

-

-

29,823

-

-

-

-

-

Purchase of noncontrolling interests

-

-

-

-

-

-

-

1,934

-

420

-

Repurchase of 521,888 shares of common stock warrants issued in conjunction with Series D Cumulative Perpetual Preferred Stock

-

-

-

-

-

-

-

-

-1,100

-

-

Proceeds from issuance of common stock, net

-

-

-

-

-

-

-

-

-

3,187

-

Purchase of noncontrolling interests

-

-

-

-

-

-

-

-

-

-

-310

Net cash provided by financing activities

222,901

279,178

381,956

154,420

39,481

100,611

-

110,558

111,777

47,719

175,812

Net increase (decrease) in cash and due from banks

-9,269

9,801

5,152

28,827

3,507

-3,715

-

8,431

11,105

6,152

2,413

Supplemental disclosure of cash flow information, cash payments (receipts) for:
Interest

59,292

38,782

19,054

11,926

14,027

16,826

17,953

19,962

24,194

31,017

36,536

Income/franchise taxes

-2,719

-30

-13,040

10,758

2,619

4,541

3,011

1,345

1,246

3,236

2,557

Supplemental schedule of noncash investing activities:
Change in accumulated other comprehensive income, unrealized gains on securities available for sale and derivative instruments, net

-4,446

3,206

-1,092

335

188

-11,708

-18,350

-48

4,050

568

-3,492

Exchange of shares of common stock in connection with payroll taxes for restricted stock and in connection with stock options exercised

218

877

1,010

568

68

177

434

10

-19

-3

-

Tax benefit of nonqualified stock options exercised

-

-

-

-394

-93

-42

62

-

-

-

-

Transfers of loans to other real estate owned

1,086

943

9,023

51

1,577

5,594

7,115

2,143

9,446

6,122

6,924

Due from broker for sales of securities

-

-

-

-

-

2,290

-

-

-

-

-

Due to broker for purchases of securities

-

-

-

2,655

0

0

-

-

-

-

-

Tax basis adjustment related to the acquisition of noncontrolling interest in m2 Lease Funds

-

-

-

2,132

-

0

-

-

-

-

-

Increase (decrease) in the fair value of back-to-back interest rate swap assets and liabilities

-62,483

-17,798

-2,059

706

-1,568

-59

-

-

-

-

-

Dividends payable

947

939

693

522

468

315

567

-

-

-

-

Transfer of equity securities from securities available for sale to other assets at fair value

-

2,614

-

-

-

-

-

-

-

-

-

Assets Sold:
Due to broker for purchases of securities

-

-

-

2,655

0

-

-

-

-

-

-

Bargain purchase gain

-

-

-

-

-

-

1,841

-

-

-

-

Gain on sale of certain assets and certain liabilities of RB&T:

12,286

-

-

-

-

-

-

-

-

-

-

Liability established for purchase of noncontrolling interest

-

-

-

-

-

-

-

2,847

-

-

-

Cash paid

-

9,834

7,803

80,000

0

-

-

0

0

-

-

Promissory note

-

1,500

-

-

-

-

-

-

-

-

-

Contingent commitment

-

2,000

-

-

-

-

-

-

-

-

-

Common stock

-

81,637

30,880

-

0

-

-

-

-

-

-

Total consideration paid

-

94,971

38,683

80,000

0

-

-

-

-

-

-

Goodwill

-

49,741

15,223

9,888

0

-

-

-

-

-

-

Exchange of shares of common stock in connection with payroll taxes for restricted stock and options exercised

-

-

-

-

-

-

-

-

-

-

-7

RB&T
Gain on sale of assets and liabilities of subsidiary

12,286

-

-

-

-

-

-

-

-

-

-

Net cash received for sale of assets and liabilities of subsidiary

42,587

-

-

-

-

-

-

-

-

-

-

Gain on sale of certain assets and certain liabilities of RB&T:

12,286

-

-

-

-

-

-

-

-

-

-

Bates Companies [Member]
Goodwill impairment

3,000

-

-

-

-

-

-

-

-

-

-

Cash paid

-

1,435

-

-

-

-

-

-

-

-

-

Goodwill

-

3,766

-

-

-

-

-

-

-

-

-

Common Stock Offering 2 [Member]
Proceeds from issuance of common stock, net

-

-

-

31,934

-

-

-

-

-

-

-

Springfield Bancshares
Cash paid

-

3,747

-

-

-

-

-

-

-

-

-

Goodwill

-

45,975

-

-

-

-

-

-

-

-

-

Guaranty Bank [Member]
Cash paid

-

-

3,368

-

-

-

-

-

-

-

-

Goodwill

-

-

15,223

-

-

-

-

-

-

-

-

Community State Bank [Member]
Goodwill

-

-

-

9,888

-

-

-

-

-

-

-