问题详情
问题已解决
所属话题:
#CMA#
question 表格后面还有 一组数据是 4 1000 6000
84785009 | 提问时间:2020 07/15 09:03
CMA徐老师
金牌答疑老师
职称:中级会计师,USCPA,CMA
Hi, I calculate the IRR using excel spreadsheet and the function called IRR(). A, I calculate Project As IRR as 34.903%, and Project B as 31.607%. B, for Project A, when discount rate is 0, present value is 4000-2000=2000, when discount rate is 5%, present value is 3545.95-2000=1545.950504, when discount rate is 10%, present value is 3169.87-2000=1169.865446, when discount rate is 20%, present value is 2588.73-2000=588.7345679. For project B , when discount rate is 0, present value is 6000-2000=4000, when discount rate is 5%, present value is 6000/(1+0.05)^4-2000=4936.214849-2000=2936.214849, when discount rate is 10%, present value is 6000/(1+0.1)^4-2000=4098.080732-2000=2098.080732, for discount rate of 20%, present value is 6000/(1+0.2)^4-2000=893.5185185 C. In term of the optimal choice, the rule of thumb is the project with the highest IRR is the best because it has a higher potential. In the regard, Project A is comparably better. When WACC reachs as high as 33%, Project A can still has a positive present value, whereas project B can not. But it is also worth noticing that in every level under 31.607%, Project B beat Project A. So in conclusion, Project A has higher potential, when Project B has better yield. 如果你对我的回复满意,麻烦给一个五星评价
2020 07/15 10:26
下载APP,拍照搜题秒出结果

您有一张限时会员卡待领取

00:10:00

免费领取