DO IT IN A EXCEL SPREAD SHEET PLEASE with formulas shown on how to get the cell (not written out in words) please thank you

S & P Corporation (SPC) has an optimal capital structure of 45 percent debt and 55 percent equity. Given the following information, calculate the marginal cost of capital (MCC) schedule and the optimal capital budget (e.g. how much is the optimal capital budget and what is the corporate cost of capital?).

• 5 years ago, the company issued non-callable bonds that pay semiannual payment with 6.50% annual coupon rate and sold them at par value ($1,000). However, each bond is currently selling at 1040 and has 20 years remaining to maturity.
• SPC's current stock price is $50.00, its long run growth rate is 3.0% and its expected earnings per share (EPS) is $4.0. The company retains 20% of its earnings to fund future growth.
• There are 102.5 million common shares outstanding.
• New common stock may be issued with 5 percent flotation costs.
• The marginal tax rate is 26%.
• SPC has the following Investment Opportunity Schedule (IOS):

Complete in excel with formulas showing how

Project	IRR	Cost (millions)
A	15.2%	20
B	12.5%	55
C	9.0%	45
D	7.5%	40
E	6.0%	50

S&P Corporation (SPC) has an optimal capital structure of 45 percent debt and 55 percent equity. Given the following information, calculate the marginal cost of capital (MCC) schedule and the optimal capital budget (e.g. how much is the optimal capital budget and what is the corporate cost of capital?). 5 years ago, the company issued non-callable bonds that pay semiannual payment with 6.50% annual coupon rate and sold them at par value ($1,000). However, each bond is currently selling at 1040 and has 20 years remaining to maturity. SPC's current stock price is $50.00, its long run growth rate is 3.0% and its expected earnings per share (EPS) is $4.0. The company retains 20% of its earnings to fund future growth. There are 102.5 million common shares outstanding. New common stock may be issued with 5 percent flotation costs. The marginal tax rate is 26%. SPC has the following Investment Opportunity Schedule (IOS): IRR Project A B Cost (millions) 20 55 45 40 50 15.2% 12.5% 9.0% 7.5% 6.0% C D E S&P Corporation (SPC) has an optimal capital structure of 45 percent debt and 55 percent equity. Given the following information, calculate the marginal cost of capital (MCC) schedule and the optimal capital budget (e.g. how much is the optimal capital budget and what is the corporate cost of capital?). 5 years ago, the company issued non-callable bonds that pay semiannual payment with 6.50% annual coupon rate and sold them at par value ($1,000). However, each bond is currently selling at 1040 and has 20 years remaining to maturity. SPC's current stock price is $50.00, its long run growth rate is 3.0% and its expected earnings per share (EPS) is $4.0. The company retains 20% of its earnings to fund future growth. There are 102.5 million common shares outstanding. New common stock may be issued with 5 percent flotation costs. The marginal tax rate is 26%. SPC has the following Investment Opportunity Schedule (IOS): IRR Project A B Cost (millions) 20 55 45 40 50 15.2% 12.5% 9.0% 7.5% 6.0% C D E