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.
• SPCs current stock price is $54.79, its long run growth rate is 4.0% and its expected earnings per share (EPS₁) is $5.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):

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

Please show Excel work. Thank you :)