hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
12. INCOME TAXES
On December 22, 2017, the Tax Cuts and Jobs Act (“Tax Act”) was signed into law in the U.S. The Tax Act significantly revised the future ongoing U.S. corporate income tax by, among other things, lowering the U.S. corporate income tax rate to 21% from 35%, providing full expensing for investments in new and used qualified property made after September 27, 2017, and implementing a territorial tax system. In connection with the transition to the new territorial tax system, a one-time transition tax on certain unrepatriated earnings of foreign subsidiaries was imposed for fiscal 2018 (the “Transitional Repatriation Tax”), for which an election can be made to pay over eight years. In addition, the Tax Act included two new U.S. tax base erosion provisions, the Global Intangible Low-Taxed Income (“GILTI”) provisions and the Base- Erosion and Anti-Abuse Tax (“BEAT”) provisions, which became effective for the Company during fiscal 2019. The GILTI provisions generally result in inclusion of income earned by foreign subsidiaries in the U.S. taxable income.
In response to the Tax Act, the SEC issued Staff Accounting Bulletin No. 118 which allowed companies to recognize provisional estimates in the preparation of a Company’s financial statements and permitted up to a one year measurement period after the enactment date of the Tax Act to finalize the recording of the related tax impacts.
During fiscal 2018, the Company recorded a net provisional tax expense of $77.3 million for the estimated effects of the Tax Act. This was comprised of a provisional Transitional Repatriation Tax expense of $116.4 million, offset by a provisional deferred tax benefit of $39.1 million from the remeasurement of U.S. deferred tax assets and liabilities. The Company completed its analysis of the impact of the Tax Act during the third quarter of fiscal 2019, and during the first three quarters of fiscal 2019 recorded a net discrete income tax benefit adjustment of $17.0 million to the prior year provisional estimates, comprised of a $1.9 million reduction to the provisional Transitional Repatriation Tax and a $15.1 million increase in U.S. deferred tax assets.
The GILTI provisions became effective for the Company in fiscal 2019 and resulted in a net $30.4 million tax expense, consisting of a $70.8 million expense related to the inclusion of unremitted foreign earnings offset by a $40.4 million tax benefit from additional foreign tax credits. The Company has made an accounting policy decision under U.S. GAAP to treat taxes due on future GILTI inclusions in U.S. taxable income as a current-period expense (the “period cost method”).
Income (loss) before income taxes consists of the following components (in thousands):
Table:
 |  | Fiscal Year | 
 | 2019 | 2018 | 2017
United States | $(297,975) | $(151,083) | $2,439
Foreign | 389,767 | 168,228 | 24,866
Total | $91,792 | $17,145 | $27,305


Question: What are the company's respective total income before income taxes in 2018 and 2019?
Answer: 17,145, 91,792
Accounts Receivable and Allowance for Doubtful Accounts
Accounts receivable consists primarily of amounts due to the Company from normal business activities. We maintain an allowance for doubtful accounts for estimated losses that result from the inability of our customers to make required payments.
The allowance for doubtful accounts is maintained based on customer payment levels, historical experience and management’s views on trends in the overall receivable agings. In addition, for larger accounts, we perform analyses of risks on a customer-specific basis. We perform ongoing credit evaluations of our customers’ financial condition and management believes that an adequate allowance for doubtful accounts has been provided.
Uncollectible accounts are removed from accounts receivable and are charged against the allowance for doubtful accounts when internal collection efforts have been unsuccessful. The following table summarizes the activity in allowance for doubtful accounts for the years ended December 31, 2019, 2018 and 2017:
Table:
 |  | Year Ended December 31, | 
(In thousands) | 2019 | 2018 | 2017
Balance at beginning of year | $4,421 | $6,667 | $2,813
Provision charged to expense | 9,347 | 8,793 | 7,072
Write-offs, less recoveries | (9,219) | (11,039) | (6,516)
Acquired allowance for doubtful accounts | — | — | 3,298
Balance at end of year | $4,549 | $4,421 | $6,667


Question: What was the increase / (decrease) in the Acquired allowance for doubtful accounts from 2017 to 2018?
Answer: -3298
Calculation: 0 - 3,298
part ii item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities at january 25 , 2019 , we had 26812 holders of record of our common stock , par value $ 1 per share . our common stock is traded on the new york stock exchange ( nyse ) under the symbol lmt . information concerning dividends paid on lockheed martin common stock during the past two years is as follows : common stock - dividends paid per share .

Table:
quarter | dividends paid per share 2018 | dividends paid per share 2017
first | $ 2.00 | $ 1.82
second | 2.00 | 1.82
third | 2.00 | 1.82
fourth | 2.20 | 2.00
year | $ 8.20 | $ 7.46
stockholder return performance graph the following graph compares the total return on a cumulative basis of $ 100 invested in lockheed martin common stock on december 31 , 2013 to the standard and poor 2019s ( s&p ) 500 index and the s&p aerospace & defense index .
the s&p aerospace & defense index comprises arconic inc. , general dynamics corporation , harris corporation , huntington ingalls industries , l3 technologies , inc. , lockheed martin corporation , northrop grumman corporation , raytheon company , textron inc. , the boeing company , transdigm group inc. , and united technologies corporation .
the stockholder return performance indicated on the graph is not a guarantee of future performance. .

Question: what is the percentage change in total dividends paid per share from 2017 to 2018?
Answer: 9.9%
Calculation: subtract(8.20, 7.46), divide(#0, 7.46)
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)
29. Earnings/(losses) per share (‘‘EPS’’)
Basic earnings/(losses) per share was calculated by dividing the profit/(loss) for the year attributable to the owners of the common shares after deducting the dividend on Preference Shares by the weighted average number of common shares issued and outstanding during the year.
Diluted EPS is calculated by dividing the profit/(loss) for the year attributable to the owners of the Group adjusted for the effects of all dilutive potential ordinary shares by the weighted average number of all potential ordinary shares assumed to have been converted into common shares, unless such potential ordinary shares have an antidilutive effect.
The following reflects the earnings/(losses) and share data used in the basic and diluted earnings/ (losses) per share computations:
The Group excluded the effect of 2,630,173 SARs and 367,162 RSUs in calculating diluted EPS for the year ended December 31, 2019, as they were anti-dilutive (December 31, 2018: 555,453 SARs and 0 RSUs, December 31, 2017: 998,502 SARs and 0 RSUs).
Table:
 |  | For the year ended December 31, | 
 | 2017 | 2018 | 2019
Basic earnings/(loss) per share |  |  | 
Profit/(loss) for the year attributable to owners of the Group | 15,506 | 47,683 | (100,661)
Less: Dividends on Preference Shares | (10,064) | (10,063) | (10,063)
Profit/(loss) for the year available to owners of the Group | 5,442 | 37,620 | (110,724)
Weighted average number of shares outstanding, basic | 80,622,788 | 80,792,837 | 80,849,818
Basic earnings/(loss) per share | 0.07 | 0.47 | (1.37)
Diluted earnings/(loss) per share |  |  | 
Profit/(loss) for the year available to owners of the Group used in the calculation of diluted EPS | 5,442 | 37,620 | (110,724)
Weighted average number of shares outstanding, basic | 80,622,788 | 80,792,837 | 80,849,818
Dilutive potential ordinary shares | 643,342 | 844,185 | —
Weighted average number of shares used in the calculation of diluted EPS | 81,266,130 | 81,637,022 | 80,849,818
Diluted earnings/(loss) per share | 0.07 | 0.46 | (1.37)


Question: In which years was the earnings/(losses) per share recorded for?
Answer: 2017, 2018, 2019
Long-term obligations consist of the following (in thousands):
(1) Net of debt issuance costs of $6.4 million and $11.2 million at September 28, 2019 and September 29, 2018, respectively.
Table:
 | Fiscal year-end | 
 | 2019 | 2018
Euro Term Loan due 2024(1) | $385,208 | $411,661
1.3% Term loan due 2024 | 5,466 | 7,242
1.0% State of Connecticut term loan due 2023 | 1,028 | 1,406
Capital lease obligations | 536 | 402
Total long-term obligations | $392,238 | $420,711


Question: What was the percentage change in Capital lease obligations from 2018 to 2019?
Answer: 33.33
Calculation: (536-402)/402
23 Borrowings (continued)
The fair values of fixed rate borrowings and CMBS are assessed based on quoted market prices, and as such are categorised as Level 1 in the fair value hierarchy (see note 27 for definition). The fair values of unlisted floating rate borrowings are equal to their carrying values and are categorised as Level 2 in the fair value hierarchy.
The maturity profile of debt (excluding lease liabilities) is as follows:
Certain borrowing agreements contain financial and other conditions that, if contravened, could alter the repayment profile (further information is provided in financial covenants on pages 165 and 166)
At 31 December 2019 the Group had committed undrawn borrowing facilities of £238.5 million (2018: £274.2 million), maturing in 2021 and 2022. This includes £42.1 million of undrawn facilities in respect of development finance.
Table:
£m | 2019 | 2018
Repayable within one year | 65.8 | 46.7
Repayable in more than one year but not more than two years | 901.8 | 30.5
Repayable in more than two years but not more than five years | 2,114.2 | 2,722.0
Repayable in more than five years | 1,569.6 | 2,155.9
 | 4,651.4 | 4,955.1


Question: In which year is there a greater total debt?
Answer: 2018
Calculation: Find the year with the greater debt amount
The table below summarizes our cash flows from continuing operations activities for each of the last two fiscal years (in thousands):
Operating Activities. Operating cash flows increased $64.4 million in 2019 compared with 2018 primarily due to favorable changes in working capital of  $37.0 million, primarily due to lower income tax payments of$41.3 million, and higher net income adjusted for non-cash items of $27.3 million
Pension and Postretirement Contributions — Our policy is to fund our pension plans at or above the minimum required by law. As of January 1, 2019, the date of our last actuarial funding valuation for our qualified pension plan, there was no minimum contribution funding requirement. In 2019 and 2018, we contributed $6.2 million and $5.5 million, respectively, to our pension and postretirement plans. We do not anticipate making any contributions to our qualified defined benefit pension plan in fiscal 2020. For additional information, refer to Note 12, Retirement Plans, of the notes to the consolidated financial statements.
Table:
 | 2019 | 2018
Total cash provided by (used in) continuing operations: |  | 
Operating activities | $168,405 | $104,055
Investing activities | (13,819) | 65,661
Financing activities | (5,730) | (445,529)
Net increase (decrease) in cash from continuing operations | $148,856 | $(275,813)


Question: What is the average of the cash flows for operating activities for 2018 and 2019?
Answer: 136230
Calculation: ($168,405 + $104,055)/2
BUSINESS COMBINATION IN FISCAL 2019
Purchase of a fibre network and corresponding assets
On October 3, 2018, the Corporation's subsidiary, Atlantic Broadband, completed the acquisition of the south Florida fibre network previously owned by FiberLight, LLC. The transaction, combined with the dark fibers acquired from FiberLight in the second quarter of fiscal 2018, added 350 route miles to Atlantic Broadband’s existing south Florida footprint.
The acquisition was accounted for using the purchase method and was subject to post closing adjustments. The final allocation of the purchase price of this acquisition is as follows:
Table:
 | Final | Preliminary
 | August 31, 2019 | November 30, 2018
(In thousands of Canadian dollars) | $ | $
Purchase price |  | 
Consideration paid at closing | 38,876 | 38,876
Balance due on business combinations | 5,005 | 5,005
 | 43,881 | 43,881
Net assets acquired |  | 
Trade and other receivables | 1,308 | 1,743
Prepaid expenses and other | 335 | 335
Property, plant and equipment | 28,785 | 45,769
Intangible assets | 3,978 | —
Goodwill | 11,093 | —
Trade and other payables assumed | (644) | (644)
Contract liabilities and other liabilities assumed | (974) | (3,322)
 | 43,881 | 43,881


Question: When did Atlantic Broadband, completed the acquisition of the south Florida fibre network?
Answer: October 3, 2018
five-year performance comparison 2013 the following graph provides an indicator of cumulative total shareholder returns for the corporation as compared to the peer group index ( described above ) , the dow jones , and the s&p 500 . the graph assumes that the value of the investment in the common stock of union pacific corporation and each index was $ 100 on december 31 , 2002 , and that all dividends were reinvested . comparison of five-year cumulative return 2002 2003 2004 2005 2006 2007 upc s&p 500 peer group dj trans purchases of equity securities 2013 during 2007 , we repurchased 13266070 shares of our common stock at an average price of $ 115.66 . during the first nine months of 2007 , we repurchased 10639916 shares of our common stock at an average price per share of $ 112.68 . the following table presents common stock repurchases during each month for the fourth quarter of 2007 : period number of shares purchased average paid per total number of shares purchased as part of a publicly announced plan or program maximum number of shares that may yet be purchased under the plan or program .

Table:
period | totalnumber ofsharespurchased[a] | averagepricepaid pershare | total number of sharespurchased as part of apublicly announcedplan orprogram | maximum number ofshares that may yetbe purchased underthe plan orprogram[b]
oct . 1 through oct . 31 | 99782 | $ 128.78 | - | 9774279
nov . 1 through nov . 30 | 540294 | 124.70 | 528000 | 9246279
dec . 1 through dec . 31 | 1986078 | 128.53 | 1869800 | 7376479
total | 2626154 | $ 127.75 | 2397800 | n/a
[a] total number of shares purchased during the quarter includes 228354 shares delivered or attested to upc by employees to pay stock option exercise prices , satisfy excess tax withholding obligations for stock option exercises or vesting of retention units , and pay withholding obligations for vesting of retention shares .
[b] on january 30 , 2007 , our board of directors authorized us to repurchase up to 20 million shares of our common stock through december 31 , 2009 .
we may make these repurchases on the open market or through other transactions .
our management has sole discretion with respect to determining the timing and amount of these transactions. .

Question: what the percent of the total number of shares purchased in the fourth quarter of 2007 that was attested to upc by employees to pay stock option exercise prices
Answer: 8.7%
Calculation: divide(228354, 2626154)
equity compensation plan information the following table presents the equity securities available for issuance under our equity compensation plans as of december 31 , 2012 . equity compensation plan information plan category number of securities to be issued upon exercise of outstanding options , warrants and rights ( 1 ) weighted-average exercise price of outstanding options , warrants and rights ( 2 ) number of securities remaining available for future issuance under equity compensation plans ( excluding securities reflected in column ( a ) ) ( a ) ( b ) ( c ) equity compensation plans approved by security holders 3946111 $ 34.67 3608527 equity compensation plans not approved by security holders ( 3 ) 2014 2014 2014 .

Table:
plan category | number of securities to be issued upon exercise of outstanding options warrants and rights ( 1 ) ( a ) ( b ) | weighted-average exercise price of outstanding optionswarrants and rights ( 2 ) | number of securities remaining available for future issuance under equity compensation plans ( excluding securitiesreflected in column ( a ) ) ( c )
equity compensation plans approved by security holders | 3946111 | $ 34.67 | 3608527
equity compensation plans not approved by security holders ( 3 ) | 2014 | 2014 | 2014
total | 3946111 | $ 34.67 | 3608527
( 1 ) includes grants made under the huntington ingalls industries , inc .
2012 long-term incentive stock plan ( the "2012 plan" ) , which was approved by our stockholders on may 2 , 2012 , and the huntington ingalls industries , inc .
2011 long-term incentive stock plan ( the "2011 plan" ) , which was approved by the sole stockholder of hii prior to its spin-off from northrop grumman corporation .
of these shares , 1166492 were subject to stock options , 2060138 were subject to outstanding restricted performance stock rights , 641556 were restricted stock rights , and 63033 were stock rights granted under the 2011 plan .
in addition , this number includes 9129 stock rights and 5763 restricted performance stock rights granted under the 2012 plan , assuming target performance achievement .
( 2 ) this is the weighted average exercise price of the 1166492 outstanding stock options only .
( 3 ) there are no awards made under plans not approved by security holders .
item 13 .
certain relationships and related transactions , and director independence information as to certain relationships and related transactions and director independence will be incorporated herein by reference to the proxy statement for our 2013 annual meeting of stockholders to be filed within 120 days after the end of the company 2019s fiscal year .
item 14 .
principal accountant fees and services information as to principal accountant fees and services will be incorporated herein by reference to the proxy statement for our 2013 annual meeting of stockholders to be filed within 120 days after the end of the company 2019s fiscal year. .

Question: what portion of the total number of securities is issued?
Answer: 52.2%
Calculation: add(3946111, 3608527), divide(3946111, #0)
part ii item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities the following table presents reported quarterly high and low per share sale prices of our class a common stock on the new york stock exchange ( 201cnyse 201d ) for the years 2007 and 2006. .

Table:
2007 | high | low
quarter ended march 31 | $ 41.31 | $ 36.63
quarter ended june 30 | 43.84 | 37.64
quarter ended september 30 | 45.45 | 36.34
quarter ended december 31 | 46.53 | 40.08
2006 | high | low
quarter ended march 31 | $ 32.68 | $ 26.66
quarter ended june 30 | 35.75 | 27.35
quarter ended september 30 | 36.92 | 29.98
quarter ended december 31 | 38.74 | 35.21
on february 29 , 2008 , the closing price of our class a common stock was $ 38.44 per share as reported on the nyse .
as of february 29 , 2008 , we had 395748826 outstanding shares of class a common stock and 528 registered holders .
dividends we have never paid a dividend on any class of our common stock .
we anticipate that we may retain future earnings , if any , to fund the development and growth of our business .
the indentures governing our 7.50% ( 7.50 % ) senior notes due 2012 ( 201c7.50% ( 201c7.50 % ) notes 201d ) and our 7.125% ( 7.125 % ) senior notes due 2012 ( 201c7.125% ( 201c7.125 % ) notes 201d ) may prohibit us from paying dividends to our stockholders unless we satisfy certain financial covenants .
the loan agreement for our revolving credit facility and the indentures governing the terms of our 7.50% ( 7.50 % ) notes and 7.125% ( 7.125 % ) notes contain covenants that restrict our ability to pay dividends unless certain financial covenants are satisfied .
in addition , while spectrasite and its subsidiaries are classified as unrestricted subsidiaries under the indentures for our 7.50% ( 7.50 % ) notes and 7.125% ( 7.125 % ) notes , certain of spectrasite 2019s subsidiaries are subject to restrictions on the amount of cash that they can distribute to us under the loan agreement related to our securitization .
for more information about the restrictions under the loan agreement for the revolving credit facility , our notes indentures and the loan agreement related to the securitization , see item 7 of this annual report under the caption 201cmanagement 2019s discussion and analysis of financial condition and results of operations 2014liquidity and capital resources 2014factors affecting sources of liquidity 201d and note 3 to our consolidated financial statements included in this annual report. .

Question: for 2007 , what was thee average quarterly high stock price?
Answer: 44.28
Calculation: add(41.31, 43.84), add(#0, 45.45), add(#1, 46.53), divide(#2, const_4)
part ii item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities our ordinary shares have been publicly traded since november 17 , 2011 when our ordinary shares were listed and began trading on the new york stock exchange ( 201cnyse 201d ) under the symbol 201cdlph . 201d on december 4 , 2017 , following the spin-off of delphi technologies , the company changed its name to aptiv plc and its nyse symbol to 201captv . 201d as of january 25 , 2019 , there were 2 shareholders of record of our ordinary shares . the following graph reflects the comparative changes in the value from december 31 , 2013 through december 31 , 2018 , assuming an initial investment of $ 100 and the reinvestment of dividends , if any in ( 1 ) our ordinary shares , ( 2 ) the s&p 500 index and ( 3 ) the automotive peer group . historical share prices of our ordinary shares have been adjusted to reflect the separation . historical performance may not be indicative of future shareholder returns . stock performance graph * $ 100 invested on december 31 , 2013 in our stock or in the relevant index , including reinvestment of dividends . fiscal year ended december 31 , 2018 . ( 1 ) aptiv plc , adjusted for the distribution of delphi technologies on december 4 , 2017 ( 2 ) s&p 500 2013 standard & poor 2019s 500 total return index ( 3 ) automotive peer group 2013 adient plc , american axle & manufacturing holdings inc , aptiv plc , borgwarner inc , cooper tire & rubber co , cooper- standard holdings inc , dana inc , dorman products inc , ford motor co , garrett motion inc. , general motors co , gentex corp , gentherm inc , genuine parts co , goodyear tire & rubber co , lear corp , lkq corp , meritor inc , motorcar parts of america inc , standard motor products inc , stoneridge inc , superior industries international inc , tenneco inc , tesla inc , tower international inc , visteon corp , wabco holdings inc company index december 31 , december 31 , december 31 , december 31 , december 31 , december 31 .

Table:
company index | december 31 2013 | december 31 2014 | december 31 2015 | december 31 2016 | december 31 2017 | december 31 2018
aptiv plc ( 1 ) | $ 100.00 | $ 122.75 | $ 146.49 | $ 117.11 | $ 178.46 | $ 130.80
s&p 500 ( 2 ) | 100.00 | 113.69 | 115.26 | 129.05 | 157.22 | 150.33
automotive peer group ( 3 ) | 100.00 | 107.96 | 108.05 | 107.72 | 134.04 | 106.89
.

Question: what is the difference in percentage performance for aptiv plc versus the automotive peer group for the five year period ending december 31 2018?
Answer: 23.91%
Calculation: subtract(130.80, const_100), subtract(106.89, const_100), divide(#0, const_100), divide(#1, const_100), subtract(#2, #3)