EXCEL财务模型库-边际资本成本.xls

《EXCEL财务模型库-边际资本成本.xls》由会员分享，可在线阅读，更多相关《EXCEL财务模型库-边际资本成本.xls（8页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、资本类型筹资结构下限上限资本成本突破点筹资总额 A20% 06.65%33.0下限 7.6206%100.00 21407%200.026 41608%300.031 61849%420.034 8510%51 B30% 0189%60.061 193310%110.076 344011%133.391 414512%150.0101 466313%210.0111 6414%116 C10% 03211%320.0. 334512%450.0. 465014%500.0. 515516%550.0. 566018%600.0. 6120%. D20% 055%25.0. 6106%50.0.

2、 11157%75.0. 16238%115.0. 24259%125.0. 2610%. E20% 069%30.0. 71810%90.0. 150100500 0% 2% 4% 6% 8% 10% 12% 筹资总额 资本成本 193511%175.0. 364612%230.0 474813%240.0 4914% E20% 资本成本 上限 257.60% 307.80% 338.00% 508.20% 608.40% 758.70% 908.90% 1009.10% 1109.30% 1159.60% 9.80% . . . . . . . . . . . . . . 筹资总额 . 筹

3、资结构下限上限资本类型资本成本边际资本成本 20%025A5.00%7.60%下限上限边际资本成本 30%B9.00%0257.60% 10%C11.00%26307.80% 20%D5.00%31338.00% 20%E9.00%34508.20% 2630A5.00%7.80%51608.40% B9.00%61758.70% C11.00%76908.90% D6.00%911009.10% E9.00%1011109.30% 3133A5.00%8.00%1111159.60% B9.00%1169.80% C11.00% D6.00% E10.00% 3450A6.00%8.20%

4、B9.00% C11.00% D6.00% E10.00% 51 60 A 6.00%8.40% B9.00% C11.00% D7.00% E10.00% 6175A6.00%8.70% B10.00% C11.00% D7.00% E10.00% 7690A6.00%8.90% B10.00% C11.00% D8.00% E10.00% 91 100 A 6.00%9.10% B10.00% C11.00% D8.00% E11.00% 101 110 A 7.00%9.30% B10.00% C11.00% D8.00% E11.00% 111115A7.00%9.60% B11.00

5、% C11.00% D8.00% E11.00% 116125A7.00%9.80% B11.00% C11.00% D9.00% E11.00% 126 133 A 7.00%10.00% B11.00% C11.00% D10.00% E11.00% 134150A7.00%10.30% B12.00% C11.00% D10.00% E11.00% 151 175 A 7.00%10.60% B13.00% C11.00% D10.00% E11.00% 176 200 A 7.00%10.80% B13.00% C11.00% D10.00% E12.00% 201210A8.00%1

6、1.00% B13.00% C11.00% D10.00% E12.00% 211230A8.00%11.30% B14.00% C11.00% D10.00% E12.00% 231240A8.00%11.50% B14.00% C11.00% D10.00% E13.00% 241300A8.00%11.70% B14.00% C11.00% D10.00% E14.00% 301320A9.00%11.90% B14.00% C11.00% D10.00% E14.00% 321420A9.00%12.00% B14.00% C12.00% D10.00% E14.00% 421450A

7、10.00%12.20% B14.00% C12.00% D10.00% E14.00% 451500A10.00%12.40% B14.00% C14.00% D10.00% E14.00% 501550A10.00%12.60% B14.00% C16.00% D10.00% E14.00% 551600A10.00%12.80% B14.00% C18.00% D10.00% E14.00% 601A10.00%13.00% B14.00% C20.00% D10.00% E14.00% 07.60% 257.60% 257.80% 307.80% 308.00% 338.00% 338.20% 508.20% 508.40% 608.40% 608.70% 758.70% 758.90% 908.90% 909.10% 1009.10% 1009.30% 1109.30% 1109.60% 1159.60% 1159.80% 1279.80%