Unit 5. Financial Statement Analysis II
Unit 5. Financial Statement Analysis II
Unit 5. Financial Statement Analysis II
The term "Analysis" refers to re-arrangement and classification of the data given in the
financial statements. In other words; it is simplification of data by methodical classification of the
data given in the financial statements. However the term "interpretation" refers to "explaining the
meaning and significance of the data so simplified." Both analysis and interpretations are closely
connected and inter related. They are complementary to each other. Therefore presentation of
information becomes more purposeful and meaningful-both analysis and interpretations are to be
considered. Metcalf and Tigard (2003) have defined financial statement analysis and interpretations
as a process of evaluating the relationship between component parts of a financial statement to
obtain a better understanding of a firm's position and performance. The facts and figures in the
financial statements can be transformed into meaningful and useful figures through a process called
"Analysis and Interpretations."
In other words, financial statement analysis and interpretation refer to the process of
establishing meaningful relationships between items of the two financial statements with the
objective of identifying both financial and operational strengths and weaknesses of an organisation.
Problem 5.1
The following ratios describe the performance of Ratio Ltd for 2015 and 2016:
1|Page
Ratio Value Value
2015 2016
Required:
a. Financial performance
b. Liquidity and solvency
c. Financial structure
d. Operating efficiency.
2. Based on the ratio values supplied, comment on the company's performance in 2016 in each of
the following categories/dimensions:
a. Financial performance
b. Liquidity and solvency
2|Page
c. Financial structure
d. Operating efficiency.
In addition, note the limitations of conclusions drawn from the provided information, and indicate
what other information would be helpful in assessing the company's performance.
3. Explain:
4. Consider the inventory turnover ratio and the days inventory on hand ratio:
5. During 2016, the chief financial officer (CFO) of Ratio Ltd employed an independent valuer to
assess the current value of the land and buildings owned by the company. The valuer had advised
the CFO that the value of the land and buildings had increased by $50 000 (10 per cent). Assume
that this increased value is reflected in the ratios provided in the first half of this chapter. Explain
how this accounting policy choice would have affected each of the ratios.
2 a. The company’s ROA and ROE appear to be high. Gross margin and ROA have increased in
2016. The fact that ROE is greater than ROA in both years indicates that leverage is being
employed to the advantage of shareholders, though this was done to a greater extent in 2015
than in 2016.
b. The company’s current ratio is well above 1 for both years and this suggests it is quite liquid,
though this depends on the industry Ratio Ltd is in and the industry norm. Both the current
3|Page
and quick ratios have dropped in 2016 however, indicating the company is currently less liquid
than it was in 2015.
c. The company’s debt-to-equity ratio shows that it is financed by debt. The drop in the interest
coverage ratio in 2016 suggests that the company is less comfortable in covering its interest
obligations in 2016 compared to in 2015.
d. The company is operating more efficiently than it did in 2015. The modest increase in
receivables turnover suggests that customers are paying the company a little faster. Also
inventory turnover has increased indicating that inventory is being turned over at a quicker
rate.
Limitations: lack of information about the company – e.g., what industry is it in? What are the
industry norms? What kind of inventory does it stock (e.g., perishables)?
3 a. ROA shows the return managers are earning on the assets under their control. In contrast,
ROE indicates how much return the company is generating on the historically accumulated
shareholders’ investment. It captures the combined effect of assets and leverage that the
company uses to create shareholder returns.
b. Because it enables managers to analyse where shareholder returns are being derived (e.g., is
it from the company’s sales and the use of its assets, or is it from leverage), and to identify the
areas for improvement.
4 a. These ratios show how efficiently the company’s inventory is being managed. More
specifically, inventory turnover shows how much sales volume is associated with a dollar of
inventory, while days inventory on hand calculates how many days, on average, inventory is
held.
c. A limitation of these ratios is that they don’t necessarily reflect how well a company is
performing. For a company whose operations are based on a premise of low turnover and
high profit margin, a low inventory turnover ratio may be sustainable. Therefore, these ratios
must be interpreted having regard to the nature of the business and norm for companies in
the same industry which compete in a similar way.
4|Page
5
Debt-to-equity Decrease
International Business Computers (IBC) has enjoyed modest success in penetrating the
personal computer market since it began operations a few years ago. A new computer line
introduced recently has been received well by the general public. However, the general manager,
who is well versed in electronics but not in accounting, is worried about the future of the company.
The company's operating loan is at its limit and more cash is needed to continue operations.
The bank wants more information before it extends the company's credit limit. The general manager
has asked you, as financial controller, to do a preliminary evaluation of the company's performance,
using appropriate financial statement analysis, and to recommend possible courses of action for the
company. The general manager particularly wants to know how the company can obtain additional
cash. Use the summary financial information shown below to do your evaluation and make your
recommendations.
5|Page
6|Page
Other related information included in total expenses:
Interest expense 89 61 –
In this case several issues are illustrated in the information provided. Just to provide some
analysis relative to the general manager’s concern about availability of cash, a start might be to
estimate what the company’s ability to generate cash has been. You could also start with other ratio
analyses illustrated later in this outline. The 2016 and 2015 statement of cash flows follow (the
7|Page
statement of cash flows for 2014 cannot be prepared without the 2013 balance sheet). Marketable
securities, but not bank loans, are included in our definition of cash equivalents as this allows us to
focus on cash given the issue of interest is extending the bank loan.
Statement of cash flows
2016 (‘000) 2015 (‘000)
Cash flows from operating activities
Receipts from operations 3 076,000 2 637,000
Payments to suppliers and (3 157,000) (2 563,000)
employees
Payments for income tax (99,000) ( 100,000)
Net cash outflows from (180,000) (26,000)
operations
8|Page
1. Workings/Notes for the statement of cash flows
1/1/2015 Balance 257,000 Cash *2 637,000 1/1/2015 Balance 361,000 Cost of goods 2 150,000
sold
Sales 2 800,000 31/12/2015 Balance 420,000 Purchases 2 292,000 31/12/20 Balance 503,000
* 15
3 057,000 3 057,000 2 653,000 2 653,000
1/1/2016 Balance 420,000 Cash *3 076,000 1/1/2016 Balance 503,000 Cost of goods 2 500,000
sold
Sales 3 200,000 31/12/2016 Balance 544,000 Purchases 2 830,000 31/12/20 Balance 833,000
* 16
3 620,000 3 620,000 3 333,000 3 333,000
9|Page
Payables (Accounts payable & other liabilities)
$’000 $’000
Cash * 2 563,000 1/1/2015 Balance – Accounts payable 144,000
Depreciation expense 84,000 – Other liabilities 75,000
31/12/2015 Balance – Accounts payable 215,000 Expenses (533 – 102) 431,000
– Other liabilities 80,000 Purchases 2 292,000
2 942,000 2 942,000
Cash * 3 157,000 1/1/2016 Balance – Accounts payable 215,000
Depreciation expense 75,000 – Other liabilities 80,000
31/12/2016 Balance – Accounts payable 300,000 Expenses (584 – 95) 489,000
– Other liabilities 82,000 Purchases 2 830,000
3 614,000 3 614,000
1/1/2017 Balance – Accounts payable 300,000
– Other liabilities 82,000
10 | P a g e
Income tax payable
$ $
Cash * 100,000 1/1/15 Balance 50,000
31/12/15 Balance 52,000 P&L summary 102,000
152,000 152,000
Cash * 99,000 1/1/16 Balance 52,000
31/12/16 Balance 48,000 P&L summary 95,000
147,000 147,000
1/1/17 Balance 48,000
* = Balancing figures
11 | P a g e
3 The increased receivables and inventories, payment of dividends, and $500 000 of noncurrent assets
in 2015, have been financed partly out of cash generated from profit but largely from short-term
borrowing. The increase in accounts payable is moderate, but the company’s reliance on its bank
loan is enormous: $825 000 over the two years 2015 and 2016.
Clearly the company is not in a strong current position. The general manager knows this, but may
not realise the risk to the company of its lack of liquidity. The quick (acid test) ratio shows that the
company’s ability to meet current debts is strained and declining, but even that ratio may understate
the problem because the quick assets include receivables and the company’s collections are not very
quick!
Some suggestions for the general manager from the above about getting cash:
i. Reduce production or purchasing until inventory is substantially reduced.
ii. Increase collection efforts or change credit terms to get receivables down.
iii. Increase share capital or obtain long-term financing to reduce the reliance on short-term
borrowing (though these would reduce returns to present owners and might not be
popular with the shareholders).
iv. Raise selling prices a little to protect returns from the effects of any further borrowing
(may not work if price competition is strong, of course).
12 | P a g e
Case Studies
BigBrewery is a large Australian beer brewing company. It sells to wholesalers and commercial
outlets which then deal directly with BigBrewery's target customers. BigBrewery's iconic beers are
also exported to New Zealand, United Kingdom and the United States. BigBrewery manufactures in
various offshore locations and as a result, a significant proportion of BigBrewery's costs of production
are incurred in US Dollars.
13 | P a g e
14 | P a g e
15 | P a g e
16 | P a g e
17 | P a g e
Required:
a. Calculate ratios for Big Brewery Limited for 2015 and 2016 using the available information
as a guide. Be sure to include appropriate units.
b. Comment on the financial performance of Big Brewery in 2016 (relative to 2015) with
reference to the above ratio calculations. You may wish to further research the
performance of the brewing industry to enhance your answer.
1. Computation of Ratios
18 | P a g e
3. Alternative Return on 10985/216661 5.07% 9150/198522 4.61%
Assets
15. Days in Debtors (as 365/1.44 253 days 365/3.32 110 days
above)
19 | P a g e
17. Quick Ratio (3804+13758)/53789 0.32 times (73+22107)/6203 0.36 times
5
19. Debt to Equity Ratio 138881/77780 1.79 times 148203/50319 2.95 times
20. Debt to Assets Ratio 138881/216661 0.64 times 148203/198522 0.75 times
2. Comments:
i. Profitability ratios
In general, profitability ratios have increased over the year. However ROA is very low
(2.97%)
Profit margin and alternative profit margin both increase. This is due to better margins
being captured even though sales have decreased – costs have been well managed.
Cash flow to total asset ratio has also decreased dramatically, this may explains the
significant decline in the dividend pay-out ratio. Although profitability improves but its
ability to generate cash has deteriorated affecting the amount available for
distribution to shareholders.
A decrease in price-earnings ratio reflects market expectation of poorer performance
in the future (may reflect a downturn in general market sentiment rather than firm-
specific factors).
ii. Activity ratios
Total asset turnover has declined over the year indicating less efficient use of assets in
generating revenue.
Inventory turnover experiences a substantial decline to 0.46 times per year, i.e. on
average beer is held for 793 days – this presents a clear potential obsolescence issue
as I’m not sure beer would taste too good after being held for 2 years. There is a
significant build-up of inventory (nearly 3 years’ worth of sales at current rates) which
may increase storage and holding cost.
Debtors turnover has declined from 3.32 times to 1.44 times suggesting that urgent
action is required to collect debtors and assist with cash flow.
20 | P a g e
iii. Liquidity ratios
Current ratio has increased, while quick ratio has declined. This indicates that the
increase in current ratio is due to building up of inventory. This is consistent with the
analysis made above and that while the current ratio has increased, this is not
necessarily good news.
Quick ratio below 1 which indicates company may have trouble paying its bills as they
fall due unless they can continue to convert inventory to cash.
iv. Financing ratios
All of the financing ratios have decreased over the year.
The decrease in the use of debt may indicate less reliance on debt financing, hence,
reduces the riskiness of the firm. Also, a slight increase in interest coverage ratio
reflects the firm’s ability to meet finance cost. Critical to be concerned about short run
liquidity (as long run might not ever happen if firm fails in short term).
Case 5E
21 | P a g e
22 | P a g e
Note: Industry historical ratios appear at the top of the following page.
23 | P a g e
Required
a. Calculate the firm’s 2003 financial ratios, and then fill in the preceding table.
b. Analyze the firm’s current financial position using both a cross-sectional and a time-series
viewpoints. Break your analysis into evaluations of the firm’s liquidity, activity, debt, profitability,
and market.
c. Summarize the firm’s overall financial position on the basis of your findings in part b.
Solution to Case 5E
Martin Manufacturing Company is an integrative case study addressing financial analysis techniques.
The company is a capital-intensive firm that has poor management of accounts receivable and
inventory. The industry average inventory turnover can fluctuate from 10 to 100 depending on the
market.
a. Ratio calculations
24 | P a g e
Current ratio $1,531,181 $616,000
= 2.5%
= 2.7%
Historical Ratios
Martin Manufacturing Company
25 | P a g e
Inventory turnover (times) 5.2 5.0 5.3 10.2
Average collection period 50.7 55.8 58.0 46.0
(days)
Total asset turnover (times) 1.5 1.5 1.6 2.0
Debt ratio 45.8% 54.3% 57% 24.5%
Times interest earned 2.2 1.9 1.6 2.5
Gross profit margin 27.5% 28.0% 27.0% 26.0%
Net profit margin 1.1% 1.0% 0.71% 1.2%
Return on total assets 1.7% 1.5% 1.2% 2.4%
Return on equity 3.1% 3.3% 2.7% 3.2%
Price/earnings ratio 33.5 38.7 34.48 43.4
Market/book 1.0 1.1 0.89 1.2
Liquidity: The firm has sufficient current assets to cover current liabilities. The trend is upward
and is much higher than the industry average. This is an unfavourable position, since it
indicates too much inventory.
Activity: The inventory turnover is stable but much lower than the industry average. This
indicates the firm is holding too much inventory. The average collection period is increasing
and much higher than the industry average. These are both indicators of a problem in
collecting payment.
The total asset turnover ratio is stable but significantly lower than the industry average. This
indicates that the sales volume is not sufficient for the amount of committed assets.
Debt: The debt ratio has increased and is substantially higher than the industry average. This
places the company at high risk. Typically industries with heavy capital investment and higher
operating risk try to minimize financial risk. Martin Manufacturing has positioned itself with
both heavy operating and financial risk. The times-interest-earned ratio also indicates a
potential debt service problem. The ratio is decreasing and is far below the industry average.
26 | P a g e
Profitability: The gross profit margin is stable and quite favourable when compared to the
industry average. The net profit margin, however, is deteriorating and far below the industry
average. When the gross profit margin is within expectations but the net profit margin is too
low, high interest payments may be to blame. The high financial leverage has caused the low
profitability.
Market: The market price of the firm’s common stock shows weakness relative to both
earnings and book value. This result indicates a belief by the market that Martin’s ability to
earn future profits faces increasing uncertainty as perceived by the market.
c. Martin Manufacturing clearly has a problem with its inventory level, and sales are not at an
appropriate level for its capital investment. As a consequence, the firm has acquired a substantial
amount of debt which, due to the high interest payments associated with the large debt burden,
is depressing profitability. These problems are being picked up by investors as shown in their
weak market ratios.
No single ratio is adequate for assessing all aspects of the firm's financial condition. Two
popular approaches to a complete ratio analysis are: the DuPont system of analysis and the
summary analysis of large number of ratios
The DuPont system of analysis is used to dissect a firm’s financial statements and assess its
financial condition. The analysis merges the income statement and balance sheet into two summary
measures of profitability, return on total assets (ROA) and return on common equity (ROE). Figure
5.2 depicts the basic DuPont system with Bartlett Company’s 2012 monetary and ratio values. The
upper portion of the chart summarizes the income statement activities; the lower portion
summarizes the balance sheet activities.
The DuPont Analysis breaks down ROE (Return on Equity) into a function of 3 or 5 ratios that
help to see the contribution of each ratio component on ROE. Suppose you are going through the
financial ratios of a company and stop at ROE and wondering what are the factors that are
contributing or impacting the ROE. DuPont analysis comes in handy as a tool for dissecting the Return
on Equity (ROE) and therefore suggests how the company is achieving its ROE. It brings spotlight on
the following questions:
These are the three questions that the DuPont analysis can help you answer.
The advantage of the DuPont system is that it allows the firm to break its return on equity into
a profit-on-sales component (net profit margin), an efficiency-of-asset use component (total asset
turnover), and a use-of-financial-leverage component (financial leverage multiplier). The total return
to owners therefore can be analysed in these important dimensions.
The use of the DuPont system of analysis as a diagnostic tool is best explained using Figure
5.2. Beginning with the rightmost value—the ROE—the financial analyst moves to the left, dissecting
and analyzing the inputs to the formula to isolate the probable cause (s) of the resulting above-
average (or below-average) value.
For the sake of demonstration, let’s ignore all industry average data in Table 3.8 and assume
that Bartlett’s ROE of 12.6% is actually below the industry average. Moving to the left in Figure 5.2,
we would examine the inputs to the ROE—the ROA and the FLM—relative to the industry averages.
Let’s assume that the FLM is in line with the industry average, but the ROA is below the industry
average. Moving farther to the left, we examine the two inputs to the ROA—the net profit margin
and total asset turnover. Assume that the net profit margin is in line with the industry average, but
the total asset turnover is below the industry average.
Moving still farther to the left, we find that whereas the firm’s sales are consistent with the
industry value, Bartlett’s total assets have grown significantly during the past year. Looking further to
the left, we would review the firm’s activity ratios for current assets. Let’s say that whereas the firm’s
inventory turnover is in line with the industry average, its average collection period is well above the
industry average. At this point we readily trace the possible problem back to its cause: Bartlett’s low
ROE is primarily the consequence of slow collections of accounts receivable, which resulted in high
levels of receivables and therefore high levels of total assets. The high total assets slowed Bartlett’s
total asset turnover, driving down its ROA, which then drove down its ROE. By using the DuPont
system of analysis to dissect Bartlett’s overall returns as measured by its ROE, we found that slow
collections of receivables caused the below-industry-average ROE. Clearly, the firm needs to better
manage its credit operations.
DuPont Formula
The DuPont system first brings together the net profit margin, which measures the firm’s
profitability on sales, with its total asset turnover, which indicates how efficiently the firm has used
29 | P a g e
its assets to generate sales. In the DuPont formula, the product of these two ratios results in the
return on total assets (ROA):
ROA = Net profit margin x Total asset turnover ………………………………………………………………. 5.1
Substituting the appropriate formulas into the equation and simplifying results in the formula given
earlier,
………………. 5.2
When the 2012 values of the net profit margin and total asset turnover for Bartlett Company,
calculated earlier, are substituted into the DuPont formula, the result is
This value is the same as that calculated directly in an earlier section (page 81). The DuPont
formula enables the firm to break down its return into profit-on sales and efficiency-of-asset-use
components. Typically, a firm with a low net profit margin has a high total asset turnover, which
results in a reasonably good return on total assets. Often, the opposite situation exists.
…………………….. 5.3
Substituting the appropriate formulas into the equation and simplifying results in the formula given
earlier,
…….. 5.4
Use of the financial leverage multiplier (FLM) to convert the ROA into the ROE reflects the
impact of financial leverage on owners’ return. Substituting the values for Bartlett Company’s ROA of
30 | P a g e
6.1 percent, calculated earlier, and Bartlett’s FLM of 2.06 ($3,597,000 total assets ÷ $1,754,000
common stock equity) into the modified DuPont formula yields
The 12.6 percent ROE calculated by using the modified DuPont formula is the same as that calculated
directly.
Solved Example
Use the following ratio information provided in Table 1 for Johnson International Ltd and the industry
averages for Johnson’s line of business.
Requirements:
a. Construct the DuPont system of analysis for both Johnson and the industry.
b. Evaluate Johnson (and the industry) over the 3-year period.
c. Indicate in which areas Johnson requires further analysis. Why?
Solution
a.
31 | P a g e
Margin Turnover = ROA (%) FL Multiple = ROE (%)
(%)
2012
2011
2010
b. Profitability: Industry net profit margins are decreasing; Johnson’s net profit margins have
fallen less.
Leverage: Only Johnson shows an increase in leverage from 2011 to 2012, while the industry
has had less stability. Between 2010 and 2011, leverage for the industry increased, while it
decreased between 2011 and 2012.
As a result of these changes, the ROE has fallen for both Johnson and the industry, but
Johnson has experienced a much smaller decline in its ROE.
d. Areas that require further analysis are profitability and debt. Since the total asset turnover is
increasing and is superior to that of the industry, Johnson is generating an appropriate sales
level for the given level of assets. But why is the net profit margin falling for both industry
and Johnson? Has there been increased competition causing downward pressure on prices?
Is the cost of raw materials, labor, or other expenses rising? A common-size income
statement could be useful in determining the cause of the falling net profit margin.
Note: Some management teams attempt to magnify returns through the use of leverage to offset
declining profit margins. This strategy is effective only within a narrow range. A high leverage
strategy may actually result in a decline in stock price due to the increased risk.
32 | P a g e