03 04 Analysis Financial Statement
03 04 Analysis Financial Statement
03 04 Analysis Financial Statement
AFS-1
Learning Objectives
1. Describe the content of the four basic financial statements and discuss the importance of financial statement analysis to the financial manager. 2. Evaluate firm profitability using the income statement. 3. Explain what we can learn by analyzing a firms financial statements.
AFS-2
Learning Objectives
4. Use common size financial statements as a tool of financial analysis. 5. Calculate and use a comprehensive set of financial ratios to evaluate a companys performance. 6. Select an appropriate benchmark for use in performing a financial ratio analysis. 7. Describe the limitations of financial ratio analysis.
AFS-3
AFS-4
AFS-9
AFS-10
AFS-11
AFS-12
AFS-13
AFS-14
AFS-15
AFS-16
AFS-17
The following three fundamental principles are adhered to by accountants when preparing financial statements: 1. The revenue recognition principle, 2. The matching principle, and 3. The historical cost principle. An understanding of these basic principles allows us to be a more informed user of financial statements.
AFS-18
What are the Accounting Principles Used to Prepare Financial Statements? (cont.)
AFS-19
What are the Accounting Principles Used to Prepare Financial Statements? (cont.)
AFS-20
What are the Accounting Principles Used to Prepare Financial Statements? (cont.)
An Income Statement
An income statement is also called a profit and loss statement. An income statement measures the amount of profits generated by a firm over a given time period (usually a year or a quarter).
Revenues (or Sales) Expenses = Profits
AFS-22
1. Profits
Gross profit, net operating income (also known as EBIT), earnings before taxes (EBT), and net income
AFS-23
= Operating income (EBIT) Minus Interest Expense = Earnings before taxes (EBT) Minus Income taxes EBIT = Earnings before interest and taxes; EBT = Earnings before taxes; EAT = Earnings after taxes
AFS-24
AFS-25
AFS-26
AFS-27
AFS-28
AFS-32
Example 3: Review examples 1 & 2. How much was retained or reinvested by the firm? Amount retained = Net Income Dividends = $90m - $20m = $70m The firms balance on retained earnings will increase by $70 million on the balance sheet.
AFS-33
AFS-34
GPM indicates the firms mark-up on its cost of goods sold per dollar of sales.
AFS-35
AFS-38
AFS-40
AFS-42
AFS-43
AFS-44
AFS-48
AFS-49
AFS-51
AFS-53
AFS-55
AFS-56
AFS-57
AFS-61
AFS-62
AFS-63
AFS-64
Uses of Cash
Increase in Accounts Receivable $22.50
Increase in long-term debt =$51.75 Increase in inventory = $148.50 Increase in retained earnings = $159.75 Increase in net plant and equipment = $40.50 Decrease in short-term notes = $9 Total Sources of cash = $216.00 Total Uses of cash = $220.50
AFS-68
The firm used more cash than it generated, resulting in a deficit of $4.5 million The primary source of cash flow was retained earnings ($159.75 million) followed by long-term debt ($51.75 million) The largest use of cash was for acquiring inventory at $148.5 million.
AFS-69
Uses of Cash
Increase in an asset account Decrease in a liability account Decrease in an owners equity account
AFS-70
AFS-73
AFS-74
Checkpoint 3.3
AFS-75
Checkpoint 3.3
AFS-76
Checkpoint 3.3
AFS-77
Checkpoint 3.3
AFS-78
Checkpoint 3.3
AFS-79
AFS-80
AFS-81
AFS-83
A common size financial statement is a standardized version of a financial statement in which all entries are presented in percentages. A common size financial statement helps to compare entries in a firms financial statements, even if the firms are not of equal size.
AFS-84
AFS-85
AFS-86
AFS-88
Capital structure ratios Asset management efficiency ratios Profitability ratios Market value ratios
AFS-91
Liquidity Ratios
Liquidity ratios address a basic question: How liquid is the firm? A firm is financially liquid if it is able to pay its bills on time. We can analyze a firms liquidity from two perspectives:
Overall or general firm liquidity Liquidity of specific current asset accounts
AFS-92
AFS-94
AFS-95
AFS-96
AFS-97
AFS-98
Average Collection Period measures the number of days it takes the firm to collects its receivables.
AFS-101
The text computes the average collection period for H.J. Boswell, Inc. for 2010. What will be the average collection period for 2009 if we assume that the annual credit sales were $2,500 million in 2009?
AFS-102
Average Collection Period = Accounts Receivable Daily Credit Sales = $139.5m $6.85m = 20.37 days The firm collects its accounts receivable in 20.37 days.
AFS-103
AFS-104
Accounts Receivable Turnover = $2,500 million $139.50 = 17.92 times The firms accounts receivable were turning over at 17.92 times per year.
AFS-106
Inventory turnover ratio measures how many times the company turns over its inventory during the year. Shorter inventory cycles lead to greater liquidity since the items in inventory are converted to cash more quickly.
AFS-107
AFS-108
Inventory Turnover Ratio = $1,980 $229.50 = 8.63 times The firm turned over its inventory 8.63 times per year.
AFS-109
AFS-110
Checkpoint 4.1
Evaluating Dell Computer Corporations (DELL) Liquidity You work for a small company that manufactures a new memory storage device. Computer giant Dell has offered to put the new device in their laptops if your firm will extend them credit terms that allow them 90 days to pay. Since your company does not have many cash resources, your boss has asked that you look into Dells liquidity and analyze its ability to pay their bills on time using the following accounting information for Dell and two other computer firms (figures in thousands of dollars):
AFS-112
Checkpoint 4.1
AFS-113
Checkpoint 4.1
AFS-114
Checkpoint 4.1
AFS-115
Calculate HPs inventory turnover ratio. Why do you think this ratio is so much lower than Dells inventory turnover ratio?
AFS-116
AFS-117
AFS-118
Step 3: Solve
Inventory Turnover Ratio for HP
= Cost of Goods Sold Inventories = $69,178,000 7,750,000 = 8.93
AFS-119
Step 4: Analyze
HPs inventory turnover ratio indicates that the inventory at HP remains on shelf for (365 8.93) days or 40.87 days. This is much higher than Dell that has an inventory turnover ratio of 79.79 or shelf life of only 4.57 days. The significant difference must be investigated further as the two firms are in the same industry.
AFS-120
AFS-121
AFS-123
AFS-124
Debt Ratio
= $1,012.50 million $1,764 million = 57.40%
We use EBIT or operating income as interest expense is paid before a firm pays its taxes.
AFS-126
Checkpoint 4.2
Comparing the Financing Decisions of Home Depot (HD) and Lowes Corporation (LOW)
You inherited a small sum of money from your grandparents and currently have it in a savings account at your local bank. After enrolling in your first finance class in business school you have decided that you would like to begin investing your money in the common stock of a few companies. The first investment you are considering is stock in either Home Depot or Lowes. Both firms operate chains of home improvement stores throughout the United States and other parts of the world. In your finance class you learned that an important determinant of the risk of investing in a firms stock is driven by the firms capital structure, or how it has financed its assets. In particular, the more money the firm borrows, the greater is the risk that the firm may become insolvent and bankrupt. Consequently, the first thing you want to do before investing in either companys stock is to compare how they financed their investments. Just how much debt financing have the two firms used?
AFS-129
Checkpoint 4.2
AFS-130
Checkpoint 4.2
AFS-131
Checkpoint 4.2
AFS-132
AFS-133
EBIT
Less: Cost of Good Sold Equals: Gross Profit Less: Operating Expenses Equals: Net Operating Income (EBIT) Less: Interest Expense Equals: Earnings before Taxes Less: Taxes Equals Net Income
Interest Expense
AFS-135
AFS-136
Step 3: Solve
Times Interest Earned (TIE)
= EBIT Interest Expense
TIE (Lowes)
= $1.03 billion $0.154 billion = 6.69 times
AFS-137
Step 4: Analyze
We observe that a drop in net operating income leads to a significant drop in times interest earned ratio for both the firms. The times interest earned ratio drops from 24.68 to 4.94 for Home Depot and from 33.45 to 6.69 for Lowes. Should creditors be worried by this drop?
AFS-138
ROE =
15,000 100,000
= 15%
ROE =
22%
AFS-141
AFS-142
AFS-143
AFS-144
Thus the firm generated $1.42 in sales per dollar of assets in 2009.
AFS-145
AFS-146
AFS-147
The firm generated $1.94 in sales per dollar invested in plant and equipment.
AFS-148
AFS-151
Profitability Ratios
Profitability ratios address a very fundamental question: Has the firm earned adequate returns on its investments? We answer this question by analyzing the firms profit margin, which predict the ability of the firm to control its expenses, and the firms rate of return on investments.
AFS-153
AFS-154
AFS-155
AFS-156
The firm spent $0.74 for cost of goods sold for each dollar of sales. Thus, $0.26 out of each dollar of sales goes to gross profits.
AFS-157
AFS-158
Operating Profit Margin = $350 million $2,500 million = 14% Thus the firm generates $0.14 in operating profit for each dollar of sales.
AFS-160
AFS-161
AFS-162
The firm generated $0.087 for each dollar of sales after all expenses (including income taxes) were accounted for.
AFS-163
AFS-164
The firm generated $0.1984 of operating profits for every $1 of its invested assets.
AFS-166
AFS-167
AFS-168
AFS-169
Checkpoint 4.3
Evaluating the Operating Return on Assets Ratio for Home Depot (HD) and Lowes (LOW)
In Checkpoint 4.2 we evaluated how much debt financing Home Depot and Lowes used. We continue our analysis by evaluating the operating return on assets (OROA) earned by the two firms. Calculate the net operating income each firm earned during 2007 relative to the total assets of each firm using the information found below:
AFS-171
Checkpoint 4.3
AFS-172
Checkpoint 4.3
AFS-173
Checkpoint 4.3
AFS-174
AFS-175
AFS-176
AFS-177
Step 3: Solve
Operating Return on Assets (OROA)
= Total Asset Turnover Operating Profit Margin
AFS-178
Step 4: Analyze
An improvement in total asset turnover ratio has a favorable impact on Home Depots operating return on assets (OROA). If Home Depot wants to increase its OROA more, it should focus on cost control that will help improve the net operating profit.
AFS-179
Is the Firm Providing a Reasonable Return on the Owners Investment? A firms net income consists of earnings that is available for distribution to the firms shareholders. Return on Equity ratio measures the accounting return on the common stockholders investment.
AFS-180
The text computes the return on equity ratio for H.J. Boswell, Inc. for 2010. What will be the return on equity ratio for 2009 if we assume net income of $217.75 million for 2009?
AFS-181
Return on Equity
= $217.75 million $751.50 million = 28.98%
Thus the shareholders earned 28.97% on their investments. Note common equity includes both common stock plus the firms retained earnings.
AFS-182
AFS-183
Using the DuPont Method for Decomposing the ROE ratio (cont.)
ROE = Profitability Efficiency Equity Multiplier
ROE = Net Profit Margin Total Asset Turnover Ratio 1/(1-debt ratio)
AFS-184
Using the DuPont Method for Decomposing the ROE ratio (cont.) The following table shows why Boswells return on equity was higher than its peers.
Return on Equity H. J. Boswell, Inc. Peer Group 22.5% Net Profit Total Asset Equity Margin Turnover Multiplier 7.6% 1.37 2.16
18.0%
10.2%
1.15
1.54
AFS-185
Using the DuPont Method for Decomposing the ROE ratio (cont.)
The table suggests that Boswell had a higher ROE as it was able to generate more sales from its assets (1.37 versus 1.15 for peers) and used more leverage (2.16 versus 1.54). Note use of financial leverage may not always generate value for shareholders. Impact of financial leverage is discussed in detail in chapter 15.
AFS-186
Using the DuPont Method for Decomposing the ROE ratio (cont.)
AFS-187
AFS-188
AFS-189
PE ratio = $22 $2.42 = 9.09 The investors were willing to pay $9.09 for every dollar of earnings per share that the firm generated.
AFS-191
AFS-192
AFS-193
Market-to-Book Ratio = Market price per share Book value per share = $22 $8.35 = 2.63 times
AFS-194
Checkpoint 4.4
Comparing the Valuation of Dell (DELL) to Apple (APPL) Using Market Value Ratios
The following information on Dell and Apple was gathered on April 9, 2010:
AFS-195
Checkpoint 4.4
AFS-196
Checkpoint 4.4
AFS-197
What price per share for Dell would it take to increase the firms price-toearnings ratio to the level of Apple?
AFS-198
AFS-199
Step 3: Solve
PE ratio = Price per share Earnings per share 18.20 = Price per share $1.14 Price per share = 18.20 1.14 = $20.75
AFS-201
Step 4: Analyze
PE ratio allows us to compare two stocks with different prices by standardizing the stock prices by earnings. Apple has a much higher PE ratio. To reach the same PE valuation, the stock price of Dell will have to increase from $12.54 to $20.75.
AFS-202
Trend Analysis
AFS-206
AFS-207
AFS-208
Practice Problems
AFS-210
Example #1 Assume you are given the following relationships for the Brauer Corporation:
Sales / Total Assets 1.5x Return on Assets (ROA) 3% Return on Equity (ROE) 5%
Example #1
ROA = Profit margin Total assets turnover 3% = Profit margin x 1.5 Profit margin = 3% / 1.5 = 2% ROE = ROA TA/E 5% = 3% TA/E TA/E = 5% / 3% E/TA = 3/5 = 60% therefore, D/TA = 1 - 0.60 = 0.40 = 40%
AFS-212
Team Assignment
Complete the balance sheet and sales information in the table that follows for Hoffmeister Industries using the following financial data (all sales are on credit):
Debt Ratio: 50% Current Ratio: 1.8x Total assets turnover: 1.5x Accounts receivable turnover: 10x Gross profit margin on sales: 25% Inventory turnover ratio: 5x
AFS-213
Team Assignment
BALANCE SHEET C ash A c c o u n ts re c e iv a b le In v e n to rie s F ix e d a s s e ts T o ta l a s s e ts S a le s A c c o u n ts p a y a b le L o n g -te rm d e b t C o m m o n s to c k R e t a i n e d e a r n i n g s 66 666 , $6 6 ,6 6 T o t a l l i a b i l i t i e s & e q u i t y 6 6 C o s t o f g o o d s s o ld
AFS-214
66 666 ,
Team Assignment
1. Debt = (0.50)(Total assets) = (0.50)($300,000) = $150,000. 2. Accounts payable = Debt Long-term debt = $150,000 - $60,000 = $90,000. 3. Common stock = Total liabilities & equity - Debt Retained earnings = $300,000 - $150,000 - $97,500 = $52,500. 4. Sales = (1.5)(Total assets) = (1.5)($300,000) = $450,000. 5. Cost of goods sold = (Sales)(1 - 0.25) = ($450,000)(0.75) = $337,500 6. Inventories = Cost of goods sold /5 = $337,500/5 = $67,500.
AFS-215
Team Assignment
7. Accounts receivable = Credit Sales / Accounts receivable turnover = ($450,000/10) = $45,000. 8. Cash + Accounts receivable + Inventories = (1.8)(Accounts payable) Cash + $45,000 + $67,500 = (1.8)($90,000) Cash + $112,500 = $162,000 Cash = $49,500. 9. Fixed assets = Total assets - (Cash + Accts rec. + Inventories) Fixed assets = $300,000 - ($49,500 + $45,000 + $67,500) = $138,000. AFS-216