Working With Financial Statements
Working With Financial Statements
Working With Financial Statements
FINANCIAL
STATEMENTS
STANDARDISED
FINANCIAL STATEMENTS
Common-size balance sheets
Compute all accounts as a percentage of total
assets
Common-size income statements
Compute all line items as a percentage of sales
Standardised statements make it easier
to compare financial information,
particularly as the company grows.
They are also useful for comparing
companies of different sizes, particularly
within the same industry.
3-2
SWAGMAN CAMPING LTD
BALANCE SHEET—TABLE 3.1
3-3
SWAGMAN CAMPING LTD
(CONT.)
COMMON-SIZE BALANCE
SHEET—TABLE 3.2
3-4
SWAGMAN CAMPING LTD
(CONT.)
INCOME STATEMENT—
TABLE 3.3
3-5
SWAGMAN CAMPING LTD
(CONT.)
COMMON-SIZE INCOME
STATEMENT—TABLE 3.4
3-6
RATIO ANALYSIS
Allows for better comparison over time
or between companies
Used both internally and externally
For each ratio, several questions arise:
How is it computed ?
What is the ratio trying to measure
and why is that information important?
What is the unit of measurement?
What might a high or low value be
telling us? How might such values be
misleading?
How could this measure be improved?
3-7
CATEGORIES OF
FINANCIAL RATIOS
Short-term solvency or liquidity
ratios
Long-term solvency or financial
leverage ratios
Asset management or turnover
ratios
Profitability ratios
Market value ratios
3-8
COMMON FINANCIAL
RATIOS
TABLE 3.5
3-9
SHORT-TERM SOLVENCY
OR LIQUIDITY RATIOS SWAGMAN CAMPING LTD
Balance Sheet -2010
ASSETS Liabilities & Owners Equity
Current Assets Current Liabilities
Cash $ 98 Accounts Payable $ 344
Accounts Receivable $ 188 Notes Payable $ 196
Inventory $ 422 Total $ 540
Total $ 708 Long term debt $ 457
Owners' Equity
Common Stock and paid in surplus $ 550
Fixed Assets Retained Earnings $ 2,041
Net Plant & Equipment $ 2,880 Total $ 2,591
Total Asets $ 3,588 Total Liabilties & Owners' Equity $ 3,588
3-10
LONG-TERM SOLVENCY
MEASURES SWAGMAN CAMPING LTD
Balance Sheet -2010
ASSETS Liabilities & Owners Equity
Current Assets Current Liabilities
Cash $ 98 Accounts Payable $ 344
Accounts Receivable $ 188 Notes Payable $ 196
Inventory $ 422 Total $ 540
Total $ 708 Long term debt $ 457
Owners' Equity
Common Stock and paid in surplus $ 550
Fixed Assets Retained Earnings $ 2,041
Net Plant & Equipment $ 2,880 Total $ 2,591
Total Asets $ 3,588 Total Liabilties & Owners' Equity $ 3,588
3-11
LONG-TERM SOLVENCY
MEASURES (CONT.)SWAGMAN CAMPING LTD
Income Statement - 2010
Sales $ 2,311
COGS $ 1,344
Depreciation $ 276
EBIT $ 691
Interest $ 141
Taxable Income $ 550
Taxes $ 165
Net Income $ 385
Dividends $ 143
Addition to RE $ 242
3-12
ASSET MANAGEMENT:
INVENTORY RATIOS SWAGMAN CAMPING LTD
Balance Sheet -2010
SWAGMAN CAMPING LTD
Income Statement - 2010
ASSETS Liabilities & Owners Equity Sales $ 2,311
Current Assets Current Liabilities COGS $ 1,344
Cash $ 98 Accounts Payable $ 344 Depreciation $ 276
Accounts Receivable $ 188 Notes Payable $ 196 EBIT $ 691
Inventory $ 422 Total $ 540 Interest $ 141
Total $ 708 Long term debt $ 457 Taxable Income $ 550
Owners' Equity Taxes $ 165
Common Stock and paid in surplus
$ 550 Net Income $ 385
Fixed Assets Retained Earnings $ 2,041
Net Plant & Equipment $ 2,880 Total $ 2,591 Dividends $ 143
Total Asets $ 3,588 Total Liabilties & Owners' Equity $ 3,588 Addition to RE $ 242
3-13
ASSET MANAGEMENT:
RECEIVABLES RATIOS SWAGMAN CAMPING LTD
Balance Sheet -2010
SWAGMAN CAMPING LTD
Income Statement - 2010
ASSETS Liabilities & Owners Equity Sales $ 2,311
Current Assets Current Liabilities COGS $ 1,344
Cash $ 98 Accounts Payable $ 344 Depreciation $ 276
Accounts Receivable $ 188 Notes Payable $ 196 EBIT $ 691
Inventory $ 422 Total $ 540 Interest $ 141
Total $ 708 Long term debt $ 457 Taxable Income $ 550
Owners' Equity Taxes $ 165
Common Stock and paid in surplus
$ 550 Net Income $ 385
Fixed Assets Retained Earnings $ 2,041
Net Plant & Equipment $ 2,880 Total $ 2,591 Dividends $ 143
Total Asets $ 3,588 Total Liabilties & Owners' Equity $ 3,588 Addition to RE $ 242
3-14
ASSET MANAGEMENT:
ASSET TURNOVER RATIOS
ASSETS
SWAGMAN CAMPING LTD
Balance Sheet -2010
Liabilities & Owners Equity
SWAGMAN CAMPING LTD
Income Statement - 2010
Sales $ 2,311
Current Assets Current Liabilities COGS $ 1,344
Cash $ 98 Accounts Payable $ 344 Depreciation $ 276
Accounts Receivable $ 188 Notes Payable $ 196 EBIT $ 691
Inventory $ 422 Total $ 540 Interest $ 141
Total $ 708 Long term debt $ 457 Taxable Income $ 550
Owners' Equity Taxes $ 165
Common Stock and paid in surplus
$ 550 Net Income $ 385
Fixed Assets Retained Earnings $ 2,041
Net Plant & Equipment $ 2,880 Total $ 2,591 Dividends $ 143
Total Asets $ 3,588 Total Liabilties & Owners' Equity $ 3,588 Addition to RE $ 242
3-15
PROFITABILITY
ASSETS
MEASURES SWAGMAN CAMPING LTD
Balance Sheet -2010
Liabilities & Owners Equity
SWAGMAN CAMPING LTD
Income Statement - 2010
Sales $ 2,311
Current Assets Current Liabilities COGS $ 1,344
Cash $ 98 Accounts Payable $ 344 Depreciation $ 276
Accounts Receivable $ 188 Notes Payable $ 196 EBIT $ 691
Inventory $ 422 Total $ 540 Interest $ 141
Total $ 708 Long term debt $ 457 Taxable Income $ 550
Owners' Equity Taxes $ 165
Common Stock and paid in surplus $ 550 Net Income $ 385
Fixed Assets Retained Earnings $ 2,041
Net Plant & Equipment $ 2,880 Total $ 2,591 Dividends $ 143
Total Asets $ 3,588 Total Liabilties & Owners' Equity $ 3,588 Addition to RE $ 242
3-16
MARKET VALUE
MEASURES
Market price = $88 per share = PPS
Shares outstanding = 35 million
3-17
SWAGMAN RATIOS
3-18
THE DU PONT IDENTITY
Return on equity (ROE) = Net income
(NI)/ Total equity (TE)= Basic formula
Du Pont identity
ROE = Profit margin (PM) * Total asset
turnover (TAT) * Equity multiplier (EM)
PM = Net income / Sales
TAT = Sales / Total assets
EM = Total assets / Total equity
NI Sales TA NI
ROE
Sales TA TE TE
3-19
USING THE DU PONT
IDENTITY
ROE = PM*TAT*EM
Profit margin (PM) is a measure of a
firm’s operating efficiency—how well it
controls costs.
Total asset turnover (TAT) is a measure
of the firm’s asset-use efficiency—how
well it manages its assets.
Equity multiplier (EM) is a measure of
the firm’s financial leverage.
3-20
SWAGMAN—DU PONT
IDENTITY
SWAGMAN CAMPING LT D RECAP
Liquidity Ratios Financial Leverage Ratios
Current Ratio 1.31 Total Debt Ratio 0.28
Quick Ratio 0.53 Debt to Equity 0.39
Cash Ratio 0.18 Equity Multiplier 1.39
Asset Management Ratios Times Interest Earned 4.9
Inventory Turnover 3.20 Cash Coverage 6.9
Days' Sales in Inventory 114 Profitability Measures
Receivables Turnover 12.30 Profit Margin 16.70%
Days' Sales in Receivables 30 ROA 10.73%
Total Asset Turnover 0.64 ROE 14.90%
Capital Intensity Ratio 1.56
Market Value Measures
Market Price $ 88.00
Shares Outstanding 35 m
EPS $ 11.00
PE Ratio 8.0 Book value per share $74.00
Market to Book 1.19
ROE = PM * TAT * EM
PM = 16.7%
TAT = .64
EM = 1.39
3-21
AN EXPANDED DU PONT
ANALYSIS
3-22
AN EXPANDED DU PONT
ANALYSIS
3-23
INTERNAL AND SUSTAINABLE
GROWTH
DIVIDEND PAYOUT AND EARNINGS
RETENTION RATIOS
3-24
INTERNAL AND SUSTAINABLE
GROWTH
DIVIDEND PAYOUT AND EARNINGS
RETENTION RATIOS (CONT.)
SWAGMAN CAMPING LTD SWAGMAN CAMPING LTD
Balance Sheet -2010 Income Statement - 2010
ASSETS Liabilities & Owners Equity Sales $ 2,311
Current Assets Current Liabilities COGS $ 1,344
Cash $ 98 Accounts Payable $ 344 Depreciation $ 276
Accounts Receivable $ 188 Notes Payable $ 196 EBIT $ 691
Inventory $ 422 Total $ 540 Interest $ 141
Total $ 708 Long term debt $ 457 Taxable Income $ 550
Ow ners' Equity Taxes $ 165
Common Stock and paid in surplus $ 550 Net Income $ 385
Fixed Assets Retained Earnings $ 2,041
Net Plant & Equipment $ 2,880 Total $ 2,591 Dividends $ 143
Total Asets $ 3,588 Total Liabilties & Owners' Equity $ 3,588 Addition to RE $ 242
3-25
INTERNAL GROWTH
RATE
The internal growth rate tells us how much the firm can
grow assets using retained earnings (internal financing)
as the only source of financing.
ROA b
Internal Growth Rate
1 - ROA b
.1012 .667
1 .1012 .667
7.23%
3-26
SUSTAINABLE GROWTH
RATE
The sustainable growth rate tells us how much the firm
can grow by using internally generated funds and
issuing debt to maintain a constant debt ratio.
ROE b
Sustainable Growth Rate
1 - ROE b
.149 .63
.1036
1 .149 .63
10.36%
3-27
DETERMINANTS OF
GROWTH
Profit margin—operating efficiency
Total asset turnover—asset use
efficiency
Financial leverage—choice of
optimal debt ratio
Dividend policy—choice of how
much to pay to shareholders versus
reinvesting in the firm
3-28
SUMMARY OF INTERNAL AND
SUSTAINABLE GROWTH
RATES
3-29
USING FINANCIAL INFORMATION—
Internal uses
Performance evaluation—
compensation and comparison
between divisions
Planning for the future—guide in
estimating future cash flows
External uses
Creditors
Suppliers
Customers
Shareholders
3-30
USING FINANCIAL STATEMENT
INFORMATION—
BENCHMARKING
3-31
PROBLEMS WITH
FINANCIAL STATEMENT
ANALYSIS
Conglomerates
No readily available comparables
Global competitors
Different accounting procedures
Different fiscal year ends
Differences in capital structure
Seasonal variations and one-time
events
3-32
QUICK QUIZ
How do you standardise balance sheets and
income statements?
Why is standardisation useful?