1- Build a financial profile for OoredooCompany( one page only).
2- Export the info (income statement and balance sheet for year 2014 ONLY from AUX website ONLY) to Excel and use them for computing the ratios ( I need the excel and I have attached the file already from the websitehttps://www.adx.ae/English/Securities/Pages/FinancialReports.aspx?Symbol=QTEL ). So you only will export it to excel.
3- Compute ratios for the company year 2014 based on list provided below:
Current Ratio = CA / CL
Quick Ratio = (CA - Inventory) / CL
Cash Ratio = Cash / CL
Total Debt Ratio = (TA - TE) / TA
Debt/Equity = TD / TE
Times Interest Earned = EBIT / Interest
Cash Coverage = (EBIT + Depreciation) / Interest
Inventory Turnover = Cost of Goods Sold / Inventory
Days' Sales in Inventory = 365 / Inventory Turnover
Receivables Turnover = Sales / Accounts Receivable
Days' Sales in Receivables = 365 / Receivables Turnover
Total Asset Turnover = Sales / Total Assets
Profit Margin = Net Income / Sales
Return on Assets (ROA) = Net Income / Total Assets
Return on Equity (ROE) = Net Income / Total Equity
Attachment:- QTEL-EN - OOREDOO.PDF