hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Supplemental balance sheet information related to operating and finance leases as of the period presented was as follows (table in millions):
(1) ROU assets for operating leases are included in other assets and ROU assets for finance leases are included in property and equipment, net on the consolidated balance sheets
(2) Current lease liabilities are included primarily in accrued expenses and other on the consolidated balance sheets. An immaterial amount is presented in due from related parties, net on the consolidated balance sheets.
(3) Operating lease liabilities are presented as operating lease liabilities on the consolidated balance sheets. Finance lease liabilities are included in other liabilities on the consolidated balance sheets.
Table:
 | January 31, 2020 | 
 | Operating Leases | Finance Leases
ROU assets, non-current (1) | $886 | $58
Lease liabilities, current (2) | $109 | $4
Lease liabilities, non-current (3) | 746 | 55
Total lease liabilities | $855 | $59


Question: What was the difference in total lease liabilities between operating leases and finance leases?
Answer: 796
Calculation: 855-59
Our net sales by offering category for North America for 2019 and 2018, were as follows (dollars
in thousands):
Net sales in North America increased 12%, or $661.3 million, in 2019 compared to 2018. This increase reflects the addition of PCM, which reported $716.1 million in net sales in 2019, partially offset by a decline in net sales of the core business of $51.3 million. Net sales of hardware, software and services increased 10%, 14% and 25%, respectively, year over year.
Table:
 | North America |  | 
SalesMix | 2019 | 2018 | %Change
Hardware | $3,957,507 | $3,610,356 | 10%
Software | 1,269,983 | 1,112,715 | 14%
Services | 796,815 | 639,910 | 25%
 | $6,024,305 | $5,362,981 | 12%


Question: What is the net sales of hardware in 2019 and 2018 respectively?
Answer: $3,957,507, $3,610,356
NOTE 7 - continued
Lease payments not recognized as a liability The Group has elected not to recognize a lease liability for short-term leases (leases of an expected term of 12 months or less) or for leases of low value assets. Payments made under such leases are expensed on a straight-line basis. The expenses relating to payments not recognized as a lease liability are insignificant.
Administrative expenses The total outflow for leases, USD 2.9m, is presented as “Depreciation” of USD 2.5m and “Financial expenses” (interest) of USD 0.4m, in contrast to the recording of an operating lease charge of a materially equivalent figure within the line item “Administrative expenses” under IAS 17.
Financial expenses
Financial expenses for the reporting periods:
Table:
USDm | 2019 | 2018 | 2017
Interest expenses: | - | - | -
Financial expenses arising from lease liabilities regarding right-of-use assets | 2.4 | 2.3 | 1.8
Other financial expenses | 39.5 | 37.0 | 38.8
Total | 41.9 | 39.3 | 40.6


Question: What is the total amount of financial expenses in 2019?
Answer: 41.9
Fiscal 2018 Acquisitions
Allocation of the purchase consideration for acquisitions completed in fiscal 2018 is summarized as follows (in millions):
On July 31, 2017, we completed our acquisition of privately held Viptela Inc. (“Viptela”), a provider of software-defined wide area networking products. Revenue from the Viptela acquisition has been included in our Infrastructure Platforms product category.
On September 22, 2017, we completed our acquisition of privately held Springpath, Inc. (“Springpath”), a hyperconvergence software company. Revenue from the Springpath acquisition has been included in our Infrastructure Platforms product category.
On February 1, 2018, we completed our acquisition of publicly held BroadSoft, Inc. (“BroadSoft”), a cloud calling and contact center solutions company. Revenue from the BroadSoft acquisition has been included in our Applications product category.
On May 10, 2018, we completed our acquisition of privately held Accompany, a provider of an AI-driven relationship intelligence platform. Results from the Accompany acquisition has been included in our Applications product category.
The total purchase consideration related to our acquisitions completed during fiscal 2018 consisted of cash consideration and vested share-based awards assumed. The total cash and cash equivalents acquired from these acquisitions was approximately $187 million.
Table:
Fiscal 2018 | Purchase Consideration | Net Tangible Assets Acquired (Liabilities Assumed) | Purchased Intangible Assets | Goodwill
Viptela | $497 | $(18) | $180 | $335
Springpath | 248 | (11) | 160 | 99
BroadSoft | 2,179 | 353 | 430 | 1,396
Accompany | 222 | 6 | 55 | 161
Others (four in total) | 72 | 4 | 42 | 26
Total | $3,218 | $334 | $867 | $2,017


Question: What was the difference in Purchase Consideration between Springpath and Broadsoft?
Answer: 1931
Calculation: 2,179-248
the internal revenue code . therefore , cash needed to execute our strategy and invest in new properties , as well as to pay our debt at maturity , must come from one or more of the following sources : 2022 cash not distributed to shareholders , 2022 proceeds of property dispositions , or 2022 proceeds derived from the issuance of new debt or equity securities . it is management 2019s intention that we continually have access to the capital resources necessary to expand and develop our business . as a result , we intend to operate with and maintain a conservative capital structure that will allow us to maintain strong debt service coverage and fixed-charge coverage ratios as part of our commitment to investment-grade debt ratings . we may , from time to time , seek to obtain funds by the following means : 2022 additional equity offerings , 2022 unsecured debt financing and/or mortgage financings , and 2022 other debt and equity alternatives , including formation of joint ventures , in a manner consistent with our intention to operate with a conservative debt structure . cash and cash equivalents were $ 30.5 million and $ 35.0 million at december 31 , 2004 and december 31 , 2003 , respectively . summary of cash flows for the year ended december 31 , 2004 ( in thousands ) .

Table:
 | for the year ended december 31 2004 ( in thousands )
cash provided by operating activities | $ 161113
cash used in investing activities | -154273 ( 154273 )
cash used by financing activities | -11333 ( 11333 )
decrease in cash and cash equivalents | -4493 ( 4493 )
cash and cash equivalents beginning of period | 34968
cash and cash equivalents end of period | $ 30475
the cash provided by operating activities is primarily attributable to the operation of our properties and the change in working capital related to our operations .
we used cash of $ 154.3 million during the twelve months ended december 31 , 2004 in investing activities , including the following : 2022 $ 101.7 million for our acquisition of westgate mall , shaw 2019s plaza and several parcels of land , 2022 capital expenditures of $ 59.2 million for development and redevelopment of properties including santana row , 2022 maintenance capital expenditures of approximately $ 36.9 million , 2022 $ 9.4 million capital contribution to a real estate partnership , and 2022 an additional $ 3.2 million net advance under an existing mortgage note receivable ; offset by 2022 $ 41.8 million in net sale proceeds from the sale of properties , and .

Question: what are the percentage of the acquisition of westgate mall , shaw 2019s plaza , and several parcels of land in the investing activities?\\n
Answer: 65.91%
Calculation: divide(101.7, 154.3)
Fair Value Measurement of Financial Assets and Liabilities
The carrying values of the Company’s accounts receivable and accounts payable, approximated their fair values due to the short period of time to maturity or repayment.
The following tables set forth the Company’s financial instruments that were measured at fair value on a recurring basis by level within the fair value hierarchy (in thousands):
The fair value of the Company’s Level 1 financial instruments is based on quoted market prices in active markets for identical instruments. The fair value of the Company’s Level 2 financial instruments is based on observable inputs other than quoted prices in active markets for identical assets and liabilities, quoted prices for identical or similar assets or liabilities in inactive markets, or other inputs that are observable or can be corroborated by observable market data.
In addition, Level 2 assets and liabilities include derivative financial instruments associated with hedging activity, which are further discussed in Note 4. Derivative financial instruments are initially measured at fair value on the contract date and are subsequently remeasured to fair value at each reporting date using inputs such as spot rates, forward rates, and discount rates. There is not an active market for each hedge contract, but the inputs used to calculate the value of the instruments are tied to active markets.
Table:
December 31, 2019 |  |  |  | 
 | Level 1 | Level 2 | Level 3 | Total
Assets: |  |  |  | 
Money market funds | $107,708 | $— | $— | $107,708
U.S. government agencies | — | 77,364 | — | 77,364
Corporate debt securities | — | 207,137 | — | 207,137
Total | $107,708 | $284,501 | $— | $392,209
Liabilities: |  |  |  | 
Contingent consideration | $— | $— | $1,889 | $1,889
Derivative liabilities | — | 748 | — | 748
Total | $— | $748 | $1,889 | $2,637
 |  |  |  | 
December 31, 2018 |  |  |  | 
 | Level 1 | Level 2 | Level 3 | Total
Assets: |  |  |  | 
Money market funds | $273,546 | $— | $— | $273,546
U.S. government agencies | — | 72,840 | — | 72,840
Corporate debt securities | — | 228,953 | — | 228,953
Derivative assets | — | 623 | — | 623
Total | $273,546 | $302,416 | $— | $575,962
Liabilities: |  |  |  | 
Derivative liabilities | $— | $549 | $— | $549
Stock warrant liability | — | — | 410 | 410
Total | $— | $549 | $410 | $959


Question: What is the fair value of the Company's Level 1 financial instruments based on?
Answer: Quoted market prices in active markets for identical instruments
Insurance Segment
(1) The Insurance segment revenues are inclusive of realized and unrealized gains and net investment income for the year ended December 31, 2019 and 2018. Such adjustments are related to transactions between entities under common control which are eliminated or are reclassified in consolidation.
Life, accident and health earned premiums, net: Life, accident and health earned premiums, net from our Insurance segment for the year ended December 31, 2019 increased $22.4 million to $116.8 million from $94.4 million for the year ended December 31, 2018. The increase was primarily due to the premiums generated from the acquisition of KIC in 2018.
Net investment income: Net investment income from our Insurance segment for the year ended December 31, 2019 increased $95.8 million to $212.9 million from $117.1 million for the year ended December 31, 2018. The increase was primarily due to the income generated from the assets acquired in the KIC acquisition, higher average invested assets as a result of the reinvestment of premiums and investment income received, and to a lesser extent, rotation into higher-yielding investments.
Net realized and unrealized gains on investments: Net realized and unrealized gains on investments from our Insurance segment for the year ended December 31, 2019 decreased $3.7 million to $1.9 million from $5.6 million for the year ended December 31, 2018. The decrease was driven by smaller realized gains on bonds and common stocks, higher impairments, and losses on fair value changes on interest only bonds in 2019. The decrease was offset by overall improvement in fair value changes in equity securities and realized gains on mortgage loans in 2019.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | Increase / (Decrease)
Life, accident and health earned premiums, net | $116.8 | $94.4 | $22.4
Net investment income | 212.9 | 117.1 | 95.8
Net realized and unrealized gains on investments | 1.9 | 5.6 | (3.7)
Net revenue | 331.6 | 217.1 | 114.5
Policy benefits, changes in reserves, and commissions | 234.4 | 197.3 | 37.1
Selling, general and administrative | 35.7 | 30.4 | 5.3
Depreciation and amortization | (23.1) | (12.4) | (10.7)
Other operating expense | 47.3 | — | 47.3
Income from operations (1) | $37.3 | $1.8 | $35.5


Question: What was the net realized and unrealized gain on investment in December 2019?
Answer: $1.9 million
Provision (Benefit) For Income Taxes
Provision for income taxes reflects the tax provision on our operations in foreign and U.S. jurisdictions, offset by tax benefits from a partial release of valuation allowance against U.S. federal and state deferred tax assets ("DTAs") and from lapsing of statute of limitations related to uncertain tax positions in foreign jurisdictions. As of December 28, 2019, we maintain a valuation allowance of $36.6 million primarily against our California deferred tax assets and foreign tax credits, due to uncertainty about the future realization of these assets.
The benefit for income taxes in fiscal 2018 includes a $75.8 million reduction to our valuation allowance on our U.S. deferred tax assets as sufficient positive evidence existed to support the realization of such DTAs. The effective tax rate in fiscal 2018 also benefited from a lower statutory tax rate in the U.S., partially offset by higher profits in foreign jurisdictions.
Our effective tax rate may vary from period to period based on changes in estimated taxable income or loss by jurisdiction, changes to the valuation allowance, changes to U.S. federal, state or foreign tax laws, future expansion into areas with varying country, state, and local income tax rates, deductibility of certain costs and expenses by jurisdiction.
Table:
 |  | Fiscal Year Ended | 
 | December 28, 2019 | December 29, 2018 | December 30, 2017
 |  | (Dollars in thousands) | 
Provision (benefit) for income taxes | $11,717 | $(70,109) | $1,293
Effective tax rate | 22.9 % | (206.6) % | 3.1 %


Question: In which year was Provision (benefit) for income taxes greater than 10,000 thousands?
Answer: 2019
Calculation: locate and analyze Provision (benefit) for income taxes in row 4
Unrecognized Tax Benefits
The aggregate changes in the balance of gross unrecognized tax benefits were as follows (in millions):
As of July 27, 2019, $1.7 billion of the unrecognized tax benefits would affect the effective tax rate if realized. During fiscal 2019, we recognized $30 million of net interest expense and $6 million of penalty expense. During fiscal 2018, we recognized $10 million of net interest expense and no net penalty expense. During fiscal 2017, we recognized $26 million of net interest expense and a $4 million reduction in penalties. Our total accrual for interest and penalties was $220 million, $180 million, and $186 million as of the end of fiscal 2019, 2018, and 2017, respectively. We are no longer subject to U.S. federal income tax audit for returns covering tax years through fiscal 2010. We are no longer subject to foreign or state income tax audits for returns covering tax years through fiscal 1999 and fiscal 2008, respectively.
We regularly engage in discussions and negotiations with tax authorities regarding tax matters in various jurisdictions. We believe it is reasonably possible that certain federal, foreign, and state tax matters may be concluded in the next 12 months. Specific positions that may be resolved include issues involving transfer pricing and various other matters. We estimate that the unrecognized tax benefits at July 27, 2019 could be reduced by $50 million in the next 12 months.
Table:
Years Ended | July 27, 2019 | July 28, 2018 | July 29, 2017
Beginning balance | $2,000 | $1,973 | $1,627
Additions based on tax positions related to the current year | 185 | 251 | 336
Additions for tax positions of prior years | 84 | 84 | 180
Reductions for tax positions of prior years . | (283) | (129) | (78)
Settlements | (38) | (124) | (43)
Lapse of statute of limitations . | (23) | (55) | (49)
Ending balance . | $ 1,925 | $ 2,000 | $ 1,973


Question: How much net interest expense did the company recognize in fiscal year 2019?
Answer: $30 million
Dividends
The following table shows our total cash dividends paid in the years ended December 31:
On February 13, 2020, our Board of Directors declared a quarterly cash dividend of $0.16 per common share payable on March 20, 2020 to stockholders of record at the close of business on March 6, 2020. The estimated amount of this dividend payment is $24.8 million based on 154.7 million shares of our common stock issued and outstanding as of February 21, 2020.
The dividend payments discussed above are recorded as reductions to cash and cash equivalents and retained earnings on our Consolidated Balance Sheets. Our credit facility and our senior notes contain covenants that restrict our ability to declare or pay dividends and repurchase stock. However, we do not believe these covenants are likely to materially limit the future payment of quarterly cash dividends on our common stock. From time to time, we may consider other means of returning value to our stockholders based on our consolidated financial condition and results of operations. There is no guarantee that our Board of Directors will declare any further dividends.
Table:
(In millions, except per share amounts) | Total Cash Dividends Paid | Total Cash Dividends Paid Per Common Share
2017 | $119.7 | $0.64
2018 | 102.9 | 0.64
2019 | 99.1 | 0.64
Total | $321.7 | 


Question: What years are included in the table?
Answer: 2017, 2018, 2019
Consolidated Statements of Earnings and Comprehensive Earnings
A detail of related party items included in Operating expenses (net of expense reimbursements) is as follows (in millions):
(1) Transactions with FNF are summarized through November 30, 2019, the date after which FNF is no longer considered a related party.
Table:
 |  | Year ended December 31, | 
 | 2019(1) | 2018 | 2017
Data entry, indexing services and other operating expenses | $8.8 | $8.2 | $5.1
Corporate services | 3.8 | 4.9 | 9.2
Technology and corporate services | (0.1) | (1.0) | (1.7)
Total related party expenses, net | $12.5 | $12.1 | $12.6


Question: What was the change in corporate services between 2017 and 2018?
Answer: -4.3
Calculation: 4.9-9.2
Note 8. Goodwill and Intangible Assets, Net
The following table reflects changes in the net carrying amount of the components of intangible assets (in thousands):
Table:
 | Customer Relationships | Developed Technology | Trade Name | Total
Balance as of January 1, 2018 | $88,526 | $5,532 | $228 | $94,286
Amortization | (11,262) | (3,854) | (103) | (15,219)
Balance as of December 31, 2018 | 77,264 | 1,678 | 125 | 79,067
Intangible assets acquired | 19,805 | 16,583 | 2,219 | 38,607
Amortization | (12,673) | (1,441) | (122) | (14,236)
Balance as of December 31, 2019 | $84,396 | $16,820 | $2,222 | $103,438


Question: What was the total balance as of January 1, 2018?
Answer: $94,286
Net Profit After Tax
Net profit after tax increased by 41.1% to US$52.9 million from US$37.5 million in the previous year.
The effective tax rate for the year was 8% (2018: 6%). This reflects the tax utilisation of the deferred tax asset recognised as a result of both temporary differences arising on relocation of Altium’s core business assets to the USA. Altium will continue to utilize the tax benefits and re-evaluate the valuation of the deferred tax asset on an annual basis.
For more details on revenue, refer to Note 3 of the annual report.
Table:
 |  | Consolidated | 
 | 2019 | 2018 | Change
Product Revenue | US$’000 | US$’000 | %
Altium Designer software licenses | 62,377 | 51,309 | 22%
Altium Designer subscriptions | 58,468 | 51,522 | 13%
Octopart search advertising | 17,940 | 11,968 | 50%
TASKING software licenses | 12,293 | 8,526 | 44%
TASKING maintenance | 5,741 | 4,709 | 22%
Altium Nexus | 6,635 | 4,848 | 37%
Service revenue | 3,655 | 4,833 | (25%)
Other | 4,710 | 2,461 | 91%
Total Product Revenue | 171,819 | 140,176 | 23%


Question: What are the years included in the table?
Answer: 2019, 2018
In connection with the asset-backed securitization programs, the Company recognized the following (in millions):
(1) The amounts primarily represent proceeds from collections reinvested in revolving-period transfers.
(2) Recorded to other expense within the Consolidated Statements of Operations.
(3) Excludes $650.3 million of trade accounts receivable sold, $488.1 million of cash and $13.9 million of net cash received prior to the amendment of the foreign asset-backed securitization program and under the previous North American asset-backed securitization program.
The asset-backed securitization programs require compliance with several covenants. The North American asset-backed securitization program covenants include compliance with the interest ratio and debt to EBITDA ratio of the five-year unsecured credit facility amended as of November 8, 2017 (“the 2017 Credit Facility”). The foreign asset-backed securitization program covenants include limitations on certain corporate actions such as mergers and consolidations. As of August 31, 2019 and 2018, the Company was in compliance with all covenants under the asset-backed securitization programs.
Table:
 |  | Fiscal Year Ended August 31, | 
 | 2019(3) | 2018 | 2017
Trade accounts receivable sold | $4,057 | $8,386 | $8,878
Cash proceeds received(1) | $4,031 | $7,838 | $8,300
Pre-tax losses on sale of receivables(2) | $26 | $15 | $9
Deferred purchase price receivables as of August 31 | $— | $533 | $569


Question: What was the change in Trade accounts receivable sold between 2018 and 2019?
Answer: -4329
Calculation: $4,057-$8,386
Net Periodic Benefit Cost
The following table provides information about the net periodic benefit cost for the plans for fiscal years 2019, 2018 and 2017 (in thousands):
On September 1, 2018, the Company adopted a new accounting standard, which changes the presentation of net periodic benefit cost in the Consolidated Statements of Operation. The Company adopted the standard on a retrospective basis which results in reclassifications for the service cost component of net periodic benefit cost from selling, general and administrative expense to cost of revenue and for the other components from selling, general and administrative expense to other expense. Prior periods have not been reclassified due to immateriality.
Table:
 |  | Pension | 
 | 2019 | 2018 | 2017
Service cost | $1,437 | $1,063 | $1,068
Interest cost | 3,715 | 3,807 | 2,942
Expected long-term return on plan assets | (5,291) | (5,954) | (4,206)
Recognized actuarial loss | 741 | 1,127 | 1,929
Amortization of prior service credit | (44) | (88) | (138)
Net settlement loss | 634 | 116 | 1,472
Net periodic benefit cost | $1,192 | $71 | $3,067


Question: What was the total percentage change in the Net periodic benefit cost between 2017 and 2019?
Answer: -61.13
Calculation: ($1,192-$3,067)/$3,067
Sales and Marketing Expense
Sales and marketing expense increased by $22.6 million in 2018 compared to 2017. The increase was primarily due to a $20.0 million increase in employee- related costs, which includes stock-based compensation, associated with our increased headcount from 215 employees as of December 31, 2017 to 286 employees as of December 31, 2018. The remaining increase was principally the result of a $1.8 million increase in trade show and advertising costs and a $0.8 million increase attributed to office related expenses to support the sales team. The adoption of ASC 606 did not have a material impact on the change in commission expense when compared to year over year.
Table:
 | Year Ended December 31, |  | Change | 
 | 2018 | 2017 | $ | %
 |  | (dollars in thousands) |  | 
Sales and marketing | $ 69,608 | $ 46,998 | $ 22,610 | 48.1%
% of revenue | 47% | 45% |  | 


Question: In which year was Sales and marketing expenses less than 50,000 thousands?
Answer: 2017
Calculation: locate and analyze sales and marketing in row 4