Question

In: Accounting

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

$   5,000

Other Current Liabilities

$   3,000

Long-Term Debt & Leases

$ 25,000

Other Long-Term Liabilities

$ 17,000

Shareholder’s Equity

$ 30,000

g.) Calculate Return on Equity

h.) Calculate Return on Assets

i.)Calculate Net Profit Margin

j.) A firm reported Net Income of $20,200,000 in 2016. The balance of the Retained Earnings Account at the beginning of 2017 was $14,500,000 in 2017 and at the beginning of 2016 the balance of the Retained Earnings account was $11,500,000. What was the total amount of dividends the firm paid in 2016?

Solutions

Expert Solution

ans g. Return on Equity (ROE) = Net Income/Shareholders' Equity
ROE [$3669/$30000] 12.23%
ans h. Return On Assets (ROA)= Net Income/Total Assets
ROA [$3669/$133300] 2.75%
Particulars Amount
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
Total Assets $133,300
ans i. Net Profit = Net Income/Sales
Net Profit [$3669/$39579] 9.27%
ans j. Ending Retained Earnings = Beginning Retained Earnings + Net Income - Dividend
Dividend = Beginning Retained Earnings + Net Income - Ending Retained Earnings
Dividend [$11500000+$20200000-$14500000]
Dividend $17,200,000

Related Solutions

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...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 15% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 60% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 20% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 75% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2016 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (40%) 64 Net income $96 Dividends $32 Addition to retained earnings $64 For the coming year, the company is forecasting a 30% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 60% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
Austin Grocers recently reported the following 2019 income statement (in millions of dollars): Sales $700 Operating...
Austin Grocers recently reported the following 2019 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (25%) 40 Net income $120 Dividends $40 Addition to retained earnings $80 For the coming year, the company is forecasting a 30% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 65% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to...
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...
Flamingo, Inc. 2019 statement of comprehensive income ($ in millions) Net sales $1,384 Less: Cost of...
Flamingo, Inc. 2019 statement of comprehensive income ($ in millions) Net sales $1,384 Less: Cost of goods sold 605 Less: Depreciation 180 Earnings before interest and taxes 599 Less: Interest paid 80 Taxable income 519 Less: Taxes 156 Net income $363 Addition to retained earnings $254 Dividends paid 109 Flamingo, Inc. 2018 and 2019 Statement of financial positions ($ in millions) 2018 2019 2018 2019 Cash $100 $121 Accounts payable $400 $350 Accounts rec. 350 425 Notes payable 390 370...
Flamingo, Inc. 2019 statement of comprehensive income ($ in millions) Net sales $1,384 Less: Cost of...
Flamingo, Inc. 2019 statement of comprehensive income ($ in millions) Net sales $1,384 Less: Cost of goods sold 605 Less: Depreciation 180 Earnings before interest and taxes 599 Less: Interest paid 80 Taxable income 519 Less: Taxes 156 Net income $363 Addition to retained earnings $254 Dividends paid 109 Unit 2 Exercise Questions Flamingo, Inc. 2018 and 2019 Statement of financial positions ($ in millions) 2018 2019 2018 2019 Cash $100 $121 Accounts payable $400 $350 Accounts rec. 350 425...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 895.00 Cost of goods sold 755.00 Depreciation 45.00 Earnings before interest and taxes (EBIT) $ 95.00 Interest expense 26.00 Income before tax $ 69.00 Taxes 14.49 Net income $ 54.51 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 383 $ 340 Long-term assets 286 236 Total assets $ 669 $ 576 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 887.00 Cost of goods sold 747.00 Depreciation 37.00 Earnings before interest and taxes (EBIT) $ 103.00 Interest expense 18.00 Income before tax $ 85.00 Taxes 29.75 Net income $ 55.25 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 375 $ 324 Long-term assets 270 228 Total assets $ 645 $ 552 Liabilities and shareholders’ equity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT