Need in 7 hours
studystudent
minicaseTemplate111.xlsxMainModel
| EMN Cost of Capital | |
| Stock Price | |
| Shares outstanding | |
| Market Value of Equity | |
| Market Value of Bond | |
| Dividend Yield | |
| Tax Rate | |
| Risk Free Rate | |
| Market Risk Premium | |
| Growth Rate (5 year) | |
| Cost of Capital from CAPM | |
| Cost of Equity from DDM | |
| Cost of Equity | |
| Cost of Debt | |
| Cost of Capital |
Regression
Beta Estimation
| EMN Beta Estimation | ||
| Beta | ||
| Method 1 | Regression | |
| Method 2 | Yahoo Finance | |
| Final Estimation | ||
| (please compare Beta from Yahoo Finance and Regression and determine the final Beta used in your mini case) |
Bonddata
| Settlement Data | Maturity Date | Price | Coupon % | frequency | YTM | book Amount $ | Market Amount $ |
