Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started