Performance Ratios in Financial Modeling

Performance Ratios in Financial Modeling

There are 4 common types of financial ratios that a good financial analyst will use to assess the performance of a business or project in building or interpretating the results of a financial model.

These 4 performance ratios are by no means exhaustive, but provide a good rule of thumb indication on the most important ones to take note of in a financial modeling exercise.

  1. Return on assets (ROA), this ratio provides an indication of how effectively a business is utilizing its investments in assets : ROA = Net income  /  Average assets
  2. Operating margin, a good high-level indicator of profitability and profit potential or “wiggle room” (robustness to competitive and external factors that may reduce profitability in the short-run) : Operating margin = EBIT  /  Sales
  3. Asset turnover, this ratio provides a further indication of the effectiveness of capital/asset utilization and relative “capital intensity” of a business: Asset turnover = Sales  /  Average assets
  4. Return on Equity (ROE), also known as the Return on average common equity or return on net worth, measures the rate of return on the ownership interest (shareholders’ equity) of the common stock owners. ROE measures a firm’s efficiency at generating profits from every dollar of net assets, and shows how well a company uses investment dollars to generate earnings growth. Look at the illustration below for details of the formula for ROE:

ROE

If you're new to Financial Modeling Guide, you may want to join our sister site, the Finance 3.0 network, to enroll in online financial training programs, ask questions, attend seminars, connect with others and download free finance spreadsheet templates about financial modeling, financial management, corporate finance & valuation, quantitative finance and accounting.
Over 65,000 finance professionals, entrepreneurs, analysts and investors from 195 countries have benefited.
Don't miss out on this outstanding opportunity for high quality, globally recognized financial education: Sign Up For Free Now!

After reading this article, people also reviewed these financial modeling and valuation resources:

5 Responses to “Performance Ratios in Financial Modeling”

  1. i think the formula for ROA should be net income divided by average assets instead of net income times average assets

  2. Well spotted – we have made the amendments. It now reads as what you have pointed out.

    Visitors like you keep us on our editorial toes, so thanks for the feedback and please do continue to keep an eye on what we publish so that we can serve up relevant and accurate information on financial modeling.

  3. Love the site, thanks

  4. Hi

    I’m studying at a University in New Zealand, I won’t say which one, just in case!

    I think ROA should really be NOPAT/OPNA
    (Net Operating Profit after Tax / Operating Net Assets)

    It’s a better reflection of the true ROA (which is self explanatory by the use of Operating profits and assets instead of totals)

    Cheers

    Nathan

  5. Sorry I mean Nets and Averages of those figures, not totals. Although you could use the Du Pont formula for further clarification.

    Does this seem right?

Weigh in - share your financial insights on this article