I need help for these questions, and please tell me the formula how did you get the answers of each questions.

A1 Item E G H 06/10 06/18 6,424,000.00 237,000.00 995,000.00 4,202,000.00 2,309,000.00 2,616,000.00 8,057,000.00 CA - Receivables 60,039,000.00 46,236,000.00 39,546,000.00 35,613,000.00 41,698,000.00 39,193,000.00 40,197,000.00 2,805,000.00 2,636,000.00 3,851,000.00 4,867,000.00 1,622,000.00 2,020,000.00 4,056,000.00 140,507,000.00 151,376,000.00 168,142,000.00 145,218,000.00 141,553,000.00 139,882,000.00 156,346,000.00 1,469,000.00 827,000.00 0.00 57,000.00 37,644,000.00 25,901,000.00 1,254,000.00 12,000.00 79,000.00 49,000.00 119,000. 0.0 220,843,000.00 221,765,000.00 174,712,000.00 191,700,000.00 217,942,000.00 211,947,000.00 187,334,000.00 195,140,000.00 213,817,000.00 10 NCA - Receivables 2,400,000.00 0.00 1,843,000.00 0.00 0.00 11 NCA - Inventories 54,059,000.00 52,130,000.00 55,047,000.00 54,042,000.00 56,920,000.00 66,371,000.00 85,272,000.00 53,046,000.00 52,164,000.00 34,268,000.00 12 NCA - Investments 2,013,000.00 64,000.00 59,000.00 59,000.00 59,000.00 334,000.00 396,000.00 178,000.00 781,000.00 13 NCA - PP&E 79,643,000.00 97,148,000.00 95,613,000.00 90,058,000.00 83,200,000.00 81,375,000.00 97,308,000.00 109,095,000.00 117,482,000.00 14 NCA - Intangibles(ExGW) 17,144,000.00 16,784,000.00 16,472,000.00 15,298,000.00 13,656,000.00 13,338,000.00 12,850,000.00 12,733,000.00 15 NCA - Goodwill 36,774,000.00 37,685,000.00 37,685,000.00 37,685,000.00 37,685,000.00 37,685,000.00 37,685,000.00 37,685,000.00 16 NCA - Future Tax Benefit 59,008,000.00 58,493,000.00 55,123,000.00 52,288,000.00 36,134,000.00 36,945,000.00 33,597,000.00 29,380,000.00 17 NCA - Other 0.00 184,000.00 18 Total NCA 251,041,000.00 262,304,000.00 261,842,000.00 252,117,000.00 252,555,000.00 252,156,000.00 254,138,000.00 238,230,000.00 245,636,000.00 232,195,000.00 19 Total Assets 471,884,000.00 484,069,000.00 436,554,000.00 443,817,000.00 470,497,000.00 450,605,000.00 425,564,000.00 440,776,000.00 446,012,000.00 56,229,000.00 41,433,000.00 36,918,000.00 33,019,000.00 40,996,000.00 43,813,000.00 46,468,000.00 55,523,000.00 59,353,000.00 21 CL - Short-Term Debt 129,000.00 1,838,000.00 1,993,000.00 2,305,000.00 3,606,000.00 1,514,000.00 259,000.00 551,000.00 503,000.00 470,000.00 22 CL - Provisions 10,360,000.00 9,973,000.00 7,620,000.00 6,680,000.00 7,490,000.00 5,594,000.00 5,680,000.00 23 CL - NCL Held Sale 806,000.00 373,000.00 0.00 0.00 0.00 0.00 0.00 24 CL - Other 241,000.00 222,000.00 535,000.00 495,000.00 215,000.00 0.00 596,000.00 25 Total Curr. Liabilities 67,765,000.00 53,839,000.00 48,587,000.00 42,992,000.00 49,804,000.00 49,881,000.00 52,699,000.00 62,638,000.00 66,175,000.00 26 NCL - Account Payable 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27 NCL - Long-Term Debt 143,533,000.00 165,596,000.00 127,329,000.00 140,748,000.00 112,349,000.00 105,047,000.00 107,131,000.00 84,880,000.00 84,435,000.00 79,965,000.00 28 NCL - Provisions 31,406,000.00 23,769,000.00 19,178,000.00 18,094,000.00 1,829,000.00 1,041,000.00 29 NCL - Other 0.00 0.00 30 Total NCL 176,318,000.00 197,002,000.00 151,098,000.00 159,926,000.00 121,939,000.00 108,960,000.00 86,022,000.00 85,245,000.00 81,006,000.00 31 Total Liabilities 244,083,000.00 250,841,000.00 199,685,000.00 202,918,000.00 171,743,000.00 158,841,000.00 138,721,000.00 147,883,000.00 147,181,000.00 32 Share Capital 401,831,000.00 401,831,000.00 402,792,000.00 403, 155,000.00 443,266,000.00 443,266,000.00 463,009,000.00 463,961,000.00 465,490,000.00 586,000.00 1,814,000.00 670,000.00 2,047,000.00 1,829,000.00 1,989,000.00 2,443,000.00 -170,417,000.00 -162,926,000.00 -155,833,000.00 -151,577,000.00 -153,549,000.00 -177,995,000.00 -173,057,000.00 -169,102,000.00 35 Other Equity 0.00 0.00 36 Convertible Equity 0.00 0.00 0.00 0.00 0.00 37 SE Held Sale 0.00 0.00 0.00 0.OC 0.00 38 Outside Equity 39 Total Equity 227,801,000.00 233,228,000.00 236,869,000.00 240,899,000.00 288,237,000.00 292,360,000.00 291,764,000.00 286,843,000.00 292,893,000.00 298,831,000.00Australian_Vintage-Financial_Data (1) [Protected View] - Excel File Home Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Al A B D E F G H K Item 06/10 06/11 06/13 06/14 250,375,000.00 258,081,000.00 241,448,000.00 06/15 06/16 06/17 Receipts from Customers 06/18 3 Payments to Suppliers and Employees 223,481,000.00 06/19 -231,040,000.00 220,898,000.00 -244,500,000.00 247,221,000.00 -217,723,000.00 4 Dividends Received -217,164,000.00 259,277,000.00 -216,593,000.00 1,000.00 -239,085,000.00 269,166,000.00 0.00 -247,723,000.00 1,000.00 932,000.00 0.00 0.00 0.00 Interest Received 197,000.00 457,000.00 0.00 157,000.00 284,000.00 447,000.00 5,000.00 45,000.00 270,098,000.00 Interest Paid -12,615,000.00 Tax Paid -12,750,000.00 -13,292,000.00 15,000.00 -10,935,000.00 ),000.00 8,388,000.00 -245,903,000.00 -6,090,000.00 -5,108,000.00 0.00 5,000.00 0.00 24,195,000.00 0.00 0.0 0.00 0.00 8 Other Operating Cashflows -1,204,000.00 3,000.00 0.00 -7,745,000.00 0.00 0.00 0.00 9 Net Operating Cashflows 5,713,000.00 1,288,000.00 10,590,000.00 3,000.00 2,091,000.00 -169,000.00 10 Payment for Purchase of PPE -3,808,000.00 -4,334,000.00 -3,636,000.00 -20,276,000.00 6,461,000.00 -5,334,000.00 1,566,000.00 -4,360,000.00 -3,530,000.00 -4,471,000.00 1,000.00 7,914,000.00 11 Proceeds From Sale of PPE 1,901,000.00 26,151,000.00 1,316,000.00 4,428,000.00 ),000.00 184,000.00 15,516,000.00 16,281,000.00 183,000.00 12 Investments Purchased 0.00 ,000.00 0.00 0.00 0.00 25,000.00 0.00 0.00 0.00 13 Proceeds From Sale of Investments 0.00 0.00 0.00 0.OC 0.0 000.00 -4,059,000.00 14 Payments for Purchase of Subsidiaries 0.00 0.00 0.00 ,000.00 4,034,000.00 0.00 15 Proceeds from Sale of Subsidiaries 0.00 0.00 0.00 0.00 12,247,000.00 0.00 0.00 16 Loans Granted 0.00 0.00 0.00 000.00 0.00 0.00 0.00 -4,124,000.00 0.00 17 Loans Repaid 0.00 0.00 0.00 ,000.00 0.00 8,123,000.00 0.00 0.00 0.00 18 Other Investing Cashflows 0.00 0.00 0.00 0.00 0.00 0.00 0.00 19 Net Investing Cashflows -1,907,000.00 0.00 -18,710,000.00 20,817,000.00 0.00 0.00 20 Proceeds from Issues -3,044,000.00 -3,346,000.00 11,045,000.00 0.00 -4,245,000.00 0.00 0.00 0.00 39,383,000.00 0.00 0.00 21 Proceeds from Borrowings 0.00 0.00 0.00 23,745,000.00 1,000.00 0.00 13,700,000.00 8,123,000.00 22 Repayment of Borrowings -8,433,000.00 37,654,000.00 -2,683,000.00 3,000,000.00 -27,586,000.00 0.00 23 Dividends Paid -1,454,000.00 0.00 0.00 -2,253,000.00 -9,919,000.00 -1,514,000.00 0.00 0.00 -3,069,000.00 3,771.00 280,708,071.00 24 Other Financing Cashflows -3,451,000.00 2,313,000.00 -5,110,000.00 0.00 0.00 188,000.00 1,843,000.00 ,000.00 279,670,000.00 0.00 25 Net Financing Cashflows 0.00 0.00 -8,433,000.00 22,291,000.00 -37,594,000.00 10,189,000.00 2.70 26 Net Increase in Cash 8,136,000.00 2.80 -4,627,000.00 -15,029,000.00 4,869,000.00 1,486,000.00 27 Cash at Beginning of Period -6,187,000.00 758,000.00 3,207,000.00 2.70 2.80 6,182,000.00 -1,893,000.00 1,555,000.00 3,702,000.00 28 Exchange Rate Adj 6,424,000.00 237,000.00 995,000.00 4,202,000.00 2,309,000.00 0.00 0.00 0.00 0.00 0.00 29 Other Cash Adjustments 0.00 0.00 0.00 0.00 0.00 0.00 30 Cash at End of Period 0.00 1,555,000.00 6,424,000.00 237,000.00 995,000.00 31 4,202,000.00 2,309,000.00 6,011,000.00 32A1 x v fx Item A B C D E F G H J K Item 06/10 06/11 06/12 06/13 238,318,000.00 06/14 226,015,000.00 06/15 Operating Revenue 228,469,000.00 06/16 06/17 209,023,000.00 06/18 06/19 Other Revenue 214,753,000.00 230,896,000.00 4,188,000.00 242,686,000.00 6,183,000.00 2,018,000.00 226,450,000.00 8,861,000.00 264,613,000.00 8,906,000.00 11,993,000.00 269,166,000.00 4 Total Revenue Excluding Interest 242,506,000.00 5,859,000.00 4,282,000.00 232, 198,000.00 230,487,000.00 217,884,000.00 1,253,000.00 932,000.00 Operating Expenses 223,659,000.00 -211,786,000.00 242,889,000.00 248,545,000.00 -200,096,000.00 230,732,000.00 265,866,000.00 270,098,000.00 EBITDA 196,087,000.00 30,720,000.00 186,735,000.00 -192,786,000.00 218,835,000.00 36,111,000.00 30,873,000.00 -239,062,000.00 -242, 190,000.00 Depreciation 30,391,000.00 31,149,000.00 -212,022,000.00 -245,903,000.00 8 -6,773,000.00 -6,434,000.00 6,564,000.00 24,054,000.00 6,559,000.00 9,483,000.00 18,710,000.00 6,507,000.00 23,676,000.00 -5,795,000.00 24, 195,000.00 Amortisation -381,000.00 -398,000.00 -6,045,000.00 6,945,000.00 -511,000.00 -567,000.00 -589,000.00 -7,188,000.00 -7,745,000.00 9 Depreciation and Amortisation -463,000.00 10 EBIT -7,154,000.00 -6,832,000.00 598,000.00 23,566,000.00 -7,027,000.00 -504,000.00 -7,070,000.00 23,364,000.00 -7,074,000.00 -308,000.00 -169,000.00 -6,634,000.00 29,279,000.00 -7,496,000.00 -7,914,000.00 455,000.00 24,079,000.00 -6,393,000.00 -7,449,000.00 11 Interest Revenue 396,000.00 23,799,000.00 17,420,000.00 325,000.00 312,000.00 3,090,000.00 11,261,000.00 16,180,000.00 16,281,000.00 12 Interest Expense 447,000.00 -13,304,000.00 45,000.0 15,000.00 -14,751,000.00 15,000.00 16,000.00 25,000.00 13 Net Interest Expense -12,849,000.00 -16,349,000.00 -13,910,000.00 -9,139,000.00 -15,953,000.00 -6,397,000.00 -5,790,000.00 -14,426,000.00 -13,598,000.00 -8,692,000.00 -5,025,000.00 -5,031,000.00 -4,059,000.00 14 PreTax Profit 10,717,000.00 13,326,000.00 -6,352,000.00 8,938,000.00 -5,010,000.00 -2,624,000.00 10,481,000.00 -5,775,000.00 15 Tax Expense -3,106,000.00 15,107,000.00 11,068,000.00 -5,015,000.00 -4,034,000.00 -1,871,000.00 -2,685,000.00 6,251,000.00 16 Net Profit after Tax Before Abnormals 8,093,000.00 -3,411,000.00 10,220,000.00 -4,563,000.00 -1,702,000.00 11,165,000.00 713,000.00 12,247,000.00 134,000.00 7,067,000.00 7,070,000.00 -1,948,000.00 10,544,000.00 9,366,000.00 -3,471,000.00 17 Abnormals -6,677,000.00 -1,972,000.00 4,303,000.00 7,694,000.00 -4,124,000.00 0.00 0.00 8,123,000.00 866,000.00 0.00 18 Abnormals Tax 0.00 0.00 3,021,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 19 Net Abnormals 0.00 0.00 1,000,000.00 -3,656,000.00 0.00 0.00 0.00 0.00 0.00 0.00 20 Reported NPAT After Abnormals 9,093,000.00 0.00 0.00 0.00 6,564,000.00 7,067,000.00 7,070,000.00 0.00 10,544,000.00 9,366,000.00 21 Outside Equity Interests -1,972,000.00 0.00 4,303,000.00 7,694,000.00 0.00 8,123,000.00 0.00 0.00 22 Shares Outstanding at Period End 0.00 0.00 0.00 128,580,317.00 128,580,317.00 131,993,692.00 0.00 0.00 0.00 23 Weighted Average Number of Shares 128,576,000.00 132,720,637.00 128,576,000.00 232,262,382.00 232,262,382.00 131,037,000.00 132,438,000.00 232,262,382.00 207,738,000.00 232,262,000.00 275,568,321.00 232,262,000.00 277,838,771.00 280,708,071.00 24 EPS Adjusted (cents/share) 6.29 7.95 242,577,000.00 277,011,000.00 5.39 5.34 279,670,000.00 5.08 -0.85 1.70 2.70 2.80 26 25 EPS After Abnormals (cents/share) 4.03 7.07 5.11 5.39 5.34 5.08 4.03 -0.85 1.70 2.70 2.80 profit loss imageRatio Calculations W N Profitability Ratios: 2017 2018 2019 Return on Equity 6 Profit avail to owners / 7 Average Equity 8 Answer: % 9 10 Return on Assets: 11 Net profit (loss) / 12 Average total assets % 13 Answer: 14 15 Profit Margin 16 Net profit (loss) / 17 Sales Revenue (note used operating revenue) 18 Answer: 19 20 Gross Profit Margin 21 Gross profit / 22 Sales Revenue (note used operating revenue) 23 Answer: 24