Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

tot The following financial statements are taken from the records of Organo Inc. a) Use horizontal analysis techniques to compare the changes between 2020 and

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
tot The following financial statements are taken from the records of Organo Inc. a) Use horizontal analysis techniques to compare the changes between 2020 and 2019 balance sheet items. Do not enter dollar signs or commas in the input boxes Use the negative sign for negative values. Round all percentages to 2 decimal places Organo Inc. Balance Sheet As at November 30 2020 2019 $ Change % Change Current Assets Cash $314,900 $321,400 $ % Accounts Receivable $209,300 $180,500 $ % Merchandise Inventory $428,400 $402,800 $ % Short-Term Investments $83,400 $97,900 $ % Total Current Assets $1,036,000 $1,002,600 $ 96 Long-Term Assets $444,600 $328,100 $ Total Assets $1,480,600 $1,330,700 $ Current Liabilities $268,400 $237,100 $ Long-Term Liabilities $134,100 $102,700 $ Total Liabilities $402.500 $339,800 $ Shareholders' Equity $1,078,100 $990,900 $ MacBook Air Total Liabilities and Equity S1480,600 $1,330,700 $ b) Perform a vertical analysis of the income statement for 2020, stating all income statement items as a percentage of net sales Organo Inc. Income Statement For the Year Endod December 31 2020 Sales $681,000 Cast of Goods Sold $374,550 % Gross Profit $306,450 Operating Expenses Advertising Expense $4,800 Utilities Expense $8,300 Rent Expense $4,100 Salaries and Wages Expense $49,700 % Depreciation Expense $34,300 % Interest Expense $7,600 94 Total Expenses $108,800 Income Before Income Tax $197,650 Income Tax Expense $59,295 Operating Expenses $4,800 Advertising Expense % $8,300 % Utilities Expense $4,100 % Rent Expense % Salaries and Wages Expense $49,700 $34,300 Depreciation Expense % Interest Expense $7,600 % Total Expenses $108,800 % Income Before Income Tax $197,650 % Income Tax Expense $59,295 % Net Income $138,355 % Presented below are select figures from the balance sheet of Newton Company for 2020 and 2019. Newton Company Balance Sheet As at February 28 2020 2019 Total Assets $289,238 $205,856 Total Liabilities $115,916 $63,949 Shareholders' Equity $173,322 $141,907 In 2020. Newton Company had sales of $466,000 and net income of $46,600. Calculate the ratios for 2020 as indicated below Do not enter dollar signs or commas in the input boxes Round your answers to 2 decimal places. Return on Assets (Percent): % Asset Turnover: times Debt-to-Equity (Decimal): Debt-to-Total-Assets (Percent): Check For the Year Ended June 30 2020 2019 Sales $184,172 $111,239 Cost of Goods Sold $ 118,765 $61,197 Gross Profit $65,407 $50,042 Operating Expenses Administrative Expense $19,461 $14,997 Selling Expense $24,365 $20,674 Total Operating Expenses $43,826 $35,671 Other Income and Expenses Interest Expense $1,374 $1,161 Income Before Income Tax $20,207 $13,210 Income Tax $6,062 $3,963 Net Income (Loss) $14,145 $9,247 a) Calculate the following ratios for both years. Enter net profit margin as a percentage. Do not enter dollar signs or commas in the input boxes. Round your answers to 2 decimal places 2020 2019 Net Profit Margin Time Interest Earned b) in which year does the company have a better performance with respect to the net profit margin calculated in part a)? Year Check

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Security Audit And Control Features SAP ERP

Authors: Isaca

4th Edition

1604205806, 978-1604205800

More Books

Students also viewed these Accounting questions

Question

design a simple performance appraisal system

Answered: 1 week ago