Required informationUse the following information for the Exercises below. (Static)[The following information applies to the questions displayed below.]Simon Company's year-end balance sheets follow.At December 31AssetsCashAccounts receivable, netMerchandise inventoryPrepaid expensesPlant assets, netTotal assetsCurrent Year$ 31,80089,500112,50010, 700278,500$ 523,000$ 129,90098,500163, 500131, 100$ 523,0001 Year AgoLiabilities and EquityAccounts payableLong-term notes payableCommon stock, $10 par valueRetained earningsTotal liabilities and equityFor both the current year and one year ago, compute the following ratios:< Prev$ 35,62562,50082,5009,375255,000$ 445,000$ 75,250101, 500163,500104, 750NS2 Years Ago$ 51, 25083,500163, 50079, 250$ 445,000 $ 377,500of 9$ 37,80050, 20054,0005,000230,500$ 377,500Next > Required informationFor Year Ended December 31SalesCost of goods soldOther operating expensesCurrent Year$ 411, 225209,55012, 1009,525$ 673,500642, 400$31,100$ 1.90:. -. - == .......< Prev.$ 345,500134, 98013,3008,845Interest expenseIncome tax expenseTotal costs and expensesNet incomeEarnings per shareFor both the Current Year and 1 Year Ago, compute the following ratios:(1-a) Profit margin ratio.(1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago?(2) Total asset turnover.(3-a) Return on total assets.(3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago?S21 Year Agoof 9hp$ 532,000+++502,625$ 29, 375$ 1.80HelpNext >9 USSaM

Profit margin ratio = Net income/Sales Total asset turnover ratio = Sales/Average total assets Total…

For Year Ended December 31 Sales Cost of goods sold Other operating expenses Interest expense Income tax expense Total costs and expenses Net income Current Year $ 411, 225 209,550 12, 100 9,525 $ 673,500 642, 400 $31, 100 $ 1.90 1 Year Ago $ 345,500 134,980 13, 300 8,845 $ 532,000 502, 625 $ 29,375 $ 1.80 Earnings per share For both the Current Year and 1 Year Ago, compute the following ratios: (1-a) Profit margin ratio. (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (3-a) Return on total assets. (3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago?

For Year Ended December 31 Sales Cost of goods sold Other operating expenses Interest expense Income tax expense Total costs and expenses Net income Current Year $ 411, 225 209,550 12, 100 9,525 $ 673,500 642, 400 $31, 100 $ 1.90 1 Year Ago $ 345,500 134,980 13, 300 8,845 $ 532,000 502, 625 $ 29,375 $ 1.80 Earnings per share For both the Current Year and 1 Year Ago, compute the following ratios: (1-a) Profit margin ratio. (1-b) Did profit margin improve or worsen in the Current Year versus 1 Year Ago? (2) Total asset turnover. (3-a) Return on total assets. (3-b) Based on return on total assets, did Simon's operating efficiency improve or worsen in the Current Year versus 1 Year Ago?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Income statement data for Boone Company for two recent years ended December 31, are as follows: Previous Year Horizontal Analysis of the Income Statement Current Year $800,000 $640,000 Sales 664,200 540,000 Cost of goods sold $135,800 $100,000 Gross profit $39,100 $34,000 Selling expenses 35,670 29,000 Administrative expenses $74,770 $63,000 Total operating expenses Income before income tax $61,030 $37,000 Income tax expenses 24,400 14,800 Net income $36,630 $22,200 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Boone Company Comparative Income Statement For the Years Ended December 31 Current year Previous year Increase (Decrease) Increase (Decrease) Amount Amount Amount Percent Sales $800,000 $640,000 Cost of goods sold 664,200 540,000 Gross profit $135,800 $100,000 Selling expenses 39,100 34,000 Administrative 35,670 29,000…
b. The vertical analysis indicates that the cost of goods sold as a percent of sales by 8 percentage points, while selling expenses - by 4 percentage points, and administrative expenses by 1 percentage points. Thus, net income as a percent of sales by 3 percentage points.
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Current Year Previous Year Sales $2,280,000 $2,000,000 Cost of merchandise sold 1,960,000 1,750,000 Gross profit $320,000 $250,000 Selling expenses $156,500 $125,000 Administrative expenses 122,000 100,000 Total operating expenses $278,500 $225,000 Income before income tax expense $41,500 $25,000 Income tax expenses 16,600 10,000 Net income $24,900 $15,000
Revenue and expense data for Bluestem Company are as follows: Year 2 Year 1 Administrative expenses $37,000 $20,000 Cost of merchandise sold 350,000 320,000 Income tax expense 40,000 32,000 Sales 800,000 700,000 Selling expenses 150,000 110,000 a. Prepare a comparative income statement, with vertical analysis, stating each item for both years as a percent of sales. Round percentages to one decimal place. Bluestem Company Comparative Income Statement For Years Ended December 31, Year 2 and Year 1 Year 2 Amount Year 2 Percent Year 1 Amount Year 1 Percent % % % Total operating expenses b. Complete the following regarding significant changes disclosed by the comparative income statement. The most significant increase in expenses is which offsets the decrease in resulting in the overall of net income. 111111111
Compute common-size percents for the following comparative income statements (round percents to one decimal). Using the common-size percents, which item is most responsible for the decline in net income?
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $490,000 $446,000 Cost of merchandise sold 289,100 231,920 Selling expenses 78,400 84,740 Administrative expenses 88,200 75,820 Income tax expense 14,700 22,300 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $490,000 % $446,000 % Cost of merchandise sold 289,100 % 231,920 % % % Selling expenses 78,400 84,740 % Administrative expenses 88,200 % 75,820 % % % Income tax expense 14,700 % 22,300 % % % b. The vertical analysis indicates that the cost of merchandise sold as a percent of sales - by 7 percentage points, while selling expenses by 3…
Assume the following sales data for a company: Current year $778,795 Preceding year 600,257 What is the percentage increase in sales from the preceding year to the current year?
Comparative Income StatementsConsider the following income statement data from the Ross Company: Current Year Previous Year Sales revenue $525,000 $450,000 Cost of goods sold 336,000 279,000 Selling expenses 105,000 99,000 Administrative expenses 60,000 54,000 Income tax expense 7,800 5,400 Prepare a comparative income statement, showing increases and decreases in dollars and in percentages. Note: Round "Percent Change" answers to one decimal place (ex: 0.2345 = 23.5%). ROSS COMPANYComparative Income Statements Current Year Previous Year Increase(Decrease) PercentChange Sales Revenue Answer Answer Answer Answer Cost of Goods Sold Answer Answer Answer Answer Answer Answer Answer Answer Answer Answer Selling Expenses Answer Answer Answer Answer Administrative Expenses Answer Answer Answer Answer Total Answer Answer Answer Answer Income before Income Taxes Answer Answer Answer Answer Answer Answer Answer Answer Answer Answer…
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Current Year Previous Year Sales $660,000 $500,000 Cost of merchandise sold 554,700 430,000 Gross profit $105,300 $70,000 Selling expenses $31,720 $26,000 Administrative expenses 28,600 22,000 Total operating expenses $60,320 $48,000 Income before income tax expense $44,980 $22,000 Income tax expenses 18,000 8,800 Net income $26,980 $13,200
Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $369,600 $280,000 Cost of goods sold 312,000 240,000 Gross profit $57,600 $40,000 Selling expenses $17,080 $14,000 Administrative expenses 15,600 12,000 Total operating expenses $32,680 $26,000 Income before income tax $24,920 $14,000 Income tax expenses 10,000 5,600 Net income $14,920 $8,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Winthrop Company Comparative Income Statement For the Years Ended December 31 Current Previous Increase Increase year year (Decrease) (Decrease) Amount Amount Amount Percent Sales $369,600 $280,000 $ % Cost of goods sold 312,000 240,000 % Gross profit $57,600 $40,000 %
Computing Earnings per Share The income statement, statement of retained earnings, and balance sheet for Jeanette Company are as follows: Jeanette 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. Jeanette 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 Jeanette CompanyComparative Balance SheetsAt December 31,…
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Current Year Previous Year Sales $2,240,000 $2,000,000 Cost of goods sold (1,925,000) (1,750,000) Gross profit $315,000 $250,000 Selling expenses $(152,500) $(125,000) Administrative expenses (118,000) (100,000) Total operating expenses $(270,500) $(225,000) Income before income tax expense $44,500 $25,000 Income tax expense (17,800) (10,000) Net income $26,700 $15,000 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.