chapter 14

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page.

A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in the 35% tax bracket.

Part 1: Construct the bottom half of the income statement (including EPS) for each financing alternative when EBIT is at $6,000,000.

Part 2: Construct the bottom half of the income statement (including EPS) for each alternative if EBIT increases by 20%.

Part 3: Construct the bottom half of the income statement (including EPS) for each alternative if EBIT decreases by 20%.

Part 4: What is the EBIT/EPS indifference point for this firm?

Part 5: Comment on the results of your calculations above. What principle does this exercise demonstrate?