hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Contractual Obligations
The following table summarizes our contractual obligations as of September 30, 2019 (in thousands):
Our principal executive offices, as well as our research and development facility, are located in approximately 29,000 square feet of office space in San Diego, California and the term of the lease continues through June 30, 2024. The average annual base rent under this lease is approximately $1.0 million per year. In connection with this lease, we received tenant improvement allowances totaling approximately $1.0 million. These lease incentives are being amortized as a reduction of rent expense over the term of the lease.
Our other offices are located in Paris, France; Amsterdam, The Netherlands; New York, New York; Barcelona, Spain; and London, United Kingdom. The
term of the Paris, France lease continues through July 31, 2021, with an annual base rent of approximately €0.4 million (or $0.4 million). The term of the
Amsterdam, The Netherlands lease continues through December 31, 2022, with an annual base rent of approximately €0.2 million (or $0.2 million). The term of
the New York, New York lease continues through November 30, 2024, with an annual base rent of approximately $0.2 million. The term of the Barcelona, Spain lease continues through May 31, 2023, with an annual base rent of approximately €0.1 million (or $0.1 million). The term of the London, United Kingdom lease continues through May 31, 2020, with an annual base rent of approximately £63,000 (or approximately $78,000). Our other offices are located in Paris, France; Amsterdam, The Netherlands; New York, New York; Barcelona, Spain; and London, United Kingdom. The term of the Paris, France lease continues through July 31, 2021, with an annual base rent of approximately €0.4 million (or $0.4 million). The term of the Amsterdam, The Netherlands lease continues through December 31, 2022, with an annual base rent of approximately €0.2 million (or $0.2 million). The term of the New York, New York lease continues through November 30, 2024, with an annual base rent of approximately $0.2 million. The term of the Barcelona, Spain lease continues through May 31, 2023, with an annual base rent of approximately €0.1 million (or $0.1 million). The term of the London, United Kingdom lease continues through May 31, 2020, with an annual base rent of approximately £63,000 (or approximately $78,000).
Other than the lease for our office space in San Diego, California, we do not believe that the leases for our offices are material to the Company. We believe our existing properties are in good condition and are sufficient and suitable for the conduct of its business.
Table:
 | Less than 1 year | 1-3 years | 3-5 years | More than 5 years | Total
Operating lease obligations | $1,699 | $3,950 | $2,707 | $36 | $8,392
Other borrowings | 131 | 145 | 219 | 61 | 556
Total | $1,830 | $4,095 | $2,926 | $97 | $8,948


Question: What is the proportion of total operating lease obligations that expire in 3 years over total operating lease obligations?
Answer: 0.67
Calculation: (1,699+3,950)/8,392
Non-GAAP Integration and Transformation Costs and Special Items
(UNAUDITED)
($ in millions)
(1) Includes $18 million of hardware impairment for Q3 2018 and $15 million of content commitment impairment and $27 million of hardware, software and internal labor impairment in Q1 2018.
(2) Includes $55 million of restructuring reserve impairment for Q2 2018.
(3) Reference to pro forma figures assume the Level 3 acquisition and the colocation and data center sale took place on January 1, 2017.
Table:
 |  |  | Pro Forma (3)
Integration and Transformation Costs and Special Items Impacting Adjusted EBITDA | 2019 | 2018 | 2017
Consumer litigation settlement | $65 | 0 | 0
Loss on sale of data centers and colocation business | 0 | 0 | 82
OTT/Stream impairment of content commitment and hardware, software, and internal labor(1) | 0 | 60 | 0
Total special items impacting Adjusted EBITDA | 65 | 60 | 82
Plus: integration and transformation costs impacting Adjusted EBITDA (2) | 234 | 378 | 164
Plus: transaction related expenses impacting Adjusted EBTIDA | 0 | 0 | 192
Total integration and transformation costs and special items impacting Adjusted EBITDA | $299 | 438 | 438


Question: What does the integration and transformation costs impacting Adjusted EBITDA include?
Answer: $55 million of restructuring reserve impairment for Q2 2018
(1) Of the total deferred costs, $1,896 million was current and $2,472 million was noncurrent at December 31, 2019 and $2,300 million was current and $2,676 million was noncurrent at December 31, 2018.
The amount of total deferred costs amortized during the year ended December 31, 2019 was $3,836 million and there were no material impairment losses incurred. Refer to note A, “Significant Accounting Policies,” for additional information on deferred costs to fulfill a contract and capitalized costs of obtaining a contract.
Table:
($ in millions) |  | 
At December 31: | 2019 | 2018
Capitalized costs to obtain a contract | $  609 | $  717
Deferred costs to fulfill a contract |  | 
Deferred setup costs | 1,939 | 2,085
Other deferred fulfillment costs | 1,820 | 2,173
Total deferred costs (1) | $4,368 | $4,975


Question: What is the total deferred costs amortized during 2019?
Answer: $3,836 million
Depreciation and Amortization
The following table sets forth depreciation and amortization by segment for the periods presented (in millions):
(1) Depreciation and amortization for Corporate and Other primarily represents net incremental depreciation and amortization adjustments associated with the application of purchase accounting recorded in accordance with GAAP.
The increase in Depreciation and Amortization is primarily driven by implementation of new clients, accelerated amortization of deferred contract costs and hardware and software placed in service.
Table:
 | Year ended December 31, |  | Variance | 
 | 2019 | 2018 | $ | %
Software Solutions | $123.9 | $112.9 | $11.0 | 10%
Data and Analytics | 15.9 | 14.1 | 1.8 | 13%
Corporate and Other(1) | 96.4 | 90.0 | 6.4 | 7%
Total | $236.2 | $217.0 | 19.2 | 9%


Question: What was the average total depreciation and amortization between 2018 and 2019?
Answer: 226.6
Calculation: (236.2+217.0)/2
9. Pensions continued
Defined benefit plans continued
ii) Amounts in the financial statements continued
e) Movements in the fair value of plans’ assets
Table:
 | 2019 | 2018
 | $ million | $ million
At 1 January | 254.2 | 282.6
Interest income on plans’ assets | 7.0 | 7.0
Employer contributions | 6.6 | 6.8
Benefit payments | (11.4) | (12.1)
Plan administration expenses | (0.6) | (0.5)
Re-measurement gain/(loss) on plans’ assets | 25.8 | (14.2)
Exchange adjustment | 9.5 | (15.4)
Fair value of plans’ assets | 291.1 | 254.2


Question: What is the fair value of plans' assets in 2019?
Answer: 291.1
Trading profit
The Group reported Trading profit of £128.5m in the year, growth of £5.5m, up +4.5% compared to 2017/18. Divisional contribution increased by £6.1m to £161.9m. The Grocery business recorded Divisional contribution growth of £8.3m to £138.3m while Sweet Treats Divisional contribution was £2.2m lower than the prior year at £23.6m. Group & corporate costs were £0.6m higher than the prior year.
In the first half of the year, Grocery Divisional contribution benefitted from previous changes in the promotional strategy of Ambrosia. The business reduced the depth of promotional deals it offered which resulted in lower volumes and revenue in the period but growth in Divisional contribution.
Additionally, Divisional contribution margins in the Grocery business grew 2.1 percentage points in the first half compared to the prior year. This is in line with margins two years ago, whereby margins in the prior year were impacted by a longer than expected process to recover input cost inflation seen across the Group’s categories.
Table:
£m | 2018/19 | 2017/18 | Change
Divisional contribution2 |  |  | 
Grocery | 138.3 | 130.0 | +6.3%
Sweet Treats | 23.6 | 25.8 | (8.4%)
Total | 161.9 | 155.8 | +3.9%
Group & corporate costs | (33.4) | (32.8) | (1.8%)
Trading profit | 128.5 | 123.0 | +4.5%


Question: What is the change in Divisional contribution of Sweet Treats from 2018/19 to 2017/18?
Answer: -2.2
Calculation: 23.6-25.8
Our revenues and operating results are significantly affected by the timing, number and breadth of our theatrical releases and their budgets, the timing of television syndication agreements, and our amortization policy for the first 12 months of commercial exploitation for a film. The timing of releases is determined based on several factors. A significant portion of the films we distribute are delivered to Indian theaters at times when theater attendance has traditionally been highest, including school holidays, national holidays and the festivals. This timing of releases also takes into account competitor film release dates, major cricket events in India and film production schedules. Significant holidays and festivals, such as Diwali, Eid and Christmas, occur during July to December each year, and the Indian Premier League cricket season generally occurs during April and May of each year. The Tamil New Year, called Pongal, falls in January each year making the quarter ending March an important one for Tamil releases.
Our quarterly results can vary from one period to the next, and the results of one quarter are not necessarily indicative of results for the next or any future quarter. Our revenue and operating results are therefore seasonal in nature due to the impact on income of the timing of new releases as well as timing and quantum of catalogue revenues.
Table:
 |  | Three Months Ended |  | 
 | June 30, 2018 | September 30, 2018 | December 31, 2018 | March 31, 2019
 |  | (in thousands) |  | 
Revenue | 60,212 | 63,425 | 76,744 | 69,745
Adjustment towards significant financing component | 6,410 | 8,837 | 9,917 | 9,303
Gross Revenue | 66,622 | 72,262 | 86,661 | 79,048


Question: What is taken into account while releasing films?
Answer: school holidays, national holidays, the festivals, competitor film release dates, major cricket events in India, film production schedules.
company stock performance the following graph shows a five-year comparison of cumulative total shareholder return , calculated on a dividend reinvested basis , for the company , the s&p 500 composite index , the s&p computer hardware index , and the dow jones u.s . technology index . the graph assumes $ 100 was invested in each of the company 2019s common stock , the s&p 500 composite index , the s&p computer hardware index , and the dow jones u.s . technology index as of the market close on september 30 , 2007 . data points on the graph are annual . note that historic stock price performance is not necessarily indicative of future stock price performance . sep-11sep-10sep-09sep-08sep-07 sep-12 apple inc . s&p 500 s&p computer hardware dow jones us technology comparison of 5 year cumulative total return* among apple inc. , the s&p 500 index , the s&p computer hardware index , and the dow jones us technology index *$ 100 invested on 9/30/07 in stock or index , including reinvestment of dividends . fiscal year ending september 30 . copyright a9 2012 s&p , a division of the mcgraw-hill companies inc . all rights reserved . september 30 , september 30 , september 30 , september 30 , september 30 , september 30 .

Table:
 | september 30 2007 | september 30 2008 | september 30 2009 | september 30 2010 | september 30 2011 | september 30 2012
apple inc . | $ 100 | $ 74 | $ 121 | $ 185 | $ 248 | $ 437
s&p 500 | $ 100 | $ 78 | $ 73 | $ 80 | $ 81 | $ 105
s&p computer hardware | $ 100 | $ 84 | $ 99 | $ 118 | $ 134 | $ 214
dow jones us technology | $ 100 | $ 76 | $ 85 | $ 95 | $ 98 | $ 127
.

Question: what was the cumulative total return on apple stock between september 30 2007 and september 30 2012?
Answer: 337
Calculation: subtract(437, const_100)
Liquidity and Capital Resources
As of December 31, 2019, we had total current assets of approximately $27.1 million, compared with current liabilities of approximately $6.1 million, resulting in working capital of approximately $21.0 million and a current ratio of approximately 4.4 to 1. This compares with the working capital balance of approximately $11.5 million and the current ratio of 3.7 to 1 at December 31, 2018. This increase in working capital, as discussed in more detail below, is primarily the result of the capital we raised in 2019.
Following is a table with summary data from the consolidated statement of cash flows for the years ended December 31, 2019 and 2018, as presented.
Our operating activities used approximately $1.7 million in the year ended December 31, 2019, as compared with approximately $0.8 million provided by operating activities in the year ended December 31, 2018. The cash provided in 2018 was the result of our net income and non-cash expenses, partially offset by the increased working capital required to support higher revenues. The cash used in operations in 2019 was the result of increased levels of working capital required to support higher revenue levels, expenditures related to growth, and costs associated with our acquisition in 2019.
We used approximately $5.7 million in investing activities in the year ended December 31, 2018, as compared with approximately $10.6 million used in investing activities in the year ended December 31, 2019. The majority of the investing activities in 2018 related to our acquisition of CareSpeak communications in October 2018. The majority of investing in activities in 2019 related to our acquisitions of RMDY Health, Inc. in 2019, as well as a software purchase in 2019.
Financing activities provided $8.7 million in the year ended December 31, 2018, as compared with $22.2 million in the year ended December 31, 2019. The cash provided in 2018 was primarily the result of the equity raised in connection with our uplisting to Nasdaq, as well as from the proceeds of option exercises. The cash used in 2019 was the result of our underwritten offering in 2019, as well as from the proceeds of option exercises.
With our cash on hand, we have sufficient cash to operate our business for more than the next 12 months and we do not anticipate the need to raise additional equity for operating purposes.
Table:
 | 2019 | 2018
Net cash provided by (used in) operating activities | $(1,660,796) | $792,555
Net cash used in investing activities | (10,582,086) | (5,686,833)
Net cash provided by financing activities | 22,181,528 | 8,685,739
Net increase in cash and cash equivalents | $9,938,646 | $3,791,461


Question: What is the ratio of net cash used in investing activities from 2018 to 2019?
Answer: 0.54
Calculation: -5,686,833/-10,582,086
Stock-Based Compensation Expense
Stock-based compensation expense is included in the consolidated statements of operations as follows (in millions):
As of April 26, 2019, total unrecognized compensation expense related to our equity awards was $285 million, which is expected to be recognized on a straight-line basis over a weighted-average remaining service period of 2.1 years.
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
Cost of product revenues | $ 4 | $ 3 | $ 4
Cost of hardware maintenance and other services revenues | 10 | 10 | 13
Sales and marketing | 67 | 68 | 84
Research and development | 48 | 49 | 59
General and administrative | 29 | 31 | 35
Total stock-based compensation expense | $ 158 | $ 161 | $ 195
Income tax benefit for stock-based compensation | $ 15 | $ 29 | $ 41


Question: What was the cost of product revenues in 2019?
Answer: 4
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
Other Redeemable Noncontrolling Interests—During the year ended December 31, 2019, the Company entered into an agreement with MTN to acquire MTN’s noncontrolling interests in each of the Company’s joint ventures in Ghana and Uganda for total consideration of approximately $523.0 million. The transaction is expected to close in the first quarter of 2020, subject to regulatory approval and other closing conditions. In addition, the Company, through a subsidiary of ATC Europe, entered into an agreement with its local partners in France to form Eure-et-Loir Réseaux Mobiles SAS (“Eure-et-Loir”), a telecommunications infrastructure company that owns and operates wireless communications towers in France. The Company’s controlling interest in Eure-et-Loir is 51% with local partners holding a 49% noncontrolling interest. The agreement provides the local partners with put options, which allow them to sell outstanding shares of Eure-et-Loir to the Company, and the Company with call options, which allow it to buy the noncontrolling shares of Eure-et-Loir. The put options, which are not under the Company’s control, cannot be separated from the noncontrolling interests. As a result, the combination of the noncontrolling interests and the redemption feature requires classification as redeemable noncontrolling interests in the consolidated balance sheet, separate from equity. The value of the Eure-et-Loir interests as of December 31, 2019 was $2.7 million.
The changes in Redeemable noncontrolling interests for the years ended December 31, 2019, 2018 and 2017 were as follows:
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Balance as of January 1, | $1,004.8 | $1,126.2 | $1,091.3
Additions to redeemable noncontrolling interests | 525.7 | — | —
Net income (loss) attributable to noncontrolling interests | 35.8 | (87.9) | (33.4)
Adjustment to noncontrolling interest redemption value | (35.8) | 86.7 | —
Adjustment to noncontrolling interest due to merger | — | (28.1) | —
Purchase of redeemable noncontrolling interest | (425.7) | — | —
Foreign currency translation adjustment attributable to noncontrolling interests | (8.3) | (92.1) | 68.3
Balance as of December 31, | $1,096.5 | $1,004.8 | $1,126.2


Question: What was the change in balance as of January 1 between 2017 and 2018?
Answer: 34.9
Calculation: $1,126.2-$1,091.3
Costs and Expenses
Cost of Revenues
The following tables detail the components of cost of revenues in dollars (amounts in millions) and as a percentage of associated net revenues:
Cost of Revenues—Product Sales:
The decrease in product costs for 2019, as compared to 2018, was due to the decrease in product sales, primarily associated with the Destiny franchise (reflecting our sale of the publishing rights for Destiny to Bungie in December 2018).
The decrease in software royalties, amortization, and intellectual property licenses related to product sales for 2019, as compared to 2018, was primarily due to a decrease of $133 million in software amortization and royalties from Activision, primarily due to the Destiny franchise. The decrease was partially offset by:
higher software amortization and royalties for 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; software amortization and royalties from Sekiro: Shadows Die Twice, which was released in March 2019; and higher software amortization and royalties for Call of Duty: Modern Warfare, which was released in October 2019, as compared to Call of Duty: Black Ops 4.
Cost of Revenues—Subscription, Licensing, and Other Revenues:
The decrease in game operations and distribution costs for 2019, as compared to 2018, was primarily due to a decrease of $50 million in service provider fees such as digital storefront fees (e.g., fees retained by Apple and Google for our sales on their platforms), payment processor fees, and server bandwidth fees.
The decrease in software royalties, amortization, and intellectual property licenses related to subscription, licensing, and other revenues for 2019, as compared to 2018, was primarily due to:
a decrease of $122 million in amortization of internally-developed franchise intangible assets acquired as part of our acquisition of King; a decrease of $36 million in software amortization and royalties from Activision, driven by the Destiny franchise, partially offset by software royalties on Call of Duty: Mobile, which was released in October 2019; and  lower amortization of capitalized film costs due to the release of the third season of the animated TV series, Skylanders™ Academy, in September 2018, with no comparable release in 2019.
Table:
 | Year Ended December 31, 2019 | % of associated net revenues | Year Ended December 31, 2018 | % of associated net revenues | Increase (Decrease)
Cost of revenues—product sales: |  |  |  |  | 
Product costs | $656 | 33% | $719 | 32% | $(63)
Software royalties, amortization, intellectual property licenses | 240 | 12 | 371 | 16 | (131)
Cost of revenues—subscription, licensing, and other revenues: |  |  |  |  | 
Game operations and distribution costs | 965 | 21 | 1,028 | 20 | (63)
Software royalties, amortization, intellectual property licenses | 233 | 5 | 399 | 8 | (166)
Total cost of revenues | $2,094 | 32% | $2,517 | 34% | $(423)


Question: What were the product costs in 2019?
Answer: 656
Financial Highlights
International Business Machines Corporation and Subsidiary Companies
* Includes charges of $0.1 billion in 2019 and $2.0 billion in 2018 associated with U.S. tax reform.
** See page 46 for a reconciliation of net income to operating earnings.
Table:
($ in millions except per share amounts) |  | 
For the year ended December 31: | 2019 | 2018
Revenue | $ 77,147 | $ 79,591
Net Income | 9,431* | 8,728*
Income from continuing operations | 9,435* | 8,723*
Operating (non-GAAP) earnings** | $ 11,436 | $ 12,657
Earnings per share of common stock—continuing operations |  | 
Assuming dilution | 10.57* | 9.51*
Basic | 10.63 | 9.56*
Diluted operating (non-GAAP)** | $  12.81 | $  13.81
Net cash provided by operating activities | $ 14,770 | $ 15,247
Capital expenditures, net | $  2,370 | $  3,716
Share repurchases | $  1,361 | $  4,443
Cash dividends paid on common stock | $  5,707 | $  5,666
Per share of common stock | $   6.43 | $   6.21
At December 31: | 2019 | 2018
Cash, cash equivalents, restricted cash and marketable securities | $  9,009 | $ 12,222
Total assets | $152,186 | $123,382
Working capital | $    718 | $ 10,918
Total debt | $ 62,899 | $ 45,812
Total equity | $ 20,985 | $ 16,929
Common shares outstanding (in millions) | 887 | 892
Stock price per common share | $ 134.04 | $ 113.67


Question: What is the Basic earnings per share in 2019?
Answer: 10.63