Should we - PowerPoint PPT Presentation

1 / 41
About This Presentation
Title:

Should we

Description:

To find TV with HP 10B, enter in CFLO: I = 10. NPV = 118.78 = PV of inflows. ... Pavilion Project: NPV and IRR? 5,000 -5,000. 0. 1. 2. k = 10% -800. Enter CFs ... – PowerPoint PPT presentation

Number of Views:16
Avg rating:3.0/5.0
Slides: 42
Provided by: shan208
Category:
Tags: hp | pavilion

less

Transcript and Presenter's Notes

Title: Should we


1
CHAPTER 11The Basics of Capital Budgeting
Should we build this plant?
2
What is capital budgeting?
  • Analysis of potential additions to fixed assets.
  • Long-term decisions involve large expenditures.
  • Very important to firms future.

3
Steps
  • 1. Estimate CFs (inflows outflows).
  • 2. Assess riskiness of CFs.
  • 3. Determine k WACC (adj.).
  • 4. Find NPV and/or IRR.
  • 5. Accept if NPV gt 0 and/or IRR gt WACC.

4
What is the difference between independent and
mutually exclusive projects?
  • Projects are
  • independent, if the cash flows of one are
    unaffected by the acceptance of the other.
  • mutually exclusive, if the cash flows of one can
    be adversely impacted by the acceptance of the
    other.

5
An Example of Mutually Exclusive Projects
BRIDGE vs. BOAT to get products across a river.
6
Normal Cash Flow Project
Cost (negative CF) followed by a series of
positive cash inflows. One change of signs.
Nonnormal Cash Flow Project
Two or more changes of signs. Most common Cost
(negative CF), then string of positive CFs, then
cost to close project. Nuclear power plant, strip
mine.
7
Inflow () or Outflow (-) in Year
0
1
2
3
4
5
N
NN
-





N
-




-
NN
-
-
-



N



-
-
-
N
-


-

-
NN
8
What is the payback period?
The number of years required to recover a
projects cost, or how long does it take to get
our money back?
9
Payback for Project L(Long Large CFs in later
years)
2.4
0
1
2
3
10
60
-100
CFt
100
80
Cumulative
-100
-90
-30
50
0

PaybackL
2 30/80 2.375 years
10
Project S (Short CFs come quickly)
1.6
0
1
2
3
70
20
50
-100
CFt
100
Cumulative
-100
-30
20
40
0
PaybackL
1 30/50 1.6 years

11
Strengths of Payback
1. Provides an indication of a projects risk and
liquidity. 2. Easy to calculate and understand.
Weaknesses of Payback
1. Ignores the TVM. 2. Ignores CFs occurring
after the payback period.
12
Discounted Payback Uses discounted rather than
raw CFs.
0
1
2
3
10
10
80
60
CFt
-100
PVCFt
-100
9.09
49.59
60.11
Cumulative
-100
-90.91
-41.32
18.79
Discounted payback
2 41.32/60.11 2.7 years

Recover invest. cap. costs in 2.7 years.
13
NPV Sum of the PVs of inflows and outflows.
14
Whats Project Ls NPV?
Project L
0
1
2
3
10
10
80
60
-100.00
9.09
49.59
60.11
18.79 NPVL
NPVS 19.98.
15
Calculator Solution
Enter in CFLO for L
-100 10 60 80 10
CF0
CF1
CF2
CF3
NPV
I
18.78 NPVL
16
Rationale for the NPV Method
NPV PV inflows Cost Net gain in
wealth. Accept project if NPV gt 0. Choose
between mutually exclusive projects on basis
of higher NPV. Adds most value.
17
Using NPV method, which project(s) should be
accepted?
  • If Projects S and L are mutually exclusive,
    accept S because NPVs gt NPVL .
  • If S L are independent, accept both NPV gt 0.

18
Internal Rate of Return IRR
0
1
2
3
CF0
CF1
CF2
CF3
Cost
Inflows
IRR is the discount rate that forces PV inflows
cost. This is the same as forcing NPV 0.
19
NPV Enter k, solve for NPV.
IRR Enter NPV 0, solve for IRR.
20
Whats Project Ls IRR?
0
1
2
3
IRR ?
10
80
60
-100.00
PV1
PV2
PV3
0 NPV
Enter CFs in CFLO, then press IRR
IRRL 18.13.
IRRS 23.56.
21
Find IRR if CFs are constant
0
1
2
3
IRR ?
40
40
40
-100
INPUTS
3 -100 40 0
9.70
N
I/YR
PV
PMT
FV
OUTPUT
Or, with CFLO, enter CFs and press IRR 9.70.
22
Q. How is a projects IRR related to a bonds
YTM?
A. They are the same thing. A bonds YTM is the
IRR if you invest in the bond.
0
1
2
10
IRR ?
...
90
1090
90
-1134.2
IRR 7.08 (use TVM or CFLO).
23
Rationale for the IRR Method
If IRR gt WACC, then the projects rate of return
is greater than its cost--some return is left
over to boost stockholders returns. Example WAC
C 10, IRR 15. Profitable.
24
IRR Acceptance Criteria
  • If IRR gt k, accept project.
  • If IRR lt k, reject project.

25
Decisions on Projects S and L per IRR
  • If S and L are independent, accept both. IRRs gt
    k 10.
  • If S and L are mutually exclusive, accept S
    because IRRS gt IRRL .

26
Construct NPV Profiles
Enter CFs in CFLO and find NPVL and NPVS at
different discount rates
NPVL 50 33 19 7 (4
NPVS 40 29 20 12 5
k 0 5 10 15 20
(4)
27
NPV ()
k 0 5 10 15 20
NPVL 50 33 19 7 (4)
NPVS 40 29 20 12 5
60
.
50
.
40
.
.
30
.
.
S
20
.
IRRS 23.6
.
L
.
10
.
Discount Rate ()
.
0
5
15
20
23.6
10
-10
IRRL 18.1
28
NPV and IRR always lead to the same accept/reject
decision for independent projects
NPV ()
k gt IRR and NPV lt 0. Reject.
IRR gt k and NPV gt 0 Accept.
k ()
IRR
29
Mutually Exclusive Projects
NPV
k lt 8.7 NPVLgt NPVS , IRRS gt IRRL CONFLICT
L
k gt 8.7 NPVSgt NPVL , IRRS gt IRRL NO CONFLICT
IRRS
S

k 8.7 k
IRRL
30
Two Reasons NPV Profiles Cross
1. Size (scale) differences. Smaller project
frees up funds at t 0 for investment. The
higher the opportunity cost, the more valuable
these funds, so high k favors small
projects. 2. Timing differences. Project with
faster payback provides more CF in early years
for reinvestment. If k is high, early CF
especially good, NPVS gt NPVL.
31
Reinvestment Rate Assumptions
  • NPV assumes reinvest at k (opportunity cost of
    capital).
  • IRR assumes reinvest at IRR.
  • Reinvest at opportunity cost, k, is more
    realistic, so NPV method is best. NPV should be
    used to choose between mutually exclusive
    projects.

32
Managers like rates--prefer IRR to NPV
comparisons. Can we give them a better IRR?
Yes, MIRR is the discount rate that causes the PV
of a projects terminal value (TV) to equal the
PV of costs. TV is found by compounding
inflows at WACC.
Thus, MIRR assumes cash inflows are reinvested at
WACC.
33
MIRR for Project L (k 10)
0
1
2
3
10
10.0
80.0
60.0
-100.0
10
66.0 12.1
10
MIRR 16.5
158.1
158.1 (1 MIRRL)3
-100.0
TV inflows
100
PV outflows
MIRRL 16.5
34
To find TV with HP 10B, enter in CFLO
CF0 0, CF1 10, CF2 60, CF3 80
I 10
NPV 118.78 PV of inflows.
Enter PV -118.78, N 3, I 10, PMT 0. Press
FV 158.10 FV of inflows.
Enter FV 158.10, PV -100, PMT 0, N
3. Press I 16.50 MIRR.
35
Why use MIRR versus IRR?
MIRR correctly assumes reinvestment at
opportunity cost WACC. MIRR also avoids the
problem of multiple IRRs. Managers like rate of
return comparisons, and MIRR is better for this
than IRR.
36
Pavilion Project NPV and IRR?
0
1
2
k 10
5,000
-5,000
-800
Enter CFs in CFLO, enter I 10.
NPV -386.78
IRR ERROR. Why?
37
We got IRR ERROR because there are 2 IRRs.
Nonnormal CFs--two sign changes. Heres a
picture
NPV Profile
NPV
IRR2 400
450
0
k
400
100
IRR1 25
-800
38
Logic of Multiple IRRs
1. At very low discount rates, the PV of CF2 is
large negative, so NPV lt 0. 2. At very high
discount rates, the PV of both CF1 and CF2 are
low, so CF0 dominates and again NPV lt 0. 3. In
between, the discount rate hits CF2 harder than
CF1, so NPV gt 0. 4. Result 2 IRRs.
39
Could find IRR with calculator 1. Enter CFs as
before. 2. Enter a guess as to IRR by storing
the guess. Try 10 10 STO IRR 25
lower IRR Now guess large IRR, say,
200 200 STO IRR 400 upper IRR
40
When there are nonnormal CFs and more than one
IRR, use MIRR
0
1
2
-800,000
5,000,000
-5,000,000
PV outflows _at_ 10 -4,932,231.40.
TV inflows _at_ 10 5,500,000.00.
MIRR 5.6
41
Accept Project P?
NO. Reject because MIRR 5.6 lt k 10. Also,
if MIRR lt k, NPV will be negative NPV
-386,777.
Write a Comment
User Comments (0)
About PowerShow.com