hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
A condensed summary of the Company’s financial information for equity-accounted investments (20% to 52%-owned) shown on a 100% basis (excluding the impact from purchase price adjustments arising from the acquisition of Joint Ventures) are as follows:
The results included for TIL are until its consolidation on November 27, 2017. The results included for Altera are from the date of deconsolidation on September 25, 2017 to the sale of Teekay's remaining interests on May 8, 2019.
For the year ended December 31, 2019, the Company recorded equity loss of $14.5 million (2018 – income of $61.1 million, and 2017 – loss of $37.3 million).
The equity loss in 2019 was primarily comprised of the write-down and loss on sale of Teekay's investment in Altera and the Company’s share of net loss from the Bahrain LNG Joint Venture; offset by equity income in the Yamal LNG Joint Venture, the RasGas III Joint Venture, the MALT Joint Venture, the Pan Union Joint Venture and the Angola Joint Venture.
For the year ended December 31, 2019, equity loss included $12.9 million related to the Company’s share of unrealized losses on interest rate swaps in the equity-accounted investments (2018 – gains of $17.6 million and 2017 – gains of $7.7 million).
Table:
 | As at December 31, | 
 | 2019 | 2018
 | $ | $
Cash and restricted cash | 379,085 | 568,843
Other assets – current | 148,663 | 412,388
Vessels and equipment, including vessels related to finance leases and advances on  Vessels and equipment, including vessels related to finance leases and advances on newbuilding contracts | 3,123,377 | 6,615,077
Net investment in direct financing leases | 4,469,861 | 3,000,927
Other assets – non-current | 169,925 | 1,957,271
Current portion of long-term debt and obligations related to finance leases | 563,776 | 1,106,812
Other liabilities – current | 189,165 | 563,862
Long-term debt and obligations related to finance leases | 5,156,307 | 6,882,426
Other liabilities – non-current | 243,301 | 478,311


Question: In which year was cash and restricted cash less than 400,000 million?
Answer: 2019
Calculation: locate and analyze cash and restricted cash in row 4
Commitments and Significant Contractual Obligations
The following table summarizes our contractual obligations and commercial commitments at December 27, 2019:
(1) Interest on our various outstanding debt instruments is included in the above table, except for our Term Loan and ABL, which have floating interest rates. At December 27, 2019, we had borrowings of $238.1 million under our Term Loan and zero under our ABL. During the fiscal year ended December 27, 2019, the weighted average interest rate on our Term Loan was approximately 5.8% and we incurred interest expense of approximately $13.9 million. During the fiscal year ended December 27, 2019, the weighted average interest rate on our ABL borrowings was approximately 3.7% and we incurred interest expense of approximately $1.6 million. See Note 9 “Debt Obligations” to our consolidated financial statements for further information on our debt instruments.
(2) The table above excludes cash to be paid for income taxes, $14.7 million of total contingent earn-out liabilities related to certain acquisitions as of December 27, 2019 and approximately $5.3 million of lease payments related to long-term leases for several vehicles and a distribution and processing facility that do not commence until fiscal 2020.
We had outstanding letters of credit of approximately $16.6 million and $15.8 million at December 27, 2019 and December 28, 2018, respectively. Substantially all of our assets are pledged as collateral to secure our borrowings under our credit facilities.
Table:
 |  |  | Payments Due by Period (1, 2) |  | 
 | Total  | Less than One Year | 1-3 Years | 4-5 Years | Thereafter
 |  |  | (In thousands) |  | 
Inventory purchase commitments | $53,413 | $53,413 | $— | $— | $—
Indebtedness | $406,644 | $2,993 | $244,151 | $159,500 | $—
Finance lease obligations  | $4,597 | $880 | $1,715 | $1,392 | $610
Pension exit liabilities  | $2,169 | $149 | $329 | $375 | $1,316
Long-term operating leases  | $197,359 | $25,662 | $43,130 | $30,080 | $98,487
Total  | $664,182 | $83,097 | $289,325 | $191,347 | $100,413


Question: At December 27, 2019, what is the amount of borrowings under our Term Loan?
Answer: $238.1 million
Disaggregation of revenue
The following table provides information about disaggregated revenue by primary geographical markets:
The Company derived over 90%, and approximately 88% and 84% of subscription revenues from RingCentral Office product for the years ended December 31, 2019, 2018 and 2017, respectively
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Primary geographical markets |  |  | 
North America | 93% | 95% | 96%
Others | 7% | 5% | 4%
Total revenues | 100% | 100% | 100%


Question: What are the respective percentage of subscription revenue derived in the years ended December 2017 and 2018?
Answer: 84%, 88%
Sales and Distribution
We maintain a strong local presence in each of the geographic regions in which we operate. Our net sales by geographic region(1) as a percentage of our total net sales were as follows:
(1) Net sales to external customers are attributed to individual countries based on the legal entity that records the sale.
We sell our products into approximately 150 countries primarily through direct selling efforts to manufacturers. In fiscal 2019, our direct sales represented approximately 80% of total net sales. We also sell our products indirectly via third-party distributors.
We maintain distribution centers around the world. Products are generally delivered to the distribution centers by our manufacturing facilities and then subsequently delivered to the customer. In some instances, however, products are delivered directly from our manufacturing facility to the customer. Our global coverage positions us near our customers’ locations and allows us to assist them in consolidating their supply base and lowering their production costs. We contract with a wide range of transport providers to deliver our products globally via road, rail, sea, and air. We believe our balanced sales distribution lowers our exposure to any particular geography and improves our financial profile.
Table:
 |  | Fiscal | 
 | 2019 | 2018 | 2017
Europe/Middle East/Africa (“EMEA”) | 36 % | 38 % | 36 %
Asia–Pacific | 33 | 34 | 35
Americas | 31 | 28 | 29
Total | 100 % | 100 % | 100 %


Question: What are the net sales by geographic region in the table presented as a percentage of?
Answer: total net sales
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
In February 2018, Advanced Energy acquired Trek Holding Co., LTD ("Trek"), a privately held company with operations in Tokyo, Japan and Lockport, New York, for $6.1 million, net of cash acquired. Trek has a 95% ownership interest in its U.S. subsidiary which is also its primary operation.
The components of the fair value of the total consideration transferred for our 2018 acquisitions are as follows:
Table:
 | Trek | Electrostatic Product Line | LumaSense | Total
Cash paid for acquisition | $11,723 | $3,000 | $94,946 | $ 109,669
Less cash acquired | (5,651) | — | (10,262) | (15,913)
Total purchase price | $6,072 | $3,000 | $84,684 | $ 93,756


Question: What is the sum of the two highest total purchase prices?
Answer: 90756
Calculation: $84,684+$6,072
Global Services
Adjusteda revenue £4,735m
£4,735m
Adjusteda operating profit
£135m
Global Services operates in a global market that continues to experience high levels of change driven by both rapid technology innovation and a dynamic competitive landscape. Customers’ demands continue to evolve towards more flexible, on-demand models and new cloud-based and software-defined networking solutions. We continue to execute our Digital Global Services transformation programme to focus our business, standardise our operations, transform our underlying infrastructure, and provide innovative solutions to address the changing demands of our customers. We are focused on around 800 multinational companies and financial institutions served by three global industry verticals.
Adjusteda revenue for the year was down 6%, in line with our strategy to de-emphasise low margin business and including the impact of divestments. This includes a £35m negative impact from foreign exchange movements, primarily reflecting lower IP Exchange volumes and equipment sales.
Adjusteda operating costs for the year were down 8% mainly reflecting the decline in IP Exchange volumes and equipment sales and lower labour costs from our ongoing restructuring programme. Adjusteda EBITDA for the year was up £71m reflecting the reduction in operating costs and certain one-offs, more than offsetting the impact of lower revenue.
Depreciation and amortisation was down 13% for the year due to closure of certain projects in the prior year.
Capital expenditure was down 12% for the year reflecting ongoing rationalisation and our strategy to become a more asset light business. Normalised free cash flowb for the year improved by 151% to £296m, reflecting higher EBITDA, lower capital expenditure and improved working capital.
Total order intake was £3.3bn, down 15% year on year continuing to reflect a shift in customer behaviour, including shorter contract lengths and greater prevalence of usage-based terms.
a Adjusted measures exclude specific items, as explained in the Additional Information on page 185. b Free cash flow after net interest paid, before pension deficit payments (including the cash tax benefit of pension deficit payments) and specific items. c Openreach comparatives have been re-presented to reflect the transfer of Northern Ireland Networks from Enterprise to Openreach.
Table:
 | 2019 (IFRS 15) | 2018 (IAS 18) | Change | 
Year to 31 March | £m | £m | £m | %
Adjusted a revenue | 4,735 | 5,013 | (278) | (6)
Adjusted a operating costs | 4,230 | 4,579 | (349) | (8)
Adjusted a EBITDA | 505 | 434 | 71 | 16
Depreciation & amortisation | 370 | 424 | (54) | (13)
Adjusted a operating profit | 135 | 10 | 125 | 1,250
Capital expenditure | 245 | 278 | (33) | (12)
Normalised free cash flow b | 296 | 118 | 178 | 151


Question: What is the Capital expenditure for 2019?
Answer: 245
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 ASC 605 and ASC 606 in fiscal year 2019?
Answer: 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., Under ASC Topic 606, unbilled deferred revenue is not included as a receivable or deferred revenue on our Consolidated Balance Sheet.
Other Assets
Other assets consist of the following (in thousands):
The Company’s other assets includes a strategic equity investment in a privately-held company. The strategic investment is a non-marketable equity security, in which the Company does not have a controlling interest or the ability to exert significant influence. This investment does not have a readily determinable market value. The Company records this strategic investment at cost less impairment and adjusts cost for subsequent observable price changes. During the years ended July 31, 2019 and 2018, there were no changes in the investment’s carrying value of $10.7 million.
Table:
 | July 31, 2019  | July 31, 2018
Prepaid expenses | $2,640 | $2,476
Contract costs | 23,375 | —
Deferred costs | 8,867 | 9,377
Strategic investments | 10,672 | 10,672
Other assets | $45,554 | 22,525


Question: What was the Prepaid expenses in 2019 and 2018 respectively?
Answer: $2,640, $2,476
A.3.10 Reconciliation to Consolidated Financial Statements
The negative swing in Corporate items was mainly due to large positive effects in fiscal 2018 – the gain of € 900 million resulting from the transfer of Siemens’ shares in Atos SE to Siemens Pension- Trust e. V. and the gain of € 655 million from the sale of OSRAM Licht AG shares. These effects substantially outweighed a positive result in fiscal 2019 from the measurement of a major asset retirement obligation, which was previously reported in Centrally managed portfolio activities. Severance charges within Corporate items were € 99 million (€ 159 million in fiscal 2018).
Table:
 |  | Fiscal year
(in millions of €) | 2019 | 2018
Real Estate Services | 145 | 140
Corporate items | (562) | 631
Centrally carried pension expense | (264) | (423)
Amortization of intangible assets acquired in business combinations | (1,133) | (1,164)
Eliminations, Corporate Treasury and other reconciling items | (215) | (318)
Reconciliation to Consolidated financial Statements | (2,028) | (1,135)


Question: What was the Reconciliation to Consolidated financial Statements in 2019?
Answer: (2,028)
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: what was the increase in payroll and related withholdings in 2014 , in millions?
Answer: 6267
Calculation: subtract(57110, 50843)
Deferred commissions
As a result of our adoption of ASC 606, we capitalize sales commissions that are incremental direct costs of obtaining customer contracts for which revenue is not immediately recognized. We then amortize capitalized commissions based on the transfer of goods or services to which they relate. The following tables summarize the activity related to deferred commissions and their balances as reported in our consolidated balance sheets (in millions):
Table:
 |  | Year Ended
 | April 26, 2019 | April 27, 2018
Other current assets | $ 75 | $ 66
Other non-current assets | 97 | 71
Total deferred commissions | $ 172 | $ 137


Question: What does the table show?
Answer: summarize the activity related to deferred commissions and their balances as reported in our consolidated balance sheets
For the full year 2019, our ADG revenues increased 1.4% compared to the previous period. The increase was primarily due to improved average selling prices of approximately 9%, which was entirely due to a better product mix, and partially offset by a decrease in volumes by approximately 8%.
AMS revenues grew 4.6%, mainly due to the double-digits growth in Imaging. The increase was due to higher average selling prices of approximately 12%, as a result of a better product mix, and was partially offset by lower volumes of approximately 7%.
MDG revenues were down by 10.3%, mainly due to Microcontrollers. The decrease was due to lower volumes of approximately 10% while average selling prices remained substantially flat.
In 2018, all product groups registered double-digit revenue increase. Our ADG revenues increased 16.2% for the full year 2018 compared to the full year 2017 on growth in both Power Discrete and Automotive. The increase was primarily due to improved average selling prices of approximately 21% and volumes decreased by approximately 5%. The increase in average selling prices was entirely due to improved product mix, while selling prices remained substantially flat.
AMS revenues grew 19.9%, mainly on the strong increase in Imaging. The increase was due to higher volumes of approximately 12% and higher average selling prices of approximately 8%, which was entirely due to improved product mix of approximately 13%, while selling prices decreased by approximately 5%.
MDG revenues were up by 11.1%, with Digital and Microcontrollers & Memories equally contributing. The increase was primarily due to higher average selling prices of approximately 11%, while volumes remained substantially flat. The increase in average selling prices was due to a better product mix of approximately 13%, while the selling prices effect was negative of approximately 2%.
Table:
 | Year Ended | Year Ended | Year Ended | % Variation | % Variation
2019 vs 2018 2018 vs 2017 | 2019 | 2018 | 2017 | 2019 vs 2018 | 2018 vs 2017
 | (In millions) | (In millions) | (In millions) |  | 
Automotive and Discrete Group (ADG) | $3,606 | $3,556 | $3,059 | 1.4% | 16.2%
Analog MEMS and Sensors Group (AMS) | 3,299 | 3,154 | 2,630 | 4.6 | 19.9
Microcontrollers and Digital ICs Group (MDG) | 2,638 | 2,940 | 2,646 | (10.3) | 11.1
Others | 13 | 14 | 12 | — | —
Total consolidated net revenues | $9,556 | $9,664 | $8,347 | (1.1)% | 15.8%


Question: In 2019, what was the reason for fall in MDG revenues?
Answer: MDG revenues were down by 10.3%, mainly due to Microcontrollers. The decrease was due to lower volumes of approximately 10% while average selling prices remained substantially flat.
Australian Food’s VOC NPS (including Online) was up 3 pts on the prior year with Store‐controllable VOC steady on the prior year. Store‐controllable VOC improved on Q3’19 where scores were impacted by flood and drought effects on fruit and vegetable prices impacting quality and availability. Fruit & Vegetables and Availability scores improved 1 pt to 78% compared to June 2018, and 5 pts and 2 pts respectively vs. Q3’19. Team Attitude remained stable (89%) compared to June 2018.
In F20, Store‐controllable VOC will be reduced from seven metrics to five, removing Ease of Movement and Correct Price Tickets to simplify the focus for stores on the areas that offer the most opportunity for improvement.
Sales increased by 5.3% to $39.6 billion or 3.3% on a normalised basis. Comparable sales increased by 3.1% for the year with transaction growth of 1.8% and items per basket of 1.7% contributing to comparable item growth of 3.5%.
Despite some challenges during the year, sales momentum improved in H2 with strong growth across a number of Fresh categories. Sales in the second half also benefitted from successful campaigns including Disney Words and Earn & Learn. In Q4, comparable sales increased by 3.6% with comparable transaction growth of 1.4%. Comparable items per basket increased by 1.2%.
Metro continued to grow strongly with further refinement to price, promotional optimisation and range curation. An extra‐small store format was successfully launched in Kirribilli and new stores opened in Rozelle and Kings Cross. At the end of the financial year, 43 Metro‐branded stores and 16 small Woolworths Supermarkets were managed by the Metro team.
In WooliesX, Online VOC scores improved 2 pts to 81% at the end of June, with improvements in Delivery & Pick up and Ease of Website Navigation. Online sales grew 31% (normalised) to $1.4 billion driven by expanded offerings such as Same day, Delivery Now, Drive thru and Drive up.
Australian Food sales per square metre was $17,163 with normalised growth of 2.0% on the prior year. During the year, 24 new stores were opened (21 supermarkets and three Metros), eight were closed and 68 Renewals completed. At year‐end, there were 1,024 Woolworths Supermarkets and Metro stores.
Average prices declined 0.4% for the year, with modest inflation of 0.5% in the fourth quarter as a result of increases in a number of Fresh categories impacted by the drought including Fruit & Vegetables, Meat and Bakery.
Table:
 | F19 | F18 |  | CHANGE
$ MILLION | 53 WEEKS | 52 WEEKS | CHANGE | NORMALISED
Sales | 39,568 | 37,589 | 5.3% | 3.3%
EBITDA | 2,613 | 2,430 | 7.5% | 6.1%
Depreciation and amortisation | (756) | (673) | 12.3% | 12.3%
EBIT | 1,857 | 1,757 | 5.7% | 3.8%
Gross margin (%) | 28.7 | 29.0 | (24) bps | (24) bps
Cost of doing business (%) | 24.0 | 24.3 | (27) bps | (26) bps
EBIT to sales (%) | 4.7 | 4.7 | 2 bps | 2 bps
Sales per square metre ($) | 17,163 | 16,528 | 3.8% | 2.0%
Funds employed | 1,468 | 1,215 | 20.9% | 
ROFE (%) | 140.2 | 170.7 | (30.6) pts | (33.2) pts


Question: What is the percentage change for Sales during this financial year?
Answer: 5.3%