90.2K
Verified Solution
Link Copied!
Based on the balance sheet and income statement provided, answer the following and show calculations, then provide a brief explanation to the calculations:
Calculate net working capital to sales ratio and Calculate accounts receivable turnover ratio for 5 years Calculate current ratio and net debt to capital ratio for 5 years INCOME STATEMENT FOR BLUESCOPE STEEL LIMITED Company Name Item 06/16 06/17 06/18 06/19 06/20 BlueScope Steel Limited Operating Revenue 9182700000 10626700000 11497800000 12532700000 BlueScope Steel Limited Other Revenue 776900000 288700000 391700000 163000000 BlueScope Steel Limited Total Revenue Excluding Interest 9959600000 10915400000 11889500000 12695700000 BlueScope Steel Limited Operating Expenses -9085900000 -9458100000 -10211000000 -1.0942E+10 BlueScope Steel Limited EBITDA 873700000 1457300000 1678500000 1753900000 BlueScope Steel Limited Depreciation -342700000 -327900000 -323000000 -362600000 BlueScope Steel Limited Amortisation 45400000 -52500000 -52300000 -50500000 BlueScope Steel Limited Depreciation and Amortisation -388100000 -380400000 -375300000 -413100000 BlueScope Steel Limited EBIT 485600000 1076900000 1303200000 1340800000 BlueScope Steel Limited Interest Revenue 5200000 6200000 8700000 19000000 BlueScope Steel Limited Interest Expense -109100000 -90200000 -112400000 -56800000 BlueScope Steel Limited Net Interest Expense -103900000 -84000000 -103700000 -37800000 BlueScope Steel Limited PreTax Profit 381700000 992900000 1199500000 1303000000 BlueScope Steel Limited Tax Expense -126400000 -292000000 -309500000 -292600000 BlueScope Steel Limited Net Profit after Tax Before Abnorn 255300000 700900000 890000000 1010400000 BlueScope Steel Limited Abnormals 136700000 -52100000 185400000 4700000 BlueScope Steel Limited Abnormals Tax 24900000 110200000 579500000 0 BlueScope Steel Limited Net Abnormals 161600000 58100000 764900000 4700000 BlueScope Steel Limited Reported NPAT After Abnormals 416300000 773900000 1628600000 1010100000 BlueScope Steel Limited Outside Equity Interests -62500000 -58000000 -59500000 5700000 BlueScope Steel Limited Shares Outstanding at Period End 571346300 561111434 546875343 516463073 BlueScope Steel Limited Weighted Average Number of Sha 570111745 571146269 556843500 534904974 BlueScope Steel Limited EPS Adjusted (cents/share) 32.77 109.2 146 187.61 BlueScope Steel Limited EPS After Abnormals (cents/sharel 60.14 121.6 275.84 187.55 11284500000 89100000 11373600000 -10146400000 1227200000 481000000 -53600000 -534600000 692600000 18900000 -77000000 -58100000 634500000 -128000000 506500000 -378200000 0 -378200000 123500000 -27000000 502632849 507294530 93.74 18.87 BALANCE SHEET FOR BLUESCOPE STEEL LIMITED Company Name Item BlueScope Steel Limited CA-Cash BlueScope Steel Limited CA-Receivables BlueScope Steel Limited CA- Prepaid Expenses BlueScope Steel Limited CA-Inventories BlueScope Steel Limited CA-Investments BlueScope Steel Limited CA-NCA Held Sale BlueScope Steel Limited CA-Other BlueScope Steel Limited Total Current Assets BlueScope Steel Limited NCA-Receivables BlueScope Steel Limited NCA-Inventories BlueScope Steel Limited NCA-Investments BlueScope Steel Limited NCA-PP&E BlueScope Steel Limited NCA-Intangibles(ExGW) BlueScope Steel Limited NCA-Goodwill BlueScope Steel Limited NCA - Future Tax Benefit BlueScope Steel Limited NCA-Other BlueScope Steel Limited Total NCA BlueScope Steel Limited Total Assets BlueScope Steel Limited CL-Account Payable BlueScope Steel Limited CL -Short-Term Debt BlueScope Steel Limited CL - Provisions BlueScope Steel Limited CL - NCL Held Sale BlueScope Steel Limited CL - Other BlueScope Steel Limited Total Curr. Liabilities BlueScope Steel Limited NCL - Account Payable BlueScope Steel Limited NCL - Long-Term Debt BlueScope Steel Limited NCL - Provisions BlueScope Steel Limited NCL - Other BlueScope Steel Limited Total NCL BlueScope Steel Limited Total Liabilities BlueScope Steel Limited Share Capital BlueScope Steel Limited Reserves BlueScope Steel Limited Retained Earnings BlueScope Steel Limited Other Equity BlueScope Steel Limited Convertible Equity BlueScope Steel Limited SE Held Sale BlueScope Steel Limited Outside Equity BlueScope Steel Limited Total Equity. 06/16 06/17 06/18 06/19 06/20 549800000 753000000 944400000 1644500000 1158400000 1331500000 1454300000 1199400000 0 0 112200000 122500000 1391500000 1658800000 1945900000 2056900000 5100000 2000000 4700000 1500000 0 5300000 4000000 1100000 101300000 122500000 28200000 52700000 3206100000 3873100000 4493700000 5078600000 35800000 32400000 31300000 34900000 71100000 74400000 67500000 73300000 39300000 49500000 79700000 127400000 3834100000 3721700000 4049300000 4147500000 534000000 483300000 466000000 454500000 1202500000 1156600000 1210200000 1269000000 196700000 155300000 487700000 419100000 29000000 29100000 45600000 92000000 5942500000 5702300000 6437300000 6617700000 9148600000 9575400000 10931000000 11696300000 1480700000 1802900000 1797800000 2052000000 228600000 53200000 95900000 212200000 392900000 428800000 487300000 443300000 0 0 0 0 181800000 163100000 227200000 189500000 2284000000 2448000000 2608200000 2897000000 32800000 44900000 67400000 78300000 1099200000 932000000 784900000 739600000 744400000 609300000 579300000 625800000 2900000 2500000 3600000 14100000 1879300000 1588700000 1435200000 1457800000 4163300000 4036700000 4043400000 4354800000 4688100000 4554400000 4311200000 3832800000 224900000 174700000 272800000 369000000 415800000 341300000 1809800000 2662300000 0 0 0 0 0 0 0 0 0 0 0 0 488100000 468300000 493800000 477400000 4985300000 5538700000 6887600000 7341500000 En bondade sedan 1399500000 1077000000 124200000 1921600000 100000 10300000 60200000 4592900000 52100000 60200000 112800000 4513300000 427900000 1293600000 413200000 94300000 6967400000 11560300000 1679200000 218600000 438200000 0 205000000 2541000000 59200000 1101800000 808400000 10300000 1979700000 4520700000 3634700000 354600000 2553800000 0 0 0 4965000001 7039600000 en
Answer & Explanation
Solved by verified expert
Link Copied!
