Question

In: Accounting

Consider the following data for the XYZ Company: Assets: $150 million Equity: $90 million Sales: $75...

Consider the following data for the XYZ Company:

Assets: $150 million

Equity: $90 million

Sales: $75 million

EBIT: $26 million

Profit (bt) $20 million

Profit (at) $15 million

a) How much debt does XYZ have in its capital structure?

b) How much interest is XYZ paying on this debt? What is the interest rate?

c) How much in taxes is XYZ paying? What is the tax rate?

d) What is XYZ company's current ROE?

e) Suppose, XYZ could save $10 million in labor costs per year by purchasing a state-

of-the-art, new machine. However, the new machine will cost $30 million. If XYZ

buys the new machine by borrowing $30 million. What will the new ROE?

[Assume they can borrow the $30 million at the same interest rate as the existing

borrowed money. Please calculate the new ROE under these conditions assuming the

tax rate remains unchanged. Assume all else remains unchanged.]

f) Suppose, after careful consideration of the additional debt suggested in part f), XYZ

decides to purchase the new machine by selling common stock (equity) to raise the $30

million. Please calculate the ROE under these conditions assuming all else remains the

same.

Expert Solution

a	Accounting Equation
	Particulars	Amount
	Assets	150.00
	Equity	90.00
	Debt(150-90)	60.00

b	Particulars	Amount
	EBIT	26.00
	Less: Interest(Bal.fig)	6.00
	PBT	20.00
	Debt(from above)	60.00
	% of Interest(6/60)	10.00%

c	Particulars	Amount
	PBT	20.00
	Less: Tax(20-15)	5.00
	PAT	15.00
	Tax Rate(5/20)	25.00%

d	Particulars	Amount
	Net Income(PAT)	15.00
	Equity	90.00
	ROE(15/90)	17%

e	Particulars	Amount
	EBIT(26+10)	36.00
	Less: Interest(6+30*10%)	9.00
	PBT	27.00
	Less: Tax(27*25%)	6.75
	PAT	20.25

	Accounting Equation
	Particulars	Amount
	Assets(150+30(machine cost))	180.00
	Equity	90.00
	Debt(180-90(60+30 borrowing))	90.00

	Particulars	Amount
	Net Income(PAT)	20.25
	Equity	90.00
	ROE(20.25/90)	23%

f	Particulars	Amount
	EBIT(26+10)	36.00
	Less: Interest(6)	6.00
	PBT	30.00
	Less: Tax(30*25%)	7.50
	PAT	22.50

	Accounting Equation
	Particulars	Amount
	Assets(150+30(machine cost))	180.00
	Equity	60.00
	Debt(180-60)	120.00

	Particulars	Amount
	Net Income(PAT)	22.50
	Equity	60.00
	ROE(22.5/60)	38%

ekkarill92 answered 1 year ago

Standard bank has assets of $ 150 million, liabilities of $ 135 million and equity of...

Standard bank has assets of $ 150 million, liabilities of $ 135 million and equity of $ 15 million. It asset duration is six years and the duration of the liabilities is for four years. Standards bank wishes to hedge the balance sheet with 20-year T-bond futures contracts, witch are currently trading at $95 per $100 face value and duration of 10.37 year. Note that T-bond futures are sold in $100000 face value per contract. What is the duration gap...

Please consider the following data for the Hercules Company: Assets: $3 billion Equity: &nbs

Please consider the following data for the Hercules Company: Assets: $3 billion Equity: $2 billion Sales: $1.5 billion EBIT: $300 million Profit (bt) $200 million Profit (at) $150 million Payout ratio is: 30% Number of common stock shares outstanding is: 50 million shares a) How much interest is Hercules paying on this debt? b What is Hercules Company’s current ROE & ROI (return on investment or return on assets)? c) i) If Hercules were to float (sell) $500 million...

Tree row bank has assets of $150 million, liabilities of $135 million, and equity of $15...

Tree row bank has assets of $150 million, liabilities of $135 million, and equity of $15 million. The asset duration is six years and the duration of the liabilities is four years. Market interest rates are 10 percent. Tree row bank wishes to hedge the balance sheet with treasury bond futures contracts, which currently have a prim quote of $95 per $100 face value for the benchmark 20-year, 8 percent coupon underlying the contract, a market yield of 8.5295 percent,...

Tree Row Bank has assets of $150 million, liabilities of $135 million, and equity of $15...

Tree Row Bank has assets of $150 million, liabilities of $135 million, and equity of $15 million. The asset duration is six years and the duration of the liabilities is four years. Market interest rates are 10 percent. Tree Row Bank wishes to hedge the balance sheet with Treasury bond futures contracts, which currently have a price quote of $95 per $100 face value for the benchmark 20-year, 8 percent coupon bond underlying the contract, a market yield of 8.5295...

Consider the following data for Nike Inc.: In 2009 it had $ 19 comma 150 million...

Consider the following data for Nike Inc.: In 2009 it had $ 19 comma 150 million in sales with a 10% growth rate in 2010, but then slows by 1 % to the long-run growth rate of 5% by 2015. Nike expects EBIT to be 10% of sales, increases in net working capital requirements to be 10% of any increases in sales, and capital expenditures to equal depreciation expenses. Nike also has $2 comma 300 million in cash, $32 million...

Dearborn Supplies has total sales of $191 million, assets of $95 million, a return on equity...

Dearborn Supplies has total sales of $191 million, assets of $95 million, a return on equity of 32 percent, and a net profit margin of 7.3 percent. What is the firms debt ratio? The company's debt ratio is what percent? Round to one decimal place.

The Sooner Equipment Company has total assets of $90 million. Of this total, $40 million was...

The Sooner Equipment Company has total assets of $90 million. Of this total, $40 million was financed with common equity and $50 million with debt (both long and short-term). Its average accounts receivable balance is $20 million, and this represents an 85-day average collection period. Sooner believes it can reduce its average collection period from 85 to 65 days without affecting sales or the dollar amount of net income after taxes (currently $4.71 million). What will be the effect of...

% - XYZ Company provides you with the following data projected for 2018: Projected sales are...

% - XYZ Company provides you with the following data projected for 2018: Projected sales are 30,000 units. Inventory at Dec 31,2017 was 4,000 manufactured units. The desired ending for Dec 31, 2018 is 8,000 manufactured units. a) 5% - Provide a production budget for the number of units that need to be produced. b) 6% - Assume for each unit manufactured, four pounds of raw materials are needed. Assume the desired ending inventory became 10,000 manufactured units. What effect...

Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 73,802 Assets 209,087...

Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 73,802 Assets 209,087 Debt 38,278 Costs 44,281 Equity 170,809 EBIT 29,521 Taxes @ 38% 11,218 Total 209,087 Total 209,087 Net Income 18,303 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,907 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to grow by 25%. What is the pro-forma value for equity?...

Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 63,252 Assets 122,852...

Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 63,252 Assets 122,852 Debt 28,164 Costs 37,951 Equity 94,688 EBIT 25,301 Taxes @ 38% 9,614 Total 122,852 Total 122,852 Net Income 15,687 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,918 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to grow by 20%. What is the pro-forma value for equity?...