Financial Statement Analysis
Financial Statement Analysis
Financial Statement Analysis
892-9793/95
Profitability ratios—measures of the income or operating success of an enterprise for a given period of
time.
Ratio Formula Purpose Or Use
1 Profit margin Net Income ÷ Sales Measures the net income generated by
each peso sales
2 Asset Turnover Net Sales ÷ Average Total Assets Measures how assets are efficiently used
to generate sales
3 Return On Assets Net Income ÷ Total Assets Measures overall profitability of assets
4 Return On Net Income ÷ Average Common Measures profitability of owner’s
Equity Stockholder’s Equity investment
5 Earnings
(Accounting
Per Net Income Or Earningsafter tax − Measures net income per common share
Share Preferred Dividends) ÷ Average outstanding
number of common shares
outstanding
Or
Earnings available to common
stockholder ÷ Average number of
common shares outstanding
6 Price Earnings Market Value of common Stock ÷ Measures the value investors are willing to
Ratio Earnings Per Share give up for every peso earnings they earn
7 Payout Ratio Common Cash Dividends ÷ Earnings Measures the percentage of earnings
Available To Common Stockholders distributed as cash dividends
8 Dividend Yield Common Cash Dividends ÷ Market Measures the percentage of cash dividends
Value of common Stock received over the cash investment per
share of common stockholders
9 Book value per Common stockholders' equity ÷ Book value per common share
1
share Number of common shares
outstanding
10 Book value to Book value per share ÷ Measures the book value per share against
Market Market Value of common Stock perceived market value of common stock
Solvency ratios— measures of the ability of the enterprise to survive over a long period of time.
Ratio Formula Purpose Or Use
1 Times interest Operating income ÷ Interest Measures the ability to meets interest
earned ratio expense payments as they become due
2 Debt-to-equity Liabilities ÷ Stockholders' equity Measures size of total debt to total capital
ratio
3 Debt ratio Liabilities ÷ Total Assets Measures the percentage of total assets
provided by creditors
4 Equity ratio Total Equity ÷ Total Assets Measures the percentage of total assets
provided by owners
b. Vertical analysis, also called common size analysis, expresses each item within a
financial statement as a percent of a base amount. Generally, the base amount is total assets for
the balance sheet, and net sales for the income statement.
c. Ratio analysis, also called common size analysis, expresses each item within a
financial statement as a percent of a base amount. Generally, the base amount is total assets for
the balance sheet, and net sales for the income statement.
PROBLEMS
1
The comparative balance sheet of Greer Company appears below:
GREER COMPANY
Comparative Balance Sheet
December 31,
———————————————————————————————————————————
Assets 2009 2008
Current assets .................................................................................. P 330 P280
Plant assets ...................................................................................... 670 520
Total assets ...................................................................................... P1,000 P800
2
The financial statements of Dobson Company appear below:
DOBSON COMPANY
Comparative Balance Sheet
December 31,
———————————————————————————————————————————
Assets 2009 2008
Cash........................................................................................... P 35,000 P 40,000
2
Short-term investments................................................................. 15,000 60,000
Accounts receivable (net)............................................................... 50,000 30,000
Inventory.................................................................................... 50,000 70,000
Property, plant and equipment (net)................................................ 250,000 300,000
Total assets ........................................................................... P400,000 P500,000
DOBSON COMPANY
Income Statement
For the Year Ended December 31, 2009
Additional information:
a. Cash dividends of P9,000 were declared and paid in 2009.
b. Weighted-average number of shares of common stock outstanding during 2009 was 30,000 shares.
c. Market value of common stock on December 31, 2009, was P21 per share.
Instructions
Using the financial statements and additional information, compute the following ratios for Coulter
Company for 2009. Show all computations.
3
The following ratios have been computed for Pratt Company for 2009.
PRATT COMPANY
Comparative Balance Sheet
December 31,
———————————————————————————————————————————
Assets 2009 2008
Cash...................................................................................... P 25,000 P 35,000
Short-term Investments........................................................... 15,000 15,000
Accounts receivable (net)......................................................... ? (6) 60,000
Inventory............................................................................... ? (8) 50,000
Property, plant, and equipment (net)......................................... 200,000 150,000
Total assets..................................................................... P ? (9) P310,000
3
Liabilities and stockholders' equity
Accounts payable.................................................................... P ? (7) P 25,000
Short-term notes payable......................................................... 35,000 30,000
Bonds payable........................................................................ ? (10) 20,000
Common stock........................................................................ 200,000 200,000
Retained earnings................................................................... 59,000 35,000
Total liabilities and stockholders' equity............................... P ? (11) P310,000
PRATT COMPANY
Income Statement
For the Year Ended December 31, 2009
———————————————————————————————————————————
Net sales................................................................................ P250,000
Cost of goods sold................................................................... 125,000
Gross profit............................................................................ 125,000
Expenses:
Depreciation expense......................................................... P ? (5)
Administrative expenses..................................................... 15,000
Selling expenses................................................................ 10,000
Interest expense................................................................ 5,000
Total expenses............................................................. ? (4)
Income before income taxes..................................................... ? (2)
Income tax expense........................................................... ? (3)
Net income............................................................................. P ? (1)
Instructions
Use the above ratios and information from the Pratt Company financial statements to fill in the missing
information on the financial statements. Follow the sequence indicated. Show computations that support
your answers.
4
The following data are taken from the financial statements of Doyle Company:
2009 2008
Monthly average accounts receivable P 520,000 P 500,000
Net sales on account 5,460,000 4,500,000
Terms for all sales are 2/10, n/30
Instructions
(a) Compute the receivables turnover and the average collection period for both years.
(b) What conclusion can an analyst draw about the management of the accounts receivable?
5
The income statement for Stoval Company for the year ended December 31, 2008 appears below.
Sales P610,000
Cost of goods sold 380,000
Gross profit 230,000
Expenses 170,000*
Net income P 60,000
MULTIPLE CHOICE
2. What financial analysis technique would imply benchmarking with other firms?
a. Horizontal analysis.
b. Vertical analysis.
4
c. Cross-sectional analysis.
d. Ratio analysis.
3.The expected common stock dividend per share for Dawson Corporation for 2012 is
a. P2.34
b. P2.70
c. P3.90
d. P2.10
4.If Dawson Corporation’s common stock is expected to trade at a price/earnings ratio of eight, the
market price per share (to the nearest peso) would be
a. P125
b. P56
c. P72
d. P68
5
8.McKeon Company’s total asset turnover for 2012 is
a. 0.805
b. 0.761
c. 0.722
d. 0.348
13.Obsolete inventory of P125,000 was written off during the year. This transaction
a. Decreased the quick ratio.
b. Increased the quick ratio.
c. Increased net working capital.
d. Decreased the current ratio.
15.The issuance of serial bonds in exchange for an office building, with the first installment of the bonds
due late this year,
a. Decreases net working capital.
b. Decreases the current ratio.
c. Decreases the quick ratio.
d. Affects all of the answers as indicated.
6
SOLUTION 1 FINANCIAL STATEMENT ANALYSIS
Solution 1
GREER COMPANY
Comparative Balance Sheet
December 31,
(b) (b) (a)
Assets 2009 Percent 2008 Percent Percent
Current assets P 330 33% P280 35% 18%
Plant assets 670 67 520 65 29%
Total assets P1,000 100% P800 100% 25%
Solution 2
P150,000
1. Current ratio 3:1. ———— = 3
P50,000
P36,000
2. Return on common stockholders' equity 14.9%. ———————————— = .149
(P262,000 + P220,000) ÷ 2
P36,000
3. Price-earnings ratio 17.5 times. EPS = ———— = P1.20;
30,000
P21
——— = 17.5 times
P1.20
P100,000
4. Acid-test ratio 2:1. ———— = 2:1
P50,000
P360,000
5. Receivables turnover 9 times. ——————————— = 9
(P50,000 + P30,000) ÷ 2
P36,000
7. Profit margin 10%. ———— = .10
P360,000
8. Days in inventory 110.6 days.
P198,000
Inventory turnover = ——————————— = 3.3;
(P50,000 + P70,000) ÷ 2
365 days
———— = 110.6
3.3
P9,000
9. Payout ratio 25%. ———— = .25
P36,000
P36,000
10. Return on assets 8%. ———————————— = .08
(P400,000 + P500,000) ÷ 2
Solution 3
PRATT COMPANY
Comparative Balance Sheet
December 31,
———————————————————————————————————————————
Assets 2009 2008
Cash................................................................................ P 25,000 P 35,000
Marketable securities.......................................................... 15,000 15,000
Accounts receivable (net).................................................... 40,000 (6) 60,000
Inventory......................................................................... 70,000 (8) 50,000
Property, plant, and equipment (net).................................... 200,000 150,000
Total assets................................................................ P350,000 (9) P310,000
PRATT COMPANY
Income Statement
For the Year Ended December 31, 2009
———————————————————————————————————————————
Net sales.......................................................................... P250,000
Cost of goods sold.............................................................. 125,000
Gross profit....................................................................... 125,000
Expenses
Depreciation expense.................................................... P25,000 (5)
Administrative expenses................................................ 15,000
Selling expenses.......................................................... 10,000
Interest expense.......................................................... 5,000
Total expenses....................................................... 55,000 (4)
Income before income taxes................................................ 70,000 (2)
Income tax expense........................................................... 20,000 (3)
Net income....................................................................... P 50,000 (1)
(1) Net income = P50,000 (P250,000 × 20%).
(2) Income before income taxes = P70,000.
Let X = Income before income taxes and interest expense.
X
——— = 15 times
P5,000
X = P75,000
P75,000 – P5,000 = P70,000
(3) Income tax expense = P20,000 (P70,000 – P50,000).
(4) Total operating expenses = P55,000 (P125,000 – P70,000).
(5) Depreciation expense = P25,000 [P55,000 – (P5,000 + P10,000 + P15,000)].
8
P91,000 – (P15,000 + P35,000) = P41,000
(11) Total liabilities and stockholders' equity = P350,000; same as total assets—see (9) above.
Soltion 4
(a) 2009 2008
P5,460,000 P4,500,000
Receivables turnover ————— —————
520,000 500,000
10.5 times 9.0 times
1.(d) The requirement is to identify the ratio that does not measure asset utilization. Answer (d) is
correct because the debt to total assets ratio is a debt utilization (financial leverage) ratio. Answers (a),
(b), and (c) are incorrect because they are asset utilization ratios.
2.(c) The requirement is to identify the nature of benchmarking with other firms. Answer (c) is correct
because cross-sectional analysis involves comparing results and ratios to those of other firms in the
same industry. Answer (a) is incorrect because horizontal analysis involves comparisons
of results and ratios for the same firm over time. Answer (b) is incorrect because vertical analysis
involves comparisons of
relationships in a firm’s financial statements for a single year. Answer (d) is incorrect because ratio
analysis does not imply any particular comparison.
3.(d) The requirement is to calculate the expected dividend per share. Earnings after interest is equal to
P30 million (P35 million – P5 million). Net earnings after taxes is equal to P18 million [P30 million × 1 –
Tax rate (40%)]. The net earnings after dividends to preferred shareholders is equal to P14 million (P18
million – P4 million), and the dividend for common stockholders is equal to P4,200,000 (P14 million ×
30%). The dividend per share is equal to P4,200,000/P2 million shares = P2.10. Therefore, the correct
answer is (d).
4.(b) The requirement is to calculate the market price from the earnings per share and price/earnings
ratio. Net earnings is
equal to P18 million (P35 million – P5 million) × (1 – 40%). Net earnings available to common
stockholders is equal to P14 million (P18 million – P4 million). Earnings per share is equal to P14
million/2 million shares, or P7.00. Therefore, the estimated market price would be P7.00 × 8 = P56, or
answer (b).
5.(b) The requirement is to calculate the debt-to-total-asset ratio. Answer (b) is correct. The debt-to-
total-asset ratio is
calculated by dividing total debt by total assets. Therefore, the debt-to-total-asset ratio is equal to
0.315 (P78,000 current
liabilities + P75,000 long-term debt) ÷ (P210,000 current assets + P275,000 noncurrent assets).
Answers (a), (c), and (d) are incorrect because the computations are not correct.6.(d) The requirement
is to calculate accounts receivable turnover. Answer (d) is correct. Accounts receivable turnover is
calculated by dividing total credit sales by the average balance of accounts receivable. The average
balance of accounts receivable is P85,000 [(P100,000 + P70,000) ÷ 2]. Therefore,
accounts receivable turnover is equal to 4.118 (P350,000 credit sales ÷ P85,000 average accounts
receivable).
7.(a) The requirement is to calculate inventory turnover. Answer (d) is correct. Inventory turnover is
calculated by dividing cost of goods sold by average inventory. Average inventory is equal to P75,000
[(P70,000 + P80,0000) ÷ 2]. Therefore, inventory turnover is equal to 2.133 (P160,000 ÷ P75,000).
8.(b) The requirement is to calculate total asset turnover. Answer (b) is correct. Total asset turnover is
calculated by dividing sales by average total assets. Average total assets is equal to P460,000 =
[(P210,000 + P275,000) + (P180,000 +
P255,000)] ÷ 2. Therefore, total asset turnover is equal to 0.761 (P350,000 ÷ P460,000).9.(c) The
requirement is to calculate return on total assets. Answer (c) is correct. Return on assets is calculated
by
9
dividing net income by average total assets. As determined in the previous question, average total
assets is equal to
P460,000. Net income is equal to P72,000 (P350,000 sales – P160,000 cost of goods sold – P3,000
interest expense –
P48,000 income taxes – P67,000 administrative expense). Therefore, return on assets is equal to 0.157
(P72,000 ÷
P460,000), or 15.7%.
10.(c) The requirement is to determine the effect of payment of an account payable. Answer (c) is
correct. The quick ratio is equal to quick assets divided by current liabilities and the current ratio is
equal to current assets divided by current liabilities. Since we are told that quick assets exceed current
liabilities, both ratios are greater than one. With a ratio greater than one if you reduce the numerator
and denominator by an equal amount, the ratio will increase.
11.(b) The requirement is to determine the effect of a purchase of raw materials on account. The
correct answer is (b). Since we know that the current ratio is greater than one, an increase in the
numerator and the denominator by an equal amount will decrease the ratio. Answers (c) and (d) are
incorrect because working capital will not change.
12.(d) The requirement is to determine the effect of the collection of accounts receivable. Answer (d) is
correct. Collection of accounts receivable has no effect on the quick or current ratio because both cash
and accounts receivable are part of the numerator of both ratios.
13.(d) The requirement is to determine the effect of writing off inventory. Answer (d) is correct because
a write-off of inventory will decrease the current ratio. Answers (a) and (b) are incorrect because
inventory is not used in computing the quick ratio. Answer (c) is incorrect because working capital will
be decreased.
14.(a) The requirement is to determine the effect of a fivefor-one stock split. Answer (a) is correct
because a stock split increases the number of shares outstanding and, therefore, reduces the book
value per share. Answers (c) and (d)
are incorrect because the transaction does not affect total stockholders’ equity.
15.(d) The requirement is to determine the effect of issuing serial bonds in exchange for an office
building. Answer (d) is correct because the first installment is a current liability which affects the quick
ratio, the current ratio, and working capital.
16.(b) The requirement is to determine the effect of liquidating a long-term note with cash. Answer (b)
is correct. Cash is included in the numerator of both the quick and current ratios. However, a reduction
in cash affects the quick ratio more than the current ratio because it is smaller.
10