hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
there were no changes in the company 2019s valuation techniques used to measure fair values on a recurring basis as a result of adopting asc 820 . pca had no assets or liabilities that were measured on a nonrecurring basis . 11 . stockholders 2019 equity on october 17 , 2007 , pca announced that its board of directors authorized a $ 150.0 million common stock repurchase program . there is no expiration date for the common stock repurchase program . through december 31 , 2008 , the company repurchased 3818729 shares of common stock , with 3142600 shares repurchased during 2008 and 676129 shares repurchased during 2007 . all repurchased shares were retired prior to december 31 , 2008 . there were no shares repurchased in 2009 . as of december 31 , 2009 , $ 65.0 million of the $ 150.0 million authorization remained available for repurchase of the company 2019s common stock . 12 . commitments and contingencies capital commitments the company had authorized capital commitments of approximately $ 41.7 million and $ 43.0 million as of december 31 , 2009 and 2008 , respectively , in connection with the expansion and replacement of existing facilities and equipment . in addition , commitments at december 31 , 2009 for the major energy optimization projects at its counce and valdosta mills totaled $ 156.3 million . lease obligations pca leases space for certain of its facilities and cutting rights to approximately 91000 acres of timberland under long-term leases . the company also leases equipment , primarily vehicles and rolling stock , and other assets under long-term leases with a duration of two to seven years . the minimum lease payments under non-cancelable operating leases with lease terms in excess of one year are as follows: .

Table:
 | ( in thousands )
2010 | $ 28162
2011 | 25181
2012 | 17338
2013 | 11557
2014 | 7742
thereafter | 18072
total | $ 108052
total lease expense , including base rent on all leases and executory costs , such as insurance , taxes , and maintenance , for the years ended december 31 , 2009 , 2008 and 2007 was $ 41.3 million , $ 41.6 million and $ 39.8 million , respectively .
these costs are included in cost of goods sold and selling and administrative expenses .
pca was obligated under capital leases covering buildings and machinery and equipment in the amount of $ 23.1 million and $ 23.7 million at december 31 , 2009 and 2008 , respectively .
during the fourth quarter of 2008 , the company entered into a capital lease relating to buildings and machinery , totaling $ 23.9 million , payable over 20 years .
this capital lease amount is a non-cash transaction and , accordingly , has been excluded packaging corporation of america notes to consolidated financial statements ( continued ) december 31 , 2009 .

Question: what percentage of total minimum lease payments under non-cancelable operating leases with lease terms in excess of one year are due in 2011?
Answer: 23%
Calculation: divide(25181, 108052)
19. Inventories
Note
1. Finished goods in 2018 includes $1.8 million relating to deferred costs which has been reclassified from trade and other receivables; see note 2 for further details.
An expense of $1.6 million (2018 $0.1 million) has been charged to the income statement in the year for inventory write-downs. There were no reversals of prior period inventory write-downs (2018 nil).
No inventories are carried at fair value less costs to sell (2018 nil).
Table:
 | 2019 | 2018
 | $ million | $ million
Raw materials | 4.8 | 6.6
Work in progress | 1.2 | 1.2
Finished goods¹ | 14.6 | 19.7
 | 20.6 | 27.5


Question: What was the change in total inventories?
Answer: -6.9
Calculation: 20.6-27.5
15 . leases in january 1996 , the company entered into a lease agreement with an unrelated third party for a new corporate office facility , which the company occupied in february 1997 . in may 2004 , the company entered into the first amendment to this lease agreement , effective january 1 , 2004 . the lease was extended from an original period of 10 years , with an option for five additional years , to a period of 18 years from the inception date , with an option for five additional years . the company incurred lease rental expense related to this facility of $ 1.3 million in 2008 , 2007 and 2006 . the future minimum lease payments are $ 1.4 million per annum from january 1 , 2009 to december 31 , 2014 . the future minimum lease payments from january 1 , 2015 through december 31 , 2019 will be determined based on prevailing market rental rates at the time of the extension , if elected . the amended lease also provided for the lessor to reimburse the company for up to $ 550000 in building refurbishments completed through march 31 , 2006 . these amounts have been recorded as a reduction of lease expense over the remaining term of the lease . the company has also entered into various noncancellable operating leases for equipment and office space . office space lease expense totaled $ 9.3 million , $ 6.3 million and $ 4.7 million for the years ended december 31 , 2008 , 2007 and 2006 , respectively . future minimum lease payments under noncancellable operating leases for office space in effect at december 31 , 2008 are $ 8.8 million in 2009 , $ 6.6 million in 2010 , $ 3.0 million in 2011 , $ 1.8 million in 2012 and $ 1.1 million in 2013 . 16 . royalty agreements the company has entered into various renewable , nonexclusive license agreements under which the company has been granted access to the licensor 2019s technology and the right to sell the technology in the company 2019s product line . royalties are payable to developers of the software at various rates and amounts , which generally are based upon unit sales or revenue . royalty fees are reported in cost of goods sold and were $ 6.3 million , $ 5.2 million and $ 3.9 million for the years ended december 31 , 2008 , 2007 and 2006 , respectively . 17 . geographic information revenue to external customers is attributed to individual countries based upon the location of the customer . revenue by geographic area is as follows: .

Table:
( in thousands ) | year ended december 31 , 2008 | year ended december 31 , 2007 | year ended december 31 , 2006
united states | $ 151688 | $ 131777 | $ 94282
germany | 68390 | 50973 | 34567
japan | 66960 | 50896 | 35391
canada | 8033 | 4809 | 4255
other european | 127246 | 108971 | 70184
other international | 56022 | 37914 | 24961
total revenue | $ 478339 | $ 385340 | $ 263640
.

Question: what is the total combined royalty fees for years ended 2006-2008 , in millions?
Answer: 15.4
Calculation: add(6.3, 5.2), add(#0, 3.9)
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 Accrued property and real estate taxes in 2018?
Answer: $169.7
18. Other Income (Expense), Net
Other income (expense), net consists of the following:
Table:
 |  | Years Ended June 30, | 
($ in millions) | 2019 | 2018 | 2017
Unrealized gains on company owned life insurance contracts and investments held in rabbi trusts | $0.8 | $1.5 | $1.7
Interest income | 0.1 | 0.3 | 0.3
Foreign exchange | (0.4) | (0.7) | (0.4)
Pension earnings, interest and deferrals | (0.1) | (2.1) | (23.8)
Pension curtailment | — | — | (0.5)
Other | 0.2 | 0.2 | 1.2
Total other income (expense), net | $0.6 | $(0.8) | $(21.5)


Question: What was the change in interest income in 2019 from 2018?
Answer: -0.2
Calculation: 0.1-0.3
Note 11. Share-Based Compensation
A summary of share-based compensation expense recognized in the Company’s Consolidated Statements of Operations is as follows (in thousands):
Table:
 |  | Year ended December 31, | 
 | 2019 | 2018 | 2017
Cost of revenues | $8,741 | $4,982 | $3,735
Research and development | 23,132 | 14,975 | 9,550
Sales and marketing | 38,325 | 27,324 | 16,015
General and administrative | 31,156 | 20,807 | 12,760
Total share-based compensation expense | $101,354 | 68,088 | 42,060


Question: What are the respective share-based compensation for sales and marketing in 2018 and 2019?
Answer: 27,324, 38,325
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 was the change in the Unrecognized tax benefits, end of period from 2018 to 2019?
Answer: 367
Calculation: 3,102 - 2,735
The following table includes additional fair value information on financial assets and liabilities as at December 31, 2019 and 2018:
(1) Cash equivalents primarily correspond to deposits at call with banks.
(2) The carrying amount of the senior unsecured convertible bonds as reported above corresponds to the liability component only. For the convertible bonds issued on July 3, 2017 and outstanding as at December 31, 2017, the carrying amount of the senior unsecured convertible bonds corresponds to the liability component only, since, at initial recognition, an amount of $242 million was recorded directly in shareholders’ equity as the value of the equity instrument embedded in the convertible instrument.
Table:
 | 2019 | 2019 | 2019 | 2018 | 2018
 | Level | Carrying Amount | Estimated Fair Value | Carrying Amount | Estimated Fair Value
Cash equivalents (1) | 1 | 1,691 | 1,691 | 2,138 | 2,138
Long-term debt |  |  |  |  | 
– Bank loans (including current portion) | 2 | 718 | 718 | 594 | 594
– Senior unsecured convertible bonds (2) | 1 | 1,354 | 2,103 | 1,316 | 1,501


Question: Under which head of balance sheet does senior unsecured convertible bonds correspond to?
Answer: The carrying amount of the senior unsecured convertible bonds as reported above corresponds to the liability component only.
Summarized financial information of Hilli LLC
The most significant impacts of Hilli LLC VIE's operations on our consolidated statements of income and consolidated statements of cash flows, as of December 31, 2019 and 2018, are as follows:
Table:
(in thousands of $) | 2019 | 2018
Statement of income |  | 
Liquefaction services revenue | 218,096 | 127,625
Realized and unrealized (losses)/gains on the oil derivative instrument | (26,001) | 16,767
Statement of cash flows |  | 
Net debt repayments | (243,513) | (30,300)
Net debt receipts | 129,454 | —


Question: What was the net debt repayments in 2018?
Answer: (30,300)
Due To/From Related Parties, Net
Amounts due to and from related parties, net as of the periods presented consisted of the following (table in millions):
(1) Includes an immaterial amount related to the Company’s current operating lease liabilities due to related parties as of January 31, 2020.
The Company also recognized an immaterial amount related to non-current operating lease liabilities due to related parties. This amount has been included in operating lease liabilities on the consolidated balance sheet as of January 31, 2020.
Table:
 | January 31, 2020 | February 1, 2019
Due from related parties, current | $1,618 | $1,248
Due to related parties, current(1) | 161 | 158
Due from related parties, net, current | $1,457 | $1,090


Question: What was the percentage change in the net current amount due from related parities between 2019 and 2020?
Answer: 33.67
Calculation: (1,457-1,090)/1,090
2017 ESPP
In May 2017, we adopted the 2017 Employee Stock Purchase Plan (the “2017 ESPP”). The 2017 ESPP grants employees the ability to designate a portion of their base-pay to purchase ordinary shares at a price equal to 85% of the fair market value of our ordinary shares on the first or last day of each 6 month purchase period. Purchase periods begin on January 1 or July 1 and end on June 30 or December 31, or the next business day if such date is not a business day. Shares are purchased on the last day of the purchase period.
The table below sets forth the weighted average assumptions used to measure the fair value of 2017 ESPP rights:
We recognize share-based compensation expense associated with the 2017 ESPP over the duration of the purchase period. We recognized$0.3 million, $0.3 million, and $0.1 million of share-based compensation expense associated with the 2017 ESPP during 2019, 2018, and 2017, respectively. At December 27, 2019, there was no unrecognized share-based compensation expense.
Table:
 | Year Ended |  | 
 | December 27, 2019 | December 28, 2018 | December 29, 2017
Weighted average expected term | 0.5 years | 0.5 years | 0.4 years
Risk-free interest rate | 2.3% | 1.9% | 1.1%
Dividend yield | 0.0% | 0.0% | 0.0%
Volatility | 56.0% | 52.7% | 47.8%


Question: When did the company adopt the 2017 Employee Stock Purchase Plan (the “2017 ESPP”)?
Answer: May 2017
entergy louisiana , llc management's financial discussion and analysis 2007 compared to 2006 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 ( credits ) . following is an analysis of the change in net revenue comparing 2007 to 2006 . amount ( in millions ) .

Table:
 | amount ( in millions )
2006 net revenue | $ 942.1
base revenues | 78.4
volume/weather | 37.5
transmission revenue | 9.2
purchased power capacity | -80.0 ( 80.0 )
other | 3.9
2007 net revenue | $ 991.1
the base revenues variance is primarily due to increases effective september 2006 for the 2005 formula rate plan filing to recover lpsc-approved incremental deferred and ongoing capacity costs .
see "state and local rate regulation" below and note 2 to the financial statements for a discussion of the formula rate plan filing .
the volume/weather variance is due to increased electricity usage , including electricity sales during the unbilled service period .
billed retail electricity usage increased a total of 666 gwh in all sectors compared to 2006 .
see "critical accounting estimates" below and note 1 to the financial statements for further discussion of the accounting for unbilled revenues .
the transmission revenue variance is primarily due to higher rates .
the purchased power capacity variance is primarily due to higher purchased power capacity charges and the amortization of capacity charges effective september 2006 as a result of the formula rate plan filing in may 2006 .
a portion of the purchased power capacity costs is offset in base revenues due to a base rate increase implemented to recover incremental deferred and ongoing purchased power capacity charges , as mentioned above .
see "state and local rate regulation" below and note 2 to the financial statements for a discussion of the formula rate plan filing .
gross operating revenues , fuel , purchased power expenses , and other regulatory charges ( credits ) gross operating revenues increased primarily due to : an increase of $ 143.1 million in fuel cost recovery revenues due to higher fuel rates and usage ; an increase of $ 78.4 million in base revenues , as discussed above ; and an increase of $ 37.5 million related to volume/weather , as discussed above .
fuel and purchased power expenses increased primarily due to an increase in net area demand and an increase in deferred fuel expense as a result of higher fuel rates , as discussed above .
other regulatory credits decreased primarily due to the deferral of capacity charges in 2006 in addition to the amortization of these capacity charges in 2007 as a result of the may 2006 formula rate plan filing ( for the 2005 test year ) with the lpsc to recover such costs through base rates effective september 2006 .
see note 2 to the financial statements for a discussion of the formula rate plan and storm cost recovery filings with the lpsc. .

Question: what is the growth rate in net revenue in 2007?
Answer: 5.2%
Calculation: subtract(991.1, 942.1), divide(#0, 942.1)
Stock-based Compensation Expense
The income tax benefit related to share-based compensation was $66 million, $158 million and $97 million for 2019, 2018 and 2017, respectively. The income tax benefits related to share-based compensation for the periods presented prior to the second quarter of 2018 were offset by an increase in the U.S. valuation allowance. Stock-based compensation expense of $30 million and $19 million was capitalized and remained in inventory as of August 29, 2019 and August 30, 2018, respectively. As of August 29, 2019, $439 million of total unrecognized compensation costs for unvested awards, before the effect of any future forfeitures, was expected to be recognized through the fourth quarter of 2023, resulting in a weighted-average period of 1.3 years.
Table:
For the year ended | 2019 | 2018 | 2017
Stock-based compensation expense by caption |  |  | 
Cost of goods sold | $102 | $83 | $88
Selling, general, and administrative | 73 | 61 | 75
Research and development | 68 | 54 | 52
 | $243 | $198 | $215
Stock-based compensation expense by type of award |  |  | 
Restricted stock awards | $178 | $140 | $144
Stock options | 33 | 55 | 71
ESPP | 32 | 3 | —
 | $243 | $198 | $215


Question: How much stock-based compensation expense was capitalized and remained in inventory as of August 29, 2019?
Answer: $30 million
stock performance graph : the graph below shows the cumulative total shareholder return assuming the investment of $ 100 , on december 31 , 2010 , and the reinvestment of dividends thereafter , if any , in the company's common stock versus the standard and poor's s&p 500 retail index ( "s&p 500 retail index" ) and the standard and poor's s&p 500 index ( "s&p 500" ) . .

Table:
company/index | december 31 , 2010 | december 31 , 2011 | december 31 , 2012 | december 31 , 2013 | december 31 , 2014 | december 31 , 2015
o'reilly automotive inc . | $ 100 | $ 132 | $ 148 | $ 213 | $ 319 | $ 419
s&p 500 retail index | 100 | 103 | 128 | 185 | 203 | 252
s&p 500 | $ 100 | $ 100 | $ 113 | $ 147 | $ 164 | $ 163
.

Question: what is the roi of an investment in the o'reilly automotive inc . from 2010 to 2011?
Answer: 32%
Calculation: subtract(132, 100), divide(#0, 100)
Share Repurchase
In September 2015, our Board of Directors authorized a program to repurchase up to $150.0 million of our common stock over a thirty-month period. In November 2017, our Board of Directors approved an extension of the share repurchase program to December 2019 from its original maturity of March 2018. In May 2018, our Board of Directors approved a $50 million increase in its authorization to repurchase shares of our common stock under this same program.
On December 18, 2019, the Board of Directors authorized to remove the expiration date to the Company’s share repurchase program and increase the authorized amount by $25.1 million. As of December 31, 2019, the Company is authorized to repurchase shares of the Company’s common stock of up to a total of $50.0 million.
ADVANCED ENERGY INDUSTRIES, INC. NOTES TO CONSOLIDATED FINANCIAL STATEMENTS – (continued) (in thousands, except per share amounts)
In order to execute the repurchase of shares of our common stock, the Company periodically enters into stock repurchase agreements. During the years ended December 31, 2019, 2018 and 2017 the Company has repurchased the following shares of common stock:
Table:
 |  | Years Ended December 31, | 
(in thousands, except per share amounts) | 2019 | 2018 | 2017
Amount paid to repurchase shares | $  — | $95,125 | $29,993
Number of shares repurchased | — | 1,696 | 422
Average repurchase price per share | $  — | $56.07 | $71.07


Question: What was the average repurchase price per share in 2018?
Answer: $56.07
Inventories.
Inventories are stated at the lower-of-cost or net realizable value. Cost is determined using the first-in, first-out method. Finished products and work-in-process inventories include direct material costs and direct and indirect manufacturing costs. The Company records reserves for inventory that may be obsolete or in excess of current and future market demand. A summary of inventories is shown below:
Table:
(Dollars in Millions) | April 27, 2019 | April 28, 2018
Finished Products | $40.2 | $15.4
Work in Process | 9.4 | 14.6
Materials | 67.1 | 54.1
Total Inventories | $116.7 | $84.1


Question: What is the average work in progress value for 2018 and 2019?
Answer: 12
Calculation: (9.4 + 14.6) / 2