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 | |||
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?
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 12 Solutions
EP FINANCIAL ACCOUNTING-MYACCOUNTINGLAB
- 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…arrow_forwardFill 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…arrow_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_forward
- CASE4: 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_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,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_forward
- E12-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_forwardSelected 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_forward
- An 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_forwardMac 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_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
- 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:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)