Required: Using the above information, compute the following: 1) Calculate trend percents for all components of the income statements using three years ago as the base year, rounding all percents to 2 decimal places. 2) Express the balance sheets in common-size percents, rounding all percents to 2 decimals.

Required: Using the above information, compute the following: 1) Calculate trend percents for all components of the income statements using three years ago as the base year, rounding all percents to 2 decimal places. 2) Express the balance sheets in common-size percents, rounding all percents to 2 decimals.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter4: Accounting For Retail Operations

Section: Chapter Questions

Problem 4.2MBA: Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on...

See similar textbooks

Similar questions

Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Calculate the common-sized percentage 2023. for Gross Margin in
Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes. Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Sin Comparative Income Statements For Years Ended December 31 2021 $ 420,027 252,856 167,171 59,644 37,802 97,446 69,725 12,969 $ 56,756 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity Assets Current assets Long-term investments Plant assets, net. Total assets Liabilities and Equity Current liabaties Common stock Other paid-in capital Retained earnings Total liabilities and equity 2020 $ 321,775 202,718 KORBIN COMPANY Comparative Balance Sheets December 31 2021 119,057 44,405 28,316 72,721 46,336 9,499 $ 36,837 $ 55,286 0 102,674 $ 157,960 2020 3. Complete the below table to calculate the balance sheet data in trend percents with 2019 as answers to 2 decimal places.) 111.77 % 0.00 $ 37,003 700…
ces Income statement Sales revenue Cost of goods sold Gross profit Operating expenses and interest expense Pretax income Income tax Net income Balance sheet Cash Accounts receivable (net) Inventory Property and equipment (net) Total assets Current liabilities (no interest) Long-term liabilities (interest rate: 12%) Common stock ($5 par value, 7,500 shares outstanding) Retained earnings Total liabilities and stockholders' equity Return on assets Total asset turnover Net profit margin % Year 2 % $ 220,000 119,500 100,500 59,000 41,500 11,000 $ 30,500 $7,000 15,500 43,000 49,500 $ 115,000 $ 17,500 46,500 37,500 Year 11 $ 174,500 103,000 71,500 54,500 17,000 5,500 $ 11,500 2. Compute return on assets, total asset turnover, and the net profit margin for Year 2. Note: Round your answers to 2 decimal places. $ 8,500 19,500 38,400 41,000 $ 107,400 $ 18,500 46,500 37,500 4,900 13,500 $ 115,000 $ 107,400
Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Target Corporation Income Statement Data for Year $65,357 45,583 15,101 707 (94) 1,384 $ 2,488 $18,424 26,109 Balance Sheet Data (End of Year) $44,533 $11,327 17,859 15,347 Walmart Inc. $44,533 $408,214 304,657 79,607 10,512 2,065 (411) 7,139 $ 14,335 $48,331 122,375 $170,706 $55,561 44,089 71,056 $170,706 Beginning-of-Year Balances $44,106 13,712 $163,429 65,682 55,390
At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year Interest expense Income tax expense Total costs and expenses Net income Earnings per share $ 31,880 88,776 116, 174 9,763 283, 158 $ 529,751 $ 127,951 100,589 162,500 138,711 $529,751 For both the current year and one year ago, compute the following ratios: $ 420,092 213,490 11,707 8,953 Current Year 1 Year Ago The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: $ 688,676 $36,900 63,296 86,176 9,686 260,624 $ 456,682 654,242 $34,434 $ 2.12 2 Years Ago $36,930 50,235 $ 75,636 105, 037 163,500 $ 49,240 81,607 162,500 83,453 112,509 $ 456,682 $ 376,800 54, 576 4,186 230,873 $…
Ross Company Comparative Income Statements Sales revenue Cost of goods sold Gross profit on sales Operating expenses Selling expenses Administrative expenses Total Income before income taxes Income tax expense Net income $ Current Year Prior Year (Decrease) 0 $ 0 0 0 0 0 0 0 0$ Increase Percent 0$ 0 0 0 0 0 0 0 0 $ 0 0 0 0 0 0 0 0 0 Change 0 0 a 0 0 0 0 0 0
Current Attempt in Progress The comparative statements of Pharoah Company are presented here. Pharoah Company Income Statements For the Years Ended December 31 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations Other expenses and losses Interest expense Income before income taxes Income tax expense Net income 2025 $2,104,400 1,167,000 937,400 570.000 367,400 25.080 342,320 102,696 $239,624 2024 $1,960,000 1,146.840 813,160 546,060 267.100 22,800 244.300 73,290 $171.010 Assets Current assets Cash Debt investments (short-term) Accounts receivable (net) Inventory Total current assets Plant assets (net) Total assets Pharoah Company Balance Sheets December 31 Liabilities and Stockholders' Equity. Current liabilities Accounts payable Income taxes payable Total current liabilities Bonds payable Total liabilities Stockholders' equity 2025 $68,514 84,360 134,292 143,640 430,806 739,860 $1,170,666 $182,400 49,590 231,990 250,800 482,790 2024…
Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2020, 2019, and 2018 2020 $ 474, 200 285,468 2819 $363, 276 228,864 188, 732 134,412 67,336 50, 132 42,678 31, 968 119,014 82, 198 78, 718 52,312 14,642 19,724 $ 64,976 $ 41,588 S Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income KORBIN COMPANY Comparative Balance Sheets December 31, 2020, 2019, and 2018 2020 Common-Size Comparative Income Statements For Years Ended December 31, 2020, 2019, and 2018 2020 100.00 % 2019 100.00 % Assets Current assets Long-term investments Plant assets,…
Comparative income statements and balance sheets for F&N are shown below ($ millions): Year 2 Year 1 Income Statement $19,889 6,204 Net sales. $20,092 6,044 Cost of goods Gross profit. Selling, general, and administrative expense Depreciation and amortization expense Interest expense (revenue) 14,048 7,893 803 (308) 13,685 9,221 773 292 3,399 1,222 Income before tax 5,660 1,691 Income tax expense. Net income $ 3,969 $ 2,177 Outstanding shares 3,491 3,481
At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity Cost of goods sold Other operating expenses Current Year $ 26,053 77,051 95, 908 8, 732 242,846 $ 450, 590 Interest expense Income tax expense Total costs and expenses Net income Earnings per share 1 Year Ago Current Year $ 31, 386 54, 925 69, 706 $ 66,303 $ 113, 319 87, 252 162, 500 87, 519 89, 341 162,500 70, 296 $ 450, 590 $ 388, 440 $ 357, 318 181, 588 9,958 7,615 7,994 224, 429 388, 440 The company's income statements for the current year and one year ago, follow. 1 Year Ago For Year Ended December 31 Sales $ 585, 767 2 Years Ago 556, 479 S 29, 288 $ 1.80 $31, 085 43, 156 46,425 3,596 199, 438 $ 323, 700 $ 42,728 70, 822 162,500 47,650 $ 323, 700 $ 300, 459 116, 948 10, 632 6,934 $ 462,244 434,973 $ 27,271 $ 1.68
Assume the following sales data for a company: Line Item Description Amount Current year $883,993 Preceding year 542,076 What is the percentage increase in sales from the preceding year to the current year? a. 63.08% b. 61.32% c. 163.08% d. 38.68%