hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Financial position and cash flow
Capital expenditure and cash flow
Net operating cash inflow was $4,709,000, which was $4,081,000 lower than last year. The reduction in operating revenue was offset by lower operational costs. However, net cash was impacted by the increase in trail to upfront revenue mix. In addition, as a result of the loss position reported for FY18, the Group received a net tax refund of $2,327,000 during the year, compared to the prior year net tax paid of $172,000.
Net investing cash outflows for the year was $12,337,000. The $7,755,000 decrease in spend in investing activities relates to the Group’s controlling interest acquisition of iMoney in December 2017.
Net financing cash outflows for the 2019 year totalled $3,471,000. This included $2,839,000 lease payments and $497,000 interest expense related to leases. The material decrease against the prior year comparative period relates to $32,918,000 paid in share buy-backs and dividends in the prior period.
Table:
CASH FLOW SUMMARY | 2019 $’000 | 2018 $’000 RESTATED | CHANGE
Net cash provided  from operating  activities | 4,709 | 8,790 | 46%
Net cash used in  investing activities | (12,337) | (20,092) | (39%)
Net cash used in financing activities | (3,471) | (36,014) | (90%)
Net change in cash and cash equivalent | (11,099) | (47,316) | (77%)


Question: What is the percentage change in the net cash provided from investing activities?
Answer: (39%)
Operating Income
Our operating income in fiscal year 2019 increased to $241.4 million, or 10.1 percent of net sales as compared with $189.3 million, or 8.8 percent of net sales in fiscal year 2018. Excluding surcharge revenue and special items, adjusted operating margin was 12.5 percent for the fiscal year 2019 and 10.6 percent for the same period a year ago. The increase in the operating margin reflects steady demand and improved product mix coupled with operating cost improvements offset by higher selling, general and administrative expenses compared to the same period a year ago.
The following presents our operating income and operating margin, in each case excluding the impact of surcharge on net sales and special items. We present and discuss these financial measures because management believes removing the impact of these items provides a more consistent and meaningful basis for comparing results of operations from period to period. See the section “Non-GAAP Financial Measures” below for further discussion of these financial measures.
Table:
 | Fiscal Year | 
($ in millions) | 2019 | 2018
Net sales | $2,380.2 | $2,157.7
Less: surcharge revenue | 438.1 | 365.4
Net sales excluding surcharge revenue | $1,942.1 | $1,792.3
Operating income | $241.4 | $189.3
Special items: |  | 
Acquisition-related costs | 1.2 | —
Adjusted operating income excluding special items | $242.6 | $189.3
Operating margin | 10.1% | 8.8%
Adjusted operating margin excluding surcharge revenue and special items | 12.5% | 10.6%


Question: What was the amount of operating income as percentage of net sales in 2018?
Answer: 8.8 percent
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
The Company expects the unrecognized tax benefits to change over the next 12 months if certain tax matters ultimately settle with the applicable taxing jurisdiction during this timeframe, or if the applicable statute of limitations lapses. The impact of the amount of such changes to previously recorded uncertain tax positions could range from zero to $53.0 million.
A reconciliation of the beginning and ending amount of unrecognized tax benefits are as follows:
During the years ended December 31, 2019, 2018 and 2017, the statute of limitations on certain unrecognized tax benefits lapsed and certain positions were effectively settled, which resulted in a decrease of $2.5 million, $9.3 million and $0.4 million, respectively, in the liability for uncertain tax benefits.
The Company recorded penalties and tax-related interest expense to the tax provision of $10.3 million, $8.0 million and $5.0 million for the years ended December 31, 2019, 2018 and 2017, respectively. In addition, due to the expiration of the statute of limitations in certain jurisdictions and certain positions that were effectively settled, the Company reduced its liability for penalties and income tax-related interest expense related to uncertain tax positions during the years ended December 31, 2019, 2018 and 2017 by $2.7 million, $16.2 million and $0.6 million, respectively.
As of December 31, 2019 and 2018, the total amount of accrued income tax-related interest and penalties included in the consolidated balance sheets were $26.6 million and $19.1 million, respectively.
The Company has filed for prior taxable years, and for its taxable year ended December 31, 2019 will file, numerous consolidated and separate income tax returns, including U.S. federal and state tax returns and foreign tax returns. The Company is subject to examination in the U.S. and various state and foreign jurisdictions for certain tax years. As a result of the Company’s ability to carryforward federal, state and foreign NOLs, the applicable tax years generally remain open to examination several years after the applicable loss carryforwards have been used or have expired. The Company regularly assesses the likelihood of additional assessments in each of the tax jurisdictions resulting from these examinations. The Company believes that adequate provisions have been made for income taxes for all periods through December 31, 2019.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Balance at January 1 | $107.7 | $116.7 | $107.6
Additions based on tax positions related to the current year | 33.3 | 8.1 | 7.6
Additions and reductions for tax positions of prior years | 37.5 | 0.3 | —
Foreign currency | (1.6) | (8.1) | 1.9
Reduction as a result of the lapse of statute of limitations | (1.3) | (2.6) | (0.4)
Reduction as a result of effective settlements | — | (6.7) | —
Balance at December 31 | $175.6 | $107.7 | $116.7


Question: Which years was the Additions based on tax positions related to the current year above $10 million?
Answer: 1
Calculation: 2019
Consolidated Results
Net Revenues by Distribution Channel
The following table details our consolidated net revenues by distribution channel (amounts in millions):
(1) Net revenues from “Digital online channels” include revenues from digitally-distributed subscriptions, downloadable content, microtransactions, and products, as well as licensing royalties.
(2) Net revenues from “Other” primarily includes revenues from our Distribution business and the Overwatch League.
Digital Online Channel Net Revenues The decrease in net revenues from digital online channels 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); and • lower revenues recognized from Hearthstone.
Retail Channel Net Revenues The decrease in net revenues from retail channels for 2019, as compared to 2018, was primarily due to: • 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; • lower revenues recognized from the Destiny franchise; and • lower revenues from Crash Bandicoot™ N. Sane Trilogy, which was released on the Xbox One, PC, and Nintendo Switch in June 2018.
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:
 |  | For the Years Ended December 31, |  | 
 | 2019 | 2018 | Increase/ (decrease) | % Change
Net revenues by distribution channel: |  |  |  | 
Digital online channels (1) | $4,932 | $5,786 | $(854) | (15)%
Retail channels | 909 | 1,107 | (198) | (18)
Other (2) | 648 | 607 | 41 | 7
Total consolidated net revenues | $6,489 | $7,500 | $(1,011) | (13)


Question: What percentage of total consolidated net revenue consists of Other in 2019?
Answer: 9.99
Calculation: (648/$6,489)
Free Cash Flow
Free cash flow is a non-GAAP financial measure that reflects an additional way of viewing our liquidity that, when viewed with our GAAP results, provides a more complete understanding of factors and trends affecting our cash flows. Free cash flow is calculated by subtracting capital expenditures from net cash provided by operating activities. We believe it is a more conservative measure of cash flow since purchases of fixed assets are necessary for ongoing operations.
Free cash flow has limitations due to the fact that it does not represent the residual cash flow available for discretionary expenditures. For example, free cash flow does not incorporate payments made on finance lease obligations or cash payments for business acquisitions or wireless licenses. Therefore, we believe it is important to view free cash flow as a complement to our entire consolidated statements of cash flows.
The following table reconciles net cash provided by operating activities to Free cash flow:
The increase in free cash flow during 2019 is a reflection of the increase in operating cash flows, partially offset by the increase in capital expenditures discussed above.
Table:
 |  | (dollars in millions)
Years Ended December 31, | 2019 | 2018
Net cash provided by operating activities | $ 35,746 | $ 34,339
Less Capital expenditures (including capitalized software) | 17,939 | 16,658
Free cash flow | $ 17,807 | $ 17,681


Question: What was the average free cash flow for 2018 and 2019?
Answer: 17744
Calculation: (17,807 + 17,681) / 2
table of contents e*trade | 2016 10-k 24 2022 limits on the persons who may call special meetings of stockholders 2022 the prohibition of stockholder action by written consent 2022 advance notice requirements for nominations to the board or for proposing matters that can be acted on by stockholders at stockholder meetings in addition , certain provisions of our stock incentive plans , management retention and employment agreements ( including severance payments and stock option acceleration ) , our senior secured credit facility , certain provisions of delaware law and certain provisions of the indentures governing certain series of our debt securities that would require us to offer to purchase such securities at a premium in the event of certain changes in our ownership may also discourage , delay or prevent someone from acquiring or merging with us , which could limit the opportunity for our stockholders to receive a premium for their shares of our common stock and could also affect the price that some investors are willing to pay for our common stock . item 1b . unresolved staff comments item 2 . properties a summary of our significant locations at december 31 , 2016 is shown in the following table . square footage amounts are net of space that has been sublet or space that is part of a facility restructuring. .

Table:
location | approximate square footage
alpharetta georgia | 260000
jersey city new jersey | 109000
arlington virginia | 102000
sandy utah | 85000
menlo park california | 63000
new york new york | 52000
chicago illinois | 37000
all facilities are leased at december 31 , 2016 .
all other leased facilities with space of less than 25000 square feet are not listed by location .
in addition to the significant facilities above , we also lease all 30 regional branches , ranging in space from approximately 2500 to 8000 square feet .
item 3 .
legal proceedings information in response to this item can be found under the heading legal matters in note 21 2014 commitments , contingencies and other regulatory matters in this annual report and is incorporated by reference into this item .
item 4 .
mine safety disclosures not applicable. .

Question: at december 312016 what was the ratio of the square footage of alpharetta georgia to jersey city new jersey
Answer: 2.39
Calculation: divide(260000, 109000)
Gross Profit. Gross profit increased 15%, or $144.4 million, in 2019 compared to 2018, with gross margin increasing approximately 70 basis points to 14.7% of net sales. Our gross profit and gross profit as a percent of net sales by operating segment for 2019 and 2018 were as follows (dollars in thousands):
North America’s gross profit in 2019 increased 19% compared to 2018, and as a percentage of net sales, gross margin increased by approximately 80 basis points year over year. The year over year net increase in gross margin was primarily attributable to the following:
• A net increase in product margin, which includes partner funding and freight, of 30 basis points year over year. This increase was due primarily to improvements in hardware and software product margin partially as a result of improvements in core business margins on product net sales and also as a result of PCM.
• Services margin improvement year over year of 50 basis points was generated from increased vendor funding, cloud solution offerings and referral fees. In addition, there was a 21 basis point improvement in margins from Insight delivered services.
EMEA’s gross profit in 2019 increased 3% (increased 8% excluding the effects of fluctuating foreign currency exchange rates), compared to 2018. As a percentage of net sales, gross margin increased by approximately 40 basis points year over year.
APAC’s gross profit in 2019 increased 1% (increased 6% excluding the effects of fluctuating foreign currency exchange rates), compared to 2018, with gross margin increasing to 22.1% in 2019 from 21.2% in 2018. The improvement in gross margin for both EMEA and APAC in 2019 compared to 2018 was due primarily to changes in sales mix to higher margin products and services.
Table:
 | 2019 | % of Net
Sales | 2018 | % of Net Sales
NorthAmerica | $ 871,114 | 14.5% | $732,695 | 13.7%
EMEA | $227,083 | 14.9% | $221,467 | 14.5%
APAC | $39,901 | 22.1% | $39,556 | 21.2%
Consolidated | $1,138,098 | 14.7% | $993,718 | 14.0%


Question: What is the change in Net sales of EMEA between 2018 and 2019?
Answer: 5616
Calculation: 227,083-221,467
Revision of Prior Period Financial Statements
During the preparation of the financial statements for the three months ended September 30, 2019, the Company identified a misstatement in previously issued financial statements. The misstatement related to an error in the measurement of the cumulative effect of the accounting change related to the Company’s January 1, 2018 adoption of Accounting Standards Update No. 2014-09, “Revenue from Contracts with Customers (Topic 606)” (“ASU 2014-09” or “Topic 606”) and impacted the January 1, 2018 opening accumulated deficit balance and the related opening balances of deferred commissions assets and accrued expenses. The Company determined that the error was not material to any previously issued financial statements. The Company has revised the December 31, 2018 consolidated balance sheet and the statements of changes in stockholders’ equity for all periods after January 1, 2018 to correct the misstatement as follows (in thousands):
Table:
 |  | December 31, 2018 | 
 | As Previously Reported | Adjustment | As Revised
Deferred commissions, current portion | $24,467 | $1,064 | $25,531
Total current assets | 573,035 | 1,064 | 574,099
Deferred commissions, net of current portion | 45,444 | 10,006 | 55,450
Total assets | 807,156 | 11,070 | 818,226
Accrued expenses | 68,331 | 1,734 | 70,065
Total current liabilities | 400,423 | 1,734 | 402,157
Accumulated deficit | (529,962) | 9,336 | (520,626)
Total stockholders’ equity | 55,907 | 9,336 | 65,243
Total liabilities and stockholders’ equity | 807,156 | 11,070 | 818,226


Question: What was the total current assets as previously reported?
Answer: 573,035
Note 8 – Property, Plant and Equipment
As of December 31, 2019 and 2018, property, plant and equipment was comprised of the following:
Depreciation expense was $12.5 million, $12.7 million and $12.8 million for the years ended December 31, 2019, 2018 and 2017, respectively, which is recorded in cost of sales, selling, general and administrative expense and research and development expense in the consolidated statements of income.
We assess long-lived assets used in operations for potential impairment whenever events or changes in circumstances indicate that the carrying amount of an asset may not be recoverable and the undiscounted cash flows estimated to be generated by the asset are less than the asset’s carrying value. During the year ended December 31, 2019, the Company recognized impairment charges of $3.9 million related to the abandonment of certain information technology projects in which we had previously capitalized expenses related to these projects. The impairment charges were determined based on actual costs incurred as part of the projects. No impairment charges were recognized during the years ended December 31, 2018 and 2017.
Table:
(In thousands) | 2019 | 2018
Land | $4,575 | $4,575
Building and land improvements | 34,797 | 34,379
Building | 68,157 | 68,183
Furniture and fixtures | 19,959 | 19,831
Computer hardware and software | 74,399 | 92,071
Engineering and other equipment | 130,430 | 127,060
Total Property, Plant and Equipment | 332,317 | 346,099
Less accumulated depreciation | (258,609) | (265,464)
Total Property, Plant and Equipment, net | $73,708 | $80,635


Question: What was the  Total Property, Plant and Equipment, net in 2019?
Answer: $73,708
performance graph the following graph shows a five-year comparison of the cumulative total return on our common stock , the nasdaq composite index , the s&p 500 index and the s&p 500 information technology index from april 24 , 2009 through april 25 , 2014 . the past performance of our common stock is not indicative of the future performance of our common stock . comparison of 5 year cumulative total return* among netapp , inc. , the nasdaq composite index , the s&p 500 index and the s&p 500 information technology index .

Table:
 | 4/09 | 4/10 | 4/11 | 4/12 | 4/13 | 4/14
netapp inc . | $ 100.00 | $ 189.45 | $ 284.75 | $ 212.19 | $ 190.66 | $ 197.58
nasdaq composite | 100.00 | 144.63 | 170.44 | 182.57 | 202.25 | 253.22
s&p 500 | 100.00 | 138.84 | 162.75 | 170.49 | 199.29 | 240.02
s&p 500 information technology | 100.00 | 143.49 | 162.37 | 186.06 | 189.18 | 236.12
we believe that a number of factors may cause the market price of our common stock to fluctuate significantly .
see 201citem 1a .
risk factors . 201d sale of unregistered securities .

Question: what was the difference in percentage cumulative total return for the five year period ending 4/14 between netapp inc . and the s&p 500 information technology index?
Answer: -38.54%
Calculation: subtract(197.58, const_100), divide(#0, const_100), subtract(236.12, const_100), divide(#2, const_100), subtract(#0, #2)
During the fourth and third quarters of 2019 and the fourth quarter of 2018, we recorded an income tax expense of $62 million, $28 million and $28 million, respectively, reflecting (i) in the third quarter of 2019 the estimated annual effective tax rate in each of our jurisdictions, applied to the consolidated results before taxes in the third quarter of 2019 and (ii) in both fourth quarters the actual tax charges and benefits in each jurisdiction as well as the true-up of tax provisions based upon the most updated visibility on open tax matters in several jurisdictions. and (ii) in both fourth quarters the actual tax charges and benefits in each jurisdiction as well as the true-up of tax provisions based upon the most updated visibility on open tax matters in several jurisdictions. and (ii) in both fourth quarters the actual tax charges and benefits in each jurisdiction as well as the true-up of tax provisions based upon the most updated visibility on open tax matters in several jurisdictions.
Income tax expense
Table:
 |  | Three Months Ended | 
 | December 31, 2019 | September 29, 2019 | December 31, 2018
 |  | (Unaudited, in millions) | 
Income tax expense | $(62) | $(28) | $(28)


Question: How much was the income tax expense in the fourth quarter of 2019?
Answer: $62 million
entergy gulf states louisiana , l.l.c . management 2019s financial discussion and analysis plan to spin off the utility 2019s transmission business see the 201cplan to spin off the utility 2019s transmission business 201d section of entergy corporation and subsidiaries management 2019s financial discussion and analysis for a discussion of this matter , including the planned retirement of debt and preferred securities . results of operations net income 2011 compared to 2010 net income increased $ 12.3 million primarily due to lower interest expense and lower other operation and maintenance expenses , offset by higher depreciation and amortization expenses and a higher effective income tax 2010 compared to 2009 net income increased $ 37.7 million primarily due to higher net revenue , a lower effective income tax rate , and lower interest expense , offset by higher other operation and maintenance expenses , lower other income , and higher taxes other than income taxes . net revenue 2011 compared to 2010 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory credits . following is an analysis of the change in net revenue comparing 2011 to 2010 . amount ( in millions ) .

Table:
 | amount ( in millions )
2010 net revenue | $ 933.6
retail electric price | -20.1 ( 20.1 )
volume/weather | -5.2 ( 5.2 )
fuel recovery | 14.8
transmission revenue | 12.4
other | -2.1 ( 2.1 )
2011 net revenue | $ 933.4
the retail electric price variance is primarily due to an increase in credits passed on to customers as a result of the act 55 storm cost financing .
see 201cmanagement 2019s financial discussion and analysis 2013 hurricane gustav and hurricane ike 201d and note 2 to the financial statements for a discussion of the act 55 storm cost financing .
the volume/weather variance is primarily due to less favorable weather on the residential sector as well as the unbilled sales period .
the decrease was partially offset by an increase of 62 gwh , or 0.3% ( 0.3 % ) , in billed electricity usage , primarily due to increased consumption by an industrial customer as a result of the customer 2019s cogeneration outage and the addition of a new production unit by the industrial customer .
the fuel recovery variance resulted primarily from an adjustment to deferred fuel costs in 2010 .
see note 2 to the financial statements for a discussion of fuel recovery. .

Question: what as the percent of the net revenue from transmission in 2011
Answer: 1.3%
Calculation: divide(12.4, 933.4)