hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
14. Income Taxes
The provision for income taxes consists of the following (in millions):
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
Current: |  |  | 
Federal | $ 26 | $ 764 | $ 22
State | 27 | 10 | 3
Foreign | 49 | 39 | 41
Total current | 102 | 813 | 66
Deferred: |  |  | 
Federal | 35 | 239 | 61
State | (6 ) | 27 | 17
Foreign | (32 ) | 4 | (4 )
Total deferred | (3 ) | 270 | 74
Provision for income taxes | $ 99 | $ 1,083 | $ 140


Question: How many years did current foreign provision for income tax exceed $40 million?
Answer: 2
Calculation: 2019##2017
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
20. SUPPLEMENTAL CASH FLOW INFORMATION
Supplemental cash flow information and non-cash investing and financing activities are as follows for the years ended December 31,:
(1) Related to the note extinguishment with TV Azteca, S.A. de C.V. in 2018.
Table:
 | 2019 | 2018 | 2017
Supplemental cash flow information: |  |  | 
Cash paid for interest | $750.2 | $789.7 | $712.1
Cash paid for income taxes (net of refunds of $11.2, $25.0 and $20.7, respectively) | 147.5 | 163.9 | 136.5
Non-cash investing and financing activities: |  |  | 
(Decrease) increase in accounts payable and accrued expenses for purchases of property and equipment and construction activities | (21.0) | 8.3 | 34.0
Purchases of property and equipment under finance leases, perpetual easements and capital leases | 81.3 | 57.8 | 54.8
Fair value of debt assumed through acquisitions | 329.8 | — | —
Acquisition of Commercialization Rights (1) | — | 24.8 | —
Conversion of third-party debt to equity | — | — | 48.2
Debt financed acquisition of communication sites | — | 54.2 | —


Question: What was the Acquisition of Commercialization Rights related to?
Answer: Related to the note extinguishment with TV Azteca, S.A. de C.V. in 2018.
3. Accrued and other liabilities:
Accrued and other current liabilities consist of the following (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Operating accruals | $23,695 | $24,020
Deferred revenue—current portion | 4,316 | 4,504
Payroll and benefits | 6,613 | 7,695
Taxes—non-income based | 6,053 | 4,212
Interest | 10,624 | 11,000
Total | $51,301 | $51,431


Question: What is the total operating accruals in 2018 and 2019?
Answer: 47715
Calculation: ($24,020 + $23,695)
Property, Plant and Equipment
Property, plant and equipment consists of the following (in millions):
Depreciation expense attributed to property, plant and equipment was $180.6 million, $123.7 million and $122.9 million for the fiscal years ending March 31, 2019, 2018 and 2017, respectively.
Table:
 | March 31, | 
 | 2019 | 2018
Land | $83.4 | $73.4
Building and building improvements | 647.6 | 508.5
Machinery and equipment | 2,095.5 | 1,943.9
Projects in process | 119.2 | 118.3
Total property, plant and equipment, gross | 2,945.7 | 2,644.1
Less accumulated depreciation and amortization | 1,949.0 | 1,876.2
Total property, plant and equipment, net | $996.7 | $767.9


Question: Which years does the table provide information for Property, plant and equipment?
Answer: 2019, 2018
S. Selected Quarterly Financial Data (unaudited)
Quarterly financial data for fiscal 2020 and 2019 were as follows (tables in millions, except per share amounts):
(1) Adjusted to reflect the recast of prior period information due to the Pivotal acquisition, which was accounted for as a transaction between entities under common control (refer to Note B).
Table:
Fiscal 2020 | Q1 2020 (1) | Q2 2020 (1) | Q3 2020 (1) | Q4 2020
Total revenue | $2,450 | $2,632 | $2,656 | $3,073
Net income attributable to VMware, Inc. | 380 | 5,303 | 407 | 321
common stockholders, basic for Classes A and B Net income per weighted-average share attributable to VMware, Inc. common stockholders, basic for Classes A and B | $0.91 | $12.72 | $0.98 | $0.77
Net income per weighted-average share attributable to VMware, Inc. common stockholders, diluted for Classes A and B | $0.89 | $12.47 | $0.96 | $0.76


Question: What was the change in Net income per weighted-average share attributable to VMware, Inc. common stockholders, diluted for Classes A and B between Q2 and Q3 2020?
Answer: -11.74
Calculation: 0.98-12.72
History and Development of the Company
Our legal and commercial name is United Microelectronics Corporation, commonly known as “UMC”. We were incorporated under the R.O.C. Company Law as a company limited by shares in May 1980 and our common shares were listed on the Taiwan Stock Exchange in 1985. Our principal executive office is located at No. 3 Li-Hsin Road II, Hsinchu Science Park, Hsinchu, Taiwan, Republic of China, and our telephone number is 886-3-578-2258.
Our Internet website address is www.umc.com. The information on our website does not form part of this annual report. Our ADSs have been listed on the NYSE under the symbol “UMC” since September 19, 2000. In 2019, we were ranked among the top 5% of companies for a fifth consecutive year in the Corporate Governance Evaluation conducted by the Taiwan Stock Exchange and Taipei Exchange. The assessment was conducted across over 1,400 public companies in Taiwan.
We are one of the world’s largest independent semiconductor foundries and a leader in semiconductor manufacturing process technologies. Our primary business is the manufacture, or “fabrication”, of semiconductors, sometimes called “chips” or “integrated circuits”, for others. Using our own proprietary processes and techniques, we make chips to the design specifications of our many customers. Our company maintains a diversified customer base across industries, including communication devices, consumer electronics, computer, and others, while continuing to focus on manufacturing for high growth, large volume applications, including networking, telecommunications, internet, multimedia, PCs and graphics.
We sell and market mainly wafers which in turn are used in a number of different applications by our customers. The following table presented the percentages of our wafer sales by application for the years ended December 31, 2017, 2018 and 2019.
Table:
 |  | Years Ended December 31, | 
Application | 2017 | 2018 | 2019
 | % | % | %
Communication | 48.6 | 45.2 | 52.2
Consumer | 29.4 | 28.6 | 26.4
Computer | 13.1 | 16.3 | 13.6
Others | 8.9 | 9.9 | 7.8
Total | 100.0 | 100.0 | 100.0


Question: What is the average of consumer in the 3 years?
Answer: 28.13
Calculation: ((29.4% + 28.6% + 26.4%) / 3) * 100
united parcel service , inc . and subsidiaries notes to consolidated financial statements 8.375% ( 8.375 % ) debentures the 8.375% ( 8.375 % ) debentures consist of two separate tranches , as follows : 2022 $ 276 million of the debentures have a maturity of april 1 , 2030 . these debentures have an 8.375% ( 8.375 % ) interest rate until april 1 , 2020 , and , thereafter , the interest rate will be 7.62% ( 7.62 % ) for the final 10 years . these debentures are redeemable in whole or in part at our option at any time . the redemption price is equal to the greater of 100% ( 100 % ) of the principal amount and accrued interest , or the sum of the present values of the remaining scheduled payout of principal and interest thereon discounted to the date of redemption ( at a benchmark treasury yield plus five basis points ) plus accrued interest . 2022 $ 424 million of the debentures have a maturity of april 1 , 2020 . these debentures are not subject to redemption prior to maturity . interest is payable semiannually in april and october for both tranches and neither tranche is subject to sinking fund requirements . we subsequently entered into interest rate swaps on the 2020 debentures , which effectively converted the fixed interest rates on the debentures to variable libor-based interest rates . the average interest rate payable on the 2020 debentures , including the impact of the interest rate swaps , for 2016 and 2015 was 5.43% ( 5.43 % ) and 5.04% ( 5.04 % ) , respectively . floating rate senior notes the floating rate senior notes bear interest at either one or three-month libor , less a spread ranging from 30 to 45 basis points . the average interest rate for 2016 and 2015 was 0.21% ( 0.21 % ) and 0.01% ( 0.01 % ) , respectively . these notes are callable at various times after 30 years at a stated percentage of par value , and putable by the note holders at various times after 10 years at a stated percentage of par value . the notes have maturities ranging from 2049 through 2066 . in march , june and august 2016 , we issued floating rate senior notes in principal balances of $ 118 , $ 74 and $ 35 million , respectively . these notes bear interest at three-month libor less 30 basis points and mature in 2066 . capital lease obligations we have certain property , plant and equipment subject to capital leases . some of the obligations associated with these capital leases have been legally defeased . the recorded value of our property , plant and equipment subject to capital leases is as follows as of december 31 ( in millions ) : .

Table:
 | 2016 | 2015
vehicles | $ 68 | $ 74
aircraft | 2291 | 2289
buildings | 190 | 207
accumulated amortization | -896 ( 896 ) | -849 ( 849 )
property plant and equipment subject to capital leases | $ 1653 | $ 1721
these capital lease obligations have principal payments due at various dates from 2017 through 3005. .

Question: what was the change in millions of vehicles from 2015 to 2016?
Answer: -6
Calculation: subtract(68, 74)
The following is a breakdown of revenue by shipment destination (in thousands):
(1) Asia Pacific includes revenue from China $1.1 million or 11% and Japan of $1.8 million or 17% of total revenue in 2019 and $1.8 million or 15% and $1.6 million or 12% of total revenue in 2018, respectively. In 2017, revenue from China and Japan were $1.3 million or 11% and $1.5 million or 12%, respectively.
(2) North America includes revenue from the United States of $4.7 million or 46% of total revenue in 2019, $6.4 million or 50% of total revenue in 2018 and $4.2 million or 34% of total revenue in 2017.
Table:
 |  |  | Fiscal Years
 | 2019 | 2018 | 2017
Revenue by geography: |  |  | 
Asia Pacific (1) | $3,049 | $4,905 | $5,810
Europe | 2,459 | 1,280 | 2,015
North America (2) | 4,802 | 6,444 | 4,324
Total revenue | $10,310 | $12,629 | $12,149


Question: What is the respective revenue from North America in 2018 and 2019?
Answer: 6,444, 4,802
Annual Dividends Paid and Proposed
The following table sets forth in euro the annual dividends paid or proposed to be paid per ordinary share in respect of each of the years indicated. One SAP ADR currently represents one SAP SE ordinary share. Accordingly, the final dividend per ADR is equal to the dividend for one SAP SE ordinary share and is dependent on the euro/U.S. dollar exchange rate. The table does not reflect tax credits that may be available to German taxpayers who receive dividend payments. If you own our ordinary shares or ADRs and if you are a U.S. resident, refer to “Item 10. Additional Information — Taxation,” for further information.
(1) Translated for the convenience of the reader from euro into U.S. dollars at the Noon Buying Rate for converting euro into U.S. dollars on the dividend payment date. The Depositary is required to convert any dividend payments received from SAP as promptly as practicable upon receipt.
(2) Subject to approval at the Annual General Meeting of Shareholders of SAP SE currently scheduled to be held on May 15, 2020.
(3) Translated for the convenience of the reader from euro into U.S. dollars at the Noon Buying Rate for converting euro into U.S. dollars on February 7, 2020 of US$1.0950 per €1.00. The dividend paid may differ due to changes in the exchange rate.
The amount of dividends paid on the ordinary shares depends on the amount of profits to be distributed by SAP SE, which depends in part upon our financial performance. In addition, the amount of dividends received by holders of ADRs may be affected by fluctuations in exchange rates (see “Item 3. Key Information — Exchange Rates”). The timing, declaration, amount and payment of any future dividend will depend upon our future earnings, capital needs and other relevant factors, in each case as proposed by the Executive Board and the Supervisory Board of SAP SE and approved by the Annual General Meeting of Shareholders.
In light of SAP’s strong financial performance and healthy balance sheet, the Supervisory Board of SAP SE approved, on November 4, 2019, the Executive Board’s plan for enhanced capital return in 2020. Under this new program, the Company intends to repurchase shares and/or issue a special dividend with a combined volume of €1.5 billion by December 31, 2020.
Table:
 | Dividend Paid per Ordinary Share | 
Year Ended December 31, | € | US$
2015 | 1.15 | 1.30 (1)
2016 | 1.25 | 1.37 (1)
2017 | 1.40 | 1.65 (1)
2018 | 1.50 | 1.68 (1)
2019 (proposed) | 1.58 (2) | 1.73 (2), (3)


Question: What was the change in Dividend Paid per Ordinary Share in € in 2016 from 2015?
Answer: 0.1
Calculation: 1.25-1.15
vertex pharmaceuticals incorporated notes to consolidated financial statements ( continued ) f . marketable securities ( continued ) unrealized losses in the portfolio relate to various debt securities including u.s . government securities , u.s . government-sponsored enterprise securities , corporate debt securities and asset-backed securities . for these securities , the unrealized losses are primarily due to increases in interest rates . the investments held by the company are high investment grade and there were no adverse credit events . because the company has the ability and intent to hold these investments until a recovery of fair value , which may be maturity , the company does not consider these investments to be other-than-temporarily impaired as of december 31 , 2006 and 2005 . gross realized gains and losses for 2006 were $ 4000 and $ 88000 respectively . gross realized gains and losses for 2005 were $ 15000 and $ 75000 , respectively . gross realized gains and losses for 2004 were $ 628000 and $ 205000 , respectively . g . restricted cash at december 31 , 2006 and 2005 , the company held $ 30.3 million and $ 41.5 million respectively , in restricted cash . at december 31 , 2006 and 2005 the balance was held in deposit with certain banks predominantly to collateralize conditional stand-by letters of credit in the names of the company 2019s landlords pursuant to certain operating lease agreements . h . property and equipment property and equipment consist of the following at december 31 ( in thousands ) : depreciation and amortization expense for the years ended december 31 , 2006 , 2005 and 2004 was $ 25.4 million , $ 26.3 million and $ 28.4 million , respectively . in 2006 and 2005 , the company wrote off certain assets that were fully depreciated and no longer utilized . there was no effect on the company 2019s net property and equipment . additionally , the company wrote off or sold certain assets that were not fully depreciated . the net loss on disposal of those assets was $ 10000 for 2006 , $ 344000 for 2005 and $ 43000 for 2004 . i . altus investment altus pharmaceuticals , inc . ( 201caltus 201d ) completed an initial public offering in january 2006 . as of the completion of the offering , vertex owned 817749 shares of common stock and warrants to purchase 1962494 shares of common stock ( the 201caltus warrants 201d ) . in addition , the company , as of the completion .

Table:
 | 2006 | 2005
furniture and equipment | $ 97638 | $ 98387
leasehold improvements | 74875 | 66318
computers | 19733 | 18971
software | 21274 | 18683
total property and equipment gross | 213520 | 202359
less accumulated depreciation and amortization | 151985 | 147826
total property and equipment net | $ 61535 | $ 54533
furniture and equipment $ 97638 $ 98387 leasehold improvements 74875 66318 computers 19733 18971 software 21274 18683 total property and equipment , gross 213520 202359 less accumulated depreciation and amortization 151985 147826 total property and equipment , net $ 61535 $ 54533 .

Question: what percent of the gross total property and equipment values in 2006 are related to computers?
Answer: 32%
Calculation: divide(19733, 61535)
Accrued Liabilities
Accrued liabilities consists of the following (in millions):
Sales related reserves represent price concessions and stock rotation rights that the Company offers to many of its distributors. For the fiscal year ending March 31, 2018, these sales related reserves were recorded within accounts receivable, and therefore did not exist within accrued liabilities. The Company made this change in classification as part of its adoption of ASC 606. For additional information regarding the Company's adoption of ASC 606, refer to Note 1 of the consolidated financial statements.
Table:
 | March 31, | 
 | 2019 | 2018
Accrued compensation and benefits | $133.2 | $87.6
Income taxes payable | 46.9 | 27.5
Sales related reserves | 366.9 | —
Accrued expenses and other liabilities | 240.3 | 114.5
Total accrued liabilities | $787.3 | $229.6


Question: How many years did Accrued expenses and other liabilities exceed $200 million?
Answer: 1
Calculation: 2019
The following table sets forth our sources of revenue for each of the periods indicated (in thousands, except for percentages):
Subscription revenue increased by $69.9 million, or 15%, in 2019 when compared to 2018. Subscription revenue growth on a constant currency basis increased 16% in 2019 when compared to 2018. The increase was attributable to new business, which includes new customers, upsells, cross-sells, and renewals from existing customers.
Professional services revenue decreased by $31.3 million, or 48%, in 2019 when compared to 2018. The decrease of professional services revenue is attributable to the continued migration of implementation services to our global partners.
Subscription revenue increased by $76.3 million, or 19%, in 2018 when compared to 2017. The increase was attributable to new business, which included new customers, upsells, and renewals from existing customers. Professional services revenue decreased by $20.4 million, or 24%, in 2018 when compared to 2017. The decrease of professional services revenue is attributable to the execution of our strategic initiative to migrate much of our implementation services to our global partners.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Subscription revenue | $542,968 | $473,052 | $396,764
Percentage of subscription revenue to total revenue | 94.2% | 87.9% | 82.3%
Professional services revenue | $33,555 | $64,839 | $85,221
Percentage of professional services to total revenue | 5.8% | 12.1% | 17.7%
Total revenue | $576,523 | 537,891 | 481,985


Question: What was Total Revenue in 2019?
Answer: $576,523
there were no share repurchases in 2016 . stock performance graph the graph below matches fidelity national information services , inc.'s cumulative 5-year total shareholder return on common stock with the cumulative total returns of the s&p 500 index and the s&p supercap data processing & outsourced services index.aa the graph tracks the performance of a $ 100 investment in our common stock and in each index ( with the reinvestment of all dividends ) from december 31 , 2011 to december 31 , 2016. .

Table:
 | 12/11 | 12/12 | 12/13 | 12/14 | 12/15 | 12/16
fidelity national information services inc . | 100.00 | 134.12 | 210.97 | 248.68 | 246.21 | 311.81
s&p 500 | 100.00 | 116.00 | 153.58 | 174.60 | 177.01 | 198.18
s&p supercap data processing & outsourced services | 100.00 | 126.06 | 194.91 | 218.05 | 247.68 | 267.14
the stock price performance included in this graph is not necessarily indicative of future stock price performance .
item 6 .
selected financial ss the selected financial data set forth below constitutes historical financial data of fis and should be read in conjunction with "item 7 , management 2019s discussion and analysis of financial condition and results of operations , " and "item 8 , financial statements and supplementary data , " included elsewhere in this report. .

Question: what is the total return if $ 100000 are invested in s&p500 in 12/11 and sold in 12/16?
Answer: 98180
Calculation: subtract(198.18, const_100), divide(100000, const_100), multiply(#1, #0)
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
Our pension plan asset allocation at December 31, 2019, and 2018, and target allocation for 2020 by asset category are as follows:
We employ a liability-driven investment strategy whereby a mix of equity and fixed-income investments are used to pursue a derisking strategy which over time seeks to reduce interest rate mismatch risk and other risks while achieving a return that matches or exceeds the growth in projected pension plan liabilities. Risk tolerance is established through careful consideration of plan liabilities and funded status. The investment portfolio primarily contains a diversified mix of equity and fixed-income investments. Other assets such as private equity are used modestly to enhance long-term returns while improving portfolio diversification. Investment risk is measured and monitored on an ongoing basis through quarterly investment portfolio reviews, annual liability measurements, and asset/liability studies at regular intervals.
Table:
 | Target Allocations | Percentage of Plan Assets at December 31, | 
Asset Category | 2020 | 2019 | 2018
Equity securities | 13% | 13% | 12%
Debt securities | 83% | 83% | 84%
Other | 4% | 4% | 4%
Total | 100% | 100% | 100%


Question: Which years did the percentage of plan assets for Debt Securities exceed 80% for 2018 and 2019?
Answer: 2019, 2018
Calculation: (2019:83%),(2018:84%)
Share-based Compensation Our Board of Directors may grant share-based awards from our shareholder approved Amended and Restated Consolidated Communications Holdings, Inc. 2005 Long-Term Incentive Plan (the “Plan”). The Plan permits the issuance of awards in the form of stock options, stock appreciation rights, stock grants, stock unit grants and other equity-based awards to eligible directors and employees at the discretion of the Compensation Committee of the Board of Directors.
On April 30, 2018, the shareholders approved an amendment to the Plan to increase by 2,000,000 the number of shares of our common stock authorized for issuance under the Plan and extend the term of the Plan through April 30, 2028.
With the amendment, approximately 4,650,000 shares of our common stock are authorized for issuance under the Plan, provided that no more than 300,000 shares may be granted in the form of stock options or stock appreciation rights to any eligible employee or director in any calendar year. Unless terminated sooner, the Plan will continue in effect until April 30, 2028.
We measure the fair value of RSAs based on the market price of the underlying common stock on the date of grant. We recognize the expense associated with RSAs on a straight-line basis over the requisite service period, which generally ranges from immediate vesting to a four year vesting period.
We implemented an ongoing performance-based incentive program under the Plan. The performance-based incentive program provides for annual grants of PSAs. PSAs are restricted stock that are issued, to the extent earned, at the end of each performance cycle.
Under the performance-based incentive program, each participant is given a target award expressed as a number of shares, with a payout opportunity ranging from 0% to 120% of the target, depending on performance relative to predetermined goals. An estimate of the number of PSAs that are expected to vest is made, and the fair value of the PSAs is expensed utilizing the fair value on the date of grant over the requisite service period.
The following table summarizes grants of RSAs and PSAs under the Plan during the years ended December 31, 2019, 2018 and 2017:
Table:
 |  |  | Year Ended December 31, |  |  | 
 | 2019 | Grant Date Fair Value | 2018 | Grant Date Fair Value | 2017 | Grant Date Fair Value
RSAs Granted | 551,214 | $ 9.87 | 478,210 | $ 12.45 | 124,100 | $ 23.12
PSAs Granted | 371,672 | $ 12.45 | - | $ - | 36,982 | $ 23.27
Total | 922,886 |  | 478,210 |  | 161,082 | 


Question: What were the RSAs granted in 2019?
Answer: 551,214