hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Cubic Mission Solutions
Sales: CMS sales increased 23% to $207.0 million in fiscal 2018 compared to $168.9 million in 2017. The increase in sales was primarily due to increased orders and shipments of expeditionary satellite communications products, tactical networking products, and Command and Control, Intelligence, Surveillance and Reconnaissance (C2ISR) products and services. Businesses acquired during fiscal years 2018 and 2017 whose operations are included in our CMS operating segment had sales of $5.6 million and $1.5 million for fiscal years 2018 and 2017, respectively.
Amortization of Purchased Intangibles: Amortization of purchased intangibles included in the CMS results amounted to $20.8 million in 2018 and $23.6 million in 2017. The $2.8 million decrease in amortization expense is related to purchased intangible assets that are amortized based upon accelerated methods.
Operating Income: CMS had an operating loss of $0.1 million in 2018 compared to $9.3 million in 2017. CMS realized increased profits from expeditionary satellite communications products, tactical networking products, and C2ISR products and services. As mentioned above, amortization of purchased intangibles decreased to $20.8 million in 2018 compared to $23.6 million in 2017. CMS increased R&D expenditures between 2017 and 2018 by $10.8 million, primarily driven by development of new antenna technologies. Businesses acquired by CMS in fiscal years 2018 and 2017 incurred operating losses of $4.7 million in fiscal 2018 compared to $2.9 million in fiscal 2017. Included in the operating loss incurred by acquired businesses are acquisition transaction costs of $1.6 million and $1.8 million incurred in fiscal years 2018 and 2017, respectively.
Adjusted EBITDA: CMS Adjusted EBITDA increased 82% to $26.2 million in 2018 compared to $14.4 million in 2017.
The increase in CMS Adjusted EBITDA was primarily due to the same items described in the operating income section
above, excluding the changes in amortization expense and acquisition transaction costs discussed above as such items are
excluded from Adjusted EBITDA.
Table:
 | Fiscal 2018 | Fiscal 2017 | % Change
 |  | (in millions) | 
Sales | $  207.0 | $  168.9 | 23 %
Operating loss | (0.1) | (9.3) | (99)
Adjusted EBITDA | 26.2 | 14.4 | 82


Question: What is the average adjusted EBITDA in 2018 and 2017?
Answer: 20.3
Calculation: (26.2+14.4)/2
item 2 : properties information concerning applied 2019s properties is set forth below: .

Table:
( square feet in thousands ) | united states | other countries | total
owned | 3964 | 1652 | 5616
leased | 845 | 1153 | 1998
total | 4809 | 2805 | 7614
because of the interrelation of applied 2019s operations , properties within a country may be shared by the segments operating within that country .
the company 2019s headquarters offices are in santa clara , california .
products in semiconductor systems are manufactured in santa clara , california ; austin , texas ; gloucester , massachusetts ; kalispell , montana ; rehovot , israel ; and singapore .
remanufactured equipment products in the applied global services segment are produced primarily in austin , texas .
products in the display and adjacent markets segment are manufactured in alzenau , germany ; and tainan , taiwan .
other products are manufactured in treviso , italy .
applied also owns and leases offices , plants and warehouse locations in many locations throughout the world , including in europe , japan , north america ( principally the united states ) , israel , china , india , korea , southeast asia and taiwan .
these facilities are principally used for manufacturing ; research , development and engineering ; and marketing , sales and customer support .
applied also owns a total of approximately 269 acres of buildable land in montana , texas , california , israel and italy that could accommodate additional building space .
applied considers the properties that it owns or leases as adequate to meet its current and future requirements .
applied regularly assesses the size , capability and location of its global infrastructure and periodically makes adjustments based on these assessments. .

Question: what portion of the company's property is located in united states?
Answer: 73.8%
Calculation: divide(5616, 7614)
Telecommunications Segment
ICS operates an extensive network of direct routes and offers premium voice communication services for carrying a mix of business, residential and carrier long-distance traffic, data and transit traffic. Customers may have a bilateral relationship with ICS, meaning they have both a customer and vendor relationship with ICS. In these cases, ICS sells the customer access to the ICS supplier routes but also purchases access to the customer’s supplier routes.
Net revenue is derived from the long-distance data and transit traffic. Net revenue is earned based on the number of minutes during a call multiplied by the price per minute, and is recorded upon completion of a call. Completed calls are billable activity while incomplete calls are non-billable. Incomplete calls may occur as a result of technical issues or because the customer’s credit limit was exceeded and thus the customer routing of traffic was prevented.
Revenue for a period is calculated from information received through ICS’s billing software, such as minutes and market rates. Customized billing software has been implemented to track the information from the switch and analyze the call detail records against stored detailed information about revenue rates. This software provides ICS with the ability to perform a timely and accurate analysis of revenue earned in a period.
ICS evaluates gross versus net revenue recognition for each of its contractual arrangements by assessing indicators of control and significant influence to determine whether the ICS acts as a principal (i.e. gross recognition) or an agent (i.e. net recognition). ICS has determined that it acts as a principal for all of its performance obligations in connection with all revenue earned. Net revenue represents gross revenue, net of allowance for doubtful accounts receivable, service credits and service adjustments. Cost of revenue includes network costs that consist of access, transport and termination costs. The majority of ICS’s cost of revenue is variable, primarily based upon minutes of use, with transmission and termination costs being the most significant expense.
Disaggregation of Revenues ICS's revenues are predominantly derived from wholesale of international long distance minutes (in millions):
Table:
Years Ended December 31, |  | 
 | 2019 | 2018
Termination of long distance minutes | $696.1 | $793.6
Total revenue from contracts with customers | 696.1 | 793.6
Other revenue | — | —
Total Telecommunications segment revenue | $696.1 | $793.6


Question: What is the increase / (decrease) in the Termination of long distance minutes from 2018 to 2019?
Answer: -97.5
Calculation: 696.1 - 793.6
8. Income Per Share
Basic income per share is calculated by dividing net earnings by the weighted average number of common shares outstanding for the applicable period. Diluted income per share is calculated after adjusting the denominator of the basic income per share calculation for the effect of all potential dilutive common shares outstanding during the period. The following table sets forth the computation of basic and diluted income per share:
For fiscal 2019, options and RSUs of 83,939 were excluded from the computation of diluted net income per share as their effect would have been anti-dilutive. For fiscal 2018 and fiscal 2017, the Company had no options or RSUs that were excluded from the computation of diluted net income per shares. RSAs for 594,382 shares in fiscal 2019, 363,413 shares in fiscal 2018 and 779,000 shares in fiscal 2017 were excluded from the calculation of diluted net income per share as these awards contain performance conditions that would not have been achieved as of the end of each reporting period had the measurement period ended as of that date.
Table:
 | April 27, 2019 | April 28, 2018 | April 29, 2017
Numerator: |  |  | 
Net Income (in millions) | $91.6 | $57.2 | $92.9
Denominator: |  |  | 
Denominator for Basic Earnings Per Share-Weighted Average Shares |  |  | 
Outstanding and Vested/Unissued Restricted Stock Units | 37,405,298 | 37,281,630 | 37,283,096
Dilutive Potential Common Shares-Employee Stock Options, |  |  | 
Restricted Stock Awards and Restricted Stock Units | 264,262 | 260,269 | 202,605
Denominator for Diluted Earnings Per Share | 37,669,560 | 37,541,899 | 37,485,701
Basic and Diluted Income Per Share: |  |  | 
Basic Income Per Share | $2.45 | $1.54 | $2.49
Diluted Income Per Share | $2.43 | $1.52 | $2.48


Question: In which year was Basic Income Per Share less than 2.0?
Answer: 2018
Calculation: locate and analyze Basic Income Per Share in row 12
Acquisitions and divestments
Acquisitions
In 2019, Ericsson made acquisitions with a negative cash flow effect amounting to SEK 1,815 (1,220) million. The acquisitions presented below are not material, but the Company gives the information to provide the reader a summarized view of the content of the acquisitions made. The acquisitions consist primarily of:
Kathrein: On October 2, 2019, the Company acquired assets from Kathrein, a world leading provider of antenna and filter technologies with approximately 4,000 employees. Kathrein’s antenna and filters business has a strong R&D organization with extensive experience in antenna design and research, coupled with a strong IPR portfolio. In addition to broadening Ericsson’s portfolio of antenna and filter products, the acquisition will bring vital competence for the evolution of advanced radio network products. The acquired Kathrein business has had a negative impact of SEK –0.5 billion since the acquisition, corresponding to –1 percentage point in Networks operating margin. Balances to facilitate the Purchase price allocation are preliminary.
CSF: On August 20, 2019, the Company acquired 100% of the shares in CSF Holdings Inc. a US-based technology company with approximately 25 employees. CSF strengthens iconectiv’s Business to Consumer (B2C) product platforms to enable growth in messaging and Toll-Free Number (TFN) management. Balances to facilitate the Purchase price allocation are final.
ST-Ericsson: Before ST-Ericsson was a joint venture where Ericsson and ST Microelectronics had a 50/50 ownership. This joint venture consisted of a number of legal entities where the two parties owned different stakes in the different legal entities. In December 2019 the Company initiated transactions to wind-down the legal structure of ST-Ericsson by acquiring the remaining shares in two legal ST-Ericsson entities and costs of SEK –0.3 billion impacted the result. The Company now owns 100% of the shares in those entities.
In order to finalize a Purchase price allocation all relevant information needs to be in place. Examples of such information are final consideration and final opening balances, they may remain preliminary for a period of time due
to for example adjustments of working capital, tax items or decisions from local authorities.
1) Acquisition-related costs are included in Selling and administrative expenses in the consolidated income statement.
Table:
Acquisitions 2017–2019 |  |  | 
 | 2019 | 2018 | 2017
Total consideration, including cash | 1,957 | 1,314 | 62
Net assets acquired |  |  | 
Cash and cash equivalents | 142 | 94 | –
Property, plant and equipment | 353 | 4 | 12
Intangible assets | 497 | 481 | 101
Investments in associates | 101 | 64 | –
Other assets | 1,357 | 254 | 1
Provisions, incl. post-employment benefits | –102 | – | –
Other liabilities | –743 | –494 | 25
Total identifiable net assets | 1,605 | 403 | 139
Costs recognized in net income | 153 | – | –
Goodwill | 199 | 911 | –77
Total | 1,957 | 1,314 | 62
Acquisition-related costs 1) | 85 | 24 | 49


Question: What is the change in cash and cash equivalents between 2019 and 2018?
Answer: 48
Calculation: 142-94
4. Inventories
Inventories consisted of the following (in thousands):
We grow and maintain flocks of layers (mature female chickens), pullets (female chickens, under 18 weeks of age), and breeders (male and female chickens used to produce fertile eggs to hatch for egg production flocks). Our total flock at June 1, 2019, consisted of approximately 9.4 million pullets and breeders and 36.2 million layers.
Table:
 | June 1, 2019 | June 2, 2018
Flocks, net of accumulated amortization | $105,536 | $96,594
Eggs | 14,318 | 17,313
Feed and supplies | 52,383 | 54,737
 | $172,237 | $168,644


Question: What is the increase / (decrease) in number of eggs in 2019?
Answer: -2995
Calculation: 14,318 - 17,313
We recorded $14.2 million, $15.2 million and $12.3 million of amortization related to our intangible assets for the years ended December 31, 2019, 2018 and 2017, respectively. There were no impairments of long-lived assets during the years ended December 31, 2019, 2018 and 2017.
The following tables reflect the weighted-average remaining life and carrying value of finite-lived intangible assets (in thousands, except weighted-average remaining life):
Table:
 |  | December 31, 2019 |  | 
 | Gross Carrying Amount | Accumulated Amortization | Net Carrying Value | Weighted- Average Remaining Life
Customer relationships | $123,731 | $(39,335) | $84,396 | 9.8
Developed technology | 30,542 | (13,722) | 16,820 | 8.7
Trade name | 3,304 | (1,082) | 2,222 | 4.8
Other | 234 | (234) | — | —
Total intangible assets | $157,811 | $(54,373) | $103,438 | 


Question: What was the trade name gross carrying amount in 2019?
Answer: 3,304
Unfunded Status
The following table presents the unfunded status of the Combined Pension Plan and post-retirement benefit plans:
The current portion of our post-retirement benefit obligations is recorded on our consolidated balance sheets in accrued expenses and other current liabilities-salaries and benefits.
Table:
 | Combined Pension Plan |  | Post-Retirement Benefit Plans | 
 | Years Ended December 31, |  | Years Ended December 31, | 
 | 2019 | 2018 | 2019 | 2018
 |  | (Dollars in millions) |  | 
Benefit obligation | $(12,217) | (11,594) | (3,037) | (2,977)
Fair value of plan assets | 10,493 | 10,033 | 13 | 18
Unfunded status | (1,724) | (1,561) | (3,024) | (2,959)
Current portion of unfunded status | — | — | (224) | (252)
Non-current portion of unfunded status | $(1,724) | (1,561) | (2,800) | (2,707)


Question: What is the percentage difference in the fair value of plan assets under the combined pension plan in 2019?
Answer: 4.58
Calculation: (10,493-10,033)/10,033
7. ACCOUNTS RECEIVABLES ALLOWANCES
Summarized below is the activity in our accounts receivable allowances including compensation credits and doubtful accounts as follows (in thousands):
The balances at the end of fiscal years 2019, 2018 and 2017 are comprised primarily of compensation credits of $4.5 million, $6.3 million and $8.9 million, respectively.
Table:
 |  | Fiscal Year | 
 | 2019 | 2018 | 2017
Balance - beginning of year | $6,795 | $9,410 | $3,279
Provision, net | 11,989 | 15,465 | 29,512
Charge-offs | (13,737) | (18,080) | (23,381)
Balance - end of year | $5,047 | 6,795 | 9,410


Question: What were the respective balances at the end of 2019, 2018 and 2017?
Answer: $4.5 million, $6.3 million, $8.9 million
issuer purchases of equity securities during the three months ended december 31 , 2007 , we repurchased 8895570 shares of our class a common stock for an aggregate of $ 385.1 million pursuant to the $ 1.5 billion stock repurchase program publicly announced in february 2007 , as follows : period total number of shares purchased ( 1 ) average price paid per share total number of shares purchased as part of publicly announced plans or programs approximate dollar value of shares that may yet be purchased under the plans or programs ( in millions ) .

Table:
period | total number of shares purchased ( 1 ) | average price paid per share | total number of shares purchased as part of publicly announced plans or programs | approximate dollar value of shares that may yet be purchased under the plans or programs ( in millions )
october 2007 | 3493426 | $ 43.30 | 3493426 | $ 449.9
november 2007 | 2891719 | $ 44.16 | 2891719 | $ 322.2
december 2007 | 2510425 | $ 44.20 | 2510425 | $ 216.2
total fourth quarter | 8895570 | $ 43.27 | 8895570 | $ 216.2
( 1 ) issuer repurchases pursuant to the $ 1.5 billion stock repurchase program publicly announced in february 2007 .
under this program , our management was authorized through february 2008 to purchase shares from time to time through open market purchases or privately negotiated transactions at prevailing prices as permitted by securities laws and other legal requirements , and subject to market conditions and other factors .
to facilitate repurchases , we typically made purchases pursuant to trading plans under rule 10b5-1 of the exchange act , which allow us to repurchase shares during periods when we otherwise might be prevented from doing so under insider trading laws or because of self-imposed trading blackout periods .
subsequent to december 31 , 2007 , we repurchased 4.3 million shares of our class a common stock for an aggregate of $ 163.7 million pursuant to this program .
in february 2008 , our board of directors approved a new stock repurchase program , pursuant to which we are authorized to purchase up to an additional $ 1.5 billion of our class a common stock .
purchases under this stock repurchase program are subject to us having available cash to fund repurchases , as further described in item 1a of this annual report under the caption 201crisk factors 2014we anticipate that we may need additional financing to fund our stock repurchase programs , to refinance our existing indebtedness and to fund future growth and expansion initiatives 201d and item 7 of this annual report under the caption 201cmanagement 2019s discussion and analysis of financial condition and results of operations 2014liquidity and capital resources . 201d .

Question: what is the total amount spent for stock repurchase during november 2007 , in millions?
Answer: 127.7
Calculation: multiply(2891719, 44.16), divide(#0, const_1000000)
30. Financial instruments and financial risk management
The main purpose of the Group’s financial instruments, other than trade and other receivables, trade and other payables, contractual provisions and lease liabilities, is to fund the Group’s liquidity requirements.
All of the Group’s financial assets and liabilities are categorised as financial assets/liabilities stated at amortised cost, except for forward foreign currency exchange contracts, included within current other financial assets, that are designated as financial assets at fair value through profit or loss and corporate owned life insurance, amounting to $3.0 million (2018 $2.4 million), included within non-current trade and other receivables, that is designated as financial assets at fair value through profit or loss. These are shown in the below table:
The Group enters into derivative transactions, forward foreign currency exchange contracts, for the management of the Group’s foreign currency exposures when deemed appropriate.
The key objective of the Group’s treasury department is to manage the financial risks of the business and to ensure that sufficient liquidity is available to the Group. All treasury activity operates within a formal control framework. The Board has approved treasury policies and guidelines and periodically reviews treasury activities. Additionally, it is the Group’s policy that speculative treasury transactions are expressly forbidden.
Table:
 |  | 2019 | 2018
 | Notes | $ million | $ million
Non-current trade and other receivables | 20 | 5.7 | 3.5
Cash and cash equivalents | 22 | 183.2 | 121.6
Current trade and other receivables | 20 | 133.2 | 126.9
Current other financial assets | 20 | 0.1 | –
Financial assets |  | 322.2 | 252.0
Non-current other payables, excluding government grants | 23 | 0.8 | 4.4
Current trade payables, other payables and accruals | 23 | 75.4 | 57.1
Lease liabilities, current and non-current | 26 | 33.0 | –
Contractual provisions | 28 | 3.6 | 3.6
Financial liabilities |  | 112.8 | 65.1


Question: What is the key objective of the Group's treasury department?
Answer: to manage the financial risks of the business and to ensure that sufficient liquidity is available to the Group
The following table summarizes activity for the interest rate swap:
There were no transfers between Level 1, Level 2 or Level 3 fair value hierarchy categories of financial instruments in the years ended December 31, 2019 and 2018.
Financial Instruments Not Recorded at Fair Value on a Recurring Basis
Some of the Company’s financial instruments are not measured at fair value on a recurring basis but are recorded at amounts that approximate fair value due to their liquid or short-term nature. Such financial assets and financial liabilities include: cash and cash equivalents, restricted cash, net receivables, certain other assets, accounts payable, accrued price protection liability, accrued expenses, accrued compensation costs, and other current liabilities. The Company’s long-term debt is not recorded at fair value on a recurring basis, but is measured at fair value for disclosure purposes (Note8 ).
Table:
 | Fair Value at December 31, | 
 | 2019 | 2018
 | (in thousands) | 
Interest rate swap |  | 
Beginning balance | $1,623 | $734
Unrealized gain (loss) recognized in other comprehensive income (loss) | (1,660) | 889
Ending balance | $(37) | 1,623


Question: In which year was the beginning balance less than 1,000 thousands?
Answer: 2018
Calculation: locate and analyze beginning balance in row 5
4. INVENTORIES
The components of inventories, net, are as follows (in thousands):
Table:
 | March 30, 2019 | March 31, 2018
Raw materials | $118,608 | $110,389
Work in process | 272,469 | 221,137
Finished goods | 120,716 | 140,766
Total inventories | $511,793 | $472,292


Question: What is the average value of the company's raw materials on March 31, 2018 and 2019?
Answer: 114498.5
Calculation: ($110,389 + $118,608)/2
Research, Development and Engineering Expense
NM—Not meaningful
Research, development and engineering (RD&E) expense was 7.8 percent of revenue in 2019 and 6.8 percent of revenue in 2018.
RD&E expense increased 11.3 percent in 2019 versus 2018 primarily driven by: • Higher spending (11 points) including investment in the z15 and Red Hat spending in the second half of 2019 (8 points); and • Higher acquisition-related charges associated with the Red Hat transaction (1 point); partially offset by • The effects of currency (1 point).
Operating (non-GAAP) expense increased 10.4 percent year to year primarily driven by the same factors excluding the acquisition-related charges associated with the Red Hat transaction.
Table:
($ in million) |  |  | 
For the year ended December 31: | 2019 | 2018 | Yr.-to-Yr. Percent Change
Total consolidated research, development and engineering | $5,989 | $5,379 | 11.3%
Non-operating adjustment |  |  | 
Acquisition-related charges | (53) | - | NM
Operating (non-GAAP) research, development and engineering | $5,936 | $5,379 | 10.4%


Question: What was the Operating (non-GAAP) research, development and engineering average?
Answer: 5657.5
Calculation: (5,936 + 5,379) / 2
The average duration of the defined benefit obligation at the end of the reporting period is 6.8 years (2018: 6.3 years) which relates wholly to active participants.
The plan invests entirely in pooled superannuation trust products where prices are quoted daily. The asset allocation of the plan has been set taking into account the membership profile, the liquidity requirements of the plan, and risk appetite of the Group.
The percentage invested in each asset class is as follows:
Table:
 | 2019 | 2018
 | % | %
Equity instruments | 53.9 | 58.5
Debt instruments | 18.6 | 22.5
Real estate | 10.8 | 3.5
Cash and cash equivalents | 3.7 | 3.0
Other | 13.0 | 12.5
Total | 100.0 | 100.0


Question: What is the average percentage constitution of real estate for 2018 and 2019?
Answer: 7.15
Calculation: (10.8% + 3.5%)/2