Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Analysis of Financial Statements PowerPoint Presentation
Download Presentation
Analysis of Financial Statements

Analysis of Financial Statements

133 Views Download Presentation
Download Presentation

Analysis of Financial Statements

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Analysis of Financial Statements Chapter 3

  2. Overview of Financial Analysis • First order of business is to SPECIFY THE OBJECTIVES OF THE ANALYSIS • Remember -- the identity of the user helps define what information is needed

  3. Potential Financial Statement Users: • Creditors • Investors • Managers • Employees • What types of questions do each of these users seek answers to?

  4. Creditors • Why does the firm want/need to borrow funds? • What is the firm’s capital structure? How leveraged are they? • How will they pay it back? What kind of cash flows are being generated by operations?

  5. Investors • How has the firm performed/what are future expectations? • How much RISK is inherent in the capital structure? • What are expected returns from the firm? • What is firm’s competitive position?

  6. Managers • Need all info creditors and investors need PLUS: • What operating areas have contributed to success and which have not? • What are strengths/weaknesses of company’s financial position? • What changes are indicated to improve future performance?

  7. Caution!!! • Keep in mind: management PREPARES financial statements • Analyst should be alert to potential for management to influence reporting to make data more “appealing” • May want to supplement analysis with information apart from Annual Report prepared by management

  8. Where to look for data... • Financial statements (and notes) • Annual Report • 10K and 10Q reports filed with SEC • Computerized data bases • Info on industry norms/ratios • Info on particular companies/industries/mutual funds • Websites

  9. Basic Tools • Common size financial statements • Financial ratios • Trend analysis • Industry comparisons

  10. Common Sizing

  11. Common Sizing

  12. Common Sizing

  13. Common Size Statements • Common size income statement • expresses each income statement category as a percentage of sales • Common size balance sheet • expresses each item on balance sheet as a percentage of total assets or equities

  14. Ratio Analysis Four Categories of Ratios • Profitability • Liquidity • Debt Utilization • Asset Utilization ratios

  15. Ratio Analysis Profitability Ratios • Measure the overall effectiveness of the firm’s management.

  16. Gross Profit Sales Gross Profit Margin = Ratio Analysis Profitability Ratios How effective is the firm at generating revenue in excess of its cost of goods sold?

  17. Gross Profit = Margin Gross Profit Sales $575 $1,450 Gross Profit Margin = = 39.7% Balance Sheet Excalibur Corporation Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Bonds $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Net Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  18. Operating Income Sales Operating Profit Margin = Ratio Analysis Profitability Ratios How effective is the firm in keeping costs of production low?

  19. Operating Profit = Margin Operating Income Sales $330 $1,450 Oper. Profit Margin = = 22.8% Balance Sheet Excalibur Corporation Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625 Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  20. Ratio Analysis Profitability Ratios Note: Net Income equals Earnings Available to CS when there is no preferred stock. Net Income Sales Profit Margin or Return on Sales = How much net profit is being generated from each dollar of sales?

  21. Net Profit = Margin Net Income Sales $162 $1,450 Profit Margin = = 11.2% Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625 Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  22. Net Income Total Assets Return on Assets = Ratio Analysis Profitability Ratios How effectively is the firm generating net income from its assets ?

  23. Net Income Total Assets Return on Assets = $162 $2,530 = 6.4% ROA = Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625 Current Liabilities $230 Current Assets $1,230 Long-term debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40) 108 Net Income% $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  24. Ratio Analysis Profitability Ratios Net Income Equity Return on Common Equity = How well is the firm generating return to its equity providers?

  25. Net Income Equity Return on Equity = $162 $1,700 ROE = = 9.53% Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625 Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  26. Current Assets Current Liabilities Current Ratio = Ratio Analysis Liquidity Ratios • Measure the ability of the firm to meet its short-term financial obligations. Are there sufficient current assets to pay off current liabilities? What is the cushion of safety?

  27. Current Assets Current Liabilities Current Ratio = $1,230 $230 Current Ratio = = 5.35x Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530

  28. Current Assets - Inventory Current Liabilities Quick Ratio = Ratio Analysis Liquidity Ratios • Measure the ability of the firm to meet its short-term financial obligations. What happens to the firm’s ability to repay current liabilities after what is usually the least liquid of the current assets is subtracted?

  29. Current Assets - Inventory Current Liabilities Quick Ratio = $1,230 -$625 $230 Acid-Test Ratio = = 2.63x Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530

  30. Ratio Analysis Debt Utilization Ratios • Measure the relative size of the firm’s debt load and the firm’s ability to pay off the debt.

  31. Total Debt Total Assets Debt Ratio = Ratio Analysis Debt Ratios What proportion of the firm’s assets is financed with debt?

  32. Total Debt Total Assets Debt Ratio = $230 + $600 $2,530 Debt Ratio = = 33% Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  33. Operating Income Interest Expense Times Interest Earned Ratio = Ratio Analysis Debt Ratios What is the firm’s ability to repay interest payments from its operating income?

  34. Times Interest = Earned Ratio Operating Income Interest Expense $330 $60 TIE Ratio = = 5.50x Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  35. Ratio Analysis Asset Management Ratios • Help assess how effectively the firm is using assets to generate sales.

  36. Ratio Analysis Asset Utililzation Ratios Accounts Receivable Avg. Daily Cr. Sales Average Collection Period = How long does it take for the firm on average to collect its credit sales from customers?

  37. Average Collection = Period Accounts Receivable Avg. Daily Sales $430 $1,450/365 ACP = = 108.24 days Balance Sheet Excalibur Corporation Additional Info: We assume all sales are credit sales. Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Bonds $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62 Days in a year

  38. Sales Inventory Inventory Turnover Ratio = Ratio Analysis Asset Management Ratios Is inventory efficiently translating into sales for the firm?

  39. Inventory Turnover = Ratio Sales Inventory $1450 $625 Inventory Turnover = = 2.3x Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  40. Sales Net Fixed Assets Fixed Asset Turnover Ratio = Ratio Analysis Asset Management Ratios How effective is the firm in using its fixed assets to help generate sales?

  41. Fixed Asset Turnover = Ratio Sales Net Fixed Assets $1,450 $1,300 Fixed Asset Turnover = = 1.12x Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  42. Sales Total Assets Total Asset Turnover Ratio = Ratio Analysis Asset Management Ratios How effective is the firm in using its overall assets to generate sales?

  43. Total Asset Turnover = Ratio Sales Total Assets $1,450 $2,530 Total Asset Turnover = = 0.57x Balance Sheet Excalibur Corporation Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  44. Price per Share Earnings per Share Price to Earnings Ratio = Ratio Analysis Market Value Ratios How much are investors willing to pay per dollar of earnings of the firm? (Indicator of investor’s attitudes toward future prospects of the firm and of the firm’s risk.)

  45. P/E Ratio Price/Share EPS = $20.00 $162/100 P/E ratio = = 12.35x Balance Sheet Excalibur Corporation Additional Info: 100 shares $20.00 per share Assets Liabilities Cash $175 Accounts Payable $115 Accounts Receivable 430 S-T Notes Payable 115 Inventories 625Current Liabilities $230 Current Assets $1,230 Long-term Debt $600 Plant & Equipment $2,500 Owner’s Equity Less:Acc. Depr. (1,200) Common Stock $300 Net Fixed Assets $1,300 Capital in Excess of Par 600 Total Assets $2,530 Retained Earnings 800 Total Owners’ Equity $1,700 Total Liabilities and Owners Equity $2,530 Income Statement Excalibur Corporation Sales $1,450 Cost of Goods Sold 875 Gross Profit $575 Operating Expenses 45 Depreciation 200 Operating Income $330 Interest Expense 60 Income Before Taxes $270 Taxes (40%) 108 Net Income $162 Common Dividends Paid 100 Addition to Retained Earnings $62

  46. Ratio Industry Excalibur Profitability Gross Profit Margin 38% 39.7% Operating Profit Margin 20% 22.8% Net Profit Margin 12% 11.2% Return on Assets 9.0% 6.4% Return on Equity 13.4% 9.5%

  47. Ratio Industry Excalibur Profitability Gross Profit Margin 38% 39.7% Operating Profit Margin 20% 22.8% Net Profit Margin 12% 11.2% Return on Assets 9.0% 6.4% Return on Equity 13.4% 9.5% Excalibur is good at keeping operating costs down, but not as good at total costs. ROA and ROE are low mainly due to productivity problems.

  48. Summary of Excalibur Corporation Ratios Ratio Industry Excalibur Liquidity Current Ratio 5.00x 5.35x Quick Ratio 3.00x 2.63x

  49. Summary of Excalibur Corporation Ratios Ratio Industry Excalibur Liquidity Current Ratio 5.00x 5.35x Quick Ratio 3.00x 2.63x Looking at the current ratio it appears that Excalibur is more liquid than the industry.... however when looking at Acid Test (a better measure) they are not as liquid indicating that inventory levels are probably too high.

  50. Ratio Industry Excalibur Debt Debt Ratio 35% 33% Times Interest Earned 7.00x 5.50x