hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Effective Income Tax Rate
A reconciliation of the United States federal statutory income tax rate to our effective income tax rate is as follows:
In 2019 and 2018 we had pre-tax losses of $19,573 and $25,403, respectively, which are available for carry forward to offset future taxable income. We made determinations to provide full valuation allowances for our net deferred tax assets at the end of 2019 and 2018, including NOL carryforwards generated during the years, based on our evaluation of positive and negative evidence, including our history of operating losses and the uncertainty of generating future taxable income that would enable us to realize our deferred tax.
Table:
 | Year Ended | Year Ended
 | December 31, 2018 | December 31, 2019
United States federal statutory rate | 21.00% | 21.00%
State taxes, net of federal benefit | 1.99% | (0.01)%
Valuation allowance | (21.96)% | (24.33)%
Cumulative effect of accounting change | — | 2.07%
R&D Credit | 1.34% | 1.53%
Other | (0.38)% | (0.27)%
Effective income tax rate | 1.99% | (0.01)%


Question: What were the pre-tax losses in 2019?
Answer: $19,573
Cloud & Cognitive Software revenue increased in 2018 compared to the prior year with growth in all three lines of business, as reported and adjusted for currency. Within Cognitive Applications, the increase was driven by strong double-digit growth in security services, while growth in Cloud & Data Platforms was led by analytics platforms and integration offerings. Transaction Processing Platforms grew with improved revenue performance sequentially in the fourth-quarter 2018 versus the third-quarter 2018 reflecting clients’ commitment to the company’s platform for the long term and the value it provides in managing mission-critical workloads. Within Cloud & Cognitive Software, cloud revenue of $3.0 billion grew 10 percent as reported and adjusted for currency compared to the prior year.
* Recast to reflect segment changes.
Gross margin in Cloud & Cognitive Software was impacted by an increased mix toward SaaS, a mix toward security services and increased royalty costs associated with IP licensing agreements compared to the prior year. Pre-tax income improvement year to year was primarily driven by operational efficiencies and mix.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2018* | 2017* | Yr.-to-Yr. Percent/ Margin Change
Cloud & Cognitive Software |  |  | 
External gross profit | $17,224 | $16,986 | 1.4%
External gross profit margin | 77.6% | 78.1% | (0.5)pts.
Pre-tax income | $8,882 | $8,068 | 10.1%
Pre-tax margin | 35.0% | 32.4% | 2.6pts.


Question: What was the gross profit margin in 2018?
Answer: 77.6%
4. Acquisitions and Divestitures
(a) Acquisition Summary
We completed five acquisitions during fiscal 2019. A summary of the allocation of the total purchase consideration is presented as follows (in millions):
On September 28, 2018, we completed our acquisition of privately held Duo Security, Inc. (“Duo”), a leading provider of unified access security and multi-factor authentication delivered through the cloud. Revenue from the Duo acquisition has been included in our Security product category.
On February 6, 2019, we completed our acquisition of Luxtera, Inc. (“Luxtera”), a privately held semiconductor company. Revenue from the Luxtera acquisition has been included in our Infrastructure Platforms product category.
The total purchase consideration related to our acquisitions completed during fiscal 2019 consisted of cash consideration and vested share-based awards assumed. The total cash and cash equivalents acquired from these acquisitions was approximately $100 million.
Table:
Fiscal 2019 | Purchase Consideration | Net Tangible Assets Acquired (Liabilities Assumed) | Purchased Intangible Assets | Goodwill
Duo | $2,025 | $(57) | $342 | $1,740
Luxtera | 596 | (19) | 319 | 296
Others (three in total) | 65 | 2 | 11 | 52
Total | $2,686 | $(74) | $672 | $2,088


Question: What is the acquisition with the highest Purchase Consideration?
Answer: Duo
Calculation: Under the column for Purchase Considerations, excluding the Total row,find the largest number and the corresponding acquisition in COL2
Warranty Obligations
We offer warranties on certain products and record a liability for the estimated future costs associated with warranty claims at the time revenue is recognized. The warranty liability is based upon historical experience and our estimate of the level of future costs. While we engage in product quality programs and processes, our warranty obligation is affected by product failure rates, material usage and service delivery costs incurred in correcting a product failure.
We continuously monitor product returns for warranty and maintain a reserve for the related expenses based upon our historical experience and any specifically identified field failures. As we sell new products to our customers, we must exercise considerable judgment in estimating the expected failure rates. This estimating process is based on historical experience of similar products, as well as various other assumptions that we believe to be reasonable under the circumstances.
We provide for the estimated cost of product warranties at the time revenue is recognized. Warranty costs are reflected in the Consolidated Statement of Income as a Cost of revenues. A reconciliation of the changes in our warranty liability is as follows (in thousands):
Table:
 |  | Fiscal Year Ended | 
 | December 28,
2019 | December 29, 2018 | December 30, 2017
Balance at beginning of year | $2,102 | $ 3,662 | $2,972
Accruals | 3,881 | 3,181 | 8,115
Settlements | (4,041) | (4,741) | (7,425)
Balance at end of year | $1,942 | $2,102 | $3,662


Question: What is the change in Accruals from Fiscal Year Ended December 28, 2019 to December 29, 2018?
Answer: 700
Calculation: 3,881-3,181
WebLife Balance, Inc.
On November 30, 2017 (the “WebLife Acquisition Date”), pursuant to the terms of a merger agreement, the Company acquired all shares of WebLife Balance, Inc. (“WebLife”), a browser isolation offerings vendor, to extend its advanced threat protection capabilities into personal email, while preserving the privacy of its users.
The Company has estimated fair values of acquired tangible assets, intangible assets and liabilities at the WebLife Acquisition Date. The results of operations and the fair values of the acquired assets and liabilities assumed have been included in the accompanying consolidated financial statements since the WebLife Acquisition Date.
At the WebLife Acquisition Date, the consideration transferred was $48,765, net of cash acquired of $278.
Per the terms of the merger agreement, unvested stock options held by WebLife employees were canceled and exchanged for the Company’s unvested awards. The fair value of $333 of these unvested options was attributed to pre-combination service and included in consideration transferred. The fair value of $1,468 was allocated to post-combination services. The unvested awards are subject to the recipient’s continued service with the Company, and $1,468 is recognized ratably as stock-based compensation expense over the required remaining service period. Also, as part of the merger agreement, 107 shares of the Company’s common stock were deferred for certain key employees with the total fair value of $9,652 (see Note 11 “Equity Award Plans”), which was not included in the purchase price. The deferred shares are subject to forfeiture if employment terminates prior to the lapse of the restrictions, and their fair value is expensed as stock-based compensation expense over the remaining period.
Proofpoint, Inc. Notes to Consolidated Financial Statements (Continued) (dollars and share amounts in thousands, except per share amounts)
The following table summarizes the fair values of tangible assets acquired, liabilities assumed, intangible assets and goodwill:
Table:
 |  | Estimated
 |  | Useful Life
 | Fair value | (in years)
Current assets | $534 | N/A
Fixed assets | 23 | N/A
Liabilities | (88) | N/A
Deferred revenue | (700) | N/A
Customer relationships | 600 | 5
Core/developed technology | 16,600 | 5
Deferred tax liability, net | (4,440) | N/A
Goodwill | 36,514 | Indefinite
 | $49,043 | 


Question: What is the amount of Goodwill in fair value?
Answer: 36,514
american tower corporation and subsidiaries notes to consolidated financial statements acquisition accounting upon closing of the acquisition . based on current estimates , the company expects the value of potential contingent consideration payments required to be made under these agreements to be between zero and $ 4.4 million . during the year ended december 31 , 2014 , the company ( i ) recorded a decrease in fair value of $ 1.7 million in other operating expenses in the accompanying consolidated statements of operations , ( ii ) recorded settlements under these agreements of $ 3.5 million , ( iii ) reduced its contingent consideration liability by $ 0.7 million as a portion of the company 2019s obligations was assumed by the buyer in conjunction with the sale of operations in panama and ( iv ) recorded additional liability of $ 0.1 million . as a result , the company estimates the value of potential contingent consideration payments required under these agreements to be $ 2.3 million using a probability weighted average of the expected outcomes as of december 31 , 2014 . other u.s . 2014in connection with other acquisitions in the united states , the company is required to make additional payments if certain pre-designated tenant leases commence during a specified period of time . during the year ended december 31 , 2014 , the company recorded $ 6.3 million of contingent consideration liability as part of the preliminary acquisition accounting upon closing of certain acquisitions . during the year ended december 31 , 2014 , the company recorded settlements under these agreements of $ 0.4 million . based on current estimates , the company expects the value of potential contingent consideration payments required to be made under these agreements to be between zero and $ 5.9 million and estimates it to be $ 5.9 million using a probability weighted average of the expected outcomes as of december 31 , 2014 . for more information regarding contingent consideration , see note 12 . 7 . accrued expenses accrued expenses consists of the following as of december 31 , ( in thousands ) : .

Table:
 | 2014 | 2013 ( 1 )
accrued property and real estate taxes | $ 61206 | $ 54529
payroll and related withholdings | 57110 | 50843
accrued construction costs | 46024 | 52446
accrued rent | 34074 | 28456
other accrued expenses | 219340 | 234914
balance as of december 31, | $ 417754 | $ 421188
( 1 ) december 31 , 2013 balances have been revised to reflect purchase accounting measurement period adjustments. .

Question: how much of the of contingent consideration for acquisitions was actually settled in 2014?
Answer: 6.3%
Calculation: divide(0.4, 6.3)
11 Intangible assets
(a) Intangible assets
RIGHTS AND LICENCES
Certain licences that NEXTDC possesses have an indefinite useful life and are carried at cost less impairment losses and are subject to impairment review at least annually and whenever there is an indication that it may be impaired.
Other licences that NEXTDC acquires are carried at cost less accumulated amortisation and accumulated impairment losses. Amortisation is recognised on a straight-line basis over the estimated useful life. The estimated useful life and amortisation method are reviewed at the end of each annual reporting period.
INTERNALLY GENERATED SOFTWARE
Internally developed software is capitalised at cost less accumulated amortisation. Amortisation is calculated using the straight-line basis over the asset’s useful economic life which is generally two to three years. Their useful lives and potential impairment are reviewed at the end of each financial year.
SOFTWARE UNDER DEVELOPMENT
Costs incurred in developing products or systems and costs incurred in acquiring software and licenses that will contribute to future period financial benefits through revenue generation and/or cost reduction are capitalised to software and systems. Costs capitalised include external direct costs of materials and services and employee costs.
Assets in the course of construction include only those costs directly attributable to the development phase and are only recognised following completion of technical feasibility and where the Group has an intention and ability to use the asset.
Table:
 | 30 June 2019 | 30 June 2018
 | $'000 | $'000
Rights and licences | 13 | 13
Internally generated software | 7,381 | 6,385
Software under development | 16,284 | 6,509
Total intangible assets | 23,678 | 12,907


Question: What was the total intangible assets in 2019?
Answer: 23,678
4.2 Equity (continued)
Share buy-back
A buy-back is the purchase by a company of its existing shares. Refer to note 4.3 for further details.
Share-based payment reserve
This reserve records the value of shares under the Long Term Incentive Plan, and historical Employee and CEO Share Option plans offered to the CEO, Executives and employees as part of their remuneration. Refer to note 5.2 for further details of these plans.
Business combination reserve
The internal group restructure performed in the 2007 financial year, which interposed the holding company, iSelect Limited, into the consolidated group was exempted by AASB 3 Business Combinations as it precludes entities or businesses under common control. The carry-over basis method of accounting was used for the restructuring of the iSelect Group. As such, the assets and liabilities were reflected at their carrying amounts. No adjustments were made to reflect fair values, or recognise any new assets or liabilities. No goodwill was recognised as a result of the combination and any difference between the consideration paid and the ‘equity’ acquired was reflected within equity as an equity reserve titled “Business Combination Reserve”.
Foreign currency translation reserve
Refer to Note 1.5 for further details.
Table:
 | CONSOLIDATED | 
 | 2019 $’000 | 2018 $’000
Reserves |  | 
Share-based payment reserve | 3,960 | 3,198
Business combination reserve | 5,571 | 5,571
Foreign currency translation reserve | (12) | (24)
 | 9,519 | 8,745


Question: Which method of accounting was used for the restructuring of the iSelect Group?
Answer: carry-over basis method of accounting
DEVELOPMENT OF EMPLOYEE NUMBERS BY SEGMENTS
Full-time equivalents1 as of the closing date of 30/9
1 Excluding METRO China.
Table:
 | 2018 | 2019
METRO | 86,239 | 82,979
METRO Germany | 11,816 | 11,760
METRO Western Europe (excl.Germany) | 24,073 | 24,044
METRO Russia | 13,884 | 12,288
METRO Eastern Europe (excl.Russia) | 28,264 | 27,589
METRO Asia | 8,202 | 7,298
Others | 6,916 | 7,067
METROAG | 863 | 837
Total | 94,018 | 90,883


Question: What was the percentage change in METRO AG in 2019 from 2018?
Answer: -3.01
Calculation: (837-863)/863
Free Cash Flow
We monitor our free cash flow, as a key measure of our overall business performance, which enables us to analyze our financial performance without the effects of certain non-cash items such as depreciation, amortization, and stock-based compensation expenses. Additionally, free cash flow takes into account the impact of changes in deferred revenue, which reflects the receipt of cash payment for products before they are recognized as revenue, and unbilled accounts receivable, which reflects revenue that has been recognized that has yet to be invoiced to our customers.
Our net cash provided by (used in) operating activities is significantly impacted by the timing of invoicing and collections of accounts receivable, the timing and amount of annual bonus payments, as well as payroll and tax payments. Our capital expenditures consisted of purchases of property and equipment, most of which were computer hardware, software, capitalized software development costs, and leasehold improvements.
In fiscal year 2019, free cash flow was impacted by $23.6 million related to the build out and furnishing of our new corporate headquarters in San Mateo, California. For a further discussion of our operating cash flows, see “Liquidity and Capital Resources - Cash Flows.”(in thousands)
Table:
 | Fiscal years ended July 31, | 
 | 2019 | 2018
Net cash provided by operating activities | $116,126 | $140,459
Net cash used for capital expenditures | (48,857) | (12,011)
Free cash flow | $67,269 | $128,448


Question: In which year was Free cash flow less than 100,000 thousands?
Answer: 2019
Calculation: locate and analyze Free cash flow in row 5
xvii. Transfer of unclaimed/unpaid amounts to the Investor Education and Protection Fund:
Pursuant to Sections 124 and 125 of the Act read with the Investor Education and Protection Fund Authority (Accounting, Audit, Transfer and Refund) Rules, 2016 (“IEPF Rules”), dividend, if not claimed for a consecutive period of 7 years from the date of transfer to Unpaid Dividend Account of the Company, are liable to be transferred to the Investor Education and Protection Fund (“IEPF”).
Further, all the shares in respect of which dividend has remained unclaimed for seven consecutive years or
more from the date of transfer to unpaid dividend account shall also be transferred to IEPF Authority. The said
requirement does not apply to shares in respect of which there is a specific order of Court, Tribunal or Statutory
Authority, restraining any transfer of the shares.
In the interest of the shareholders, the Company sends periodical reminders to the shareholders to claim
their dividends in order to avoid transfer of dividends/shares to IEPF Authority. Notices in this regard are also
published in the newspapers and the details of unclaimed dividends and shareholders whose shares are liable
to be transferred to the IEPF Authority, are uploaded on the Company’s website (https://www.tcs.com/detailsunclaimed-
dividend-transfer-IEPF-account-2017).
In light of the aforesaid provisions, the Company has during the year under review, transferred to IEPF the
unclaimed dividends, outstanding for 7 consecutive years, of the Company, erstwhile TCS e-Serve Limited and
CMC Limited (since amalgamated with the Company). Further, shares of the Company, in respect of which
dividend has not been claimed for 7 consecutive years or more from the date of transfer to unpaid dividend
account, have also been transferred to the demat account of IEPF Authority.
The details of unclaimed dividends and shares transferred to IEPF during FY 2019 are as follows:
* Includes final dividend of erstwhile TCS e-Serve Limited and erstwhile CMC Limited
The members who have a claim on above dividends and shares may claim the same from IEPF Authority by
submitting an online application in the prescribed Form No. IEPF-5 available on the website www.iepf.gov.
in and sending a physical copy of the same, duly signed to the Company, along with requisite documents
enumerated in the Form No. IEPF-5. No claims shall lie against the Company in respect of the dividend/shares
so transferred. The Members/Claimants can file only one consolidated claim in a financial year as per the IEPF
Rules.
Table:
Financial year | Amount of unclaimed dividend transferred (` lakh) | Number of shares transferred
2011 | 102.6* | 3,028
2012 | 86.5 | 29,672
TOTAL | 189.1 | 32,000


Question: How many times is the number of shares transferred from FY 2012 that of 2011?
Answer: 9.8
Calculation: 29,672/3,028
Note 8 — Property, Plant and Equipment, net
The components of property, plant and equipment, net, are:
The estimated useful lives of buildings and improvements and rental property are twenty to twenty-five years. The estimated useful lives of furniture and equipment range from three to eight years. Depreciation expense from continuing operations was $1.5 million and $1.2 million for 2019 and 2018, respectively.
The Company leases a portion of its headquarters facility to various tenants. Net rent received from these leases totaled $0.3 million and $0.4 million for 2019 and 2018, respectively.
Table:
 | December 31, | 
 | (in thousands) | 
 | 2019 | 2018
Land | $199 | $199
Building and improvements | 6,983 | 6,983
Rental property | 2,749 | 2,749
Software | 12,015 | 2,226
Furniture and equipment | 11,755 | 10,274
Construction in process | 480 | 8,519
 | 34,181 | 30,950
Less accumulated depreciation | (19,830) | (18,375)
 | $ 14,351 | $ 12,575


Question: How much was the Net rent received from leases for 2019 and 2018 respectively?
Answer: $0.3 million, $0.4 million
properties 51vornado realty trust industrial properties our dry warehouse/industrial properties consist of seven buildings in new jersey containing approximately 1.5 million square feet . the properties are encumbered by two cross-collateralized mortgage loans aggregating $ 47179000 as of december 31 , 2006 . average lease terms range from three to five years . the following table sets forth the occupancy rate and average annual rent per square foot at the end of each of the past five years . average annual occupancy rent per as of december 31 , rate square foot .

Table:
as of december 31, | occupancy rate | average annual rent per square foot
2006 | 96.9% ( 96.9 % ) | $ 4.17
2005 | 100.0% ( 100.0 % ) | 4.19
2004 | 88.0% ( 88.0 % ) | 3.96
2003 | 88.0% ( 88.0 % ) | 3.86
2002 | 100.0% ( 100.0 % ) | 3.89
220 central park south , new york city we own a 90% ( 90 % ) interest in 220 central park south .
the property contains 122 rental apartments with an aggregate of 133000 square feet and 5700 square feet of commercial space .
on november 7 , 2006 , we completed a $ 130000000 refinancing of the property .
the loan has two tranches : the first tranche of $ 95000000 bears interest at libor ( capped at 5.50% ( 5.50 % ) ) plus 2.35% ( 2.35 % ) ( 7.70% ( 7.70 % ) as of december 31 , 2006 ) and the second tranche can be drawn up to $ 35000000 and bears interest at libor ( capped at 5.50% ( 5.50 % ) ) plus 2.45% ( 2.45 % ) ( 7.80% ( 7.80 % ) as of december 31 , 2006 ) .
as of december 31 , 2006 , approximately $ 27990000 has been drawn on the second tranche .
40 east 66th street , new york city 40 east 66th street , located at madison avenue and east 66th street , contains 37 rental apartments with an aggregate of 85000 square feet , and 10000 square feet of retail space .
the rental apartment operations are included in our other segment and the retail operations are included in the retail segment. .

Question: for the 2006 refinancing , as of december 31 , 2006 , approximately what percentage as been drawn on the second tranche?
Answer: 80%
Calculation: divide(27990000, 35000000)
19. Inventories
Note
1. Finished goods in 2018 includes $1.8 million relating to deferred costs which has been reclassified from trade and other receivables; see note 2 for further details.
An expense of $1.6 million (2018 $0.1 million) has been charged to the income statement in the year for inventory write-downs. There were no reversals of prior period inventory write-downs (2018 nil).
No inventories are carried at fair value less costs to sell (2018 nil).
Table:
 | 2019 | 2018
 | $ million | $ million
Raw materials | 4.8 | 6.6
Work in progress | 1.2 | 1.2
Finished goods¹ | 14.6 | 19.7
 | 20.6 | 27.5


Question: In which year was the amount of raw materials larger?
Answer: 2018
Calculation: 6.6>4.8