用Excel计算资本成本

14/2006/3/23/023Excel()=()Excel()=(1)1(1)=(1)(1)=(1)11615008%0.5%33%5.387%B7=B3(1B6)(1B5)24(2)G3=A3(1D3)PV(F3C3A3B3(1E3)A3)A3(1D3)PV(F3C3A3B3(1E3)A3)G30F35.460%IRFIA6=A3(1D3)B6G6156F6=E6=D6=C6=B6=$A$3$B$3(1$E$3)G6=$A$3$B$3(1$E$3)A3G2=IRR(A6G6)G2IRR()()ExcelF30(10%)G3=A3(1D3)PV(F3C3A3B3(1E3)A3)$G$30F3F35.460%IRR342()21000713%3%110033%5A6=A3(1E3)B6C6D6E6F6G6=$B$3$C$3(1$F$3)H6=$B$3$C$3(1$F$3)B3H2=IRR(A6H6)()1()=(1)2=1(1)+3=[phone]%2%300013%1%3%B7=B5+B6C7=C5(1C4)D7=D5(1D4)+D644()47B3F4G3=SUM(B3:F3)B5=B3G3C5=C3G3,D5=D3G3,E5=E3G3F5=F3(33,G5=SUM(B5:F5)B6=SUMPRQDUCT(B4:F4,B5:F5)SUMPRODUCTSUMPRODUCT(B4:F4,B5:F5)B4B5+C4C5+D4D5+F4E5+F4F5