lecture9 NPV
第八章 NPV及其它投资准绳-PPT文档资料

二、内部报酬率法(IRR法) The Internal Rate of Return Rule
• • • • 1、什么是IRR IRR: 令 NPV 等于零的贴现率 2、 IRR法则的决策程序 第一、确定一个最低要求回报率 Minimum Acceptance Criteria • 第二、估计现金流,求出IRR
故事启示
• 资本预算需要权衡风险和回报 • 本章主要内容 • (1)净现值NPV • (2)内含报酬率IRR • *(3)获利能力指数PI • *(4)回收期及贴现回收期法则
一、净现值(NPV)
• 1、什么是NPV • NPV=所有未来流入现金的现值-现在和未 来流出现金的现值 • 2、净现值法则 • 最低接受准则: Accept if NPV > 0 • 排序标准: 最高 NPV
3、NPV例子
假设现金流如下,7%的贴现率
Year 0 Year 1 Year 2
150 , 000 100 , 000 0 , 000
3、NPV例子(续)
Discount Period Factor 时点 贴现率 0 1.0 1 1 1.0 7 .935 1 2 .873 1.0 72 Cash Flow Present Value 现金流 现值 150 ,000 150 ,000 100 ,000 93,500 300 ,000 261 ,900 NPV Total $18,400
课堂问题
• 1、两个独立项目如何用NPV法则选择? 互斥的项目呢? • 独立项目指接受或拒绝此项目的决策, 不会影响其他项目的决策.互斥项目指只 能选其中一个的项目. • 答:如果是独立项目,则NPV>0都可接受。 如果是互斥的项目,则排序选最高NPV。
ESSENTIAL LECTURE NPV

Should Clair Inc. invest in one project or both?
Independent versus Mutually Exclusive Projects
Independent projects – accepting/rejecting one project has no impact on the accept/reject decision for the other project Mutually exclusive projects – accepting one project implies rejecting another Both Clair Inc.projects deal with production capacity If demand is high enough, projects may be independent If demand warrants only one investment, projects are mutually exclusive When ranking mutually exclusive projects, choose the project with highest NPV
Net Present Value
The difference between the market value of a project and its cost How much value is created from undertaking an investment? The first step is to estimate the expected future cash flows. The second step is to estimate the required return for projects of this risk level. The third step is to find the present value of the cash flows and subtract the initial investject: NPV = $41,339.39
工程经济学npv公式解析

工程经济学npv公式解析工程经济学里的 NPV 公式,就像是一个神秘的魔法工具,能帮助我们在经济决策的迷宫中找到正确的方向。
咱先来说说啥是 NPV 公式。
NPV 就是净现值(Net Present Value),它的公式是:NPV = ∑(CI - CO) / (1 + i)^t 。
这里的 CI 代表现金流入,CO 代表现金流出,i 是折现率,t 是时间周期。
举个例子,比如说你想开一家小咖啡店。
你预计第一年能赚5 万块,第二年能赚 8 万块,第三年能赚 10 万块。
但是开这个咖啡店,一开始你得投进去 20 万块买设备、装修啥的。
假设咱们的折现率是 10%,那咱们来算算 NPV 。
第一年的现金流入是 5 万,折现到现在就是 5 万 / (1 + 10%)^1 =4.545 万。
第二年的 8 万,折现就是 8 万 / (1 + 10%)^2 = 6.611 万。
第三年的 10 万,折现就是 10 万 / (1 + 10%)^3 = 7.513 万。
然后把这三年的折现值加起来,再减去一开始的 20 万投资,就是 NPV 啦。
如果算出来 NPV 是正数,那就说明这个投资项目可能值得干,能给你带来正的收益。
要是 NPV 是负数,那你就得再好好琢磨琢磨,是不是这买卖不太划算。
再比如说,你想换个工作。
新工作的工资第一年是 10 万,每年涨 2 万,但是工作地点远,通勤成本一年要多花 1 万。
你现在的工作每年能拿 8 万,很稳定。
咱们也用 NPV 公式来算算,假设工作 5 年,折现率还是 10%。
新工作第一年的净现金流入是 9 万,折现就是 9 万 / (1 + 10%)^1 = 8.182 万。
第二年是 11 万,折现是 11 万 / (1 + 10%)^2 = 9.091 万。
以此类推,算出 5 年的折现值加起来,再和现在工作 5 年的收入折现比较。
在实际生活中,用 NPV 公式做决策可太有用了。
就像我之前一个朋友,他纠结要不要投资一个小超市。
净现值NPV

内插法求内部收益率IRR:
IRR=10%+(15%-10%) ×10.16/(10.16+4.02)
=13.5%
IRR> i0=12%,所以项目可行。
内部收益率的经济含义: 在项目的整个计算期内,按利率i=IRR 计算,始终存在未回收的投资,只是在项目 结束时投资恰好被完全回收。即在项目计算 期内,项目始终处于“偿付”未被回收投资 的状态。
1000元/年 10
0
1
2
3
9
17548.7
用终值法计算IRR: 1000(F/A,IRR,10) -17548.7=0 IRR=12%> i0=10% 结论:此项业务不可行。
NPV
i0 不可行
-7548.7
可行区 IRR=12%
多个正数解:
一元n次方程必有n个复数根,其正实根 的数目可借助迪卡尔符号规则来判断:方程 正数根的个数不超过现金流量序列正负号 变化的次数,如果少的话,则少偶数个。如 何判断一个正数根是不是项目的内部收益 率,根据IRR的经济含义。
TP*——动态投资回收期。
如果项目为一次性投资,投资额为K, 并且当年投产,每年净收益相等且为M, 基准收益率为i0,则:
经整理
更为实用的TP*的公式:
判别标准(基准动态投资回收期为T0*) 若 TP*≤ T0*,则项目可行; 否则项目不可行。
例 某项目一次性投资2400万元,每年净收 益为270万元。分别计算其静态及动态回收 期(i0=10%)。 解:
解:各方案的费用现值: PCA=200+60(P/A,10%,10)=568.64(万元) PCB=240+50(P/A,10%,10)=547.2(万元) PCc=300+35(P/A,10%,10)=515.04(万元) C方案的PC最小,故C方案为最优方案。 各方案的费用年值: ACA= PCA (A/P,10%,10)=92.55(万元) ACB= 240 (A/P,10%,10)+50=89.06(万元) ACC=300 (A/P,10%,10)+35=83.82(万元) 故C方案是最优方案。
lecture9 NPV

Chap. 10KMPLECTURE 9Capital budgeting techniques and practice1.Discuss the difficulty of finding profitable projects incompetitive markets and the importance of the search.2.Determine whether a new project should be accepted orrejected using the payback period, net present value, the profitability index, and the internal rate of return.3.Explain how the capital-budgeting decision processchanges when a dollar limit is placed on the capitalbudget.4.Discuss the problems encountered inproject ranking.5.Explain the importance of ethicalconsiderations in capital-budgetingdecisions.6.Discuss the trends in the use of differentcapital-budgeting criteria.Slide Contents•Capital Budgeting•Capital Budgeting Decision Criteria •Capital Rationing•Ranking Problems•Ethics in Capital Budgeting •Capital Budgeting Practices1. Capital Budgeting •Meaning: The process of decision making with respect to investments in fixed assets—that is, should a proposed project be accepted or rejected.•It is easier to “evaluate”profitable projects than to “find them”Source of Ideas for projects •Within the Firm: Typically, a firm has a research & development (R&D) department that searches for ways of improving existing products or finding new projects.•Other sources: Other employees, Competition, Suppliers, Customers.2. Capital BudgetingDecision Criteria•The Payback Period•Net Present Value•Profitability Index•Internal Rate of Return2.1 The Payback Period •Meaning: Number of years needed to recover theinitial cash outlay of a capital budgeting project.•Decision Rule: Project feasible or desirable if the payback period is less than or equal to the firm’s maximum desired payback period. In general, shorter payback period is preferred while comparing two projects.Payback Period ExampleExample: Project with an initial cash outlay of $20,000 with following free cash flows for 5 years.Payback is 4 years.YEAR CASH FLOWBALANCE 1$ 8,000($ 12,000)24,000( 8,000)33,000( 5,000)45,0000510,00012,000Trade-offs •Benefits:–Uses cash flows rather than accounting profits–Easy to compute and understand–Useful for firms that have capital constraints •Drawbacks:–Ignores the time value of money and–Does not consider cash flows beyond the paybackperiod.Discounted Payback Period •The discounted payback period is similar to the traditional payback period except that it uses discounted free cash flows rather than actual undiscounted cash flows.•The discounted payback period is defined as the number of years needed to recover the initial cash outlay from the discounted free cash flows.Table 10-2•Table 10-2 shows thedifference betweentraditional payback anddiscounted paybackmethods.•With undiscounted freecash flows,the payback period isonly 2 yearswhile with discountedfree cash flows (at 17%),the discounted paybackperiod is 3.07 years.2.2 Net Present Value (NPV)•Meaning: NPV is equal to the present value of all future free cash flows less the investment’s initial outlay. It measures the net value of a project in today’s dollars.NPV Example•Example: Project with an initial cash outlay of $60,000 with following free cash flows for 5 years.Year FCF Year FCFInitial outlay–60,000313,0001–25,000412,0002–24,000511,000•The firm has a 15% required rate of return.•PV of FCF= $60,764•Subtracting the initial cash outlay of $60,000 leaves an NPV of $764.•Since NPV> 0, project is feasibleNPV in Excel®•Input cash flows for initial outlay and free cash inflows in cells A1 to A6.•In cell A7 type the following formula:=A1+npv(.15,a2:a6)•Excel will give the NPV= $764NPV Trade-offs •Benefits–Considers cash flows, not profits–Considers all cash flows–Recognizes time value of money•Drawbacks–Requires detailed long-term forecast of cash flows •NPV is considered to be the most theoretically correct criterion for evaluating capital budgeting projects.2.3 Profitability Index (PI)(Benefit-Cost ratio) •Meaning: PI is the ratio of the present value of the future free cash flows (FCF) to the initial outlay. It yields the sameaccept/reject decision as NPV.PI= PV of FCF/Initial outlayProfitability Index•Decision Rule:PI≥1 = accept;PI< 1 = reject• A firm with a 10% required rate of return is considering investing in a new machine with an expected life of six years. The initial cash outlay is $50,000.FCF PVF@10%PVInitialOutlay–$50,0001.000–$50,000 Year 115,0000.90913,636 Year 28,0000.8266,612 Year 310,0000.7517,513 Year 412,0000.6838,196 Year 514,0000.6218,693 Year 616,0000.5649,032PI= ($13,636 + $6,612+$7,513 + $8,196 + $8,693+ $9,032) / $50,000= $53,682/$50,000= 1.0736Project’s PI is greater than 1. Therefore, accept.NPV and PI•When the present value of a project’s free cash inflows are greater than the initial cash outlay, the project NPV will be positive. PI will also be greater than 1.•NPV and PI will always yield the same decision.2.4 Internal Rateof Return (IRR)•Meaning: IRR is the discount rate that equates the present value of a project’s future net cash flows with the project’s initial cash outlay.•Internal Rate of Return•Decision Rule:–If IRR≥Required Rate of Return, accept –If IRR< Required Rate of Return, rejectFigure 10-1IRR and NPV•If NPV is positive, IRR will be greater than the required rate of return•If NPV is negative, IRR will be less than required rate of return•If NPV= 0, IRR is the required rate of return.IRR Example•Initial Outlay:$3,817•Cash flows: Yr.1=$1,000, Yr. 2=$2,000,Yr. 3=$3,000Discount rate NPV15%$4,35620%$3,95822%$3,817•IRR is 22%because the NPV equals the initial cash outlay at that rate.IRR in Excel®•IRR can be easily computed in Excel®•In the previous example, input cash outflow and three year cash inflows in cells A1:A4•In cell A5 input “=IRR(a1:a4)”•Excel®will give the IRR= 22%Multiple IRR s• A normal cash flow pattern for project is negative initial outlay followed by positive cash flows (–, +, +, + …)•However, if the cash flow pattern is not normal (such as –, +, –) there can be more than one IRRs.•Figure 10-2 is based on cash flows of:–1,600; +10,000; –10,000 in years 0,1, 2Figure 10-2Modified IRR•Primary drawback of the IRR relative to the net present value is the reinvestment rate assumption made by the internal rate of return. Modified IRR allows the decision maker to directly specify the appropriate reinvestment rate.•Modified IRR •Accept if MIRR ≥required rate of return •Reject if MIRR < required rate of return•Project having a 3 year life and a required rate of return of 10% with the following cash flows:FCF’s FCF’sInitial–$6,000Year 2$3,000OutlayYear 12,000Year 34,000•Step 1: Determine the PV of the project’s cash outflows. $6,000 is already at present.•Step 2: Determine the terminal value of the project’s free cash flows. To do this use the project’s required rate of return to calculate the FV of the project’s three cash flows of the project’s cash outflows. They turn out to be $2,420 + $3,300 + $4,000 = $9,720 for the terminal value•Step 3: Determine the discount rate that equates to the PV of the terminal valueand the PV of the project’s cash outflows. MIRR= 17.446%.It is greater than required rate of return so Accept.MIRR in Excel®= MIRR(values, finance rate, reinvestment rate)where values is simply the range of cells where the cash flows are stored, and k is entered for both the finance rate and the reinvestment rate.3. Capital Rationing •Meaning: Capital rationing refers to situation where there is a limit on the dollar size of thecapital budget. This may be due to:(a) temporarily adverse conditions in the market;(b) shortage of qualified personnel to direct newprojects; and/or(c) other factors such as not willing to take onexcess debt to finance new projects.Capital Rationing•How to select? Select a set of projects with the highest NPV—subject to the capital constraint. Using NPV may preclude accepting the highest ranked project in terms of PI or IRR.Figure 10-4Table 10-74. Ranking MutuallyExclusive Projects•Size Disparity•Time Disparity•Unequal Life4.1 Size Disparity•This occurs when we examine mutually exclusive projects of unequal size.•Example: Consider the following cash flows for one-year Project A and B, with required rates of return of 10%.–Initial Outlay: A = $200; B = $1,500–Inflow:A = $300; B = $1,900Table 10-8Ranking ProblemRanking Conflict:–Using NPV , Project B is better;–Using PI and IRR , Project A is better.27%50%IRR 1.151.36PI227.2872.73NPVProject B Project ARanking Problem•Which technique to use to select the project?•Use NPV whenever there is size disparity. If there is no capital rationing, project with the largest NPV will be selected. When capital rationing exists, select set of projects with the largest NPV.•Time Disparity problem arises because of differing reinvestment assumptions made by the NPV and IRR decision criteria.•How are Cash flows reinvested?–According to NPV: Required rate of return–According to IRR: IRR•Example: Consider two projects, A and B, with initial outlay of $1,000, cost of capital of 10%, and following cash flows in years 1, 2, and 3:•A: $100$200$2,000•B: $650$650$650Table 10-9Time Disparity Problem•Ranking Conflict:–Using NPV or PI , A is better–Using IRR , B is better•Which technique to use to select the superior project?–Use NPV43%35%IRR1.6161.759PI 616.45758.83NPV Project B Project A4.3 Unequal Lives Problem •This occurs when we are comparing twomutually exclusive projects with different lifespans.•To compare projects, we compute the Equivalent Annual Annuity (EAA)Unequal Lives Problem •Example: If you have two projects, A and B, with equal investment of $1,000, requiredrate of return of 10%, and following cash flows in years 1-3 (for project A) and 1-6(for project B)•Project A = $500 each in years 1-3•Project B = $300 each in years 1-6。
浅议NPV法则

其中,C0 为初始投资, r 为折现率, CFt 为 t 时期的现金流。 NPV 为正值,表示项目的未来现金流量超过初始投资,多余的现金流最终将 为企业的股东带来价值,并体现为股价的上涨程度;NPV 为负值,说明项目的未 来现金流的现值不足以补偿初始成本, 企业的价值将会缩减。 在市场经济环境下, 投资者要求最低的收益率—资本成本, 因此资本预算具有可行性要求项目的净现 值等于或大于零。 NPV 法则的决策一般分为四个步骤: 一是将未来各年净现金流以一定的折现 率折算为现值; 二是计算各年净现金流现值的和;三是将净现金流现值的和与最 初投资成本进行比较;四是根据比较结果的正负,判断资本预算的可行性。 2、应用 从 NPV 的计算模型可以看出,NPV 法则暗含了前提条件和假设:
3
模。 这种决策的灵活性会给未来现金流量的预测带来很大的困难。净现值法没有 考虑到项目投资过程中的决策灵活性。
三、总结
尽管 NPV 法则有以上所分析的缺陷, 从理论上来说其还是一种很好的投资决 策方法。我们可以通过敏感性分析、场景分析和盈亏平衡分析、蒙特卡罗模拟来 弥补 NPV 法则上的不足和缺陷, 合理地选择折现率, 降低未来的不确定性对 NPV 的影响。 将实物期权引入投资决策来减少在项目实施后管理者进行决策的灵活性, 当然要真正实现实物期权的价值,还需要有审时度势、灵活多变的决策者和决策 机制做支撑。从而提高投资决策的准确性。由于本文作者水平和时间有限,对于 NPV 法则的改进暂不做过多的论述,在以后的时间会做进一步的论述。
浅议净现值法则
摘要:本文首先对净现值法则进行简要的介绍,进一步,从净现值准则的内 在假设入手分析,可以发现,它存在着两个缺陷,最后对净现值法则进行简要的 改进。 关键词:净现值 净现值法则 现金流 折现率
净现值与其他投资准绳38页PPT

净现值与内部收益率:净现值曲线(NPV Profile) 净现值曲线描 绘的是项目净现值与折现率之间的关系
第二节 内含报酬率(IRR)
• IRR的问题
– 非常规现金流量
P172,图9-6;例9-5
结果:可能存在多重报酬率,或根本不存在IRR
– 互斥投资
P174,例题
结果:IRR与NPV不一致,选择NPV作为评价标准
第六节 投资项目评价标准的比较
——NPV与PI
NPV与PI
在投资规模不同的互斥项目的选择中,两种标准可能得出相反的结 论。在这种情况下,可采用考查投资增量的获利指数的方法来进一
步分析两个投资项目的获利指数,投资增量D-C的获利指数可计算
如下:
10 000(P / A,12%,4) 30 370
PI DC
–决策标准:如果投资回收期小于基准回收期(公 司自行确定或根据行业标准确定)时,可接受该 项目;反之则应放弃。在互斥项目比较分析时, 应以回收期最短的方案作为中选方案。
第四节 投资回收期
例:续前例项目现金流量
单位:元
项目
NCF 累计NCF
0
1
-170000 39800 -170000 -130200
五、平均会计报酬率(AAR)
• 会计收益率是指投资项目年平均净收益与该项目平均投资额的比率。 其计算公式为:
会计收益率
年平均净收益 年平均投资总额
100%
• 决策标准:会计收益率大于基准会计收益率,则应接受该项目,反 之则应放弃。在有多个方案的互斥选择中,则应选择会计收益率最
高的项目。
P168,表9-4
2
50110 -80090
公司理财(双语)npv

McGraw Hill/Irwin
Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved
5- 3
CFO Decision Tools
Survey Data on CFO Use of Investment Evaluation Techniques
a discounted basis within the specified time
McGraw Hill/Irwin
9-14 Copyright © 2003 by The McGraw-Hill Companies, Inc. All rights reserved
5- 15 Computing Discounted Payback for
Does the payback rule provide an indication about the increase in value?
Should we consider the payback rule for our primary decision rule?
McGraw Hill/Irwin
5- 14 Discounted Payback Period
Compute the present value of each cash flow and then determine how long it takes to pay back on a discounted basis
Compare to a specified required period Decision Rule - Accept the project if it pays back on
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
Chap. 10KMPLECTURE 9Capital budgeting techniques and practice1.Discuss the difficulty of finding profitable projects incompetitive markets and the importance of the search.2.Determine whether a new project should be accepted orrejected using the payback period, net present value, the profitability index, and the internal rate of return.3.Explain how the capital-budgeting decision processchanges when a dollar limit is placed on the capitalbudget.4.Discuss the problems encountered inproject ranking.5.Explain the importance of ethicalconsiderations in capital-budgetingdecisions.6.Discuss the trends in the use of differentcapital-budgeting criteria.Slide Contents•Capital Budgeting•Capital Budgeting Decision Criteria •Capital Rationing•Ranking Problems•Ethics in Capital Budgeting •Capital Budgeting Practices1. Capital Budgeting •Meaning: The process of decision making with respect to investments in fixed assets—that is, should a proposed project be accepted or rejected.•It is easier to “evaluate”profitable projects than to “find them”Source of Ideas for projects •Within the Firm: Typically, a firm has a research & development (R&D) department that searches for ways of improving existing products or finding new projects.•Other sources: Other employees, Competition, Suppliers, Customers.2. Capital BudgetingDecision Criteria•The Payback Period•Net Present Value•Profitability Index•Internal Rate of Return2.1 The Payback Period •Meaning: Number of years needed to recover theinitial cash outlay of a capital budgeting project.•Decision Rule: Project feasible or desirable if the payback period is less than or equal to the firm’s maximum desired payback period. In general, shorter payback period is preferred while comparing two projects.Payback Period ExampleExample: Project with an initial cash outlay of $20,000 with following free cash flows for 5 years.Payback is 4 years.YEAR CASH FLOWBALANCE 1$ 8,000($ 12,000)24,000( 8,000)33,000( 5,000)45,0000510,00012,000Trade-offs •Benefits:–Uses cash flows rather than accounting profits–Easy to compute and understand–Useful for firms that have capital constraints •Drawbacks:–Ignores the time value of money and–Does not consider cash flows beyond the paybackperiod.Discounted Payback Period •The discounted payback period is similar to the traditional payback period except that it uses discounted free cash flows rather than actual undiscounted cash flows.•The discounted payback period is defined as the number of years needed to recover the initial cash outlay from the discounted free cash flows.Table 10-2•Table 10-2 shows thedifference betweentraditional payback anddiscounted paybackmethods.•With undiscounted freecash flows,the payback period isonly 2 yearswhile with discountedfree cash flows (at 17%),the discounted paybackperiod is 3.07 years.2.2 Net Present Value (NPV)•Meaning: NPV is equal to the present value of all future free cash flows less the investment’s initial outlay. It measures the net value of a project in today’s dollars.NPV Example•Example: Project with an initial cash outlay of $60,000 with following free cash flows for 5 years.Year FCF Year FCFInitial outlay–60,000313,0001–25,000412,0002–24,000511,000•The firm has a 15% required rate of return.•PV of FCF= $60,764•Subtracting the initial cash outlay of $60,000 leaves an NPV of $764.•Since NPV> 0, project is feasibleNPV in Excel®•Input cash flows for initial outlay and free cash inflows in cells A1 to A6.•In cell A7 type the following formula:=A1+npv(.15,a2:a6)•Excel will give the NPV= $764NPV Trade-offs •Benefits–Considers cash flows, not profits–Considers all cash flows–Recognizes time value of money•Drawbacks–Requires detailed long-term forecast of cash flows •NPV is considered to be the most theoretically correct criterion for evaluating capital budgeting projects.2.3 Profitability Index (PI)(Benefit-Cost ratio) •Meaning: PI is the ratio of the present value of the future free cash flows (FCF) to the initial outlay. It yields the sameaccept/reject decision as NPV.PI= PV of FCF/Initial outlayProfitability Index•Decision Rule:PI≥1 = accept;PI< 1 = reject• A firm with a 10% required rate of return is considering investing in a new machine with an expected life of six years. The initial cash outlay is $50,000.FCF PVF@10%PVInitialOutlay–$50,0001.000–$50,000 Year 115,0000.90913,636 Year 28,0000.8266,612 Year 310,0000.7517,513 Year 412,0000.6838,196 Year 514,0000.6218,693 Year 616,0000.5649,032PI= ($13,636 + $6,612+$7,513 + $8,196 + $8,693+ $9,032) / $50,000= $53,682/$50,000= 1.0736Project’s PI is greater than 1. Therefore, accept.NPV and PI•When the present value of a project’s free cash inflows are greater than the initial cash outlay, the project NPV will be positive. PI will also be greater than 1.•NPV and PI will always yield the same decision.2.4 Internal Rateof Return (IRR)•Meaning: IRR is the discount rate that equates the present value of a project’s future net cash flows with the project’s initial cash outlay.•Internal Rate of Return•Decision Rule:–If IRR≥Required Rate of Return, accept –If IRR< Required Rate of Return, rejectFigure 10-1IRR and NPV•If NPV is positive, IRR will be greater than the required rate of return•If NPV is negative, IRR will be less than required rate of return•If NPV= 0, IRR is the required rate of return.IRR Example•Initial Outlay:$3,817•Cash flows: Yr.1=$1,000, Yr. 2=$2,000,Yr. 3=$3,000Discount rate NPV15%$4,35620%$3,95822%$3,817•IRR is 22%because the NPV equals the initial cash outlay at that rate.IRR in Excel®•IRR can be easily computed in Excel®•In the previous example, input cash outflow and three year cash inflows in cells A1:A4•In cell A5 input “=IRR(a1:a4)”•Excel®will give the IRR= 22%Multiple IRR s• A normal cash flow pattern for project is negative initial outlay followed by positive cash flows (–, +, +, + …)•However, if the cash flow pattern is not normal (such as –, +, –) there can be more than one IRRs.•Figure 10-2 is based on cash flows of:–1,600; +10,000; –10,000 in years 0,1, 2Figure 10-2Modified IRR•Primary drawback of the IRR relative to the net present value is the reinvestment rate assumption made by the internal rate of return. Modified IRR allows the decision maker to directly specify the appropriate reinvestment rate.•Modified IRR •Accept if MIRR ≥required rate of return •Reject if MIRR < required rate of return•Project having a 3 year life and a required rate of return of 10% with the following cash flows:FCF’s FCF’sInitial–$6,000Year 2$3,000OutlayYear 12,000Year 34,000•Step 1: Determine the PV of the project’s cash outflows. $6,000 is already at present.•Step 2: Determine the terminal value of the project’s free cash flows. To do this use the project’s required rate of return to calculate the FV of the project’s three cash flows of the project’s cash outflows. They turn out to be $2,420 + $3,300 + $4,000 = $9,720 for the terminal value•Step 3: Determine the discount rate that equates to the PV of the terminal valueand the PV of the project’s cash outflows. MIRR= 17.446%.It is greater than required rate of return so Accept.MIRR in Excel®= MIRR(values, finance rate, reinvestment rate)where values is simply the range of cells where the cash flows are stored, and k is entered for both the finance rate and the reinvestment rate.3. Capital Rationing •Meaning: Capital rationing refers to situation where there is a limit on the dollar size of thecapital budget. This may be due to:(a) temporarily adverse conditions in the market;(b) shortage of qualified personnel to direct newprojects; and/or(c) other factors such as not willing to take onexcess debt to finance new projects.Capital Rationing•How to select? Select a set of projects with the highest NPV—subject to the capital constraint. Using NPV may preclude accepting the highest ranked project in terms of PI or IRR.Figure 10-4Table 10-74. Ranking MutuallyExclusive Projects•Size Disparity•Time Disparity•Unequal Life4.1 Size Disparity•This occurs when we examine mutually exclusive projects of unequal size.•Example: Consider the following cash flows for one-year Project A and B, with required rates of return of 10%.–Initial Outlay: A = $200; B = $1,500–Inflow:A = $300; B = $1,900Table 10-8Ranking ProblemRanking Conflict:–Using NPV , Project B is better;–Using PI and IRR , Project A is better.27%50%IRR 1.151.36PI227.2872.73NPVProject B Project ARanking Problem•Which technique to use to select the project?•Use NPV whenever there is size disparity. If there is no capital rationing, project with the largest NPV will be selected. When capital rationing exists, select set of projects with the largest NPV.•Time Disparity problem arises because of differing reinvestment assumptions made by the NPV and IRR decision criteria.•How are Cash flows reinvested?–According to NPV: Required rate of return–According to IRR: IRR•Example: Consider two projects, A and B, with initial outlay of $1,000, cost of capital of 10%, and following cash flows in years 1, 2, and 3:•A: $100$200$2,000•B: $650$650$650Table 10-9Time Disparity Problem•Ranking Conflict:–Using NPV or PI , A is better–Using IRR , B is better•Which technique to use to select the superior project?–Use NPV43%35%IRR1.6161.759PI 616.45758.83NPV Project B Project A4.3 Unequal Lives Problem •This occurs when we are comparing twomutually exclusive projects with different lifespans.•To compare projects, we compute the Equivalent Annual Annuity (EAA)Unequal Lives Problem •Example: If you have two projects, A and B, with equal investment of $1,000, requiredrate of return of 10%, and following cash flows in years 1-3 (for project A) and 1-6(for project B)•Project A = $500 each in years 1-3•Project B = $300 each in years 1-6。