Question

In: Finance

Figures are in millions of dollars Net sales $ 2,473.8 Cost of goods sold (COGS) $...

Figures are in millions of dollars

Net sales $ 2,473.8
Cost of goods sold (COGS) $ 1,316.2
Operating expenses (S&GA) $ 575.8
Inventory $ 250.1
Accounts receivable $ 36.7
Other current assets $ 68.9
Fixed assets $ 690.0

What's the net profit margin? $____ Show work.

What's the net profit margin %? _____ Show work.

What's the value of total assets? $____ Show work.

What's the asset turnover ? $____ Show work.

What's the return on assets (ROA)? $____ Show work.

Solutions

Expert Solution

Calculate net profit margin
Net profit margin ($) Net sales - Cost of goods sold - Operating expenses
Net profit margin ($) 2473.8-1316.2-575.8
Net profit margin ($) $581.8 million
Calculate net profit margin (%)
Net profit margin (%) Net profit margin/Sales revenue
Net profit margin (%) 581.8/2473.8
Net profit margin (%) 23.52%
Calculate value of total assets
Total assets Inventory + Accounts receivable + Other current assets + Fixed assets
Total assets 250.1+36.7+68.9+690
Total assets $1,045.7 million
Calculate asset turnover
Asset turnover Net sales/Total assets
Asset turnover 2473.8/1045.7
Asset turnover 2.37
Calculate return on assets
Return on assets Net profit margin/Total assets
Return on assets 581.8/1045.7
Return on assets 55.64%

Related Solutions

Income statement (millions of dollars) Net sales $ 39,579 COGS $ 12,180 Other Expenses $ 12,147...
Income statement (millions of dollars) Net sales $ 39,579 COGS $ 12,180 Other Expenses $ 12,147 Depreciation $   7,554 EBIT $   7,698 Interest Expense $   2,055 Income Before Tax $   5,643 Tax Expense (35%) $   2,055 Net income $   3,669 Dividends $   2,568 Balance sheet (millions of dollars) Cash $       300 Accounts Receivable $ 10,000 Inventories $   5,000     Other Assets $    3,000 Property, Plant and Equipment, net $100,000 Other Long-Term Assets $ 15,000 Accounts Payable $   8,000 Short-Term Debt $  ...
STORE 5 NET SALES = ? COST OF GOODS SOLD = $90.0 GROSS MARGIN-DOLLARS = ?...
STORE 5 NET SALES = ? COST OF GOODS SOLD = $90.0 GROSS MARGIN-DOLLARS = ? GROSS MARGIN-PERCENT = ? EXPENSE-DOLLARS = $41.1 EXPENSE-PERCENT = ? NET INCOME-DOLLARS = $0.5 NET INCOME-PERCENT = ?
Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold...
Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold 7,340 Depreciation 405 Earnings before interest and taxes $ 955 Interest paid 82 Taxable income $ 873 Taxes 306 Net income $ 567    Windswept, Inc. 2016 and 2017 Balance Sheets ($ in millions) 2016 2017 2016 2017 Cash $ 150 $ 185 Accounts payable $ 1,180 $ 1,260 Accounts rec. 920 730 Long-term debt 1,000 1,265 Inventory 1,520 1,550 Common stock 3,210 2,900...
Williams & Sons last year reported sales of $17 million,cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $17 million, cost of goods sold (COGS) of $12 and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 3 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
Williams & Sons last year reported sales of $9 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $9 million, cost of goods sold (COGS) of $6 million, and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 3 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Enter your answer in...
Williams & Sons last year reported sales of $97 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $97 million, cost of goods sold (COGS) of $80 million, and an inventory turnover ratio of 5. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 8 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Enter your answer in...
Williams & Sons last year reported sales of $74 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $74 million, cost of goods sold (COGS) of $60 and an inventory turnover ratio of 5. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
Williams & Sons last year reported sales of $37 million, cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $37 million, cost of goods sold (COGS) of $30 and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 5 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
2009 2010 Sales ($ millions) 1000 1112 Cost of Goods Sold ($ millions) 500 556 Other...
2009 2010 Sales ($ millions) 1000 1112 Cost of Goods Sold ($ millions) 500 556 Other Expenses ($ millions) 100 111 Depreciation ($ millions) 100 100 Interest Expense ($ millions) 50 55 Total Current Assets ($ millions) 600 700 Total Fixed Assets ($ millions) 2200 2500 Accumulated Depreciation ($ millions) 400 This can be determined from the information given Net Fixed Assets ($ millions) 1800 2000 Total Current Liabilities ($ millions) 450 550 Long-term Liabilities ($ millions) 900 975 Common...
In 2018, ABC Corp. had sales/revenue of $26,500,000, Costs of Goods Sold (COGS) of $14,500,000, Sales,...
In 2018, ABC Corp. had sales/revenue of $26,500,000, Costs of Goods Sold (COGS) of $14,500,000, Sales, General, and Administrative (SG&A) expense of $5,600,000, Depreciation expense of $1,000,000, and Interest expense of $400,000. Also assume that its average tax rate was 19%. What was ABC Corp.'s Earnings Before Interests and Taxes (or Operating Income) as of 2018?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT