978-0078025600 Chapter 13 Excel

subject Type Homework Help
subject Pages 7
subject Words 732
subject Authors Barbara Chiappetta, John Wild, Ken Shaw

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
Assets Liabilities Ratio
52,390$ 22,800$ 2.3 «- Correct!
37,924 19,960 1.9 «- Correct!
51,748 20,300 2.5 «- Correct!
2014 2013 2012
100.00% 100.00% 100.00%
51.08% 62.50% 55.36%
48.92% 37.50% 44.64%
18.54% 13.80% 18.27%
9.13% 8.80% 8.20%
27.67% 22.60% 26.47%
21.25% 14.90% 18.17%
7.35% 3.05% 5.64%
13.90% 11.85% 12.53%
Correct! Correct! Correct!
2014 2013 2012
101.24% 73.29% 100.00%
Correct! Correct! Correct!
0.00% 12.66% 100.00%
Correct! Correct! Correct!
166.67% 160.00% 100.00%
Correct! Correct! Correct!
131.71% 116.19% 100.00%
Correct! Correct! Correct!
112.32% 98.33% 100.00%
Correct! Correct! Correct!
120.00% 120.00% 100.00%
Correct! Correct! Correct!
150.00% 150.00% 100.00%
Correct! Correct! Correct!
165.28% 113.83% 100.00%
Correct! Correct! Correct!
131.71% 116.19% 100.00%
Correct! Correct! Correct!
Total liabilities and equity
Total assets
Liabilities & Equity
Current liabilities
Balance Sheet Data in Trend Percentages
December 31, 2014, 2013, and 2012
Problem 13-01A
McGraw-Hill/Irwin
Instructor
Retained earnings
Total expenses
Income before taxes
Common stock
Other paid-in capital
Income taxes
Net income
Assets
Current assets
Long-term investments
Plant assets, net
Common-Size Comparative Income Statements
KORBIN COMPANY
Cost of goods sold
Gross profit
Selling expenses
Administrative expenses
Current Ratios
KORBIN COMPANY
KORBIN COMPANY
December 31, 2014:
December 31, 2013:
December 31, 2012:
Sales
For Years Ended December 31, 2014, 2013, and 2012
page-pf2
Part 4: Comment on any significant relations revealed
by the ratios and percents computed.
Significant relations revealed: Korbin's selling expenses and income taxes consumed smaller
portions of each sales dollar in 2013 than 2012. However, cost of goods sold and
administrative expenses consumed a larger portion in 2013. Therefore, income as a percent of
sales declined from 2012 to 2013. In 2014, selling expenses, administrative expenses, and
income tax took a greater portion of each sales dollar while the gross profit portion improved.
The reduction in cost of goods sold allowed income as a percent of sales to increase from 2013
to 2014. Korbin expanded its plant assets in 2013, financing the expansion through the sale of
long-term investments, through a reduction in working capital (the current ratio decreased from
2.5 to 1to 1.9 to 1), and perhaps through the sale of a small amount of stock. As to the stock
increase, it is not possible to tell from these two statements whether the company sold shares
or declared a stock dividend. In either case, the increase in retained earnings during 2013
indicates that net income was larger than the reductions from cash (and perhaps stock)
dividends. In 2014, working capital increased, the current ratio increased from 1.9-to-1 to 2.3-
to-1, and cash dividends were paid.
page-pf3
2014 2013 2012
555,000$ 340,000$ 278,000$
283,500 212,500 153,900
271,500 127,500 124,100
102,900 46,920 50,800
50,668 29,920 22,800
153,568 76,840 73,600
117,932 50,660 50,500
40,800 10,370 15,670
77,132$ 40,290$ 34,830$
2014 2013 2012
52,390$ 37,924$ 51,748$
- 500 3,950
100,000 96,000 60,000
152,390$ 134,424$ 115,698$
Current assets
Long-term investments
Plant assets, net
Total assets
Administrative expenses
Total expenses
Income before taxes
Income taxes
Net income
Assets
December 31, 2014, 2013, and 2012
Comparative Balance Sheets
KORBIN COMPANY
For Years Ended December 31, 2014, 2013, and 2012
Comparative Income Statements
KORBIN COMPANY
Sales
Cost of goods sold
Gross profit
Selling expenses
page-pf4
Student Name:
Class:
Current Quick Current Current Acid-Test Working
Transaction Assets Assets Liabilities Ratio Ratio Capital
Beginning 700,000$ 308,000$ 280,000$ 2.50 1.10 420,000
May 2 50,000 50,000 Correct! Correct! Correct!
Balances 750,000 308,000 330,000 2.27 0.93 420,000
May 8 110,000 110,000 Correct! Correct! Correct!
(55,000)
Balances 805,000 418,000 330,000 2.44 1.27 475,000
May 10 20,000 20,000 Correct! Correct! Correct!
(20,000) (20,000)
Balances 805,000 418,000 330,000 2.44 1.27 475,000
May 15 (22,000) (22,000) (22,000) Correct! Correct! Correct!
Balances 783,000 396,000 308,000 2.54 1.29 475,000
May 17 - - Correct! Correct! Correct!
Balances 783,000 396,000 308,000 2.54 1.29 475,000
May 22 50,000 Correct! Correct! Correct!
Balances 783,000 396,000 358,000 2.19 1.11 425,000
May 26 (50,000) (50,000) (50,000) Correct! Correct! Correct!
Balances 733,000 346,000 308,000 2.38 1.12 425,000
May 27 100,000 100,000 100,000 Correct! Correct! Correct!
Balances 833,000 446,000 408,000 2.04 1.09 425,000
May 28 80,000 80,000 Correct! Correct! Correct!
Balances 913,000 526,000 408,000 2.24 1.29 505,000
May 29 (180,000) (180,000) Correct! Correct! Correct!
Balances 733,000$ 346,000$ 408,000$ 1.80 0.85 325,000
Correct! Correct! Correct! Correct! Correct! Correct!
Instructor
Ratios and Working Capital
PLUM CORPORATION
Problem 13-03A
McGraw-Hill/Irwin
page-pf5
700,000$
2.50
1.10
May 2 50,000$
May 8 55,000$
110,000$
May 10 20,000$
May 15 22,000$
May 17 5,000$
May 22 1$
50,000
May 26 ?
May 27 100,000$
May 28 80,000$
May 29 180,000$
May 22: 2.19
1.11
May 29: 1.80
325,000$
Given Data P13-03A:
Current ratio
Acid-test
Current ratio
Working capital
Check figures:
Shares of outstanding common stock
Paid dividend
Borrowed on 30-day, 10% note
Borrowed on long-term secured note
Sold merchandise that cost
Received from sale of merchandise
Collected account receivable
Paid account payable
Wrote off bad debt
Declared per share cash dividend
PLUM CORPORATION
Current assets, beginning of May
Current ratio, beginning of May
Acid-test ratio, beginning of May
Purchased merchandise on credit
Bought machinery
page-pf6
Student Name:
Class:
3.6 to 1
Correct!
2.2 to 1
Correct!
27.4 days
Correct!
7.3 times
Correct!
39.5 days
Correct!
0.57 to 1
Correct!
12.9 times
Correct!
6.5%
Correct!
2.1 times
Correct!
13.5%
Correct!
21.9%
Correct!
(11) Return on common stockholders' equity:
(8) Profit margin ratio:
(9) Total asset turnover:
(10) Return on total assets:
(5) Days' sales in inventory:
(6) Debt-to-equity ratio:
(7) Times interest earned:
(2) Acid-test ratio:
(3) Days' sales uncollected:
(4) Inventory turnover:
Ratios
CABOT CORPORATION
(1) Current ratio:
Problem 13-04A
McGraw-Hill/Irwin
Instructor
page-pf7
448,600$
297,250
151,350
98,600
4,100
48,650
19,598
29,052$
Given Data P13-04A:
Operating expenses
Interest expense
Income before taxes
Income taxes
Net income
Balance Sheet
CABOT CORPORATION
Gross profit
For Year Ended December 31, 2013
Income Statement
CABOT CORPORATION
Sales
Cost of goods sold

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.