Question
David and Amelia's Toy Company Please explain in EXCEL (show formulas) where the HIGHLIGHTED % come from please. Formula Answer EQUITY INFO 1. After tax
David and Amelia's Toy Company
Please explain in EXCEL (show formulas) where the HIGHLIGHTED % come from please.
| Formula | Answer |
| EQUITY INFO |
1. After tax cost of equity funding | D0*(1+G)/P | 14% |
| 50 million shares |
|
|
|
| Issued with $40 Par value |
2. After tax cost of LT debt funding | I(1-t)+(RV-NP/n) | 6% |
| P=Sold at $40 per share, no excess |
| /(RV+NP)/2 |
|
| Market Price: $80 per share |
|
|
|
| D0 = $5.15 |
| 6.576666667 |
|
| Growth Rate = 5.0% |
| 104 |
|
| Flotation Cost = 9.0% |
|
|
|
| Retained Earnings = $1 billion |
3. The book value weights |
|
|
|
|
Common stock | 50000000 x $40/share | 2,000,000,000 |
| DEBT INFO |
Retained earnings |
| 1,000,000,000 |
| $1 billion in outstanding debt |
TOTAL EQUITY | 75% | 3,000,000,000 |
| $1,000 face value per bond |
TOTAL DEBT | 25% | 1,000,000,000 |
| Current quote = 110 |
|
|
|
| I= Coupon rate = 9%, semiannual coupons |
|
|
|
| n= 15 years to maturity |
4. The marginal or market value weights |
|
|
| Flotation Cost = 2% |
Common stock | 50000000*72.8 | 3,640,000,000 |
| RV = $100 face value |
Retained earnings |
| 1,000,000,000 |
| NP = net proceeds = 108 |
TOTAL EQUITY | 81% | 4,640,000,000 |
|
|
TOTAL DEBT | 19% | 1,078,000,000 |
|
|
|
|
|
| Marginal Tax Bracket |
|
|
|
| t = tax rate 21% |
5. After tax WACC at book value |
|
|
| |
Common stock | 75% | 13.50% |
| $80*9% float = 7.2 - $80 - 72.8 = price |
Retained earnings | 25% | 6.30% |
| |
WACC @ book |
|
|
| |
|
|
|
| |
6. After tax WACC at market value |
|
|
| |
Common stock | 81% | 13.50% |
| |
Retained earnings | 19% | 6.30% |
| |
WACC @ market |
|
|
| |
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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