Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Item 12/20 12/21 12/22 Operating Revenue 15,175,600,000 21,420,900,000 38,245,400,000 COGS -14,200,500,000 -19,389,800,000 -35,679,600,000 Gross Profit 975,100,000 2,031,100,000 2,565,800,000 Other Revenue 297,800,000 275,900,000 251,400,000 Total Revenue

Item 12/20 12/21 12/22
Operating Revenue 15,175,600,000 21,420,900,000 38,245,400,000
COGS -14,200,500,000 -19,389,800,000 -35,679,600,000
Gross Profit 975,100,000 2,031,100,000 2,565,800,000
Other Revenue 297,800,000 275,900,000 251,400,000
Total Revenue Excluding Interest 1,272,900,000 2,307,000,000 2,817,200,000
Operating Expenses -880,200,000 -993,500,000 -1,250,900,000
EBITDA 392,700,000 1,313,500,000 1,566,300,000
Depreciation -531,800,000 -363,900,000 -400,100,000
Amortisation -27,900,000 -17,100,000 -38,300,000
Depreciation and Amortisation -559,700,000 -381,000,000 -438,400,000
EBIT -167,000,000 932,500,000 1,127,900,000
Interest Revenue 600,000 400,000 76,900,000
Interest Expense -109,700,000 -113,100,000 -183,900,000
Net Interest Expense -109,100,000 -112,700,000 -107,000,000
PreTax Profit -276,100,000 819,800,000 1,020,900,000
Tax Expense 245,800,000 -199,600,000 -184,500,000
Net Profit after Tax Before Abnormals -30,300,000 620,200,000 836,400,000
Abnormals -449,500,000 -22,700,000 -84,400,000
Abnormals Tax 0 0 26,600,000
Net Abnormals -449,500,000 -22,700,000 -57,800,000
Reported NPAT After Abnormals -479,800,000 597,500,000 847,000,000
Outside Equity Interests -5,100,000 -37,500,000 -51,100,000
Shares Outstanding at Period End 249,700,000 238,300,000 238,300,000
Weighted Average Number of Shares 249,700,000 238,300,000 238,300,000
EPS Adjusted (cents/share) -14.18 242.97 327.87
EPS After Abnormals (cents/share) -194.19 233.50 332.30
Price per share @31 Dec 25.2 24.04 27.10
Item 12/20 12/21 12/22
CA - Cash 367,600,000 566,300,000 126,000,000
CA - Receivables 859,800,000 1,576,200,000 2,601,100,000
CA - Prepaid Expenses 0 0 0
CA - Inventories 1,333,600,000 2,064,900,000 3,593,900,000
CA - Investments 0 0 0
CA - NCA Held Sale 0 0 0
CA - Other 50,900,000 0 0
Total Current Assets 2,611,900,000 4,207,400,000 6,321,000,000
NCA - Receivables 2,500,000 41,500,000 118,100,000
NCA - Inventories 0 0 0
NCA - Investments 173,000,000 184,000,000 305,400,000
NCA - PP&E 3,467,700,000 3,564,700,000 4,617,700,000
NCA - Intangibles(ExGW) 152,700,000 99,600,000 925,900,000
NCA - Goodwill 405,700,000 406,700,000 673,300,000
NCA - Future Tax Benefit 453,800,000 344,200,000 366,100,000
NCA - Other 50,600,000 5,600,000 3,700,000
Total NCA 4,706,000,000 4,646,300,000 7,010,200,000
Total Assets 7,317,900,000 8,853,700,000 13,331,200,000
CL - Account Payable 1,489,100,000 2,370,200,000 4,438,200,000
CL - Short-Term Debt 160,200,000 159,600,000 503,700,000
CL - Provisions 334,500,000 364,300,000 512,500,000
CL - NCL Held Sale 0 0 0
CL - Other 0 0 0
Total Curr. Liabilities 1,983,800,000 2,894,100,000 5,454,400,000
NCL - Account Payable 16,000,000 12,800,000 52,200,000
NCL - Long-Term Debt 1,555,500,000 2,104,000,000 3,110,700,000
NCL - Provisions 537,900,000 496,000,000 663,800,000
NCL - Other 0 0 0
Total NCL 2,109,400,000 2,612,800,000 3,826,700,000
Total Liabilities 4,093,200,000 5,506,900,000 9,281,100,000
Net Assets 3,224,700,000 3,346,800,000 4,050,100,000
Share Capital 501,000,000 478,200,000 476,900,000
Reserves 5,600,000 65,500,000 209,100,000
Retained Earnings 2,444,500,000 2,531,000,000 2,946,000,000
Other Equity 0 0 0
Equity Avail for Ordinary Shareholders 2,951,100,000 3,074,700,000 3,632,000,000
Convertible Equity 0 0 0
SE Held Sale 0 0 0
Outside Equity 273,600,000 272,100,000 418,100,000
Total Equity 3,224,700,000 3,346,800,000 4,050,100,000
Calculate the following ratios upto two decimals
2020 2021 2022
Liquidity ratios
Current ratio
Quick ratio
Activity Ratios
Inventroy Turnover
No. of days of inventory
Avg sales per day
Avg collection period in days
Average purchases/day
Average payment period
Fixed asset turnover
Total asset turnover
Debt ratios
Debt ratio
Debt to Equity ratio
Asset to Equity ratio
Times Interest earned
Profitability Ratios
Gross profit Margin in %
Operating profit Margin in %
Net profit Margin in %
Earnings per share
Return on total assets in %
Return on Ordinary equity
Profitability Ratios (Du Pont)
Return on Ordinary equity
Market Ratios-P/E ratio
Earnings per share
Price to Earnings(P/E )ratio
Book Value per share
Market to Book(M/B) share

Calculate the ratios as requested in the above based on financial sheet?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Cost Accounting

Authors: William Lanen, Shannon Anderson, Michael Maher

3rd Edition

9780078025525, 9780077517359, 77517350, 978-0077398194

More Books

Students also viewed these Accounting questions

Question

Who usually administers a bond sinking fund?

Answered: 1 week ago