Perform an integrated financial ratio analysis through Modified Du Pont System on this company using...

60.1K

Verified Solution

Question

Finance

Perform an integrated financial ratio analysis through Modified Du Pont System on this company using the 2020 financial data. Analyse the strengths and weaknesses for this company. For the same industry, the profit margin, total assets turnover, and equity multiplier are 8%, 1.3, and 0.9 respectively.

image

2016/12/31 2017/12/31 US$000 12 months US$000 2015/12/31 US$000 13 months 12 months 365,825 339,449 412 7,980 884 367,121 -17,912 -3,185 -11,830 - 16,006 - 102 350,445 1,178 10,107 361,730 -17,069 0 1,662 7,402 348,513 -15,140 0 - 1,213 -24,809 -580 -27,713 522 510 0 0 0 53,870 53,870 30,368 33,553 49,923 46,476 58,306 71,125 81,061 81,641 43,623 40,054 60,705 67,922 69,135 79,403 98,710 84,275 35.42 56.31 41.87 52.7 74.35 63.46 Profit and Dividend Summary / Ratios Period Ending: 2020/12/31 2019/12/31 2018/12/31 Denomination: US$ 000 US$000 US$000 Reporting Period: 12 months 12 months 12 months Sales Revenue 436,564 367,739 390,028 Interest Received 1,664 2,313 860 Other Revenue 39,637 342 Total Revenue 477,865 378,032 391,230 Depreciation 0 - 14,820 - 15,167 Amortisation 0 - 1,000 - 1,000 Interest Expense - 10,985 - 13,886 -13,107 Tax - 15,328 -5,046 -13,393 Minority Interests - 76 105 -517 Equity Earnings 0 0 0 Reported NPAT 53,344 19,678 26,074 Normalised NPAT 53,344 12,725 27,074 Cash Eamings 52,298 34,897 41,431 EBT (Profit before Tax) 68,748 24,619 39,984 EBIT (Profit before Int. & Tax) 79,733 38,505 53,091 EBITDA (Profit before Int., Tax, 79,733 54,325 69,258 Depreciation & Amortisation) Adjusted EPS (c) 56.98 13.59 28.92 Adjusted Cash EPS (0) 55.86 37.27 44.25 Interim Dividend (c) 9 9 9 Final Dividend () 14 13 13 Adjusted DPS (4) 23 22 22 Ord Div Paid ($000) 21,534 20,598 20,598 Balance Sheet Summary Period Ending: 2020/12/31 2019/12/31 2018/12/31 Denomination: US$000 US$000 US$000 Shareholders Equity 525,846 504,025 503,811 Other Equity 523 443 978 Non-Current Liabilities 93,144 130,198 130,694 Current Liabilities 44,891 48,779 56,430 Equity & Liabilities 664,404 683,445 691,913 Current Assets 109,837 116,536 120,373 Fixed Assets 106,760 531,313 539,411 Investments 32,039 35,596 31,129 Intangibles 415,768 0 1,000 Total Assets 664,404 683,445 691,913! Issued Shares (000) 93,627 93,627 93,627 Adjusted Shares (000) 93,627 93,627 93,627 Ord Shareholders Equity (%) 44.27 73.75 72.77 Current Ratio 2.45 2.39 2.13 Adjusted NTA per share ($) 1.18 5.38 5.37 Ord Earings : Sh/Equity (%) 48.46 2.52 5.38 Ord Earnings : Tot Funds (%) 21.45 1.86 3.92 9 9 9 13 13 12 22 22 21 20,598 21,046 20,089 2016/12/31 US$000 493,713 -501 3,665 2015/12/31 US$000 447,525 -754 2017/12/31 US$000 495,259 354 145,021 46,458 687,092 109,061 548,889 27,142 22,524 519,401 97,302 394,759 27,340 26,955 24,477 498,203 112,859 357,887 27,457 0 0 2,000 687,092! 498,203 519,401 95,664 95,664 93,627 93,627 95,664 95,664 72 95.05 89.83 2.35 4.32 4.61 5.27 5.16 4.68 6.8 10.91 8.95 4.9 10.37 8.04

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students