hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
As described in Note 7, the acquisition of Norstel resulted in the recognition of technology in process for $86 million in the line “Technologies in progress”.
The line “Technologies in progress” in the table above also includes internally developed software under construction and software not ready for use.
The amortization expense in 2019, 2018 and 2017 was $69 million, $64 million and $58 million, respectively.
Table:
December 31, 2019 | Gross Cost | Accumulated Amortization | Net Cost
Technologies & licenses | 699 | (578) | 121
Purchased & internally developed software | 486 | (427) | 59
Technologies in progress | 119 | — | 119
Other intangible assets | 70 | (70) | —
Total | 1,374 | (1,075) | 299
December 31, 2018 | Gross Cost | Accumulated Amortization | Net Cost
Technologies & licenses | 705 | (592) | 113
Purchased & internally developed software | 459 | (404) | 55
Technologies in progress | 44 | — | 44
Other intangible assets | 69 | (69) | —
Total | 1,277 | (1,065) | 212


Question: What does Technologies in progress in the table include?
Answer: includes internally developed software under construction and software not ready for use.
Figure 29. 2016/2018 LTIP Award Grants
(1) All of the Market-based PRSUs and one-third of the stock options and service-based RSUs granted to Mr. Anstice under the 2016/2018 LTIP that were scheduled to vest in February 2019 were canceled upon his termination of employment with the Company as of December 5, 2018.
(2) The number of Market-based PRSUs awarded is reflected at target. The final number of shares that may have been earned is 0% to 150% of target.
In February 2019, the committee determined the payouts for the calendar year 2016/2018 LTIP Awards of Market-based PRSUs. The number of shares represented by the Marketbased PRSUs earned over the performance period was based on our stock price performance compared to the market price performance of the SOX index.
Based on the above formula and Market-based PRSU Vesting Summary set forth in Figures 26 and 27, the Company’s stock price performance over the three-year performance period was equal to 89.93% and performance of the SOX index (based on market price) over the same three-year performance period was equal to 84.47%. Lam’s stock price outperformed the SOX index by 5.46%, which resulted in a performance payout of 110.93% to target number of Marketbased PRSUs granted to each NEO. Based on such results, the committee made the following payouts to each NEO for the 2016/2018 LTIP Award of Market-based PRSUs.
Table:
Named Executive Officer (1)(2) (1)(2) (1)(2) | Target Award Opportunity ($) | Market-based PRSUs award (#) | Stock Options Award (#) | Service-based RSUs Award (#)
Timothy M.Archer | 4,000,000 | 28,935 | 34,722 | 17,361
Douglas R.Bettinger | 2,750,000 | 19,892 | 23,871 | 11,935
Richard A.Gottscho | 3,250,000 | 23,509 | 28,209 | 14,105
Patrick J. Lord | 1,100,000 | 7,957 | — | 7,957
Vahid Vahedi | 1,100,000 | 7,957 | — | 7,957
Seshasayee(Sesha) Varadarajan | 1,100,000 | 7,957 | — | 7,957


Question: Which named executive officer has the highest target award opportunity?
Answer: Timothy M.Archer
Calculation: Find the named executive officer with the highest target award opportunity
Management Discussion and Analysis
Capital Management and Dividend Policy
Notes: (1) Net debt is defined as gross debt less cash and bank balances adjusted for related hedging balances.
(2) Net debt gearing ratio is defined as the ratio of net debt to net capitalisation. Net capitalisation is the aggregate of net debt, shareholders’ funds and non-controlling interests.
(3) Interest cover refers to the ratio of EBITDA and share of associates’ pre-tax profits to net interest expense.
As at 31 March 2019, the Group’s net debt was S$9.9 billion, stable from a year ago. 

As at 31 March 2019, the Group’s net debt was S$9.9 billion, stable from a year ago.
The Group has one of the strongest credit ratings among telecommunication companies in the Asia Pacific region. Singtel is currently rated A1 by Moody’s and A+ by S&P Global Ratings. The Group continues to maintain a healthy capital structure. 

The Group has one of the strongest credit ratings among telecommunication companies in the Asia Pacific region. Singtel is currently rated A1 by Moody’s and A+ by S&P Global Ratings. The Group continues to maintain a healthy capital structure.
For the financial year ended 31 March 2019, the total ordinary dividend payout, including the proposed final dividend, was 17.5 cents per share or 101% of the Group’s underlying net profit and 88% of the Group’s free cash flow (after interest and tax payments). 

For the financial year ended 31 March 2019, the total ordinary dividend payout, including the proposed final dividend, was 17.5 cents per share or 101% of the Group’s underlying net profit and 88% of the Group’s free cash flow (after interest and tax payments).
Singtel is committed to delivering dividends that increase over time with growth in underlying earnings, while maintaining an optimal capital structure and investment grade credit ratings. Barring unforeseen circumstances, it expects to maintain its ordinary dividends at 17.5 cents per share for the next financial year ending 31 March 2020.
Table:
 | Financial Year ended 31 March | 
Group | 2019 | 2018
Gross debt (S$ million) | 10,396 | 10,402
Net debt (1) (S$ million) | 9,883 | 9,877
Net debt gearing ratio (2) (%) | 24.9 | 24.9
Net debt to EBITDA and share of associates’ pre-tax proﬁts (number of times) | 1.6 | 1.3
Interest cover (3) (number of times) | 16.2 | 20.1


Question: What is the average gross debt across the 2 years?
Answer: 10399
Calculation: ( 10,396 + 10,402 ) / 2
Significant components of our deferred tax assets and liabilities are as follows:
The deferred tax assets and liabilities for fiscal 2019 and 2018 include amounts related to various acquisitions. The total change in deferred tax assets and liabilities in fiscal 2019 includes changes that are recorded to other comprehensive income (loss), retained earnings and goodwill.
We calculate deferred tax assets and liabilities based on differences between financial reporting and tax bases of assets and liabilities and measure them using the enacted tax rates and laws that we expect will be in effect when the differences reverse.
Table:
 |  | September 30,
 | 2019 | 2018
 |  | (in thousands)
Deferred tax assets: |  | 
Accrued employee benefits | $ 11,409 | $ 8,285
Allowances for loss contingencies | 3,561 | 3,518
Deferred compensation | 3,071 | 3,272
Intangible assets | — | 1,361
Inventory valuation | 8,036 | 1,154
Long-term contracts | 6,995 | 7,751
Prepaid and accrued expenses | 1,816 | 1,229
Retirement benefits | 4,967 | 1,398
Tax credit carryforwards | 33,118 | 35,137
Loss carryforwards | 36,248 | 29,097
Other | 818 | 264
Total gross deferred tax assets | 110,039 | 92,466
Valuation allowance | (69,098) | (81,838)
Total deferred tax assets | 40,941 | 10,628
Deferred tax liabilities: |  | 
Debt obligation basis difference | (4,582) | —
Deferred revenue | (12,135) | (2,351)
Intangible assets | (18,592) | —
Property, plant and equipment | (4,524) | (5,079)
Unremitted earnings | (977) | (823)
Other | (587) | (351)
Total deferred tax liabilities | (41,397) | (8,604)
Net deferred tax asset (liability) | $ (456) | $ 2,024


Question: What is the change in the amount of prepaid and accrued expenses from 2018 to 2019?
Answer: 587
Calculation: 1,816-1,229
eog resources , inc . supplemental information to consolidated financial statements ( continued ) capitalized costs relating to oil and gas producing activities . the following table sets forth the capitalized costs relating to eog's crude oil and natural gas producing activities at december 31 , 2018 and 2017: .

Table:
 | 2018 | 2017
proved properties | $ 53624809 | $ 48845672
unproved properties | 3705207 | 3710069
total | 57330016 | 52555741
accumulated depreciation depletion and amortization | -31674085 ( 31674085 ) | -29191247 ( 29191247 )
net capitalized costs | $ 25655931 | $ 23364494
costs incurred in oil and gas property acquisition , exploration and development activities .
the acquisition , exploration and development costs disclosed in the following tables are in accordance with definitions in the extractive industries - oil and gas topic of the accounting standards codification ( asc ) .
acquisition costs include costs incurred to purchase , lease or otherwise acquire property .
exploration costs include additions to exploratory wells , including those in progress , and exploration expenses .
development costs include additions to production facilities and equipment and additions to development wells , including those in progress. .

Question: considering the years 2017 and 2018 , what was the increase observed in the net capitalized costs?
Answer: 9.80%
Calculation: divide(25655931, 23364494), subtract(#0, const_1)
During the year, we passed an additional 12,400 addresses in the Greater Cincinnati area with Fioptics, which included a focus on Fiber to the Premise ("FTTP") addresses as FTTP has become a more relevant solution for our customers. As of December 31, 2019, the Fioptics products are now available to approximately 623,400 customer locations or 75% of the Greater Cincinnati operating territory. During 2019, we passed an additional 5,900 addresses in Hawaii.  The Consumer/SMB Fiber products are now available to approximately 246,400 addresses, or 50% of the operating territory in Hawaii, including Oahu and the neighbor islands
In 2019, the Company also invested $24.0 million in Enterprise Fiber products, which includes fiber and IP-ased core network technology.  These investments position the Company to meet increased business and carrier demand within Greater Cincinnati and in contiguous markets in the Midwest region.  In Hawaii, expenditures are for high-bandwidth data transport products, such as metro-ethernet, including the Southeast Asia to United States ("SEA-US") cable.  We continue to evolve and optimize network assets to support the migration of legacy products to new technology, and as of December 31, 2019, the Company has:
increased the total number of commercial addresses with fiber-based services (referred to as a lit address) to 28,800 in Greater Cincinnati and 20,300 in Hawaii by connecting approximately 2,200 additional lit addresses in Greater Cincinnati and 1,200 additional lit addresses in Hawaii during the twelve months ended December 31, 2019;
expanded the fiber network to span more than 12,500 route miles in Greater Cincinnati and 4,700 route miles in Hawaii; and
provided cell site back-haul services to approximately 90% of the 1,000 cell sites in the Greater Cincinnati market, of which approximately 97% of these sites are lit with fiber, and 80% of the 1,100 cell sites in Hawaii, all of which are lit with fiber.
As a result of our investments, we have generated year-over-year Entertainment and Communications revenue growth each year since 2013.  The Company's expanding fiber assets allow us to support the ever-increasing demand for data, video and internet devices with speed, agility and security.  We believe our fiber investments are a long-term solution for our customers' bandwidth needs
Table:
Hawaii Operating Territory | 2018 | 2019
Consumer / SMB Fiber Revenue (in millions): | $87.2 | $42.3
Subscribers (in thousands): |  | 
High-speed internet | 68.2 | 65.9
Video | 42.7 | 48.8
Voice | 30.0 | 30.3


Question: When did the company start enjoying year on year  Entertainment and Communications revenue growth?
Answer: 2013
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 percentage change in Net sales between Three Months Ended  September and December in 2019?
Answer: 1.49
Calculation: ( $115,787 - $114,092 )/ $114,092
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
NOTE 20 — Geographic Data
Financial information relating to our operations by geographic area were as follows:
Sales are attributed to countries based upon the origin of the sale.
Table:
 |  | Years Ended December 31, | 
Net Sales | 2019 | 2018 | 2017
United States | $279,904 | $313,489 | $287,092
Singapore | 32,957 | 6,724 | 5,596
Taiwan | 19,810 | 20,802 | 18,586
China | 87,342 | 79,380 | 66,510
Czech Republic | 33,214 | 36,528 | 34,476
Other non-U.S. | 15,772 | 13,560 | 10,733
Consolidated net sales | $468,999 | $470,483 | $422,993


Question: Which years does the table provide information relating to the company's operations by geographic area?
Answer: 2019, 2018, 2017
Operating Activities
Net cash provided by operating activities in fiscal 2019 was primarily attributable to net income of $39.3 million, which included $89.9 million of net non-cash items, offset by changes in operating assets and liabilities using $8.2 million of cash as discussed in more detail below. Accounts receivable increased $2.6 million to $97.9 million at December 28, 2019 compared to $95.3 million at December 29, 2018 as a result of strong collections despite increased revenues and changes in payment terms related to customer mix.
Inventories, net, increased $5.6 million to $83.3 million at December 28, 2019 compared to $77.7 million at December 29, 2018 as a result of higher sales volumes, partially offset by a $10.4 million increase to our provision for excess and obsolete inventories. Accrued liabilities increased $8.7 million to $36.4 million at December 28, 2019 compared to $27.7 million at December 29, 2018, as a result of an increase in employee performance-based compensation and benefits and an increase in accrued income taxes due to timing of payments.
Accounts payable increased $0.9 million to $40.9 million at December 28, 2019 compared to $40.0 million at December 29, 2018, as a result of higher volumes mostly offset by the impact of timing of vendor payments.
Investing Activities
Net cash used in investing activities in fiscal 2019 primarily related to $20.8 million of cash used in the acquisition of property, plant and equipment, $20.5 million paid (net of cash acquired) as part of the consideration for the acquisition of FRT, and $25.1 million used for the purchase of marketable securities, net of maturities.
Financing Activities
Net cash used in financing activities in fiscal 2019 primarily related to $30.0 million of principal payments made towards the repayment of our term loan and $8.0 million related to tax withholdings associated with the net share settlements of our equity awards, largely offset by $23.4 million of proceeds from a term loan to fund the acquisition of FRT and $8.1 million of proceeds received from issuances of common stock under our stock incentive plans.
Table:
 |  | Fiscal Year Ended | 
 | December 28, 2019 | December 29, 2018 | December 30, 2017
 |  | (Dollars in thousands) | 
Net cash provided by operating activities | $121,048 | $68,700 | $86,323
Net cash used in investing activities | (66,352) | (21,295) | (59,425)
Net cash used in financing activities | $(6,578) | $(39,329) | $(39,470)


Question: What was the Net cash used in investing activities in 2019, 2018 and 2017 respectively?
Answer: (66,352), (21,295), (59,425)
34| | duke realty corporation annual report 2009 property investment we evaluate development and acquisition opportunities based upon market outlook , supply and long-term growth potential . our ability to make future property investments is dependent upon our continued access to our longer-term sources of liquidity including the issuances of debt or equity securities as well as generating cash flow by disposing of selected properties . in light of current economic conditions , management continues to evaluate our investment priorities and is focused on accretive growth . we have continued to operate at a substantially reduced level of new development activity , as compared to recent years , and are focused on the core operations of our existing base of properties . recurring expenditures one of our principal uses of our liquidity is to fund the recurring leasing/capital expenditures of our real estate investments . the following is a summary of our recurring capital expenditures for the years ended december 31 , 2009 , 2008 and 2007 , respectively ( in thousands ) : dividends and distributions we are required to meet the distribution requirements of the internal revenue code of 1986 , as amended ( the 201ccode 201d ) , in order to maintain our reit status . because depreciation and impairments are non-cash expenses , cash flow will typically be greater than operating income . we paid dividends per share of $ 0.76 , $ 1.93 and $ 1.91 for the years ended december 31 , 2009 , 2008 and 2007 , respectively . we expect to continue to distribute at least an amount equal to our taxable earnings , to meet the requirements to maintain our reit status , and additional amounts as determined by our board of directors . distributions are declared at the discretion of our board of directors and are subject to actual cash available for distribution , our financial condition , capital requirements and such other factors as our board of directors deems relevant . at december 31 , 2009 we had six series of preferred shares outstanding . the annual dividend rates on our preferred shares range between 6.5% ( 6.5 % ) and 8.375% ( 8.375 % ) and are paid in arrears quarterly. .

Table:
 | 2009 | 2008 | 2007
recurring tenant improvements | $ 29321 | $ 36885 | $ 45296
recurring leasing costs | 40412 | 28205 | 32238
building improvements | 9321 | 9724 | 8402
totals | $ 79054 | $ 74814 | $ 85936
.

Question: what was the percent of the increase in the dividend from 2007 to 2008
Answer: 1%
Calculation: subtract(1.93, 1.91), divide(#0, 1.91)
Revenues
Revenues for our reportable segments were as follows:
The increase in Semiconductor Test revenues of $60.2 million, or 4%, from 2018 to 2019 was driven primarily by an increase in semiconductor tester sales for 5G infrastructure and image sensors and higher service revenue, partially offset by a decrease in sales in the automotive and analog test segments.
The increase in Industrial Automation revenues of $36.6 million, or 14%, from 2018 to 2019 was primarily due to higher demand for collaborative robots. The MiR acquisition was completed in April 2018.
The increase in System Test revenues of $71.4 million, or 33%, from 2018 to 2019 was primarily due to higher sales in Storage Test of 3.5” hard disk drive testers, higher sales in Defense/Aerospace test instrumentation and systems, and higher sales in Production Board Test from higher 5G demand.
The increase in Wireless Test revenues of $25.3 million, or 19%, from 2018 to 2019 was primarily due to higher demand for millimeter wave and cellular test products driven by new wireless standards and 5G, partially offset by lower sales in connectivity test products and services.
Table:
 | 2019 | 2018 | 2018-2019 Dollar Change
 |  | (in millions) | 
Semiconductor Test | $1,552.6 | $1,492.4 | $60.2
Industrial Automation | 298.1 | 261.5 | 36.6
System Test | 287.5 | 216.1 | 71.4
Wireless Test | 157.3 | 132.0 | 25.3
Corporate and Other | (0.5) | (1.2) | 0.7
 | $2,295.0 | $2,100.8 | $194.2


Question: In which year was Wireless Test larger?
Answer: 2019
Calculation: 157.3>132.0
Operating profit
Notes
1. Before exceptional items, acquisition related costs, acquired intangible asset amortisation and share-based payment amounting to $4.3 million in total (2018 $19.6 million).
2. Adjusted operating profit as a percentage of revenue in the period.
Adjusted operating profit increased by $15.8 million or 20.5 per cent to $92.9 million in 2019, compared with $77.1 million in 2018. Adjusted operating margin increased by 2.2 per cent to 18.4 per cent, from 16.2 per cent in 2018.
Reported operating profit was up by $31.1 million or 54.1 per cent to $88.6 million (2018 $57.5 million). Total adjusting items were lower in 2019 at $4.3 million, compared to $19.6 million in 2018, mainly due to exceptional items totalling $13.1 million charged last year (see below).
Table:
$ million | 2019 | Adjusted operating margin 1, 2 % | 2018 | Adjusted operating margin 1, 2 %
Networks & Security | 73.9 | 23.1 | 56.4 | 19.8
Lifecycle Service Assurance | 18.1 | 16.3 | 17.4 | 15.4
Connected Devices | 9.5 | 13.1 | 10.5 | 13.3
Corporate | (8.6) |  | (7.2) | 
Adjusted operating profit1 | 92.9 | 18.4 | 77.1 | 16.2
Exceptional items | 0.5 |  | (13.1) | 
Acquisition related costs | (0.1) |  | – | 
Acquired intangible asset amortisation | (1.2) |  | (3.7) | 
Share-based payment | (3.5) |  | (2.8) | 
Reported operating profit | 88.6 |  | 57.5 | 


Question: What was the adjusted operating margin in 2018?
Answer: 16.2 per cent
Contract Balances
A contract asset will be recorded if we have recognized revenue but do not have an unconditional right to the related consideration from the customer. For example, this will be the case if implementation services offered in a cloud arrangement are identified as a separate performance obligation and are provided to a customer prior to us being able to bill the customer. In addition, a contract asset may arise in relation to subscription licenses if the license revenue that is recognized upfront exceeds the amount that we are able to invoice the customer at that time. Contract assets are reclassified to accounts receivable when the rights become unconditional.
The balance for our contract assets and contract liabilities (i.e. deferred revenues) for the periods indicated below were as follows:
The difference in the opening and closing balances of our contract assets and deferred revenues primarily results from the timing difference between our performance and the customer’s payments. We fulfill our obligations under a contract with a customer by transferring products and services in exchange for consideration from the customer. During the year ended June 30, 2019, we reclassified $19.2 million of contract assets to receivables as a result of the right to the transaction consideration becoming unconditional. During the year ended June 30, 2019, there was no significant impairment loss recognized related to contract assets.
We recognize deferred revenue when we have received consideration or an amount of consideration is due from the customer for future obligations to transfer products or services. Our deferred revenues primarily relate to customer support agreements which have been paid for by customers prior to the performance of those services. The amount of revenue that was recognized during the year ended June 30, 2019 that was included in the deferred revenue balances at July 1, 2018 was approximately $617 million.
Table:
 | As of June 30, 2019 | As of July 1, 2018
Short-term contract assets | $20,956 | $5,474
Long-term contract assets | $15,386 | $12,382
Short-term deferred revenue | $641,656 | $618,197
Long-term deferred revenue | $46,974 | $64,743


Question: When was $19.2 million of contract assets to receivables as a result of the right to the transaction consideration becoming unconditional reclassified?
Answer: year ended June 30, 2019