hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
(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. For further details, please consult the "Accounting policies" section. (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.
REVENUE Fiscal 2019 fourth-quarter revenue increased by 7.0% (6.0% in constant currency). In local currency, revenue amounted to US$199.5 million compared to US$188.1 million for the same period of fiscal 2018. The increase resulted mainly from: • rate increases; • activation of bulk properties in Florida during the fourth quarter of fiscal 2019; • continued growth in Internet service customers; and • the FiberLight acquisition completed in the first quarter of fiscal 2019; partly offset by • a decrease in video service customers.
OPERATING EXPENSES Fiscal 2019 fourth-quarter operating expenses increased by 8.6% (7.6% in constant currency) mainly as a result of: • programming rate increases; • the FiberLight acquisition completed in the first quarter of fiscal 2019; • higher compensation expenses due to higher headcount to support growth; and • higher marketing initiatives to drive primary service units growth.
ADJUSTED EBITDA Fiscal 2019 fourth-quarter adjusted EBITDA increased by 5.1% (4.1% in constant currency). In local currency, adjusted EBITDA amounted to US$87.4 million compared to US$83.9 million for the same period of fiscal 2018. The increase was mainly due to organic growth combined with the impact of the FiberLight acquisition.
ACQUISITIONS OF PROPERTY, PLANT AND EQUIPMENT Fiscal 2019 fourth-quarter acquisitions of property, plant and equipment decreased by 9.5% (10.5% in constant currency) mainly due to: • lower purchases of customer premise equipment due to the timing of certain initiatives; and • lower capital expenditures due to the timing of certain initiatives; partly offset by • additional capital expenditures related to the expansion in Florida.
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) | $ | $ | % | % | $
Revenue | 263,738 | 246,443 | 7.0 | 6.0 | 2,427
Operating expenses | 148,215 | 136,506 | 8.6 | 7.6 | 1,370
Adjusted EBITDA | 115,523 | 109,937 | 5.1 | 4.1 | 1,057
Adjusted EBITDA margin | 43.8% | 44.6% |  |  | 
Acquisitions of property, plant and equipment | 65,967 | 72,914 | (9.5) | (10.5) | 704
Capital intensity | 25.0% | 29.6% |  |  | 


Question: What was the average Adjusted EBITDA?
Answer: 112730
Calculation: (115,523 + 109,937) / 2
Cash Flows
The following table summarizes key cash flow activity for the years ended December 31, 2019, 2018, and 2017 (in thousands):
Operating Activities
The increase in net cash provided by operating activities during 2019 was primarily driven by higher cash proceeds from sales of systems projects, including the Sunshine Valley, Sun Streams, and California Flats projects, and advance payments received for sales of solar modules prior to the step down in the U.S. investment tax credit as discussed above. These increases were partially offset by operating expenditures associated with initial ramp of certain Series 6 manufacturing lines and expenditures for the construction of certain projects.
Investing Activities
The decrease in net cash used in investing activities during 2019 was primarily due to higher net sales of marketable securities and restricted investments, partially offset by proceeds associated with the sale of our interests in 8point3 and its subsidiaries in 2018.
Financing Activities
The decrease in net cash provided by financing activities during 2019 was primarily the result of lower net proceeds from borrowings under project specific debt financings associated with the construction of certain projects in Australia, Japan, and India.
Table:
 | 2019 | 2018 | 2017
Net cash provided by (used in) operating activities | $174,201 | $(326,809) | $1,340,677
Net cash used in investing activities | (362,298) | (682,714) | (626,802)
Net cash provided by financing activities | 74,943 | 255,228 | 192,045
Effect of exchange rate changes on cash, cash equivalents and restricted cash. | (2,959) | (13,558) | 8,866
Net (decrease) increase in cash, cash equivalents and restricted cash | $(116,113) | $(767,853) | $914,786


Question: What are the reasons for the decrease in cash provided by financing activities?
Answer: The decrease in net cash provided by financing activities during 2019 was primarily the result of lower net proceeds from borrowings under project specific debt financings associated with the construction of certain projects in Australia, Japan, and India.
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: How much was the trade payables for 2019?
Answer: 44,840
Non-operating income (expense), net
Non-operating income (expense), net, decreased primarily due to the absence of the fiscal 2018 $653 million gain on the divestiture of our WSS and PKI solutions. In addition, our loss from our equity interest received in connection with the divestiture of our WSS and PKI solutions increased $75 million, which was partially offset by a $48 million decrease in interest expense as a result of lower outstanding borrowings due to repayments.
Table:
 | Fiscal Year |  | 
(In millions) | 2019 | 2018 | Variance in Dollars
Interest expense | $(208) | $(256) | $48
Gain on divestiture | — | 653 | (653)
Interest income | 42 | 24 | 18
Loss from equity interest | (101) | (26) | (75)
Foreign exchange loss | (18) | (28) | 10
Other | 13 | 21 | (8)
Total other income (expense), net | $(272) | $388 | $(660)


Question: What was the total other income (expense), net for both fiscal years?
Answer: 116
Calculation: -272+388
2016 Collective Bargaining Negotiations
During 2016, we adopted changes to our defined benefit pension plans and other postretirement benefit plans to reflect the agreed upon terms and conditions of the collective bargaining agreements ratified in June 2016. The impact includes a net increase to Accumulated other comprehensive income of $2.9 billion (net of taxes of $1.8 billion).
The amount recorded in Accumulated other comprehensive income will be reclassified to net periodic benefit cost on a straight-line basis over the average remaining service period of the respective plans’ participants, which, on a weighted-average basis, is 12.2 years for defined benefit pension plans and 7.8 years for other postretirement benefit plans.
The above-noted reclassification resulted in a decrease to net periodic benefit cost and increase to pre-tax income of approximately $658 million during 2019, 2018 and 2017, respectively. Information for pension plans with an accumulated benefit obligation in excess of plan assets follows:
Information for pension plans with an accumulated benefit obligation in excess of plan assets follows:
Table:
 |  | (dollars in millions)
At December 31, | 2019 | 2018
Projected benefit obligation | $ 21,190 | $ 19,510
Accumulated benefit obligation | 21,134 | 19,461
Fair value of plan assets | 19,388 | 17,757


Question: What is the duration of postretirement benefit plan over which the amount will be reclassified?
Answer: 7.8 years
35 Related party transactions
Key management1 compensation
1 Key management comprises the directors of intu properties plc and the Executive Committee who have been designated as persons discharging managerial responsibility (PDMR).
During 2017 the Group’s joint ventures in intu Puerto Venecia and intu Asturias sold shares in subsidiaries, previously wholly owned by the respective joint ventures, listed on the Spanish MaB to PDMRs of the Group. The total value of the shares at 31 December 2019 is €1.0 million for each joint venture, representing 1 per cent of the respective outstanding share capital. The sale of shares in these entities was required to comply with Spanish MaB free float listing requirements. The Group provided an interest-free loan to PDMRs to enable them to purchase the shares. The loans are treated as a taxable benefit which accordingly is included in the above table. In line with the terms of the relevant loan agreements entered into, the loans are repayable in full upon cessation of employment or the sale of the underlying assets. Further to the exchange of contracts in respect of the sale of intu Puerto Venecia in December 2019 and of intu Asturias in January 2020, the relevant PDMRs sold these shareholdings in January 2020 and February 2020 respectively. All outstanding loans in respect of the above arrangements have been repaid to the Company in full or in part. For those loans which have been partially repaid, the outstanding balance has been written off by the Company.
Table:
Key management1 compensation |  | 
£m | 2019 | 2018
Salaries and short-term employee benefits | 4.7 | 4.9
Pensions and other post-employment benefits | 0.3 | 0.8
Share-based payments | 1.5 | 1.7
 | 6.5 | 7.4


Question: What is the total value of shares at 31 December 2019 for each joint venture?
Answer: €1.0 million
OFF-BALANCE SHEET ARRANGEMENTS AND CONTRACTUAL OBLIGATIONS
At June 30, 2019, the Company’s total off-balance sheet contractual obligations were $665,107. This balance consists of $71,633 of long-term operating leases for various facilities and equipment which expire from 2020 to 2030 and $593,474 of purchase commitments. In fiscal 2017, JHA entered a strategic services agreement with First Data® and PSCU® to provide full-service debit and credit card processing on a single platform to all existing core bank and credit union customers, as well as expand its card processing platform to financial institutions outside our core customer base. This agreement includes a purchase commitment of $555,754 over the remaining term of the contract. The remainder of the purchase commitments relate mainly to open purchase orders. The contractual obligations table below excludes $12,009 of liabilities for uncertain tax positions as we are unable to reasonably estimate the ultimate amount or timing of settlement.
The operating lease obligations included on this table will be recorded on the balance sheet beginning in fiscal 2020 due to the Company’s adoption of ASU No. 2016-02, issued by the FASB in February 2016 and effective for the Company on July 1, 2019.
Table:
Contractual obligations by period as of June 30, 2019 | Less than 1 year | 1-3 years | 3-5 years | More than 5 years | TOTAL
Operating lease obligations | $15,559 | $25,399 | $19,004 | $11,671 | $71,633
Purchase obligations | 62,637 | 86,875 | 107,188 | 336,774 | 593,474
Total | $78,196 | $112,274 | $126,192 | $348,445 | $665,107


Question: Between total operating lease obligations and total purchase obligations, which is higher?
Answer: Purchase obligations
Calculation: 593,474>71,633
CREDIT FACILITIES
Bell Canada may issue notes under its Canadian and U.S. commercial paper programs up to the maximum aggregate principal amount of $3 billion in either Canadian or U.S. currency provided that at no time shall such maximum amount of notes exceed $4 billion in Canadian currency which equals the aggregate amount available under Bell Canada’s committed supporting revolving and expansion credit facilities as at December 31, 2019. The total amount of the net available committed revolving and expansion credit facilities may be drawn at any time.
The table below is a summary of our total bank credit facilities at December 31, 2019.
(1) Bell Canada’s $2.5 billion and additional $500 million committed revolving credit facilities expire in November 2024 and November 2020, respectively, and its $1 billion committed expansion credit facility expires in November 2022. Bell Canada has the option, subject to certain conditions, to convert advances outstanding under the additional $500 million revolving credit facility into a term loan with a maximum one-year term.
(2) As of December 31, 2019, Bell Canada’s outstanding commercial paper included $1,502 million in U.S. dollars ($1,951 million in Canadian dollars). All of Bell Canada’s commercial paper outstanding is included in debt due within one year.
Table:
 | TOTAL AVAILABLE | DRAWN | LETTERS OF CREDIT | COMMERCIAL PAPER OUTSTANDING | NET AVAILABLE
Committed credit facilities |  |  |  |  | 
Unsecured revolving and expansion credit facilities (1) (2) | 4,000 | – | – | 1,951 | 2,049
Other | 106 | – | 106 | – | –
Total committed credit facilities | 4,106 | – | 106 | 1,951 | 2,049
Total non-committed credit facilities | 1,939 | – | 1,059 | – | 880
Total committed and non-committed credit facilities | 6,045 | – | 1,165 | 1,951 | 2,929


Question: What is the ratio of the net available total committed credit facilities over the net available total non-committed credit facilities?
Answer: 2.33
Calculation: 2,049/880
Other (Income) and Expense
NM—Not meaningful
Total consolidated other (income) and expense was income of $968 million in 2019 compared to expense of $1,152 million in 2018. The year-to-year change was primarily driven by: • Lower non-operating retirement-related costs ($957 million). Refer to “Retirement-Related Plans” for additional information. • Higher gains from divestitures ($833 million) reflected in Other; and • Higher net exchange gains (including derivative instruments) ($272 million). The company’s hedging programs help mitigate currency impacts in the Consolidated Income Statement.
Operating (non-GAAP) other (income) and expense was $1,431 million of income in 2019 and increased $1,010 million compared to the prior-year period. The year-to-year change was primarily driven by the same factors excluding lower non-operating retirement-related costs.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2019 | 2018 | Yr.-to-Yr. Percent Change
Other (income) and expense |  |  | 
Foreign currency transaction losses/(gains) | $(279) | $(427) | (34.6)%
(Gains)/losses on derivative instruments | 15 | 434 | (96.6)
Interest income | (349) | (264) | 32.2
Net (gains)/losses from securities and investment assets | (32) | (101) | (67.9)
Retirement-related costs/(income) | 615 | 1,572 | (60.9)
Other | (937) | (63) | NM
Total consolidated other (income) and expense | $(968) | $1,152 | NM
Non-operating adjustments |  |  | 
Amortization of acquired intangible assets | (2) | (2) | 50.0%
Acquisition-related charges | 154 | 0 | NM
Non-operating retirement related costs/(income) | (615) | (1,572) | (60.9)%
Operating (non-GAAP) other (income) and expense | $(1,431) | $(422) | 239.4%


Question: What is the increase / (decrease) in the interest income from 2018 to 2019?
Answer: -85
Calculation: -349 - (-264)
Net Asset Value per share (NAV/share):
TORM believes that the NAV/share is a relevant measure that Management uses to measure the overall development of the assets and liabilities per share. Such measure may not be comparable to similarly titled measures of other companies. NAV/share is calculated using broker values of vessels and excluding charter commitments. NAV/share is calculated as follows:
Table:
USDm | 2019 | 2018 | 2017
Net Asset Value per share |  |  | 
Total vessel values including newbuildings (broker values) | 1,801.5 | 1,675.1 | 1,661.1
Committed CAPEX on newbuildings | -51.2 | -258.0 | -306.9
Cash position | 72.5 | 127.4 | 134.2
Loans receivables | 4.6 | - | -
Bunkers | 34.8 | 39.4 | 33.2
Freight receivables | 89.8 | 86.0 | 71.3
Other receivables | 6.2 | 7.5 | 11.8
Other plant and operating equipment | 4.3 | 3.0 | 1.9
Land and buildings | 8.1 | - | -
Investments in joint ventures | 1.2 | 0.1 | 0.3
Prepayments | 3.5 | 2.9 | 4.4
Borrowings | -863.4 | -754.7 | -753.9
Trade payables | -47.1 | -35.1 | -26.2
Other liabilities | -47.3 | -36.5 | -33.8
Current tax liabilities | -1.5 | -1.0 | -1.4
Total Net Asset Value (NAV) | 1,016.0 | 856.1 | 796.0
Total number of shares excluding treasury shares (million) | 74.4 | 73.9 | 62.0
Total Net Asset Value per share (NAV/share) (USD) | 13.6 | 11.6 | 12.8


Question: What was the percentage change in the Total Net Asset Value (NAV) in 2019 from 2018?
Answer: 18.68
Calculation: (1,016.0-856.1)/856.1
( 3 ) refer to note 2 201csummary of significant accounting principles and practices 201d for further information . 13 . employee benefitsp y defined contribution savings plans aon maintains defined contribution savings plans for the benefit of its employees . the expense recognized for these plans is included in compensation and benefits in the consolidated statements of income . the expense for the significant plans in the u.s. , u.k. , netherlands and canada is as follows ( in millions ) : .

Table:
years ended december 31 | 2018 | 2017 | 2016
u.s . | $ 98 | $ 105 | $ 121
u.k . | 45 | 43 | 43
netherlands and canada | 25 | 25 | 27
total | $ 168 | $ 173 | $ 191
pension and other postretirement benefits the company sponsors defined benefit pension and postretirement health and welfare plans that provide retirement , medical , and life insurance benefits .
the postretirement health care plans are contributory , with retiree contributions adjusted annually , and the aa life insurance and pension plans are generally noncontributory .
the significant u.s. , u.k. , netherlands and canadian pension plans are closed to new entrants. .

Question: considering the years 2016-2018 , what is the average expense for the significant plans in the u.s.?
Answer: 108
Calculation: table_average(u.s ., none)
(1) Includes construction costs capitalized related to build-to-suit facilities:
As of March 31, 2019 and 2018, the U.S. build-to-suit facility includes company-funded building improvements of $5.2 million and $4.5 million, respectively. In March 2019, the Company derecognized the U.K. build-to-suit facility upon substantial completion of construction. See Note 12 for further details.
Table:
 | As of March 31, | 
 | 2019 | 2018
U.S. build-to-suit facility | $47,001 | $43,925
U.K. build-to-suit facility | — | 31,240
Less: Accumulated depreciation | (5,164) | (753)
 | $41,837 | $74,412


Question: How much was the company-funded building improvements as of March 31, 2019?
Answer: $5.2 million
performance graph the following graph is a comparison of the five-year cumulative return of our common shares , the standard & poor 2019s 500 index ( the 201cs&p 500 index 201d ) and the national association of real estate investment trusts 2019 ( 201cnareit 201d ) all equity index ( excluding health care real estate investment trusts ) , a peer group index . the graph assumes that $ 100 was invested on december 31 , 2005 in our common shares , the s&p 500 index and the nareit all equity index and that all dividends were reinvested without the payment of any commissions . there can be no assurance that the performance of our shares will continue in line with the same or similar trends depicted in the graph below. .

Table:
 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
vornado realty trust | 100 | 151 | 113 | 81 | 100 | 124
s&p 500 index | 100 | 116 | 122 | 77 | 97 | 112
the nareit all equity index | 100 | 135 | 114 | 71 | 91 | 116
.

Question: what was the average price of the the nareit all equity index from 2005 to 2009
Answer: 102.2
Calculation: add(100, 135), add(#0, 114), add(#1, 71), add(#2, 91), add(#3, const_5), divide(#4, const_2)
ALTERNATIVE PERFORMANCE MEASURES
Time Charter Equivalent (TCE) earnings:
TORM defines TCE earnings, a performance measure, as revenue after port expenses, bunkers and commissions incl. freight and bunker derivatives. The Company reports TCE earnings because we believe it provides additional meaningful information to investors in relation to revenue, the most directly comparable IFRS measure. TCE earnings is a standard shipping industry performance measure used primarily to compare period-to-period changes in a shipping company’s performance irrespective of changes in the mix of charter types (i.e. spot charters, time charters and bareboat charters) under which the vessels may be employed between the periods. Below is presented a reconciliation from Revenue to TCE earnings:
Table:
USDm | 2019 | 2018 | 2017
Reconciliation to revenue |  |  | 
Revenue | 692.6 | 635.4 | 657.0
Port expenses, bunkers and commissions | -267.7 | -283.0 | -259.9
TCE earnings | 424.9 | 352.4 | 397.1


Question: What was the percentage change in TCE earnings in 2019 from 2018?
Answer: 20.57
Calculation: (424.9-352.4)/352.4
Restricted Stock and Restricted Stock Units ("Restricted Stock Awards")
As of August 29, 2019, there were 16 million shares of Restricted Stock Awards outstanding, 14 million of which contained only service conditions. For service-based Restricted Stock Awards, restrictions generally lapse in one-fourth or one-third increments during each year of employment after the grant date. Restrictions lapse on Restricted Stock granted in 2019 with performance or market conditions over a three-year period if conditions are met. At the end of the performance period, the number of actual shares to be awarded will vary between 0% and 200% of target amounts, depending upon the achievement level. Restricted Stock Awards activity for 2019 is summarized as follows:
Table:
 | Number of Shares | Weighted-Average Grant Date Fair Value Per Share
Outstanding as of August 30, 2018 | 15 | $25.18
Granted | 9 | 41.11
Restrictions lapsed | (6) | 24.22
Canceled | (2) | 24.79
Outstanding as of August 29, 2019 | 16 | 34.72


Question: How many Restricted Stock Awards of shares were outstanding as of August 29, 2019?
Answer: 16 million shares
Note 17. Other Accrued Expenses and Current Liabilities
Other accrued expenses and current liabilities consisted of the following (in thousands):
Table:
 | December 31, | 
 | 2019 | 2018
Accrued purchases | $4,328 | $1,679
Accrued legal and professional fees | 3,860 | 3,380
Accrued customer-acquisition advertising costs (Note 1) | 3,745 | 2,831
Deferred Symphony acquisition purchase price (Note 4) | 3,517 | 3,394
Accrued roadside assistance claim costs | 1,709 | 1,330
Accrued telephone charges | 1,605 | 2,000
Financial derivatives (Note 12) | 251 | 2,859
Accrued restructuring (Note 5) | 56 | 976
Accrued rent (Note 3) | — | 3,283
Other | 10,259 | 9,503
 | $29,330 | $31,235


Question: In which year were Accrued roadside assistance claim costs larger?
Answer: 2019
Calculation: 1,709>1,330
3. Inventories
Inventories consist of the following (in thousands):
Table:
 | August 31,2019 | August 31,2018
Raw materials | $2,310,081 | $2,070,569
Work in process | 468,217 | 788,742
Finished goods | 314,258 | 659,335
Reserve for excess and obsolete inventory | (69,553) | (60,940)
Inventories, net | $3,023,003 | $3,457,706


Question: What was the amount of finished goods in 2019?
Answer: 314,258