DFS Ratio's **Please Help**

Options
stevenbcfc
stevenbcfc Registered Posts: 19 New contributor ๐Ÿธ
Hi, i'm doing DFS tomorrow but i want to ensure that the following formula's are correct for the following ratios but are there any im missing and are any of these wrong??

GP Ratio = GP/Revenue x 100

NP Ratio = NP/Revenue x 100

Return on Capital employed = Net profit/Equity x 100

Inventory turnover = Inventories/COS x 100

Trade receivable turnover = Trade receivables/Revenue x 365

Trade payables turnover = Trade payables/COS x 365

Okay this is where im a little more unsure ;

Acid Ratio
Quick Ratio
Gearing ratio

one of these is current assets/current liabilites
another is current assets - inventories/current liabilities
another is long term debt/LTD + equity ????

Comments

  • fpettifer
    fpettifer Registered Posts: 40 Regular contributor โญ
    Options
    Be carefully where you've put net profit. I believe its Operating profit (PBIT), net profit would be after interest and tax. Payables you could also use purchases instead of COS.

    Acid and quick are the same = current assets - inventories / current liabilities

    Gearing = debt / equity or long term debt / equity + debt
  • hfadkins19
    hfadkins19 Registered Posts: 12 New contributor ๐Ÿธ
    Options
    inventories turnover is calculated in days so it is inventories / cost of sales x 365
  • Richard
    Richard Registered Posts: 373 Dedicated contributor ๐Ÿฆ‰
    Options
    A few other ratios that you may find helpful are:

    Current Ratio = Current Assets / Current Liabilities

    Interest Cover = Profit from operations / Finance Costs

    Also, I calculate ROCE as Profit from operations / Equity + Long-term liabilities (ie loans)
  • stevenbcfc
    stevenbcfc Registered Posts: 19 New contributor ๐Ÿธ
    Options
    gearing ratio

    i dont understand what u mean by this as you come out with different answers;

    Gearing = debt / equity or long term debt / equity + debt

    So say debt is 10 k n equity is 40k =

    debt (10k) / equity (40k) = 0.25
    debt (10k) / long term debt (10k) = 1
    debt (10k) / equity (40k) + debt (10k) 0.20

    Im confused......
  • stevenbcfc
    stevenbcfc Registered Posts: 19 New contributor ๐Ÿธ
    Options
    Return on capital employed

    Im a little confused on this aswell - is return on equity and return on capital employed the same thing??

    And if so and you calculate as follows why does it give different answers;

    Profit attributable to shareholders (after tax and int) / equity

    Profit before Int and tax / equity + long term loans

    help im worried!!
  • Richard
    Richard Registered Posts: 373 Dedicated contributor ๐Ÿฆ‰
    Options
    i dont understand what u mean by this as you come out with different answers;

    Gearing = debt / equity or long term debt / equity + debt

    So say debt is 10 k n equity is 40k =

    debt (10k) / equity (40k) = 0.25
    debt (10k) / long term debt (10k) = 1
    debt (10k) / equity (40k) + debt (10k) 0.20

    Im confused......

    Either method is acceptable in an exam, just stick with the one you feel happier with. Just remember that if a question asks you to compare the ratio for 2 years or companies, be consistent with your formula to give an accurate like-for-like comparison.

    Debt / Debt + Equity will always give a lower answer than Debt / Equity.

    Gearing ratio is showing you how much lending the company is being financed with, so the higher the figure, the more lending it has.
  • Richard
    Richard Registered Posts: 373 Dedicated contributor ๐Ÿฆ‰
    Options
    Im a little confused on this aswell - is return on equity and return on capital employed the same thing??

    And if so and you calculate as follows why does it give different answers;

    Profit attributable to shareholders (after tax and int) / equity

    Profit before Int and tax / equity + long term loans

    help im worried!!

    Return on equity would be used by the shareholders who have invested in the company. You use the Profit after tax and interest as this is the profit that the shareholders would get back, in the event of the company going into liquidation the tax and interest liabilities would be settled first.

    Whereas ROCE is more interested in the overall performance of the investments which is why long term lending is included.

    I hope this makes sense to you. Good luck for tomorrow! I'm sitting DFS too.
  • stevenbcfc
    stevenbcfc Registered Posts: 19 New contributor ๐Ÿธ
    Options
    gearing ratio
    Either method is acceptable in an exam, just stick with the one you feel happier with. Just remember that if a question asks you to compare the ratio for 2 years or companies, be consistent with your formula to give an accurate like-for-like comparison.

    Debt / Debt + Equity will always give a lower answer than Debt / Equity.

    Gearing ratio is showing you how much lending the company is being financed with, so the higher the figure, the more lending it has.


    So i will get marks for debt/equity cuz i find that easy to remember but i just get confused when different formulas are thrown at me when i've learnt one.

    Sorry....for everybody thats taking the exam good luck this is my 2nd attempt...im cool with the income statement, balance sheet, consolidate balance sheet & cashflow its just these stupid ratios!!!! ARGH!!!
  • Richard
    Richard Registered Posts: 373 Dedicated contributor ๐Ÿฆ‰
    Options
    I'm using Osborne study books and they say that either method is acceptable.
  • stevenbcfc
    stevenbcfc Registered Posts: 19 New contributor ๐Ÿธ
    Options
    Current ratio

    Is the current ratio the same as the acid test?

    Are they both C.Assets/C.Liabilities?

    Sorry bout all the questions
  • Richard
    Richard Registered Posts: 373 Dedicated contributor ๐Ÿฆ‰
    Options
    No, quick and acid are the same. Current is c.assets/c. liabilities. Quick/acid is c.assets-stock/c.liabilities. As stock is the least liquid asset, it is taken out of the equation.
  • stevenbcfc
    stevenbcfc Registered Posts: 19 New contributor ๐Ÿธ
    Options
    Ratios

    So have i covered most/all below?

    Stock turnover
    Trade payables turnover
    Trade receivables turnover
    Gearing ratio
    Quick ratio
    Current ratio
    Return on equity
    Return on Capital Employed (This includes long term debt)
    Interest Cover
    Asset turnover - please remind me of this one??
  • mark130273
    mark130273 Registered Posts: 4,234 Beyond epic contributor ๐Ÿง™โ€โ™‚๏ธ
    Options
    well you got most of them !!!!

    asset turnover is the one for me !!
Privacy Policy