ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
WACC & D/E
3
4
Efecto D/E sobre costo de deuda (Kd)
Sí
5
Datos
6
Rf6%
7
Rm12%
8
Tasa impositiva
29.50%
9
Beta Desapalancado (𝛽u)
0.85
10
11
Prima de Riesgo Crediticia (PRC)
12
BBB2.00%
13
BB2.50%
14
B+3.00%
15
B-3.50%
16
CCC4.00%
17
CC5.00%
18
C6.00%
19
D7.00%
20
21
22
23
WACC =WeKe+WdKd(1-t)Ke =Rf𝛽Rm𝛽 =𝛽uD/E(1-t)PRCtRating
24
11.06%98%11%2%8.0%70.50%11%6%0.8612%0.860.850.0270.50%2.00%29.50%BBB
25
11.04%97%11%3%8.0%70.50%11%6%0.8712%0.870.850.0370.50%2.00%29.50%BBB
26
11.03%96%11%4%8.0%70.50%11%6%0.8712%0.870.850.0470.50%2.00%29.50%BBB
27
11.01%95%11%5%8.0%70.50%11%6%0.8812%0.880.850.0570.50%2.00%29.50%BBB
28
10.99%94%11%6%8.0%70.50%11%6%0.8912%0.890.850.0670.50%2.00%29.50%BBB
29
10.97%93%11%7%8.0%70.50%11%6%0.9012%0.900.850.0870.50%2.00%29.50%BBB
30
10.95%92%11%8%8.0%70.50%11%6%0.9012%0.900.850.0970.50%2.00%29.50%BBB
31
10.93%91%11%9%8.0%70.50%11%6%0.9112%0.910.850.1070.50%2.00%29.50%BBB
32
10.91%90%11%10%8.0%70.50%11%6%0.9212%0.920.850.1170.50%2.00%29.50%BBB
33
10.89%89%12%11%8.0%70.50%12%6%0.9212%0.920.850.1270.50%2.00%29.50%BBB
34
10.88%88%12%12%8.0%70.50%12%6%0.9312%0.930.850.1470.50%2.00%29.50%BBB
35
10.86%87%12%13%8.0%70.50%12%6%0.9412%0.940.850.1570.50%2.00%29.50%BBB
36
10.84%86%12%14%8.0%70.50%12%6%0.9512%0.950.850.1670.50%2.00%29.50%BBB
37
10.82%85%12%15%8.0%70.50%12%6%0.9612%0.960.850.1870.50%2.00%29.50%BBB
38
10.80%84%12%16%8.0%70.50%12%6%0.9612%0.960.850.1970.50%2.00%29.50%BBB
39
10.78%83%12%17%8.0%70.50%12%6%0.9712%0.970.850.2070.50%2.00%29.50%BBB
40
10.76%82%12%18%8.0%70.50%12%6%0.9812%0.980.850.2270.50%2.00%29.50%BBB
41
10.75%81%12%19%8.0%70.50%12%6%0.9912%0.990.850.2370.50%2.00%29.50%BBB
42
10.73%80%12%20%8.0%70.50%12%6%1.0012%1.000.850.2570.50%2.00%29.50%BBB
43
10.71%79%12%21%8.0%70.50%12%6%1.0112%1.010.850.2770.50%2.00%29.50%BBB
44
10.69%78%12%22%8.0%70.50%12%6%1.0212%1.020.850.2870.50%2.00%29.50%BBB
45
10.67%77%12%23%8.0%70.50%12%6%1.0312%1.030.850.3070.50%2.00%29.50%BBB
46
10.65%76%12%24%8.0%70.50%12%6%1.0412%1.040.850.3270.50%2.00%29.50%BBB
47
10.63%75%12%25%8.0%70.50%12%6%1.0512%1.050.850.3370.50%2.00%29.50%BBB
48
10.62%74%12%26%8.0%70.50%12%6%1.0612%1.060.850.3570.50%2.00%29.50%BBB
49
10.60%73%12%27%8.0%70.50%12%6%1.0712%1.070.850.3770.50%2.00%29.50%BBB
50
10.58%72%12%28%8.0%70.50%12%6%1.0812%1.080.850.3970.50%2.00%29.50%BBB
51
10.56%71%13%29%8.0%70.50%13%6%1.0912%1.090.850.4170.50%2.00%29.50%BBB
52
10.54%70%13%30%8.0%70.50%13%6%1.1112%1.110.850.4370.50%2.00%29.50%BBB
53
10.52%69%13%31%8.0%70.50%13%6%1.1212%1.120.850.4570.50%2.00%29.50%BBB
54
10.50%68%13%32%8.0%70.50%13%6%1.1312%1.130.850.4770.50%2.00%29.50%BBB
55
10.48%67%13%33%8.0%70.50%13%6%1.1512%1.150.850.4970.50%2.00%29.50%BBB
56
10.47%66%13%34%8.0%70.50%13%6%1.1612%1.160.850.5270.50%2.00%29.50%BBB
57
10.45%65%13%35%8.0%70.50%13%6%1.1712%1.170.850.5470.50%2.00%29.50%BBB
58
10.43%64%13%36%8.0%70.50%13%6%1.1912%1.190.850.5670.50%2.00%29.50%BBB
59
10.41%63%13%37%8.0%70.50%13%6%1.2012%1.200.850.5970.50%2.00%29.50%BBB
60
10.39%62%13%38%8.0%70.50%13%6%1.2212%1.220.850.6170.50%2.00%29.50%BBB
61
10.37%61%13%39%8.0%70.50%13%6%1.2312%1.230.850.6470.50%2.00%29.50%BBB
62
10.35%60%13%40%8.0%70.50%13%6%1.2512%1.250.850.6770.50%2.00%29.50%BBB
63
10.34%59%14%41%8.0%70.50%14%6%1.2712%1.270.850.6970.50%2.00%29.50%BBB
64
10.32%58%14%42%8.0%70.50%14%6%1.2812%1.280.850.7270.50%2.00%29.50%BBB
65
10.30%57%14%43%8.0%70.50%14%6%1.3012%1.300.850.7570.50%2.00%29.50%BBB
66
10.28%56%14%44%8.0%70.50%14%6%1.3212%1.320.850.7970.50%2.00%29.50%BBB
67
10.26%55%14%45%8.0%70.50%14%6%1.3412%1.340.850.8270.50%2.00%29.50%BBB
68
10.24%54%14%46%8.0%70.50%14%6%1.3612%1.360.850.8570.50%2.00%29.50%BBB
69
10.22%53%14%47%8.0%70.50%14%6%1.3812%1.380.850.8970.50%2.00%29.50%BBB
70
10.21%52%14%48%8.0%70.50%14%6%1.4012%1.400.850.9270.50%2.00%29.50%BBB
71
10.19%51%15%49%8.0%70.50%15%6%1.4312%1.430.850.9670.50%2.00%29.50%BBB
72
10.17%50%15%50%8.0%70.50%15%6%1.4512%1.450.851.0070.50%2.00%29.50%BBB
73
10.15%49%15%51%8.0%70.50%15%6%1.4712%1.470.851.0470.50%2.00%29.50%BBB
74
10.13%48%15%52%8.0%70.50%15%6%1.5012%1.500.851.0870.50%2.00%29.50%BBB
75
10.11%47%15%53%8.0%70.50%15%6%1.5312%1.530.851.1370.50%2.00%29.50%BBB
76
10.09%46%15%54%8.0%70.50%15%6%1.5512%1.550.851.1770.50%2.00%29.50%BBB
77
10.07%45%15%55%8.0%70.50%15%6%1.5812%1.580.851.2270.50%2.00%29.50%BBB
78
10.06%44%16%56%8.0%70.50%16%6%1.6112%1.610.851.2770.50%2.00%29.50%BBB
79
10.04%43%16%57%8.0%70.50%16%6%1.6412%1.640.851.3370.50%2.00%29.50%BBB
80
10.02%42%16%58%8.0%70.50%16%6%1.6812%1.680.851.3870.50%2.00%29.50%BBB
81
10.00%41%16%59%8.0%70.50%16%6%1.7112%1.710.851.4470.50%2.00%29.50%BBB
82
 >9.98%40%16%60%8.0%70.50%16%6%1.7512%1.750.851.5070.50%2.00%29.50%BBB
83
10.18%39%17%61%8.5%70.50%17%6%1.7912%1.790.851.5670.50%2.50%29.50%BB
84
10.16%38%17%62%8.5%70.50%17%6%1.8312%1.830.851.6370.50%2.50%29.50%BB
85
10.15%37%17%63%8.5%70.50%17%6%1.8712%1.870.851.7070.50%2.50%29.50%BB
86
10.13%36%17%64%8.5%70.50%17%6%1.9212%1.920.851.7870.50%2.50%29.50%BB
87
10.12%35%18%65%8.5%70.50%18%6%1.9612%1.960.851.8670.50%2.50%29.50%BB
88
10.10%34%18%66%8.5%70.50%18%6%2.0112%2.010.851.9470.50%2.50%29.50%BB
89
10.32%33%18%67%9.0%70.50%18%6%2.0712%2.070.852.0370.50%3.00%29.50%B+
90
10.31%32%19%68%9.0%70.50%19%6%2.1212%2.120.852.1270.50%3.00%29.50%B+
91
10.30%31%19%69%9.0%70.50%19%6%2.1812%2.180.852.2370.50%3.00%29.50%B+
92
10.29%30%19%70%9.0%70.50%19%6%2.2512%2.250.852.3370.50%3.00%29.50%B+
93
10.28%29%20%71%9.0%70.50%20%6%2.3212%2.320.852.4570.50%3.00%29.50%B+
94
10.27%28%20%72%9.0%70.50%20%6%2.3912%2.390.852.5770.50%3.00%29.50%B+
95
10.25%27%21%73%9.0%70.50%21%6%2.4712%2.470.852.7070.50%3.00%29.50%B+
96
10.24%26%21%74%9.0%70.50%21%6%2.5612%2.560.852.8570.50%3.00%29.50%B+
97
10.23%25%22%75%9.0%70.50%22%6%2.6512%2.650.853.0070.50%3.00%29.50%B+
98
10.49%24%22%76%9.5%70.50%22%6%2.7512%2.750.853.1770.50%3.50%29.50%B-
99
10.48%23%23%77%9.5%70.50%23%6%2.8612%2.860.853.3570.50%3.50%29.50%B-
100
10.47%22%24%78%9.5%70.50%24%6%2.9712%2.970.853.5570.50%3.50%29.50%B-