Prepared by: C. Douglas Cloud
Professor Emeritus of Accounting
Pepperdine University
Reeve Warren Duchac
PRINCIPLES OF FINANCIAL ACCOUNTING
PRINCIPLES OF ACCOUNTING
ACCOUNTING PRINCIPLES
Using excel for Success
12e
24e
2e
Prepared by: C. Douglas Cloud
Professor Emeritus of Accounting
Pepperdine University
Reeve Warren Duchac
PRINCIPLES OF FINANCIAL ACCOUNTING
PRINCIPLES OF ACCOUNTING
ACCOUNTING PRINCIPLES
Using excel for Success
12e
24e
2e
LO 1
LO 1
= 24.0%
= 37.5%
LO 1
Horizontal Analysis
LO 1
LO 1
= 48.3%
LO 1
= 12.8%
LO 2
LO 2
LO 2
Working Capital = Current Assets – Current Liabilities
LO 2
Current assets $550,000 $533,000
Current liabilities $210,000 $243,000
Current ratio 2.6 2.2
Quick assets are cash and other assets that can be easily converted to cash.
Quick ratio 1.3 1.0
Quick assets:
Cash $ 90,500 $ 64,700
Temporary Investments 75,000 60,000
Accounts receivable (net) 115,000 120,000
Total quick assets $280,500 $244,700
Current liabilities $210,000 $243,000
LO 2
Net sales $1,498,000 $1,200,000
Accounts receivable (net):
Beginning of year $ 120,000 $ 140,000
End of year 115,000 120,000
Total $ 235,000 $ 260,000
Average (Total ÷ 2) $ 117,500 $ 130,000
2012 2011
Accounts Receivable Turnover
LO 2
The accounts receivable turnover for Lincoln Company is computed below.
LO 2
The number of days’ sales in receivables for Lincoln Company is computed below.
LO 2
2012 2011
Cost of goods sold $1,043,000 $820,000
Inventories:
Beginning of year $ 283,000 $311,000
End of year 264,000 283,000
Total $ 547,000 $594,000
Average (Total ÷ 2) $ 273,500 $297,000
Lincoln’s inventory balance at the beginning of 2011 is $311,000.
$547,000 ÷ 2
$594,000 ÷ 2
2012 2011
(continued)
Number of Days’ Sales in Inventory
The number of days’ sales in inventory for Lincoln Company is computed below.
$1,043,000 ÷ 365
$820,000 ÷ 365
Number of days’ sales in inventory 95.7 132.2
LO 2
To illustrate, the ratio of fixed assets to long-term liabilities for Lincoln Company is computed below.
LO 2
The ratio of liabilities to stockholders’ equity for Lincoln Company is computed below.
LO 2
Number of times interest
charges earned 28.1 12.2
2012 2011
Income before income tax $162,500 $134,600
Add interest expense 6,000 12,000
Amount available to meet
interest charges $168,500 $146,600
LO 3
LO 3
The ratio of net sales to assets for Lincoln Company is computed below.
(continued)
The ratio of net sales to assets for Lincoln Company is computed below.
Ratio of net sales to assets 1.4 1.2
LO 3
This ratio for Lincoln Company is computed below. Total assets are $1,187,500 at the beginning of 2011.
LO 3
The rate for Lincoln Company is computed below. Total stockholders’ equity is $750,000 at the beginning of 2011.
LO 3
LO 3
(continued)
Rate Earned on Common Stockholders’ Equity
LO 3
2012 2011
Net income $91,000 $76,500
Less preferred dividends 9,000 9,000
Total $82,000 $67,500
Shares of common stock 50,000 50,000
EPS for Lincoln Company is computed below.
LO 3
Price-Earnings Ratio
The P/E ratio for Lincoln Company is computed below.
LO 3
(continued)
LO 3
The dividend yield for Lincoln Company is computed below.
LO 4
(continued)
LO 4
LO 4
Appendix
Appendix
Appendix
Appendix
Если не удалось найти и скачать презентацию, Вы можете заказать его на нашем сайте. Мы постараемся найти нужный Вам материал и отправим по электронной почте. Не стесняйтесь обращаться к нам, если у вас возникли вопросы или пожелания:
Email: Нажмите что бы посмотреть