After analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenue as the base amount. Round percentages to two decimal places. Here is the operating data for Yalis Cleaning, Inc.: 2021 2020 Service revenue $523,000 $476,000 Operating expenses 385,500 319,800 Income tax expense 34,375 39,050 Net income $103,125 $117,150

After analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenue as the base amount. Round percentages to two decimal places. Here is the operating data for Yalis Cleaning, Inc.: 2021 2020 Service revenue $523,000 $476,000 Operating expenses 385,500 319,800 Income tax expense 34,375 39,050 Net income $103,125 $117,150

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter5: Sales And Receivables

Section: Chapter Questions

Problem 77E: Ratio Analysis The following information was taken from Logsden Manufacturings trial balances as of...

See similar textbooks

Similar questions

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.
Data for Lozano Chip Company and its industry averages follow. Calculate the indicated ratios for Lozano. Construct the extended DuPont equation for both Lozano and the industry. Outline Lozano’s strengths and weaknesses as revealed by your analysis. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars)
Ratio Analysis The following information was taken from Logsden Manufacturings trial balances as of December 31, 2018, and December 31, 2019. Required: 1. Calculate the gross profit margin and operating margin percentage for 2019. ( Note: Round answers to two decimal places.) 2. Assuming that all of the operating expenses are fixed (or, wont change as sales increase or decrease), what will be the operating margin percentage if sales increase by 25%?
Here is the operating data for Yalis Cleaning, Inc.: After analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenue as the base amount. Round percentages to two decimal places.
Prepare a vertical analysis scheduleHere is the operating data for Yalis Cleaning, Inc.:2021 2020Service revenue $523,000 $476,000Operating expenses 385,500 319,800Income tax expense 34,375 39,050Net income $103,125 $117,150PurposeThe purpose of this problem is to demonstrate an understanding of preparing a vertical analysis schedule.InstructionsAfter analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenueas the base amount. Round percentages to two decimal places.GuidanceFor formatting guidance, see the vertical analysis examples that are provided in Chapter 13 of the textbook.
Operating data for Cheyenne Corp. are presented below. 2022 2021 Sales revenue $831,900 $629,500 Cost of goods sold 529,700 410,900 Selling expenses 125,400 74,300 Administrative expenses 79,400 52,000 Income tax expense 37,000 24,500 Net income 60,400 67,800 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Operating data for Riverbed Corp are presented below. 2022 2021 Sales revenue $850,500 $643,000 Cost of goods sold 529,000 409,600 Selling expenses 121,800 75,900 Administrative expenses 73,300 50,700 Income tax expense 33,000 23,500 Net income 93,400 83,300 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.) RIVERBED CORPCondensed Income Statementchoose the accouning period For the Years Ended December 31December 31For the Month Ended December 31 2022 2021 Amount Percent Amount Percent Sales $850,500 enter percentages % $643,000 enter percentages % Cost of goods sold 529,000 enter percentages % 409,600 enter percentages % Gross profit 321,500 enter percentages % 233,400 enter percentages % Selling…
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Operating data for Taylor Corporation are presented below. Using the Excel spreadsheet provided, prepare a schedule showing a vertical analysis for 2020 and 2019. 2020 2019 Sales revenue $800,000 $600,000 Cost of goods sold 520,000 408,000 Selling expenses 120,000 72,000 Administrative expenses 60,000 48,000 Income tax expense 30,000 24,000 Net income 70,000 48,000 (CGS percent. = CGS ÷ Sales rev.)
Operating data for Joshua Corporation are presented below. 2020 2019 Sales revenue $ 755,000 $ 604,000 Cost of goods sold 464,325 386,560 Selling expenses 118,535 75,500 Administrative expenses 58,135 54,360 Income tax expense 37,750 24,764 Net income 76,255 62,816 Prepare a schedule showing a vertical analysis for 2020 and 2019. (Round answers to 1 decimal place, e.g. 48.5%.)