hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
notes to consolidated financial statements ( continued ) note 7 2014income taxes ( continued ) as of september 30 , 2006 , the company has state and foreign tax loss and state credit carryforwards , the tax effect of which is $ 55 million . certain of those carryforwards , the tax effect of which is $ 12 million , expire between 2016 and 2019 . a portion of these carryforwards was acquired from the company 2019s previous acquisitions , the utilization of which is subject to certain limitations imposed by the internal revenue code . the remaining benefits from tax losses and credits do not expire . as of september 30 , 2006 and september 24 , 2005 , a valuation allowance of $ 5 million was recorded against the deferred tax asset for the benefits of state operating losses that may not be realized . management believes it is more likely than not that forecasted income , including income that may be generated as a result of certain tax planning strategies , together with the tax effects of the deferred tax liabilities , will be sufficient to fully recover the remaining deferred tax assets . a reconciliation of the provision for income taxes , with the amount computed by applying the statutory federal income tax rate ( 35% ( 35 % ) in 2006 , 2005 , and 2004 ) to income before provision for income taxes , is as follows ( in millions ) : 2006 2005 2004 as restated ( 1 ) as restated ( 1 ) .

Table:
 | 2006 | 2005 as restated ( 1 ) | 2004 as restated ( 1 )
computed expected tax | $ 987 | $ 633 | $ 129
state taxes net of federal effect | 86 | -19 ( 19 ) | -5 ( 5 )
indefinitely invested earnings of foreign subsidiaries | -224 ( 224 ) | -98 ( 98 ) | -31 ( 31 )
nondeductible executive compensation | 11 | 14 | 12
research and development credit net | -12 ( 12 ) | -26 ( 26 ) | -5 ( 5 )
other items | -19 ( 19 ) | -24 ( 24 ) | 4
provision for income taxes | $ 829 | $ 480 | $ 104
effective tax rate | 29% ( 29 % ) | 27% ( 27 % ) | 28% ( 28 % )
( 1 ) see note 2 , 201crestatement of consolidated financial statements . 201d the company 2019s income taxes payable has been reduced by the tax benefits from employee stock options .
the company receives an income tax benefit calculated as the difference between the fair market value of the stock issued at the time of the exercise and the option price , tax effected .
the net tax benefits from employee stock option transactions were $ 419 million , $ 428 million ( as restated ( 1 ) ) , and $ 83 million ( as restated ( 1 ) ) in 2006 , 2005 , and 2004 , respectively , and were reflected as an increase to common stock in the consolidated statements of shareholders 2019 equity. .

Question: what was the 2006 tax expense?
Answer: $ 240.41
Calculation: multiply(829, 29%)
Accrued Liabilities
Accrued liabilities consists of the following (in millions):
Sales related reserves represent price concessions and stock rotation rights that the Company offers to many of its distributors. For the fiscal year ending March 31, 2018, these sales related reserves were recorded within accounts receivable, and therefore did not exist within accrued liabilities. The Company made this change in classification as part of its adoption of ASC 606. For additional information regarding the Company's adoption of ASC 606, refer to Note 1 of the consolidated financial statements.
Table:
 | March 31, | 
 | 2019 | 2018
Accrued compensation and benefits | $133.2 | $87.6
Income taxes payable | 46.9 | 27.5
Sales related reserves | 366.9 | —
Accrued expenses and other liabilities | 240.3 | 114.5
Total accrued liabilities | $787.3 | $229.6


Question: What was the change in income taxes payable between 2018 and 2019?
Answer: 19.4
Calculation: 46.9-27.5
7. LOANS PAYABLE
Plan B, a subsidiary of the Company, entered into a business loan agreement, prior to being acquired by the Company, with Tri Counties Bank dated March 14, 2014, in the original amount of $131 bearing interest at 4.95%. The loan agreement called for monthly payments of $2 and was scheduled to mature on March 14, 2019. Proceeds from the loan were used to purchase a pile driver and related equipment and is secured by the equipment. The loan was fully paid off during the year ended December 31, 2019.
Plan B entered into a business loan agreement prior to being acquired by the Company, with Tri Counties Bank dated April 9, 2014, in the original amount of $250 bearing interest at 4.95%. The loan agreement calls for monthly payments of $5 and was scheduled to mature on April 9, 2019. Proceeds from the loan were used to purchase racking inventory and related equipment. The loan was secured by the inventory and equipment. The loan was fully paid off during the year ended December 31, 2019.
On January 5, 2016, the Company entered into a loan agreement for the acquisition of a pile driver in the principal amount of $182 bearing interest at 5.5%. The loan agreement calls for monthly payments of $4 and is scheduled to mature on January 15, 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $4.
On September 8, 2016, the Company entered into a loan agreement for the acquisition of a pile driver in the principal amount of $174 bearing interest at 5.5%. The loan agreement calls for monthly payments of $4 and is scheduled to mature on September 15, 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $36.
On November 14, 2016, the Company entered into a 0% interest loan agreement for the acquisition of an excavator in the principal amount of $59. The loan agreement calls for monthly payments of $1 and is scheduled to mature on November 13, 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $13.
On December 23, 2016, the Company entered into a loan agreement for the acquisition of modular office systems and related furniture in the principal amount of $172 bearing interest at 4.99%. The loan agreement calls for 16 quarterly payments of $12 and is scheduled to mature in September 2020. The loan is secured by the equipment. The outstanding balance at December 31, 2019, is $35.
As of December 31, 2019 and 2018, loans payable are summarized as follows:
Table:
 | 2019 | 2018
Business loan agreement dated March 14, 2014 | - | 7
Business loan agreement dated April 9, 2014 | - | 19
Equipment notes payable | 88 | 241
Subtotal | 88 | 267
Less: Current position | (88) | (179)
Long-term position | - | $88


Question: What does the table show?
Answer: As of December 31, 2019 and 2018, loans payable
Contractual Obligations
Our contractual obligations as of August 31, 2019 are summarized below. As disclosed below, while we have certain non-cancelable purchase order obligations for property, plant and equipment, we generally do not enter into non-cancelable purchase orders for materials until we receive a corresponding purchase commitment from our customer. Non-cancelable purchase orders do not typically extend beyond the normal lead time of several weeks, at most. Purchase orders beyond this time frame are typically cancelable.
(1) Consists of interest on notes payable and long-term debt outstanding as of August 31, 2019. Certain of our notes payable and long-term debt pay interest at variable rates. We have applied estimated interest rates to determine the value of these expected future interest payments.
(2) Consists of purchase commitments entered into as of August 31, 2019 primarily for property, plant and equipment and software pursuant to legally enforceable and binding agreements.
(3) Includes the estimated company contributions to funded pension plans during fiscal year 2020 and the expected benefit payments for unfunded pension and postretirement plans from fiscal years 2020 through 2029. These future payments are not recorded on the Consolidated Balance Sheets but will be recorded as incurred.
(4) Includes (i) a $28.5 million capital commitment, (ii) a $16.2 million obligation related to a new human resource system and (iii) $33.0 million related to the one-time transition tax as a result of the Tax Act that will be paid in annual installments through fiscal year 2026.
(5) As of August 31, 2019, we have $1.5 million and $103.7 million recorded as a current and a long-term liability, respectively, for uncertain tax positions. We are not able to reasonably estimate the timing of payments, or the amount by which our liability for these uncertain tax positions will increase or decrease over time, and accordingly, this liability has been excluded from the above table.
Table:
 |  |  | Payments due by period (in thousands) |  | 
 | Total | Less than 1 year | 1-3 years | 3-5 years | After 5 years
Notes payable and long-term debt | $2,496,465 | $375,181 | $491,655 | $1,134,733 | $494,896
Future interest on notes payable and long-term debt(1) | 373,762 | 109,506 | 142,082 | 55,463 | 66,711
Operating lease obligations | 603,185 | 118,312 | 187,644 | 114,297 | 182,932
Capital lease obligations | 77,829 | 6,038 | 11,726 | 10,928 | 49,137
Non-cancelable purchase order obligations(2) | 351,230 | 289,516 | 61,537 | 177 | —
Pension and post retirement contributions and payments(3) | 14,618 | 1,135 | 1,904 | 2,396 | 9,183
Other(4) | 77,669 | 17,922 | 27,863 | 14,214 | 17,670
Total contractual obligations(5) | $3,994,758 | $917,610 | $924,411 | $1,332,208 | $820,529


Question: What was the difference between total operating lease obligations and total capital lease obligations?
Answer: 525356
Calculation: 603,185-77,829
the fair value of our total investments increased $ 4.8 billion during 2010 , primarily due to unrealized appreciation , the inves- ting of operating cash flows , and the portfolios acquired in the 2010 corporate acquisitions . the following tables show the market value of our fixed maturities and short-term investments at december 31 , 2010 and 2009 . the first table lists investments according to type and the second according to s&p credit rating. .

Table:
( in millions of u.s . dollars except for percentages ) | 2010 market value | 2010 percentage of total | 2010 market value | percentageof total
treasury | $ 2075 | 4% ( 4 % ) | $ 2068 | 5% ( 5 % )
agency | 2015 | 4% ( 4 % ) | 2698 | 6% ( 6 % )
corporate and asset-backed securities | 15900 | 33% ( 33 % ) | 13537 | 30% ( 30 % )
mortgage-backed securities | 12362 | 25% ( 25 % ) | 11311 | 25% ( 25 % )
municipal | 2449 | 5% ( 5 % ) | 2300 | 5% ( 5 % )
non-u.s . | 12199 | 25% ( 25 % ) | 11172 | 25% ( 25 % )
short-term investments | 1983 | 4% ( 4 % ) | 1667 | 4% ( 4 % )
total | $ 48983 | 100% ( 100 % ) | $ 44753 | 100% ( 100 % )
aaa | $ 23718 | 48% ( 48 % ) | $ 22884 | 51% ( 51 % )
aa | 4714 | 10% ( 10 % ) | 4021 | 9% ( 9 % )
a | 8482 | 17% ( 17 % ) | 7461 | 17% ( 17 % )
bbb | 5487 | 11% ( 11 % ) | 4910 | 11% ( 11 % )
bb | 3357 | 7% ( 7 % ) | 2866 | 6% ( 6 % )
b | 2393 | 5% ( 5 % ) | 2029 | 5% ( 5 % )
other | 832 | 2% ( 2 % ) | 582 | 1% ( 1 % )
total | $ 48983 | 100% ( 100 % ) | $ 44753 | 100% ( 100 % )
.

Question: what is the percentage change in the balance of treasury in 2010?
Answer: 0.3%
Calculation: subtract(2075, 2068), divide(#0, 2068)
Financing and cash flow
The Group delivered very strong cash generation in 2019, driven by higher operating profit and effective working capital management. Changes in working capital, reflected within cash flow from operations, benefited from:
• our continued focus on improving trade receivables collection; • a reduction in inventory levels due to a high level of shipments at the end of 2019; and • growth in payables, resulting from the increase in activity levels and emphasis on extending supplier payment terms.
Free cash flow for 2019 almost doubled year-on-year coming in at $100.1 million, compared to $50.9 million in 2018, resulting in a free cash flow conversion which represented 123 per cent of adjusted earnings (2018 77 per cent).
Free cash flow is set out below:
Note
1. Spirent adopted IFRS 16 on 1 January 2019; in prior periods operating lease payments were included within cash flow from operations.
Free cash flow includes a net cash outflow in respect of exceptional items in 2018 and 2019 of $5.5 million (2018 $3.6 million in respect of exceptional items charged in 2017 and 2018).
Tax payments of $5.6 million made in 2019 were consistent with the prior year (2018 $5.7 million). Net capital expenditure of $11.9 million was also broadly consistent with the prior year (2018 $10.6 million), with the incremental spend of $1.3 million primarily related to investment in 5G. We continue to exercise careful management of capital investment to ensure efficient use of capital and maximise return on investment.
Following the adoption of IFRS 16 on 1 January 2019, the payment of lease liabilities, both the principal and interest elements, are shown separately from net cash flow from operating activities. In previous periods they would have been reflected in that number. There is no overall impact in comparing free cash flow year-on-year.
In 2019, the final dividend for 2018 and an interim dividend for 2019 totalling $28.6 million were paid. This compared to total dividends of $54.8 million paid in 2018, including a special dividend of $29.9 million. In addition, 4.0 million shares were purchased and placed into the Employee Share Ownership Trust at a cost of $8.6 million (2018 1.5 million shares at a net cost of $2.5 million) and $1.9 million of cash consideration was paid to acquire the business of a navigation systems company based in the United Kingdom.
Following these payments, cash and cash equivalents closed at $183.2 million at 31 December 2019, compared with $121.6 million at 31 December 2018. There continues to be no bank debt.
Table:
$ million | 2019 | 2018
Cash flow from operations | 124.9 | 65.9
Tax paid | (5.6) | (5.7)
Net cash inflow from operating activities | 119.3 | 60.2
Interest received | 2.6 | 1.3
Net capital expenditure | (11.9) | (10.6)
Payment of lease liabilities, principal and interest1 | (10.3) | —
Lease payments received from finance leases | 0.4 | —
Free cash flow | 100.1 | 50.9


Question: What was the change in free cash flow?
Answer: 49.2
Calculation: $100.1-$50.9
performance graph the table below compares the cumulative total shareholder return on our common stock with the cumulative total return of ( i ) the standard & poor 2019s 500 composite stock index ( 201cs&p 500 index 201d ) , ( ii ) the standard & poor 2019s industrials index ( 201cs&p industrials index 201d ) and ( iii ) the standard & poor 2019s consumer durables & apparel index ( 201cs&p consumer durables & apparel index 201d ) , from december 31 , 2007 through december 31 , 2012 , when the closing price of our common stock was $ 16.66 . the graph assumes investments of $ 100 on december 31 , 2007 in our common stock and in each of the three indices and the reinvestment of dividends . performance graph 2007 2008 2009 2010 2011 2012 s&p 500 index s&p industrials index s&p consumer durables & apparel index the table below sets forth the value , as of december 31 for each of the years indicated , of a $ 100 investment made on december 31 , 2007 in each of our common stock , the s&p 500 index , the s&p industrials index and the s&p consumer durables & apparel index and includes the reinvestment of dividends. .

Table:
 | 2008 | 2009 | 2010 | 2011 | 2012
masco | $ 55.78 | $ 71.52 | $ 67.12 | $ 52.15 | $ 92.49
s&p 500 index | $ 63.45 | $ 79.90 | $ 91.74 | $ 93.67 | $ 108.55
s&p industrials index | $ 60.60 | $ 72.83 | $ 92.04 | $ 91.50 | $ 105.47
s&p consumer durables & apparel index | $ 66.43 | $ 90.54 | $ 118.19 | $ 127.31 | $ 154.72
in july 2007 , our board of directors authorized the purchase of up to 50 million shares of our common stock in open-market transactions or otherwise .
at december 31 , 2012 , we had remaining authorization to repurchase up to 24 million shares .
during the first quarter of 2012 , we repurchased and retired one million shares of our common stock , for cash aggregating $ 8 million to offset the dilutive impact of the 2012 grant of one million shares of long-term stock awards .
we have not purchased any shares since march 2012. .

Question: what was the percent of the increase in the performance of the s&p 500 index from 2008 to 2009
Answer: 25.93%
Calculation: subtract(79.90, 63.45), divide(#0, 63.45)
Item 10. Directors, Executive Officers and Corporate Governance
Executive Officers of the Registrant
The following table sets forth information concerning the executive officers of Loral as of March 12, 2020.
The remaining information required under Item 10 will be presented in the Company’s 2020 definitive proxy statement which is incorporated herein by reference or by amendment to this Annual Report on Form 10‐K.
Table:
Name | Age | Position
Avi Katz | 61 | President, General Counsel and Secretary since December 2012. Senior Vice President, General Counsel and Secretary from January 2008 to December 2012.
John Capogrossi | 66 | Vice President, Chief Financial Officer and Treasurer since January 2016. Vice President, Chief Financial Officer, Treasurer and Controller from March 2013 to January 2016. Vice President and Controller from January 2008 to March 2013.
Ravinder S. Girgla | 56 | Vice President and Controller since January 2016. Deputy Controller from February 2013 to January 2016. Assistant Controller from July 2008 to February 2013.


Question: What is the average age of the company's Vice Presidents?
Answer: 61
Calculation: (66 + 56)/2
2. Net Income (Loss) Per Share
Basic earnings per share, or EPS, is calculated by dividing net income (loss) by the weighted-average number of common shares outstanding for the period, without consideration for common stock equivalents. Diluted EPS is computed by dividing net income by the weighted-average number of common shares outstanding for the period and the weighted-average number of dilutive common stock equivalents outstanding for the period determined using the treasury-stock method.
For purposes of this calculation, common stock options, restricted stock units and restricted stock awards are considered to be common stock equivalents and are only included in the calculation of diluted EPS when their effect is dilutive. In periods in which the Company has a net loss, dilutive common stock equivalents are excluded from the calculation of diluted EPS.
The table below presents the computation of basic and diluted earnings per share:
For the years ended December 31, 2019, 2018 and 2017, the Company incurred net losses and accordingly excluded common stock equivalents for outstanding stockbased awards, which represented all potentially dilutive securities, of 2.5 million, 3.7 million, and 4.5 million, respectively, from the calculation of diluted net loss per share due to their anti-dilutive nature.
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
 |  | (in thousands, except per share amounts) | 
Numerator: |  |  | 
Net loss | $(19,898) | $(26,199) | $(9,187)
Denominator: |  |  | 
Weighted average common shares outstanding—basic | 71,005 | 68,490 | 66,252
Dilutive common stock equivalents | — | — | —
Weighted average common shares outstanding—diluted | 71,005 | 68,490 | 66,252
Net loss per share: |  |  | 
Basic | $(0.28) | $(0.38) | $(0.14)
Diluted | $(0.28) | $(0.38) | $(0.14)


Question: What is the average Numerator: Net loss for the year ended December 31, 2019 to 2018?
Answer: 23048.5
Calculation: (19,898+26,199) / 2
Year Ended December 31, 2018 Compared to the Year Ended December 31, 2017
Our management reviews and analyzes several key financial measures in order to manage our business and assess the quality of and variability of our service revenue, operating results and cash flows. The following summary tables present a comparison of our results of operations with respect to certain key financial measures. The comparisons illustrated in the tables are discussed in greater detail below.
Table:
 | Year Ended December 31, |  | 
 | 2018 | 2017 | Change
Other Operating Data |  |  | 
Average Revenue Per Unit (ARPU) |  |  | 
ARPU—on-net | $ 480 | $ 506 | (5.1)%
ARPU—off-net | $ 1,155 | $ 1,239 | (6.8)%
Average price per megabit | $ 0.82 | $ 1.11 | (25.9)%
Customer Connections—end of period |  |  | 
On-net | 68,770 | 61,334 | 12.1%
Off-net | 10,974 | 9,953 | 10.3%


Question: What is the percentage change in off-net APRU between 2017 and 2018? 
Answer: -6.78
Calculation: ((1,155 - 1,239)/1,239 ) * 100
Year Ended December 31, 2018 Compared to Year Ended December 31, 2017
Revenue
Total revenue for the year ended December 31, 2018 increased by $58.9 million, or 28%, compared to the year ended December 31, 2017. Subscription
and returns revenue for the year ended December 31, 2018 increased by $54.1 million, or 27%, compared to the year ended December 31, 2017. Professional
services revenue for the year ended December 31, 2018 increased by $4.8 million, or 37%, compared to the year ended December 31, 2017. Growth in total
revenue was due primarily to increased demand for our products and services from both new and existing customers. Of the increase in total revenue for the year
ended December 31, 2018 compared to 2017, approximately $29.6 million was attributable to existing customers, approximately $28.3 million was attributable to
new customers, and approximately $1.1 million was due to interest income on funds held for customers. Total subscription and returns revenue for 2018 included
$1.2 million related to our cross-border transactions technology acquired in May 2018.
Table:
 | For the Year Ended December 31, |  | Change | 
 | 2018 | 2017 | Amount | Percentage
 |  | (dollars in thousands) |  | 
Revenue: |  |  |  | 
Subscription and returns | $254,056 | $199,942 | $54,114 | 27%
Professional services | 18,042 | 13,217 | 4,825 | 37%
Total revenue | $272,098 | $213,159 | $58,939 | 28%


Question: What are the 2017 and 2018 total revenue respectively?
Answer: $272,098, $213,159
Trade Receivables, Net
The carrying amounts reported in the Consolidated Balance Sheets for Trade receivables, net approximate their fair value because of their short-term nature.
A summary of Trade receivables, net of allowance for doubtful accounts is as follows (in millions):
In addition to the amounts above, we have unbilled receivables that we do not expect to collect within the next year included in Other non-current assets in our Consolidated Balance Sheets. Billings for these receivables are based on contractual terms. Refer to Note 11 — Other Non-Current Assets.
Table:
 | December 31, | 
 | 2019 | 2018
Trade receivables — billed | $136.6 | $136.6
Trade receivables — unbilled | 39.8 | 37.0
Trade receivables | 176.4 | 173.6
Allowance for doubtful accounts | (1.3) | (1.3)
Trade receivables, net | $175.1 | $172.3


Question: What was the change in trade receivables between 2018 and 2019?
Answer: 2.8
Calculation: 176.4-173.6
25. Deferred income
The Group’s deferred income balances relate solely to revenue from contracts with customers.
Table:
 | 2019 | 2018
 | $ million | $ million
Current | 53.2 | 55.2
Non-current | 13.6 | 14.4
 | 66.8 | 69.6


Question: What does the Group's deferred income balances relate to?
Answer: relate solely to revenue from contracts with customers
Note 13. Investments Held in Rabbi Trust
The mutual funds held in the rabbi trust were 66% equity-based and 34% debt-based as of December 31, 2019. Net investment income (losses), included in “Other income (expense), net” in the accompanying Consolidated Statements of Operations consisted of the following (in thousands):
Table:
 |  | Years Ended December 31, | 
 | 2019 | 2018 | 2017
Net realized gains (losses) from sales of trading securities | $143 | $10 | $195
Dividend and interest income | 419 | 635 | 422
Net unrealized holding gains (losses) | 1,817 | (1,512) | 1,002
 | $2,379 | $(867) | $1,619


Question: What was the amount of Dividend and interest income in 2019?
Answer: 419