Financial Statement Analysis

These pages are designed for students in Intro. to Finance and other elementary Finance courses.

Financial Statement analysis involves using the output of the standard business information system found in all businesses to judge the performance and riskiness at an instance or over time. A business may have other information systems for managers but all business must conform with generally accepted standards with their accounting statements.

There are several steps in the use of Financial Statement Analysis:

  1. Understanding the basic statements
  2. Inherent problems with the system
  3. Use of ratio analysis
  4. Interpreting the analysis
  5. Using the analysis

Basic Financial Statements

Income Statement

INCOME STATEMENT
for the year ending
December 31, 1996
Sales5,011,766
Cost of goods sold 3,758,825
Gross Profit1,252,942
Expenses:
Selling353,300
General and administrative250,025
Depreciation102,000
Miscellaneous65,927
Net Profit481,490

The Income Statement presents a picture of the activity of the firm for the last year and tries to give the reader an impression of whether or not there was an increase in wealth or the value of the firm. Since most of the values shown represent summaries of cash flows during the year there is much to be learned from this statement. Some expenses do not represent cash flows such as depreciation and some very large cash flows from financing and capital improvements are missing from the Income Statement. But it is a good place tostart analyzing the basic day to day operations of the firm. The statement of Cash flows described below is an attempt to provide the missing information.

Find the connection between the Income Statement and the balance sheet! Notice that the net income for the previous year explains the difference in retained earnings between years. Exceptions are shown in the Statement of Retained Earnings.

This connection clearly indicates that Retained Earnings is not a hoard of cash but really only a book entry reflecting cash reinvested in the business in other assets such as Accounts Receivable or Plant and Equipment.

Notice that there are two measure of profit shown, Gross Profit and Net Profit. Gross Profit gives an indication of the level of markup maintained. This can also be viewed as a measure of the amount of competition in the industry.

Balance Sheet

Balance Sheet
12-31-9312-31-9412-31-9512-31-96
ASSETS
Cash400000250000300000175500
Accounts Receivable1050000135000015605001875250
Inventory6100007891501060350146890
Plant and Equipment1240000126000011000001155250
Total Assets3300000364915040208504662890
Liabilities & Capital
Accruals15000075000250000275000
Accounts Payable250000350000425000560550
Notes Payable [current]760000800000800000800000
Mortgage Bonds1000000100000010000001000000
Preferred Stock225000225000225000225000
Common Stock300000300000300000300000
Retained Earnings61500089915010208501502340
Total Lia. & capital3300000364915040208504662890

The Balance Sheet presents a summation of the entries made in the accounting system of a business over a long period of time. The titles on the statement refer to the account name in the bookkeeping system and may not accurately reflect what we might think of as "real" value today. The more short-lived an asset is or the more often it turns over, the more likely the statement value will reflect real value. The bookkeeping value for Plant and Equipment is especially inaccurate for old companies as amounts are added for the cost of equipment purchases and amounts are deducted for deprecation according to arbitrary methods. The balances shown for Preferred Stock and Common Stock and Retained Earnings bear no relationship to reality and should be used with caution. Equity market values should be used instead.

Balance Sheets are shown for several consecutive years to give an impression of the direction of growth and progress. No attempt is made by the company to account for the generally decreasing purchasing power of the currency over time!

Financial Statement Analysis should concentrate on evaluating the current assets and liabilities in proportion to the level of sales and profits shown in the income statement. Analysis or ratios using book values for Plant and Equipment or Equity Capital items should be used with caution and viewed with suspicion!

Statement of Retained Earnings

STATEMENT OF RETAINED EARNINGS
for the year ending
December 31, 1996
Balance of retained earnings, December 31, 1995 1,050,000
Add: 1996 Net Income 350,000
Less Dividends to stockholders120,000
Less Loss on Abandoned Operations100,000
Balance of retained earnings December 31, 19961,280,000

The Statement of Retained Earnings is straightforward and simple and shows the reconcilement of the Retained Earnings account as the result of a year's activities. It purports to show how much the stockholder's equity increased or decreased as a result of the year's activities.

Statement of Cash Flows

Although it may seem strange at first, Financial managers are always more concerned about cash flows than they are about profit. Profit is important in the long run for survival and growth but cash flow problems can be aggravated by the very conditions that lead to enhanced profitability. Running out of cash can cause default and bankruptcy and is a major headache for financial managers. The financial statements can give a view of where the money came from and where the money went throughout the past year.

A two stage process is necessary to analyze cash flows:

  1. Source and use of cash statement
  2. Statement of cash flows for the period.

The source and use of cash statement is prepared by looking at consecutive year balance sheets and the last year's income statement.

Cash Sources and Uses During 1996
12/31/9612/31/95SourcesUses
Cash204020
Accounts Receivable18016020
Inventory27020070
Gross Plt & Equip68060080
Accounts Payable301515
Accruals60555
Notes Payable40355
Long Term Bonds29725542
Common Stock130130
Net Income6262
Depreciation5050
Dividends2929
Totals199199

Notice that when comparing balance sheet accounts, increases in liabilities and decreases in assets are sources of funds and increases in assets and decreases in liabilities are uses of funds. Don't go further until you understand why this works out!

Notice that from the income statement we only need net income and depreciation. Depreciation is a source of funds because income is a source and the accountant subtracted depreciation to get net income. Depreciation is a non-cash expense so the accountant made a mistake, in a financial sense.

Statement of Cash Flows

The statement of cash flows merely takes the information gathered above in the sources and uses statement and uses them to reconcile the change in the cash account from the beginning of the year to the end of the year. Further, this statement classifies the cash flows according to operating activities, long term investing activities, and financing activities. It is like a quick replay of all of the financial manager's cash activities for the year.

Statement of Cash Flows for the Period Ending December 31, 1995
Cash Flows from Operating Activities
Net Income62
Depreciation50
Increase in Accounts payable15
Increase in accruals5
Increase in Accounts receivable(20)
Increase in Inventory(70)
Net cash flow from operations42
Cash flows from long term investingactivities
Purchase of fixed assets(80)
Cash flows from financing activities
Increase in notes payable5
Increase in bonds42
Dividend payment(29)
Net cash flow from financing18
Net change in cash(20)
Cash at beginning of the year40
Cash at the end of the year20

You only really understand these Cash flow statements when you can look at each item in the cells and by observing whether it is positive or negative describe in words what must have happened in the business to cause it. If you cannot do this easily let me know and I will try to have your Accounting credits revoked!

Ratio Analysis

You may be able to discover facts and trends about the risk and profitability of a company and also something about the quality and efficiency of the management by examining the financial statements. This process is called ratio analysis and is not perfect nor does it give definitive answers but it can serve as an early warning or alarm system to alert owners, lenders and managers to general problems. It is very common in everyday use.

There are several steps to implementing and understanding ratio analysis:

  1. Calculating Key ratios from the latest and earlier financial statements.
  2. Gathering industry average ratios
  3. Making the comparisons.
  4. Making recommendations for action.

Calculating key financial ratios

There are four types of ratios:

  1. Liquidity
  2. Leverage
  3. Efficiency
  4. Profitability
Liquidity Ratios

These ratios are the most used. Both creditors and managers need to keep a close watch on the following measures. They predict the ability of the firm topay its bills on time.

Current Ratio

Quick or Acid test

Leverage Ratios

Debt ratio.

Debt to equity ratio

Efficiency Ratios

Average Collection period or number of days sales outstanding in receivables. 360 days is traditionally usedto measure average daily sales.

Inventory Turnover can be based on sales or cost of goods sold, both shown on the income statement. Industry average figures are often shown both ways.

Profitability Ratios

Owners Equity = Common stock = Preferred Stock + Retained Earnings. This number represents the rate of return earned on the book value of the owners investment.

The Price Earnings ratio is astock market oriented measure of profitability and stockholder's expectations.

Use of Financial Ratios

The use of financial ratios involves comparison of one company's values to that of a group of similar companies and the comparison of a company's ratios over time.

Commercial sources of industry data. Convenient printed forms of the data are available at the Weinberg Library Reference Desk. You will need to look upthe company's SIC [Standard Industrial Classification], also available at the same Reference Desk.

These industry averages are made by statistical surveys of companies. The data are stratified according to size of assets and sales in the RMA guide. Since the company you are studying will always have a value that is different from the industry average you will be faced with the question whether the deviation is significant. To help you answer this question the industry sources will also present upper and lower quartile values for each ratio. With this information you can judge whether you company is close to the average or really far away from it. It is not wrong to have an average that is different but it does indicate a need for an explanation.

Using the balance sheet data above and some industry averages:

RATIO ANALYSIS1993199419951996IND LOIND AVGIND HI
Current Ratio1.781.951.982.141.521.661.83
Quick Ratio1.251.311.261.25.981.301.61
Debt Ratio.65.61.62.57.33.51.61
InventoryTurnover9.316.53 4.73.446.017.348.56
ACP395576105455177

It should be quite clear from the above information that the company was close to the industry averages in 1993 but as time has passed it has clearly accumulated too much Inventory and Accounts receivable for the size of its business.

Comments and Suggestions should may be sent togramborw@scranton.edu