Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DO IT IN A EXCEL SPREAD SHEET PLEASE with formulas shown(not written out) please thank you S & P Corporation (SPC) has an optimal capital
DO IT IN A EXCEL SPREAD SHEET PLEASE with formulas shown(not written out) 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started