hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
The following table shows for the fiscal year ended March 29, 2019, certain information regarding option exercises and stock vested during the last fiscal year with respect to our named executive officers:
Option Exercises and Stock Vested in Fiscal 2019
(1) The value realized upon option exercises is based on the difference between the closing price of our common stock at exercise and the option exercise price.
(2) The number of shares and value realized for stock awards set forth above reflect (i) RSUs that vested and settled in FY19, (ii) RSUs granted under the FY19 EAIP on 5/20/2019, which vested and settled on 6/1/2019, and (iii) PRUs that vested in FY19 and were settled in FY20.
(3) The value realized upon vesting is based on the closing price of our common stock upon vesting in the case of RSUs and the closing price of our common stock on March 29, 2019 in the case of PRUs.
Table:
Option Awards |  |  | Stock Awards | 
Name | Number of Shares Acquired on Exercise (#) | Value Realized on Exercise (1)($)$) | Number of Shares Acquired on Vesting(2) (#) | Value Realized on Vesting (3)($)$)
Gregory S. Clark | — | — | 342,338 | 7,467,791
Nicholas R. Noviello | 332,155 | 4,699,993 | 111,855 | 2,419,818
Amy L. Cappellanti-Wolf | — | — | 92,644 | 1,997,239
Samir Kapuria | — | — | 112,125 | 2,497,640
Scott C. Taylor | — | — | 103,798 | 2,216,595


Question: What does the table show?
Answer: for the fiscal year ended March 29, 2019, certain information regarding option exercises and stock vested during the last fiscal year with respect to our named executive officers
(C.5) Income Taxes
Judgments and Estimates
We are subject to changing tax laws in multiple jurisdictions within the countries in which we operate. Our ordinary business activities also include transactions where the ultimate tax outcome is uncertain due to different interpretations of tax laws, such as those involving revenue sharing and cost reimbursement arrangements between SAP Group entities. In addition, the amount of income taxes we pay is generally subject to ongoing audits by domestic and foreign tax authorities. In determining our worldwide income tax provisions, judgment is involved in assessing whether to consider each uncertain tax treatment separately or together with one or more other uncertain tax treatments and whether to reflect the respective effect of uncertainty based on the most likely amount or the expected value. In applying these judgments, we consider the nature and the individual facts and circumstances of each uncertain tax treatment as well as the specifics of the respective jurisdiction, including applicable tax laws and our interpretation thereof.
The assessment whether a deferred tax asset is impaired requires judgment, as we need to estimate future taxable profits to determine whether the utilization of the deferred tax asset is probable. In evaluating our ability to utilize our deferred tax assets, we consider all available positive and negative evidence, including the level of historical taxable income and projections for future taxable income over the periods in which the deferred tax assets are recoverable. Our judgment regarding future taxable income is based on assumptions about future market conditions and future profits of SAP.
Judgment is also required in evaluating whether interest or penalties related to income taxes meet the definition of income taxes, and, if not, whether it is of financial nature. In this judgment, we particularly consider applicable local tax laws and interpretations on IFRS by national standard setters in the area of group financial reporting.
Tax Expense by Geographic Location
Table:
€ millions | 2019 | 2018 | 2017
Current tax expense |  |  | 
Germany | 625 | 733 | 935
Foreign | 1,153 | 1,019 | 716
Total current tax expense | 1,778 | 1,752 | 1,651
Deferred tax expense/income |  |  | 
Germany | –3 | 57 | –584
Foreign | –549 | –298 | –84
Total deferred tax income | –552 | –241 | –668
Total income tax expense | 1,226 | 1,511 | 983


Question: What are the geographic locations in the table considered when calculating the total current tax expense?
Answer: Germany, Foreign
EBITDA and EBITDA Margin
The following tables set forth EBITDA (in millions) and EBITDA Margin by segment for the periods presented:
Software Solutions
EBITDA was $567.2 million in 2018 compared to $516.5 million in 2017, an increase of $50.7 million, or 10%, with an EBITDA Margin of 59.0%, an increase of 190 basis points from the prior year. The increase was primarily driven by incremental margins on revenue growth.
Data and Analytics
EBITDA was $39.5 million in 2018 compared to $38.4 million in 2017, an increase of $1.1 million, or 3%, with an EBITDA Margin of 25.6%, an increase of 30 basis points from the prior year. The EBITDA Margin increase was primarily driven by incremental margins on revenue growth.
Table:
 | Year ended December 31, |  | Variance | 
 | 2018 | 2017 | $ | %
Software Solutions | $567.2 | $516.5 | $50.7 | 10%
Data and Analytics | 39.5 | 38.4 | 1.1 | 3%


Question: What was increase in EBITDA for Software Solutions?
Answer: 50.7
FINANCIAL EXPENSE
(1) Fiscal 2018 was restated to reclassify results from Cogeco Peer 1 as discontinued operations. For further details, please consult the "Discontinued operations" section.
Fiscal 2019 fourth-quarter financial expense decreased by 15.2% mainly due to: • the reimbursements of $65 million and US$35 million under the Canadian Revolving Facility during the second quarter of fiscal 2019 and of US$328 million during the third quarter of fiscal 2019 following the sale of Cogeco Peer 1; and • lower debt outstanding and interest rates on the First Lien Credit Facilities; party offset by • the appreciation of the US dollar against the Canadian dollar compared to same period of the prior year.
Table:
Three months ended August 31, | 2019 | 2018 (1) | Change
(in thousands of dollars, except percentages) | $ | $ | %
Interest on long-term debt | 41,307 | 46,127 | (10.4)
Net foreign exchange losses (gains) | (403) | 482 | —
Amortization of deferred transaction costs | 464 | 441 | 5.2
Capitalized borrowing costs | (168) | (162) | 3.7
Other | (763) | 821 | —
 | 40,437 | 47,709 | (15.2)


Question: What was the reimbursement in 2019 fourth quarter?
Answer: $65 million and US$35 million
Deferred revenue primarily consists of amounts that have been invoiced but not yet been recognized as revenue and consists of performance obligations pertaining to support and subscription services. During the years ended December 31, 2019 and 2018, we recognized revenue of $63.2 million and $60.2 million, related to deferred revenue at the beginning of the period.
Deferred revenue consisted of the following (in thousands):
Table:
 | December 31, 2019 | December 31, 2018
Deferred revenue: |  | 
Products | $6,593 | $5,216
Services | 94,571 | 92,750
Total deferred revenue | 101,164 | 97,966
Less: current portion | (62,233) | (63,874)
Non-current portion | $38,931 | $34,092


Question: What does deferred revenue refer to?
Answer: Deferred revenue primarily consists of amounts that have been invoiced but not yet been recognized as revenue and consists of performance obligations pertaining to support and subscription services
Pension benefit commitments
For fiscal 2019, Managing Board members were granted contributions under the BSAV totaling € 5.6 million (2018: € 5.4 million), based on a Supervisory Board decision from November 7, 2019. Of this amount, € 0.02 million (2018: € 0.03 million) relates to the funding of pension commitments earned prior to the transfer to the BSAV.
The expense recognized in fiscal 2019 as a service cost under IFRS for Managing Board members’ entitlements under the BSAV in fiscal 2019 totaled € 5.4 million (2018: € 5.3 million).
Contributions under the BSAV are added to the individual pension accounts in the January following each fiscal year. Until pension payments begin, members’ pension accounts are credited with an annual interest payment (guaranteed interest) on January 1 of each year. The interest rate is currently 0.90%.
The following table shows the individualized contributions (allocations) under the BSAV for fiscal 2019 as well as the defined benefit obligations for pension commitments:
In fiscal 2019, former members of the Managing Board and their surviving dependents received emoluments within the meaning of Section 314 para. 1 No. 6 b of the German Commercial Code totaling € 21.09 million (2018: € 39.9 million).
The defined benefit obligation (DBO) of all pension commitments to former members of the Managing Board and their surviving dependents as of September 30, 2019, amounted to €175.7 million (2018: €168.2 million). This figure is included in NOTE 17 in B.6 NOTES TO CONSOLIDATED FINANCIAL STATEMENTS.
1 Deferred compensation totals € 4,125,612 (2018: € 4,115,237), including € 3,703,123 for Joe Kaeser (2018: € 3,694,439), € 361,494 for Klaus Helmrich (2018: € 362,606) and € 60,995 for Prof. Dr. Ralf P. Thomas (2018: € 58,192).
2 In accordance with the provisions of the BSAV, benefits to be paid to Lisa Davis are not in any way secured or funded through the trust associated with the Company’s BSAV plan or with any other trust. They represent only an unsecured, unfunded legal obligation on the part of the Company to pay such benefits in the future under certain conditions, and the payout will only be made from the Company’s general assets.
Table:
 |  | Total contributions for | Defined benefit obligation for all pension commitments excluding deferred compensation 1 | 
(in €) | 2019 | 2018 | 2019 | 2018
Managing Board members in office as of September 30, 2019 |  |  |  | 
Joe Kaeser | 1,234,800 | 1,210,440 | 14,299,267 | 12,970,960
Dr. Roland Busch | 616,896 | 604,800 | 6,071,233 | 5,121,226
Lisa Davis 2 | 616,896 | 604,800 | 5,701,811 | 5,322,537
Klaus Helmrich | 616,896 | 604,800 | 6,473,904 | 5,714,522
Janina Kugel | 616,896 | 604,800 | 2,674,432 | 2,157,427
Cedrik Neike | 616,896 | 604,800 | 2,349,895 | 1,757,258
Michael Sen | 616,896 | 604,800 | 1,862,660 | 1,239,785
Prof. Dr. Ralf P. Thomas | 616,896 | 604,800 | 6,184,498 | 5,235,121
Total | 5,553,072 | 5,444,040 | 45,617,700 | 39,518,836


Question: What was the expense recognized in fiscal 2019 as a service cost under IFRS for Managing Board members’ entitlements amount to?
Answer: € 5.6 million
NOTE 6 - continued
For information on assets provided as collateral security, please refer to note 16. Please refer to note 8 for information on impairment testing.
The depreciation expense related to "Other plant and operating equipment" of USD 1.0m relates to "Administrative expense" (2018: USD 1.1m, 2017: USD 0.9m). Depreciation and impairment losses on tangible fixed assets on "Vessels and capitalized dry-docking" relate to operating expenses.
Table:
USDm | 2019 | 2018 | 2017
Other plant and operating equipment |  |  | 
Cost: |  |  | 
Balance as of 1 January | 5.8 | 3.6 | 2.7
Adjustment on transition to IFRS 16 | 0.3 | - | -
Additions | 2.2 | 2.2 | 1.0
Disposals | -0.2 | - | -0.1
Balance as of 31 December | 8.1 | 5.8 | 3.6
Depreciation: |  |  | 
Balance as of 1 January | 2.8 | 1.7 | 0.9
Disposals | - | - | -0.1
Depreciation for the year | 1.0 | 1.1 | 0.9
Balance as of 31 December | 3.8 | 2.8 | 1.7
Carrying amount as of 31 December | 4.3 | 3.0 | 1.9


Question: What was the change in the carrying amount as of 31 December from 2018 to 2019?
Answer: 1.3
Calculation: 4.3-3.0
ASSUMPTIONS USED IN STOCK OPTION PRICING MODEL
The fair value of options granted was determined using a variation of a binomial option pricing model that takes into account factors specific to the share incentive plans, such as the vesting period. The following table shows the principal assumptions used in the valuation.
Expected dividend growth is commensurate with BCE’s dividend growth strategy. Expected volatility is based on the historical volatility of BCE’s share price. The risk-free rate used is equal to the yield available on Government of Canada bonds at the date of grant with a term equal to the expected life of the options
Table:
 | 2019 | 2018
Weighted average fair value per option granted | $2.34 | $2.13
Weighted average share price | $58 | $57
Weighted average exercise price | $58 | $56
Expected dividend growth | 5% | 5%
Expected volatility | 14% | 12%
Risk-free interest rate | 2% | 2%
Expected life (years) | 4 | 4


Question: In which year is the weighted average share price higher?
Answer: 2019
Calculation: $58>$57
Notes to Consolidated Financial Statements
Operating Leases
The Company leases certain of its corporate, manufacturing and other facilities from multiple third- party real estate developers. The operating leases expire at various dates through 2034, and some of these leases have renewal options, with the longest ranging up to two, ten-year periods. Several of these leases also include market rate rent escalations, rent holidays, and leasehold improvement incentives, all of which are recognized to expense on a straight-line basis. Leasehold improvements made either at the inception of the lease or during the lease term are amortized over the lesser of the remaining life of the lease term (including renewals that are reasonably assured) or the useful life of the asset. The Company also leases various machinery and equipment and office equipment under non-cancelable operating leases. The remaining terms of these operating leases range from less than one year to approximately 15 years.
Rent expense under operating leases, covering facilities and equipment, was approximately $19.3 million, $16.3 million, and $14.8 million for fiscal years 2019, 2018 and 2017, respectively.
Capital Leases
In fiscal 2018, the Company entered into a capital lease for a facility in Beijing, China that will allow the Company to consolidate several leased facilities as well as provide additional manufacturing space. The lease term is expected to commence in fiscal 2021 and therefore is not recorded on the Consolidated Balance Sheet as of March 30, 2019. The lease has an initial term of five years and includes multiple renewal options, with the maximum lease term not to exceed 30 years. The minimum future payments for this lease are included in the table below.
Purchase commitments
The Company’s other purchase commitments include payments due for materials and manufacturing services. The Company also has commitments for the purchase of property and equipment, a substantial majority of which will be due within the next 12 months.
The Company’s minimum payments under non-cancelable leases and purchase commitments as of March 30, 2019, are as follows (in thousands):
Table:
Fiscal Year | Operating Leases | Capital Leases | Purchase Commitments
2020 | $22,207 | $241 | $328,435
2021 | 13,382 | 1,220 | 24,005
2022 | 10,331 | 1,220 | 5,654
2023 | 8,224 | 1,220 | 3,596
2024 | 7,139 | 1,220 | —
Thereafter | 31,598 | 47,258 | —
Total minimum payments | $92,881 | $52,379 | $361,690


Question: What is the company's total operating leases and capital leases in 2020?
Answer: 22448
Calculation: $22,207 + $241
Foreign Currency Translation Impact on Consolidated Financial Results
Since we are a U.S. domiciled company, we translate our foreign currency-denominated financial results into US Dollars. Due to the changes in the value of foreign currencies relative to the US Dollar, translating our financial results from foreign currencies to US Dollars may result in a favorable or unfavorable impact. Historically, the most significant currencies that have impacted the translation of our consolidated financial results are the euro, the Australian dollar, the Mexican peso, the British pound, the Canadian dollar, the Brazilian real and the Chinese Renminbi.
The following table presents the approximate favorable or (unfavorable) impact foreign currency translation had on certain of our consolidated financial results
Table:
(In millions) | 2019 vs. 2018 | 2018 vs. 2017
Net sales | $ (137.2) | $ (43.4)
Cost of sales | 98.4 | 31.7
Selling, general and administrative expenses | 16.3 | 1.0
Net earnings | (15.7) | (8.2)
Non-U.S. GAAP Adjusted EBITDA | (25.3) | (11.1)


Question: What is the total favourable impact foreign currency translation had on certain of their consolidated financial results? 
Answer: 147.4
Calculation: 98.4+31.7+16.3+1.0
The Company recognizes these compensation costs on a straight-line basis over the requisite service period of the award, which is generally the award vesting term of four years. Forfeitures are accounted for as they occur.
Total stock-based compensation cost capitalized in inventory was less than $0.8 million in the years ended December 31, 2019, 2018 and 2017.
As of December 31, 2019, $7.8 million of unrecognized compensation cost related to stock options is expected to be recognized over a weighted-average period of 2.1 years and $41.3 million of unrecognized compensation cost related to unvested RSUs is expected to be recognized over a weighted-average period of 2.2 years. If there are any modifications or cancellations of the underlying unvested awards, the Company may be required to accelerate, increase or cancel all or a portion of the remaining unearned stock-based compensation expense.
The  following  table  sets  forth  the  stock-based  compensation  expense  resulting  from  stock  options,  RSUs,  and  the  ESPP  included  in  the  Company’s consolidated statements of operations:
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (In thousands) | 
Cost of revenue | $2,843 | $2,435 | $1,406
Research and development | 6,532 | 4,283 | 2,968
Sales and marketing | 9,069 | 8,267 | 5,481
General and administrative | 10,693 | 11,476 | 9,114
Total | $29,137 | $26,461 | $18,969


Question: Which year has the highest general and administrative expense?
Answer: 2018
Calculation: 11,476 > 10,693 >  9,114
DESCRIPTION OF THE PLANS
ESP
The ESP is designed to encourage employees of BCE and its participating subsidiaries to own shares of BCE. Each year, employees can choose to have a certain percentage of their eligible annual earnings withheld through regular payroll deductions for the purchase of BCE common shares. In some cases, the employer also will contribute a percentage of the employee’s eligible annual earnings to the plan, up to a specified maximum. Dividends are credited to the participant’s account on each dividend payment date and are equivalent in value to the dividends paid on BCE common shares.
The ESP allows employees to contribute up to 12% of their annual earnings with a maximum employer contribution of 2%.
Employer contributions to the ESP and related dividends are subject to employees holding their shares for a two-year vesting period.
The trustee of the ESP buys BCE common shares for the participants on the open market, by private purchase or from treasury. BCE determines the method the trustee uses to buy the shares.
At December 31, 2019, 4,360,087 common shares were authorized for issuance from treasury under the ESP.
The following table summarizes the status of unvested employer contributions at December 31, 2019 and 2018.
(1) The weighted average fair value of the shares contributed was $60 in 2019 and $55 in 2018.
Table:
NUMBER OF ESP SHARES | 2019 | 2018
Unvested contributions, January 1 | 1,120,426 | 1,039,030
Contributions (1) | 623,705 | 671,911
Dividends credited | 57,083 | 56,926
Vested | (523,359) | (501,089)
Forfeited | (153,657) | (146,352)
Unvested contributions, December 31 | 1,124,198 | 1,120,426


Question: What are the conditions regarding employer contributions to the ESP and related dividends?
Answer: subject to employees holding their shares for a two-year vesting period
The fair value of plan assets, summarized by level within the fair value hierarchy described in Note 20, as of May 27, 2018, was as follows:
Level 1 assets are valued based on quoted prices in active markets for identical securities. The majority of the Level 1 assets listed above include the common stock of both U.S. and international companies, mutual funds, master limited partnership units, and real estate investment trusts, all of which are actively traded and priced in the market.
Level 2 assets are valued based on other significant observable inputs including quoted prices for similar securities, yield curves, indices, etc. Level 2 assets consist primarily of individual fixed income securities where values are based on quoted prices of similar securities and observable market data.
Level 3 assets consist of investments where active market pricing is not readily available and, as such, fair value is estimated using significant unobservable inputs.
Certain assets that are measured at fair value using the NAV (net asset value) per share (or its equivalent) practical expedient have not been classified in the fair value hierarchy. Such investments are generally considered long-term in nature with varying redemption availability. For certain of these investments, with a fair value of approximately $51.0 million as of May 26, 2019, the asset managers have the ability to impose customary redemption gates which may further restrict or limit the redemption of invested funds therein. As of May 26, 2019, funds with a fair value of $4.2 million have imposed such gates.
As of May 26, 2019, we have unfunded commitments for additional investments of $48.3 million in private equity funds and $17.0 million in natural resources funds. We expect unfunded commitments to be funded from plan assets rather than the general assets of the Company.
Notes to Consolidated Financial Statements - (Continued) Fiscal Years Ended May 26, 2019, May 27, 2018, and May 28, 2017 (columnar dollars in millions except per share amounts)
Table:
 | Level 1 | Level 2 | Level 3 | Total
Cash and cash equivalents | $1.0 | $65.0 | $— | $66.0
Equity securities: |  |  |  | 
U.S. equity securities | 319.8 | 124.0 | — | 443.8
International equity securities | 256.5 | 1.0 | — | 257.5
Fixed income securities: |  |  |  | 
Government bonds | — | 1,854.8 | — | 1,854.8
Corporate bonds | — | 4.7 | — | 4.7
Mortgage-backed bonds | — | 9.3 | — | 9.3
Real estate funds | 7.7 | — | — | 7.7
Master limited partnerships | 0.4 | — | — | 0.4
Net receivables for unsettled transactions | 10.9 | — | — | 10.9
Fair value measurement of pension plan assets in the fair value hierarchy | $596.3 | $2,058.8 | $— | $2,655.1
Investments measured at net asset value |  |  |  | 700.0
Total pension plan assets |  |  |  | $3,355.1


Question: What is the proportion (in percentage) of real estate funds and master limited partnerships over the total pension plan assets?
Answer: 0.24
Calculation: (7.7+0.4)/3,355.1
Non-operating income (expense), net
Non-operating income (expense), net, decreased primarily due to the absence of the fiscal 2018 $653 million gain on the divestiture of our WSS and PKI solutions. In addition, our loss from our equity interest received in connection with the divestiture of our WSS and PKI solutions increased $75 million, which was partially offset by a $48 million decrease in interest expense as a result of lower outstanding borrowings due to repayments.
Table:
 | Fiscal Year |  | 
(In millions) | 2019 | 2018 | Variance in Dollars
Interest expense | $(208) | $(256) | $48
Gain on divestiture | — | 653 | (653)
Interest income | 42 | 24 | 18
Loss from equity interest | (101) | (26) | (75)
Foreign exchange loss | (18) | (28) | 10
Other | 13 | 21 | (8)
Total other income (expense), net | $(272) | $388 | $(660)


Question: What is the average Total other income (expense), net for fiscal 2019 and fiscal 2018?
Answer: 58
Calculation: (-272+388)/2