DFS Ratio's **Please Help**
stevenbcfc
Registered Posts: 19 Dedicated 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 ????
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 ????
0
Comments

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 + debt0 
inventories turnover is calculated in days so it is inventories / cost of sales x 3650

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 + Longterm liabilities (ie loans)0 
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......0 
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!!0 
stevenbcfc wrote: ยป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 likeforlike 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.0 
stevenbcfc wrote: ยป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.0 
gearing ratioEither 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 likeforlike 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!!!0 
I'm using Osborne study books and they say that either method is acceptable.0

Current ratio
Is the current ratio the same as the acid test?
Are they both C.Assets/C.Liabilities?
Sorry bout all the questions0 
No, quick and acid are the same. Current is c.assets/c. liabilities. Quick/acid is c.assetsstock/c.liabilities. As stock is the least liquid asset, it is taken out of the equation.0

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??0 
well you got most of them !!!!
asset turnover is the one for me !!0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 586 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership