hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
NOTE 6 - continued
For information on assets provided as collateral security, please refer to note 16. Please refer to note 8 for information on impairment testing.
The depreciation expense related to "Other plant and operating equipment" of USD 1.0m relates to "Administrative expense" (2018: USD 1.1m, 2017: USD 0.9m). Depreciation and impairment losses on tangible fixed assets on "Vessels and capitalized dry-docking" relate to operating expenses.
Table:
USDm | 2019 | 2018 | 2017
Other plant and operating equipment |  |  | 
Cost: |  |  | 
Balance as of 1 January | 5.8 | 3.6 | 2.7
Adjustment on transition to IFRS 16 | 0.3 | - | -
Additions | 2.2 | 2.2 | 1.0
Disposals | -0.2 | - | -0.1
Balance as of 31 December | 8.1 | 5.8 | 3.6
Depreciation: |  |  | 
Balance as of 1 January | 2.8 | 1.7 | 0.9
Disposals | - | - | -0.1
Depreciation for the year | 1.0 | 1.1 | 0.9
Balance as of 31 December | 3.8 | 2.8 | 1.7
Carrying amount as of 31 December | 4.3 | 3.0 | 1.9


Question: What information can be derived in note 16?
Answer: information on assets provided as collateral security
Note: The Company adopted IFRS 16 on January 1, 2019. The Company elected not to restate prior periods in accordance with the transition provision in IFRS 16.
Financial risk management objectives and policies
The Company’s risk management objectives are to manage the market risk, credit risk and liquidity risk related to its operating activities. The Company identifies, measures and manages the aforementioned risks based on policy and risk preference.
The Company has established appropriate policies, procedures and internal controls for financial risk management. Before entering into significant financial activities, approval process by the Board of Directors and Audit Committee must be carried out based on related protocols and internal control procedures. The Company complies with its financial risk management policies at all times.
Table:
Financial Assets | As of December 31, | 
 | 2018 | 2019
 | NT$ | NT$
 | (In Thousands) | (In Thousands)
Financial assets at fair value through profit or loss | $12,084,297 | $14,021,473
Financial assets at fair value through other comprehensive income | 11,585,477 | 14,723,232
Financial assets measured at amortized cost |  | 
Cash and cash equivalents (excludes cash on hand) | 83,655,648 | 95,486,403
Receivables | 24,583,451 | 26,459,392
Refundable deposits | 2,757,399 | 2,600,733
Other financial assets | 2,320,037 | 2,353,066
Total | $136,986,309 | $155,644,299
Financial Liabilities | As of December 31, | 
 | 2018 | 2019
 | NT$ | NT$
 | (In Thousands) | (In Thousands)
Financial liabilities measured at amortized cost |  | 
Short-term loans | $13,103,808 | $12,015,206
Payables | 23,559,548 | 27,433,065
Guarantee deposits (current portion included) | 665,793 | 296,694
Bonds payable (current portion included) | 41,378,182 | 38,781,416
Long-term loans (current portion included) | 30,826,215 | 33,902,074
Lease liabilities (Note) | — | 6,031,025
Other financial liabilities | 20,523,099 | 20,093,441
Total | $130,056,645 | $138,552,921


Question: What is the percentage change of Other financial assets from 2018 to 2019?
Answer: 1.42
Calculation: 2,353,066 / 2,320,037 - 1
Pro Forma Information
The following unaudited pro forma information gives effect to the acquisition of AutoGuide as if the acquisition occurred on January 1, 2018 and the acquisition of MiR as if the acquisition occurred on January 1, 2017. The unaudited pro forma results are not necessarily indicative of what actually would have occurred had the acquisition been in effect for the periods presented:
Pro forma results for the year ended December 31, 2019 were adjusted to exclude $1.2 million of AutoGuide acquisition related costs and $0.1 million of AutoGuide non-recurring expense related to fair value adjustment to acquisition-date inventory.
Pro forma results for the year ended December 31, 2018 were adjusted to include $1.2 million of AutoGuide acquisition related costs and $0.4 million of AutoGuide non-recurring expense related to fair value adjustment to acquisition-date inventory.
Pro forma results for the year ended December 31, 2018 were adjusted to exclude $2.9 million of MiR acquisition related costs and $0.4 million of MiR non-recurring expense related to fair value adjustment to acquisition-date inventory.
Table:
 | For the Year Ended | 
 | December 31, 2019 | December 31, 2018
 | (in thousands, except per share amounts) | 
Revenues | $2,303,737 | $2,111,373
Net income | $464,602 | $442,082
Net income per common share: |  | 
Basic | $2.73 | $2.36
Diluted | $2.59 | $2.30


Question: What are the types of net income per common share in the table?
Answer: Basic, Diluted
Systems revenue of $8,034 million decreased 2.0 percent year to year as reported (2 percent adjusted for currency) driven by strong IBM Z performance in 2017 and continued price pressures impacting Storage Systems in a competitive environment.
Both hardware platforms were down year to year for the full year, as reported and adjusted for currency. This performance was partially offset by strong growth in Power Systems (which grew as reported and adjusted for currency in 2018) with strong performance in POWER9-based systems and Linux throughout the year. Within Systems, cloud revenue of $3.1 billion decreased 10 percent as reported and adjusted for currency compared to the prior year reflecting IBM Z product cycle dynamics.
Table:
($ in millions) |  |  |  | 
For the year ended December 31: | 2018 |  | Yr.-to-Yr. Percent Change | Yr.-to-Yr. Percent Change Adjusted for Currency
Systems external revenue | $8,034 | $8,194 | (2.0)% | (2.3)%
Systems Hardware | $6,363 | $6,494 | (2.0)% | (2.3)%
IBM Z |  |  | (5.4) | (5.6)
Power Systems |  |  | 8.8 | 8.7
Storage Systems |  |  | (5.5) | (5.9)
Operating Systems Software | 1,671 | 1,701 | (1.7) | (2.4)


Question: What led to fall in systems revenue from 2017 to 2018?
Answer: strong IBM Z performance in 2017 and continued price pressures impacting Storage Systems in a competitive environment
The movements below in foreign currency translation reserve and cashflow hedge reserve relating to the NSPT Group are presented within non-controlling interest in the Group’s consolidated statement of changes in equity.
Taxation impact on revaluation applies only to cash flow hedges held in NSNZPT, a sub-trust of NSPT, which is subject to New Zealand tax legislation. Deferred tax does not apply to any other cash flow hedges held in the NSPT Group under current Australian tax legislation.
The hedging reserve is used to record gains or losses on derivatives that are designated as cash flow hedges and recognised in other comprehensive income, as described in note 2(m). Amounts are reclassified to profit or loss in the period when the associated hedged transaction takes place.
On 24 June 2019, the Group reset the interest rates associated with AUD denominated interest rate swaps designated as cash flow hedges. This resulted in a cash outflow of $22.9m which reduced the Group’s financial liability as presented in note 9.8. In accordance with AASB 9 Financial instruments, as the nature of the underlying hedged instrument is unchanged the fair value of this outflow remains in the cash flow hedge reserve and will be amortised to the statement of profit or loss in future periods.
The cash flow hedge is included in non-controlling interest in the Consolidated Group and is not classified within other reserves.
Table:
NSPT Group |  | 
 | 2019 | 2018
 | $'000 | $'000
Foreign currency translation reserve |  | 
Opening balance at 1 July | (115) | 232
Net investment hedge | (1,591) | 1,007
Foreign exchange translation differences | 2,464 | (1,354)
Closing balance at 30 June | 758 | (115)
Cash flow hedge reserve |  | 
Opening balance at 1 July | (2,073) | (45)
Revaluation of derivatives | (22,098) | (2,112)
Taxation impact on revaluation | 290 | 84
Closing balance at 30 June | (23,881) | (2,073)
Other reserves | (23,123) | (2,188)


Question: What was the cash outflow which reduced the Group's financial liability?
Answer: $22.9m
Note 6: Other Expense, Net
The significant components of other expense, net, were as follows:
Interest income in the year ended June 30, 2019, increased compared to the years ended June 24, 2018, and June 25, 2017, primarily as a result of higher yield. Interest expense in the year ended June 30, 2019, increased compared to the year ended June 24, 2018, primarily due to issuance of the $2.5 billion of senior notes. Interest expense in the year ended June 24, 2018, decreased compared to the year ended June 25, 2017, primarily due to the conversions of 2018 and 2041 Convertible Notes as well as the retirement of the 2018 Convertible Notes in May 2018.
The gain on deferred compensation plan related assets in fiscal years 2019, 2018 and 2017 was driven by an improvement in the fair market value of the underlying funds.
The loss on impairment of investments in the year ended June 24, 2018 was the result of a decision to sell selected investments held in foreign jurisdictions in connection with the Company’s cash repatriation strategy following the December 2017 U.S. tax reform.
Net loss on extinguishment of debt realized in the year ended June 25, 2017, was primarily a result of the special mandatory redemption of the Senior Notes due 2023 and 2026, as well as the termination of the Term Loan Agreement.
Table:
 | June 30, 2019 | June 24, 2018 | June 25, 2017
 |  | (in thousands) | 
Interest income | $98,771 | $85,813 | $57,858
Interest expense | (117,263) | (97,387) | (117,734)
Gains on deferred compensation plan related assets, net | 10,464 | 14,692 | 17,880
Loss on impairment of investments | — | (42,456) | —
Gains (losses) on extinguishment of debt, net | 118 | 542 | (36,252)
Foreign exchange gains (losses), net | 826 | (3,382) | (569)
Other, net | (11,077) | (19,332) | (11,642)
 | $(18,161) | $(61,510) | $(90,459)


Question: What is the percentage change in the foreign exchange losses from 2017 to 2018?
Answer: 494.38
Calculation: (3,382-569)/569
Item 6. SELECTED FINANCIAL DATA
You should read the following selected consolidated financial data for the five-year period ended March 31, 2019 in conjunction with our consolidated financial statements and notes thereto and "Management's Discussion and Analysis of Financial Condition and Results of Operations" included in Items 7 and 8 of this Form 10-K. Our consolidated statements of income data for each of the years in the three-year period ended March 31, 2019, and the balance sheet data as of March 31, 2019 and 2018, are derived from our audited consolidated financial statements, included in Item 8 of this Form 10-K. The statement of income data for the years ended March 31, 2016 and 2015 and balance sheet data as of March 31, 2017, 2016 and 2015 have been derived from our audited consolidated financial statements not included herein (in the tables below all amounts are in millions, except per share data).
(1) Refer to Note 2 to our consolidated financial statements for an explanation of our material business combinations during fiscal 2019 and fiscal 2017.
(2) Refer to Note 4 to our consolidated financial statements for a discussion of the special charges and other, net.
(3) Refer to Note 12 Debt and Credit Facility for further discussion.
Table:
 |  |  | Year ended March 31, |  | 
 | 2019 (1) | 2018 | 2017 (1) | 2016 | 2015
Consolidated Statements of Income data: |  |  |  |  | 
Net sales | $5,349.5 | $3,980.8 | $3,407.8 | $2,173.3 | $2,147.0
Special charges and other, net (2) | $33.7 | $17.5 | $98.6 | $4.0 | $2.8
Loss on settlement of debt (3) | $(12.6) | $(16.0) | $(43.9) | $— | $(50.6)
Net income from continuing operations | $355.9 | $255.4 | $170.6 | $323.9 | $365.3
Basic net income per common share from continuing operations | $1.51 | $1.10 | $0.79 | $1.59 | $1.84
Diluted net income per common share from continuing operations | $1.42 | $1.03 | $0.73 | $1.49 | $1.65
Dividends declared per common share | $1.457 | $1.449 | $1.441 | $1.433 | $1.425
Consolidated Balance Sheets data: |  |  |  |  | 
Total assets | $18,350.0 | $8,257.2 | $7,686.9 | $5,537.9 | $4,780.7
Net long-term debt and capital lease obligations, less current maturities (3) | $8,956.0 | $1,769.1 | $2,912.1 | $2,465.8 | $1,840.0
Microchip Technology stockholders' equity | $ 5,287.5 | $ 3,279.8 | $3,270.7 | $ 2,150.9 | $ 2,044.7


Question: Which years does the table provide information for the company's consolidated balance sheets?
Answer: 2019, 2018, 2017, 2016, 2015
Asset position
In financial year 2018/19, total assets of continuing and discontinued operations decreased by €709 million to €14.5 billion (30/9/2018: €15.2 billion).
In financial year 2018/19, non-current assets from continuing operations decreased by €141 million to €6.7 billion (30/9/2018: €6.9 billion), primarily relating to property, plant and equipment. In addition to cost-efficient investment activities, this was mainly due to individual property sales, while currency effects increased the carrying amount.
1 Adjustment of previous year according to explanation in notes.
2 Adjusted for effects of the discontinued business segment.
For more information about the development of non-current assets, see the notes to the consolidated financial statements in the numbers listed in the table.
Table:
€ million | Note no. | 30/9/2018 1 | 30/9/2018 adjusted2 | 30/9/2019
Non-current assets |  | 7,503 | 6,877 | 6,736
Goodwill | 19 | 797 | 778 | 785
Other intangible assets | 20 | 499 | 496 | 562
Property, plant and equipment | 21 | 5,314 | 4,892 | 4,760
Investment properties | 22 | 97 | 97 | 82
Financial assets | 23 | 88 | 88 | 97
Investments accounted for using the equity method | 23 | 178 | 178 | 179
Other financial and other non-financial assets | 24 | 202 | 86 | 80
Deferred tax assets | 25 | 329 | 262 | 191


Question: What is the difference in Goodwill and other intangible assets for FY2019?
Answer: 223
Calculation:  785 - 562
General and Administrative Expense
General and administrative expense increased by $8.6 million in 2018 compared to 2017. The increase was primarily due to a $3.7 million increase in employee-related costs, which includes stock-based compensation, associated with our increased headcount from 79 employees as of December 31, 2017 to 89 employees as of December 31, 2018. There was an additional increase of $2.8 million in depreciation and amortization, an increase of $1.5 million to support compliance as a public company, an increase of $0.4 million in software subscription cost and a $0.2 million increase in office related expenses to support the administrative team.
Table:
 | Year Ended December 31, |  | Change | 
 | 2018 | 2017 | $ | %
 |  | (dollars in thousands) |  | 
General and administrative | $ 31,462 | $ 22,895 | $ 8,567 | 37.4%
% of revenue | 21% | 22% |  | 


Question: In which year was General and administrative expense less than 40,000 thousands?
Answer: 2018, 2017
Calculation: locate and analyze General and administrative in row 4
9. DEFERRED REVENUES
Deferred revenues consisted of the following:
Deferred cloud services and license support revenues and deferred hardware revenues substantially represent customer payments made in advance for cloud or support contracts that are typically billed in advance with corresponding revenues generally being recognized ratably over the contractual periods. Deferred services revenues include prepayments for our services business and revenues for these services are generally recognized as the services are performed. Deferred cloud license and on-premise license revenues typically resulted from customer payments that related to undelivered products and services or specified enhancements.
In connection with our acquisitions, we have estimated the fair values of the cloud services and license support performance obligations assumed from our acquired companies. We generally have estimated the fair values of these obligations assumed using a cost build-up approach. The cost build-up approach determines fair value by estimating the costs related to fulfilling the obligations plus a normal profit margin. The sum of the costs and operating profit approximates, in theory, the amount that we would be required to pay a third party to assume these acquired obligations. These aforementioned fair value adjustments recorded for obligations assumed from our acquisitions reduced the cloud services and license support deferred revenues balances that we recorded as liabilities from these acquisitions and also reduced the resulting revenues that we recognized or will recognize over the terms of the acquired obligations during the post-combination periods.
Table:
 |  | May 31,
(in millions) | 2019 | 2018
Cloud services and license support | $7,340 | $7,265
Hardware | 635 | 645
Services | 360 | 404
Cloud license and on-premise license | 39 | 27
Deferred revenues, current | 8,374 | 8,341
Deferred revenues, non-current (in other non-current liabilities) | 669 | 625
Total deferred revenues | $9,043 | $8,966


Question: How did the fair value adjustments recorded for obligations affect the cloud services and license support deferred revenue balances?
Answer: These aforementioned fair value adjustments recorded for obligations assumed from our acquisitions reduced the cloud services and license support deferred revenues balances that we recorded as liabilities from these acquisitions
Note 7 — Inventories, net
Inventories are used in the manufacture and service of Restaurant/Retail products. The components of inventory, net consist of the following:
At December 31, 2019 and 2018, the Company had recorded inventory write-downs of $9.6 million and $9.8 million , respectively, against Restaurant/Retail inventories, which relate primarily to service parts.
Table:
 | December 31, | 
 | (in thousands) | 
 | 2019 | 2018
Finished Goods | $8,320 | $12,472
Work in process | — | 67
Component parts | 6,768 | 4,716
Service parts | 4,238 | 5,482
 | $19,326 | $22,737


Question: Where are Inventories used?
Answer: in the manufacture and service of Restaurant/Retail products.
NOTE 7. INVENTORIES
The following table details the components of inventories (in thousands).
Table:
 | December 31 | 
 | 2019 | 2018
Finished goods | $698 | $853
Raw materials | 90 | 3
Packaging | 110 | 102
Inventories | $ 898 | $ 958


Question: What are the respective values of finished goods in 2018 and 2019?
Answer: $853, $698
5.1.3 Consolidated Shipments and Net Revenue in 2019 and 2018
Unit: Shipments (thousand 12-inch equivalent wafers) / Net Revenue (NT$ thousands)
Note 1: Domestic means sales to Taiwan. Note 2: Others mainly include revenue associated with packaging and testing services, mask making, design services, and royalties.
Note 3: Commencing in 2018, the Company began to break down the net revenue by product based on a new method which associates most estimated sales returns and allowances with individual sales transactions, as opposed to the previous method which allocated sales returns and allowances based on the aforementioned gross revenue. The Company believes the new method provides a more relevant breakdown than the previous one.
Table:
 |  | 2019 |  | 2018 | 
 |  | Shipments | Net Revenue (Note 3) | Shipments | Net Revenue (Note 3)
Wafer | Domestic (Note 1) | 1,678 | 91,259,259 | 1,575 | 81,718,513
 | Export | 8,390 | 836,058,092 | 9,177 | 829,577,851
Others (Note 2) | Domestic (Note 1) | N/A | 8,835,783 | N/A | 8,398,094
 | Export | N/A | 133,832,314 | N/A | 111,779,099
Total | Domestic (Note 1) | 1,678 | 100,095,042 | 1,575 | 90,116,607
 | Export | 8,390 | 969,890,406 | 9,177 | 941,356,950


Question: What is the change in Wafer Domestic Net Revenue between 2018 and 2019?
Answer: 9540746
Calculation: 91,259,259-81,718,513
Acquisition Related and Other Expenses: Acquisition related and other expenses consist of personnel related costs and stock-based compensation for transitional and certain other employees, integration related professional services, and certain business combination adjustments including certain adjustments after the measurement period has ended and certain other operating items, net. Stock-based compensation expenses included in acquisition related and other expenses resulted from unvested restricted stock-based awards and stock options assumed from acquisitions whereby vesting was accelerated generally upon termination of the employees pursuant to the original terms of those restricted stock-based awards and stock options.
* Not meaningful
On a constant currency basis, acquisition related and other expenses decreased in fiscal 2019 compared to fiscal 2018 primarily due to certain favorable business combination related adjustments that were recorded in fiscal 201 9 .
Table:
 |  |  | Year Ended May 31, | 
 |  |  | Percent Change | 
(Dollars in millions) | 2019 | Actual | Constant | 2018
Transitional and other employee related costs | $49 | 3% | 4% | $48
Stock-based compensation | — | -100% | -100% | 1
Professional fees and other, net | 16 | 373% | 426% | 3
Business combination adjustments, net | (21) | * | * | —
Total acquisition related and other expenses | $44 | -15% | -13% | $52


Question: What was the difference between the transitional and other employee related costs in 2019 and 2018?
Answer: 1
Calculation: 49-48
MEDIA FINANCIAL RESULTS
REVENUE
Media revenue is earned from:
• advertising sales across its television, radio, and digital media properties; • subscriptions to televised and OTT products; • ticket sales, fund redistribution and other distributions from MLB, and concession sales; and • retail product sales.
The 4% decrease in revenue this year was a result of: • the sale of our publishing business in the second quarter of 2019; and • lower revenue at the Toronto Blue Jays, primarily as a result of a distribution from Major League Baseball in 2018; partially offset by • higher revenue generated by Sportsnet and TSC. Excluding the sale of our publishing business and the impact of the distribution from Major League Baseball last year, Media revenue would have increased by 1% this year.
OPERATING EXPENSES
We record Media operating expenses in four primary categories:
• the cost of broadcast content, including sports programming
and production;
• Toronto Blue Jays player compensation;
• the cost of retail products sold; and
• all other expenses involved in day-to-day operations.
The 2% decrease in operating expenses this year was a result of:
• lower Toronto Blue Jays player compensation; and
• lower publishing-related costs due to the sale of this business;
partially offset by
• higher programming costs; and
• higher cost of sales as a result of higher revenue at TSC.
ADJUSTED EBITDA
The 29% decrease in adjusted EBITDA this year was a result of the
revenue and expense changes described above. Excluding the
impact of the sale of our publishing business in the second quarter
of 2019 and the distribution from Major League Baseball last year,
adjusted EBITDA would have increased by 1% this year.
Table:
 |  | Years ended December 31 | 
(In millions of dollars, except margins) | 2019 | 2018 | %Chg
Revenue | 2,072 | 2,168 | (4)
Operating expenses | 1,932 | 1,972 | (2)
Adjusted EBITDA | 140 | 196 | (29)
Adjusted EBITDA margin | 6.8% | 9.0% | (2.2pts)
Capital expenditures | 102 | 90 | 13


Question: What was the percentage decrease in Adjusted EBITDA from 2018 to 2019?
Answer: 29%