Chapter 8 - Minicase

Juan Ibarra
2/13/07
Professor Anu Vuorikoski
Bus 173A - Intermediate Financial Management
Chapter 8: mini case
a. Why are ratios useful? What are the five major categories of ratios?
Ratios are useful to evaluate a firms financial statements and one can also
compare their performance with other firms, or the industry average.
The five major categories for ratios are as follow:
i. Liquidity Ratios: measures the liquidity of the firms current
assets to their current liabilities (or obligations to creditors).
ii. Asset Management Ratios: measures how effectively the firm is
handling and managing their assets.
iii. Debt Management Ratios: measure their debt financing, or
financial leverage; how much is the firm depended on debt.
iv. Profitability Ratios: these ratios demonstrate the effects of
liquidity, asset management, and debt combined together on
operating results.
v. Market Value Ratios: these are ratios that help managers know
what investors think of the companys past performance and future
prospects.
b. Calculate the 2007 current and quick ratios based on the projected balance sheet
and income statement data. What can you say about the companys liquidity
position in 2005, 2006, and as projected for 2007? We often think of ratios as
being useful (1) to managers to help run the business, (2) to bankers for credit
analysis, and (3) to stockholders for stock valuation. Would these different types
of analysts have an equal interest in the liquidity ratios?
Current Ratio = Current Assets / Current Liabilities
Current Ratio = $2,680,112 / $1,039,800
Current Ratio = 2.58 times
Quick Asset Ratio = (Current Assets Inventory) / Current Liabilities
Quick Asset Ratio = ($2,680,112 - $1,716,480) / $1,039,800
Quick Asset Ratio = 0.93 times
The firm is has improved their in reducing their current liabilities and
increasing their current asset; however, they are still below industrial avg.
Current Ratio
Quick Acid Ratio
2005
2.3x
0.8x
2006
1.5x
0.5x
2007E
2.58x
0.93x
Industrial Avg.
2.7x
1.0x
Table 1 from minicase (pg 281)
Not all type of analyst would have an

equal interest in the liquidity ratios.
For instance, creditors might be
interested more than managers. If
they are going to lend the firm some
funds, they want to be sure they can
be recovered their capital fast incase
the firms goes bankrupt.
c. Calculate the 2007 inventory turnover, days sales outstanding (DSO), fixed assets
turnover, and total assets turnover. How does Computrons utilization of assets
stack up against that of other firms in its industry?
Inventory Turnover = Sales / Inventory
Inventory Turnover = $7,035,600 / $1,716,480
Inventory Turnover = 4.10 times
Industry turn over is 6.1 times while the firms

inventory turnover is 4.10. The firms inventory is
being stored longer than the industry average; hence
it is taking up space, which is costing them money.
They need to improve their inventory management
system.
Days Sales Outstanding = Receivables / (Annual Sales/365)
Days Sales Outstanding = $878,000 / ($7,035,600/365)
Days Sales Outstanding = 45.55
Industry DSO is 32 days while the firms DSO is

45.55 days to collect money from sales (or collect
money from their accounts receivable). If they have
a 30 days term, they are not doing to a good job and
should change or enforce new policies.
Fixed Assets Turnover = Sales / Fixed Assets
Fixed Assets Turnover = $7,035,600 / $836,840

Fixed Assets Turnover = 8.41 times
The industry fixed asset turnover is 7 times while the firms is expected to
be a little bit over 8.41. Meaning, they are being a bit more efficient than
the industry average in using their assets to generate sales.
Total Assets Turnover = Sales / Total Assets Turnover
Total Assets Turnover = $7,035,600 / $3,516,952
Total Assets Turnover = 2.00 times
The industry total asset turnover is 2.5 times while the firms is expected
to be a 2.0 times. The firm is below the industry average due the increase
in inventories and accounts receivables.
d. Calculate the 2007 debt, times-interest-earned, and EBITDA coverage ratios. How
does Computron compare with the industry with respect to financial leverage?
What can you conclude from these ratios?
Debt Ratio = total liabilities / total assets
Debt Ratio = $ 1,539,800/ $3,516,952
Debt Ratio = 0.44 = 44%
The industry average is 50%, which means creditors have supplied 50%
(half) of their financing. The firms debt ratio is lower than the industry
average, 44%, which is a good sign. They should try to minimize it a bit
more or not let it increase.
Times-Interest-Earned (TIE) = EBIT / Interest Charges
TIE = $502,640/ $80,000
TIE = 6.28 times
The industry and the firms TIE are almost the same (firms is 6.28 and the
industry average is 6.2). They are both covering interest charges on their
debt in the same length of time.
EBITDA Coverage ratio = (EBIT + Depr. + Amort. + Lease payments) / (Interest
+ Lease payments)
EBITDA Coverage Ratio = ($502,640 + $120,000)/ ($80,000 +
$40,000+0)
EBITDA Coverage Ratio = 5.5 times
e. Calculate the 2007 profit margin, basic earning power (BEP), return on assets
(ROA), and return on equity (ROE). What can you say about these ratios?
Profit Margin = Net Income / Sales
PM = $253,548/ $7,035,600
PM = 3.6%
Profit Margin
2005
2.6%
2006 2007E
-1.6% 3.6%
Industrial Avg.
3.6%
The firm did horrible in 2006, but its now meeting the industrial average.
Basic Earning Power = EBIT / Total Assets
BEP = $502,640 / $3,516,952
BEP = 0.142 = 14%
Basic Earning
Power
2005 2006
14.2% 0.6%
2007E
14%
Industrial Avg.
17.8%
Basic Earning Power eliminates the effect of taxes and financial leverage.
The projected is below average compared to the industrial average.
Return on Total Assets = ROA = Net Income/ Total Assets
ROA = $253,548 / $3,516,952
ROA = 7.2%
ROA is lowered by debt--interest expense lowers net income, which also
lowers ROA.
ROA
2005
6.0%
2006 2007E
-3.3% 7.2%
Industrial Avg.
9%
Return on Common Equity = ROE = Net Income/ Common Equity

ROE = $253,548 / $1,977,152
ROE = 12.8%
The use of debt lowers equity, and if equity is lowered more than net
income, ROE would increase.
ROE
2005 2006
13.3% -17.1%
2007E
12.8%
Industrial Avg.
17.9%
f. Calculate the 2007 price/earnings ratio, price/cash flow ratio, and market/book
ratio. Do these ratios indicate that investors are expected to have a high or low
opinion of the company?
Price/Earning Ratio = Price per share / Earning per Share
Earnings per Share = Income / Number of outstanding shares

P/E ratio = $12.17 / ($253,548 / $250,000)
P/E ratio = 11.99x = 12x
P/E ratio
2005
9.7x
2006
-6.3x
2007E
12x
Industrial Avg.
16.2x
Price/Cash Flow Ratio = Price per Share / Cash Flow per Share
Cash Flow per Share = (Net Income + Depr.) / Shares Outstanding
Price/Cash Flow Ratio = $12.17/ (($253,548+$120,000)/250,000)
Price/Cash Flow Ratio = $12.17/ (($373,548)/250,000)
Price/Cash Flow Ratio = $12.17/ $1.494192
Price/Cash Flow Ratio = 8.15x
Price/Cash Flow Ratio
2005
8.0x
2006
27.5x
2007E
8.15x
Industrial Avg.
7.6x
Market/Book Ratio
1st Book Value per Share = Common Equity / Shares Outstanding
Book Value per Share = $1,977,152 / 250,000
Book Value per Share = $7.91
2nd Market/Book ratio = Market Price per Share / Book Value per Share
M/B ratio = $12.17 / $7.91
M/B ratio = 1.54 x
Market/Book ratio
2005
1.3x
2006
1.1x
2007E
1.54x
Industrial Avg.
2.9x
The price earning ratio is still below industrial average. The firm is considered
riskier. However, investors are willing to pay a more for the estimated 2007 year
than they did for the year of 2006. They do expect both revenue and earning to
grow.
g. Perform a common size analysis and percent change analysis. What do these
analyses tell you about Computron?
Common Size analysis for Income Statement
(86.7) than industry (84.5), but higher other expenses. Result is that net, net the
company has similar EBIT % (7.1) as industry.
To increase EBIT and bottom line to create shareholder wealth (by increasing
NOPAT), company needs to cut costs or grow costs slower than sales
Common Size analysis for Balance Sheet

The firm has higher proportion of inventory and current assets than Industry. The
firm now has more equity \than the industry average.
The firm has more short-term debt than industry, but less long-term debt than
industry.
Common Size analysis for Balance Sheet (cont.)
Percent Change Analysis for Income Statement

Sales grew 105% from 2004, and Net Income grew 188% from 2004.
h. Use the extended Du Pont equation to provide a summary and overview of

Computrons financial condition as projected for 2007. What are the firms
strengths and weaknesses?
Extended Du Pont Equation = ROE =
= (Net Income / Sales) x (Sales / Total Assets) x (Total Assets / Common Equity)
= ($253,548 / $7,035,600) x ($7,035,600 / $3,516,952) x ($3,516,952 /
$1,977,152)
= 0.036038 x 2.000482 x 1.778797
= 0.128239
OR
= Net Income / Comment Equity
= 0.128239
i. What are some potential problems and limitations of financial ratio analyses?
Average performance is not the best position a firm would like to be in. You want
to aim higher.
There are some firms that are seasonal and this can throw off some of the ratios
for those firms when comparing them with others.
Window dressing techniques can make statements and ratios look better.
Different accounting and operating practices can distort comparisons.
Sometimes it is difficult to tell if a ratio value is good or bad.
Often, different ratios give different signals, so it is difficult to tell, on balance,
whether a company is in a strong or weak financial condition.1
From the professors power point slide
j. What are some qualitative factors analysts should consider when evaluating a
company?
Are the companys revenues tied to a single customer?
To what extent are the companys revenues tied to a single product?
To what extent does the company rely on a single supplier?
What percentage of the companys business is generated overseas?
What is the competitive situation?
What does the future have in store?
What is the companys legal and regulatory environment? 2
From the professors power point slide

Chapter 8 - Minicase

Uploaded by

Copyright:

Available Formats

Chapter 8 - Minicase

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Chapter 8 - Minicase

Uploaded by

Copyright:

Available Formats

Juan Ibarra

Table 1 from minicase (pg 281)

Not all type of analyst would have an

Industry turn over is 6.1 times while the firms

Industry DSO is 32 days while the firms DSO is

Fixed Assets Turnover = $7,035,600 / $836,840

Table 2 from minicase (pg 281)

Table 3 from minicase (pg 281)

Table 4 from minicase (pg 281)

Return on Common Equity = ROE = Net Income/ Common Equity

Table 5 from minicase (pg 281)

Earnings per Share = Income / Number of outstanding shares

Table 6 from minicase (pg 281)

Table 7 from minicase (pg 281)

Table 8 from minicase (pg 281)

Common Size analysis for Balance Sheet

Common Size analysis for Balance Sheet (cont.)

Percent Change Analysis for Income Statement

h. Use the extended Du Pont equation to provide a summary and overview of

From the professors power point slide

From the professors power point slide

You might also like