Question

In: Accounting

ABC Company reports the following comparative income statement: 2017 Revenue $100,000 COGS 42,000 Gross Profit 58,000...

ABC Company reports the following comparative income statement:

2017

Revenue $100,000

COGS 42,000

Gross Profit 58,000

SGA Expenses 25,000

Income before tax 33,000

Income tax expense. 11,000

Net Income 22,000

2016

Revenue $70,000

COGS 25,000

Gross Profit 45,000

SGA Expenses 28,000

Income before tax 17,000

Income tax expense. 6,000

Net Income 11,000

Prepare a vertical and horizontal analysis for ABC Company and then calculate the profit margin for ABC Company

Solutions

Expert Solution

  • All working forms part of the answer
  • Horizontal Analysis

2017

2016

Increase (Decrease)

% Increase (Decrease)

Revenue

$      100,000.00

$         70,000.00

$          30,000.00

42.86%

COGS

$         42,000.00

$         25,000.00

$          17,000.00

68.00%

Gross Profit

$         58,000.00

$         45,000.00

$          13,000.00

28.89%

SGA Expenses

$         25,000.00

$         28,000.00

$          (3,000.00)

-10.71%

Income before taxes

$         33,000.00

$         17,000.00

$          16,000.00

94.12%

Income Tax Expense

$         11,000.00

$           6,000.00

$             5,000.00

83.33%

Net Income

$         22,000.00

$         11,000.00

$          11,000.00

100.00%

  • Vertical Analysis

2017

2016

Revenue

$      100,000.00

100.00%

$          70,000.00

100.00%

COGS

$         42,000.00

42.00%

$          25,000.00

35.71%

Gross Profit

$         58,000.00

58.00%

$          45,000.00

64.29%

SGA Expenses

$         25,000.00

25.00%

$          28,000.00

40.00%

Income before taxes

$         33,000.00

33.00%

$          17,000.00

24.29%

Income Tax Expense

$         11,000.00

11.00%

$             6,000.00

8.57%

Net Income

$         22,000.00

22.00%

$          11,000.00

15.71%

  • Profit Margin

2017

2016

Net Income

$         22,000.00

$         11,000.00

Revenues

$      100,000.00

$         70,000.00

Profit Margin %

22.00%

15.71%


Related Solutions

Dynex Company had the following income statement for last year: Sales $200,000 Less: COGS   100,000 Gross...
Dynex Company had the following income statement for last year: Sales $200,000 Less: COGS   100,000 Gross Profit $100,000 Less: Selling & Admin. Expense     40,000 Operating income $  60,000 Beginning assets were $280,000, and ending assets were $300,000. Use the excel document found in the Assignments tab to answer the questions below. Average operating assets were: Margin was: Turnover was: Return on investment was:
How to explain and classify income statement revenue, gross profit, and net income?
How to explain and classify income statement revenue, gross profit, and net income?
1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following:...
1. Calculate Revenues, COGS, Gross Profit and Gross Margin in year 2 based on the following: Yr. 1 Revenues 500 COGS 400 Gross Profit 100 Gross Margin 20% Sales rise 5%, 3% due to increase in volume and 2% due to increase in price. COGS is 80% variable. 2. What is the primary driver of sales growth for the following company? Explain. Assume COGS is 60% variable. Yr. 1 Yr. 2 Revenues 800    850 COGS 500 519 Gross Profit...
INCOME STATEMENT (IN MILL$): January 1, 2019 – December 31, 2019 Revenue = 400; Gross Profit...
INCOME STATEMENT (IN MILL$): January 1, 2019 – December 31, 2019 Revenue = 400; Gross Profit Margin = 30%; Operating Expenses (before depreciation) = 20; Depreciation = 20; Interest = 10; Average Tax Rate =40%; Preferred Dividend = 5; Common Dividend= 7; # of shares outstanding=10 million; Per Share Price of Common Stock = $50.00 BALANCE SHEET (IN MILL$): December 31, 2019 Cash = 5; A/R = 20; Inventory = 55; Net Fixed Asset = 120; Accounts Payable= 10; Accrued...
Profit and Loss Statement 2018 Revenue 34,290 percent of growth 0.0% Gross Profit 34,290 Gross Margin...
Profit and Loss Statement 2018 Revenue 34,290 percent of growth 0.0% Gross Profit 34,290 Gross Margin 100% SGA Costs (2,500) EBITDA 31,790 EBITDA Margin 92.7% Depreciation (7,500) % of Sales -21.9% EBIT 24,290 EBIT Margin 70.8% Interest (2,500) % of Sales -7.3% EBIT 21,790 EBIT Margin 63.5% Net Income 21,790 Net Income Margin 63.5% Balance Sheet 2017 2018 Cash 9,000 12,000 Inventory 0 0 A/R    0 3,179 Current Assets    9,000 15,179 Fixed Assets 747,300 763,800 Total Assets   ...
I.   Gross Profit Method ABC Company uses the gross profit method to estimate inventory for monthly...
I.   Gross Profit Method ABC Company uses the gross profit method to estimate inventory for monthly reporting purposes. Presented below is information for the month of December. Cost Retail Inventory, Dec 1st. $   250,000 $ 520,000 Purchases (gross)         500,000     980,000 Freight-in           25,000 Sales revenue             500,000 Sales returns             8,000 Purchase discounts           10,000 Compute the estimated inventory at cost on December 31st, assuming that the gross profit is 20% of sales. b. How does the...
Revenue and expense data for Searle Technologies Co. are as follows: The following comparative income statement...
Revenue and expense data for Searle Technologies Co. are as follows: The following comparative income statement (in thousands of dollars) for two recent years was adapted from the annual report of Speedway Motorsports, Inc. (TRK), owner and operator of several major motor speedways, such as the Atlanta, Bristol, Charlotte, Texas, and Las Vegas Motor Speedways. Year 2 Year 1 Revenues: Admissions $100,798 $106,050 Event-related revenue 146,849 145,749 NASCAR broadcasting revenue 207,369 199,014 Other operating revenue 29,293 29,836 Total revenue $484,309...
How much gross profit will the company recognize in the first year using the percentage-of-completion method? How much revenue will appear in the company's income statement?
A construction company entered into a fixed-price contract to build an office building for $20 million. Construction costs incurred during the first year were $6 million and estimated costs to complete at the end of the year were $9 million. How much gross profit will the company recognize in the first year using the percentage-of-completion method? How much revenue will appear in the company's income statement?
Multi-step or single-step? Reports gross profit as a separate line item. Reports net income equal to...
Multi-step or single-step? Reports gross profit as a separate line item. Reports net income equal to income from operations adjusted for any nonoperating items Reports subtotals for various classes of item. Reports cost of goods sold before the reporting of groww profit
Company A reports pretax financial income of $100,000 for 2019. The following items caused taxable income...
Company A reports pretax financial income of $100,000 for 2019. The following items caused taxable income to be different than pretax financial income. $5,000 of life insurance carried by the company on key officers. Estimated warranty liability is $20,000 for accounting purposes and $0 for tax purposes. Depreciation for tax purposes exceeds depreciation for accounting purposes by $25,000. Company A's tax rate is 25% for all years, and the company expects to report taxable income in all future years. There...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT