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

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...
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   ...
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...
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...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux's accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 33 $ 20 Accounts receivable 48 50 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 3 2 Inventory 55 50 Long-term investment 15 10 Land 70 40 Buildings and...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for National Intercable Company. Additional information from NIC’s accounting records is provided also. NATIONAL INTERCABLE COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in millions) 2018 2017 Assets Cash $ 106 $ 95 Accounts receivable 280 275 Less: Allowance for uncollectible accounts (8 ) (6 ) Prepaid insurance 4 10 Inventory 262 255 Long-term investment 50 75 Land 180 180...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT