hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Item 6. SELECTED FINANCIAL DATA
You should read the following selected consolidated financial data for the five-year period ended March 31, 2019 in conjunction with our consolidated financial statements and notes thereto and "Management's Discussion and Analysis of Financial Condition and Results of Operations" included in Items 7 and 8 of this Form 10-K. Our consolidated statements of income data for each of the years in the three-year period ended March 31, 2019, and the balance sheet data as of March 31, 2019 and 2018, are derived from our audited consolidated financial statements, included in Item 8 of this Form 10-K. The statement of income data for the years ended March 31, 2016 and 2015 and balance sheet data as of March 31, 2017, 2016 and 2015 have been derived from our audited consolidated financial statements not included herein (in the tables below all amounts are in millions, except per share data).
(1) Refer to Note 2 to our consolidated financial statements for an explanation of our material business combinations during fiscal 2019 and fiscal 2017.
(2) Refer to Note 4 to our consolidated financial statements for a discussion of the special charges and other, net.
(3) Refer to Note 12 Debt and Credit Facility for further discussion.
Table:
 |  |  | Year ended March 31, |  | 
 | 2019 (1) | 2018 | 2017 (1) | 2016 | 2015
Consolidated Statements of Income data: |  |  |  |  | 
Net sales | $5,349.5 | $3,980.8 | $3,407.8 | $2,173.3 | $2,147.0
Special charges and other, net (2) | $33.7 | $17.5 | $98.6 | $4.0 | $2.8
Loss on settlement of debt (3) | $(12.6) | $(16.0) | $(43.9) | $— | $(50.6)
Net income from continuing operations | $355.9 | $255.4 | $170.6 | $323.9 | $365.3
Basic net income per common share from continuing operations | $1.51 | $1.10 | $0.79 | $1.59 | $1.84
Diluted net income per common share from continuing operations | $1.42 | $1.03 | $0.73 | $1.49 | $1.65
Dividends declared per common share | $1.457 | $1.449 | $1.441 | $1.433 | $1.425
Consolidated Balance Sheets data: |  |  |  |  | 
Total assets | $18,350.0 | $8,257.2 | $7,686.9 | $5,537.9 | $4,780.7
Net long-term debt and capital lease obligations, less current maturities (3) | $8,956.0 | $1,769.1 | $2,912.1 | $2,465.8 | $1,840.0
Microchip Technology stockholders' equity | $ 5,287.5 | $ 3,279.8 | $3,270.7 | $ 2,150.9 | $ 2,044.7


Question: How many years did Total Assets exceed $10,000 million?
Answer: 1
Calculation: 2019
General and Administrative Expense
General and administrative expense increased by $8.6 million in 2018 compared to 2017. The increase was primarily due to a $3.7 million increase in employee-related costs, which includes stock-based compensation, associated with our increased headcount from 79 employees as of December 31, 2017 to 89 employees as of December 31, 2018. There was an additional increase of $2.8 million in depreciation and amortization, an increase of $1.5 million to support compliance as a public company, an increase of $0.4 million in software subscription cost and a $0.2 million increase in office related expenses to support the administrative team.
Table:
 | Year Ended December 31, |  | Change | 
 | 2018 | 2017 | $ | %
 |  | (dollars in thousands) |  | 
General and administrative | $ 31,462 | $ 22,895 | $ 8,567 | 37.4%
% of revenue | 21% | 22% |  | 


Question: What was the General and administrative in 2018 and 2017?
Answer: 31,462, 22,895
Note 13. Basic and Diluted Net Loss Per Share
Basic net loss per share is computed by dividing the net loss by the weighted-average number of shares of common stock outstanding during the period, less the weighted-average unvested common stock subject to repurchase or forfeiture as they are not deemed to be issued for accounting purposes. Diluted net loss per share is computed by giving effect to all potential shares of common stock, stock options, restricted stock units, ESPP, and convertible senior notes, to the extent dilutive. For the periods presented, all such common stock equivalents have been excluded from diluted net loss per share as the effect to net loss per share would be anti-dilutive.
The following table sets forth the computation of the Company’s basic and diluted net loss per share during the years ended December 31, 2019, 2018 and 2017 (in thousands, except per share data)
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Numerator |  |  | 
Net loss | $(53,607) | $(26,203) | $(4,204)
Denominator |  |  | 
Weighted-average common shares for basic and diluted net loss per share | 83,130 | 79,500 | 76,281
Basic and diluted net loss per share | $(0.64) | $(0.33) | $(0.06)


Question: What is the percentage change in the weighted-average common shares for basic and diluted net loss per share between 2017 and 2018?
Answer: 4.22
Calculation: (79,500 - 76,281)/76,281
the following is a list of distribution locations including the approximate square footage and if the location is leased or owned: .

Table:
distribution facility location | approximate square footage | owned/leased facility
frankfort new york ( a ) | 924000 | owned
franklin kentucky | 833000 | owned
pendleton indiana | 764000 | owned
macon georgia | 684000 | owned
waco texas | 666000 | owned
casa grande arizona | 650000 | owned
hagerstown maryland ( b ) | 482000 | owned
hagerstown maryland ( b ) | 309000 | leased
waverly nebraska | 592000 | owned
seguin texas ( c ) | 71000 | owned
lakewood washington | 64000 | leased
longview texas ( c ) | 63000 | owned
longview , texas ( c ) 63000 owned ( a ) the frankfort , new york , distribution center began receiving merchandise in fourth quarter of fiscal 2018 , and is expected to begin shipping merchandise to stores in the first quarter of fiscal 2019 .
( b ) the leased distribution center in hagerstown is treated as an extension of the existing owned hagerstown location and is not considered a separate distribution center .
( c ) this is a mixing center designed to process certain high-volume bulk products .
the company 2019s store support center occupies approximately 260000 square feet of owned building space in brentwood , tennessee , and the company 2019s merchandising innovation center occupies approximately 32000 square feet of leased building space in nashville , tennessee .
the company also leases approximately 8000 square feet of building space for the petsense corporate headquarters , located in scottsdale , arizona .
item 3 .
legal proceedings the company is involved in various litigation matters arising in the ordinary course of business .
the company believes that any estimated loss related to such matters has been adequately provided for in accrued liabilities to the extent probable and reasonably estimable .
accordingly , the company currently expects these matters will be resolved without material adverse effect on its consolidated financial position , results of operations or cash flows .
item 4 .
mine safety disclosures not applicable. .

Question: what is the total texas facilities square footage?
Answer: 800000
Calculation: add(71000, 63000), add(#0, 666000)
(1) Of the total deferred costs, $1,896 million was current and $2,472 million was noncurrent at December 31, 2019 and $2,300 million was current and $2,676 million was noncurrent at December 31, 2018.
The amount of total deferred costs amortized during the year ended December 31, 2019 was $3,836 million and there were no material impairment losses incurred. Refer to note A, “Significant Accounting Policies,” for additional information on deferred costs to fulfill a contract and capitalized costs of obtaining a contract.
Table:
($ in millions) |  | 
At December 31: | 2019 | 2018
Capitalized costs to obtain a contract | $  609 | $  717
Deferred costs to fulfill a contract |  | 
Deferred setup costs | 1,939 | 2,085
Other deferred fulfillment costs | 1,820 | 2,173
Total deferred costs (1) | $4,368 | $4,975


Question: What is the average of Deferred setup costs?
Answer: 2012
Calculation: (1,939 +2,085) / 2
Results of Operations: Year Ended December 31, 2019, versus Year Ended December 31, 2018 (Amounts in thousands, except percentages and per share amounts):
Other income and expense items are summarized in the following table:
Interest expense increased mainly as a result of an increase in debt related to the QTI acquisition. Other expense in 2019 was principally driven by foreign currency translation losses, mainly due to the appreciation of the U.S. Dollar compared to the Chinese Renminbi and Euro, as well as an increase in pension expense.
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Interest expense | $(2,648) | $(2,085)
Interest income | 1,737 | 1,826
Other (expense) income | (2,638) | (2,676)
Total other (expense) income, net | $(3,549) | $(2,935)


Question: Which years does the table provide information for the company's Other income and expense items?
Answer: 2019, 2018
devon energy corporation and subsidiaries notes to consolidated financial statements 2013 ( continued ) other debentures and notes following are descriptions of the various other debentures and notes outstanding at december 31 , 2014 and 2013 , as listed in the table presented at the beginning of this note . geosouthern debt in december 2013 , in conjunction with the planned geosouthern acquisition , devon issued $ 2.25 billion aggregate principal amount of fixed and floating rate senior notes resulting in cash proceeds of approximately $ 2.2 billion , net of discounts and issuance costs . the floating rate senior notes due in 2015 bear interest at a rate equal to three-month libor plus 0.45 percent , which rate will be reset quarterly . the floating rate senior notes due in 2016 bears interest at a rate equal to three-month libor plus 0.54 percent , which rate will be reset quarterly . the schedule below summarizes the key terms of these notes ( in millions ) . .

Table:
floating rate due december 15 2015 | $ 500
floating rate due december 15 2016 | 350
1.20% ( 1.20 % ) due december 15 2016 ( 1 ) | 650
2.25% ( 2.25 % ) due december 15 2018 | 750
discount and issuance costs | -2 ( 2 )
net proceeds | $ 2248
( 1 ) the 1.20% ( 1.20 % ) $ 650 million note due december 15 , 2016 was redeemed on november 13 , 2014 .
the senior notes were classified as short-term debt on devon 2019s consolidated balance sheet as of december 31 , 2013 due to certain redemption features in the event that the geosouthern acquisition was not completed on or prior to june 30 , 2014 .
on february 28 , 2014 , the geosouthern acquisition closed and thus the senior notes were subsequently classified as long-term debt .
additionally , during december 2013 , devon entered into a term loan agreement with a group of major financial institutions pursuant to which devon could draw up to $ 2.0 billion to finance , in part , the geosouthern acquisition and to pay transaction costs .
in february 2014 , devon drew the $ 2.0 billion of term loans for the geosouthern transaction , and the amount was subsequently repaid on june 30 , 2014 with the canadian divestiture proceeds that were repatriated to the u.s .
in june 2014 , at which point the term loan was terminated. .

Question: what percentage of the net proceeds came from the floating rates due in 2015 and 2016?
Answer: 37.81%
Calculation: add(500, 350), divide(#0, 2248), multiply(#1, const_100)
Employee Stock Purchase Plan
The maximum aggregate number of shares that are available for issuance under the 2011 Employee Stock Purchase Plan (the “ESPP”) is 12,000,000.
Employees are eligible to participate in the ESPP after 90 days of employment with the Company. The ESPP permits eligible employees to purchase common stock through payroll deductions, which may not exceed 10% of an employee’s compensation, as defined in the ESPP, at a price equal to 85% of the fair value of the common stock at the beginning or end of the offering period, whichever is lower. The ESPP is intended to qualify under Section 423 of the Internal Revenue Code. As of August 31, 2019, 3,397,019 shares remained available for issue under the 2011 ESPP.
The fair value of shares issued under the ESPP was estimated on the commencement date of each offering period using the Black-Scholes option pricing model. The following weighted-average assumptions were used in the model for each respective period:
(1) The expected volatility was estimated using the historical volatility derived from the Company’s common stock.
Table:
 | Fiscal Year Ended August 31, |  | 
 | 2019 | 2018 | 2017
Expected dividend yield | 0.6% | 0.6% | 0.8%
Risk-free interest rate | 2.3% | 1.4% | 0.5%
Expected volatility(1) | 28.6% | 23.0% | 33.0%
Expected life | 0.5 years | 0.5 years | 0.5 years


Question: What was the percentage change in expected volatility between 2018 and 2019?
Answer: 5.6
Calculation: 28.6-23.0
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
The information provided below includes one pension plan which is part of discontinued operations. As such, all related liabilities and expenses are reported in discontinued operations in the Company’s Consolidated Balance Sheets and Consolidated Statements of Operations for all periods presented.
The components of net periodic pension benefit cost recognized in our Consolidated Statements of Operations for the periods presented are as follows:
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Service cost | $272 | $841 | $  —
Interest cost | 1,211 | 802 | 809
Expected return on plan assets | (615) | (665) | (597)
Amortization of actuarial gains and losses | 411 | 478 | 503
Net periodic pension cost | $1,279 | $1,456 | $715


Question: What was the change in Amortization of actuarial gains and losses between 2017 and 2018?
Answer: -25
Calculation: 478-503
8. Financing Receivables and Operating Leases
(a) Financing Receivables
Financing receivables primarily consist of lease receivables, loan receivables, and financed service contracts. Lease receivables represent sales-type and direct-financing leases resulting from the sale of Cisco’s and complementary third-party products and are typically collateralized by a security interest in the underlying assets. Lease receivables consist of arrangements with terms of four years on average. Loan receivables represent financing arrangements related to the sale of our hardware, software, and services, which may include additional funding for other costs associated with network installation and integration of our products and services. Loan receivables have terms of three years on average. Financed service contracts include financing receivables related to technical support and advanced services. Revenue related to the technical support services is typically deferred and included in deferred service revenue and is recognized ratably over the period during which the related services are to be performed, which typically ranges from one to three years.
A summary of our financing receivables is presented as follows (in millions):
Table:
July 27, 2019 | Lease Receivables | Loan Receivables | Financed Service Contracts | Total
Gross | $2,367 | $5,438 | $2,369 | $10,174
Residual value | 142 | — | — | 142
Unearned income | (137) | — | — | (137)
Allowance for credit loss | (46) | (71) | (9) | (126)
Total, net  . | $2,326 | $5,367 | $2,360 | $10,053
Reported as: |  |  |  | 
Current . | $1,029 | $2,653 | $1,413 | $5,095
Noncurrent | 1,297 | 2,714 | 947 | 4,958
Total, net  . | $2,326 | $5,367 | $2,360 | $10,053


Question: What was the difference in the reported total between current and noncurrent financing receivables?
Answer: 137
Calculation: 5,095-4,958
Note 20. Income Taxes
The Company’s income before income taxes consisted of the following (in thousands):
Table:
 |  | Years Ended December31, | 
 | 2019 | 2018 | 2017
Domestic (U.S., state and local) | $38,672 | $6,971 | $9,662
Foreign | 47,251 | 49,946 | 71,645
 | $85,923 | $56,917 | $81,307


Question: What was the change in Foreign in 2019 from 2018?
Answer: -2695
Calculation: 47,251-49,946
Stock purchase warrants
Prior to the 2019 Brookfield Transaction, Teekay held 15.5 million common unit warrants (or the Brookfield Transaction Warrants) issued by Altera to Teekay in connection with the 2017 Brookfield Transaction (see Note 4) and 1,755,000 warrants to purchase common units of Altera issued to Teekay in connection with Altera's private placement of Series D Preferred Units in June 2016 (or the Series D Warrants). In May 2019, Teekay sold to Brookfield all of the Company’s remaining interests in Altera, which included, among other things, both the Brookfield Transaction Warrants and Series D Warrants.
Changes in fair value during the years ended December 31, 2019 and 2018 for the Company’s Brookfield Transaction Warrants and the Series D Warrants, which were measured at fair value using significant unobservable inputs (Level 3), are as follows:
Table:
 | Year Ended December 31, | 
 | 2019 | 2018
 | $ | $
Fair value at the beginning of the year | 12,026 | 30,749
Fair value on acquisition/issuance | — | 2,330
Unrealized gain (loss) included in earnings | 26,900 | (21,053)
Realized loss included in earnings | (25,559) | —
Settlements | (13,367) | —
Fair value at the end of the year | — | 12,026


Question: What is the average Fair value on acquisition/issuance?
Answer: 1165
Calculation: (0 + 2,330) / 2
H. Net Income Per Share
Basic net income per share is computed by dividing net income by the weighted-average number of common stock outstanding during the period. Diluted net income per share is computed by dividing net income by the weighted-average number of common stock outstanding and potentially dilutive securities outstanding during the period, as calculated using the treasury stock method. Potentially dilutive securities primarily include unvested restricted stock units (“RSUs”), including PSU awards, and stock options, including purchase options under VMware’s employee stock purchase plan, which included Pivotal’s employee stock purchase plan through the date of acquisition. Securities are excluded from the computation of diluted net income per share if their effect would be anti-dilutive. VMware uses the two-class method to calculate net income per share as both classes share the same rights in dividends; therefore, basic and diluted earnings per share are the same for both classes.
The following table sets forth the computations of basic and diluted net income per share during the periods presented (table in millions, except per share amounts and shares in thousands):
Table:
 |  | For the Year Ended | 
 | January 31, 2020 | February 1, 2019 | February 2, 2018
Net income attributable to VMware, Inc. | $6,412 | $1,650 | $437
Weighted-average shares, basic for Classes A and B | 417,058 | 413,769 | 410,315
Effect of other dilutive securities | 8,177 | 7,362 | 10,572
Weighted-average shares, diluted for Classes A and B | 425,235 | 421,131 | 420,887
Net income per weighted-average share attributable to VMware, Inc. common stockholders, basic for Classes A and B | $15.37 | $3.99 | $1.07
Net income per weighted-average share attributable to VMware, Inc. common stockholders, diluted for Classes A and B | $15.08 | $3.92 | $1.04


Question: What was the Weighted-average shares, basic for Classes A and B in 2019?
Answer: 413,769
( 5 ) we occupy approximately 350000 square feet of the one north end building . ( 6 ) this property is owned by board of trade investment company ( botic ) . kcbt maintains a 51% ( 51 % ) controlling interest in botic . we also lease other office space around the world and have also partnered with major global telecommunications carriers in connection with our telecommunications hubs whereby we place data cabinets within the carriers 2019 existing secured data centers . we believe our facilities are adequate for our current operations and that additional space can be obtained if needed . item 3 . legal proceedings see 201clegal and regulatory matters 201d in note 14 . contingencies to the consolidated financial statements beginning on page 91 for cme group 2019s legal proceedings disclosure which is incorporated herein by reference . item 4 . mine safety disclosures not applicable . part ii item 5 . market for registrant 2019s common equity , related stockholder matters and issuer purchases of equity securities class a common stock our class a common stock is currently listed on nasdaq under the ticker symbol 201ccme . 201d as of february 13 , 2013 , there were approximately 3106 holders of record of our class a common stock . in may 2012 , the company 2019s board of directors declared a five-for-one split of its class a common stock effected by way of a stock dividend to its class a and class b shareholders . the stock split was effective july 20 , 2012 for all shareholders of record on july 10 , 2012 . as a result of the stock split , all amounts related to shares and per share amounts have been retroactively restated . the following table sets forth the high and low sales prices per share of our class a common stock on a quarterly basis , as reported on nasdaq. .

Table:
2012 first quarter | high $ 59.73 | low $ 45.20 | 2011 first quarter | high $ 63.40 | low $ 56.06
second quarter | 58.24 | 50.70 | second quarter | 62.15 | 52.45
third quarter | 59.35 | 49.83 | third quarter | 59.80 | 47.43
fourth quarter | 57.89 | 50.12 | fourth quarter | 59.73 | 45.20
class b common stock our class b common stock is not listed on a national securities exchange or traded in an organized over- the-counter market .
each class of our class b common stock is associated with a membership in a specific division of our cme exchange .
cme 2019s rules provide exchange members with trading rights and the ability to use or lease these trading rights .
each share of our class b common stock can be transferred only in connection with the transfer of the associated trading rights. .

Question: what was the average sales price for the class b common shares in 2012 in the first quarter
Answer: 52.465
Calculation: add(59.73, 45.20), add(#0, const_2), divide(#1, const_2)