chapter30
UN-19JCF1 234Growth rate 10%Discount rate 15%Year 0 1 2 3 4 5 6 7Cash flow -1150.00 234.00 257.40 283.14 311.45 342.60 376.86 414.55NPV 101.46 - =+B6+NPV(B3,C6:I6)IRR 17.60% - =IRR(B6:I6,0)=B8 =B9NPV IRR0 -176.46 9.71%Growth 5% -47.82 13.67%rate 10% 101.46 17.60%15% 274.35 21.50%=B8Discount rate101.46 7% 10% 12%Growth 0 111.09 -10.79 -82.08rate 5% 297.62 150.74 65.1310% 515.79 339.09 236.4415% 770.34 558.25 435.41A B C D E F G H I J K1234567891011121314151617181920212223242526UN-19JCF1 234增长率 10%折现率 15%年 0 1 2 3 4 5 6 7现金流量 -1150.00 234.00 257.40 283.14 311.45 342.60 376.86 414.55NPV 101.46 - =+B6+NPV(B3,C6:I6)IRR 17.60% - =IRR(B6:I6,0)=B8 =B9NPV IRR101.46 17.60%0 -176.462 0.097144增长率 5% -47.82 13.67%10% 101.46 17.60%15% 274.35 21.50%=B8折现率101.46 7% 10% 12%增长率 0 111.09 -10.79 -82.085% 297.62 150.74 65.1310% 515.79 339.09 236.4415% 770.34 558.25 435.41A B C D E F G H I J K1234567891011121314151617181920212223242526
