RatioAnalysisFormulasSheet.xlsx

RatioAnalysisFormulasSheet.xlsx

Ratio Analysis Formula

Ratio Analysis Formula Sheet
Group 1: Profitability Ratios
1- Gross Profit Margin =Gross Profit* 100
Sales revenue
2- Operating Profit Margin =Operating Profit* 100
Sales revenue
3- Return on Capital Employed =Profit before interest and tax* 100
Capital Employed
Group 2: Liquidity Ratios
1- Current Ratio (Working Capital Ratio) =Current Assets
Current Liabilities
2- Acid Test Ratio (Quick Ratio) =Current Assets – Inventory
Current Liabilities
Group 3: Efficiency Ratios
1- Inventory Turnover = Inventory* 365 days
Cost of Sales
2- Trade Receivables Turonver =Trade Receivables* 365 days
Revenue
3- Trade Payables Turnover =Trade Payables* 365 days
Cost of Sales
Group 4: Financial Gearing Ratios
1- Gearing Ratio =Long term debts* 100
Capital Employed
2- Interest Coverage =Operating Profit
Interest Payable
Group 5: Investor Ratios
1- Dividend Payout Ratio =Dividends announced for the year* 100
Profit after tax
2- Dividend Cover Ratio =Profit after tax
Dividend announced for the year
3- Dividend per Share =Dividend announced for the year
Number of ordinary shares in issue
4- Dividend Yield Ratio =Dividend per share * 100
Market price per share
5- Earnings Per Share =Profit after tax – Preference dividend
Number of ordinary shares in issue
6- Price Earning (P/E) Ratio =Market Price per share
Earning per share