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,100

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,100

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter6: Merchandising Transactions

Section: Chapter Questions

Problem 15EA: The following select account data is taken from the records of Reese Industries for 2019. A. Use the...

See similar textbooks

Similar questions

(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?
OBJECTIVE: To enable learners to utilize financial ratios as a mechanism to evaluate the firm's financial performance and identify areas for making decisions for improvement REQUIREMENT: Financial Statement Analysis Question Refer to the following financial statements of Delima Corporation for 2019 and 2020: Delima Corporation Income Statements For the year ended 31 December (in millions) 2020 $13,198 7,750 2019 $12,397 7,108 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations 5,448 5,289 3,472 3,299 1,976 1,990 Interest expense 233 248 Other (income) expense, net 11 1,732 503 1,229 Income before income taxes 1,742 Income tax expense 502 Net income 1,240 Delima Corporation Balance Sheets 31 December (in millions) 2020 2019 Assets Current assets Cash $460 $444 Accounts receivables (net) 1,188 1,132 1,190 1,056 225 2,915 3,128 Inventories Other current assets 247 Total current assets 3,027 3,281 Property (net) 5,593 $11,901 Other assets…
(Learning Objective 7: Calculate return on assets) Handley Grocery Corporationreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$50,000$ 2,200$40,000$48,350$ 2,100$39,300Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?
(Learning Objective 4: Construct the financial statements) Suppose Robin SportingGoods Company reported the following data at July 31, 2018, with amounts in thousands:Cost of goods sold................. $136,800Cash...................................... 50,000Property and equipment, net ... 19,400Common stock...................... 26,000Inventories ............................ 36,000Long-term liabilities.............. 11,700Dividends.............................. 0Retained earnings,July 31, 2017 ............ $ 31,500Accounts receivable....... 34,000Net revenues ................. 191,000Total current liabilities.. 80,000All other expenses......... 29,000Other current assets ...... 5,000Other assets................... 30,000Use these data to prepare Robin Sporting Goods Company’s single-step income statement forthe year ended July 31, 2018; statement of retained earnings for the year ended July 31, 2018;and classified balance sheet at July 31, 2018. Use the report format for the balance…
(Learning Objective 7: Calculate return on assets) Hometown Supply Companyreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$84,000$ 4,200$70,000$82,600$ 4,050$69,450Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?
The following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.
Cost of Goods Sold, Income Statement. and Statement of Comprehensive Income Gaskin Company derives the following items from its adjusted trial balance as of December 31, 2019: The following; additional information is also available. The December 31, 2019, ending inventory is 14,700. During 2019, 4,200 shares of'common stock were outstanding the entire year. The income tax rate 30% on all items of income. Required: 1. As a supporting document for Requirements 2 and 3, prepare a separate schedule for Gaskins cost of goods sold. 2. Prepare a 2019 single-step income statement. 3. Prepare a 2019 multiple-step income statement. 4. Prepare a 2019 statement of comprehensive income.
ement. From the following income statement accounts in the popup window, ne income statement for the year. ne operating cash flow for the year. 6 Data Table ne income statement for the year. e income statement below. (Round to the nearest dollar. (Click on the following icon in order to copy its contents into a spreadsheet.) Income Statement Income Statement Accounts for the Year Ending 2017 Year Ending December 31, 2017 Account Cost of goods sold Interest expense Balance $345,000 $82,000 $42,000 $744,000 $66,000 $112.000 Taxes Revenue Selling, general, and administrative expenses Depreciation Print Done income any list or enter any number in the input fields and then continue to the next question. %24 %24 %24 %24
Not Graded please assist with the calculations with image provided. Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicatedusing the EXCEL template provided:10. Average collection period11. Inventory turnover12. Days’ sales in inventory13. Debt-to-equity ratio14. Times-interest-earned ratio15. Operating-cash-flow-to-capital-expenditures ratio16. Earnings per share17. Price-earnings ratio18. Dividend yield19. Dividend payout ratioTotal 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
E5-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.
(Learning Objective 7: Evaluate liquidity using the quick [acid-test] ratio and days’sales in receivables) Northern Products reported the following amounts in its 2019 financialstatements. The 2018 amounts are given for comparison.2019 2018Current assets:Cash............................................ $ 9,500Short-term investments................ 7,000Accounts receivable..................... $70,100Less: Allowance foruncollectibles.......................$86,500(7,500) (5,500) 64,600Inventory..................................... 190,000Prepaid insurance ........................ 2,200Total current assets..................... 273,300Total current liabilities.................... 106,000Net sales (all on account) ................$ 9,50010,50079,000189,0002,200290,20099,0001,077,000 734,000Requirements1. Compute Northern’s quick (acid-test) ratio at the end of 2019. Round to two decimalplaces. How does the quick ratio compare with the industry average of 0.92?2. Compare days’ sales…
Prepare an income statement for Hansen Realty for the year ended December 31, 2023. Beginning inventory was $1,242. Ending inventory was $1,594. Note: Input all amounts as positive values. Sales Sales returns and allowances Sales discount Purchases Purchase discounts Depreciation expense Salary expense Insurance expense Utilities expense Plumbing expense Rent expense HANSEN REALTY Income Statement For Year Ended December 31, 2023 Gross profit from sales Operating expenses: $ 34,300 1,086 1,146 10,212 Total operating expenses 534 109 4,900 2,300 204 244 174