A.5 Appendix: Common Size Analysis
Introduction
The major purpose for preparing
financial statements is so users can extract useful
information from them about a company.
The first step is to understand how financial
statements are constructed and what the various line items
mean. This was
covered earlier in the introduction to financial statements.
In this topic we explore a technique designed to let
users extract additional information from the financial
statements.
This technique is referred to as common size analysis.
Common size analysis re-expresses an entire financial
statement relative to a single item referred to as the “base
item.” Typical
base items are Total Assets and Revenue for general
purposes, but the depending upon the purpose many other base
items are relevant for specific purposes.
Common size analysis creates a simple ratio between
every item on the financial statement and the selected base
item. Ratio
analysis provides a refinement of common size analysis
designed to extract and summarize additional information
relative to key categories such as profitability, risk,
solvency and liquidity.
Vertical and
Horizontal Common Size Analysis
There are two types of common size
analysis, vertical and horizontal.
Vertical
analysis restricts common size analysis to one reporting
period and typically focuses upon the composition within a
report. For
example, vertical analysis provides immediate insight to
users regarding asset, financing and cost structures within
a firm.
Horizontal analysis
applies common size analysis to focus upon trends and
changes over time.
For example, how has a firm’s gross margin changed
over time?
Both vertical and horizontal common
size analysis can be further extended to comparing across a
set of competitors or other firms to tease out additional
information. As a
result, common size analysis is an important tool that is
immediately applicable to the financial reports.
Valuation Tutor lets you work
interactively and visually with the financial statements
provided to investors in a 10-K, 10-Q, and 20-F.
This is a powerful tool lets you take common size
analysis to new heights permitted by today’s technology.
This tool allows for the common size analysis of any
of the latest as well as past interactive statements so that
easy comparisons can be made over time and among immediate
competitors or other stocks being screened.
This ensures that you are extracting timely
information from these reports that can be compared to
responses in the stock market after the reports are publicly
disclosed such as in “earnings’ season.”
The opening screen appears as follows:
The top LHS of the screen is where you
enter the ticker and select the statement you want to apply
common size analysis to.
The bottom LHS of the screen is the statement you
have selected to apply common size analysis to, the center
part of the screen is the base variable that you select to
scale by (which can come from another statement) and the RHS
of the screen is the results of your graphical analysis.
First we consider the default
Consolidated Balance Sheet and scale it by Total Assets.
We then extend this analysis to the Income other
statements.
Common size Analysis
of the Balance Sheet
The common size analysis of a balance
sheet can immediately highlight some important issues such
as:
What is the composition of assets (real
versus financial assets)?
What is the financing composition (debt
versus equity)?
How does the asset composition change
over time?
Has the financing composition changed
over time?
What does a strong versus a weak
balance sheet look like?
Vertical analysis provides answers to
the first two questions and horizontal analysis provides
answers to the second pair of questions.
Combined, both forms of analysis provide some
relevant information for the last question.
Example:
Common Size Analysis using Total Assets for Apple
In the above screen a common size
analysis of the January, 2012 balance sheet for Apple is
provided scaled by Total Assets.
The LHS of the screen provides the results of the
analysis and the RHS of the screen presents these results
graphically.
A few immediate observations jump out.
First, the relative importance of Property, Plant and
Equipment to Apple is not large.
This reflects the fact that manufacturing hardware
such as the Apple iPhone is outsourced.
The relative importance of Financial Assets is
immediately clear.
The big spike is “Long term marketable securities.”
In general the asset composition is a much greater
emphasis upon financial as opposed to real assets for Apple.
Furthermore, this is an increasing
trend over time.
For example the relative percentage of total assets
for PPE is declining, because Apple’s financial assets are
growing. This
is especially the case for investment related financial
assets however Apple’s working capital assets, such as
inventory and accounts receivable, are also growing.
This reflects the current growth and the expectations
for immediate future growth.
The composition f liabilities for Apple
also reflect strength.
Apple has no debt and the composition is heavily
skewed toward current liabilities (long term liabilities are
approximately 10% of total liabilities).
Compared to Total Assets Apples total liabilities
are low, less than 40% implying that the stockholders’
equity is relatively large (65%).
The composition can be decomposed to
reveal greater detail in a more traditional pie chart
How does Apple compare to Intel, a
manufacturer that does not rely heavily on outsourcing?
Immediately the difference for real
assets is apparent.
Intel’s PPE has increased from 28% to 33% in contrast
to Apples decrease to 5.6% from 6.7%.
This reflects the fact that Intel manufacture in
their own plants.
Similarly, on the liability side investment in real assets implies the financing decision is more important to Intel than it is to Apple.
The relative % of Owners Equity has
declined for Intel to just over 60% from a very high 78%
which is largely due to the additional long term debt
financing taken on over the last year – presumably to take
advantage of the very low rates currently available to fund
its increased investment in real assets.
Example:
Common Size Analysis using Revenue for Apple
Common size analysis applied to Apple’s
2012 10Q reveals the strength in earnings for this company.
First, Gross margin, Operating and Net Income have
all increased.
Every cost category has declined with the exception of
provision for taxes which understandably increased.
Apple’s Gross Margins are large and
growing (45%, 35% respectively for 2011, 2010 December
quarters).
Example:
Common Size Analysis of the Cash Flow Statement for
Apple
Common size analysis of the cash flow
statement provides additional insights into the Operating,
Investing and Financing activities of the firm.
For example, scaling these activities by Net Income
reveals that Apple is achieving large amounts of growth
without increasing their investments:
However, the Cash Flow from Operations
as a % of Net Income is declining which raises the
interesting question why:
Why has Apple’s Cash Flow from
Operations relative to Net Income declined
significantly?
Graphically you can observe this from
the RHS plot relative to the LHS plot (which is Net
Income/Net Income = 1).
To clarify this consider scaling both
cash flow statements by the net income for the 2010 quarter.
This is achieved by selecting both 2010 statements
circled below:
Now all is relative to the 2010 Net Income. This common size analysis immediately reflects the strong growth Apple is currently experiencing. That is, the increase in December quarter’s net income was 218%! Common size analysis immediately reflects how each category has grown relative to Net Income. This reveals that along with this rapid growth Apple was positioning itself for even stronger growth especially with respect to the working capital items such as Inventory, and accounts payable. Also reflective of the quarter’s realized growth was the sharp jump in accounts receivable. Combined these working capital items implied that the rate of increase in net income greater than the rate of increase in cash flow from operations. The pie chart depicting composition makes this clearer:
In the above scaled by 2010 Net Income
the growth in Net Income for the same quarter 2011 was 218%
but the growth in cash generated from operations is
2.92/1.63 = 179%.
This is largely driven by Accounts Receivable jumping
from -2.80% to -11.28% (i.e., a use of cash), Inventory
jumping from 0.90% to -1.46% (a use of cash) and Accounts
Payable increasing from 12.7% to 13.7% (a use of cash).
These jumps when growth is strong indicates the
expectation of even stronger growth to come.
Exercise:
Apply the Valuation Tutor to the 1st
quarter of 2012 to further check these trends.