hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
The Group has non-current borrowing facilities denominated in Australian Dollars (“AUD”) and New Zealand Dollars (“NZD”). All facilities are interest only facilities with any drawn balances payable at maturity. Drawn amounts and facility limits are as follows:
The major terms of these agreements are as follows: • Maturity dates on the facilities range from 23 July 2020 to 23 December 2026 (2018: 23 July 2019 to 23 December 2026). • The interest rate applied is the bank bill rate plus a margin depending on the gearing ratio. • Security has been granted over the Group's freehold investment properties.
The Group has a bank overdraft facility with a limit of $3m that was undrawn at 30 June 2019 and 30 June 2018. During the year ended 30 June 2019, the Group converted an existing AUD facility of $25m into an NZD facility of $25.75m, refinanced part of the existing debt facilities, and increased its club banking facilities by AUD $100m and NZD $50m (year ended 30 June 2018 facilities increased by $150m AUD and $25m NZD).
The Group have complied with the financial covenants of their borrowing facilities during the 2019 and 2018 reporting periods (see note 16). The fair value of borrowings approximates carrying value. Details of the exposure to risk arising from current and non-current borrowings are set out in note 15.
Table:
 | 2019 | 2018
 | $'000 | $'000
Bank finance facilities (AUD) |  | 
Drawn amount | 663,800 | 520,300
Facility limit | 680,000 | 605,000
Bank finance facilities (NZD) |  | 
Drawn amount | 192,250 | 87,500
Facility limit | 196,750 | 121,000
AUD equivalent of NZD facilities |  | 
Drawn amount | 184,038 | 80,048
Facility limit | 188,346 | 110,696


Question: What is the change in Bank finance facilities (AUD) Drawn amount from 2018 to 2019?
Answer: 143500
Calculation: 663,800-520,300
(19) Income Taxes
As of December 31, 2019 and 2018, the components of deferred tax assets primarily relate to equity method investments, equity-based compensation, deferred revenues, interest rate swaps, employee benefits accruals and deferred compensation. As of December 31, 2019 and 2018, the components of deferred tax liabilities primarily relate to depreciation and amortization of intangible assets, property and equipment and deferred contract costs.
The significant components of deferred tax assets and liabilities consist of the following (in millions):
Table:
 | December 31, | 
 | 2019 | 2018
Deferred tax assets: |  | 
Equity method investments | $25.7 | $—
Equity-based compensation | 12.6 | 9.2
Deferred revenues | 6.2 | 14.8
Interest rate swaps | 5.6 | —
Other | 13.0 | 11.4
Total deferred tax assets | 63.1 | 35.4
Deferred tax liabilities: |  | 
Goodwill and other intangibles | (168.7) | (178.9)
Deferred contract costs | (40.3) | (41.9)
Property, equipment and computer software | (34.3) | (28.0)
Other | (5.1) | (7.5)
Total deferred tax liabilities | (248.4) | (256.3)
Net deferred tax liability | $(185.3) | $(220.9)


Question: Which years does the table provide information for  components of deferred tax assets and liabilities?
Answer: 2019, 2018
The Company’s contractual obligations as of December 31, 2019, consist of our obligations as borrower under our 2019 Senior Secured Credit Facility, our obligations related to financing of our three 2018 Newbuildings.
The following table sets out financial, commercial and other obligations outstanding as of December 31, 2019.
Notes:
(1) Refers to obligation to repay indebtedness outstanding as of December 31, 2019.
(2) Refers to estimated interest payments over the term of the indebtedness outstanding as of December 31, 2019. Estimate based on applicable interest rate and drawn amount as of December 31, 2019.
(3) Refers to obligation to repay indebtedness outstanding as of December 31, 2019 for three 2018 Newbuildings.
(4) Refers to estimated interest payments over the term of the indebtedness outstanding as of December 31, 2019. Estimate based on applicable interest as of December 31, 2019 for the financing of the three 2018 Newbuildings.
(5) Refers to the future obligation as of December 31, 2019 to pay for operating lease liabilities at nominal values.
*The new five-year senior secured credit facility for $306.1 million is amortizing with a twenty-year maturity profile, carries a floating LIBOR interest rate plus a margin and matures in February 2024. Further, the agreement contains a discretionary excess cash amortization mechanism for the lender that equals 50% of the net earnings from the collateral vessels, less capex provision and fixed amortization.
Table:
Contractual Obligations in $’000s  | Total   | Less than 1 year   | 1-3 years   | 3-5 years   | More than 5 years
Senior Secured Credit Facility (1)* | 291,798 | 18,749 | 30,610 | 242,439 | -
Interest Payments (2) | 82,255 | 21,690 | 39,624 | 20,941 | -
Financing of 2018 Newbuildings (3) | 119,867 | 7,630 | 16,287 | 17,849 | 78,101
Interest Payments 2018 Newbuildings (4) | 47,517 | 7,674 | 13,739 | 11,526 | 14,578
Operating Lease Liabilities (5)   | 1,937 | 500 | 638 | 587 | 212
Total   | 543,374 | 56,243 | 100,898 | 293,342 | 92,891


Question: What is the total average Financing of 2018 Newbuildings and Interest Payments 2018 Newbuildings?
Answer: 83692
Calculation: (119,867 + 47,517)/2
for intangible assets subject to amortization , the estimated aggregate amortization expense for each of the five succeeding fiscal years is as follows : 2009 - $ 41.1 million , 2010 - $ 27.3 million , 2011 - $ 20.9 million , 2012 - $ 17.0 million , and 2013 - $ 12.0 million . fees and expenses related to the merger totaled $ 102.6 million , principally consisting of investment banking fees , legal fees and stock compensation ( $ 39.4 million as further discussed in note 10 ) , and are reflected in the 2007 results of operations . capitalized debt issuance costs as of the merger date of $ 87.4 million for merger-related financing were reflected in other long- term assets in the consolidated balance sheet . the following represents the unaudited pro forma results of the company 2019s consolidated operations as if the merger had occurred on february 3 , 2007 and february 4 , 2006 , respectively , after giving effect to certain adjustments , including the depreciation and amortization of the assets acquired based on their estimated fair values and changes in interest expense resulting from changes in consolidated debt ( in thousands ) : ( in thousands ) year ended february 1 , year ended february 2 .

Table:
( in thousands ) | year endedfebruary 12008 | year endedfebruary 22007
revenue | $ 9495246 | $ 9169822
net loss | -57939 ( 57939 ) | ( 156188 )
the pro forma information does not purport to be indicative of what the company 2019s results of operations would have been if the acquisition had in fact occurred at the beginning of the periods presented , and is not intended to be a projection of the company 2019s future results of operations .
subsequent to the announcement of the merger agreement , the company and its directors , along with other parties , were named in seven putative class actions filed in tennessee state courts alleging claims for breach of fiduciary duty arising out of the proposed merger , all as described more fully under 201clegal proceedings 201d in note 8 below .
3 .
strategic initiatives during 2006 , the company began implementing certain strategic initiatives related to its historical inventory management and real estate strategies , as more fully described below .
inventory management in november 2006 , the company undertook an initiative to discontinue its historical inventory packaway model for virtually all merchandise by the end of fiscal 2007 .
under the packaway model , certain unsold inventory items ( primarily seasonal merchandise ) were stored on-site and returned to the sales floor until the items were eventually sold , damaged or discarded .
through end-of-season and other markdowns , this initiative resulted in the elimination of seasonal , home products and basic clothing packaway merchandise to allow for increased levels of newer , current-season merchandise .
in connection with this strategic change , in the third quarter of 2006 the company recorded a reserve for lower of cost or market inventory .

Question: what is the net income margin in 2008?
Answer: 0.6%
Calculation: divide(57939, 9495246)
(9) Property, Plant and Equipment
Net property, plant and equipment is composed of the following:
(1) Fiber, conduit and other outside plant consists of fiber and metallic cable, conduit, poles and other supporting structures.
2) Central office and other network electronics consists of circuit and packet switches, routers, transmission electronics and electronics providing service to customers.
(3) Support assets consist of buildings, cable landing stations, data centers, computers and other administrative and support equipment.
(4) Construction in progress includes inventory held for construction and property of the aforementioned categories that has not been placed in service as it is still under construction.
We recorded depreciation expense of $3.1 billion, $3.3 billion and $2.7 billion for the years ended December 31, 2019, 2018 and 2017, respectively.
Table:
 | Depreciable Lives | As of December 31 | 
 |  | 2019 | 2018
 |  | (Dollars in millions) | 
Land | N/A | $867 | 871
Fiber, conduit and other outside plant(1) | 15-45 years | 24,666 | 23,936
Central office and other network electronics(2) | 3-10 years | 19,608 | 18,736
Support assets(3) | 3-30 years | 7,984 | 8,020
Construction in progress(4) | N/A | 2,300 | 1,704
Gross property, plant and equipment |  | 55,425 | 53,267
Accumulated depreciation |  | (29,346) | (26,859)
Net property, plant and equipment |  | $26,079 | 26,408


Question: What does 'Fiber, conduit and other outside plant' consist of?
Answer: fiber and metallic cable, conduit, poles and other supporting structures
5. Property, Plant and Equipment
Property, plant and equipment consists of the following (in thousands):
Table:
 | August 31, | 
 | 2019 | 2018
Land and improvements | $146,719 | $144,136
Buildings | 962,559 | 849,975
Leasehold improvements | 1,092,787 | 1,013,428
Machinery and equipment | 4,262,015 | 3,983,025
Furniture, fixtures and office equipment | 209,257 | 192,243
Computer hardware and software | 671,252 | 601,955
Transportation equipment | 16,423 | 17,215
Construction in progress | 83,234 | 42,984
 | 7,444,246 | 6,844,961
Less accumulated depreciation and amortization | 4,110,496 | 3,646,945
 | $3,333,750 | $3,198,016


Question: Which years does the table provide information for Property, plant and equipment?
Answer: 2019, 2018
Cubic Mission Solutions
Sales: CMS sales increased 23% to $207.0 million in fiscal 2018 compared to $168.9 million in 2017. The increase in sales was primarily due to increased orders and shipments of expeditionary satellite communications products, tactical networking products, and Command and Control, Intelligence, Surveillance and Reconnaissance (C2ISR) products and services. Businesses acquired during fiscal years 2018 and 2017 whose operations are included in our CMS operating segment had sales of $5.6 million and $1.5 million for fiscal years 2018 and 2017, respectively.
Amortization of Purchased Intangibles: Amortization of purchased intangibles included in the CMS results amounted to $20.8 million in 2018 and $23.6 million in 2017. The $2.8 million decrease in amortization expense is related to purchased intangible assets that are amortized based upon accelerated methods.
Operating Income: CMS had an operating loss of $0.1 million in 2018 compared to $9.3 million in 2017. CMS realized increased profits from expeditionary satellite communications products, tactical networking products, and C2ISR products and services. As mentioned above, amortization of purchased intangibles decreased to $20.8 million in 2018 compared to $23.6 million in 2017. CMS increased R&D expenditures between 2017 and 2018 by $10.8 million, primarily driven by development of new antenna technologies. Businesses acquired by CMS in fiscal years 2018 and 2017 incurred operating losses of $4.7 million in fiscal 2018 compared to $2.9 million in fiscal 2017. Included in the operating loss incurred by acquired businesses are acquisition transaction costs of $1.6 million and $1.8 million incurred in fiscal years 2018 and 2017, respectively.
Adjusted EBITDA: CMS Adjusted EBITDA increased 82% to $26.2 million in 2018 compared to $14.4 million in 2017.
The increase in CMS Adjusted EBITDA was primarily due to the same items described in the operating income section
above, excluding the changes in amortization expense and acquisition transaction costs discussed above as such items are
excluded from Adjusted EBITDA.
Table:
 | Fiscal 2018 | Fiscal 2017 | % Change
 |  | (in millions) | 
Sales | $  207.0 | $  168.9 | 23 %
Operating loss | (0.1) | (9.3) | (99)
Adjusted EBITDA | 26.2 | 14.4 | 82


Question: What is the change in sales in 2018?
Answer: 38.1
Calculation: 207.0-168.9
Realized and unrealized (losses) gains on non-designated derivative instruments. Realized and unrealized (losses) gains related to derivative instruments that are not designated as hedges for accounting purposes are included as a separate line item in the consolidated statements of loss. Net realized and unrealized losses on non-designated derivatives were $13.7 million for 2019, compared to $14.9 million for 2018, as detailed in the table below:
The realized losses relate to amounts we actually realized for settlements related to these derivative instruments in normal course and amounts paid to terminate interest rate swap agreement terminations.
During 2019 and 2018, we had interest rate swap agreements with aggregate average net outstanding notional amounts of approximately $1.1 billion and $1.3 billion, respectively, with average fixed rates of approximately 3.0% and 2.9%, respectively. Short-term variable benchmark interest rates during these periods were generally less than 3.0% and, as such, we incurred realized losses of $8.3 million and $13.9 million during 2019 and 2018, respectively, under the interest rate swap agreements.
We did not incur any realized losses related to the termination of interest rate swaps in 2019, compared to realized losses of $13.7 million during 2018. Primarily as a result of significant changes in long-term benchmark interest rates during 2019 and 2018, we recognized unrealized losses of $7.9 million in 2019 compared to unrealized gains of $33.7 million in 2018 under the interest rate swap agreements.
During the year ended December 31, 2019, we recognized a reversal of previously unrealized losses of $26.9 million on all the warrants held by Teekay to purchase common units of Altera (or the Warrants) as a result of the sale of the Warrants to Brookfield, and we concurrently recognized a realized loss of $25.6 million during the same period. During the year ended December 31, 2018, we recognized unrealized losses of $21.1 million on the Warrants. Please read “Item 18 – Financial Statements: Note 12 – Fair Value Measurements and Financial Instruments.”
Table:
 | Year Ended | Year Ended
 | December 31, 2019 | December 31, 2018
 | $ | $
Realized (losses) gains relating to: |  | 
Interest rate swap agreements | (8,296) | (13,898)
Interest rate swap agreement terminations | — | (13,681)
Foreign currency forward contracts | (147) | —
Stock purchase warrants | (25,559) | —
Forward freight agreements | 1,490 | 137
 | (32,512) | (27,442)
Unrealized (losses) gains relating to: |  | 
Interest rate swap agreements | (7,878) | 33,700
Foreign currency forward contracts | (200) | —
Stock purchase warrants | 26,900 | (21,053)
Forward freight agreements | (29) | (57)
 | 18,793 | 12,590
Total realized and unrealized losses on derivative instruments | (13,719) | (14,852)


Question: What was the Net realized and unrealized losses on non-designated derivatives in 2018?
Answer: $14.9 million for 2018
Review of operations
The Group’s operating performance for the fiscal year compared to last year is as follows:
1. The Directors believe the information additional to IFRS measures included in the report is relevant and useful in measuring the financial performance of the Group. These include: EBITDA, NPATA and EPSa. These measures have been defined in the Chairperson and Chief Executive Officer’s Joint Report on page 2.
In 2019 the business continued to deliver strong results after the record 2018 year. Revenues and EBITDA were in line with guidance. Further details on the Group’s results are outlined in the Chairperson and Chief Executive Officer’s Joint Report on page 2.
On 1 June 2019, Hansen acquired the Sigma Systems business (Sigma) and one month of these results are included in the FY19 result. Also included in the results are the transaction and other restructuring costs related to the acquisition, which we have identified as separately disclosed items in our results.
This acquisition has also resulted in the re-balancing of the Group’s market portfolio which, post the acquisition of Enoro in FY18, was initially weighted towards the Utilities sector. With Sigma’s revenues concentrated in the Communications sector, the Group’s revenue portfolio is now re-balanced to ensure greater diversification across multiple industries, regions and clients.
The Group has generated operating cash flows of $39.7 million, which has been used to retire external debt and fund dividends of $12.6 million during the financial year. With the introduction of a higher level of debt in June 2019 to fund the Sigma acquisition, the Group has, for the first time, used the strength of the Group’s balance sheet to fund 100% of an acquisition. With the Group’s strong cash generation, Hansen is well placed to service and retire the debt over the coming years.
Table:
 | 2019 | 2018 | 
 | A$ Million | A$ Million | Variance %
Operating revenue | 231.3 | 230.8 | 0.2%
EBITDA1 | 53.0 | 59.3 | (10.6%)
NPAT | 21.5 | 28.9 | (25.6%)
NPATA1 | 31.2 | 38.0 | (17.9%)
Basic earnings per share (EPS) (cents) | 10.9 | 14.8 | (26.4%)
Basic EPSa1 (cents) | 15.8 | 19.4 | (18.6%)


Question: Which sector was Sigma's revenue concentrated in?
Answer: Communications
10. Accrued and Other Current Liabilities
Accrued and other current liabilities consisted of the following:
Table:
 |  | Fiscal Year End
 | 2019 | 2018
 |  | (in millions)
Accrued payroll and employee benefits | $  455 | $  565
Dividends payable to shareholders | 308 | 303
Restructuring reserves | 245 | 141
Income taxes payable | 94 | 109
Deferred revenue | 36 | 27
Interest payable | 31 | 34
Share repurchase program payable | 18 | 94
Other | 426 | 438
Accrued and other current liabilities | $ 1,613 | $  1,711


Question: What was the change in deferred revenue in 2019 from 2018?
Answer: 9
Calculation: 36-27
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
In February 2018, Advanced Energy acquired Trek Holding Co., LTD ("Trek"), a privately held company with operations in Tokyo, Japan and Lockport, New York, for $6.1 million, net of cash acquired. Trek has a 95% ownership interest in its U.S. subsidiary which is also its primary operation.
The components of the fair value of the total consideration transferred for our 2018 acquisitions are as follows:
Table:
 | Trek | Electrostatic Product Line | LumaSense | Total
Cash paid for acquisition | $11,723 | $3,000 | $94,946 | $ 109,669
Less cash acquired | (5,651) | — | (10,262) | (15,913)
Total purchase price | $6,072 | $3,000 | $84,684 | $ 93,756


Question: What was the fair value of cash paid for acquisition of Lumasense?
Answer: $94,946
6. Inventories
Inventories consisted of the following:
Table:
 |  | Fiscal Year End
 | 2019 | 2018
 |  | (in millions)
Raw materials | $  260 | $  276
Work in progress | 739 | 656
Finished goods | 837 | 925
Inventories | $ 1,836 | $  1,857


Question: What was the change in Work in progress in 2019 from 2018?
Answer: 83
Calculation: 739-656
Cash Flows
The following table sets forth summary cash flow data for the periods indicated (in thousands).
Cash Flow from Operating Activities
Net cash flows provided by operating activities for the year ended December 31, 2019, were $137.6 million as compared to $183.9 million during the same period in 2018. Net cash provided by operating activities primarily consists of net income adjusted to add back depreciation, amortization, and stock-based compensation. Cash flows provided by operating activities were $46.3 million lower for the year ended December 31, 2019, compared to the same period in 2018, due to the timing of working capital. Our current policy is to use our operating cash flow primarily for funding capital expenditures, lease payments, stock repurchases, and acquisitions.
Cash Flow from Investing Activities
During the year ended December 31, 2019, we paid $753.9 million, net of $0.1 million in cash acquired, to acquire Speedpay. We also used cash of $18.5 million to invest in a payment technology and services company in India and $7.0 million to acquire the technology assets of RevChip, LLC and TranSend Integrated Technologies Inc. In addition, we used cash of $48.0 million to purchase software, property and equipment, as compared to $43.9 million during the same period in 2018.
Cash Flow from Financing Activities
Net cash flows provided by financing activities for the year ended December 31, 2019, were $667.2 million, as compared to net cash flows used by financing activities of $57.7 million during the same period in 2018. During 2019, we received proceeds of $500.0 million from our Delayed Draw Term Loan and $280.0 million from our Revolving Credit Facility to fund our purchase of Speedpay and stock repurchases, and we repaid $28.9 million on the Initial Term Loan and $41.0 million on the Revolving Credit Facility. In addition, we received proceeds of $16.6 million from the exercise of stock options and the issuance of common stock under our 2017 Employee Stock Purchase Plan, as amended, and used $4.0 million for the repurchase of stock-based compensation awards for tax withholdings. During 2019, we also used $35.6 million to repurchase common stock. During 2018, we received proceeds of $400.0 million from the issuance of the 2026 Notes. We used $300.0 million of the proceeds to redeem, in full, our outstanding 6.375% Senior Notes due 2020 and repaid $109.3 million on the Initial Term Loan. In addition, during 2018, we received proceeds of $22.8 million from the exercise of stock options and the issuance of common stock under our 2017 Employee Stock Purchase Plan, as amended, and used $2.6 million for the repurchase of restricted share awards ("RSAs") for tax withholdings. During 2018, we also used $54.5 million to repurchase common stock.
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Net cash provided by (used in): |  | 
Operating activities | $137,649 | $183,932
Investing activities | -830,481 | -45,360
Financing activities | 667,223 | -57,704


Question: What was the change in net cash from operating activities between 2018 and 2019?
Answer: 46283
Calculation: $183,932-$137,649