Horngren's Accounting - Acc122: Accounting Principles 1- Third Custom Edition For Borough Of Manhattan Community College
1st Edition
ISBN: 9781323410530
Author: Pearson
Publisher: PEARSON C
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 17, Problem P17.27APGA
Using ratios to evaluate a stock investment
Learning Objective 4
1. 2018: e. 48.9%
Comparative financial statement data of Sanfield, Inc. follow:
SANFIELD, INC. | ||||
Comparative Income Statement | ||||
Year Ended December 31, 2018 and 2017 | ||||
2018 | 2017 | |||
Net Sales Revenue | $462,000 | $430,000 | ||
Cost of Goods Sold | 236,000 | 213,000 | ||
Gross Profit | 226,000 | 217,000 | ||
Operating Expenses | 135,000 | 133,000 | ||
Income From Operations | 91,000 | 84,000 | ||
Interest Expenses | 8,000 | 12,000 | ||
Income Before Income Tax | 83,000 | 72,000 | ||
Income Tax Expense | 18,000 | 22,000 | ||
Net Income | $65,000 | $50,000 |
SANFIELD, INC. | ||||||
Comparitive Income Statement | ||||||
Year Ended December 31, 2018 and 2017 | ||||||
2018 | 2017 | 2016* | ||||
Assets | ||||||
Current Assets: | ||||||
Cash | $99,000 | $97,000 | ||||
109,000 | 117,000 | $100,000 | ||||
Merchandise Inventory | 142,000 | 164,000 | $207,000 | |||
Prepaid Expenses | 15,000 | 5,000 | ||||
Total Current Assets | 365,000 | 383,000 | ||||
Property, Plant, and, Equipment, Net | 215,000 | 177,000 | ||||
Total Assets | $580,000 | $560,000 | $599,000 | |||
Liabilities | ||||||
Total Current Liabilities | $222,000 | $244,000 | ||||
Long-Term Liabilities | 113,000 | 92,000 | ||||
Total Liabilities | 335,000 | 336,000 | ||||
92,000 | 92,000 | |||||
Common Stockholders' Equity, no par | 153,000 | 132,000 | 85,000 | |||
Total Liabilities and Stockholders' Equity | $580,000 | $560,000 |
- Market price of Sanfield’s common stock: $51.48 at December 31, 2016, and $37.08 at December 31,2017.
- Common shares outstanding: 16,000 on December 31, 2018 and 15,000 on December 31, 2017 and 2016.
- All sales are on credit.
Requirements
1. Compute the following ratios for 2018 and 2017:
Current ratio - Cash ratio
- Times-interest-earned ratio
- Inventory turnover
- Gross profit percentage
- Debt to equity ratio
Rate of return on common stockholders' equity- Earnings per share of common stock
- Price/earnings ratio
2. Decide (a) whether Sanfield’s ability to pay debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Using ratios to evaluate a stock investment
Comparative financial statement data of Garfield Inc. follow:
Market price of Garfield’s common stock:$69.36 at December 31 2018 and $38.04 at December 31, 2017.
Common shares outstanding 14, 000 on December 31, 2018 and 12,000 on December 31 2017 and 2016.
All sales are on credit.
Requirements
Compute the following ratios tor 2018 and 2017:
a. current ratio
b. Cash ratio
c. Times-interest-earned ratio
d. Inventory turnover
e. Gross profit percentage
f. Debt to equity ratio
g. Rate of return on common stockholder’s equity
h. Earnings per share of common stock
i. Price/earnings ratio
2. Decide (a) whether Garfield’s ability to pat debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.
Not Graded
Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56
Basic earning per share ratio= (net income- prefered dividends)/weighted average common shares outstanding
(21,331-0)/500= $42.66 (2020 year)
(11,588-0)/494= $23.46 (2019 year)
$5.19 (Walmart 2020 year) (competitor)
Write financial analysis report.
Chapter 17 Solutions
Horngren's Accounting - Acc122: Accounting Principles 1- Third Custom Edition For Borough Of Manhattan Community College
Ch. 17 - Prob. 1QCCh. 17 - Prob. 2QCCh. 17 - Prob. 3QCCh. 17 - Prob. 4QCCh. 17 - Prob. 5QCCh. 17 - Prob. 6QCCh. 17 - Prob. 7QCCh. 17 - Prob. 8QCCh. 17 - Prob. 9QCCh. 17 - Prob. 10QC
Ch. 17 - Prob. 1RQCh. 17 - Prob. 2RQCh. 17 - Prob. 3RQCh. 17 - Prob. 4RQCh. 17 - Prob. 5RQCh. 17 - Prob. 6RQCh. 17 - What is benchmarking, and what are the two main...Ch. 17 - Prob. 8RQCh. 17 - Prob. 9RQCh. 17 - Prob. 10RQCh. 17 - Prob. 11RQCh. 17 - Prob. 12RQCh. 17 - Prob. 13RQCh. 17 - Prob. S17.1SECh. 17 - Prob. S17.2SECh. 17 - Prob. S17.3SECh. 17 - Prob. S17.4SECh. 17 - Prob. S17.5SECh. 17 - Prob. S17.6SECh. 17 - Computing inventory, gross profit, and receivables...Ch. 17 - Prob. S17.8SECh. 17 - Measuring profitability Learning Objective 4...Ch. 17 - Prob. S17.10SECh. 17 - Prob. S17.11SECh. 17 - Prob. S17.12SECh. 17 - Prob. E17.13ECh. 17 - Prob. E17.14ECh. 17 - Prob. E17.15ECh. 17 - Prob. E17.16ECh. 17 - Prob. E17.17ECh. 17 - Prob. E17.18ECh. 17 - Prob. E17.19ECh. 17 - Prob. E17.20ECh. 17 - Prob. E17.21ECh. 17 - Prob. E17.22ECh. 17 - Prob. P17.23APGACh. 17 - Prob. P17.24APGACh. 17 - Prob. P17.25APGACh. 17 - Prob. P17.26APGACh. 17 - Using ratios to evaluate a stock investment...Ch. 17 - Prob. P17.28APGACh. 17 - Prob. P17.29APGACh. 17 - Prob. P17.30BPGBCh. 17 - Prob. P17.31BPGBCh. 17 - Prob. P17.32BPGBCh. 17 - Prob. P17.33BPGBCh. 17 - Prob. P17.34BPGBCh. 17 - Prob. P17.35BPGBCh. 17 - Completing a comprehensive financial statement...Ch. 17 - Prob. P17.37CTCh. 17 - Prob. P17.38CPCh. 17 - Prob. 17.1DCCh. 17 - Prob. 17.1EICh. 17 - Financial Statement Case 17-1 Use Target...
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
- Profitability Ratios Tinker Corporation operates in the highly competitive consulting industry. Tinkers balance sheet indicates the following balances as of December 31, 2019. Required: Calculate Tinkers return on equity if Tinkers 2019 net income is $90,000.arrow_forwardUsing the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56 To calculate averages use (current year balance + poor year balance) / 2) Round percentages to 1 decimal place; round other answers to 2 decimal places.arrow_forwardSome selected financial statement items belonging to MNO Company are given in the table below. According to this information, which of the following is Return on Assets (ROA) in 2021? Inventory 12,500Total Assets in 2021 110,000Current Liabilities 40,000Total Assets in 2020 90,000Net Profit 12,000Shareholders' Equity 65,000 Select one:a. 0.12b. 0.10c. 0.18d. 0.13arrow_forward
- The Diversified Portfolio Corporation provides investment advice to customers. A condensed income statement for the year ended December 31, 2021, appears below: Service revenue $ 1,180,000 Operating expenses 840,000 Income before income taxes 340,000 Income tax expense 85,000 Net income $ 255,000 The following balance sheet information also is available: 12/31/2021 12/31/2020 Cash $ 452,000 $ 84,000 Accounts receivable 148,000…arrow_forwardThe Diversified Portfolio Corporation provides investment advice to customers. A condensed income statement for the year ended December 31, 2021, appears below: Service revenue $ 1,180,000 Operating expenses 840,000 Income before income taxes 340,000 Income tax expense 85,000 Net income $ 255,000 The following balance sheet information also is available: 12/31/2021 12/31/2020 Cash $ 452,000 $ 84,000 Accounts receivable 148,000…arrow_forwardCalculating the Average Common Stockholders' Equity and the Return on Stockholders' Equity The income statement, statement of retained earnings, and balance sheet for Somerville Company are as follows: Somerville CompanyIncome StatementFor the Year Ended December 31, 20X2 Amount Percent Net sales $8,281,989 100.0% Less: Cost of goods sold (5,383,293) 65.0 Gross margin $2,898,696 35.0 Less: Operating expenses (1,323,368) 16.0 Operating income $1,575,328 19.0 Less: Interest expense (50,000) 0.6 Income before taxes $1,525,328 18.4 Less: Income taxes (40%)* (610,131) 7.4 Net income $915,197 11.0 * Includes both state and federal taxes. Somerville CompanyStatement of Retained EarningsFor the Year Ended December 31, 20X2 Balance, beginning of period $1,979,155 Net income 915,197 Total $2,894,352 Preferred dividends (80,000) Dividends to common stockholders (201,887) Balance, end of period $2,612,465…arrow_forward
- Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. The average collection period 2.Days sales in inventory 3. debt to equity ratio 4. Times interest earned 5. Operating cash flow to Capital expenditures ratio 6. Earnings per share 7. Price earnings ratio 8. Dividend yield 9. Dividend payout ratio 10. Total assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56arrow_forwardcalculate the table below based on the income statement and balance sheet attached Ratio Anaylsis 2021 est 2020 2019 Industry Average Profitability Ratios Profit Margin on Sales (%) 8 Earning Power (%) 17.2 Return on Total Assets (%) 12 Return on Common Equity (%) 25 Market Value Ratios Price/Earnings Ratio Price/Earnings Ratio (times) 12.5 Price/Cash Flow Ratio (times) 6.8 Market /Book Value Ratio (times) 1.7arrow_forwardFrom the French Instrument Corporation second-quarter report ended 2018, do a vertical analysis for the second quarter of 2018. (Input all answers as positive values except other (income) which should be indicated by a minus sign. Round your answers to the nearest hundredth percent.) FRENCH INSTRUMENT CORPORATION AND SUBSIDIARIES Consolidated Statements of Operation (Unaudited) (In thousands of dollars, except share data) Second Quarter 2018 2017 Percent of net Net sales $6,644 $6,888 Cost of sales 4,080 4,453 Gross margin 2,564 2,435 Expenses: Selling, general and administrative 1,836 1,774 Product development 166 156 Interest expense 89 114 Other (income), net (181) (108) Total expenses 1,910 1,936 Income before income taxes 654 499 Provision for income taxes 256 200 Net income $398 $299 Net income per common share* $0.05 $0.03 Weighted average number of common shares and equivalents 6,673,673…arrow_forward
- Please consider the following financial numbers for Carridine Company and then prepare answers to the required questions. Carridine Company reported a net income of $1.903 million on revenues of $55.618 million for the year 2019. Interest expense totaled $0.459 million and preferred dividends totaled $13.5 million. The average total assets for the year were $17,5 million. The income tax rate is 21%. Average preferred shareholders’ equity totaled $250 million, and average common shareholders’ equity totaled $7.5 million. Compute the rate of return on assets (ROA) and disaggregate ROA into profit margin and assets turnover components. Compute the rate of return on common stock equity (ROCE) and disaggregate ROCE into profit margin, assets turnover, and capital leverage ratio components. Calculate the amount of net income to common shareholders.arrow_forwardCompute the following ratios for 2025 and 2024. a. Currentratio b. Inventory turnover. (Inventory on December 31,2023 , was$400.) c. Profit margin. d. Return on assets. (Assets on December 31, 2023, were$2,300.) e. Return on common stockholders' equity. (Stockholders' equity-common on December 31,2023, was$950.) f. Debt to assets ratio. g. Times interest earned.arrow_forwardPrepare a vertical analysis of the income statement data for Whispering Winds Corporation for both years. (Round percentages to 1 decimal place, e.g. 12.1%.) WHISPERING WINDS CORPORATIONComparative Income StatementsFor the Years Ended December 31 2022 2021 $ Percent $ Percent Net sales $688,000 Enter percentages % $576,000 Enter percentages % Cost of goods sold 445,000 Enter percentages % 417,000 Enter percentages % Gross profit 243,000 Enter percentages % 159,000 Enter percentages % Operating expenses 145,000 Enter percentages % 108,000 Enter percentages % Net income $98,000 Enter percentages % $51,000 Enter percentages %arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License