hellotayssir/FinQA_TAT-QA_financial_finetuning_dataset huggingface dataset:
Statement of financial position
Net assets have decreased to $157,164,000 at 30 June 2019 from $163,937,000 at 30 June 2018.
Current assets have decreased from 30 June 2018 by 18% to $75,460,000. This is driven by a reduction in cash assets, a result of continued investment in technology and further investment in iMoney. The current component of the trail commission asset is $25,626,000, which increased by 16% since 30 June 2018.
Non-current assets have increased from 30 June 2018 by 2% to $150,607,000 which is largely due to higher non-current trail commission asset partially offset by capital asset writeoffs and Home Loans Goodwill impairment. The non-current component of the trail commission asset is $88,452,000 which increased by 9% since 30 June 2018, mainly due to sales volume and partner mix.
Current liabilities decreased from 30 June 2018 to 30 June 2019 by 20% to $34,555,000 primarily due to payments to suppliers in addition to trade related payable balances post 30 June 2018.
Non-current liabilities have increased by 9% ending on $34,348,000. This relates to an increase in lease liabilities and deferred tax liabilities.
Table:
FINANCIAL PERFORMANCE SUMMARY | 2019  $’000 | 2018  $’000 RESTATED | CHANGE
Current assets | 75,460 | 91,457 | (18%)
Non-current assets | 150,607 | 147,234 | 2%
Total assets | 226,067 | 238,691 | (5%)
Current liabilities | 34,555 | 43,336 | (20%)
Non-current liabilities | 34,348 | 31,418 | 9%
Total liabilities | 68,903 | 74,754 | (8%)
Net assets | 157,164 | 163,937 | (4%)
Equity | 157,164 | 163,937 | (4%)


Question: What is the debts to assets ratio in 2019?
Answer: 0.3
Calculation: 68,903/226,067
18. Trade and other receivables
Following the application of IFRS 16, trade and other receivables have been restated (note 2).
Trade receivables are amounts due from customers for services performed in the ordinary course of business. They are generally due for settlement within 30 days and therefore are all classified as current. Trade receivables are recognised initially at the amount of consideration that is unconditional and has been invoiced at the reporting date. The Group holds the trade receivables with the objective to collect the contractual cash flows and therefore measures them subsequently at amortised cost using the effective interest method.
Accrued income relates to the Group’s rights to consideration for services provided but not invoiced at the reporting date. Accrued income is transferred to receivables when invoiced. Other receivables include £0.1m due from Auto Trader Auto Stock Limited, a related party (note 34).
Exposure credit risk and expected credit losses relating to trade and other receivables are disclosed in note 31.
Table:
 | 2019 | (Restated) 2018
 | £m | £m
Trade receivables | 27.0 | 28.8
Less: provision for impairment of trade receivables | (2.1) | (3.4)
Net trade receivables | 24.9 | 25.4
Accrued income | 28.0 | 26.7
Prepayments | 2.9 | 2.7
Other receivables | 0.3 | 0.1
Total | 56.1 | 54.9


Question: What does accrued income relate to?
Answer: the Group’s rights to consideration for services provided but not invoiced at the reporting date.
NOTE 11 – INCOME TAXES
The components of loss before income taxes are as follows:
Table:
 | 2019 | 2018
Domestic | (1,698,689) | (2,468,805)
Foreign | (52,222) | (88,726)
Loss before income taxes | (1,750,911) | (2,557,531)


Question: What is the company's domestic loss before income tax in 2018?
Answer: 2,468,805
Cash Flows
The following table summarizes key cash flow activity for the years ended December 31, 2019, 2018, and 2017 (in thousands):
Operating Activities
The increase in net cash provided by operating activities during 2019 was primarily driven by higher cash proceeds from sales of systems projects, including the Sunshine Valley, Sun Streams, and California Flats projects, and advance payments received for sales of solar modules prior to the step down in the U.S. investment tax credit as discussed above. These increases were partially offset by operating expenditures associated with initial ramp of certain Series 6 manufacturing lines and expenditures for the construction of certain projects.
Investing Activities
The decrease in net cash used in investing activities during 2019 was primarily due to higher net sales of marketable securities and restricted investments, partially offset by proceeds associated with the sale of our interests in 8point3 and its subsidiaries in 2018.
Financing Activities
The decrease in net cash provided by financing activities during 2019 was primarily the result of lower net proceeds from borrowings under project specific debt financings associated with the construction of certain projects in Australia, Japan, and India.
Table:
 | 2019 | 2018 | 2017
Net cash provided by (used in) operating activities | $174,201 | $(326,809) | $1,340,677
Net cash used in investing activities | (362,298) | (682,714) | (626,802)
Net cash provided by financing activities | 74,943 | 255,228 | 192,045
Effect of exchange rate changes on cash, cash equivalents and restricted cash. | (2,959) | (13,558) | 8,866
Net (decrease) increase in cash, cash equivalents and restricted cash | $(116,113) | $(767,853) | $914,786


Question: What is the increase in cash provided by operating activities from 2018 to 2019?
Answer: 501010
Calculation: 174,201 - (-326,809)
(3) Accounts Receivable, Net
Accounts receivable, net, is as follows (in thousands):
Bad debt expense for the years ended December 31, 2019, 2018 and 2017 was $0.7 million, $0.1 million and $0.6 million, respectively.
Table:
 | As of December 31, | 
 | 2019 | 2018
Accounts receivable | $69,767 | $41,818
Allowance for doubtful accounts | (1,125) | (711)
Net accounts receivable | $68,642 | $41,107


Question: What is the change in Allowance for doubtful accounts from December 31, 2019 to December 31, 2018?
Answer: 414
Calculation: 1,125-711
Option Exercises and Stock Vested in Fiscal 2019
The following table sets forth certain details with respect to each of the Named Executive Officers concerning the exercise of stock options and vesting of stock in Fiscal 2019:
(1) “Value realized on exercise” is the excess of the market price, at date of exercise, of the shares underlying the options over the exercise price of the options.
(2) “Value realized on vesting” is the market price of the underlying Common Shares on the vesting date.
(3) Relates to the vesting of PSUs and RSUs under our Fiscal 2018 LTIP.
Table:
 | Option Awards |  | Stock Awards (3) | 
Name | Number of Shares Acquired on Exercise (#) | Value Realized on Exercise(1) ($) | Number of Shares Acquired on Vesting (#) | Value Realized on Vesting(2) ($)
Mark J. Barrenechea | 135,208 | $2,801,023 | 65,820 | $7,625,905
Madhu Ranganathan | — | $— | — | $—
Muhi Majzoub | 100,000 | $2,592,411 | 10,900 | $1,263,646
Gordon A. Davies | — | $— | 12,840 | $1,486,870
Simon Harrison | 26,504 | $714,495 | 8,980 | $346,808


Question: What is the Value Realized on Vesting of Mark J. Barrenechea expressed as a percentage of total Value Realized on Vesting?
Answer: 71.12
Calculation: 7,625,905/(7,625,905+1,263,646+1,486,870+346,808)
3. EARNINGS PER SHARE:
Basic earnings per share available to common shareholders is calculated by dividing net income less preferred stock dividend requirements by the weighted average common shares outstanding for each period. Diluted earnings per share available to common shareholders is calculated by dividing income from operations less preferred stock dividend requirements (when anti-dilutive) by the sum of the weighted average common shares outstanding and the weighted average dilutive equity awards.
Table:
 | For Fiscal Years | 
 | 2019 Basic | 2018 Basic
Weighted average common shares outstanding | 597,961 | 660,925
Net income available to common shareholders | $3,202,943 | $3,614,610
Net earnings per share available to common shareholders | $5.36 | $5.47


Question: What is the percentage change in the net income available to common shareholders between 2018 and 2019?
Answer: -11.39
Calculation: (3,202,943 - 3,614,610)/3,614,610
3. Inventories
Inventories consist of the following (in thousands):
Table:
 | August 31,2019 | August 31,2018
Raw materials | $2,310,081 | $2,070,569
Work in process | 468,217 | 788,742
Finished goods | 314,258 | 659,335
Reserve for excess and obsolete inventory | (69,553) | (60,940)
Inventories, net | $3,023,003 | $3,457,706


Question: What was the amount of work in process in 2018?
Answer: 788,742
Earnings per share for the periods indicated were computed as follows (in thousands except per share amounts):
Our weighted average shares outstanding has decreased due to the repurchase of our outstanding common stock through a modified Dutch auction tender offer (the “Tender Offer”) and the stock repurchase program announced on October 29, 2018.
11.     Earnings Per Share
Table:
 | Year ended December 31, | 
 | 2019 | 2018
Numerators |  | 
Numerator for basic and diluted earnings per share: |  | 
Net income | $13,267 | $3,654
Denominators |  | 
Denominators for basic and diluted earnings per share: |  | 
Weighted average shares outstanding - basic | 17,424 | 20,721
Dilutive potential common shares |  | 
Stock options and awards | 1,101 | 296
Denominator for diluted earnings per share | 18,525 | 21,017
Net income per common share - basic | $0.76 | $0.18
Net income per common share – diluted | $0.72 | $0.17


Question: How did the company's Denominator for diluted earnings per share change from 2018 to 2019?
Answer: -11.86
Calculation: (18,525 - 21,017)/21,017
25. Loans and other borrowings continued
Loans and other borrowings are analysed as follows:
a Includes collateral received on swaps of £638m (2017/18: £525m, 2016/17: £702m).
The carrying values disclosed in the above table reflect balances at amortised cost adjusted for accrued interest and fair value adjustments to the relevant loans or borrowings. These do not reflect the final principal repayments that will arise after taking account of the relevant derivatives in hedging relationships which are reflected in the table below. Apart from finance leases, all borrowings as at 31 March 2019, 2018 and 2017 were unsecured.
Table:
 | 2019 | 2018 | 2017
At 31 March | £m | £m | £m
Current liabilities |  |  | 
Listed bonds | 1,367 | 1,702 | 1,539
Finance leases | 16 | 18 | 15
Bank loans | – | – | 352
Other loans and bank overdrafts a | 717 | 561 | 726
Total current liabilities | 2,100 | 2,281 | 2,632
Non-current liabilities |  |  | 
Listed bonds | 14,586 | 11,789 | 9,866
Finance leases | 190 | 205 | 214
Other loans | – | – | 1
Total non-current liabilities | 14,776 | 11,994 | 10,081
Total | 16,876 | 14,275 | 12,713


Question: What was the collateral received on swaps in 2019?
Answer: £638m
Group and business unit performance factors
The underlying values and weightings for each KPI are set and approved by the remuneration committee in advance of each year to determine parameters for the STI in the form of a balanced scorecard. Below is the group STI scorecard for FY19 that applied to the CEO, CFO, executive directors, prescribed officers and other participants:
* The actual targets have not been provided as they are linked to budget and considered commercially sensitive information.
** For the key performance indicators within the growth and efficiency strategic objectives, the targeted percentages for “threshold”, “on-target” and
“stretch” as set out above per key performance indicator represent the targeted percentage achievement of the underlying budgeted amounts.
Table:
Strategic objective | Strategic objective weighting | Key performance indicator | Key performance indicator weighting | Score = 50% | Score = 100% | Score = 200%
Growth*,** | 60% | Sales volume growth | 10% | 40,0% | 100,0% | 140,0%
 |  | Absolute gross margin | 10% | 96,8% | 100,0% | 103,6%
 |  | PBIT | 40% | 98,6% | 100,0% | 103,6%
Efficiency*,** | 10% | Cost savings initiatives | 5% | 98,6% | 100,0% | 123,4%
 |  | Net working capital | 5% | 101,2% | 100,0% | 97,7%
 |  |  |  | Reduction in execution-related marketplace incidents year-on-year by |  | 
People and sustainability* | 30% | Quality | 10% | 10% | 15% | 20%
 |  | Safety (LTIFR) | 10% | 120,0% | 100,0% | 80,0%
 |  | BBBEE score | 10% | Level 7 (60 to 61) | Level 7 (61.1 to 65) | Level 6


Question: Which key performance indicator accounts for two thirds in Growth?
Answer: PBIT
Calculation: 40%/60%
Results of Operations: Years Ended December 31, 2018, versus Year Ended December 31, 2017 (Amounts in thousands, except percentages and per share amounts):
Capital Resources
Long-term debt was comprised of the following:
On February 12, 2019, we entered into an amended and restated five-year Credit Agreement with a group of banks (the "Credit Agreement") to extend the term of the facility. The Credit Agreement provides for a revolving credit facility of $300,000, which may be increased by $150,000 at the request of the Company, subject to the administrative agent's approval. This new unsecured credit facility replaces the prior $300,000 unsecured credit facility, which would have expired August 10, 2020. Borrowings of $50,000 under the prior credit agreement were refinanced into the Credit Agreement. The prior agreement was terminated as of February 12, 2019.
The Revolving Credit Facility includes a swing line sublimit of $15,000 and a letter of credit sublimit of $10,000. Borrowings under the Revolving Credit Facility bear interest at the base rate defined in the Credit Agreement. We also pay a quarterly commitment fee on the unused portion of the Revolving Credit Facility. The commitment fee ranges from 0.20% to 0.30% based on the our total leverage ratio.
We have entered into interest rate swap agreements to fix interest rates on $50,000 of long-term debt through February 2024. The difference to be paid or received under the terms of the swap agreements is recognized as an adjustment to interest expense when settled.
We have historically funded our capital and operating needs primarily through cash flows from operating activities, supported by available credit under our Revolving Credit Facility. We believe that cash flows from operating activities and available borrowings under our Revolving Credit Facility will be adequate to fund our working capital needs, capital expenditures, and debt service requirements for at least the next twelve months. However, we may choose to pursue additional equity and debt financing to provide additional liquidity or to fund acquisitions.
Table:
 | As of December 31, | 
 | 2019 | 2018
Total credit facility | $300,000 | $300,000
Balance Outstanding | $99,700 | $50,000
Standby letters of credit | $1,800 | $1,940
Amount available | $198,500 | $248,060
Weighted-average interest rate | 3.25% | 3.10%
Commitment fee percentage per annum | 0.23% | 0.20%


Question: What was the percentage change in the amount available between 2018 and 2019?
Answer: -19.98
Calculation: (198,500-248,060)/248,060
14. SHAREHOLDERS’ EQUITY
Authorized, issued and outstanding common shares roll-forward is as follows:
In December 2017, the Company completed an underwritten public offering of 40,000,000 common shares which increased its equity by $103.7 million.
In December 2018, the Annual General Meeting of the Company approved to increase the Company’s authorized share capital from $1.8 million to $3.6 million.
During 2019, the Company has issued 5,260,968 shares through the ATM program and raised net proceeds of $17.9 million.
Table:
 | Authorized
Shares | Issued and Out-
standing Shares | Common Stock
Balance as of January 1, 2017   | 180,000,000 | 101,969,666 | 1,020
Common Shares Issued in Follow-on Offering | - | 40,000,000 | 400
Balance as of December 31, 2017   | 180,000,000 | 141,969,666 | 1,420
Authorization of additional authorized shares   | 180,000,000 | - | -
Balance as of December 31, 2018   | 360,000,000 | 141,969,666 | 1,420
At-the-Market Offering   | - | 5,260,968 | 52
Balance as of December 31, 2019   | 360,000,000 | 147,230,634 | 1,472


Question: What is the value of the number of shares issued by the company in 2017 as a percentage of its total issued and outstanding shares as at December 31, 2017?
Answer: 28.18
Calculation: 40,000,000/141,969,666
Veradigm
Our Veradigm segment derives its revenue from the provision of data-driven clinical insights with actionable tools for clinical workflow, research, analytics and media. Its solutions, targeted at key healthcare stakeholders, help improve the quality, efficiency and value of healthcare delivery – from biopharma to health plans, healthcare providers and patients, and health technology partners, among others.
Year Ended December 31, 2019 Compared with the Year Ended December 31, 2018
Veradigm revenue increased during the year ended December 31, 2019 compared with the prior year comparable period due to an increase in organic sales. Gross profit and income from operations increased for during the year ended December 31, 2019 due to an increase in organic sales and cost reductions partially offset with headcount growth and hosting migration costs. The acquisition of Practice Fusion during the first quarter of 2018 also contributed to the increases.
Gross margin and operating margin decreased during the year ended December 31, 2019, compared with the prior year comparable period, primarily due to (i) an increase in hosting migration costs, (ii) costs associated with recent acquisitions, (iii) headcount growth and (iv) partially offset with other cost reductions.
Year Ended December 31, 2018 Compared with the Year Ended December 31, 2017
Veradigm revenue, gross profit, gross margin and income from operations increased during the year ended December 31, 2018 compared with the prior year comparable period primarily due to the acquisition of Practice Fusion during the first quarter of 2018. Operating margin decreased during 2018 primarily due to higher personnel costs related to incremental resources from the Practice Fusion acquisition and to support anticipated new hosting client golives.
Table:
 |  |  | Year Ended December 31, |  | 
(In thousands) | 2019 | 2018 | 2017 | 2019 % Change from 2018 | 2018 % Change from 2017
Revenue | $161,216 | $140,326 | $69,879 | 14.9% | 100.8%
Gross profit | $104,896 | $100,708 | $43,817 | 4.2% | 129.8%
Gross margin % | 65.1% | 71.8% | 62.7% |  | 
Income from operations | $43,996 | $43,641 | $23,816 | 0.8% | 83.2%
Operating margin % | 27.3% | 31.1% | 34.1% |  | 


Question: What is the change in Income from operations between 2019 and 2017?
Answer: 20180
Calculation: 43,996-23,816
1 Interest on borrowings includes interest on short-term borrowings and on long-term debt.
FOREIGN EXCHANGE AND CHANGE IN FAIR VALUE OF DERIVATIVE INSTRUMENTS We recognized $79 million in net foreign exchange gains in 2019 (2018 – $136 million in net losses). These gains and losses were primarily attributed to our US dollar-denominated commercial paper (US CP) program borrowings (see note 17).
These foreign exchange gains (2018 – losses) were partially offset by the $80 million loss related to the change in fair value of derivatives (2018 – $95 million gain) that was primarily attributed to the debt derivatives, which were not designated as hedges for accounting purposes, we used to substantially offset the foreign exchange risk related to these US dollar-denominated borrowings.
During the year ended December 31, 2018, after determining we would not be able to exercise our outstanding bond forward derivatives (bond forwards) within the designated time frame, we discontinued hedge accounting and reclassified a $21 million loss from the hedging reserve within shareholders’ equity to “change in fair value of derivative instruments” within finance costs.
We subsequently extended the bond forwards and redesignated them as effective hedges. During the year ended December 31, 2019, we exercised these bond forwards. See note 17 for more information on our bond forwards.
NOTE 11: FINANCE COSTS
Table:
 | Years ended December 31 | Years ended December 31 | Years ended December 31
(In millions of dollars) | Note | 2019 | 2018
Interest on borrowings 1 |  | 746 | 709
Interest on post-employment benefits liability | 23 | 11 | 14
Loss on repayment of long-term debt | 21 | 19 | 28
(Gain) loss on foreign exchange |  | (79) | 136
Change in fair value of derivative instruments |  | 80 | (95)
Capitalized interest |  | (19) | (20)
Other |  | 21 | 21
Finance costs before interest on lease liabilities |  | 779 | 793
Interest expense on lease liabilities | 8 | 61 | -
Total finance costs |  | 840 | 793


Question: What is the increase/ (decrease) in Interest on borrowings from 2018 to 2019?
Answer: 37
Calculation: 746-709
Note 9 – Leases
We have operating leases for office space, automobiles and various other equipment in the U.S. and in certain international locations. We also reviewed other contracts, such as manufacturing agreements and service agreements, for potential embedded leases. We specifically reviewed these other contracts to determine whether we have the right to substantially all of the economic benefit from the use of any specified assets or the right to direct the use of any specified assets, either of which would indicate the existence of a lease.
As of December 31, 2019, our operating leases had remaining lease terms of one month to six years, some of which included options to extend the leases for up to nine years, and some of which included options to terminate the leases within three months. For those leases that are reasonably assured to be renewed, we have included the option to extend as part of our right of use asset and lease liability. Leases with an initial term of 12 months or less were not recorded on the balance sheet and lease expense for these leases is recognized on a straight-line basis over the lease term. Lease expense related to these short-term leases was $0.4 million for the twelve months ended December 31, 2019, and is included in cost of sales, selling, general and administrative expenses and research and development expenses in the Consolidated Statements of Income. Lease expense related to variable lease payments that do not depend on an index or rate, such as real estate taxes and insurance reimbursements, was $0.9 million for the twelve months ended December 31, 2019. For lease agreements entered into or reassessed after the adoption of Topic 842, we elected to not separate lease and nonlease components. Our lease agreements do not contain any material residual value guarantees or material restrictive covenants.
Supplemental balance sheet information related to operating leases is as follows:
(1) Reflects the adoption of the new lease accounting standard on January 1, 2019.
Table:
(In thousands) | Classification | December 31, 2019 | January 1, 2019 (1)
Assets |  |  | 
Right of use lease assets | Other Assets | $8,452 | $10,322
Total lease asset |  | $8,452 | $10,322
Liabilities |  |  | 
Current lease liability | Accrued expenses | $2,676 | $2,948
Non-current lease liability | Other non-current liabilities | 5,818 | 7,374
Total lease liability |  | $8,494 | $10,322


Question: What types of operating leases does the company have in the U.S. and in certain international locations?
Answer: office space, automobiles and various other equipment