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

Common-Size Income StatementsConsider the following income statement data from the Ross Company: Current Year Previous Year Sales revenue $529,000 $454,000 Cost of goods sold 336,000 279,000 Selling expenses 109,000 103,000 Administrative expenses 64,000 58,000 Income tax expense 7,800 5,400 Prepare common-size income statements for each year. Note: Round answers to one decimal place (ex: 0.2345 = 23.5%). Note: Compute percentages for each "Total" (do not add prior percentage amounts to arrive at Totals). ROSS COMPANYCommon-Size Income Statements(Percent of Sales Revenue) Current Year Previous Year Sales Revenue Answer Answer Cost of Goods Sold Answer Answer Answer Answer Answer Answer Selling Expenses Answer Answer Administrative Expenses Answer Answer Total Answer Answer Income before Income Taxes Answer Answer Answer Answer Answer Answer Answer Answer PreviousSave AnswersNext
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous YearSales $4,000,000 $3,600,000Cost of goods sold 2,280,000 1,872,000Selling expenses 600,000 648,000Administrative expenses 520,000 360,000Income tax expense 240,000 216,000a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to the nearest whole percentage.b. Comment on the significant changes disclosed by the comparative income statement.
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income tax Income tax expenses Net income Current Year $381,300 312,000 $69,300 $19,210 18,150 $37,360 $31,940 12,800 $19,140 Previous Year $310,000 260,000 $50,000 $17,000 15,000 $32,000 $18,000 7,200 $10,800
1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y2 as the base year. Enter decreeses as negative amounts and negative percentages. Round percentage changes to one decimal place. Greyhound Technology Company Comparative Income Statement For the Years Ended December 31, 20Y3 and 20Y2 Increase (Decrease) Increase (Decrease) Amount 20Υ3 20Y2 Percent Sales $739,806 $646,000 S Cost of goods sold (533,000) (410,000) Gross profit $206,806 $236,000 Seling expenses $(74,250) $(54,000) Administrative expenses (43,180) 4,00) Total operating expenses 117,430) $(88,000) Income from operations $89.376 $148.000 3,351 2,700 Other income Income before income tax $92,727 $150,700 S (26,000) (45,200) Income tax expense $66,727 S105,500 Net income
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 $418,200 $340,000 Cost of goods sold 350,900 290,000 Gross profit $67,300 $50,000 Selling expenses $19,210 $17,000 Administrative expenses 16,940 14,000 Total operating expenses $36,150 $31,000 Income before income tax $31,150 $19,000 Income tax expenses 12,500 7,600 Net income $18,650 $11,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 CurrentyearAmount PreviousyearAmount Increase(Decrease)Amount Increase(Decrease)Percent Sales $418,200 $340,000 $fill in the blank…
Horizontal Analysis of Income StatementFor 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensedcomparative income statement:Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y120Y2 20Y1Sales $910,000 $700,000Cost of goods sold 441,000 350,000Gross profit $469,000 $350,000Selling expenses $139,150 $115,000Administrative expenses 99,450 85,000Total operating expenses $238,600 $200,000Income from operations $230,400 $150,000Other income 65,000 50,000Income before income tax $295,400 $200,000Income tax expense 65,000 50,000Net income $230,400 $150,000Required:1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round to one decimal place. Use theminus sign to indicate a decrease in the "Difference" columns.Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2…
Anthony Corporation reported the folowing amounts for the year Net sales $296, 000 Cost of goods sold Average inventory 138, e00 50,000 Anthony's gross profit ratio is Mole Choce 53
income statement with percentages comparatively
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. Sales Cost of merchandise sold Gross profit Selling expenses Winthrop Company Comparative Income Statement For the Years Ended December 31 Administrative expenses Total operating expenses Income before income tax expense Income tax expense Net income profit to be Increase Current Previous Increase year year (Decrease) (Decrease) Amount Amount Amount Percent $611,000 $470,000 $ 520,700 410,000 $90,300 $27,600 24,320 $51,920 $38,380 15,400 $22,980 $60,000 $23.000 19,000 $42,000 $18,000 $ 7,200 $10,800 % % % % % % % % % b. The net income for Winthrop Company increased between years. This increase was the combined result of an in cost of merchandise sold. The cost of merchandise sold increased at a than the percentage increase in sales. in sales and percentage rate than the increase in…
Common-size and trend percents for Roxi Company's sales, cost of goods sold, and expenses follow. Sales Cost of goods sold Operating expenses Common-Size Percents Current Year 100.0% 63.3 14.4 Change in Net Net Income Income 1 Year Ago 100.0% 61.1 13.9 2 Years Ago 100.0% 58.0 14.2 Trend Percents 1 Year Ago Current Year 105.0% 114.6 106.6 Complete this question by entering your answers in the tabs below. 103.8% 109.3 101.6 Determine the net income for the following years. Did the net income increase, decrease, or remain unchanged in this three-year period? 2 Years Ago 100.0% 100.0 100.0 Did the net income increase, decrease, or remain unchanged in this three-year period? Did the net income increase, decrease, or remain unchanged in this three-year period?
Comon size percentage
Common-size and trend percents for Roxi Company's sales, cost of goods sold, and expenses follow. Current Year Sales Cost of goods sold Operating expenses Common-Size Percents 1 Year Ago 100.0% 63.2 14.2 Trend Percents 2 Years Ago 100.0% 61.0 13.7 Determine the net income for the following years. Did the net income increase, decrease, or remain unchanged in this three-year period? Current Year 100.0% 57.6 14.0 1 Year Years Ago Ago 103.9% 102.7% 108.8 114.0 105.4 100.5 100.0 100.0 100.0