Coût du capital - modèle excel

Estimation of Current Cost of Capital
Inputs
Equity
Number of Shares outstanding =
1000
Current Market Price per share =
10
Number of Warrants Outstanding =
0
Current Market Price per Warrant =
3
Current Beta =
1,2
Riskfree Rate =
4%
Risk Premium =
4,84%
Debt
Book Value of Straight Debt =
5000
Interest Expense on Debt =
600
Average Maturity =
5
Pre-tax Cost of Debt =
7%
Tax Rate =
35%
Book Value of Convertible Debt =
0
Interest Expense on Convertible =
0
Maturity of Convertible Bond =
10
Market Value of Convertible =
0
Debt value of operating leases =
Preferred Stock
Number of Preferred Shares =
0
Current Market Price per Share=
70
Annual Dividend per Share =
5
Output
Estimating Market Value of Straight Debt =
$6 025,05
Estimated Value of Straight Debt in Convertible =
$-
Value of Debt in Operating leases =
$-
Estimated Value of Equity in Convertible =
$-
Equity
Debt
Preferred Stock
Capital
Market Value
$10 000,00
$6 025,05
$- $16 025,05
Weight in Cost of Capital
62,40%
37,60%
0,00%
100,00%
Cost of Component
10,09%
4,55%
7,14%
8,01%

---