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 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?
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
Financial Accounting, Student Value Edition (5th Edition)
- 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_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_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_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_forwardCalculate the profit margin (net income or net profit/total sales)for Rock Castle construction for this fiscal year. What’s the percentagearrow_forward
- First question/ you have the following data about Basra Trading Company for its first year ending on 12/31/2019 1- Sales revenue 325,000 dinars 2- Total purchases 225,000 dinars 3- Discount earned at 5% of total purchases 1- Allowed discount of 10% Of sales revenue E- Purchase expenses represent 8% of total purchases - Gross profit equals 30% of net sales - Marketing expenses 17,500 dinars, and administrative expenses 22,500 dinars, knowing that it has 50,000 boxes, 100,000 banks, 175,000 cars - 175,000 dallons, 50,000 notes receivable , 55,000 payment papers, 119,250 capital required to prepare the income statement and the financial position of the Basra Trading Company for the year 2019arrow_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_forwardAnswer the whole pagearrow_forward
- i need help finding the current ratioarrow_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
- 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