hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
(1) Included in other long-term assets.
For certain other financial instruments, including accounts receivable, unbilled receivables, and accounts payable, the carrying value approximates fair value due to the relatively short maturity of these items.
Table:
 |  | December 31, 2018 |  | 
(in thousands) | Level 1 | Level 2 | Level 3 | Total
Cash equivalents | $10,155 | $10,000 | - | $20,155
Marketable securities: |  |  |  | 
Municipal bonds | $— | $44,705 | — | $44,705
Corporate bonds | — | $48,296 | — | $48,296
Total marketable securities | $— | $93,001 | — | $93,001
Investments in privately-held companies (1) | $— | — | $3,390 | $3,390


Question: What is the value of municipal bonds as a percentage of the total marketable securities?
Answer: 48.07
Calculation: 44,705/93,001
Research and Development
The increase in research and development expenses in fiscal 2019 compared to fiscal 2018 was primarily driven by an increase in employee compensation costs caused by increases in headcount, annual compensation and benefit adjustments and employee performance-based compensation, partially offset by a decrease in project material costs.
Table:
Fiscal Year Ended |  |  |  | 
 | December 28, 2019 | December 29, 2018 | $ Change | % Change
(Dollars in thousands) |  |  |  | 
Research and development | $81,499 | $74,976 | $6,523 | 8.7 %
% of revenues | 13.8 % | 14.2 % |  | 
Fiscal Year Ended |  |  |  | 
 | December 29, 2018 | December 30, 2017 | $ Change | % Change
(Dollars in thousands) |  |  |  | 
Research and development | $74,976 | $73,807 | $1,169 | 1.6 %
% of revenues | 14.2 % | 13.5 % |  | 


Question: What led to increase in research and development expenses in fiscal 2019 compared to fiscal 2018?
Answer: The increase in research and development expenses in fiscal 2019 compared to fiscal 2018 was primarily driven by an increase in employee compensation costs
23. Investments continued
IFRS 9 was applied for the first time on 1 April 2018 and introduces new classifications for financial instruments, including investments. Under IAS 39, we classified investments as available-for-sale, loans and receivables, and fair value through profit or loss. On transition to IFRS 9 we have reclassified them as fair value through other comprehensive income, fair value through profit or loss, and amortised cost, as set out in note 1. The current year figures in the following table reflect the classifications under IFRS 9, and the prior year figures reflect the previous classifications under IAS 39.
Investments held at amortised cost consist of investments previously classified as loans and receivables and relate to money market investments denominated in sterling of £2,687m (2017/18: £416m, 2016/17: £35m), in US dollars of £26m (2017/18: £27m, 2016/17: £30m) in euros of £499m (2017/18: £nil, 2016/17: £nil) and in other currencies £2m (2017/18: £4m, 2016/17: £18m). They also include investments in liquidity funds of £2,522m (2017/18: £2,575m, 2016/17: £1,437m) held to collect contractual cash flows. In prior years these were classified as available-for-sale.
Table:
At 31 March | 2019 £m | 2018 £m | 2017 £m
Non-current assets | 48 | - | -
Fair value through other comprehensive income | - | 46 | 37
Available-for-sale | 6 | 7 | 7
Fair value through profit or loss | 54 | 53 | 44
Current assets |  |  | 
Fair value through other comprehensive income | - | - | -
Available-for-sale | - | 2,575 | 1,437
Investments held at amortised cost | 3,214 | - | -
Loans and receivables | - | 447 | 83
 | 3,214 | 3,022 | 1,520


Question: What were the  Fair value through profit or loss  in 2019, 2018 and 2017 respectively?
Answer: 54, 53, 44
7. Property, Plant and Equipment
Property, plant and equipment consisted of the following components at June 30, 2019 and 2018:
Table:
 | June 30, | 
($ in millions) | 2019 | 2018
Land | $35.6 | $34.8
Buildings and building equipment | 512.9 | 500.0
Machinery and equipment | 2,183.6 | 2,129.0
Construction in progress | 150.7 | 83.6
Total at cost | 2,882.8 | 2,747.4
Less: accumulated depreciation and amortization | 1,516.6 | 1,434.0
Total property, plant, and equipment | $1,366.2 | $1,313.4


Question: What was the amount of Land in 2019?
Answer: $35.6
10.5. Intangible assets
Impairment testing of goodwill
Goodwill has been allocated to the listed group (NSR). Management have determined that the listed group, which is considered one operating segment (see note 4), is the appropriate CGU against which to allocate these intangible assets owing to the synergies arising from combining the portfolios of the Group.
The recoverable amount of the listed group has been determined based on the fair value less costs of disposal method using the fair value quoted on an active market. As at 1 July 2019, NSR had 773,343,956 stapled securities quoted on the Australian Securities Exchange at $1.745 per security providing a market capitalisation of $1,349.5m.
This amount is in excess of the carrying amount of the Group’s net assets at 30 June 2019 which includes the contract for future issue of equity recognised as contributed equity within the statement of financial position at this date (see note 13). Had the security price decreased by 2.5% the market capitalisation would still have been in excess of the carrying amount.
Table:
 |  | 2019 | 2018
 | Notes | $'000 | $'000
Goodwill |  |  | 
Opening and closing net book value |  | 43,954 | 43,954
Other intangible assets |  |  | 
Opening net book value |  | 2,051 | 1,582
Additions |  | 1,079 | 864
Amortisation | 6 | (584) | (395)
Closing net book value |  | 2,546 | 2,051
Total intangible assets |  | 46,500 | 46,005


Question: What is the change in Other intangible assets Opening net book value from 2018 to 2019?
Answer: 469
Calculation: 2,051-1,582
Equity Method We own 20.51%of GTE Mobilnet of Texas RSA #17 Limited Partnership (“RSA #17”), 16.67% of Pennsylvania RSA 6(I) Limited Partnership (“RSA 6(I)”) and 23.67% of Pennsylvania RSA 6(II) Limited Partnership (“RSA 6(II)”). RSA #17 provides cellular service to a limited rural area in Texas.
RSA 6(I) and RSA 6(II) provide cellular service in and around our Pennsylvania service territory. Because we have significant influence over the operating and financial policies of these three entities, we account for the investments using the equity method. In connection with the adoption of ASC 606 by our equity method partnerships, the value of our combined partnership interests increased $1.8 million, which is reflected in the cumulative effect adjustment to retained earnings during the year ended December 31, 2018.
In 2019, 2018 and 2017, we received cash distributions from these partnerships totaling $19.0 million, $21.8 million and $17.2 million, respectively. The carrying value of the investments exceeds the underlying equity in net assets of the partnerships by $32.8 million as of December 31, 2019 and 2018.
The combined results of operations and financial position of our three equity investments in the cellular limited partnerships are summarized below:
Table:
(In thousands) | 2019 | 2018 | 2017
Total revenues | $ 349,640 | $ 346,251 | $ 350,611
Income from operations | 100,182 | 100,571 | 104,973
Net income before taxes | 99,146 | 99,408 | 103,497
Net income | 99,146 | 99,408 | 103,497
Current assets | $ 80,655 | $ 75,040 | $ 78,782
Non-current assets | 156,672 | 103,996 | 95,959
Current liabilities | 33,292 | 24,719 | 22,472
Non-current liabilities | 92,477 | 51,840 | 51,463
Partnership equity | 111,558 | 102,478 | 100,806


Question: What was the average income from operations for 2017-2019?
Answer: 101908.67
Calculation: (100,182 + 100,571 + 104,973) / 3
3. Investment in Unconsolidated Entities
The Company has several investments in unconsolidated entities that are accounted for using the equity method of accounting. Red River Valley Egg Farm, LLC ("Red River") operates a cage-free shell egg production complex near Bogota, Texas. Specialty Eggs, LLC ("Specialty Eggs") owns the Egg-Land's Best franchise for most of Georgia and South Carolina, as well as a portion of western North Carolina and eastern Alabama. Southwest Specialty Eggs, LLC ("Southwest Specialty Eggs") owns the Egg-Land's Best franchise for Arizona, southern California and Clark County, Nevada (including Las Vegas). As of June 1, 2019, the Company owns 50% of each of Red River, Specialty Eggs, and Southwest Specialty Eggs. Equity method investments are included in “Investments in unconsolidated entities” in the accompanying Consolidated Balance Sheets and totaled $60.7 million and $64.2 million at June 1, 2019 and at June 2, 2018, respectively.
Equity in income of unconsolidated entities of $4.8 million, $3.5 million, and $1.4 million from these entities has been included in the Consolidated Statements of Operations for fiscal 2019, 2018, and 2017, respectively.
The condensed consolidated financial information for the Company's unconsolidated joint ventures was as follows (in thousands):
The Company is a member of Eggland’s Best, Inc. (“EB”), which is a cooperative. At June 1, 2019 and June 2, 2018, “Other long-term assets” as shown on the Company’s Consolidated Balance Sheet includes the cost of the Company’s investment in EB plus any qualified written allocations. The Company cannot exert significant influence over EB’s operating and financial activities; therefore, the Company accounts for this investment using the cost method. The carrying value of this investment at June 1, 2019 and June 2, 2018 was $2.6 million and $2.6 million, respectively.
Table:
 |  | For the fiscal year ended | 
 | June 1, 2019 | June 2, 2018 | June 3, 2017
Net sales | $112,396 | $107,705 | $86,072
Net income | 9,490 | 7,071 | 2,804
Total assets | 128,470 | 134,056 | 131,871
Total liabilities | 7,600 | 5,859 | 6,543
Total equity | 120,870 | 128,197 | 125,328


Question: What is the average total assets in 3 years?
Answer: 131465.67
Calculation: (128,470 + 134,056 + 131,871) / 3
In relation to the oil derivative instrument (see note 24), the fair value was determined using the estimated discounted cash flows of the additional payments due to us as a result of oil prices moving above a contractual oil price floor over the term of the liquefaction tolling agreement ("LTA"). Significant inputs used in the valuation of the oil derivative instrument include management’s estimate of an appropriate discount rate and the length of time to blend the long-term and the short-term oil prices obtained from quoted prices in active markets. The changes in fair value of our oil derivative instrument is recognized in each period in current earnings in "Realized and unrealized gain on oil derivative instrument" as part of the consolidated statement of income.
The realized and unrealized (loss)/ gain on the oil derivative instrument is as follows:
The unrealized loss/gain results from movement in oil prices above a contractual floor price over term of the LTA; the realized gain results from monthly billings above the base tolling fee under the LTA. For further information on the nature of this derivative, refer to note 24.
Table:
 |  | Year Ended December 31, | 
(in thousands of $) | 2019 | 2018 | 2017
Realized gain on oil derivative instrument | 13,089 | 26,737 | —
Unrealized (loss)/gain on oil derivative instrument  | (39,090) | (9,970) | 15,100
 | (26,001) | 16,767 | 15,100


Question: What was the change in realized gain on oil derivative instrument from 2017 to 2018?
Answer: 26737
Calculation: 26,737 - 0
Changes in Accumulated Other Comprehensive Income (Loss)
The following table summarizes the changes in accumulated other comprehensive income (loss), which is reported as a component of shareholders’ equity, for the years ended December 31, 2019 and 2018:
Expressed in US $000's except share and per share amounts
Table:
 | Accumulated Other Comprehensive Income (Loss) | 
 | Years ended | 
 | December 31, 2019 | December 31, 2018
 | $ | $
Balance, beginning of the year | (12,216) | 3,435
 |  | 
Other comprehensive income (loss) before reclassifications | 12,865 | (19,821)
Loss on cash flow hedges reclassified from accumulated other comprehensive income (loss) to earnings were as follows: |  | 
Cost of revenues | 279 | 255
Sales and marketing | 1,538 | 1,224
Research and development | 2,620 | 2,063
General and administrative | 744 | 628
Tax effect on unrealized gain (loss) on cash flow hedges | (4,784) | —
Other comprehensive income (loss), net of tax | 13,262 | (15,651)
Balance, end of the year | 1,046 | (12,216)


Question: What is the average reclassification of cost of revenues for 2018 and 2019?
Answer: 267
Calculation: (279+255)/2
Property and equipment, net (in millions):
In September 2017, we entered into an agreement to sell certain land and buildings located in Sunnyvale, California, with a book value of $118 million, for a total of $306 million, through two separate and independent closings. Upon the completion of the first closing in fiscal 2018, we consummated the sale of properties with a net book value of $66 million for cash proceeds of $210 million, resulting in a gain, net of direct selling costs, of $142 million. The remaining properties, consisting of land with a net book value of $52 million, were classified as assets held-for-sale, and included as other current assets in our consolidated balance sheets as of April 26, 2019 and April 27, 2018. We will consummate the sale of these properties, and receive cash proceeds of $96 million, upon the completion of the second closing, which is expected to occur within the next 12 months. That closing is subject to due diligence, certain termination rights and customary closing conditions, including local governmental approval of the subdivision of a land parcel.
Table:
 | April 26, 2019 | April 27, 2018
Land | $ 106 | $ 106
Buildings and improvements | 605 | 594
Leasehold improvements | 86 | 88
Computer, production, engineering and other equipment | 817 | 733
Computer software | 357 | 357
Furniture and fixtures | 105 | 99
Construction-in-progress | 10 | 27
 | 2,086 | 2,004
Accumulated depreciation and amortization | (1,327 ) | (1,248 )
Property and equipment, net | $ 759 | $ 756


Question: Which years does the table provide information for net property and equipment?
Answer: 2019, 2018
Property, plant and equipment, net
Property, plant and equipment, net consisted of the following at December 31, 2019 and 2018 (in thousands):
We periodically assess the estimated useful lives of our property, plant and equipment whenever applicable facts and circumstances indicate a change in the estimated useful life of an asset may have occurred. During the year ended December 31, 2019, we revised the estimated useful lives of certain core Series 6 manufacturing equipment from 10 years to 15 years. Such revision was primarily due to the validation of certain aspects of our Series 6 module technology, including the nature of the manufacturing process, the operating and maintenance cost profile of the manufacturing equipment, and the technology’s compatibility with our long-term module technology roadmap. We expect the revised useful lives to reduce depreciation by approximately $15.0 million per year. Depreciation of property, plant and equipment was $176.4 million, $109.1 million, and $91.4 million for the years ended December 31, 2019, 2018, and 2017, respectively.
Table:
 | 2019 | 2018
Land | $14,241 | $14,382
Buildings and improvements . | 664,266 | 567,605
Machinery and equipment . | 2,436,997 | 1,826,434
Office equipment and furniture . | 159,848 | 178,011
Leasehold improvements | 48,772 | 49,055
Construction in progress | 243,107 | 405,581
Property, plant and equipment, gross | 3,567,231 | 3,041,068
Accumulated depreciation . | (1,386,082) | (1,284,857)
Property, plant and equipment, net | $2,181,149 | $1,756,211


Question: What is the percentage increase in net property, plant and equipment from 2018 to 2019?
Answer: 24.2
Calculation: (2,181,149 - 1,756,211)/1,756,211
Balance Sheet and Cash Flows
Cash and Cash Equivalents and Investments The following table summarizes our cash and cash equivalents and investments (in millions):
The net decrease in cash and cash equivalents and investments from fiscal 2018 to fiscal 2019 was primarily driven by cash returned to shareholders in the form of repurchases of common stock of $20.7 billion under the stock repurchase program and cash dividends of $6.0 billion, net cash paid for acquisitions and divestitures of $2.2 billion, a net decrease in debt of $1.1 billion, and capital expenditures of $0.9 billion. These uses of cash were partially offset by cash provided by operating activities of $15.8 billion and the timing of settlements of investments and other of $2.0 billion.
In addition to cash requirements in the normal course of business, on July 9, 2019 we announced our intent to acquire Acacia Communications, Inc. (“Acacia”) for a purchase consideration of approximately $2.6 billion in cash. Additionally, $0.7 billion of the U.S. transition tax on accumulated earnings for foreign subsidiaries, $6.0 billion of long-term debt and $4.2 billion of commercial paper notes outstanding at July 27, 2019, are payable within the next 12 months from the balance sheet date. See further discussion of liquidity and future payments under “Contractual Obligations” and “Liquidity and Capital Resource Requirements” below.
We maintain an investment portfolio of various holdings, types, and maturities. We classify our investments as short-term investments based on their nature and their availability for use in current operations. We believe the overall credit quality of our portfolio is strong, with our cash equivalents and our available-for-sale debt investment portfolio consisting primarily of high quality investment-grade securities. We believe that our strong cash and cash equivalents and investments position allows us to use our cash resources for strategic investments to gain access to new technologies, for acquisitions, for customer financing activities, for working capital needs, and for the repurchase of shares of common stock and payment of dividends as discussed below.
Table:
 | July 27, 2019 | July 28, 2018 | Increase (Decrease)
Cash and cash equivalents . | $11,750 | $8,934 | $2,816
Available-for-sale debt investments | 21,660 | 37,009 | (15,349)
Marketable equity securities | 3 | 605 | (602)
Total | $33,413 | $46,548 | $(13,135)


Question: How many years did Marketable equity securities exceed $500 million? 
Answer: 1
Calculation: 2018
28. FINANCIAL INSTRUMENTS (cont.)
(1) Other current and long-term financial assets classified as fair value through profit or loss were calculated using level 2 of the fair value hierarchy. All other balances were calculated using level 1 of the fair value hierarchy. (1) Other current and long-term financial assets classified as fair value through profit or loss were calculated using level 2 of the fair value hierarchy. All other balances were calculated using level 1 of the fair value hierarchy.
(2) Indebtedness excludes deferred financing costs and prepayment options (December 31, 2018 – deferred financing costs, interest rate floor, prepayment option and net gain on repricing/repayment). (2) Indebtedness excludes deferred financing costs and prepayment options (December 31, 2018 – deferred financing costs, interest rate floor, prepayment option and net gain on repricing/repayment).
(3) Trade and other receivables and trade and other payables approximate fair value due to the short-term maturity of these instruments.
Table:
As at December 31, 2018 | FVTPL | Amortised cost | Total | Fair Value | Fair Value hierarchy
Cash and cash equivalents | $ - | $768,433 | $768,433 | $768,433 | Level 1
Trade and other receivables | - | 45,631 | 45,631 | 45,631 | (3)
Other current financial assets (1) | 18,632 | 147 | 18,779 | 18,779 | Level 1, Level 2
Other long-term financial assets (1) | 33,796 | 21,959 | 55,755 | 55,755 | Level 1, Level 2
Trade and other payables | - | (30,659) | (30,659) | (30,659) | (3)
Other current financial liabilities | (6) | (26,380) | (26,386) | (29,131) | Level 2
Other long-term financial liabilities | (5,627) | (48,894) | (54,521) | (54,733) | Level 2
Indebtedness (2) | - | (3,853,883) | (3,853,883) | (3,709,695) | Level 2
 | $46,795 | $(3,123,646) | $(3,076,851) | $(2,935,620) | 


Question: What is the total fair value of financial instruments without a fair value hierarchy?
Answer: 14972
Calculation: 45,631 + (-30,659)
NOTE 4 - ACCOUNTS PAYABLE AND ACCRUED EXPENSES
Accounts payable and accrued expenses consist of the following at:
On October 1 2019, the Company entered into an agreement with a consultant for toxicology studies. The consultant quoted a commitment of approximately $988,000 as an
estimate for the study. 50% of the total price is to be paid upon the signing of the agreement, 35% of the total price is to be upon completion of the in-life study, and the
remaining 15% of the total price is to be paid upon the issuance of the report. If the Company cancels the study the Company will be required to pay a cancelation fee. If the
cancelation happens prior to the arrival of the test animals then the Company will need to pay between 20% and 50% of the animal fees depending on when the cancellation
happens. If the cancellation occurs after the animals arrive but before the study begins then the company will be responsible for paying 50% of the protocol price plus a fee of
$7,000 per room/week for animal husbandry until the animals can be relocated or disposed of. If the Company cancels the study after it has begun then the Company will need to pay any fees for procured items for the study and any nonrecoverable expenses incurred by the vendor. As of December 31, 2019, the Company has paid $0 and there is a balance of $493,905 due.
Table:
 | December 31, 2019 | December 31, 2018
Accounting | $36,161 | $52,365
Research and development | 650,584 | 137,114
Legal | 15,273 | 32,161
Other | 163,029 | 10,048
Total | $865,047 | $231,688


Question: What is the quoted consultation fees for the toxicology studies?
Answer: $988,000
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 percentage of the company's property is located in other countries and it is owned by the company?
Answer: 21.7%
Calculation: divide(1652, 7614)