hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
the following table illustrates the pro forma effect on net income and earnings per share as if all outstanding and unvested stock options in 2005 were accounted for using estimated fair value . 2005year ended december 31 .

Table:
year ended december 31, | 2005
( in millions except per share amounts ) | 
net income as reported | $ 838
add : stock option compensation expense included in reported net income net of related taxes | 20
deduct : total stock option compensation expense determined under fair value method for all awards net of related taxes | -27 ( 27 )
pro forma net income | $ 831
earnings per share: | 
basic 2014as reported | $ 2.53
basic 2014pro forma | 2.51
diluted 2014as reported | 2.50
diluted 2014pro forma | 2.48
basic earnings per share is calculated by dividing net income available to common shareholders by the weighted-average number of common shares outstanding for the period , which excludes unvested shares of restricted stock .
diluted earnings per share is calculated by dividing net income available to common shareholders by the weighted-average number of common shares outstanding for the period and the shares representing the dilutive effect of stock options and awards and other equity-related financial instruments .
the effect of stock options and restricted stock outstanding is excluded from the calculation of diluted earnings per share in periods in which their effect would be antidilutive .
special purpose entities : we are involved with various legal forms of special purpose entities , or spes , in the normal course of our business .
we use trusts to structure and sell certificated interests in pools of tax-exempt investment-grade assets principally to our mutual fund customers .
these trusts are recorded in our consolidated financial statements .
we transfer assets to these trusts , which are legally isolated from us , from our investment securities portfolio at adjusted book value .
the trusts finance the acquisition of these assets by selling certificated interests issued by the trusts to third-party investors .
the investment securities of the trusts are carried in investments securities available for sale at fair value .
the certificated interests are carried in other short-term borrowings at the amount owed to the third-party investors .
the interest revenue and interest expense generated by the investments and certificated interests , respectively , are recorded in net interest revenue when earned or incurred. .

Question: what is the diluted number of outstanding shares based on the eps , ( in millions ) ?
Answer: 335.2
Calculation: divide(838, 2.50)
ADJUSTED EBITDA AND ADJUSTED EBITDA MARGIN
The terms adjusted EBITDA and adjusted EBITDA margin do not have any standardized meaning under IFRS. Therefore, they are unlikely to be comparable to similar measures presented by other issuers.
We define adjusted EBITDA as operating revenues less operating costs as shown in BCE’s consolidated income statements. Adjusted EBITDA for BCE’s segments is the same as segment profit as reported in Note 3, Segmented information, in BCE’s 2019 consolidated financial statements. We define adjusted EBITDA margin as adjusted EBITDA divided by operating revenues.
We use adjusted EBITDA and adjusted EBITDA margin to evaluate the performance of our businesses as they reflect their ongoing profitability. We believe that certain investors and analysts use adjusted EBITDA to measure a company’s ability to service debt and to meet other payment obligations or as a common measurement to value companies in the telecommunications industry. We believe that certain investors and analysts also use adjusted EBITDA and adjusted EBITDA margin to evaluate the performance of our businesses. Adjusted EBITDA is also one component in the determination of short-term incentive compensation for all management employees.
Adjusted EBITDA and adjusted EBITDA margin have no directly comparable IFRS financial measure. Alternatively, the following table provides a reconciliation of net earnings to adjusted EBITDA.
Table:
 | 2019 | 2018
Net earnings | 3,253 | 2,973
Severance, acquisition and other costs | 114 | 136
Depreciation | 3,496 | 3,145
Amortization | 902 | 869
Finance costs |  | 
Interest expense | 1,132 | 1,000
Interest on post-employment benefit obligations | 63 | 69
Other expense | 13 | 348
Income taxes | 1,133 | 995
Adjusted EBITDA | 10,106 | 9,535
BCE operating revenues | 23,964 | 23,468
Adjusted EBITDA margin | 42.2% | 40.6%


Question: What is the percentage of interest expense of finance costs in 2018?
Answer: 93.55
Calculation: 1,000/(1,000+69)
Statements of cash flows additional information (in millions):
Non-cash investing and financing activities and supplemental cash flow information are as follows:
Table:
 |  | Year Ended | 
 | April 26, 2019 | April 27, 2018 | April 28, 2017
Non-cash Investing and Financing Activities: |  |  | 
Capital expenditures incurred but not paid | $ 9 | $ 24 | $ 19
Non-cash extinguishment of sale-leaseback financing obligations | $ — | $ 130 | $ 19
Supplemental Cash Flow Information: |  |  | 
Income taxes paid, net of refunds | $ 205 | $ 87 | $ 102
Interest paid | $ 53 | $ 58 | $ 44


Question: What was the change in capital expenditures incurred but not paid between 2017 and 2018?
Answer: 5
Calculation: 24-19
Earnings Per Share
Calculations of net income per common share attributable to ON Semiconductor Corporation are as follows (in millions, except per share data):
Basic income per common share is computed by dividing net income attributable to ON Semiconductor Corporation by the weighted average number of common shares outstanding during the period.
To calculate the diluted weighted-average common shares outstanding, the number of incremental shares from the assumed exercise of stock options and assumed issuance of shares relating to RSUs is calculated by applying the treasury stock method. Share-based awards whose impact is considered to be anti-dilutive under the treasury stock method were excluded from the diluted net income per share calculation.
The excluded number of anti-dilutive share-based awards was approximately 0.8 million, 0.6 million and 0.2 million for the years ended December 31, 2019, 2018 and 2017, respectively.
The dilutive impact related to the Company’s 1.00% Notes and 1.625% Notes is determined in accordance with the net share settlement requirements, under which the Company’s convertible notes are assumed to be convertible into cash up to the par value, with the excess of par value being convertible into common stock.
Additionally, if the average price of the Company’s common stock exceeds $ 25.96 per share, with respect to the 1.00% Notes, or $30.70 per share, with respect to the 1.625% Notes, during the relevant reporting period, the effect of the additional potential shares that may be issued related to the warrants that were issued concurrently with the issuance of the convertible notes will also be included in the calculation of diluted weighted-average common shares outstanding.
Prior to conversion, the convertible note hedges are not considered for purposes of the earnings per share calculations, as their effect would be anti-dilutive. Upon conversion, the convertible note hedges are expected to offset the dilutive effect of the 1.00% Notes and 1.625% Notes, respectively, when the stock price is above $18.50 per share, with respect to the 1.00% Notes, and $20.72 per share, with respect to the 1.625% Notes.
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Net income attributable to ON Semiconductor Corporation | $211.7 | $627.4 | $810.7
Basic weighted average common shares outstanding | 410.9 | 423.8 | 421.9
Add: Incremental shares for: |  |  | 
Dilutive effect of share-based awards | 1.9 | 4.3 | 5.5
Dilutive effect of convertible notes | 3.2 | 7.8 | 0.9
Diluted weighted average common shares outstanding | 416.0 | 435.9 | 428.3
Net income per common share attributable to ON Semiconductor Corporation: |  |  | 
Basic | $0.52 | $1.48 | $1.92
Diluted | $0.51 | $1.44 | $1.89


Question: How is Basic income per common share computed?
Answer: dividing net income attributable to ON Semiconductor Corporation by the weighted average number of common shares outstanding during the period.
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
17. OTHER OPERATING EXPENSE
Other operating expense consists primarily of impairment charges, net losses on sales or disposals of assets and other operating expense items. The Company records impairment charges to write down certain assets to their net realizable value after an indicator of impairment is identified and subsequent analysis determines that the asset is either partially recoverable or not recoverable. These assets consisted primarily of towers and related assets, which are typically assessed on an individual basis, network location intangibles, which relate directly to towers, and tenant-related intangibles, which are assessed on a tenant basis. Net losses on sales or disposals of assets primarily relate to certain non-core towers, other assets and miscellaneous items. Other operating expenses includes acquisition-related costs and integration costs.
Impairment charges included the following for the years ended December 31,:
(1) For the year ended December 31, 2018, impairment charges on tower and network location intangible assets included $258.3 million in India primarily related to carrier consolidation-driven churn events. In addition, the Company fully impaired the tenant relationship for Aircel Ltd., which resulted in an impairment charge of $107.3 million.
(2) During the year ended December 31, 2017, $81.0 million of impairment charges on tower and network location intangible assets and all impairment charges on tenant relationships were related to carrier consolidation-driven churn in India.
(3) For the year ended December 31, 2019, amount includes impairment charges related to right-of-use assets and land easements.
Table:
 | 2019 | 2018 (1) | 2017 (2)
Tower and network location intangible assets | $77.4 | $284.9 | $108.7
Tenant relationships | — | 107.3 | 100.1
Other (3) | 16.8 | 1.8 | 2.6
Total impairment charges | $94.2 | $394.0 | $211.4


Question: What were the Tower and network location intangible assets in 2019?
Answer: $77.4
Acquisition of AFP
On August 1, 2018, the Company acquired AFP, Inc., a privately held fabricator of foam, corrugated, molded pulp and wood packaging solutions, to join its Product Care division. This acquisition expands our protective packaging offerings in the electronic, transportation and industrial markets with custom engineered applications. We acquired 100% of AFP shares for an estimated consideration of $74.1 million, excluding $3.3 million of cash acquired.
The following table summarizes the consideration transferred to acquire AFP and the final allocation of the purchase price among the assets acquired and liabilities assumed.
Table:
 | Preliminary | Measurement | 
 | Allocation | Period | Final Allocation
(In millions) | As of August 1, 2018 | Adjustments | As of September 30, 2019
Total consideration transferred | $ 70.8 | $ 3.3 | $ 74.1
Assets: |  |  | 
Cash and cash equivalents | 2.9 | 0.4 | 3.3
Trade receivables, net | 30.8 | — | 30.8
Inventories, net | 7.1 | — | 7.1
Prepaid expenses and other current assets | 0.7 | — | 0.7
Property and equipment, net | 3.5 | (0.4) | 3.1
Identifiable intangible assets, net | 18.6 | 0.7 | 19.3
Goodwill | 21.6 | 1.0 | 22.6
Other non-current assets | 0.7 | (0.4) | 0.3
Total assets | $ 85.9 | $ 1.3 | $ 87.2
Liabilities: |  |  | 
Current portion of long-term debt | — | 0.1 | 0.1
Accounts payable | 13.8 | (2.2) | 11.6
Other current liabilities | 1.3 | (0.1) | 1.2
Long-term debt, less current portion | — | 0.2 | 0.2
Total liabilities | $ 15.1 | $ (2.0) | $ 13.1


Question: What does this table show?
Answer: The following table summarizes the consideration transferred to acquire AFP and the final allocation of the purchase price among the assets acquired and liabilities assumed.
xii. Shareholding as on March 31, 2019:
a. Distribution of equity shareholding as on March 31, 2019:
Table:
Number of shares | Holding | Percentage to capital | Number of accounts | Percentage to total accounts
1 - 100 | 18,402,438 | 0.5 | 528,148 | 70.3
101 - 500 | 37,550,103 | 1.0 | 185,200 | 24.6
501 - 1000 | 14,900,327 | 0.4 | 20,749 | 2.8
1001 - 5000 | 27,199,737 | 0.7 | 13,897 | 1.9
5001 - 10000 | 9,150,929 | 0.2 | 1,292 | 0.2
10001 - 20000 | 8,811,580 | 0.2 | 622 | 0.1
20001 - 30000 | 5,636,878 | 0.2 | 230 | -
30001 - 40000 | 5,424,479 | 0.1 | 154 | -
40001- 50000 | 4,808,196 | 0.1 | 106 | -
50001 -100000 | 21,790,964 | 0.6 | 304 | -
100001 - above | 3,598,709,075 | 96.0 | 903 | 0.1
GRAND TOTAL | 3,752,384,706 | 100.0 | 751,605 | 100.0


Question: Excluding shareholding of 100001 shares and above, what is the percentage to capital of the rest? 
Answer: 4
Calculation: 100-96
the containerboard group ( a division of tenneco packaging inc. ) notes to combined financial statements ( continued ) april 11 , 1999 14 . leases ( continued ) to the sale transaction on april 12 , 1999 . therefore , the remaining outstanding aggregate minimum rental commitments under noncancelable operating leases are as follows : ( in thousands ) .

Table:
remainder of 1999 | $ 7606
2000 | 7583
2001 | 4891
2002 | 3054
2003 | 1415
thereafter | 1178
total | $ 25727
15 .
sale of assets in the second quarter of 1996 , packaging entered into an agreement to form a joint venture with caraustar industries whereby packaging sold its two recycled paperboard mills and a fiber recycling operation and brokerage business to the joint venture in return for cash and a 20% ( 20 % ) equity interest in the joint venture .
proceeds from the sale were approximately $ 115 million and the group recognized a $ 50 million pretax gain ( $ 30 million after taxes ) in the second quarter of 1996 .
in june , 1998 , packaging sold its remaining 20% ( 20 % ) equity interest in the joint venture to caraustar industries for cash and a note of $ 26000000 .
the group recognized a $ 15 million pretax gain on this transaction .
at april 11 , 1999 , the balance of the note with accrued interest is $ 27122000 .
the note was paid in june , 1999 .
16 .
subsequent events on august 25 , 1999 , pca and packaging agreed that the acquisition consideration should be reduced as a result of a postclosing price adjustment by an amount equal to $ 20 million plus interest through the date of payment by packaging .
the group recorded $ 11.9 million of this amount as part of the impairment charge on the accompanying financial statements , representing the amount that was previously estimated by packaging .
pca intends to record the remaining amount in september , 1999 .
in august , 1999 , pca signed purchase and sales agreements with various buyers to sell approximately 405000 acres of timberland .
pca has completed the sale of approximately 260000 of these acres and expects to complete the sale of the remaining acres by mid-november , 1999. .

Question: of the post-closing price adjustment of $ 20 million plus interest , what percentage was recognized as part of the impairment charge on the accompanying financial statements?
Answer: 59.5%
Calculation: divide(11.9, 20)
Option Exercises and Stock Vested in Fiscal 2019
The following table sets forth certain details with respect to each of the Named Executive Officers concerning the exercise of stock options and vesting of stock in Fiscal 2019:
(1) “Value realized on exercise” is the excess of the market price, at date of exercise, of the shares underlying the options over the exercise price of the options.
(2) “Value realized on vesting” is the market price of the underlying Common Shares on the vesting date.
(3) Relates to the vesting of PSUs and RSUs under our Fiscal 2018 LTIP.
Table:
 | Option Awards |  | Stock Awards (3) | 
Name | Number of Shares Acquired on Exercise (#) | Value Realized on Exercise(1) ($) | Number of Shares Acquired on Vesting (#) | Value Realized on Vesting(2) ($)
Mark J. Barrenechea | 135,208 | $2,801,023 | 65,820 | $7,625,905
Madhu Ranganathan | — | $— | — | $—
Muhi Majzoub | 100,000 | $2,592,411 | 10,900 | $1,263,646
Gordon A. Davies | — | $— | 12,840 | $1,486,870
Simon Harrison | 26,504 | $714,495 | 8,980 | $346,808


Question: What does this table represent?
Answer: certain details with respect to each of the Named Executive Officers concerning the exercise of stock options and vesting of stock in Fiscal 2019
Note 21 Debt due within one year
(1) Includes commercial paper of $1,502 million in U.S. dollars ($1,951 million in Canadian dollars) and $2,314 million in U.S. dollars ($3,156 million in Canadian dollars) as at December 31, 2019 and December 31, 2018, respectively, which were issued under our U.S. commercial paper program and have been hedged for foreign currency fluctuations through forward currency contracts. See Note 26, Financial and capital management, for additional details.
(2) Included in long-term debt due within one year is the current portion of lease liabilities of $775 million as at December 31, 2019 and the current portion of finance leases of $466 million as at December 31, 2018.
Table:
FOR THE YEAR ENDED DECEMBER 31 | NOTE | WEIGHTED AVERAGE INTEREST RATE AT DECEMBER 31, 2019 | 2019 | 2018
Notes payable (1) | 26 | 2.03% | 1,994 | 3,201
Loans secured by trade receivables | 26 | 2.71% | 1,050 | 919
Long-term debt due within one year (2) | 22 | 4.77% | 837 | 525
Total debt due within one year |  |  | 3,881 | 4,645


Question: What is the difference in the weighted average interest rate for notes payable and loans secured by trade receivables?
Answer: 0.68
Calculation: 2.71%-2.03%
(d) Share-Based Awards Available for Grant
A summary of share-based awards available for grant is as follows (in millions):
For each share awarded as restricted stock or a restricted stock unit award under the 2005 Plan, 1.5 shares was deducted from the available share-based award balance. For restricted stock units that were awarded with vesting contingent upon the achievement of future financial performance or market-based metrics, the maximum awards that can be achieved upon full vesting of such awards were reflected in the preceding table.
Table:
Years Ended | July 27, 2019 | July 28, 2018 | July 29, 2017
Balance at beginning of fiscal year | 245 | 272 | 242
Restricted stock, stock units, and other share-based awards granted | (67) | (70) | (76)
Share-based awards canceled/forfeited/expired | 18 | 18 | 78
Shares withheld for taxes and not issued | 23 | 25 | 28
Other | 1 | — | —
Balance at end of fiscal year | 220 | 245 | 272


Question: What was the amount of Other share-based awards in 2019?
Answer: 1
Contractual Obligations
The following table summarizes the payments due by fiscal year for our outstanding contractual obligations as of June 30, 2019:
(a) Refer to Note 11 – Debt of the Notes to Financial Statements.
(b) Refer to Note 7 – Property and Equipment of the Notes to Financial Statements.
(c) Refer to Note 15 – Leases of the Notes to Financial Statements.
(d) Refer to Note 12 – Income Taxes of the Notes to Financial Statements.
(e) Amounts represent purchase commitments, including open purchase orders and take-or-pay contracts that are not presented as construction commitments above.
(f) We have excluded long-term tax contingencies, other tax liabilities, and deferred income taxes of $14.2 billion from the amounts presented as the timing of these obligations is uncertain. We have also excluded unearned revenue and non-cash items.
Table:
(In millions) | 2020 | 2021-2022 | 2023-2024 | Thereafter | Total
Long-term debt: (a) |  |  |  |  | 
Principal payments | $ 5,518 | $ 11,744 | $ 8,000 | $ 47,519 | $ 72,781
Interest payments | 2,299 | 4,309 | 3,818 | 29,383 | 39,809
Construction commitments (b) | 3,443 | 515 | 0 | 0 | 3,958
Operating leases, including imputed interest (c) | 1,790 | 3,144 | 2,413 | 3,645 | 10,992
Finance leases, including imputed interest (c) | 797 | 2,008 | 2,165 | 9,872 | 14,842
Transition tax (d) | 1,180 | 2,900 | 4,168 | 8,155 | 16,403
Purchase commitments (e) | 17,478 | 1,185 | 159 | 339 | 19,161
Other long-term liabilities (f) | 0 | 72 | 29 | 324 | 425
Total | $  32,505 | $  25,877 | $  20,752 | $  99,237 | $  178,371


Question: What is the percentage change in interest payments from 2020 to 2021-2022?
Answer: 87.43
Calculation: (4,309-2,299)/2,299
NOTE L – INCOME TAXES
On December 22, 2017, the U.S. government enacted comprehensive tax legislation commonly referred to as the Tax Cuts and Jobs Act (the “Tax Act”). The Tax Act makes broad and complex changes to the U.S. tax code, including, but not limited to, the following that impact the Company: (1) reducing the U.S. federal corporate income tax rate from 35 percent to 21 percent; (2) eliminating the corporate alternative minimum tax; (3) creating a new limitation on deductible interest expense; (4) limiting the deductibility of certain executive compensation; and (5) limiting certain other deductions.
The Company follows ASC 740-10 “Income Taxes” which requires the recognition of deferred tax liabilities and assets for the expected future tax consequences of events that have been included in the financial statement or tax returns. Under this method, deferred tax liabilities and assets are determined based on the difference between financial statements and tax bases of assets and liabilities using enacted tax rates in effect for the year in which the differences are expected to reverse.
Deferred income taxes include the net tax effects of net operating loss (NOL) carry forwards and the temporary differences between the carrying amounts of assets and liabilities for financial reporting purposes and the amounts used for income tax purposes. Significant components of the Company's deferred tax assets are as follows:
Table:
 | 2019 | 2018
Deferred Tax Assets: |  | 
Net operating loss carry forwards | $20,772,428 | $20,342,559
Intangibles | 207,618 | 318,178
Credits | 28,022 | 112,086
Other | 506,349 | 613,202
Total deferred tax assets | 21,514,417 | 21,386,025
Deferred Tax Liabilities: |  | 
Intangibles | – | –
Total deferred tax liabilities | – | –
Valuation allowance | (21,486,396) | (21,386,025)
Net deferred tax asset | $28,021 | $–


Question: What do the income taxes include?
Answer: net tax effects of net operating loss (NOL) carry forwards and the temporary differences between the carrying amounts of assets and liabilities for financial reporting purposes and the amounts used for income tax purposes
Deferred contract costs are classified as current or non-current within prepaid expenses and other, and other assets – net, respectively. The balances of deferred contract costs as of December 31, 2019 and 2018, included in the balance sheet were as follows:
For the years ended December 31, 2019 and 2018, the Partnership recognized expense of $3,757 and $2,740, respectively associated with the amortization of deferred contract costs, primarily within selling, general and administrative expenses in the statements of income.
Deferred contract costs are assessed for impairment on an annual basis. An impairment charge is recognized to the extent the carrying amount of a deferred cost exceeds the remaining amount of consideration expected to be received in exchange for the goods and services related to the cost, less the expected costs related directly to providing those goods and services that have not yet been recognized as expenses. There have been no impairment charges recognized for the year ended December 31, 2019 and 2018.
Table:
 | 2019 | 2018
Assets |  | 
Prepaid expenses and other | $ 3,481 | $ 2,921
Other assets - net | 2,016 | 2,193
Total | $ 5,497 | $ 5,114


Question: What was the increase / (decrease) in the prepaid expenses and other assets from 2018 to 2019?
Answer: 560
Calculation: 3,481 - 2,921