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
-
Construction Legal environment in US vs. China/Japan Whenever I teach this topic, it reminds me of my professor, who spent decades in Public Works Department in Florida, and was obviously very much...
-
You are a lead IT auditor conducting an assessment of a mid - sized financial institution's IT governance framework. During your review, you discover that the organization has recently implemented...
-
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...
-
A refrigeration unit compresses saturated R-134a vapor at 10C to 1000 kPa. How much power is required to compress 0.9 kg/s of R-134a with a compressor efficiency of 85 percent?
-
A rocket in outer space in a negligible gravitational field starts from rest and accelerates uniformly at a until its final speed is v. The initial mass of the rocket is m0. How much work does the...
-
Which of the following methods uses accrual accounting rather than net cash flows as a basis for calculations? a. payback b. ARR c. NPV d. IRR
-
On December 31, the Income Summary account of Davison Company has a debit balance of $37,000 after revenue of $39,000 and expenses of $76,000 were closed to the account. Michelle Davison, Drawing has...
-
Tamarisk Corp. purchased machinery for $ 3 4 7 , 4 0 0 on May 1 , 2 0 2 5 . It is estimated that it will have a useful life of 1 0 years, salvage value of $ 1 7 , 4 0 0 , production of 2 6 4 , 0 0 0...
-
F ( x) = 2 + 3 is a function that is being transformed by translation of 3 units to the left. The function that is transformed passes through (- 3, y) so, what would be the value
-
Power Series: Problem 4 Previous Problem Problem List Next Problem (5 points) Find all the values of x such that the given series would converge. Answer: [2,4) Note: Give your answer in interval...
-
The Regal Cycle Company manufacturers three types of bicycles - a dirt bike, a mountain bike and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes...
-
1.Product A has a selling price of P50 per unit and variable expenses of P30 per unit. If the company is past its break-even point and sales increase by P200,000, one would expect net income to...
-
Explain theories and models which examine organisational culture and human behaviour in sufficient depth-you have not provided enough evidence. ACTION POINTS For this criterion, you need to; provide...
-
How is China leading the way in green technology? What should organizations that design and manufacture green technology be including in their long-term strategy? 2. What advice regarding investment...
-
Riverside Company completed the following two transactions. The annual accounting period ends December 31. a. On December 31, calculated the payroll, which indicates gross earnings for wages...
-
Inexhaustible collections of ONPOs are not required to be capitalized or depreciated, if certain criteria are met. Why is this so, and what accounting and reporting recognition, if any, is required...
-
Assume that you have been asked to place a value on the ownership position in Briarwood Hospital. Its projected profit and loss statements and equity reinvestment (asset) requirements are shown below...
-
Assume that you have been asked to place a value on the fund capital (equity) of BestHealth, a not-for-profit HMO. Its projected profit and loss statements and equity reinvestment (asset)...
-
Where would you be able to bring about cost savings as a program manager for a company? Discuss these using the standard project constraints. (Lo 2)
Study smarter with the SolutionInn App