course bg
EduPristine>Blog>Step 2: Analyzing Ratios

Step 2: Analyzing Ratios

April 6, 2011

Now that we have established the cash flows via the Indirect Method, it becomes all the more essential to analyze these figures year-on-year using different ratios.

You can download a sample excel model containing the formulas for all the ratios. These ratios are list as follows –

Profitability Ratios

  • Gross Profit Margins
  • EBITDA Margins
  • EBIT Margins
  • EBT Margins/Pre-Tax Margins
  • Net Profit Margin

Return on Investment Ratios

  • Return on Assets (ROA)
  • Return on Assets (ROA) with Interest Added Back
  • Return on Invested Capital (RoIC)
  • Return on Invested Capital (RoIC) with Interest Added Back
  • Return on Stockholder’s Equity (ROE)

Activity Ratios

  • Inventory Turnover – How many times inventory was turned over or sold in a year
  • Days of Inventory – No of days the present inventory will survive
  • Receivables Turnover – How many times the revenue of recognized to the amount yet to be received
  • Days of Sales Outstanding – No of days taken to get back the money from the customers
  • Average Day’s Sales – Average Sale in a Day
  • Days of Sales Outstanding – For 0.49 sale it takes 1 day, for “Receiveables” sale it’ll take Receivable/.49 days
  • Payables Turnover – How many times in a year company pays off its creditors
  • Days of Payables – No of days a company takes to pay off it’s suppliers
  • Working Capital Turnover – How much sales is done with 1 unit of Working Capital
  • Fixed Asset Turnover – How much sales is done with one unit of Fixed Asset Turnover
  • Total asset Turnover – How much sales is done with one unit of Total Asset Turnover

Liquidity Ratios

  • Current Ratio
  • Quick Ratio
  • Cash Ratio
  • Defensive Interval Ratio
  • Cash Conversion Cycle (Net Operating Cycle)

Debt Ratios

  • Debt-to-Assets Ratio
  • Debt-to-Capital Ratio
  • Debt-to-Equity Ratio
  • Financial Leverage Ratio

Coverage Ratios


In case you are not able to download the excel file, then copy paste the following link in the address bar of your browser –

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

Post ID = 7149