Instructions: There are 2 parts in this assignment. Attempt both and write a report for this assignment. This assignment may need Excel for analysis rather than manual calculation. Part A [CLO2, 50 marks] Select FIVE stocks from the same industry, traded in any stock market where financial statements are ratio analysis data are available. Conduct relevant ratio analysis which include: i. Liquidity Ratios: the company's ability to meet day-to-day operating expenses and satisfy short-term obligations as they become due ii. Activity Ratios: how well the company is managing its assets iii. Leverage Ratios: amount of debt used by the company iv. Profitability Ratios: measures how successful the company is at creating profits 1.You need to conduct trend analysis on each ratio for each stock. [20 marks] 2.You also need to compare the most current ratio for each stock with the industry. If there are no industry ratios available, take the average of the 5 stocks to proxy the industry performance. [20 marks] 3. Recommend ONE share to investors, based on the above ratio analysis. Give your rationales on the recommendation. [10 marks] Instructions: There are 2 parts in this assignment. Attempt both and write a report for this assignment. This assignment may need Excel for analysis rather than manual calculation. Part A [CLO2, 50 marks] Select FIVE stocks from the same industry, traded in any stock market where financial statements are ratio analysis data are available. Conduct relevant ratio analysis which include: i. Liquidity Ratios: the company's ability to meet day-to-day operating expenses and satisfy short-term obligations as they become due ii. Activity Ratios: how well the company is managing its assets iii. Leverage Ratios: amount of debt used by the company iv. Profitability Ratios: measures how successful the company is at creating profits 1.You need to conduct trend analysis on each ratio for each stock. [20 marks] 2.You also need to compare the most current ratio for each stock with the industry. If there are no industry ratios available, take the average of the 5 stocks to proxy the industry performance. [20 marks] 3. Recommend ONE share to investors, based on the above ratio analysis. Give your rationales on the recommendation. [10 marks]