Transcript Slide 1

Lecture 6: Capital Budgeting Part 1

C. L. Mattoli

This week

 In the book, chapter 8.

Intro

In the beginning of the course, we looked at the 3 main decisions that financial managers of a company need to make: capital structure, capital budgeting, and WC management.

Capital budgeting

or allocation is, probably, the most important of the 3 since it will determine the very character of the business.

 Also, since the capital budgeting decisions are basically what the business invests its money in, we also call it the

investment decision

of the firm.

Intro

 There will be many potential investment opportunities facing the firm.

 The firm will need to replace old equipment and it might decide to purchase new equipment for a new business or to enter a new market.

 These decisions are not only important, to begin with, but they cover a long future time horizon and they are not easy to reverse.

Decision under Constraint

 The investment decision must be made subject to a number of constraints.

 One is, obviously, that the firm will have limited funds to invest.

 There will be no information about market value of the project.

  More important, though, is that the goal of management is to maximize owner’s value in the business.

Of course, even that goal must be carried out under the other constraints of the real world.

Value

  We have learned that the proper way to value things is using

DFCF methods

.

In the present context, then, we should value potential projects for the firm by discounting the

expected cash flows of the project

.

 Projects will also have

initial investment, startup costs.

 Thus, our method of valuing a project will be to value it on DFCF, then,

compare

that value to how much it will cost to start the project.

Value

 This is the essence of the

Net present value (NPV)

method of valuing business projects.

 The NPV of a project is the difference between the DFCF value and the initial investment outlay (IO) , i.e.,

NPV i

t n

  1  1

CF t

k a

t

IO

Whole worth more than parts

 The idea behind business investment is that the whole is worth more than the parts.

 A business buys a machine, adds labor and materials, and produces a final product for sale at a price above the price of inputs.

 As a more common, simple example, consider buying an old house and renovating it.

 You pay $100,000 for the house. You get estimates of $20,000 from the plumber, $10,000 from the electrician, $30,000 for plaster and paint.

Whole worth more than parts

 Assume that you also have estimates from real estate agents that the house, if perfect, would sell for $200,000.

 Then, adding your costs (assuming the time involved for the project is short and you can neglect time value), your estimated cost is $160,000 versus potential sale of $200,000.

 Thus, you have combined input of materials and labor to produce extra value of $40,000 ($200,000 – $160,000).

Business investment value

 As we said, previously, business investment is similar to the above example: the output is worth more than the input.

  However, in the case of a business investment, there is a longer time frame for the project.

Thus, we expect multiple future cash flows, and we must account for the time value of cash flows.

 Also, those future cash flows are just estimates.

Business investment value

 Moreover, they are more complicated cash flows, involving

estimates of future costs

of inputs, like labor and materials, as well as

estimated sales prices and volumes

, in future years.

  The original investment outlay will involve purchase of PP&E as well as estimates of other

startup requirements

of WC.

The final ingredient is a

proper choice

of the

RRR

that will give investors enough of a return.

A first example

 Assume Craig wants to add dress making to his businesses.

 He buys a sewing machine for $1,000, and he assumes that it will last for 5 years.

 Craig estimates his inflows (dress sales) and outflows (costs) over the five years.

 At the end of the 5 year project, Craig believes that he can resell the used sewing machine for $100 as scrap (or as a used sewing machine).

The cash flows

 Assuming that the proper RRR for Craig is 15%, then, we have the situation displayed in the table, below.

Time 0 line IIO -1000 Inflows Outflows Net inflow Salvage Net CF Discounted PV inflows -1000 1055 1 500 200 300 300 261 2 500 200 300 300 227 3 500 200 300 300 197 4 500 200 300 300 172 5 500 200 300 100 400 199

The outcome

 In the above table, we assume that the

RRR

Craig’s businesses is

15%

.

for  As you can see from the table, the DFCF value of the net inflows is $1,055.

 Thus, the NPV = $1,055 - $1,000 = $55, which means that the project is estimated to

add $55 in value

to Craig’s business

above his RRR

over the period.

 Alternatively,

if NPV

had turned out to be a

negative value

, it would

subtract from

the

net worth

of the business.

The NPV Decision Rule

  From the above example and discussion, we can come up with a

decision rule

for using

NPV

.

Assume that the firm is in business and they already have a

RRR demanded

by their

investors

.

 Indeed, given our discussion in Mod 4 (Securities valuation), shareholders will determine the

value

of the

company’s stock based on

DFCF valuation, using an

appropriate RRR

.

The NPV Decision Rule

 Then, a project with a

positive NPV

will

add value

above the DFCF value of the firm, before taking on the project.  So,

positive NPV projects

should be accepted.

 Alternatively, a

negative NPV

project will

subtract value

from the firm.

The NPV Decision Rule

 Thus

, negative NPV

projects should be

rejected

.

 A

zero NPV project

will leave the value of the firm unchanged, so it will neither add or detract from the value of the firm.

 Thus, we would be

neutral

to taking on the project.

NPV & Risk

  An implicit assumption in the NPV methodology, as we have described it, here, is that the risk of a project must be the same as the average risk of the firm.

We have chosen an “appropriate” discount rate to use in NPV that, as said earlier, is somehow connected to the rate at which investors discount the company’s CF’s to value its shares.

 We have also learned, in the preceding module, that, in the marketplace for returns, there is a risk component to rates of return, in the market.

NPV & Risk

 It follows that the risk that investors perceive in the firm has somehow been incorporated into their determination of the proper RRR for the firm.

 As a result, when we use the RRR that is determined by those factors to calculate NPV of a project, the project must have the same risk as the general risk of the firm, or it will demand a different RRR.

NPV & Risk

 That can be a pretty

stringent requirement

, if you

consider

the

scope

of projects and the scope of some firms.

 For example, a

new product

would be a

riskier than average

venture.

 On the other hand, a

company

that has a

division

that makes military

tanks and

another that makes

chopsticks

.

 In such a company, the

average risk

will be

different divisions

.

from the

risks of

each of its

NPV & Risk

 Indeed, the NPV method must be revised to include different RRR’s for risks that are greater or less than average.

 That kind of patch can be achieved by a number of formal and semi-formal means.  We leave further discussion of this to later.

A note on spreadsheet functions

 It is nice to have a bunch of

built-in functions

in

excel and other spreadsheet programs

, but you should be on your guard.

 In some cases, like for variance, which we shall cover later, there are several functions, and you should use the help function to find the one with the definition that you really want.

A note on spreadsheet functions

 In the case of NPV, the

NPV function, in excel

, for example, is

not the same as our definition

. The excel function is

actually just PV

of multiple cash flows.

 Thus, if you use a spreadsheet and you need to calculate NPV, you can use the NPV function, but you will have to additionally subtract out the initial investment outlay. Then, you will get the actual correct NPV, according to the true definition.

Payback Period: a non-DFCF rule

 There are a number of other decision rules for investment.

 The first one that we cover is the

payback period

, which does not account for time value.

 Payback period is a natural concept that is examined in many different investment contexts.

 In

investment

, we

pay out money to buy

an investment: our

initial investment outlay

.

Payback Period: a non-DFCF rule

 The

payback period

for an investment is the amount of time, into the future, at which we, basically,

break even

, not accounting for time value, on our initial outlay.  Thus, to find the payback period, we subtract each years cash flow from the initial investment until it is completely recovered.

Payback Period: a non-DFCF rule

 In practice, the investment will probably not be recovered in an integral number of years, but, instead, there will be a leftover amount in one year, which will be paid off in a fraction of a year.

 For example, a payback period might be in 3 years, 4 months = 3 1/3 years.

 In the next slide, we show the payback period calculation for our earlier project.

Payback Period Example

 The payback period is over 3 years but under 4. It is 100/300 = 1/3 year over 3 years.

Time line IIO Inflows Outflows 0 1000 Net inflow Salvage Net CF Payback paid to go payback period = 1 500 200 300 2 500 200 300 300 300 300 700 3 1/3 300 400 3 500 200 300 300 300 100 4 500 200 300 300 5 500 200 300 100 400 100/300 = 1/3

Payback Example

 In the example, we subtract year after year of cash inflows from the original outflow.

 It takes 3 years of $300 of inflows to cover $900 of the initial $1,000 outflow.

 Then, there is only $100 left, and that is less than year 4’s cash flow.

 So, we take the leftover $100 and divide it by year 4’s cash flow to find out what portion of a year it takes to cover the leftover.

 Thus, our payback period is 3 1/3 years.

Payback Decision Rule

 As the payback period (PBP) analysis is not formal, to begin with, being a non-DFCF tool, the decision rule is not a hard and fast rule.

 Companies simply choose a rather arbitrary number of years, usually just a few, as an acceptable PBP.

 The rule is, then, accept projects that have PBP’s equal to or less than the stated PBP of the company, and reject those that take more than the standard to pay back.

Pros & Cons of Payback

 PBP

neglects time value

and makes an

arbitrary cutoff

hurdle rate for projects.

 If there is only one hurdle rate for PBP, then, the

riskiness

of projects is also

ignored

.  One of the most salient faults of PBP is that it completely

disregards

any cash flows that come after break-even, i.e., (forgetting about time value)

profits

.

Pros & Cons of Payback

 In that regard, it really neglects any more than just recovering your initial investment, which

misses the very spirit of investment

: to make a decent return on investment.

 Many established and proper companies do use PBP, either as a

supplemental number

for decisions

or for small projects

.

 The latter case is due to the costs of coming up with detailed estimates on which to bases more formal analyses, like NPV.

Pros & Cons of Payback

 Having a

short PBP

, like 2 years, will

bias acceptance

to projects that pay themselves off,

fast, and free up cash

.

 It should also

tend to limit losses

.

 In the end, just as in any method of analyzing the future, we have to

use estimates

that might be so wrong, and that will be especially true as the years into the future increase. The PBP has a natural bias to the early years.

Average Accounting Return

 Another

non-DFCF method

is called the

average accounting return (AAR)

of a project or the accounting rate of return (ARR).

 There are a number of different definitions of AAR, but they all have the

general form

: [average accounting profits from investment]/[average accounting value of investment].

In this course

, we shall use the specific definition:

average net income/average book value

.

ARR Example

 Consider renting space for a dress shop.

 Assume that renovation an fittings cost $100,000.

 The building owner will only give you a 5 year lease, so the store will close at that time.

 Assume that the initial investment is depreciated over the 5 years, straight-line.

ARR Example

 Then, the average investment will be [$100,000 (IIO) + $0 (terminal BV)]/2 = $50,000.

 The estimated net incomes for the 5 years are $50,000, $75,000, $25,000, $0, and – $10,000.

 Then, the average profit is [$50K + $75K + $25K + $0 – $10K]/5 = $28,000.

 Thus AAR = $28,000/$50,000 = 56%

ARR Decision Rule

 Just like the PBP, the ARR method is a rule of thumb (a heuristic, in the newer language of behavioral finance).

 The choice of a hurdle rate is somewhat arbitrary.

 Given a specified hurdle rate for ARR, then, accept projects that make the hurdle, and reject projects that do not make the hurdle (or target) rate or benchmark.

ARR Expose

     ARR uses accounting numbers so it will not give a representation of return that has meaning in the economic sense.

The numbers used in ARR do not account for time value, so they mix numbers from different times.

The numbers, moreover, are not even cash flows: they are profits.

Like PBP, a benchmark rate is arbitrary, although we could compute the ARR for the firm as a whole and use that.

Advantage: easy to compute wil readily available accounting numbers.

Internal Rate of Return

 A second DFCF method that we shall examine is internal rate of return (IRR).

 We already encountered the concept of IRR when we looked at bonds: the IRR solves the coupon bond equation for YTM.

 The IRR method is also related to NPV.

 With NPV we begin with a given value for RRR, and we compare the DFCF from the investment with the price, IIO, that we pay for the investment.

Internal Rate of Return

 On the other hand, IRR finds the RRR that makes DFCF exactly equal to IIO.

  In other words, IRR is the rate of return that

equates the present value

of the project’s cash flows

to the initial outlay

of the project.

Thus, we can write the equation form of IRR as:

IO

t n

  1 ( 1 

CF t IRR

)

t

 Then, the

required rate of return

that makes

NPV=0 is

the

IRR

.

Finding IRR

    As noted in our discussion of finding YTM, IRR can not, usually, be found, directly, but must be found either with a financial function on calculator or spreadsheet or by trial and error.

In our earlier example calculation of NPV, we used RRR = 15%, and we found that NPV was positive.

That means, if we were setting out to find IRR by trail and error, we know that the value is greater than 15% because that value of RRR made the sum of DFCF larger than the IO.

We used the IRR function in excel to find the IRR for our dress-making project and found IRR = 17.23%.

RRR vs. NPV

 In the chart below we show RRR vs. NPV for our project, known as an

NPV profile RRR vs. NPV

600 500 400 300 200 100 0 -100 2% 4% 6% 8% 10% 12% 14% 16% 18% 20% Ряд1

Finding IRR using excel

 As mentioned earlier, be careful when using spreadsheet functions to understand what they are and how to use them to get the answers that you need.

 The excel function is of the form IRR(values, guess), e.g., IRR(E16:J16,0.1)  At least one of the values must be negative and one positive.

 The guess is any number: it just needs an RRR to start the trial and error.

IRR Decision Rules

 Since IRR is the return that makes NPV=0, we can translate the decision rules for NPV into IRR.

 Thus, if IRR is greater than the hurdle RRR, accept the project.

 If it is less, reject.

 If IRR = the hurdle rate, the position is neutral.

 This is displayed graphically, in the chart in the slide, above.

More detailed information

 The general rules for using IRR were given in the preceding slide, but we must embellish them.

  First, the project must be an independent project, not dependent on anything else.

If CF’s are negative in more than the initial year, the IRR problem has multiple solutions, not just one, which makes a decision difficult.

More detailed information

 Even the evenness of CF’s can affect the usefulness of IRR, for example, if CF’s are weighted in the early versus the later years.

 A general disadvantage of IRR over NPV is that when a multi-year project has a certain IRR, the implicit assumption in PV DFCF is that intermediate year CF’s must be reinvested at the IRR rate.

More detailed information

 NPV assumes that intermediate CF’s are reinvested at the RRR, which, since the RRR is the return that is being achieved by projects of the firm, in general, there should be reinvestment opportunities, in the future, at that general rate.

 However, for IRR, if the IRR is substantially above the RRR, it is not reasonable to assume that we can reinvest at that high rate through other future projects.

Mutually Exclusive Projects

 Projects can be mutually exclusive (ME).

 That means choosing one but not both (or all).

 For example, you want to buy a new computer for your business. You evaluate the CF’s of using IBM, HP, or Lenovo.

 In the end, you need only one computer system, so, choosing one eliminates the others.

Mutually Exclusive Projects

 Often, the ME nature of projects is subtle, and a problem might not tell you that the projects are ME ... Figuring that out will be part of the problem.

 If projects are not ME, they are independent.

 Once that you figure out that a set of projects is ME, then, the decision will be to choose the one that has the highest NPV or IRR or whatever your criterion is.

ME example

 CF’s for two projects, B & C, are shown, below.

  The NPV of B is $147 and C is $106, using a 10% RRR.

IRR’s for the projects are 17.01% for B and 13.06% for C. Time 0 Project B -1000 1 Project C -1000 450 100 2 380 125 3 300 300 4 200 460 5 100 600

NPV Profiles for B & C

NPV Profiles for ME Projects

600 500 400 300 200 100 0 -100 -200 -300 2% 4% 6% B C 8% 10% 12% 14% 16% 18% 20%

Example Analysis

 In the above slide we show NPV profiles for the 2 projects.

 When the 2 profiles are displayed, we find out that there is a region, lower RRR’s, where the NPV of project B dominates those for project C.

 Then, after an intersection point where both NPV’s are the same, at higher RRR’s, the NPV’s are higher for C than for B.

Example Analysis

 Thus, it appears that, depending on the choice of RRR, the NPV analysis will give different choices for the better project.

 Moreover, since we already found IRR, which is a fixed number for each project, there can be conflicting decisions from IRR and NPV.

Example Analysis

 We can actually find the intersection point by finding the IRR of the differential cash flows of the two projects, i.e., CFA – CFB in each year.

Time Delta 0 Project B -1000 Project C -1000 0 1 450 100 -350 2 380 125 -255 3 300 300 0 4 200 460 260 5 100 600 500  The result is intersection RRR = 7.30%.

The lesson for ME, IRR, and NPV

 It will always be more appropriate to use NPV over IRR.

 People care more about the money that they make, NPV, versus their returns on investment, especially when IRR might not be a good rate for reinvestment, anyway.

 Thus, if there are conflicting opinions from IRR and NPV for ME, go with the choice given by NPV.

NPV versus IRR

 Both are discounted cash flow techniques, so they are consistent with wealth maximisation  Both require detailed cash flow forecasts  Both give the same decision for independent projects with typical cash flow patterns

IRR Epilogue

 We have seen that NPV and IRR are related.

 We have also seen that there are reasons that NPV will win out over IRR, if there is a conflict, as can be the case in ME projects.

 Still, many companies still use IRR because it gives a percentage return, which is, for some reason, easier for people to relate to than NPV dollar values.

IRR Epilogue

An additional advantage

of the

IRR

is that it gives an

indication of the ‘safety margin

’ associated with a project. In particular, a higher

IRR

implies less risk of the firm being unable to recover its initial investment if projected cash inflows from the project prove to be too optimistic.

Example – IRR safety margin

 As an example of this, suppose two mutually exclusive projects, C and D, with initial investments of $20,000 and $145,000, respectively, and a single net cash inflow after one year of $28,000 and $168,000, respectively.

  If the cost of capital were 12% p.a., each project would have a NPV of $5000, and thus a firm would be indifferent between the two projects by the NPV criterion. In tabular format, we have…………………..

Example – IRR safety margin

C D Initial Investment 20000 145000 Sole Cash Flow NPV (k=0.12) 28000 5000 168000 5000 However, project C has a greater safety margin in that the net cash flow at the end of one year could fall by up to approximately 28.6% 8 , 000 28 , 000  0 .

286 and the firm would still recover its investment. For project D, the net cash flow at the end of one year could only fall up to 13.7% if the firm were still to recover its investment.

23 , 000 168 , 000  0 .

137 The IRRs of projects C and D are 40% and 15.86% respectively, which gives an indication of the relative ‘safety margins’ associated with the projects.

The Profitability Index

 The

profitability index

(PI) is similar to NPV, in that it compares the DFCF from the project to the cost, so it is also known as the

cost-benefit ratio

.

 The PI is defined as PI = DFCF/IO, the discounted cash flow value of the project divided by the initial investment cost (outlay).

The Profitability Index

 If a project, for example, costs $1 million and the DFCF value is $1.1 million, then, the PI = $1.1 million/$1 million = 1.1x

 Thus, if PI > 1, accept; PI < 1, reject.

 However, the PI just gives a ratio, so there might be cases for ME projects in which One has a higher PI but a lower actual NPV. Thus, in such cases, as was the case with IRR, the choice lies in the decision given by NPV.

Capital Budgeting Practice

    Although NPV seems to be the best method for valuing profits, in that it is consistent with the goal of wealth maximization, it, after all, just based on estimates of future CF’s, which may or may not be realized.

In practice, many firms use NPV, but they also use other methods, even the non-DFCF methods, like PBP or ARR.

By using several methods, the firm is trying to cover the bases.

The textbook shows some results of surveys.

Summary

 Last week we learned techniques to figure out how much we have to pay, in terms of investor returns (COC), to get money from investors   Now, we have to use that money for our business activities and invest it in business projects.

In order to stay in business, we have to be able to make at least as much money on our investment as we need to get to pay off our investors.

Summary

   Thus, our job becomes figuring out how to value the investments that we make, in a manner that is consistent with how our investors value their money. In both cases, the answer is discounting future expected cash flow.

We, therefore, learned several techniques to value projects using discounted cash flow.

We also learned that we must adjust our thinking in deciding which cash flows to use and how to use them. We grouped these into several categories, like initial outlay (IO), Terminal Value, incremental intermediate cash flows, and changes in working capital.

Next week

  In the next module, we shall extend this system of project selection and valuation to include some other factors, and we shall discuss the structure and process of capital budgeting, i.e., looking at the projects available and the money available and putting the two sides together in the real world.

That will also involve some additional techniques for comparing projects among themselves.

Learning activity

  

In chapter eight of the text (page 244), attempt

critical thinking questions 8.3 – 8.6 & 8.10

problems 1 – 7, 10, 15 parts a, b & c, 22, 25 and web questions 8.1 & 8.2.

END