tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← 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.”

ClassNumber of Shares Outstanding
Class A Common Stock $0.000006 par value2,370,333,098 shares outstanding as of July 24, 2017
Class B Common Stock $0.000006 par value533,863,486 shares outstanding as of July 24, 2017

Table 2 after “TABLE OF CONTENTS”

Page No.
Note About Forward-Looking Statements3
Limitations of Key Metrics and Other Data4
PART I—FINANCIAL INFORMATION5
Item 1.Financial Statements (unaudited)5
Condensed Consolidated Balance Sheets—June 30, 2017 and December 31, 20165
Condensed Consolidated Statements of Income—for the three and six months ended June 30, 2017 and 20166
Condensed Consolidated Statements of Comprehensive Income—for the three and six months ended June 30, 2017 and 20167

First 8 of 19 rows. The download has all of them.

Table 3 after “(Unaudited)”

June 30, 2017December 31, 2016
Assets
Current assets:
Cash and cash equivalents$6,252$8,903
Marketable securities29,20020,546
Accounts receivable, net of allowances for doubtful accounts of $90 and $94 as of June 30, 2017 and December 31, 2016, respectively3,8973,993
Prepaid expenses and other current assets1,455959
Total current assets40,80434,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,
2017201620172016
Revenue$9,321$6,436$17,353$11,818
Costs and expenses:
Cost of revenue1,2379172,3951,755
Research and development1,9191,4713,7532,814
Marketing and sales1,1249012,1811,728
General and administrative6404131,295778

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,
2017201620172016
Net income$3,894$2,283$6,959$4,021
Other comprehensive income (loss):
Change in foreign currency translation adjustment, net of tax246(116)30620
Change in unrealized gain/loss on available-for-sale investments and other, net of tax10192761
Comprehensive income$4,150$2,186$7,292$4,102

Table 6 after “(Unaudited)”

Six Months Ended June 30,
20172016
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 amortization1,4001,137
Share-based compensation1,8991,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,
20172016
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,
2017201620172016
Class AClass BClass AClass BClass AClass BClass AClass 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 securities4—5282112
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, 2017December 31, 2016
Cash and cash equivalents:
Cash$1,452$1,364
Money market funds4,4215,409
U.S. government securities251,463
U.S. government agency securities90667
Certificate of deposits and time deposits264—
Total cash and cash equivalents6,2528,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 years21,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
DescriptionJune 30, 2017Quoted Pricesin ActiveMarkets forIdentical Assets(Level 1)SignificantOtherObservableInputs(Level 2)SignificantUnobservableInputs(Level 3)
Cash equivalents:
Money market funds$4,421$4,421$—$—
U.S. government securities2525——
U.S. government agency securities9090——
Certificate of deposits and time deposits264—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
DescriptionDecember 31, 2016Quoted Pricesin ActiveMarkets forIdentical Assets(Level 1)SignificantOtherObservableInputs(Level 2)SignificantUnobservableInputs(Level 3)
Cash equivalents:
Money market funds$5,409$5,409$—$—
U.S. government securities1,4631,463——
U.S. government agency securities667667——
Marketable securities:
U.S. government securities7,1307,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, 2017December 31, 2016
Land$720$696
Buildings4,0133,109
Leasehold improvements742531
Network equipment6,6855,179
Computer software, office equipment and other517398
Construction in progress1,9911,890
Total14,66811,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 adjustment7
Balance as of June 30, 2017$18,129

Table 15 after “Intangible assets consist of the following (in millions):”

June 30, 2017December 31, 2016
Weighted-Average Remaining Useful Lives (in years)Gross Carrying AmountAccumulated AmortizationNet Carrying AmountGross Carrying AmountAccumulated AmortizationNet Carrying Amount
Acquired users4.3$2,056$(826)$1,230$2,056$(678)$1,378
Acquired technology2.0931(614)317931(518)413
Acquired patents6.0785(461)324785(420)365
Trade names2.7629(350)279629(293)336
Other3.0162(126)36162(119)43
Total intangible assets4.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
2018619
2019526
2020357
2021265
Thereafter81
Total$2,186

Table 17 after “17”

Shares Subject to Options Outstanding
Number ofSharesWeightedAverageExercisePriceWeightedAverageRemainingContractualTermAggregateIntrinsicValue(1)
(in thousands)(in years)(in millions)
Balance as of December 31, 20165,687$7.78
Stock options exercised(2,154)5.67
Balance as of June 30, 20173,533$9.072.7$501
Stock options exercisable as of June 30, 20172,749$7.382.6$395

Table 18 after “:”

Unvested RSUs(1)
Number of SharesWeighted Average Grant Date Fair Value
(in thousands)
Unvested at December 31, 201698,586$82.99
Granted28,565140.14
Vested(22,810)79.72
Forfeited(3,719)95.32
Unvested at June 30, 2017100,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,
2017201620172016
Revenue:
United States$4,048$2,852$7,574$5,361
Rest of the world (1)5,2733,5849,7796,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, 2017December 31, 2016
Property and equipment, net:
United States$8,215$6,793
Rest of the world (1)2,4131,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,
2017201620172016
(in millions)
Revenue$9,321$6,436$17,353$11,818
Costs and expenses:
Cost of revenue1,2379172,3951,755
Research and development1,9191,4713,7532,814
Marketing and sales1,1249012,1811,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,
2017201620172016
(in millions)
Cost of revenue$47$29$81$51
Research and development7876311,4571,217
Marketing and sales12095216177
General and administrative7862145118
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,
2017201620172016
Revenue100%100%100%100%
Costs and expenses:
Cost of revenue13141415
Research and development21232224
Marketing and sales12141315
General and administrative7677

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,
2017201620172016
Cost of revenue1%—%—%—%
Research and development810810
Marketing and sales1111
General and administrative1111
Total share-based compensation expense11%13%11%13%

Table 25 after “Revenue”

Three Months Ended June 30,Six Months Ended June 30,
20172016% change20172016% change
(in millions, except for percentages)
Advertising$9,164$6,23947%$17,021$11,44049%
Payments and other fees157197(20)%332378(12)%
Total revenue$9,321$6,43645%$17,353$11,81847%

Table 26 after “Cost of revenue”

Three Months Ended June 30,Six Months Ended June 30,
20172016% change20172016% change
(in millions, except for percentages)
Cost of revenue$1,237$91735%$2,395$1,75536%
Percentage of revenue13%14%14%15%

Table 27 after “Research and development”

Three Months Ended June 30,Six Months Ended June 30,
20172016% change20172016% change
(in millions, except for percentages)
Research and development$1,919$1,47130%$3,753$2,81433%
Percentage of revenue21%23%22%24%

Table 28 after “Marketing and sales”

Three Months Ended June 30,Six Months Ended June 30,
20172016% change20172016% change
(in millions, except for percentages)
Marketing and sales$1,124$90125%$2,181$1,72826%
Percentage of revenue12%14%13%15%

Table 29 after “General and administrative”

Three Months Ended June 30,Six Months Ended June 30,
20172016% change20172016% change
(in millions, except for percentages)
General and administrative$640$41355%$1,295$77866%
Percentage of revenue7%6%7%7%

Table 30 after “Interest and other income, net”

Three Months Ended June 30,Six Months Ended June 30,
20172016% change20172016% change
(in millions, except for percentages)
Interest income, net$91$32184%$158$60163%
Other (expense) income, net(4)(12)(67)%1018(44)%
Interest and other income, net$87$20NM$168$78115%

Table 31 after “Provision for income taxes”

Three Months Ended June 30,Six Months Ended June 30,
20172016% change20172016% change
(in millions, except for percentages)
Provision for income taxes$594$47126%$938$80017%
Effective tax rate13%17%12%17%

Table 32 after “:”

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, 20171,185$151.911,185$5,592
1,1851,185

Table 33 after “58”

ExhibitIncorporated by ReferenceFiledHerewith
NumberExhibit DescriptionFormFile No.ExhibitFiling Date
10.12012 Equity Incentive Plan forms of award agreements.X
31.1Certification 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.2Certification 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.INSXBRL Instance Document.X

First 8 of 13 rows. The download has all of them.