how to solve this through excel

A company is planning a $50 million expansion. The expansion is to be financed by selling $20 million in new debt and $30 million in new common stock. The before-tax required return on debt is 9% and 14% fo earitu If the company is in the 40% tax bracket, the company's marginal cost of capital is closest to: c Question 4 A company has $5 million in debt outstanding with a coupon rate of 12%. Currently, the yield to maturity (YTM) on these bonds is 14%. If the firm's tax rate is 40%, what is the company's after-tax cost of debt