Ratios analysis is as much an art as it is a science, therefore students must use common sense… 1 answer below »

HIRE QUALIFIED ACADEMIC WRITERS 

Submit a soft copythrough the safeassign icon created in the BlackboardTHE FINANCIAL RATIO ANALYSIS ASSIGNMENTRatios analysis is as much an art as it is a science, therefore students must use common sense and sound judgment throughout the analysis. The purpose of this case study is to provide students with the opportunity to retrieve real time financial data via the Web, and analyze the financial performance of selected companies. Students will download the financial data from Qatar stock exchange website and perform ratio analysis for two companies from the same sector selected from the table below.Companysector4Nakilattransportation5Qatar NavigationStudents are instructed to follow the path shown below to retrieve the financial profile for the selected company via DSM.· Go to Qatar stock exchange website:www.qe.com.qa· From the menu, click on listed securities then Financial Statements· Choose the year 2018& 2019 and hit submit, and then download the annual financial reportof the two firms in the same sector.perform the Ratio Analysis PLUS Graph based upon the following financial ratios:· Liquidity Ratios: to measure the company’s ability to pay its bills;Current RatioQuick Ratio· Activity Ratios: to measure the company’s ability to utilize its assets;Inventory Turnover ratioAverage age of inventoryAccounts receivables TurnoverAverage collection periodTotal Asset turnover· Leverage Ratios: to measure the extent to which the company’s assets are financed with debt;Debt ratioTimes interest earned ratio· Profitability Ratios: to measure the company’s ability to generate earnings;GROS profit marginOperating profit marginNet profit marginReturn on total assetsReturn on common equity· Market Value Ratios: to measure the market perception about the company’s future prospects.P/BVP/EEPSBook Value/Per ShareAfter calculating the financial ratios on excel sheet, each group will compare the two companies then write a report on word file highlighting the strength and weakness points for each company.The recommended layout of your project is suggested to be as follows:Cover pageTable of contentsIntroduction Firm overviewDescription of the companyRatios analysisValuation & recommendationConclusion (summary of your results)General Guidelines1- Reserve the first page (cover page) to group member names, student ID, course name, anduniversity. All group member names should be on the cover page to earn marks.2- You should write in times new roman font, size 12, with 1.5 spaces.4- Failure to submit the group members list by the deadline is subject to mark deductions.5- Failure to submit the soft copy online or the hard copy in class by the due date is subject to mark deductions.6- Maximum similarity index allowed is 15%.GOOD LUCK! Attachments: Project-sprin….docx