hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
in 2017 , the company granted 440076 shares of restricted class a common stock and 7568 shares of restricted stock units . restricted common stock and restricted stock units generally have a vesting period of two to four years . the fair value related to these grants was $ 58.7 million , which is recognized as compensation expense on an accelerated basis over the vesting period . dividends are accrued on restricted class a common stock and restricted stock units and are paid once the restricted stock vests . in 2017 , the company also granted 203298 performance shares . the fair value related to these grants was $ 25.3 million , which is recognized as compensation expense on an accelerated and straight-lined basis over the vesting period . the vesting of these shares is contingent on meeting stated performance or market conditions . the following table summarizes restricted stock , restricted stock units , and performance shares activity for 2017 : number of shares weighted average grant date fair value .

Table:
 | number of shares | weightedaveragegrant datefair value
outstanding at december 31 2016 | 1820578 | $ 98
granted | 650942 | 129
vested | -510590 ( 510590 ) | 87
cancelled | -401699 ( 401699 ) | 95
outstanding at december 31 2017 | 1559231 | 116
the total fair value of restricted stock , restricted stock units , and performance shares that vested during 2017 , 2016 and 2015 was $ 66.0 million , $ 59.8 million and $ 43.3 million , respectively .
under the espp , eligible employees may acquire shares of class a common stock using after-tax payroll deductions made during consecutive offering periods of approximately six months in duration .
shares are purchased at the end of each offering period at a price of 90% ( 90 % ) of the closing price of the class a common stock as reported on the nasdaq global select market .
compensation expense is recognized on the dates of purchase for the discount from the closing price .
in 2017 , 2016 and 2015 , a total of 19936 , 19858 and 19756 shares , respectively , of class a common stock were issued to participating employees .
these shares are subject to a six-month holding period .
annual expense of $ 0.3 million for the purchase discount was recognized in 2017 , and $ 0.2 million was recognized in both 2016 and 2015 .
non-executive directors receive an annual award of class a common stock with a value equal to $ 100000 .
non-executive directors may also elect to receive some or all of the cash portion of their annual stipend , up to $ 60000 , in shares of stock based on the closing price at the date of distribution .
as a result , 19736 shares , 26439 shares and 25853 shares of class a common stock were issued to non-executive directors during 2017 , 2016 and 2015 , respectively .
these shares are not subject to any vesting restrictions .
expense of $ 2.5 million , $ 2.4 million and $ 2.5 million related to these stock-based payments was recognized for the years ended december 31 , 2017 , 2016 and 2015 , respectively. .

Question: what was the sum of the shares purchase discount from 2015 to 2017 in millions
Answer: 0.7
Calculation: add(0.3, 0.2), add(#0, 0.2)
5. INVESTMENTS
Investments in Marketable Securities
The Company’s investments in available-for-sale marketable securities are made pursuant to its investment policy, which has established guidelines relative to the diversification of the Company’s investments and their maturities, with the principal objective of capital preservation and maintaining liquidity sufficient to meet cash flow requirements.
The following is a summary of investments, including those that meet the definition of a cash equivalent, as of December 31, 2019 (in thousands):
Table:
 | Amortized Cost | Unrealized Gains | Unrealized Losses | Fair Value
Current assets: |  |  |  | 
Cash | $67,818 | $— | $— | $67,818
Cash equivalents: |  |  |  | 
Money market funds | 126,075 | — | — | 126,075
Corporate bonds | 1,000 | — | — | 1,000
Agency bonds | 6,485 | 1 | — | 6,486
Commercial paper | 9,609 | — | (1) | 9,608
Certificates of deposit | 171 | — | — | 171
US treasury securities | 4,749 | — | — | 4,749
Total cash equivalents | 148,089 | 1 | (1) | 148,089
Total cash and cash equivalents | 215,907 | 1 | (1) | 215,907
Short-term investments: |  |  |  | 
Corporate bonds | 103,130 | 110 | (7) | 103,233
Agency bonds | 3,966 | 2 | — | 3,968
US treasury securities | 50,703 | 62 | (1) | 50,764
Commercial paper | 23,827 | 1 | — | 23,828
Certificates of deposit | 3,936 | 2 | (1) | 3,937
Asset-backed securities | 15,837 | 12 | — | 15,849
Total short-term investments | 201,399 | 189 | (9) | 201,579
Long-term investments: |  |  |  | 
Corporate bonds | 19,407 | 12 | (4) | 19,415
US treasury securities | 19,300 | 25 | — | 19,325
Asset-backed securities | 11,693 | 10 | (1) | 11,702
Strategic investments | 9,750 | — | — | 9,750
Total long-term investments | $60,150 | $47 | $(5) | $60,192


Question: What percentage of fair value total cash equivalents consist of agency bonds?
Answer: 4.38
Calculation: (6,485/148,089)
5. Earnings Per Common Share
Basic earnings per common share ("EPS") is based upon the weighted-average number of common shares outstanding during the period.  Diluted EPS reflects the potential dilution that would occur upon issuance of common shares for awards under stock-based compensation plans, or conversion of preferred stock, but only to the extent that they are considered dilutive.
The following table shows the computation of basic and diluted EPS:
In conjunction with the acquisition of Hawaiian Telcom in the third quarter of 2018, the Company issued 7.7 million Common Shares as a part of the acquisition consideration. In addition, the Company granted 0.1 million time-based restricted stock units to certain Hawaiian Telcom employees under the Hawaiian Telcom 2010 Equity Incentive Plan
For the years ended December 31, 2019 and December 31, 2018, the Company had a net loss available to common shareholders and, as a result, all common stock equivalents were excluded from the computation of diluted EPS as their inclusion would have been anti-dilutive.  For the year ended December 31, 2017, awards under the Company’s stock-based compensation plans for common shares of 0.2 million, were excluded from the computation of diluted EPS as their inclusion would have been anti-dilutive.  For all periods presented, preferred stock convertible into 0.9 million common shares was excluded as it was anti-dilutive.
Table:
Year Ended December 31, |  |  | 
(in millions, except per share amounts) | 2019 | 2018 | 2017
Numerator: |  |  | 
Net (loss) income | $(66.6) | $(69.8) | $40.0
Preferred stock dividends | 10.4 | 10.4 | 10.4
Net (loss) income applicable to common shareowners - basic and diluted | $(77.0) | $(80.2) | $29.6
Denominator: |  |  | 
Weighted-average common shares outstanding - basic | 50.4 | 46.3 | 42.2
Stock-based compensation arrangements | — | — | 0.2
Weighted-average common shares outstanding - diluted | 50.4 | 46.3 | 42.4
Basic and diluted net (loss) earnings per common share | ($1.53) | ($1.73) | $0.70


Question: What is the total basic and diluted net (loss) earnings per common share earned between 2017 to 2019?
Answer: -2.56
Calculation: $(1.53)+$(1.73)+$0.70
3. EARNINGS PER SHARE:
Basic earnings per share available to common shareholders is calculated by dividing net income less preferred stock dividend requirements by the weighted average common shares outstanding for each period. Diluted earnings per share available to common shareholders is calculated by dividing income from operations less preferred stock dividend requirements (when anti-dilutive) by the sum of the weighted average common shares outstanding and the weighted average dilutive equity awards.
Table:
 | For Fiscal Years | 
 | 2019 Basic | 2018 Basic
Weighted average common shares outstanding | 597,961 | 660,925
Net income available to common shareholders | $3,202,943 | $3,614,610
Net earnings per share available to common shareholders | $5.36 | $5.47


Question: What is the percentage change in the weighted average basic common shares outstanding between 2018 and 2019?
Answer: -9.53
Calculation: (597,961 - 660,925)/660,925
schedule iii page 6 of 6 host hotels & resorts , inc. , and subsidiaries host hotels & resorts , l.p. , and subsidiaries real estate and accumulated depreciation december 31 , 2017 ( in millions ) ( b ) the change in accumulated depreciation and amortization of real estate assets for the fiscal years ended december 31 , 2017 , 2016 and 2015 is as follows: .

Table:
balance at december 31 2014 | $ 5283
depreciation and amortization | 558
dispositions and other | -148 ( 148 )
depreciation on assets held for sale | -27 ( 27 )
balance at december 31 2015 | 5666
depreciation and amortization | 572
dispositions and other | -159 ( 159 )
depreciation on assets held for sale | -130 ( 130 )
balance at december 31 2016 | 5949
depreciation and amortization | 563
dispositions and other | -247 ( 247 )
depreciation on assets held for sale | 7
balance at december 31 2017 | $ 6272
( c ) the aggregate cost of real estate for federal income tax purposes is approximately $ 10698 million at december 31 , 2017 .
( d ) the total cost of properties excludes construction-in-progress properties. .

Question: what was the net change in millions in the accumulated depreciation and amortization of real estate assets from 2015 to 2016?
Answer: 283
Calculation: subtract(5949, 5666)
Accumulated Other Comprehensive Income
The following table sets forth the amounts reclassified from AOCI into the Consolidated Statements of Operations, and the associated financial statement line item, net of tax, for the periods indicated (in thousands):
(1) Amounts are included in the computation of net periodic benefit pension cost. Refer to Note 9 – “Postretirement and Other Employee Benefits” for additional information.
(2) The portions of AOCI reclassified into earnings during the fiscal years ended August 31, 2019 and 2017 for available for sale securities were due to a restructuring of securities loss and an other than temporary impairments on securities, respectively, and were recorded to restructuring of securities loss and other expense, respectively.
(3) The Company expects to reclassify $17.0 million into earnings during the next twelve months, which will primarily be classified as a component of cost of revenue.
(4) Amounts are net of tax, which are immaterial for the fiscal years ended August 31, 2019 and 2017. The amount for the fiscal year ended August 31, 2018 includes a reduction to income tax expense related to derivative instruments of $14.8 million.
Table:
 |  |  | Fiscal Year Ended August 31, | 
Comprehensive Income Components | Financial Statement Line Item | 2019 | 2018 | 2017
Foreign currency translation adjustment | Operating income | $— | $— | $5,947
Realized losses (gains) on derivative instruments:(3) |  |  |  | 
Foreign exchange contracts | Cost of revenue | 21,982 | (9,379) | 4,799
Interest rate contracts | Interest expense | (1,723) | (13,697) | 3,950
Actuarial loss | (1) | 741 | 1,127 | 1,929
Prior service credit | (1) | (44) | (88) | (138)
Available for sale securities | (2) | 33,333 | — | 10,139
Total amounts reclassified from AOCI(4) |  | $54,289 | $(22,037) | $26,626


Question: What were the Foreign exchange contracts in 2019?
Answer: 21,982
1. 2019 Performance Periods and Performance Goals. For the calendar year 2019, there are four quarterly Performance Periods, ending on March 31, June 30, September 30 and December 31, 2019 (each, a “2019 Performance Period”). For each of the four 2019 Performance Periods, there are two equally weighted (50% each) performance goals (each, a “2019 Performance Goal”): Revenue and Operating Margin (each as defined below). The chart below set forth the Revenue and Operating Margin Performance Goals for the four 2019 Performance Periods.
“Revenue” means as to each of the 2019 Performance Periods, the Company’s net revenues generated from third parties, including both services revenues and product revenues as defined in the Company’s Form 10-K filed for the calendar year ended December 31, 2018. Net revenue is defined as gross sales less any pertinent discounts, refunds or other contra-revenue amounts, as presented on the Company’s press releases reporting its quarterly financial results.
“Operating Margin” means as to each of the 2019 Performance Periods, the Company’s non-GAAP operating income divided by its Revenue. Non-GAAP operating income means the Company’s Revenues less cost of revenues and operating expenses, excluding the impact of stock-based compensation expense, amortization of acquisition related intangibles, legal settlement related charges and as adjusted for certain acquisitions, as presented on the Company’s press releases reporting its quarterly financial results
Table:
2019 Performance Period | Revenue Performance Goal(in millions) | Operating Margin Performance Goal
Q1 | $199.5 | 8.1%
Q2 | $211.7 | 8.3%
Q3 | $227.3 | 9.6%
Q4 | $243.2 | 10.8%


Question: What are the respective operating margin performance goal in Q1 and Q2?
Answer: 8.1%, 8.3%
Note 6: Other Expense, Net
The significant components of other expense, net, were as follows:
Interest income in the year ended June 30, 2019, increased compared to the years ended June 24, 2018, and June 25, 2017, primarily as a result of higher yield. Interest expense in the year ended June 30, 2019, increased compared to the year ended June 24, 2018, primarily due to issuance of the $2.5 billion of senior notes. Interest expense in the year ended June 24, 2018, decreased compared to the year ended June 25, 2017, primarily due to the conversions of 2018 and 2041 Convertible Notes as well as the retirement of the 2018 Convertible Notes in May 2018.
The gain on deferred compensation plan related assets in fiscal years 2019, 2018 and 2017 was driven by an improvement in the fair market value of the underlying funds.
The loss on impairment of investments in the year ended June 24, 2018 was the result of a decision to sell selected investments held in foreign jurisdictions in connection with the Company’s cash repatriation strategy following the December 2017 U.S. tax reform.
Net loss on extinguishment of debt realized in the year ended June 25, 2017, was primarily a result of the special mandatory redemption of the Senior Notes due 2023 and 2026, as well as the termination of the Term Loan Agreement.
Table:
 | June 30, 2019 | June 24, 2018 | June 25, 2017
 |  | (in thousands) | 
Interest income | $98,771 | $85,813 | $57,858
Interest expense | (117,263) | (97,387) | (117,734)
Gains on deferred compensation plan related assets, net | 10,464 | 14,692 | 17,880
Loss on impairment of investments | — | (42,456) | —
Gains (losses) on extinguishment of debt, net | 118 | 542 | (36,252)
Foreign exchange gains (losses), net | 826 | (3,382) | (569)
Other, net | (11,077) | (19,332) | (11,642)
 | $(18,161) | $(61,510) | $(90,459)


Question: What were the reasons for the net loss on extinguishment of debt realized in the year ended June 25, 2017?
Answer: the special mandatory redemption of the Senior Notes due 2023 and 2026, the termination of the Term Loan Agreement
Unbilled receivables are client committed amounts for which revenue recognition precedes billing, and billing is solely subject to the passage of time.
Unbilled receivables are expected to be billed in the future as follows
Table:
(Dollars in thousands) | December 31, 2019 | 
1 year or less | $180,219 | 60%
1-2 years | 91,132 | 30%
2-5 years | 30,604 | 10%
 | $301,955 | 100%


Question: What is the total unbilled receivables due between 1 to 5 years?
Answer: 121736
Calculation: 91,132 + 30,604
ITEM 6. SELECTED FINANCIAL DATA
The following selected consolidated financial data is derived from our Consolidated Financial Statements. As our historical operating results are not necessarily indicative of future operating results, this data should be read in conjunction with the Consolidated Financial Statements and notes thereto, and with Item 7, Management’s Discussion and Analysis of Financial Condition and Results of Operations.
(1) On December 1, 2018, the beginning of our fiscal year 2019, we adopted the requirements of the Financial Accounting Standards Board’s Accounting Standards Update No. 2014-09, Revenue from Contracts with Customers, Topic 606, utilizing the modified retrospective method of transition. Prior period information has not been restated and continues to be reported under the accounting standard in effect for those periods.
(2) As of November 29, 2019, working capital was in a deficit primarily due to the reclassification of our $2.25 billion term loan due April 30, 2020 and $900 million 4.75% senior notes due February 1, 2020 to current liabilities. We intend to refinance our Term Loan and 2020 Notes on or before the due dates.
(3) Our fiscal year is a 52- or 53-week year that ends on the Friday closest to November 30. Fiscal 2016 was a 53-week fiscal year compared with the other periods presented which were 52-week fiscal years.
Table:
(in thousands, except per share amounts and employee data) |  |  | Fiscal Years |  | 
 | 2019(1) | 2018 | 2017 | 2016(3) | 2015
Operations: |  |  |  |  | 
Revenue: | $11,171,297 | $9,030,008 | $7,301,505 | $5,854,430 | $4,795,511
Gross profit | $9,498,577 | $7,835,009 | $6,291,014 | $5,034,522 | $4,051,194
Income before income taxes | $3,204,741 | $2,793,876 | $2,137,641 | $1,435,138 | $873,781
Net income | $2,951,458 | $2,590,774 | $1,693,954 | $1,168,782 | $629,551
Net income per share: |  |  |  |  | 
Basic | $6.07 | $5.28 | $3.43 | $2.35 | $1.26
Diluted | $6.00 | $5.20 | $3.38 | $2.32 | $1.24
Shares used to compute basic net income                                        per share | 486,291 | 490,564 | 493,632 | 498,345 | 498,764
Shares used to compute diluted net income per share | 491,572 | 497,843 | 501,123 | 504,299 | 507,164
Financial position: |  |  |  |  | 
Cash, cash equivalents and short-term investments | $4,176,976 | $3,228,962 | $5,819,774 | $4,761,300 | $3,988,084
Working capital(2) | $(1,696,013) | $555,913 | $3,720,356 | $3,028,139 | $2,608,336
Total assets | $20,762,400 | $18,768,682 | $14,535,556 | $12,697,246 | $11,714,500
Debt, current | $3,149,343 | $— | $— | $— | $—
Debt, non-current | $988,924 | $4,124,800 | $1,881,421 | $1,892,200 | $1,895,259
Stockholders’ equity | $10,530,155 | $9,362,114 | $8,459,869 | $7,424,835 | $7,001,580
Additional data: |  |  |  |  | 
Worldwide employees | 22,634 | 21,357 | 17,973 | 15,706 | 13,893


Question: What was the gross profit margin in 2018?
Answer: 86.77
Calculation: 7,835,009/9,030,008
17 Inventories
The write-down of inventories recognised as an expense during the year in respect of continuing operations was £0.7m (2018: £3.5m). This comprises a cost of £5.1m (2018: £4.8m) to write-down inventory to net realisable value reduced by £4.4m (2018: £1.3m) for reversal of previous write-down reassessed as a result of customer demand.
The value of inventories expected to be recovered after more than 12 months is £13.4m (2018: £11.2m).
There is no material difference between the Statement of Financial Position value of inventories and their replacement cost. None of the inventory has been pledged as security.
Table:
 | 2019 | 2018
 | £m | £m
Raw materials, consumables and components | 72.2 | 53.0
Work in progress | 25.5 | 25.7
Finished goods and goods for resale | 88.2 | 81.9
Total inventories | 185.9 | 160.6


Question: What was the change in total inventories from 2018 to 2019?
Answer: 25.3
Calculation: 185.9-160.6
Property and equipment consist of the following (in thousands):
Depreciation expense was $1.2 million and $1.6 million for the years ended December 31, 2019 and 2018, respectively.
Amortization of capitalized internal-use software and website development costs was $157,000 and $247,000 for the years ended December 31, 2019 and 2018, respectively.
Table:
December 31, |  | 
 | 2019 | 2018
Computer hardware and software | $3,427 | $3,353
Office equipment and office furniture | 8,148 | 7,814
Capitalized internal-use software and website development | 4,390 | 4,383
Leasehold improvements | 6,247 | 6,140
 | 22,212 | 21,690
Less accumulated depreciation and amortization | (19,230) | (17,900)
Total | $2,982 | $3,790


Question: What is the depreciation expense for 2019 and 2018 respectively?
Answer: $1.2 million, $1.6 million
Operating costs
Total Group adjusted operating costs were up $8.3 million or 3.1 per cent in 2019 compared to last year, broadly in line with inflation. The emphasis remained on effective resource allocation and careful cost management. The overall investment in product development was maintained, with continuing focus on high-growth, high-margin areas. Investment in the sales and marketing organisation was targeted on expanding our key account management programme to drive incremental business with our most valuable customers and developing routes to market for our new technologies to a broadening customer base. Administration costs in 2019 reflected an inflationary increase and higher corporate costs, primarily due to CEO transition.
Segmentally, investment continued in Networks & Security, where we see the most near-term opportunities for growth, particularly in relation to 400G high-speed Ethernet and our Positioning business. A new General Manager joined Lifecycle Service Assurance in October and a review is in progress to evolve the business and optimise the organisational structure to expand the customer base and deliver on our growth agenda. Proactive cost management has once again been demonstrated within Connected Devices, where we have seen a decrease in legacy product revenue year-on-year. As stated above, corporate costs in 2019 included costs associated with CEO transition.
Note
1. Before exceptional items, acquisition related costs, acquired intangible asset amortisation and share-based payment amounting to $4.3 million in total (2018 $19.6 million).
Table:
$ million | 2019 | 2018
Product development | 96.5 | 96.9
Selling and marketing | 129.2 | 123.9
Administration1 | 50.0 | 46.6
Adjusted operating costs1 | 275.7 | 267.4
Networks & Security | 158.4 | 148.9
Lifecycle Service Assurance | 70.5 | 70.5
Connected Devices | 38.2 | 40.8
Corporate | 8.6 | 7.2
Adjusted operating costs1 | 275.7 | 267.4


Question: What are the different business segments considered in the operating costs?
Answer: Networks & Security, Lifecycle Service Assurance, Connected Devices, Corporate, Product Development, Selling and Marketing, Administration
19. Net Income per Share
The following table presents the calculation of basic and diluted net income per share (in millions, except per-share amounts):
Employee equity share options, unvested shares, and similar equity instruments granted and assumed by Cisco are treated as potential common shares outstanding in computing diluted earnings per share. Diluted shares outstanding include the dilutive effect of in-the-money options, unvested restricted stock, and restricted stock units. The dilutive effect of such equity awards is calculated based on the average share price for each fiscal period using the treasury stock method. Under the treasury stock method, the amount the employee must pay for exercising stock options and the amount of compensation cost for future service that has not yet recognized are collectively assumed to be used to repurchase shares.
Table:
Years Ended | July 27, 2019 | July 28, 2018 | July 29, 2017
Net income . | $11,621 | $110 | $9,609
Weighted-average shares—basic | 4,419 | 4,837 | 5,010
Effect of dilutive potential common shares | 34 | 44 | 39
Weighted-average shares—diluted . | 4,453 | 4,881 | 5,049
Net income per share—basic . | $2.63 | $0.02 | $1.92
Net income per share—diluted | $2.61 | $0.02 | $1.90
Antidilutive employee share-based awards, excluded | 55 | 61 | 136


Question: What was the basic net income per share in 2018?
Answer: 0.02