Reference no: EM132063954

Powder Rangers has expected sales of $3 million a year. Variable costs are expected to be 55 percent of sales and fixed operating costs are $800000 a year. Total capital is presently $1000000 and must be expanded to $2000000 to generate the anticipated sales level. The company presently has no debt outstanding, and 50000 shares of stock. Additional common stock could be sold for $10 a share. The interest rate on new debt would be 6 percent and the tax rate is 35 percent. Compute the return on equity and earnings per share assuming the expansion is financed: Sales of $3 million, Var. cost of 55% of sales, Fixed cost of $800000 per year, new capital needed $1000000 ($2000000 - $1000000), number of shares 50000 shares, stock price of $10, interest expense of 6%, tax of 35%, assume no preferred dividends. a. exclusively with debt, b. exclusively with equity and c. with one-half debt and one-half equity.

1) Calculate return on equity (ROE) and earnings per share (EPS) if expansion is financed by equity.

A  35.75%; $7.15

B  17.88%; $2.38

C  21.23%; $3.19

D  23.18%; $3.48

E  31.85%; $6.37

2) Calculate return on equity (ROE) and earnings per share (EPS) if expansion is financed by debt.

A 23.18%; $3.48

B 35.75%; $7.15

C 17.88%; $2.38

D 31.85%; $6.37

3) Calculate return on equity (ROE) and earnings per share (EPS) if expansion is financed by equity and debt equally.

A 35.75%; $7.15

B 21.23%; $3.19

C 17.88%; $2.38

D 23.18%; $3.48

Please show calculation in Excel on how to get the answers and show the function page.