Master the technical skills needed to analyze financial statements and disclosures for use in financial analysis, and learn how accounting standards and managerial incentives affect the financial reporting process. By the end of this course, you’ll be able to read the three most common financial statements: the income statement, balance sheet, and statement of cash flows. Then you can apply these skills to a real-world business challenge as part of the Wharton Business Foundations Specialization.
4.1: Overview of Ratio Analysis
Loading...
En provenance du cours de University of Pennsylvania
Introduction to Financial Accounting
notes
À partir de la leçon
Week 4: Ratio Analysis and Final Exam
We will have our final exam this week. Because of the exam, I will cover Ratio Analysis, which will not involve any "new" material. While we will define and discuss a number of ratios, they will all basically involve dividing one accounting number by another. But, the analysis of what those ratios mean will involve a deep understanding of Balance Sheet and Income Statement accounts. Thus, the Ratio Analysis videos will help provide a nice review of the material, which will help you prepare for the exam. However, there will be no questions about ratio analysis on the exam. The only thing left to do after this exam is to impress your family, friends, and co-workers with your vast knowledge of Financial Accounting!
Rencontrer les enseignants
Brian J BusheeThe Geoffrey T. Boisi Professor
Accounting
Hello, I'm Professor Brian Bushee.
Welcome back.
In this video, we're gonna start our look at ratio analysis.
And it's a good point in the course to talk about ratio analysis,
because it'll help us to review some of the material that we've covered so far.
After all there's not a lot to computing ratios.
It's just dividing one number by another.
The real challenge is to try to understand what the ratios are telling us.
And to do so we need to reverse engineer the financial statements.
We need to think about what underlying transactions must have happened to make
the finance statements and the ratios change in the way that they changed.
In other words, the ratios helps identify parts of the business that are changing,
where we need to go in and understand better what's going on with the company.
In this video, we'll talk about some tips for using and misusing ratios.
And we'll also talk about something called the DuPont analysis which is a common
ratio analysis technique for understanding changes in one of the most common ratios
people look at, return on equity.
Let's get started.
Let's start by talking about how to use ratios.
So ratios are gonna be useful in assessing profitability liquidity and risk.
You're gonna highlight sources of competitive advantage for the company so
where the company is doing really well.
And then red flag any potential trouble spots, so where the company is struggling.
But to do this we have to compare the ratios to a benchmark.
There's no absolute benchmark, there's nothing
like return on equity greater than 16% is great, below 16% is bad.
Instead you have to compare the company to the same company across time.
We call this a time-series analysis and it helps highlight trends for
the firm, and we also have to compare the firm to
other firms in the industry doing what we call a cross-sectional analysis.
This is important because sometimes firm trends could really be driven by trends in
the economy or the industry.
So to figure out whether it's the company that's doing something well or
it's just an industry wide phenomenon,
we have to look at the firm compared to its industry or its competitors.
Ratios are contextual.
There's no such thing as a ratio being good news or bad news on its own.
The key is to try to figure out what activity drive the ratio to change and
then decide whether that activity is good news or bad news for the company.
And let's talk about a number of examples of this as we go through the videos.
And finally, the key is that ratio analysis does not provide answers but
instead it's gonna help you ask much better questions.
>> My sister once told me that rations provide all the answers.
She is a long-short hedge fund guru in Hong Kong.
What are your qualifications?
>> Well, I'm not a long-short hedge fund guru.
And I guess there is the old saying that those that can't do, teach.
But I have looked at a lot of financial statements in my time, and I'm pretty
confident in my claim that ratios provide an excellent diagnostic tool to help you
figure out what areas of the finance statements you need to look into further.
But they rarely ever provide you all the answers.
Now, let's talk about how to misuse ratios.
Not that I recommend that, I just recommend avoiding this problem.
So one of the ways that people often misuse ratios
is they don't realize standard ratios actually can have multiple definitions.
There's no standardization or GAAP for ration definitions.
Different sources will use different definitions.
You wanna always make sure you're using the same definition across time and
across companies to make valid comparisons.
Also, choosing the appropriate benchmark for comparison is important.
Any major changes in a firm can distort a time-series analysis.
Differences in business strategy, capital structure or
business segments can make it hard to do a cross-sectional analysis.
And then any differences in accounting methods, either across time or
across companies can make the comparisons difficult as well.
>> The preceding passage was a fair bit too abstract to me.
Can you elucidate this further with some relevant concrete examples?
>> Yes, yes I can.
So for major changes in the firm, imagine a software company goes out and
acquires a hardware company so
that they can integrate their software into the hardware.
The problem is that this would make it a fundamentally different company.
It would change the amount of manufacturing capacity and
the amount of inventory.
And the ratios wouldn't make sense anymore.
All they would tell you is that the company's a different firm if you
look over time.
I'll talk about differences in business strategy and example later in the video.
As far as differences in accounting method, one of the ones we talked about
earlier in the course was some companies have brand names on their balance sheet.
If they acquired them externally in acquisitions whereas
other companies don't have them.
That's a difference that would affect almost all the ratios that we look at, and
you'd have to probably pull the brand name asset out of the one company
in order to make meaningful cross sectional comparisons between the two.
The final thing to keep in mind is that ratios can
be manipulated by managerial action.
So the companies managers think that investors and analysts are all
focused on the same one ratio like let's say, an interest coverage ratio.
Then those managers have incentives to manipulate their accounting numbers to
make that ratio look good.
So always keep in mind that manipulation is a possibility and
more importantly don't just focus on one ratio.
But look at the whole body of ratios because it's hard,
in fact impossible to manipulate every single ratio to make it look good.
Let's talk now about specific ratios starting with return on equity.
So is a net income of $10 million good or bad?
>> I could live with 10 million.
Sounds like a great net income to me.
>> Yeah, if you were running a lemonade stand where your only assets were a table,
a pitcher, some glasses, a bunch of lemonade and maybe a cool Letterman's
jacket, then 10 million in net income would be pretty sweet.
But if you were running a company with billions and
billions of dollars of assets, $10 million would be pretty meager for net income.
So to assess whether $10 million of net income is good or bad
we need to know how much investment was required to get that level of net income.
So to assess to whether a net income is good or
bad it depends on the level of investment required to get that net income and
that's what return on equity is going to tell us.
Return on equity is defined as net income divided by average shareholders' equity.
The numerator represents how much return the company generated for
its shareholders during the year based on accrual accounting.
So that's the net income number that we've generated through the course.
The denominator represents the shareholders' investment in the company.
Now one of the problems we run into is net income happens over a period of time
whereas stockholder's equity is at a point of time.
So we have to take an average of the beginning and
ending balances of shareholder equity to approximate it's level during the period
we were generating net income.
This ROE measure measures a return on investment and
if something should increase with the risk of the company.
For example, I could take a dollar and put it in a savings account with a bank, and
I'd get roughly one cent of interest.
So my return on investment would be one cent.
If I'm gonna take that same dollar and invest it in a company,
I'm taking much more risk and so I should get much higher return.
I should get an ROE much higher than 1%.
So ROE is a great starting point because you compare across all of your
investments.
And hopefully the ROE is high enough to compensate you for
the risk you are taking investing in the company.
Now we're gonna divide ROE into two drivers.
To figure out whether a company is getting high or
low ROE due to operating performance or due to leverage.
So the first driver for ROE is operating performance, which answers the question of
how effectively do managers use the company's resources, in other words,
their assets, to generate profits.
The ratio that we look at here is return on assets, or ROA.
ROA is defined as net income divided by average assets.
So it tells you is for each dollar of assets the manager has to play with,
how much net income do they generate.
The second driver is financial leverage.
This answers the question, how much do the managers use debt
to increase available assets for a given level of shareholder investment?
Financial leverage is defined as the average total assets divided by
average stockholder's equity.
So for each dollar of stockholder's equity,
how much assets does the company have?
Now the only way that this can be greater than one is if the company also
borrows money, takes on liabilities.
So this is a measure of leverage in terms of it measures how much debt the company
is taking on to buy more assets than it has in terms of dollars of equity.
One note is that this leverage ratio is very different from the other leverage
ratios that we're gonna be talking about this week.
It's gonna work for what we're doing with ROE, but we're gonna use
other ratios when we want to measure other kinds of risks due to leverage.
>> Pardon me.
My sister just texted me back that you need to de-lever net income in ROA.
Moreover, she said debt-to-equity is a better leverage ratio
than your Financial Leverage.
>> You know, I agree with your sister on this one.
We do need to de-lever net income for ROA.
But we'll get to that later. For now I wanna keep it simple so
that you can see the two drivers of ROE.
And yes, there are better measures of leverage for assessing things like
bankruptcy risk and long term liquidity, and we'll also get to those later.
But the financial leverage measure that we're looking at
here is the right measure if we want to see how much of ROE,
a return of equity, is driven by the company going out and borrowing money.
A company going out and levering up.
Let me show you a picture to tie this together.
So we start with return on equity and that can be split up into components, operating
performance, which is return on assets, and the financial leverage component.
And so you see in the equation,
we have ROE equals net income over assets times assets over equity.
The assets cancel and we get ROE equals net income over equity.
Let me do a quick example.
So a company raises $100 from shareholders,
borrows $100 from a bank to buy $200 of assets.
Those assets are then used to generate $10 of net income.
So ROE in this case would be 10%,
$10 of net income divided by $100 from shareholders, ROA would be 5%,
$10 of net income divided by 200 of assets, and leverage would be 2.
$200 of assets divided by $100 of shareholders equity.
Multiplying it together, 5% ROA times a leverage of 2 gives you an ROE of 10%.
And this highlights how these two components drive ROE.
So let's say instead of buying $200 of assets with $100 of shareholders equity,
we bought $400 of assets, we borrowed $300 from the bank,
combine that with our $100 from shareholders to buy $400 of assets.
Now our leverage is 4.
If we can maintain the same ROA of 5%, our ROE would go up to 20%.
Or, let's say that we keep leverage at 2 but we find a way to
operate the business more efficiently to get the performance or the ROA up to 10%.
Then we'd have 10% ROA times a leverage of 2 would give us ROE of 20%.
So, either operating performance or leverage can get you to a high ROE.
>> I am completely and utterly flamboozled by your example.
Did you not inform us mere seconds ago that one must utilize average balances?
>> Really sorry to flamboozle you, but I was trying to keep it simple.
I was trying to do an example which clearly shows how these two factors,
ROA and financial leverage, combine to drive ROE.
And yes if I was doing these ratios in practice, I would take the average of
the beginning and the ending balance for both assets and for equity.
Next, we're gonna look more carefully at the return on assets component,
which also can be separated into two drivers.
The first driver is profitability.
How much profit does the company earn on each dollar of sales?
The ratio we're gonna use here is Return on Sales or ROS,
which is defined as Net Income divided by Sales.
So what it's telling you is for
each dollar of sales how much net income do you generate.
The other driver of return on assets is efficiency.
This answers the question,
how much sales does the company generate based on its available resources?
The ratio here is called asset turnover,
which is defined as sales divided by average total assets.
So, for each dollar of assets, how much in sales does the company generate?
Now, I'm gonna go through an example of how to do this in a little bit, but first
I have to deal with that complication that came up in the question earlier.
So, ideally return on assets would measure operating performance independent of
the company's financing decisions.
We want a measure of ROA that's not at all affected by financial leverage.
The problem is the numerator of ROA, net income, includes interest expense.
If you have more leverage it means you have more debt, more debt means higher
interest expense, higher interest expense means lower net income, and so
now your leverage is affecting your net income.
So to remove the financing effects from ROA, we have to de-lever net income.
So we're gonna define ROA as de-levered net income divided by average assets.
Where de-levered net income is net income plus one minus t times
interest expense, where t is the tax rate.
So what we're doing is taking after tax interest expense and
adding it back to net income.
Then when we use this de-levered net income as the numerator in ROA,
we get a measure of operating performance that's not contaminated
by the company's financing decisions.
>> Ideally, you could explain this one minus t stuff.
And it would not hurt to explain what de-lever means.
And why we add interest expense to de-lever.
>> Yeah, I know the formulas are a little bit abstract, so
let's go through an example and see how this works.
Here's a quick example to show why we need to de-lever net income
to remove the affects of financing decisions.
Let's say we have two companies, one that has no debt and one that has some debt.
Both companies have the same pretax, pre-interest income, so
their performance seems identical in an operating sense.
Then the no debt company obviously has no interest expense, so
their pretax income is 300, we take off taxes at 35%, and their net income is 195.
For the company that has some debt, they have interest expense.
So if they had 50 of interest expense, their pre-tax income would only be 250.
We take off taxes and their net income is only 162.5.
So if we use net income in the numerator for ROA, then ROA is gonna be
affected by the fact that the some debt firm has some borrowing.
Now if you look in the last row, we're gonna calculate de-levered net income We
don't have to do anything for the no debt firm cuz it has no interest expense.
For the some debt firm we take net income plus interest expense times 1
minus the tax rate and we end up with de-levered net income of 195
which is identical to the de-levered net income of the no debt firm.
So using de-levered net income in ROA gives us a measure of ROA that only
measures operating performance.
Now when we use ROE, we do want the interest expense in there because
ROE does wanna reflect the effective financing.
So we take the financing out of ROA but we leave the financing in for ROE.
Now I'm gonna try to tie all of this together with something called
the DuPont Ratio Analysis Framework.
>> Hey, is this the same DuPont that makes the model airplane glue?
>> Hey, it is pronounced du Pont.
It is named after Eleuthere Irenee du Pont.
>> Thanks for the correct pronunciation there, Renee.
But yes, this formula was developed by people that worked for
the DuPont Chemical Company back in the 19th century.
In 1914, DuPont bought a big stake in this startup company called
General Motors which eventually became the largest car company in the world.
And when the DuPont management team started working for General Motors,
they would use this formula a lot so much so that the GM people would say hey,
give me the DuPont formula analysis.
And that's where the formula got the name, and we've continued to use it since then.
So anyway, we've seen that return on equity has two drivers,
return on assets and financial leverage.
And return on assets has two driver, return on sales and asset turnover.
So the DuPont formula is that ROE equals net income over sales which is
profitability times sales over assets which is efficiency
times assets over equity which is leverage.
And what this allows us to do is identify whether a company is advantaged or
disadvantaged in their ROE is driven by their profitability,
by their efficiency or by their leverage.
>> May you elucidate this further with a relevant concrete example of how one might
utilize this du Pont formula?
>> Yes, now I'm gonna do an extended example of how to use the DuPont formula,
which will also allow me to show you the importance of choosing firms that
are using the same business strategy when you wanna do a ratio analysis comparison.
So I'm gonna talk about the retail industry.
There's a couple big segments within the retail industry.
One segment would be discount retailers.
So those are the stores that have mart in their name and
try to compete on low prices.
And another segment are the high-end retailers,
the ones that are located in the really expensive shopping districts.
Let's start by talking about the discount end of the market,
you know the marks stores.
So their strategy is very low profitability.
They have a small markup over cost and
their strategy is to get you into the store with their low prices.
So how do they get high ROE?
By very high asset turnover.
In other words they generate a huge amount of sales for their investment in assets.
How do they do that?
Well their assets are things like fairly simple stores that are not constructed
from fancy materials.
They're located in rural districts where the land is pretty inexpensive.
And then when you go in to the store, you don't see a lot of fancy schmancy
displays, the merchandise is sort of crammed in there and they're really set up
to try to maximize the volume of sales for their level of investment and assets.
So if you're looking at discount type store, you'd wanna compare it to another
company doing a discount strategy to see if the company is able to get a little bit
extra profitability even though it's low in absolute terms.
Or if they're able to get much higher asset turnover,
either one of those would give them an ROE advantage over their competitor.
On the opposite end of the spectrum you have the high-end retailers.
Now what I've heard that these stores are like, and I don't think I've actually ever
been in one because I order all my clothes over the internet but
what I've heard is that they're really nice stores.
Their constructed out of expensive materials, marbles,
woods, they're located in very expensive real estate areas.
The merchandise is not crammed in there, very nice elegant displays.
Their asset turnover, the amount of sales they generate for
their investment in assets is fairly low.
But when they make a sale it's hugely profitable.
They have very high markup over cost, so if you were looking at a high-end
retailer, you'd want to compare it to another high-end retailer
to see if they're able to squeeze out even higher markups or if they're able to
squeeze out a little bit asset turnover even though it's lower in absolute terms.
So the DuPont formula allows you to look at these different drivers of ROE.
And as long as you're comparing companies that are doing the same strategy,
find out where a company's competitive advantages or
disadvantages lie in trying to execute their business model.
Now that we have the basic framework down,
what we're gonna do in the next couple of videos is look at a case study of
a company that had some real troubles in their business.
But then they changed their strategy had a nice turn around and
now they're performing very well.
So we'll use the DuPont analysis to figure out exactly what parts
of their strategy really helped to kick start their turn around.
I'll see you next time.
>> See you next video.
Explorer notre catalogue
Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2018 Coursera Inc. Tous droits réservés.
