Ratio Cathay Pacific 2022 Dupont analysis Download this worksheet and complete independently by following the instructions....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Ratio Cathay Pacific 2022 Dupont analysis Download this worksheet and complete independently by following the instructions. You may submit a handwritten or typed answers as long as your calculations are showing. + All answers should be highlighted. Due date is Fri 9 Feb 23:59 on Blackboard Assignments.+ 1. Search in Investor Relations section of Cathay Pacific website and save a copy of "Cathay Pacific Annual Report 2022" in PDF format answer the below questions. < + 2. Calculate below 2022 ratios using the data from the annual report and the formulas provided in the lecture/textbook. Use the middle column to show your calculation for 2022 and record. your answer in the right most column. Round up to 2 decimal places. + (Reminder: Use the appropriate units when finalizing your answers. For example, all profit ratios should be in %)+ Current ratio Debt/equity ratio Cash coverage ratio Equity multiplier Return on equity Return on assets Profit Margin Asset Tumover Calculation 2022 Answer CONSOLIDATED STATEMENT OF FINANCIAL POSITION at 31st December 2022 Note 2022 HKSM 2021 HK$M 2022 USSM US$M ASSETS AND LIABILITIES Non-current assets and liabilities Property, plant and equipment 7 Intangible assets 8 118,855 14,800 123.990 15,238 15.896 15,035 1,898 1,928 Investments in associates 9 16,492 24,532 2,114 3,145 Other long-term receivables and investments 10 3,297 3,327 423 427 Deferred tax assets 14 1.134 846 145 108 154,578 167,730 19,818 21,504 Interest-bearing liabilities 11 (62,463) (67,504) (8,008) (8.655) Other long-term payables 12 (2,766) (3.441) (355) (441) Other long-term contract liabilities 18 (282) (478) (36) Deferred tax liabilities Net non-current assets (8,117) (73,628) 80,950 (9,820) (1,041) (81,243) (9,440) 86,487 10.378 (61) (1.259) (10,416) 11,088 Current assets and liabilities Stock Trade and other receivables Assets held for sale Liquid funds Interest-bearing liabilities Trade and other payables Contract liabilities Taxation Net current liabilities Total assets less current liabilities Net assets. CAPITAL AND RESERVES Share capital Reserves Funds attributable to the shareholders of Cathay Pacific Non-controlling interests Total equity 15 1,137 6.921 1,269 8,296 146 887 163 1,064 1 48 6 16 18,277 19,284 2,343 2,472 26,336 28,897 3,376 3,705 11 (14,643) (22,350) (1,877) (2,865) 17 (11,199) (10,095) (1,436) (1,294) 18 (13,537) (7,925) (1,735) (1,016) (4,023) (43,402) (43,135) (2,765) (516) (355) (5,564) (5,530) (17,066) (14,238) (2,188) (1,825) 137,512 153,492 17,630 19,679 63,884 72,249 8,190 9,263 48.322 48.322 6.195 6,195 15,556 23,922 1,994 3,067 63,878 72,244 8,189 9,262 6 63,884 5 72,249 8,190 9,263 The financial statements are prepared and presented in HK$, the functional currency of Cathay Pacific. The US$ figures are shown only as supplementary information and are translated at US$1:HK$7.8. The notes on pages 77 to 127 and the principal accounting policies on pages 128 to 137 form part of these financial statements. CONSOLIDATED STATEMENT OF PROFIT OR LOSS AND OTHER COMPREHENSIVE INCOME for the year ended 31st December 2022 Note 2022 HK$M HKSM 2022 USSM 2021 US$M Revenue Cargo services Passenger services Other services and recoveries Total revenue Expenses Staff 14,333 4,357 1,838 30,554 35,814 3,917 6,149 5,416 51,036 45,587 558 4,592 788 6,543 694 5.844 (10,571) Inflight service and passenger expenses (694) Landing, parking and route expenses Fuel, including hedging gains Aircraft maintenance Aircraft depreciation and rentals Other depreciation, amortisation and rentals Others Operating expenses Restructuring costs Impairment and related charges Gain on deemed partial disposal of an associate Operating profit/(loss) (11,298) (366) (5,590) (5,743) (1,355) (1,449) (89) (717) (47) (736) (10,488) (7,031) (1,345) (3,206) (5,152) (901) (411) (661) (9,884) (10,444) (1,267) (1,339) (2,544) (2.381) (4,513) (3,622) (326) (578) (305) (464) (47.490) (46,037) (6,088) (5,902) Operating profit/(loss) before non-recurring items 3,546 (450) 455 (58) (385) - (49) 3,546 (818) 210 (1,443) (105) 27 455 Taxation Finance charges Finance income Net finance charges Share of losses of associates Loss before taxation Loss for the year Attributable to 165 (2,909) (2,629) (3,074) (2,704) (394) 75 (185) (347) 21 10 (373) (337) (6,677) (1.985) (856) (254) (6,040) (6,057) (774) (776) (507) (6,547) 531 (65) 68 (5.526) (839) (708) Ordinary shareholders of Cathay Pacific Preference shareholder of Cathay Pacific 20 (7,162) 614 (6,123) 596 (918) 79 (785) 77 Non-controlling interests Loss for the year (6,547) (5,526) (839) (708) Loss per ordinary share Basic and diluted Loss for the year (111.3)c (95.1) (14.3)c (12.2) (6,547) (5.526) (839) (708) Other comprehensive income Items that are or may be reclassified subsequently to profit or loss: Cash flow hedges (707) 2,581 (90) 331 Share of other comprehensive income of associates Exchange differences on translation of foreign operations Items that are or may not be reclassified subsequently to profit or loss: 227 211 29 27 (1,442) 691 (185) 89 Defined benefit plans 108 510 14 65 Revaluation of equity investments designated at fair value through other comprehensive income (non-recycling) (4) (5) (1) (1) Other comprehensive income for the year, net of taxation Total comprehensive income for the year Total comprehensive income attributable to Ordinary shareholders of Cathay Pacific Preference shareholder of Cathay Pacific Non-controlling interests 6 (1,818) 3.988 (8,365) (1,538) (233) (1,072) 511 (197) 20 (8,980) (2,135) 614 596 (1,151) 79 (274) 77 (8,365) (1.538) (1,072) (197) CONSOLIDATED STATEMENT OF CASH FLOWS for the year ended 31st December 2022 Operating activities Note 2022 HK$M 2021 HK$M 2022 2021 US$M US$M Cash generated from operations Interest received Interest paid Tax paid Net cash inflow from operating activities 22 21,386 129 11,705 67 2,742 1,500 17 9 (2,432) (1,946) (313) (249) (1,247) (991) (160) (127) 17,836 8,835 2,286 1,133 Investing activities Net (increase)/decrease in liquid funds other than cash and cash equivalents (183) 2,464 (23) 316 Proceeds from sales of property, plant and equipment 50 112 6 14 Net increase in other long-term receivables and investments Payments for property, plant and equipment and intangible assets Dividends received (17) (17) (2) (2) (3,729) (2,276) (478) (292) 1,096 140 23 (2,760) 210 493 3 27 (354) 63 Net repayments of loans to associates Net cash (outflow)/inflow from investing activities Financing activities New financing 11 Loan and lease repayments 11 Net cash outflow from financing activities 6,115 13,906 (22,351) (20,838) (16,236) (6,932) 784 1,783 (2,865) (2,081) (2,672) (889) Net (decrease)/increase in cash and cash equivalents Cash and cash equivalents at 1st January (1,160) 8,573 2,396 (149) 6,166 1,099 307 791 Effect of exchange differences (73) 11 (9) 1 Cash and cash equivalents at 31st December 16 7,340 8,573 941 1,099 The financial statements are prepared and presented in HK$, the functional currency of Cathay Pacific. The US$ figures are shown only as supplementary information and are translated at US$1:HK$7.8. The notes on pages 77 to 127 and the principal accounting policies on pages 128 to 137 form part of these financial statements. Ratio Cathay Pacific 2022 Dupont analysis Download this worksheet and complete independently by following the instructions. You may submit a handwritten or typed answers as long as your calculations are showing. + All answers should be highlighted. Due date is Fri 9 Feb 23:59 on Blackboard Assignments.+ 1. Search in Investor Relations section of Cathay Pacific website and save a copy of "Cathay Pacific Annual Report 2022" in PDF format answer the below questions. < + 2. Calculate below 2022 ratios using the data from the annual report and the formulas provided in the lecture/textbook. Use the middle column to show your calculation for 2022 and record. your answer in the right most column. Round up to 2 decimal places. + (Reminder: Use the appropriate units when finalizing your answers. For example, all profit ratios should be in %)+ Current ratio Debt/equity ratio Cash coverage ratio Equity multiplier Return on equity Return on assets Profit Margin Asset Tumover Calculation 2022 Answer CONSOLIDATED STATEMENT OF FINANCIAL POSITION at 31st December 2022 Note 2022 HKSM 2021 HK$M 2022 USSM US$M ASSETS AND LIABILITIES Non-current assets and liabilities Property, plant and equipment 7 Intangible assets 8 118,855 14,800 123.990 15,238 15.896 15,035 1,898 1,928 Investments in associates 9 16,492 24,532 2,114 3,145 Other long-term receivables and investments 10 3,297 3,327 423 427 Deferred tax assets 14 1.134 846 145 108 154,578 167,730 19,818 21,504 Interest-bearing liabilities 11 (62,463) (67,504) (8,008) (8.655) Other long-term payables 12 (2,766) (3.441) (355) (441) Other long-term contract liabilities 18 (282) (478) (36) Deferred tax liabilities Net non-current assets (8,117) (73,628) 80,950 (9,820) (1,041) (81,243) (9,440) 86,487 10.378 (61) (1.259) (10,416) 11,088 Current assets and liabilities Stock Trade and other receivables Assets held for sale Liquid funds Interest-bearing liabilities Trade and other payables Contract liabilities Taxation Net current liabilities Total assets less current liabilities Net assets. CAPITAL AND RESERVES Share capital Reserves Funds attributable to the shareholders of Cathay Pacific Non-controlling interests Total equity 15 1,137 6.921 1,269 8,296 146 887 163 1,064 1 48 6 16 18,277 19,284 2,343 2,472 26,336 28,897 3,376 3,705 11 (14,643) (22,350) (1,877) (2,865) 17 (11,199) (10,095) (1,436) (1,294) 18 (13,537) (7,925) (1,735) (1,016) (4,023) (43,402) (43,135) (2,765) (516) (355) (5,564) (5,530) (17,066) (14,238) (2,188) (1,825) 137,512 153,492 17,630 19,679 63,884 72,249 8,190 9,263 48.322 48.322 6.195 6,195 15,556 23,922 1,994 3,067 63,878 72,244 8,189 9,262 6 63,884 5 72,249 8,190 9,263 The financial statements are prepared and presented in HK$, the functional currency of Cathay Pacific. The US$ figures are shown only as supplementary information and are translated at US$1:HK$7.8. The notes on pages 77 to 127 and the principal accounting policies on pages 128 to 137 form part of these financial statements. CONSOLIDATED STATEMENT OF PROFIT OR LOSS AND OTHER COMPREHENSIVE INCOME for the year ended 31st December 2022 Note 2022 HK$M HKSM 2022 USSM 2021 US$M Revenue Cargo services Passenger services Other services and recoveries Total revenue Expenses Staff 14,333 4,357 1,838 30,554 35,814 3,917 6,149 5,416 51,036 45,587 558 4,592 788 6,543 694 5.844 (10,571) Inflight service and passenger expenses (694) Landing, parking and route expenses Fuel, including hedging gains Aircraft maintenance Aircraft depreciation and rentals Other depreciation, amortisation and rentals Others Operating expenses Restructuring costs Impairment and related charges Gain on deemed partial disposal of an associate Operating profit/(loss) (11,298) (366) (5,590) (5,743) (1,355) (1,449) (89) (717) (47) (736) (10,488) (7,031) (1,345) (3,206) (5,152) (901) (411) (661) (9,884) (10,444) (1,267) (1,339) (2,544) (2.381) (4,513) (3,622) (326) (578) (305) (464) (47.490) (46,037) (6,088) (5,902) Operating profit/(loss) before non-recurring items 3,546 (450) 455 (58) (385) - (49) 3,546 (818) 210 (1,443) (105) 27 455 Taxation Finance charges Finance income Net finance charges Share of losses of associates Loss before taxation Loss for the year Attributable to 165 (2,909) (2,629) (3,074) (2,704) (394) 75 (185) (347) 21 10 (373) (337) (6,677) (1.985) (856) (254) (6,040) (6,057) (774) (776) (507) (6,547) 531 (65) 68 (5.526) (839) (708) Ordinary shareholders of Cathay Pacific Preference shareholder of Cathay Pacific 20 (7,162) 614 (6,123) 596 (918) 79 (785) 77 Non-controlling interests Loss for the year (6,547) (5,526) (839) (708) Loss per ordinary share Basic and diluted Loss for the year (111.3)c (95.1) (14.3)c (12.2) (6,547) (5.526) (839) (708) Other comprehensive income Items that are or may be reclassified subsequently to profit or loss: Cash flow hedges (707) 2,581 (90) 331 Share of other comprehensive income of associates Exchange differences on translation of foreign operations Items that are or may not be reclassified subsequently to profit or loss: 227 211 29 27 (1,442) 691 (185) 89 Defined benefit plans 108 510 14 65 Revaluation of equity investments designated at fair value through other comprehensive income (non-recycling) (4) (5) (1) (1) Other comprehensive income for the year, net of taxation Total comprehensive income for the year Total comprehensive income attributable to Ordinary shareholders of Cathay Pacific Preference shareholder of Cathay Pacific Non-controlling interests 6 (1,818) 3.988 (8,365) (1,538) (233) (1,072) 511 (197) 20 (8,980) (2,135) 614 596 (1,151) 79 (274) 77 (8,365) (1.538) (1,072) (197) CONSOLIDATED STATEMENT OF CASH FLOWS for the year ended 31st December 2022 Operating activities Note 2022 HK$M 2021 HK$M 2022 2021 US$M US$M Cash generated from operations Interest received Interest paid Tax paid Net cash inflow from operating activities 22 21,386 129 11,705 67 2,742 1,500 17 9 (2,432) (1,946) (313) (249) (1,247) (991) (160) (127) 17,836 8,835 2,286 1,133 Investing activities Net (increase)/decrease in liquid funds other than cash and cash equivalents (183) 2,464 (23) 316 Proceeds from sales of property, plant and equipment 50 112 6 14 Net increase in other long-term receivables and investments Payments for property, plant and equipment and intangible assets Dividends received (17) (17) (2) (2) (3,729) (2,276) (478) (292) 1,096 140 23 (2,760) 210 493 3 27 (354) 63 Net repayments of loans to associates Net cash (outflow)/inflow from investing activities Financing activities New financing 11 Loan and lease repayments 11 Net cash outflow from financing activities 6,115 13,906 (22,351) (20,838) (16,236) (6,932) 784 1,783 (2,865) (2,081) (2,672) (889) Net (decrease)/increase in cash and cash equivalents Cash and cash equivalents at 1st January (1,160) 8,573 2,396 (149) 6,166 1,099 307 791 Effect of exchange differences (73) 11 (9) 1 Cash and cash equivalents at 31st December 16 7,340 8,573 941 1,099 The financial statements are prepared and presented in HK$, the functional currency of Cathay Pacific. The US$ figures are shown only as supplementary information and are translated at US$1:HK$7.8. The notes on pages 77 to 127 and the principal accounting policies on pages 128 to 137 form part of these financial statements.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Use java networking sub progrMMNING LAMHUIAGE NTO SOLVE ALL THE QUESTION, Note solve all the question or i rate unhelkpful Calculate the average MPG for each vehicle. a. Enter a formula in cell C10...
-
After reviewing the definition of Behavior Leadership Theory, explain what effect behavioral leadership theory has on traditional police in their role as a chief or any other leadership role in law...
-
Refrigerant-134a enters an adiabatic compressor as saturated vapor at 100 kPa at a rate of 0.7 m3/min and exits at 1-MPa pressure. If the isentropic efficiency of the compressor is 87 percent,...
-
According to Scientist 2s viewpoint, compared to other planets of the solar system, Plutos surface is: A. Less icy. B. More icy. C. More gaseous. D. More rocky.
-
The following article provides an overview of circuit breakers with high voltage ratings at or above 72.5 kV [4]. Circuit breakers are broadly classified by the medium used to extinguish the arc:...
-
The cost of the trading securities of Hardy Company at December 31, 2012, is $62,000. At December 31, 2012, the fair value of the securities is $59,000. Prepare the adjusting entry to record the...
-
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 30% of monthly sales are to cash customers,...
-
What are the prospects for harnessing microbial diversity and symbiotic interactions in the development of novel biotechnological solutions for agricultural productivity, environmental...
-
What is meant by a firms debt capacity?
-
What capital components are typically included when estimating a firms CCC?
-
Should large businesses estimate divisional costs of capital? Explain your answer.
-
What is the primary difference between the CCC for invest or owned and not-for-profit firms?
-
Some people are about to form a company, as a vehicle through which to run a new business. What factors should they bear in mind when deciding between forming a private limited company or a public...
-
Identify several factors that you think would be particularly effective in motivating managers and professionals. Explain your reasoning.
-
A. Select a recent issue (paper or online) of Report on Business Magazine, Canadian Business Magazine (online only), Bloomberg Businessweek, Fast Company, The Economist, or another business magazine....
-
Verify that the log-likelihood of model (7.7) is \(\sum_{i=1}^{k}\left[n_{i} \lambda-\exp (\lambda) ight]\). (a) Compute MLE of \(\lambda\). (b) Compute the Pearson chi-square statistic and compare...
-
Think about the general concept of a relationship, not necessarily in a business setting, but just relationships in general between any two parties. What aspects of relationships are inherently...
-
Has transactional selling gone the way of the dinosaur? That is, are there ever any situations in which a transactional approach to selling would be an appropriate approach today? If so, what are...
Study smarter with the SolutionInn App