trismik/FinRAG huggingface dataset:
Film and Electrolytic
The table below sets forth net sales, operating income (loss) and operating income (loss) as a percentage of net sales for our Film and Electrolytic reportable segment for the fiscal years 2018 and 2017 (amounts in thousands, except percentages):
(1) Fiscal years ending March 31, 2018 and 2017 adjusted due to the adoption of ASC 606
Net Sales
Film and Electrolytic net sales of $202.0 million in fiscal year 2018 increased $19.7 million or 10.8% from $182.2 million in fiscal year 2017. The increase in net sales was primarily driven by an increase in net sales in the distributor channel across all the APAC and EMEA regions of $13.7 million, a $3.3 million increase in net sales in the OEM channel of the EMEA region and a $4.2 million increase in the EMS channel across the Americas, EMEA, and APAC regions. These increases were partially offset by a decrease in net sales of $1.2 million in the OEM channel across the Americas, APAC, and JPKO regions. In addition, there was a favorable impact of $7.6 million from foreign currency exchange primarily due to the change in the value of the Euro compared to the U.S. dollar.
Reportable Segment Operating Income (Loss)
Segment operating income of $3.6 million in fiscal year 2018 improved $12.7 million from $9.0 million of operating loss in fiscal year 2017. The improvement was primarily attributable to a $4.3 million increase in gross margin driven by higher net sales, as well as the benefit of completed restructuring activities. The increase was also attributed to an $11.7 million improvement in (gain) loss on the write down and disposal of long-lived assets. These improvements were partially offset by a $2.1 million increase in restructuring charges, a $0.7 million increase in SG&A expenses, and a $0.6 million increase in R&D expenses.

For the Fiscal Years Ended
March 31, 2018
March 31, 2017
Amount
% to Net Sales
Amount
% to Net Sales
Net sales (1)
$201,977
$182,228
Segment operating income (loss) (1)
3,622
1.8%
(9,028)
(5.0)%


Question: Analyse this data from a financial earnings document. What was the change in the percentage to net sales for segment operating income (loss) between 2017 and 2018?
Choices:
0
-3.2
6.8
2.8
9029.8
Correct choice index: 2
The Group made an operating profit of $60.9 million in the year and adjusted operating profit increased by $50.7 million to $109.0 million, primarily as a result of strong revenue growth. This year's result benefited from a foreign exchange gain of $1.5 million, compared to a foreign exchange loss of $6.9 million in the prior-year.
The Group’s profit before taxation increased by $94.6 million to $53.6 million, from a loss of $41.0 million in the prior-year, primarily as a consequence of the $80.6 million improvement in operating profit supported by a $13.4 million reduction in finance expenses. Finance expenses benefited from foreign exchange gains in the current year resulting from the strengthening of both sterling and the euro against the US dollar, compared to foreign exchange losses in the prior-year.
The Group’s profit for the year increased by $87.8 million to $26.9 million in the year-ended 31 March 2019, which given only a small increase in the year-on-year income tax charge was primarily attributable to the improvement in the profit before taxation.
Cash flow from operating activities remained strong at $142.9 million, reduced by $4.8 million from $147.7 million in the prior-year. The small overall decrease was due to an increase in overheads, partially offset by a reduction in the cashflow outflow on exceptional items and an improved use of working capital. Unlevered free cashflow decreased by $15.8 million to $123.8 million representing the reduction in net cash flow from operating activities adjusted for the cashflow impact of exceptional items.
The table below presents the Group’s financial highlights on a reported basis:
1 Restated for the adoption of IFRS 15 and change in accounting policy in respect of research and development expenditure tax credit scheme and provision for interest on uncertain tax positions, as explained in note 2 of the Financial Statements
2 Definitions and reconciliations of non-GAAP measures are included in note 5 of the Financial Statements

FY19
FY18
Change
$M
$M
%
Statutory measures
Revenue
710.6
639.0
11.2
Profit / (Loss) before taxation
53.6
(41.0)
nm
Net cash flow from operating activities
142.9
147.7
(3.2)
Alternative performance measures2
Billings
760.3
768.6
(1.1)
Cash EBITDA
167.9
199.2
(15.7)
Adjusted operating profit
109.0
58.3
87.0
Unlevered free cash flow
123.8
139.6
(11.3)


Question: Analyse this data from a financial earnings document. What was the average revenue in 2018 and 2019?
Choices:
699.6
382.1
674.8
1349.6
9.4
Correct choice index: 2
Certain information regarding our initial distribution rights to films initially released in the three fiscal years 2019, 2018 and 2017 is set forth below:
We distribute content in over 50 countries through our own offices located in key strategic locations across the globe. In response to Indian cinemas’ continued growth in popularity across the world, especially in non-English speaking markets, including Germany, Poland, Russia, Southeast Asia and Arabic speaking countries, we offer dubbed and/or subtitled content in over 25 different languages.
In addition to our internal distribution resources, our global distribution network includes relationships with distribution partners, sub-distributors, producers, directors and prominent figures within the Indian film industry and distribution arena.

Year ended March 31,
2019
2018
2017
Global (India and International)
Hindi films
7
10
8
Regional films (excluding Tamil films)
49
3
12
Tamil films
3
1
3
International Only
Hindi films
7
1
3
Regional films (excluding Tamil films)
—
—
—
Tamil films
—
—
12
India Only
Hindi films
1
3
1
Regional films (excluding Tamil films)
5
6
5
Tamil films
—
0
1
Total
72
24
45


Question: Analyse this data from a financial earnings document. What is the average global regional films (excluding Tamil films) from 2017-2019?
Choices:
13.33
34.67
0.05
21.33
22.67
Correct choice index: 3
5. Software Development and Intellectual Property Licenses
The following table summarizes the components of our capitalized software development costs (amounts in millions):
As of both December 31, 2019 and December 31, 2018, capitalized intellectual property licenses were not material.

At December 31,
2019
2018
Internally-developed software costs
$345
$291
Payments made to third-party software developers
31
38
Total software development costs
$376
$329


Question: Analyse this data from a financial earnings document. What was the change in Internally-developed software costs between 2018 and 2019?
Choices:
38
-286
307
54
11
Correct choice index: 3
Historically, a small number of OEM customers have accounted for a substantial portion of our net revenues, and we expect that significant customer concentration will continue for the foreseeable future. Many of our OEMs use contract manufacturers to manufacture their equipment. Accordingly, a significant percentage of our net revenues is derived from sales to these contract manufacturers and to consignment warehouses.
In addition, a significant portion of our sales are made to foreign and domestic distributors who resell our products to OEMs, as well as their contract manufacturers. Direct sales to contract manufacturers and consignment warehouses accounted for 41.3%, 34.9% and 39.0% of our net revenues for fiscal 2019, 2018 and 2017, respectively.
Sales to foreign and domestic distributors accounted for 56.0%, 62.5% and 57.5% of our net revenues for fiscal 2019, 2018 and 2017, respectively. The following direct customers accounted for 10% or more of our net revenues in one or more of the following periods:
Nokia was our largest customer in fiscal 2019, 2018 and 2017. Nokia purchases products directly from us and through contract manufacturers and distributors. Based on information provided to us by its contract manufacturers and our distributors, purchases by Nokia represented approximately 45%, 36% and 41% of our net revenues in fiscal 2019, 2018 and 2017, respectively.
Our revenues have been substantially impacted by significant fluctuations in sales to Nokia, and we expect that future direct and indirect sales to Nokia will continue to fluctuate substantially on a quarterly basis and that such fluctuations may significantly affect our operating results in future periods. To our knowledge, none of our other OEM customers accounted for more than 10% of our net revenues in fiscal 2019, 2018 or 2017.

Fiscal Year Ended
March 31,
2019
2018
2017
Contract manufacturers and consignment warehouses:       
Flextronics Technology
21.8%
14.0%
10.4%
Sanmina
17.7
16.0
20.4
Distributors:       
Avnet Logistics
31.3
35.3
25.5
Nexcomm 
14.8
16.1
19.7


Question: Analyse this data from a financial earnings document. What was the average revenue from Avnet Logistics between 2017-2019?
Choices:
30.7
28.8
0.1
0.9
13.7
Correct choice index: 0
Debt
At both December 31, 2019 and December 31, 2018, our total outstanding debt was $2.7 billion, bearing interest at a weighted average rate of 3.18%.
A summary of our outstanding debt as of December 31, 2019, is as follows (amounts in millions):

December 31, 2019
Gross Carrying Amount
Unamortized Discount and Deferred Financing Costs
Net Carrying Amount
2021 Notes
$650
$(2)
$648
2022 Notes
400
(2)
398
2026 Notes
850
(7)
843
2027 Notes
400
(5)
395
2047 Notes
400
(9)
391
Total debt
$2,700
$(25)
$2,675


Question: Analyse this data from a financial earnings document. What is the sum of the 2 highest gross carrying amounts?
Choices:
1500
1
1050
200
1248
Correct choice index: 0
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (in thousands, except for share and per share data)
Our pension plan asset allocation at December 31, 2019, and 2018, and target allocation for 2020 by asset category are as follows:
We employ a liability-driven investment strategy whereby a mix of equity and fixed-income investments are used to pursue a derisking strategy which over time seeks to reduce interest rate mismatch risk and other risks while achieving a return that matches or exceeds the growth in projected pension plan liabilities. Risk tolerance is established through careful consideration of plan liabilities and funded status. The investment portfolio primarily contains a diversified mix of equity and fixed-income investments. Other assets such as private equity are used modestly to enhance long-term returns while improving portfolio diversification. Investment risk is measured and monitored on an ongoing basis through quarterly investment portfolio reviews, annual liability measurements, and asset/liability studies at regular intervals.

Target Allocations
Percentage of Plan Assets at December 31,
Asset Category
2020
2019
2018
Equity securities
13%
13%
12%
Debt securities
83%
83%
84%
Other
4%
4%
4%
Total
100%
100%
100%


Question: Analyse this data from a financial earnings document. What was the difference between the target allocations of Debt Securities and Other assets in 2020?
Choices:
-79
82
-3
87
79
Correct choice index: 4
4. PREPAID EXPENSES
Prepaid expenses consisted of the following at December 31, 2019 and 2018 (in thousands):  Prepaid expenses consisted of the following at December 31, 2019 and 2018 (in thousands):  Prepaid expenses consisted of the following at December 31, 2019 and 2018 (in thousands):
In 2018, we recorded impairment charges of approximately$0.4 million related to prepaid licenses and production tooling as a result of the restructuring of our operations. These charges are included in “Restructuring expenses” in the accompanying statements of comprehensive loss (see Note 15).

2019
2018
Prepaid services
$221
$252
Prepaid bonds for German statutory costs
188
199
Prepaid insurance
62
19
Prepaid licenses, software tools and support
17
51
Other prepaid expenses
17
17
$505
$538


Question: Analyse this data from a financial earnings document. What is the total sum of the top 3 prepaid expenses in 2018?
Choices:
502
564
471
0
269
Correct choice index: 0
entergy louisiana , llc management's financial discussion and analysis 2007 compared to 2006 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges ( credits ) .
following is an analysis of the change in net revenue comparing 2007 to 2006 .
amount ( in millions ) .

Amount (In Millions)
2006 net revenue
$942.1
Base revenues
78.4
Volume/weather
37.5
Transmission revenue
9.2
Purchased power capacity
(80.0)
Other
3.9
2007 net revenue
$991.1

the base revenues variance is primarily due to increases effective september 2006 for the 2005 formula rate plan filing to recover lpsc-approved incremental deferred and ongoing capacity costs .
see "state and local rate regulation" below and note 2 to the financial statements for a discussion of the formula rate plan filing .
the volume/weather variance is due to increased electricity usage , including electricity sales during the unbilled service period .
billed retail electricity usage increased a total of 666 gwh in all sectors compared to 2006 .
see "critical accounting estimates" below and note 1 to the financial statements for further discussion of the accounting for unbilled revenues .
the transmission revenue variance is primarily due to higher rates .
the purchased power capacity variance is primarily due to higher purchased power capacity charges and the amortization of capacity charges effective september 2006 as a result of the formula rate plan filing in may 2006 .
a portion of the purchased power capacity costs is offset in base revenues due to a base rate increase implemented to recover incremental deferred and ongoing purchased power capacity charges , as mentioned above .
see "state and local rate regulation" below and note 2 to the financial statements for a discussion of the formula rate plan filing .
gross operating revenues , fuel , purchased power expenses , and other regulatory charges ( credits ) gross operating revenues increased primarily due to : an increase of $ 143.1 million in fuel cost recovery revenues due to higher fuel rates and usage ; an increase of $ 78.4 million in base revenues , as discussed above ; and an increase of $ 37.5 million related to volume/weather , as discussed above .
fuel and purchased power expenses increased primarily due to an increase in net area demand and an increase in deferred fuel expense as a result of higher fuel rates , as discussed above .
other regulatory credits decreased primarily due to the deferral of capacity charges in 2006 in addition to the amortization of these capacity charges in 2007 as a result of the may 2006 formula rate plan filing ( for the 2005 test year ) with the lpsc to recover such costs through base rates effective september 2006 .
see note 2 to the financial statements for a discussion of the formula rate plan and storm cost recovery filings with the lpsc. .

Question: Analyse this data from a financial earnings document. what is the percent change in net revenue between 2006 and 2007?
Choices:
-0.99788
0.04944
0.34242
0.96879
0.05201
Correct choice index: 4
Research and development expenses consist primarily of payroll and payroll-related benefits expenses, contracted research and development expenses, and facility costs. Research and development assists with organic growth and improves product stability and functionality, and accordingly, we dedicate extensive efforts to update and upgrade our product offerings. The primary driver is typically budgeted software upgrades and software development.
Research and development expenses decreased by $1.1 million during the year ended June 30, 2019 as compared to the prior fiscal year. This was primarily due to a reduction in contract labour and consulting of $6.8 million and a reduction in the use of facility and related expenses of $4.8 million, partially offset by an increase in payroll and payroll-related benefits of $12.6 million. The increase in payroll and payroll-related benefits was driven primarily by increased headcount from recent acquisitions. Overall, our research and development expenses, as a percentage of total revenues, remained stable at approximately 11% compared to prior fiscal year.
Our research and development labour resources increased by 336 employees, from 3,331 employees at June 30, 2018 to 3,667 employees at June 30, 2019.

Change between Fiscal increase (decrease)
(In thousands)
2019 and 2018
2018 and 2017
Payroll and payroll-related benefits
$12,629
$39,119
Contract labour and consulting
(6,791)
(3,899)
Share-based compensation
(385)
(1,490)
Travel and communication
(588)
(343)
Facilities
(4,775)
7,834
Other miscellaneous
(1,163)
473
Total change in research and development expenses
$(1,073)
$41,694


Question: Analyse this data from a financial earnings document. What is the change of expenses for facilities from fiscal year 2017 to 2019?
Choices:
0
3059000
-4302
12609
3059
Correct choice index: 4
Billings
Group reported billings decreased by $8.3 million or 1.1 per cent to $760.3 million in the year-ended 31 March 2019. This represented a 0.1 per cent decrease on a constant currency (“CC”) basis.
Billings by region
Americas Billings attributable to the Americas decreased by $2.2 million to $267.8 million in the period, representing a 0.8 per cent reduction on a reported basis and 0.7 per cent on a constant currency basis; this decrease largely driven by a decline in Enduser products due to the stronger performance in the prior-year compare as a consequence of the impact of the WannaCry ransomware outbreak and the launch of Intercept X, the Group’s next-gen endpoint product, partially offset by an improved performance in UTM sales.
EMEA Billings attributable to EMEA increased by $0.2 million to $395.3 million in the period, representing 0.1 per cent growth on a reported basis and 0.9 per cent growth on a constant currency basis. An increase in sales of Server products being partially offset by a reduction in endpoint and email products.
APJ Billings attributable to APJ decreased by $6.3 million to $97.2 million in the period, representing 6.1 per cent on a reported basis and 2.8 per cent on a constant currency basis. As in the Americas, growth was negatively impacted by the stronger performance in the prior-year compare compounded by a legacy Network product transition in the first-half of the year partially offset by an improvement in sales of Server products.

FY19
FY18
Growth %
Growth %
$m (Reported)
$m (Reported)
(Reported)
(CC)
Billings by Region:
- Americas
267.8
270.0
(0.8)
(0.7)
- EMEA
395.3
395.1
0.1
0.9
- APJ
97.2
103.5
(6.1)
(2.8)
760.3
768.6
(1.1)
(0.1)
Billings by Product:
– Network
345.9
353.4
(2.1)
(1.1)
– Enduser
377.1
383.2
(1.6)
(0.7)
– Other
37.3
32.0
16.6
17.1
760.3
768.6
(1.1)
(0.1)
Billings by Type:
– Subscription
644.6
644.2
0.1
1.0
– Hardware
105.7
113.7
(7.0)
(6.1)
– Other
10.0
10.7
(6.5)
(4.6)
760.3
768.6
(1.1)
(0.1)


Question: Analyse this data from a financial earnings document. What was the change in Other in 2019 from 2018 under Billings by Product?
Choices:
530
-21.3
5.3
-34.1
-33.1
Correct choice index: 2
21. Supplemental Data
The following are additional required disclosures and other material items:

Years Ended June 30,
($ in millions)
2019
2018
2017
Cost Data:
Repairs and maintenance costs
$120.4
$108.0
$99.1
Cash Flow Data:
Noncash investing and financing activities:
Noncash purchases of property, plant, equipment and software
$16.1
$16.5
$13.7
Cash paid (received) during the year for:
Interest payments, net
$27.6
$29.5
$27.7
Income tax payments (refunds), net
$27.5
$33.7
$(33.3)


Question: Analyse this data from a financial earnings document. What was the change in Repairs and maintenance costs in 2019 from 2018?
Choices:
12.4
0
132.8
90.4
21.3
Correct choice index: 0
8.1 CAPITAL STRUCTURE
The table below summarizes debt-related financial ratios over the last two fiscal years and the fiscal 2020 guidelines:
(1) Based on mid-range guidelines. (2) Excludes amortization of deferred transaction costs and commitment fees but includes the impact of interest rate swaps. Potential variations in the US LIBOR rates in fiscal 2020 have not been considered. (3) Taking into consideration the interest rate swaps in effect at the end of each fiscal year. (4) Net indebtedness is defined as the aggregate of bank indebtedness, balance due on business combinations and principal on long-term debt, less cash and cash equivalents. (5) Adjusted EBITDA and financial expense for fiscal year 2018 include only eight months of MetroCast operations. (6) Specific guidance on interest coverage cannot be provided given that financial expense guidance is not provided.
In fiscal 2019, the financial leverage ratio relating to net indebtedness over adjusted EBITDA has declined as a result of the sale of Cogeco Peer 1 on April 30, 2019 for a net cash consideration of $720 million and to a lesser extent growing adjusted EBITDA and a reduction in net indebtedness from generated free cash flow. In fiscal 2020, prior to the adoption of IFRS 16 Leases, the financial leverage ratio relating to net indebtedness over adjusted EBITDA should continue to decline as a result of growing adjusted EBITDA and a projected reduction in net indebtedness from generated free cash flow.

Years ended August 31,
2020 Guidelines(1)
2019
2018
Average cost of indebtedness(2)
4.4%
4.4%
4.4%
Fixed rate indebtedness(3)
78%
78%
72%
Average term: long-term debt (in years)
3.9
4.9
5.7
Net indebtedness(4) / adjusted EBITDA(5)
2.3
2.6
3.8
Adjusted EBITDA / financial expense(5)
N/A (6)
6.3
5.4


Question: Analyse this data from a financial earnings document. What was the increase / (decrease) in the Average term: long-term debt (in years) from 2018 to 2019?
Choices:
10.3
8.9
-0.8
2.3
0
Correct choice index: 2
Note 7. Prepaid Expenses and Other Current Assets and Accrued and Other Current Liabilities
Prepaid expenses and other current assets as of December 31, 2019 and 2018 consisted of the following:

December 31,
2019
2018
Prepaid expenses
$1,948
$1,179
Securities litigation insurance receivable
16,627
306
Other current assets
1,556
2,865
Prepaid expenses and other current assets
$20,131
$4,350


Question: Analyse this data from a financial earnings document. What is the total prepaid expenses made in 2018 and 2019?
Choices:
312700
17806
769
5529
3127
Correct choice index: 4
Contractual Obligations and Contingent Liabilities and Commitments
Our principal commitments consist primarily of obligations under operating and financing leases, which include among others, certain leases of our offices, colocations and servers as well as contractual commitment related network infrastructure and data center operations. The following table summarizes our commitments to settle contractual obligations in cash as of December 31, 2019:
(1) Finance leases are related to servers and network infrastructure and our data center operations.
As of December 31, 2019, we had severance agreements with certain employees which would require us to pay up to approximately $6.4 million if all such employees were terminated from employment with our Company following a triggering event (e.g., change of control) as defined in the severance agreements.

Payments Due by Year Ending December 31, 2020
(In thousands)
Total
Year 1 (1)
Years 2 & 3
Years 4 & 5
Beyond 5 Years
Operating leases, including imputed interest
12,807
3,519
5,102
4,186
—
Finance leases, including imputed interest (1)
2,165
1,423
736
6
—
Total contractual obligations
$ 14,972
$ 4,942
$ 5,838
$ 4,192
$ —


Question: Analyse this data from a financial earnings document. How much more in total contractual obligations does the company expect to spend in Year 1 than Years 4 & 5?
Choices:
-4188
4936
75000
0
750
Correct choice index: 4