hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
REVENUE
(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.
Fiscal 2019 fourth-quarter revenue increased by 3.1% (2.7% in constant currency) resulting from: • growth in the American broadband services segment mainly due to strong organic growth and the FiberLight acquisition. • stable revenue in the Canadian broadband services segment mainly as a result of: ◦ rate increases; partly offset by ◦ decreases in video and telephony services customers compared to the same period of the prior year primarily due to issues resulting from the implementation of a new customer management system in the second half of fiscal 2018.
Table:
Three months ended August 31, | 2019 (1) | 2018 (2) | Change | Change in constant currency (3) | Foreign exchange impact (3)
(in thousands of dollars, except percentages) | $ | $ | % | % | $ $
Canadian broadband services | 319,935 | 319,741 | 0.1 | 0.1 | -
American broadband services | 263,738 | 246,443 | 7.0 | 6.0 | 2,427
 | 583,673 | 566,184 | 3.1 | 2.7 | 2,427


Question: What was the exchange rate in 2018?
Answer: 1.3100 USD/CDN.
performance graph comparison of five-year cumulative total return the following graph and table compare the cumulative total return on citi 2019s common stock , which is listed on the nyse under the ticker symbol 201cc 201d and held by 77787 common stockholders of record as of january 31 , 2017 , with the cumulative total return of the s&p 500 index and the s&p financial index over the five-year period through december 31 , 2016 . the graph and table assume that $ 100 was invested on december 31 , 2011 in citi 2019s common stock , the s&p 500 index and the s&p financial index , and that all dividends were reinvested . comparison of five-year cumulative total return for the years ended date citi s&p 500 financials .

Table:
date | citi | s&p 500 | s&p financials
31-dec-2011 | 100.0 | 100.0 | 100.0
31-dec-2012 | 150.6 | 116.0 | 128.8
31-dec-2013 | 198.5 | 153.6 | 174.7
31-dec-2014 | 206.3 | 174.6 | 201.3
31-dec-2015 | 197.8 | 177.0 | 198.2
31-dec-2016 | 229.3 | 198.2 | 243.4
.

Question: what was the percent of the growth for s&p financials cumulative total return from 2013 to 2014
Answer: 15.2%
Calculation: subtract(201.3, 174.7)
Sales and Marketing Expenses
Sales and marketing expenses increased $105 million, or 36%, in 2019 compared to 2018. The overall increase was primarily due to increased employee compensation-related costs, including
amortization of capitalized commissions, of $72 million, driven by headcount growth, and an increase in marketing program costs of $8 million. The increase in marketing program costs was driven by increased volume of advertising activities. Further contributing to the overall increase was an increase in allocated shared costs of $14 million.
Sales and marketing expenses increased $80 million, or 38%, in 2018 compared to 2017. The overall increase was primarily due to increased employee compensation-related costs, including amortization of capitalized commissions, of $55 million, driven by headcount growth, and an increase in marketing program costs of $10 million. The increase in marketing program costs was driven by increased volume of advertising activities. Further contributing to the overall increase was an increase in allocated shared costs of $11 million.
Table:
 |  | Year Ended December 31, |  |  | 
 | 2019 | 2018 | 2017 | 2018 to 2019 % change | 2017 to 2018 % change
 |  |  | (In thousands, except percentages) |  | 
Sales and Marketing | $ 396,514 | $ 291,668 | $ 211,918 | 36% | 38%


Question: What is the percentage increase in sales and marketing expenses from 2017 to 2019?
Answer: 87.11
Calculation: (396,514 - 211,918) / 211,918
(8) Computer Software
Computer software, net consists of the following (in millions):
In the fourth quarter of 2019, we entered into agreements to acquire software in exchange for a combination of cash consideration and certain of our products and services. The software was acquired for $32.0 million, of which software valued at $6.5 million was received as of December 31, 2019 and resulted in non-cash investing activity of $4.8 million.
Table:
 | December 31, | 
 | 2019 | 2018
Internally developed software | $808.2 | $746.0
Purchased software | 78.9 | 60.7
Computer software | 887.1 | 806.7
Accumulated amortization | (481.1) | (401.1)
Computer software, net | $406.0 | $405.6


Question: How many years did internally developed software exceed $800 million?
Answer: 1
Calculation: 2019
Deferred Revenue and Customer Liabilities
Deferred revenue and customer liabilities consisted of the following (in thousands):
The Company expects to recognize the majority of its deferred revenue as of December 31, 2019 over the next 180 days. Revenues of $3.7 million were recognized during the year ended December 31, 2019 from amounts included in deferred revenue at December 31, 2018. Revenues of $4.4 million were recognized during the year ended December 31, 2018 from amounts included in deferred revenue at January 1, 2018.
The Company expects to recognize the majority of the customer arrangements with termination rights into revenue as the Company has not historically experienced a high rate of contract terminations.
Estimated refund liabilities are generally resolved in 180 days, once it is determined whether the requisite service levels and client requirements were achieved to settle the contingency.
Table:
 | December 31, | 
 | 2019 | 2018
Deferred revenue | $3,012 | $3,655
Customer arrangements with termination rights | 15,024 | 16,404
Estimated refund liabilities | 8,585 | 10,117
 | $26,621 | $30,176


Question: What was the percentage change in deferred revenue in 2019 from 2018?
Answer: -17.59
Calculation: (3,012-3,655)/3,655
7 Trade and other payables
(i) Recognition and measurement
Trade and other payables, including accruals, are recorded when the Group is required to make future payments as a result of purchases of assets or services provided to the Group prior to the end of financial period. The amounts are unsecured and are usually paid within 30 days of recognition. Trade and other payables are presented as current liabilities unless payment is not due within 12 months from the reporting date. They are recognised initially at their fair value and subsequently measured at amortised cost using the effective interest method.
(ii) Fair values of trade and other payables
Due to the short-term nature of trade and other payables, their carrying amount is considered to be the same as their fair value.
(iii) Risk Exposure
As the majority of payables are in Australian dollars, management does not believe there are any significant risks in relation to these financial liabilities. Refer to note 15 for details of the Group’s financial risk management policies.
Table:
 | 30 June 2019 | 30 June 2018
 | $'000 | $'000
Trade payables | 44,840 | 27,640
Accrued capital expenditure | 5,841 | 1,767
Accrued expenses | 2,848 | 2,114
Other creditors | 3,117 | 2,888
Total trade and other payables | 56,646 | 34,409


Question: What was the percentage change in total trade and other payables between 2018 and 2019?
Answer: 64.63
Calculation: (56,646 - 34,409) / 34,409
Segment Results of Operations
In the Company's Consolidated Financial Statements, other operating (income) expense includes (i) (gain) loss on sale or disposal of assets, (ii) lease termination costs, (iii)
asset impairment expense, (iv) accretion of asset retirement obligations, and (v) FCC reimbursements. Each table summarizes the results of operations of our operating
segments and compares the amount of the change between the periods presented (in millions).                                Marine Services Segment
Net revenue: Net revenue from our Marine Services segment for the year ended December 31, 2019 decreased $21.8 million to $172.5 million from $194.3 million for the year ended December 31, 2018. The decrease was primarily driven by a decline in the volume of projects under execution across multiple reporting lines, including power cable repair in offshore renewables, telecom installation work, and a reduction in CWind Group revenue due to focusing on a mix of more profitable projects.
Cost of revenue: Cost of revenue from our Marine Services segment for the year ended December 31, 2019 decreased $35.9 million to $127.1 million from $163.0 million for the year ended December 31, 2018. The decrease was driven by the reduction in revenue, improved vessel utilization, and higher than expected costs on a certain power construction project in the comparable period that were not repeated.
Selling, general and administrative: Selling, general and administrative expenses from our Marine Services segment for the year ended December 31, 2019 increased $5.6 million to $25.8 million from $20.2 million for the year ended December 31, 2018. The increase was primarily due to higher disposition costs in the fourth quarter of 2019 related to the sale of the Marine Services segment. This was partially offset by a reversal of an accrual of bad debt expense in the current period due to a favorable receivable settlement during the quarter. See Note 24. Subsequent Events for the summary of the subsequent events.
Depreciation and amortization: Depreciation and amortization from our Marine Services segment for the year ended December 31, 2019 decreased $1.5 million to $25.7 million from $27.2 million for the year ended December 31, 2018. The decrease was largely attributable to the disposal of assets during the year.
Other operating income: Other operating income decreased $0.7 million from $0.7 million of income for the year ended December 31, 2018, as a result of an impairment expense recorded in 2019 due to the under-utilization of assets on one of the segment's barges.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | Increase / (Decrease)
Net revenue | $172.5 | $194.3 | $(21.8)
Cost of revenue | 127.1 | 163.0 | (35.9)
Selling, general and administrative | 25.8 | 20.2 | 5.6
Depreciation and amortization | 25.7 | 27.2 | (1.5)
Other operating income | — | (0.7) | 0.7
Income (loss) from operations | $(6.1) | $(15.4) | $9.3


Question: What was the net revenue from Marine Services segment for the year ended December 31, 2019?
Answer: $172.5 million
13. Stock-Based Compensation:
Under the 2014 RSU Plan, we may grant restricted stock units of up to an aggregate of 3,000 units. Each unit converts to one share of the Company’s stock at the
time of vesting. The fair value of RSU awards is determined at the closing market price of the Company’s common stock at the date of grant. For the years ended March
31, 2018 and 2019, there were 292 and 315 awards, respectively, granted from this plan. Restricted stock activity during the year ended 2019 is as follows:
Performance-based awards vest one year after the grant date. Service-based awards vest as to one-third annually with the requisite service periods beginning on
the grant date. Awards are amortized over their respective grade-vesting periods. The total unrecognized compensation costs related to unvested stock awards expected
to be recognized over the vesting period, approximately three years, was $1,476 at March 31, 2019.
We have four fixed stock option plans. Under the 2004 Stock Option Plan, as amended, we may grant options to employees for the purchase of up to an aggregate
of 10,000 shares of common stock. Under the 2004 Non-Employee Directors’ Stock Option Plan, as amended, we may grant options for the purchase of up to an
aggregate of 1,000 shares of common stock. No awards were made under these two plans after August 1, 2013. Under the 2014 Stock Option Plan, we can grant options
to employees for the purchase of up to an aggregate of 10,000 shares of common stock. Under the 2014 Non-Employee Directors’ Stock Option Plan, as amended, we can
grant options to our directors for the purchase of up to an aggregate of 1,000 shares of common stock. Under all plans, the exercise price of each option shall not be less
than the market price of our stock on the date of grant and an option’s maximum term is 10 years. Options granted under the 2004 Stock Option Plan and the 2014 Stock
Option Plan vest as to 25% annually and options granted under the 2004 Non-Employee Directors’ Stock Option Plan and the 2014 Non-Employee Director’s Stock
Option Plan vest as to one-third annually. Requisite service periods related to all plans begin on the grant date. As of March 31, 2019, there were 12,447 shares of
common stock available for future issuance under all of the plans, consisting of options available to be granted and options currently outstanding.
Table:
 | March 31, 2019 | 
 | Number of shares | Weighted-Average Grant Date Fair Value per Share
Non-vested at March 31, 2018 | 358 | $16.27
Granted | 315 | 15.28
Vested | (172) | 16.27
Cancelled and forfeited | (68) | 16.27
Non-vested at March 31, 2019 | 433 | $15.55


Question: What is the percentage change in the number of nonvested shares between March 31, 2018 and 2019? 
Answer: 20.95
Calculation: (433 - 358)/358
A summary of our outstanding debt as of December 31, 2018, is as follows (amounts in millions):
Refer to Note 13 of the notes to the consolidated financial statements included in Item 8 of this Annual Report on Form 10-K for further disclosures regarding our debt obligations.
Table:
 |  |  | December 31, 2018
 | Gross Carrying Amount | Unamortized Discount and Deferred Financing Costs | Net Carrying Amount
2021 Notes | 650 | (3) | 647
2022 Notes | 400 | (3) | 397
2026 Notes | 850 | (8) | 842
2027 Notes | 400 | (5) | 395
2047 Notes | 400 | (10) | 390
Total debt | $2,700 | $(29) | $2,671


Question: What was the gross carrying amount in the 2021 Notes?
Answer: 650
entergy arkansas , inc . management's financial discussion and analysis results of operations net income 2004 compared to 2003 net income increased $ 16.2 million due to lower other operation and maintenance expenses , a lower effective income tax rate for 2004 compared to 2003 , and lower interest charges . the increase was partially offset by lower net revenue . 2003 compared to 2002 net income decreased $ 9.6 million due to lower net revenue , higher depreciation and amortization expenses , and a higher effective income tax rate for 2003 compared to 2002 . the decrease was substantially offset by lower other operation and maintenance expenses , higher other income , and lower interest charges . net revenue 2004 compared to 2003 net revenue , which is entergy arkansas' measure of gross margin , consists of operating revenues net of : 1 ) fuel , fuel-related , and purchased power expenses and 2 ) other regulatory credits . following is an analysis of the change in net revenue comparing 2004 to 2003. .

Table:
 | ( in millions )
2003 net revenue | $ 998.7
deferred fuel cost revisions | -16.9 ( 16.9 )
other | -3.4 ( 3.4 )
2004 net revenue | $ 978.4
deferred fuel cost revisions includes the difference between the estimated deferred fuel expense and the actual calculation of recoverable fuel expense , which occurs on an annual basis .
deferred fuel cost revisions decreased net revenue due to a revised estimate of fuel costs filed for recovery at entergy arkansas in the march 2004 energy cost recovery rider , which reduced net revenue by $ 11.5 million .
the remainder of the variance is due to the 2002 energy cost recovery true-up , made in the first quarter of 2003 , which increased net revenue in 2003 .
gross operating revenues , fuel and purchased power expenses , and other regulatory credits gross operating revenues increased primarily due to : 2022 an increase of $ 20.7 million in fuel cost recovery revenues due to an increase in the energy cost recovery rider effective april 2004 ( fuel cost recovery revenues are discussed in note 2 to the domestic utility companies and system energy financial statements ) ; 2022 an increase of $ 15.5 million in grand gulf revenues due to an increase in the grand gulf rider effective january 2004 ; 2022 an increase of $ 13.9 million in gross wholesale revenue primarily due to increased sales to affiliated systems ; 2022 an increase of $ 9.5 million due to volume/weather primarily resulting from increased usage during the unbilled sales period , partially offset by the effect of milder weather on billed sales in 2004. .

Question: what is the growth rate in net revenue in 2004 for entergy arkansas inc.?
Answer: -2.0%
Calculation: subtract(978.4, 998.7), divide(#0, 998.7)
14. Restructuring and Related Charges
Following is a summary of the Company’s restructuring and related charges (in thousands):
(1) Includes $21.5 million, $16.3 million and $51.3 million recorded in the EMS segment, $2.6 million, $16.6 million and $82.4 million recorded in the DMS segment and $1.8 million, $4.0 million and $26.7 million of non-allocated charges for the fiscal years ended August 31, 2019, 2018 and 2017, respectively. Except for asset write-off costs, all restructuring and related charges are cash settled.
(2) Fiscal year ended August 31, 2017, includes expenses related to the 2017 and 2013 Restructuring Plans.
Table:
 |  | Fiscal Year Ended August 31, | 
 | 2019 | 2018 | 2017(2)
Employee severance and benefit costs | $16,029 | $16,269 | $56,834
Lease costs | (41) | 1,596 | 3,966
Asset write-off costs | (3,566) | 16,264 | 94,346
Other costs | 13,492 | 2,773 | 5,249
Total restructuring and related charges(1) | $25,914 | $36,902 | $160,395


Question: What was the change in Employee severance and benefit costs between 2017 and 2018?
Answer: -40565
Calculation: 16,269-56,834
STOCK OPTIONS
The following is a summary of stock option activity during the years ended December 31, 2019 and 2018:
Table:
 | Number of Options Outstanding | Weighted Average Exercise Price | Average Remaining Contractual Life (in years) | Aggregate Intrinsic Value (thousands)
Outstanding – December 31, 2017 | 2,341,340 | $1.77 | 5.78 | $1,087
Options granted | 376,667 | 2.41 |  | 
Options exercised | 224,400 | 1.59 |  | 
Options forfeited | 6,961 | 1.42 |  | 
Outstanding – December 31, 2018 | 2,486,646 | $1.89 | 7.01 | $1,550
Options granted | 50,832 | 3.02 |  | 
Options exercised | - |  |  | 
Options forfeited | 181,281 | 2.23 |  | 
Outstanding – December 31, 2019 | 2,356,197 | $1.89 | 5.93 | $628
Exercisable – December 31, 2019 | 1,843,468 | $1.75 | 5.34 | $624


Question: What is the percentage change in outstanding options between 2018 and 2019?
Answer: -5.25
Calculation: (2,356,197 - 2,486,646)/2,486,646
SG&A costs during fiscal 2018 were $222.0 million, an increase of $5.7 million compared to the $216.3 million of SG&A during fiscal 2017. The following table shows the components of SG&A costs for the twelve months ended October 31, 2018 and 2017.
Regarding the table above, the change in start-up expense in any particular period relates to the stage of the start-up process in which a facility under construction is in during the period. Non-construction related expenses, such as labor, training and office-related expenses for a facility under construction are recorded as start-up expense until the facility begins operations. As a facility moves closer to actual start-up, the expenses incurred for labor, training, etc. increase. As a result, amounts classified as start-up expenses will increase period over period until the facility begins production. Once production begins, the expenses from that point forward are recorded as costs of goods sold. The increase in legal expenses was primarily attributable to our ongoing defense of the litigation described in “Part II, Item 3. Legal Proceedings” of this Form 10-K. The increases in trainee expense and administrative salaries were primarily attributable to increases in personnel that coincide with the Company's growth plans. The decrease in bonus expense, payouts of which are based on profitability, was the result of profitability not reaching the required levels for payout of that incentive. The decrease in ESOP expense, payouts of which are based on profitability, was attributable to the difference in the level of profitability between fiscal 2018 and 2017. The increase in all other SG&A expenses was the result of a net increase in various other categories of SG&A costs.
Table:
Selling, General and Administrative Costs (in thousands) |  |  | 
Description | Twelve months ended October 31, 2018 | Twelve months ended October 31, 2017 | Increase/(Decrease) 
Start-up expense (Tyler, Texas complex)  | $13,394 | $403 | $ 12,991
Legal services expense  | 17,573 | 7,879 | 9,694
All other SG&A  | 68,863 | 61,847 | 7,016
Administrative salary expense | 42,288 | 36,193 | 6,095
Trainee expense  | 21,553 | 16,182 | 5,371
Charter aircraft expense | 2,167 | 900 | 1,267
Depreciation expense - machinery and equipment  | 5,801 | 4,555 | 1,246
Stock compensation expense  | 15,702 | 16,952 | (1,250)
Marketing expense | 32,624 | 34,272 | (1,648)
Start-up expense (St. Pauls, North Carolina complex)  | — | 4,022 | (4,022)
Bonus award program expense  | — | 15,098 | (15,098)
Employee Stock Ownership Plan ("ESOP") expense | 2,000 | 18,000 | (16,000)
Total SG&A  | $221,965 | $216,303 | $ 5,662


Question: What is the average Charter aircraft expense for fiscal years 2018 and 2017?
Answer: 1533.5
Calculation: (2,167+ 900)/2
VALUATION AND QUALIFYING ACCOUNTS
(in millions)
Foreign exchange and other includes the impact of foreign exchange and certain immaterial reclassifications.
Table:
 | Allowances For | 
 | Financing Receivables | Accounts Receivable
Year ended July 29, 2017 |  | 
Balance at beginning of fiscal year . | $375 | $249
Provisions (benefits) | (35) | 27
Recoveries (write-offs), net . | (49) | (61)
Foreign exchange and other . | 4 | (4)
Balance at end of fiscal year | $295 | $211
Year ended July 28, 2018 |  | 
Balance at beginning of fiscal year . | $295 | $211
Provisions (benefits) | (89) | (45)
Recoveries (write-offs), net . | (6) | (37)
Foreign exchange and other . | 5 | —
Balance at end of fiscal year | $205 | $129
Year ended July 27, 2019 |  | 
Balance at beginning of fiscal year | $205 | $129
Provisions (benefits) | (16) | 56
Recoveries (write-offs), net | (42) | (50)
Foreign exchange and other  . | (21) | 1
Balance at end of fiscal year | $126 | $136


Question: What was the percentage change in the balance at the end of fiscal year for financing receivables between 2018 and 2019?
Answer: -38.54
Calculation: (126-205)/205