| Solution Excel File -- Fill in Yellow Cells -- Submit this Excel File with your Write Up |
| | Cost of Debt (PRE tax) | | <--- | show formula, not a hard-coded number |
| | Tax Rate |
| | After-Tax Cost of Debt | | <--- | show formula, not a hard-coded number |
| | Cost of Equity Using: (show explain assumptions for all in write up) |
| | 1. CAPM: | exhibit 4 has options | | 2. DDM: | exhibit 4 has options |
| | Risk Free Rate | | | Dividend Yield |
| | Equity Risk Premium | | | Growth |
| | Beta | | | Cost of Equity | 0.00% |
| | Cost of Equity | 0.00% |
| | 3. Earnings Cap |
| | Component | Weights | | After-Tax Cost | WACC |
| | Debt | | | 0.00% | 0.00% |
| | Equity | | | | 0.00% |
| | Total | 0.0% | | | 0.00% |
Rebel_1004
NikeTemplate.xlsx
