The after-tax costs for each source will be as follows: 8% for debt, 10.5% for preferred equity,
Fantastic news! We've Found the answer you've been seeking!
Question:
- The after-tax costs for each source will be as follows: 8% for debt, 10.5% for preferred equity, and 12.75% for common equity.
Calculate the WACC in another spreadsheet within your Excel worksheet.
- Given the following data:
Fountain | Price by unit | Units | Total market value | Percentage of total |
Debt | $1,035.65 | 750 | $776,737.50 | 17.25% |
Preferred capital | 200.00 | 2,000 | 400,000 | 8.89% |
common capital | 95.00 | 35,000 | 3,325,000 | 73.86% |
Totals | $4,501,737.50 | 100% |
Posted Date: