Question

In: Finance

company XYZ in 2015 is given : sales €500000, costs €332000 depreciation expense €120000 Interest expense...

company XYZ in 2015 is given : sales €500000, costs €332000 depreciation expense €120000 Interest expense €60000 dividends €16000 tax rate 35 percent

a) given this information prepare XYZ income statement

b) calculate XYZ profit margin

c) If company XYZ has total asset €250000 and equity multiplier 2.5 what is return on equity, what is return on equity (ROE) based on DU point identity.

d) discus the component of Du point identity

Expert Solution

a & b) Income statements and profit margins

XYZ Income Statement	Amount in EUR
Sales	500,000
Costs	-332,000
Earning before Depreciation interest and tax (EBITDA)	168,000
Depreciation expense	-120,000
Operating profit (EBIT)	48,000
Interest expense	-60,000
Profit before tax	-12,000
Income tax (at 35%)	4,200
Income after tax	-7,800
Dividends	-16,000
Retained earnings	-23,800

Profit margin
EBITDA margin	33.6%
Operating margin	9.6%
Net profit margin	-1.6%

Excel formula:

c)

Return on Equity = Net profit / Sales * Sales/ Total assets * equity multiplier (assets/equity)

= -7,800 / 500,000 * 500,000 / 250,000 * 2.5

Return on Equity = -7.8%

d) Component of Dupont

As per Dupont,

Return on Equity = Net profit / Sales * Sales/ Total assets * equity multiplier (assets/equity)

Return on Equity = Net profit margin * Asset turnover * Equity multiplier

jeff jeffy answered 1 year ago

A company has sales of $50,000, costs of $23,000, depreciation expense of $2,000, and interest expense...

A company has sales of $50,000, costs of $23,000, depreciation expense of $2,000, and interest expense of $1,500. If the tax rate is 21%, what is the operating cash flow, OCF?

Company ZYX has sales of $664000, costs of $255000, depreciation expense of $45000, interest expense of...

Company ZYX has sales of $664000, costs of $255000, depreciation expense of $45000, interest expense of $31000, and a tax rate of 30.00%. The firm paid out $108000 in cash dividends, and has 30,000 shares of common stock outstanding. What is the earnings per share (EPS) and dividends per share (DPS)? A. $7.77 and $3.60 B. $9.01 and $4.15 C. $8.65 and $3.60 D. $7.77 and $4.80

XYZ Inc., has sales of $800,000, costs of $375,000, depreciation expense of $85,000, interest expense of $50,000, and a tax rate of 35%.

XYZ Inc., has sales of $800,000, costs of $375,000, depreciation expense of $85,000, interest expense of $50,000, and a tax rate of 35%. What is the net income of this firm? (10 Points)The income statement for the company is(Use Excel and Excel Formulas to answer)

Following information for company XYZ in 2015 is given: sales $550 000, cost $332 000, depreciation...

Following information for company XYZ in 2015 is given: sales $550 000, cost $332 000, depreciation expense $120 000, interest expense 60 000, dividends 16 000, tax rate 35% percent. a) prepare income statement b) calculate company XYZ profit margin c) If company XYZ has total assets $250 000 and equity multiplier 2.5. What is return on equity (ROE) based on DuPoint identity? d) Discuss the three components of DuPoint identity

Ziggy Inc., has sales of $817,000 costs of $343,000, depreciation expense of $51,000, interest expense of...

Ziggy Inc., has sales of $817,000 costs of $343,000, depreciation expense of $51,000, interest expense of $38,000 and tax rate of 35%. What is the net income of the firm? Suppose the firm paid out $95,000 in cash dividends. What is the addition to retained earnings? Suppose the firm had 90,000 shares of common stock outstanding. What is the earnings per share? What is the dividends per share figure?

ABC Inc. has sales of $44,500, costs of $19,400, depreciation expense of $2,900, and interest expense...

ABC Inc. has sales of $44,500, costs of $19,400, depreciation expense of $2,900, and interest expense of $2,400. If the tax rate is 35%, what is the operating cash flow, or OCF? (Omit $ sign in your response.)

Kamenka LLC has sales of 634,000, costs of 305,000, depreciation expense of 46,000, interest expense of...

Kamenka LLC has sales of 634,000, costs of 305,000, depreciation expense of 46,000, interest expense of 29,000 and tax rate of 35%, what is its net income? Suppose it paid dividends of 86,000, what was the addition to the retained earnings?

Hammett, Inc., has sales of $19,630, costs of $9,400, depreciation expense of $2,070, and interest expense...

Hammett, Inc., has sales of $19,630, costs of $9,400, depreciation expense of $2,070, and interest expense of $1,560. Assume the tax rate is 30 percent. (Enter your answer as directed, but do not round intermediate calculations.) Required: What is the operating cash flow? Operating cash flow

Benson, Inc., has sales of $39,230, costs of $12,930, depreciation expense of $2,630, and interest expense...

Benson, Inc., has sales of $39,230, costs of $12,930, depreciation expense of $2,630, and interest expense of $1,910. The tax rate is 22 percent. What is the operating cash flow, or OCF? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

Billy's Exterminators, Inc., has sales of $817,000, costs of $343,000, depreciation expense of $51,000, interest expense...

Billy's Exterminators, Inc., has sales of $817,000, costs of $343,000, depreciation expense of $51,000, interest expense of $38,000, and a tax rate of 21 percent. The firm just paid out $95,000 in cash dividends. The company has 90,000 shares of common stock outstanding. What is the earnings per share, or EPS, figure? What is the dividends per share?