hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
We believe our success in attracting these end customers is a direct result of our commitment to high quality service and our intense focus on customer needs and performance. As an independent semiconductor foundry, most of our operating revenue is generated by our sales of wafers. The following table presented the percentages of our wafer sales by types of customers for the years ended December 31, 2017, 2018 and 2019.
We focus on providing a high level of customer service in order to attract customers and maintain their ongoing loyalty. Our culture emphasizes responsiveness to customer needs with a focus on flexibility, speed and accuracy throughout our manufacturing and delivery processes. Our customer oriented approach is especially evident in two types of services: customer design development services and manufacturing services.
For example, in 2013, we expand our regional business by opening our UMC Korea office, in order to provide local support to our customers in Korea, and shorten time-to-market for our Korea-based customers designing and manufacturing on UMC process technologies. We believe that our large production capacity and advanced process technology enable us to provide better customer service than many other foundries through shorter turn-around time, greater manufacturing flexibility and higher manufacturing yields.
Table:
 |  | Years Ended December 31, | 
Customer Type | 2017 | 2018 | 2019
 | % | % | %
Fabless design companies | 91.0 | 92.4 | 91.3
Integrated device manufacturers | 9.0 | 7.6 | 8.7
Total | 100.0 | 100.0 | 100.0


Question: What is the increase / (decrease) in the Fabless design companies from 2018 to 2019?
Answer: -1.1
Calculation: 91.3% - 92.4%
12. Income taxes
Income taxes include the taxes on income paid or owed in the individual countries as well as deferred taxes.
1 Adjustment of previous year according to explanation in notes.
The income tax rate of the German companies of METRO consists of a corporate income tax of 15.00% plus a 5.50% solidarity surcharge on corporate income tax as well as the trade tax of 14.70% given an average assessment rate of 420.00%. All in all, this results in an aggregate tax rate of 30.53%. The tax rates are unchanged from the previous year. The income tax rates applied to foreign companies are based on the respective laws and regulations of the individual countries and vary within a range of 0.00% (2017/18: 0.00%) and 34.94% (2017/18: 44.41%).
At €298 million (2017/18: €216 million), recognised income tax expenses are €81 million higher than in the previous year. In addition to an increase in pre-tax earnings, the change is due to higher expenses for impairments on deferred taxes, among other things.
Table:
€ million | 2017/2018 | 2018/2019
Actual taxes | 173 | 215
thereof Germany | (14) | (9)
thereof international | (159) | (206)
thereof tax expenses/income of 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 was the change in recognised income tax expenses in 2018/2019 from 2017/2018?
Answer: 82
Calculation: 298-216
american tower corporation and subsidiaries notes to consolidated financial statements the allocation of the purchase price was finalized during the year ended december 31 , 2012 . the following table summarizes the allocation of the aggregate purchase consideration paid and the amounts of assets acquired and liabilities assumed based upon their estimated fair value at the date of acquisition ( in thousands ) : purchase price allocation .

Table:
 | final purchase price allocation
non-current assets | $ 2
property and equipment | 3590
intangible assets ( 1 ) | 1062
other non-current liabilities | -91 ( 91 )
fair value of net assets acquired | $ 4563
goodwill ( 2 ) | 89
( 1 ) consists of customer-related intangibles of approximately $ 0.4 million and network location intangibles of approximately $ 0.7 million .
the customer-related intangibles and network location intangibles are being amortized on a straight-line basis over periods of up to 20 years .
( 2 ) the company expects that the goodwill recorded will be deductible for tax purposes .
the goodwill was allocated to the company 2019s international rental and management segment .
colombia 2014colombia movil acquisition 2014on july 17 , 2011 , the company entered into a definitive agreement with colombia movil s.a .
e.s.p .
( 201ccolombia movil 201d ) , whereby atc sitios infraco , s.a.s. , a colombian subsidiary of the company ( 201catc infraco 201d ) , would purchase up to 2126 communications sites from colombia movil for an aggregate purchase price of approximately $ 182.0 million .
from december 21 , 2011 through the year ended december 31 , 2012 , atc infraco completed the purchase of 1526 communications sites for an aggregate purchase price of $ 136.2 million ( including contingent consideration of $ 17.3 million ) , subject to post-closing adjustments .
through a subsidiary , millicom international cellular s.a .
( 201cmillicom 201d ) exercised its option to acquire an indirect , substantial non-controlling interest in atc infraco .
under the terms of the agreement , the company is required to make additional payments upon the conversion of certain barter agreements with other wireless carriers to cash paying lease agreements .
based on the company 2019s current estimates , the value of potential contingent consideration payments required to be made under the amended agreement is expected to be between zero and $ 32.8 million and is estimated to be $ 17.3 million using a probability weighted average of the expected outcomes at december 31 , 2012 .
during the year ended december 31 , 2012 , the company recorded a reduction in fair value of $ 1.2 million , which is included in other operating expenses in the consolidated statements of operations. .

Question: based on the final purchase price allocation what was the ratio of the property and equipment to the intangible assets
Answer: 3.4
Calculation: divide(3590, 1062)
(12) Basic and Diluted Net Loss per Share
Basic net loss per common share is computed by dividing net loss by the weighted-average number of shares of common stock outstanding during the period. Diluted net loss per share is computed by giving effect to all potential dilutive shares of common stock. Basic and diluted net loss per share of common stock were the same for all periods presented as the impact of all potentially dilutive securities outstanding was anti-dilutive. The Company uses the if converted method for calculating any potential dilutive effect on diluted loss per share.
The following common equivalent shares were excluded from the diluted net loss per share calculation because their inclusion would have been anti-dilutive:
In connection with the issuance of the 2024 Notes in December 2019, the Company paid $44.9 million to enter into capped call option agreements to reduce the potential dilution to holders of the Company’s common stock upon conversion of the 2024 Notes. In connection with the issuance of the 2022 Notes in November 2017, the Company paid $12.9 million to enter into capped call option agreements to reduce the potential dilution to holders of the Company’s common stock upon conversion of the 2022 Notes.
In December 2019, the Company partially terminated capped call options related to the 2022 Notes and received $5.8 million. The capped call option agreements are excluded from the calculation of diluted net loss per share attributable to common stockholders as their effect is antidilutive.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Convertible senior notes | 6,733,914 | 3,411,199 | 3,411,199
Stock-based compensation grants | 2,038,174 | 2,562,274 | 3,268,610
Total | 8,772,088 | 5,973,473 | 6,679,809


Question: What was Stock-based compensation grants in 2019, 2018 and 2017 respectively?
Answer: 2,038,174, 2,562,274, 3,268,610
Pre-tax income from international operations was $214 million, $890 million, and $353 million for fiscal 2019, 2018, and 2017, respectively.
The components of income tax expense (benefit) recorded in continuing operations are as follows:
As of December 28, 2018, we have completed our accounting for the effects of the enactment of the Tax Cuts and Jobs Act (H.R.1) (the 2017 Tax Act) in accordance with U.S. Securities and Exchange Commission (SEC) Staff Accounting Bulletin No. 118, and the amounts are no longer considered provisional. We will continue to evaluate any new guidance from the U.S. Department of Treasury and the Internal Revenue Service (IRS) as issued.
Table:
 |  | Year Ended | 
(In millions) | March 29, 2019 | March 30, 2018 | March 31, 2017
Current: |  |  | 
Federal | $73 | $1,011 | $108
State | 15 | 40 | 6
International | 74 | 107 | 68
Total | 162 | 1,158 | 182
Deferred: |  |  | 
Federal | (52) | (1,664) | (177)
State | (2) | (151) | (17)
International | (16) | (33) | (14)
Total | (70) | (1,848) | (208)
Income tax expense (benefit) | $92 | $(690) | $(26)


Question: What is the income tax expense for Federal for year ended March 29, 2019 expressed as a percentage of total income tax expenses?
Answer: 45.06
Calculation: 73/162
Retirement-Related Plans
The following table provides the total pre-tax cost for all retirement-related plans. Total operating costs/(income) are included in the Consolidated Income Statement within the caption (e.g., Cost, SG&A, RD&E) relating to the job function of the plan participants.
Total pre-tax retirement-related plan cost decreased by $994 million compared to 2018, primarily driven by a decrease in recognized actuarial losses ($1,123 million), primarily due to the change in the amortization period in the U.S. Qualified Personal Pension Plan and higher expected return on plan assets ($143 million), partially offset by higher interest costs ($203 million).
As discussed in the “Operating (non-GAAP) Earnings” section, we characterize certain retirement-related costs as operating and others as non-operating. Utilizing this characterization, operating retirement-related costs in 2019 were $1,457 million, a decrease of $37 million compared to 2018. Non-operating costs of $615 million in 2019 decreased $957 million year to year, driven primarily by the same factors as above.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2019 | 2018 | Yr.-to-Yr. Percent Change
Retirement-related plans—cost |  |  | 
Service cost | $385 | $431 | (10.7)%
Multi-employer plans | 32 | 38 | (16.9)
Cost of defined contribution plans | 1,040 | 1,024 | 1.5
Total operating costs/ (income) | $1,457 | $1,494 | (2.5)%
Interest cost | $2,929 | $2,726 | 7.4%
Expected return on plan assets | (4,192) | (4,049) | 3.5
Recognized actuarial losses | 1,819 | 2,941 | (38.2)
Amortization of prior service costs/(credits) | (9) | (73) | (87.6)
Curtailments/settlements | 41 | 11 | 262.2
Other costs | 28 | 16 | 76.2
Total non-operating costs/(income) | $615 | $1,572 | (60.9)%
Total retirement-related plans—cost | $2,072 | $3,066 | (32.4)%


Question: What were the operating retirement related costs in 2019?
Answer: $1,457 million
NOTE 19—SEGMENT INFORMATION
ASC Topic 280, “Segment Reporting” (Topic 280), establishes standards for reporting, by public business enterprises, information about operating segments, products and services, geographic areas, and major customers. The method of determining what information, under Topic 280, to report is based on the way that an entity organizes operating segments for making operational decisions and how the entity’s management and chief operating decision maker (CODM) assess an entity’s financial performance. Our operations are analyzed by management and our CODM as being part of a single industry segment: the design, development, marketing and sales of Enterprise Information Management software and solutions.
The following table sets forth the distribution of revenues, by significant geographic area, for the periods indicated:
Table:
 |  | Year Ended June 30, | 
 | 2019 | 2018 | 2017
Revenues: |  |  | 
Canada | $153,890 | $149,812 | $227,115
United States | 1,490,863 | 1,425,244 | 1,090,049
United Kingdom | 182,815 | 201,821 | 159,817
Germany | 203,403 | 198,253 | 166,611
Rest of Europe | 534,204 | 517,693 | 394,132
All other countries | 303,580 | 322,418 | 253,333
Total revenues | $2,868,755 | $2,815,241 | $2,291,057


Question: What does the table show?
Answer: distribution of revenues, by significant geographic area, for the periods indicated
Liquidity and Capital Resources
Working Capital
The following table summarizes our cash and cash equivalents, accounts receivable, net and working capital, for the periods indicated (in thousands):
We define working capital as current assets minus current liabilities. Our cash and cash equivalents as of December 31, 2019 are available for working capital purposes. We do not enter into investments for trading purposes, and our investment policy is to invest any excess cash in short term, highly liquid investments that limit the risk of principal loss; therefore, our cash and cash equivalents are held in demand deposit accounts that generate very low returns.
Table:
 |  | As of December 31, | 
 | 2019 | 2018 | 2017
Cash and cash equivalents | $119,629 | $146,061 | $96,329
Accounts receivable, net | 76,373 | 49,510 | 40,634
Working capital | 167,879 | 152,793 | 119,433


Question: Which years does the table provide information for the company's cash and cash equivalents, accounts receivable, net and working capital for?
Answer: 2019, 2018, 2017
4. Debt, Capital Lease Obligations and Other Financing
Debt and capital lease obligations as of September 28, 2019 and September 29, 2018, consisted of the following (in thousands):
On June 15, 2018, the Company entered into a Note Purchase Agreement (the “2018 NPA”) pursuant to which it issued an aggregate of$ 150.0 million in principal amount of unsecured senior notes, consisting of $100.0 million in principal amount of 4.05% Series A Senior Notes, due on June 15, 2025, and $50.0 million in principal amount of 4.22% Series B Senior Notes, due on June 15, 2028 (collectively, the “2018 Notes”), in a private placement. The 2018 NPA includes customary operational and financial covenants with which the Company is required to comply, including, among others, maintenance of certain financial ratios such as a total leverage ratio and a minimum interest coverage ratio. The 2018 Notes may be prepaid in whole or in part at any time, subject to payment of a makewhole amount; interest on the 2018 Notes is payable semiannually. At September 28, 2019, the Company was in compliance with the covenants under the 2018 NPA.
In connection with the issuance of the 2018 Notes, on June 15, 2018, the Company repaid, on maturity $175.0 million in principal amount of its previous 5.20% Senior Notes.
On May 15, 2019, the Company refinanced its then-existing senior unsecured revolving credit facility (the "Prior Credit Facility") by entering into a new5 -year senior unsecured revolving credit facility (collectively with the Prior Credit Facility, referred to as the "Credit Facility"), which expanded the maximum commitment from $300.0 million to $350.0 million and extended the maturity from July 5, 2021 to May 15, 2024. The maximum commitment under the Credit Facility may be further increased to $600.0 million, generally by mutual agreement of the Company and the lenders, subject to certain customary conditions. During fiscal 2019, the highest daily borrowing was $250.0 million; the average daily borrowings were $140.7 million. The Company borrowed $1,084.5 million and repaid $989.5 million of revolving borrowings under the Credit Facility during fiscal 2019. The Company was in compliance with all financial covenants relating to the Credit Agreement, which are generally consistent with those in the 2018 NPA discussed above. The Company is required to pay a commitment fee on the daily unused revolver credit commitment based on the Company's leverage ratio; the fee was 0.125% as of September 28, 2019.
Table:
 | 2019 | 2018
4.05% Senior Notes, due June 15, 2025 | $100,000 | $100,000
4.22% Senior Notes, due June 15, 2028  | 50,000 | 50,000
Borrowings under the credit facility | 95,000 | —
Capital lease and other financing obligations | 44,492 | 39,857
Unamortized deferred financing fees | (1,512) | (1,240)
Total obligations | 287,980 | 188,617
Less: current portion  | (100,702) | (5,532)
Long-term debt and capital lease obligations, net of current portion | 187,278 | 183,085


Question: What was the percentage change in Total obligations between 2018 and 2019?
Answer: 52.68
Calculation: (287,980-188,617)/188,617
Note 19 – Summarized Quarterly Financial Data (Unaudited)
The following table presents unaudited quarterly operating results for each of our last eight fiscal quarters. This information has been prepared on a basis consistent with our audited financial statements and includes all adjustments, consisting only of normal recurring adjustments, considered necessary for a fair presentation of the data.
UNAUDITED QUARTERLY OPERATING RESULTS
(In thousands, except for per share amounts)
(1) Assumes exercise of dilutive securities calculated under the treasury stock method.
Table:
Three Months Ended | March 31, 2019 | June 30, 2019 | September 30, 2019 | December 31, 2019
Net sales | $143,791 | $156,391 | $114,092 | $115,787
Gross profit | $60,612 | $65,015 | $46,331 | $47,209
Operating income (loss) | $(6,167) | $562 | $(20,288) | $(14,070)
Net income (loss) | $770 | $3,995 | $(46,123) | $(11,624)
Earnings (loss) per common share - basic | $0.02 | $0.08 | $(0.96) | $(0.25)
Earnings (loss) per common share - diluted | $0.02(1) | $0.08(1) | $(0.96) | $(0.25)


Question: What was the Gross Profit in Three Months Ended June 30, 2019?
Answer: $65,015
Quarterly Financial Data (Unaudited)
Quarterly results for the years ended June 30, 2019 and 2018 are as follow (in thousands, except per share amounts).
Table:
 | June 30,
2019 | March 31,
2019 | December 31,
2018 | September 30,
2018
Net revenues  | $252,359 | $250,864 | $252,680 | $239,886
Gross profit  | $138,946 | $138,919 | $141,299 | $132,071
Net (loss) income (1)  | $(17,055) | $(6,932) | $7,199 | $(9,065)
Net (loss) income per share – basic  | $(0.14) | $(0.06) | $0.06 | $(0.08)
Net (loss) income per share – diluted  | $(0.14) | $(0.06) | $0.06 | $(0.08)


Question: What was the percentage change in the net (loss) income between March 31 and June 30, 2019?
Answer: 146.03
Calculation: (-17,055+6,932)/-6,932
Comparison of Fiscal Year Ended September 27, 2019 to Fiscal Year Ended September 28, 2018
Revenue. In fiscal year 2019, our revenue decreased by $70.7 million, or 12.4%, to $499.7 million from $570.4 million for fiscal year 2018. Revenue from our primary markets, the percentage of change between the years and revenue by primary markets expressed as a percentage of total revenue were (in thousands, except percentages):
In fiscal year 2019, our Telecom market revenue decreased by $42.0 million, or 18.8%, compared to fiscal year 2018. The decrease was primarily due to the full year effect of our May 2018 sale of the Japan-based long-range optical subassembly business (the "LR4 Business"), lower sales of carrier-based optical semiconductor products to our Asia customer base, as well as lower sales of products targeting fiber to the home applications.
In fiscal year 2019, our Data Center market revenue decreased by $48.0 million, or 29.6%, compared to fiscal year 2018. The decrease was primarily due to lower revenue related to sales of legacy optical products and lasers, partially offset by the recognition of $7.0 million of licensing revenue during the fiscal year ended September 27, 2019.
In fiscal year 2019, our I&D market revenues increased by $19.3 million, or 10.4%, compared to fiscal year 2018. The increase was related to higher revenue from sales across the product portfolio.
Table:
 | Fiscal Years |  | 
 | 2019 | 2018 | % Change
Telecom | $180,938 | $ 222,940 | (18.8)%
Data Center | 114,132 | 162,098 | (29.6)%
Industrial & Defense | 204,638 | 185,360 | 10.4 %
Total | $499,708 | $ 570,398 | (12.4)%
Telecom | 36.2% | 39.1% | 
Data Center | 22.8% | 28.4% | 
Industrial & Defense | 41.0% | 32.5% | 
 Total | 100.0% | 100.0% | 


Question: In which year was Telecom less than 200,000 thousand?
Answer: 2019
Calculation: locate and analyze Telecom in row 3
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 Less Capital expenditures (including capitalized software) in 2019?
Answer: 17,939
Revenue
Revenue was $5,517.9 million and $5,878.3 million for 2019 and 2018, respectively. The decrease of $360.4 million, or 6.1% was primarily attributable to an 8.2%, 4.8% and 1.5% decrease in revenue in PSG, ASG and ISG, respectively, which is further explained below. Revenue by reportable segment for each were as follows (dollars in millions):
(1) Certain of the amounts may not total due to rounding of individual amounts.
Revenue from PSG
Revenue from PSG decreased by $249.9 million, or approximately 8%, which was due to a combination of a decrease in volume of products sold and a competitive pricing environment. The revenue in our Protection and Signal Division, Integrated Circuits Division, and High Power Division, decreased by $106.5 million, $96.6 million and $91.5 million, respectively. This was partially offset by an increase in revenue of $30.1 million and $15.0 million from our Foundry Services and Power Mosfet Division, respectively.
Revenue from ASG
Revenue from ASG decreased by $98.9 million, or approximately 5%, which was also due to a combination of a decrease in volume of products sold and a competitive pricing environment. The revenue in our Industrial and Offline Power Division and our Signal Processing, Wireless and Medical Division, decreased by $100.5 million and $56.4 million, respectively. This was partially offset by $84.8 million of revenue from Quantenna, which was acquired during 2019.
Revenue from ISG
Revenue from ISG decreased by $11.6 million, or 1.5%, which was due to a decrease in our Industrial Sensing Division revenue of $20.8 million, primarily due to decreased demand, which was partially offset by an increase in revenue in other divisions.
Table:
 | 2019 | As a % of Revenue (1) | 2018 | As a % of Revenue (1)
PSG | $ 2,788.3 | 50.5 % | $ 3,038.2 | 51.7 %
ASG | 1,972.3 | 35.7 % | 2,071.2 | 35.2 %
ISG | 757.3 | 13.7 % | 768.9 | 13.1 %
Total revenue | $ 5,517.9 |  | $ 5,878.3 | 


Question: What is the change in revenues from ASG from 2018 to 2019?
Answer: -98.9
Calculation: 1,972.3-2,071.2