← Filings of META
Tables in the 10-Q of Meta Platforms, Inc.
33 tables with numbers, filed Jul 27, 2017. Each one downloads as an Excel file or a CSV (numbers are stored as numbers),
with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed.
Open the filing on sec.gov ↗
Table 1 after “Indicate the number of shares outstanding of each of the issuer's classes of Common Stock, as of the latest practicable date.”
| Class | Number of Shares Outstanding |
| Class A Common Stock $0.000006 par value | 2,370,333,098 shares outstanding as of July 24, 2017 |
| Class B Common Stock $0.000006 par value | 533,863,486 shares outstanding as of July 24, 2017 |
Table 2 after “TABLE OF CONTENTS”
| | Page No. |
| Note About Forward-Looking Statements | 3 | |
| Limitations of Key Metrics and Other Data | 4 | |
| PART I—FINANCIAL INFORMATION | 5 | |
| Item 1. | Financial Statements (unaudited) | 5 |
| Condensed Consolidated Balance Sheets—June 30, 2017 and December 31, 2016 | 5 |
| Condensed Consolidated Statements of Income—for the three and six months ended June 30, 2017 and 2016 | 6 |
| Condensed Consolidated Statements of Comprehensive Income—for the three and six months ended June 30, 2017 and 2016 | 7 |
First 8 of 19 rows. The download has all of them.
Table 3 after “(Unaudited)”
| June 30, 2017 | December 31, 2016 | |
| Assets | | | |
| Current assets: | | | |
| Cash and cash equivalents | $6,252 | | $8,903 |
| Marketable securities | 29,200 | | 20,546 |
| Accounts receivable, net of allowances for doubtful accounts of $90 and $94 as of June 30, 2017 and December 31, 2016, respectively | 3,897 | | 3,993 |
| Prepaid expenses and other current assets | 1,455 | | 959 |
| Total current assets | 40,804 | | 34,401 |
First 8 of 29 rows. The download has all of them.
Table 4 after “(Unaudited)”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Revenue | $9,321 | | $6,436 | | $17,353 | $11,818 |
| Costs and expenses: | | | | | | |
| Cost of revenue | 1,237 | | 917 | | 2,395 | 1,755 |
| Research and development | 1,919 | | 1,471 | | 3,753 | 2,814 |
| Marketing and sales | 1,124 | | 901 | | 2,181 | 1,728 |
| General and administrative | 640 | | 413 | | 1,295 | 778 |
First 8 of 28 rows. The download has all of them.
Table 5 after “(Unaudited)”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Net income | $3,894 | | $2,283 | | $6,959 | $4,021 |
| Other comprehensive income (loss): | | | | | | |
| Change in foreign currency translation adjustment, net of tax | 246 | | (116) | | 306 | 20 |
| Change in unrealized gain/loss on available-for-sale investments and other, net of tax | 10 | | 19 | | 27 | 61 |
| Comprehensive income | $4,150 | | $2,186 | | $7,292 | $4,102 |
Table 6 after “(Unaudited)”
| Six Months Ended June 30, | | |
| 2017 | 2016 | |
| Cash flows from operating activities | | | |
| Net income | $6,959 | | $4,021 |
| Adjustments to reconcile net income to net cash provided by operating activities: | | | |
| Depreciation and amortization | 1,400 | | 1,137 |
| Share-based compensation | 1,899 | | 1,563 |
| Deferred income taxes | (58) | | (178) |
First 8 of 37 rows. The download has all of them.
Table 7 after “(Unaudited)”
| Six Months Ended June 30, | | |
| 2017 | 2016 | |
| Supplemental cash flow data | | | |
| Cash paid during the period for: | | | |
| Interest | $— | | $11 |
| Income taxes, net | $1,359 | | $407 |
| Non-cash investing and financing activities: | | | |
| Net change in accounts payable, accrued expenses and other current liabilities, and other liabilities related to property and equipment additions | $157 | | $89 |
First 8 of 9 rows. The download has all of them.
Table 8 after “The numerators and denominators of the basic and diluted EPS computations for our common stock are calculated as follows (in millions, excep”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | | | | | | | | |
| 2017 | 2016 | | 2017 | 2016 | | | | | | | | |
| Class A | Class B | | Class A | Class B | Class A | | Class B | Class A | Class B | | | |
| Basic EPS: | | | | | | | | | | | | | |
| Numerator | | | | | | | | | | | | | |
| Net income | $3,177 | | $717 | | $1,846 | | $437 | | $5,673 | | $1,286 | $3,250 | $771 |
| Less: Net income attributable to participating securities | 4 | | — | | 5 | | 2 | | 8 | | 2 | 11 | 2 |
| Net income attributable to common stockholders | $3,173 | | $717 | | $1,841 | | $435 | | $5,665 | | $1,284 | $3,239 | $769 |
First 8 of 30 rows. The download has all of them.
Table 9 after “The following table sets forth the cash and cash equivalents, and marketable securities (in millions):”
| June 30, 2017 | December 31, 2016 | |
| Cash and cash equivalents: | | | |
| Cash | $1,452 | | $1,364 |
| Money market funds | 4,421 | | 5,409 |
| U.S. government securities | 25 | | 1,463 |
| U.S. government agency securities | 90 | | 667 |
| Certificate of deposits and time deposits | 264 | | — |
| Total cash and cash equivalents | 6,252 | | 8,903 |
First 8 of 14 rows. The download has all of them.
Table 10 after “The following table classifies our marketable securities by contractual maturities (in millions):”
| June 30, 2017 |
| Due in one year | $7,739 |
| Due in one to five years | 21,461 |
| Total | $29,200 |
Table 11 after “The following table summarizes, for assets or liabilities measured at fair value, the respective fair value and the classification by level ”
| | Fair Value Measurement atReporting Date Using | | | | |
| Description | June 30, 2017 | Quoted Pricesin ActiveMarkets forIdentical Assets(Level 1) | | SignificantOtherObservableInputs(Level 2) | SignificantUnobservableInputs(Level 3) | |
| Cash equivalents: | | | | | | |
| Money market funds | $4,421 | | $4,421 | | $— | $— |
| U.S. government securities | 25 | | 25 | | — | — |
| U.S. government agency securities | 90 | | 90 | | — | — |
| Certificate of deposits and time deposits | 264 | | — | | 264 | — |
| Marketable securities: | | | | | | |
First 8 of 14 rows. The download has all of them.
Table 12 after “The following table summarizes, for assets or liabilities measured at fair value, the respective fair value and the classification by level ”
| | Fair Value Measurement atReporting Date Using | | | | |
| Description | December 31, 2016 | Quoted Pricesin ActiveMarkets forIdentical Assets(Level 1) | | SignificantOtherObservableInputs(Level 2) | SignificantUnobservableInputs(Level 3) | |
| Cash equivalents: | | | | | | |
| Money market funds | $5,409 | | $5,409 | | $— | $— |
| U.S. government securities | 1,463 | | 1,463 | | — | — |
| U.S. government agency securities | 667 | | 667 | | — | — |
| Marketable securities: | | | | | | |
| U.S. government securities | 7,130 | | 7,130 | | — | — |
First 8 of 13 rows. The download has all of them.
Table 13 after “Property and equipment consists of the following (in millions):”
| June 30, 2017 | December 31, 2016 | |
| Land | $720 | | $696 |
| Buildings | 4,013 | | 3,109 |
| Leasehold improvements | 742 | | 531 |
| Network equipment | 6,685 | | 5,179 |
| Computer software, office equipment and other | 517 | | 398 |
| Construction in progress | 1,991 | | 1,890 |
| Total | 14,668 | | 11,803 |
First 8 of 10 rows. The download has all of them.
Table 14 after “are as follows (in millions):”
| Balance as of December 31, 2016 | $18,122 |
| Effect of currency translation adjustment | 7 |
| Balance as of June 30, 2017 | $18,129 |
Table 15 after “Intangible assets consist of the following (in millions):”
| | June 30, 2017 | December 31, 2016 | | | | | | | | |
| Weighted-Average Remaining Useful Lives (in years) | Gross Carrying Amount | Accumulated Amortization | | Net Carrying Amount | Gross Carrying Amount | Accumulated Amortization | | Net Carrying Amount | | |
| Acquired users | 4.3 | $2,056 | | $(826) | | $1,230 | | $2,056 | | $(678) | $1,378 |
| Acquired technology | 2.0 | 931 | | (614) | | 317 | | 931 | | (518) | 413 |
| Acquired patents | 6.0 | 785 | | (461) | | 324 | | 785 | | (420) | 365 |
| Trade names | 2.7 | 629 | | (350) | | 279 | | 629 | | (293) | 336 |
| Other | 3.0 | 162 | | (126) | | 36 | | 162 | | (119) | 43 |
| Total intangible assets | 4.0 | $4,563 | | $(2,377) | | $2,186 | | $4,563 | | $(2,028) | $2,535 |
Table 16 after “, expected amortization expense for the unamortized acquired intangible assets for the next five years and thereafter is as follows (in mill”
| The remainder of 2017 | $338 |
| 2018 | 619 |
| 2019 | 526 |
| 2020 | 357 |
| 2021 | 265 |
| Thereafter | 81 |
| Total | $2,186 |
| Shares Subject to Options Outstanding | | | | | |
| Number ofShares | WeightedAverageExercisePrice | | WeightedAverageRemainingContractualTerm | AggregateIntrinsicValue(1) | |
| (in thousands) | | | (in years) | (in millions) | |
| Balance as of December 31, 2016 | 5,687 | | $7.78 | | | |
| Stock options exercised | (2,154) | | 5.67 | | | |
| Balance as of June 30, 2017 | 3,533 | | $9.07 | | 2.7 | $501 |
| Stock options exercisable as of June 30, 2017 | 2,749 | | $7.38 | | 2.6 | $395 |
| Unvested RSUs(1) | | |
| Number of Shares | Weighted Average Grant Date Fair Value | |
| (in thousands) | | |
| Unvested at December 31, 2016 | 98,586 | | $82.99 |
| Granted | 28,565 | | 140.14 |
| Vested | (22,810) | | 79.72 |
| Forfeited | (3,719) | | 95.32 |
| Unvested at June 30, 2017 | 100,622 | | $99.49 |
Table 19 after “Revenue by geography is based on the billing address of the marketer or developer. The following tables set forth revenue and property and e”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Revenue: | | | | | | |
| United States | $4,048 | | $2,852 | | $7,574 | $5,361 |
| Rest of the world (1) | 5,273 | | 3,584 | | 9,779 | 6,457 |
| Total revenue | $9,321 | | $6,436 | | $17,353 | $11,818 |
Table 20 after “Revenue by geography is based on the billing address of the marketer or developer. The following tables set forth revenue and property and e”
| June 30, 2017 | December 31, 2016 | |
| Property and equipment, net: | | | |
| United States | $8,215 | | $6,793 |
| Rest of the world (1) | 2,413 | | 1,798 |
| Total property and equipment, net | $10,628 | | $8,591 |
Table 21 after “The following tables set forth our condensed consolidated statements of income data:”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| (in millions) | | | | | |
| Revenue | $9,321 | | $6,436 | | $17,353 | $11,818 |
| Costs and expenses: | | | | | | |
| Cost of revenue | 1,237 | | 917 | | 2,395 | 1,755 |
| Research and development | 1,919 | | 1,471 | | 3,753 | 2,814 |
| Marketing and sales | 1,124 | | 901 | | 2,181 | 1,728 |
First 8 of 15 rows. The download has all of them.
Table 22 after “Share-based compensation expense included in costs and expenses:”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| (in millions) | | | | | |
| Cost of revenue | $47 | | $29 | | $81 | $51 |
| Research and development | 787 | | 631 | | 1,457 | 1,217 |
| Marketing and sales | 120 | | 95 | | 216 | 177 |
| General and administrative | 78 | | 62 | | 145 | 118 |
| Total share-based compensation expense | $1,032 | | $817 | | $1,899 | $1,563 |
Table 23 after “The following tables set forth our condensed consolidated statements of income data (as a percentage of revenue):”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Revenue | 100% | | 100% | | 100% | 100% |
| Costs and expenses: | | | | | | |
| Cost of revenue | 13 | | 14 | | 14 | 15 |
| Research and development | 21 | | 23 | | 22 | 24 |
| Marketing and sales | 12 | | 14 | | 13 | 15 |
| General and administrative | 7 | | 6 | | 7 | 7 |
First 8 of 14 rows. The download has all of them.
Table 24 after “Share-based compensation expense included in costs and expenses (as a percentage of revenue):”
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Cost of revenue | 1% | | —% | | —% | —% |
| Research and development | 8 | | 10 | | 8 | 10 |
| Marketing and sales | 1 | | 1 | | 1 | 1 |
| General and administrative | 1 | | 1 | | 1 | 1 |
| Total share-based compensation expense | 11% | | 13% | | 11% | 13% |
| Three Months Ended June 30, | | | Six Months Ended June 30, | | | | | | |
| 2017 | 2016 | | % change | 2017 | 2016 | | % change | | |
| (in millions, except for percentages) | | | | | | | | | |
| Advertising | $9,164 | | $6,239 | | 47% | | $17,021 | | $11,440 | 49% |
| Payments and other fees | 157 | | 197 | | (20)% | | 332 | | 378 | (12)% |
| Total revenue | $9,321 | | $6,436 | | 45% | | $17,353 | | $11,818 | 47% |
Table 26 after “Cost of revenue”
| Three Months Ended June 30, | | | Six Months Ended June 30, | | | | | | | |
| 2017 | 2016 | | % change | 2017 | 2016 | | % change | | | |
| (in millions, except for percentages) | | | | | | | | | | |
| Cost of revenue | $1,237 | | $917 | | 35% | | $2,395 | | | $1,755 | 36% |
| Percentage of revenue | 13% | | 14% | | | 14% | | | 15% | | |
Table 27 after “Research and development”
| Three Months Ended June 30, | | | Six Months Ended June 30, | | | | | | | |
| 2017 | 2016 | | % change | 2017 | 2016 | | % change | | | |
| (in millions, except for percentages) | | | | | | | | | | |
| Research and development | $1,919 | | $1,471 | | 30% | | $3,753 | | | $2,814 | 33% |
| Percentage of revenue | 21% | | 23% | | | 22% | | | 24% | | |
Table 28 after “Marketing and sales”
| Three Months Ended June 30, | | | Six Months Ended June 30, | | | | | | | |
| 2017 | 2016 | | % change | 2017 | 2016 | | % change | | | |
| (in millions, except for percentages) | | | | | | | | | | |
| Marketing and sales | $1,124 | | $901 | | 25% | | $2,181 | | | $1,728 | 26% |
| Percentage of revenue | 12% | | 14% | | | 13% | | | 15% | | |
Table 29 after “General and administrative”
| Three Months Ended June 30, | | | Six Months Ended June 30, | | | | | | | |
| 2017 | 2016 | | % change | 2017 | 2016 | | % change | | | |
| (in millions, except for percentages) | | | | | | | | | | |
| General and administrative | $640 | | $413 | | 55% | | $1,295 | | | $778 | 66% |
| Percentage of revenue | 7% | | 6% | | | 7% | | | 7% | | |
Table 30 after “Interest and other income, net”
| Three Months Ended June 30, | | | Six Months Ended June 30, | | | | | | | | |
| 2017 | 2016 | | % change | 2017 | 2016 | | % change | | | | |
| (in millions, except for percentages) | | | | | | | | | | | |
| Interest income, net | $91 | | $32 | | 184% | | $158 | | | $60 | | 163% |
| Other (expense) income, net | (4) | | (12) | | (67)% | | 10 | | | 18 | | (44)% |
| Interest and other income, net | $87 | | $20 | | NM | $168 | | | $78 | | 115% | |
Table 31 after “Provision for income taxes”
| Three Months Ended June 30, | | | Six Months Ended June 30, | | | | | | | |
| 2017 | 2016 | | % change | 2017 | 2016 | | % change | | | |
| (in millions, except for percentages) | | | | | | | | | | |
| Provision for income taxes | $594 | | $471 | | 26% | | $938 | | | $800 | 17% |
| Effective tax rate | 13% | | 17% | | | 12% | | | 17% | | |
| Total Number of Shares Purchased (1) | Average Price Paid Per Share (2) | | Total Number of Shares Purchased as Part of Publicly Announced Programs (1) | | Approximate Dollar Value of Shares that May Yet Be Purchased Under the Plans or Programs | |
| (in thousands) | | | (in thousands) | | (in millions) | |
| April 1 – 30, 2017 | — | | $— | | | — | $5,772 |
| May 1 – 31, 2017 | — | | $— | | | — | $5,772 |
| June 1 – 30, 2017 | 1,185 | | $151.91 | | | 1,185 | $5,592 |
| 1,185 | | | | 1,185 | | |
| Exhibit | | Incorporated by Reference | FiledHerewith | | | |
| Number | Exhibit Description | Form | File No. | Exhibit | Filing Date | |
| 10.1 | 2012 Equity Incentive Plan forms of award agreements. | | | | | X |
| 31.1 | Certification of Mark Zuckerberg, Chief Executive Officer, pursuant to Rule 13a-14(a)/15d-14(a), as adopted pursuant to Section 302 of the Sarbanes-Oxley Act of 2002. | | | | | X |
| 31.2 | Certification of David M. Wehner, Chief Financial Officer, pursuant to Rule 13a-14(a)/15d-14(a), as adopted pursuant to Section 302 of the Sarbanes-Oxley Act of 2002. | | | | | X |
| 32.1# | Certification of Mark Zuckerberg, Chief Executive Officer, pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002. | | | | | X |
| 32.2# | Certification of David M. Wehner, Chief Financial Officer, pursuant to 18 U.S.C. Section 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002. | | | | | X |
| 101.INS | XBRL Instance Document. | | | | | X |
First 8 of 13 rows. The download has all of them.