hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Item 2. Properties
Our corporate headquarters are located in Culver City, California, where we occupy facilities totaling approximately 8,000 square feet on a monthto-month basis pursuant to a Shared Services Agreement with NantWorks. We use these facilities for administration, sales and marketing, research and development, engineering, client support, and professional services. In addition, we have 5 U.S. locations across four states and one international location. Our key facilities include the following:
United States
Boston, Massachusetts
Panama City, Florida
Philadelphia, Pennsylvania
Phoenix, Arizona
International
◦ Belfast, Northern Ireland
Note that on February 3, 2020, the Company completed the sale of its Connected Care business which includes the Panama City, Florida property.
We believe that our facilities are adequate to meet our needs in the near term, and that, if needed, suitable additional space will be available to accommodate any expansion of our operations.
The following table outlines our facilities location, square footage, and use:
Table:
City | State | Country | Sq ft | Type | Business Nature/Use
Boston | MA | USA | 31,752 | Lease | Administrative, sales, client support, R&D, engineering, professional services
Panama City | FL | USA | 51,288 | Lease | Administrative, sales, client support, R&D, engineering, professional services
Belfast | NI | UK | 15,500 | Lease | R&D, engineering, administrative
Phoenix | AZ | USA | 4,865 | Lease | Data Centre
Philadelphia | PA | USA | 14,183 | Lease | Administrative, sales, client support, R&D, engineering, professional services
 |  |  | 117,588 |  | 


Question: What is the value of the company's facility in Phoenix as a percentage of the total square feet of all its facilities in the U.S.?
Answer: 4.14
Calculation: 4,865/117,588
Sources and Uses of Cash
Our primary source of liquidity from operations was the collection of revenue in advance from our customers, accounts receivable from our customers, and the management of the timing of payments to our vendors and service providers.
Investing activities in 2019 consist of $284.6 million, net of cash acquired, used in the acquisitions of AppRiver and DeliverySlip and $11.7 million for capital expenditures, which include $8.2 million in internal-use software costs, and $3.5 million for computer and networking equipment. These investments in new equipment and cloud hosting infrastructure are to renovate our business processes and product offerings.
Investing activities in 2018 consist of $11.8 million, net of cash acquired, used in the acquisition of Erado and $4.2 million for capital expenditures, which include $2.1 million for computer and networking equipment, $1.5 million in internal-use software costs, and $500 thousand for other activities including the acquisition of other internal use software. These investments in new equipment and cloud hosting infrastructure were to modernize our business processes and product offerings.
Financing activities in 2019 includes proceeds from long term debt of $179.2 million, net of issuance costs of $6.4 million and repayment of $1.4 million, as well as $96.6 million, net of issuance costs, raised through the private purchase of preferred stock, and $415 thousand received from the exercise of stock options. The proceeds from our debt and preferred stock issuances were used to fund our AppRiver acquisition in February 2019 and our DeliverySlip acquisition in May 2019. We also used $3.8 million for contingent consideration payments associated with our acquisitions of Greenview, Erado and DeliverySlip. In addition to these items, we paid $1.7 million to satisfy finance lease liabilities and $1.9 million to repurchase common stock related to the tax impact of vesting restricted awards in 2019.
Financing activities in 2018 relate primarily to $5.4 million used in a $10 million share repurchase program authorized by our Board of Directors on April 24, 2017, and $656 thousand used in the repurchase of common stock related to the tax impact of vesting restricted stock awards, and a $605 thousand earn-out payment associated with our acquisition of Greenview. Financing activities in 2017 include $3.8 million used in the same share repurchase program and $762 thousand used in the repurchase of common stock related to the tax impact of vesting restricted awards offset by the receipt of $4.2 million from the exercise of stock options.
Table:
Years Ended December 31, |  |  | 
(In thousands) | 2019 | 2018 | 2017
Net cash provided by operations | $ 13,951 | $ 16,671 | $ 18,204
Net cash used in investing activities | $ (296,243 ) | $ (15,952 ) | $ (11,285 )
Net cash provided by (used in) financing activities | $ 268,740 | $ (6,593 ) | $ (367 )


Question: What is the percentage change in Net cash provided by operations from 2017 to 2018?
Answer: -8.42
Calculation: (16,671-18,204)/18,204
Trade accounts receivable past due is defined as the amount outstanding beyond normal credit terms and conditions for the respective customers. A large portion of the Corporation’s customers are billed and pay before the services are rendered. The Corporation considers the amount outstanding at the due date as trade accounts receivable past due.
The following table provides further details on trade accounts receivable past due net of allowance for doubtful accounts at August 31, 2019 and 2018:
Table:
At August 31, | 2019 | 2018
(In thousands of Canadian dollars) | $ | $
Less than 60 days past due | 18,645 | 32,857
60 to 90 days past due | 899 | 3,022
More than 90 days past due | 3,074 | 4,923
 | 22,618 | 40,802


Question: What was the average trade accounts receivable more than 90 days past due?
Answer: 3998.5
Calculation: (3,074 + 4,923) / 2
Stock Option Activity - The weighted-average fair value of options granted during the years ended December 31, 2019, 2018 and 2017, as determined under the Black-Scholes-Merton valuation model, was $12.07, $10.42 and $6.75, respectively. Option grants that vested during the years ended December 31, 2019, 2018 and 2017 had a combined fair value of $2.5 million, $1.5 million and $1.7 million, respectively.
The following table summarizes stock option activity for the years ended December 31, 2019, 2018 and 2017:
Table:
 | Number of Shares | Weighted Average Exercise Price | Aggregate Intrinsic Value (in thousands) | Weighted Average Remaining Contractual Life
Stock options outstanding at December 31, 2016 | 1,160,419 | $29.93 | $14,299 | 
Granted | 534,030 | $42.90 |  | 
Exercised | (463,800) | $29.34 | $7,203 | 
Cancelled and expired | (61,241) | $33.80 |  | 
Stock options outstanding at December 31, 2017 | 1,169,408 | $35.88 | $16,731 | 
Granted | 466,828 | $54.87 |  | 
Exercised | (420,524) | $30.05 | $12,411 | 
Cancelled and expired | (122,312) | $43.85 |  | 
Stock options outstanding at December 31, 2018 | 1,093,400 | $45.34 | $8,776 | 
Granted | 489,947 | $63.87 |  | 
Exercised | (338,748) | $37.94 | $9,641 | 
Cancelled and expired | (108,504) | $51.21 |  | 
Stock options outstanding at December 31, 2019 | 1,136,095 | $54.98 | $28,291 | 4 years
Stock options exercisable at December 31, 2019 | 290,540 | $44.90 | $10,163 | 3 years


Question: What was the weighted average remaining contractual life of the stock options outstanding as of December 31, 2019?
Answer: 4 years
NOTE 5 – PROPERTY AND EQUIPMENT
The Company owned equipment recorded at cost, which consisted of the following as of December 31, 2019 and 2018:
Depreciation expense was $80,206 and $58,423 for the years ended December 31, 2019 and 2018, respectively
Table:
 | 2019 | 2018
Computer equipment | $137,763 | $94,384
Furniture and fixtures | 187,167 | 159,648
Subtotal | 324,930 | 254,032
Less accumulated depreciation | 148,916 | 104,702
Property and equipment, net | $176,014 | $149,330


Question: What was the depreciation expense in 2018?
Answer: $58,423
Acquisition of Fagerdala
On October 2, 2017, the Company acquired Fagerdala Singapore Pte Ltd., a manufacturer and fabricator of polyethylene foam based in Singapore, to join its Product Care division. We acquired 100% of Fagerdala shares for estimated consideration of S$144.7 million, or $106.2 million, net of cash acquired of $13.3 million, inclusive of purchase price adjustments which were finalized in the third quarter of 2018. We acquired Fagerdala to leverage its manufacturing footprint in Asia, experience in foam manufacturing and fabrication and commercial organization to expand our presence across multiple industries utilizing fulfillment to distribute goods.
The following table summarizes the consideration transferred to acquire Fagerdala and the final allocation of the purchase price among the assets acquired and liabilities assumed. price among the assets acquired and liabilities assumed.
Table:
 | Preliminary Allocation | Measurement Period | Final Allocation
(In millions) | As of October 2, 2017 | Adjustments | As of December 31, 2018
Total consideration transferred | $ 106.6 | $ (0.4) | $ 106.2
Assets: |  |  | 
Cash and cash equivalents | 13.3 | — | 13.3
Trade receivables, net | 22.4 | — | 22.4
Inventories, net | 10.0 | 0.1 | 10.1
Prepaid expenses and other current assets | 8.4 | — | 8.4
Property and equipment, net | 23.3 | — | 23.3
Identifiable intangible assets, net | 41.4 | 0.7 | 42.1
Goodwill | 39.3 | (1.5) | 37.8
Total assets | $ 158.1 | $ (0.7) | $ 157.4
Liabilities: |  |  | 
Short-term borrowings | 14.0 | — | 14.0
Accounts payable | 6.9 | — | 6.9
Other current liabilities | 15.1 | (0.1) | 15.0
Long-term debt, less current portion | 3.8 | — | 3.8
Non-current deferred taxes | 11.7 | (0.2) | 11.5
Total liabilities | $ 51.5 | $ (0.3) | $ 51.2


Question: What does the table represent?
Answer: summarizes the consideration transferred to acquire Fagerdala and the final allocation of the purchase price among the assets acquired and liabilities assumed. price among the assets acquired and liabilities assumed.
5. Trade Accounts Receivable and Contract Liabilities:
Charges related to allowances for doubtful accounts are charged to selling, general, and administrative expenses. Charges related to stock rotation, ship from stock and debit, sales returns, and sales discounts are reported as deductions from revenue. Please refer to Note 6, “Revenue Recognition,” for additional information
Table:
 | Fiscal Year Ended March 31, | 
 | 2018 | 2019
Gross Accounts Receivable - Trade | $300,016 | $273,053
Less |  | 
Allowances for doubtful accounts | 1,893 | 1,276
Stock rotation and ship from stock and debit | 15,989 | 14,140
Sales returns and discounts | 6,875 | 646
Total allowances | 24,757 | 16,062
Accounts Receivable - Trade, net | $275,259 | $256,991


Question: What is the company's allowances for doubtful accounts in 2019?
Answer: 1,276
Expected Cash Flows
The Combined Pension Plan payments, post-retirement health care benefit payments and premiums, and life insurance premium payments are either distributed from plan assets or paid by us. The estimated benefit payments provided below are based on actuarial assumptions using the demographics of the employee and retiree populations and have been reduced by estimated participant contributions.
Table:
 | Combined Pension Plan | Post-Retirement Benefit Plans | Medicare Part D Subsidy Receipts
 |  | (Dollars in millions) | 
Estimated future benefit payments: |  |  | 
2020 | $971 | 242 | (6)
2021 | 921 | 238 | (6)
2022 | 893 | 232 | (6)
2023 | 868 | 226 | (5)
2024 | 842 | 219 | (5)
2025-2029 | 3,813 | 986 | (20)


Question: What are the different periods highlighted in the table?
Answer: 2020, 2021, 2022, 2023, 2024, 2025-2029
SHARE INFORMATION
On December 31, 2019, the total number of issued common shares of ASMI amounted to 51,297,394 compared to 56,297,394 at year-end 2018. The decrease was the result of the cancellation of 5 million treasury shares that was approved by the Annual General Meeting of Shareholders (AGM) on May 20, 2019, and became effective on July 23, 2019.
On December 31, 2019, we had 48,866,220 outstanding common shares excluding 2,431,174 treasury shares. This compared to 49,318,898 outstanding common shares and 6,978,496 treasury shares at year-end 2018. Besides the cancellation of 5 million treasury shares in July 2019, the change in the number of treasury shares in 2019 was the result of approximately 951,000 repurchased shares and approximately 498,000 treasury shares that were used as part of share based payments.
On December 31, 2019, 48,583,340 of the outstanding common shares were registered with our transfer agent in the Netherlands, ABN AMRO Bank NV; and 282,880 were registered with our transfer agent in the United States, Citibank, NA, New York.
On February 25, 2020, ASMI announced that it will propose to the AGM 2020 the cancellation of 1.5 million treasury shares, as the number of 2.4 million treasury shares held at that date was more than sufficient to cover our outstanding options and restricted/performance shares.
Table:
 | 2018 | 2019
As per January 1: |  | 
Issued shares | 62,297,394 | 56,297,394
Treasury shares | 6,157,241 | 6,978,496
Outstanding shares | 56,140,153 | 49,318,898
Changes during the year: |  | 
Cancellation of treasury shares | 6,000,000 | 5,000,000
Share buybacks | 7,242,734 | 950,902
Treasury shares used for share based performance programs | 421,479 | 498,224
As per December 31: |  | 
Issued shares | 56,297,394 | 51,297,394
Treasury shares | 6,978,496 | 2,431,174
Outstanding shares | 49,318,898 | 48,866,220


Question: What is the change in Outstanding shares as per December 31, 2019 as compared to January 1, 2018?
Answer: -7273933
Calculation:  48,866,220-56,140,153
Opening Balance Sheet Adjustments
The following summarizes the effect of adopting the above new accounting standards:
(1) The balance as of March 30, 2018, includes income tax receivable and prepaid income taxes of $107 million and short-term deferred commissions of $94 million. The opening balance as of March 31, 2018, includes income tax receivable and prepaid income taxes of $99 million and short-term deferred commissions of $86 million.
(2) The balance as of March 30, 2018, includes long-term deferred commissions of $35 million, long-term income tax receivable and prepaid income taxes of $61 million and deferred income tax assets of $46 million. The opening balance as of March 31, 2018, includes long-term deferred commissions of $92 million, long-term income tax receivable and prepaid income taxes of $29 million, and deferred income tax assets of $828 million.
Table:
(in millions) | Balance as of March 30, 2018 | Revenue Recognition Guidance | Accounting for Income Taxes Guidance | Opening Balance as of March 31, 2018
Accounts receivable, net | $809 | $24 | $— | $833
Other current assets (1) | $522 | $(8) | $(8) | $506
Other long-term assets (2) | $526 | $57 | $750 | $1,333
Total assets | $15,759 | $73 | $742 | $16,574
Short-term contract liabilities | $2,368 | $(107) | $— | $2,261
Other current liabilities | $372 | $(2) | $— | $370
Long-term contract liabilities | $735 | $(62) | $— | $673
Deferred income tax liabilities | $592 | $47 | $— | $639
Total liabilities | $10,736 | $(124) | $— | $10,612
Retained earnings | $328 | $197 | $742 | $1,267


Question: What is the percentage change in Total liabilities from Balance as of March 30, 2018 to Opening balance as of March 31, 2018?
Answer: -1.15
Calculation: -124/10,736
AMERICAN TOWER CORPORATION AND SUBSIDIARIES NOTES TO CONSOLIDATED FINANCIAL STATEMENTS (Tabular amounts in millions, unless otherwise disclosed) net foreign currency losses
(“AOCL”) in the consolidated balance sheets and included as a component of Comprehensive income in the consolidated
statements of comprehensive income.
Gains and losses on foreign currency transactions are reflected in Other expense in the consolidated statements of operations. However, the effect from fluctuations in foreign currency exchange rates on intercompany debt for which repayment is not anticipated in the foreseeable future is reflected in AOCL in the consolidated balance sheets and included as a component of Comprehensive income.
The Company recorded the following net foreign currency losses:
Table:
 |  | Year Ended December 31, | 
 | 2019 | 2018 | 2017
Foreign currency losses recorded in AOCL | $45.8 | $385.8 | $51.6
Foreign currency (gains) losses recorded in Other expense | (6.1) | 4.5 | (26.4)
Total foreign currency losses | $39.7 | $390.3 | $25.2


Question: What does the table show?
Answer: net foreign currency losses
Year Ended December 31, 2019 Compared to Year Ended December 31, 2018
Revenues
Our Products and Licensing segment included revenues from sales of test and measurement systems, primarily representing sales of our Optical Backscatter Reflectometer, ODiSI, and Optical Vector Analyzer platforms, optical components and sub-assemblies and sales of our Hyperion and Terahertz sensing platforms. Our Products and Licensing segment revenues increased $22.5 million to $44.5 million for the year ended December 31, 2019 compared to $21.9 million for the year ended December 31, 2018.
The increase resulted primarily from $10.8 million of revenues realized from the legacy business of MOI and $10.5 million of revenues realized from the legacy business of GP during the year ended December 31, 2019. Continued growth in sales of our fiber-optic sensing products, including our ODiSI products directed toward the expanding use of composite materials and the need for improved means of testing their structural integrity, and our communications test instruments also contributed to this increase.
Our Technology Development segment revenues increased $5.1 million to $26.0 million for the year ended December 31, 2019 compared to $21.0 million for the year ended December 31, 2018. Revenues within this segment increased due to additional contract awards, including higher value Phase 2 SBIR contracts. The increase continues a growth trend experienced over the past two years largely driven by successes in Phase 2 SBIR awards. The increase was realized primarily in our intelligent systems, advanced materials, optical systems and terahertz research groups. As Phase 2 SBIR contracts generally have a performance period of a year or more, we currently expect Technology Development segment revenues to remain at a similar level for the near term.
Table:
 | Years ended December 31, |  |  | 
 | 2019 | 2018 | $ Difference  | % Difference
Products and licensing revenues | $44,491,041 | $21,949,689 | $22,541,352 | 102.7%
Technology development revenues | 26,024,674 | 20,967,556 | 5,057,118 | 24.1%
Total revenues | $70,515,715 | $42,917,245 | $27,598,470 | 64.3%


Question: In which year was Products and licensing revenues less than 40,000,000?
Answer: 2018
Calculation: locate and analyze Products and licensing revenues in row 3
The Corporation’s segment profit (loss) is reported in two operating segments: Canadian broadband services and American broadband services. The reporting structure reflects how the Corporation manages its business activities to make decisions about resources to be allocated to the segments and to assess their performance.
The Canadian and American broadband services segments provide a wide range of Internet, video and telephony services primarily to residential customers as well as business services across their coverage areas. The Canadian broadband services activities are carried out by Cogeco Connexion in the provinces of Québec and Ontario and the American broadband services activities are carried out by Atlantic Broadband in 11 states: Connecticut, Delaware, Florida, Maine, Maryland, New Hampshire, New York, Pennsylvania, South Carolina, Virginia and West Virginia.
The previously reported Business ICT services segment, comprised of the Cogeco Peer 1 operations, is now reported in discontinued operations following the sale on April 30, 2019 of the Cogeco Peer 1 subsidiary. Information about the discontinued segment is provided in Note 8.
The Corporation and its chief operating decision maker assess the performance of each operating segment based on its segment profit (loss), which is equal to revenue less operating expenses. The other expenses, except for management fees, financial expense and income taxes, are reported by segment solely for external reporting purposes.
(1) Revenue by geographic market includes $1,294,967 in Canada and $1,036,853 in the United States. (2) Comprised of restructuring costs within the Canadian broadband services segment and acquisition and integration costs related to the FiberLight network acquisition in the American broadband services segment.
Table:
Year ended August 31, 2019 | Canadian broadband services | American broadband services | Inter-segment eliminations and other | Consolidated
(In thousands of Canadian dollars) | $ | $ | $ | $
Revenue (1) | 1,294,967 | 1,036,853 | — | 2,331,820
Operating expenses | 606,286 | 571,208 | 26,486 | 1,203,980
Management fees – Cogeco Inc. | — | — | 19,900 | 19,900
Segment profit (loss) | 688,681 | 465,645 | (46,386) | 1,107,940
Integration, restructuring and acquisition costs (2) | 9,299 | 1,851 | — | 11,150
Depreciation and amortization | 254,345 | 226,301 | 79 | 480,725
Financial expense |  |  |  | 175,502
Profit before income taxes |  |  |  | 440,563
Income taxes |  |  |  | 83,655
Profit for the year from continuing operations |  |  |  | 356,908
Acquisition of property, plant and equipment | 241,940 | 192,605 | — | 434,545


Question: Where is the activities of American broadband services carried out?
Answer: 11 states: Connecticut, Delaware, Florida, Maine, Maryland, New Hampshire, New York, Pennsylvania, South Carolina, Virginia and West Virginia.
Share-based Compensation Expense
We have several share-based compensation plans covering stock options and RSUs for our employees and directors, which are described more fully in Note 11.
We measure our compensation cost related to share-based payment transactions based on fair value of the equity or liability classified instrument. For purposes of estimating the fair value of each stock option unit on the date of grant, we utilize the Black-Scholes option-pricing model. Option valuation models require the input of highly subjective assumptions including the expected volatility factor of the market price of our common stock (as determined by reviewing our historical public market closing prices). Our accounting for share-based compensation for RSUs is based on the closing market price of our common stock on the date of grant.
Our total share-based compensation expense recognized in the Company’s results of operations from non-cash and cash-portioned instruments issued to our employees and directors comprised the following (in thousands):
Table:
 |  | Year Ended December 31,
 | 2019 | 2018
Research and development expense: |  | 
Stock option awards | $8 | $38
RSU awards | 13 | 27
 | 21 | $65
General and administrative expense: |  | 
Stock option awards | 12 | 61
RSU awards | 105 | 104
 | 117 | $165
Total share-based compensation expense | 138 | $230


Question: What proportion of the total stock-based compensation expense is made up from the research and development operations in 2019?
Answer: 15.22
Calculation: 21/138