Question: BELOW ARE THE SAMPLE CHART: Compare & analyze the EQUITY RATIO between two companies and provide explanation based on both Trend Analysis and Comparison Analysis

 BELOW ARE THE SAMPLE CHART: Compare & analyze the EQUITY RATIO

BELOW ARE THE SAMPLE CHART:

between two companies and provide explanation based on both Trend Analysis and

  1. Compare & analyze the EQUITY RATIO between two companies and provide explanation based on both Trend Analysis and Comparison Analysis

a.) Use a horizontal (landscape) box format in Microsoft Word.

  • Show all formula and calculations for the all financial ratios in each year.
  • Show the graph of the trend of each ratio. (SAMPLE GRAPH AS PROVIDED)
  • Write your analysis based on
  1. Trend Analysis [year by year performance for each company]; and
  2. Comparison Analysis [ year by year performance between the two companies).

Note: Must use adverbs or adjectives in your description analysis. Examples:

  • The current ratio for 2019 is slightly lower than that of 2018 because
  • In 2019, the current ratio for Maxis is significantly higher than

ii) Equity Ratio Total Equity Total Assets x 100 + COMPANY PBA HOLDINGS RANHILL UTILITIES YEAR 2017 x 100 x 100 2018 x 100 x 100 824,377,000 1,218,640,000 = 0.6765 times / 67.65% 695,873,000 1,263,915 000 = 0.5506 times / 55.06% 678,420 000 1,483,258 000 = 0.4574 times / 45.74% 778,143,000 2,732,650,000 = 0.2848 times / 28.48% 756,751,000 3,335,573 000 = 0.2269 times / 22.69% 800,108,000 3,040,324 000 = 0.2663 times / 26.32% 2019 x 100 x 100 LIQUIDITY RATIO MAXIS BERHAD (full name) 2017 2018 2019 DIGI BERHAD (full name) 2018 2019 2017 = A/B = C/D = F/G = H/1 = J/K = L/M CURRENT RATIO = CA/CL [Chart] [Explanation on Trend Analysis and Comparison analysis] 5 Chart Fitle 0 Category 1 Series 1 Category 2 Series 2 Series 3 2017 2018 2019 2017 2018 2019 QUICK RATIO = (CA - Inventory)/CL 5 Chart Fitle 0 Categorie 31 2 -Series 2 Series 3 ii) Equity Ratio Total Equity Total Assets x 100 + COMPANY PBA HOLDINGS RANHILL UTILITIES YEAR 2017 x 100 x 100 2018 x 100 x 100 824,377,000 1,218,640,000 = 0.6765 times / 67.65% 695,873,000 1,263,915 000 = 0.5506 times / 55.06% 678,420 000 1,483,258 000 = 0.4574 times / 45.74% 778,143,000 2,732,650,000 = 0.2848 times / 28.48% 756,751,000 3,335,573 000 = 0.2269 times / 22.69% 800,108,000 3,040,324 000 = 0.2663 times / 26.32% 2019 x 100 x 100 LIQUIDITY RATIO MAXIS BERHAD (full name) 2017 2018 2019 DIGI BERHAD (full name) 2018 2019 2017 = A/B = C/D = F/G = H/1 = J/K = L/M CURRENT RATIO = CA/CL [Chart] [Explanation on Trend Analysis and Comparison analysis] 5 Chart Fitle 0 Category 1 Series 1 Category 2 Series 2 Series 3 2017 2018 2019 2017 2018 2019 QUICK RATIO = (CA - Inventory)/CL 5 Chart Fitle 0 Categorie 31 2 -Series 2 Series 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!