hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
leased real property in september 2002 , we completed a sale/leaseback transaction for our 200000 square foot headquarters and manufacturing facility located in bedford , massachusetts and our 62500 square foot lorad manufacturing facility in danbury , connecticut . the lease for these facilities , including the associated land , has a term of 20 years , with four-five year renewal options . we sublease approximately 10000 square feet of the bedford facility to a subtenant , cmp media , under a lease which expires in may 2006 . we also sublease approximately 11000 square feet of the bedford facility to a subtenant , genesys conferencing , under a lease which expires in february we lease a 60000 square feet of office and manufacturing space in danbury , connecticut near our lorad manufacturing facility . this lease expires in december 2012 . we also lease a sales and service office in belgium . item 3 . legal proceedings . in march 2005 , we were served with a complaint filed on november 12 , 2004 by oleg sokolov with the united states district court for the district of connecticut alleging that our htc 2122 grid infringes u.s . patent number 5970118 . the plaintiff is seeking to preliminarily and permanently enjoin us from infringing the patent , as well as damages resulting from the alleged infringement , treble damages and reasonable attorney fees , and such other and further relief as may be available . on april 25 , 2005 , we filed an answer and counterclaims in response to the complaint in which we denied the plaintiff 2019s allegations and , among other things , sought declaratory relief with respect to the patent claims and damages , as well as other relief . on october 28 , 1998 , the plaintiff had previously sued lorad , asserting , among other things , that lorad had misappropriated the plaintiff 2019s trade secrets relating to the htc grid . this previous case was dismissed on august 28 , 2000 . the dismissal was affirmed by the appellate court of the state of connecticut , and the united states supreme court refused to grant certiorari . we do not believe that we infringe any valid or enforceable patents of the plaintiff . however , while we intend to vigorously defend our interests , ongoing litigation can be costly and time consuming , and we cannot guarantee that we will prevail . item 4 . submission of matters to a vote of security holders . at a special meeting of stockholders held november 15 , 2005 , our stockholders approved a proposal to amend our certificate of incorporation to increase the number of shares of common stock the company has authority to issue from 30 million to 90 million . the voting results for the proposal , not adjusted for the effect of the stock split , were as follows: .

Table:
for | against | abstained | broker non-votes
17695228 | 963202 | 155213 | 0
as a result of the amendment , the previously announced two-for-one stock split to be effected as a stock dividend , was paid on november 30 , 2005 to stockholders of record on november 16 , 2005. .

Question: what portion of the votes support the proposal?
Answer: 94.1%
Calculation: table_sum(17695228, 963202), add(#0, 155213), divide(17695228, #1)
Notes to Consolidated Financial Statements - (Continued) Fiscal Years Ended May 26, 2019, May 27, 2018, and May 28, 2017 (columnar dollars in millions except per share amounts) General
The Revolving Credit Facility (as defined in Note 5) and the Term Loan Agreement generally require our ratio of earnings before interest, taxes, depreciation and amortization ("EBITDA") to interest expense not to be less than 3.0 to 1.0 and our ratio of funded debt to EBITDA not to exceed certain decreasing specified levels, ranging from 5.875 through the first quarter of fiscal 2020 to 3.75 from the second quarter of fiscal 2023 and thereafter, with each ratio to be calculated on a rolling fourquarter basis. As of May 26, 2019, we were in compliance with all financial covenants under the Revolving Credit Facility and the Term Loan Agreement.
Net interest expense consists of:
Interest paid from continuing operations was $375.6 million, $164.5 million, and $223.7 million in fiscal 2019, 2018, and 2017, respectively.
Table:
 | 2019 | 2018 | 2017
Long-term debt | $385.9 | $161.2 | $203.6
Short-term debt | 15.0 | 4.8 | 0.6
Interest income | (6.8) | (3.8) | (3.7)
Interest capitalized | (2.7) | (3.5) | (5.0)
 | $391.4 | $158.7 | $195.5


Question: Which year has the highest total net interest expense?
Answer: 2019
Calculation: 391.4>195.5>158.7
Product Revenue by Groups of Similar Products
In addition to the primary view on a geographic basis, we also prepare financial information related to groups of similar products and customer markets for various purposes. We report our product revenue in the following categories: Infrastructure Platforms, Applications, Security, and Other Products. This aligns our product categories with our evolving business model. Prior period amounts have been reclassified to conform to the current period’s presentation.
The following table presents revenue for groups of similar products (in millions, except percentages):
Amounts may not sum and percentages may not recalculate due to rounding.
Infrastructure Platforms The Infrastructure Platforms product category represents our core networking offerings related to switching, routing, wireless, and the data center. Infrastructure Platforms revenue increased by 7%, or $1,869 million, with growth across the portfolio. Switching had solid growth, with strong revenue growth in campus switching driven by an increase in sales of our intent-based networking Catalyst 9000 Series, and with growth in data center switching driven by increased revenue from our ACI portfolio. Routing experienced modest revenue growth driven by an increase in sales of SD-WAN products, partially offset by weakness in the service provider market. We experienced double digit revenue growth from wireless products driven by increases across the portfolio. Revenue from data center increased driven by higher sales of HyperFlex and our server products.
Applications The Applications product category includes our collaboration offerings (unified communications, Cisco TelePresence and conferencing) as well as IoT and AppDynamics analytics software offerings. Revenue in our Applications product category increased by 15%, or $767 million, with double digit growth in unified communications, TelePresence, AppDynamics, and IoT software.
Security Revenue in our Security product category increased 16%, or $378 million, driven by higher sales of identity and access, advanced threat security, unified threat management and web security products. The Duo acquisition in the first quarter of fiscal 2019 also contributed to the revenue increase in this product category.
Other Products The decrease in revenue from our Other Products category was primarily driven by a decrease in revenue from SPVSS business which we divested on October 28, 2018.
Table:
 |  | Years Ended |  | 2019 vs. 2018 | 
 | July 27, 2019 | July 28, 2018 | July 29, 2017 | Variance in Dollars | Variance in Percent
Product revenue: |  |  |  |  | 
Infrastructure Platforms | $30,191 | $28,322 | $27,817 | $1,869 | 7%
Applications | 5,803 | 5,036 | 4,568 | 767 | 15%
Security  . | 2,730 | 2,352 | 2,152 | 378 | 16%
Other Products | 281 | 999 | 1,168 | (718) | (72)%
Total  . | $39,005 | $36,709 | $35,705 | $2,296 | 6%


Question: What was the revenue from Security in 2019?
Answer: 2,730
sacramento container acquisition in october 2017 , pca acquired substantially all of the assets of sacramento container corporation , and 100% ( 100 % ) of the membership interests of northern sheets , llc and central california sheets , llc ( collectively referred to as 201csacramento container 201d ) for a purchase price of $ 274 million , including working capital adjustments . funding for the acquisition came from available cash on hand . assets acquired include full-line corrugated products and sheet feeder operations in both mcclellan , california and kingsburg , california . sacramento container provides packaging solutions to customers serving portions of california 2019s strong agricultural market . sacramento container 2019s financial results are included in the packaging segment from the date of acquisition . the company accounted for the sacramento container acquisition using the acquisition method of accounting in accordance with asc 805 , business combinations . the total purchase price has been allocated to tangible and intangible assets acquired and liabilities assumed based on respective fair values , as follows ( dollars in millions ) : .

Table:
 | 12/31/17 allocation | adjustments | revised allocation
goodwill | $ 151.1 | $ 5.5 | $ 156.6
other intangible assets | 72.6 | -5.5 ( 5.5 ) | 67.1
property plant and equipment | 26.7 | 2014 | 26.7
other net assets | 23.4 | 2014 | 23.4
net assets acquired | $ 273.8 | $ 2014 | $ 273.8
during the second quarter ended june 30 , 2018 , we made a $ 5.5 million net adjustment based on the final valuation of the intangible assets .
we recorded the adjustment as a decrease to other intangible assets with an offset to goodwill .
goodwill is calculated as the excess of the purchase price over the fair value of the net assets acquired .
among the factors that contributed to the recognition of goodwill were sacramento container 2019s commitment to continuous improvement and regional synergies , as well as the expected increases in pca 2019s containerboard integration levels .
goodwill is deductible for tax purposes .
other intangible assets , primarily customer relationships , were assigned an estimated weighted average useful life of 9.6 years .
property , plant and equipment were assigned estimated useful lives ranging from one to 13 years. .

Question: for the revised total purchase price allocation , property plant and equipment was what percentage of net assets acquired?
Answer: 9.8%
Calculation: divide(26.7, 273.8)
INCOME TAX EXPENSE
Below is a summary of the difference between income tax expense computed by applying the statutory income tax rate to income before income tax expense and the actual income tax expense for the year.
Our effective income tax rate this year was 25.8% compared to 26.9% for 2018. The effective income tax rate for 2019 was lower than the statutory tax rate primarily as a result of a reduction to the Alberta corporate income tax rate over a four-year period.
Cash income taxes paid increased this year primarily as a result of the timing of installment payments.
Table:
 | Years ended December31 | 
(In millions of dollars, except tax rates) | 2019 | 2018
Statutory income tax rate | 26.7% | 26.7%
Income before income tax expense | 2,755 | 2,817
Computed income tax expense | 736 | 752
Increase (decrease) in income tax expense resulting from: |  | 
Non-deductible stock-based compensation | – | 5
Non-deductible portion of equity losses | 7 | 1
Income tax adjustment, legislative tax change | (23) | -
Non-taxable portion of capital gains | (2) | (9)
Other items | (6) | 9
Total income tax expense | 712 | 758
Effective income tax rate | 25.8% | 26.9%
Cash income taxes paid | 400 | 370


Question: What was the percentage increase / (decrease) in Total income tax expense from 2018 to 2019?
Answer: -6.07
Calculation: 712 / 758 - 1
The movements below in foreign currency translation reserve and cashflow hedge reserve relating to the NSPT Group are presented within non-controlling interest in the Group’s consolidated statement of changes in equity.
Taxation impact on revaluation applies only to cash flow hedges held in NSNZPT, a sub-trust of NSPT, which is subject to New Zealand tax legislation. Deferred tax does not apply to any other cash flow hedges held in the NSPT Group under current Australian tax legislation.
The hedging reserve is used to record gains or losses on derivatives that are designated as cash flow hedges and recognised in other comprehensive income, as described in note 2(m). Amounts are reclassified to profit or loss in the period when the associated hedged transaction takes place.
On 24 June 2019, the Group reset the interest rates associated with AUD denominated interest rate swaps designated as cash flow hedges. This resulted in a cash outflow of $22.9m which reduced the Group’s financial liability as presented in note 9.8. In accordance with AASB 9 Financial instruments, as the nature of the underlying hedged instrument is unchanged the fair value of this outflow remains in the cash flow hedge reserve and will be amortised to the statement of profit or loss in future periods.
The cash flow hedge is included in non-controlling interest in the Consolidated Group and is not classified within other reserves.
Table:
NSPT Group |  | 
 | 2019 | 2018
 | $'000 | $'000
Foreign currency translation reserve |  | 
Opening balance at 1 July | (115) | 232
Net investment hedge | (1,591) | 1,007
Foreign exchange translation differences | 2,464 | (1,354)
Closing balance at 30 June | 758 | (115)
Cash flow hedge reserve |  | 
Opening balance at 1 July | (2,073) | (45)
Revaluation of derivatives | (22,098) | (2,112)
Taxation impact on revaluation | 290 | 84
Closing balance at 30 June | (23,881) | (2,073)
Other reserves | (23,123) | (2,188)


Question: Where is the hedging reserve used?
Answer: record gains or losses on derivatives that are designated as cash flow hedges and recognised in other comprehensive income, as described in note 2(m).
NAVIOS MARITIME HOLDINGS INC. NOTES TO THE CONSOLIDATED FINANCIAL STATEMENTS (Expressed in thousands of U.S. dollars — except share data)
NOTE 8: INTANGIBLE ASSETS/LIABILITIES OTHER THAN GOODWILL
Net Book Value of Intangible Assets other than Goodwill as at December 31, 2018
(**) During the year ended December 31, 2018, acquisition costs of $1,150 of favorable lease terms were capitalized as part of the cost of one vessel due to the exercise of the purchase option (See also Note 2(n)). As of December 31, 2018, intangible assets associated with the favorable lease terms included an amount of $31,342 associated with the favorable lease terms of certain charter out contracts of Navios Containers which were recognized as of November 30, 2018 (see Note 3). During the year ended December 31, 2017, acquisition costs of $10,398 and accumulated amortization of $7,001 of favorable lease terms were considered impaired and were written off resulting in a loss of $3,397 included in the statement of comprehensive (loss)/income within the caption of “Impairment loss/ loss on sale of vessels, net”.
Table:
 | Acquisition Cost | Accumulated Amortization | Transfer/ Write off | Net Book Value December 31, 2018
Trade name | $100,420 | $(47,966) | $— | $52,454
Port terminal operating rights | 53,152 | (11,838) | — | 41,314
Customer relationships | 35,490 | (19,520) | — | 15,970
Favorable lease terms(**) | 32,492 | (2,143) | (1,150) | 29,199
Total Intangible assets | $221,554 | $(81,467) | $(1,150) | $138,937


Question: What was the Accumulated Amortization of favorable lease terms?
Answer: (2,143)
The following table provides a reconciliation of Adjusted SG&A to SG&A expenses, the most directly comparable financial measure presented in accordance with U.S. GAAP:
(a) Represents depreciation and amortization expense included in SG&A.
(b) Represents non-cash share-based compensation expense included in SG&A.
(c) Represents new store marketing allowance of $1,000 for each store added to our distribution network, as well as the non-capitalized freight costs associated with Freshpet Fridge replacements. The expense enhances the overall marketing spend to support our growing distribution network.
(d) Represents fees associated with secondary public offerings of our common stock.
(e) Represents charges associated with our former Chief Executive Officer’s separation agreement, as well as changes in estimates associated with leadership transition costs
(f) Represents fees associated with two securities lawsuits.
Table:
 | Twelve Months Ended December 31, |  |  |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
 | (Dollars in thousands) |  |  |  | 
SG&A expenses | $114,450 | $94,876 | $75,167 | $62,586 | $58,297
Depreciation and amortization expense (a) | 9,551 | 7,977 | 6,901 | 5,859 | 5,008
Non-cash share-based compensation (b) | 6,912 | 5,949 | 4,195 | 3,972 | 3,723
Launch expense (c) | 4,563 | 3,540 | 3,066 | 2,813 | 2,626
Loss on disposal of equipment | 649 | — | — | — | —
Secondary offering expenses (d) | 302 | 362 | — | — | 593
Leadership transition expenses (e) | — | — | 63 | 1,291 | —
Litigation expense (f) | — | 348 | 145 | — | —
Adjusted SG&A Expenses | $92,473 | $76,698 | $60,797 | $48,651 | $46,347
Adjusted SG&A Expenses as a % of Net Sales | 37.6% | 39.7% | 39.9% | 37.5% | 40.8%


Question: What does Leadership transition expenses represent?
Answer: charges associated with our former Chief Executive Officer’s separation agreement, as well as changes in estimates associated with leadership transition costs
Stock Options
Our stock options are generally exercisable in increments of either one-fourth or one-third per year beginning one year from the date of grant. Stock options issued after February 2014 expire eight years from the date of grant. Options issued prior to February 2014 expire six years from the date of grant. Option activity for 2019 is summarized as follows:
The total intrinsic value was $108 million, $446 million, and $198 million for options exercised in 2019, 2018, and 2017, respectively.
Table:
 | Number of Shares | Weighted-Average Exercise Price Per Share | Weighted-Average Remaining Contractual Life (In Years) | Aggregate Intrinsic Value
Outstanding as of August 30, 2018 | 18 | $23.38 |  | 
Granted | — | 44.30 |  | 
Exercised | (5) | 17.50 |  | 
Canceled or expired | (1) | 22.60 |  | 
Outstanding as of August 29, 2019 | 12 | 25.94 | 4.3 | $220
Exercisable as of August 29, 2019 | 7 | $25.37 | 3.7 | $143
Unvested as of August 29, 2019 | 5 | 26.94 | 5.5 | 77


Question: What is the proportion of exercisable shares among the total outstanding shares as of August 29, 2019?
Answer: 0.58
Calculation: 7/12
* Recast to reflect segment changes.
The year-to-year improvements in margins and pre-tax income in GBS were the result of the shift to higher-value offerings, realignment of resources to key skill areas, increased productivity and utilization as well as a benefit from currency, due to the company’s global delivery model.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2018* | 2017* | Yr.-to-Yr. Percent/ Margin Change
Global Business Services |  |  | 
External gross profit | $4,448 | $4,033 | 10.3%
External gross profit margin | 26.8% | 25.1% | 1.7pts
Pre-tax income | $1,629 | $1,303 | 25.0%
Pre-tax margin | 9.6% | 7.9% | 1.7pts


Question: What is the increase / (decrease) in the external gross profit from 2017 to 2018?
Answer: 415
Calculation: 4,448 - 4,033
Property and equipment consist of the following (in thousands):
Depreciation expense was $1.2 million and $1.6 million for the years ended December 31, 2019 and 2018, respectively.
Amortization of capitalized internal-use software and website development costs was $157,000 and $247,000 for the years ended December 31, 2019 and 2018, respectively.
Table:
December 31, |  | 
 | 2019 | 2018
Computer hardware and software | $3,427 | $3,353
Office equipment and office furniture | 8,148 | 7,814
Capitalized internal-use software and website development | 4,390 | 4,383
Leasehold improvements | 6,247 | 6,140
 | 22,212 | 21,690
Less accumulated depreciation and amortization | (19,230) | (17,900)
Total | $2,982 | $3,790


Question: What is the average of the total property and equipment for 2018 and 2019?
Answer: 3386
Calculation: (2,982+ 3,790)/2
REVENUES BY SERVICES AND PRODUCTS
The following table presents our revenues disaggregated by type of services and products.
(1) Our service revenues are generally recognized over time.
(2) Our product revenues are generally recognized at a point in time.
Table:
FOR THE YEAR ENDED DECEMBER 31 | 2019 | 2018
Services (1) |  | 
Wireless | 6,427 | 6,269
Wireline data | 7,684 | 7,466
Wireline voice | 3,564 | 3,782
Media | 2,811 | 2,677
Other wireline services | 251 | 247
Total services | 20,737 | 20,441
Products (2) |  | 
Wireless | 2,660 | 2,497
Wireline data | 519 | 466
Wireline equipment and other | 48 | 64
Total products | 3,227 | 3,027
Total operating revenues | 23,964 | 23,468


Question: Which segment when disaggregated has more types?
Answer: Services
Calculation: 5>3
Gross Profit
Year Ended December 31, 2019 Compared with the Year Ended December 31, 2018
Gross profit and margin decreased during the year ended December 31, 2019 compared to prior year primarily due to an increase in hosting migration costs, higher amortization of software development, recognition of previously deferred costs and the sale of OneContent business on April 2, 2018, which carried a higher gross margin compared with our other businesses. These were partially offset with an increase in organic sales for Veradigm and our acute solutions in 2019.
Year Ended December 31, 2018 Compared with the Year Ended December 31, 2017
Gross profit increased during the year ended December 31, 2018 compared with the year ended December 31, 2017 primarily due to acquisitions. From a revenue mix perspective, gross profit associated with our recurring revenue streams, which include the delivery of recurring subscription-based software sales, support and maintenance, and recurring client services improved as we continued to expand our customer base for these services, particularly those related to outsourcing and revenue cycle management. Gross profit associated with our non-recurring software delivery, support and maintenance revenue stream decreased primarily due to fewer perpetual software license sales of our acute and population health management solutions. Gross profit associated with our non-recurring client services revenue stream, which includes non-recurring project-based client services, decreased primarily driven by higher internal personnel costs, including those related to incremental resources from recent acquisitions. Gross margin decreased primarily due to lower sales of higher margin perpetual software licenses and higher amortization of software development and acquisition-related assets driven by additional amortization expense associated with intangible assets acquired as part of recent acquisitions.
Table:
 | Year Ended December 31, |  |  |  | 
(In thousands) | 2019 | 2018 | 2017 | 2019 % Change from 2018 | 2018 % Change from 2017
Total cost of revenue | $ 1,058,097 | $ 1,025,419 | $ 864,909 | 3.2% | 18.6%
Gross profit | $ 713,580 | $ 724,543 | $ 632,799 | (1.5%) | 14.5%
Gross margin % | 40.3% | 41.4% | 42.3% |  | 


Question: What caused the decrease in Gross profit and margin in 2019?
Answer: primarily due to an increase in hosting migration costs, higher amortization of software development, recognition of previously deferred costs and the sale of OneContent business on April 2, 2018, which carried a higher gross margin compared with our other businesses