Question

2) Compute the EBIT margin and its components – the gross profit margin and selling, general,...

2) Compute the EBIT margin and its components – the gross profit margin and selling, general, and administrative expenses to revenue in 2018 and 2019. What caused the change in EBIT margin? [You do not have to use the average method – i.e. you can use year-end numbers in computing the ratios.]

ATC Company

Balance Sheet on December31 ($ millions)

2018

2019

Inventory

20

28

Accounts Receivable

36

26

Other

29

36

Cash

410

473

Total Current Assets

495

562

NPPE

1,847

2,237

Other Fixed Assets

156

212

Total Fixed Assets

2,003

2,449

Total Assets

2,499

3,011

Short Term Debt and Notes

152

173

Accounts Payable

27

28

Other

334

412

Total Current Liabilities

514

613

Long Term Debt

1,119

1,249

Other Long Term Liabilities

175

266

Total Long Term Liabilities

1,294

1,515

Common Equity

690

884

Total Liabilities & Equity

2,499

3,011

Income Statement for Year Ending December 31 ($ millions)

2018

2019

Total revenues

1,667

1,841

Cost of sales

1,250

1,297

Gross profit

417

544

Selling, general & admin expenses

174

180

Operating profit

243

364

Net interest expense

45

64

Other income (expense)

0

2

Income before tax

199

301

Taxes

38

69

Net Income

162

232

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Calculate Return on equity (ROE), Return on assets (ROA), Net Profit Margin (NPM), Debt ratio, and...
Calculate Return on equity (ROE), Return on assets (ROA), Net Profit Margin (NPM), Debt ratio, and Total assets turnover for 2018 and 2019. Explain why ROE is lower in 2019 than in 2018 (explain in terms of each ratio in DuPont equation for ROE). Income Statements ($ in millions) Balance Sheets ($ in millions) 2018 2019 Assets 2018 2019 Sales Revenue $2,580 $2,865 Cash $70 $50 Less: Cost of goods sold $1,060 $1,500 Short-Term investments $35 $9 Less: Operating Expenses...
Provide calculations and show steps for each Gross profit margin Gross Profit/Revenue 2018 = 20,537/79,040*100 =...
Provide calculations and show steps for each Gross profit margin Gross Profit/Revenue 2018 = 20,537/79,040*100 = 2019 = 25,053/90,621*100 = Net profit margin Net Income/Total Revenues 2018 = -2,926/79,040*100 = 2019 = -2,181/90,621*100 = EPS Net Income/Common Stock 2018 = -2,926/11,960 = 2019 = -2,181/3,840 = Return to equity Net Income/Average Shareholders’ Equity 2018 = -2,926/9,062 = 2019 = -2,181/17,869 = Earnings Ratio Market Value Per Share/Earning Per share 2018 = 33.38/-0.18 = 2019 = 33.38/-0.76 =
Provide calculations for each Gross profit margin Gross Profit/Revenue 2018 = 20,537/79,040*100 = 2019 = 25,053/90,621*100...
Provide calculations for each Gross profit margin Gross Profit/Revenue 2018 = 20,537/79,040*100 = 2019 = 25,053/90,621*100 = Net profit margin Net Income/Total Revenues 2018 = -2,926/79,040*100 = 2019 = -2,181/90,621*100 = EPS Net Income/Common Stock 2018 = -2,926/11,960 = 2019 = -2,181/3,840 = Return to equity Net Income/Average Shareholders’ Equity 2018 = -2,926/9,062 = 2019 = -2,181/17,869 = Earnings Ratio Market Value Per Share/Earning Per share 2018 = 33.38/-0.18 = 2019 = 33.38/-0.76 =
Ratios FY Ending 9/30/2000 9/29/2001 Sales growth rate -32.82 Gross profit margin (gross profit/sales) 27.13% 23.03%...
Ratios FY Ending 9/30/2000 9/29/2001 Sales growth rate -32.82 Gross profit margin (gross profit/sales) 27.13% 23.03% Operating profit margin (EBIT/sales) 6.64% -6.21% Net profit margin (net profit/sales) 9.85% -0.47% Cash flow margin (cash flow/sales) 10.87% 3.45% Asset turnover (sales/assets) 1.17 0.89 Equity multiplier (assets/equity) 1.66 1.54 ROA (net income/assets) 0.12 0.00 ROE (net income/equity) 0.19 -0.01 Adjusted equity (equity - investments) 2,317.00 1,208.00 Adjusted ROE (net income/adjusted equity 33.92% -2.07% Financial Statements data ($mil) for FY Ending 9/30/2000 9/29/2001 Total...
Net sales $7,245,088 $6,944,296 $6,149,218 Cost of goods sold (5,286,253) (4,953,556) (4,355,675) Gross margin $1,958,835 $1,990,740...
Net sales $7,245,088 $6,944,296 $6,149,218 Cost of goods sold (5,286,253) (4,953,556) (4,355,675) Gross margin $1,958,835 $1,990,740 $1,793,543 General and administrative expenses (1,259,896) (1,202,042) (1,080,843) Special and nonrecurring items 2,617 - - Operating income $701,556 $788,698 $712,700 Interest expense (63,685) (62,398) (63,927) Other income 7,308 10,080 11,529 Gain on sale of investments - 9,117 - Income before income taxes $645,179 $745,497 $660,302 Provision for income taxes 254,000 290,000 257,000 Net income $391,179 $455,497 $403,302 Net income per share $1.08 $1.25 $1.11...
The financial statements for Wiley Ltd are presented below Statement of profit or loss and other...
The financial statements for Wiley Ltd are presented below Statement of profit or loss and other comprehensive income for Wiley Ltd for the year ending 30 June 2019 $ $ Sales (credit) 250 000 Cost of sales – Inventory—01 July 2018 (25 000) – Purchases (152 500) – Inventory—30 June 2019     27 500 (150 000) Gross profit 100 000 Selling and administrative expenses (20 000) Depreciation (40 000) Profit before tax 40 000 Income tax expense (20 per cent)...
A) The firm has a gross profit of $100, operating income (EBIT) of $70, taxable income...
A) The firm has a gross profit of $100, operating income (EBIT) of $70, taxable income (EBT) of $65, net income of $45, total assets of $4,000, total equity of $1,200, and total sales of $200. What is net profit margin? B)The company has net income of $30,000 for the year and paid dividends of $40,000.  At the beginning of the year, the company had common stock of $50,000, paid-in surplus of $60,000, and retained earnings of $70,000. At the end...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
Please Calculate the following ratios: Asset turnover Operating profit margin Long-term debt to equity ratio Current...
Please Calculate the following ratios: Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Income Statement All numbers in thousands Revenue 1/29/17 1/31/16 Total Revenue 94,595,000 88,519,000 Cost of Revenue 62,282,000 58,254,000 Gross Profit 32,313,000 30,265,000 Operating Expenses Research Development - - Selling General and Administrative 17,132,000 16,801,000 Non Recurring - - Others 1,754,000 1,690,000 Total Operating Expenses - - Operating Income or Loss 13,427,000 11,774,000 Income from Continuing Operations Total Other Income/Expenses...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT