Financial Statement Analysis - NACM

Financial Accounting

Financial Statement Analysis

Dr. Charles W. Mulford Scheller College of Business Georgia Institute of Technology

Atlanta, GA 30332-0520 (404) 894-4395

cwmulford@

Financial Accounting

C.Mulford: Financial Statement Analysis: 1

Profitability Ratios ? Gross margin ratio ? Operating income ratio ? R&D expense percent ? SGA expense percent ? Net margin ratio ? Effective tax rate ? Return on total assets ? Return on equity ? DuPont Analysis ? Economic value added (EVA)

Financial Analysis Ratio Formula Sheet

Gross profit / sales Sustainable operating income / sales R&D / sales SGA / sales Sustainable net income / sales Income tax provision / Income before taxes Sustainable net income / total assets Sustainable net income / shareholders' equity Net margin ratio X total asset turnover X total assets to equity (Return on total assets% ? Cost of capital%) x Total assets

Liquidity Ratios ? Current ratio ? Quick ratio ? Defensive interval

Current assets / current liabilities Cash + ST investments + accounts receivable / current liabilities Cash + ST investments + accounts receivable / Daily spending on operating expenses and interest

Leverage Ratios ? Total assets to equity ? Total liabilities to equity ? Debt to equity ? Times interest earned ? Altman's Z bankruptcy

? Book value per share

Activity Ratios ? Receivables turnover ? Days receivables ? Inventory turnover ? Days inventory ? Payables turnover ? Days payables ? Cash cycle ? Fixed assets turnover ? Cash cycle ? Days fixed assets ? Total assets turnover ? Days total assets

Cash Flow Ratio ? Net cash margin ? Capital expend. To depreciation

Valuation Ratios ? Earnings per share (EPS) ? Price / earnings ratios (PE) ? Price to book value

Total assets / shareholders' equity Total liabilities / shareholders' equity Debt financing / shareholders' equity EBITDA / interest expense 3.3(EBT/TA)+1.2(WC/TA)+.6(MktEq/BkDebt) 1.4(RE/TA) + 1(Revenue/TA) Common shareholders' equity / number of

shares outstanding

Revenue / accounts receivable 365 / receivables turnover Revenue / inventory 365 / inventory turnover Revenue / accounts payable 365 / payables turnover Days inventory - Days payables + Days receivables Revenue / PP&E Days inventory - Days payables + Days 365 / fixed assets turnover Revenue / total assets 365 / total assets turnover

Operating cash flow / sales Additions to PP&E / depreciation expense

Net income / common shares outstanding Market price / EPS Market price / book value per share

Financial Accounting

C.Mulford: Financial Statement Analysis: 2

Financial Statement Analysis

The financial statements for BGS Technologies are provided below:

BGS Technologies Income Statement Year Ended December 31, 2017

Sales

$ 1,000,000

Cost of goods sold

550,000

Gross profit

450,000

Research and development expense

100,000

Selling, general and admin. expenses

150,000

Operating income

200,000

Other income (expense): Special item ? Lawsuit settlement Special item ? Loss from flood Interest income Interest expense

(125,000) (25,000) 50,000 (25,000)

Income from continuing operations before taxes

75,000

Income tax provision

18,750

Income from continuing operations

56,250

Gain from discontinued operations (net of tax)

110,250

Net Income

$ 166,500

Financial Accounting

C.Mulford: Financial Statement Analysis: 3

BGS Technologies

Balance Sheet

As of December 31, 2017

Assets

Current Assets:

Cash and cash equivalents

$ 25,000

Short-term investments

50,000

Accounts receivable

80,000

Inventory

150,000

Total current assets

Property, Plant & Equipment:

Land

80,000

Buildings

475,000

Equipment, furniture & fixtures

310,000

Less: accumulated depreciation

(320,000)

Net property, plant and equipment

Total Assets

Liabilities and Stockholders' Equity

Current Liabilities:

Accounts payable

$ 55,000

Current portion of long-term debt

20,000

Income taxes payable

10,000

Total current liabilities

Noncurrent Liabilities: Long-term debt

Total liabilities

Stockholders' Equity: Common stock (100,000 shares) Additional paid-in capital Retained earnings

Total stockholders' equity Total Liabilities and Stockholders' Equity

10,000 290,000 315,000

$ 305,000

545,000 $ 850,000

$ 85,000 150,000 235,000

615,000 $ 850,000

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download