hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Commitments and Significant Contractual Obligations
The following table summarizes our contractual obligations and commercial commitments at December 27, 2019:
(1) Interest on our various outstanding debt instruments is included in the above table, except for our Term Loan and ABL, which have floating interest rates. At December 27, 2019, we had borrowings of $238.1 million under our Term Loan and zero under our ABL. During the fiscal year ended December 27, 2019, the weighted average interest rate on our Term Loan was approximately 5.8% and we incurred interest expense of approximately $13.9 million. During the fiscal year ended December 27, 2019, the weighted average interest rate on our ABL borrowings was approximately 3.7% and we incurred interest expense of approximately $1.6 million. See Note 9 “Debt Obligations” to our consolidated financial statements for further information on our debt instruments.
(2) The table above excludes cash to be paid for income taxes, $14.7 million of total contingent earn-out liabilities related to certain acquisitions as of December 27, 2019 and approximately $5.3 million of lease payments related to long-term leases for several vehicles and a distribution and processing facility that do not commence until fiscal 2020.
We had outstanding letters of credit of approximately $16.6 million and $15.8 million at December 27, 2019 and December 28, 2018, respectively. Substantially all of our assets are pledged as collateral to secure our borrowings under our credit facilities.
Table:
 |  |  | Payments Due by Period (1, 2) |  | 
 | Total  | Less than One Year | 1-3 Years | 4-5 Years | Thereafter
 |  |  | (In thousands) |  | 
Inventory purchase commitments | $53,413 | $53,413 | $— | $— | $—
Indebtedness | $406,644 | $2,993 | $244,151 | $159,500 | $—
Finance lease obligations  | $4,597 | $880 | $1,715 | $1,392 | $610
Pension exit liabilities  | $2,169 | $149 | $329 | $375 | $1,316
Long-term operating leases  | $197,359 | $25,662 | $43,130 | $30,080 | $98,487
Total  | $664,182 | $83,097 | $289,325 | $191,347 | $100,413


Question: What is the total Inventory purchase commitments for all periods?
Answer: $53,413
As described in Note 7, the acquisition of Norstel resulted in the recognition of $43 million in goodwill which has been included in the ADG segment to align the goodwill of the acquired Company with the segment under which the related activities will be reported.
As of the end of the third quarters of 2019 and 2018, the Company performed its annual impairment test. The Company did not elect to perform a qualitative assessment. The impairment test was conducted following a two-step process. In the first step, the Company compared the fair value of the reporting units tested to their carrying value. Based upon the first step of the goodwill impairment test, no impairment was recorded since the fair value of the reporting units exceeded their carrying value.
Goodwill as at December 31, 2019 and 2018 is net of accumulated impairment losses of $102 million, of which $96 million relates to the MDG segment and $6 million to Others. In 2019, 2018 and 2017, no impairment loss was recorded by the Company.
Table:
 | Automotive and Discrete Group (ADG) | Microcontrollers and Digital ICs Group (MDG) | Analog, MEMS & Sensors Group AMS) | Total
December 31, 2017 | — | 121 | 2 | 123
Foreign currency translation | — | (2) | — | (2)
December 31, 2018 | — | 119 | 2 | 121
Business combination | 43 | — | — | 43
Foreign currency translation | — | (2) | — | (2)
December 31, 2019 | 43 | 117 | 2 | 162


Question: What is the average goodwill for the period December 31, 2019?
Answer: 54
Calculation: 162/ 3
Changes in parameters on the basis of actuarial calculations led to a total increase in the present value of defined benefit obligations by €247 million (2017/18: €−24 million). Most of the effects result from the reduction of the applied invoice rates.
The weighted average term of defined benefit commitments for the countries with material pension obligations amounts to:
Table:
Years | 30/9/2018 | 30/9/2019
Germany | 16 | 16
Netherlands | 22 | 24
United Kingdom | 18 | 18
Belgium | 4 | 6
Other countries | 11 | 11


Question: What are the changes in parameter based on?
Answer: on the basis of actuarial calculations
We recorded non-cash compensation expense related to stock-based awards as follows (in thousands):
As of September 30, 2019, there was $39.7 million of unrecognized compensation expense related to unvested RSUs. Based upon the expected forfeitures and the expected vesting of performance-based RSUs, the aggregate fair value of RSUs expected to ultimately vest is $40.0 million, which is expected to be recognized over a weighted-average period of 1.7 years and includes the RSUs that vested on October 1, 2019.
We estimate forfeitures at the time of grant and revise those estimates in subsequent periods on a cumulative basis in the period the estimated forfeiture rate changes for all stock-based awards when significant events occur. We consider our historical experience with employee turnover as the basis to arrive at our estimated forfeiture rate. The forfeiture rate was estimated to be 12.5% per year as of September 30, 2019. To the extent the actual forfeiture rate is different from what we have estimated, compensation expense related to these awards will be different from our expectations.
Table:
 |  | Years Ended September 30, | 
 | 2019 | 2018 | 2017
Cost of sales | $  1,766 | $  1,096 | $  338
Selling, general and administrative | 13,722 | 6,419 | 4,674
 | $15,488 | $7,515 | $5,012


Question: What was the forfeiture rate estimated to be?
Answer: 12.5% per year as of September 30, 2019
Short-term borrowings and current portion of long-term obligations consist of the following (in thousands):
(1) Net of debt issuance costs of $4.6 million and $4.7 million at September 28, 2019 and September 29, 2018, respectively.
Table:
 | Fiscal year-end | 
 | 2019 | 2018
Current portion of Euro Term Loan(1) | $2,748 | $3,092
1.3% Term loan due 2024 | 1,367 | 1,448
1.0% State of Connecticut term loan due 2023 | 378 | 374
Capital lease obligations | 370 | 158
Line of credit borrowings | 10,000 | —
Total current portion of long-term obligations | $14,863 | $5,072


Question: What was the change in Capital lease obligations from 2018 to 2019?
Answer: 212
Calculation: 370-158
REVENUE
(1) For the three-month period ended August 31, 2019, the average foreign exchange rate used for translation was 1.3222 USD/CDN.
(2) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy as well as to reclassify results from Cogeco Peer 1 as discontinued operations. For further details, please consult the "Accounting policies" and "Discontinued operations" sections.
(3) Fiscal 2019 actuals are translated at the average foreign exchange rate of the comparable period of fiscal 2018 which was 1.3100 USD/CDN.
Fiscal 2019 fourth-quarter revenue increased by 3.1% (2.7% in constant currency) resulting from: • growth in the American broadband services segment mainly due to strong organic growth and the FiberLight acquisition. • stable revenue in the Canadian broadband services segment mainly as a result of: ◦ rate increases; partly offset by ◦ decreases in video and telephony services customers compared to the same period of the prior year primarily due to issues resulting from the implementation of a new customer management system in the second half of fiscal 2018.
Table:
Three months ended August 31, | 2019 (1) | 2018 (2) | Change | Change in constant currency (3) | Foreign exchange impact (3)
(in thousands of dollars, except percentages) | $ | $ | % | % | $ $
Canadian broadband services | 319,935 | 319,741 | 0.1 | 0.1 | -
American broadband services | 263,738 | 246,443 | 7.0 | 6.0 | 2,427
 | 583,673 | 566,184 | 3.1 | 2.7 | 2,427


Question: What was the average Canadian broadband services from 2018 to 2019?
Answer: 319838
Calculation: (319,935 + 319,741) / 2
Note 11. Other Current Assets
Other current assets consisted of the following (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Investments held in rabbi trust | $13,927 | $11,442
Financial derivatives | 3,373 | 1,078
Deferred rent | 558 | 1,867
Other current assets | 2,667 | 2,374
 | $20,525 | $16,761


Question: What was the amount of deferred rent in 2019?
Answer: 558
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
3. PROPERTY AND EQUIPMENT
Property and equipment (including assets held under finance leases) consisted of the following:
(1) Assets on leased land are depreciated over the shorter of the estimated useful life of the asset or the term of the corresponding ground lease taking into consideration lease renewal options and residual value.
(2) Includes fiber and DAS assets.
(3) Estimated useful lives apply to improvements only.
Table:
 | Estimated Useful Lives (years) (1) | December 31, 2019 | December 31, 2018
Towers | Up to 20 | $13,930.7 | $12,777.9
Equipment (2) | 2 - 20 | 1,897.3 | 1,667.3
Buildings and improvements | 3 - 32 | 638.9 | 628.5
Land and improvements (3) | Up to 20 | 2,486.1 | 2,285.4
Construction-in-progress |  | 372.6 | 358.1
Total |  | 19,325.6 | 17,717.2
Less accumulated depreciation |  | (7,241.2) | (6,470.1)
Property and equipment, net |  | $12,084.4 | $11,247.1


Question: What was the value of Equipment in 2018?
Answer: 1,667.3
Our common shares are not a direct investment of our pension funds; however, the pension funds may indirectly include our shares. The aggregate amount of our common shares would not be considered material relative to the total pension fund assets.
Our funding policy is to make contributions in accordance with the laws and customs of the various countries in which we operate as well as to make discretionary voluntary contributions from time to time. We expect to make the minimum required contributions of $42 million and $26 million to our non-U.S. and U.S. pension plans, respectively, in fiscal 2020. We may also make voluntary contributions at our discretion.
At fiscal year end 2019, benefit payments, which reflect future expected service, as appropriate, are expected to be
paid as follows:
Table:
 | Non-U.S. Plans | U.S. Plans
 |  | (in millions)
Fiscal 2020 | $  82 | $  77
Fiscal 2021 | 77 | 74
Fiscal 2022 | 81 | 74
Fiscal 2023 | 85 | 74
Fiscal 2024 | 86 | 74
Fiscal 2025-2029 | 490 | 361


Question: How much minimum required contributions is expected to be made to the non-U.S. pension plan?
Answer: $42 million
(4) Goodwill, Customer Relationships and Other Intangible Assets
Goodwill, customer relationships and other intangible assets consisted of the following:
Our goodwill was derived from numerous acquisitions where the purchase price exceeded the fair value of the net assets acquired (including the acquisition described in Note 2—Acquisition of Level 3). As of December 31, 2019, the weighted average remaining useful lives of the intangible assets were approximately 8 years in total, approximately 9 years for customer relationships, 4 years for capitalized software and 3 years for trade names.
Total amortization expense for intangible assets for the years ended December 31, 2019, 2018 and 2017 was $1.7 billion, $1.8 billion and $1.2 billion, respectively. As of December 31, 2019, the gross carrying amount of goodwill, customer relationships, indefinite-life and other intangible assets was $44.0 billion.
Table:
 | As of December 31 | 
 | 2019 | 2018
 | (Dollars in million) | 
Goodwill | $21,534 | 28,031
Customer relationships, less accumulated amortization of $9,809 and $8,492 | $7,596 | 8,911
Indefinite-life intangible assets | $269 | 269
Other intangible assets subject to amortization: |  | 
Capitalized software, less accumulated amortization of $2,957 and $2,616 | $1,599 | 1,468
Trade names, less accumulated amortization of $91 and $61 | 103 | 131
Total other intangible assets, net | $1,971 | 1,868


Question: Which item has the longest weighted average remaining useful life?
Answer: Customer relationships
Calculation: 9>8>4>3
Note 9 Earnings per share
The following table shows the components used in the calculation of basic and diluted earnings per common share for earnings attributable to common shareholders.
(1) The calculation of the assumed exercise of stock options includes the effect of the average unrecognized future compensation cost of dilutive options. It excludes options for which the exercise price is higher than the average market value of a BCE common share. The number of excluded options was 61,170 in 2019 and 12,252,594 in 2018.
Table:
FOR THE YEAR ENDED DECEMBER 31 | 2019 | 2018
Net earnings attributable to common shareholders – basic | 3,040 | 2,785
Dividends declared per common share (in dollars) | 3.17 | 3.02
Weighted average number of common shares outstanding (in millions) |  | 
Weighted average number of common shares outstanding – basic | 900.8 | 898.6
Assumed exercise of stock options (1) | 0.6 | 0.3
Weighted average number of common shares outstanding – diluted (in millions) | 901.4 | 898.9


Question: What is the Net earnings attributable to common shareholders – basic for 2019?
Answer: 3,040
23. Associates (Cont'd)
The summarised financial information of the Group’s significant associate namely Intouch Holdings Public Company Limited (“Intouch”), based on its financial statements and a reconciliation with the carrying amount of the investment in the consolidated financial statements was as follows –
Note: (1) Others include adjustments to align the respective local accounting standards to SFRS(I).
Table:
 | 2019 | 2018 | 2017
 | S$ Mil | S$ Mil | S$ Mil
Statement of comprehensive income |  |  | 
Revenue | 250.1 | 353.9 | 144.1
Profit after tax | 451.7 | 488.2 | 166.1
Other comprehensive (loss)/ income | (0.9) | 10.9 | (1.6)
Total comprehensive income | 450.8 | 499.1 | 164.5
Statement of financial position |  |  | 
Current assets | 743.1 | 720.0 | 701.9
Non-current assets | 1,532.5 | 1,554.3 | 1,629.3
Current liabilities | (305.1) | (444.4) | (483.6)
Non-current liabilities | (205.5) | (313.4) | (395.3)
Net assets | 1,765.0 | 1,516.5 | 1,452.3
Less: Non-controlling interests | (304.6) | (342.2) | (411.6)
Net assets attributable to equity holders | 1,460.4 | 1,174.3 | 1,040.7
Proportion of the Group’s ownership | 21.0% | 21.0% | 21.0%
Group’s share of net assets | 306.7 | 246.6 | 218.5
Goodwill and other identifiable intangible assets | 1,441.7 | 1,417.6 | 1,371.7
Others (1) | (46.8) | (23.0) | (8.4)
Carrying amount of the investment | 1,701.6 | 1,641.2 | 1,581.8
Other items |  |  | 
Group’s share of market value | 1,653.2 | 1,639.6 | 1,525.0
Dividends received during the year | 78.5 | 77.8 | -


Question: What other information is provided other than financial information from the statement of comprehensive income and statement of financial position?
Answer: Group’s share of market value, Dividends received during the year
Minimising our environmental impact
During FY19 we have undertaken energy audits across all our UK manufacturing sites as part of our Energy Savings Opportunity Scheme (‘ESOS’) compliance programme, which is a mandatory energy assessment scheme for UK organisations. Our progress on energy efficiency improvements remains good, and we have delivered a further 4.9% improvement in our primary energy per tonne of product against last year, and 26.5% over the last six years.
Table:
Category | Destination | FY19 |  | FY18 | 
 |  | Tonnes | % of production | Tonnes | % of production
 | Redistribution for human consumption | 950 | 0.3% | 791 | 0.2%
Waste avoided | Animal feed | 4,454 | 1.2% | 4,895 | 1.3%
 | Total | 5,404 | 1.5% | 5,686 | 1.5%
 | Co/Anaerobic digestion | 24,978 | 6.6% | 32,202 | 8.3%
Food waste | Controlled combustion | 1,650 | 0.4% | 1,964 | 0.5%
 | Sewer | 8,280 | 2.2% | 6,746 | 1.7%
 | Total | 34,908 | 9.2% | 40,912 | 10.5%


Question: What is the average controlled combustion food waste for FY18 and FY19?
Answer: 1807
Calculation: (1,650 + 1,964) / 2
Inventory
Inventory is stated at the lower of cost and net realizable value, using the first-in, first-out (“FIFO”) valuation method. Net realizable value is the estimated selling prices in the ordinary course of business, less reasonably predictable costs of completion, disposal, and transportation. Any adjustments to reduce the cost of inventories to their net realizable value are recognized in earnings in the current period.
Due to the low sell-through of our AirBar products, management has decided to fully reserve work-in-process for AirBar components, as well as AirBar related raw materials. Management has further decided to reserve for a portion of AirBar finished goods, depending on type of AirBar and in which location it is stored. The AirBar inventory reserve was $0.8 million and $1.0 million for the years ended December 31, 2019 and 2018, respectively.
In order to protect our manufacturing partners from losses in relation to AirBar production, we agreed to secure the value of the inventory with a bank guarantee. Since the sale of AirBars has been lower than expected, a major part of the inventory at the partner remained unused when the due date of the bank guarantee neared and Neonode therefore agreed that the partner should keep inventory for the production of 20,000 AirBars and the rest be purchased by us. The inventory value of these purchases has been fully reserved.
As of December 31, 2019, the Company’s inventory consists primarily of components that will be used in the manufacturing of our sensor modules. We segregate inventory for reporting purposes by raw materials, work-in-process, and finished goods.
Raw materials, work-in-process, and finished goods are as follows (in thousands):
Table:
 | December 31, | December 31,
 | 2019 | 2018
Raw materials | $396 | $246
Work-in-process | 186 | 220
Finished goods | 448 | 753
Ending inventory | $1,030 | $1,219


Question: What kind of method is used to measure the inventory?
Answer: the first-in, first-out (“FIFO”) valuation method
item 2 : properties information concerning applied 2019s properties is set forth below: .

Table:
( square feet in thousands ) | united states | other countries | total
owned | 4530 | 2417 | 6947
leased | 1037 | 1341 | 2378
total | 5567 | 3758 | 9325
because of the interrelation of applied 2019s operations , properties within a country may be shared by the segments operating within that country .
the company 2019s headquarters offices are in santa clara , california .
products in semiconductor systems are manufactured in santa clara , california ; austin , texas ; gloucester , massachusetts ; kalispell , montana ; rehovot , israel ; and singapore .
remanufactured equipment products in the applied global services segment are produced primarily in austin , texas .
products in the display and adjacent markets segment are manufactured in alzenau , germany and tainan , taiwan .
other products are manufactured in treviso , italy .
applied also owns and leases offices , plants and warehouse locations in many locations throughout the world , including in europe , japan , north america ( principally the united states ) , israel , china , india , korea , southeast asia and taiwan .
these facilities are principally used for manufacturing ; research , development and engineering ; and marketing , sales and customer support .
applied also owns a total of approximately 269 acres of buildable land in montana , texas , california , israel and italy that could accommodate additional building space .
applied considers the properties that it owns or leases as adequate to meet its current and future requirements .
applied regularly assesses the size , capability and location of its global infrastructure and periodically makes adjustments based on these assessments. .

Question: what portion of total company used area is company owned?
Answer: 74.5%
Calculation: divide(6947, 9325)
AMERICAN TOWER CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(Tabular amounts in millions, unless otherwise disclosed)
At December 31, 2019, the Company had net federal, state and foreign operating loss carryforwards available to reduce future taxable income. If not utilized, the Company’s NOLs expire as follows:
Table:
Years ended December 31, | Federal | State | Foreign
2020 to 2024 | $— | $222.3 | $11.9
2025 to 2029 | 141.6 | 285.7 | 104.8
2030 to 2034 | 7.0 | 41.4 | 19.6
2035 to 2039 | 3.6 | 159.5 | —
Indefinite carryforward | 22.8 | — | 853.8
Total | $175.0 | $708.9 | $990.1


Question: What was the company's Foreign NOLs expiring in 2030 to 2034?
Answer: 19.6
acquisition date ) . realex is a leading european online payment gateway technology provider . this acquisition furthered our strategy to provide omnichannel solutions that combine gateway services , payment service provisioning and payment technology services across europe . this transaction was accounted for as a business combination . we recorded the assets acquired , liabilities assumed and noncontrolling interest at their estimated fair values as of the acquisition date . on october 5 , 2015 , we paid 20ac6.7 million ( $ 7.5 million equivalent as of october 5 , 2015 ) to acquire the remaining shares of realex , after which we own 100% ( 100 % ) of the outstanding shares . the estimated acquisition date fair values of the assets acquired , liabilities assumed and the noncontrolling interest , including a reconciliation to the total purchase consideration , are as follows ( in thousands ) : .

Table:
cash | $ 4082
customer-related intangible assets | 16079
acquired technology | 39820
trade name | 3453
other intangible assets | 399
other assets | 6213
liabilities | -3479 ( 3479 )
deferred income tax liabilities | -7216 ( 7216 )
total identifiable net assets | 59351
goodwill | 66809
noncontrolling interest | -7280 ( 7280 )
total purchase consideration | $ 118880
goodwill of $ 66.8 million arising from the acquisition , included in the europe segment , was attributable to expected growth opportunities in europe , potential synergies from combining our existing business with gateway services and payment service provisioning in certain markets and an assembled workforce to support the newly acquired technology .
goodwill associated with this acquisition is not deductible for income tax purposes .
the customer-related intangible assets have an estimated amortization period of 16 years .
the acquired technology has an estimated amortization of 10 years .
the trade name has an estimated amortization period of 7 years .
ezidebit on october 10 , 2014 , we completed the acquisition of 100% ( 100 % ) of the outstanding stock of ezi holdings pty ltd ( 201cezidebit 201d ) for aud302.6 million in cash ( $ 266.0 million equivalent as of the acquisition date ) .
this acquisition was funded by a combination of cash on hand and borrowings on our revolving credit facility .
ezidebit is a leading integrated payments company focused on recurring payments verticals in australia and new zealand .
the acquisition of ezidebit further enhanced our existing integrated solutions offerings .
this transaction was accounted for as a business combination .
we recorded the assets acquired and liabilities assumed at their estimated fair values as of the acquisition date .
76 2013 global payments inc .
| 2017 form 10-k annual report .

Question: what percentage of the total purchase consideration did the trade name represent?
Answer: 3%
Calculation: divide(3453, 118880)