Ezzell Enterprises has the following capital structure, which it considers to be optimal under present and forecasted conditions 45% Debt (long-term only) Common equity Total liabilities and equity 100% For the coming year, management policy of paying out 60 percent of earnings will continue. allow Ezzell to borrow according to the following schedule: expects after-tax earnings of $2.5 million. Ezzell's past dividend Present commitments from its banker will S to S500,000 $500,001 to $900,000 $900,001 and above 996 on this increment of debt 11% on this increment of debt 13% on this increment ofdebt The company's marginal tax rate is 40 percent, the current market price of its stock is $22 per share, its last dividend was $2.20 per share, and the expected growth rate is 5 percent. External equity (new common) can be sold at a flotation cost of 10 percent Ezzell has the following independent investment opportunities for the next year: $675,000 900,000 375,000 562,500 750,000 16.0% 15.0 14.0 12.5 11.0 Management asks you to help determine which projects (if any) should be undertaken. You proceed with this analysis by answering the following questions (or performing the tasks) as posed in a logical sequence: a. How many breaks are there in the MCC schedule? At what dollar amounts do the breaks occur, and Enter what causes them? b. What is the weighted average cost of capital in each of the intervals between the breaks? c. Which projects should Ezzell's management accept? d. What assumptions about project risk are implicit in this problem? If you learned that Projects 1, 2, and 3 were of above-average risk, yet Ezzell chose the projects that you indicated in part (e), how would this affect the situation? The problem stated that Ezzell pays out 60 percent of its earnings as dividends. How would the analysis change if the payout ratio were changed to zero, to 100 percent, or somewhere in between? (No calculations are necessary.) e. Notes Please do it in excel showing formula please