hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
The failed-sale-leaseback accounting treatment had the following effects on our consolidated results of operations for the years ended December 31, 2018 and 2017:
After factoring in the costs to sell the data centers and colocation business, excluding the impact from the failed-sale-leaseback accounting treatment, the sale resulted in a $20 million gain as a result of the aggregate value of the proceeds we received exceeding the carrying value of the assets sold and liabilities assumed. Based on the fair market values of the failed-sale-leaseback assets, the failed-sale-leaseback accounting treatment resulted in a loss of $102 million as a result of the requirement to treat a certain amount of the pre-tax cash proceeds from the sale of the assets as though it were the result of a financing obligation. The combined net loss of $82 million was included in selling, general and administrative expenses in our consolidated statement of operations for the year ended December 31, 2017.
Effective November 3, 2016, which is the date we entered into the agreement to sell a portion of our data centers and colocation business, we ceased recording depreciation of the property, plant and equipment to be sold and amortization of the business’s intangible assets in accordance with applicable accounting rules. Otherwise, we estimate that we would have recorded additional depreciation and amortization expense of $67 million from January 1, 2017 through May 1, 2017.
Upon adopting ASU 2016-02, accounting for the failed sale leaseback is no longer applicable based on our facts and circumstances, and the real estate assets and corresponding financing obligation were derecognized from our consolidated financial statements. Please see “Leases” (ASU 2016-02) in Note 1— Background and Summary of Significant Accounting Policies for additional information on the impact the new lease standard will have on the accounting for the failed-sale-leaseback.
Table:
 | Positive (Negative) Impact to Net Income | 
 | December 31, | 
 | 2018 | 2017
 | (Dollars in millions) | 
Increase in revenue | $74 | 49
Decrease in cost of sales | 22 | 15
Increase in loss on sale of business included in selling, general and administrative expense | — | (102)
Increase in depreciation expense (one-time) | — | (44)
Increase in depreciation expense (ongoing) | (69) | (47)
Increase in interest expense | (55) | (39)
Decrease in income tax expense | 7 | 65
Decrease in net income | $(21) | (103)


Question: Which year had a larger decrease in the cost of sales?
Answer: 2018
Calculation: 22>15
GasLog Ltd. and its Subsidiaries Notes to the consolidated financial statements (Continued) For the years ended December 31, 2017, 2018 and 2019 (All amounts expressed in thousands of U.S. Dollars, except share and per share data)      Investment in associates and joint venture consist of the following:
The additions of $158 relate to the investment in Gastrade (December 31, 2018: $136). On February 9, 2017, GasLog acquired a 20% shareholding in Gastrade, a private limited company licensed to develop an independent natural gas system offshore Alexandroupolis in Northern Greece utilizing an FSRU along with other fixed infrastructure. GasLog, as well as being a shareholder, will provide operations and maintenance (‘‘O&M’’) services for the FSRU through an O&M agreement which was signed on February 23, 2018.
Table:
 | Associates | 
 | 2018 | 2019
As of January 1, | 20,800 | 20,713
Additions | 136 | 158
Share of profit of associates | 1,800 | 1,627
Dividend declared | (2,023) | (878)
As of December 31, | 20,713 | 21,620


Question: What was the change in additions from 2018 to 2019?
Answer: 22
Calculation: 158 - 136
3. Property, Plant and Equipment
Assets held under capital leases and included in property, plant and equipment as of September 28, 2019 and September 29, 2018 consisted of the following (in thousands):
Amortization of assets held under capital leases totaled $3.8 million, $3.4 million and $3.0 million for fiscal 2019, 2018 and 2017, respectively. Capital lease additions totaled $6.7 million, $11.8 million, and $20.5 million for fiscal 2019, 2018 and 2017, respectively.
As of September 28, 2019, September 29, 2018 and September 30, 2017, accounts payable included approximately $10.0 million, $11.2 million and $10.8 million, respectively, related to the purchase of property, plant and equipment, which have been treated as non-cash transactions for purposes of the Consolidated Statements of Cash Flows.
Table:
 | 2019 | 2018
Buildings and improvements | $23,717 | $23,717
Machinery and equipment  | 12,293 | 10,995
Capital assets in progress | 11,831 | 7,747
Total property, plant and equipment held under capital leases, gross | 47,841 | 42,459
Less: accumulated amortization  | (8,762) | (6,123)
Total property, plant and equipment held under capital leases, net | 39,079 | 36,336


Question: What was the percentage change in the accumulated amortization between 2018 and 2019?
Answer: 43.1
Calculation: (-8,762-(-6,123))/-6,123
Restricted Shares
We granted shares to certain of our Directors, executives and key employees under the 2016 and 2011 Plans, the vesting of which is service-based. The following table summarizes the activity during the twelve months ended March 31, 2019 for restricted shares awarded under the 2016 and 2011 Plans:
The weighted-average grant date fair value of the restricted shares is determined based upon the closing price of our common shares on the grant date. During fiscal 2019, a total of 197,917 shares, net of 47,146 shares withheld from the vested restricted shares to cover the employee's minimum applicable income taxes, were issued from treasury. The shares withheld were returned to treasury shares.
Table:
 | Number of Shares | Weighted-Average Grant-Date Fair Value
 |  | (per share)
Outstanding at April 1, 2018 | 243,354 | $10.78
Granted | 265,452 | 14.66
Vested | (197,917) | 12.74
Forfeited | (73,743) | 11.3
Outstanding at March 31, 2019 | 237,146 | $13.46


Question: What was the difference between the vested and granted Weighted-Average Grant-Date Fair Value?
Answer: 1.92
Calculation: 14.66-12.74
14 . accounting for certain long-lived assets eog reviews its proved oil and gas properties for impairment purposes by comparing the expected undiscounted future cash flows at a depreciation , depletion and amortization group level to the unamortized capitalized cost of the asset . the carrying rr values for assets determined to be impaired were adjusted to estimated fair value using the income approach described in the fair value measurement topic of the asc . in certain instances , eog utilizes accepted offers from third-party purchasers as the basis for determining fair value . during 2017 , proved oil and gas properties with a carrying amount of $ 370 million were written down to their fair value of $ 146 million , resulting in pretax impairment charges of $ 224 million . during 2016 , proved oil and gas properties with a carrying rr amount of $ 643 million were written down to their fair value of $ 527 million , resulting in pretax impairment charges of $ 116 million . impairments in 2017 , 2016 and 2015 included domestic legacy natural gas assets . amortization and impairments of unproved oil and gas property costs , including amortization of capitalized interest , were $ 211 million , $ 291 million and $ 288 million during 2017 , 2016 and 2015 , respectively . 15 . asset retirement obligations the following table presents the reconciliation of the beginning and ending aggregate carrying amounts of short-term and long-term legal obligations associated with the retirement of property , plant and equipment for the years ended december 31 , 2017 and 2016 ( in thousands ) : .

Table:
 | 2017 | 2016
carrying amount at beginning of period | $ 912926 | $ 811554
liabilities incurred ( 1 ) | 54764 | 212739
liabilities settled ( 2 ) | -61871 ( 61871 ) | -94800 ( 94800 )
accretion | 34708 | 32306
revisions | -9818 ( 9818 ) | -38286 ( 38286 )
foreign currency translations | 16139 | -10587 ( 10587 )
carrying amount at end of period | $ 946848 | $ 912926
current portion | $ 19259 | $ 18516
noncurrent portion | $ 927589 | $ 894410
( 1 ) includes $ 164 million in 2016 related to yates transaction ( see note 17 ) .
( 2 ) includes settlements related to asset sales .
the current and noncurrent portions of eog's asset retirement obligations are included in current liabilities - other and other liabilities , respectively , on the consolidated balance sheets. .

Question: considering the years 2016 and 2017 , what is the average current portion?
Answer: 18887.5
Calculation: table_average(current portion, none)
Share Based Compensation Expense
Share-based compensation expense recognized in the financial statements by line item caption is as follows (in thousands):
The amount of share-based compensation expense capitalized in inventory has been immaterial for each of the periods presented.
Table:
 |  | Year Ended | 
 | June 30,
2019 | June 30,
2018 | June 30,
2017
Cost of product revenue  | $844 | $564 | $333
Cost of service revenue | 1,639 | 1,131 | 589
Research and development   | 10,443 | 7,642 | 3,312
Sales and marketing   | 11,747 | 9,843 | 4,253
General and administrative   | 8,224 | 8,453 | 4,146
Total share-based compensation expense  | $32,897 | $27,633 | $12,633


Question: What was the change in cost of product revenue between 2018 and 2019?
Answer: 280
Calculation: 844-564
OPERATING AND FINANCIAL RESULTS
(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.
Table:
Three months ended August 31, | 2019 (1) | 2018 (2) | Change | Change in constant currency | Foreign exchange impact
(in thousands of dollars, except percentages) | $ | $ | % | % | $
Revenue | 583,673 | 566,184 | 3.1 | 2.7 | 2,427
Operating expenses | 302,833 | 297,977 | 1.6 | 1.1 | 1,441
Management fees – Cogeco Inc. | 5,230 | 4,796 | 9.0 | 9.0 | -
Adjusted EBITDA | 275,610 | 263,411 | 4.6 | 4.3 | 986
Adjusted EBITDA margin | 47.2% | 46.5% |  |  | 


Question: What was the Adjusted EBITDA margin in fourth quarter fiscal year 2019?
Answer: 47.2%
The following tables summarize information for operating income (loss), depreciation and amortization, restructuring charges, gain (loss) on write down and disposal of long-lived assets, and capital expenditures by reportable segment for the fiscal years ended 2019, 2018 and 2017 and total assets by reportable segment for the fiscal years ended 2019 and 2018 (amounts in thousands): The following tables summarize information for operating income (loss), depreciation and amortization, restructuring charges, gain (loss) on write down and disposal of long-lived assets, and capital expenditures by reportable segment for the fiscal years ended 2019, 2018 and 2017 and total assets by reportable segment for the fiscal years ended 2019 and 2018 (amounts in thousands):
(1) March 31, 2018 adjusted due to the adoption of ASC 606.
Table:
 | March 31, | 
 | 2019 | 2018
Total assets: |  | 
Solid Capacitors | $794,402 | $704,851
Film and Electrolytic (1) | 219,711 | 240,968
MSA | 234,419 | 254,193
Corporate | 69,563 | 22,911
 | $1,318,095 | $1,222,923


Question: What were the total Corporate assets in 2018?
Answer: 22,911
FY19 EAIP Payout Results:
(1) Calculated in FY19 plan exchange rates and excludes stock-based compensation expense, charges related to the amortization of intangible assets, restructuring, separation, transition and other related expenses, contract liabilities fair value adjustment, acquisition-related costs and certain litigation settlement gains.
(2) Calculated in FY19 plan exchange rates and excludes contract liabilities fair value adjustment.
Table:
Weighted Average Company Performance Funding |  |  |  |  | 
Company Performance Metric | Target ($) (millions) | Threshold ($)(millions) | Actual ($) (millions) | Threshold Funding (%) | Funding (%)
Non-GAAP Operating Income | 1,630 | 1,428 | 1,427(1) | 40 | 0.0
Non-GAAP Revenue | 4,943 | 4,760 | 4,804(2) | 40 | 71.2
FY19 Funding | . | . | . | . | 35.6


Question: What is the difference between Actual and Target for Non-GAAP Revenue?
Answer: 139
Calculation: 4,943-4,804
The Group’s measure of segment profit, adjusted EBITDA, excludes depreciation, amortisation, impairment loss, restructuring costs, loss on disposal of fixed assets, the Group’s share of results in associates and joint ventures and other income and expense. A reconciliation of adjusted EBITDA to operating profit is shown below. For a reconciliation of operating profit to profit for the financial year, see the Consolidated income statement on page 111.
Note: 1 Share of adjusted results in equity accounted associates and joint ventures excludes amortisation of acquired customer bases and brand intangible assets, restructuring costs and other costs of €0.6 billion (2018: €0.4 billion, 2017: €0.1 billion) which are included in amortisation of acquired customer base and brand intangible assets, restructuring costs and other income and expense respectively
2 See note 31 “IAS 18 basis primary statements” for further details.
Table:
 | 2019 €m | 2018 €m | 2017 €m
Adjusted EBITDA | 14,139 | 14,737 | 14,149
Depreciation, amortisation and loss on disposal of fixed assets | (9,665) | (9,910) | (10,179)
Share of adjusted results in equity accounted associates and joint ventures1 | (291) | 389 | 164
Adjusted operating profit | 4,183 | 5,216 | 4,134
Impairment losses | (3,119) | – | –
Restructuring costs | (486) | (156) | (415)
Amortisation of acquired customer based and brand intangible assets | (583) | (974) | (1,046)
Other (expense)/income | (262) | 213 | 1,052
Operating (loss)/profit (IAS 18 basis) | (267) | 4,299 | 3,725
Impact of adoption of IFRS 152 | (684) |  | 
Operating loss (IFRS 15 basis) | (951) |  | 


Question: What is the change in average adjusted EBITDA between 2018 and 2019, and 2017 and 2018?
Answer: -5
Calculation: [(14,139+14,737)/2] - [(14,737+14,149)/2]
Capital management
The Group considers capital to be net debt plus total equity. Net debt is calculated as total bank debt and lease financing, less unamortised debt fees and cash and cash equivalents as shown in note 32. Total equity is as shown in the Consolidated balance sheet.
The calculation of total capital is shown in the table below:
Following the application of IFRS 16, total capital for the year ended 31 March 2018 has been restated (note 2).
The objectives for managing capital are to safeguard the Group’s ability to continue as a going concern, in order to provide returns for shareholders and benefits for other stakeholders and to maintain an efficient capital structure to optimise the cost of capital. In order to maintain or adjust the capital structure, the Group may adjust the amount of dividends paid to shareholders, return capital to shareholders, issue new shares or take other steps to increase share capital and reduce or increase debt facilities.
As at 31 March 2019, the Group had borrowings of £313.0m (2018: £343.0m) through its Syndicated revolving credit facility (2018: Syndicated Term Loan). Interest is payable on this facility at a rate of LIBOR plus a margin of between 1.2% and 2.1% depending on the consolidated leverage ratio of Auto Trader Group plc and its subsidiaries, which is calculated and reviewed on a biannual basis. The Group remains in compliance with its banking covenants.
Table:
 | 2019 | (Restated) 2018
 | £m | £m
Total net debt | 321.0 | 355.2
Total equity | 59.0 | 5.6
Total capital | 380.0 | 360.8


Question: What was the percentage change in total capital in 2019 from 2018?
Answer: 5.32
Calculation: (380.0-360.8)/360.8
Sources and Uses of Cash
Historically, our primary source of cash has been provided by operations. Other sources of cash in the past three fiscal years include proceeds from our Euro Term Loan used to finance our acquisition of Rofin, proceeds received from the sale of our stock through our employee stock purchase plan as well as borrowings under our revolving credit facility (‘‘Revolving Credit Facility’’). Our historical uses of cash have primarily been for acquisitions of businesses and technologies, the repurchase of our common stock, capital expenditures and debt issuance costs. Supplemental information pertaining to our historical sources and uses of cash is presented as follows and should be read in conjunction with our Consolidated Statements of Cash Flows and notes thereto (in thousands):
Net cash provided by operating activities decreased by $54.7 million in fiscal 2019 compared to fiscal 2018. The decrease in cash provided by operating activities in fiscal 2019 was primarily due to lower net income and lower cash flows from income taxes payable and deferred taxes, partially offset by higher cash flows from accounts receivable, inventories, deferred revenue and accrued payroll. We believe that our existing cash, cash equivalents and short term investments combined with cash to be provided by operating activities and amounts available under our Revolving Credit Facility will be adequate to cover our working capital needs and planned capital expenditures for at least the next 12 months to the extent such items are known or are reasonably determinable based on current business and market conditions. However, we may elect to finance certain of our capital expenditure requirements through other sources of capital. We continue to follow our strategy to further strengthen our financial position by using available cash flow to fund operations.
Table:
 | Fiscal | 
 | 2019 | 2018
Net cash provided by operating activities | $181,401 | $236,111
Purchases of property and equipment | (83,283) | (90,757)
Acquisition of businesses, net of cash acquired | (18,881) | (45,448)
Proceeds from sale of discontinued operation (the Hull Business) | — | 25,000
Proceeds from sales of other entities | — | 6,250
Borrowings, net of repayments | 263 | (173,252)
Issuance of shares under employee stock plans | 11,811 | 10,574
Repurchase of common stock | (77,410) | (100,000)
Net settlement of restricted common stock | (15,179) | (36,320)


Question: What was the  Purchases of property and equipment  in 2018?
Answer: (90,757)
Pension benefit commitments
For fiscal 2019, Managing Board members were granted contributions under the BSAV totaling € 5.6 million (2018: € 5.4 million), based on a Supervisory Board decision from November 7, 2019. Of this amount, € 0.02 million (2018: € 0.03 million) relates to the funding of pension commitments earned prior to the transfer to the BSAV.
The expense recognized in fiscal 2019 as a service cost under IFRS for Managing Board members’ entitlements under the BSAV in fiscal 2019 totaled € 5.4 million (2018: € 5.3 million).
Contributions under the BSAV are added to the individual pension accounts in the January following each fiscal year. Until pension payments begin, members’ pension accounts are credited with an annual interest payment (guaranteed interest) on January 1 of each year. The interest rate is currently 0.90%.
The following table shows the individualized contributions (allocations) under the BSAV for fiscal 2019 as well as the defined benefit obligations for pension commitments:
In fiscal 2019, former members of the Managing Board and their surviving dependents received emoluments within the meaning of Section 314 para. 1 No. 6 b of the German Commercial Code totaling € 21.09 million (2018: € 39.9 million).
The defined benefit obligation (DBO) of all pension commitments to former members of the Managing Board and their surviving dependents as of September 30, 2019, amounted to €175.7 million (2018: €168.2 million). This figure is included in NOTE 17 in B.6 NOTES TO CONSOLIDATED FINANCIAL STATEMENTS.
1 Deferred compensation totals € 4,125,612 (2018: € 4,115,237), including € 3,703,123 for Joe Kaeser (2018: € 3,694,439), € 361,494 for Klaus Helmrich (2018: € 362,606) and € 60,995 for Prof. Dr. Ralf P. Thomas (2018: € 58,192).
2 In accordance with the provisions of the BSAV, benefits to be paid to Lisa Davis are not in any way secured or funded through the trust associated with the Company’s BSAV plan or with any other trust. They represent only an unsecured, unfunded legal obligation on the part of the Company to pay such benefits in the future under certain conditions, and the payout will only be made from the Company’s general assets.
Table:
 |  | Total contributions for | Defined benefit obligation for all pension commitments excluding deferred compensation 1 | 
(in €) | 2019 | 2018 | 2019 | 2018
Managing Board members in office as of September 30, 2019 |  |  |  | 
Joe Kaeser | 1,234,800 | 1,210,440 | 14,299,267 | 12,970,960
Dr. Roland Busch | 616,896 | 604,800 | 6,071,233 | 5,121,226
Lisa Davis 2 | 616,896 | 604,800 | 5,701,811 | 5,322,537
Klaus Helmrich | 616,896 | 604,800 | 6,473,904 | 5,714,522
Janina Kugel | 616,896 | 604,800 | 2,674,432 | 2,157,427
Cedrik Neike | 616,896 | 604,800 | 2,349,895 | 1,757,258
Michael Sen | 616,896 | 604,800 | 1,862,660 | 1,239,785
Prof. Dr. Ralf P. Thomas | 616,896 | 604,800 | 6,184,498 | 5,235,121
Total | 5,553,072 | 5,444,040 | 45,617,700 | 39,518,836


Question: What was The defined benefit obligation (DBO) of all pension commitments to former members of the Managing Board and their surviving dependents as of September 30, 2019 amount to?
Answer: €175.7 million
issuer purchases of equity securities the following table provides information about our repurchases of common stock during the three-month period ended december 31 , 2012 . period total number of shares purchased average price paid per total number of shares purchased as part of publicly announced program ( a ) amount available for future share repurchases the program ( b ) ( in millions ) .

Table:
period | total number of shares purchased | average price paid per share | total number of shares purchased as part of publicly announced program ( a ) | amount available for future share repurchases under the program ( b ) ( in millions )
october 1 2012 2013 october 28 2012 | 842445 | $ 93.38 | 842445 | $ 2522
october 29 2012 2013 november 25 2012 | 872973 | 90.86 | 872973 | 2443
november 26 2012 2013 december 31 2012 | 1395288 | 92.02 | 1395288 | 2315
total | 3110706 | $ 92.07 | 3110706 | $ 2315
( a ) we repurchased a total of 3.1 million shares of our common stock for $ 286 million during the quarter ended december 31 , 2012 under a share repurchase program that we announced in october 2010 .
( b ) our board of directors has approved a share repurchase program for the repurchase of our common stock from time-to-time , authorizing an amount available for share repurchases of $ 6.5 billion .
under the program , management has discretion to determine the dollar amount of shares to be repurchased and the timing of any repurchases in compliance with applicable law and regulation .
the program does not have an expiration date .
as of december 31 , 2012 , we had repurchased a total of 54.3 million shares under the program for $ 4.2 billion. .

Question: as of december 31 , 2012 , what was the year to date percent of the share repurchase under the program for $ 4.2 billion..\\n
Answer: 1.3%
Calculation: add(4.2, 54.3)