hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
entergy corporation and subsidiaries management 2019s financial discussion and analysis regulatory asset associated with new nuclear generation development costs as a result of a joint stipulation entered into with the mississippi public utilities staff , subsequently approved by the mpsc , in which entergy mississippi agreed not to pursue recovery of the costs deferred by an mpsc order in the new nuclear generation docket . see note 2 to the financial statements for further discussion of the new nuclear generation development costs and the joint stipulation . net revenue utility following is an analysis of the change in net revenue comparing 2015 to 2014 . amount ( in millions ) .

Table:
 | amount ( in millions )
2014 net revenue | $ 5735
retail electric price | 187
volume/weather | 95
louisiana business combination customer credits | -107 ( 107 )
miso deferral | -35 ( 35 )
waterford 3 replacement steam generator provision | -32 ( 32 )
other | -14 ( 14 )
2015 net revenue | $ 5829
the retail electric price variance is primarily due to : 2022 formula rate plan increases at entergy louisiana , as approved by the lpsc , effective december 2014 and january 2015 ; 2022 an increase in energy efficiency rider revenue primarily due to increases in the energy efficiency rider at entergy arkansas , as approved by the apsc , effective july 2015 and july 2014 , and new energy efficiency riders at entergy louisiana and entergy mississippi that began in the fourth quarter 2014 .
energy efficiency revenues are largely offset by costs included in other operation and maintenance expenses and have a minimal effect on net income ; and 2022 an annual net rate increase at entergy mississippi of $ 16 million , effective february 2015 , as a result of the mpsc order in the june 2014 rate case .
see note 2 to the financial statements for a discussion of rate and regulatory proceedings .
the volume/weather variance is primarily due to an increase of 1402 gwh , or 1% ( 1 % ) , in billed electricity usage , including an increase in industrial usage and the effect of more favorable weather .
the increase in industrial sales was primarily due to expansion in the chemicals industry and the addition of new customers , partially offset by decreased demand primarily due to extended maintenance outages for existing chemicals customers .
the louisiana business combination customer credits variance is due to a regulatory liability of $ 107 million recorded by entergy in october 2015 as a result of the entergy gulf states louisiana and entergy louisiana business combination .
consistent with the terms of an agreement with the lpsc , electric customers of entergy louisiana will realize customer credits associated with the business combination ; accordingly , in october 2015 , entergy recorded a regulatory liability of $ 107 million ( $ 66 million net-of-tax ) .
see note 2 to the financial statements for further discussion of the business combination and customer credits. .

Question: in october 2015 , what was the ratio of the entergy recorded a regulatory liability to the tax liability
Answer: 62.12%
Calculation: subtract(107, 66), divide(#0, 66)
notes to consolidated financial statements uncertain tax provisions as described in note 1 , the company adopted fin 48 on january 1 , 2007 . the effect of adopting fin 48 was not material to the company 2019s financial statements . the following is a reconciliation of the company 2019s beginning and ending amount of unrecognized tax benefits ( in millions ) . .

Table:
balance at january 1 2007 | $ 53
additions based on tax positions related to the current year | 4
additions for tax positions of prior years | 24
reductions for tax positions of prior years | -6 ( 6 )
settlements | -5 ( 5 )
balance at december 31 2007 | $ 70
of the amount included in the previous table , $ 57 million of unrecognized tax benefits would impact the effective tax rate if recognized .
aon does not expect the unrecognized tax positions to change significantly over the next twelve months .
the company recognizes interest and penalties related to unrecognized income tax benefits in its provision for income taxes .
aon accrued potential penalties and interest of less than $ 1 million related to unrecognized tax positions during 2007 .
in total , as of december 31 , 2007 , aon has recorded a liability for penalties and interest of $ 1 million and $ 7 million , respectively .
aon and its subsidiaries file income tax returns in the u.s .
federal jurisdiction as well as various state and international jurisdictions .
aon has substantially concluded all u.s .
federal income tax matters for years through 2004 .
the internal revenue service commenced an examination of aon 2019s federal u.s .
income tax returns for 2005 and 2006 in the fourth quarter of 2007 .
material u.s .
state and local income tax jurisdiction examinations have been concluded for years through 2002 .
aon has concluded income tax examinations in its primary international jurisdictions through 2000 .
aon corporation .

Question: what is the percentual increase in the balance during the year 2007?
Answer: 32.07%
Calculation: divide(70, 53), subtract(#0, const_1)
Inventories
Inventories are stated at the lower of cost (first-in, first-out or weighted average cost) or net realizable value. Inventories are as follows (in thousands):
Table:
 | Fiscal year-end | 
 | 2019 | 2018
Purchased parts and assemblies | $134,298 | $137,566
Work-in-process | 174,550 | 186,240
Finished goods | 133,682 | 162,935
Total inventories | $442,530 | $486,741


Question: What was the percentage change in Finished goods from 2018 to 2019?
Answer: -17.95
Calculation: ((133,682-162,935)/162,935) * 100
Trade Receivables, Net
The carrying amounts reported in the Consolidated Balance Sheets for Trade receivables, net approximate their fair value because of their short-term nature.
A summary of Trade receivables, net of allowance for doubtful accounts is as follows (in millions):
In addition to the amounts above, we have unbilled receivables that we do not expect to collect within the next year included in Other non-current assets in our Consolidated Balance Sheets. Billings for these receivables are based on contractual terms. Refer to Note 11 — Other Non-Current Assets.
Table:
 | December 31, | 
 | 2019 | 2018
Trade receivables — billed | $136.6 | $136.6
Trade receivables — unbilled | 39.8 | 37.0
Trade receivables | 176.4 | 173.6
Allowance for doubtful accounts | (1.3) | (1.3)
Trade receivables, net | $175.1 | $172.3


Question: What was the percentage change in the net trade receivables between 2018 and 2019?
Answer: 1.63
Calculation: ((175.1-172.3)/172.3) * 100
CAPITAL EXPENDITURES
BCE capital expenditures totaled $3,988  million for the year, up $17 million over 2018. This corresponded to a capital intensity ratio of 16.6%, down 0.3 pts compared to last year. Capital spending in the year reflected the following:
• Greater capital investments in our wireless segment of $33 million in 2019, compared to 2018, as we advanced the build-out of our LTE-A network, continued to deploy wireless small-cells to expand capacity to support subscriber growth and increase network speeds, coverage and signal quality, as well as to expand data fibre backhaul in preparation for 5G technology
• A modest reduction in capital spending in our wireline segment of $10 million in 2019, compared to last year, as we continued to focus our investments on the ongoing deployment of FTTP to more homes and businesses, the roll-out of fixed WTTP to rural locations in Ontario and Québec, the connection of fibre Internet and TV services to more homes and businesses and the execution of business customer contracts
• Lower capital expenditures at Bell Media of $6 million in 2019, compared to 2018, mainly due to production equipment and IT upgrades in 2018
Table:
 | 2019 | 2018 | $ CHANGE | % CHANGE
Bell Wireless | 697 | 664 | (33) | (5.0%)
Capital intensity ratio | 7.6% | 7.5% |  | (0.1) pts
Bell Wireline | 3,183 | 3,193 | 10 | 0.3%
Capital intensity ratio | 25.8% | 26.0% |  | 0.2 pts
Bell Media | 108 | 114 | 6 | 5.3%
Capital intensity ratio | 3.4% | 3.7% |  | 0.3 pts
BCE | 3,988 | 3,971 | (17) | (0.4%)
Capital intensity ratio | 16.6% | 16.9% |  | 0.3 pts


Question: What is the % change in the capital intensity ratio for BCE?
Answer: 0.3 pts
In 2019 and 2018, we had pre-tax losses of $19,573 and $25,403 respectively, which are available for carry forward to offset future taxable income. We made determinations to provide full valuation allowances for our net deferred tax assets at the end of 2019 and 2018, including NOL carryforwards generated during the years, based on our evaluation of positive and negative evidence, including our history of operating losses and the uncertainty of generating future taxable income that would enable us to realize our deferred tax assets.
Deferred tax assets (liabilities) consist of the following:
In assessing the realization of deferred tax assets, management considers whether it is more likely than not that a portion of the net deferred assets will not be realized. The ultimate realization of the net deferred tax assets is dependent upon the generation of future taxable income during the periods in which those temporary differences become deductible. Based on the available objective evidence, management believes it is more likely than not that the net deferred tax assets at December 31, 2019 will not be realizable. Accordingly, management has maintained a full valuation allowance against its net deferred tax assets at December 31, 2019. The net change in the total valuation allowance for the 12 months ended December 31, 2019 was an increase of $1,816.
Table:
 | As of | As of
 | December 31, 2019 | December 31, 2018
Deferred tax assets: |  | 
Reserves and accruals | $62 | $45
Research and development credits and other credits | 1,730 | 1,635
Net operating loss carry forward | 27,907 | 25,733
Stock based compensation | 8,402 | 8,857
Other | 11 | 26
Total deferred tax assets | 38,112 | 36,296
Valuation allowance | (38,112) | (36,296)
Deferred tax assets after valuation allowance | — | —
Total deferred tax liability | — | —
Net deferred tax assets (liabilities) | $— | $—


Question: What is the net change in the total valuation allowance for the 12 months ended December 31, 2019?
Answer: Increase of $1,816
17. Financial Information About Segments
Our operations are divided into two reportable segments: Products and Licensing and Technology Development. The Products and Licensing segment develops and sells products or licenses technologies based on commercially viable concepts developed by the Technology Development segment. The Products and Licensing segment derives its revenue from product sales, funded product development and technology licenses.
Our engineers and scientists collaborate with our network of government, academic and industry experts to identify technologies and ideas with promising market potential. We then compete to win fee-for-service contracts from government agencies and industrial customers who seek innovative solutions to practical problems that require new technology. The Technology Development segment derives its revenue primarily from services. The Technology Development segment provides applied research to customers in our areas of focus.
Our President and Chief Executive Officer and his direct reports collectively represent our chief operating decision makers, and they evaluate segment performance based primarily on revenue and operating income or loss.
Information about the results of operations for each segment is set forth in the table below. There were no significant inter-segment sales during the years ended December 31, 2019 and 2018.
During the years ended December 31, 2019 and 2018, 32% and 24%, respectively, of our total sales took place outside the United States. Customers in China represented 11% of total revenues in the year ended December 31, 2019, while no other single country, outside of the United States, represented more than 10% of total revenues in the year ended December 31, 2018.
Table:
 | Years ended December 31, | 
 | 2019 | 2018
Products and Licensing revenue | $44,491,041 | $21,949,689
Technology Development revenue | 26,024,674 | 20,967,556
Total revenue | $70,515,715 | $42,917,245
Products and Licensing operating income | $1,807,616 | $499,323
Technology Development operating income  | 1,507,405 | 378,212
Total operating income | $3,315,021 | $877,535
Depreciation, Technology Development | $397,296 | $379,952
Depreciation, Products and Licensing  | $552,285 | $273,185
Amortization, Technology Development  | $91,185 | $130,765
Amortization, Products and Licensing | $1,462,525 | $418,349


Question: What was the Technology Development revenue in 2019 and 2018 respectively?
Answer: 26,024,674, 20,967,556
Retail TV
(1) As of January 1, 2019, we are no longer reporting wholesale subscribers in our TV subscriber base reflecting our focus on the retail market. Consequently, we restated previously reported 2018 subscribers for comparability.
Retail IPTV net subscriber activations decreased by 17.4% in 2019, compared to last year, resulting from the impact of a maturing Fibe TV market, slower new service footprint growth and greater substitution of traditional TV services with OTT services, partly offset by higher Alt TV activations.
Retail satellite TV net customer losses improved by 4.3% compared to 2018, attributable to lower deactivations, reflecting a more mature subscriber base geographically better-suited for satellite TV service.
Total retail TV net subscriber activations (IPTV and satellite TV combined) decreased by 71.9% in 2019, compared to last year, due to lower IPTV net activations, moderated by fewer satellite TV net losses.
Retail IPTV subscribers at December 31, 2019 totaled 1,767,182, up 5.5% from 1,675,706 subscribers reported at the end of 2018.
Retail satellite TV subscribers at December 31, 2019 totaled 1,005,282, down 7.8% from 1,090,705 subscribers at the end of last year.
Total retail TV subscribers (IPTV and satellite TV combined) at December 31, 2019 were 2,772,464, representing a 0.2% increase since the end of 2018.
Table:
 | 2019 | 2018 | CHANGE | % CHANGE
Retail net subscriber activations (losses) (1) | 6,053 | 21,559 | (15,506) | (71.9%)
IPTV | 91,476 | 110,790 | (19,314) | (17.4%)
Satellite | (85,423) | (89,231) | 3,808 | 4.3%
Total retail subscribers (1) | 2,772,464 | 2,766,411 | 6,053 | 0.2%
IPTV | 1,767,182 | 1,675,706 | 91,476 | 5.5%
Satellite | 1,005,282 | 1,090,705 | (85,423) | (7.8%)


Question: What resulted in the change in the retail IPTV net subscriber activations in 2019?
Answer: the impact of a maturing Fibe TV market, slower new service footprint growth and greater substitution of traditional TV services with OTT services, partly offset by higher Alt TV activations
Operating Expense
Sales and Marketing
Sales and marketing expenses increased $122.8 million, or 35.1%, for the year ended December 31, 2019 compared to the same period in 2018, due to an increase of $70.4 million in expenditures on marketing programs to support the growth of our business, such as advertisements on search engines and social media, brand campaigns, event sponsorships and payments to partners. Employee-related costs increased $48.7 million ($14.1 million of which related to stock-based compensation and related payroll taxes) to support the growth of the business including in Shopify Plus and International operations. Computer hardware and software costs increased by $3.7 million, largely due to the growth in sales and marketing headcount
Sales and marketing expenses increased $124.4 million, or 55.1%, for the year ended December 31, 2018 compared to the same period in 2017, primarily due to an increase of $80.7 million in employee-related costs. In addition to employee-related costs, marketing costs increased by $39.7 million and computer hardware and software costs increased by $4.0 million.
Table:
 | Years ended December 31, |  |  | 2019 vs 2018 | 2018 vs 2017
 | 2019 | 2018 | 2017 | % Change | % Change
 | (in thousands, except percentages) |  |  |  | 
Sales and marketing | $ 472,841 | $ 350,069 | $ 225,694 | 35.1 % | 55.1 %
Percentage of total revenues | 30.0 % | 32.6 % | 33.5 % |  | 


Question: How much did sales and marketing expenses increase by for year ended 2019 compared to year ended 2018?
Answer: $122.8 million
A non-employee director who is initially appointed after any annual meeting of stockholders will receive a restricted stock unit award or option grant on the date of his or her initial appointment to the Board of Directors equal to the pro-rated amount of the annual grant
Annual option grants and restricted stock unit awards (or any pro-rated grants for directors initially appointed between annual meetings) vest on the earlier to occur of the first anniversary of the date of grant or the next annual meeting of stockholders. No portion of an option automatically granted to a director is exercisable after the tenth anniversary after the date of option grant. Additionally, an option automatically granted to a director may be exercisable after the termination of the director’s services as described in the option agreement, generally ending three months after such termination.
The following table shows compensation information for our non-employee directors for fiscal year 2019.
2019 Director Compensation Table
(1) The amounts reflected in this column represent the aggregate grant date fair value for stock awards granted to our non-employee directors in 2019, measured in accordance with ASC 718, excluding the effect of estimated forfeitures, and do not reflect whether the recipient has actually realized a financial benefit from these awards. For the methodology of how the aggregate grant date fair value amount is calculated, please see Note 13 of the Notes to Consolidated Financial Statements included in this Form 10-K. The aggregate number of shares subject to unvested restricted stock unit awards outstanding for each non-employee director at December 31, 2019 was: Mr. Hill: 5,889; Ms. Antonellis: 5,889; Mr. Habiger: 5,889; Ms. Molina: 5,889; Mr. Riedel: 5,889 and Mr. Seams: 5,889. None of the non-employee directors held any stock options as of December 31, 2019.
Table:
Name | Fees Earned or Paid in Cash ($) | Stock Awards ($) | Option Awards ($) | Total($)
Richard S. Hill | $106,000 | $149,987 | — | $255,987
Darcy Antonellis | $55,333 | $149,987 | — | $205,320
David C. Habiger | $70,000 | $149,987 | — | $219,987
V. Sue Molina | $81,000 | $149,987 | — | $230,987
George A. Riedel | $68,333 | $149,987 | — | $218,320
Christopher A. Seams | $82,000 | $149,987 | — | $231,987


Question: What does the table show?
Answer: compensation information for our non-employee directors for fiscal year 2019
Trade Accounts Receivable
The Company’s trade accounts receivable, net, consisted of the following (in thousands):
(1) Included in “Receivables, net” in the accompanying Consolidated Balance Sheets.
(2) Included in “Deferred charges and other assets” in the accompanying Consolidated Balance Sheets.
The Company’s noncurrent trade accounts receivable result from (1) contracts with customers that include renewal provisions, and (2) contracts with customers under multi-year arrangements. For contracts that include renewal provisions, revenue is recognized up-front upon satisfaction of the associated performance obligations, but payments are received upon renewal. Renewals occur in bi-annual and annual increments over the associated expected contract term, the majority of which range from two to five years. The Company’s contracts with customers under multi-year arrangements generally have three-year terms and are invoiced annually at the beginning of each annual coverage period. The Company records a receivable related to revenue recognized under multi-year arrangements as the Company has an unconditional right to invoice and receive payment in the future related to these arrangements.
Where the timing of revenue recognition differs from the timing of invoicing and payment, the Company has determined that its contracts do not include a significant financing component. A substantial amount of the consideration promised by the customer under the contracts that include renewal provisions is variable, and the amount and timing of that consideration varies based on the occurrence or nonoccurrence of future events that are not substantially within the Company’s control. With respect to multi-year year arrangements, there is minimal difference between the consideration received and the cash selling price, any offered discounts are driven by volume, and the contracts are of short duration resulting in insignificant interest. Thus, the primary purpose of the invoicing terms on the multi-year arrangements is to provide the customer with a simplified and predictable way of purchasing certain products, not to provide financing or to receive financing from the Company’s customer.
Table:
 | December 31, | 
 | 2019 | 2018
Trade accounts receivable, net, current (1) | $375,136 | $335,377
Trade accounts receivable, net, noncurrent (2) | 26,496 | 15,948
 | $401,632 | $351,325


Question: In which year was the Trade accounts receivable, net, current larger?
Answer: 2019
Calculation: 375,136>335,377
Total Restructuring Reserves
Restructuring reserves included on the Consolidated Balance Sheets were as follows:
Table:
 |  | Fiscal Year End
 | 2019 | 2018
 |  | (in millions)
Accrued and other current liabilities | $  245 | $  141
Other liabilities | 19 | 26
Restructuring reserves | $  264 | $  167


Question: In which year was Other liabilities larger?
Answer: 2018
Calculation: 26>19
The following table presents a reconciliation of revenue to constant currency revenue (in thousands, except for revenue growth):
Total revenue growth declined to 7% in 2019 from 12% in 2018. Our growth rate can depend on a variety of factors, such as new customers, the size, volume, and complexity of our agreements with our customers, foreign currency movements, our ability to work with our customers to implement and deliver our products, our ability to upsell and renew our existing customers, the success of our alliance and partnership arrangements, and the expansion of our business through emerging markets. The decline in the growth rate of total revenue was driven by our strategic plan to transition away from one-time professional services and recommit our efforts to grow recurring revenue and free cash flows.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Revenue | $576,523 | $537,891 | $481,985
Foreign exchange effect on current period revenue using prior year rates | 7,077 | (5,291) | 5,865
Constant currency revenue | $583,600 | $532,600 | $487,850
Revenue growth | 7.2% | 11.6% | 13.9%
Constant currency revenue growth | 8.5% | 10.5% | 15.3%


Question: What was the change in Revenue between 2017 and 2018?
Answer: 55906
Calculation: ($537,891-$481,985)
Amortization of Intangibles and Acquisition-Related Costs
Amortization of intangibles included in operating expense and acquisition-related costs during fiscal years 2019 , 2018 and 2017 were as follows (in thousands):
Amortization of intangible assets consists of amortization of acquired intangible assets, including customer relationships and trademarks and trade names. Acquisition-related costs include legal expense, due diligence costs, and other professional costs incurred for business acquisitions.
The increase in amortization of intangible assets from fiscal year 2018 to 2019 was primarily due to the Blue Microphones Acquisition and the ASTRO Acquisition. The increase in amortization of intangible assets from fiscal year 2018 to 2017 was primarily driven by the ASTRO Acquisition.
Table:
 |  | Years Ended March 31, | 
 | 2019 | 2018 | 2017
Amortization of intangible assets | $12,594 | $7,518 | $4,352
Acquisition-related costs | 1,696 | 1,412 | 1,462
Total | $14,290 | $8,930 | $5,814


Question: In which year was primarily driven by ASTRO Acquisition
Answer: from fiscal year 2018 to 2017