Answer this in excel

Alpha Company has the following capital structure: Earnings per share have grown steadily from $0.93 in 19X0 to $2.00 estimated in 19X8. Expecting this growth to continue, the investment community has applied a price/earnings ratio of 10 to the firm's earnings yielding a market price for its stock of $20.00. Alpha's last annual dividend was $1.25, and securities analysts indicate they expect the dividend to continue to grow with earnings. After taxes at 34% and dividends this year, Alpha anticipates adding $4,000,000 to retained earnings. Assuming the current capital structure is maintained, new securities could be sold in the following sequence: Bonds: Up to $5 million of 30 year bonds with a 10% yield and a 3% flotation cost. Next, up to $3 million of additional 30 year bonds with a 11% yield and a 5% flotation cost. Next up to $2 million of additional 30 year bonds with a 13% coupon and an 8% flotation cost. Preferred stock: Up to $1 million with a 12% dividend and a 4% flotation cost. Next, up to another $1 million with a 13% dividend and a 6% flotation cost. Next, up to a third $1 million with a 15% dividend and a 8% flotation cost. Common stock: Up to $6 million at $20 per share less a $2.50 per share flotation cost. Over $6 million at $19 per share less a $4.00 per share flotation cost. Required Calculate the "cost" of each tranche of bond, preferred and common stock financing. At what dollar amounts of new capital will breaks occur in the marginal cost of capital (MCC) schedule? Calculate the MCC in the interval between each break, then plot the MCC curve. What factors in the real world would tend to make the MCC curve smooth rather than a step-function as you have graphed it