Two firms are identical in assets value, EBIT, and stock price per share, but one firm is unlevered, and another firm is levered with $$5,000$ debt and $8\%$ interest, as illustrated in the table below. Please solve for the equity value, number of stock shares outstanding debt to assets ratio, earnings per share, and return on equity for both unlevered and levered firm, assuming that tax rate is $0\%$ and that the market value of equity is the same as the book value of equity. You can copy and paste the table for Excel for easier computation. $(6$ points$)$

$\backslash$table$[[$Assets$,$Unlevered Firm,Levered Firm$],[$$$,20\mathrm{.}000,$$$,20,000],[$Debt$,$$$,-,,5,000]]$

$\backslash$table$[[$Equity$,,,,],[\backslash$table$[[$Equity$],[$Interest Rate$]]],[,,,,],[$Share Price,$$,100,$$$,100],[\backslash$table$[[$Share Price$],[$Shares Outstanding$]]],[\backslash$table$[[$Shares Outstanding$],[$Debt$/$Asset Ratio$]]],[,,2000,$$$,2000],[\backslash$table$[[$EBIT$],[$Interest Expense$]]],[\backslash$table$[[$Interest Expense$],[$Net Income$]]],[\backslash$table$[[$Net Income$],[$Earnings per Share$]]],[$Return on Equity,,,,$]]$

Activate Windows