Chapter 6
This presentation is the property of its rightful owner.
Sponsored Links
1 / 68

Chapter 6 PowerPoint PPT Presentation


  • 163 Views
  • Uploaded on
  • Presentation posted in: General

Chapter 6. Financial Statement Analysis. © 2001 Prentice-Hall, Inc. Fundamentals of Financial Management, 11/e Created by: Gregory A. Kuhlemeyer, Ph.D. Carroll College, Waukesha, WI. Financial Statement Analysis. Financial Statements A Possible Framework for Analysis Ratio Analysis

Download Presentation

Chapter 6

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Chapter 6

Chapter 6

Financial Statement Analysis

© 2001 Prentice-Hall, Inc.

Fundamentals of Financial Management, 11/e

Created by: Gregory A. Kuhlemeyer, Ph.D.

Carroll College, Waukesha, WI


Financial statement analysis

Financial Statement Analysis

  • Financial Statements

  • A Possible Framework for Analysis

  • Ratio Analysis

  • Trend Analysis

  • Common-Size and Index Analysis


Examples of external uses of statement analysis

Examples of External Uses of Statement Analysis

  • Trade Creditors-- Focus on the liquidity of the firm.

  • Bondholders-- Focus on the long-term cash flow of the firm.

  • Shareholders -- Focus on the profitability and long-term health of the firm.


Examples of internal uses of statement analysis

Examples of Internal Uses of Statement Analysis

  • Plan-- Focus on assessing the current financial position and evaluating potential firm opportunities.

  • Control-- Focus on return on investment for various assets and asset efficiency.

  • Understand -- Focus on understanding how suppliers of funds analyze the firm.


Primary types of financial statements

Primary Types of Financial Statements

Income Statement

  • A summary of a firm’s revenues and expenses over a specified period, ending with net income or loss for the period.

  • Balance Sheet

    • A summary of a firm’s financial position on a given date that shows total assets = total liabilities + owners’ equity.


Basket wonders balance sheet asset side

a. How the firm stands on a specific date.

b. What BW owned.

c. Amounts owed by customers.

d. Future expense items already paid.

e. Cash/likely convertible to cash within 1 year.

f. Original amount paid.

g. Acc. deductions for wear and tear.

Cash and C.E. $ 90 Acct. Rec.c 394 Inventories 696 Prepaid Expd 5 Accum Tax Prepay 10Current Assetse $1,195 Fixed Assets (@Cost)f 1030 Less: Acc. Depr. g (329) Net Fix. Assets $ 701 Investment, LT 50 Other Assets, LT 223Total Assetsb $2,169

Basket Wonders’ Balance Sheet (Asset Side)

Basket Wonders Balance Sheet (thousands) Dec. 31, 2003a


Basket wonders balance sheet liability side

a. Note, Assets = Liabilities + Equity.

b. What BW owed and ownership position.

c. Owed to suppliers for goods and services.

d. Unpaid wages, salaries, etc.

e. Debts payable < 1 year.

f. Debts payable > 1 year.

g. Original investment.

h. Earnings reinvested.

Notes Payable $ 290 Acct. Payablec 94 Accrued Taxesd 16 Other Accrued Liab.d 100Current Liab.e $ 500 Long-Term Debtf530Shareholders’ Equity Com. Stock ($1 par)g200Add Pd in Capitalg729 Retained Earningsh 210 Total Equity $1,139

Total Liab/Equitya,b $2,169

Basket Wonders’ Balance Sheet (Liability Side)

Basket Wonders Balance Sheet (thousands) Dec. 31, 2003


Basket wonders income statement

a. Measures profitability over a time period.

b. Received, or receivable, from customers.

c. Sales comm., adv., officers’ salaries, etc.

d. Operating income.

e. Cost of borrowed funds.

f. Taxable income.

g. Amount earned for shareholders.

Net Sales $ 2,211 Cost of Goods Soldb1,599Gross Profit $ 612 SG&A Expenses c 402EBITd$ 210 Interest Expensee 59 EBT f$151Income Taxes 60 EATg$ 91 Cash Dividends 38 Increase in RE $ 53

Basket Wonders’ Income Statement

Basket Wonders Statement of Earnings (in thousands) for Year Ending December 31, 2003a


Framework for financial analysis

Framework for Financial Analysis

Trend / Seasonal Component

How much funding will be required in the future?

Is there a seasonal component?

Analytical Tools Used

Sources and Uses Statement

Statement of Cash Flows

Cash Budgets

1. Analysis of the funds

needs of the firm.


Framework for financial analysis1

Framework for Financial Analysis

Health of a Firm

Financial Ratios

1. Individually

2. Over time

3. In combination

4. In comparison

1. Analysis of the funds

needs of the firm.

2. Analysis of the financial

condition and profitability

of the firm.


Framework for financial analysis2

Framework for Financial Analysis

Examples:

Volatility in sales

Volatility in costs

Proximity to break-even point

Business riskrelates to the risk inherent in the operations of the firm.

1. Analysis of the funds

needs of the firm.

2. Analysis of the financial

condition and profitability

of the firm.

3. Analysis of the business

risk of the firm.


Framework for financial analysis3

Framework for Financial Analysis

A Financial Manager must consider all three jointly when determining the financing needs of the firm.

1. Analysis of the funds

needs of the firm.

Determining

the

financing

needs of

the firm.

2. Analysis of the financial

condition and profitability

of the firm.

3. Analysis of the business

risk of the firm.


Framework for financial analysis4

Framework for Financial Analysis

1. Analysis of the funds

needs of the firm.

Determining

the

financing

needs of

the firm.

Negotiations

with

suppliers of

capital.

2. Analysis of the financial

condition and profitability

of the firm.

3. Analysis of the business

risk of the firm.


Use of financial ratios

Types of Comparisons

Internal Comparisons

External Comparisons

A Financial Ratio is an index that relates twoaccountingnumbers and is obtained by dividing one number by the other.

Use of Financial Ratios


External comparisons and sources of industry ratios

Examples:

Robert Morris Associates

Dun & Bradstreet

Almanac of Business and Industrial Financial Ratios

This involves comparing the ratios of one firm with those of similar firms or with industry averages.

Similarity is important as one should compare “apples to apples.”

External Comparisons and Sources of Industry Ratios


Liquidity ratios

Current

Current Assets

Current Liabilities

For Basket Wonders December 31, 2003

Shows a firm’s ability to cover its current liabilities with its current assets.

Liquidity Ratios

Balance Sheet Ratios

Liquidity Ratios

$1,195

$500

= 2.39


Liquidity ratio comparisons

BWIndustry

2.392.15

2.262.09

1.912.01

Year

2003

2002

2001

Liquidity Ratio Comparisons

CurrentRatio

Ratio is stronger than the industry average.


Liquidity ratios1

Acid-Test (Quick)

Current Assets - Inv

Current Liabilities

For Basket Wonders December 31, 2003

Shows a firm’s ability to meet current liabilities with its most liquid assets.

Liquidity Ratios

Balance Sheet Ratios

Liquidity Ratios

$1,195 - $696

$500

= 1.00


Liquidity ratio comparisons1

BWIndustry

1.001.25

1.041.23

1.111.25

Year

2003

2002

2001

Liquidity Ratio Comparisons

Acid-Test Ratio

Ratio is weaker than the industry average.


Summary of the liquidity ratio comparisons

Strong current ratio and weak acid-test ratio indicates a potential problem in the inventories account.

Note that this industry has a relatively high level of inventories.

RatioBWIndustry

Current2.39 2.15

Acid-Test1.00 1.25

Summary of the Liquidity Ratio Comparisons


Current ratio trend analysis comparison

Current Ratio -- Trend Analysis Comparison


Acid test ratio trend analysis comparison

Acid-Test Ratio -- Trend Analysis Comparison


Summary of the liquidity trend analyses

The current ratio for the industry has been rising slowly at the same time the acid-test ratio has been relatively stable.

This indicates that inventories are a significant problem for BW.

Summary of the Liquidity Trend Analyses

  • The current ratio for BW has been rising at the same time the acid-test ratio has been declining.


Financial leverage ratios

Debt-to-Equity

Total Debt

Shareholders’ Equity

For Basket Wonders December 31, 2003

Shows the extent to which the firm is financed by debt.

Financial Leverage Ratios

Balance Sheet Ratios

Financial Leverage

Ratios

$1,030

$1,139

= .90


Financial leverage ratio comparisons

BWIndustry

.90 .90

.88 .90

.81 .89

Year

2003

2002

2001

Financial Leverage Ratio Comparisons

Debt-to-Equity Ratio

BW has average debt utilization

relative to the industry average.


Financial leverage ratios1

Debt-to-Total-Assets

Total Debt

Total Assets

For Basket Wonders December 31, 2003

Shows the percentage of the firm’s assets that are supported by debt financing.

Financial Leverage Ratios

Balance Sheet Ratios

Financial Leverage

Ratios

$1,030

$2,169

= .47


Financial leverage ratio comparisons1

BWIndustry

.47 .47

.47 .47

.45 .47

Year

2003

2002

2001

Financial Leverage Ratio Comparisons

Debt-to-Total-Asset Ratio

BW has average debt utilization

relative to the industry average.


Financial leverage ratios2

Total Capitalization

Total Debt

Total Capitalization

For Basket Wonders December 31, 2003

Shows the relative importance of long-term debt to the long-term financing of the firm.

Financial Leverage Ratios

Balance Sheet Ratios

(i.e., LT-Debt + Equity)

Financial Leverage

Ratios

$1,030

$1,669

= .62


Financial leverage ratio comparisons2

BWIndustry

.62 .60

.62 .61

.67 .62

Year

2003

2002

2001

Financial Leverage Ratio Comparisons

Total Capitalization Ratio

BW has average long-term debt utilization

relative to the industry average.


Coverage ratios

Interest Coverage

EBIT

Interest Charges

For Basket Wonders December 31, 2003

Indicates a firm’s ability to cover interest charges.

Coverage Ratios

Income Statement

Ratios

Coverage Ratios

$210

$59

= 3.56


Coverage ratio comparisons

BW Industry

3.565.19

4.355.02

10.304.66

Year

2003

2002

2001

CoverageRatio Comparisons

Interest Coverage Ratio

BW has below average interest coverage

relative to the industry average.


Coverage ratio trend analysis comparison

Coverage Ratio -- Trend Analysis Comparison


Summary of the coverage trend analysis

This indicates that low earnings (EBIT) may be a potential problem for BW.

Note, we know that debt levels are in line with the industry averages.

Summary of the Coverage Trend Analysis

  • The interest coverage ratio for BW has been falling since 2001. It has been below industry averages for the past two years.


Activity ratios

Receivable Turnover

Annual Net Credit Sales

Receivables

For Basket Wonders December 31, 2003

Indicates quality of receivables and how successful the firm is in its collections.

Activity Ratios

Income Statement /

Balance Sheet

Ratios

(Assume all sales are credit sales.)

Activity Ratios

$2,211

$394

= 5.61


Activity ratios1

Avg Collection Period

Days in the Year

Receivable Turnover

For Basket Wonders December 31, 2003

Average number of days that receivables are outstanding.

(or RT in days)

Activity Ratios

Income Statement /

Balance Sheet

Ratios

Activity Ratios

365

5.61

= 65 days


Activity ratio comparisons

BWIndustry

65.065.7

71.166.3

83.669.2

Year

2003

2002

2001

ActivityRatio Comparisons

Average Collection Period

BW has improved the average collection

period to that of the industry average.


Activity ratios2

Payable Turnover (PT)

Annual Credit Purchases

Accounts Payable

For Basket Wonders December 31, 2003

Indicates the promptness of payment to suppliers by the firm.

Activity Ratios

Income Statement /

Balance Sheet

Ratios

(Assume annual credit

purchases = $1,551.)

Activity Ratios

$1551

$94

= 16.5


Activity ratios3

PT in Days

Days in the Year

Payable Turnover

For Basket Wonders December 31, 2003

Average number of days that payables are outstanding.

Activity Ratios

Income Statement /

Balance Sheet

Ratios

Activity Ratios

365

16.5

= 22.1 days


Activity ratio comparisons1

BWIndustry

22.146.7

25.451.1

43.548.5

Year

2003

2002

2001

ActivityRatio Comparisons

Payable Turnover in Days

BW has improved the PT in Days.

Is this good?


Activity ratios4

Inventory Turnover

Cost of Goods Sold

Inventory

For Basket Wonders December 31, 2003

Indicates the effectiveness of the inventory management practices of the firm.

Activity Ratios

Income Statement /

Balance Sheet

Ratios

Activity Ratios

$1,599

$696

= 2.30


Activity ratio comparisons2

BWIndustry

2.303.45

2.443.76

2.643.69

Year

2003

2002

2001

ActivityRatio Comparisons

Inventory Turnover Ratio

BW has a very poor inventory turnover ratio.


Inventory turnover ratio trend analysis comparison

Inventory Turnover Ratio --Trend Analysis Comparison


Activity ratios5

Total Asset Turnover

Net Sales

Total Assets

For Basket Wonders December 31, 2003

Indicates the overall effectiveness of the firm in utilizing its assets to generate sales.

Activity Ratios

Income Statement /

Balance Sheet

Ratios

Activity Ratios

$2,211

$2,169

= 1.02


Activity ratio comparisons3

BWIndustry

1.021.17

1.031.14

1.011.13

Year

2003

2002

2001

ActivityRatio Comparisons

Total Asset Turnover Ratio

BW has a weak total asset turnover ratio.

Why is this ratio considered weak?


Profitability ratios

Gross Profit Margin

Gross Profit

Net Sales

For Basket Wonders December 31, 2003

Indicates the efficiency of operations and firm pricing policies.

Profitability Ratios

Income Statement /

Balance Sheet

Ratios

Profitability Ratios

$612

$2,211

= .277


Profitability ratio comparisons

BWIndustry

27.7%31.1%

28.730.8

31.327.6

Year

2003

2002

2001

ProfitabilityRatio Comparisons

Gross Profit Margin

BW has a weak Gross Profit Margin.


Gross profit margin trend analysis comparison

Gross Profit Margin --Trend Analysis Comparison


Profitability ratios1

Net Profit Margin

Net Profit after Taxes

Net Sales

For Basket Wonders December 31, 2003

Indicates the firm’s profitability after taking account of all expenses and income taxes.

Profitability Ratios

Income Statement /

Balance Sheet

Ratios

Profitability Ratios

$91

$2,211

= .041


Profitability ratio comparisons1

BWIndustry

4.1%8.2%

4.98.1

9.07.6

Year

2003

2002

2001

Profitability Ratio Comparisons

Net Profit Margin

BW has a poor Net Profit Margin.


Net profit margin trend analysis comparison

Net Profit Margin --Trend Analysis Comparison


Profitability ratios2

Return on Investment

Net Profit after Taxes

Total Assets

For Basket Wonders December 31, 2003

Indicates the profitability on the assets of the firm (after all expenses and taxes).

Profitability Ratios

Income Statement /

Balance Sheet

Ratios

Profitability Ratios

$91

$2,160

= .042


Profitability ratio comparisons2

BWIndustry

4.2% 9.8%

5.0 9.1

9.110.8

Year

2003

2002

2001

Profitability Ratio Comparisons

Return on Investment

BW has a poor Return on Investment.


Return on investment trend analysis comparison

Return on Investment –Trend Analysis Comparison


Profitability ratios3

Return on Equity

Net Profit after Taxes

Shareholders’ Equity

For Basket Wonders December 31, 2003

Indicates the profitability to the shareholders of the firm (after all expenses and taxes).

Profitability Ratios

Income Statement /

Balance Sheet

Ratios

Profitability Ratios

$91

$1,139

= .08


Profitability ratio comparisons3

BW Industry

8.0%17.9%

9.417.2

16.620.4

Year

2003

2002

2001

Profitability Ratio Comparisons

Return on Equity

BW has a poor Return on Equity.


Return on equity trend analysis comparison

Return on Equity --Trend Analysis Comparison


Return on investment and the du pont approach

ROI2003= .041 x 1.02 =.042or 4.2%

ROIIndustry = .082 x 1.17 =.098or 9.8%

Return on Investment and the Du Pont Approach

Earning Power = Sales profitability X

Asset efficiency

ROI = Net profit margin X

Total asset turnover


Return on equity and the du pont approach

ROE2003 = .041 x 1.02 x 1.90 =.080

ROEIndustry = .082 x 1.17 x 1.88 = .179

Return on Equity and the Du Pont Approach

Return On Equity = Net profit margin X

Total asset turnover X

Equity Multiplier

Total Assets

Equity Multiplier =

Shareholders’ Equity


Summary of the profitability trend analyses

The profitability ratios for BW have ALL been falling since 2001. Each has been below the industry averages for the past three years.

This indicates that COGSandadministrative costsmay both be too high and a potential problem for BW.

Note, this result is consistent with the low interest coverage ratio.

Summary of the Profitability Trend Analyses


Summary of ratio analyses

Inventories are too high.

May be paying off creditors (accounts payable) too soon.

COGS may be too high.

Selling, general, and administrative costs may be too high.

Summary of Ratio Analyses


Common size analysis

Common-size Analysis

An analysis of percentage financial statements where all balance sheet items are divided by total assets and all income statement items are divided by net sales or revenues.


Basket wonders common size balance sheets

Basket Wonders’ Common Size Balance Sheets


Basket wonders common size balance sheets1

Basket Wonders’ Common Size Balance Sheets


Basket wonders common size income statements

Basket Wonders’ Common Size Income Statements


Index analyses

Index Analyses

An analysis of percentage financial statements where all balance sheet or income statement figures for a base year equal 100.0 (percent) and subsequent financial statement items are expressed as percentages of their values in the base year.


Basket wonders indexed balance sheets

Basket Wonders’ Indexed Balance Sheets


Basket wonders indexed balance sheets1

Basket Wonders’ Indexed Balance Sheets


Basket wonders indexed income statements

Basket Wonders’ Indexed Income Statements


  • Login