Finance 3310

Lecture 10

Project Analysis and Evaluation

1. General

2. 'What If' Analysis

3. Breakeven Analysis

4. Operating leverage

5. Setting the Bid Price

1. General:

In the capital budgeting analysis to this point we have taken most of the information as given. We should recognize that all capital budgeting problems involve forecasting future cash flows. These cash flows are risky. That is, the actual cash flows may turn out much different than we originally expected. A project that had a positive NPVbased on our forecast cash flows may turn out to have a negative NPV based on actual cash flows. To address the issue of risky cash flows in capital budgeting we resort to 'what if' analysis. We will discuss two types of such analysis: scenario analysis and sensitivity analysis.

Before looking at what-if analysis, one futher comment is in order. We should understand that if a project is estimated to have a positive NPV this implies the project's return exceeds the project's cost of capital. This means the project is making an 'economic' profit. Economic theory predicts that competition will work to eliminate economic profit. Thus we should always try to determine the source of value for the project.

2. What If Analysis:

a. Scenario Analysis - we look at changes in NPV for different sets of values of the variables. These sets of values are called scenarios, and we usually will examine a 'base' case, 'worst' case and 'best' case scenarios. Sometimes it may be necessary to attach probabilities to each of the cases and then compute an 'expected' NPV.

b. Sensitivity analysis - this involves changing a particular variable in the capital budgeting problem, while holding all other variables constant, and examining the effect on NPV. The 'NPV profile' we discussed in the previous chapter is simply the plot of the senstivity of NPV to a change in the cost of capital.

We can plot NPV for changes in each particular variable. The slope of the graph indicates the sensitivity of NPV to a change in a particular variable. We should devote our forecasting effort and resources to those variables which uncertainty has the largest impact on NPV.

3. Breakeven Analysis

a. Accounting Breakeven:

Breakeven analysis is concerned with the relation between sales volume and profitability. How much do we have to sell to break even.

To analyze, we need two concepts:

Fixed costs - those costs which are not affected by or do not vary with sales. Examples include:

Variable (direct) costs - those costs which vary directly with sales. Examples include:

To calculate breakeven, we divide the profit margin on each item into the total amount of fixed costs.

Let P = price, VC = variable cost per unit, FC = total fixed costs, and Q = quantity.

example: suppose: FC = $100,000

P = $1.75

VC = $1.00

Q = ?

Operating profit = Total Revenues - variable costs - fixed costs = P*Q - Q*VC - FC

We want operating profit = 0

==> 0 = P*Q - Q*VC - FC

==> (P - VC)*Q = FC

==> Q = FC/ (P - VC) = FC / profit margin

thus: ==> Q = 100,000 / (1.75 - 1.00) = 133,333 units

b. Cash Flow Breakeven:

Do just like accounting breakeven above, but exclude non-cash expenses such as depreciation from the costs.

c. Financial Breakeven:

This calculates the quantity, Q, which sets NPV equal to zero. If the project involves the same cash flow per year, then it is an annuity and you can do it on your calculator. First calculate the operating cash flow per year needed to create a zero NPV. Then calculate the Q needed to create this cash flow. If the operating cash flows differ by year, you will need a spreadsheet.


4. Operating leverage


Operating leverage - measures the percentage change in operating cash flow for a percentage change in sales. It measures the degree of fixed costs in operations.

Consider two ways in which a company may operate:

(Capital intensive) Higher fixed costs, lower variable ==> higher OL

(Labor intensive) Low fixed, higher variable ==> low OL

Intuition: once you have covered fixed costs, you are contributing more to the bottom line for each unit of sales.

To calculate: %  in OCF / %  in Q

Example of operating leverage:

Consider two companies, A and B:

Company: A B
Fixed costs $1,000,000 $500,000
Price $2.00 $2.00
VC per unit $1.00 $1.50
Breakeven units

1,000,000

1,000,000

Now, assume there are two possible outcomes. One outcome involves sales of 500,000 units and the second outcome involves sales of 2,000,000 units.

  Scenario 1 Scenario 2
Units Sold: 500,000 2,000,000
Company A    
Sales 1,000,000 4,000,000
Variable Costs 500,000 2,000,000
Gross Profit 500,000 2,000,000
Fixed costs 1,000,000 1,000,000
EBIT (500,000) 1,000,000
     
Company B    
Sales 1,000,000 4,000,000
Variable Costs 750,000 3,000,000
Gross Profit 250,000 1,000,000
Fixed Costs 500,000 500,000
EBIT (250,000) 500,000
     



The degree of operating leverage, DOL, can be measured by:

DOL = 1 + FC/OCF

 

5. Setting the Bid Price

Many times companies are asked to 'bid' on a particular project. That is, they are asked to submit a price at which the company is willing to manufacture or produce a certain project. An example would be a defense contractor submitting a bid to construct a stealth bomber. The question is, how does the company arrive at the correct price to charge?

This is just another capital budgeting problem and a particular example of financial breakeven. We will only propose on a project if we can earn a fair rate of return, or what we have been calling the cost of capital. If we just earn our cost of capital, then the project will have a 0 NPV. Thus the lowest amount of revenues (or price) for which we are willing to do the project is the amount that causes NPV=0. Of course we would like more, but if we set the price too high we will likely lose the bid.

To do this problem, first calculate the present value of all the project cash flows except the revenues (or price). This will usually be a negative number, since it contains cash outflows but does not contain revenues. If the project involves a set of revenues, then determine what annual annuity amount has the same present value. If the project involves a single price, the price (today) should be equal to the present value.

 

Return to Finance 3310

Return to Home Page