hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
2016 non-qualified deferred compensation as of december 31 , 2016 , mr . may had a deferred account balance under a frozen defined contribution restoration plan . the amount is deemed invested , as chosen by the participant , in certain t . rowe price investment funds that are also available to the participant under the savings plan . mr . may has elected to receive the deferred account balance after he retires . the defined contribution restoration plan , until it was frozen in 2005 , credited eligible employees 2019 deferral accounts with employer contributions to the extent contributions under the qualified savings plan in which the employee participated were subject to limitations imposed by the code . defined contribution restoration plan executive contributions in registrant contributions in aggregate earnings in 2016 ( 1 ) aggregate withdrawals/ distributions aggregate balance at december 31 , ( a ) ( b ) ( c ) ( d ) ( e ) ( f ) .

Table:
name | executive contributions in 2016 ( b ) | registrant contributions in 2016 ( c ) | aggregate earnings in 2016 ( 1 ) ( d ) | aggregate withdrawals/distributions ( e ) | aggregate balance at december 31 2016 ( a ) ( f )
phillip r . may jr . | $ 2014 | $ 2014 | $ 177 | $ 2014 | $ 1751
( 1 ) amounts in this column are not included in the summary compensation table .
2016 potential payments upon termination or change in control entergy corporation has plans and other arrangements that provide compensation to a named executive officer if his or her employment terminates under specified conditions , including following a change in control of entergy corporation .
in addition , in 2006 entergy corporation entered into a retention agreement with mr .
denault that provides possibility of additional service credit under the system executive retirement plan upon certain terminations of employment .
there are no plans or agreements that would provide for payments to any of the named executive officers solely upon a change in control .
the tables below reflect the amount of compensation each of the named executive officers would have received if his or her employment with their entergy employer had been terminated under various scenarios as of december 31 , 2016 .
for purposes of these tables , a stock price of $ 73.47 was used , which was the closing market price on december 30 , 2016 , the last trading day of the year. .

Question: what was mr . may's 12/31/15 plan balance?
Answer: 1928
Calculation: add(1751, 177)
For a particular tax-paying component of the Company and within a particular tax jurisdiction, all current deferred tax liabilities and assets are offset and presented as a single amount, similarly to non-current deferred tax liabilities and assets. The Company does not offset deferred tax liabilities and assets attributable to different tax-paying components or to different tax jurisdictions.
The net deferred tax assets are recorded in legal entities which have been historically profitable and are expected to be profitable in the next coming years.
Table:
 | December 31, 2019 | December 31, 2018
Tax loss carryforwards and investment credits | 612 | 603
Less unrecognized tax benefit | (21) | (20)
Tax loss carry forwards net of unrecognized tax benefit | 591 | 583
Inventory valuation | 28 | 28
Impairment and restructuring charges | 6 | 14
Fixed asset depreciation in arrears | 39 | 35
Increased depreciation incentives | 213 | 211
Capitalized development costs | 118 | 108
Receivables for government funding | 14 | 11
Tax credits granted on past capital investments | 1,151 | 1,155
Pension service costs | 81 | 65
Stock awards | 6 | 7
Operating lease liabilities | 40 | —
Commercial accruals | 15 | 12
Other temporary differences | 22 | 26
Total deferred tax assets | 2,324 | 2,255
Valuation allowances | (1,534) | (1,548)
Deferred tax assets, net | 790 | 707
Accelerated fixed asset depreciation | (20) | (16)
Acquired intangible assets | (16) | (13)
Advances of government funding | (31) | (12)
Operating lease right-of-use assets | (40) | —
Other temporary differences | (7) | (7)
Deferred tax liabilities | (114) | (48)
Net deferred income tax asset | 676 | 659


Question: What was the tax loss carryforwards and investment credits in 2019?
Answer: 612
The Group reported a loss before tax of £(42.7)m in the year, compared to a profit before tax of £20.9m in 2017/18. A loss after tax was £(33.8)m, compared to a £7.2m profit in the prior year.
Adjusted profit before tax was £88.0m in the year, an increase of £9.4m compared to the prior year due to growth both in Trading profit and lower interest costs as described above. Adjusted profit after tax increased £7.6m to £71.3m in the year after deducting a notional 19.0% tax charge of £16.7m. Based on average shares in issue of 841.5 million shares, adjusted earnings per share in the year was 8.5 pence, growth in the year of +11.5%.
Table:
Adjusted earnings per share (£m) | 2018/19 | 2017/18 | Change
Trading profit | 128.5 | 123.0 | +4.5%
Less: Net regular interest | (40.5) | (44.4) | +8.9%
Adjusted profit before tax | 88.0 | 78.6 | +12.1%
Less: Notional tax (19%) | (16.7) | (14.9) | (12.1%)
Adjusted profit after tax6 | 71.3 | 63.7 | +12.1%
Average shares in issue (millions) | 841.5 | 836.8 | +0.6%
Adjusted earnings per share (pence) | 8.5 | 7.6 | +11.5%


Question: What is the change in the adjusted profit before tax from 2017/18 to 2018/19?
Answer: 9.4
Calculation: 88.0 - 78.6
4. Cash and Cash Equivalents
The following table summarizes the components of our cash and cash equivalents (amounts in millions):
Table:
 | At December 31, | 
 | 2019 | 2018
Cash | $437 | $268
Foreign government treasury bills | 37 | 32
Money market funds | 5,320 | 3,925
Cash and cash equivalents | $5,794 | $4,225


Question: What was the cash amount in 2019?
Answer: 437
31. Financial instruments
Financial assets
Table:
 |  | 2019 | 2018
 | Note | £m | £m
Net trade receivables | 18 | 24.9 | 25.4
Accrued income | 18 | 28.0 | 26.7
Other receivables | 18 | 0.3 | 0.1
Cash and cash equivalents | 19 | 5.9 | 4.3
Total |  | 59.1 | 56.5


Question: In which years was the amount of total financial assets calculated?
Answer: 2019, 2018
Transactions involving stock options issued to employees are summarized as follows:
The expected life of awards granted represents the period of time that they are expected to be outstanding. The Company determines the expected life based on historical experience with similar awards, giving consideration to the contractual terms, vesting schedules, exercise patterns and pre-vesting and post-vesting forfeitures. The Company estimates the volatility of the Company’s common stock based on the calculated historical volatility of the Company’s common stock using the share price data for the trailing period equal to the expected term prior to the date of the award. The Company bases the risk-free interest rate used in the Black-Scholes option valuation model on the implied yield currently available on U.S. Treasury zero-coupon issues with an equivalent remaining term equal to the expected life of the award. The Company has not paid any cash dividends on the Company’s common stock and does not anticipate paying any cash dividends in the foreseeable future. Consequently, the Company uses an expected dividend yield of zero in the Black-Scholes option valuation model. The Company uses historical data to estimate pre-vesting option forfeitures and records share-based compensation for those awards that are expected to vest. In accordance with ASC 718-10, the Company calculates share-based compensation for changes to the estimate of expected equity award forfeitures based on actual forfeiture experience.
Table:
 | Number of Shares | Weighted Average Exercise Price Per Share
Outstanding at January 1, 2018 | 4,376,474 | $0.16
Granted | 67,394 | 0.17
Exercised | – | –
Cancelled or expired | (1,094,075) | 0.14
Outstanding at December 31, 2018 | 3,349,793 | $0.16
Granted | – | –
Exercised | – | –
Cancelled or expired | – | –
Outstanding at December 31, 2019 | 3,349,793 | $0.16


Question: Which stock option has the highest weighted average exercise price per share in 2018?
Answer: granted
Calculation: find the highest weighted average exercise price per share in 2018
ITEM 6. SELECTED FINANCIAL DATA
The selected financial data should be read in conjunction with our “Management’s Discussion and Analysis of Financial Condition and Results of Operations,” and our audited consolidated financial statements and the related notes to those consolidated financial statements included in this Annual Report.
Year-over-year comparisons are significantly affected by our acquisitions, dispositions and construction of towers. Our transaction with Verizon Communications Inc. (“Verizon” and the transaction, the “Verizon Transaction”) and the acquisition of a controlling ownership interest in Viom Networks Limited (“Viom” and the acquisition, the “Viom Acquisition”), which closed in March 2015 and April 2016, respectively, significantly impact the comparability of reported results between periods. Our principal 2019 acquisitions are described in note 7 to our consolidated financial statements included in this Annual Report.
(2) As of December 31, 2019, 2018, 2017, 2016 and 2015, amounts include $76.8 million, $96.2 million, $152.8 million, $149.3 million, and $142.2 million, respectively, of restricted funds pledged as collateral to secure obligations and cash, the use of which is otherwise limited by contractual provisions.
(3) Total assets as of December 31, 2019 includes the Right-of-use asset recognized in connection with our adoption of the new lease accounting standard described in note 1 to our consolidated financial statements included in this Annual Report
Table:
 |  |  | As of December 31, |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
(In millions) |  |  |  |  | 
Balance Sheet Data: |  |  |  |  | 
Cash and cash equivalents (including restricted cash) (2) | $1,578.0 | $1,304.9 | $954.9 | $936.5 | $462.9
Property and equipment, net | 12,084.4 | 11,247.1 | 11,101.0 | 10,517.3 | 9,866.4
Total assets (3) | 42,801.6 | 33,010.4 | 33,214.3 | 30,879.2 | 26,904.3
Long-term obligations, including current portion | 24,055.4 | 21,159.9 | 20,205.1 | 18,533.5 | 17,119.0
Redeemable noncontrolling interests | 1,096.5 | 1,004.8 | 1,126.2 | 1,091.3 | —
Total American Tower Corporation equity | 5,055.4 | 5,336.1 | 6,241.5 | 6,763.9 | 6,651.7


Question: What was the amount of net property and equipment in 2015?
Answer: 9,866.4
Property and Equipment
Property and equipment are stated at cost. Depreciation of these assets is generally computed using the straight-line method over their estimated useful lives based on asset class. As of December 31, 2019 and 2018, net property and equipment consisted of the following (in thousands):
Table:
 |  | December 31, | 
 | Useful Lives | 2019 | 2018
Computer and office equipment | 3 - 5 years | $143,942 | $129,359
Leasehold improvements lease | Lesser of useful life of improvement or remaining life of lease | 33,346 | 32,096
Furniture and fixtures | 7 years | 12,980 | 12,500
Building and improvements | 7 - 30 years | 14,553 | 14,381
Land | Non-depreciable | 1,785 | 1,785
Property and equipment, gross |  | 206,606 | 190,121
Less: accumulated depreciation |  | (136,226 ) | (117,392 )
Property and equipment, net |  | $ 70,380 | $ 72,729


Question: What was the cost of building and improvements in 2019?
Answer: 14,553
Note 21. Quarterly Results (Unaudited)
The following table presents the Company's selected unaudited quarterly operating results for the eight quarters ended March 31, 2019. The Company believes that all adjustments of a normal recurring nature have been made to present fairly the related quarterly results (in millions, except per share amounts). Amounts may not add to the total due to rounding:
Refer to Note 11, Income Taxes, for an explanation of the one-time transition tax recognized in the third quarter of fiscal 2018. Refer to Note 4, Special Charges and Other, Net, for an explanation of the special charges included in operating income in fiscal 2019 and fiscal 2018. Refer to Note 12, Debt and Credit Facility, for an explanation of the loss on settlement of debt included in other (loss) income, net of $4.1 million during the second quarter, $0.2 million during the third quarter, and $8.3 million during the fourth quarter of fiscal 2019 and $13.8 million and $2.1 million for the first quarter and third quarter of fiscal 2018, respectively. Refer to Note 5, Investments, for an explanation of the impairment recognized on available-for-sale securities in the fourth quarter of fiscal 2018.
Table:
Fiscal 2019 | First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total
Net sales | $1,212.5 | $1,432.5 | $1,374.7 | $1,329.8 | $5,349.5
Gross profit | $642.0 | $689.3 | $779.6 | $820.5 | $2,931.3
Operating income | $132.3 | $102.7 | $194.7 | $284.6 | $714.3
Net income from continuing operations | $35.7 | $96.3 | $49.2 | $174.7 | $355.9
Diluted net income per common share | $0.14 | $0.38 | $0.20 | $0.70 | $1.42


Question: What was the total gross profit?
Answer: 2,931.3
7. Earnings Per Share
The following is a reconciliation of the amounts utilized in the computation of basic and diluted earnings per share for fiscal2 019, 2018 and 2017 (in thousands, except per share amounts):
In each of the fiscal years 2019, 2018 and 2017, share-based awards for approximately 0.1 million shares were not included in the computation of diluted earnings per share as they were antidilutive.
Table:
 | 2019 | 2018 | 2017
Net income | 108,616 | 13,040 | 112,062
Basic weighted average common shares outstanding | 30,271 | 33,003 | 33,612
Dilutive effect of share-based awards and options outstanding  | 803 | 916 | 941
Diluted weighted average shares outstanding | 31,074 | 33,919 | 34,553
Earnings per share: |  |  | 
Basic | 3.59 | 0.40 | 3.33
Diluted | 3.50 | 0.38 | 3.24


Question: What was the change in the Basic weighted average common shares outstanding between 2018 and 2019?
Answer: -3341
Calculation: 30,271-33,612
Dell purchases our products and services directly from us, as well as through our channel partners. Information about our revenue and receipts, and unearned revenue from such arrangements, for the periods presented consisted of the following (table in millions):
Sales through Dell as a distributor, which is included in reseller revenue, continues to grow rapidly.
Customer deposits resulting from transactions with Dell were $194 million and $85 million as of January 31, 2020 and February 1, 2019, respectively.
Table:
 |  | Revenue and Receipts |  | Unearned Revenue | 
 |  | For the Year Ended As of |  | As of | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018 | January 31, 2020 | February 1, 2019
Reseller revenue | $3,288 | $2,355 | $1,464 | $3,787 | $2,554
Internal-use revenue | 82 | 41 | 46 | 57 | 29
Collaborative technology project receipts | 10 | 4 | — | n/a | n/a


Question: What was the change in unearned reseller revenue between 2019 and 2020? 
Answer: 1233
Calculation: 3,787-2,554
Other income, net
The components of other income, net from continuing operations for the years ended December 31 are as follows:
In 2018, we recorded a $0.5 million adjustment to decrease the fair value of the Company's contingent consideration related to the Brink Acquisition. Also, during 2019 and 2018, the Company incurred a net loss on rental contracts of approximately $1.0 million and $0.9 million, respectively.
Table:
 | Year ended December 31 (in thousands) | 
 | 2019 | 2018
Foreign currency loss | $(83) | $(258)
Rental loss-net | (996) | (865)
Gain on sale of real estate | — | 649
Fair value adjustment contingent consideration | — | 450
Other | (424) | 330
Other income, net | $(1,503) | $306


Question: What is the change in Rental loss-net between December 31, 2018 and 2019?
Answer: -131
Calculation: (996)-(865)
ITEM 5. MARKET FOR REGISTRANT’S COMMON EQUITY, RELATED STOCKHOLDER MATTERS AND ISSUER PURCHASES OF EQUITY SECURITIES ITEM 5. MARKET FOR REGISTRANT’S COMMON EQUITY, RELATED STOCKHOLDER MATTERS AND ISSUER PURCHASES OF EQUITY SECURITIES
MARKET FOR COMMON STOCK
The Company’s common stock trades on NYSE American under the trading symbol “DIT”. As of October 31, 2019 the closing price of our common stock on NYSE American was $73.00 and there were 565,942 common shares outstanding. As of that date, the Company had approximately 521 persons holding common shares beneficially of which approximately 121 are shareholders of record (including direct participants in the Depository Trust Company). The following table reflects the range of the high and low closing prices per share of the Company’s common stock reported by NYSE American for fiscal 2019 and 2018.
Table:
 | Fiscal 2018 |  | Fiscal 2019 | 
 | High | Low | High | Low
4th Quarter | $100.00 | $73.41 | $89.00 | $ 81.10
3rd Quarter | 100.00 | 88.27 | 98.35 | 81.30
2nd Quarter | 101.51 | 88.01 | 99.87 | 84.10
1st Quarter | 99.75 | 77.92 | 97.85 | 86.61


Question: What is the percentage change in the high closing prices per share of the Company’s common stock reported by NYSE American between Quarter 4 of fiscal 2018 and 2019?
Answer: 12.36
Calculation: (100-89)/89
The long-term portion of the Company’s unrecognized tax benefits at March 31, 2019 and 2018 was $622,000 and $619,000, respectively, of which the timing of the resolution is uncertain. As of March 31, 2019 and 2018, $2.5 million and $2.1 million, respectively, of unrecognized tax benefits had been recorded as a reduction to net deferred tax assets.
As of March 31, 2019, the Company’s net deferred tax assets of $6.7 million are subject to a valuation allowance of $6.7 million. It is possible, however, that some months or years may elapse before an uncertain position for which the Company has established a reserve is resolved. A reconciliation of unrecognized tax benefits is as follows:
The unrecognized tax benefit balance as of March 31, 2019 of $599,000 would affect the Company’s effective tax rate if recognized.
Table:
 |  | Year Ended March 31,  | 
 | 2019 | 2018 | 2017
 |  | (In thousands) | 
Unrecognized tax benefits, beginning of period | $2,735 | $2,714 | $2,055
Additions based on tax positions related to current year | 371 | 520 | 730
Additions based on tax positions related to prior years | 13 | — | —
2017 Tax Act and tax rate re-measurement   | — | (499) | —
Reductions based on tax positions related to prior years   | (17) | — | —
Lapses during the current year applicable to statutes of limitations   | — | — | (71)
Unrecognized tax benefits, end of period | $3,102 | $2,735 | $2,714


Question: What was the Unrecognized tax benefits, beginning of period in 2019?
Answer: $2,735
VALUATION AND QUALIFYING ACCOUNTS
(Amounts in millions)
(A) Includes increases and reversals of allowances for sales returns, price protection, and valuation allowance for deferred tax assets due to normal reserving terms.
(B) Includes actual write-offs and utilization of allowances for sales returns, price protection, and releases of income tax valuation allowances and foreign currency translation and other adjustments.
Table:
Col. A Description | Col B. Balance at Beginning of Period | Col. C Additions(A) | Col. D Deductions(B) | Col. E Balance at End of Period
At December 31, 2019 |  |  |  | 
Allowances for sales returns and price protection and other allowances | $186 | $11 | $(79) | $118
Valuation allowance for deferred tax assets | $61 | $127 | $(7) | $181
At December 31, 2018 |  |  |  | 
Allowances for sales returns and price protection and other allowances | $274 | $24 | $(112) | $186
Valuation allowance for deferred tax assets | $— | $61 | $— | $61
At December 31, 2017 |  |  |  | 
Allowances for sales returns and price protection and other allowances | $257 | $83 | $(66) | $274


Question: What was the Valuation allowance for deferred tax assets at the end of the period of 2019?
Answer: $181
comparison of five-year cumulative total return the following graph compares the cumulative total return on citigroup 2019s common stock with the s&p 500 index and the s&p financial index over the five-year period extending through december 31 , 2009 . the graph assumes that $ 100 was invested on december 31 , 2004 in citigroup 2019s common stock , the s&p 500 index and the s&p financial index and that all dividends were reinvested . citigroup s&p 500 index s&p financial index 2005 2006 2007 2008 2009 comparison of five-year cumulative total return for the years ended .

Table:
december 31 | citigroup | s&p 500 index | s&p financial index
2005 | 104.38 | 104.83 | 106.30
2006 | 124.02 | 121.20 | 126.41
2007 | 70.36 | 127.85 | 103.47
2008 | 18.71 | 81.12 | 47.36
2009 | 9.26 | 102.15 | 55.27
.

Question: what was the difference in percent cumulative total return on citigroup's common stock compared to the s&p 500 index for five year period ended 2009?
Answer: -92.89%
Calculation: subtract(9.26, 100), divide(#0, 100), subtract(102.15, 100), divide(#2, 100), subtract(#1, #3)
the following table provides a summary of our historical capital expenditures related to the upgrading of our infrastructure and systems: .

Table:
( in millions ) | for the years ended december 31 , 2018 | for the years ended december 31 , 2017 | for the years ended december 31 , 2016
transmission and distribution | $ 572 | $ 551 | $ 568
treatment and pumping | 231 | 171 | 151
services meter and fire hydrants | 303 | 281 | 297
general structure and equipment | 371 | 281 | 202
sources of supply | 26 | 54 | 59
wastewater | 83 | 96 | 34
total capital expenditures | $ 1586 | $ 1434 | $ 1311
in 2018 , our capital expenditures increased $ 152 million , or 10.6% ( 10.6 % ) , primarily due to investment across the majority of our infrastructure categories .
in 2017 , our capital expenditures increased $ 123 million , or 9.4% ( 9.4 % ) , primarily due to investment in our general structure and equipment and wastewater categories .
we also grow our business primarily through acquisitions of water and wastewater systems , as well as other water-related services .
these acquisitions are complementary to our existing business and support continued geographical diversification and growth of our operations .
generally , acquisitions are funded initially with short- term debt , and later refinanced with the proceeds from long-term debt .
the following is a summary of the acquisitions and dispositions affecting our cash flows from investing activities : 2022 the majority of cash paid for acquisitions pertained to the $ 365 million purchase of pivotal within our homeowner services group .
2022 paid $ 33 million for 15 water and wastewater systems , representing approximately 14000 customers .
2022 received $ 35 million for the sale of assets , including $ 27 million for the sale of the majority of the o&m contracts in our contract services group during the third quarter of 2018 .
2022 the majority of cash paid for acquisitions pertained to the $ 159 million purchase of the wastewater collection and treatment system assets of the municipal authority of the city of mckeesport , pennsylvania ( the 201cmckeesport system 201d ) , excluding a $ 5 million non-escrowed deposit made in 2016 .
2022 paid $ 18 million for 16 water and wastewater systems , excluding the mckeesport system and shorelands ( a stock-for-stock transaction ) , representing approximately 7000 customers .
2022 received $ 15 million for the sale of assets .
2022 paid $ 199 million for 15 water and wastewater systems , representing approximately 42000 customers .
2022 made a non-escrowed deposit of $ 5 million related to the mckeesport system acquisition .
2022 received $ 9 million for the sale of assets .
as previously noted , we expect to invest between $ 8.0 billion to $ 8.6 billion from 2019 to 2023 , with $ 7.3 billion of this range for infrastructure improvements in our regulated businesses .
in 2019 , we expect to .

Question: total transmission and distribution expenses in millions for the three year period equaled what?
Answer: 1691
Calculation: table_sum(transmission and distribution, none)