hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The Company’s effective tax rate differs from the U.S. federal statutory rate of 35% for the year ended December 31, 2017, primarily due to the benefit related to the wind down of our solar inverter business and earnings in foreign jurisdictions, which are subject to lower tax rates, offset by the impact of U.S. tax reform. The principal causes of the difference between the federal statutory rate and the effective income tax rate for each the years below are as follows:
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Income taxes per federal statutory rate | $14,111 | $36,199 | $69,348
State income taxes, net of federal deduction | 10 | 2,372 | 1,794
Transition tax - U.S. Tax Reform | — | 1,174 | 61,690
Corporate tax rate changes - U.S. Tax Reform | — | (652) | 11,177
Tax benefit associated with inverter business wind down | — | — | (33,837)
Stock based compensation | (97) | (974) | (5,263)
GILTI Tax | 8,796 | 13,064 | —
Tax effect of foreign operations | (13,086) | (19,162) | (47,482)
Uncertain tax position | (4,487) | (3,088) | 4,948
Unremitted earnings | 1,624 | 2,564 | —
Tax credits | (6,280) | (9,844) | (658)
Change in valuation allowance | 7,222 | (1,306) | 841
Withholding taxes | 6,500 | 1,371 | —
Other permanent items, net | (3,614) | 3,509 | (468)
Total provision for income taxes | $10,699 | $25,227 | $62,090


Question: Why did the company's effective tax rate differ from the U.S. federal statutory rate?
Answer: due to the benefit related to the wind down of our solar inverter business and earnings in foreign jurisdictions, which are subject to lower tax rates, offset by the impact of U.S. tax reform.
Financial Statement Impact of Adoption on Previously Reported Results
We adopted Topic 606 using the modified retrospective method. The cumulative impact of applying the new guidance to all contracts with customers that were not completed as of April 1, 2018 was recorded as an adjustment to retained earnings as of the adoption date. As a result of applying the modified retrospective method to adopt the new standard, the following adjustments were made to noted accounts on the Consolidated Balance Sheet as of April 1, 2018:
The acceleration of revenue that was deferred under prior guidance as of the adoption date was primarily attributable to the requirement of Topic 606 to allocate the transaction price to the performance obligations in the contract on a relative basis using SSP rather than allocating under the residual method, which allocates the entire arrangement discount to the delivered performance obligations.
Due to the Company's full valuation allowance as of the adoption date, there is no tax impact associated with the adoption of Topic 606.
We made certain presentation changes to our Consolidated Balance Sheet on April 1, 2018 to comply with Topic 606. Prior to adoption of the new standard, we offset accounts receivable and contract liabilities (previously presented as deferred revenue on our Consolidated Balance Sheet) for unpaid deferred performance obligations included in contract liabilities.
Under the new standard, we record accounts receivable and related contract liabilities for non-cancelable contracts with customers when the right to consideration is unconditional. Upon adoption, the right to consideration in exchange for goods or services that have been transferred to a customer when that right is conditional on something other than the passage of time were reclassified from accounts receivable to contract assets.
Table:
(In thousands) | March 31, 2018 | Adjustment from Topic 606 | April 1, 2018
Assets: |  |  | 
Accounts receivable, net | 16,389 | 3,124 | 19,513
Contract assets | — | 4,583 | 4,583
Prepaid expenses and other current assets | 5,593 | (496) | 5,097
Other non-current assets | 2,484 | 2,409 | 4,893
Liabilities: |  |  | 
Contract liabilities | 26,820 | 7,006 | 33,826
Shareholders' equity: |  |  | 
Retained earnings | 103,601 | 2,614 | 106,215


Question: What was the percentage change in  Retained earnings after  Adjustment from Topic 606?
Answer: 2.52
Calculation: 2,614/103,601
21. Subsidiaries
The advances given to subsidiaries were interest-free and unsecured with settlement neither planned nor likely to occur in the foreseeable future.
The deemed investment in a subsidiary, Singtel Group Treasury Pte. Ltd. (“SGT”), arose from financial guarantees provided by the Company for loans drawn down by SGT prior to 1 April 2010.
The significant subsidiaries of the Group are set out in Note 44.1 to Note 44.3.
Table:
 |  | Company | 
 | 31 March 2019 | 31 March 2018 | 1 April 2017
 | S$ Mil | S$ Mil | S$ Mil
Unquoted equity shares, at cost | 14,259.7 | 13,676.4 | 11,001.2
Shareholders' advances | 5,733.0 | 5,733.0 | 6,423.3
Deemed investment in a subsidiary | 32.5 | 32.5 | 32.5
 | 20,025.2 | 19,441.9 | 17,457.0
Less: Allowance for impairment losses | (16.0) | (16.0) | (16.0)
 | 20,009.2 | 19,425.9 | 17,441.0


Question: What are the terms of the shareholders' advances?
Answer: interest-free and unsecured with settlement neither planned nor likely to occur in the foreseeable future
We engaged with Dell in the following ongoing related party transactions, which resulted in costs to us:
• We purchase and lease products and purchase services from Dell.
• From time to time, we and Dell enter into agreements to collaborate on technology projects, and we pay Dell for services provided to us by Dell related to such projects.
• In certain geographic regions where we do not have an established legal entity, we contract with Dell subsidiaries for support services and support from Dell personnel who are managed by us. The costs incurred by Dell on our behalf related to these employees are charged to us with a mark-up intended to approximate costs that would have been incurred had we contracted for such services with an unrelated third party. These costs are included as expenses on our consolidated statements of income and primarily include salaries, benefits, travel and occupancy expenses. Dell also incurs certain administrative costs on our behalf in the U.S. that are recorded as expenses on our consolidated statements of income.
• In certain geographic regions, Dell files a consolidated indirect tax return, which includes value added taxes and other indirect taxes collected by us from our customers. We remit the indirect taxes to Dell and Dell remits the tax payment to the foreign governments on our behalf.
• From time to time, we invoice end users on behalf of Dell for certain services rendered by Dell. Cash related to these services is collected from the end user by us and remitted to Dell.
• From time to time, we also enter into agency arrangements with Dell that enable us to sell our subscriptions and services, leveraging the Dell enterprise relationships and end customer contracts.
Information about our payments for such arrangements during the periods presented consisted of the following (table in millions):
1) Amount includes indirect taxes that were remitted to Dell during the periods presented.
We also purchase Dell products through Dell’s channel partners. Purchases of Dell products through Dell’s channel partners were not significant during the periods presented.
Table:
 |  | For the Year Ended | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Purchases and leases of products and purchases of services(1) | $242 | $200 | $142
Dell subsidiary support and administrative costs | 119 | 145 | 212


Question: How many years did Dell subsidiary support and administrative costs exceed $200 million?
Answer: 1
Calculation: 2018
Financial review
2019 was a challenging year for the retail property sector with the ongoing structural changes and low consumer confidence impacting some weaker retailers and leading to a higher level of CVAs and administrations. This impacted our revenue, net rental income and property valuations, with like-for-like net rental income down 9.1 per cent and the property revaluation deficit was £1,979.7 million.
Fixing the balance sheet is our top strategic priority and although the notes accompanying these financial statements indicate a material uncertainty in relation to intu’s ability to continue as a going concern we have options including alternative capital structures and further disposals to put us on a stronger financial footing.
1 A reconciliation from the IFRS consolidated income statement to the underlying earnings amounts presented above is provided in presentation of information on page 161.
2 Other underlying amounts includes net other income, share of underlying profit in associates and any underlying amounts attributable to non-controlling interests.
3 Other non-underlying amounts includes losses on disposal of subsidiaries, gains on sale of investment and development property, write-down on recognition of joint ventures and other assets classified as held for sale, impairment of goodwill, impairment of investment in associates, impairment of loan to associate, exceptional administration expenses, exceptional tax, and any non-underlying amounts attributable to non-controlling interests.
The IFRS loss for the year attributable to owners of intu properties plc increased by £818.7 million to £1,950.9 million, with the IFRS basic loss per share increasing by 60.8 pence. Underlying earnings decreased by £65.9 million to £127.2 million, with a corresponding reduction in underlying EPS of 4.9 pence. The key drivers of these variances are discussed below.
Table:
£m | Notes | 2019 | 2018 | Change
Net rental income | A | 401.6 | 450.5 | (48.9)
Administration expenses | B | (40.5) | (44.0) | 3.5
Net finance costs | C | (224.6) | (220.4) | (4.2)
Tax on underlying profit | D | (17.6) | (0.7) | (16.9)
Other underlying amounts2 |  | 8.3 | 7.7 | 0.6
Underlying earnings1 |  | 127.2 | 193.1 | (65.9)
Revaluation of investment and development property | E | (1,979.7) | (1,405.0) | (574.7)
Change in fair value of financial
instruments | F | (75.3) | 86.3 | (161.6)
Other finance charges – exceptional | G | (37.7) | (28.4) | (9.3)
Other non-underlying amounts3 |  | 14.6 | 21.8 | (7.2)
IFRS loss for the year attributable
to owners of intu properties plc1 |  | (1,950.9) | (1,132.2) | (818.7)
IFRS basic loss per share (pence) |  | (145.1)p | (84.3)p | (60.8)p
Underlying EPS (pence) |  | 9.5p | 14.4p | (4.9)p


Question: What is the administration expense in 2019?
Answer: 40.5
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: average annual rent per square foot changed in 2005 from 2004 by what amount?
Answer: 0.23
Calculation: multiply(4.19, 3.96)
Disaggregation of Revenue
We generate revenue from the sale of services and sale of software for end-user software products provided through direct customer downloads and through the sale of these end-user software products via partners. The following table depicts the disaggregation of revenue (in thousands) according to revenue type and is consistent with how we evaluate our financial performance:
Revenue from Contracts with Customers:
Table:
 | Twelve months ended December 31, | 
 | 2019 | 2018
Services  | $59,545 | $64,476
Software and other   | 3,788 | 5,073
             Total revenue  | $63,333 | $69,549


Question: Which year was the software and other revenue higher?
Answer: 2018
Calculation: 5,073 > 3,788
The following table illustrates the classification of pre-payroll tax and social contribution stock-based compensation expense included in the consolidated statements of income for the years ended December 31, 2019, December 31, 2018 and December 31, 2017:
The fair value of the shares vested in 2019 was $114 million compared to $68 million for 2018 and $38 million for 2017.
Compensation cost, excluding payroll tax and social contribution, capitalized as part of inventory was $6 million as of December 31, 2019, compared to $6 million as of December 31, 2018 and $3 million as of December 31, 2017. As of December 31, 2019, there was $138 million of total unrecognized compensation cost related to the grant of unvested shares, which is expected to be recognized over a weighted average period of approximately 9 months.
The total deferred income tax benefit recognized in the consolidated statements of income related to unvested share-based compensation expense amounted to $9 million, $7 million and $3 million for the years ended December 31, 2019, 2018 and 2017, respectively.
Table:
 | December 31, 2019 | December 31, 2018 | December 31, 2017
Cost of sales | 22 | 23 | 12
Selling, general and administrative | 46 | 67 | 31
Research and development | 77 | 35 | 18
Total pre-payroll tax and social contribution compensation | 145 | 125 | 61


Question: What was the percentage increase / (decrease) in the Research and development from 2018 to 2019?
Answer: 120
Calculation: 77 / 35 - 1
NOTE 6—INTANGIBLE ASSETS, NET, AND GOODWILL
Intangible assets include patents, domain name and other intangibles purchased from GVR, including customer relationships, technology and a trademark. Certain patents were acquired from STI as a result of an asset contribution and were recorded at their carryover basis. The fair value of the patents remained substantially the same as their carrying value at the exchange date. In addition, we acquired other patents and the domain name www.resonant.com through the normal course of business. Intangibles acquired as part of the purchase of GVR were initially recorded at their fair value. Issued patents are amortized over their approximate useful life of 17 years, or 20 years in the case of new patents, once they are approved by their respective regulatory agency. For the patents acquired from STI, we are amortizing them over the remaining useful life of 1 to 11 years as of December 31, 2019. The domain name is amortized over the approximate useful life of 10 years. The other intangibles acquired from GVR are amortized over their useful life of three to five years.
Intangible assets, net, consists of the following as of December 31, 2019 and 2018:
(1) Includes the impact of foreign currency translation. The total impact at December 31, 2018 was $1,000 and there was no impact at December 31,
2019.
During the year ended December 31, 2019 and 2018, we wrote-off $145,000 and $96,000, respectively, of patents we are no longer pursuing. The write-offs are included in research and development expense. There were no impairments to any other intangibles.
Table:
 | 2019 | 2018
Cost: |  | 
Patents | $1,801,000 | $1,507,000
Domain name | 22,000 | 22,000
Client Base (1) | 144,000 | 142,000
Trademark (1) | 18,000 | 17,000
Backlog (1) | 13,000 | 13,000
Technology | 77,000 | 77,000
 | 2,075,000 | 1,778,000
Less: Accumulated amortization | (499,000) | (404,000)
Intangible assets, net | $ 1,576,000 | $ 1,374,000


Question: What are the components recorded under cost for intangible assets?
Answer: Patents, Domain name, Client Base, Trademark, Backlog, Technology
Note 11: Share-Based Compensation
Total share-based compensation expense related to the Company's stock options, RSUs, stock grant awards and ESPP were recorded within the Consolidated Statements of Operations and Comprehensive Income as follows (in millions):
(1) Recognition of related income tax benefits are the result of the adoption of ASU 2016-09 during the first quarter of 2017 through a cumulative effect adjustment of $68.1 million recorded as a credit to retained earnings as of January 1, 2017. Tax benefit is calculated using the federal statutory rate of 21% during the years ended December 31, 2019 and December 31, 2018, and 35% for the year ended December 31, 2017.
At December 31, 2019, total unrecognized share-based compensation expense, net of estimated forfeitures, related to non-vested RSUs with service, performance and market conditions was $74.9 million, which is expected to be recognized over a weighted-average period of 1.3 years. The total intrinsic value of stock options exercised during the year ended December 31, 2019 was $3.9 million.
The Company received cash of $1.7 million and $26.2 million from the exercise of stock options and the issuance of shares under the ESPP, respectively. Upon option exercise, vesting of RSUs, stock grant awards, or completion of a purchase under the ESPP, the Company issues new shares of common stock.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Cost of revenue | $10.6 | $7.0 | $6.0
Research and development | 17.0 | 14.3 | 12.5
Selling and marketing | 14.8 | 14.1 | 11.7
General and administrative | 37.0 | 42.9 | 39.6
Share-based compensation expense | 79.4 | 78.3 | 69.8
Related income tax benefits at federal rate (1) | (16.7) | (16.4) | (24.4)
Share-based compensation expense, net of taxes | $62.7 | $61.9 | $45.4


Question: How much cash was recieved from the exercise of stock options and the issuance of shares under the ESPP, respectively?
Answer: $1.7 million, $26.2 million
Note 13 – Income Taxes
A summary of the components of the expense (benefit) for income taxes for the years ended December 31, 2019, 2018 and 2017 is as follows:
Table:
(In thousands) | 2019 | 2018 | 2017
Current |  |  | 
Federal | $(518) | $(8,001) | $466
State | (1,065) | (476) | (150)
International | (282) | 11,705 | 6,458
Total Current | (1,865) | 3,228 | 6,774
Deferred |  |  | 
Federal | 24,801 | (14,448) | 8,024
State | 5,815 | (3,390) | 1,882
International | (546) | 581 | 4,167
Total Deferred | 30,070 | (17,257) | 14,073
Total Income Tax Expense (Benefit) | $28,205 | $(14,029) | $20,847


Question: What was the expense (benefit) of the current Federal component in 2019?
Answer: $(518)
Note 21 Debt due within one year
(1) Includes commercial paper of $1,502 million in U.S. dollars ($1,951 million in Canadian dollars) and $2,314 million in U.S. dollars ($3,156 million in Canadian dollars) as at December 31, 2019 and December 31, 2018, respectively, which were issued under our U.S. commercial paper program and have been hedged for foreign currency fluctuations through forward currency contracts. See Note 26, Financial and capital management, for additional details.
(2) Included in long-term debt due within one year is the current portion of lease liabilities of $775 million as at December 31, 2019 and the current portion of finance leases of $466 million as at December 31, 2018.
Table:
FOR THE YEAR ENDED DECEMBER 31 | NOTE | WEIGHTED AVERAGE INTEREST RATE AT DECEMBER 31, 2019 | 2019 | 2018
Notes payable (1) | 26 | 2.03% | 1,994 | 3,201
Loans secured by trade receivables | 26 | 2.71% | 1,050 | 919
Long-term debt due within one year (2) | 22 | 4.77% | 837 | 525
Total debt due within one year |  |  | 3,881 | 4,645


Question: What is the percentage change in the total debt due within one year in 2019?
Answer: -16.45
Calculation: (3,881-4,645)/4,645
Note: 1 See “Alternative performance measures” on page 231 for further details and reconciliations to the respective closest equivalent GAAP measure.
The Group’s adjusted effective tax rate for its controlled businesses for the year ended 31 March 2019 was 24.4% compared to 20.6% for the last financial year. The higher rate in the current year is primarily due to a change in the mix of the Group’s profit, driven by the financing for the Liberty Global transaction. The tax rate in the prior year also reflected the consequences of closing tax audits in Germany and Romania. We expect the Group’s adjusted effective tax rate to remain in the low-mid twenties range for the medium term.
The Group’s adjusted effective tax rate for both years does not include the following items: the derecognition of a deferred tax asset in Spain of €1,166 million (2018: €nil); deferred tax on the use of Luxembourg losses of €320 million (2018: €304 million); an increase in the deferred tax asset of €488 million (2018: €330 million) arising from a revaluation of investments based upon the local GAAP financial statements and tax returns.
The Group’s adjusted effective tax rate for the year ended 31 March 2018 does not include the recognition of a deferred tax asset of €1,603 million due to higher interest rates; and a tax charge in respect of capital gains on the transfer of share in Vodafone Kenya Limited to the Vodacom Group of €110 million.
Table:
Taxation |  | 
 | 2019 €m | 2018 €m
Income tax (expense)/credit: | (1,496) | 879
Tax on adjustments to derive adjusted profit before tax | (206) | (188)
Deferred tax following revaluation of investments in Luxembourg | (488) | (330)
Luxembourg deferred tax asset recognised | – | (1,603)
Deferred tax on use of Luxembourg losses in the year | 320 | 304
Tax on the Safaricom transaction | – | 110
Derecognition of a deferred tax asset in Spain | 1,166 | –
Adjusted income tax expense for calculating adjusted tax rate1 | (704) | (828)
Loss)/profit before tax | (2,613) | 3,878
Adjustments to derive adjusted profit before tax (see earnings per share) | 5,149 | 530
Adjusted profit before tax1 | 2,536 | 4,408
Share of adjusted results in associates and joint ventures | 348 | (389)
Adjusted profit before tax for calculating adjusted effective tax rate | 2,884 | 4,019
Adjusted effective tax rate1 | 24.4% | 20.6%


Question: What was the reason for a higher adjusted effective tax rate in 2019?
Answer: change in the mix of the Group’s profit, driven by the financing for the Liberty Global transaction