Question

In: Finance

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

Solutions

Expert Solution


Related Solutions

1.     Compute the acid-test ratio and explain its use to assess liquidity. 2.     Compute the gross margin ratio...
1.     Compute the acid-test ratio and explain its use to assess liquidity. 2.     Compute the gross margin ratio and explain its use to assess profitability. Google one of your favorite companies and use their annual report to complete one of the following tests
Compute the Profit margin (PM), asset turnover (AT), and financial leverage (FL) components of the basic...
Compute the Profit margin (PM), asset turnover (AT), and financial leverage (FL) components of the basic Dupont model. Show that ROE=PMxATxFL for 2016. To assets we $45,550 million in 2014. Which component (S) explain the year over year change in Valero's ROE?
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...
1.How and why does a company's profit margin stay the same but its gross margin increases?...
1.How and why does a company's profit margin stay the same but its gross margin increases? 2.How and why can a company's current ratio decrease but their acid test ratio increase? 3.What is the difference between gross margin and profit margin?
If Gross Profit Margin is 55%, what is COGS %?
If Gross Profit Margin is 55%, what is COGS %?
What is the firm's current year gross profit margin?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 428,048.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,731.00Interest expense 40,500 41,017.00Inventories 279,000 288,000Long-term debt 339,670.00 401,877.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 161,905.00Retained earnings 306,000 342,000Sales 639,000 850,323.00Taxes 24,750 48,686.00What is the firm's current year gross profit margin?
What is Gross Profit communicating to us? What is Gross Margin communicating to us?
What is Gross Profit communicating to us? What is Gross Margin communicating to us?
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit...
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit Margin; 3) Return on Assets; 4) Days Sales Outstanding; 5) Quick Ratio. For EACH of these five ratios do the following: 1) calculate the value and 2) interpret the value in about one sentence.  TO RECEIVE ANY CREDIT YOU MUST SHOW YOUR WORK, WITHIN THE PROVIDED WORK SPACE. FINAL ANSWERS ONLY WILL NOT CUT IT!         Balance Sheet         ASSETS                                                                                               LIABILITIES                     Cash: $1,160,000                                                                          Current Liabilities: $173,000 A/R: 335,000                                                                                 Non-current...
Calculate the contribution margin (selling price minus variable costs) and gross margin (selling price minus all...
Calculate the contribution margin (selling price minus variable costs) and gross margin (selling price minus all manufacturing costs) per gallon for each type of paint and total firm-wide profit under each of the following scenarios: Scenario A Current production, including the Virginia contract Scenario B Without either the Virginia contract or the promotion to expand sales of commercial paint Scenario C Without the Virginia contract but assuming the promotional campaign is undertaken and sales of commercial paint do in fact...
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   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT