hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Our revenues and operating results are significantly affected by the timing, number and breadth of our theatrical releases and their budgets, the timing of television syndication agreements, and our amortization policy for the first 12 months of commercial exploitation for a film. The timing of releases is determined based on several factors. A significant portion of the films we distribute are delivered to Indian theaters at times when theater attendance has traditionally been highest, including school holidays, national holidays and the festivals. This timing of releases also takes into account competitor film release dates, major cricket events in India and film production schedules. Significant holidays and festivals, such as Diwali, Eid and Christmas, occur during July to December each year, and the Indian Premier League cricket season generally occurs during April and May of each year. The Tamil New Year, called Pongal, falls in January each year making the quarter ending March an important one for Tamil releases.
Our quarterly results can vary from one period to the next, and the results of one quarter are not necessarily indicative of results for the next or any future quarter. Our revenue and operating results are therefore seasonal in nature due to the impact on income of the timing of new releases as well as timing and quantum of catalogue revenues.
Table:
 |  | Three Months Ended |  | 
 | June 30, 2018 | September 30, 2018 | December 31, 2018 | March 31, 2019
 |  | (in thousands) |  | 
Revenue | 60,212 | 63,425 | 76,744 | 69,745
Adjustment towards significant financing component | 6,410 | 8,837 | 9,917 | 9,303
Gross Revenue | 66,622 | 72,262 | 86,661 | 79,048


Question: What is the percentage increase / (decrease) in the Gross Revenue from Three Months Ended  December 2018 to March 2019?
Answer: -8.78
Calculation: 79,048 / 86,661 - 1
Liquidity and Capital Resources
As of December 31, 2019, we had cash and cash equivalents of $92.7 million, restricted cash of $0.4 million, and net accounts receivable of $50.4 million. Additionally, as of December 31, 2019, our working capital was $115.2 million.
Our primary uses of cash are to fund operating expenses, purchases of inventory, property and equipment, intangible assets, and from time to time, the acquisition of businesses. We also use cash to pay down outstanding debt. Our cash and cash equivalents are impacted by the timing of when we pay expenses as reflected in the change in our outstanding accounts payable and accrued expenses.
Cash used to fund operating expenses in our consolidated statements of cash flows excludes the impact of non-cash items such as stock-based compensation, amortization and depreciation of acquired intangible assets, leased right-of-use assets and property and equipment, and impairment of intangible assets and long-lived assets. Cash used to fund acquisitions of businesses and other capital purchases is included in investing activities in our consolidated statements of cash flows.
Our primary sources of cash are cash receipts on accounts receivable from our shipment of products to distributors and direct customers. Aside from the amounts billed to our customers, net cash collections of accounts receivable are impacted by the efficiency of our cash collections process, which can vary from period to period depending on the payment cycles of our major distributor customers, and relative linearity of shipments period-to-period.
Our credit agreement, under which we entered into a term loan to partially fund our acquisition of Exar, permits us to request incremental loans in an aggregate principal amount not to exceed the sum of $160.0 million (subject to adjustments for any voluntary prepayments), plus an unlimited amount that is subject to pro forma compliance with certain secured leverage ratio and total leverage ratio tests. We have not requested any incremental loans to date.
Following is a summary of our working capital, cash and cash equivalents, and restricted cash for the periods indicated:
Table:
 | December 31, | 
 | 2019 | 2018
 | (in thousands) | 
Working capital | $115,208 | 110,044
Cash and cash equivalents | $92,708 | $73,142
Short-term restricted cash | 349 | 645
Long-term restricted cash | 60 | 404
Total cash and cash equivalents, restricted cash and investments | $93,117 | 74,191


Question: What is the average Cash and cash equivalents for December 31, 2019 to 2018?
Answer: 82925
Calculation: (92,708+73,142) / 2
GreenSky, Inc.
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS — (Continued)
(United States Dollars in thousands, except per share data, unless otherwise stated)
Note 4. Loan Receivables Held for Sale
The following table summarizes the activity in the balance of loan receivables held for sale, net at lower of cost or fair value during the periods indicated.
(1) Includes accrued interest and fees, recoveries of previously charged-off loan receivables held for sale, as well as proceeds from transferring our rights to Charged-Off Receivables attributable to loan receivables held for sale. We retain servicing arrangements on sold loan receivables with the same terms and conditions as loans that are originated by our Bank Partners. Income from loan receivables held for sale activities is recorded within interest income and other gains (losses), net in the Consolidated Statements of Operations. We sold loan receivables held for sale to certain Bank Partners on the following dates during the years ended December 31:
(2) We temporarily hold certain loan receivables, which are originated by a Bank Partner, while non-originating Bank Partner eligibility is being determined. Once we determine that a loan receivable meets the investment requirements of an eligible Bank Partner, we transfer the loan receivable to the Bank Partner at cost plus any accrued interest. The reported amount also includes loan receivables that have been placed on non-accrual and non-payment status while we investigate consumer inquiries.
(3) We received recovery payments of $50, $57 and $238 during the years ended December 31, 2019, 2018 and 2017, respectively. Recoveries of principal and finance charges and fees on previously written off loan receivables held for sale are recognized on a collected basis as other gains and interest income, respectively, in the Consolidated Statements of Operations. Separately, during the years ended December 31, 2019, 2018, and 2017, write offs and other were reduced by $312, $431, and $406, respectively, related to cash proceeds received from transferring our rights to Charged-Off Receivables attributable to loan receivables held for sale. The cash proceeds received were recorded within other gains (losses), net in the Consolidated Statements of Operations.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Beginning balance | $2,876 | $73,606 | $41,268
Additions | 157,928 | 93,240 | 134,659
Proceeds from sales and borrower payments(1) | (104,858) | (161,009) | (93,044)
Loss on sale | — | — | (500)
Increase in valuation allowance | (1,289) | (92) | (584)
Transfers(2) | 251 | 22 | (5,017)
Write offs and other(3) | (2,982) | (2,891) | (3,176)
Ending balance | $51,926 | $2,876 | $73,606


Question: How many years did additions exceed $100,000 thousand?
Answer: 2
Calculation: 2019##2017
In the fourth quarter of 2019, we recognized other income, net of expenses, of $54 million, increasing from a negative $2 million in the prior quarter and from an income of $16 million in the year-ago quarter, reflecting higher R&D grants in Italy associated with the IPCEI program.
Other income and expenses, net
Table:
 |  | Three Months Ended | 
 | December 31, 2019 | September 29,2019 | December 31, 2018
 |  | (Unaudited, in millions) | 
Research and development funding | $68 | $14 | $19
Phase-out and start-up costs | (16) | (15) | (1)
Exchange gain (loss), net | 1 | (1) | —
Patent costs | (1) | (1) | (1)
Gain on sale of non-current assets | 1 | — | 1
Other, net | 1 | 1 | (2)
Other income and expenses, net | $54 | $(2) | $16
As percentage of net revenues | 2.0% | (0.1)% | 0.6%


Question: How much was the Other income and expenses, net in the fourth quarter of 2019?
Answer: $54 million
Research and development
Research and development expense consists primarily of salaries and other personnel-related costs; the cost of products, materials, and outside services used in our R&D activities; and depreciation and amortization expense associated with R&D specific facilities and equipment. We maintain a number of programs and activities to improve our technology and processes in order to enhance the performance and reduce the costs of our solar modules.
The following table shows research and development expense for the years ended December 31, 2019, 2018, and 2017:
Research and development expense in 2019 increased compared to 2018 primarily due to increased material and module testing costs and higher employee compensation expense.
Table:
 |  | Year Ended |  |  | Change |  | 
(Dollars in thousands) | 2019 | 2018 | 2017 | 2019 over 2018 |  | 2018 over 2017 | 
Research and development | $96,611 | $84,472 | $88,573 | $12,139 | 14% | $(4,101) | (5)%
% of net sales . | 3.2% | 3.8% | 3.0% |  |  |  | 


Question: What is the amount of net sales derived in 2017?
Answer: 2952433.33
Calculation: 88,573 / 3.0%
b) Transactions with Golar Power and affiliates:
Net revenues: The transactions with Golar Power and its affiliates for the twelve months ended December 31, 2019, 2018 and 2017 consisted of the following:
(i) Debt guarantee compensation - In connection with the closing of the Golar Power and Stonepeak transaction, Golar Power entered into agreements to compensate Golar in relation to certain debt guarantees (as further described under the subheading "Guarantees and other") relating to Golar Power and subsidiaries.
(ii) Balances due to Golar Power and affiliates - Receivables and payables with Golar Power and its subsidiaries are comprised primarily of unpaid management fees, advisory and administrative services. In addition, certain receivables and payables arise when we pay an invoice on behalf of a related party and vice versa. Receivables and payables are generally settled quarterly in arrears. Balances owing to or due from Golar Power and its subsidiaries are unsecured, interest-free and intended to be settled in the ordinary course of business. In December 2019, we loaned $7.0 million to Golar Power, with interest of LIBOR plus 5.0%. The loan was fully repaid, including interest, in December 2019.
Table:
(in thousands of $) | 2019 | 2018 | 2017
Management and administrative services revenue | 5,904 | 6,167 | 5,711
Ship management fees income | 1,210 | 1,400 | 824
Debt guarantee compensation (i) | 693 | 861 | 775
Other (ii) | (2) | (247) | 135
Total | 7,805 | 8,181 | 7,445


Question: What was the change in ship management fees income from 2017 to 2018?
Answer: 576
Calculation: 1,400 - 824
Net periodic benefit expense for our post-retirement benefit plans includes the following components:
We report service costs for our Combined Pension Plan and post-retirement benefit plans in cost of services and products and selling, general and administrative expenses in our consolidated statements of operations for the years ended December 31, 2019, 2018 and 2017. Additionally, a portion of the service cost is also allocated to certain assets under construction, which are capitalized and reflected as part of property, plant and equipment in our consolidated balance sheets. The remaining components of net periodic benefit expense (income) are reported in other income, net in our consolidated statements of operations. As a result of ongoing efforts to reduce our workforce, we recognized a one-time charge in 2019 of $6 million and in 2018 of $15 million for special termination benefit enhancements paid to certain eligible employees upon voluntary retirement.
Table:
 | Post-Retirement Plans |  | 
 | Years Ended December 31, |  | 
 | 2019 | 2018 | 2017
 | (Dollars in milions) |  | 
Service cost | $15 | 18 | 18
Interest cost | 110 | 97 | 100
Expected return on plan assets | (1) | (1) | (2)
Recognition of prior service cost | 16 | 20 | 20
Net periodic post-retirement benefit expense | $140 | 134 | 136


Question: Where are the remaining components of net periodic benefit expense (income) reported?
Answer: in other income, net in our consolidated statements of operations
Net Cash Provided By Operating Activities and Free Cash Flow
The following table presents a reconciliation of net cash provided by operating activities to free cash flow (in thousands, except for percentages):
Net cash provided by operating activities for the twelve months ended December 31, 2019 was $115.5 million as compared to $90.3 million during the same period in 2018. The increase was primarily due to improved profitability, improved collections, and other working capital changes in 2019 when compared to the same period in 2018.
Free cash flow for the twelve months ended December 31, 2019 was $72.8 million, resulting in a free cash flow margin of 12.6%, as compared to free cash flow of $49.8 million and a free cash flow margin of 9.3% for the same period in 2018. The increase was primarily due to both improved profitability and collections, and is partially offset by cash paid for interest on our convertible notes of $17.4 million in the twelve months ended December 31, 2019. Refer to the section titled “Liquidity and Capital Resources” for additional information on the convertible notes.
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Reconciliation of free cash flow: |  |  | 
Net cash provided by operating activities | $115,549 | $90,253 | $67,510
Capital expenditures | (18,034) | (14,895) | (7,100)
Capitalized software costs | (24,668) | (25,515) | (20,571)
Free cash flow | $72,847 | $49,843 | $39,839
Free cash flow margin | 12.6% | 9.3% | 8.3%


Question: What was the reason behind the increase of net cash provided by operating activities between 2018 and 2019?
Answer: The increase was primarily due to improved profitability, improved collections, and other working capital changes
stock performance graph : the graph below shows the cumulative total shareholder return assuming the investment of $ 100 , on december 31 , 2011 , and the reinvestment of dividends thereafter , if any , in the company 2019s common stock versus the standard and poor 2019s s&p 500 retail index ( 201cs&p 500 retail index 201d ) and the standard and poor 2019s s&p 500 index ( 201cs&p 500 201d ) . .

Table:
company/index | december 31 , 2011 | december 31 , 2012 | december 31 , 2013 | december 31 , 2014 | december 31 , 2015 | december 31 , 2016
o 2019reilly automotive inc . | $ 100 | $ 112 | $ 161 | $ 241 | $ 317 | $ 348
s&p 500 retail index | 100 | 125 | 180 | 197 | 245 | 257
s&p 500 | $ 100 | $ 113 | $ 147 | $ 164 | $ 163 | $ 178
.

Question: what is the total return generated if $ 10 million are invested in s&p500 in 2011 and sold in 2013 , in millions?
Answer: 4.7
Calculation: subtract(147, 100), divide(#0, 100), multiply(#1, 10)
Disaggregated Revenue
The Company has disaggregated revenue from contracts with customers into categories which depict how the nature, amount, timing and uncertainty of revenue and cash flows are affected by economic factors. Consequently, the disaggregation below is based on contract type.
Since the terms within these contract types are generally standard in nature, the Company does not believe that further disaggregation would result in increased insight into the economic factors impacting revenue and cash flows.
The following table shows the Company's shipping revenues disaggregated by nature of the charter arrangement for the years ended December 31, 2019 and 2018:
(1) Voyage charter revenues include approximately $10,152 and $7,600 of revenue related to short-term time charter contracts for the years ended December 31, 2019 and 2018, respectively.
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Time and bareboat charter revenues | $263,683 | $213,923
Voyage charter revenues(1) | 33,275 | 83,542
Contracts of affreightment revenues | 58,589 | 68,698
Total shipping revenues | $355,547 | $366,163


Question: What was the Contracts of affreightment revenues in 2019 and 2018 respectively?
Answer: 58,589, 68,698
Revenue stream
The Company generates revenue primarily from the sales of equipment and sales of spares & service. The products and services described by nature in Note 1, can be part of all revenue streams.
The proceeds resulting from the patent litigation & arbitration settlements (€159 million) are included in the equipment revenue stream.
Table:
 | Year ended December 31, | 
(EUR thousand) | 2018 | 2019
Equipment revenue | 631,504 | 1,068,645
Spares & service revenue | 186,577 | 215,215
Total | 818,081 | 1,283,860


Question: What is the  Spares & service revenue for 2019?
Answer: 215,215
the following table provides a summary of our historical capital expenditures related to the upgrading of our infrastructure and systems: .

Table:
( in millions ) | for the years ended december 31 , 2018 | for the years ended december 31 , 2017 | for the years ended december 31 , 2016
transmission and distribution | $ 572 | $ 551 | $ 568
treatment and pumping | 231 | 171 | 151
services meter and fire hydrants | 303 | 281 | 297
general structure and equipment | 371 | 281 | 202
sources of supply | 26 | 54 | 59
wastewater | 83 | 96 | 34
total capital expenditures | $ 1586 | $ 1434 | $ 1311
in 2018 , our capital expenditures increased $ 152 million , or 10.6% ( 10.6 % ) , primarily due to investment across the majority of our infrastructure categories .
in 2017 , our capital expenditures increased $ 123 million , or 9.4% ( 9.4 % ) , primarily due to investment in our general structure and equipment and wastewater categories .
we also grow our business primarily through acquisitions of water and wastewater systems , as well as other water-related services .
these acquisitions are complementary to our existing business and support continued geographical diversification and growth of our operations .
generally , acquisitions are funded initially with short- term debt , and later refinanced with the proceeds from long-term debt .
the following is a summary of the acquisitions and dispositions affecting our cash flows from investing activities : 2022 the majority of cash paid for acquisitions pertained to the $ 365 million purchase of pivotal within our homeowner services group .
2022 paid $ 33 million for 15 water and wastewater systems , representing approximately 14000 customers .
2022 received $ 35 million for the sale of assets , including $ 27 million for the sale of the majority of the o&m contracts in our contract services group during the third quarter of 2018 .
2022 the majority of cash paid for acquisitions pertained to the $ 159 million purchase of the wastewater collection and treatment system assets of the municipal authority of the city of mckeesport , pennsylvania ( the 201cmckeesport system 201d ) , excluding a $ 5 million non-escrowed deposit made in 2016 .
2022 paid $ 18 million for 16 water and wastewater systems , excluding the mckeesport system and shorelands ( a stock-for-stock transaction ) , representing approximately 7000 customers .
2022 received $ 15 million for the sale of assets .
2022 paid $ 199 million for 15 water and wastewater systems , representing approximately 42000 customers .
2022 made a non-escrowed deposit of $ 5 million related to the mckeesport system acquisition .
2022 received $ 9 million for the sale of assets .
as previously noted , we expect to invest between $ 8.0 billion to $ 8.6 billion from 2019 to 2023 , with $ 7.3 billion of this range for infrastructure improvements in our regulated businesses .
in 2019 , we expect to .

Question: for 2018 , wastewater was what percent of total capital expenditures?
Answer: 5.2%
Calculation: divide(83, 1586)
Contract Assets and Liabilities
The following table provides information about receivables, contract assets and contract liabilities from our revenue contracts with customers:
Contract assets include costs that are incremental to the acquisition of a contract. Incremental costs are those that result directly from obtaining a contract or costs that would not have been incurred if the contract had not been obtained, which primarily relate to sales commissions. These costs are deferred and amortized over the expected customer life.
We determined that the expected customer life is the expected period of benefit as the commission on the renewal contract is not commensurate with the commission on the initial contract. During the years ended December 31, 2019 and 2018, the Company recognized expense of $6.3 million and $2.9 million, respectively, related to deferred contract acquisition costs.
Contract liabilities include deferred revenues related to advanced payments for services and nonrefundable, upfront service activation and set-up fees, which under the new standard are generally deferred and amortized over the expected customer life as the option to renew without paying an upfront fee provides the customer with a material right. During the years ended December 31, 2019 and 2018, the Company deferred and recognized revenues of $397.5 million and $354.2 million, respectively.
A receivable is recognized in the period the Company provides goods or services when the Company’s right to consideration is unconditional. Payment terms on invoiced amounts are generally 30 to 60 days.
Table:
 | Year Ended December 31, | 
(In thousands) | 2019 | 2018
Accounts receivable, net | $120,016 | $133,136
Contract assets | 18,804 | 12,128
Contract liabilities | 50,974 | 52,966


Question: What was the percentage increase / (decrease) in the contract assets from 2018 to 2019?
Answer: 55.05
Calculation: 18,804 / 12,128 - 1
Disaggregation of Revenues
The Company serves customers in diverse geographies, which are subject to different economic and industry factors. The Company's presentation of revenue by geography most reasonably depicts how the nature, amount, timing and uncertainty of Company revenue and cash flows are affected by economic and industry factors. The following table presents the Company's revenue, from continuing operations, by geography for the year ended December 31, 2019, 2018 and 2017 (in millions):
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Net sales: |  |  | 
United States | $901.3 | $854.6 | $759.4
Canada | 45.6 | 42.3 | 32.4
Consolidated | $946.9 | $896.9 | $791.8


Question: What is the company's total revenue from continuing operations in 2018 and 2017?
Answer: 1688.7
Calculation: 791.8 + 896.9
Property, plant and equipment consists of the following (in millions):
Depreciation expense was $52.3 million and $46.6 million for the years ended December 31, 2019 and 2018, respectively. These amounts included $9.1 million and $7.0 million of depreciation expense recognized within cost of revenue for the years ended December 31, 2019 and 2018, respectively.
As of December 31, 2019 and 2018 total net book value of equipment, cable-ships, and submersibles under capital leases consisted of $35.1 million and $40.0 million, respectively.
For the year ended December 31, 2018, our Energy segment recorded an impairment expense of $0.7 million, of which $0.4 million was due to station performance and $0.3 million was related to the abandonment of a station development project.
Table:
 | December 31, | 
 | 2019 | 2018
Cable-ships and submersibles | $ 246.5 | $ 251.1
Equipment, furniture and fixtures, and software | 214.1 | 148.0
Building and leasehold improvements | 48.9 | 47.3
Land | 36.8 | 32.8
Construction in progress | 14.3 | 12.9
Plant and transportation equipment | 13.5 | 12.0
 | 574.1 | 504.1
Less: Accumulated depreciation | 168.3 | 127.8
Total | $ 405.8 | $ 376.3


Question: What is the count of depreciable assets in the company?
Answer: 6