tickdelta
Sign in
Tables

Tables in the 10-Q of Monster Beverage Corp

36 tables with numbers, filed May 2, 2016. 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 ↗

← Filings of MNST

Table 1 after “INDEX”

Part I.FINANCIAL INFORMATIONPage No.
Item 1.Condensed Consolidated Financial Statements (Unaudited)
Condensed Consolidated Balance Sheets as of March 31, 2016 and December 31, 20153
Condensed Consolidated Statements of Income for the Three-Months Ended March 31, 2016 and 20154
Condensed Consolidated Statements of Comprehensive Income for the Three-Months Ended March 31, 2016 and 20155
Condensed Consolidated Statements of Cash Flows for the Three-Months Ended March 31, 2016 and 20156
Notes to Condensed Consolidated Financial Statements8
Item 2.Management’s Discussion and Analysis of Financial Condition and Results of Operations28

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

Table 2 after “(In Thousands, Except Par Value) (Unaudited)”

March 31, 2016December 31, 2015
ASSETS
CURRENT ASSETS:
Cash and cash equivalents$2,528,109$2,175,417
Short-term investments508,243744,610
Accounts receivable, net416,704352,955
TCCC Transaction receivable125,000125,000
Inventories165,929156,121

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

Table 3 after “(In Thousands, Except Per Share Amounts) (Unaudited)”

Three-Months Ended
March 31,
20162015
NET SALES$680,186$626,791
COST OF SALES257,088257,834
GROSS PROFIT423,098368,957
OPERATING EXPENSES168,385361,328
OPERATING INCOME254,7137,629

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

Table 4 after “(In Thousands) (Unaudited)”

Three-Months Ended March 31,
20162015
Net income, as reported$163,877$4,414
Other comprehensive income:
Change in foreign currency translation adjustment6,435(9,980)
Available-for-sale investments:
Change in net unrealized gains--
Reclassification adjustment for net gains included in net income--

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

Table 5 after “(In Thousands) (Unaudited)”

Three-Months Ended
March 31, 2016March 31, 2015
CASH FLOWS FROM OPERATING ACTIVITIES:
Net income$163,877$4,414
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization9,0246,470
Loss (gain) on disposal of property and equipment46(46)
Stock-based compensation10,0626,354

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

Table 6 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

Three-Months Ended March 31, 2015
Pro Forma Adjustments
Monster Beverage Corporation as reportedKO EnergyDisposal of Monster Non- EnergyOtherPro Forma Combined
Net sales$626,791$80,705$(31,308)$4,923$681,111
Net income4,41459,4391(1,229)(23,159)39,465

Table 7 after “Pro-Forma Adjustments – Other include the following:”

Three-Months Ended March 31, 2015
Net sales:
Amortization of deferred revenue$4,923
Net income:
Amortization of deferred revenue$4,923
To record sales commissions(9,043)
To record amortization of definite lived KO Energy intangibles(1,726)
To eliminate TCCC Transaction expenses3,597

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

Table 8 after “The following table summarizes the Company’s investments at:”

March 31, 2016Amortized CostGross Unrealized Holding GainsGross Unrealized Holding LossesFair ValueContinuous Unrealized Loss Position less than 12 MonthsContinuous Unrealized Loss Position greater than 12 Months
Held-to-Maturity
Short-term:
Commercial paper$7,969$-$-$7,969$-$-
Municipal securities464,86522148464,739148-
U.S. government agency securities17,3161717,3107-
U.S. Treasuries18,0931-18,094--
Long-term:

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

Table 9 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

March 31, 2016December 31, 2015
Amortized CostFair ValueAmortized CostFair Value
Less than 1 year:
Commercial paper$7,969$7,969$3,978$3,978
Municipal securities464,865464,739709,207709,078
U.S. government agency securities17,31617,31023,36923,311
U.S. Treasuries18,09318,0948,0568,043
Due 1 -10 years:

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

Table 10 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

March 31, 2016Level 1Level 2Level 3Total
Cash$280,113$-$-$280,113
Money market funds1,195,818--1,195,818
Certificates of deposit-102,315-102,315
Commercial paper-244,125-244,125
U.S. Treasuries-561,104-561,104
Municipal securities-478,005-478,005
U.S. government agency securities-182,291-182,291

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

Table 11 after “The notional amount and fair value of all outstanding foreign currency derivative instruments in the condensed consolidated balance sheets c”

March 31, 2016
Derivatives not designated as hedging instruments under FASB ASC 815-20Notional AmountFair ValueBalance Sheet Location
Assets:
Foreign currency exchange contracts:
Receive EUR/pay USD$21,945$157Accounts receivable, net
Receive SGD/pay USD9,60638Accounts receivable, net
Receive RUB/pay USD1,37424Accounts receivable, net
Liabilities:

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

Table 12 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

December 31, 2015
Derivatives not designated as hedging instruments under FASB ASC 815-20Notional AmountFair ValueBalance Sheet Location
Assets:
Foreign currency exchange contracts:
Receive USD/pay GBP$18,146$168Accounts receivable, net
Receive USD/pay ZAR17,411144Accounts receivable, net
Receive USD/pay RUB2,1739Accounts receivable, net
Receive USD/pay BRL2,47849Accounts receivable, net

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

Table 13 after “The net gains (losses) on derivative instruments in the condensed consolidated statements of income were as follows:”

Amount of gain (loss) recognized in income on derivatives
Three-months ended
Derivatives not designated as hedging instruments under FASB ASC 815-20Location of gain recognized in income on derivativesMarch 31, 2016March 31, 2015
Foreign currency exchange contractsInterest and other income, net$317$(1,856)

Table 14 after “Inventories consist of the following at:”

March 31, 2016December 31, 2015
Raw materials$55,053$52,043
Finished goods110,876104,078
$165,929$156,121

Table 15 after “Property and equipment consist of the following at:”

March 31, 2016December 31, 2015
Land$6,792$6,792
Leasehold improvements2,8622,804
Furniture and fixtures3,5993,551
Office and computer equipment10,63911,080
Computer software2,6722,530
Equipment97,12493,465
Buildings40,04339,848

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

Table 16 after “The following is a roll-forward of goodwill for the three-months ended March 31, 2016 by reportable segment:”

Finished ProductsConcentrateTotal
Balance at December 31, 2015$641,716$637,999$1,279,715
Acquisitions---
Balance at March 31, 2016$641,716$637,999$1,279,715

Table 17 after “Intangible assets consist of the following at:”

March 31, 2016December 31, 2015
Amortizing intangibles$35,286$35,263
Accumulated amortization(5,651)(3,899)
29,63531,364
Non-amortizing intangibles398,943396,622
$428,578$427,986

Table 18 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

Currency Translation Losses
Balance at December 31, 2015$21,878
Other comprehensive (gain) before reclassifications-
Amounts reclassified from accumulated other comprehensive loss-
Net current-period other comprehensive (gain)(6,435)
Balance at March 31, 2016$15,443

Table 19 after “The following weighted-average assumptions were used to estimate the fair value of options granted during:”

Three-Months Ended March 31,
20162015
Dividend yield0.0%0.0%
Expected volatility36.2%37.1%
Risk-free interest rate1.5%1.6%
Expected term5.7 years5.8 years

Table 20 after “The following table summarizes the Company’s activities with respect to its stock option plans as follows:”

OptionsNumber of Shares (In thousands)Weighted- Average Exercise Price Per ShareWeighted- Average Remaining Contractual Term (In years)Aggregate Intrinsic Value
Outstanding at January 1, 20166,590$50.855.6$646,497
Granted 01/01/16 - 03/31/16961$132.06
Exercised(110)$37.18
Cancelled or forfeited(8)$93.05
Outstanding at March 31, 20167,433$61.505.7$536,196
Vested and expected to vest in the future at March 31, 20166,969$57.975.5$527,253
Exercisable at March 31, 20164,257$30.384.0$438,805

Table 21 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

Number of Shares (in thousands)Weighted Average Grant-Date Fair Value
Non-vested at January 1, 2016178$99.58
Granted 01/01/16- 03/31/1682$131.96
Vested(46)$109.44
Forfeited/cancelled-$-
Non-vested at March 31, 2016214$109.84

Table 22 after “The following is a roll-forward of the Company’s total gross unrecognized tax benefits, not including interest and penalties, for the three-”

Gross Unrecognized Tax Benefits
Balance at December 31, 2015$471
Additions for tax positions related to the current year-
Additions for tax positions related to the prior year-
Decreases related to settlement with taxing authority-
Balance at March 31, 2016$471

Table 23 after “A reconciliation of the weighted-average shares used in the basic and diluted earnings per common share computations is presented below:”

Three-Months Ended
March 31,
20162015
Weighted-average shares outstanding:
Basic202,946169,871
Dilutive securities3,9623,907
Diluted206,908173,778

Table 24 after “The net revenues derived from the Company’s reportable segments and other financial information related thereto for the three-months ended M”

Three-Months Ended
March 31,
20162015
Net sales:
Finished Products(1)$624,292$595,482
Concentrate55,894-
Other-31,309
Corporate and unallocated--

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

Table 25 after “The net revenues derived from the Company’s reportable segments and other financial information related thereto for the three-months ended M”

Three-Months Ended
March 31,
20162015
Operating Income:
Finished Products(1) (2)$267,996$55,621
Concentrate38,122-
Other-1,999
Corporate and unallocated(51,405)(49,991)

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

Table 26 after “The net revenues derived from the Company’s reportable segments and other financial information related thereto for the three-months ended M”

Three-Months Ended
March 31,
20162015
Income before tax:
Finished Products(1) (2)$268,047$55,695
Concentrate38,107-
Other-1,999
Corporate and unallocated(50,833)(48,832)

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

Table 27 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

Three-Months Ended
March 31,
20162015
Depreciation and amortization
Finished Products$5,779$5,055
Concentrate1,770-
Other-140
Corporate and unallocated1,4751,275

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

Table 28 after “(Tabular Dollars in Thousands, Except Per Share Amounts) (Unaudited)”

March 31, 2016December 31, 2015
Goodwill and other intangible assets:
Finished Products$701,651$699,346
Concentrate1,006,6421,008,355
Other--
Corporate and unallocated--
$1,708,293$1,707,701

Table 29 after “expenses were $1.6 million and $1.8 million for the three-months ended March 31, 2016 and 2015, respectively. Accounts receivable, accounts ”

March 31, 2016December 31, 2015
Accounts receivable, net$217,708$172,201
Accounts payable$59,347$58,579
Accrued promotional allowances$41,752$27,544

Table 30 after “The following table summarizes the selected items discussed above for the three-months ended March 31, 2016 and 2015:”

Income Statement Items (in thousands):Three-Months Ended March 31, 2016Three-Months Ended March 31, 2015
Included in Net Sales:
Accelerated recognition of deferred revenue$-$39,761
Included in Operating Expenses:
Distributor termination costs$3,440$205,980
TCCC Transaction expenses$-$3,597
Net Impact on Operating Income$(3,440)$(169,816)

Table 31 after “Our customers are primarily full service beverage bottlers/distributors, retail grocery and specialty chains, wholesalers, club stores, drug”

Three-Months Ended March 31,
20162015
U.S. full service bottlers/distributors66%65%
Club stores, drug chains & mass merchandisers9%9%
International full service bottlers/distributors24%21%
Retail grocery, specialty chains and wholesalers1%3%
Other0%2%

Table 32 after “The following table sets forth key statistics for the three-months ended March 31, 2016 and 2015, respectively.”

(In thousands, except per share amounts)Three-Months Ended March 31,Percentage Change
2016201516 vs. 15
Net sales1$680,186$626,7918.5%
Cost of sales257,088257,834(0.3%)
Gross profit*1423,098368,95714.7%
Gross profit as a percentage of net sales162.2%58.9%
Operating expenses2,3168,385361,328(53.4%)
Operating expenses as a percentage of net sales24.8%57.6%

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

Table 33 after “Table of Contents”

(In thousands, except per share amounts)Three-Months Ended March 31,Percentage Change
2016201516 vs. 15
Gross sales, net of discounts and returns$777,508$710,1939.5%
Less: Promotional and other allowances***97,32283,40216.7%
Net Sales$680,186$626,7918.5%

Table 34 after “The following represents a summary of the Company’s contractual commitments and related scheduled maturities as of March 31, 2016:”

Payments due by period (in thousands)
ObligationsTotalLess than 1 year1-3 years3-5 yearsMore than 5 years
Contractual Obligations1$106,316$63,891$42,380$45$-
Capital Leases1,4551,455---
Operating Leases11,0766,7452,892789650
Purchase Commitments233,62133,621---
$152,468$105,712$45,272$834$650

Table 35 after “Table of Contents”

(In thousands, except average net sales per case)Three-Months Ended March 31,
20162015
Net sales1$680,186$626,791
Case sales by segment:
Finished Products57,87751,847
Concentrate14,776-
Other-5,932
Total case sales72,65357,779

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

Table 36 after “EXHIBITS”

31.1*Certification of Chief Executive Officer Pursuant to Section 302 of the Sarbanes- Oxley Act of 2002
31.2*Certification of Chief Financial Officer Pursuant to Section 302 of the Sarbanes- Oxley Act of 2002
32.1*Certification of Chief Executive Officer Pursuant to 18 U.S.C. Section 1350, as Adopted Pursuant to Section 906 of the Sarbanes-Oxley Act of 2002
32.2*Certification by Chief Financial Officer Pursuant to 18 U.S.C. Section 1350, as Adopted Pursuant to Section 906 of the Sarbanes-Oxley Act of 2002
101*The following financial information from Monster Beverage Corporation’s Quarterly Report on Form 10-Q for the quarter ended March 31, 2016, formatted in XBRL (eXtensible Business Reporting Language): (i) Condensed Consolidated Balance Sheets as of March 31, 2016 and December 31, 2015, (ii) Condensed Consolidated Statements of Income for the three-months ended March 31, 2016 and 2015, (iii) Condensed Consolidated Statements of Comprehensive Income for the three-months ended March 31, 2016 and 2015, (iv) Condensed Consolidated Statements of Cash Flows for the three-months ended March 31, 2016 and 2015, and (v) the Notes to Condensed Consolidated Financial Statements.
Esc

Type a ticker such as AAPL, a name, an investor such as Buffett, or a topic such as tariffs. ↑ ↓ to move, Enter to open.