?The McGraw-Hill Companies,Inc.,2001
8- 1
Irwin/McGraw-Hill
Chapter 8Fundamentals of Corporate FinanceThird Edition
Project
Analysis
Brealey Myers Marcus
slides by Matthew Will
?The McGraw-Hill Companies,Inc.,2001
8- 2
Irwin/McGraw-Hill
Topics Covered
?How Firms Organize Their Investment
Process
?Some,What If” Questions
?Sensitivity Analysis
?Break Even Analysis
?Flexibility in Capital Budgeting
?Decision Trees
?Options
?The McGraw-Hill Companies,Inc.,2001
8- 3
Irwin/McGraw-Hill
Capital Budgeting Process
Capital Budget - The list of planned
investment projects.
The Decision Process
1 - Develop and rank all investment projects
2 - Authorize projects based on:
? Govt regulation
? Production efficiency
? Capacity requirements
? NPV
?The McGraw-Hill Companies,Inc.,2001
8- 4
Irwin/McGraw-Hill
Capital Budgeting Process
?Capital Budgeting Problems
?Consistent forecasts
?Conflict of interest
?Forecast bias
?Selection criteria (NPV and others)
?The McGraw-Hill Companies,Inc.,2001
8- 5
Irwin/McGraw-Hill
How To Handle Uncertainty
Sensitivity Analysis - Analysis of the effects
of changes in sales,costs,etc,on a project.
Scenario Analysis - Project analysis given a
particular combination of assumptions.
Simulation Analysis - Estimation of the
probabilities of different possible outcomes.
Break Even Analysis - Analysis of the level of
sales (or other variable) at which the
company breaks even,
?The McGraw-Hill Companies,Inc.,2001
8- 6
Irwin/McGraw-Hill
Sensitivity Analysis
Example
Given the expected cash flow
forecasts listed on the next
slide,determine the NPV of
the project given changes in
the cash flow components
using an 8% cost of capital,
Assume that all variables
remain constant,except the
one you are changing.
?The McGraw-Hill Companies,Inc.,2001
8- 7
Irwin/McGraw-Hill
Sensitivity Analysis
Year 0 Years 1 - 12
Investment - 5,400
Sales 16,000
Variable C osts 13,000
Fixed Cost s 2,000
Depreciati on 450
Pretax pro fit 550
,Taxes @ 40% 220
Profit aft er tax 330
Operating cash flow 780
Net Cash F low - 5,400 780
Example - continued
NPV= $478
?The McGraw-Hill Companies,Inc.,2001
8- 8
Irwin/McGraw-Hill
Sensitivity Analysis
Example - continued
Possible Outcomes
Range
Variable Pessimisti c Expected Optimistic
Investment (000s) 6,200 5,400 5,000
Sales(000s ) 14,000 16,000 18,000
Var Cost ( % of sales ) 83% 81.25% 80%
Fixed Cost s(000s) 2,100 2,000 1,900
?The McGraw-Hill Companies,Inc.,2001
8- 9
Irwin/McGraw-Hill
Sensitivity Analysis
Example - continued
NPV Calculations for Pessimistic Investment Scenario
Year 0 Years 1 - 12
Investment - 6,200
Sales 16,000
Variable C osts 13,000
Fixed Cost s 2,000
Depreciati on 450
Pretax pro fit 550
,Taxes @ 40% 220
Profit aft er tax 330
Operating cash flow 780
Net Cash F low - 6,200 780
NPV= ($121)
?The McGraw-Hill Companies,Inc.,2001
8- 10
Irwin/McGraw-Hill
Sensitivity Analysis
Example - continued
NPV Possibilities
NPV s
Variable Pessimisti c Expected Optimistic
Investment
( )000
(000s) - 121 478 778
Sales(000s ) - 1,218 478 2,174
Var Cost ( % of sales ) - 788 478 1,382
Fixed Cost s(000s) 26 478 930
?The McGraw-Hill Companies,Inc.,2001
8- 11
Irwin/McGraw-Hill
Break Even Analysis
Example
Given the forecasted data
on the next slide,
determine the number of
planes that the company
must produce in order to
break even,on an NPV
basis,The company’s cost
of capital is 10%.
?The McGraw-Hill Companies,Inc.,2001
8- 12
Irwin/McGraw-Hill
Break Even Analysis
Year 0 Years 1 - 6
Investment $900
Sales 15.5xPlane s Sold
Var,Cost 8.5xPlanes Sold
Fixed Cost s 175
Depreciati on 900 / 6 = 150
Pretax Pro fit (7xPlanes Sold) - 325
Taxes (50% ) (3.5xPlane s Sold) - 162.5
Net Profit (3.5xPlane s Sold) - 162.5
Net Cash F low - 900 (3.5xPlane s Sold) - 12.5
?The McGraw-Hill Companies,Inc.,2001
8- 13
Irwin/McGraw-Hill
Break Even Analysis
Answer
The break even point,is the # of Planes
Sold that generates a NPV=$0,
The present value annuity factor of a 6
year cash flow at 10% is 4.355
Thus,
NPV xPlanes So= -900 + 4 355 3 5,(, ld - 12.5)
?The McGraw-Hill Companies,Inc.,2001
8- 14
Irwin/McGraw-Hill
Answer
Solving for,Planes Sold”
0 4 355 3 5= -900 +, (, ld - 12.5)xPlanes So
Planes Sol d = 63
Break Even Analysis
?The McGraw-Hill Companies,Inc.,2001
8- 15
Irwin/McGraw-Hill
Operating Leverage
Operating Leverage- The degree to which
costs are fixed.
Degree of Operating Leverage (DOL) -
Percentage change in profits given a 1
percent change in sales,
DOL = % change i n profits% change i n sales
?The McGraw-Hill Companies,Inc.,2001
8- 16
Irwin/McGraw-Hill
Operating Leverage
Example - A company has sales outcomes that range from
$16mil to $19 mil,Depending on the economy,The same
conditions can produce profits in the range from $550,000
to $1,112,000,What is the DOL?
DOL = = 5, 4 51 0 2, 21 8, 7 5
?The McGraw-Hill Companies,Inc.,2001
8- 17
Irwin/McGraw-Hill
Flexibility & Options
Decision Trees - Diagram of sequential decisions
and possible outcomes.
?Decision trees help companies determine their
Options by showing the various choices and
outcomes.
?The Option to avoid a loss or produce extra profit
has value.
?The ability to create an Option thus has value that
can be bought or sold.
?The McGraw-Hill Companies,Inc.,2001
8- 18
Irwin/McGraw-Hill
Decision Trees
NPV=0
Don’t test
Test (Invest
$200,000)
Success
Failure
Pursue project
NPV=$2million
Stop project
NPV=0
8- 1
Irwin/McGraw-Hill
Chapter 8Fundamentals of Corporate FinanceThird Edition
Project
Analysis
Brealey Myers Marcus
slides by Matthew Will
?The McGraw-Hill Companies,Inc.,2001
8- 2
Irwin/McGraw-Hill
Topics Covered
?How Firms Organize Their Investment
Process
?Some,What If” Questions
?Sensitivity Analysis
?Break Even Analysis
?Flexibility in Capital Budgeting
?Decision Trees
?Options
?The McGraw-Hill Companies,Inc.,2001
8- 3
Irwin/McGraw-Hill
Capital Budgeting Process
Capital Budget - The list of planned
investment projects.
The Decision Process
1 - Develop and rank all investment projects
2 - Authorize projects based on:
? Govt regulation
? Production efficiency
? Capacity requirements
? NPV
?The McGraw-Hill Companies,Inc.,2001
8- 4
Irwin/McGraw-Hill
Capital Budgeting Process
?Capital Budgeting Problems
?Consistent forecasts
?Conflict of interest
?Forecast bias
?Selection criteria (NPV and others)
?The McGraw-Hill Companies,Inc.,2001
8- 5
Irwin/McGraw-Hill
How To Handle Uncertainty
Sensitivity Analysis - Analysis of the effects
of changes in sales,costs,etc,on a project.
Scenario Analysis - Project analysis given a
particular combination of assumptions.
Simulation Analysis - Estimation of the
probabilities of different possible outcomes.
Break Even Analysis - Analysis of the level of
sales (or other variable) at which the
company breaks even,
?The McGraw-Hill Companies,Inc.,2001
8- 6
Irwin/McGraw-Hill
Sensitivity Analysis
Example
Given the expected cash flow
forecasts listed on the next
slide,determine the NPV of
the project given changes in
the cash flow components
using an 8% cost of capital,
Assume that all variables
remain constant,except the
one you are changing.
?The McGraw-Hill Companies,Inc.,2001
8- 7
Irwin/McGraw-Hill
Sensitivity Analysis
Year 0 Years 1 - 12
Investment - 5,400
Sales 16,000
Variable C osts 13,000
Fixed Cost s 2,000
Depreciati on 450
Pretax pro fit 550
,Taxes @ 40% 220
Profit aft er tax 330
Operating cash flow 780
Net Cash F low - 5,400 780
Example - continued
NPV= $478
?The McGraw-Hill Companies,Inc.,2001
8- 8
Irwin/McGraw-Hill
Sensitivity Analysis
Example - continued
Possible Outcomes
Range
Variable Pessimisti c Expected Optimistic
Investment (000s) 6,200 5,400 5,000
Sales(000s ) 14,000 16,000 18,000
Var Cost ( % of sales ) 83% 81.25% 80%
Fixed Cost s(000s) 2,100 2,000 1,900
?The McGraw-Hill Companies,Inc.,2001
8- 9
Irwin/McGraw-Hill
Sensitivity Analysis
Example - continued
NPV Calculations for Pessimistic Investment Scenario
Year 0 Years 1 - 12
Investment - 6,200
Sales 16,000
Variable C osts 13,000
Fixed Cost s 2,000
Depreciati on 450
Pretax pro fit 550
,Taxes @ 40% 220
Profit aft er tax 330
Operating cash flow 780
Net Cash F low - 6,200 780
NPV= ($121)
?The McGraw-Hill Companies,Inc.,2001
8- 10
Irwin/McGraw-Hill
Sensitivity Analysis
Example - continued
NPV Possibilities
NPV s
Variable Pessimisti c Expected Optimistic
Investment
( )000
(000s) - 121 478 778
Sales(000s ) - 1,218 478 2,174
Var Cost ( % of sales ) - 788 478 1,382
Fixed Cost s(000s) 26 478 930
?The McGraw-Hill Companies,Inc.,2001
8- 11
Irwin/McGraw-Hill
Break Even Analysis
Example
Given the forecasted data
on the next slide,
determine the number of
planes that the company
must produce in order to
break even,on an NPV
basis,The company’s cost
of capital is 10%.
?The McGraw-Hill Companies,Inc.,2001
8- 12
Irwin/McGraw-Hill
Break Even Analysis
Year 0 Years 1 - 6
Investment $900
Sales 15.5xPlane s Sold
Var,Cost 8.5xPlanes Sold
Fixed Cost s 175
Depreciati on 900 / 6 = 150
Pretax Pro fit (7xPlanes Sold) - 325
Taxes (50% ) (3.5xPlane s Sold) - 162.5
Net Profit (3.5xPlane s Sold) - 162.5
Net Cash F low - 900 (3.5xPlane s Sold) - 12.5
?The McGraw-Hill Companies,Inc.,2001
8- 13
Irwin/McGraw-Hill
Break Even Analysis
Answer
The break even point,is the # of Planes
Sold that generates a NPV=$0,
The present value annuity factor of a 6
year cash flow at 10% is 4.355
Thus,
NPV xPlanes So= -900 + 4 355 3 5,(, ld - 12.5)
?The McGraw-Hill Companies,Inc.,2001
8- 14
Irwin/McGraw-Hill
Answer
Solving for,Planes Sold”
0 4 355 3 5= -900 +, (, ld - 12.5)xPlanes So
Planes Sol d = 63
Break Even Analysis
?The McGraw-Hill Companies,Inc.,2001
8- 15
Irwin/McGraw-Hill
Operating Leverage
Operating Leverage- The degree to which
costs are fixed.
Degree of Operating Leverage (DOL) -
Percentage change in profits given a 1
percent change in sales,
DOL = % change i n profits% change i n sales
?The McGraw-Hill Companies,Inc.,2001
8- 16
Irwin/McGraw-Hill
Operating Leverage
Example - A company has sales outcomes that range from
$16mil to $19 mil,Depending on the economy,The same
conditions can produce profits in the range from $550,000
to $1,112,000,What is the DOL?
DOL = = 5, 4 51 0 2, 21 8, 7 5
?The McGraw-Hill Companies,Inc.,2001
8- 17
Irwin/McGraw-Hill
Flexibility & Options
Decision Trees - Diagram of sequential decisions
and possible outcomes.
?Decision trees help companies determine their
Options by showing the various choices and
outcomes.
?The Option to avoid a loss or produce extra profit
has value.
?The ability to create an Option thus has value that
can be bought or sold.
?The McGraw-Hill Companies,Inc.,2001
8- 18
Irwin/McGraw-Hill
Decision Trees
NPV=0
Don’t test
Test (Invest
$200,000)
Success
Failure
Pursue project
NPV=$2million
Stop project
NPV=0