hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
30. RECONCILIATION OF LIABILITIES FROM FINANCING ACTIVITIES (Cont’d)
Note: (1) The cash flows comprise the net amount of proceeds from borrowings and repayments of borrowings, net interest paid on borrowings, and settlement of swaps for bonds repaid in the statement of cash flows.
Table:
 | Bonds | Bank loans | Finance lease liabilities | Interest payable | Derivative financial instruments
Group - 2018 | S$ Mil | S$ Mil | S$ Mil | S$ Mil | S$ Mil
As at 1 April 2017 | 8,726.6 | 2,306.3 | 198.2 | 142.7 | (245.3)
Financing cash flows (1) | (506.2) | 222.6 | (28.3) | (379.9) | 61.4
Non-cash changes: |  |  |  |  | 
Fair value adjustments | (65.4) | - | - | - | 107.8
Amortisation of bond discount | 3.2 | - | - | - | -
Foreign exchange movements | (273.3) | (58.5) | (0.5) | (8.5) | 11.5
Acquisition of subsidiary | - | 31.3 | 8.7 | - | 
Additions of finance lease | - | - | 4.8 | - | -
Interest expense | - | - | - | 383.6 | -
Adjustment | - | - | (78.3) | - | -
 | (335.5) | (27.2) | (65.3) | 375.1 | 119.3
As at 31 March 2018 | 7,884.9 | 2,501.7 | 104.6 | 137.9 | (64.6)


Question: What is included in the line item "financing cash flows"?
Answer: The cash flows comprise the net amount of proceeds from borrowings and repayments of borrowings, net interest paid on borrowings, and settlement of swaps for bonds repaid in the statement of cash flows.
Operational Highlights
Altium achieved US$177.2 million in sales (a 23% increase) and US$171.8 million in product revenue (a 23% increase).
The Board and Systems business revenue grew to US$126.8 million with all regions reporting positive results. EMEA grew revenue to US$44.6 million, an increase of 15% and continued the transformation of its business model to direct transactional sales in key markets. The America’s achieved revenue of US$50.9 million which was a 14% growth rate. China results were outstanding with revenue at US$19.8 million, a growth rate of 37%. The Altium focus on our business in China led us to open a new sales office in Beijing and to expand our existing sales centres in Shenzhen and Shanghai. The expansion of our footprint in China will enable us to increase our penetration of the market.
Table:
Consolidated |  |  | 
 | 2019 | 2018 | Change
Product Sales | US$’000 | US$’000 | %
Altium Designer licenses | 65,157 | 53,088 | 23%
Altium Designer subscriptions | 58,959 | 53,701 | 10%
Octopart search advertising | 17,940 | 11,968 | 50%
TASKING licenses | 13,536 | 10,432 | 30%
TASKING maintenance | 8,324 | 4,706 | 67%
Altium Nexus | 6,277 | 3,769 | 67%
Service sales | 3,337 | 4,624 | (28%)
Other | 3,656 | 2,254 | 62%
Total Product Sales | 177,216 | 144,541 | 23%


Question: Which product sales segment had the smallest percentage change from 2018 to 2019?
Answer: Altium Designer subscriptions
Calculation: For COL5 rows 4 to 11 find the smallest absolute value and the corresponding product sale component in COL2
Unrecognized Tax Benefits
We are providing the following disclosures related to our unrecognized tax benefits and the effect on our effective income tax rate if recognized:
In 2019, our unrecognized tax benefit increased by $33.9 million, primarily related to increases in North America. In 2018, we increased our unrecognized tax benefit by $142.1 million, also primarily related to North America.
If the unrecognized tax benefits at December 31, 2019 were recognized, our income tax provision would decrease by $343.5 million, resulting in a substantially lower effective tax rate. Based on the potential outcome of the Company’s global tax examinations and the expiration of the statute of limitations for specific jurisdictions, it is possible that the unrecognized tax benefits could change significantly within the next 12 months. Absent resolution of significant tax controversy, the associated impact on the reserve balance is estimated to be a decrease in the range of $4.6 to $6.6 million during 2020.
We recognize interest and penalties associated with unrecognized tax benefits in our income tax provision in the Consolidated Statements of Operations. Interest and penalties recorded were $13.1 million, negligible and $4.0 million, respectively in 2019, 2018 and 2017. We had gross liabilities, for interest and penalties, of $56.2 million at December 31, 2019, $18.2 million at December 31, 2018 and $14.8 million at December 31, 2017. The increase in the gross liability related to interest and penalties from 2018 to 2019 was primarily due to a reclass within other non-current liabilities from unrecognized tax benefits to interest and penalties which had no impact on the overall Consolidated Balance Sheets or Consolidated Statement of Operations.
The majority of the unrecognized tax benefit amount of $390.3 million relates to North America.
Table:
 |  | Year Ended December 31, | 
(in millions) | 2019 | 2018 | 2017
Beginning balance of unrecognized tax benefits | $ 356.4 | $ 214.3 | $ 162.6
Additions for tax positions of current year | 3.4 | 106.0 | 7.3
Additions for tax positions of prior years | 47.9 | 59.5 | 49.3
Reductions for tax positions of prior years | (16.0) | (7.0) | (4.3)
Reductions for lapses of statutes of limitation and settlements | (1.4) | (16.4) | (0.6)
Ending balance of unrecognized tax benefits | $ 390.3 | $ 356.4 | $ 214.3


Question: What is the Beginning balance of unrecognized tax benefits expressed as a percentage of Ending balance of unrecognized tax benefits for 2019?
Answer: 91.31
Calculation: (356.4/390.3) * 100
NOTE 4. OTHER ASSETS
Goodwill
The carrying amount of goodwill for the fiscal years ended June 30, 2019 and 2018, by reportable segments, is as follows:
Goodwill acquired during fiscal 2019 totaled $17,015, with $12,893 of that resulting from the purchase of BOLTS Technologies, Inc., $3,999 resulting from the purchase of Agiletics, Inc., and the remainder resulting from a measurement period adjustment on the Ensenta valuation. The goodwill arising from these acquisitions consists largely of the growth potential, synergies and economies of scale expected from combining the operations of the Company with those of BOLTS Technologies and Agiletics, together with the value of their assembled workforces. No goodwill was assigned to the Company’s Corporate and Other reportable segment.
Goodwill acquired during fiscal 2018 totaled $97,597, with $91,098 of that resulting from the purchase of Ensenta Corporation, included in the Payments segment. The remaining $6,499 of goodwill acquired during fiscal 2018 resulted from the purchase of Vanguard Software Group, which was added to the Company’s Complementary segment. The goodwill arising from these acquisitions consists largely of the growth potential, synergies and economies of scale expected from combining the operations of the Company with those of Ensenta and Vanguard, together with the value of their assembled workforces. No goodwill was assigned to the Company’s Corporate and Other reportable segment.
The Goodwill reduction during fiscal 2018 was a result of the Company’s sale of jhaDirect product line in the first quarter. Goodwill allocated to the carrying amount of the net assets sold was calculated based on the relative fair values of the business disposed and the portion of the reporting unit that was retained.
Table:
 | June 30, | 
Core | 2019 | 2018
Beginning balance | $195,956 | $195,956
Goodwill, acquired during the year | 4,000 | —
Goodwill, adjustments related to dispositions | — | —
Ending balance | $199,956 | $195,956
Payments |  | 
Beginning balance | $325,204 | $234,106
Goodwill, acquired during the year | 122 | 91,098
Goodwill, adjustments related to dispositions | — | —
Ending balance | $325,326 | $325,204
Complementary |  | 
Beginning balance | $128,769 | $122,403
Goodwill, acquired during the year | 12,893 | 6,499
Goodwill, adjustments related to dispositions | — | (133)
Ending balance | $141,662 | $128,769


Question: How much is the core beginning balance as at June 30, 2019?
Answer: $195,956
Presentation of Derivative Gains (Losses) from Economic Hedges of Forecasted Cash Flows in Segment Results
Derivatives used to manage commodity price risk and foreign currency risk are not designated for hedge accounting treatment. We believe these derivatives provide economic hedges of certain forecasted transactions. As such, these derivatives are generally recognized at fair market value with realized and unrealized gains and losses recognized in general corporate expenses. The gains and losses are subsequently recognized in the operating results of the reporting segments in the period in which the underlying transaction being economically hedged is included in earnings. In the event that management determines a particular derivative entered into as an economic hedge of a forecasted commodity purchase has ceased to function as an economic hedge, we cease recognizing further gains and losses on such derivatives in corporate expense and begin recognizing such gains and losses within segment operating results, immediately.
The following table presents the net derivative gains (losses) from economic hedges of forecasted commodity consumption and the foreign currency risk of certain forecasted transactions associated with continuing operations, under this methodology:
As of May 26, 2019, the cumulative amount of net derivative gains from economic hedges that had been recognized in general corporate expenses and not yet allocated to reporting segments was $1.4 million. This amount reflected net gains of $1.0 million incurred during the fiscal year ended May 26, 2019, as well as net gains of $0.4 million incurred prior to fiscal 2019. Based on our forecasts of the timing of recognition of the underlying hedged items, we expect to reclassify to segment operating results gains of $0.9 million in fiscal 2020 and $0.5 million in fiscal 2021 and thereafter.
Table:
 |  | Fiscal Years Ended | 
($ in millions) | May 26, 2019 | May 27, 2018 | May 28, 2017
Net derivative gains (losses) incurred | $(3.6) | $(0.9) | $0.6
Less: Net derivative gains (losses) allocated to reporting segments | (1.8) | (7.1) | 5.7
Net derivative gains (losses) recognized in general corporate expenses | $(1.8) | $6.2 | $(5.1)
Net derivative gains (losses) allocated to Grocery & Snacks | $(2.1) | $0.2 | $3.4
Net derivative gains (losses) allocated to Refrigerated & Frozen | (1.1) | (0.3) | 0.8
Net derivative gains (losses) allocated to International Foods . | 2.8 | (6.9) | 1.6
Net derivative losses allocated to Foodservice . | (0.6) | (0.1) | —
Net derivative losses allocated to Pinnacle Foods | (0.8) | — | —
Net derivative losses allocated to Commercial . | — | — | (0.1)
Net derivative gains (losses) included in segment operating profit . | $(1.8) | $(7.1) | $5.7


Question: What does the table show?
Answer: the net derivative gains (losses) from economic hedges of forecasted commodity consumption and the foreign currency risk of certain forecasted transactions associated with continuing operations
performance graph the table below compares the cumulative total shareholder return on our common stock with the cumulative total return of ( i ) the standard & poor's 500 composite stock index ( "s&p 500 index" ) , ( ii ) the standard & poor's industrials index ( "s&p industrials index" ) and ( iii ) the standard & poor's consumer durables & apparel index ( "s&p consumer durables & apparel index" ) , from december 31 , 2012 through december 31 , 2017 , when the closing price of our common stock was $ 43.94 . the graph assumes investments of $ 100 on december 31 , 2012 in our common stock and in each of the three indices and the reinvestment of dividends . the table below sets forth the value , as of december 31 for each of the years indicated , of a $ 100 investment made on december 31 , 2012 in each of our common stock , the s&p 500 index , the s&p industrials index and the s&p consumer durables & apparel index and includes the reinvestment of dividends. .

Table:
 | 2013 | 2014 | 2015 | 2016 | 2017
masco | $ 138.48 | $ 155.26 | $ 200.79 | $ 227.08 | $ 318.46
s&p 500 index | $ 132.04 | $ 149.89 | $ 151.94 | $ 169.82 | $ 206.49
s&p industrials index | $ 140.18 | $ 153.73 | $ 149.83 | $ 177.65 | $ 214.55
s&p consumer durables & apparel index | $ 135.84 | $ 148.31 | $ 147.23 | $ 138.82 | $ 164.39
$ 50.00 $ 100.00 $ 150.00 $ 200.00 $ 250.00 $ 300.00 $ 350.00 masco s&p 500 index s&p industrials index s&p consumer durables & apparel index .

Question: what was the percentage of the growth of the s&p 500 index from 2016 to 2017
Answer: 21.6%
Calculation: subtract(206.49, 169.82), divide(#0, 169.82)
Cost of Net Revenue and Gross Profit
Cost of net revenue decreased $26.7 million to $149.5 million for the year ended December 31, 2019, as compared to $176.2 million for the year ended December 31, 2018. The decrease was primarily driven by lower sales. The decrease in gross profit percentage for the year ended December 31, 2019, as compared to the year ended December 31, 2018, was due to lower revenue and product mix.
We currently expect that gross profit percentage will fluctuate in the future, from period-to-period, based on changes in product mix, average selling prices, and average manufacturing costs.
Table:
 | Year Ended December 31, |  | % Change
 | 2019 | 2018 | 2019
 |  | (dollars in thousands) | 
Cost of net revenue | $149,495 | $176,223 | (15)%
% of net revenue | 47% | 46% | 
Gross profit | 167,685 | 208,774 | (20)%
% of net revenue | 53% | 54% | 


Question: What is the average Cost of net revenue, for the Years Ended December 31, 2019 to 2018?
Answer: 162859
Calculation: (149,495+176,223) / 2
Estimated Useful Lives of Computer Software and Other Intangible Assets Acquired
As of the acquisition date, the gross carrying value and weighted average estimated useful lives of Computer software and Other intangible assets acquired during the year ended December 31, 2019 consisted of the following (dollars in millions):
Table:
 | Gross carrying value | Weighted average estimated life (in years)
Computer software | $9.4 | 5
Other intangible assets: |  | 
Client relationships | 19.1 | 10
Trade names | 1.4 | 3
Non-compete agreements | 0.9 | 5
Other intangible assets | 21.4 | 
Total gross carrying value | $30.8 | 


Question: What was the difference in the gross carrying value between Trade Names and Non-compete agreements?
Answer: 0.5
Calculation: 1.4-0.9
part ii item 5 2014market for registrant 2019s common equity and related stockholder matters ( a ) market information . the common stock of the company is currently traded on the new york stock exchange ( nyse ) under the symbol 2018 2018aes 2019 2019 . the following tables set forth the high and low sale prices for the common stock as reported by the nyse for the periods indicated . price range of common stock .

Table:
2001 first quarter | high $ 60.15 | low $ 41.30 | 2000 first quarter | high $ 44.72 | low $ 34.25
second quarter | 52.25 | 39.95 | second quarter | 49.63 | 35.56
third quarter | 44.50 | 12.00 | third quarter | 70.25 | 45.13
fourth quarter | 17.80 | 11.60 | fourth quarter | 72.81 | 45.00
( b ) holders .
as of march 2 , 2002 , there were 9967 record holders of the company 2019s common stock , par value $ 0.01 per share .
( c ) dividends .
under the terms of the company 2019s corporate revolving loan and letters of credit facility of $ 850 million entered into with a commercial bank syndicate and other bank agreements , the company is currently limited in the amount of cash dividends it is allowed to pay .
in addition , the company is precluded from paying cash dividends on its common stock under the terms of a guaranty to the utility customer in connection with the aes thames project in the event certain net worth and liquidity tests of the company are not met .
the company has met these tests at all times since making the guaranty .
the ability of the company 2019s project subsidiaries to declare and pay cash dividends to the company is subject to certain limitations in the project loans , governmental provisions and other agreements entered into by such project subsidiaries .
such limitations permit the payment of cash dividends out of current cash flow for quarterly , semiannual or annual periods only at the end of such periods and only after payment of principal and interest on project loans due at the end of such periods , and in certain cases after providing for debt service reserves. .

Question: what was the difference in the companies high compared to its low sales price for the second quarter of 2001?
Answer: 12.30
Calculation: subtract(52.25, 39.95)
17. Financial Information About Segments
Our operations are divided into two reportable segments: Products and Licensing and Technology Development. The Products and Licensing segment develops and sells products or licenses technologies based on commercially viable concepts developed by the Technology Development segment. The Products and Licensing segment derives its revenue from product sales, funded product development and technology licenses.
Our engineers and scientists collaborate with our network of government, academic and industry experts to identify technologies and ideas with promising market potential. We then compete to win fee-for-service contracts from government agencies and industrial customers who seek innovative solutions to practical problems that require new technology. The Technology Development segment derives its revenue primarily from services. The Technology Development segment provides applied research to customers in our areas of focus.
Our President and Chief Executive Officer and his direct reports collectively represent our chief operating decision makers, and they evaluate segment performance based primarily on revenue and operating income or loss.
Information about the results of operations for each segment is set forth in the table below. There were no significant inter-segment sales during the years ended December 31, 2019 and 2018.
During the years ended December 31, 2019 and 2018, 32% and 24%, respectively, of our total sales took place outside the United States. Customers in China represented 11% of total revenues in the year ended December 31, 2019, while no other single country, outside of the United States, represented more than 10% of total revenues in the year ended December 31, 2018.
Table:
 | Years ended December 31, | 
 | 2019 | 2018
Products and Licensing revenue | $44,491,041 | $21,949,689
Technology Development revenue | 26,024,674 | 20,967,556
Total revenue | $70,515,715 | $42,917,245
Products and Licensing operating income | $1,807,616 | $499,323
Technology Development operating income  | 1,507,405 | 378,212
Total operating income | $3,315,021 | $877,535
Depreciation, Technology Development | $397,296 | $379,952
Depreciation, Products and Licensing  | $552,285 | $273,185
Amortization, Technology Development  | $91,185 | $130,765
Amortization, Products and Licensing | $1,462,525 | $418,349


Question: What was the Products and Licensing revenue in 2019 and 2018 respectively?
Answer: $44,491,041, $21,949,689
4 Expenses
The Group has identified a number of significant expense items below that impacted financial performance for the year:
(a) Finance costs
Included in finance costs are costs related to unsecured notes on issue and interest expense on lease liabilities.
Refer to note 16 for details on unsecured notes on issue and note 12 for details on interest expense on lease liabilities for the year.
(b) Data centre rent paid to APDC
NEXTDC Limited acquired Asia Pacific Data Centre ("APDC") on 18 October 2018 (refer to note 26). Prior to acquisition, APDC was the landlord of three of NEXTDC’s data centre facilities: M1 Melbourne, S1 Sydney and P1 Perth. For the year ended 30 June 2018, NEXTDC paid rent and ancillary amounts to APDC totalling $13.8 million that was included in the Consolidated Statement of Comprehensive Income in Data centre facility costs. On early adoption of AASB 16 from 1 July 2018, this rent ceased to be a Data centre facility cost, and became a depreciation expense and finance cost, until 18 October 2018, when the three leases were derecognised on acquisition.
(c) APDC acquisition costs
A number of acquisition related costs were incurred as a result of the acquisition of APDC. Refer note 26 for further details.
Table:
 |  | 30 June 2019 | 30 June 2018
 | Note | $'000 | $'000
EXPENSE |  |  | 
Finance costs | 4(a) | (54,897) | (25,803)
Data centre rent paid to APDC (included in Data centre facility costs) | 4(b) | - | (13,785)
APDC transaction costs (included in Professional fees) | 4(c) | (5,459) | -
Landholder duty on acquisition of APDC properties (included in Office and administrative expenses) | 4(c) | (3,498) | -


Question: What was the most significant expense in FY18?
Answer: Finance costs
Calculation: (25,803) vs (13,785)
Geographic Revenue
In addition to the revenue presentation by reportable segment, we also measure revenue performance on a geographic basis.
Total revenue of $77,147 million in 2019 decreased 3.1 percent year to year as reported (1 percent adjusted for currency), but increased 0.2 percent excluding divested businesses and adjusted for currency.
Americas revenue decreased 1.9 percent as reported (1 percent adjusted for currency), but grew 1 percent excluding divested businesses and adjusted for currency. Within North America, the U.S. decreased 2.4 percent and Canada increased 4.0 percent as reported (6 percent adjusted for currency). Latin America declined as reported but grew adjusted for currency. Within Latin America, Brazil declined 4.8 percent as reported, but was flat adjusted for currency.
EMEA revenue decreased 4.1 percent as reported, but was essentially flat adjusted for currency and increased 1 percent excluding divested businesses and adjusted for currency. As reported, the U.K., France and Italy decreased 2.9 percent, 4.1 percent and 1.3 percent, respectively, but grew 1 percent, 1 percent and 4 percent, respectively, adjusted for currency. Germany decreased 7.9 percent as reported and 3 percent adjusted for currency. The Middle East and Africa region decreased 3.5 percent as reported and 2 percent adjusted for currency.
Asia Pacific revenue decreased 4.0 percent as reported (3 percent adjusted for currency) and 2 percent excluding divested businesses and adjusted for currency. Japan increased 2.3 percent as reported and 1 percent adjusted for currency.
Australia decreased 17.3 percent as reported and 11 percent adjusted for currency. China decreased 13.4 percent as reported and 11 percent adjusted for currency and India decreased 8.1 percent as reported and 5 percent adjusted for currency.
Table:
($ in millions) |  |  |  |  | 
For the year ended December 31: | 2019 | 2018 | Yr.-to-Yr. Percent Change | Yr.-to-Yr. Percent Change Adjusted for Currency | Yr.-to-Yr. Percent Change Excluding Divested Businesses And Adjusted for Currency
Total revenue | $77,147 | $79,591 | (3.1)% | (1.0)% | 0.2%
Americas | $36,274 | $36,994 | (1.9)% | (1.1)% | 0.8%
Europe/Middle East/Africa | 24,443 | 25,491 | (4.1) | 0.4 | 1.3
Asia Pacific | 16,430 | 17,106 | (4.0) | (3.0) | (2.5)


Question: What was the average total revenue?
Answer: 78369
Calculation: (77,147 + 79,591) / 2
3. Operating segments continued
Note
1. Non-current assets excludes trade and other receivables, assets recognised from costs to obtain a contract, defined benefit pension plan surplus and deferred tax asset.
Europe, Middle East and Africa includes United Kingdom non-current assets of $6.9 million (2018 $2.0 million). Americas includes United States non-current assets of $182.4 million (2018 $171.1 million).
Table:
 | 2019 | 2018
 | $ million | $ million
Non-current assets1 |  | 
Americas | 196.9 | 184.6
Asia Pacific | 7.4 | 4.4
Europe, Middle East and Africa | 11.5 | 5.1
 | 215.8 | 194.1


Question: Where are the operating segments for non-current assets in the table?
Answer: Americas, Asia Pacific, Europe, Middle East and Africa