hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Results of Operations
The following table sets forth our consolidated statement of operations for the years ended December 31, 2019, 2018, and 2017.
(1) Includes stock-based compensation expense and related payroll taxes as follows:
Table:
 |  | Years ended December 31, | 
 | 2019 | 2018 | 2017
 | (in thousands, except share and per share data) |  | 
Revenues: |  |  | 
Subscription solutions | $642,241 | $464,996 | $310,031
Merchant solutions | 935,932 | 608,233 | 363,273
 | 1,578,173 | 1,073,229 | 673,304
Cost of revenues(1)(2): |  |  | 
Subscription solutions | 128,155 | 100,990 | 61,267
Merchant solutions | 584,375 | 375,972 | 231,784
 | 712,530 | 476,962 | 293,051
Gross profit | 865,643 | 596,267 | 380,253
Operating expenses: |  |  | 
Sales and marketing(1)(2) | 472,841 | 350,069 | 225,694
Research and development(1)(2) | 355,015 | 230,674 | 135,997
General and administrative(1) | 178,934 | 107,444 | 67,719
Total operating expenses | 1,006,790 | 688,187 | 429,410
Loss from operations | (141,147) | (91,920) | (49,157)
Other income | 45,332 | 27,367 | 9,162
Loss before income taxes | (95,815) | (64,553) | (39,995)
Provision for income taxes | 29,027 | — | —
Net loss | $(124,842) | $(64,553) | $(39,995)
Basic and diluted net loss per share attributable to shareholders | $(1.10) | $(0.61) | $(0.42)
Weighted average shares used to compute net loss per share attributable to shareholders | 113,026,424 | 105,671,839 | 95,774,897


Question: What financial items does revenue consist of?
Answer: Subscription solutions, Merchant solutions
stock performance graph the graph depicted below shows a comparison of our cumulative total stockholder returns for our common stock , the nasdaq stock market index , and the nasdaq pharmaceutical index , from the date of our initial public offering on july 27 , 2000 through december 26 , 2003 . the graph assumes that $ 100 was invested on july 27 , 2000 , in our common stock and in each index , and that all dividends were reinvested . no cash dividends have been declared on our common stock . stockholder returns over the indicated period should not be considered indicative of future stockholder returns . comparison of total return among illumina , inc. , the nasdaq composite index and the nasdaq pharmaceutical index december 26 , 2003december 27 , 2002december 28 , 2001december 29 , 2000july 27 , 2000 illumina , inc . nasdaq composite index nasdaq pharmaceutical index july 27 , december 29 , december 28 , december 27 , december 26 , 2000 2000 2001 2002 2003 .

Table:
 | july 27 2000 | december 29 2000 | december 28 2001 | december 27 2002 | december 26 2003
illumina inc . | 100.00 | 100.39 | 71.44 | 19.50 | 43.81
nasdaq composite index | 100.00 | 63.84 | 51.60 | 35.34 | 51.73
nasdaq pharmaceutical index | 100.00 | 93.20 | 82.08 | 51.96 | 74.57
.

Question: at december 292000 what was the ratio of the nasdaq composite index to the nasdaq pharmaceutical index
Answer: 0.685
Calculation: divide(63.84, 93.20)
table of contents part ii item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities . price range our common stock trades on the nasdaq global select market under the symbol 201cmktx 201d . the range of closing price information for our common stock , as reported by nasdaq , was as follows : on february 20 , 2013 , the last reported closing price of our common stock on the nasdaq global select market was $ 39.60 . holders there were 33 holders of record of our common stock as of february 20 , 2013 . dividend policy we initiated a regular quarterly dividend in the fourth quarter of 2009 . during 2012 and 2011 , we paid quarterly cash dividends of $ 0.11 per share and $ 0.09 per share , respectively . on december 27 , 2012 , we paid a special dividend of $ 1.30 per share . in january 2013 , our board of directors approved a quarterly cash dividend of $ 0.13 per share payable on february 28 , 2013 to stockholders of record as of the close of business on february 14 , 2013 . any future declaration and payment of dividends will be at the sole discretion of our board of directors . the board of directors may take into account such matters as general business conditions , our financial results , capital requirements , and contractual , legal , and regulatory restrictions on the payment of dividends to our stockholders or by our subsidiaries to the parent and any other such factors as the board of directors may deem relevant . recent sales of unregistered securities securities authorized for issuance under equity compensation plans please see the section entitled 201cequity compensation plan information 201d in item 12. .

Table:
2012: | high | low
january 1 2012 to march 31 2012 | $ 37.79 | $ 29.26
april 1 2012 to june 30 2012 | $ 37.65 | $ 26.22
july 1 2012 to september 30 2012 | $ 34.00 | $ 26.88
october 1 2012 to december 31 2012 | $ 35.30 | $ 29.00
2011: | high | low
january 1 2011 to march 31 2011 | $ 24.19 | $ 19.78
april 1 2011 to june 30 2011 | $ 25.22 | $ 21.00
july 1 2011 to september 30 2011 | $ 30.75 | $ 23.41
october 1 2011 to december 31 2011 | $ 31.16 | $ 24.57
.

Question: by how much did the low of mktx stock increase from 2011 to march 2012?
Answer: 19.1%
Calculation: subtract(29.26, 24.57), divide(#0, 24.57)
Contractual Obligations
The following table sets forth our future payments due under contractual obligations as of December 31, 2019 (in thousands):
(1) Our debt obligations consist of principal and interest repayments due on our Credit Facility based on current interest rates.
(2) Amounts represent the minimum contractual cash commitments, including the effects of fixed rental escalation clauses and deferred rent, exclusive of certain contingent rents that are not determinable for future periods.
(3) Our purchase obligations consist of purchase commitments with various manufacturing suppliers to ensure the availability of components.
(4) Income tax obligations are a result of the Tax Act and include a transition tax on unremitted foreign earnings and profits, of which we have elected to pay the estimated amount over an eight-year period.
(5) Our pension funding commitments represent the amounts that we are required to pay to fund our pension plans.
Table:
 | Total | 1 year | Less than 1-3 years | 3-5 years | More than 5 years
Debt obligations(1) | $341,250 | $17,500 | 35,000 | 288,750 | —
Interest payments associated with debt obligations(1) | 36,555 | 8,532 | 15,726 | 12,297 | —
Operating lease obligations(2) | 152,778 | 22,727 | 33,275 | 20,387 | 76,389
Purchase obligations(3) | 192,981 | 192,803 | 178 | — | —
Income tax obligations(4) | 11,724 | 1,117 | 2,234 | 4,884 | 3,489
Pension funding commitment(5) | 173,830 | 6,113 | 12,712 | 20,203 | 134,802
Total | $909,118 | $ 248,792 | $ 99,125 | $ 346,521 | $ 214,680


Question: What was the total purchase obligations?
Answer: 192,981
Contractual Obligations
Obligations under long-term debt; non-cancelable operating leases; purchase obligations relating to feed grains, other feed ingredients and packaging supplies; construction contracts and claims payable relating to the Company’s workers’ compensation insurance policy at October 31, 2019, were as follows:
Table:
 |  |  | Payments Due By Period (in thousands)  |  | 
Contractual Obligations | Total | Less than 1 Year | 1-3 Years | 3-5  Years | 5 Years
Operating leases  | 47,774 | $15,363 | $22,919 | $ 9,382 | $110
Long-term debt  | 55,000 | — | — | 55,000 | —
Purchase obligations:    |  |  |  |  | 
Feed grains, feed ingredients and packaging supplies | 199,097 | 199,097 | — |  | 
Construction contracts and other  | 8,996 | 8,996 | — | — | —
Claims payable  | 20,587 | 9,687 | 10,900 | — | —
Total  | 331,454 | $233,143 | $33,819 | $ 64,382 | $110


Question: What is the total long-term debt due for payment?
Answer: 55,000
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 was the company's rank in 2019 conducted by the Taiwan Stock Exchange and Taipei Exchange?
Answer: among the top 5%
NOTE 15. ACCRUED EXPENSES AND OTHER PAYABLES
Accrued expenses and other payables consist of the following:
Personnel-related items comprise accrued management bonuses, accrued vacation days, accrued wage tax, social securities and pension premiums. Deferred revenue consists of the revenue relating to the undelivered elements of the arrangements, see Note 21 for more information. This part of revenue is deferred at their relative selling prices until delivery of these elements. Other includes accruals for VAT, other taxes and invoices to be received for goods and services.
Table:
 | December 31, | 
 | 2018 | 2019
Personnel-related items | 32,636 | 45,318
Deferred revenue | 28,255 | 32,146
Financing related items | – | 3,912
Current portion of lease liabilities | – | 7,002
Advanced payments from customers | 25,382 | 47,601
Supplier related items | 1,828 | 2,175
Marketing related items | 1,049 | 1,365
R&D projects | 1,209 | 1,109
Other | 8,634 | 9,215
Total accrued expenses and other payables | 98,993 | 149,843


Question: What is the percentage change in Total accrued expenses and other payables from 2018 to 2019?
Answer: 51.37
Calculation: (( 149,843 - 98,993 )/ 98,993 ) * 100
4. PREPAID EXPENSES
Prepaid expenses consisted of the following at December 31, 2019 and 2018 (in thousands):  Prepaid expenses consisted of the following at December 31, 2019 and 2018 (in thousands):  Prepaid expenses consisted of the following at December 31, 2019 and 2018 (in thousands):
In 2018, we recorded impairment charges of approximately$0.4 million related to prepaid licenses and production tooling as a result of the restructuring of our operations. These charges are included in “Restructuring expenses” in the accompanying statements of comprehensive loss (see Note 15).
Table:
 | 2019 | 2018
Prepaid services | $221 | $252
Prepaid bonds for German statutory costs | 188 | 199
Prepaid insurance | 62 | 19
Prepaid licenses, software tools and support | 17 | 51
Other prepaid expenses | 17 | 17
 | $505 | $538


Question: What is the total sum of the top 3 prepaid expenses in 2018?
Answer: 502
Calculation: 252 + 199 + 51
Year Ended December 31, 2018 Compared to Year Ended December 31, 2017
Revenue
Total revenue for the year ended December 31, 2018 increased by $58.9 million, or 28%, compared to the year ended December 31, 2017. Subscription
and returns revenue for the year ended December 31, 2018 increased by $54.1 million, or 27%, compared to the year ended December 31, 2017. Professional
services revenue for the year ended December 31, 2018 increased by $4.8 million, or 37%, compared to the year ended December 31, 2017. Growth in total
revenue was due primarily to increased demand for our products and services from both new and existing customers. Of the increase in total revenue for the year
ended December 31, 2018 compared to 2017, approximately $29.6 million was attributable to existing customers, approximately $28.3 million was attributable to
new customers, and approximately $1.1 million was due to interest income on funds held for customers. Total subscription and returns revenue for 2018 included
$1.2 million related to our cross-border transactions technology acquired in May 2018.
Table:
 | For the Year Ended December 31, |  | Change | 
 | 2018 | 2017 | Amount | Percentage
 |  | (dollars in thousands) |  | 
Revenue: |  |  |  | 
Subscription and returns | $254,056 | $199,942 | $54,114 | 27%
Professional services | 18,042 | 13,217 | 4,825 | 37%
Total revenue | $272,098 | $213,159 | $58,939 | 28%


Question: What are the increase in revenue from subscription and returns as well as from professional service between 2017 and 2018?
Answer: $54.1, $4.8
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
6. NOTES RECEIVABLE AND OTHER NON-CURRENT ASSETS
Notes receivable and other non-current assets consisted of the following:
The reduction in Long-term prepaid ground rent is a result of the reclassification of assets to the Right-of-use asset in connection with the Company’s adoption of the new lease accounting standard.
Table:
 | As of | 
 | December 31, 2019 | December 31, 2018
Long-term prepaid ground rent | $— | $607.5
Notes receivable | 1.1 | 1.0
Other miscellaneous assets | 405.3 | 354.1
Notes receivable and other non-current assets | $406.4 | $962.6


Question: What was long-term prepaid ground rent as a percentage of notes receivable and other non-current assets in 2018?
Answer: 63.11
Calculation: ($607.5/$962.6) * 100
other items on our consolidated financial statements have been appropriately adjusted from the amounts provided in the earnings release , including a reduction of our full year 2016 gross profit and income from operations by $ 2.9 million , and a reduction of net income by $ 1.7 million. .

Table:
( in thousands ) | at december 31 , 2016 | at december 31 , 2015 | at december 31 , 2014 | at december 31 , 2013 | at december 31 , 2012
cash and cash equivalents | $ 250470 | $ 129852 | $ 593175 | $ 347489 | $ 341841
working capital ( 1 ) | 1279337 | 1019953 | 1127772 | 702181 | 651370
inventories | 917491 | 783031 | 536714 | 469006 | 319286
total assets | 3644331 | 2865970 | 2092428 | 1576369 | 1155052
total debt including current maturities | 817388 | 666070 | 281546 | 151551 | 59858
total stockholders 2019 equity | $ 2030900 | $ 1668222 | $ 1350300 | $ 1053354 | $ 816922
( 1 ) working capital is defined as current assets minus current liabilities. .

Question: what is the debt-to-equity ratio in 2016?
Answer: 40.2%
Calculation: divide(817388, 2030900)
Computer Equipment, Software, Furniture, and Leasehold Improvements, Net
Computer equipment, software, and furniture are depreciated using the straight-line method over the estimated useful lives of the assets, which range from three to five years. Leasehold improvements are amortized on a straight-line basis over the shorter of their estimated useful lives or the lease term. Depreciation expense was $59.2 million in fiscal 2019, $67.6 million in fiscal 2018, and $73.1 million in fiscal 2017
Computer equipment, software, furniture, leasehold improvements and the related accumulated depreciation at January 31 were as follows:
Costs incurred for computer software developed or obtained for internal use are capitalized for application development activities, if material, and immediately expensed for preliminary project activities and post-implementation activities. These capitalized costs are amortized over the software’s expected useful life, which is generally three years.
Table:
 | 2019 | 2018
Computer hardware, at cost | $190.2 | $217.1
Computer software, at cost | 66.7 | 72.6
Leasehold improvements, land and buildings, at cost | 247.8 | 228.9
Furniture and equipment, at cost | 67.2 | 63.4
Computer software, hardware, leasehold improvements, furniture, and equipment, at cost | 571.9 | 582.0
Less: Accumulated depreciation | (422.2) | (437.0)
Computer software, hardware, leasehold improvements, furniture, and equipment, net | $149.7 | $145.0


Question: What kind of computer software costs are immediately expensed?
Answer: preliminary project activities and post-implementation activities
Revenue by geographic area are as follows (in thousands):
Revenues by geographic area are based upon the country of billing. The geographic location of distributors and OEM customers may be different from the geographic location of the ultimate end users of the products and services provided by us. No single non-U.S. country accounted for more than 10% of our revenue in fiscal years ended February 28, 2019, 2018 and 2017.
Table:
 |  | Year Ended February 28, | 
 | 2019 | 2018 | 2017
United States | 268,453 | 265,613 | 259,974
Europe, Middle East and Africa | 49,496 | 45,830 | 49,918
South America | 15,134 | 20,699 | 17,738
Canada | 9,815 | 14,958 | 8,412
Asia and Pacific Rim | 13,958 | 12,873 | 8,967
All other | 6,944 | 5,939 | 6,093
 | 363,800 | 365,912 | 351,102


Question: What was the revenue from Asia and Pacific Rim in 2018?
Answer: 12,873
Discontinued Operations
Year Ended December 31, 2019 Compared with the Years Ended December 31, 2018 and 2017
On December 31, 2018, we sold all of the Class A Common Units of Netsmart owned by the Company. Prior to the sale, Netsmart comprised a separate reportable segment, which due to its significance to our historical consolidated financial statements and results of operations, is now reported as a discontinued operation as a result of the sale for all periods presented. The loss from discontinued operations represents the net of losses incurred by Netsmart for the years ended December 31, 2018 and 2017 partly offset by earnings attributable to two solutions acquired during the fourth quarter of 2017 as part of the EIS Business that we no longer support effective as of March 31, 2018. Refer to Note 17, “Discontinued Operations” to our consolidated financial statements included in Part II, Item 8, “Financial Statements and Supplementary Data” of this Form 10-K for additional information regarding discontinued operations.
Table:
 | Year Ended December 31, |  |  | 2019 % | 2018 %
(In thousands) | 2019 | 2018 | 2017 | Change from 2018 | Change from 2017
Loss from discontinued operations | $ 0 | $(72,836) | $(11,915) | (100.0%) | NM
Gain on sale of Netsmart | $ 0 | 500,471 | 0 | (100.0%) | NM
Income tax effect on discontinued operations | $ 0 | (32,497) | 42,263 | (100.0%) | (176.9%)
Income (loss) from discontinued operations, net of tax | $ 0 | $395,138 | $30,348 | (100.0%) | NM


Question: What was the average Income tax effect on discontinued operations between 2017-2019?
Answer: 3255.33
Calculation: (0 - 32,497 + 42,263) / 3
7. LOANS PAYABLE
Plan B, a subsidiary of the Company, entered into a business loan agreement, prior to being acquired by the Company, with Tri Counties Bank dated March 14, 2014, in the original amount of $131 bearing interest at 4.95%. The loan agreement called for monthly payments of $2 and was scheduled to mature on March 14, 2019. Proceeds from the loan were used to purchase a pile driver and related equipment and is secured by the equipment. The loan was fully paid off during the year ended December 31, 2019.
Plan B entered into a business loan agreement prior to being acquired by the Company, with Tri Counties Bank dated April 9, 2014, in the original amount of $250 bearing interest at 4.95%. The loan agreement calls for monthly payments of $5 and was scheduled to mature on April 9, 2019. Proceeds from the loan were used to purchase racking inventory and related equipment. The loan was secured by the inventory and equipment. The loan was fully paid off during the year ended December 31, 2019.
On January 5, 2016, the Company entered into a loan agreement for the acquisition of a pile driver in the principal amount of $182 bearing interest at 5.5%. The loan agreement calls for monthly payments of $4 and is scheduled to mature on January 15, 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $4.
On September 8, 2016, the Company entered into a loan agreement for the acquisition of a pile driver in the principal amount of $174 bearing interest at 5.5%. The loan agreement calls for monthly payments of $4 and is scheduled to mature on September 15, 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $36.
On November 14, 2016, the Company entered into a 0% interest loan agreement for the acquisition of an excavator in the principal amount of $59. The loan agreement calls for monthly payments of $1 and is scheduled to mature on November 13, 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $13.
On December 23, 2016, the Company entered into a loan agreement for the acquisition of modular office systems and related furniture in the principal amount of $172 bearing interest at 4.99%. The loan agreement calls for 16 quarterly payments of $12 and is scheduled to mature in September 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $35.
As of December 31, 2019 and 2018, loans payable are summarized as follows:
Table:
 | 2019 | 2018
Business loan agreement dated March 14, 2014 | - | 7
Business loan agreement dated April 9, 2014 | - | 19
Equipment notes payable | 88 | 241
Subtotal | 88 | 267
Less: Current position | (88) | (179)
Long-term position | - | $88


Question: What is the principal amount for the loan agreement for the acquisition of an excavator on November  2016?
Answer: $59
The following table presents each NEO’s base salary for FY19.
(1) Mr. Kapuria was named an executive officer during FY19 and received a salary increase in connection with his promotion. His salary increased from $390,000 to $440,000 effective May 8, 2018.
As presented in the table above, our named executive officers did not receive an increase in annual base salary other than in connection with a promotion for Mr. Kapuria. Our former CEO determined that none of our other NEOs would receive a base salary increase for FY19. In addition, our Board also determined that Mr. Clark would not receive a salary increase in FY19.
Table:
 | FY18 | Change in | FY19
NEO | Annual Salary ($) | Salary (%) | Annual Salary
Gregory S. Clark | 1,000,000 | — | 1,000,000
Nicholas R. Noviello | 650,000 | — | 650,000
Amy L. Cappellanti-Wolf | 440,000 | — | 440,000
Samir Kapuria(1) | 390,000(1) | 60,000(1) | 450,000
Scott C. Taylor | 600,000 | — | 600,000


Question: Who was named an executive officer during FY19?
Answer: Mr. Kapuria