Analysis of Financial Statements: Answers To End-Of-Chapter Questions
Analysis of Financial Statements: Answers To End-Of-Chapter Questions
Analysis of Financial Statements: Answers To End-Of-Chapter Questions
c. Financial leverage ratios measure the use of debt financing. The debt
ratio is the ratio of total debt to total assets, it measures the
percentage of funds provided by creditors. The times-interest-earned
ratio is determined by dividing earnings before interest and taxes by
the interest charges. This ratio measures the extent to which
operating income can decline before the firm is unable to meet its
annual interest costs. The EBITDA coverage ratio is similar to the
times-interest-earned ratio, but it recognizes that many firms lease
assets and also must make sinking fund payments. It is found by adding
EBITDA and lease payments then dividing this total by interest charges,
lease payments, and sinking fund payments over one minus the tax rate.
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 1
e. Market value ratios relate the firm’s stock price to its earnings and
book value per share. The price/earnings ratio is calculated by
dividing price per share by earnings per share--this shows how much
investors are willing to pay per dollar of reported profits. The
price/cash flow is calculated by dividing price per share by cash flow
per share. This shows how much investors are willing to pay per dollar
of cash flow. Market-to-book ratio is simply the market price per
share divided by the book value per share. Book value per share is
common equity divided by the number of shares outstanding.
3-2 The emphasis of the various types of analysts is by no means uniform nor
should it be. Management is interested in all types of ratios for two
reasons. First, the ratios point out weaknesses that should be
strengthened; second, management recognizes that the other parties are
interested in all the ratios and that financial appearances must be kept
up if the firm is to be regarded highly by creditors and equity investors.
Equity investors are interested primarily in profitability, but they
examine the other ratios to get information on the riskiness of equity
commitments. Long-term creditors are more interested in the debt ratio,
TIE, and fixed-charge coverage ratios, as well as the profitability
ratios. Short-term creditors emphasize liquidity and look most carefully
at the liquidity ratios.
Answers and Solutions: 3 - 2 Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc.
3-4 Given that sales have not changed, a decrease in the total assets turnover
means that the company’s assets have increased. Also, the fact that the
fixed assets turnover ratio remained constant implies that the company
increased its current assets. Since the company’s current ratio
increased, and yet, its quick ratio is unchanged means that the company
has increased its inventories.
3-7 ROE, using the Du Pont equation, is the return on assets multiplied by the
equity multiplier. The equity multiplier, defined as total assets divided
by owners’ equity, is a measure of debt utilization; the more debt a firm
uses, the lower its equity, and the higher the equity multiplier. Thus,
using more debt will increase the equity multiplier, resulting in a higher
ROE.
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 3
of-year equity to make returns on equity appear excessive or
inadequate. Similar problems can arise when a firm is being evaluated.
3-9 Firms within the same industry may employ different accounting techniques
which make it difficult to compare financial ratios. More fundamentally,
comparisons may be misleading if firms in the same industry differ in
their other investments. For example, comparing Pepsico and Coca-Cola may
be misleading because apart from their soft drink business, Pepsi also
owns other businesses such as Frito-Lay, Pizza Hut, Taco Bell, and KFC.
Answers and Solutions: 3 - 4 Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc.
Total Effect
Current Current on Net
Assets Ratio Income
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 5
SOLUTIONS TO END-OF-CHAPTER PROBLEMS
CA CA - I
3-1 CA = $3,000,000; = 1.5; = 1.0;
CL CL
CL = ?; I = ?
CA
= 1.5
CL
$3,000,000
= 1.5
CL
1.5 CL = $3,000,000
CL = $2,000,000.
CA - I
= 1.0
CL
$3,000,000 - I
= 1.0
$2,000,000
$3,000,000 - I = $2,000,000
I = $1,000,000.
AR
DSO =
S
360
AR
40 =
$20,000
AR = $800,000.
D 1
= 1 -
A A
E
D 1
= 1 -
A 2.4
D
= 0.5833 = 58.33%.
A
Answers and Solutions: 3 - 6 Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc.
3-4 ROA = 10%; PM = 2%; ROE = 15%; S/TA = ?; A/E = ?
ROA = NI/A; PM = NI/S; ROE = NI/E
ROA = PM × S/TA
NI/A = NI/S × S/TA
10% = 2% × S/TA
S/TA = 5.
We can also calculate the company’s debt ratio in a similar manner, given
the facts of the problem. We are given ROA(NI/A) and ROE(NI/E); if we use
the reciprocal of ROE we have the following equation:
E NI E D E
= _ and = 1- , so
A A NI A A
E 1
= 3% _
A 0.05
E
= 60% .
A
D
= 1 - 0.60 = 0.40 = 40% .
A
Alternatively,
ROE = ROA × EM
5% = 3% × EM
EM = 5%/3% = 5/3 = TA/E.
Take reciprocal:
therefore,
Thus, the firm’s profit margin = 2% and its debt ratio = 40%.
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 7
$1,312,500
3-6 Present current ratio = = 2.5.
$525,000
$1,312,500 + ∆ NP
Minimum current ratio = = 2.0.
$525,000 + ∆ NP
Inventories = $432,000.
Sales Sales
4. = 6.0× = 6.0×
Inventory $432,000
Sales = $2,592,000.
Answers and Solutions: 3 - 8 Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc.
3-9 ROE = Profit margin × TA turnover × Equity multiplier
= NI/Sales × Sales/TA × TA/Equity.
Now we need to determine the inputs for the equation from the data that
were given. On the left we set up an income statement, and we put numbers
in it on the right:
TA = $1,000,000
BEP = 0.2 = EBIT/Total assets, so EBIT = 0.2($1,000,000) = $200,000.
kd = 8%
T = 40%
D/A = 0.5 = 50%, so Equity = $500,000.
NI $120,000 $96,000
ROE = = = 12%; = 19.2%.
Equity $1,000,000 $500,000
*If D/A = 50%, then half of assets are financed by debt, so Debt =
$500,000. At an 8% interest rate, INT = $40,000.
3-11 Statement a is correct. Refer to the solution setup for Problem 3-10 and
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 9
think about it this way: (1) Adding assets will not affect common equity
if the assets are financed with debt. (2) Adding assets will cause
expected EBIT to increase by the amount EBIT = BEP(added assets). (3)
Interest expense will increase by the amount kd(added assets). (4) Pre-tax
income will rise by the amount (added assets)(BEP - kd). Assuming BEP >
kd, if pre-tax income increases so will net income. (5) If expected net
income increases but common equity is held constant, then the expected ROE
will also increase. Note that if kd > BEP, then adding assets financed by
debt would lower net income and thus the ROE. Therefore, Statement a is
true--if assets financed by debt are added, and if the expected BEP on
those assets exceeds the cost of debt, then the firm’s ROE will increase.
Statements b and c are false, because the BEP ratio uses EBIT, which is
calculated before the effects of taxes or interest charges are felt, and d
is false unless kd > BEP. Of course, Statement e is also false.
b. 1. Doubling the dollar amounts would not affect the answer; it would
still be 5.54%.
4. If the company had 10,000 shares outstanding, then its EPS would be
$15,000/10,000 = $1.50. The stock has a book value of
$200,000/10,000 = $20, so the shares retired would be $85,000/$20 =
4,250, leaving 10,000 - 4,250 = 5,750 shares. The new EPS would be
$15,000/5,750 = $2.6087, so the increase in EPS would be $2.6087 -
$1.50 = $1.1087, which is a 73.91% increase, the same as the
increase in ROE.
5. If the stock was selling for twice book value, or 2 x $20 = $40,
then only half as many shares could be retired ($85,000/$40 =
2,125), so the remaining shares would be 10,000 - 2,125 = 7,875, and
Answers and Solutions: 3 - 10 Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc.
the new EPS would be $15,000/7,875 = $1.9048, for an increase of
$1.9048 - $1.5000 = $0.4048.
Sales $1,607,500
= = 6.66× 6.7×
Inventory $241,500
Sales $1,607,500
= = 5.50× 12.1×
Fixed assets $292,500
Sales $1,607,500
= = 1.70× 3.0×
Total assets $947,500
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 11
Industry
Firm Average
$947,500
ROE = PM × T.A. turnover × EM = 1.7% × 1.7 × = 7.6%.
$361,000
For the industry, ROE = 1.2% × 3 × 2.5 = 9%.
c. The firm’s days sales outstanding is more than twice as long as the
industry average, indicating that the firm should tighten credit or
enforce a more stringent collection policy. The total assets turnover
ratio is well below the industry average so sales should be increased,
assets decreased, or both. While the company’s profit margin is higher
than the industry average, its other profitability ratios are low
compared to the industry--net income should be higher given the amount
of equity and assets. However, the company seems to be in an average
liquidity position and financial leverage is similar to others in the
industry.
Total liabilities
3. Common stock = and equity - Debt - Retained earnings
Answers and Solutions: 3 - 12 Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc.
6. Accounts receivable = (Sales/360)(DSO) = ($450,000/360)(36)
= $45,000.
EBITDA $61.5
coverage = = = 9.46× 9×
$6.5
F. A. Sales $795
Turnover = = = 5.41× 6×
Net fixed assets $147
Return on
common equity = ROA × EM = 6% × 1.43 = 8.58% 12.9%
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 13
Alternatively,
D E
* 1 - =
TA TA
1 – 0.30 = 0.7
TA 1
EM = = = 1.43.
E 0.7
c. Analysis of the Du Pont equation and the set of ratios shows that the
turnover ratio of sales to assets is quite low. Either sales should be
increased at the present level of assets, or the current level of
assets should be decreased to be more in line with current sales.
Thus, the problem appears to be in the balance sheet accounts.
3-16 a. Here are the firm’s base case ratios and other data as compared to the
Answers and Solutions: 3 - 14 Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc.
industry:
The firm appears to be badly managed--all of its ratios are worse than
the industry averages, and the result is low earnings, a low P/E, P/CF
ratio, a low stock price, and a low M/B ratio. The company needs to do
something to improve.
Harcourt, Inc. items and derived items copyright © 2002 by Harcourt, Inc. Answers and Solutions: 3 - 15