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 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.)

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

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.
CAN SOMEONE HELP ME PREPARE A SCHEDULE VERTICAL ANALYSIS? Operating data for Joshua Corporation are presented below. 2020 2019 Sales revenue $754,000 $605,000 Cost of goods sold 465,218 392,645 Selling expenses 122,148 69,575 Administrative expenses 61,828 54,450 Income tax expense 33,176 21,780 Net income 71,630 66,550
Operating data for Indigo Corporation are as follows. Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2022 $810,000 535,410 124,740 59,940 27,540 62,370 2021 $590,000 371,700 66,080 44,840 24,190 83,190 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)
Using the following operating data for Complex Corporation, prepare a schedule showing a vertical analysis for 2020. (Round percentage answers to 1 decimal place, e.g. 15.2.) 2020 Percentage 2019 Net sales $360,000 % $320,000 Cost of goods sold 210,000 % 180,000 Gross profit % Operating expenses 112,000 % 100,000 Net income 38,000 % 40,000
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%.)
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…
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%.)
Operating data for Joshua Corporation are presented as follows: Net Sales Cost of Goods Sold Selling Expenses Administrative Expenses Income Tax Expense Net Income 2022 800,000 520,000 120,000 60,000 30,000 70,000 Instructions Prepare a schedule showing a vertical analysis for 2022 and 2021. Net Sales Cost of Goods Sold Gross Profit Selling Expenses Your Answers: FYI: Format the percent cols to one decimal place. Ex 99.9% 2022 Administrative Expenses Total Operating Expenses Income Before Income Taxes Income Tax Expense Net Income 2021 600,000 408,000 72,000 48,000 24,000 48,000 Amount 800,000 520,000 280,000 120,000 60,000 180,000 100,000 30,000 70,000 Percent 100.0% 2021 Amount Percent 600,000 100.0% 408,000 192,000 72,000 48,000 120,000 72,000 24,000 48,000
Below are Samarahan Jaya Berhad’s income statement, statement of retained earnings and balance sheet for 2019 and 2020. Samarahan Jaya Berhad Comparative Income Statement For the Years Ended December 31, 2019 and 2020 2020 (RM) 2019 (RM) Sales 5,125,000 3,257.600 Sales returns and allowances 125,000 57,600 Net sales 5,000,000 3,200,000 Cost of goods sold 3,400,000 2,080,000 Gross Profit 1,600,000 1,120,00 Selling expenses 650,000 464,000 Administrative expenses 325,000 224,000 Total operating expenses 975,000 688,000 Income from operations 625,000 432,000 Other income 25,000 19,200 650,000 451,200 Interest expense 105,000 64,000 Income before tax 545,000 387,200 Income tax expense 300,000 176,000 Net income 245,000 211,200 Samarahan Jaya Berhad Comparative Retained Earnings Statement For the Years Ended December 31, 2019 and 2020…
The following items were taken from the financial statements of Kramer Manufacturing, Inc., over a 3-year period: Item 2021 2020 2019 Net sales $226,000 $212,000 $200,000 Cost of goods sold 150,000 140,000 125,000 Gross profit $ 76,000 $ 72,000 $ 75,000 Instructions Using horizontal analysis and 2019 as the base year, compute the trend percentages for net sales, cost of goods sold, and gross profit. Item 2021 2020 2019 Net sales % % 100% Cost of goods sold % % 100% Gross profit % % 100% Explain whether the trends are favorable or unfavorable for each…
The following are the comparative financial statements for Outland Corporation for 2020 and 2019: OUTLAND CORPORATION Statement of Income For Periods Ending October 31 Sales Revenue Cost of Goods Sold Gross Profit.. 2020 167,500 100,000 67,500 2019 140,000 85,000 55,000 Expenses Depreciation Selling and Administrative Interest Expense. Total Expenses. 15,000 22,500 15,000 15,000 47,500 35,000 Net Income (before taxes). Income Taxes 25,000 10,000 15,000 22,500 7,500 15,000 Net Income OUTLAND CORPORATION Statement of Financial Position As at October 31 2020 2019 Assets Current Assets: 4,000 10,000 35,000 31,000 80,000 Cash. 2,500 7,500 30,000 25,000 65,000 Marketable Securities. Accounts Receivable. Inventory Total Current Assets Investments (at cost).. 30,000 32,500 Property, plant and equipment Property, Plant and Equipment.. Less: Accumulated Depreciation. 200,000 87,500 112,500 2,500 225,000 190,000 80,000 110,000 2,500 210,000 Goodwill Total Assets Liabilities and Shareholders'…
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…

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

	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