hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
14. STOCK-BASED COMPENSATION
Summary of Stock-Based Compensation Plans—The Company maintains equity incentive plans that provide for the grant of stock-based awards to its directors, officers and employees. The 2007 Equity Incentive Plan, as amended (the “2007 Plan”), provides for the grant of non-qualified and incentive stock options, as well as restricted stock units, restricted stock and other stock-based awards. Exercise prices for non-qualified and incentive stock options are not less than the fair value of the underlying common stock on the date of grant. Equity awards typically vest ratably, generally over four years for RSUs and stock options and three years for PSUs. Stock options generally expire 10 years from the date of grant. As of December 31, 2019, the Company had the ability to grant stock-based awards with respect to an aggregate of 7.0 million shares of common stock under the 2007 Plan. In addition, the Company maintains an employee stock purchase plan (the “ESPP”) pursuant to which eligible employees may purchase shares of the Company’s common stock on the last day of each bi-annual offering period at a 15% discount from the lower of the closing market value on the first or last day of such offering period. The offering periods run from June 1 through November 30 and from December 1 through May 31 of each year.
During the years ended December 31, 2019, 2018 and 2017, the Company recorded and capitalized the following stock-based compensation expenses:
Table:
 | 2019 | 2018 | 2017
Stock-based compensation expense - Property | $1.8 | $2.4 | $2.1
Stock-based compensation expense - Services | 1.0 | 0.9 | 0.8
Stock-based compensation expense - SG&A | 108.6 | 134.2 | 105.6
Total stock-based compensation expense | $111.4 | $137.5 | $108.5
Stock-based compensation expense capitalized as property and equipment | $1.6 | $2.0 | $1.6


Question: What was the percentage change in Total stock-based compensation expense between 2018 and 2019?
Answer: -18.98
Calculation: ($111.4-$137.5)/$137.5
entergy louisiana , llc management's financial discussion and analysis net revenue 2008 compared to 2007 net revenue consists of operating revenues net of : 1 ) fuel , fuel-related expenses , and gas purchased for resale , 2 ) purchased power expenses , and 3 ) other regulatory charges . following is an analysis of the change in net revenue comparing 2008 to 2007 . amount ( in millions ) .

Table:
 | amount ( in millions )
2007 net revenue | $ 991.1
retail electric price | -17.1 ( 17.1 )
purchased power capacity | -12.0 ( 12.0 )
net wholesale revenue | -7.4 ( 7.4 )
other | 4.6
2008 net revenue | $ 959.2
the retail electric price variance is primarily due to the cessation of the interim storm recovery through the formula rate plan upon the act 55 financing of storm costs and a credit passed on to customers as a result of the act 55 storm cost financing , partially offset by increases in the formula rate plan effective october 2007 .
refer to "hurricane rita and hurricane katrina" and "state and local rate regulation" below for a discussion of the interim recovery of storm costs , the act 55 storm cost financing , and the formula rate plan filing .
the purchased power capacity variance is due to the amortization of deferred capacity costs effective september 2007 as a result of the formula rate plan filing in may 2007 .
purchased power capacity costs are offset in base revenues due to a base rate increase implemented to recover incremental deferred and ongoing purchased power capacity charges .
see "state and local rate regulation" below for a discussion of the formula rate plan filing .
the net wholesale revenue variance is primarily due to provisions recorded for potential rate refunds related to the treatment of interruptible load in pricing entergy system affiliate sales .
gross operating revenue and , fuel and purchased power expenses gross operating revenues increased primarily due to an increase of $ 364.7 million in fuel cost recovery revenues due to higher fuel rates offset by decreased usage .
the increase was partially offset by a decrease of $ 56.8 million in gross wholesale revenue due to a decrease in system agreement rough production cost equalization credits .
fuel and purchased power expenses increased primarily due to increases in the average market prices of natural gas and purchased power , partially offset by a decrease in the recovery from customers of deferred fuel costs. .

Question: what is the percent change in net revenue between 2007 and 2008?
Answer: -34.3%
Calculation: subtract(959.2, 991.1), divide(#0, 991.1)
3.2 Capital risk management
The Group’s objectives on managing capital are to safeguard the Group’s ability to continue as a going concern and support the sustainable growth of the Group in order to provide returns for shareholders and benefits for other stakeholders and to maintain an optimal capital structure to enhance shareholders’ value in the long term.
Capital refers to equity and external debts (including borrowings and notes payable). In order to maintain or adjust the capital structure, the Group may adjust the amount of dividends paid to shareholders, return capital to shareholders, issue new shares, repurchase the Company’s shares or raise/repay debts.
The Group monitors capital by regularly reviewing debts to adjusted earnings before interest, tax, depreciation and amortisation (“EBITDA”) (Note) ratio, being the measure of the Group’s ability to pay off all debts that reflects financial health and liquidity position. The total debts/adjusted EBITDA ratio calculated by dividing the total debts by adjusted EBITDA is as follows:
Note: Adjusted EBITDA represents operating profit less interest income and other gains/(losses), net, and adding back depreciation of property, plant and equipment, investment properties as well as right-of-use assets, amortisation of intangible assets and equitysettled share-based compensation expenses.
Table:
 | As at 31 December | 
 | 2019 | 2018
 | RMB’Million | RMB’Million
Borrowings (Note 35) | 126,952 | 114,271
Notes payable (Note 36) | 93,861 | 65,018
Total debts | 220,813 | 179,289
Adjusted EBITDA (Note) | 147,395 | 118,273
Total debts/Adjusted EBITDA ratio | 1.50 | 1.52


Question: How much did borrowings change from 2018 year end to 2019 year end?
Answer: 12681
Calculation: 126,952-114,271
11. Quarterly financial information (unaudited): (Continued)
(1) Included in net income for the three months ended September 30, 2019 and December 31, 2019 are an unrealized gain and (loss) on foreign exchange on the Company’s 2024 Notes of $6.1 million and ($4.0) million, respectively.
Table:
 |  | Three months ended |  | 
 | March 31, 2018 | June 30, 2018 | September 30, 2018 | December 31, 2018
 |  | (in thousands, except share and per share amounts) |  | 
Service revenue | $128,706 | $129,296 | $130,139 | $132,049
Network operations, including equity-based compensation expense | 54,875 | 54,379 | 54,615 | 55,660
Gains on equipment transactions | 117 | 357 | 416 | 92
Operating income | 20,637 | 21,354 | 22,255 | 22,311
Net income | 6,784 | 6,552 | 8,231 | 7,100
Net income per common share—basic and diluted | 0.15 | 0.15 | 0.18 | 0.16
Weighted-average number of common shares—basic | 44,923,973 | 45,016,767 | 45,105,830 | 45,284,481
Weighted-average number of common shares—diluted | 45,294,697 | 45,536,473 | 45,699,635 | 45,803,418


Question: What is the total service revenue at March 31 and June 30, 2018?
Answer: 258002
Calculation: ($128,706 + $129,296)
risks relating to our business fluctuations in the financial markets could result in investment losses . prolonged and severe disruptions in the overall public debt and equity markets , such as occurred during 2008 , could result in significant realized and unrealized losses in our investment portfolio . although financial markets have significantly improved since 2008 , they could deteriorate in the future . there could also be disruption in individual market sectors , such as occurred in the energy sector in recent years . such declines in the financial markets could result in significant realized and unrealized losses on investments and could have a material adverse impact on our results of operations , equity , business and insurer financial strength and debt ratings . our results could be adversely affected by catastrophic events . we are exposed to unpredictable catastrophic events , including weather-related and other natural catastrophes , as well as acts of terrorism . any material reduction in our operating results caused by the occurrence of one or more catastrophes could inhibit our ability to pay dividends or to meet our interest and principal payment obligations . by way of illustration , during the past five calendar years , pre-tax catastrophe losses , net of contract specific reinsurance but before cessions under corporate reinsurance programs , were as follows: .

Table:
calendar year: | pre-tax catastrophe losses
( dollars in millions ) | 
2016 | $ 301.2
2015 | 53.8
2014 | 56.3
2013 | 194.0
2012 | 410.0
our losses from future catastrophic events could exceed our projections .
we use projections of possible losses from future catastrophic events of varying types and magnitudes as a strategic underwriting tool .
we use these loss projections to estimate our potential catastrophe losses in certain geographic areas and decide on the placement of retrocessional coverage or other actions to limit the extent of potential losses in a given geographic area .
these loss projections are approximations , reliant on a mix of quantitative and qualitative processes , and actual losses may exceed the projections by a material amount , resulting in a material adverse effect on our financial condition and results of operations. .

Question: what are the total pre-tax catastrophe losses in the last two years?
Answer: 355
Calculation: add(301.2, 53.8)
(D.6) Non-Current Assets by Region
The table below shows non-current assets excluding financial instruments, deferred tax assets, post-employment benefit assets, and rights arising under insurance contracts.
Non-Current Assets by Region
For a breakdown of our employee headcount by region, see Note (B.1) , and for a breakdown of revenue by region, see Note (A.1) .
Table:
€ millions | 2019 | 2018
Germany | 4,486 | 4,184
Rest of EMEA | 5,386 | 4,742
EMEA | 9,872 | 8,926
United States | 29,744 | 22,133
Rest of Americas | 411 | 258
Americas | 30,154 | 22,391
APJ | 1,276 | 922
SAP Group | 41,302 | 32,239


Question: What was the change in the amount in Rest of Americas in 2019 from 2018?
Answer: 153
Calculation: 411-258
The increase in Global Financing total revenue was driven by an increase in internal revenue, partially offset by a decrease in external revenue. Internal revenue grew 9.5 percent driven by increases in internal financing (up 17.6 percent) and internal used equipment sales (up 6.8 percent).
External revenue declined 6.3 percent due to a decrease in external used equipment sales (down 30.8 percent), partially offset by an increase in external financing (up 4.9 percent).
The increase in Global Financing pre-tax income was primarily driven by an increase in gross profit and a decrease in total expense.
Table:
($ in millions) |  |  | 
For the year ended December 31: | 2018 | 2017 | Yr.-to-Yr. Percent Change
Results of Operations |  |  | 
External revenue | $1,590 | $1,696 | (6.3)%
Internal revenue | 1,610 | 1,471 | 9.5
Total revenue | $3,200 | $3,168 | 1.0%
Pre-tax income | $1,361 | $1,278 | 6.5%


Question: What led to decline in External revenue 
Answer: a decrease in external used equipment sales (down 30.8 percent), partially offset by an increase in external financing (up 4.9 percent).
REPURCHASE OF COMPANY SHARES
The Company repurchased a total of 75,113 and 74,880 shares of its common stock during fiscal 2019 and fiscal 2018, respectively, for cash totaling approximately $7.5 million and $7.7 million, respectively. All repurchased shares were recorded in treasury stock at cost. At September 2019, 34,846 shares of the Company’s common shares remained authorized for repurchase in either the open market or privately negotiated transactions, as previously approved by the Company’s Board of Directors. In October 2019, our Board of Directors renewed the repurchase authorization for up to 75,000 shares of the Company’s common stock.
During the fourth quarter of fiscal 2019, the Company repurchased shares of its common stock for cash totaling approximately $4.3 million. The following table summarizes these repurchases made by or on behalf of our Company or certain affiliated purchasers of shares of our common stock for the quarterly period ended September 30, 2019:
* In October 2019 and subsequent to the end of fiscal 2019, our Board of Directors authorized purchases of up to
75,000 shares of our Company’s common stock in open market or negotiated transactions. Management was
given discretion to determine the number and pricing of the shares to be purchased, as well as the timing of any
such purchases.
Table:
Period | (a) Total Number of Shares (or Units) Purchased | (b) Average Price Paid per Share (or Unit) | (c) Total Number of Shares (or Units) Purchased as Part of Publicly Announced Plans or Programs | (d) Maximum Number (or Approximate Dollar Value) of Shares (or Unites) that May Yet Be Purchased Under the Plans or Programs*
July 1-31, 2019 | 293 | $ 99.35 | 293 | 74,706
August 1 - 31, 2019 | 39,769 | 107.71 | 39,769 | 34,937
September 1 - 30, 2019 | 91 | 75.51 | 91 | 34,846
Total | 40,153 | $ 107.58 | 40,153 | 34,846


Question: What is the percentage change in the amount paid by the company to purchase its common stock during 2018 and 2019?
Answer: -2.6
Calculation: (7.5 - 7.7)/7.7
Cash Flows
Our cash flows from operations are significantly impacted by timing of invoicing and collections of accounts receivable and annual bonus payments, as well as payments of payroll, payroll taxes, and other taxes.
We expect that we will continue to generate positive cash flows from operations on an annual basis, although this may fluctuate significantly on a quarterly basis. In particular, we typically use more cash during the first fiscal quarter ended October 31, as we generally pay cash bonuses to our employees for the prior fiscal year during that period and pay seasonally higher sales commissions from increased customer orders booked in our fourth fiscal quarter.
We believe that our existing cash and cash equivalents and sources of liquidity will be sufficient to fund our operations for at least the next 12 months. Our future capital requirements will depend on many factors, including our rate of revenue growth, the expansion of our sales and marketing activities, the timing and extent of our spending to support our research and development efforts, investments in cloud infrastructure and operating costs, and expansion into other markets.
We also may invest in or acquire complementary businesses, applications, or technologies, which may require the use of significant cash resources and/or additional financing. The following summary of cash flows for the periods indicated has been derived from our consolidated financial statements included elsewhere in this Annual Report on Form 10-K (in thousands):
Table:
 | Fiscal years ended July 31, | 
 | 2019 | 2018
Net cash provided by operating activities | $116,126 | $140,459
Net cash used in investing activities | $(301,433) | $(537,584)
Net cash provided by financing activities | $3,954 | $573,000


Question: What is the change in the Net cash provided by financing activities from 2018 to 2019?
Answer: -569046
Calculation: 3,954 - 573,000
ANG's revenues are principally derived from sales of compressed natural gas. ANG recognizes revenue from the sale of natural gas fuel primarily at the time the fuel is dispensed.
In December 2019, the U.S. Congress passed an alternative fuel tax credit ("AFTC") which will continue to support the use of natural gas. The AFTC is retroactive beginning January 2018 and extends through 2020.
The legislation extends the $0.50 per gallon fuel credit/payment for the use of natural gas as a transportation fuel, and the Alternative Fuel Vehicle Refueling Property Credit, which extends the 30 percent/$30,000 investment tax credit for alternative vehicle refueling property. Net revenue after customer rebates for such credits recognized in 2019 was $10.6 million.
As a result of the Bipartisan Budget Act of 2018, signed into law on February 9, 2018, all AFTC revenue for vehicle fuel ANG sold in 2017 was collected in the second quarter of 2018. Net revenue after customer rebates for such credits recognized in 2018 was $2.6 million.
Disaggregation of Revenues The following table disaggregates ANG's revenue by type (in millions):
Table:
 | Years Ended December 31, | 
 | 2019 | 2018
Volume-related | $ 27.5 | $ 16.5
Maintenance services | 0.1 | 0.1
Total revenue from contracts with customers | 27.6 | 16.6
RNG incentives | 0.5 | 1.3
Alternative fuel tax credit | 10.6 | 2.6
Other revenue | 0.3 | 0.2
Total Energy segment revenue | $ 39.0 | $ 20.7


Question: What was the average maintenance services?
Answer: 0.1
Calculation: (0.1 + 0.1) / 2
Total assets for the Company decreased $76.4 million as of December 31, 2019 as compared to December 31, 2018.  Entertainment and Communications assets decreased $58.8 million due to a decrease in property, plant and equipment primarily as a result of the increased depreciation in 2019 related to Hawaiian Telcom property, plant and equipment exceeding capital expenditures. IT Services and Hardware assets increased by $32.6 million primarily due to the Company’s recognition of operating lease right-of-use assets in the Consolidated Balance Sheets upon adoption of ASU 2016-02.
Corporate assets decreased $50.2 million primarily due to decreased receivables. Lower receivables is partially due to timing of sales in the fourth quarter as well as additional sales of certain receivables under the factoring arrangement as of December 31, 2019 compared to December 31, 2018. Deferred tax assets and liabilities totaled $59.3 million and $11.7 million as of December 31, 2019, respectively. Deferred tax assets and liabilities totaled $47.5 million and $11.4 million as of December 31, 2018, respectively. The increase in deferred tax assets in 2019, as compared to 2018, is due to increased net operating losses in 2019.
Table:
 |  | As of December 31,
(dollars in millions) | 2019 | 2018
Assets |  | 
Entertainment and Communications | $1,840.0 | $1,898.8
IT Services and Hardware | 500.7 | 468.1
Corporate and eliminations | 313.1 | 363.3
Total assets | $2,653.8 | $2,730.2


Question: Which asset classification makes up the biggest proportion of the company's assets as at December 31, 2019?
Answer: Entertainment and Communication
Calculation: $1,840.0 is the biggest value
Restricted Stock Grants—During 2019 and 2018, the Company granted 0.321 and 0.410 shares, respectively, of restricted stock to certain employee and director participants under its share-based compensation plans. Restricted stock grants generally vest over a period of 1 to 4 years. The Company recorded $72.5, $109.7 and $63.0 of compensation expense related to outstanding shares of restricted stock held by employees and directors during 2019, 2018 and 2017, respectively. In 2018, this expense included $29.4 associated with accelerated vesting due to the passing of our former executive chairman. A summary of the Company’s nonvested shares activity for 2019 and 2018 is as follows:
At December 31, 2019, there was $77.9 of total unrecognized compensation expense related to nonvested awards granted to both employees and directors under the Company’s share-based compensation plans. That cost is expected to be recognized over a weighted-average period of 1.8 years. Unrecognized compensation expense related to nonvested shares of restricted stock grants is recorded as a reduction to additional paid-in capital in stockholder’s equity at December 31, 2019.
Employee Stock Purchase Plan—During 2019, 2018 and 2017, participants of the ESPP purchased 0.021, 0.020 and 0.020 shares, respectively, of Roper’s common stock for total consideration of $6.8, $5.4, and $4.2, respectively. All of these shares were purchased from Roper’s treasury shares.
Table:
 | Number of shares | Weighted-average grant date fair value
Nonvested at December 31, 2017 | 0.859 | $ 187.01
Granted | 0.410 | 278.29
Vested | (0.492) | 204.24
Forfeited | (0.038) | 191.51
Nonvested at December 31, 2018 | 0.739 | $ 225.93
Granted | 0.321 | 318.75
Vested | (0.290) | 209.05
Forfeited | (0.061) | 225.23
Nonvested at December 31, 2019 | 0.709 | $ 275.00


Question: What is the percentage change in the total price of nonvested shares from December 31, 2018, to 2019?
Answer: 16.78
Calculation: ((0.709*275.00)-(0.739*225.93))/(0.739*225.93)
Supplemental balance sheet information related to operating and finance leases as of the period presented was as follows (table in millions):
(1) ROU assets for operating leases are included in other assets and ROU assets for finance leases are included in property and equipment, net on the consolidated balance sheets
(2) Current lease liabilities are included primarily in accrued expenses and other on the consolidated balance sheets. An immaterial amount is presented in due from related parties, net on the consolidated balance sheets.
(3) Operating lease liabilities are presented as operating lease liabilities on the consolidated balance sheets. Finance lease liabilities are included in other liabilities on the consolidated balance sheets.
Table:
 | January 31, 2020 | 
 | Operating Leases | Finance Leases
ROU assets, non-current (1) | $886 | $58
Lease liabilities, current (2) | $109 | $4
Lease liabilities, non-current (3) | 746 | 55
Total lease liabilities | $855 | $59


Question: What were the total lease liabilities for finance leases?
Answer: 59
Note 23 Provisions
(1) Other includes environmental, vacant space and legal provisions
AROs reflect management’s best estimates of expected future costs to restore current leased premises to their original condition prior to lease inception. Cash outflows associated with our ARO liabilities are generally expected to occur at the restoration dates of the assets to which they relate, which are long-term in nature. The timing and extent of restoration work that will be ultimately required for these sites is uncertain.
Table:
FOR THE YEAR ENDED DECEMBER 31 | NOTE | AROs | OTHER (1) | TOTAL
January 1, 2019 |  | 199 | 172 | 371
Additions |  | 21 | 24 | 45
Usage |  | (4) | (52) | (56)
Reversals |  | (17) | (1) | (18)
Adoption of IFRS 16 |  | – | (11) | (11)
December 31, 2019 |  | 199 | 132 | 331
Current | 20 | 16 | 17 | 33
Non-current | 25 | 183 | 115 | 298
December 31, 2019 |  | 199 | 132 | 331


Question: What do the AROs reflect?
Answer: management’s best estimates of expected future costs to restore current leased premises to their original condition prior to lease inception