hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
five-year performance comparison 2013 the following graph provides an indicator of cumulative total shareholder returns for the corporation as compared to the peer group index ( described above ) , the dow jones , and the s&p 500 . the graph assumes that the value of the investment in the common stock of union pacific corporation and each index was $ 100 on december 31 , 2005 and that all dividends were reinvested . purchases of equity securities 2013 during 2010 , we repurchased 17556522 shares of our common stock at an average price of $ 75.51 . the following table presents common stock repurchases during each month for the fourth quarter of 2010 : period total number of shares purchased [a] average price paid per share total number of shares purchased as part of a publicly announced plan or program [b] maximum number of shares that may yet be purchased under the plan or program [b] .

Table:
period | total number ofsharespurchased [a] | averageprice paidper share | total number of sharespurchased as part of apublicly announced planor program [b] | maximum number ofshares that may yetbe purchased under the planor program [b]
oct . 1 through oct . 31 | 725450 | 84.65 | 519554 | 17917736
nov . 1 through nov . 30 | 1205260 | 89.92 | 1106042 | 16811694
dec . 1 through dec . 31 | 1133106 | 92.59 | 875000 | 15936694
total | 3063816 | $ 89.66 | 2500596 | n/a
[a] total number of shares purchased during the quarter includes approximately 563220 shares delivered or attested to upc by employees to pay stock option exercise prices , satisfy excess tax withholding obligations for stock option exercises or vesting of retention units , and pay withholding obligations for vesting of retention shares .
[b] on may 1 , 2008 , our board of directors authorized us to repurchase up to 40 million shares of our common stock through march 31 , 2011 .
we may make these repurchases on the open market or through other transactions .
our management has sole discretion with respect to determining the timing and amount of these transactions .
on february 3 , 2011 , our board of directors authorized us to repurchase up to 40 million additional shares of our common stock under a new program effective from april 1 , 2011 through march 31 , 2014. .

Question: for the quarter ended december 312010 what was percent of the total number of shares purchased in november
Answer: 39.3%
Calculation: divide(1205260, 3063816)
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 is the long term position loans payable for 2018?
Answer: $88
5. Remuneration continued
Remuneration at a glance 2019
How we performed
The above figures exclude the acquisition of Thermocoax.
Table:
Remuneration key performance indicator | 2019 actual | 2019 threshold | 2019 target | 2019 maximum | Remuneration measure
Group operating profit (£m) | 277.3 | 256.7 | 270.3 | 283.8 | Annual Incentive Plan
Group cash generation (£m) | 296.4 | 270.7 | 285.0 | 299.2 | Annual Incentive Plan
Group ROCE (%) | 54.5 | 50.1 | 52.7 | 55.3 | Annual Incentive Plan
2017-2019 EPS (%) | 57.5 | 27.6 | N/A | 52.3 | Performance Share Plan
2017-2019 relative TSR (percentile TSR) | 94th | 50th | N/A | 75th | Performance Share Plan


Question: What are the plans under remuneration measure?
Answer: Annual Incentive Plan, Performance Share Plan
Geographic information
The Group is domiciled in the UK and the following tables detail external revenue by location of customers, trade receivables and non-current assets (excluding deferred tax) by geographic area:
Due to the large number of customers the Group serves, there are no individual customers whose revenue is greater than 10% of the Group’s total revenue in all periods presented in these financial statements.
Table:
 | 2019 | 2018
Revenue | £m | £m
UK | 349.9 | 324.9
Ireland | 5.2 | 5.2
Total revenue | 355.1 | 330.1


Question: How is external revenue detailed?
Answer: by location of customers, trade receivables and non-current assets (excluding deferred tax) by geographic area:
.

Table:
( $ in millions except per share amounts ) | year ended december 31 2014 1st qtr | year ended december 31 2014 2nd qtr | year ended december 31 2014 3rd qtr | year ended december 31 2014 4th qtr ( 3 )
sales and service revenues | $ 1594 | $ 1719 | $ 1717 | $ 1927
operating income ( loss ) | 159 | 181 | 171 | 144
earnings ( loss ) before income taxes | 132 | 152 | 144 | 79
net earnings ( loss ) | 90 | 100 | 96 | 52
dividends declared per share | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.40
basic earnings ( loss ) per share | $ 1.83 | $ 2.05 | $ 1.97 | $ 1.07
diluted earnings ( loss ) per share | $ 1.81 | $ 2.04 | $ 1.96 | $ 1.05
( 3 ) in the fourth quarter of 2014 , the company recorded a $ 47 million goodwill impairment charge .
item 9 .
changes in and disagreements with accountants on accounting and financial disclosure item 9a .
controls and procedures disclosure controls and procedures the company's management , with the participation of the company's chief executive officer and chief financial officer , has evaluated the effectiveness of the company's disclosure controls and procedures ( as defined in rules 13a-15 ( e ) and 15d-15 ( e ) under the securities exchange act of 1934 , as amended ( the "exchange act" ) ) as of december 31 , 2015 .
based on that evaluation , the company's chief executive officer and chief financial officer concluded that , as of december 31 , 2015 , the company's disclosure controls and procedures were effective to ensure that information required to be disclosed in reports the company files or submits under the exchange act is ( i ) recorded , processed , summarized and reported within the time periods specified in sec rules and forms , and ( ii ) accumulated and communicated to management to allow their timely decisions regarding required disclosure .
changes in internal control over financial reporting during the three months ended december 31 , 2015 , no change occurred in the company's internal control over financial reporting that materially affected , or is reasonably likely to materially affect , the company's internal control over financial reporting. .

Question: what was the operating margin in the 4th quarter
Answer: 7.5%
Calculation: divide(144, 1927)
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed)
Cash and Cash Equivalents—Cash and cash equivalents include cash on hand, demand deposits and short-term investments with original maturities of three months or less. The Company maintains its deposits at high-quality financial institutions and monitors the credit ratings of those institutions.
Restricted Cash—Restricted cash includes cash pledged as collateral to secure obligations and all cash whose use is otherwise limited by contractual provisions.
The reconciliation of cash and cash equivalents and restricted cash reported within the applicable balance sheet that sum to the total of the same such amounts shown in the statements of cash flows is as follows:
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Cash and cash equivalents | $1,501.2 | $1,208.7 | $802.1
Restricted cash | 76.8 | 96.2 | 152.8
Total cash, cash equivalents and restricted cash | $1,578.0 | $1,304.9 | $954.9


Question: What was the Cash and cash equivalents in 2019?
Answer: $1,501.2
BELL WIRELESS RESULTS
REVENUES
Bell Wireless operating revenues increased by 3.7% in 2019, compared to 2018, driven by greater postpaid and prepaid service revenues and higher product revenues.
Service revenues increased by 2.5% in 2019, compared to last year, driven by: • Continued growth in our postpaid and prepaid subscriber base coupled with rate increases • A greater mix of customers subscribing to higher-value monthly plans including unlimited data plans launched in June 2019 • The favourable year-over-year impact from the 2018 CRTC retroactive decision on wireless domestic wholesale roaming rates
These factors were partly offset by: • Greater sales of premium handsets and more customers subscribing to higher-value monthly plans • Lower data and voice overages driven by increased customer adoption of monthly plans with higher data allotments and richer voice plans
Product revenues increased by 6.6% in 2019, compared to last year, driven by greater sales of premium handsets and the impact of higher-value rate plans in our sales mix.
Table:
 | 2019 | 2018 | $ CHANGE | % CHANGE
External service revenues | 6,427 | 6,269 | 158 | 2.5%
Inter-segment service revenues | 49 | 48 | 1 | 2.1%
Total operating service revenues | 6,476 | 6,317 | 159 | 2.5%
External product revenues | 2,660 | 2,497 | 163 | 6.5%
Inter-segment product revenues | 6 | 4 | 2 | 50.0%
Total operating product revenues | 2,666 | 2,501 | 165 | 6.6%
Total Bell Wireless revenues | 9,142 | 8,818 | 324 | 3.7%


Question: What was the percentage change in External service revenues in 2019 compared to the previous year?
Answer: 2.5%
Disaggregated Revenue
The table below includes the Company’s revenue for the fiscal year ended September 28, 2019 disaggregated by geographic reportable segment and market sector (in thousands):
Table:
 |  | Fiscal Year Ended September 28, 2019 |  | 
 |  | Reportable Segment: |  | 
 | AMER  | APAC  | EMEA  | Total
Market Sector: |  |  |  | 
Healthcare/Life Sciences  | $488,851 | $602,922 | $128,225 | $1,219,998
Industrial/Commercial  | 359,381 | 534,971 | 86,868 | 981,220
Aerospace/Defense  | 317,558 | 186,486 | 84,556 | 588,600
Communications  | 256,523 | 113,329 | 4,764 | 374,616
     External revenue  | 1,422,313 | 1,437,708 | 304,413 | 3,164,434
Inter-segment sales  | 6,995 | 119,497 | 5,520 | 132,012
    Segment revenue  | $1,429,308 | $1,557,205 | $309,933 | $3,296,446


Question: What was the percentage constituent of total external revenue to segment revenue?
Answer: 96
Calculation: (3,164,434/3,296,446) * 100
Cost of Net Revenue and Gross Profit
Cost of net revenue decreased $26.7 million to $149.5 million for the year ended December 31, 2019, as compared to $176.2 million for the year ended December 31, 2018. The decrease was primarily driven by lower sales. The decrease in gross profit percentage for the year ended December 31, 2019, as compared to the year ended December 31, 2018, was due to lower revenue and product mix.
We currently expect that gross profit percentage will fluctuate in the future, from period-to-period, based on changes in product mix, average selling prices, and average manufacturing costs.
Table:
 | Year Ended December 31, |  | % Change
 | 2019 | 2018 | 2019
 |  | (dollars in thousands) | 
Cost of net revenue | $149,495 | $176,223 | (15)%
% of net revenue | 47% | 46% | 
Gross profit | 167,685 | 208,774 | (20)%
% of net revenue | 53% | 54% | 


Question: What is the average % of net revenue for cost of net revenue for the Years Ended December 31, 2019 to 2018?
Answer: 46.5
Calculation: (47+46) / 2
Key Metrics
In addition to our results determined in accordance with GAAP, we believe the following operating metrics are useful as supplements in evaluating our ongoing operational performance and help provide an enhanced understanding of our business:
Total bookings. Total bookings represents cash receipts from the sale of products to customers in a given period adjusted for products where we recognize revenue on a net basis and without giving effect to certain adjustments, primarily net refunds granted in the period. Total bookings provides valuable insight into the sales of our products and the performance of our business since we typically collect payment at the time of sale and recognize revenue ratably over the term of our customer contracts. We report total bookings without giving effect to refunds granted in the period because refunds often occur in periods different from the period of sale for reasons unrelated to the marketing efforts leading to the initial sale. Accordingly, by excluding net refunds, we believe total bookings reflects the effectiveness of our sales efforts in a given period.
Total customers. We define a customer as an individual or entity, as of the end of a period, having an account with one or more paid product subscriptions. A single user may be counted asacustomer more than once if the user maintains paid subscriptions in multiple accounts. Total customers is one way we measure the scale of our business and is an important part of our ability to increase our revenue base
Average revenue per user (ARPU). We calculate ARPU as total revenue during the preceding 12 month period divided by the average of the number of total customers at the beginning and end of the period. ARPU provides insight into our ability to sell additional products to customers, though the impact to date has been muted due to our continued growth in total customers.
Table:
 | Year Ended December 31, |  |  |  | 
 | 2019 | 2018 | 2017 | 2016 | 2015
 | (unaudited) |  |  |  | 
Total bookings (in millions) | $3,401.2 | $3,011.5 | $2,618.2 | $2,155.5 | $1,914.2
Total customers at period end (in thousands) | 19,274 | 18,518 | 17,339 | 14,740 | 13,774
Average revenue per user | $158 | $148 | $139 | $130 | $121


Question: What is the total number of customers at each listed period end, in chronological order?
Answer: 13,774, 14,740, 17,339, 18,518, 19,274
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 is the percentage change in the equipment notes payable from 2018 to 2019?
Answer: -63.49
Calculation: ((88-241)/241) * 100
part ii item 5 2014market for registrant 2019s common equity and related stockholder matters ( a ) market information . the common stock of the company is currently traded on the new york stock exchange ( nyse ) under the symbol 2018 2018aes 2019 2019 . the following tables set forth the high and low sale prices for the common stock as reported by the nyse for the periods indicated . price range of common stock .

Table:
2001 first quarter | high $ 60.15 | low $ 41.30 | 2000 first quarter | high $ 44.72 | low $ 34.25
second quarter | 52.25 | 39.95 | second quarter | 49.63 | 35.56
third quarter | 44.50 | 12.00 | third quarter | 70.25 | 45.13
fourth quarter | 17.80 | 11.60 | fourth quarter | 72.81 | 45.00
( b ) holders .
as of march 2 , 2002 , there were 9967 record holders of the company 2019s common stock , par value $ 0.01 per share .
( c ) dividends .
under the terms of the company 2019s corporate revolving loan and letters of credit facility of $ 850 million entered into with a commercial bank syndicate and other bank agreements , the company is currently limited in the amount of cash dividends it is allowed to pay .
in addition , the company is precluded from paying cash dividends on its common stock under the terms of a guaranty to the utility customer in connection with the aes thames project in the event certain net worth and liquidity tests of the company are not met .
the company has met these tests at all times since making the guaranty .
the ability of the company 2019s project subsidiaries to declare and pay cash dividends to the company is subject to certain limitations in the project loans , governmental provisions and other agreements entered into by such project subsidiaries .
such limitations permit the payment of cash dividends out of current cash flow for quarterly , semiannual or annual periods only at the end of such periods and only after payment of principal and interest on project loans due at the end of such periods , and in certain cases after providing for debt service reserves. .

Question: what was average of high and low stock prices for the first quarter of 2000?
Answer: 39.49
Calculation: add(44.72, 34.25), divide(#0, const_2)
Note 3 – Net Income per Share
Potentially dilutive securities that have been excluded from the calculation of diluted net income per common share because the effect is anti-dilutive are as follows:
Table:
Fiscal Year Ended |  |  | 
 | December 27, 2019 | December 28, 2018 | December 29, 2017
Restricted Share Awards (“RSAs”) | 132,861 | 42 | 84,511
Stock options | — | — | 201,799
Convertible notes | 76,384 | — | —


Question: What is the Restricted Share Awards (“RSAs”) for fiscal years 2019, 2018 and 2017 respectively?
Answer: 132,861, 42, 84,511
Note 8: Net Income per Share
Basic net income per share is computed by dividing net income by the weighted-average number of common shares outstanding during the period. Diluted net income per share is computed using the treasury stock method, for dilutive stock options, restricted stock units, and convertible notes.
The following table reconciles the numerators and denominators of the basic and diluted computations for net income per share.
(1) Diluted shares outstanding do not include any effect resulting from note hedges associated with the Company’s 2018 Notes as their impact would have been anti-dilutive.
Table:
 |  | YearEnded | 
 | June 30, 2019 | June 24, 2018 | June 25, 2017
 |  | (in thousands, except per share data) | 
Numerator: |  |  | 
Net income | $2,191,430 | $2,380,681 | $1,697,763
Denominator: |  |  | 
Basic average shares outstanding | 152,478 | 161,643 | 162,222
Effect of potential dilutive securities: |  |  | 
Employee stock plans | 1,323 | 2,312 | 2,058
Convertible notes | 5,610 | 12,258 | 16,861
Warrants | 504 | 4,569 | 2,629
Diluted average shares outstanding | 159,915 | 180,782 | 183,770
Net income per share-basic | $14.37 | $14.73 | $10.47
Net income per share-diluted | $13.70 | $13.17 | $9.24


Question: In which year is the Diluted average shares outstanding is the highest?
Answer: 2017
Calculation: Find the year with the highest diluted average shares outstanding