Financial Accounting, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780134728520
Author: Robert Kemp, Jeffrey Waybright
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 12, Problem 34AP
Calculating various ratios for analysis (Learning Objectives 2 & 3) 20-25 min.
Comparative financial statement data of Lodgepole Furniture Company follow:
| Lodgepole Furniture Company Income Statement Years Ended December 31, 2018 and 2017 |
||||
| 2018 | 2017 | |||
| Net Sales | $494,000 | $464,000 | ||
| Cost of Goods Sold | 242,000 | 233,000 | ||
| Grass Profit | 252,000 | 231,000 | ||
| Operating Expenses | 135,000 | 140,000 | ||
| Income from Operations | 117,000 | 91,000 | ||
| Interest Expense | 8,000 | 18,000 | ||
| Income Before Income Tax | 109,000 | 73,000 | ||
| Income Tax Expense | 28,000 | 24,000 | ||
| Net Income | $81,000 | $49,000 | ||
| Lodgepole Furniture Company Balance Sheet December 31, 2018 and 2017 (Selected 2016 amounts given for computation of ratios) |
|||||
| 2018 | 2017 | 2016 | |||
| Current Assets: | |||||
| Cash | $98,000 | $102,000 | |||
| Accounts Receivable, Net | 103,000 | 95,000 | $106,000 | ||
| Inventory | 167,000 | 158,000 | 189,000 | ||
| Prepaid Expenses | 32,000 | 18,000 | |||
| Total Current Assets | 400,000 | 373,000 | |||
| Property, Plant, and Equipment, Net | 197,000 | 178,000 | |||
| Total Assets | $597,000 | $551,000 | |||
| Total Current Liabilities | $212,000 | $232,000 | |||
| Long-Term Liabilities | 124,000 | 114,000 | |||
| Total Liabilities | 336,000 | 346,000 | |||
| Common Stockholders’ Equity, No Par | 261,000 | 205,000 | 197,000 | ||
| Total Liabilities and Stockholders’ Equity | $597,000 | $551,000 | |||
Other information follows:
a. Market price of a share of common stock was $50.00 at December 31, 2018. and $33.00 at December 31, 2017.
b. An average of 11,000 common shares were outstanding during 2018 and 8,000 during 2017.
Requirements
1. Compute the following ratios for 2018 and 2017. Round to two decimal places. Assume all sales are on credit.
- a.
Current ratio - b. Inventory turnover
- c. Accounts receivable turnover
- d. Interest coverage ratio
- e. Return on equity
- f. Earnings per share of common stock
- g. Price-earnings ratio
2. Decide (a) whether Lodgepole Furniture Company’s performance improved or deteriorated during 2018 and (b) whether the attractiveness of its common stock as an investment seems to have increased or decreased.
How will what you learned in this problem help you evaluate an investment?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
salamagundi, inc. has the following income statement:
For the year ended December 31, 2021
net sales: $160
Cost of goods sold: $100
gross profit: $60
Operating expenses: $40
Net income: $20
Using vertical analysis, what percentage is assigned to operating expenses?
a. 25%
b. 40%
c. 66.7%
d. 200%
Fill in thr blanks on the table below and show the formulas used for each value
Dayton, Inc.
Annual Income Statement (Values in Millions)
Common
Size
2019
2018
2019
2018
Sales
$ 178,909
$ 187,510
100.0%
100.0%
Cost of Sales
111,631
59.5%
Gross Operating Profit
$ 75,879
40.5%
Selling, General & Admin. Expense
12,900
6.9%
Other Expenses
33,377
17.8%
EBITDA
$ 29,602
15.8%
Depreciation & Amortization
7,944
4.2%
EBIT
$ 21,658
11.6%
Other Income, Net
3,323
1.8%
Earnings Before Interest and Taxes
$ 24,981
13.3%
Interest Expense
293
0.2%
Earnings Before Taxes
$ 24,688
13.2%
Income Taxes
5,184
0.21
tax rate
Net Income Available to Common
$ 19,504
10.4%
Dividends per share
$ 1.15
$ 0.91
EPS…
KORBIN COMPANY
Comparative Income Statements
For Years Ended December 31, 2019, 2018, and 2017
2019
2018
2017
Sales
$
459,716
$
352,180
$
244,400
Cost of goods sold
276,749
223,282
156,416
Gross profit
182,967
128,898
87,984
Selling expenses
65,280
48,601
32,261
Administrative expenses
41,374
30,992
20,285
Total expenses
106,654
79,593
52,546
Income before taxes
76,313
49,305
35,438
Income tax expense
14,194
10,108
7,194
Net income
$
62,119
$
39,197
$
28,244
KORBIN COMPANY
Comparative Balance Sheets
December 31, 2019, 2018, and 2017
2019
2018
2017
Assets
Current assets
$
58,718
$
39,300
$
52,535
Long-term investments
0
500
4,280
Plant assets, net
109,047
99,561
58,646
Total assets
$
167,765
$
139,361
$
115,461
Liabilities and Equity
Current liabilities
$
24,494…
Chapter 12 Solutions
Financial Accounting, Student Value Edition (5th Edition)
Ch. 12 - Prob. 1DQCh. 12 - Which amount is the base amount for vertical...Ch. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - How would you expect a recession to affect asset...Ch. 12 - Prob. 9DQCh. 12 - Prob. 10DQ
Ch. 12 - Prob. 1SCCh. 12 - Prob. 2SCCh. 12 - Prob. 3SCCh. 12 - Prob. 4SCCh. 12 - Prob. 5SCCh. 12 - Prob. 6SCCh. 12 - Prob. 7SCCh. 12 - Prob. 8SCCh. 12 - Prob. 9SCCh. 12 - Prob. 10SCCh. 12 - Prob. 11SCCh. 12 - Prob. 12SCCh. 12 - Prob. 1SECh. 12 - Prob. 2SECh. 12 - Prob. 3SECh. 12 - Prob. 4SECh. 12 - Prob. 5SECh. 12 - Prob. 6SECh. 12 - Prob. 7SECh. 12 - Prob. 8SECh. 12 - Prob. 9SECh. 12 - Prob. 10SECh. 12 - Horizontal analysis(Learning Objective 2)15-20 min...Ch. 12 - Prob. 12AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 14AECh. 12 - Prob. 15AECh. 12 - Prob. 16AECh. 12 - Prob. 17AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 26BECh. 12 - Prob. 27BECh. 12 - Prob. 28BECh. 12 - Prob. 29BECh. 12 - Prob. 30BECh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Current ratio, debt ratio, EPS (Learning Objective...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 35APCh. 12 - Prob. 36APCh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Prob. 39BPCh. 12 - Calculating various ratios for analysis(Learning...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 42BPCh. 12 - Prob. 1CECh. 12 - Prob. 1CPCh. 12 - Prob. 1EIACh. 12 - Prob. 2EIACh. 12 - Prob. 1FACh. 12 - Industry Analysis Purpose: To help you understand...Ch. 12 - Prob. 1SBACh. 12 - Prob. 1WC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Dance School reports the following information Total assets 3,840,000 Profit after tax 130,000 Current liabilities 1,140,000 Non-current liabilities 1,660,000 Current assets - 40% total assets Required: 1. Calculate the following ratios (year-end figures will have to be used because the comparative year figures are not available) (show your workings) a. Liquidity ratio b. Return on equity c. Return on assets d. Debt ratioarrow_forwardRussell Department Stores, Inc. Income Statement Compared with Industry Average Year Ended December 31, 2018 Russell Industry Average Net sales revenue $780,000 100.0 % Cost of goods sold 524,940 65.8 Gross Profit 255,060 34.2 Operating Expenses 162,240 19.7 Operating Income 92,820 14.5 Other Expenses 7,800 0.4 Net Income 85,020 14.1 % MORE INFO: Russell/industry average Total Assets $480,000 100.0 % total Liabilities 327,360 64.7 total Liabilities and Stockholders' Equity $480,000 100.0 % SOLVE for % of total (round total to one decimal place x.x%) Amount Percent of total Net Sales Revenue 780,000 Cost of goods sold 524,940 gross profit 255,060 operating expenses 162240 operating income 92820 other expenses 7800arrow_forwardCASE4: Sally Manufacturing company had sales totaling $40,000,000 in fiscal year 2020. Some ratios for the company are listed below. Use this information to determine the $ value of various income statement and balance sheet accounts as required. Sally Manufacturing Company Year ended December 31, 2020 Gross profit margin 80% Operating profit margin 35% Net profit margin 8% Return on assets 16% Return on equity 20% Total asset turnover 2 Average collection period 62.2 days Calculate values and discuss for the following: Gross profits Cost of goods sold Operating profits Earnings available for common stockholders Total assets Account receivablearrow_forward
- Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Sales $ 2,260 $ 1,979 $ 1,801 $ 1,651 $ 1,540 $ 1,432 $ 1,174 Cost of goods sold 1,625 1,322 1,137 995 925 865 689 Gross profit 635 657 664 656 615 567 485 Operating expenses 483 378 347 256 222 219 182 Net income $ 152 $ 279 $ 317 $ 400 $ 393 $ 348 $ 303 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Assets Cash $ 111 $ 147 $ 153 $ 156 $ 162 $ 160 $ 165 Accounts receivable, net 800 840 760 583 514 487 343 Merchandise inventory 2,893 2,106 1,840 1,551 1,393 1,183 858 Other current assets 74 67 41 74 62 63 33 Long-term investments 0 0 0 228 228 228 228 Plant assets, net 3,541 3,527 3,086 1,740 1,799 1,599 1,373 Total assets $ 7,419 $ 6,687 $ 5,880 $ 4,332 $ 4,158 $ 3,720 $ 3,000 Liabilities and…arrow_forward(Learning Objective 2: Analyze accounts payable turnover) Barnacle Sales, Inc.’s,comparative income statements and balance sheets show the following selected information for2017 and 2018:2018$2,850,000$ 800,000$ 600,000$ 305,0002017$2,700,000$ 600,000$ 400,000$ 255,000Cost of goods sold.......................................................Ending inventory.........................................................Beginning inventory ....................................................Average accounts payable ...........................................Requirements1. Calculate the company’s accounts payable turnover and days’ payable outstanding (DPO)for 2017 and 2018.2. On the basis of this computation alone, has the company’s liquidity position improved ordeteriorated during 2018?arrow_forwardE12-24B Vertical analysis (Learning Objective 2) 15-20 min. Simpson Painting, Inc., requested that you perform a vertical analysis of its balance sheet to determine the component percentages of its assets, liabilities, and stockholders' equity. Round to the nearest tenth of a percent. P. Donnelly, Inc. Comparative Income Statement Years Ended December 31, 2018 and 2017 Revenue Expenses: Cost of Goods Sold Selling and General Expenses Interest Expense Income Tax Expense Total Expenses Net Income 2018 $500,000 $245,000 111,000 10,000 54,700 420,700 $ 79,300 2017 $439,500 $236,000 103,500 6,500 44,400 390,400 $ 49,100arrow_forward
- Selected information from Bigg Company's financial statements follows: Fiscal Year Ended December 31 2019 2018 2017 (in thousands) Gross sales $2,004,719 $1,937,021 $1,835,987 Less: Sales discounts 4,811 4,649 4,406 Less: Sales returns and allowances 2,406 2,324 2,203 Net sales $1,997,502 $1,930,048 $1,829,378 Cost of goods sold 621,463 619,847 660,955 Gross profit $1,376,039 $1,310,201 $1,168,423 Operating expenses 577,369 595,226 583,555 Operating income $798,670 $714,975 $584,868 Other income (expenses) 15,973 (6,070) (8,773) Net income $814,643 $708,905 $576,095 At December 31 2019 2018 2017 (in thousands) Accounts receivable $201,290 $195,427 $182,642 Less: Allowance for doubtful accounts 2,516 2,736 2,192 Net accounts receivable $198,774 $192,691 $180,450 Required: 1. Calculate the following ratios for 2018 and 2019. Round your answers to two decimal places. 2018 2019 a. Gross profit margin 67.88 % 68.89 % b. Operating margin 37.04 39.98 c. Net profit margin х % 36.77 40.78 % d.…arrow_forwardSelected information from Bigg Company's financial statements follows: Fiscal Year Ended December 31 2019 2018(in thousands) 2017 Gross sales $2,004,719 $1,937,021 $1,835,987 Less: Sales discounts 4,811 4,649 4,406 Less: Sales returns and allowances 2,406 2,324 2,203 Net sales $1,997,502 $1,930,048 $1,829,378 Cost of goods sold 621,463 619,847 660,955 Gross profit $1,376,039 $1,310,201 $1,168,423 Operating expenses 577,369 595,226 583,555 Operating income $798,670 $714,975 $584,868 Other income (expenses) 15,973 (6,140) (8,773) Net income $814,643 $708,835 $576,095 At December 31 2019 2018(in thousands) 2017 Accounts receivable $201,290 $195,427 $182,642 Less: Allowance for doubtful accounts 2,516 2,736 2,192 Net accounts receivable $198,774 $192,691 $180,450 Required: 1. Calculate the following ratios for 2018 and 2019. Round your answers…arrow_forwardAn extract from an outdoor equipment company's 2021 financial statements follows: Income statement Year ended December 31, 2021 Year ended December 31, 2020 Sales 27,764 26,982 Net income 1,132 (322) What was the company's profitability ratio for 2021? O A. 13.7% OB. 8.8% O C. 4.08% O D. 7.9%arrow_forward
- Mac Donald company reported the following on its comparative income statement: 2017 2018 2019 Revenue 9,000 10,000 14,000 Cost of goods sold 6,000 4,000 9,000 Prepare a horizontal analysis of revenue , cost of goods sold and gross profitarrow_forwardE5-27 Computing the gross profit percentage Cauy Cookies earned net sales revenue of $66,000,000 in 2018. Cost of goods sold was 39 600.000, and net income reached $7,000,000, the company's highest ever. Compute the company's gross profit percentage for 2018.arrow_forwardSelected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Sales $ 2,318 $ 2,030 $ 1,847 $ 1,693 $ 1,580 $ 1,469 $ 1,204 Cost of goods sold 1,667 1,356 1,167 1,021 949 887 707 Gross profit 651 674 680 672 631 582 497 Operating expenses 497 389 356 263 228 225 187 Net income $ 154 $ 285 $ 324 $ 409 $ 403 $ 357 $ 310 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021–2015 ($ thousands) 2021 2020 2019 2018 2017 2016 2015 Assets Cash $ 89 $ 118 $ 122 $ 125 $ 130 $ 128 $ 132 Accounts receivable, net 640 672 608 467 411 389 275 Merchandise inventory 2,315 1,685 1,472 1,241 1,114 946 686 Other…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Consolidated financial statements; Author: The Finance Storyteller;https://www.youtube.com/watch?v=DTFD912ZJQg;License: Standard Youtube License