hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
OPERATING EXPENSES
(1) For the three-month period ended August 31, 2019, the average foreign exchange rate used for translation was 1.3222 USD/CDN.
(2) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy as well as to reclassify results from Cogeco Peer 1 as discontinued operations. For further details, please consult the "Accounting policies" and "Discontinued operations" sections.
(3) Fiscal 2019 actuals are translated at the average foreign exchange rate of the comparable period of fiscal 2018 which was 1.3100 USD/CDN.
Fiscal 2019 fourth-quarter operating expenses increased by 1.6% (1.1% in constant currency) mainly from: • additional costs in the American broadband services segment mainly due to higher programming costs, additional headcount to support growth, higher marketing initiatives to drive primary service units growth and the FiberLight acquisition;
Table:
Three months ended August 31, | 2019 (1) | 2018 (2) | Change | Change in constant currency (3) | Foreign exchange impact (3)
(in thousands of dollars, except percentages) | $ | $ | % | % | $
Canadian broadband services | 147,815 | 153,560 | (3.7) | (3.8) | 73
American broadband services | 148,215 | 136,506 | 8.6 | 7.6 | 1,370
Inter-segment eliminations and other | 6,803 | 7,911 | (14.0) | (14.0) | (2)
 | 302,833 | 297,977 | 1.6 | 1.1 | 1,441


Question: What was the increase / (decrease) in the Canadian broadband services from three months ended August 31, 2018 to 2019?
Answer: -5745
Calculation: 147,815 - 153,560
OPERATING AND FINANCIAL RESULTS
(1) For the three-month period ended August 31, 2019, the average foreign exchange rate used for translation was 1.3222 USD/CDN.
(2) Fiscal 2018 was restated to comply with IFRS 15 and to reflect a change in accounting policy as well as to reclassify results from Cogeco Peer 1 as discontinued
operations. For further details, please consult the "Accounting policies" and "Discontinued operations" sections.
(3) Fiscal 2019 actuals are translated at the average foreign exchange rate of the comparable period of fiscal 2018 which was 1.3100 USD/CDN.
Table:
Three months ended August 31, | 2019 (1) | 2018 (2) | Change | Change in constant currency | Foreign exchange impact
(in thousands of dollars, except percentages) | $ | $ | % | % | $
Revenue | 583,673 | 566,184 | 3.1 | 2.7 | 2,427
Operating expenses | 302,833 | 297,977 | 1.6 | 1.1 | 1,441
Management fees – Cogeco Inc. | 5,230 | 4,796 | 9.0 | 9.0 | -
Adjusted EBITDA | 275,610 | 263,411 | 4.6 | 4.3 | 986
Adjusted EBITDA margin | 47.2% | 46.5% |  |  | 


Question: What was the foreign exchange rate used for the three-month period ended 2019?
Answer: 1.3222 USD/CDN.
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
8. ACCRUED EXPENSES
Accrued expenses consisted of the following:
Table:
 | As of | 
 | December 31, 2019 | December 31, 2018
Accrued property and real estate taxes | $198.1 | $169.7
Accrued pass-through costs | 74.2 | 71.2
Amounts payable to tenants | 77.9 | 93.5
Accrued rent | 75.6 | 61.4
Payroll and related withholdings | 102.4 | 90.4
Accrued construction costs | 27.8 | 41.5
Accrued income tax payable | 55.2 | 57.9
Other accrued expenses | 347.0 | 362.7
Accrued expenses | $958.2 | $948.3


Question: What was the percentage change in accrued expenses between 2018 and 2019?
Answer: 1.04
Calculation: ($958.2-$948.3)/$948.3
vornado realty trust notes to consolidated financial statements ( continued ) 10 . redeemable noncontrolling interests - continued redeemable noncontrolling interests on our consolidated balance sheets are recorded at the greater of their carrying amount or redemption value at the end of each reporting period . changes in the value from period to period are charged to 201cadditional capital 201d in our consolidated statements of changes in equity . below is a table summarizing the activity of redeemable noncontrolling interests . ( amounts in thousands ) .

Table:
balance at december 31 2009 | $ 1251628
net income | 55228
distributions | -53515 ( 53515 )
conversion of class a units into common shares at redemption value | -126764 ( 126764 )
adjustment to carry redeemable class a units at redemption value | 191826
redemption of series d-12 redeemable units | -13000 ( 13000 )
other net | 22571
balance at december 31 2010 | 1327974
net income | 55912
distributions | -50865 ( 50865 )
conversion of class a units into common shares at redemption value | -64830 ( 64830 )
adjustment to carry redeemable class a units at redemption value | -98092 ( 98092 )
redemption of series d-11 redeemable units | -28000 ( 28000 )
other net | 18578
balance at december 31 2011 | $ 1160677
redeemable noncontrolling interests exclude our series g convertible preferred units and series d-13 cumulative redeemable preferred units , as they are accounted for as liabilities in accordance with asc 480 , distinguishing liabilities and equity , because of their possible settlement by issuing a variable number of vornado common shares .
accordingly , the fair value of these units is included as a component of 201cother liabilities 201d on our consolidated balance sheets and aggregated $ 54865000 and $ 55097000 as of december 31 , 2011 and 2010 , respectively. .

Question: what was the percentage change in the redeemable noncontrolling interests from 2009 to 2010
Answer: 6.1%
Calculation: subtract(1327974, 1251628), divide(#0, 1251628)
Unearned Revenue
Unearned revenue as of the periods presented consisted of the following (table in millions):
Unearned subscription and SaaS revenue is generally recognized over time as customers consume the services or ratably over the term of the subscription, commencing upon provisioning of the service. Previously, unearned subscription and SaaS revenue was allocated between unearned license revenue and unearned software maintenance revenue in prior periods and has been reclassified to conform with current period presentation.
Unearned software maintenance revenue is attributable to VMware’s maintenance contracts and is generally recognized over time on a ratable basis over the contract duration. The weighted-average remaining contractual term as of January 31, 2020 was approximately two years. Unearned professional services revenue results primarily from prepaid professional services and is generally recognized as the services are performed.
Total billings and revenue recognized during the year ended January 31, 2020, were $8.1 billion and $6.4 billion, respectively, and did not include amounts for performance obligations that were fully satisfied upon delivery, such as on-premise licenses. During the year ended January 31, 2020, VMware assumed $154 million in unearned revenue in the acquisition of Carbon Black, Inc. (“Carbon Black”).
Total billings and revenue recognized during the year ended February 1, 2019, were $6.9 billion and $5.5 billion, respectively, and did not include amounts for performance obligations that were fully satisfied upon delivery, such as on-premise licenses.
Revenue recognized during the year ended February 2, 2018 was $4.8 billion and did not include amounts for performance obligations that were fully satisfied upon delivery, such as on-premise licenses.
Table:
 | January 31, 2020 | February 1, 2019
Unearned license revenue | $19 | $15
Unearned subscription and SaaS revenue | 1,534 | 916
Unearned software maintenance revenue | 6,700 | 5,741
Unearned professional services revenue | 1,015 | 767
Total unearned revenue | $9,268 | $7,439


Question: What was the total billings recognized during the year ended 2020?
Answer: $8.1 billion
Current other investments comprise the following:
The Group invests surplus cash positions across a portfolio of short-term investments to manage liquidity and credit risk whilst achieving suitable returns. These assets do not meet the definition of cash and cash equivalents, but are included in the Group’s net debt based on their liquidity.
Bonds and debt securities includes €955 million (2018: €862 million) of highly liquid German and €941 million (2018: €nil) Japanese government securities; €1,115 million (2018: €1,112 million) of UK government bonds and €1,184 million (2018: 830 million) of other assets both paid as collateral on derivative financial instruments6. Managed investment funds include €5,513 million (2018: €3,087 million) in managed investment funds with liquidity of up to 90 days and €892 million (2018: €804 million) invested in a fund whose underlying securities are supply chain receivables from a diverse range of corporate organisations of which Vodafone is a minority constituent.
Other investments are excluded from net debt based on their liquidity and primarily consist of restricted debt securities including amounts held in qualifying assets by Group insurance companies to meet regulatory requirements.
3 €1,184 million (2018: €830 million) is measured at amortised cost and remaining items are measured at fair value. For €3,011 million (2018: €1,974 million) the valuation basis is level 1 classification, which comprises financial instruments where fair value is determined by unadjusted quoted prices in active markets for identical assets or liabilities. The remaining balance is level 2 classification.
4 Items measured at fair value and the valuation basis is level 2 classification
5 €1,097 million (2018: €487 million) is measured at fair value and the valuation basis is level 1. The remaining items are measured at amortised cost and the carrying amount approximates fair value
Table:
 | 2019 | 2018
 | €m | €m
Included within current assets: |  | 
Short-term investments: |  | 
Bonds and debt securities3 | 4,690 | 4,690
Managed investment funds4 | 6,405 | 3,891
 | 11,095 | 6,870
Other investments5 | 1,917 | 1,925
 | 13,012 | 8,795


Question: What is the change in managed investment funds between 2018 and 2019?
Answer: 2514
Calculation: 6,405-3,891
13. Stock-Based Compensation:
Under the 2014 RSU Plan, we may grant restricted stock units of up to an aggregate of 3,000 units. Each unit converts to one share of the Company’s stock at the
time of vesting. The fair value of RSU awards is determined at the closing market price of the Company’s common stock at the date of grant. For the years ended March
31, 2018 and 2019, there were 292 and 315 awards, respectively, granted from this plan. Restricted stock activity during the year ended 2019 is as follows:
Performance-based awards vest one year after the grant date. Service-based awards vest as to one-third annually with the requisite service periods beginning on
the grant date. Awards are amortized over their respective grade-vesting periods. The total unrecognized compensation costs related to unvested stock awards expected
to be recognized over the vesting period, approximately three years, was $1,476 at March 31, 2019.
We have four fixed stock option plans. Under the 2004 Stock Option Plan, as amended, we may grant options to employees for the purchase of up to an aggregate
of 10,000 shares of common stock. Under the 2004 Non-Employee Directors’ Stock Option Plan, as amended, we may grant options for the purchase of up to an
aggregate of 1,000 shares of common stock. No awards were made under these two plans after August 1, 2013. Under the 2014 Stock Option Plan, we can grant options
to employees for the purchase of up to an aggregate of 10,000 shares of common stock. Under the 2014 Non-Employee Directors’ Stock Option Plan, as amended, we can
grant options to our directors for the purchase of up to an aggregate of 1,000 shares of common stock. Under all plans, the exercise price of each option shall not be less
than the market price of our stock on the date of grant and an option’s maximum term is 10 years. Options granted under the 2004 Stock Option Plan and the 2014 Stock
Option Plan vest as to 25% annually and options granted under the 2004 Non-Employee Directors’ Stock Option Plan and the 2014 Non-Employee Director’s Stock
Option Plan vest as to one-third annually. Requisite service periods related to all plans begin on the grant date. As of March 31, 2019, there were 12,447 shares of
common stock available for future issuance under all of the plans, consisting of options available to be granted and options currently outstanding.
Table:
 | March 31, 2019 | 
 | Number of shares | Weighted-Average Grant Date Fair Value per Share
Non-vested at March 31, 2018 | 358 | $16.27
Granted | 315 | 15.28
Vested | (172) | 16.27
Cancelled and forfeited | (68) | 16.27
Non-vested at March 31, 2019 | 433 | $15.55


Question: What is the number of options granted and vested respectively?
Answer: 315, (172)
Adjusted cash flow
A reconciliation showing the items that bridge between net cash from operating activities as reported under IFRS to an adjusted basis is given below. Adjusted cash from operations is used by the Board to monitor the performance of the Group, with a focus on elements of cashflow, such as Net capital expenditure, which are subject to day to day control by the business.
Adjusted cash conversion in 2019 is 84% (2018: 91%). Cash conversion is calculated as adjusted cash from operations divided by adjusted operating profit.
The adjusted cash flow is included in the Financial Review on page 58.
Table:
 | 2019 | 2018
 | £m | £m
Net cash from operating activities as reported under IFRS | 227.4 | 212.6
Acquisition and disposal costs | 2.5 | 0.2
Net capital expenditure excluding acquired intangibles from acquisitions | (59.0) | (31.5)
Tax paid | 78.4 | 61.6
Repayments of principal under lease liabilities | (11.2) | –
Adjusted cash from operations | 238.1 | 242.9


Question: What does the Board use Adjusted cash from operations for?
Answer: to monitor the performance of the Group, with a focus on elements of cashflow, such as Net capital expenditure, which are subject to day to day control by the business
FRT Term Loan
On October 25, 2019, we entered into a $23.4 million three-year credit facility loan agreement (the "FRT Term Loan") with HSBC Trinkaus & Burkhardt AG, Germany, to fund the acquisition of FRT GmbH, which we acquired on October 9, 2019. See Note 4 for further details of the acquisition.
The FRT Term Loan bears interest at a rate equal to the Euro Interbank Offered Rate ("EURIBOR") plus 1.75 % per annum and will be repaid in quarterly installments of approximately $1.9 million plus interest beginning January 25, 2020.
The obligations under the FRT Term Loan are fully and unconditionally guaranteed by FormFactor, Inc.
The Credit Facility contains negative covenants customary for financing of this type, including covenants that place limitations on the incurrence of additional indebtedness, the creation of liens, the payment of dividends; dispositions; fundamental changes, including mergers and acquisitions; loans and investments; sale leasebacks; negative pledges; transactions with affiliates; changes in fiscal year; sanctions and anti-bribery laws and regulations, and modifications to charter documents in a manner materially adverse to the Lenders.
The FRT Term Loan also contains affirmative covenants and representations and warranties customary for financing of this type.
Future principal and interest payments on our term loans as of December 28, 2019, based on the interest rate in effect at that date were as follows (in thousands):
(1) Represents our minimum interest payment commitments at 1.35% per annum for the FRT Term Loan and 3.71% per annum for the CMI Term Loan.
Table:
 |  | Payments Due In Fiscal Year |  | 
 | 2020 | 2021 | 2022 | Total
Term loans - principal payments | $42,838 | $7,838 | $7,838 | $58,514
Term loans - interest payments(1) | 777 | 155 | 47 | 979
Total | $43,615 | $7,993 | $7,885 | $59,493


Question: What is the change in Term loans - interest payments from Fiscal Year 2021 to 2020?
Answer: -622
Calculation: 155-777
Movement of options during the year ended 30 June 2018:
The weighted average fair value of options granted during the year was nil (2018: nil) as there were none issued during the year.
The weighted average share price for share options exercised during the period was $3.57 (2018: $3.90).
The weighted average remaining contractual life for share options outstanding at the end of the period was 1.68 years (2018: 2.47 years).
The weighted average remaining contractual life for share options outstanding at the end of the period was 1.68 years (2018: 2.47 years).
Table:
Grant Date | Exercise Date | Expiry Date | Exercise Price $ | No. of Options at Beg. of Year | Options Exercised or Lapsed | No. of Options at End of Year
2 Jul 2012 | 2 Jul 2015 | 2 Jul 2017 | 0.92 | 40,000 | (40,000) | -
2 Jul 2013 | 2 Jul 2016 | 30 Sept 2018 1 | 0.92 | 295,000 | (220,000) | 75,000
2 Jul 2014 | 2 Jul 2017 | 2 Jul 2019 | 1.30 | 875,000 | (405,000) | 470,000
2 Jul 2015 | 2 Jul 2018 | 2 Jul 2020 | 2.67 | 1,000,000 | - | 1,000,000
22 Dec 2016 | 31 Aug 2019 | 22 Dec 2021 | 3.59 | 1,323,730 | - | 1,323,730
Total |  |  |  | 3,533,730 | (665,000) | 2,868,730
Weighted average exercise price |  |  |  |  | $1.15 | $2.82


Question: Why was the weighted average fair value of options granted during the year was nil?
Answer: The weighted average fair value of options granted during the year was nil (2018: nil) as there were none issued during the year.
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 is value realized upon option exercises is based on?
Answer: the difference between the closing price of our common stock at exercise and the option exercise price.
3.4 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 financial expense decreased by 5.4% mainly due to:
• the reimbursement at maturity of the Senior Secured Notes Series B on October 1, 2018; • 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
• early reimbursement of the US$400 million Senior Unsecured Notes during the third quarter of fiscal 2018 which resulted in a $6.2 million redemption premium and the write-off of the unamortized deferred transaction costs of $2.5 million; partly offset by • higher interest cost on the First Lien Credit Facilities resulting from the full year impact of the financing of the MetroCast acquisition; and • the appreciation of the US dollar against the Canadian dollar compared to the prior year.
Table:
Years ended August 31, | 2019 | 2018 (1) | Change
(in thousands of dollars, except percentages) | $ | $ | %
Interest on long-term debt | 176,798 | 179,680 | (1.6)
Net foreign exchange gains | (2,744) | (2,134) | 28.6
Amortization of deferred transaction costs | 1,836 | 1,884 | (2.5)
Capitalized borrowing costs | (690) | (2,074) | (66.7)
Other | 302 | 8,100 | (96.3)
 | 175,502 | 185,456 | (5.4)


Question: What was the redemption premium in third quarter of 2018?
Answer: $6.2 million redemption premium
The long-term portion of the Company’s unrecognized tax benefits at March 31, 2019 and 2018 was $622,000 and $619,000, respectively, of which the timing of the resolution is uncertain. As of March 31, 2019 and 2018, $2.5 million and $2.1 million, respectively, of unrecognized tax benefits had been recorded as a reduction to net deferred tax assets.
As of March 31, 2019, the Company’s net deferred tax assets of $6.7 million are subject to a valuation allowance of $6.7 million. It is possible, however, that some months or years may elapse before an uncertain position for which the Company has established a reserve is resolved. A reconciliation of unrecognized tax benefits is as follows:
The unrecognized tax benefit balance as of March 31, 2019 of $599,000 would affect the Company’s effective tax rate if recognized.
Table:
 |  | Year Ended March 31,  | 
 | 2019 | 2018 | 2017
 |  | (In thousands) | 
Unrecognized tax benefits, beginning of period | $2,735 | $2,714 | $2,055
Additions based on tax positions related to current year | 371 | 520 | 730
Additions based on tax positions related to prior years | 13 | — | —
2017 Tax Act and tax rate re-measurement   | — | (499) | —
Reductions based on tax positions related to prior years   | (17) | — | —
Lapses during the current year applicable to statutes of limitations   | — | — | (71)
Unrecognized tax benefits, end of period | $3,102 | $2,735 | $2,714


Question: What is the average Additions based on tax positions related to prior years between 2017-2019?
Answer: 4.33
Calculation: (13 + 0 + 0) / 3
Summarized financial information concerning our segments is shown in the tables below (in millions):
(1) Revenues for Corporate and Other represent deferred revenue purchase accounting adjustments recorded in accordance with GAAP
(2) Operating expenses for Corporate and Other includes equity-based compensation, including certain related payroll taxes, of $51.7 million, $51.4 million and $19.2 million for the years ended December 31, 2019, 2018 and 2017, respectively.
(4) Depreciation and amortization for Corporate and Other primarily represents net incremental depreciation and amortization adjustments associated with the application of purchase accounting recorded in accordance with GAAP.
(6) Receivables from related parties are included in Corporate and Other.
(7) Transition and integration costs primarily consists of legal and professional fees related to the Distribution and transition-related costs following the Distribution.
Table:
 |  |  | Year ended December 31, 2017 |  | 
 | Software Solutions | Data and Analytics | Corporate and Other |  | Total
Revenues | $904.5 | $151.6 | $(4.5) | (1) | $1,051.6
Expenses: |  |  |  |  | 
Operating expenses | 388.0 | 113.2 | 68.3 | (2) | 569.5
Transition and integration costs | — | — | 13.1 | (7) | 13.1
EBITDA | 516.5 | 38.4 | (85.9) |  | 469.0
Depreciation and amortization | 101.2 | 12.8 | 92.5 | (4) | 206.5
Operating income (loss) | 415.3 | 25.6 | (178.4) |  | 262.5
Interest expense, net |  |  |  |  | (57.5)
Other expense, net |  |  |  |  | (12.6)
Earnings before income taxes |  |  |  |  | 192.4
Income tax benefit |  |  |  |  | (61.8)
Net earnings |  |  |  |  | $254.2
Balance sheet data: |  |  |  |  | 
Total assets | $3,223.5 | $304.7 | $127.7 | (6) | $3,655.9
Goodwill | $2,134.7 | $172.1 | $— |  | $2,306.8


Question: What was the difference between Operating expenses and Revenues from Software Solutions?
Answer: 516.5
Calculation: 904.5-388.0