useful formula

Question The summarised financial statements of Jupiter ple and Juno ple for the year ended 30 June 2018 are set out below. Both companies operate in the retail sector Required: Your client is considering an investment in the ordinary shares of either of the above companies and would like you to write a report advising which of the two would make the better investment. Your report should include the following The calculation of a selection of TEN ratios for each company which will help assess the profitability, asset manapament, short-term solvency and long term financial health of the companies. (Please do not calculate any more than 10) (20 marks) An evaluation of the ratios you have calculated. (20 marks) An identification and discussion of two other types of information which would be helpful in making an investment decision (4 marks) (iv) A brief discussion of some of the limitations of ratio analysis 6 marks) Financial Ratios (in alphabetical order) 1) Acid test (Quick) ratio Current assets stock Current liabilities 2, Current ratio Current assets Current liabilities 3) Dividend Cover Profit available for ordinary shareholders Ordinary Dividends Dividend Payout Ratio Dividends Profit available for ordinary shareholders 5) Dividend Per Share Dividend Number of Shares Dividend Yield Ratio 100 Dividend per Share Market Value per Share 7) Earnings per share Profit After Interest and Tax-Preference Dividend Number of ordinary shares Gearing x100 Debt. x 100 Equity OR Debt Debt + equity 9 Gross profit margin Gross profit Sales revenue x 100 10 Interest cover Operating profit (PBIT) Interest payable in Operating profit margin Operating . Gross profit margin Gross profit Sales revenue x 100 10 Interest cover Operating profit (PBIT Interest payable in Operating profit margin Operating profit_ Sales revenue x 100 12) Price/Earnings Ratio Market value nsr share Earnings per share 13) Return on Capital Employed (ROCE) Profit Before Interest and Taxation x 100 Share Capital Reserves +Long Term Loans 14) Return on Equity (ROE) x 100 Profit available for Shareholders Ordinary Share Capital Reserves 15) Sales to Capital Employed Sales Capital Employed 16 Sales Per Employee Sales Number of employees 17) Stock (Inventory)Turnover Period Closing Stock x 365 days Cost of Sales 18) Trade Payable Days (Creditors) Trade Payables x 365 days Purchases (COS) 19) Trade Receivable Days (Debtors) Trade Receivables x 365 days Credit Sales Question 1 The summarised financial statements of Jupiter ple and Juno plc for the year ended 30 June 2018 are set out below. Both companies operate in the retail sector. Statement of Financial Position as at 30 June 2015 Jupiter ple June ple 1000s Non-Current Assets Property.plant & equipment 296 1466 Intangible assets 1460 1 975 Current Assets Inventories 1750 12 Trade Receivables 1 1 450 11 12 Bank 1272 2200 1212 Current Liabilities Trade Payables 1962 11714 Bank Overdraft 30610 111261 714 Net Current Assets 93211 Total Assets less current liabilities 10688 Non-Current Liabilities Long Term Loans SNN Net Assets Equity Ordinary Share Capital (El Shares) Retained Earnings Total Equity 2000 3488 Statement of Profit & Loss for the year ended 30 June 2018 3700 Sales Revenue Cost of Sales Kross Profit Operating Expenses Operating Profit Interest Payable Profit before taxation Profit after taxation Dividends paid