hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Net Revenues by Geographic Region
The following table details our consolidated net revenues by geographic region (amounts in millions):
(1) “EMEA” consists of the Europe, Middle East, and Africa geographic regions
Americas
The decrease in net revenues in the Americas region for 2019, as compared to 2018, was primarily due to lower revenues recognized from the Destiny franchise (reflecting our sale of the publishing rights for Destiny to Bungie in December 2018).
EMEA
The decrease in net revenues in the EMEA region for 2019, as compared to 2018, was primarily due to:
lower revenues recognized from the Destiny franchise; and lower revenues recognized from Call of Duty: Black Ops 4, which was released in October 2018, as compared to Call of Duty: WWII, which was released in November 2017.
Asia Pacific
The decrease in net revenues in the Asia Pacific region for 2019, as compared to 2018, was primarily due to:
lower revenues recognized from Hearthstone, primarily due to the prior year including additional digital content delivered in connection with the renewal of our contract with NetEase, Inc. in December 2018, with no equivalent transaction for the franchise in 2019; and lower revenues recognized from the Destiny franchise.
The decrease was partially offset by:• revenues recognized from Crash Team Racing Nitro-Fueled, which was released in June 2019; • revenues from Sekiro: Shadows Die Twice, which was released in March 2019; and • higher revenues recognized from Call of Duty: Modern Warfare, which was released in October 2019, as compared to Call of Duty: Black Ops 4.
Table:
 |  |  |  | 
 | 2019 | 2018 | Increase/ (decrease) | % Change
Net revenues by geographic region: |  |  |  | 
Americas | $3,341 | $3,880 | $(539) | (14)%
EMEA (1) | 2,239 | 2,618 | (379) | (14)
Asia Pacific | 909 | 1,002 | (93) | (9)
Consolidated net revenues | $6,489 | $7,500 | $(1,011) | (13)


Question: What was the net revenue from Americas in 2019?
Answer: $3,341
Taxes
At €298 million (2017/18: €216 million), recognised income tax expenses are €81 million higher than the previous year’s figures.
During the reporting period, the group tax rate for the continuing segment is 42.0% (2017/18: 37.6%). The group tax rate represents the relationship between recognised income tax expenses and earnings before taxes. The increase in the ratio in the current financial year is mainly attributable to impairments on deferred taxes on loss carry-forwards in Germany. The comparatively low ratio in the previous year includes positive one-off tax effects such as tax rate changes abroad and the reduction for risk provisions.
For more information about income taxes, see the notes to the consolidated financial statements in no. 12 – income taxes page 206 .
1 Adjustment of previous year according to explanation in notes.
Table:
€ million | 2017/2018 | 2018/2019
Actual taxes | 173 | 215
thereof Germany | (14) | (9)
thereof international | (159) | (206)
thereof tax expenses/income for the current period | (194) | (221)
thereof tax expenses/income of previous periods | (−21) | (−6)
Deferred taxes | 43 | 83
thereof Germany | (39) | (104)
thereof international | (4) | (−21)
 | 216 | 298


Question: What were the components under Deferred taxes in the table?
Answer: thereof Germany, thereof international
Original Equipment Manufacturers (“OEM”) are the end-customers to which we provide direct marketing application engineering support, while Distribution customers refers to the distributors and representatives that we engage to distribute our products around the world.
By market channel, our fourth quarter revenues in Distribution amounted to 28% of our total revenues, flat compared to the previous quarter and decreasing on a year-over-year basis.
Table:
 |  | Three Months Ended | 
 | December 31, 2019 | September 29, 2019 | December 31, 2018
 |  | (Unaudited, in %) | 
OEM | 72% | 72% | 69%
Distribution | 28 | 28 | 31
Total | 100% | 100% | 100%


Question: What is the average net revenues from Distribution for the period December 31, 2019 and 2018?
Answer: 29.5
Calculation: (28+31) / 2
Customer Receivables and Contract Balances
The following table provides balances of customer receivables, contract assets and contract liabilities as of December 31, 2019 and December 31, 2018:
(1) Gross customer receivables of $2.3 billion and $2.5 billion, net of allowance for doubtful accounts of $94 million and $132 million, at December 31, 2019 and December 31, 2018, respectively.
Contract liabilities are consideration we have received from our customers or billed in advance of providing goods or services promised in the future. We defer recognizing this consideration as revenue until we have satisfied the related performance obligation to the customer. Contract liabilities include recurring services billed one month in advance and installation and maintenance charges that are deferred and recognized over the actual or expected contract term, which typically ranges from one to five years depending on the service. Contract liabilities are included within deferred revenue in our consolidated balance sheet. During the years ended December 31, 2019 and December 31, 2018, we recognized $630 million and $295 million, respectively, of revenue that was included in contract liabilities as of January 1, 2019 and January 1, 2018, respectively.
Table:
 | December 31, 2019 | December 31, 2018
 | (Dollars in millions) | 
Customer receivables(1) | $2,194 | 2,346
Contract liabilities | 1,028 | 860
Contract assets | 130 | 140


Question: What was the gross customer receivables at December 31, 2019?
Answer: $2.3 billion
stock performance graph the following graph sets forth the cumulative total shareholder return on our series a common stock , series b common stock and series c common stock as compared with the cumulative total return of the companies listed in the standard and poor 2019s 500 stock index ( 201cs&p 500 index 201d ) and a peer group of companies comprised of cbs corporation class b common stock , scripps network interactive , inc . ( acquired by the company in march 2018 ) , time warner , inc . ( acquired by at&t inc . in june 2018 ) , twenty-first century fox , inc . class a common stock ( news corporation class a common stock prior to june 2013 ) , viacom , inc . class b common stock and the walt disney company . the graph assumes $ 100 originally invested on december 31 , 2013 in each of our series a common stock , series b common stock and series c common stock , the s&p 500 index , and the stock of our peer group companies , including reinvestment of dividends , for the years ended december 31 , 2014 , 2015 , 2016 , 2017 and 2018 . two peer companies , scripps networks interactive , inc . and time warner , inc. , were acquired in 2018 . the stock performance chart shows the peer group including scripps networks interactive , inc . and time warner , inc . and excluding both acquired companies for the entire five year period . december 31 , december 31 , december 31 , december 31 , december 31 , december 31 .

Table:
 | december 312013 | december 312014 | december 312015 | december 312016 | december 312017 | december 312018
disca | $ 100.00 | $ 74.58 | $ 57.76 | $ 59.34 | $ 48.45 | $ 53.56
discb | $ 100.00 | $ 80.56 | $ 58.82 | $ 63.44 | $ 53.97 | $ 72.90
disck | $ 100.00 | $ 80.42 | $ 60.15 | $ 63.87 | $ 50.49 | $ 55.04
s&p 500 | $ 100.00 | $ 111.39 | $ 110.58 | $ 121.13 | $ 144.65 | $ 135.63
peer group incl . acquired companies | $ 100.00 | $ 116.64 | $ 114.02 | $ 127.96 | $ 132.23 | $ 105.80
peer group ex . acquired companies | $ 100.00 | $ 113.23 | $ 117.27 | $ 120.58 | $ 127.90 | $ 141.58
equity compensation plan information information regarding securities authorized for issuance under equity compensation plans will be set forth in our definitive proxy statement for our 2019 annual meeting of stockholders under the caption 201csecurities authorized for issuance under equity compensation plans , 201d which is incorporated herein by reference. .

Question: what was the percentage cumulative total shareholder return on discb for the five year period ended december 31 , 2018?
Answer: -27.1%
Calculation: subtract(72.90, const_100), divide(#0, const_100)
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
8. ACCRUED EXPENSES
Accrued expenses consisted of the following:
Table:
 | As of | 
 | December 31, 2019 | December 31, 2018
Accrued property and real estate taxes | $198.1 | $169.7
Accrued pass-through costs | 74.2 | 71.2
Amounts payable to tenants | 77.9 | 93.5
Accrued rent | 75.6 | 61.4
Payroll and related withholdings | 102.4 | 90.4
Accrued construction costs | 27.8 | 41.5
Accrued income tax payable | 55.2 | 57.9
Other accrued expenses | 347.0 | 362.7
Accrued expenses | $958.2 | $948.3


Question: What was the Accrued pass-through costs in 2018?
Answer: 71.2
Financing receivables primarily consist of client loan and installment payment receivables (loans), investment in sales-type and direct financing leases, and commercial financing receivables. Client loan and installment payment receivables (loans) are provided primarily to clients to finance the purchase of hardware, software and services.
Payment terms on these financing arrangements are generally for terms up to seven years. Client loans and installment payment financing contracts are priced independently at competitive market rates. Investment in sales-type and direct financing leases relates principally to the company’s Systems products and are for terms ranging generally from two to six years.
Commercial financing receivables relate primarily to inventory and accounts receivable financing for dealers and remarketers of IBM and OEM products. Payment terms for inventory and accounts receivable financing generally range from 30 to 90 days.
Table:
($ in millions) |  |  |  | 
At December 31, 2019: | Investment in Sales-Type and Direct Financing Leases | Commercial Financing Receivables | Client Loan and Installment Payment Receivables/ (Loans) | Total
Financing receivables, gross | $6,077 | $3,836 | $13,592 | $23,504
Unearned income | (509) | (4) | (570) | (1,083)
Recorded investment | $5,567 | $3,831 | $13,022 | $22,421
Allowance for credit losses | (72) | (11) | (138) | (221)
Unguaranteed residual value | 652 | — | — | 652
Guaranteed residual value | 53 | — | — | 53
Total financing receivables, net | $6,199 | $3,820 | $12,884 | $22,904
Current portion | $2,334 | $3,820 | $ 8,037 | $14,192
Noncurrent portion | $3,865 | $      — | $ 4,847 | $ 8,712


Question: What is the average of Recorded investment?
Answer: 7473.33
Calculation: (5,567+3,831+13,022) / 3
NOTE 8—OTHER ASSETS
Deposits and restricted cash primarily relate to security deposits provided to landlords in accordance with facility lease agreements and cash restricted per the terms of certain contractual-based agreements.
Deferred implementation costs relate to direct and relevant costs on implementation of long-term contracts, to the extent such costs can be recovered through guaranteed contract revenues. As a result of the adoption of Topic 606, deferred implementation costs are no longer capitalized, but rather expensed as incurred as these costs do not relate to future performance obligations. Accordingly, these costs were adjusted through opening retained earnings as of July 1, 2018 (see note 3 "Revenues").
Capitalized costs to obtain a contract relate to incremental costs of obtaining a contract, such as sales commissions, which are eligible for capitalization on contracts to the extent that such costs are expected to be recovered (see note 3 "Revenues").
Investments relate to certain non-marketable equity securities in which we are a limited partner. Our interests in each of these investees range from 4% to below 20%. These investments are accounted for using the equity method. Our share of net income or losses based on our interest in these investments is recorded as a component of other income (expense), net in our Consolidated Statements of Income. During the year ended June 30, 2019, our share of income (loss) from these investments was $13.7 million (year ended June 30, 2018 and 2017 — $6.0 million and $6.0 million, respectively).
Long-term prepaid expenses and other long-term assets includes advance payments on long-term licenses that are being amortized over the applicable terms of the licenses and other miscellaneous assets.
Table:
 | As of June 30, 2019 | As of June 30, 2018
Deposits and restricted cash | $13,671 | $9,479
Deferred implementation costs | — | 13,740
Capitalized costs to obtain a contract | 35,593 | 13,027
Investments | 67,002 | 49,635
Long-term prepaid expenses and other long-term assets | 32,711 | 25,386
Total | $148,977 | $111,267


Question: What is the percentage difference of Deposits and restricted cash for June 30, 2019 vs June 30, 2018?
Answer: 44.22
Calculation: (13,671-9,479)/9,479
15 . leases in january 1996 , the company entered into a lease agreement with an unrelated third party for a new corporate office facility , which the company occupied in february 1997 . in may 2004 , the company entered into the first amendment to this lease agreement , effective january 1 , 2004 . the lease was extended from an original period of 10 years , with an option for five additional years , to a period of 18 years from the inception date , with an option for five additional years . the company incurred lease rental expense related to this facility of $ 1.3 million in 2008 , 2007 and 2006 . the future minimum lease payments are $ 1.4 million per annum from january 1 , 2009 to december 31 , 2014 . the future minimum lease payments from january 1 , 2015 through december 31 , 2019 will be determined based on prevailing market rental rates at the time of the extension , if elected . the amended lease also provided for the lessor to reimburse the company for up to $ 550000 in building refurbishments completed through march 31 , 2006 . these amounts have been recorded as a reduction of lease expense over the remaining term of the lease . the company has also entered into various noncancellable operating leases for equipment and office space . office space lease expense totaled $ 9.3 million , $ 6.3 million and $ 4.7 million for the years ended december 31 , 2008 , 2007 and 2006 , respectively . future minimum lease payments under noncancellable operating leases for office space in effect at december 31 , 2008 are $ 8.8 million in 2009 , $ 6.6 million in 2010 , $ 3.0 million in 2011 , $ 1.8 million in 2012 and $ 1.1 million in 2013 . 16 . royalty agreements the company has entered into various renewable , nonexclusive license agreements under which the company has been granted access to the licensor 2019s technology and the right to sell the technology in the company 2019s product line . royalties are payable to developers of the software at various rates and amounts , which generally are based upon unit sales or revenue . royalty fees are reported in cost of goods sold and were $ 6.3 million , $ 5.2 million and $ 3.9 million for the years ended december 31 , 2008 , 2007 and 2006 , respectively . 17 . geographic information revenue to external customers is attributed to individual countries based upon the location of the customer . revenue by geographic area is as follows: .

Table:
( in thousands ) | year ended december 31 , 2008 | year ended december 31 , 2007 | year ended december 31 , 2006
united states | $ 151688 | $ 131777 | $ 94282
germany | 68390 | 50973 | 34567
japan | 66960 | 50896 | 35391
canada | 8033 | 4809 | 4255
other european | 127246 | 108971 | 70184
other international | 56022 | 37914 | 24961
total revenue | $ 478339 | $ 385340 | $ 263640
.

Question: in 2008 what was the percent of the revenue by geographic from the unite states
Answer: 31.7%
Calculation: divide(151688, 478339)
Stock repurchases
(1) On March 15, 2019, the Company announced that the Board of Directors extended the expiration date of the current stock repurchase program to June 30, 2020 and increased the amount of common stock the Company is authorized to repurchase by $60 million.
Table:
 | 2019 |  | 2018 |  | 2017 | 
(in thousands) | Shares | Amount | Shares | Amount | Shares | Amount
January 1, |  | $6,620 |  | $34,892 |  | $39,385
Authorizations (1) |  | $60,000 |  | $27,003 |  | $ -
Repurchases | (333) | $(21,136) | (1,001) | $(55,275) | (99) | $(4,493)
December 31, |  | $45,484 |  | $6,620 |  | $34,892


Question: What were the respective amounts of stock repurchases made by the company as at January 1, 2018 and 2019 respectively?
Answer: $34,892, $6,620
In connection with the asset-backed securitization programs, the Company recognized the following (in millions):
(1) The amounts primarily represent proceeds from collections reinvested in revolving-period transfers.
(2) Recorded to other expense within the Consolidated Statements of Operations.
(3) Excludes $650.3 million of trade accounts receivable sold, $488.1 million of cash and $13.9 million of net cash received prior to the amendment of the foreign asset-backed securitization program and under the previous North American asset-backed securitization program.
The asset-backed securitization programs require compliance with several covenants. The North American asset-backed securitization program covenants include compliance with the interest ratio and debt to EBITDA ratio of the five-year unsecured credit facility amended as of November 8, 2017 (“the 2017 Credit Facility”). The foreign asset-backed securitization program covenants include limitations on certain corporate actions such as mergers and consolidations. As of August 31, 2019 and 2018, the Company was in compliance with all covenants under the asset-backed securitization programs.
Table:
 |  | Fiscal Year Ended August 31, | 
 | 2019(3) | 2018 | 2017
Trade accounts receivable sold | $4,057 | $8,386 | $8,878
Cash proceeds received(1) | $4,031 | $7,838 | $8,300
Pre-tax losses on sale of receivables(2) | $26 | $15 | $9
Deferred purchase price receivables as of August 31 | $— | $533 | $569


Question: What were the Pre-tax losses on sale of receivables in 2018?
Answer: $15
AMERICAN TOWER CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(Tabular amounts in millions, unless otherwise disclosed)
At December 31, 2019, the Company had net federal, state and foreign operating loss carryforwards available to reduce future taxable income. If not utilized, the Company’s NOLs expire as follows:
Table:
Years ended December 31, | Federal | State | Foreign
2020 to 2024 | $— | $222.3 | $11.9
2025 to 2029 | 141.6 | 285.7 | 104.8
2030 to 2034 | 7.0 | 41.4 | 19.6
2035 to 2039 | 3.6 | 159.5 | —
Indefinite carryforward | 22.8 | — | 853.8
Total | $175.0 | $708.9 | $990.1


Question: What is the sum of the company's total NOLs?
Answer: 1874
Calculation: $175.0+$708.9+$990.1
The total compensation of the Executive Board members for each of the years 2019, 2018, and 2017 was as follows:
Executive Board Compensation
1) Portion of total executive compensation allocated to the respective year
Table:
€ thousands | 2019 | 2018 | 2017
Short-term employee benefits | 17,378 | 18,652 | 16,634
Share-based payment1) | 32,393 | 23,646 | 25,723
Subtotal1) | 49,771 | 42,298 | 42,357
Post-employment benefits | 2,825 | 1,106 | 1,312
Thereof defined-benefit | 2,056 | 250 | 423
Thereof defined-contribution | 769 | 856 | 889
Total1) | 52,596 | 43,404 | 43,669


Question: What does the subtotal amount of compensation relate to?
Answer: Portion of total executive compensation allocated to the respective year
Acquisitions and divestments
Acquisitions
In 2019, Ericsson made acquisitions with a negative cash flow effect amounting to SEK 1,815 (1,220) million. The acquisitions presented below are not material, but the Company gives the information to provide the reader a summarized view of the content of the acquisitions made. The acquisitions consist primarily of:
Kathrein: On October 2, 2019, the Company acquired assets from Kathrein, a world leading provider of antenna and filter technologies with approximately 4,000 employees. Kathrein’s antenna and filters business has a strong R&D organization with extensive experience in antenna design and research, coupled with a strong IPR portfolio. In addition to broadening Ericsson’s portfolio of antenna and filter products, the acquisition will bring vital competence for the evolution of advanced radio network products. The acquired Kathrein business has had a negative impact of SEK –0.5 billion since the acquisition, corresponding to –1 percentage point in Networks operating margin. Balances to facilitate the Purchase price allocation are preliminary.
CSF: On August 20, 2019, the Company acquired 100% of the shares in CSF Holdings Inc. a US-based technology company with approximately 25 employees. CSF strengthens iconectiv’s Business to Consumer (B2C) product platforms to enable growth in messaging and Toll-Free Number (TFN) management. Balances to facilitate the Purchase price allocation are final.
ST-Ericsson: Before ST-Ericsson was a joint venture where Ericsson and ST Microelectronics had a 50/50 ownership. This joint venture consisted of a number of legal entities where the two parties owned different stakes in the different legal entities. In December 2019 the Company initiated transactions to wind-down the legal structure of ST-Ericsson by acquiring the remaining shares in two legal ST-Ericsson entities and costs of SEK –0.3 billion impacted the result. The Company now owns 100% of the shares in those entities.
In order to finalize a Purchase price allocation all relevant information needs to be in place. Examples of such information are final consideration and final opening balances, they may remain preliminary for a period of time due
to for example adjustments of working capital, tax items or decisions from local authorities.
1) Acquisition-related costs are included in Selling and administrative expenses in the consolidated income statement.
Table:
Acquisitions 2017–2019 |  |  | 
 | 2019 | 2018 | 2017
Total consideration, including cash | 1,957 | 1,314 | 62
Net assets acquired |  |  | 
Cash and cash equivalents | 142 | 94 | –
Property, plant and equipment | 353 | 4 | 12
Intangible assets | 497 | 481 | 101
Investments in associates | 101 | 64 | –
Other assets | 1,357 | 254 | 1
Provisions, incl. post-employment benefits | –102 | – | –
Other liabilities | –743 | –494 | 25
Total identifiable net assets | 1,605 | 403 | 139
Costs recognized in net income | 153 | – | –
Goodwill | 199 | 911 | –77
Total | 1,957 | 1,314 | 62
Acquisition-related costs 1) | 85 | 24 | 49


Question: What is the total consideration for 2017?
Answer: 62
Inventories
The components of inventories consist of the following (in millions):
Inventories are valued at the lower of cost and net realizable value using the first-in, first-out method. Inventory impairment charges establish a new cost basis for inventory and charges are not subsequently reversed to income even if circumstances later suggest that increased carrying amounts are recoverable.
Table:
 | March 31, | 
 | 2019 | 2018
Raw materials | $74.5 | $26.0
Work in process | 413.0 | 311.8
Finished goods | 224.2 | 138.4
Total inventories | $711.7 | $476.2


Question: How were inventories valued at the lower of cost and net realizable value?
Answer: using the first-in, first-out method.
Accrued Warranty
The following table summarizes the activity related to the Company’s product warranty liability during the following periods (in thousands):
Table:
 | Year Ended | 
 | June 30,
2019 | June 30,
2018
Balance beginning of period | $12,807 | $10,584
Warranties assumed due to acquisitions   | — | 3,682
New warranties issued | 22,919 | 10,491
Warranty expenditures | (20,947) | (11,950)
Balance end of period  | $14,779 | $12,807


Question: What was the amount of new warranties issued in 2019?
Answer: 22,919