Apptio inc (APTI)
CashFlow / Quarterly
Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16
Net loss

-

-

-8,099

-

-

-

-7,139

-7,917

-8,755

-8,985

-5,896

Adjustments to reconcile net loss to net cash provided by operating activities
Depreciation and amortization

1,316

1,308

1,376

1,444

1,575

1,552

1,530

1,501

1,502

1,503

1,482

(Accretion of discounts)/amortization of premiums on investments

280

195

42

24

-5

-31

-23

-18

-5

-1

-14

Amortization of acquisition-related intangible assets

896

909

583

-

-

-

-

-

-

-

-

Amortization of deferred costs

4,272

4,014

3,936

-

3,477

3,348

3,268

-

-

-

-

Amortization of debt discount and issuance costs

1,588

1,598

176

0

0

9

9

9

55

42

30

Loss on disposal of property and equipment

38

0

-47

11

-11

-3

7

1

-1

-4

-21

Stock-based compensation

6,155

5,579

4,952

4,403

4,357

3,685

3,625

3,557

2,487

2,510

1,905

Impairment of acquired assets

-

-

573

-

-

-

-

-

-

-

-

Remeasurement of preferred stock warrant liability

-

-

-

-

-

-

-

0

210

7

-15

Foreign exchange loss (gain)

-335

-576

114

-184

93

-108

174

-

-

-

-

Change in operating assets and liabilities, net of impact of business combination
Accounts receivable

7,522

3,507

-19,015

22,810

-4,696

12,768

-20,098

16,067

-1,759

14,811

-23,354

Prepaid expenses and other assets

682

1,658

-1,747

-78

-1,779

-1,191

-290

2,946

-101

-56

817

Deferred costs

5,448

5,255

2,908

-

4,529

3,447

2,672

-

-

-

-

Accounts payable

265

-1,424

2,263

1,607

-402

-758

1,795

-1,370

173

1,030

445

Accrued expenses

3,765

1,464

-2,792

1,597

-298

-769

-958

4,068

-500

3,695

-5,637

Deferred revenue

-197

1,039

-10,713

19,091

2,892

4,750

-7,570

16,373

1,576

3,726

-4,767

Deferred rent

-148

-222

-224

-203

-198

-198

-200

557

-115

-166

-140

Net cash provided by operating activities

-

-

9,776

-

-

-

11,918

-1,806

-779

-11,388

9,979

Business combination, net of cash acquired

0

4,472

34,569

-

-

-

-

-

-

-

-

Purchases of property and equipment

842

716

680

766

601

691

1,545

1,884

1,198

2,128

192

Proceeds from sales of equipment

-

-

-

13

2

0

9

-

-

-

-

Proceeds from maturities of investments

34,400

32,150

49,400

15,382

15,375

12,900

6,800

-

-

-

-

Purchases of investments

34,567

48,425

18,793

3,026

37,298

7,453

21,445

-

-

-

-

Payments for security deposits

-

-

31

-

-

-

9

141

-9

25

27

Net cash used in investing activities

-

-

-4,673

-

-

-

-16,190

-66,502

-12,015

4,092

-219

Proceeds from borrowings on convertible notes, net of issuance costs

-

-

139,438

-

-

-

-

-

-

-

-

Purchase of capped calls

0

0

17,092

-

-

-

-

-

-

-

-

Proceeds from exercises of common stock options

4,090

6,427

7,515

12,920

3,453

4,937

558

333

489

124

387

Payment of initial public offering costs

-

-

-

0

0

0

243

1,788

356

40

178

Proceeds from long-term debt

-

-

-

-

-

-

-

0

0

10,000

10,000

Principal payments on capital lease obligations

7

7

6

11

11

10

11

10

10

14

9

Net cash provided by financing activities

-

-

129,855

-

-

-

304

-1,465

82,583

9,834

10,200

Foreign currency effect on cash, cash equivalents and restricted cash

-

-

39

-

-

-

-135

68

-129

-209

7

Net increase (decrease) in cash, cash equivalents and restricted cash

-

-

134,997

-

-

-

-4,103

-69,705

69,660

2,329

19,967

Supplemental non-cash disclosures
Business acquisition working capital adjustment

-

-

4,295

-

-

-

-

-

-

-

-

Debt issuance costs in accounts payable and accrued expenses

-

-440

444

-

-

-

-

-

-

-

-

Purchases under capital lease obligations

0

0

144

-

-

-

-

-

-

-

-

Property and equipment additions in accounts payable and accrued expenses

1,495

-29

376

125

-414

197

545

-

-

-

-