Datto Holding (MSP) annual cash flow statement covering fiscal 2018 through 2021, as reported to the SEC.
A cash flow statement shows the cash that actually came in and went out, split between running the business, investing and financing.
| Dec'21 | Dec'20 | Dec'19 | Dec'18 | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OPERATING ACTIVITIES | |||||||||||||||||||
Net income | |||||||||||||||||||
51,434 | 22,498 | -31,188 | -37,723 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net income | 51,434 | 22,498 | -31,188 | -37,723 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Adjustments to reconcile net income to net cash provided by operating activities: | |||||||||||||||||||
Depreciation | |||||||||||||||||||
32,044 | 26,434 | 20,562 | 16,395 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Depreciation | 32,044 | 26,434 | 20,562 | 16,395 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Amortization of acquired intangible assets | |||||||||||||||||||
27,139 | 22,679 | 22,600 | 25,481 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Amortization of acquired intangible assets | 27,139 | 22,679 | 22,600 | 25,481 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Loss on extinguishment of debt | |||||||||||||||||||
- | -8,500 | -19,231 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Loss on extinguishment of debt | - | -8,500 | -19,231 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Amortization of debt issuance costs | |||||||||||||||||||
341 | 1,428 | 1,879 | 2,398 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Amortization of debt issuance costs | 341 | 1,428 | 1,879 | 2,398 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Reserve for inventory obsolescence | |||||||||||||||||||
57 | 1,517 | 3,168 | 261 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Reserve for inventory obsolescence | 57 | 1,517 | 3,168 | 261 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Non-cash operating lease expense | |||||||||||||||||||
7,292 | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Non-cash operating lease expense | 7,292 | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Stock-based compensation | |||||||||||||||||||
48,909 | 33,460 | 12,215 | 4,135 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Stock-based compensation | 48,909 | 33,460 | 12,215 | 4,135 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Allowance for expected credit losses | |||||||||||||||||||
367 | 6,217 | 6,634 | 2,603 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Allowance for expected credit losses | 367 | 6,217 | 6,634 | 2,603 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Deferred income taxes | |||||||||||||||||||
4,922 | 7,770 | -6,071 | -11,925 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Deferred income taxes | 4,922 | 7,770 | -6,071 | -11,925 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Unrealized foreign exchange | |||||||||||||||||||
1,303 | 1,204 | 18 | -850 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Unrealized foreign exchange | 1,303 | 1,204 | 18 | -850 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Changes in operating assets and liabilities: | |||||||||||||||||||
Accounts receivable | |||||||||||||||||||
-1,598 | -769 | 10,837 | 6,355 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Accounts receivable | -1,598 | -769 | 10,837 | 6,355 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Inventory | |||||||||||||||||||
21,186 | 2,826 | 3,538 | 2,586 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Inventory | 21,186 | 2,826 | 3,538 | 2,586 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Prepaid expenses and other current assets | |||||||||||||||||||
11,487 | 7,498 | 6,073 | -2,629 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Prepaid expenses and other current assets | 11,487 | 7,498 | 6,073 | -2,629 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Other assets | |||||||||||||||||||
19,641 | 12,952 | 24,172 | 15,917 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Other assets | 19,641 | 12,952 | 24,172 | 15,917 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Accounts payable, accrued expenses and other | |||||||||||||||||||
8,391 | 3,073 | 14,786 | -4,573 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Accounts payable, accrued expenses and other | 8,391 | 3,073 | 14,786 | -4,573 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Deferred revenue | |||||||||||||||||||
-3,511 | -1,155 | -7,943 | 13,768 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Deferred revenue | -3,511 | -1,155 | -7,943 | 13,768 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net cash provided by operating activities | |||||||||||||||||||
125,366 | 108,698 | 11,235 | -10,559 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net cash provided by operating activities | 125,366 | 108,698 | 11,235 | -10,559 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
INVESTING ACTIVITIES | |||||||||||||||||||
Purchase of property and equipment | |||||||||||||||||||
47,237 | 40,466 | 38,226 | 28,199 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Purchase of property and equipment | 47,237 | 40,466 | 38,226 | 28,199 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Acquisition of business, net of cash acquired | |||||||||||||||||||
45,486 | 4,371 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Acquisition of business, net of cash acquired | 45,486 | 4,371 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net cash used in investing activities | |||||||||||||||||||
-92,723 | -44,837 | -38,226 | -28,199 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net cash used in investing activities | -92,723 | -44,837 | -38,226 | -28,199 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
FINANCING ACTIVITIES | |||||||||||||||||||
Proceeds from debt | |||||||||||||||||||
- | 32,100 | 562,250 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Proceeds from debt | - | 32,100 | 562,250 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Repayments of debt | |||||||||||||||||||
101 | 594,727 | 523,523 | 994 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Repayments of debt | 101 | 594,727 | 523,523 | 994 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Debt issuance costs | |||||||||||||||||||
- | 1,178 | 8,775 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Debt issuance costs | - | 1,178 | 8,775 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Prepayment penalty on debt | |||||||||||||||||||
- | - | 10,400 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Prepayment penalty on debt | - | - | 10,400 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Proceeds from initial public offering, net of underwriting costs | |||||||||||||||||||
- | 641,643 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Proceeds from initial public offering, net of underwriting costs | - | 641,643 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Capitalized transaction costs | |||||||||||||||||||
684 | 5,256 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Capitalized transaction costs | 684 | 5,256 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Proceeds from stock option exercises | |||||||||||||||||||
22,510 | 3,150 | 291 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Proceeds from stock option exercises | 22,510 | 3,150 | 291 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Repurchase of common stock and settlement of stock-based payment awards | |||||||||||||||||||
- | 53 | 1,338 | 4,188 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Repurchase of common stock and settlement of stock-based payment awards | - | 53 | 1,338 | 4,188 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net cash provided by (used in) financing activities | |||||||||||||||||||
21,725 | 75,679 | 18,505 | -5,182 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net cash provided by (used in) financing activities | 21,725 | 75,679 | 18,505 | -5,182 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Effect of exchange rate changes on cash and cash equivalents | |||||||||||||||||||
-2,041 | 1,807 | 294 | -367 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Effect of exchange rate changes on cash and cash equivalents | -2,041 | 1,807 | 294 | -367 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net decrease in cash and cash equivalents | |||||||||||||||||||
52,327 | 141,347 | -8,192 | -44,307 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net decrease in cash and cash equivalents | 52,327 | 141,347 | -8,192 | -44,307 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
SUPPLEMENTAL DISCLOSURE OF CASH FLOW INFORMATION | |||||||||||||||||||
Cash paid for income taxes | |||||||||||||||||||
6,380 | 890 | 2,333 | 410 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Cash paid for income taxes | 6,380 | 890 | 2,333 | 410 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Cash paid for interest | |||||||||||||||||||
133 | 24,037 | 43,624 | 53,750 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Cash paid for interest | 133 | 24,037 | 43,624 | 53,750 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
NON-CASH INVESTING AND FINANCING ACTIVITIES | |||||||||||||||||||
Purchase of property and equipment included in accounts payable | |||||||||||||||||||
- | 17 | 3,051 | 225 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Purchase of property and equipment included in accounts payable | - | 17 | 3,051 | 225 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||