Question

In: Finance

your firm is considering two financing plans. The key information follows: use a 40% tax rate...

your firm is considering two financing plans. The key information follows: use a 40% tax rate

Source of funds Plan A Plan B
Long term Dent $500 @ 6% $2,500 @ 10%
Preferred Stock 50 shares, $2 dividend per share 10 shares, $2 dividend per share
Common Stock 60 shares 15 shares

Draw the Earning Per Share and Earning Before Interest Tax line for each plan on the same set axes. Over what range of Earnings before income tax would you prefer Plan A?

Show in excel if possible

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

With above EBIT-EPS Plot, Plan-A would be preferred if EBIT is below $312 because EPS of Plan-B is higher when EBIT > $312.

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.


Related Solutions

Your firm is considering two financing plans. The key information             follows: use a 20% tax...
Your firm is considering two financing plans. The key information             follows: use a 20% tax rate.             Source of Funds                      Plan A                         Plan B             Long-term Debt                      $1000 at 6%                $5000 at 10%             Preferred Stock                       100 shares, $2             20 shares, $2                                                             dividend per share      dividend per share             Common Stock                       120 shares                   30 shares             --------------------------------------------------------------------------------------                         Draw the EPS-EBIT line for each plan on the same set of axes. Over what range of EBIT would...
Use the following information for Ingersoll, Inc., (assume the tax rate is 40 percent):      2014...
Use the following information for Ingersoll, Inc., (assume the tax rate is 40 percent):      2014 2015   Sales $ 9,535 $ 10,109   Depreciation 1,295 1,296   Cost of goods sold 2,866 3,230   Other expenses 809 704   Interest 695 773   Cash 4,279 5,373   Accounts receivable 5,609 6,297   Short-term notes payable 964 916   Long-term debt 15,330 17,750   Net fixed assets 36,155 37,317   Accounts payable 4,656 4,355   Inventory 9,840 10,108   Dividends 1,126 1,221     For 2015, calculate the cash flow from assets, cash flow...
Use the following information for Ingersoll, Inc., (assume the tax rate is 40 percent):      2014...
Use the following information for Ingersoll, Inc., (assume the tax rate is 40 percent):      2014 2015   Sales $ 8,035 $ 8,609   Depreciation 1,145 1,146   Cost of goods sold 2,716 3,080   Other expenses 659 554   Interest 545 623   Cash 4,129 5,223   Accounts receivable 5,459 6,147   Short-term notes payable 814 766   Long-term debt 13,680 16,250   Net fixed assets 34,655 35,517   Accounts payable 4,356 4,205   Inventory 9,690 9,958   Dividends 976 1,071     For 2015, calculate the cash flow from assets, cash flow...
Use the following information to calculate the value of a business that your firm is considering...
Use the following information to calculate the value of a business that your firm is considering acquiring. Firm's WACC: 12.5% Firm's Cash Flows: $1 million FCF, years 1-4 $1.05 million FCF, year 5 5% growth after 4 years Please show step by step solution. Answer should be 8,462,060.
Tiger Woods Enterprises manufactures two products (information follows). Fixed costs are $250,000; the tax rate is...
Tiger Woods Enterprises manufactures two products (information follows). Fixed costs are $250,000; the tax rate is 35%. PRODUCT                                 SALES MIX                    SALES PRICE/UNIT         VARIABLE COST/UNIT Deceit Potion   2   $50   $25 Forgiveness Ointment               1   $40   $15 Calculate (A) the composite contribution margin per unit, (B) the break-even point in composite units, and (C) the amount of sales revenues in dollars if the company reports after-tax income of $550,000. Label your answers and round answers in units to the nearest unit.
Alternative Financing Plans Frey Co. is considering the following alternative financing plans: Plan 1 Plan 2...
Alternative Financing Plans Frey Co. is considering the following alternative financing plans: Plan 1 Plan 2 Issue 10% bonds (at face value) $1,200,000 $600,000 Issue preferred $1 stock, $10 par — 1,000,000 Issue common stock, $5 par 1,200,000 800,000 Income tax is estimated at 40% of income. Determine the earnings per share on common stock, assuming that income before bond interest and income tax is $480,000. Enter answers in dollars and cents, rounding to the nearest cent. Plan 1 $________...
Alternative Financing Plans Frey Co. is considering the following alternative financing plans: Plan 1 Plan 2...
Alternative Financing Plans Frey Co. is considering the following alternative financing plans: Plan 1 Plan 2 Issue 10% bonds (at face value) $1,320,000 $660,000 Issue preferred $1 stock, $10 par — 1,100,000 Issue common stock, $5 par 1,320,000 880,000 Income tax is estimated at 40% of income. Determine the earnings per share on common stock, assuming that income before bond interest and income tax is $1,056,000. Enter answers in dollars and cents, rounding to the nearest cent. Plan 1 $...
Alternative Financing Plans Frey Co. is considering the following alternative financing plans: Plan 1 Plan 2...
Alternative Financing Plans Frey Co. is considering the following alternative financing plans: Plan 1 Plan 2 Issue 10% bonds (at face value) $1,000,000 $500,000 Issue preferred $1 stock, $10 par — 830,000 Issue common stock, $5 par 1,000,000 670,000 Income tax is estimated at 40% of income. Determine the earnings per share on common stock, assuming that income before bond interest and income tax is $300,000. Enter answers in dollars and cents, rounding to two decimal places. Plan 1 $...
A firm is 65% equity and 35% debt. The firm's marginal tax rate is 40%. Their...
A firm is 65% equity and 35% debt. The firm's marginal tax rate is 40%. Their bonds trade for $990, mature in nine years, have a par value of $1,000, a coupon rate of 8.00% and pay semi-annually. The firm's common stock trades for $27 and just paid a dividend of $5.00. Dividends are expected to grow at 3% forever. The firm's after tax cost of debt is _____%. PLEASE USE FINNACE CALUATLER FOR ANSWER IF NOT USE BASIC CALUATOR...
Problem #1: A firm with a normalized pretax income of $40 million, 25% tax rate, and...
Problem #1: A firm with a normalized pretax income of $40 million, 25% tax rate, and a Total Debt/Total Capital ratio of 30%, decides to undertake a capital expansion financed by new debt. The new level of debt will raise the Total Debt/Total Capital ratio to 40% (5-percentage points above its industry average). As a result, the firm’s credit rating is downgraded by a full level (say for example, from A to B) despite being secured by specific assets. This...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT