hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Purchases of Accenture plc Class A Ordinary Shares
The following table provides information relating to our purchases of Accenture plc Class A ordinary shares during the fourth quarter of fiscal 2019. For year-to-date information on all of our share purchases, redemptions and exchanges and further discussion of our share purchase activity, see “Management’s Discussion and Analysis of Financial Condition and Results of Operations—Liquidity and Capital Resources—Share Purchases and Redemptions.”
(1) Average price paid per share reflects the total cash outlay for the period, divided by the number of shares acquired, including those acquired by purchase or redemption for cash and any acquired by means of employee forfeiture.
(2) Since August 2001, the Board of Directors of Accenture plc has authorized and periodically confirmed a publicly
announced open-market share purchase program for acquiring Accenture plc Class A ordinary shares. During
the fourth quarter of fiscal 2019, we purchased 2,048,307 Accenture plc Class A ordinary shares under this
program for an aggregate price of $389 million. The open-market purchase program does not have an expiration
date
(3) As of August 31, 2019, our aggregate available authorization for share purchases and redemptions was $3,674 million, which management has the discretion to use for either our publicly announced open-market share purchase program or our other share purchase programs. Since August 2001 and as of August 31, 2019, the Board of Directors of Accenture plc has authorized an aggregate of $35.1 billion for share purchases and redemptions by Accenture plc and Accenture Canada Holdings Inc
(4) During the fourth quarter of fiscal 2019, Accenture purchased 66,017 Accenture plc Class A ordinary shares in transactions unrelated to publicly announced share plans or programs. These transactions consisted of acquisitions of Accenture plc Class A ordinary shares primarily via share withholding for payroll tax obligations due from employees and former employees in connection with the delivery of Accenture plc Class A ordinary shares under our various employee equity share plans. These purchases of shares in connection with employee share plans do not affect our aggregate available authorization for our publicly announced open-market share purchase and our other share purchase programs.
Table:
Period | Total Number of Shares Purchased | Average Price Paid per Share (1) | Total Number of Shares Purchased as Part of Publicly Announced Plans or Programs (2) | Approximate Dollar Value of Shares that May Yet Be Purchased Under the Plans or Programs (3)
 |  |  |  | (in millions of U.S. dollars)
June 1, 2019 — June 30, 2019 | 801,659 | $183.18 | 785,600 | $3,924
July 1, 2019 — July 31, 2019 | 462,629 | $194.65 | 442,846 | $3,832
August 1, 2019 — August 31, 2019 | 850,036 | $193.23 | 819,861 | $3,674
Total (4) | 2,114,324 | $189.73 | 2,048,307 | 


Question: When did Accenture's Board of Directors authorize and confirm an open-market share purchase program for acquiring Accenture pls Class A ordinary shares?
Answer: August 2001
american tower corporation and subsidiaries notes to consolidated financial statements the allocation of the purchase price was finalized during the year ended december 31 , 2012 . the following table summarizes the allocation of the aggregate purchase consideration paid and the amounts of assets acquired and liabilities assumed based upon their estimated fair value at the date of acquisition ( in thousands ) : purchase price allocation .

Table:
 | final purchase price allocation
non-current assets | $ 2
property and equipment | 3590
intangible assets ( 1 ) | 1062
other non-current liabilities | -91 ( 91 )
fair value of net assets acquired | $ 4563
goodwill ( 2 ) | 89
( 1 ) consists of customer-related intangibles of approximately $ 0.4 million and network location intangibles of approximately $ 0.7 million .
the customer-related intangibles and network location intangibles are being amortized on a straight-line basis over periods of up to 20 years .
( 2 ) the company expects that the goodwill recorded will be deductible for tax purposes .
the goodwill was allocated to the company 2019s international rental and management segment .
colombia 2014colombia movil acquisition 2014on july 17 , 2011 , the company entered into a definitive agreement with colombia movil s.a .
e.s.p .
( 201ccolombia movil 201d ) , whereby atc sitios infraco , s.a.s. , a colombian subsidiary of the company ( 201catc infraco 201d ) , would purchase up to 2126 communications sites from colombia movil for an aggregate purchase price of approximately $ 182.0 million .
from december 21 , 2011 through the year ended december 31 , 2012 , atc infraco completed the purchase of 1526 communications sites for an aggregate purchase price of $ 136.2 million ( including contingent consideration of $ 17.3 million ) , subject to post-closing adjustments .
through a subsidiary , millicom international cellular s.a .
( 201cmillicom 201d ) exercised its option to acquire an indirect , substantial non-controlling interest in atc infraco .
under the terms of the agreement , the company is required to make additional payments upon the conversion of certain barter agreements with other wireless carriers to cash paying lease agreements .
based on the company 2019s current estimates , the value of potential contingent consideration payments required to be made under the amended agreement is expected to be between zero and $ 32.8 million and is estimated to be $ 17.3 million using a probability weighted average of the expected outcomes at december 31 , 2012 .
during the year ended december 31 , 2012 , the company recorded a reduction in fair value of $ 1.2 million , which is included in other operating expenses in the consolidated statements of operations. .

Question: what was the cost per tower in the colombia movil acquisition?
Answer: 856067
Calculation: multiply(182.0, const_1000000), divide(#0, 2126)
18. Geographic Information
Property and equipment, net by geography was as follows:
No individual international country represented more than 10% of property and equipment, net in any period presented.
Table:
 | Year Ended December31, | 
 | 2019 | 2018
U.S. | 200.4 | 231.0
International | 58.2 | 68.0
 | $258.6 | $299.0


Question: What information does the table show?
Answer: Property and equipment, net by geography
Commitments and Significant Contractual Obligations
The following table summarizes our contractual obligations and commercial commitments at December 27, 2019:
(1) Interest on our various outstanding debt instruments is included in the above table, except for our Term Loan and ABL, which have floating interest rates. At December 27, 2019, we had borrowings of $238.1 million under our Term Loan and zero under our ABL. During the fiscal year ended December 27, 2019, the weighted average interest rate on our Term Loan was approximately 5.8% and we incurred interest expense of approximately $13.9 million. During the fiscal year ended December 27, 2019, the weighted average interest rate on our ABL borrowings was approximately 3.7% and we incurred interest expense of approximately $1.6 million. See Note 9 “Debt Obligations” to our consolidated financial statements for further information on our debt instruments.
(2) The table above excludes cash to be paid for income taxes, $14.7 million of total contingent earn-out liabilities related to certain acquisitions as of December 27, 2019 and approximately $5.3 million of lease payments related to long-term leases for several vehicles and a distribution and processing facility that do not commence until fiscal 2020.
We had outstanding letters of credit of approximately $16.6 million and $15.8 million at December 27, 2019 and December 28, 2018, respectively. Substantially all of our assets are pledged as collateral to secure our borrowings under our credit facilities.
Table:
 |  |  | Payments Due by Period (1, 2) |  | 
 | Total  | Less than One Year | 1-3 Years | 4-5 Years | Thereafter
 |  |  | (In thousands) |  | 
Inventory purchase commitments | $53,413 | $53,413 | $— | $— | $—
Indebtedness | $406,644 | $2,993 | $244,151 | $159,500 | $—
Finance lease obligations  | $4,597 | $880 | $1,715 | $1,392 | $610
Pension exit liabilities  | $2,169 | $149 | $329 | $375 | $1,316
Long-term operating leases  | $197,359 | $25,662 | $43,130 | $30,080 | $98,487
Total  | $664,182 | $83,097 | $289,325 | $191,347 | $100,413


Question: What is the difference in the total Indebtedness and total Inventory purchase commitments for all periods?
Answer: 353231
Calculation: 406,644-53,413
Operating Leases and Other Contractual Commitments
VMware leases office facilities and equipment under various operating arrangements. VMware’s minimum future lease commitments and other contractual commitments at January 31, 2020 were as follows (table in millions):
(1) Amounts in the table above exclude legally binding minimum lease payments for leases signed but not yet commenced of $361 million, as well as expected sublease income.
The amount of the future lease commitments after fiscal 2025 is primarily for the ground leases on VMware’s Palo Alto, California headquarter facilities, which expire in fiscal 2047. As several of VMware’s operating leases are payable in foreign currencies, the operating lease payments may fluctuate in response to changes in the exchange rate between the U.S. dollar and the foreign currencies in which the commitments are payable.
Table:
 | Future Lease Commitments(1) | Purchase Obligations | Asset Retirement Obligations | Total
2021 | $144 | $168 | $1 | $313
2022 | 141 | 74 | 3 | 218
2023 | 127 | 13 | 2 | 142
2024 | 101 | — | — | 101
2025 | 77 | — | 2 | 79
Thereafter | 612 | — | 5 | 617
Total | $1,202 | $255 | $13 | $1,470


Question: What were the Asset Retirement Obligations in 2023?
Answer: 2
d) Transaction with other related parties:
Net revenues/(expenses): The transactions with other related parties for the years ended December 31, 2019, 2018 and 2017 consisted of the following:
(i) The Cool Pool - On July 8, 2019 GasLog's vessel charter contracts had concluded and withdrew their participation from the Cool Pool. Following Gaslog's departure, we assumed sole responsibility for the management of the Cool Pool and consolidate the Cool Pool. From point of consolidation, the Cool Pool ceased to be a related party.
(ii) Magni Partners - Tor Olav Trøim is the founder of, and partner in, Magni Partners (Bermuda) Limited, a privately held Bermuda company, and is the ultimate beneficial owner of the company. Receivables and payables from Magni Partners comprise primarily of the cost (without mark-up) or part cost of personnel employed by Magni Partners who have providedadvisory and management services to Golar. These costs do not include any payment for any services provided by Tor Olav Trøim himself.
iii) Borr Drilling - Tor Olav Trøim is the founder, and director of Borr Drilling, a Bermuda company listed on the Oslo and NASDAQ stock exchanges. Receivables comprise primarily of management and administrative services provided by our Bermuda corporate office.
iv) 2020 Bulkers - 2020 Bulkers is a related party by virtue of common directorships. Receivables comprise primarily of management and administrative services provided by our Bermuda corporate office.
Table:
(in thousands of $) | 2019 | 2018 | 2017
The Cool Pool (i) | 39,666 | 151,152 | 59,838
Magni Partners (ii) | (858) | (375) | (260)
Borr Drilling (iii) | 542 | — | —
2020 Bulkers (iv) | 265 | — | —
Total | 39,615 | 150,777 | 59,578


Question: In which years was the transaction with other related parties recorded for?
Answer: 2019, 2018, 2017
jpmorgan chase & co./2015 annual report 233 note 11 2013 noninterest expense for details on noninterest expense , see consolidated statements of income on page 176 . included within other expense is the following : year ended december 31 , ( in millions ) 2015 2014 2013 .

Table:
year ended december 31 ( in millions ) | 2015 | 2014 | 2013
legal expense | $ 2969 | $ 2883 | $ 11143
federal deposit insurance corporation-related ( 201cfdic 201d ) expense | 1227 | 1037 | 1496
federal deposit insurance corporation-related ( 201cfdic 201d ) expense 1227 1037 1496 note 12 2013 securities securities are classified as trading , afs or held-to-maturity ( 201chtm 201d ) .
securities classified as trading assets are discussed in note 3 .
predominantly all of the firm 2019s afs and htm investment securities ( the 201cinvestment securities portfolio 201d ) are held by treasury and cio in connection with its asset-liability management objectives .
at december 31 , 2015 , the investment securities portfolio consisted of debt securities with an average credit rating of aa+ ( based upon external ratings where available , and where not available , based primarily upon internal ratings which correspond to ratings as defined by s&p and moody 2019s ) .
afs securities are carried at fair value on the consolidated balance sheets .
unrealized gains and losses , after any applicable hedge accounting adjustments , are reported as net increases or decreases to accumulated other comprehensive income/ ( loss ) .
the specific identification method is used to determine realized gains and losses on afs securities , which are included in securities gains/ ( losses ) on the consolidated statements of income .
htm debt securities , which management has the intent and ability to hold until maturity , are carried at amortized cost on the consolidated balance sheets .
for both afs and htm debt securities , purchase discounts or premiums are generally amortized into interest income over the contractual life of the security .
during 2014 , the firm transferred u.s .
government agency mortgage-backed securities and obligations of u.s .
states and municipalities with a fair value of $ 19.3 billion from afs to htm .
these securities were transferred at fair value , and the transfer was a non-cash transaction .
aoci included net pretax unrealized losses of $ 9 million on the securities at the date of transfer .
the transfer reflected the firm 2019s intent to hold the securities to maturity in order to reduce the impact of price volatility on aoci and certain capital measures under basel iii. .

Question: what was the minimum legal expense in the past three years?
Answer: 2883
Calculation: table_min(legal expense, none)
Geographic Information
The amounts for revenue by region in the following tables are based on the location of customers. The regions in the following table are EMEA (Europe, Middle East, and Africa), Americas (North America and Latin America), and APJ (Asia Pacific Japan).
Total Revenue by Region
Table:
€ millions | 2019 | 2018 | 2017
Germany | 3,948 | 3,658 | 3,352
Rest of EMEA | 8,158 | 7,446 | 7,063
EMEA | 12,105 | 11,104 | 10,415
United States | 9,085 | 7,880 | 7,436
Rest of Americas | 2,109 | 1,832 | 1,911
Americas | 11,194 | 9,713 | 9,347
Japan | 1,180 | 963 | 885
Rest of APJ | 3,074 | 2,928 | 2,814
APJ | 4,254 | 3,891 | 3,699
SAP Group | 27,553 | 24,708 | 23,461


Question: What are the broad categories making up the total revenue by region?
Answer: EMEA, Americas, APJ
performance graph the graph below compares the cumulative total shareholder return on pmi's common stock with the cumulative total return for the same period of pmi's peer group and the s&p 500 index . the graph assumes the investment of $ 100 as of december 31 , 2012 , in pmi common stock ( at prices quoted on the new york stock exchange ) and each of the indices as of the market close and reinvestment of dividends on a quarterly basis . date pmi pmi peer group ( 1 ) s&p 500 index .

Table:
date | pmi | pmi peer group ( 1 ) | s&p 500 index
december 31 2012 | $ 100.00 | $ 100.00 | $ 100.00
december 31 2013 | $ 108.50 | $ 122.80 | $ 132.40
december 31 2014 | $ 106.20 | $ 132.50 | $ 150.50
december 31 2015 | $ 120.40 | $ 143.50 | $ 152.60
december 31 2016 | $ 130.80 | $ 145.60 | $ 170.80
december 31 2017 | $ 156.80 | $ 172.70 | $ 208.10
( 1 ) the pmi peer group presented in this graph is the same as that used in the prior year , except reynolds american inc .
was removed following the completion of its acquisition by british american tobacco p.l.c .
on july 25 , 2017 .
the pmi peer group was established based on a review of four characteristics : global presence ; a focus on consumer products ; and net revenues and a market capitalization of a similar size to those of pmi .
the review also considered the primary international tobacco companies .
as a result of this review , the following companies constitute the pmi peer group : altria group , inc. , anheuser-busch inbev sa/nv , british american tobacco p.l.c. , the coca-cola company , colgate-palmolive co. , diageo plc , heineken n.v. , imperial brands plc , japan tobacco inc. , johnson & johnson , kimberly-clark corporation , the kraft-heinz company , mcdonald's corp. , mondel z international , inc. , nestl e9 s.a. , pepsico , inc. , the procter & gamble company , roche holding ag , and unilever nv and plc .
note : figures are rounded to the nearest $ 0.10. .

Question: what was the percentage cumulative total shareholder return on pmi's common stock for the five years ended december 31 , 2017?
Answer: 56.80%
Calculation: subtract(156.80, const_100), divide(#0, const_100)
24. Operating lease commitments
The Group has lease agreements in respect of property, plant and equipment, for which future minimum payments extend over a number of years.
Leases primarily relate to the Group’s properties, which principally comprise offices and factories. Lease payments are typically subject to market review every five years to reflect market rentals, but because of the uncertainty over the amount of any future changes, such changes have not been reflected in the table below. Within our leasing arrangements there are no significant contingent rental, renewal, purchase or escalation clauses.
The future aggregate minimum lease payments under non-cancellable operating leases for continuing operations are as follows:
The Group has made provision for the aggregate minimum lease payments under non-cancellable operating leases. The Group sub-lets various properties under non-cancellable lease arrangements. Sub-lease receipts of £0.2m (2017/18: £0.2m) were recognised in the statement of profit or loss during the period. The total future minimum sub-lease payments at the period end is £0.2m (2017/18: £0.2m).
Table:
 | As at 30 Mar 2019 |  | As at 31 Mar 2018 | 
 | Property | Plant and Equipment | Property | Plant and Equipment
 | £m | £m | £m | £m
Within one year | 1.8 | 1.3 | 2.5 | 1.8
Between 2 and 5 years | 6.3 | 2.4 | 5.3 | 1.9
After 5 years | 6.0 | 0.5 | 9.4 | –
Total | 14.1 | 4.2 | 17.2 | 3.7


Question: What was the property payment within between 2 and 5 years in 2019?
Answer: 6.3
iv. Details of the Remuneration for the year ended March 31, 2019:
a. Non-Executive Directors:
@ As a policy, N Chandrasekaran, Chairman, has abstained from receiving commission from the
Company.
@@ In line with the internal guidelines of the Company, no payment is made towards commission to
the Non-Executive Directors of the Company, who are in full time employment with any other Tata
company.
* Relinquished the position of Independent Director w.e.f. July 10, 2018.
** Relinquished the position of Independent Director w.e.f. September 28, 2018.
*** Appointed as an Additional and Independent Director w.e.f. December 18, 2018.
**** Appointed as an Additional and Independent Director w.e.f. January 10, 2019.
Table:
 |  | (` lakh)
Name | Commission | Sitting Fees
N Chandrasekaran, Chairman@ | - | 3.60
Aman Mehta | 315.00 | 4.80
V Thyagarajan* | 100.00 | 3.00
Prof Clayton M Christensen** | 75.00 | 0.30
Dr Ron Sommer | 220.00 | 5.10
O P Bhatt | 215.00 | 7.50
Aarthi Subramanian@@ | - | 5.70
Dr Pradeep Kumar Khosla | 150.00 | 2.10
Hanne Sorensen*** | 50.00 | 0.60
Keki Mistry*** | 50.00 | 0.60
Don Callahan**** | 35.00 | 0.30
Total | 1,210.00 | 33.60


Question: What is the ratio of total commission to total sitting fees?
Answer: 36.01
Calculation: 1,210/33.6
2017 Restructuring Plan
On September 15, 2016, the Company’s Board of Directors formally approved a restructuring plan to better align the Company’s global capacity and administrative support infrastructure to further optimize organizational effectiveness. This action includes headcount reductions across the Company’s selling, general and administrative cost base and capacity realignment in higher cost locations (the “2017 Restructuring Plan”).
The 2017 Restructuring Plan, totaling $195.0 million in restructuring and other related costs, is complete as of August 31, 2019.
The tables below summarize the Company’s liability activity, primarily associated with the 2017 Restructuring Plan (in thousands):
Table:
 | Employee Severance and Benefit Costs | Lease Costs | Asset Write-off Costs | Other Related Costs | Total
Balance as of August 31, 2017 | $ 33,580 | $1,665 | $ — | $ 3,143 | $38,388
Restructuring related charges | 16,269 | 1,596 | 16,264 | 2,773 | 36,902
Asset write-off charge and other non-cash activity | (127) | 525 | (16,264) | 25 | (15,841)
Cash payments | (31,591) | (1,102) | — | (5,419) | (38,112)
Balance as of August 31, 2018 | 18,131 | 2,684 | — | 522 | 21,337
Restructuring related charges | 16,029 | (41) | (3,566) | 2,071 | 14,493
Asset write-off charge and other non-cash activity | (494) | — | 3,566 | (18) | 3,054
Cash payments | (30,504) | (663) | — | (1,786) | (32,953)
Balance as of August 31, 2019 | $3,162 | $1,980 | $— | $789 | $5,931


Question: What was the total balance as of August 31, 2017?
Answer: $38,388
3 . dividends from subsidiaries and affiliates cash dividends received from consolidated subsidiaries and from affiliates accounted for by the equity method were as follows ( in millions ) : .

Table:
 | 2003 | 2002 | 2001
subsidiaries | $ 807 | $ 771 | $ 1038
affiliates | 43 | 44 | 21
4 .
guarantees and letters of credit guarantees 2014in connection with certain of its project financing , acquisition , and power purchase agreements , the company has expressly undertaken limited obligations and commitments , most of which will only be effective or will be terminated upon the occurrence of future events .
these obligations and commitments , excluding those collateralized by letter of credit and other obligations discussed below , were limited as of december 31 , 2003 , by the terms of the agreements , to an aggregate of approximately $ 515 million representing 55 agreements with individual exposures ranging from less than $ 1 million up to $ 100 million .
of this amount , $ 147 million represents credit enhancements for non-recourse debt , and $ 38 million commitments to fund its equity in projects currently under development or in construction .
letters of credit 2014at december 31 , 2003 , the company had $ 89 million in letters of credit outstanding representing 9 agreements with individual exposures ranging from less than $ 1 million up to $ 36 million , which operate to guarantee performance relating to certain project development and construction activities and subsidiary operations .
the company pays a letter of credit fee ranging from 0.5% ( 0.5 % ) to 5.00% ( 5.00 % ) per annum on the outstanding amounts .
in addition , the company had $ 4 million in surety bonds outstanding at december 31 , 2003. .

Question: what was the average dividend or cash dividends received from consolidated subsidiaries and from affiliates accounted for by the equity method in millions in 2003?
Answer: 18.8
Calculation: divide(807, 43)
Below is the summary of the FY17 PRUs vested and earned by each NEO.
(1) The Compensation Committee did not exercise its discretion to reduce any payouts.
Table:
NEO | Total FY17 PRUs Vested at end of FY18 | Total FY17 PRUs Vested at end of FY19 | Total FY17 PRUs Earned and Vested (1)
Gregory S. Clark | 2,404,175 | 175,023 | 2,579,198
Nicholas R. Noviello | 606,935 | 44,184 | 651,119
Amy L. Cappellanti-Wolf | 207,142 | 15,080 | 222,222
Samir Kapuria | 148,322 | 10,798 | 159,120
Scott C. Taylor | 414,287 | 30,160 | 444,447


Question: Were any payouts reduced by the Compensation Committee?
Answer: The Compensation Committee did not exercise its discretion to reduce any payouts