Assume you have just been hired as a business manager of Bernie’s Pizza Plaza a regional pizza restaurant chain. The company’s EBIT was $95 million last year and is not expected to grow. The firm is currently financed with all equity and it has 10 million shares outstanding. When you took your corporate finance course, your instructor stated that most firm’s owners would be financially better off if the firms used some debt. When you suggested this to your new boss, he encouraged you to pursue the idea. As a first step, assume that you obtained from the firm’s investment banker the following estimated costs of debt for the firm at different capital structures:

                                                   % Financed With Debt            rd           

                                                               0%                              ---      

                                                              35                                 8.0%     

                                                              45                                 8.5      

                                                              55                                10.5      

                                                              65                               12.5      

If the company were to recapitalize, debt would be issued, and the funds received would be used to repurchase stock. Bernie’s is in the 30 percent state-plus-federal corporate tax bracket, its unlevered beta is .95, the risk-free rate is 3 percent, and the market risk premium is 8 percent.

1. For each capital structure under consideration, calculate the levered beta, the cost of equity, and the WACC.

2. Now calculate the corporate value for each capital structure.

PLEASE SHOW ALL WORK IN EXCEL