Dropbox, inc. (DBX)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17
Cash flow from operating activities
Net Income (Loss) Attributable to Parent

-5,700

-52,700

-55,600

-44,400

-27,100

-484,900

-513,100

-521,400

-544,100

-111,700

0

0

0

Adjustments to reconcile net income (loss) to net cash provided by operating activities:
Depreciation and amortization

167,200

173,500

177,700

182,800

176,700

166,800

164,500

163,300

169,700

181,800

0

0

0

Stock-based compensation

245,400

261,200

245,400

232,200

219,200

650,100

644,000

628,700

612,300

164,600

0

0

0

Equity Securities, FV-NI, Gain (Loss)

0

-

0

0

0

-

-

-

-

-

-

-

-

Amortization of deferred commissions

18,700

17,500

16,300

14,900

13,600

12,100

10,500

9,300

7,800

6,600

0

0

0

Other

11,000

16,600

9,300

8,400

5,700

1,900

800

1,900

1,800

1,700

0

0

0

Changes in operating assets and liabilities:
Trade and other receivables, net

3,600

7,500

9,800

6,500

8,600

-100

2,400

7,200

10,400

14,400

0

0

0

Prepaid expenses and other current assets

18,700

18,200

26,700

32,500

60,600

47,900

67,000

54,500

26,800

18,200

0

0

0

Other assets

-67,800

-61,200

-41,000

-32,500

-5,700

11,200

16,800

26,000

14,500

10,600

0

0

0

Accounts payable

3,800

6,400

-200

5,000

-4,100

-1,700

12,400

5,100

12,600

16,200

0

0

0

Accrued and other current liabilities

3,100

23,000

9,200

6,300

41,500

40,300

48,600

66,700

37,100

34,000

0

0

0

Accrued compensation and benefits

5,300

19,100

14,700

11,100

5,300

25,000

17,400

10,100

8,300

14,400

0

0

0

Deferred revenue

72,300

68,700

60,300

48,000

58,300

66,400

72,600

78,500

72,100

64,300

0

0

0

Other non-current liabilities

-65,700

-62,400

-37,300

-18,400

-1,200

12,200

2,900

5,600

-1,200

-4,400

0

0

0

Increase (Decrease) Tenant Improvement Allowance Reimbursement

50,700

55,300

-45,400

-28,500

13,800

0

0

0

0

-

-

-

-

Net cash provided by operating activities

518,600

528,500

465,400

443,700

426,800

425,400

372,800

356,300

330,500

330,300

0

0

0

Cash flow from investing activities
Capital expenditures

134,200

136,100

146,000

106,800

82,800

63,000

40,900

36,100

30,100

25,300

0

0

0

Purchase of intangible assets

-

-

-

-

-

-

-

-

-

800

0

0

0

Business combinations, net of cash acquired

1,800

173,900

171,600

171,600

172,100

0

0

0

0

-

-

-

-

Cash received from equipment rebates

-

-

-

-

-

-

-

-

-

-

0

0

0

Purchases of short-term investments

742,900

775,400

768,800

744,200

822,600

850,400

664,300

495,900

180,800

0

0

0

0

Proceeds from sales of short-term investments

249,700

294,800

491,800

390,300

322,600

212,400

0

0

0

-

-

-

-

Proceeds from maturities of short-term investments

457,200

456,100

206,000

216,400

137,800

71,200

0

0

0

-

-

-

-

Other

-15,300

-16,200

-8,000

-12,200

-6,100

1,000

0

0

0

-

-

-

-

Net cash used in investing activities

-158,400

-320,000

-383,600

-406,700

-614,000

-633,800

-542,000

-513,800

-212,900

-23,900

0

0

0

Cash flow from financing activities
Proceeds from Issuance Initial Public Offering

-

-

-

-

-

746,600

746,600

746,600

638,200

0

0

0

0

Payments of Stock Issuance Costs

-

-

-

-

-

4,500

7,000

5,900

3,400

2,500

0

0

0

Shares repurchased for tax withholdings on release of restricted stock

78,800

85,400

92,300

117,600

136,200

351,900

342,400

346,300

305,100

87,900

0

0

0

Proceeds from issuance of common stock, net of repurchases

2,000

2,200

18,400

27,200

26,300

26,200

0

0

0

-

-

-

-

Principal payments on finance lease obligations

88,400

92,900

96,800

101,400

105,500

109,100

114,800

122,000

128,200

133,000

0

0

0

Common stock repurchases

0

-

-

-

0

-

-

-

-

-

-

-

-

Other

-800

-600

-800

-3,100

-4,600

-6,500

-7,800

-7,800

-9,700

-8,800

0

0

0

Net cash used in financing activities

-230,000

-176,700

-171,500

-196,000

-115,200

300,800

284,400

266,100

193,100

-231,700

0

0

0

Effect of exchange rate changes on cash and cash equivalents

-3,000

200

-3,300

-1,500

-3,700

-3,100

-1,700

-200

3,400

2,600

0

0

0

Change in cash and cash equivalents

127,200

32,000

-93,000

-160,500

-306,100

89,300

113,500

108,400

314,100

77,300

0

0

0

Supplemental cash flow data:
Property and equipment acquired under finance leases

0

-

0

0

0

-

-

-

-

-

-

-

-

Non-cash investing and financing activities:
Property and equipment acquired under finance leases

-

-

-

-

-

98,500

99,200

73,700

55,900

44,900

0

0

0