hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
23 Borrowings (continued)
The fair values of fixed rate borrowings and CMBS are assessed based on quoted market prices, and as such are categorised as Level 1 in the fair value hierarchy (see note 27 for definition). The fair values of unlisted floating rate borrowings are equal to their carrying values and are categorised as Level 2 in the fair value hierarchy.
The maturity profile of debt (excluding lease liabilities) is as follows:
Certain borrowing agreements contain financial and other conditions that, if contravened, could alter the repayment profile (further information is provided in financial covenants on pages 165 and 166)
At 31 December 2019 the Group had committed undrawn borrowing facilities of £238.5 million (2018: £274.2 million), maturing in 2021 and 2022. This includes £42.1 million of undrawn facilities in respect of development finance.
Table:
£m | 2019 | 2018
Repayable within one year | 65.8 | 46.7
Repayable in more than one year but not more than two years | 901.8 | 30.5
Repayable in more than two years but not more than five years | 2,114.2 | 2,722.0
Repayable in more than five years | 1,569.6 | 2,155.9
 | 4,651.4 | 4,955.1


Question: What is the amount of undrawn borrowing facilities at 31 December 2019?
Answer: £238.5 million
20. Trade and other payables
Following the application of IFRS 16, trade and other payables for the year ended 31 March 2018 have been restated (note 2).
Trade payables are unsecured and are usually paid within 30 days of recognition. The carrying amounts of trade and other payables are considered to be the same as their fair values, due to their short-term nature.
Table:
 | 2019 | (Restated) 2018
 | £m | £m
Trade payables | 4.3 | 3.7
Accruals | 10.5 | 9.8
Other taxes and social security | 13.0 | 11.8
Deferred income | 13.2 | 1.8
Other payables | 0.3 | 0.9
Accrued interest payable | 0.5 | 0.5
Total | 41.8 | 28.5


Question: Why are trade payables in 2018 restated in the table?
Answer: Following the application of IFRS 16
Patents and Intangible Assets
The Company owns or possesses licenses to use its patents. The costs of maintaining the patents are expensed as incurred.
The Company and Finjan Blue entered into a Patent Assignment and Support Agreement (the “Patent Assignment Agreement”) with IBM effective as of August 24, 2017 (see "Note 7 - Commitments and Contingencies"). Pursuant to the Patent Assignment Agreement, Finjan Blue acquired select IBM patents in the security sector. In accordance with ASC 350-30-35-2 through 35-4, Intangibles-Goodwill and Other, the Company determined that the useful life of the patents acquired under the Patent Assignment and Support Agreement should be amortized over the four-year term of the agreement.
On May 15, 2018, Finjan Blue, entered into a second agreement with IBM (the “May 2018 Patent Assignment Agreement”). Pursuant to the May 2018 Patent Assignment Agreement, Finjan Blue acquired 56 select issued and pending IBM patents in the security sector. The terms of the May 2018 Patent Assignment Agreement are confidential. In accordance with ASC 350-30-35-2 through 35-4, Intangibles-Goodwill and Other, the Company determined that the useful life of the patents acquired under the May 2018 Patent Assignment Agreement should be amortized over five years as the covenants between the parties are effective for that period.
Management did not identify any triggering events which would have necessitated an impairment change.
The components of these intangible assets are as follows:
Amortization expense for the years ended December 31, 2019, 2018 and 2017 was approximately $2.0 million, $1.8 million, and $0.8 million, respectively.
Table:
As of December 31, |  | 
 | 2019 | 2018
 |  | (in thousands)
Patents | $26,069 | $26,069
Less accumulated amortization | (22,517) | (20,562)
Intangible assets, net | $3,552 | $5,507


Question: What are the respective values of patents in 2019 and 2018?
Answer: $26,069, $26,069
5. Investment income and financing costs
Investment income comprises interest received from short-term investments and other receivables as well as certain foreign exchange movements. Financing costs mainly arise from interest due on bonds and commercial paper issued, bank loans and the results of hedging transactions used to manage foreign exchange and interest rate movements
Note: 1 Includes €305 million (2018: €187 million; 2017: €272 million) of interest on foreign exchange derivatives.
Table:
 | 2019 | 2018 | 2017
 | €m | €m | €m
Investment income: |  |  | 
Amortised cost | 286 | 339 | 426
Fair value through profit and loss | 147 | 24 | 20
Foreign exchange | – | 322 | 28
 | 433 | 685 | 474
Financing costs: |  |  | 
Items in hedge relationships: |  |  | 
Other loans | 17 | 74 | 170
Interest rate and cross-currency interest rate swaps | (414) | (128) | (235)
Fair value hedging instrument | (8) | 48 | 22
Fair value of hedged item | 10 | (36) | (16)
Other financial liabilities held at amortised cost: |  |  | 
Bank loans and overdrafts | 336 | 317 | 419
Bonds and other liabilities1 | 1,567 | 885 | 1,243
Interest (credit)/charge on settlement of tax issues | (1) | (11) | 47
Fair value through profit and loss: |  |  | 
Derivatives – options, forward starting swaps and futures | 391 | (75) | (244)
Foreign exchange | 190 | – | –
 | 2,088 | 1,074 | 1,406
Net financing costs | 1,655 | 389 | 932


Question: How much is the 2019 bonds and other liabilities, excluding the interest on foreign exchange derivatives?
Answer: 1262
Calculation: 1,567-305
Net Income Per Share
Basic net income per share is computed by dividing net income by the weighted-average number of common shares outstanding for the period. Diluted net income per share is computed giving effect to all potentially dilutive common stock and common stock equivalents, including stock options, RSUs and common stock subject to repurchase.
The following table reconciles the shares used in calculating basic net income per share and diluted net income per share (in thousands):
Table:
 |  | Fiscal Year Ended | 
 | December 28, 2019 | December 29, 2018 | December 30, 2017
Weighted-average shares used in computing basic net income per share | 74,994 | 73,482 | 72,292
Add potentially dilutive securities | 2,292 | 1,700 | 1,947
Weighted-average shares used in computing basic and diluted net income per share | 77,286 | 75,182 | 74,239


Question: How is the basic net income per share calculated?
Answer: computed by dividing net income by the weighted-average number of common shares outstanding for the period.
Indefinite-lived Intangible Assets
Indefinite-lived intangible assets consist entirely of acquired in-process research and development technology, or IPR&D. The following table sets forth the Company’s activities related to the indefinite-lived intangible assets:
The Company performs its annual assessment of indefinite-lived intangible assets on October 31 each year or more frequently if events or changes in circumstances indicate that the asset might be impaired utilizing a qualitative test as a precursor to the quantitative test comparing the fair value of the assets with their carrying amount. Based on the qualitative test, if it is more likely than not that indicators of impairment exists, the Company proceeds to perform a quantitative analysis. Based on the Company’s assessment as of October 31, 2019, no indicators of impairment were identified.
In the years ended December 31, 2019 and 2018, no IPR&D impairment losses were recorded. In the year ended December 31, 2017, the Company recognized impairment losses of $2.0 million related to the Company's abandonment of a single IPR&D project.
Table:
Years Ended December 31, |  | 
 | 2019 | 2018
(in thousands) |  | 
Beginning balance | $4,400 | $4,400
Transfers to developed technology from IPR&D | (4,400) | —
Ending balance | $— | $4,400


Question: What was the impairment loss recognized by the company in 2017?
Answer: $2.0 million
Plans with projected benefit obligations in excess of plan assets are attributable to unfunded domestic supplemental retirement plans, and our U.K. retirement plan.
Accrued benefit liability reported as:
As of September 30, 2019 and 2018, the amounts included in accumulated other comprehensive income, consisted of
deferred net losses totaling approximately $6.3 million and $5.3 million, respectively.
The amount of net deferred loss expected to be recognized as a component of net periodic benefit cost for the year ending September 30, 2019, is approximately $229 thousand.
Table:
 | September 30, | 
 | 2019 | 2018
 | (Amounts in thousands) | 
Current accrued benefit liability | $335 | $340
Non-current accrued benefit liability | 6,904 | 6,168
Total accrued benefit liability | $7,239 | $6,508


Question: What is the change in non-current accrued benefit liability between 2018 and 2019?
Answer: 736
Calculation: 6,904 - 6,168
Net Debt to Adjusted EBITDA Ratio
(UNAUDITED)
($ in millions)
(1) 2017 Adjusted EBITDA shown pro forma, assuming the Level 3 acquisition and the colocation and data center sale took place on January 1, 2017.
Table:
 | 2019 | 2018 | 2017(1)
Gross Debt | $35,039 | 36,352 | 38,053
Cash and cash equivalents | (1,690) | (488) | (551)
Net debt | $33,349 | 35,864 | 37,502
Adjusted EBITDA excluding integration and transformation costs and special items (1) | $9,070 | 9,040 | 8,686
Net Debt to Adjusted EBITDA Ratio | 3.7 | 4.0 | 4.3


Question: What is the assumption for the 2017 adjusted EBITDA shown pro forma?
Answer: the Level 3 acquisition and the colocation and data center sale took place on January 1, 2017.
At December 31, 2019, the Company’s net operating losses and credit carryforwards are:
(1) Excludes federal and state net operating losses of $60.2 million and $0.8 million, respectively, from prior acquisitions that the Company expects will expire unutilized
(2) Excludes federal and state tax credits of $0.1 million and $8.3 million, respectively, that the Company expects will expire unutilized
Carryforward losses and credits expire between 2020 and 2038, except for the 2019 federal net operating loss of $43.9 million and $1 million of state credits, which both have unlimited carryforward periods.
The Company’s India subsidiary is primarily located in Special Economic Zones (“SEZs”) and is entitled to a tax holiday in India. The tax holiday reduces or eliminates income tax in India. The tax holiday in the Hyderabad SEZ is scheduled to expire in 2024. The tax holiday in the Bangalore SEZ is scheduled to expire in 2022. For 2019, 2018 and 2017, the income tax holiday reduced the Company’s provision for income taxes by $1.9 million, $1.3 million, and $1 million, respectively.
Table:
(in thousands) | Federal | State
Net operating losses (1) | $120,722 | $3,337
Net operating losses due to acquisitions (1) | $76,827 | $778
Credit carryforwards (2) | $8,202 | $1,958
Credit carryforwards due to acquisitions | $640 | $227


Question: What is the company's reduction in provision for income taxes arising from its income tax holiday in 2019 and 2018 respectively?
Answer: $1.9 million, $1.3 million
Total Deferred Revenue
The adoption of ASC Topic 606 required a change to the definition of unbilled deferred revenue and new qualitative and quantitative disclosures around our performance obligations. Unbilled deferred revenue represents contractually stated or committed orders under early renewal and multi-year billing plans primarily for subscription, services and maintenance for which the associated deferred revenue has not been recognized. Under ASC Topic 606, unbilled deferred revenue is not included as a receivable or deferred revenue on our Consolidated Balance Sheet. See Part II, Item 8, Note 2, “Revenue Recognition” for more details on Autodesk's performance obligations.
We expect that the amount of billed and unbilled deferred revenue will change from quarter to quarter for several reasons, including the specific timing, duration and size of customer subscription and support agreements, varying billing cycles of such agreements, the specific timing of customer renewals, and foreign currency fluctuations
Table:
 | January 31, 2019 |  | January 31, 2018
(in millions) | ASC 606 | ASC 605 | ASC 605
Deferred revenue | $2,091.4 | $2,269.2 | $1,955.1
Unbilled deferred revenue | 591.0 | 491.6 | 326.4
Total deferred revenue | $2,682.4 | $2,760.8 | $2,281.5


Question: What is the difference between the unbilled deferred revenue for ASC 605 from January 31, 2018 to January 31, 2019?
Answer: 165.2
Calculation: 491.6-326.4
The Group made an operating profit of $60.9 million in the year and adjusted operating profit increased by $50.7 million to $109.0 million, primarily as a result of strong revenue growth. This year's result benefited from a foreign exchange gain of $1.5 million, compared to a foreign exchange loss of $6.9 million in the prior-year.
The Group’s profit before taxation increased by $94.6 million to $53.6 million, from a loss of $41.0 million in the prior-year, primarily as a consequence of the $80.6 million improvement in operating profit supported by a $13.4 million reduction in finance expenses. Finance expenses benefited from foreign exchange gains in the current year resulting from the strengthening of both sterling and the euro against the US dollar, compared to foreign exchange losses in the prior-year.
The Group’s profit for the year increased by $87.8 million to $26.9 million in the year-ended 31 March 2019, which given only a small increase in the year-on-year income tax charge was primarily attributable to the improvement in the profit before taxation.
Cash flow from operating activities remained strong at $142.9 million, reduced by $4.8 million from $147.7 million in the prior-year. The small overall decrease was due to an increase in overheads, partially offset by a reduction in the cashflow outflow on exceptional items and an improved use of working capital. Unlevered free cashflow decreased by $15.8 million to $123.8 million representing the reduction in net cash flow from operating activities adjusted for the cashflow impact of exceptional items.
The table below presents the Group’s financial highlights on a reported basis:
1 Restated for the adoption of IFRS 15 and change in accounting policy in respect of research and development expenditure tax credit scheme and provision for interest on uncertain tax positions, as explained in note 2 of the Financial Statements
2 Definitions and reconciliations of non-GAAP measures are included in note 5 of the Financial Statements
Table:
 | FY19 | FY18 | Change
 | $M | $M | %
Statutory measures |  |  | 
Revenue | 710.6 | 639.0 | 11.2
Profit / (Loss) before taxation | 53.6 | (41.0) | nm
Net cash flow from operating activities | 142.9 | 147.7 | (3.2)
Alternative performance measures2 |  |  | 
Billings | 760.3 | 768.6 | (1.1)
Cash EBITDA | 167.9 | 199.2 | (15.7)
Adjusted operating profit | 109.0 | 58.3 | 87.0
Unlevered free cash flow | 123.8 | 139.6 | (11.3)


Question: Where can the definitions and reconciliations for non-GAAP measures under alternative performance measures be found?
Answer: in note 5 of the Financial Statements
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
14. STOCK-BASED COMPENSATION
Summary of Stock-Based Compensation Plans—The Company maintains equity incentive plans that provide for the grant of stock-based awards to its directors, officers and employees. The 2007 Equity Incentive Plan, as amended (the “2007 Plan”), provides for the grant of non-qualified and incentive stock options, as well as restricted stock units, restricted stock and other stock-based awards. Exercise prices for non-qualified and incentive stock options are not less than the fair value of the underlying common stock on the date of grant. Equity awards typically vest ratably, generally over four years for RSUs and stock options and three years for PSUs. Stock options generally expire 10 years from the date of grant. As of December 31, 2019, the Company had the ability to grant stock-based awards with respect to an aggregate of 7.0 million shares of common stock under the 2007 Plan. In addition, the Company maintains an employee stock purchase plan (the “ESPP”) pursuant to which eligible employees may purchase shares of the Company’s common stock on the last day of each bi-annual offering period at a 15% discount from the lower of the closing market value on the first or last day of such offering period. The offering periods run from June 1 through November 30 and from December 1 through May 31 of each year.
During the years ended December 31, 2019, 2018 and 2017, the Company recorded and capitalized the following stock-based compensation expenses:
Table:
 | 2019 | 2018 | 2017
Stock-based compensation expense - Property | $1.8 | $2.4 | $2.1
Stock-based compensation expense - Services | 1.0 | 0.9 | 0.8
Stock-based compensation expense - SG&A | 108.6 | 134.2 | 105.6
Total stock-based compensation expense | $111.4 | $137.5 | $108.5
Stock-based compensation expense capitalized as property and equipment | $1.6 | $2.0 | $1.6


Question: Which years did the company record and capitalize stock-based compensation expenses?
Answer: 2019, 2018, 2017
Our fourth quarter 2019 net revenues amounted to $2,754 million, registering a sequential increase of 7.9%, 290 basis points above the mid-point of our guidance, with all product groups contributing to the growth. The sequential increase resulted from higher volumes of approximately 7% and an increase of approximately 1% in average selling prices, the latter entirely due to product mix, while selling prices remained substantially stable.
On a year-over-year basis, our net revenues increased by 4.0%. This increase was entirely due to an increase of approximately 6% in average selling prices, partially offset by an approximate 2% decrease in volumes. The average selling prices increase was entirely driven by improved product mix of approximately 9%, partially offset by lower selling prices of approximately 3%.
Table:
 | Three Months Ended | Three Months Ended | Three Months Ended | % Variation | % Variation
 | December 31, 2019 | September 29, 2019 | December 31, 2018 | Sequential | Year- Over- Year
 | (Unaudited, in millions) |  |  |  | 
Net sales | $ 2,750 | $ 2,547 | $ 2,633 | 8.0% | 4.5%
Other revenues | 4 | 6 | 15 | (45.0) | (77.4)
Net revenues | $ 2,754 | $ 2,553 | $ 2,648 | 7.9% | 4.0%


Question: What is the average other revenues sales for the period December 31, 2019 and 2018?
Answer: 9.5
Calculation: (4+15) / 2
Net revenues by geographical region
Percentage of revenue by geographic region as presented below is based on the billing location of the customer.
Percentages may not add to 100% due to rounding.
The Americas include U.S., Canada, and Latin America; EMEA includes Europe, Middle East, and Africa; APJ includes Asia Pacific and Japan.
Table:
 | Fiscal Year | 
 | 2019 | 2018
Americas | 64% | 63%
EMEA | 21% | 22%
APJ | 15% | 16%


Question: What regions are included in the Americas?
Answer: U.S., Canada, and Latin America
The difference between the tax provision at the statutory federal income tax rate and the tax provision as a percentage of income before income taxes (effective tax rate) for each period was as follows:
The majority of the increase in our effective tax rate in 2019 compared to 2018 was driven by one-time benefits that occurred in 2018.
The majority of the decrease in our effective tax rate in 2018 compared to 2017 resulted from initial tax expense from Tax Reform and the tax impacts from the ISecG divestiture that we had in 2017, but not in 2018. The reduction of the U.S. statutory rate, combined with the net impact of the enactment or repeal of specific tax law provisions through Tax Reform, drove the remaining decrease in our effective tax rate in 2018.
We derive the effective tax rate benefit attributed to non-U.S. income taxed at different rates primarily from our operations in China, Hong Kong, Ireland, and Israel. The statutory tax rates in these jurisdictions range from 12.5% to 25.0%. In addition, we are subject to reduced tax rates in China and Israel as long as we conduct certain eligible activities and make certain capital investments. These conditional reduced tax rates expire at various dates through 2026 and we expect to apply for renewals upon expiration.
Table:
Years Ended | Dec 28, 2019 | Dec 29, 2018 | Dec 30, 2017
Statutory federal income tax rate | 21.0% | 21.0% | 35.0%
Increase (reduction) in rate resulting from: |  |  | 
Non-U.S. income taxed at different rates | (3.7) | (3.6) | (7.6)
Research and development tax credits | (2.3) | (2.7) | (2.3)
Domestic manufacturing deduction benefit | — | — | (1.3)
Foreign derived intangible income benefit | (3.2) | (3.7) | —
Tax Reform | — | (1.3) | 26.8
ISecG divestiture | — | — | 3.3
Other | 0.7 | (0.1) | (1.1)
Effective tax rate | 12.5% | 9.7% | 52.8%


Question: What does the table show?
Answer: The difference between the tax provision at the statutory federal income tax rate and the tax provision as a percentage of income before income taxes (effective tax rate) for each period
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 increase / (decrease) in Income before income tax expense from 2019 to 2018?
Answer: -62
Calculation: 2,755 - 2,817
Results of Operations
The following tables set forth selected consolidated statements of operations data and such data as a percentage of total revenues. The historical results presented below are not necessarily indicative of the results that may be expected for any future period (in thousands):
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Revenues |  |  | 
Subscriptions | $817,811 | $612,888 | $465,254
Other | 85,047 | 60,736 | 38,363
Total revenues | 902,858 | 673,624 | 503,617
Cost of revenues |  |  | 
Subscriptions | 160,320 | 109,454 | 89,193
Other | 70,723 | 47,675 | 32,078
Total cost of revenues | 231,043 | 157,129 | 121,271
Gross profit | 671,815 | 516,495 | 382,346
Operating expenses |  |  | 
Research and development | 136,363 | 101,042 | 75,148
Sales and marketing | 439,100 | 329,116 | 240,223
General and administrative | 142,027 | 102,773 | 72,313
Total operating expenses | 717,490 | 532,931 | 387,684
Loss from operations | (45,675) | (16,436) | (5,338)
Other income (expense), net |  |  | 
Interest expense | (20,512) | (16,102) | (99)
Other income, net | 9,247 | 6,475 | 1,491
Other income (expense), net | (11,265) | (9,627) | 1,392
Loss before income taxes | (56,940) | (26,063) | (3,946)
Provision for (benefit from) income taxes | (3,333) | 140 | 258
Net loss | $(53,607) | $(26,203) | $(4,204)


Question: What is the percentage change in total revenue between 2017 and 2018?
Answer: 33.76
Calculation: (673,624 - 503,617)/503,617