Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
2016 2015
Amount Amount Amount Percent
Sales 6,750,000$ 6,000,000$
Cost of goods sold 2,480,000 2,000,000
Gross profit 4,270,000$ 4,000,000$
Selling expenses 1,260,000$ 1,000,000$
Administrative expenses 625,000 500,000
Total operating expenses 1,885,000$ 1,500,000$
Income from operations 2,385,000$ 2,500,000$
Expenses and other:
Other income 110,000 100,000
Income before income tax 2,495,000$ 2,600,000$
Income tax expense 60,000 50,000
Net income 2,435,000$ 2,550,000$
2.
Increase (Decrease)
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
CLAPTON COMPANY
Comparative Income Statement
For the Years Ended December 31, 2016 and 2015
Score:
Key Code:
Instructions
Problem 17-1A
Name:
Section:
0%
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
2016 2015
Amount Amount Amount Percent
Sales 6,750,000$ 6,000,000$ 750,000$ 12.5%
Cost of goods sold 2,480,000 2,000,000 480,000 24.0%
Gross profit 4,270,000$ 4,000,000$ 270,000$ 6.8%
Selling expenses 1,260,000$ 1,000,000$ 260,000$ 26.0%
2.
Problem 17-1A
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Net income has declined from 2015 to 2016. Sales have increased by 12.5%; however, cost of goods sold
For the Years Ended December 31, 2016 and 2015
CLAPTON COMPANY
Comparative Income Statement
Increase (Decrease)
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
2016 2015
Amount Amount Amount Percent
Sales 910,000$ 700,000$
Cost of goods sold 441,000 350,000
Gross profit 469,000$ 350,000$
Selling expenses 139,150$ 115,000$
Administrative expenses 99,450 85,000
Total operating expenses 238,600$ 200,000$
Income from operations 230,400$ 150,000$
Expenses and other:
Other income 65,000 50,000
Income before income tax 295,400$ 200,000$
Income tax expense 65,000 50,000
Net income 230,400$ 150,000$
2.
Increase (Decrease)
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
MACKLIN INC.
Comparative Income Statement
For the Years Ended December 31, 2016 and 2015
Score:
Key Code:
Instructions
Problem 17-1B
Name:
Section:
0%
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
2016 2015
Amount Amount Amount Percent
Sales 910,000$ 700,000$ 210,000$ 30.0%
Cost of goods sold 441,000 350,000 91,000 26.0%
Gross profit 469,000$ 350,000$ 119,000$ 34.0%
Selling expenses 139,150$ 115,000$ 24,150$ 21.0%
2.
Problem 17-1B
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
The profitability has significantly improved. Sales have increased by 30% over the 2015 base year.
However, cost of goods sold, selling expenses, and administrative expenses grew at a slower rate.
For the Years Ended December 31, 2016 and 2015
MACKLIN INC.
Comparative Income Statement
Increase (Decrease)
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
Amount Percent Amount Percent
Sales 820,000$ 600,000$
Cost of goods sold 311,600 240,000
Gross profit 508,400$ 360,000$
Selling expenses 164,000$ 108,000$
Administrative expenses 57,400 54,000
Total operating expenses 221,400$ 162,000$
Income from operations 287,000$ 198,000$
Other income 65,600 48,000
Income before income tax 352,600$ 246,000$
Income tax 246,000 180,000
Net income 106,600$ 66,000$
2.
2016
2015
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
INDIGO COMPANY
Comparative Income Statement
For the Years Ended December 31, 2016 and 2015
Score:
Key Code:
Instructions
Problem 17-2A
Name:
Section:
0%
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
Amount Percent Amount Percent
Sales 820,000$ 100.0% 600,000$ 100.0%
Cost of goods sold 311,600 38.0% 240,000 40.0%
Gross profit 508,400$ 62.0% 360,000$ 60.0%
Income before income tax 352,600$ 43.0% 246,000$ 41.0%
Income tax 246,000 30.0% 180,000 30.0%
2.
Problem 17-2A
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
The vertical analysis indicates that the costs other than selling expenses (cost of goods sold and
For the Years Ended December 31, 2016 and 2015
INDIGO COMPANY
Comparative Income Statement
2016
2015
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
Amount Percent Amount Percent
Sales 1,300,000$ 1,180,000$
Cost of goods sold 682,500 613,600
Gross profit 617,500$ 566,400$
Selling expenses 260,000$ 188,800$
Administrative expenses 169,000 177,000
Total operating expenses 429,000$ 365,800$
Income from operations 188,500$ 200,600$
Other income 78,000 70,800
Income before income tax 266,500$ 271,400$
Income tax 117,000 106,200
Net income 149,500$ 165,200$
2.
2016
2015
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
FIELDER INDUSTRIES INC.
Comparative Income Statement
For the Years Ended December 31, 2016 and 2015
Score:
Key Code:
Instructions
Problem 17-2B
Name:
Section:
0%
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
Amount Percent Amount Percent
Sales 1,300,000$ 100.0% 1,180,000$ 100.0%
Cost of goods sold 682,500 52.5% 613,600 52.0%
Gross profit 617,500$ 47.5% 566,400$ 48.0%
2.
Problem 17-2B
Name:
Solution
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
The net income as a percent of sales has declined. All the costs and expenses, other than selling
expenses, have maintained their approximate cost as a percent of sales relationship between 2015 and
For the Years Ended December 31, 2016 and 2015
FIELDER INDUSTRIES INC.
Comparative Income Statement
2016
2015
An asterisk (*) will appear to the right of an incorrect entry.
1.
a. Working Capital = Current Assets -Current Liabilities
=
Working Capital =
b. Current Assets
Current Liabilities
Current Ratio =
Quick Assets
Current Liabilities
Quick Ratio =
2. Current Quick Current Working Current Quick
Transaction Assets Assets Liabilities Capital Ratio Ratio
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
0%
Problem 17-3A
Name:
Section:
=
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Key Code:
Instructions
Current Ratio
=
=
c.
Quick Ratio
=
An asterisk (*) will appear to the right of an incorrect entry.
1.
a. Working Capital = Current Assets -Current Liabilities
= $1,650,000 $750,000
Working Capital = $900,000
b. Current Assets
Current Liabilities
$1,650,000
$750,000
2. Current Quick Current Working Current Quick
Transaction Assets Assets Liabilities Capital Ratio Ratio
a. 1,650,000$ 900,000$ 750,000$ 900,000$ 2.2 1.2
b. 1,525,000 775,000 625,000 900,000 2.4 1.2
c. 1,760,000 900,000 860,000 900,000 2.0 1.0
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Current Ratio
=
Problem 17-3A
Name:
Solution
Section:
=
ON
An asterisk (*) will appear to the right of an incorrect entry.
1.
a. Working Capital = Current Assets -Current Liabilities
=
Working Capital =
b. Current Assets
Current Liabilities
Current Ratio =
Quick Assets
Current Liabilities
Quick Ratio =
2. Current Quick Current Working Current Quick
Transaction Assets Assets Liabilities Capital Ratio Ratio
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
=
Current Ratio
=
=
Key Code:
Instructions
0%
c.
Quick Ratio
=
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 17-3B
Name:
Section:
Score:
An asterisk (*) will appear to the right of an incorrect entry.
1.
a. Working Capital = Current Assets -Current Liabilities
= $3,200,000 $2,000,000
b. Current Assets
Current Liabilities
$3,200,000
Quick Assets
Current Liabilities
$2,200,000
2. Current Quick Current Working Current Quick
Transaction Assets Assets Liabilities Capital Ratio Ratio
a. 3,200,000$ 2,200,000$ 2,000,000$ 1,200,000$ 1.6 1.1
b. 2,912,500 1,912,500 1,712,500 1,200,000 1.7 1.1
c. 3,600,000 2,200,000 2,400,000 1,200,000 1.5 0.9
c.
Quick Ratio
=
Problem 17-3B
Name:
Solution
Section:
Score:
Current Ratio
=
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
Current Assets -
Current
Liabilities
=
Calculated Value
1. Working capital:
Ratio Numerator ÷ Denominator =
Calculated Value
2. Current ratio
3. Quick ratio
4. Accounts receivable
turnover
5. Number of days'
sales in receivables
6. Inventory turnover
7. Number of days'
sales in inventory
8. Ratio of fixed assets to
long-term liabilities
9. Ratio of liabilities to
stockholders' equity
10. Number of times
interest charges earned
11. Number of times
preferred dividends earned
12. Ratio of sales to
assets
13. Rate earned on total
assets
14. Rate earned on stock-
holders' equity
0%
Problem 17-4A
Name:
Section:
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Key Code:
Instructions
15. Rate earned on common
stockholders' equity
16. Earnings per share
on common stock
17. Price-earnings ratio
18. Dividends per share
of common stock
19. Dividend yield
An asterisk (*) will appear to the right of an incorrect entry.
Current Assets -
Current
Liabilities
=
Calculated Value
1. Working capital: $1,100,000 $440,000 $660,000
Ratio Numerator ÷ Denominator =
Calculated Value
2. Current ratio 1,100,000$ 440,000$ 2.5
3. Quick ratio 880,000$ 440,000$ 2.0
8. Ratio of fixed assets to
long-term liabilities 1,320,000$ 1,100,000$ 1.2
9. Ratio of liabilities to
stockholders' equity 1,540,000$ 3,230,000$ 0.5
10. Number of times
interest charges earned 446,000$ 66,000$ 6.8
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
Problem 17-4A
Name:
Solution
Section:
15. Rate earned on common
stockholders' equity 285,000$ 2,892,500$ 9.9%
16. Earnings per share
on common stock 285,000$ 10,000 $28.50
An asterisk (*) will appear to the right of an incorrect entry.
Current Assets -
Current
Liabilities
=
Calculated Value
1. Working capital:
Ratio Numerator ÷ Denominator =
Calculated Value
2. Current ratio
3. Quick ratio
4. Accounts receivable
turnover
5. Number of days'
sales in receivables
6. Inventory turnover
7. Number of days'
sales in inventory
8. Ratio of Fixed assets to
long-term liabilities
9. Ratio of liabilities to
stockholders' equity
10. Number of times
interest charges earned
11. Number of times
preferred dividends earned
12. Ratio of sales to
assets
13. Rate earned on total
assets
14. Rate earned on stock-
holders' equity
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Key Code:
Instructions
0%
Problem 17-4B
Name:
Section:
15. Rate earned on common
stockholders' equity
16. Earnings per share
on common stock
17. Price-earnings ratio
18. Dividends per share
of common stock
19. Dividend yield
An asterisk (*) will appear to the right of an incorrect entry.
Current Assets -
Current
Liabilities
=
Calculated Value
1. Working capital: $3,690,000 $900,000 $2,790,000
Ratio Numerator ÷ Denominator =
Calculated Value
2. Current ratio 3,690,000$ 900,000$ 4.1
6. Inventory turnover 5,350,000$ 1,070,000$ 5.0
7. Number of days'
sales in inventory 1,070,000$ 14,658$ 73.0
8. Ratio of fixed assets to
long-term liabilities 3,740,000$ 1,700,000$ 2.2
12. Ratio of sales to
assets 10,000,000$ 6,942,500$ 1.4
Problem 17-4B
Name:
Solution
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
15. Rate earned on common
stockholders' equity 855,000$ 6,277,500$ 13.6%
