st 1 -u ($ and units in 000s) Units Sales COGS Gross Profit Selling Expense Administrative Expense Operating Income Other Income (Expense) Net Income 2018 80 1,200 720 480 204 216 60 84 144 100% 2017 62.5 1,000 500 500 250 150 100 0 100 100% Required: Using vertical analysis, evaluate the results of operations in 2017 and 2018. Quantify the percentages of each line item to sales. Evaluate the drivers of net income, including gross profit, selling and administrative expenses, and other income. What is the overall percentage point change in profitability and what is the contribution (positive or negative) of each driver. Explain the effect of each driver on profitability and the possible scenarios of each based on the data above. Which are areas of concern? Which areas are positive? What additional questions would you have? Analysis/Explaination

st 1 -u ($ and units in 000s) Units Sales COGS Gross Profit Selling Expense Administrative Expense Operating Income Other Income (Expense) Net Income 2018 80 1,200 720 480 204 216 60 84 144 100% 2017 62.5 1,000 500 500 250 150 100 0 100 100% Required: Using vertical analysis, evaluate the results of operations in 2017 and 2018. Quantify the percentages of each line item to sales. Evaluate the drivers of net income, including gross profit, selling and administrative expenses, and other income. What is the overall percentage point change in profitability and what is the contribution (positive or negative) of each driver. Explain the effect of each driver on profitability and the possible scenarios of each based on the data above. Which are areas of concern? Which areas are positive? What additional questions would you have? Analysis/Explaination

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

Compare the Solvency, Liquidity and Profitability for the two companies
Income statements for Walton Company for Year 3 and Year 4 follow: WALTON COMPANY Income Statements Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses Income before taxes Income taxes expense Net income Required A Required B Year 4 $200, 300 143,300 20,900 12,900 3,200 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses Income before taxes Complete this question by entering your answers in the tabs below. Income taxes expense Net income (loss) $180,300 $160,300 20,000 20,000 3,300 5,600 $ 14,400 $ 16,700 WALTON COMPANY Horizontal Analysis of Income Statements Perform a horizontal analysis, showing the percentage change in each income statement…
LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2017 and 2018 2018 2017 Gross sales $ 23,800 $ 18,600 Sales returns and allowances 1,000 100 Net sales $ 22,800 $ 18,500 Cost of merchandise (goods) sold 10,800 7,200 Gross profit $ 12,000 $ 11,300 Operating expenses: Depreciation $ 1,180 $ 840 Selling and administrative 5,800 4,400 Research 1,030 740 Miscellaneous 840 540 Total operating expenses $ 8,850 $ 6,520 Income before interest and taxes $ 3,150 $ 4,780 Interest expense 1,040 740 Income before taxes $ 2,110 $ 4,040 Provision for taxes 844 1,616 Net income $ 1,266 $ 2,424 LOGIC COMPANY Comparative Balance Sheet December 31, 2017 and 2018 2018 2017 Assets Current assets: Cash $…
Using the accounts and amounts below, calculate Income from Operations: Account Amount $173,570 Sales Revenue Net Sales Sales Returns and Allowances Cost of Goods Sold Operating Expenses 102,735 36,023 31,211 34,693
Complete the comparative income statement and balance sheet for Logic Company. Note: Input all answers as positive values except decrease answers which should be indicated by a minus sign. Round your "percent" answers to the nearest hundredth percent.
The Cullumber Supply Company reported the following information for 2017. Prepare a common-size income statement for the year ended June 30, 2017. (Round answers to 1 decimal place, e.g. 52.7%.) Cullumber Supply CompanyIncome Statement for the Fiscal Year Ended June 30, 2017($ thousands) % of Net Sales Net sales $2,111,000 enter percentages of net sales % Cost of goods sold 1,464,000 enter percentages of net sales % Selling and administrative expenses 312,200 enter percentages of net sales % Nonrecurring expenses 27,600 enter percentages of net sales % Earnings before interest, taxes, depreciation, and amortization (EBITDA) $307,200 enter percentages of net sales % Depreciation 117,000 enter percentages of net sales % Earnings before interest and taxes (EBIT) 190,200 enter percentages of net sales % Interest expense 118,600 enter percentages of net sales % Earnings before taxes (EBT)…
Waterway Corporation, Inc. has the following income statement (in millions): Waterway Corporation, Inc. Income Statement For the Year Ended December 31, 2017 Net Sales $390 Cost of Goods Sold 311 Gross Profit 79 Operating Expenses 40 Net Income $39 Using vertical analysis, what percentage is assigned to net income? 100% 90% O 10% O 17%
LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2017 and 2018 2018 2017 Gross sales $ 20,400 $ 16,050 Sales returns and allowances 900 100 Net sales $ 19,500 $ 15,950 Cost of merchandise (goods) sold 11,650 8,650 Gross profit $ 7,850 $ 7,300 Operating expenses: Depreciation $ 840 $ 670 Selling and administrative 3,250 2,700 Research 690 570 Miscellaneous 500 370 Total operating expenses $ 5,280 $ 4,310 Income before interest and taxes $ 2,570 $ 2,990 Interest expense 700 570 Income before taxes $ 1,870 $ 2,420 Provision for taxes 748 968 Net income $ 1,122 $ 1,452 LOGIC COMPANY Comparative Balance Sheet December 31, 2017 and 2018 2018 2017 Assets Current assets: Cash $ 12,700 $…
LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2017 and 2018 2018 2017 Gross sales $ 22,800 $ 17,850 Sales returns and allowances 900 100 Net sales $ 21,900 $ 17,750 Cost of merchandise (goods) sold 11,050 7,700 Gross profit $ 10,850 $ 10,050 Operating expenses: Depreciation $ 1,080 $ 790 Selling and administrative 5,050 3,900 Research 930 690 Miscellaneous 740 490 Total operating expenses $ 7,800 $ 5,870 Income before interest and taxes $ 3,050 $ 4,180 Interest expense 940 690 Income before taxes $ 2,110 $ 3,490 Provision for taxes 844 1,396 Net income $ 1,266 $ 2,094 LOGIC COMPANY Comparative Balance Sheet December 31, 2017 and 2018 2018 2017 Assets Current assets: Cash $ 11,800…
In a common-sized income statement, 100% is the a. net cost of goods sold b. gross profit c. sales d. net income
The following transactions pertain to Year 1, the first-year operations of Rooney Company. All inventory was started and completed during Year 1. Assume that all transactions are cash transactions. 1. Acquired $4,900 cash by issuing common stock. 2. Paid $660 for materials used to produce inventory. 3. Paid $1,900 to production workers. 4. Paid $1,078 rental fee for production equipment. 5. Paid $90 to administrative employees. 6. Paid $106 rental fee for administrative office equipment. 7. Produced 340 units of inventory of which 190 units were sold at a price of $13 each. Required Prepare an income statement and a balance sheet in accordance with GAAP.
Based on the income statement calculate and explain the profitability ratio and leverage ratio.